ORDER_TREE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
3	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
4	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	NODE_VALUE	Character(60)	VARCHAR2(60) NOT NULL	Field used for storing node value information
7	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Y/N Table Edit Default Value: N
8	ATTRIBUTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing attribute flag information Y/N Table Edit Default Value: N
9	EXPANDED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expanded Flag Y/N Table Edit Default Value: N
10	LEAF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Leaf Flag Y/N Table Edit Default Value: N
11	NODECOL_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Collapsed Node Image Field
12	NODECOL_IMAGE_1	Character(30)	VARCHAR2(30) NOT NULL	Collapsed Node Image Field
13	NODECOL_IMAGE_2	Character(30)	VARCHAR2(30) NOT NULL	Node Image Name
14	NODECOL_SHRD_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Collapsed Node Image Field
15	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
16	LINE_NBR_REL	Number(5,0)	INTEGER NOT NULL	Related Line
17	LINE_NBR_REL_1	Number(5,0)	INTEGER NOT NULL	Field used for storing related order line (line number) information
18	LINE_NBR_REL_2	Number(5,0)	INTEGER NOT NULL	Field used for storing related order line (line number) information
19	UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
20	UID20F	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID...................................................................
21	WIDTH	Number(2,0)	SMALLINT NOT NULL	Width
22	HEIGHT	Number(2,0)	SMALLINT NOT NULL	Height
23	IMAGE_WIDTH	Number(2,0)	SMALLINT NOT NULL	Image Width
24	IMAGE_WIDTH_1	Number(2,0)	SMALLINT NOT NULL	Image Width
25	IMAGE_WIDTH_2	Number(2,0)	SMALLINT NOT NULL	Image Width
26	IMAGE_HEIGHT	Number(2,0)	SMALLINT NOT NULL	Image Height
27	IMAGE_HEIGHT_1	Number(2,0)	SMALLINT NOT NULL	Image Height
28	IMAGE_HEIGHT_2	Number(2,0)	SMALLINT NOT NULL	Image Height
29	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
30	MESSAGE_NBR01	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
31	MESSAGE_NBR02	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
32	MESSAGE_NBR03	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
33	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
34	MESSAGE_SET_NBR01	Number(5,0)	INTEGER NOT NULL	Message Catalog Number is used to store the message catalog number and dynamically retrieve a message.
35	MESSAGE_SET_NBR02	Number(5,0)	INTEGER NOT NULL	Message Set Number
36	MESSAGE_SET_NBR_SR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
37	CAPTURE_ID_REL	Character(20)	VARCHAR2(20) NOT NULL	This field stores relative capture IDs.