DBA Data[Home] [Help] [Dependency Information]

TABLE: EC.ECE_AP_INVOICES_INTERFACE

Object Details
Object Name: ECE_AP_INVOICES_INTERFACE
Object Type: TABLE
Owner: EC
FND Design Data: TableEC.ECE_AP_INVOICES_INTERFACE
Subobject Name:
Status: VALID


ECE_AP_INVOICES_INTERFACE contains the invoice data to support
the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV)
transaction. ECE_AP_INVOICES_INTERFACE contains the remittance
advice portion of the transaction representing the individual invoices
to be paid. The payment portion of the transaction is stored in
ECE_AP_CHECKS_INTERFACE.

ECE_AP_INVOICES_INTERFACE is based primarily on data stored in
AP_SELECTED_INVOICES in Oracle Payables. ECE_AP_INVOICES_INTERFACE
includes payment batch number, check number, invoice number,
invoice date, and invoice amount.

CHECKRUN_NAME is the primary key to ECE_AP_CHECKS_INTERFACE to
reference a payment batch. There is a one-to-many relationship between
ECE_AP_CHECKS_INTERFACE and ECE_AP_INVOICES_INTERFACE.

All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.

Each row in ECE_AP_INVOICES_INTERFACE is purged after the data is
written to the data file.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_AP_INVOICES_INTERFACE table to its corresponding extension table
ECE_AP_INVOICES_INTERFACE _X.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER

Run ID
TRANSACTION_RECORD_ID NUMBER

Unique identifier which links the transaction base table to its associated extension table.
CHECKRUN_NAME VARCHAR2 (50) Yes Payment Batch Name
CHECK_NUMBER NUMBER

Check Number
VENDOR_NUM VARCHAR2 (30)
Supplier Number
VENDOR_NUM_EXT1 VARCHAR2 (80)
Supplier Number (Ext)
CUSTOMER_NUM VARCHAR2 (25)
Customer number that the supplier uses for your company.
INVOICE_NUM VARCHAR2 (50)
Invoice Number
INVOICE_DATE DATE

Invoice Date
INVOICE_DESCRIPTION VARCHAR2 (240)
Invoice Description
PROPOSED_PAYMENT_AMOUNT NUMBER

Payment Amount
INVOICE_AMOUNT NUMBER

Invoice Amount
DISCOUNT_AMOUNT NUMBER

Discount Amount
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Remittance Advice Attribute Category
PRINT_SELECTED_CHECK_ID NUMBER

Print Selected Check ID
ATTRIBUTE1 VARCHAR2 (150)
Remittance Advice Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Remittance Advice Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Remittance Advice Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Remittance Advice Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Remittance Advice Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Remittance Advice Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Remittance Advice Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Remittance Advice Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Remittance Advice Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Remittance Advice Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Remittance Advice Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Remittance Advice Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Remittance Advice Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Remittance Advice Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Remittance Advice Attribute 15
CREATION_DATE VARCHAR2 (1)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
INV_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Invoice Global Attribute Category
INV_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Invoice Global Attribute 1
INV_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Invoice Global Attribute 2
INV_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Invoice Global Attribute 3
INV_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Invoice Global Attribute 4
INV_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Invoice Global Attribute 5
INV_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Invoice Global Attribute 6
INV_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Invoice Global Attribute 7
INV_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Invoice Global Attribute 8
INV_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Invoice Global Attribute 9
INV_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Invoice Global Attribute 10
INV_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Invoice Global Attribute 11
INV_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Invoice Global Attribute 12
INV_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Invoice Global Attribute 13
INV_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Invoice Global Attribute 14
INV_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Invoice Global Attribute 15
INV_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Invoice Global Attribute 16
INV_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Invoice Global Attribute 17
INV_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Invoice Global Attribute 18
INV_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Invoice Global Attribute 19
INV_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Invoice Global Attribute 20
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RUN_ID
,      TRANSACTION_RECORD_ID
,      CHECKRUN_NAME
,      CHECK_NUMBER
,      VENDOR_NUM
,      VENDOR_NUM_EXT1
,      CUSTOMER_NUM
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_DESCRIPTION
,      PROPOSED_PAYMENT_AMOUNT
,      INVOICE_AMOUNT
,      DISCOUNT_AMOUNT
,      ATTRIBUTE_CATEGORY
,      PRINT_SELECTED_CHECK_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INV_GLOBAL_ATTRIBUTE_CATEGORY
,      INV_GLOBAL_ATTRIBUTE1
,      INV_GLOBAL_ATTRIBUTE2
,      INV_GLOBAL_ATTRIBUTE3
,      INV_GLOBAL_ATTRIBUTE4
,      INV_GLOBAL_ATTRIBUTE5
,      INV_GLOBAL_ATTRIBUTE6
,      INV_GLOBAL_ATTRIBUTE7
,      INV_GLOBAL_ATTRIBUTE8
,      INV_GLOBAL_ATTRIBUTE9
,      INV_GLOBAL_ATTRIBUTE10
,      INV_GLOBAL_ATTRIBUTE11
,      INV_GLOBAL_ATTRIBUTE12
,      INV_GLOBAL_ATTRIBUTE13
,      INV_GLOBAL_ATTRIBUTE14
,      INV_GLOBAL_ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE16
,      INV_GLOBAL_ATTRIBUTE17
,      INV_GLOBAL_ATTRIBUTE18
,      INV_GLOBAL_ATTRIBUTE19
,      INV_GLOBAL_ATTRIBUTE20
FROM EC.ECE_AP_INVOICES_INTERFACE;

Dependencies

[top of page]

EC.ECE_AP_INVOICES_INTERFACE does not reference any database object

EC.ECE_AP_INVOICES_INTERFACE is referenced by following:

SchemaEC
ViewECE_AP_INVOICES_INTERFACE#