[Home] [Help]
| Product: | BIS - Applications BIS |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID ROW_ID
, ALTERNATE_NAME
, PARENT_TPARTNER_KEY
, PARENT_TPARTNER
, NAME
, LAST_UPDATE_DATE
, INSTANCE
, END_ACTIVE_DATE
, CUST_YEAR_EST
, CUST_TYPE
, CUST_THIRD_PARTY
, CUST_TAX_ROUND
, CUST_TAX_HDR_FLAG
, CUST_TAX_CODE
, CUST_STATUS
, CUST_SHIP_VIA
, CUST_SHIP_PARTIAL
, CUST_SALES_REP
, CUST_SALES_CHNL
, CUST_REVENUE_NEXT
, CUST_REVENUE_CURR
, CUST_REF_USE_FLAG
, CUST_PROSPECT
, CUST_PRICE_LIST
, CUST_ORIG_SYS_REF
, CUST_ORIG_SYS
, CUST_ORDER_TYPE
, CUST_NUM_EMP
, CUST_NUMBER
, CUST_KEY
, CUST_GSA_IND
, CUST_FREIGHT
, CUST_FOB_POINT
, CUST_FISCAL_END
, CUST_DO_NOT_MAIL
, VNDR_WOMEN_OWNED
, VNDR_UNORDER_RCV
, VNDR_TYPE
, VNDR_SUB_RECEIPT
, VNDR_SMALL_BUS
, VNDR_RECEIPT_REQ
, VNDR_ONE_TIME
, VNDR_NUMBER
, VNDR_MINORITY_GRP
, VNDR_INSPECT_REQ
, VNDR_HOLD_FLAG
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, TRADE_PARTNER_PK_KEY
, TRADE_PARTNER_PK
, TRADE_PARTNER_DP
, TAX_REG_NUM
, TAXPAYER_ID
, START_ACTIVE_DATE
, SIC_CODE
, PAYMENT_TERMS
, CUST_ANALYSIS_FY
, CUST_CAT_CODE
, CUST_CLASS
, CUST_COTERM_DATE
, CUST_COMPETITOR
, CUST_ACCESS_TMPL
, CREATION_DATE
, ' ' OPERATION_CODE
FROM EDW_TPRT_TRADE_PARTNER_LTC