ALLOC_CALC_LOG

#	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
6	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
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	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
21	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
22	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
23	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
24	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
25	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
26	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
27	GL_ADJUST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type
28	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PROJ_ANTYPE_FS
29	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: PROJ_SUBCAT_FS
30	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: PROJ_RESCAT_FS
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
32	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
33	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
34	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.
35	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
36	ALLOC_POOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Allocations Pool Amount
37	ALLOC_POOL_PBA	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Allocations Pool PBA Amount
38	ALLOC_POOL_PTR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Log posted tran amount
39	ALLOC_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Basis Amt
40	ALLOC_BASIS_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Basis Total
41	ALLOC_TARG_OFF_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Target/Offset Amount
42	ALLOC_TARG_OFF_PBA	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Alloc Target/Offset PBA Amt
43	ALLOC_TARG_OFF_PTR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Target/Offset posted transaction amount
44	LOGICAL_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Allocations Logical Record O=Offset T=Target
45	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID