PC_KK_LIQUID_VW (SQL View)	Index Back
Projects view of remaining bal This view groups by the KK transaction keys (KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN) without the LEDGER_GROUP. It selects the minimum remaining balance--representing the most liquidated document.

PC_KK_LIQUID_VW

(SQL View)

Projects view of remaining bal

This view groups by the KK transaction keys (KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN) without the LEDGER_GROUP. It selects the minimum remaining balance--representing the most liquidated document.

SELECT KK_TRAN_ID , KK_TRAN_DT , KK_TRAN_LN , FOREIGN_CURRENCY , MIN(FOREIGN_AMOUNT) , PC_DISTRIB_STATUS FROM PS_KK_LIQUIDATION GROUP BY KK_TRAN_ID , KK_TRAN_DT , KK_TRAN_LN , FOREIGN_CURRENCY , PC_DISTRIB_STATUS

# 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 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

5 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

6 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

#	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	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
5	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
6	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged