BUSINESS_UNITREQ_IDLINE_NBRSCHED_NBRDISTRIB_LINE_NUMRQ_PENCM_DIS_VW(SQL View) |
Index Back |
|---|
| 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_PO_KK_VW KKVW , PS_REQ_LN_DISTRIB DIS , PS_REQ_HDR REQHDR , PS_BUL_CNTL_BUD LED WHERE KKVW.REQ_ID = REQHDR.REQ_ID AND KKVW.BUSINESS_UNIT = REQHDR.BUSINESS_UNIT AND REQHDR.BUSINESS_UNIT = DIS.BUSINESS_UNIT AND REQHDR.REQ_ID = DIS.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 DIS.DISTRIB_LN_STATUS <> 'X' 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 |