SCON_RELEASE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID Prompt Table: SCON_HDR
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number Default Value: 1
5	REQ_SHIP_DTTM	DateTime(26)	TIMESTAMP	Requested Ship
6	REQ_ARRIVAL_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Requested Arrival
7	TRNSPT_LEAD_DAYS	Number(3,0)	SMALLINT NOT NULL	Transportation Lead Tm (days)
8	TRNSPT_LEAD_HOURS	Number(2,0)	SMALLINT NOT NULL	Transportation Lead Tm (Hours)
9	TRNSPT_LEAD_MIN	Number(2,0)	SMALLINT NOT NULL	Transportation Lead Tm (Min)
10	QTY_RELEASE	Number(16,4)	DECIMAL(15,4) NOT NULL	Release Quantity
11	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: CUST_SLDSHP_VW
12	INCL_IN_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Include in Planning Y/N Table Edit Default Value: N
13	RELEASE_DTTM	DateTime(26)	TIMESTAMP	Release Date/Time
14	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
15	CUSTOMER_PO_LINE	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Line
16	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
17	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
18	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID