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

TABLE: FII.FII_AP_HOLD_DATA_FSTG

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


This is the interface table for AP hold data 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_HOLD_DATA_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnHOLD_DATA_PK
FII_AP_HOLD_DATA_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 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 foreign 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 the user defined dimension
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
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, dimnension 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).
RELEASE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the release dimension at the lowest level.
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_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the invoice dimension at the lowest level.
INV_CURRENCY_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the invoice currency dimension at the lowest level.
INV_AMT_T NUMBER

Invoice amount in transactional currency
INV_AMT_G NUMBER

Invoice amount in global currency
INV_AMT_B NUMBER

Invoice amount in base currency.
INSTANCE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the instance dimension at the lowest level.
HOLD_RELEASE_DAYS NUMBER

Number of days from the hold date to the release days
HOLD_RELEASE_COUNT NUMBER

Set to 1 if this hold has been released. 0 otherwise.
HOLD_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the hold dimension at the lowest level.
HOLD_DATE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the hold date dimension at the lowest level.
HOLD_COUNT NUMBER

Set to 1
HOLD_BY_EMPLOYEE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the employee dimension at the lowest level.
HELD_BY NUMBER

Employee who placed the hold on the invoice.
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.
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 user the 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
RELEASE_REASON VARCHAR2 (240)
Reason for release being placed on invoice
RELEASE_LOOKUP_CODE VARCHAR2 (25)
Name of release code
RELEASE_FK VARCHAR2 (120)
Foreign key to release dimension
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)
Invoice type of the invoice on hold
INV_SOURCE_FK VARCHAR2 (120)
Foreign key to the invoice source dimension
INV_SOURCE VARCHAR2 (25)
Invoice source of the invoice on hold
INV_NUM VARCHAR2 (50)
Invoice number of the invoice on hold
INV_FK VARCHAR2 (120)
Foreign key to the invoice 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
HOLD_REASON VARCHAR2 (240)
Reason for hold being placed
HOLD_LOOKUP_CODE VARCHAR2 (25)
Name of the hold code
HOLD_FK VARCHAR2 (120)
Foreign key to the hold dimension
HOLD_DATE_FK VARCHAR2 (120)
Foreign key to the hold date dimension
HOLD_DATA_PK VARCHAR2 (300)
Unique identifier
HOLD_BY_EMPLOYEE_FK VARCHAR2 (120)
Foreign key to the employee dimension
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
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
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.
HOLD_DATE DATE

Date the hold was placed
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.
TRANSACTION_DATE DATE

Date used by edw_currency.get_rate api to calculate GLOBAL_CURRENCY_RATE.
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_SITE_ID
,      SUPPLIER_FK_KEY
,      SOB_FK_KEY
,      SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      REQUEST_ID
,      RELEASE_FK_KEY
,      PAYMENT_TERM_FK_KEY
,      ORG_FK_KEY
,      INV_SOURCE_FK_KEY
,      INV_FK_KEY
,      INV_CURRENCY_FK_KEY
,      INV_AMT_T
,      INV_AMT_G
,      INV_AMT_B
,      INSTANCE_FK_KEY
,      HOLD_RELEASE_DAYS
,      HOLD_RELEASE_COUNT
,      HOLD_FK_KEY
,      HOLD_DATE_FK_KEY
,      HOLD_COUNT
,      HOLD_BY_EMPLOYEE_FK_KEY
,      HELD_BY
,      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
,      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
,      RELEASE_REASON
,      RELEASE_LOOKUP_CODE
,      RELEASE_FK
,      PAYMENT_TERM_FK
,      ORG_FK
,      OPERATION_CODE
,      INV_TYPE
,      INV_SOURCE_FK
,      INV_SOURCE
,      INV_NUM
,      INV_FK
,      INV_CURRENCY_FK
,      INSTANCE_FK
,      INSTANCE
,      HOLD_REASON
,      HOLD_LOOKUP_CODE
,      HOLD_FK
,      HOLD_DATE_FK
,      HOLD_DATA_PK
,      HOLD_BY_EMPLOYEE_FK
,      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
,      ERROR_CODE
,      COLLECTION_STATUS
,      LAST_UPDATE_DATE
,      HOLD_DATE
,      CREATION_DATE
,      FROM_CURRENCY
,      TRANSACTION_DATE
FROM FII.FII_AP_HOLD_DATA_FSTG;

Dependencies

[top of page]

FII.FII_AP_HOLD_DATA_FSTG does not reference any database object

FII.FII_AP_HOLD_DATA_FSTG is referenced by following:

SchemaAPPS
SynonymFII_AP_HOLD_DATA_FSTG