DP_DDHXTRCT_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	DP_DDHUPD_DTTM	DateTime(26)	TIMESTAMP	datetime of last update to demand_history table
4	DP_DDHUPD_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	DP_DDHUPD_SOURCE BI=Billing IN=Material Request OM=Sales Order PL=Planning Requisition PR=Purchasing Requisition RT=Material Return SO=Order Shipments
5	DP_DDH_BI	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_BI Y/N Table Edit Default Value: N
6	DP_DDH_OM	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_OM Y/N Table Edit Default Value: N
7	DP_DDH_SO	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_SO Y/N Table Edit Default Value: N
8	DP_DDH_IN	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_IN Y/N Table Edit Default Value: N
9	DP_DDH_PL	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_PL Y/N Table Edit Default Value: N
10	DP_DDH_PR	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_PR Y/N Table Edit Default Value: N
11	DP_DDH_KT	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_PR Y/N Table Edit Default Value: N
12	DP_DDH_NKT	Character(1)	VARCHAR2(1) NOT NULL	DP_DDH_PR Y/N Table Edit Default Value: N
13	DP_DDHUPD_DATE	Date(10)	DATE	DP_DDHUPD_DATE
14	DP_DDHUPD_DATE_FR	Date(10)	DATE	DP_DDHUPD_DATE_FR
15	DP_DDHUPD_DATE_TO	Date(10)	DATE	DP_DDHUPD_DATE_TO
16	DP_DDHUPD_ROWS	Number(7,0)	INTEGER NOT NULL	DP_DDHUPD_ROWS
17	DP_DDHUPD_LOGTXT	Character(50)	VARCHAR2(50) NOT NULL	DP_DDHUPD_LOGTXT
18	DP_DDHUPD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	DP_DDHUPD_STATUS -1=Error 0=Started 2=Loaded
19	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description