JRNLGEN_TGRP (SQL Table)	Index Back
JGen Trans Group Field Journal Generator Transaction Group Fields

JRNLGEN_TGRP

(SQL Table)

JGen Trans Group Field

Journal Generator Transaction Group Fields

# 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_TGRPFLD_VW

5 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_TGRPFLD_VW
5	FIELD_VALUE1	Character(50)	VARCHAR2(50) NOT NULL	Field Value