BI_HDR_NOADH_VW(SQL View) |
Index Back |
|---|---|
Bill Hdr w no hdr adjusts vw |
| SELECT business_unit , invoice , invoice_type , bill_type_id , bill_source_id , bill_to_cust_id , contract_num FROM ps_bi_hdr a ,ps_customer b WHERE a.bill_status = 'INV' AND a.adjusted_flag <> 'H' AND a.consol_hdr = 'N' AND a.bill_status <> 'TMP' AND a.bill_to_cust_id = b.cust_id AND b.cust_status = 'A' AND b.setid = ( SELECT c.setid FROM ps_set_cntrl_rec c WHERE c.recname = 'CUSTOMER' AND c.setcntrlvalue = a.business_unit) AND (a.bi_bu_tax_ind <> '2' OR (a.bi_bu_tax_ind = '2' AND NOT EXISTS( SELECT 'X' FROM ps_bi_hdr_gst gst , PS_BI_GST_EINV_LMT einv WHERE a.business_unit = gst.business_unit AND a.invoice = gst.invoice AND gst.einv_proc_flag NOT IN ('E', 'Y') AND einv.bi_check_einv_flag = 'Y'))) |
| # | 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 |
| 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_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE |
| 5 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC |
| 6 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 7 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |