KK_XCP_LDGR_VW1 (SQL View)	Index Back
Budget LedGrp by BU Prompt Prompts for valid Budget Ledger Groups given the Tran Id, Tran Dt and Budget Business Unit. Used in the Transaction Header Exception Panel.

KK_XCP_LDGR_VW1

(SQL View)

Budget LedGrp by BU Prompt

Prompts for valid Budget Ledger Groups given the Tran Id, Tran Dt and Budget Business Unit. Used in the Transaction Header Exception Panel.

SELECT DISTINCT KK_TRAN_ID ,KK_TRAN_DT , BUSINESS_UNIT ,LEDGER_GROUP FROM PS_KK_EXCPTN_TBL

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group