ALLOC_CLCLG_BUD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROCESS_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
6	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_TBL
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
8	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
9	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
10	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
11	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
12	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
13	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
14	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
15	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
16	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
17	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
18	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
19	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
20	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
21	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
22	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
23	GL_ADJUST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type
24	SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca Prompt Table: BD_SCENARIO_TBL
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
26	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
27	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
28	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
29	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
30	ALLOC_POOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Allocations Pool Amount
31	ALLOC_POOL_PBA	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Allocations Pool PBA Amount
32	ALLOC_POOL_PTR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Log posted tran amount
33	ALLOC_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Basis Amt
34	ALLOC_BASIS_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Basis Total
35	ALLOC_TARG_OFF_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Target/Offset Amount
36	ALLOC_TARG_OFF_PBA	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Target/Offset PBA Amt
37	ALLOC_TARG_OFF_PTR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Target/Offset posted transaction amount
38	LOGICAL_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Allocations Logical Record O=Offset T=Target