CUSTCPY_PRDCT_V

(SQL View)
Index Back

Cust Copy-cust/prod link

View of Customer Aliases on the customer record for copy function.

SELECT SETID, CUST_ID, CATALOG_NBR FROM PS_PRODCTLG_CUST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CUST_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
3 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number

Prompt Table: PRODCTLG_TBL