BU_BOOK_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DISTRIBUTION_SW	Character(1)	VARCHAR2(1) NOT NULL	Distribution Switch N=No Y=Yes
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	ACCT_ENT_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Account Entry Template ID
5	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	BUD_LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Budget Ledger Group
8	BUDGET_LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Budget Ledger
9	CAL_DEPR_PD	Character(2)	VARCHAR2(2) NOT NULL	Calendar
10	LEASE_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Book used by Lease
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	ROUND_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Round Type C=Currency G=Generic
13	ROUND_RULE_AM	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down N=Natural Round U=Round Up
14	ROUND_PRECISION	Signed Number(4,0)	DECIMAL(3) NOT NULL	Rounding Precision
15	ROUND_FACTOR	Number(15,7)	DECIMAL(14,7) NOT NULL	Rounding Factor
16	TRUNCATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used for Round Up. 'Y'es - truncate 1 decimal place past the round precision. 'N' - do not truncate
17	BOOK_STATUTORY	Character(10)	VARCHAR2(10) NOT NULL	Statutory Book
18	DEROGATORY_SW	Character(1)	VARCHAR2(1) NOT NULL	Derogatory Depreciation
19	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
20	TRANSLATE_ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Translate Account
21	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account