|
|
RJENCUMB FILE
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 Numeric 4 GL170 GL70.1
Element: Company The company number represents an GL70.2 GL70.3
established company and is maintained on GL70.5 GL70.6
GL10. GL75.1
RJE-JE-TYPE Alpha 1 GL170 GL70.1
Element: Je Type The type of journal entry. Valid values GL70.2 GL70.3
are Normal and Intercompany. GL70.5 GL70.6
GL75.1
RJE-REC-GROUP Numeric 8 GL170 GL70.1
Element: Rec Group The recurring journal entry number. GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-LINE-NBR Numeric 6 GL170 GL70.1
Element: Line Nbr This field contains the line number. GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-FISCAL-YEAR Numeric 4 GL170 GL70.1
Element: Year This is the fiscal year for the record. GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-PERIOD Numeric 2 GL170 GL70.1
Element: Period This is the period for the record. GL70.2 GL70.3
GL70.5 GL70.6
GL75.1
RJE-ACCT-UNIT Alpha 15 GL170 GL70.1
Element: Acct Unit The accounting unit is a shorthand GL70.2 GL70.3
notation representing the variable level GL70.5 GL70.6
number. The accounting unit entered in GL75.1
this field must be defined in the
General Ledger Names file as a posting
accounting unit.
RJE-ACCOUNT Numeric 6 GL170 GL70.1
Element: Account This field along with the accounting GL70.2 GL70.3
unit and subaccount make up the location GL70.5 GL70.6
(account) where amounts and other GL75.1
account information is stored.
RJE-SUB-ACCOUNT Numeric 4 GL170 GL70.1
Element: Sub Acct This field along with the accounting GL70.2 GL70.3
unit and account make up the location GL70.5 GL70.6
(account) where amounts and other GL75.1
account information is stored.
RJE-GLT-OBJ-ID Numeric 12 GL170 GL70.1
Element: Obj Id This field contains the object ID GL70.2 GL70.3
sequence number. GL70.5 GL70.6
GL75.1
RJE-ATN-OBJ-ID Numeric 12 GL170 GL70.1
Element: Obj Id This is the object identifier. It is GL70.2 GL70.3
used to relate commitments or posted GL70.5 GL70.6
transactions back to the originating GL75.1
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.
RJENCUMB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJESET1 GLT-OBJ-ID KeyChange, Subset
Where (GLT-OBJ-ID != Zeroes )
RJESET2 COMPANY GL170 GL70.1
JE-TYPE GL70.2 GL70.3
REC-GROUP GL70.5 GL70.6
LINE-NBR GL75.1
FISCAL-YEAR
PERIOD
RJESET3 ATN-OBJ-ID KeyChange, Subset
Where (ATN-OBJ-ID != Zeroes )
RJENCUMB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
