BI_BILL_STR_OVW(SQL View) |
Index Back |
|---|---|
Billing Invoice Hdr Start View |
| SELECT business_unit ,invoice_id ,ext_org_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 ='C' AND sf_bill_status = 'I' |
| # | 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 | INVOICE_START |
Character(22) | VARCHAR2(22) NOT NULL | Invoice Start Nbr |
| 3 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 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 |