BI_INST_INFO_VW(SQL View) |
Index Back |
|---|---|
Bill Hdr w INV bill status vw |
| SELECT A.BUSINESS_UNIT , A.INVOICE , A.GENERATED_INVOICE , B.BILL_STATUS , B.DT_INVOICED FROM PS_BI_INSTALL_SCHE A , PS_BI_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.GENERATED_INVOICE = B.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
Default Value: NEXT Prompt Table: BI_HDR_IVC_VW |
| 3 | GENERATED_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Generated Invoice
Default Value: NEXT |
| 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 Default Value: NEW |
| 5 | DT_INVOICED | Date(10) | DATE | Date Invoiced |