APWC_KKXCPTRAN2

(SQL View)
 Index Back

Budg Excptn for Trans Hdr Pnl

This view extracts the Commitment Control Budgets for Source transactions. The key order is setup to allow related display of the Budget Override data from KK_OVERRIDE_VW. All the budget fields are keys in order to distinquish the multiple budgets that the entire source transaction has exceptions on.

SELECT DISTINCT A.KK_TRAN_ID , A.KK_TRAN_DT , A.KK_TRAN_LN , A.LEDGER_GROUP , A.EXCPTN_TYPE , A.BUSINESS_UNIT , B.VOUCHER_ID , B.KK_PROCESS_STATUS , A.ACCOUNT , A.DEPTID , %subrec(CF9A_AK_SBR, A) , %subrec(cfcc1_ak_sbr,a) , A.STATISTICS_CODE , A.KK_SOURCE_TRAN FROM PS_KK_EXCPTN_TBL A , PS_KK_XCP_AP1N_VW1 B WHERE A.EXCPTN_TYPE LIKE 'E%' AND B.KK_TRAN_ID = A.KK_TRAN_ID AND B.KK_TRAN_DT = A.KK_TRAN_DT

# 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 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 EXCPTN_TYPE Character(3) VARCHAR2(3) NOT NULL Exception Type
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 KK_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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

Prompt Table: OPER_UNIT_TBL

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

Prompt Table: PRODUCT_TBL

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

Prompt Table: FUND_TBL

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

Prompt Table: CLASS_CF_TBL

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

Prompt Table: PROGRAM_TBL

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

Prompt Table: BUD_REF_TBL

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CHARTFIELD1_TBL

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

Prompt Table: CHARTFIELD2_TBL

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

Prompt Table: CHARTFIELD3_TBL

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

Prompt Table: PC_BU_GL_VW

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

Prompt Table: KK_PROJ_ID_VW

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

Prompt Table: PROJ_ACT_FVW2

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

Prompt Table: PROJ_RESTYPE_FS

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

Prompt Table: KK_BP_ALL_VW

28 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
29 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type