AR_BI_HDR2_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	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist
8	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
10	BILL_TO_COPIES	Number(3,0)	SMALLINT NOT NULL	Number of Copies
11	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
12	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
13	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
14	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.
15	INVOICE_DT	Date(10)	DATE	Invoice Date
16	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
17	INVOICE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
18	INVOICE_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
19	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
20	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. "
21	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
22	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
23	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
24	RATE_MULT_XEU	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
25	RATE_DIV_XEU	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
26	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
27	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
28	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
29	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
30	SOLD_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Sold To Address Sequence Num
31	TOT_SU_TAX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Sales/Use Tax
32	TOT_SU_TAX_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Sales/Use Tax
33	TOT_SU_TAX_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Sales/Use Tax
34	TOT_VAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
35	TOT_VAT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
36	TOT_VAT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
37	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
38	DT_INVOICED	Date(10)	DATE	Date Invoiced
39	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
40	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
41	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
42	CONTRACT_DT	Date(10)	DATE	Contract Date
43	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type
44	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
45	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
46	REIMB_AGREEMENT	Character(25)	VARCHAR2(25) NOT NULL	Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records
47	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
48	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
49	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
50	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
51	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
52	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
53	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
54	ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Activity Type A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason
55	START_DT	Date(10)	DATE	Start Date
56	END_DT	Date(10)	DATE	End Date
57	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num