CURR_LOG_BUDG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
3	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
4	CURR_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
5	FROM_CURRENCY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	From Currency Type L=Ledger Base Currency S=Specify
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_TBL
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
23	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_ID_VW
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	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
30	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
31	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.
32	POSTED_TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.
33	POSTED_TRAN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Posted Transaction Amount
34	POSTED_BASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination, in the base currency of the business unit. Unless the Separate Debit/Credit option is set up, the ledger stores net amounts only.
35	RESTATED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remeasured Amount
36	REVAL_ADJUSTMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation Adjustment Amount
37	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
38	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
39	TARGET_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Target Currency