OPRIDGM_PT_PYM_VW(SQL View) |
Index Back |
|---|
| SELECT C.OPRID , B.BUSINESS_UNIT , A.CONTRACT_NUM , A.PAYMENT_ID , A.ITEM , A.BUDGET_PERIOD_GM , A.ACCOUNTING_DT , SUM(A.RECEIVED_AMT) , A.CURRENCY_CD FROM PS_GM_PT_AWD_TRN A , PS_GM_PT_ACC_LVL2 B , PSOPRDEFN C ,PS_GM_PT_PCBU_VW D WHERE A.AMOUNT_TYPE = 'PAY' AND B.CONTRACT_NUM = A.CONTRACT_NUM AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.CONTRACT_NUM = D.CONTRACT_NUM AND A.BUSINESS_UNIT = D.BUSINESS_UNIT_PC AND (B.END_DT >= %CurrentDateIn OR B.END_DT IS NULL) AND C.EMPLID = B.EMPLID GROUP BY C.OPRID, B.BUSINESS_UNIT , A.CONTRACT_NUM , A.PAYMENT_ID, A.ITEM , A.BUDGET_PERIOD_GM, A.ACCOUNTING_DT , A.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 4 | PAYMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 5 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 6 | BUDGET_PERIOD_GM | Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 7 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 8 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |