eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDW_TPRT_P3_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_P3_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