BI_HDR_IM_VW(SQL View) |
Index Back |
|---|---|
Invoice Maintenance Comp SrchThe component search record for Invoice Maintenance. |
| SELECT H.BUSINESS_UNIT , H.INVOICE , H.INVOICE_TYPE , H.BILL_TYPE_ID , H.BILL_STATUS , H.BILL_TO_CUST_ID FROM PS_BI_HDR H WHERE H.CONSOL_HDR <> 'Y' AND H.PROCESS_INSTANCE = 0 AND H.BILL_STATUS NOT IN ('INV', 'FNL', 'CAN', 'TMR', 'TMP') AND H.INVOICE_TYPE <> 'ACR' AND EXISTS ( SELECT 'X' FROM PS_BI_LINE L WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.INVOICE = H.INVOICE AND L.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
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 |
| 4 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 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 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |