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

TABLE: FII.FII_AP_INV_PAYMTS_FSTG

Object Details
Object Name: FII_AP_INV_PAYMTS_FSTG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_INV_PAYMTS_FSTG
Subobject Name:
Status: VALID


This is the interface table for AP invoice payments fact. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_INV_PAYMTS_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINV_PAYMENT_PK
FII_AP_INV_PAYMTS_FSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
USER_MEASURE5 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE1 NUMBER

User defined measure
USER_FK9_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK8_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK7_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK6_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK5_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK4_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK3_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK2_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK1_KEY NUMBER

System generated foreign keys for the user defined dimension
USER_FK10_KEY NUMBER

System generated foreign keys for the user defined dimension
SUPPLIER_FK_KEY NUMBER

System generated foreign key for the supplier dimension
SOB_FK_KEY NUMBER

System generated foreign key for the set of books dimension
SIC_CODE_FK_KEY NUMBER

System generated foreign key for the standard industry code,SIC, dimension.
DUNS_FK_KEY NUMBER

System generated foreign key for the data universal numbering system,DUNS, dimension.
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PAYMENT_TERM_FK_KEY NUMBER

System generated foreign key for the payment term dimension
PAYMENT_FK_KEY NUMBER

System generated foreign key for the payment dimension
PAYMENT_EXCHANGE_RATE NUMBER

Exchange rate between invoice currency and payment currency
PAYMENT_DATE_FK_KEY NUMBER

System generated foreign key for the payment date dimension
PAYMENT_CURRENCY_FK_KEY NUMBER

System generated foreign key for the payment currency dimension
PAYMENT_COUNT NUMBER

Set to 1
PAYMENT_AMT_T NUMBER

Payment amount in transactional currency
PAYMENT_AMT_G NUMBER

Payment amount in global currency
PAYMENT_AMT_B NUMBER

Payment amount in functional currency
ORG_FK_KEY NUMBER

System generated foreign key for the organization dimension
LATE_NET_PAYMENT_DAYS NUMBER

The number of days from the net due date to the payment date
LATE_NET_PAYMENT_COUNT NUMBER

Set to 1 if this payment is made after the net due date. 0 otherwise
LATE_NET_PAYMENT_AMT_T NUMBER

The payment amount in payment currency that was made after the net due date
LATE_NET_PAYMENT_AMT_G NUMBER

The payment amount in global currency that was made after the net due date
LATE_NET_PAYMENT_AMT_B NUMBER

The payment amount in functional currency that was made after the net due date
LATE_DISC_PAYMENT_COUNT NUMBER

Set to 1 if this payment is made after the first discount date. 0 otherwise
LATE_DISC_PAYMENT_AMT_T NUMBER

The payment amount in transaction currency that was made after the first discount date
LATE_DISC_PAYMENT_AMT_G NUMBER

The payment amount in global currency that was made after the first discount date
LATE_DISC_PAYMENT_AMT_B NUMBER

The payment amount in functional currency that was made after the first discount date
LATE_DISC_DAYS NUMBER

The number of days from the discount deadline date of the best possible discount to the payment date
JE_BATCH_ID NUMBER

Journal entry batch identifier
INV_SOURCE_FK_KEY NUMBER

System generated foreign key for the invoice source dimension
INV_FK_KEY NUMBER

System generated foreign key for the invoice type dimension
INV_EXCHANGE_RATE NUMBER

Exchange rate between invoice currency and base currency
INSTANCE_FK_KEY NUMBER

System generated foreign key for the instance dimension
GL_ACCT9_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT8_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT7_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT6_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT5_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT4_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT3_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT2_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT1_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT10_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GEOGRAPHY_FK_KEY NUMBER

System generated foreign key for the geography dimension
EMPLOYEE_FK_KEY NUMBER

System generated foreign key for the employee dimension
EARLY_NET_PAYMENT_DAYS NUMBER

The number of days from the payment date to the net due date, where the payment date is earlier or on the due date, and the payment date is after all discount dates
EARLY_NET_PAYMENT_COUNT NUMBER

Set to 1 if this payment is made before or on the net due date but after all discount dates, otherwise 0
EARLY_NET_PAYMENT_AMT_T NUMBER

The payment amount in transaction currency of this payment if it is made before or on the net due date but after all discount dates, otherwise 0
EARLY_NET_PAYMENT_AMT_G NUMBER

The payment amount in warehouse currency of this payment if it is made before or on the net due date but after all discount dates, otherwise 0
EARLY_NET_PAYMENT_AMT_B NUMBER

The payment amount in functional currency of this payment if it is made before or on the net due date but after all discount dates, otherwise 0
EARLY_DISC_PAYMENT_DAYS NUMBER

The number of days from the payment date to the first discount date, where the payment date is earlier or on the first discount date
EARLY_DISC_PAYMENT_COUNT NUMBER

Set to 1 if this payment is made before or on the first discount date, otherwise 0
EARLY_DISC_PAYMENT_AMT_T NUMBER

The payment amount in transaction currency of this payment if it is made before or on the first discount date for the discount taken, otherwise 0
EARLY_DISC_PAYMENT_AMT_G NUMBER

The payment amount in warehouse currency of this payment if it is made before or on the first discount date for the discount taken, otherwise 0
EARLY_DISC_PAYMENT_AMT_B NUMBER

The payment amount in functional currency of this payment if it is made before or on the first discount date for the discount taken, otherwise 0
DISC_AMT_TAKEN_T NUMBER

Discount amount taken in transaction currency
DISC_AMT_TAKEN_G NUMBER

Discount amount taken in global currency
DISC_AMT_TAKEN_B NUMBER

Discount amount taken in functional currency
DISC_AMT_LOST_T NUMBER

Discount amount lost in transaction currency
DISC_AMT_LOST_G NUMBER

Discount amount lost in global currency
DISC_AMT_LOST_B NUMBER

Discount amount lost in functional currency
CCID NUMBER

Invoice accounting flexfield identifier for accounts payable liability account
CASH_JE_BATCH_ID NUMBER

Cash journal entry batch identifier
BANK_ACCOUNT_ID NUMBER

Bank account identifier of the payment check
USER_FK9 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK8 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK7 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK6 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK5 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK4 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK3 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK2 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK10 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK1 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
SUPPLIER_FK VARCHAR2 (120)
Foreign key for the supplier dimension
SOB_FK VARCHAR2 (120)
Foreign key for the set of books dimension
SIC_CODE_FK VARCHAR2 (120)
Foreign key for the standard industry code,SIC, dimension.
DUNS_FK VARCHAR2 (120)
Foreign key for the data universal numbering system,DUNS, dimension.
ROW_ID ROWID (10)
Row identifier
POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted (Y/N)
PAYMENT_TERM_FK VARCHAR2 (120)
Foreign key for the payment term dimension
PAYMENT_FK VARCHAR2 (120)
Foreign key for the payment dimension
PAYMENT_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Rate type of the payment exchange rate
PAYMENT_DATE_FK VARCHAR2 (120)
Foreign key for the payment date dimension
PAYMENT_CURRENCY_FK VARCHAR2 (120)
Foreign key for the payment currency dimension
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
Payment currency code
ORG_FK VARCHAR2 (120)
Foreign key for the organization dimension
OPERATION_CODE VARCHAR2 (30)
Code used during warehouse collection
INV_TYPE VARCHAR2 (25)
Type of paid invoice.
INV_SOURCE_FK VARCHAR2 (120)
Foreign key for the invoice source dimension
INV_SOURCE VARCHAR2 (25)
Invoice source of paid invoice.
INV_PAYMENT_TYPE VARCHAR2 (25)
Creation method of a paymnet used by the postive pay feature (single or batch)
INV_PAYMENT_STATUS_FLAG VARCHAR2 (1)
Flag that indicates if the inovice has been paid (Y/N/P)
INV_PAYMENT_PK VARCHAR2 (120)
Foreign key for the invoice payment dimension
INV_NUM VARCHAR2 (50)
Invoice number of paid invoice.
INV_FK VARCHAR2 (120)
Foreign key for the invoice type dimension
INV_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type of foreign currecny invoice
INV_CURRENCY_CODE VARCHAR2 (15)
Invoice currency code
INSTANCE_FK VARCHAR2 (120)
Foreign key for the instance dimension
INSTANCE VARCHAR2 (40)
Instance identifier
GL_ACCT9_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT8_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT7_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT6_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT5_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT4_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT3_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT2_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT1_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GL_ACCT10_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimension
GEOGRAPHY_FK VARCHAR2 (120)
Foreign key to the geography dimension
FUTURE_PAY_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted (Y/N)
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
EMPLOYEE_FK VARCHAR2 (120)
Foreign key for the employee dimension
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
CASH_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted (Y/N)
BASE_CURRENCY_CODE VARCHAR2 (15)
Base currency of the set of books
ASSETS_ADDITION_FLAG VARCHAR2 (1)
Flag that indicates if discounts on invoice payment have been transferred into Oracle Assets (Y/N)
ACCRUAL_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted (Y/N)
PAYMENT_EXCHANGE_DATE DATE

Rate date of the payment exchange rate
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
INV_EXCHANGE_DATE DATE

Date exchange rate is effective
INVOICE_DATE DATE

Invoice date
CREATION_DATE DATE

Standard who column - date when this row was created.
CHECK_DATE DATE

Payment date
ACCOUNTING_DATE DATE

Accounting date of the invoice line
CHECK_AMT_B NUMBER

Check amount in base currency.
CHECK_AMT_T NUMBER

Check amount in transaction currency.
CHECK_AMT_G NUMBER

Check amount in global currency.
CHECK_NUMBER NUMBER (15)
Check Number.
Query Text

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


SELECT USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK9_KEY
,      USER_FK8_KEY
,      USER_FK7_KEY
,      USER_FK6_KEY
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      USER_FK10_KEY
,      SUPPLIER_FK_KEY
,      SOB_FK_KEY
,      SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      REQUEST_ID
,      PAYMENT_TERM_FK_KEY
,      PAYMENT_FK_KEY
,      PAYMENT_EXCHANGE_RATE
,      PAYMENT_DATE_FK_KEY
,      PAYMENT_CURRENCY_FK_KEY
,      PAYMENT_COUNT
,      PAYMENT_AMT_T
,      PAYMENT_AMT_G
,      PAYMENT_AMT_B
,      ORG_FK_KEY
,      LATE_NET_PAYMENT_DAYS
,      LATE_NET_PAYMENT_COUNT
,      LATE_NET_PAYMENT_AMT_T
,      LATE_NET_PAYMENT_AMT_G
,      LATE_NET_PAYMENT_AMT_B
,      LATE_DISC_PAYMENT_COUNT
,      LATE_DISC_PAYMENT_AMT_T
,      LATE_DISC_PAYMENT_AMT_G
,      LATE_DISC_PAYMENT_AMT_B
,      LATE_DISC_DAYS
,      JE_BATCH_ID
,      INV_SOURCE_FK_KEY
,      INV_FK_KEY
,      INV_EXCHANGE_RATE
,      INSTANCE_FK_KEY
,      GL_ACCT9_FK_KEY
,      GL_ACCT8_FK_KEY
,      GL_ACCT7_FK_KEY
,      GL_ACCT6_FK_KEY
,      GL_ACCT5_FK_KEY
,      GL_ACCT4_FK_KEY
,      GL_ACCT3_FK_KEY
,      GL_ACCT2_FK_KEY
,      GL_ACCT1_FK_KEY
,      GL_ACCT10_FK_KEY
,      GEOGRAPHY_FK_KEY
,      EMPLOYEE_FK_KEY
,      EARLY_NET_PAYMENT_DAYS
,      EARLY_NET_PAYMENT_COUNT
,      EARLY_NET_PAYMENT_AMT_T
,      EARLY_NET_PAYMENT_AMT_G
,      EARLY_NET_PAYMENT_AMT_B
,      EARLY_DISC_PAYMENT_DAYS
,      EARLY_DISC_PAYMENT_COUNT
,      EARLY_DISC_PAYMENT_AMT_T
,      EARLY_DISC_PAYMENT_AMT_G
,      EARLY_DISC_PAYMENT_AMT_B
,      DISC_AMT_TAKEN_T
,      DISC_AMT_TAKEN_G
,      DISC_AMT_TAKEN_B
,      DISC_AMT_LOST_T
,      DISC_AMT_LOST_G
,      DISC_AMT_LOST_B
,      CCID
,      CASH_JE_BATCH_ID
,      BANK_ACCOUNT_ID
,      USER_FK9
,      USER_FK8
,      USER_FK7
,      USER_FK6
,      USER_FK5
,      USER_FK4
,      USER_FK3
,      USER_FK2
,      USER_FK10
,      USER_FK1
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE1
,      SUPPLIER_FK
,      SOB_FK
,      SIC_CODE_FK
,      DUNS_FK
,      ROW_ID
,      POSTED_FLAG
,      PAYMENT_TERM_FK
,      PAYMENT_FK
,      PAYMENT_EXCHANGE_RATE_TYPE
,      PAYMENT_DATE_FK
,      PAYMENT_CURRENCY_FK
,      PAYMENT_CURRENCY_CODE
,      ORG_FK
,      OPERATION_CODE
,      INV_TYPE
,      INV_SOURCE_FK
,      INV_SOURCE
,      INV_PAYMENT_TYPE
,      INV_PAYMENT_STATUS_FLAG
,      INV_PAYMENT_PK
,      INV_NUM
,      INV_FK
,      INV_EXCHANGE_RATE_TYPE
,      INV_CURRENCY_CODE
,      INSTANCE_FK
,      INSTANCE
,      GL_ACCT9_FK
,      GL_ACCT8_FK
,      GL_ACCT7_FK
,      GL_ACCT6_FK
,      GL_ACCT5_FK
,      GL_ACCT4_FK
,      GL_ACCT3_FK
,      GL_ACCT2_FK
,      GL_ACCT1_FK
,      GL_ACCT10_FK
,      GEOGRAPHY_FK
,      FUTURE_PAY_POSTED_FLAG
,      ERROR_CODE
,      EMPLOYEE_FK
,      COLLECTION_STATUS
,      CASH_POSTED_FLAG
,      BASE_CURRENCY_CODE
,      ASSETS_ADDITION_FLAG
,      ACCRUAL_POSTED_FLAG
,      PAYMENT_EXCHANGE_DATE
,      LAST_UPDATE_DATE
,      INV_EXCHANGE_DATE
,      INVOICE_DATE
,      CREATION_DATE
,      CHECK_DATE
,      ACCOUNTING_DATE
,      CHECK_AMT_B
,      CHECK_AMT_T
,      CHECK_AMT_G
,      CHECK_NUMBER
FROM FII.FII_AP_INV_PAYMTS_FSTG;

Dependencies

[top of page]

FII.FII_AP_INV_PAYMTS_FSTG does not reference any database object

FII.FII_AP_INV_PAYMTS_FSTG is referenced by following:

SchemaAPPS
SynonymFII_AP_INV_PAYMTS_FSTG