BI_HDR_FRM_VW(SQL View) |
Index Back |
|---|---|
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 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 <> ' ' |
| # | 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 |