REPORT_TBL_TEO2

#	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_DETAIL_SEQ	Number(6,0)	INTEGER NOT NULL	Reporting Detail Line
7	RPTG_BALANCE_SEQ	Signed Number(19,0)	DECIMAL(18) NOT NULL	Reporting Balance Line
8	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
9	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
10	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
11	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
12	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
13	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
14	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
15	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.
16	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
17	DOC_TYPE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Document Type SetId
18	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
19	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
20	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
21	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
22	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
23	BUSINESS_UNIT_TXN	Character(5)	VARCHAR2(5) NOT NULL	Transaction Business Unit
24	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
25	JRNL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Journal Type
26	JRNL_CODE	Character(8)	VARCHAR2(8) NOT NULL	Journal Code
27	RPTG_REFERENCE	Character(50)	VARCHAR2(50) NOT NULL	Reporting Source Reference
28	RPTG_REFERENCE_DT	Date(10)	DATE	Reporting Src Date Reference
29	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
30	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
31	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
32	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
33	LINE_DST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Revenue Sequence Number
34	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
35	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
36	PRCS_INST_RVL	Number(10,0)	DECIMAL(10) NOT NULL	Revaluation Process Instance
37	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
38	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
39	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
40	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. "
41	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
42	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.
43	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
44	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
45	MONETARY_AMT_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base DR Amount
46	MONETARY_AMT_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base CR Amount
47	FOREIGN_AMT_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Debit Amount
48	FOREIGN_AMT_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Amount
49	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code