JRNLGEN_DEFNV (SQL Table)	Index Back
Journal Generator CF Mapping

JRNLGEN_DEFNV

(SQL Table)

Journal Generator CF Mapping

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL 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 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number
Default Value: 1

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: RECFLD_LBLGL_VW

5 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
Prompt Table: CFS_NO_BU_VW

6 CF_SUMMARIZE_OPT Character(1) VARCHAR2(1) NOT NULL Summarize ChartField
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	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	FIELD_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	Field Sequence Number Default Value: 1
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: RECFLD_LBLGL_VW
5	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField Prompt Table: CFS_NO_BU_VW
6	CF_SUMMARIZE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Summarize ChartField Y/N Table Edit Default Value: Y