BUSINESS_UNITPO_IDLINE_NBRSCHED_NBRDISTRIB_LINE_NUMPO_ENCUM_DIS_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT KKVW.BUSINESS_UNIT , KKVW.PO_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 , DIS.BUSINESS_UNIT_GL FROM PS_PO_KK_VW KKVW , PS_PO_LINE_DISTRIB DIS , PS_BUL_CNTL_BUD LED WHERE KKVW.BUSINESS_UNIT = DIS.BUSINESS_UNIT AND KKVW.PO_ID = DIS.PO_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 NOT IN ('X', 'C') AND LED.BUSINESS_UNIT = DIS.BUSINESS_UNIT_GL AND LED.KK_LEDGER_GROUP = KKVW.LEDGER_GROUP AND LED.KK_DETAIL_LED = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 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 | ENCUM_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Encumbrance Balances |
| 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 |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |