JGEN_DOC_MAP

(SQL Table)
Index Back

Jrnl Generator Doc Mapping

Journal Generator Document Type Mapping

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

Prompt Table: DOC_TYPE_A_VW

5 DOC_TYPE_GL Character(8) VARCHAR2(8) NOT NULL GL Document Type

Prompt Table: DOC_TYPE_A_VW