[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_TRD_PARTNER_M |
|---|---|
| Object Type: | TABLE |
| Owner: | POA |
| FND Design Data: |  BIS.EDW_TRD_PARTNER_M
POA.EDW_TRD_PARTNER_M
|
| Subobject Name: | |
| Status: | VALID |
This is the denormalized star table for the Trading Partner dimension. It contains records for the lowest level of the Trading Partner dimension and their parentage up to the top level.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EDW_TRD_PARTNER_M_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 TPLO_TPARTNER_LOC_PK
TPLO_TPARTNER_LOC_PK_KEY
|
| EDW_TRD_PARTNER_M_U2 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
TPLO_TPARTNER_LOC_PK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TPLO_LEVEL_NAME | VARCHAR2 | (15) | Level name | |
| TPLO_ADDRESS_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| TPLO_ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| TPLO_ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| TPLO_ADDRESS_LINE4 | VARCHAR2 | (240) | Fourth line of physical address | |
| TPLO_CITY | VARCHAR2 | (60) | City | |
| TPLO_COUNTY | VARCHAR2 | (240) | County | |
| TPLO_STATE | VARCHAR2 | (240) | State | |
| TPLO_POSTAL_CODE | VARCHAR2 | (60) | Postal Code | |
| TPLO_PROVINCE | VARCHAR2 | (240) | Province | |
| TPLO_COUNTRY | VARCHAR2 | (240) | Country | |
| TPLO_TPARTNER_LOC_PK_KEY | NUMBER | Yes | System generated unique identifier | |
| TPLO_TPARTNER_LOC_PK | VARCHAR2 | (320) | Unique identifier | |
| TPLO_TPARTNER_LOC_DP | VARCHAR2 | (480) | Unique Trading Partner Location name | |
| TPLO_NAME | VARCHAR2 | (480) | Trading Partner Location name | |
| TPLO_BUSINESS_TYPE | VARCHAR2 | (25) | Indicates whether trading partner is a vendor or a customer and which level they originates from. For Oracle Application source the values are: CUSTOMER, CUSTOMER ACOUNT, CUSTOMER SITE USE, PARTY, VENDOR, and VENDOR SITE. | |
| TPLO_DATE_FROM | DATE | Start date that trading partner location is valid | ||
| TPLO_DATE_TO | DATE | End date that trading partner location is valid | ||
| TPLO_VNDR_PURCH_SITE | VARCHAR2 | (20) | Indicates that goods and services can be purchased from site | |
| TPLO_VNDR_RFQ_ONLY | VARCHAR2 | (20) | Indicates that goods and services cannot be purchased from site. Only a Request for Quotation can be solicited. | |
| TPLO_VNDR_PAY_SITE | VARCHAR2 | (20) | Indicates that trading partner location is a site where payments can be sent | |
| TPLO_VNDR_PAY_TERMS | VARCHAR2 | (80) | Agreed upon payment terms with trading partner location | |
| TPLO_CUST_SITE_USE | VARCHAR2 | (40) | Customer site business purpose. For example: Bill To, Ship To, DUN. | |
| TPLO_CUST_LOCATION | VARCHAR2 | (80) | Customer location | |
| TPLO_CUST_PRIMARY_FLAG | VARCHAR2 | (20) | Indicates primary customer site | |
| TPLO_CUST_STATUS | VARCHAR2 | (80) | Customer status: Acitve or Inactive | |
| TPLO_CUST_ORIG_SYS_REF | VARCHAR2 | (320) | Customer record identifier from system origination source | |
| TPLO_CUST_SIC_CODE | VARCHAR2 | (40) | Standard Industrial Classification code | |
| TPLO_CUST_PAY_TERMS | VARCHAR2 | (80) | Payment terms agreed to with customer | |
| TPLO_CUST_GSA_IND | VARCHAR2 | (20) | Indicates customer is a Government Service Agency | |
| TPLO_CUST_SHIP_PARTIAL | VARCHAR2 | (20) | Indicates whether partial shipment to customer is allowed | |
| TPLO_CUST_SHIP_VIA | VARCHAR2 | (40) | Customer ship method | |
| TPLO_CUST_FOB_POINT | VARCHAR2 | (40) | Customer Freight On Board point | |
| TPLO_CUST_ORDER_TYPE | VARCHAR2 | (40) | Customer order type | |
| TPLO_CUST_PRICE_LIST | VARCHAR2 | (40) | Customer price list | |
| TPLO_CUST_FREIGHT | VARCHAR2 | (80) | Customer freight term | |
| TPLO_CUST_TERRITORY | VARCHAR2 | (40) | Customer territory | |
| TPLO_CUST_TAX_REF | VARCHAR2 | (80) | Customer tax reference number | |
| TPLO_CUST_SORT_PRTY | NUMBER | Customer site priority | ||
| TPLO_CUST_TAX_CODE | VARCHAR2 | (80) | Customer tax code | |
| TPLO_CUST_DEMAND_CLASS | VARCHAR2 | (80) | Customer demand class | |
| TPLO_CUST_TAX_CLASSFN | VARCHAR2 | (80) | Customer tax classification of the bill-to site | |
| TPLO_CUST_TAX_HDR_FLAG | VARCHAR2 | (20) | Indicates whether tax for customer should be calculated at the header level | |
| TPLO_CUST_TAX_ROUND | VARCHAR2 | (40) | Customer tax rounding rule | |
| TPLO_CUST_SALES_REP | VARCHAR2 | (120) | Customer sales representative name | |
| TPLO_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| TPLO_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| TPLO_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| TPLO_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| TPLO_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| TPLO_REQUEST_ID | NUMBER | Identifier used by collection program | ||
| TPLO_OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
| TPLO_ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| TPLO_COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
| TPLO_INSTANCE | VARCHAR2 | (40) | Source database instance for Trading Partner Location | |
| TPRT_TRADE_PARTNER_PK_KEY | NUMBER | System generated unique identifier | ||
| TPRT_TRADE_PARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
| TPRT_TRADE_PARTNER_DP | VARCHAR2 | (480) | Unique Trading Partner name | |
| TPRT_NAME | VARCHAR2 | (480) | Trading Partner name | |
| TPRT_ALTERNATE_NAME | VARCHAR2 | (320) | Trading Partner alternate name | |
| TPRT_START_ACTIVE_DATE | DATE | Start date for supplier validity | ||
| TPRT_END_ACTIVE_DATE | DATE | End date for supplier validity | ||
| TPRT_SIC_CODE | VARCHAR2 | (40) | Trading partner Standard Industrial Classification code | |
| TPRT_TAX_REG_NUM | VARCHAR2 | (80) | Tax registration number | |
| TPRT_TAXPAYER_ID | VARCHAR2 | (80) | Taxpayer Identification Number | |
| TPRT_PAYMENT_TERMS | VARCHAR2 | (80) | Payment terms agreed to with trading partner | |
| TPRT_VNDR_NUMBER | VARCHAR2 | (40) | Supplier number | |
| TPRT_VNDR_TYPE | VARCHAR2 | (80) | Supplier type | |
| TPRT_VNDR_ONE_TIME | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
| TPRT_VNDR_MINORITY_GRP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
| TPRT_VNDR_WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
| TPRT_VNDR_SMALL_BUS | VARCHAR2 | (20) | Indicator that supplier is small business | |
| TPRT_VNDR_HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
| TPRT_VNDR_INSPECT_REQ | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
| TPRT_VNDR_RECEIPT_REQ | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from trading partner before invoice is paid | |
| TPRT_VNDR_SUB_RECEIPT | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with supplier | |
| TPRT_VNDR_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
| TPRT_CUST_NUMBER | VARCHAR2 | (40) | Customer number | |
| TPRT_CUST_ORIG_SYS_REF | VARCHAR2 | (240) | Customer record identifier from system origination source | |
| TPRT_CUST_STATUS | VARCHAR2 | (80) | Customer status: Active or Inactive | |
| TPRT_CUST_TYPE | VARCHAR2 | (80) | Customer type | |
| TPRT_CUST_PROSPECT | VARCHAR2 | (40) | Indicates whether customer is a prospect | |
| TPRT_CUST_CLASS | VARCHAR2 | (40) | Customer class | |
| TPRT_CUST_SALES_REP | VARCHAR2 | (120) | Sales representative name for this customer | |
| TPRT_CUST_SALES_CHNL | VARCHAR2 | (80) | Customer sales channel | |
| TPRT_CUST_ORDER_TYPE | VARCHAR2 | (40) | Order type | |
| TPRT_CUST_PRICE_LIST | VARCHAR2 | (40) | Price list | |
| TPRT_CUST_ANALYSIS_FY | VARCHAR2 | (20) | Fiscal Year upon which customer financial information is based | |
| TPRT_CUST_CAT_CODE | VARCHAR2 | (80) | Customer category code | |
| TPRT_CUST_KEY | VARCHAR2 | (80) | Customer identifier | |
| TPRT_CUST_FISCAL_END | VARCHAR2 | (40) | Month that customer fiscal year ends | |
| TPRT_CUST_NUM_EMP | NUMBER | Number of employees | ||
| TPRT_CUST_REVENUE_CURR | NUMBER | Potential revenue from customer for the current fiscal year | ||
| TPRT_CUST_REVENUE_NEXT | NUMBER | Potential revenue from customer for the next fiscal year | ||
| TPRT_CUST_REF_USE_FLAG | VARCHAR2 | (20) | Indicates that customer has agreed to be a reference | |
| TPRT_CUST_TAX_CODE | VARCHAR2 | (80) | Customer tax code | |
| TPRT_CUST_THIRD_PARTY | VARCHAR2 | (20) | Indicates whether customer is a direct customer or a third party supplier | |
| TPRT_CUST_ACCESS_TMPL | VARCHAR2 | (40) | Template to auto-create customer new access control | |
| TPRT_CUST_COMPETITOR | VARCHAR2 | (20) | Indicates whether customer is a competitor | |
| TPRT_CUST_ORIG_SYS | VARCHAR2 | (40) | Customer record system origination source | |
| TPRT_CUST_YEAR_EST | NUMBER | Year in which customer business was established | ||
| TPRT_CUST_COTERM_DATE | VARCHAR2 | (20) | Date in which services ordered by customer will terminate | |
| TPRT_CUST_FOB_POINT | VARCHAR2 | (40) | Customer Freight On Board point | |
| TPRT_CUST_FREIGHT | VARCHAR2 | (80) | Customer freight term | |
| TPRT_CUST_GSA_IND | VARCHAR2 | (20) | Indicates customer is a Government Service Agency | |
| TPRT_CUST_SHIP_PARTIAL | VARCHAR2 | (20) | Indicates whether partial shipment to customer is allowed | |
| TPRT_CUST_SHIP_VIA | VARCHAR2 | (40) | Ship method | |
| TPRT_CUST_DO_NOT_MAIL | VARCHAR2 | (20) | Indicates whether or not mail can be sent to customer | |
| TPRT_CUST_TAX_HDR_FLAG | VARCHAR2 | (20) | Indicates whether tax for customer should be calculated at the header level | |
| TPRT_CUST_TAX_ROUND | VARCHAR2 | (40) | Customer tax rounding rule | |
| TPRT_INSTANCE | VARCHAR2 | (40) | Source database instance for Trading Partner | |
| TPRT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| TPRT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| TPRT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| TPRT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| TPRT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| TPRT_REQUEST_ID | NUMBER | Identifier used by collection program | ||
| TPRT_OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
| TPRT_ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| TPRT_COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
| PTP1_TPARTNER_PK_KEY | NUMBER | System generated unique identifier | ||
| PTP1_TPARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
| PTP1_TPARTNER_DP | VARCHAR2 | (480) | Unique Parent Trading Partner 1 name | |
| PTP1_NAME | VARCHAR2 | (480) | Parent Trading Partner 1 name | |
| PTP1_ALTERNATE_NAME | VARCHAR2 | (320) | Parent Trading Partner 1 alternate name | |
| PTP1_START_ACTIVE_DATE | DATE | Start date for supplier validity | ||
| PTP1_END_ACTIVE_DATE | DATE | End date for supplier validity | ||
| PTP1_SIC_CODE | VARCHAR2 | (40) | Trading partner Standard Industrial Classification code | |
| PTP1_TAX_REG_NUM | VARCHAR2 | (80) | Tax registration number | |
| PTP1_TAXPAYER_ID | VARCHAR2 | (80) | Taxpayer Identification Number | |
| PTP1_PAYMENT_TERMS | VARCHAR2 | (80) | Payment terms agreed to with trading partner | |
| PTP1_VENDOR_NUMBER | VARCHAR2 | (40) | Supplier number | |
| PTP1_VENDOR_TYPE | VARCHAR2 | (80) | Supplier type | |
| PTP1_ONE_TIME_FLAG | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
| PTP1_MINORITY_GROUP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
| PTP1_WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
| PTP1_SMALL_BUSINESS | VARCHAR2 | (20) | Indicator that supplier is small business | |
| PTP1_HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
| PTP1_INSPECT_REQUIRED | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
| PTP1_RECEIPT_REQUIRED | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from trading partner before invoice is paid | |
| PTP1_ALLOW_SUB_RECEIPT | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with supplier | |
| PTP1_ALLOW_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
| PTP1_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| PTP1_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| PTP1_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| PTP1_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| PTP1_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| PTP1_REQUEST_ID | NUMBER | Identifier used by collection program | ||
| PTP1_OPERATION_CODE | VARCHAR2 | (30) | Code used by collection program to determine whether to insert/update/delete this record | |
| PTP1_ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| PTP1_COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
| PTP1_INSTANCE | VARCHAR2 | (40) | Source database instance for Parent Trading Partner 1 | |
| PTP2_TPARTNER_PK_KEY | NUMBER | System generated unique identifier | ||
| PTP2_TPARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
| PTP2_TPARTNER_DP | VARCHAR2 | (480) | Unique Parent Trading Partner 2 name | |
| PTP2_NAME | VARCHAR2 | (480) | Parent Trading Partner 2 name | |
| PTP2_ALTERNATE_NAME | VARCHAR2 | (320) | Parent Trading Partner 2 alternate name | |
| PTP2_START_ACTIVE_DATE | DATE | Begin date for supplier validity | ||
| PTP2_END_ACTIVE_DATE | DATE | End date for supplier validity | ||
| PTP2_SIC_CODE | VARCHAR2 | (40) | Trading partner Standard Industrial Classification code | |
| PTP2_TAX_REG_NUM | VARCHAR2 | (80) | Tax registration number | |
| PTP2_TAXPAYER_ID | VARCHAR2 | (80) | Taxpayer Identification Number | |
| PTP2_PAYMENT_TERMS | VARCHAR2 | (80) | Payment terms agreed to with trading partner | |
| PTP2_VENDOR_NUMBER | VARCHAR2 | (40) | Supplier number | |
| PTP2_VENDOR_TYPE | VARCHAR2 | (80) | Supplier type | |
| PTP2_ONE_TIME_FLAG | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
| PTP2_MINORITY_GROUP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
| PTP2_WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
| PTP2_SMALL_BUSINESS | VARCHAR2 | (20) | Indicator that supplier is small business | |
| PTP2_HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
| PTP2_INSPECT_REQUIRED | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
| PTP2_RECEIPT_REQUIRED | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from trading partner before invoice is paid | |
| PTP2_ALLOW_SUB_RECEIPT | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with supplier | |
| PTP2_ALLOW_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
| PTP2_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| PTP2_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| PTP2_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| PTP2_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| PTP2_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| PTP2_REQUEST_ID | NUMBER | Identifier used by collection program | ||
| PTP2_OPERATION_CODE | VARCHAR2 | (30) | Code used by collection program to determine whether to insert/update/delete this record | |
| PTP2_ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| PTP2_COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
| PTP2_INSTANCE | VARCHAR2 | (40) | Source database instance for Parent Trading Partner 2 | |
| PTP3_TPARTNER_PK_KEY | NUMBER | System generated unique identifier | ||
| PTP3_TPARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
| PTP3_TPARTNER_DP | VARCHAR2 | (480) | Unique Parent Trading Partner 3 name | |
| PTP3_NAME | VARCHAR2 | (480) | Parent Trading Partner 3 name | |
| PTP3_ALTERNATE_NAME | VARCHAR2 | (320) | Parent Trading Partner 3 alternate name | |
| PTP3_START_ACTIVE_DATE | DATE | Begin date for supplier validity | ||
| PTP3_END_ACTIVE_DATE | DATE | End date for supplier validity | ||
| PTP3_SIC_CODE | VARCHAR2 | (40) | Trading partner Standard Industrial Classification code | |
| PTP3_TAX_REG_NUM | VARCHAR2 | (80) | Tax registration number | |
| PTP3_TAXPAYER_ID | VARCHAR2 | (80) | Taxpayer Identification Number | |
| PTP3_PAYMENT_TERMS | VARCHAR2 | (80) | Payment terms agreed to with trading partner | |
| PTP3_VENDOR_NUMBER | VARCHAR2 | (40) | Supplier number | |
| PTP3_VENDOR_TYPE | VARCHAR2 | (80) | Supplier type | |
| PTP3_ONE_TIME_FLAG | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
| PTP3_MINORITY_GROUP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
| PTP3_WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
| PTP3_SMALL_BUSINESS | VARCHAR2 | (20) | Indicator that supplier is small business | |
| PTP3_HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
| PTP3_INSPECT_REQUIRED | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
| PTP3_RECEIPT_REQUIRED | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from trading partner before invoice is paid | |
| PTP3_ALLOW_SUB_RECEIPT | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with supplier | |
| PTP3_ALLOW_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
| PTP3_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| PTP3_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| PTP3_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| PTP3_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| PTP3_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| PTP3_REQUEST_ID | NUMBER | Identifier used by collection program | ||
| PTP3_OPERATION_CODE | VARCHAR2 | (30) | Code used by collection program to determine whether to insert/update/delete this record | |
| PTP3_ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| PTP3_COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
| PTP3_INSTANCE | VARCHAR2 | (40) | Source database instance for Parent Trading Partner 3 | |
| PTP4_TPARTNER_PK_KEY | NUMBER | System generated unique identifier | ||
| PTP4_TPARTNER_PK | VARCHAR2 | (120) | Unique identifier | |
| PTP4_TPARTNER_DP | VARCHAR2 | (480) | Unique Parent Trading Partner 4 name | |
| PTP4_NAME | VARCHAR2 | (480) | Parent Trading Partner 4 name | |
| PTP4_ALTERNATE_NAME | VARCHAR2 | (320) | Parent Trading Partner 4 alternate name | |
| PTP4_START_ACTIVE_DATE | DATE | Begin date for supplier validity | ||
| PTP4_END_ACTIVE_DATE | DATE | End date for supplier validity | ||
| PTP4_SIC_CODE | VARCHAR2 | (40) | Trading partner Standard Industrial Classification code | |
| PTP4_TAX_REG_NUM | VARCHAR2 | (80) | Tax registration number | |
| PTP4_TAXPAYER_ID | VARCHAR2 | (80) | Taxpayer Identification Number | |
| PTP4_PAYMENT_TERMS | VARCHAR2 | (80) | Payment terms agreed to with trading partner | |
| PTP4_VENDOR_NUMBER | VARCHAR2 | (40) | Supplier number | |
| PTP4_VENDOR_TYPE | VARCHAR2 | (80) | Supplier type | |
| PTP4_ONE_TIME_FLAG | VARCHAR2 | (20) | Indicator that supplier is for one time purchase | |
| PTP4_MINORITY_GROUP | VARCHAR2 | (80) | Minority group represented by supplier owners | |
| PTP4_WOMEN_OWNED | VARCHAR2 | (20) | Indicator that supplier is woman-owned | |
| PTP4_SMALL_BUSINESS | VARCHAR2 | (20) | Indicator that supplier is small business | |
| PTP4_HOLD_FLAG | VARCHAR2 | (20) | Indicator that supplier is in hold status | |
| PTP4_INSPECT_REQUIRED | VARCHAR2 | (20) | Indicator that inspection is required for all shipments from trading partner | |
| PTP4_RECEIPT_REQUIRED | VARCHAR2 | (20) | Indicator that receipt is required for all shipments from trading partner before invoice is paid | |
| PTP4_ALLOW_SUB_RECEIPTS | VARCHAR2 | (20) | Indicator that receipts of substitute items are allowed with supplier | |
| PTP4_ALLOW_UNORDER_RCV | VARCHAR2 | (20) | Indicator that unordered receipts are allowed with trading partner | |
| PTP4_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| PTP4_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| PTP4_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| PTP4_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| PTP4_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| PTP4_REQUEST_ID | NUMBER | Identifier used by collection program | ||
| PTP4_OPERATION_CODE | VARCHAR2 | (30) | Code used by collection program to determine whether to insert/update/delete this record | |
| PTP4_ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| PTP4_COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
| PTP4_INSTANCE | VARCHAR2 | (40) | Source database instance for Parent Trading Partner 4 | |
| ALL_ID | NUMBER | Identifier for top level of Trading Partner dimension | ||
| ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier | |
| ALL_ALL_PK_KEY | NUMBER | System generated unique identifier | ||
| ALL_NAME | VARCHAR2 | (80) | Top level name | |
| ALL_ALL_DP | VARCHAR2 | (320) | Unique top level name | |
| 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 TPLO_LEVEL_NAME
, TPLO_ADDRESS_LINE1
, TPLO_ADDRESS_LINE2
, TPLO_ADDRESS_LINE3
, TPLO_ADDRESS_LINE4
, TPLO_CITY
, TPLO_COUNTY
, TPLO_STATE
, TPLO_POSTAL_CODE
, TPLO_PROVINCE
, TPLO_COUNTRY
, TPLO_TPARTNER_LOC_PK_KEY
, TPLO_TPARTNER_LOC_PK
, TPLO_TPARTNER_LOC_DP
, TPLO_NAME
, TPLO_BUSINESS_TYPE
, TPLO_DATE_FROM
, TPLO_DATE_TO
, TPLO_VNDR_PURCH_SITE
, TPLO_VNDR_RFQ_ONLY
, TPLO_VNDR_PAY_SITE
, TPLO_VNDR_PAY_TERMS
, TPLO_CUST_SITE_USE
, TPLO_CUST_LOCATION
, TPLO_CUST_PRIMARY_FLAG
, TPLO_CUST_STATUS
, TPLO_CUST_ORIG_SYS_REF
, TPLO_CUST_SIC_CODE
, TPLO_CUST_PAY_TERMS
, TPLO_CUST_GSA_IND
, TPLO_CUST_SHIP_PARTIAL
, TPLO_CUST_SHIP_VIA
, TPLO_CUST_FOB_POINT
, TPLO_CUST_ORDER_TYPE
, TPLO_CUST_PRICE_LIST
, TPLO_CUST_FREIGHT
, TPLO_CUST_TERRITORY
, TPLO_CUST_TAX_REF
, TPLO_CUST_SORT_PRTY
, TPLO_CUST_TAX_CODE
, TPLO_CUST_DEMAND_CLASS
, TPLO_CUST_TAX_CLASSFN
, TPLO_CUST_TAX_HDR_FLAG
, TPLO_CUST_TAX_ROUND
, TPLO_CUST_SALES_REP
, TPLO_USER_ATTRIBUTE1
, TPLO_USER_ATTRIBUTE2
, TPLO_USER_ATTRIBUTE3
, TPLO_USER_ATTRIBUTE4
, TPLO_USER_ATTRIBUTE5
, TPLO_REQUEST_ID
, TPLO_OPERATION_CODE
, TPLO_ERROR_CODE
, TPLO_COLLECTION_STATUS
, TPLO_INSTANCE
, TPRT_TRADE_PARTNER_PK_KEY
, TPRT_TRADE_PARTNER_PK
, TPRT_TRADE_PARTNER_DP
, TPRT_NAME
, TPRT_ALTERNATE_NAME
, TPRT_START_ACTIVE_DATE
, TPRT_END_ACTIVE_DATE
, TPRT_SIC_CODE
, TPRT_TAX_REG_NUM
, TPRT_TAXPAYER_ID
, TPRT_PAYMENT_TERMS
, TPRT_VNDR_NUMBER
, TPRT_VNDR_TYPE
, TPRT_VNDR_ONE_TIME
, TPRT_VNDR_MINORITY_GRP
, TPRT_VNDR_WOMEN_OWNED
, TPRT_VNDR_SMALL_BUS
, TPRT_VNDR_HOLD_FLAG
, TPRT_VNDR_INSPECT_REQ
, TPRT_VNDR_RECEIPT_REQ
, TPRT_VNDR_SUB_RECEIPT
, TPRT_VNDR_UNORDER_RCV
, TPRT_CUST_NUMBER
, TPRT_CUST_ORIG_SYS_REF
, TPRT_CUST_STATUS
, TPRT_CUST_TYPE
, TPRT_CUST_PROSPECT
, TPRT_CUST_CLASS
, TPRT_CUST_SALES_REP
, TPRT_CUST_SALES_CHNL
, TPRT_CUST_ORDER_TYPE
, TPRT_CUST_PRICE_LIST
, TPRT_CUST_ANALYSIS_FY
, TPRT_CUST_CAT_CODE
, TPRT_CUST_KEY
, TPRT_CUST_FISCAL_END
, TPRT_CUST_NUM_EMP
, TPRT_CUST_REVENUE_CURR
, TPRT_CUST_REVENUE_NEXT
, TPRT_CUST_REF_USE_FLAG
, TPRT_CUST_TAX_CODE
, TPRT_CUST_THIRD_PARTY
, TPRT_CUST_ACCESS_TMPL
, TPRT_CUST_COMPETITOR
, TPRT_CUST_ORIG_SYS
, TPRT_CUST_YEAR_EST
, TPRT_CUST_COTERM_DATE
, TPRT_CUST_FOB_POINT
, TPRT_CUST_FREIGHT
, TPRT_CUST_GSA_IND
, TPRT_CUST_SHIP_PARTIAL
, TPRT_CUST_SHIP_VIA
, TPRT_CUST_DO_NOT_MAIL
, TPRT_CUST_TAX_HDR_FLAG
, TPRT_CUST_TAX_ROUND
, TPRT_INSTANCE
, TPRT_USER_ATTRIBUTE1
, TPRT_USER_ATTRIBUTE2
, TPRT_USER_ATTRIBUTE3
, TPRT_USER_ATTRIBUTE4
, TPRT_USER_ATTRIBUTE5
, TPRT_REQUEST_ID
, TPRT_OPERATION_CODE
, TPRT_ERROR_CODE
, TPRT_COLLECTION_STATUS
, PTP1_TPARTNER_PK_KEY
, PTP1_TPARTNER_PK
, PTP1_TPARTNER_DP
, PTP1_NAME
, PTP1_ALTERNATE_NAME
, PTP1_START_ACTIVE_DATE
, PTP1_END_ACTIVE_DATE
, PTP1_SIC_CODE
, PTP1_TAX_REG_NUM
, PTP1_TAXPAYER_ID
, PTP1_PAYMENT_TERMS
, PTP1_VENDOR_NUMBER
, PTP1_VENDOR_TYPE
, PTP1_ONE_TIME_FLAG
, PTP1_MINORITY_GROUP
, PTP1_WOMEN_OWNED
, PTP1_SMALL_BUSINESS
, PTP1_HOLD_FLAG
, PTP1_INSPECT_REQUIRED
, PTP1_RECEIPT_REQUIRED
, PTP1_ALLOW_SUB_RECEIPT
, PTP1_ALLOW_UNORDER_RCV
, PTP1_USER_ATTRIBUTE1
, PTP1_USER_ATTRIBUTE2
, PTP1_USER_ATTRIBUTE3
, PTP1_USER_ATTRIBUTE4
, PTP1_USER_ATTRIBUTE5
, PTP1_REQUEST_ID
, PTP1_OPERATION_CODE
, PTP1_ERROR_CODE
, PTP1_COLLECTION_STATUS
, PTP1_INSTANCE
, PTP2_TPARTNER_PK_KEY
, PTP2_TPARTNER_PK
, PTP2_TPARTNER_DP
, PTP2_NAME
, PTP2_ALTERNATE_NAME
, PTP2_START_ACTIVE_DATE
, PTP2_END_ACTIVE_DATE
, PTP2_SIC_CODE
, PTP2_TAX_REG_NUM
, PTP2_TAXPAYER_ID
, PTP2_PAYMENT_TERMS
, PTP2_VENDOR_NUMBER
, PTP2_VENDOR_TYPE
, PTP2_ONE_TIME_FLAG
, PTP2_MINORITY_GROUP
, PTP2_WOMEN_OWNED
, PTP2_SMALL_BUSINESS
, PTP2_HOLD_FLAG
, PTP2_INSPECT_REQUIRED
, PTP2_RECEIPT_REQUIRED
, PTP2_ALLOW_SUB_RECEIPT
, PTP2_ALLOW_UNORDER_RCV
, PTP2_USER_ATTRIBUTE1
, PTP2_USER_ATTRIBUTE2
, PTP2_USER_ATTRIBUTE3
, PTP2_USER_ATTRIBUTE4
, PTP2_USER_ATTRIBUTE5
, PTP2_REQUEST_ID
, PTP2_OPERATION_CODE
, PTP2_ERROR_CODE
, PTP2_COLLECTION_STATUS
, PTP2_INSTANCE
, PTP3_TPARTNER_PK_KEY
, PTP3_TPARTNER_PK
, PTP3_TPARTNER_DP
, PTP3_NAME
, PTP3_ALTERNATE_NAME
, PTP3_START_ACTIVE_DATE
, PTP3_END_ACTIVE_DATE
, PTP3_SIC_CODE
, PTP3_TAX_REG_NUM
, PTP3_TAXPAYER_ID
, PTP3_PAYMENT_TERMS
, PTP3_VENDOR_NUMBER
, PTP3_VENDOR_TYPE
, PTP3_ONE_TIME_FLAG
, PTP3_MINORITY_GROUP
, PTP3_WOMEN_OWNED
, PTP3_SMALL_BUSINESS
, PTP3_HOLD_FLAG
, PTP3_INSPECT_REQUIRED
, PTP3_RECEIPT_REQUIRED
, PTP3_ALLOW_SUB_RECEIPT
, PTP3_ALLOW_UNORDER_RCV
, PTP3_USER_ATTRIBUTE1
, PTP3_USER_ATTRIBUTE2
, PTP3_USER_ATTRIBUTE3
, PTP3_USER_ATTRIBUTE4
, PTP3_USER_ATTRIBUTE5
, PTP3_REQUEST_ID
, PTP3_OPERATION_CODE
, PTP3_ERROR_CODE
, PTP3_COLLECTION_STATUS
, PTP3_INSTANCE
, PTP4_TPARTNER_PK_KEY
, PTP4_TPARTNER_PK
, PTP4_TPARTNER_DP
, PTP4_NAME
, PTP4_ALTERNATE_NAME
, PTP4_START_ACTIVE_DATE
, PTP4_END_ACTIVE_DATE
, PTP4_SIC_CODE
, PTP4_TAX_REG_NUM
, PTP4_TAXPAYER_ID
, PTP4_PAYMENT_TERMS
, PTP4_VENDOR_NUMBER
, PTP4_VENDOR_TYPE
, PTP4_ONE_TIME_FLAG
, PTP4_MINORITY_GROUP
, PTP4_WOMEN_OWNED
, PTP4_SMALL_BUSINESS
, PTP4_HOLD_FLAG
, PTP4_INSPECT_REQUIRED
, PTP4_RECEIPT_REQUIRED
, PTP4_ALLOW_SUB_RECEIPTS
, PTP4_ALLOW_UNORDER_RCV
, PTP4_USER_ATTRIBUTE1
, PTP4_USER_ATTRIBUTE2
, PTP4_USER_ATTRIBUTE3
, PTP4_USER_ATTRIBUTE4
, PTP4_USER_ATTRIBUTE5
, PTP4_REQUEST_ID
, PTP4_OPERATION_CODE
, PTP4_ERROR_CODE
, PTP4_COLLECTION_STATUS
, PTP4_INSTANCE
, ALL_ID
, ALL_ALL_PK
, ALL_ALL_PK_KEY
, ALL_NAME
, ALL_ALL_DP
, CREATION_DATE
, LAST_UPDATE_DATE
FROM POA.EDW_TRD_PARTNER_M;
POA.EDW_TRD_PARTNER_M does not reference any database object
POA.EDW_TRD_PARTNER_M is referenced by following:
APPS
EDW_TRD_PARTNER_M
|
|
|
|