RPTG_BALANCE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RPTG_APPL_ID	Character(3)	VARCHAR2(3) NOT NULL	Reporting Application AP=Accounts Payable AR=Accounts Receivable BI=Billing EX=Expenses
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	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.
5	RPTG_BALANCE_SEQ	Signed Number(19,0)	DECIMAL(18) NOT NULL	Reporting Balance Line
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
8	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
9	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
11	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
12	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.
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
15	RPTG_BEGIN_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reporting Beginning Balance
16	MONETARY_AMT_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base DR Amount
17	MONETARY_AMT_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base CR Amount