KK_XCP_TR_E_VW2

(SQL View)
 Index Back

Budg Excptn for Trans Hdr Pnl

This view extracts the Commitment Contro Budget Exceptions for transactions for the Exception Status of Error. It it the view that is selected from on the scroll of the Transaction header Panel. This view differs from KK_XCP_TRAN_VW2 only in the selection of the Exception Type of errors.

SELECT DISTINCT A.KK_TRAN_ID , A.KK_TRAN_DT , A.KK_TRAN_LN , A.BUSINESS_UNIT , A.ACCOUNT , A.DEPTID , %subrec(CF9A_AK_SBR, A) , %subrec(cfcc1_ak_sbr,a) , A.STATISTICS_CODE , A.LEDGER_GROUP , A.EXCPTN_TYPE , A.KK_SOURCE_TRAN , A.MESSAGE_NBR , A.MESSAGE_PARM1 , A.MESSAGE_PARM2 , A.MESSAGE_PARM3 , A.MESSAGE_PARM4 FROM PS_KK_EXCPTN_TBL A WHERE A.EXCPTN_TYPE LIKE 'E%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
2 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
3 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

7 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

8 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_TBL

9 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_TBL

10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASS_CF_TBL

11 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_TBL

12 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_TBL

13 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

14 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

15 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

16 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CHARTFIELD1_TBL

17 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CHARTFIELD2_TBL

18 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CHARTFIELD3_TBL

19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: PC_BU_GL_VW

20 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: KK_PROJ_ID_VW

21 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_FVW2

22 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS

23 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

Prompt Table: KK_BP_ALL_VW

24 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
25 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
26 EXCPTN_TYPE Character(3) VARCHAR2(3) NOT NULL Exception Type
27 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
28 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
29 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
30 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
31 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
32 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4