[Home] [Help] [Dependency Information]
Object Name: | EDW_ARDN_DOC_NUM_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_ARDN_DOC_NUM_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Receivables Document Number level table. Before document number information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_NUM_PK | VARCHAR2 | (120) | The unique identifier of the invoice number | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the Document Number dimension | |
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the document number dimension | ||
DOC_NUM_DP | VARCHAR2 | (120) | Unique document number | |
NAME | VARCHAR2 | (120) | Transaction number | |
DOCUMENT_NUMBER | VARCHAR2 | (40) | Document number | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute idnetifier | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
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). | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine wheather to insert/update/delete this record. | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record |
Cut, paste (and edit) the following text to query this object:
SELECT DOC_NUM_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, DOC_NUM_DP
, NAME
, DOCUMENT_NUMBER
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
FROM FII.EDW_ARDN_DOC_NUM_LSTG;
FII.EDW_ARDN_DOC_NUM_LSTG does not reference any database object
FII.EDW_ARDN_DOC_NUM_LSTG is referenced by following:
|
|
|