[Home] [Help] [Dependency Information]
Object Name: | EDW_TPRT_P2_TPARTNER_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | BIS.EDW_TPRT_P2_TPARTNER_LSTG
POA.EDW_TPRT_P2_TPARTNER_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for Parent Trading Partner 2 level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_TPRT_P2_TPARTNER_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | TPARTNER_PK |
EDW_TPRT_P2_TPARTNER_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TPARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
PARENT_TPARTNER_FK | VARCHAR2 | (120) | Foreign key to Parent Trading Partner 3 level | |
PARENT_TPARTNER_FK_KEY | NUMBER | System generated foreign key to Parent Trading Partner 3 level | ||
TPARTNER_DP | VARCHAR2 | (480) | Unique Parent Trading Partner 2 name | |
NAME | VARCHAR2 | (480) | Parent Trading Partner 2 name | |
ALTERNATE_NAME | VARCHAR2 | (320) | Parent Trading Partner 2 alternate name | |
START_ACTIVE_DATE | DATE | Begin date for supplier validity | ||
END_ACTIVE_DATE | DATE | End date for supplier validity | ||
SIC_CODE | VARCHAR2 | (40) | Trading Partner Standard Industrial Classification code | |
TAX_REG_NUM | VARCHAR2 | (80) | Tax registration number | |
TAXPAYER_ID | VARCHAR2 | (80) | Taxpayer Identification Number | |
PAYMENT_TERMS | VARCHAR2 | (80) | Payment terms agreed to with trading partner | |
VENDOR_NUMBER | VARCHAR2 | (40) | Supplier number | |
VENDOR_TYPE | VARCHAR2 | (80) | Supplier type | |
ONE_TIME_FLAG | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
MINORITY_GROUP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
SMALL_BUSINESS | VARCHAR2 | (20) | Indicator that supplier is small business | |
HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
INSPECT_REQUIRED | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
RECEIPT_REQUIRED | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from trading partner before invoice is paid | |
ALLOW_SUB_RECEIPT | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with trading partner | |
ALLOW_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
INSTANCE | VARCHAR2 | (40) | Source database instance for Trading Partner 2 | |
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 | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the level table. It does not refer to the movement of the data from the source to the staging table) |
Cut, paste (and edit) the following text to query this object:
SELECT TPARTNER_PK
, ROW_ID
, PARENT_TPARTNER_FK
, PARENT_TPARTNER_FK_KEY
, TPARTNER_DP
, NAME
, ALTERNATE_NAME
, START_ACTIVE_DATE
, END_ACTIVE_DATE
, SIC_CODE
, TAX_REG_NUM
, TAXPAYER_ID
, PAYMENT_TERMS
, VENDOR_NUMBER
, VENDOR_TYPE
, ONE_TIME_FLAG
, MINORITY_GROUP
, WOMEN_OWNED
, SMALL_BUSINESS
, HOLD_FLAG
, INSPECT_REQUIRED
, RECEIPT_REQUIRED
, ALLOW_SUB_RECEIPT
, ALLOW_UNORDER_RCV
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LAST_UPDATE_DATE
, CREATION_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
FROM POA.EDW_TPRT_P2_TPARTNER_LSTG;
POA.EDW_TPRT_P2_TPARTNER_LSTG does not reference any database object
POA.EDW_TPRT_P2_TPARTNER_LSTG is referenced by following:
|
|
|