BILL_HEADER_VW3(SQL View) |
Index Back |
|---|---|
Billing Invoice Header View |
| SELECT A.BUSINESS_UNIT , A.EXT_ORG_ID , A.INVOICE_ID , A.BILL_TYPE_ID , A.PRIOR_INVOICE_ID , A.INVOICE_TYPE , A.OPRID , A.SF_BILL_STATUS FROM PS_BI_BILL_HEADER A where TYPE_OF_REQUEST = 'C' |
| # | 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_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 3 | INVOICE_ID |
Character(22) | VARCHAR2(22) NOT NULL | Invoice Number |
| 4 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type ID
PP=Payment Plan PRE=Pre-Payment STU=Student TP=Third Party |
| 5 | PRIOR_INVOICE_ID | Character(22) | VARCHAR2(22) NOT NULL | Prior Invoice ID |
| 6 | INVOICE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Invoice ADJ=Adjustment Only Bill ARB=Rebill Bill RAD=Regular bill with adjustments REG=Regular Bill Default Value: REG |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID Prompt Table: OPR_DEF_TBL_CS |
| 8 | SF_BILL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Status
C=Cancelled I=Initiated |