CUSTCPY_SHEXB_V(SQL View) |
Index Back |
---|---|
Shipment date block exceptionsView 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 |