CUST_SHEX_DT (SQL Table)	Index Back
Shipment Exception Date/Time This table stores the standing daily exception dates and times that a customer cannot receive deliveries. This table is consulted during quotation and order entry when trying to determine a scheduled arrival date. Date Init. Issue # Description 08/14/01 JJM DI-EDWONG-17 Inverted CUST_ID, SETID in index 01/21/02 dms 10944801 Add dummy dttm fields

CUST_SHEX_DT

(SQL Table)

Shipment Exception Date/Time

This table stores the standing daily exception dates and times that a customer cannot receive deliveries. This table is consulted during quotation and order entry when trying to determine a scheduled arrival date. Date Init. Issue # Description 08/14/01 JJM DI-EDWONG-17 Inverted CUST_ID, SETID in index 01/21/02 dms 10944801 Add dummy dttm fields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

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

6 DTTM_FROM DateTime(26) TIMESTAMP From Date/Time

7 DTTM_TO DateTime(26) TIMESTAMP To Date/Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
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
6	DTTM_FROM	DateTime(26)	TIMESTAMP	From Date/Time
7	DTTM_TO	DateTime(26)	TIMESTAMP	To Date/Time