OCD_HEADER_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	BULK_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determinate if an order is the master order when using bulk ordering.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RO_NONVW
4	SETID_CAPTURE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	MOC SETID Field
5	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order Prompt Table: RO_TYPE
6	SETID_SRC_CD	Character(5)	VARCHAR2(5) NOT NULL	Setid Source Code
7	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code Prompt Table: RO_DEFN_SOURCE
8	SETID_STATUS	Character(5)	VARCHAR2(5) NOT NULL	MOC SETID Field
9	STATUS_CODE	Number(5,0)	INTEGER NOT NULL	Status Code Prompt Table: RO_DEFN_HDSTAT
10	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
11	BO_ID_SOLD_TO_CUST	Number(31,0)	DECIMAL(31) NOT NULL	BO ID for the sold to customer
12	BO_ID_SOLD_TO_CNT	Number(31,0)	DECIMAL(31) NOT NULL	BO ID for the sold to contact.
13	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
14	ORDER_STAGE	Character(15)	VARCHAR2(15) NOT NULL	This field indicates which of the stages that the order is in.
15	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
16	SUBMISSION_DTTM	DateTime(26)	TIMESTAMP	This is the submission date time of an order.
17	FINISH_HOLD1_DTTM	DateTime(26)	TIMESTAMP	This is the date time that the order finished the first hold check.
18	FINISH_QUEUE_DTTM	DateTime(26)	TIMESTAMP	This is the date time that an order finished the queue status.
19	FINISH_HOLD2_DTTM	DateTime(26)	TIMESTAMP	This is the date time that an order finished the second hold check.
20	FINISH_BP_DTTM	DateTime(26)	TIMESTAMP	This is the date time that an order finished the business project.
21	START_DTTM	DateTime(26)	TIMESTAMP	start date time
22	EST_TASK_TIME	Number(15,0)	DECIMAL(15) NOT NULL	Estimated Time to finish the task.
23	EST_TOTAL_TIME	Number(15,0)	DECIMAL(15) NOT NULL	This is a field for storing the estimated time to finish the order.
24	CURRENCY_DATE	Date(10)	DATE	Order capture date used for orders and quotes