BI_SAL_DTL_VW(SQL View) |
Index Back |
|---|---|
Grants Salary Detail |
| SELECT D.BUSINESS_UNIT ,D.INVOICE ,D.CONTRACT_NUM ,D.INVOICE_DT ,B.ACCOUNT ,C.EMPLID ,SUM(C.NET_EXTENDED_AMT + C.TAX_AMT + C.VAT_AMT) ,D.BILL_STATUS FROM PS_PROJ_RESOURCE B ,PS_BI_LINE C ,PS_BI_HDR D WHERE D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.INVOICE = C.INVOICE AND C.BUSINESS_UNIT_PC = B.BUSINESS_UNIT AND C.PROJECT_ID = B.PROJECT_ID AND C.ACTIVITY_ID = B.ACTIVITY_ID AND C.RESOURCE_ID = B.RESOURCE_ID AND C.EMPLID <> ' ' GROUP BY D.BUSINESS_UNIT, D.INVOICE, D.CONTRACT_NUM, D.INVOICE_DT, B.ACCOUNT, C.EMPLID, D.BILL_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 4 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 5 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 8 | BILL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill |