[Home] [Help]
View: EDW_TPRT_TPARTNER_LOC_LTC_IV
| Product: | BIS - Applications BIS |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ROWID ROW_ID
, BUSINESS_TYPE
, CUST_SIC_CODE
, CUST_SHIP_VIA
, CUST_SHIP_PARTIAL
, CUST_SALES_REP
, CUST_PRIMARY_FLAG
, CUST_PRICE_LIST
, CUST_PAY_TERMS
, CUST_ORIG_SYS_REF
, CUST_ORDER_TYPE
, VNDR_RFQ_ONLY
, VNDR_PURCH_SITE
, VNDR_PAY_TERMS
, VNDR_PAY_SITE
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, TRADE_PARTNER_KEY
, TRADE_PARTNER
, TPARTNER_LOC_PK_KEY
, TPARTNER_LOC_PK
, NAME
, LEVEL_NAME
, LAST_UPDATE_DATE
, INSTANCE
, DATE_TO
, DATE_FROM
, CUST_TERRITORY
, CUST_TAX_ROUND
, CUST_TAX_REF
, CUST_TAX_HDR_FLAG
, CUST_TAX_CODE
, CUST_TAX_CLASSFN
, CUST_STATUS
, CUST_SORT_PRTY
, CUST_SITE_USE
, CUST_DEMAND_CLASS
, CUST_FOB_POINT
, CUST_FREIGHT
, CUST_LOCATION
, CUST_GSA_IND
, CREATION_DATE
, BUSINESS_UNIT_DP
, ' ' OPERATION_CODE
FROM EDW_TPRT_TPARTNER_LOC_LTC
Columns
| Name |
| ROW_ID |
| BUSINESS_TYPE |
| CUST_SIC_CODE |
| CUST_SHIP_VIA |
| CUST_SHIP_PARTIAL |
| CUST_SALES_REP |
| CUST_PRIMARY_FLAG |
| CUST_PRICE_LIST |
| CUST_PAY_TERMS |
| CUST_ORIG_SYS_REF |
| CUST_ORDER_TYPE |
| VNDR_RFQ_ONLY |
| VNDR_PURCH_SITE |
| VNDR_PAY_TERMS |
| VNDR_PAY_SITE |
| USER_ATTRIBUTE5 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE1 |
| TRADE_PARTNER_KEY |
| TRADE_PARTNER |
| TPARTNER_LOC_PK_KEY |
| TPARTNER_LOC_PK |
| NAME |
| LEVEL_NAME |
| LAST_UPDATE_DATE |
| INSTANCE |
| DATE_TO |
| DATE_FROM |
| CUST_TERRITORY |
| CUST_TAX_ROUND |
| CUST_TAX_REF |
| CUST_TAX_HDR_FLAG |
| CUST_TAX_CODE |
| CUST_TAX_CLASSFN |
| CUST_STATUS |
| CUST_SORT_PRTY |
| CUST_SITE_USE |
| CUST_DEMAND_CLASS |
| CUST_FOB_POINT |
| CUST_FREIGHT |
| CUST_LOCATION |
| CUST_GSA_IND |
| CREATION_DATE |
| BUSINESS_UNIT_DP |
| OPERATION_CODE |