BI_BILL_SRCH_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
3	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
4	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
5	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
6	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
7	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
8	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
9	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
10	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
11	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
12	INVOICE_DT	Date(10)	DATE	Invoice Date
13	INVOICE_DT_C	Character(26)	VARCHAR2(26) NOT NULL	Invoice Date Character
14	TEMPLATE_IVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Invoice Flag I=Installment Bill N=No R=Recurring Bill
15	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
16	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. "
17	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
18	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
19	INVOICE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
20	INVOICE_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
21	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
22	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
23	CONSOL_KEY	Character(22)	VARCHAR2(22) NOT NULL	Invoice Consolidation Key
24	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
25	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
26	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID