KK_SRC_TRAN_VW

(SQL View)
 Index Back

Tran Type by Budg Prompt VW

Prompt table for Source transaction type given the Commitment control Budget fields. Used on the Budget Exception Panel.

SELECT DISTINCT A.BUSINESS_UNIT ,A.LEDGER_GROUP ,A.ACCOUNT , A.DEPTID , %subrec(CF9A_AK_SBR, A) ,%subrec(cfcc1_ak_sbr,a) ,A.STATISTICS_CODE ,B.DESCR ,A.KK_SOURCE_TRAN FROM PS_KK_EXCPTN_TBL A ,PS_KK_SOURCE_TRAN B WHERE A.KK_SOURCE_TRAN = B.KK_SOURCE_TRAN AND A.EXCPTN_TYPE LIKE 'W%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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

Prompt Table: OPER_UNIT_TBL

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

Prompt Table: PRODUCT_TBL

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

Prompt Table: FUND_TBL

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

Prompt Table: CLASS_CF_TBL

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

Prompt Table: PROGRAM_TBL

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

Prompt Table: BUD_REF_TBL

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CHARTFIELD1_TBL

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

Prompt Table: CHARTFIELD2_TBL

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

Prompt Table: CHARTFIELD3_TBL

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

Prompt Table: PC_BU_GL_VW

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

Prompt Table: KK_PROJ_ID_VW

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

Prompt Table: PROJ_ACT_FVW2

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

Prompt Table: PROJ_RESTYPE_FS

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

Prompt Table: KK_BP_ALL_VW

22 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
24 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type