BI_REQUEST_VW(SQL View) |
Index Back |
|---|---|
Billing Request View |
| SELECT a.business_unit ,a.bi_req_nbr ,a.bill_one_emplid ,a.bill_req_id ,a.bi_req_dt_tm ,a.invoice_start ,a.invoice_end ,a.invoice_dt FROM PS_BI_REQUEST a WHERE a.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 | BI_REQ_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Billing Request Nbr |
| 3 | BILL_ONE_EMPLID |
Character(1) | VARCHAR2(1) NOT NULL |
Bill By Option
A=Bill All Not Yet Billed C=Bill Per Contract(s) E=Bill One Ext Org ID N=Bill Range Y=Bill One ID Prompt Table: BILL_BY_XL_VW |
| 4 | BILL_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Request ID
Prompt Table: BI_STD_REQ_TBL |
| 5 | BI_REQ_DT_TM | DateTime(26) | TIMESTAMP | Billing Request Dt/Time |
| 6 | INVOICE_START | Character(22) | VARCHAR2(22) NOT NULL | Invoice Start Nbr |
| 7 | INVOICE_END | Character(22) | VARCHAR2(22) NOT NULL | Invoice Nbr End |
| 8 | INVOICE_DT | Date(10) | DATE | Invoice Date |