BUSINESS_UNITEMPLIDEXT_ORG_IDBILL_HEADER_VW4(SQL View) |
Index Back |
|---|
| select a.business_unit ,a.emplid ,a.ext_org_id ,a.invoice_dt ,a.due_dt ,'Invoice Generated' ,sum(a.total_bill) ,0 from PS_BI_BILL_HEADER a, ps_bi_std_req_tbl b where a.sf_bill_status <> 'C' and b.bill_req_id = a.bill_req_id and b.setid = (select c.setid from ps_set_cntrl_rec c where c.recname = 'BI_STD_REQ_TBL' and c.setcntrlvalue = a.business_unit) and b.invoice_flag = 'I' group by a.business_unit ,a.emplid ,a.ext_org_id ,a.invoice_dt ,a.due_dt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | ACTUAL_BILLING_DT | Date(10) | DATE | Actual Billing Date |
| 5 | DUE_DT | Date(10) | DATE | Due Date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 8 | AMOUNT_TOTAL | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Amount Total |