RJENCUMB

Recurring Journal Encumbrance

This file contains the recurring journal transaction line detail information that links the recurring journal entry to the matching RJ GLCOMMITX records.
UPDATED BY
GL170 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJE-COMPANY
Element: Company		Numeric 4
The company number represents an established company and is maintained on GL10.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-JE-TYPE
Element: Je Type		Alpha 1
The type of journal entry. Valid values are Normal and Intercompany.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-REC-GROUP
Element: Rec Group		Numeric 8
The recurring journal entry number.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-FISCAL-YEAR
Element: Year		Numeric 4
This is the fiscal year for the record.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-PERIOD
Element: Period		Numeric 2
This is the period for the record.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-ACCT-UNIT
Element: Acct Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. The accounting unit entered in this field must be defined in the General Ledger Names file as a posting accounting unit.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-SUB-ACCOUNT
Element: Sub Acct		Numeric 4
This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-GLT-OBJ-ID
Element: Obj Id		Numeric 12
This field contains the object ID sequence number.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-ATN-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1


RJENCUMB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJESET1 GLT-OBJ-ID
KeyChange, Subset
Where(GLT-OBJ-ID !=Zeroes)
RJESET2 COMPANY
JE-TYPE
REC-GROUP
LINE-NBR
FISCAL-YEAR
PERIOD
GL170 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJESET3 ATN-OBJ-ID
KeyChange, Subset
Where(ATN-OBJ-ID !=Zeroes)


RJENCUMB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accommitx ACCOMMITX Required
RJE-ATN-OBJ-ID->MIX-ATN-OBJ-ID (MIXSET2)
Glcommitx GLCOMMITX Required
RJE-GLT-OBJ-ID->GOX-GLT-OBJ-ID
Rjcontrol RJCONTROL Required
RJE-COMPANY->RJC-COMPANY
RJE-JE-TYPE->RJC-JE-TYPE
RJE-REC-GROUP->RJC-REC-GROUP

File created: Thu Jun 09 02:14:23 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.