BI_HDR_C_SS_VW (SQL View)	Index Back
Bill Hdr - Self-Service View

BI_HDR_C_SS_VW

(SQL View)

Bill Hdr - Self-Service View

SELECT BUSINESS_UNIT , INVOICE , BILL_TO_CUST_ID , INVOICE_DT , DUE_DT , BI_CURRENCY_CD , INVOICE_AMOUNT , BILL_INQUIRY_PHONE , ADDRESS_SEQ_NUM , INVOICE_FORM_ID FROM PS_BI_HDR WHERE BILL_STATUS = 'INV' AND CONSOL_HDR = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONSOL_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Specifies the Billing business unit associated with a consolidated bill.

2 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.

3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

4 INVOICE_DT Date(10) DATE Invoice Date

5 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.

6 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

7 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

8 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone

9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

10 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
2	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
3	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
4	INVOICE_DT	Date(10)	DATE	Invoice Date
5	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.
6	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
7	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
8	BILL_INQUIRY_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Bill Inquiry Phone
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
10	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form