BI_CONS_HDR_VW(SQL View) |
Index Back |
|---|---|
Consolidated Invoices |
| select a.business_unit, a.bill_to_cust_id, a.invoice, a.consol_key, a.bill_status, a.invoice_form_id, b.invoice_layout_id, c.page_orientation, a.bill_to_media from PS_BI_HDR a, ps_bi_ivc_form b, ps_bi_ivc_layout c where consol_hdr = 'Y' and a.invoice_form_id = b.invoice_form_id and b.invoice_layout_id = c.invoice_layout_id |
| # | 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 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 3 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT |
| 4 | CONSOL_KEY | Character(22) | VARCHAR2(22) NOT NULL | Invoice Consolidation Key |
| 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 |
| 6 | INVOICE_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL | Invoice Form |
| 7 | INVOICE_LAYOUT_ID | Character(10) | VARCHAR2(10) NOT NULL | Invoice Layout ID |
| 8 | PAGE_ORIENTATION | Character(1) | VARCHAR2(1) NOT NULL |
Layout Type
E=Crystal L=SQR - Landscape P=SQR - Portrait X=XML Publisher |
| 9 | 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 |