BILNIUPAY_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
4	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
5	LINE_DST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Revenue Sequence Number
6	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
7	BASE_CURRENCY_TO	Character(3)	VARCHAR2(3) NOT NULL	Base Currency To
8	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
9	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
12	AMOUNT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
13	DST_ID	Character(10)	VARCHAR2(10) NOT NULL	Distribution Code
14	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
15	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
16	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
17	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_SC_VW
18	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_SC_VW
19	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_SC_VW
20	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_SC_VW
21	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_SC_VW
22	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_SC_VW
23	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
24	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
25	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
26	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_SC_VW
27	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_SC_VW
28	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_SC_VW
29	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
30	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
31	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
32	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
33	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
34	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
35	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
36	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
37	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
38	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code