DELV_HIST_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
4	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	DELIVERY_TXN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Delivery Transaction Type 00=Received 10=Added to Cart 15=Removed from Cart 20=Delivery Attempted 30=Delivered 40=Delivery Data Changed 50=Undelivered
8	DELIVERY_TXN_SRC	Character(1)	VARCHAR2(1) NOT NULL	Delivery Transaction Source 0=Online 1=Mobile 2=Other
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
11	DELIVERY_CART_ID	Character(10)	VARCHAR2(10) NOT NULL	Container ID
12	DELIVERY_FEEDBACK	Character(240)	VARCHAR2(240) NOT NULL	Delivery Feedback
13	DELIVERED_TO	Character(30)	VARCHAR2(30) NOT NULL	Delivered To
14	DELIVERED_DT	Date(10)	DATE	Delivered Date
15	DELIVERED_TM	Time(15)	TIMESTAMP	Delivered Time
16	DELIVERED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Deliverer
17	FLEX_FIELD_C30_A	Character(30)	VARCHAR2(30) NOT NULL	Flex Field Char 30 A
18	FLEX_FIELD_C30_B	Character(30)	VARCHAR2(30) NOT NULL	Flex Field Char 30 B
19	FLEX_FIELD_C30_C	Character(30)	VARCHAR2(30) NOT NULL	Flex Field Char 30 C
20	FLEX_FIELD_C30_D	Character(30)	VARCHAR2(30) NOT NULL	Flex Field Char 30 D
21	FLEX_FIELD_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Flex Field Char 1 A
22	FLEX_FIELD_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Flex Field Char 1 B
23	FLEX_FIELD_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Flex Field Char 1 C
24	FLEX_FIELD_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Flex Field Char 1 D
25	FLEX_FIELD_C10_A	Character(10)	VARCHAR2(10) NOT NULL	Flex Field Char 10 A
26	FLEX_FIELD_C10_B	Character(10)	VARCHAR2(10) NOT NULL	Flex Field Char 10 B
27	FLEX_FIELD_C10_C	Character(10)	VARCHAR2(10) NOT NULL	Flex Field Char 10 C
28	FLEX_FIELD_C10_D	Character(10)	VARCHAR2(10) NOT NULL	Flex Field Char 10 D
29	FLEX_FIELD_C2	Character(2)	VARCHAR2(2) NOT NULL	Flex Field Char 2
30	FLEX_FIELD_C4	Character(4)	VARCHAR2(4) NOT NULL	Flex Field Char 4
31	FLEX_FIELD_C6	Character(6)	VARCHAR2(6) NOT NULL	Flex Field Char 6
32	FLEX_FIELD_C8	Character(8)	VARCHAR2(8) NOT NULL	Flex Field Char 8
33	FLEX_FIELD_N12_A	Number(16,3)	DECIMAL(15,3) NOT NULL	Flex Field Numeric 12 A
34	FLEX_FIELD_N12_B	Number(16,3)	DECIMAL(15,3) NOT NULL	Flex Field Numeric 12 B
35	FLEX_FIELD_N12_C	Number(16,3)	DECIMAL(15,3) NOT NULL	Flex Field Numeric 12 C
36	FLEX_FIELD_N12_D	Number(16,3)	DECIMAL(15,3) NOT NULL	Flex Field Numeric 12 D
37	FLEX_FIELD_N15_A	Number(15,0)	DECIMAL(15) NOT NULL	Flex Field Numeric 15 A
38	FLEX_FIELD_N15_B	Number(15,0)	DECIMAL(15) NOT NULL	Flex Field Numeric 15 B
39	FLEX_FIELD_N15_C	Number(15,0)	DECIMAL(15) NOT NULL	Flex Field Numeric 15 C
40	FLEX_FIELD_N15_D	Number(15,0)	DECIMAL(15) NOT NULL	Flex Field Numeric 15 D
41	FLEX_FIELD_S15_A	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Flex Field Signed 15.15 A
42	FLEX_FIELD_S15_B	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Flex Field Signed 15.15 B
43	FLEX_FIELD_S15_C	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Flex Field Signed 15.15 C
44	FLEX_FIELD_S15_D	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Flex Field Signed 15.15 D
45	FLEX_FIELD_DT_A	DateTime(26)	TIMESTAMP	Flex Field Datetime A
46	FLEX_FIELD_DT_B	DateTime(26)	TIMESTAMP	Flex Field Datetime B
47	FLEX_FIELD_DT_C	DateTime(26)	TIMESTAMP	Flex Field Datetime C
48	FLEX_FIELD_DT_D	DateTime(26)	TIMESTAMP	Flex Field Datetime D
49	GROUPBOX	Character(1)	VARCHAR2(1) NOT NULL	Groupbox