BI_HDR_EMPLI_VW(SQL View) |
Index Back |
|---|---|
Billing Invoice Hdr Start View |
| select business_unit ,emplid ,invoice_id ,bill_type_id ,prior_invoice_id ,invoice_type ,due_dt ,oprid ,total_bill ,sf_bill_status ,invoice_dt from PS_BI_BILL_HEADER where type_of_request ='E' |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | INVOICE_START |
Character(22) | VARCHAR2(22) NOT NULL | Invoice Start Nbr |
| 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 | DUE_DT | Date(10) | DATE NOT NULL |
Due Date
Default Value: %date |
| 8 | 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 |
| 9 | TOTAL_BILL | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Billed |
| 10 | SF_BILL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Status
C=Cancelled I=Initiated |
| 11 | INVOICE_DT | Date(10) | DATE | Invoice Date |