REPBALANCE_TEO1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RPTG_APPL_ID	Character(3)	VARCHAR2(3) NOT NULL	Reporting Application AP=Accounts Payable AR=Accounts Receivable BI=Billing EX=Expenses
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	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.
6	RPTG_BALANCE_SEQ	Signed Number(19,0)	DECIMAL(18) NOT NULL	Reporting Balance Line
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
10	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
11	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
12	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
13	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.
14	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
15	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. "
16	RPTG_BEGIN_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reporting Beginning Balance
17	MONETARY_AMT_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base DR Amount
18	MONETARY_AMT_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base CR Amount
19	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code