PO_KK_VW(SQL View) |
Index Back |
|---|
| SELECT KKHDR.BUSINESS_UNIT , KKHDR.KK_TRAN_ID , KKHDR.KK_TRAN_DT , KKHDR.REQ_ID , KKHDR.PO_ID , KKLN.LINE_NBR , KKLN.SCHED_NBR , KKLN.DISTRIB_LINE_NUM , KKLIQ.FOREIGN_AMOUNT , KKLIQ.FOREIGN_CURRENCY , KKLIQ.MONETARY_AMOUNT , KKLIQ.BASE_CURRENCY , KKLIQ.LEDGER_GROUP FROM PS_KK_SOURCE_HDR KKHDR , PS_KK_SOURCE_LN KKLN , PS_KK_LIQUIDATION KKLIQ WHERE KKHDR.KK_TRAN_ID = KKLN.KK_TRAN_ID AND KKHDR.KK_TRAN_DT = KKLN.KK_TRAN_DT AND KKLN.KK_TRAN_ID = KKLIQ.KK_TRAN_ID AND KKLN.KK_TRAN_DT = KKLIQ.KK_TRAN_DT AND KKLN.KK_TRAN_LN = KKLIQ.KK_TRAN_LN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | KK_TRAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 3 | KK_TRAN_DT | Date(10) | DATE | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 4 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 5 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 6 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 7 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 8 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 9 | ENCUM_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Encumbrance Balances |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | 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. |
| 12 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 13 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |