TD_TREE_NODE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	TD_TREE_ID	Character(8)	VARCHAR2(8) NOT NULL	Tree ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	TD_NODE_ID	Character(8)	VARCHAR2(8) NOT NULL	Node ID
5	TD_NODE_PARENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Node ID
6	TD_SEQNO	Number(15,4)	DECIMAL(14,4) NOT NULL	Sequence Number
7	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
8	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
9	TD_TREE_BRANCH	Character(20)	VARCHAR2(20) NOT NULL	Tree Branch Node ID
10	TD_TREE_BRANCH_PAR	Character(20)	VARCHAR2(20) NOT NULL	Parent Branch
11	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
12	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
13	PROMO_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Promotional Group
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	TD_NODE_LEVEL	Number(3,0)	SMALLINT NOT NULL	Node Level
16	TD_CUST_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Customer Class
17	TD_WEIGHTING	Number(6,2)	DECIMAL(5,2) NOT NULL	Weighting
18	TD_NODE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Node Type
19	TD_CHILD_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Number Of Children