IN_SDA_CCHT_RS1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DATE_TO	Date(10)	DATE	Date To
2	DATE_STRING	Character(25)	VARCHAR2(25) NOT NULL	Label for Completion Date
3	TOTAL_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Total Quantity
4	TOTAL_QTY_TEXT	Character(30)	VARCHAR2(30) NOT NULL	Total Quantity
5	EXTENDED_NET_PRICE	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Ext Net Amount
6	EXT_NET_PRICE_TXT	Character(40)	VARCHAR2(40) NOT NULL	Estimated Total Cost
7	IN_SDA_ORD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Used for mapping in_fulfill_state and po_status together into a field used for PAR analytics. 10=Pending 12=Approved 14=Line Approved 20=Unfulfilled 22=Open 24=Dispatched 30=Releasable 40=Released 50=Confirmed 60=Shipped 66=Completed 76=Received
8	ORDER_COUNT	Number(5,0)	INTEGER NOT NULL	Line Count
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	TEXT80	Character(80)	VARCHAR2(80) NOT NULL	80 Char text field
11	HOVERTEXT	Character(80)	VARCHAR2(80) NOT NULL	Hovertext
12	WM_DATACOLOR	Signed Number(4,0)	DECIMAL(3) NOT NULL	Data Color
13	INTERVAL_VAL	Number(9,0)	DECIMAL(9) NOT NULL	Interval
14	IN_SDA_CHT_SRC	Character(3)	VARCHAR2(3) NOT NULL	Sup/Dmd Chart Legend Src D1=Sales Orders D2=Material Stock Requests D3=Other Order Demand D50=Sales Orders, MSRs D51=Sales Orders, MSRs, Other D52=Sales Orders, MSRs, Prdn D53=Sales Orders, Other Demand D54=Sales Orders, Other, Prdn D55=Sales Orders, Prdn Comps D56=MSRs, Other Demand D57=MSRs, Other, Prdn Dmd D58=MSRs, Prdn Comps D59=Other Dmd, Prdn Comps D8=Prdn Components D90=All Demand P1=Purchase Orders P2=Requisitions P3=Material Stock Requests P50=POs, Reqs P51=POs, MSRs P52=Reqs, MSRs P90=All Par Orders S1=Purchasing S2=Prdn Assemblies S3=Interunit Transfers S50=Purchasing, Prdn Assys S51=Purchasing, IUTs S52=Prdn Assys, IUT S90=All Supply
15	SOURCE_TEXT	Character(45)	VARCHAR2(45) NOT NULL	Source Key