[Home] [Help]
View: EDW_TPRT_P1_TPARTNER_LCV
Product: | PO - Purchasing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TPARTNER_PK
, PARENT_TPARTNER_FK
, LAST_UPDATE_DATE
, CREATION_DATE
, TPARTNER_DP
, NAME
, ALTERNATE_NAME
, START_ACTIVE_DATE
, END_ACTIVE_DATE
, SIC_CODE
, TAX_REG_NUM
, TAXPAYER_ID
, PAYMENT_TERMS
, VENDOR_NUMBER
, VENDOR_TYPE
, ONE_TIME_FLAG
, MINORITY_GROUP
, WOMEN_OWNED
, SMALL_BUSINESS
, HOLD_FLAG
, INSPECT_REQUIRED
, RECEIPT_REQUIRED
, ALLOW_SUB_RECEIPT
, ALLOW_UNORDER_RCV
, INSTANCE
, VENDOR_ID
, OPERATION_CODE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5 FROM EDWBV_TPRT_P1_TPARTNER_LCV
Columns
Name |
TPARTNER_PK |
PARENT_TPARTNER_FK |
LAST_UPDATE_DATE |
CREATION_DATE |
TPARTNER_DP |
NAME |
ALTERNATE_NAME |
START_ACTIVE_DATE |
END_ACTIVE_DATE |
SIC_CODE |
TAX_REG_NUM |
TAXPAYER_ID |
PAYMENT_TERMS |
VENDOR_NUMBER |
VENDOR_TYPE |
ONE_TIME_FLAG |
MINORITY_GROUP |
WOMEN_OWNED |
SMALL_BUSINESS |
HOLD_FLAG |
INSPECT_REQUIRED |
RECEIPT_REQUIRED |
ALLOW_SUB_RECEIPT |
ALLOW_UNORDER_RCV |
INSTANCE |
VENDOR_ID |
OPERATION_CODE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |