[Home] [Help] [Dependency Information]
Object Name: | EDW_TPRT_TRADE_PARTNER_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | BIS.EDW_TPRT_TRADE_PARTNER_LSTG
POA.EDW_TPRT_TRADE_PARTNER_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for Trading Partner 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_TRADE_PARTNER_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | TRADE_PARTNER_PK |
EDW_TPRT_TRADE_PARTNER_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_SALES_REP | VARCHAR2 | (120) | Sales representative name for this customer | |
CUST_SALES_CHNL | VARCHAR2 | (80) | Customer sales channel | |
CUST_ORDER_TYPE | VARCHAR2 | (40) | Customer order type | |
CUST_PRICE_LIST | VARCHAR2 | (40) | Customer price list | |
CUST_ANALYSIS_FY | VARCHAR2 | (20) | Fiscal Year upon which customer financial information is based | |
CUST_CAT_CODE | VARCHAR2 | (80) | Customer category code | |
CUST_KEY | VARCHAR2 | (80) | Customer identifier | |
CUST_FISCAL_END | VARCHAR2 | (40) | Month that customer fiscal year ends | |
CUST_NUM_EMP | NUMBER | Customer number of employees | ||
CUST_REVENUE_CURR | NUMBER | Potential revenue from customer for the current fiscal year | ||
CUST_REVENUE_NEXT | NUMBER | Potential revenue from customer for the next fiscal year | ||
CUST_REF_USE_FLAG | VARCHAR2 | (20) | Indicates that customer has agreed to be a reference | |
CUST_TAX_CODE | VARCHAR2 | (80) | Customer tax code | |
CUST_THIRD_PARTY | VARCHAR2 | (20) | Indicates whether customer is a direct customer or a third party supplier | |
CUST_ACCESS_TMPL | VARCHAR2 | (40) | Template to auto-create customer new access control | |
CUST_COMPETITOR | VARCHAR2 | (20) | Indicates whether customer is a competitor | |
CUST_ORIG_SYS | VARCHAR2 | (40) | Customer record system origination source | |
CUST_YEAR_EST | NUMBER | Year in which customer business was established | ||
CUST_COTERM_DATE | VARCHAR2 | (20) | Date in which services ordered by customer will terminate | |
CUST_FOB_POINT | VARCHAR2 | (40) | Customer Freight On Board point | |
CUST_FREIGHT | VARCHAR2 | (80) | Customer freight term | |
CUST_GSA_IND | VARCHAR2 | (20) | Indicates customer is a Government Service Agency | |
CUST_SHIP_PARTIAL | VARCHAR2 | (20) | Indicates whether partial shipment to customer are allowed | |
CUST_SHIP_VIA | VARCHAR2 | (40) | Ship method | |
CUST_DO_NOT_MAIL | VARCHAR2 | (20) | Indicates whether or not mail can be sent to customer | |
CUST_TAX_HDR_FLAG | VARCHAR2 | (20) | Indicates whether tax for customer should be calculated at the header level | |
CUST_TAX_ROUND | VARCHAR2 | (40) | Customer tax rounding rule | |
INSTANCE | VARCHAR2 | (40) | Source database instance for Trading Partner | |
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 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) | |
TRADE_PARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
PARENT_TPARTNER_FK | VARCHAR2 | (120) | Foreign key to Parent Trading Partner 1 level | |
PARENT_TPARTNER_FK_KEY | NUMBER | System generated foreign key to Parent Trading Partner 1 level | ||
TRADE_PARTNER_DP | VARCHAR2 | (480) | Unique Trading Partner name | |
NAME | VARCHAR2 | (480) | Trading Partner name | |
ALTERNATE_NAME | VARCHAR2 | (320) | Trading Partner alternate name | |
START_ACTIVE_DATE | DATE | Start 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 | |
VNDR_NUMBER | VARCHAR2 | (40) | Supplier number | |
VNDR_TYPE | VARCHAR2 | (80) | Supplier type | |
VNDR_ONE_TIME | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
VNDR_MINORITY_GRP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
VNDR_WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
VNDR_SMALL_BUS | VARCHAR2 | (20) | Indicator that supplier is small business | |
VNDR_HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
VNDR_INSPECT_REQ | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
VNDR_RECEIPT_REQ | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from supplier before invoice is paid | |
VNDR_SUB_RECEIPT | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with supplier | |
VNDR_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
CUST_NUMBER | VARCHAR2 | (40) | Customer number | |
CUST_ORIG_SYS_REF | VARCHAR2 | (240) | Customer record identifier from system origination source | |
CUST_STATUS | VARCHAR2 | (80) | Status of customer | |
CUST_TYPE | VARCHAR2 | (80) | Customer type | |
CUST_PROSPECT | VARCHAR2 | (40) | Indicates whether customer is a prospect | |
CUST_CLASS | VARCHAR2 | (40) | Customer class |
Cut, paste (and edit) the following text to query this object:
SELECT CUST_SALES_REP
, CUST_SALES_CHNL
, CUST_ORDER_TYPE
, CUST_PRICE_LIST
, CUST_ANALYSIS_FY
, CUST_CAT_CODE
, CUST_KEY
, CUST_FISCAL_END
, CUST_NUM_EMP
, CUST_REVENUE_CURR
, CUST_REVENUE_NEXT
, CUST_REF_USE_FLAG
, CUST_TAX_CODE
, CUST_THIRD_PARTY
, CUST_ACCESS_TMPL
, CUST_COMPETITOR
, CUST_ORIG_SYS
, CUST_YEAR_EST
, CUST_COTERM_DATE
, CUST_FOB_POINT
, CUST_FREIGHT
, CUST_GSA_IND
, CUST_SHIP_PARTIAL
, CUST_SHIP_VIA
, CUST_DO_NOT_MAIL
, CUST_TAX_HDR_FLAG
, CUST_TAX_ROUND
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LAST_UPDATE_DATE
, CREATION_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, TRADE_PARTNER_PK
, ROW_ID
, PARENT_TPARTNER_FK
, PARENT_TPARTNER_FK_KEY
, TRADE_PARTNER_DP
, NAME
, ALTERNATE_NAME
, START_ACTIVE_DATE
, END_ACTIVE_DATE
, SIC_CODE
, TAX_REG_NUM
, TAXPAYER_ID
, PAYMENT_TERMS
, VNDR_NUMBER
, VNDR_TYPE
, VNDR_ONE_TIME
, VNDR_MINORITY_GRP
, VNDR_WOMEN_OWNED
, VNDR_SMALL_BUS
, VNDR_HOLD_FLAG
, VNDR_INSPECT_REQ
, VNDR_RECEIPT_REQ
, VNDR_SUB_RECEIPT
, VNDR_UNORDER_RCV
, CUST_NUMBER
, CUST_ORIG_SYS_REF
, CUST_STATUS
, CUST_TYPE
, CUST_PROSPECT
, CUST_CLASS
FROM POA.EDW_TPRT_TRADE_PARTNER_LSTG;
POA.EDW_TPRT_TRADE_PARTNER_LSTG does not reference any database object
POA.EDW_TPRT_TRADE_PARTNER_LSTG is referenced by following:
|
|
|