BI_HDR_CAN_VW(SQL View) |
Index Back |
|---|---|
Cancel Bills View |
| SELECT DISTINCT H.business_unit ,H.invoice ,H.bill_status ,H.bill_to_cust_id ,H.contract_num ,H.project_id ,H.invoice_amount ,H.bi_currency_cd ,H.add_dttm ,H.invoice_type ,H.template_ivc_flg FROM PS_BI_HDR H , PS_BI_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.INVOICE = L.INVOICE AND H.BILL_STATUS = 'CAN' AND L.SYSTEM_SOURCE NOT IN ('PBI', 'CBI') |
| # | 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 |
| 3 | 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 |
| 4 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 5 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 7 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 8 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 9 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 10 | 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 |
| 11 | TEMPLATE_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Template Invoice Flag
I=Installment Bill N=No R=Recurring Bill |