ALLOC_DEFN_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: ALLOC_DEFN.BUSINESS_UNIT
2	ALLOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Allocation Id Default Value: ALLOC_DEFN.ALLOC_ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: ALLOC_DEFN.EFFDT
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Default Value: ALLOC_DEFN.BOOK
5	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
6	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
7	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
8	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
9	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
10	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
11	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
12	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
13	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
14	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
15	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
16	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
17	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: ALLOC_DEFN.PROJECT_ID
18	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Default Value: ALLOC_DEFN.PROJECT_ID
19	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category Default Value: ALLOC_DEFN.CATEGORY
20	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type Default Value: ALLOC_DEFN.COST_TYPE
21	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: COST_ALLOC_VW1
22	BASIS_ID	Character(10)	VARCHAR2(10) NOT NULL	Allocation Basis Id Default Value: ALLOC_DEFN.BASIS_ID Prompt Table: ALLOC_BASIS Set Control Field: BUSINESS_UNIT