BI_HDR_NC_VW(SQL View) |
Index Back |
|---|---|
Non-Consol Bill Hdr vw |
| SELECT hdr.business_unit , hdr.invoice , hdr.invoice_type , hdr.bill_status , hdr.bill_to_cust_id , hdr.contract_num FROM PS_BI_HDR hdr WHERE hdr.consol_hdr <> 'Y' AND hdr.bill_status IN ('INV','FNL') AND hdr.process_instance = 0 AND hdr.preload_ind = '1' AND hdr.ar_entry_created = 'N' AND hdr.gl_entry_created = 'N' AND hdr.gen_ap_vchr_flg = 'N' AND hdr.invoice_type <> 'ACR' AND EXISTS ( SELECT 'X' FROM ps_bi_line ln WHERE ln.business_unit = hdr.business_unit AND ln.invoice = hdr.invoice AND ln.adj_line_type IN ('REG', 'ARB')) |
| # | 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 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT Prompt Table: BI_HDR_NOCON_VW |
| 3 | INVOICE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill Default Value: REG |
| 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_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |