[Home] [Help] [Dependency Information]
Object Name: | FII_AP_INV_ON_HOLD_FSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AP_INV_ON_HOLD_FSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for AP invoices on hold fact. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_AP_INV_ON_HOLD_FSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INV_ON_HOLD_PK |
FII_AP_INV_ON_HOLD_FSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
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 key for the user defined dimension | ||
USER_FK8_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK7_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK6_KEY | NUMBER | System generated key for the user defined dimension | ||
USER_FK5_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK4_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK3_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK2_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK1_KEY | NUMBER | System generated foreign key for the user defined dimension | ||
USER_FK10_KEY | NUMBER | System generated foreign key for user the defined dimension | ||
SUPPLIER_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level. | ||
SOB_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the set of books dimension at the lowest level. | ||
SIC_CODE_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the standard industry code, SIC, dimension at the lowest level. | ||
DUNS_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the data universal numbering system, DUNS, dimension at the lowest level. | ||
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 | A foreign key generated by the warehouse that points to the payment term dimension at the lowest level. | ||
ORG_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the organization dimension at the lowest level. | ||
INV_SOURCE_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the invoice source dimension at the lowest level. | ||
INV_ON_HOLD_COUNT | NUMBER | Set to 1 | ||
INV_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the invoice type dimension at the lowest level. | ||
INV_DATE_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the time dimension at the lowest level. | ||
INV_CURRENCY_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the currency dimension at the lowest level. | ||
INV_AMT_ON_HOLD_T | NUMBER | Invoice amount in transaction currency of invoice being held | ||
INV_AMT_ON_HOLD_G | NUMBER | Invoice amount in global currency of invoice being held | ||
INV_AMT_ON_HOLD_B | NUMBER | Invoice amount in functional currency of invoice on hold | ||
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 | A foreign key generated by the warehouse that points to the geography dimension at the lowest level. | ||
EXCHANGE_RATE | NUMBER | Exchange rate for a foreign currency invoice. | ||
EMPLOYEE_FK_KEY | NUMBER | A foreign key generated by the warehouse that points to the employee dimension at the lowest level. | ||
CCID | NUMBER | Invoice accounting flexfield identifier for accounts payable liability account | ||
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 to the supplier dimension | |
SOB_FK | VARCHAR2 | (120) | Foreign key to the set of books dimension | |
SIC_CODE_FK | VARCHAR2 | (120) | Foreign key to the standard industry code,SIC, dimension | |
DUNS_FK | VARCHAR2 | (120) | Foreign key to the data universal numbering system,DUNS, dimension | |
ROW_ID | ROWID | (10) | Row identifier | |
PAYMENT_TERM_FK | VARCHAR2 | (120) | Foreign key to the payment term dimension | |
ORG_FK | VARCHAR2 | (120) | Foreign key to the organization dimension | |
OPERATION_CODE | VARCHAR2 | (30) | Code used during warehouse collection | |
INV_TYPE | VARCHAR2 | (25) | Type of invoice placed on hold. | |
INV_SOURCE_FK | VARCHAR2 | (120) | Foreign key to the invoice source dimension | |
INV_ON_HOLD_PK | VARCHAR2 | (120) | Unique identifier | |
INV_NUM | VARCHAR2 | (50) | Invoice number of invoice being held | |
INV_FK | VARCHAR2 | (120) | Foreign key to the invoice type dimension | |
INV_DATE_FK | VARCHAR2 | (120) | Foreign key to the invoice date dimension | |
INV_CURRENCY_FK | VARCHAR2 | (120) | Foreign key to the invoice currency dimension | |
INSTANCE_FK | VARCHAR2 | (120) | Foreign key to 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 | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
EMPLOYEE_FK | VARCHAR2 | (120) | Foreign key to the employee dimension | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
EXCHANGE_DATE | DATE | Date exchange rate is effective | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
FROM_CURRENCY | VARCHAR2 | (15) | Currency used by edw_currency.get_rate api to calculate GLOBAL_CURRENCY_RATE |
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
, ORG_FK_KEY
, INV_SOURCE_FK_KEY
, INV_ON_HOLD_COUNT
, INV_FK_KEY
, INV_DATE_FK_KEY
, INV_CURRENCY_FK_KEY
, INV_AMT_ON_HOLD_T
, INV_AMT_ON_HOLD_G
, INV_AMT_ON_HOLD_B
, 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
, EXCHANGE_RATE
, EMPLOYEE_FK_KEY
, CCID
, 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
, PAYMENT_TERM_FK
, ORG_FK
, OPERATION_CODE
, INV_TYPE
, INV_SOURCE_FK
, INV_ON_HOLD_PK
, INV_NUM
, INV_FK
, INV_DATE_FK
, INV_CURRENCY_FK
, 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
, EXCHANGE_RATE_TYPE
, ERROR_CODE
, EMPLOYEE_FK
, COLLECTION_STATUS
, LAST_UPDATE_DATE
, EXCHANGE_DATE
, CREATION_DATE
, FROM_CURRENCY
FROM FII.FII_AP_INV_ON_HOLD_FSTG;
FII.FII_AP_INV_ON_HOLD_FSTG does not reference any database object
FII.FII_AP_INV_ON_HOLD_FSTG is referenced by following:
|
|
|