BI_HDR_TMP_VW(SQL View) |
Index Back |
|---|---|
Temp Bills View |
| SELECT business_unit ,invoice ,bill_status ,bill_to_cust_id ,contract_num ,project_id ,invoice_amount ,bi_currency_cd ,add_dttm FROM PS_BI_HDR WHERE (bill_status = 'TMP' OR bill_status = 'TMR') AND pc_distrib_status = 'I' AND NOT EXISTS ( SELECT 'X' FROM PS_BI_WRKSHT_STG WHERE PS_BI_HDR.BUSINESS_UNIT = PS_BI_WRKSHT_STG.BUSINESS_UNIT AND PS_BI_HDR.INVOICE = PS_BI_WRKSHT_STG.INVOICE) |
| # | 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 |