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