[Home] [Help] [Dependency Information]
Object Name: | EDW_AP_PTRM_PAY_TERM_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_AP_PTRM_PAY_TERM_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the AP payment terms level table. Data from multiple transactional systems is staged here for verefication and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_AP_PTRM_PAY_TERM_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PAY_TERM_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign Key to the Top Level of the Payment term 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). | ||
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the Payment term dimension | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Staging table for Payment term level | |
ENABLED_FLAG | VARCHAR2 | (20) | Enabled Flag | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
NAME | VARCHAR2 | (2000) | Name of payment term | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine wheather to insert/update/delete this record | |
PAYMENT_TERM | VARCHAR2 | (2000) | Payment term | |
PAY_TERM_PK | VARCHAR2 | (80) | Unique identifier | |
RANK | VARCHAR2 | (20) | Unique rank to rate invoice payment term against purchase order payment terms in accordance with Prompt Payment Act | |
ROW_ID | ROWID | (10) | Row identifier | |
TERM_TYPE | VARCHAR2 | (40) | Payment term type | |
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 defined attribute | |
DELETION_DATE | DATE | Deletion date of the record | ||
END_DATE_ACTIVE | DATE | Standard Who column | ||
START_DATE_ACTIVE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_FK_KEY
, REQUEST_ID
, ALL_FK
, COLLECTION_STATUS
, DESCRIPTION
, ENABLED_FLAG
, ERROR_CODE
, INSTANCE
, NAME
, OPERATION_CODE
, PAYMENT_TERM
, PAY_TERM_PK
, RANK
, ROW_ID
, TERM_TYPE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, DELETION_DATE
, END_DATE_ACTIVE
, START_DATE_ACTIVE
FROM FII.EDW_AP_PTRM_PAY_TERM_LSTG;
FII.EDW_AP_PTRM_PAY_TERM_LSTG does not reference any database object
FII.EDW_AP_PTRM_PAY_TERM_LSTG is referenced by following:
|
|
|