CUSTCPY_SHEXB_V

(SQL View)
Index Back

Shipment date block exceptions

View of blocked shipment dates on the customer record for copy function.

SELECT SETID, CUST_ID, DTTM_FROM, DTTM_TO FROM PS_CUST_SHEX_BLK

# 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 DTTM_FROM DateTime(26) TIMESTAMP From Date/Time
4 DTTM_TO DateTime(26) TIMESTAMP To Date/Time