PE_KK_ACTLOG_VW (SQL View)	Index Back
KK budget activity record

PE_KK_ACTLOG_VW

(SQL View)

KK budget activity record

SELECT A.KK_TRAN_ID , A.KK_TRAN_DT , A.KK_TRAN_LN , A.REFERENCED_BUDGET , A.BALANCING_LINE , A.LEDGER_GROUP , A.LEDGER , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.SEQNBR , A.RVRSL_FLG , A.CLOSED_VALUE , A.BASE_CURRENCY , A.MONETARY_AMOUNT FROM PS_KK_ACTIVITY_LOG A , PS_BU_LED_GRP_TBL B , PS_BUL_CNTL_BUD C WHERE A.BALANCING_LINE = 'N' AND A.REFERENCED_BUDGET = 'N' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.LEDGER_GROUP = B.LEDGER_GROUP AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.LEDGER_GROUP = C.KK_LEDGER_GROUP AND C.KK_DETAIL_LED = 'Y' AND A.MONETARY_AMOUNT <> 0

# 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 NOT NULL 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 REFERENCED_BUDGET Character(1) VARCHAR2(1) NOT NULL Referenced Budget
Y/N Table Edit
Default Value: N

5 BALANCING_LINE Character(1) VARCHAR2(1) NOT NULL Balancing Line
Y/N Table Edit
Default Value: N

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

7 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

9 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

10 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

11 RVRSL_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Control Reversal Flag

12 CLOSED_VALUE Character(1) VARCHAR2(1) NOT NULL Closed Status field value
Y/N Table Edit

13 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

14 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

#	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 NOT NULL	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	REFERENCED_BUDGET	Character(1)	VARCHAR2(1) NOT NULL	Referenced Budget Y/N Table Edit Default Value: N
5	BALANCING_LINE	Character(1)	VARCHAR2(1) NOT NULL	Balancing Line Y/N Table Edit Default Value: N
6	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
9	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
10	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
11	RVRSL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Reversal Flag
12	CLOSED_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Closed Status field value Y/N Table Edit
13	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
14	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.