BUSINESS_UNITREQ_IDLINE_NBRSCHED_NBRDISTRIB_LINE_NUMSP_REQ_P_DIS_VW(SQL View) |
Index Back |
|---|---|
Requisition Pre EncumbranceRequisition Pre Encumbrance Distribution View |
| SELECT DISTINCT KKVW.BUSINESS_UNIT , KKVW.REQ_ID , KKVW.LINE_NBR , KKVW.SCHED_NBR , KKVW.DISTRIB_LINE_NUM , KKVW.ENCUM_BALANCE , KKVW.CURRENCY_CD , KKVW.FOREIGN_AMOUNT , KKVW.FOREIGN_CURRENCY , KKVW.LEDGER_GROUP FROM PS_SPF_REQ_LINE REQLINE , PS_PV_REQ_LN_XREF XREF , PS_REQ_LN_DISTRIB DIS , PS_PO_KK_VW KKVW , PS_BUL_CNTL_BUD LED WHERE REQLINE.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND REQLINE.SP_REQ_ID = XREF.SP_REQ_ID AND REQLINE.LINE_NBR = XREF.SP_LINE_NBR AND DIS.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND DIS.REQ_ID = XREF.REQ_ID AND DIS.LINE_NBR = XREF.LINE_NBR AND KKVW.BUSINESS_UNIT = XREF.BUSINESS_UNIT 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 |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 5 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 6 | PRE_ENCUM_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pre-Encumbrance Balance |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | 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. |
| 9 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 10 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |