CM_KK_HDR2VW(SQL View) |
Index Back |
|---|---|
Header View of Commitment CtrlThis view is used by the Upgrade Budget Processor. |
| SELECT BUSINESS_UNIT , INV_ITEM_ID , DT_TIMESTAMP , SEQ_NBR , MIN(TRANSACTION_GROUP) , MIN(ACCOUNTING_DT) , MIN(COST_ELEMENT) , BUDGET_HDR_STATUS , BUDGET_DT , KK_AMOUNT_TYPE , KK_TRAN_OVER_DTTM , KK_TRAN_OVER_FLAG , KK_TRAN_OVER_OPRID FROM PS_CM_ACCTG_LINE WHERE 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 BUSINESS_UNIT , INV_ITEM_ID , DT_TIMESTAMP , SEQ_NBR , BUDGET_HDR_STATUS , BUDGET_DT , KK_AMOUNT_TYPE , KK_TRAN_OVER_DTTM , KK_TRAN_OVER_FLAG , 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 | Date Timestamp |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 6 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 8 | 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 |
| 9 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 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 |