CA_JRNLGEN_DEFN (SQL View)	Index Back
CA Journal Generator Defn View This view is used in INSTALLATION_CA to prompt for Journal Generator Accounting Definition

CA_JRNLGEN_DEFN

(SQL View)

CA Journal Generator Defn View

This view is used in INSTALLATION_CA to prompt for Journal Generator Accounting Definition

SELECT setid , acctg_def_name , descr , system_source FROM PS_JRNLGEN_DEFN

Related Language Record: CA_JGEN_DEFN_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACCT_DEF_SETID Character(5) VARCHAR2(5) NOT NULL Acctg Definition SetID

2 ACCTG_DEF_NAME Character(10) VARCHAR2(10) NOT NULL Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCT_DEF_SETID	Character(5)	VARCHAR2(5) NOT NULL	Acctg Definition SetID
2	ACCTG_DEF_NAME	Character(10)	VARCHAR2(10) NOT NULL	Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.