CM_KK_HDR_VW

(SQL View)
Index Back

Header View of Commitment Ctrl

5/20/99 ej CN#CM800-1.0: Used to group CM_ACCTG_LINE by transaction set for Budget Processor. Also added a total amount by transaction set. 6/11/2010 CB 1945775000 Removed fields ACCOUNTING_DT and BUDGET_DT

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.SEQ_NBR , A.CM_BOOK , MIN(A.COST_ELEMENT) , A.TRANSACTION_GROUP , A.DISTRIB_TYPE , A.BUDGET_HDR_STATUS , A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_DTTM , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID FROM PS_CM_ACCTG_LINE A ,PS_CM_KK_LINE0TMP B WHERE A.GL_DISTRIB_STATUS IN ('N','H') AND A.CM_IU_INDICATOR = 'N' AND A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.TRANSACTION_GROUP = B.TRANSACTION_GROUP AND A.ACCOUNTING_DT = B.ACCOUNTING_DT AND A.ACCTG_LINE_NO = B.ACCTG_LINE_NO AND A.TRANSACTION_GROUP IN ( SELECT TRANSACTION_GROUP FROM PS_CM_ACCTG_GRP_D WHERE PS_CM_ACCTG_GRP_D.CM_SOURCE_RECORD = 'TRANSACTION_INV') GROUP BY A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.SEQ_NBR , A.CM_BOOK , A.TRANSACTION_GROUP , A.DISTRIB_TYPE , A.BUDGET_HDR_STATUS ,A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_DTTM , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
7 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
8 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

9 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
10 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
11 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
12 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
13 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator