CUSTCPY_INDR_VW

(SQL View)
Index Back

Cust Copy-Valid Indirect

View of valid Indirect relationships on the customer record for copy function.

SELECT SETID , CUST_ID , INDIRECT_CUST_ID , SHPTO_PRIORITY_NBR FROM PS_CUST_INDIRECT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: CUSTOMER.SETID

Prompt Table: SP_SETID_NONVW

2 CUST_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
3 INDIRECT_CUST_ID Character(15) VARCHAR2(15) NOT NULL Indirect Customer ID

Prompt Table: CUST_IND_A1S_VW

4 SHPTO_PRIORITY_NBR Number(4,0) SMALLINT NOT NULL Ship To Priority