JRNLGEN_UPDV (SQL Table)	Index Back
Journal Generator UF Mapping Journal Generator Update Field Mapping

JRNLGEN_UPDV

(SQL Table)

Journal Generator UF Mapping

Journal Generator Update Field 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: JGEN_UPDFLD_VW

5 JGEN_UPDATE_OPTION Character(1) VARCHAR2(1) NOT NULL Update Option
1=Current Date Time
2=Current User
Default Value: 2

6 FIELD_VALUE1 Character(50) VARCHAR2(50) NOT NULL Field Value

#	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: JGEN_UPDFLD_VW
5	JGEN_UPDATE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Update Option 1=Current Date Time 2=Current User Default Value: 2
6	FIELD_VALUE1	Character(50)	VARCHAR2(50) NOT NULL	Field Value