BUSINESS_UNITREQ_IDSP_REQ_P_BAL_VW(SQL View) |
Index Back |
|---|---|
Requisition PreEncumbaranceRequisition PreEncumbarance Balance View |
| SELECT KKVW.BUSINESS_UNIT , KKVW.REQ_ID , SUM(KKVW.ENCUM_BALANCE) , KKVW.CURRENCY_CD , SUM(KKVW.FOREIGN_AMOUNT) , KKVW.FOREIGN_CURRENCY , KKVW.LEDGER_GROUP FROM PS_SPF_REQ_HDR REQHDR , PS_PV_REQ_LN_XREF XREF , PS_REQ_LN_DISTRIB DIS , PS_PO_KK_VW KKVW , PS_BUL_CNTL_BUD LED WHERE REQHDR.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND REQHDR.SP_REQ_ID = XREF.SP_REQ_ID AND DIS.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND DIS.REQ_ID = XREF.REQ_ID AND KKVW.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND KKVW.REQ_ID = XREF.REQ_ID AND KKVW.LINE_NBR = DIS.LINE_NBR AND KKVW.SCHED_NBR = DIS.SCHED_NBR AND KKVW.DISTRIB_LINE_NUM = DIS.DISTRIB_LINE_NUM AND LED.BUSINESS_UNIT = DIS.BUSINESS_UNIT_GL AND LED.KK_DETAIL_LED = 'Y' AND LED.KK_LEDGER_GROUP = KKVW.LEDGER_GROUP GROUP BY KKVW.BUSINESS_UNIT , KKVW.REQ_ID , KKVW.CURRENCY_CD , KKVW.FOREIGN_CURRENCY, KKVW.LEDGER_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | PRE_ENCUM_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pre-Encumbrance Balance |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 6 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 7 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |