AR_BI_HDR_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_BI_NONVW
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice Default Value: NEXT Prompt Table: BI_HDR
3	INVOICE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Invoice Type ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill Default Value: REG
4	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier Prompt Table: BI_TYPE
5	BILL_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Bill Status CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill Default Value: NEW
6	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source Prompt Table: BI_SRC
7	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
9	BILL_TO_COPIES	Number(3,0)	SMALLINT NOT NULL	Number of Copies
10	BILL_TO_MEDIA	Character(1)	VARCHAR2(1) NOT NULL	Bill To Media A=Email Invoice as Attachment E=EDI H=Federal Highway File N=Email Notification P=Print Copy X=Electronic Invoice File
11	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
12	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
13	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.
14	INVOICE_DT	Date(10)	DATE	Invoice Date
15	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
16	INVOICE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
17	INVOICE_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
18	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
19	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. "
20	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
21	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
22	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
23	RATE_MULT_XEU	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
24	RATE_DIV_XEU	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
25	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_BU_SP_NONVW Set Control Field: CONTRACT_NUM
26	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
27	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
28	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
29	SOLD_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Sold To Address Sequence Num
30	TOT_SU_TAX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Sales/Use Tax
31	TOT_SU_TAX_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Sales/Use Tax
32	TOT_SU_TAX_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Sales/Use Tax
33	TOT_VAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
34	TOT_VAT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
35	TOT_VAT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
36	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
37	DT_INVOICED	Date(10)	DATE	Date Invoiced
38	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
39	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
40	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
41	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
42	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num