R_HR_ACCRUAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
5	DRCR	Character(1)	VARCHAR2(1) NOT NULL	Debit/Credit Flag
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
8	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
9	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
10	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
11	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
12	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
13	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
14	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
15	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
16	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
17	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
18	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
19	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
20	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
21	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
22	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
23	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Journal Line Reference
24	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
25	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
26	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Journal Line Description
27	SETID_HR	Character(5)	VARCHAR2(5) NOT NULL	SetID - HR
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	REVERSED	Character(1)	VARCHAR2(1) NOT NULL	Reversed