BI_HDR_FRM_VW2 (SQL View)	Index Back
Bill Header Form/Layout View

BI_HDR_FRM_VW2

(SQL View)

Bill Header Form/Layout View

SELECT hdr.business_unit , hdr.invoice , hdr.consol_hdr , hdr.consol_key , hdr.bi_currency_cd , HDR.BILL_TO_MEDIA , hdr.bill_status , hdr.bill_to_cust_id , hdr.SUMMARIZE_IVC_FLG , f.invoice_form_id , l.invoice_layout_id , l.page_orientation , hdr.ACCEPTGIRO_IND FROM PS_BI_HDR hdr , ps_bi_ivc_form f , ps_bi_ivc_layout l WHERE hdr.consol_hdr = 'Y' AND hdr.bill_status NOT IN ('INV', 'CAN', 'RDY', 'FNL' ) AND hdr.invoice_form_id = f.invoice_form_id AND f.invoice_layout_id = l.invoice_layout_id AND hdr.SUMMARIZE_IVC_FLG <> ' ' AND hdr.ACCEPTGIRO_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 CONSOL_HDR Character(1) VARCHAR2(1) NOT NULL Consolidated Hdr?
N=No
Y=Yes

4 CONSOL_KEY Character(22) VARCHAR2(22) NOT NULL Invoice Consolidation Key

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

6 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

7 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

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

9 SUMMARIZE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Summarize Invoice Flag

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

11 INVOICE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL Invoice Layout ID

12 PAGE_ORIENTATION Character(1) VARCHAR2(1) NOT NULL Layout Type
E=Crystal
L=SQR - Landscape
P=SQR - Portrait
X=XML Publisher

13 ACCEPTGIRO_IND Character(1) VARCHAR2(1) NOT NULL Field indicator that 'Invoice print will have Acceptgiro'. 'Y' indicates that Invoice has to be printed with Acceptgiro. 'N' indicates that Invoice has to be printed without Acceptgiro.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
4	CONSOL_KEY	Character(22)	VARCHAR2(22) NOT NULL	Invoice Consolidation Key
5	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
6	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
7	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
8	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
9	SUMMARIZE_IVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Summarize Invoice Flag
10	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form
11	INVOICE_LAYOUT_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Layout ID
12	PAGE_ORIENTATION	Character(1)	VARCHAR2(1) NOT NULL	Layout Type E=Crystal L=SQR - Landscape P=SQR - Portrait X=XML Publisher
13	ACCEPTGIRO_IND	Character(1)	VARCHAR2(1) NOT NULL	Field indicator that 'Invoice print will have Acceptgiro'. 'Y' indicates that Invoice has to be printed with Acceptgiro. 'N' indicates that Invoice has to be printed without Acceptgiro.