BI_INVOICE2_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	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	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
5	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
6	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
7	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
8	INVOICE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Invoice Date Option P=Processing Date U=User Defined
9	INVOICE_DT	Date(10)	DATE	Invoice Date
10	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
11	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
12	NET_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
13	NET_AMOUNT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Amount Euro
14	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
15	CR_CARD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Credit Card Flag
16	EDI_OPTION	Character(1)	VARCHAR2(1) NOT NULL	EDI Invoice Options 1=EDI Only 2=EDI and Print 3=Print Only
17	FAX_OPTION	Character(1)	VARCHAR2(1) NOT NULL	FAX Invoice Option 1=FAX only 2=FAX & Print copy 3=Print only
18	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
19	PRT_INVOICE_SORT	Character(1)	VARCHAR2(1) NOT NULL	Print Invoice Sort By B=Bus Unit, Invoice C=Customer, Invoice P=Country, Postal
20	PRT_ONLY_PRIMARY	Character(1)	VARCHAR2(1) NOT NULL	Print Only Primary Copy
21	CUSTOM_LABEL	Character(20)	VARCHAR2(20) NOT NULL	Custom Label
22	INVOICE_LAYOUT_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Layout ID
23	USE_CURRENT_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Use Current Effective Address