RVL_AR_BU_DBT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
10	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
11	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
12	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
13	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
14	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
15	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
16	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
17	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
18	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
19	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
20	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
21	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
22	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
23	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
24	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
25	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
26	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
27	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PC_GL_AN_GRP_VW Set Control Field: BUSINESS_UNIT_PC
28	BUDGET_DT	Date(10)	DATE	Budget Date
29	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
30	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
31	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
32	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
33	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
34	DOUBTFUL	Character(1)	VARCHAR2(1) NOT NULL	Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.