CUST_SHEXDT_VW

(SQL View)
Index Back

Shipment Exception Date/Time


select setid, cust_id, ship_day, time_from, time_to from PS_CUST_SHEX_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
3 SHIP_DAY Character(1) VARCHAR2(1) NOT NULL Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
4 TIME_FROM Time(15) TIMESTAMP NOT NULL From Time
5 TIME_TO Time(15) TIMESTAMP NOT NULL To Time