GLCONTROL

General Ledger Control

This file contains journal entry control information. This information is used to process the journal entry detail records.

REFERENCED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 CA00.1 CA00.2
CA05.1 CA05.2 CA10.1 CA10.2 CA10.4 CA10.6
CA10.7 CA15.1 CA15.2 CA160 CA190 FB11.1
FB111 FB160 FB211 FB296 FB60.1 FB95.1
FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 GL122
GL240 GL241 GL245 GL247 GL256 GL270
GL284 GL285 GL286 GL287 GL288 GL289
GL290 GL297 GL298 GL299 GL70.1 GL70.2
GL70.3 GL70.6 GL90.1 GL90.2 GL90.5 GL90.6
GL94.1 GL94.2 GL94.3 GL94.4 GL94.5 GL94.6
GL94.7 GL95.1 GL95.2 GL95.3 GL95.4 GL95.5
GL95.6 GL95.7 GL95.8 GL95.9 GL96.1 GL96.2
GL96.3 GL96.4 GL96.5 GL97.1 GL97.2 GL97.3
GL97.4 GL97.5 GL97.6 GL97.7 GL97.8 GL97.9
GL98.1 GL98.2 GL98.3 GL98.4 GL98.5 GL99.1
GL99.2 GL99.3 GL99.4 GL99.5 GL99.6 GLBO.2
GLCC.1 JB240 CU01.1 CU01.2 CU02.1 CU02.2
CU03.1 CU10.1 CU10.2 CU20.1 CU20.3 GL00.1
GL00.2 GL00.3 GL00.6 GL00.7 GL00.8 GL00.9
GL02.1 GL02.2 GL02.3 GL02.6 GL03.2 GL03.4
GL10.1 GL121 GL20.1 GL20.2 GL20.4 IFJR.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 MA61.1 MA70.1 MA75.1 MAI1.1
ML170 ML290 ML90.5 GL12.1 GL12.2


UPDATED BY
GL110 GL145 GL146 GL148 GL167 GL170
GL190 GL191 GL196 GL197 GL199 GL300
GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8
GL41.4 GL44.1 GL45.1 GL500 GL75.1 IFGT.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLC-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
GL110 GL148
GL167 GL191
GL196 GL197
GL199 GL40.2
GL40.6 GL41.4
GL45.1 GL500
GLCC.1 IFGT.1
GLC-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
Contains the fiscal year for the data stored on this record.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-ACCT-PERIOD
Element: Account Period		Numeric 2
The accounting period assigned to the journal entry.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-SYSTEM
Element: System		Alpha 2
This is the journal entry system code.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-JE-TYPE
Element: Journal Entry Type		Alpha 1
Displays the type of journal entry created.
N = Normal
I = Intercompany
A = Auto Rev Normal
R = Auto Rev Intco
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-JE-TYPE-1
Element: Journal Entry Type		Derived
Displays the derived journal entry type.
GLC-CONTROL-GROUP
Element: Control Group		Numeric 8
This field displays the journal entry number used for process control of the journal entry detail.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL41.4 GL45.1
GL500 GLCC.1
IFGT.1
GLC-JE-SEQUENCE
Journal Entry
Sequence		Numeric 2
The unique journal entry sequence number.
GL146 GL148
GL167 GL190
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GLCC.1 IFGT.1
GLC-STATUS
Element: Status		Numeric 1
This field contains the processing cycle status of the assigned journal entry.
0 = Unreleased
1 = Released
2 = Post In Progress
3 = Load In Process
4 = Quick Posted
5 = Posted
6 = Unreleased no AC update
9 = History
GL146 GL148
GL167 GL190
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-STATUS-1
Element: Status		Derived
This field displays the journal entry status.
GLC-CNTRL-AMOUNT
Element: Control Amount		Signed 18.2
Displays the total journal entry amount.
GL146 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLC-ENTRY-DB
Element: Entry Debit		Signed 18.2
GL146 GL167
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-ENTRY-CR
Element: Entry Credit		Signed 18.2
GL146 GL167
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-TRAN-ND
Trans Number of
Decimals		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.5
GL41.3 GL45.1
GL500 IFGT.1
GLC-UNIT-CNTRL-DB
Element: Auto Debits		Signed 15.2
The total positive detail auto reversing amounts.
GL190 GL500
GLC-UNIT-CNTRL-CR
Element: Auto Credits		Signed 15.2
The journal entry total for negative detail unit balances.
GL190 GL500
GLC-UNIT-ENTRY-DB
Element: Auto Debits		Signed 15.2
The total positive detail auto reversing amounts.
GL146 GL167
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-UNIT-ENTRY-CR
Element: Auto Credits		Signed 15.2
The total negative detail auto reversing amounts.
GL146 GL167
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-AUTO-UNIT-DB
Element: Auto Debits		Signed 15.2
The total positive detail auto reversing amounts.
GL146 GL190
GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-AUTO-UNIT-CR
Element: Auto Credits		Signed 15.2
The total negative detail auto reversing amounts.
GL146 GL190
GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLC-LINE-NBR
Element: Line Number		Numeric 6
This field contains the line number.
GL146 GL148
GL167 GL190
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-NBR-LINES
Element: Number of Lines		Numeric 6
This is the number of detail lines.
GL146 GL148
GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login ID of the person who entered the record.
GL146 GL148
GL167 GL190
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-REL-OPERATOR
Element: Release Operator		Alpha 10
The operator ID assigned to the released journal entry.
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-RELEASED-FLAG
Element: Released Flag		Alpha 1
This flag is set to Yes when a Journal Entry is Released. If the Journal Entry is Unreleased this flag will not be reset, instead it is an indicator that the Journal Entry had been released at one time.
Y = Yes
N = No
S = System Generated
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-HOLD-CODE
Element: Hold Code		Alpha 4
The journal hold code.
GL145 GL146
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-PER-DATE-FLAG
Element: Period Date Flag		Alpha 1
Indicates the period or date derived.
P = Period Derived
D = Date Derived
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLC-POSTING-DATE
Element: Posting Date		Numeric 8 (yyyymmdd)
The date assigned to the journal entry for posting.
GL146 GL148
GL167 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-LAST-CMT-SEQ
Last Comment
Sequence Number		Numeric 4
The sequence number of the last comment for the journal entry.
GL190 GL199
GL500
GLC-LAST-LOG-SEQ
Last Logfile
Sequence Number		Numeric 6
The last sequence control number.
GL146 GL148
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-ZONE
Element: Base Zone		Alpha 15
The base zone as assigned for interzone balance processing.
GL146 GL148
GL167 GL190
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-DEBITS
Element: Base Debits		Signed 18.2
GL146 GL148
GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-BASE-CREDITS
Element: Base Credits		Signed 18.2
GL146 GL167
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-AUTO-DB
Element: Base Auto Debits		Signed 18.2
The total positive detail auto reversing amount in the company base currency.
GL146 GL190
GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-AUTO-CR
Element: Base Auto Credits		Signed 18.2
GL146 GL190
GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-BASE-ND
Base Number of
Decimals		Numeric 1
The number of decimal positions defined for the company base currency.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLC-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ) unless an alternate currency code is chosen on the GL40.2.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL45.1
GL500 IFGT.1
GLC-BASERATE
Element: Base Rate		Signed 14.7
The exchange rate at the time the journal entry was made. If left blank, the current exchange rate defaults.
GL148 GL167
GL191 GL196
GL197 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLC-NET-BASE-AMT
Element: Net Base Amount		Derived
The net amount in the base currency.
GLC-NET-BASE-AREV
Element: Net Base Reversed		Derived
The net reversed in the base currency.
GLC-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
The company name or description.
GL146 GL148
GL167 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-AUTO-REV
Element: Auto Reverse		Alpha 1
Auto reversal is the process of reversing the transaction. If you select auto reverse, the Lawson General Ledger closing program creates a reversing journal entry in the next period for this transaction.
Y = Yes
N = No
" " = No
GL146 GL148
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-SOURCE-CODE
Element: Source Code		Alpha 2
A two-character code assigned to a transaction to identify where the transaction was created.
GL146 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLC-REFERENCE
Element: Reference		Alpha 10 (Lower Case)
The reference you enter for this journal entry appears on inquiries and reports.
GL146 GL148
GL167 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLC-DOCUMENT-NBR
Element: Document Number		Alpha 27
The document number assigned to the journal entry. This is used in conjunction with the Journal by Document option in GL10 (Company).
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-EFFECT-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
The effective date.
GL148 GL197
GL199 GL40.2
GL500 IFGT.1
GLC-JRNL-BOOK-NBR
Element: Journal Book		Alpha 12
The journal book assigned to the transaction.
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-TRAN-DESC-DFLT
Transaction
Description		Alpha 1
The transaction description default. Indicates if the new journal entry is a journal entry header or prior transaction line.
J = Journal Entry
P = Prior Transaction Line
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLC-MX-VALUE
Element: Matrix Value		Alpha 32 Occurs 3 Times
The attribute value.
GL199 GL40.2
GL500
GLC-MX-CATEGORY-1
Element: Matrix Category		Derived
The attribute category associated with the transaction.
GLC-MX-CATEGORY-2
Element: Matrix Category		Derived
The attribute category associated with the transaction.
GLC-MX-CATEGORY-3
Element: Matrix Category		Derived
The attribute category associated with the transaction.
GLC-MX-DESC-1
Element: Description		Derived
The attribute category description.
GLC-MX-DESC-2
Element: Description		Derived
The attribute category description.
GLC-MX-DESC-3
Element: Description		Derived
The attribute category description.
GLC-CLOSE-SEQ
Element: Close Sequence		Numeric 2
Contains the closing sequence number.
GL146 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLC-ACT-POST-DATE
Element: Act Post Date		Numeric 8 (yyyymmdd)
Contains the posting date for activity transactions.
GL146 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLC-JBK-SEQ-NBR
Element: Jbk Seq Nbr		Numeric 10
The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).
GL40.2 GL40.6
GL500 IFGT.1
GLC-JE-APPROVE-FLG
Element: Account Flag		Alpha 1
This indicates if the journal entry is released.
GL146 GL170
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL41.4
GL44.1 GL45.1
GL500 GL75.1
GLC-SEGMENT-BLOCK
Element: Segment Block		Alpha 103
This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.
GL40.2 GL500
GLC-WF-JE-CTRL-NBR
Element: Wf Je Ctrl Nbr		Derived
The workflow journal entry number.
GLC-AUTO-REV-PD
Element: Auto Rev Pd		Numeric 2
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
GLC-REVERSE
Element: Reverse		Alpha 1
This field indicates if a reversing journal entry will be created by GL199 for this journal entry.
GL190 GL500
GLC-HOLD-REM-OPER
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
GL145 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GLC-BLANK
Element: Blankam		Derived
This field consists of blank spaces. It is used to provide column headings on Drill Arounds.
GLC-CREATED-BY
Element: Operator		Alpha 10
GL146 GL167
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
IFGT.1
GLC-LAST-UPDT-DATE
Element: Date		Numeric 8 (yyyymmdd)
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL41.4
GL44.1 GL45.1
GL500 GL75.1
IFGT.1
GLC-LAST-UPDT-TIME
Element: Time		Numeric 8
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL41.4
GL44.1 GL45.1
GL500 GL75.1
IFGT.1
GLC-LAST-UPDATE-BY
Element: Operator		Alpha 10
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL41.4
GL44.1 GL45.1
GL500 GL75.1
IFGT.1


GLCONTROL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLCSET1 COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
CA190 FB11.1
GLCSET2 COMPANY
FISCAL-YEAR
ACCT-PERIOD
STATUS
SYSTEM
CONTROL-GROUP
JE-TYPE
JE-SEQUENCE
KeyChange
GL110 GL146
GL199 GL240
GL300 GL45.1
GL500
GLCSET3 COMPANY
SYSTEM
FISCAL-YEAR
ACCT-PERIOD
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange, Subset
WhereSTATUS =3
GL167
GLCSET4 COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
Subset
Where((STATUS =Zeroes)
Or(STATUS =6))
GL240 GL40.1
GL40.2
GLCSET5 COMPANY
HOLD-CODE
FISCAL-YEAR
ACCT-PERIOD
STATUS
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange, Subset
WhereHOLD-CODE !=Spaces
GL145 GL45.1
GL12.1 GL12.2
GLCSET6 COMPANY
FISCAL-YEAR
ACCT-PERIOD
CLOSE-SEQ
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange
GL199
GLCSET7 COMPANY
POSTING-DATE
LAST-UPDT-DATE
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
KeyChange


GLCONTROL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GLC-COMPANY->GLS-COMPANY (GLSSET1)
Cucontrol One CUCONTROL Not Required
GLC-COMPANY->CLC-COMPANY
GLC-FISCAL-YEAR->CLC-FISCAL-YEAR
GLC-ACCT-PERIOD->CLC-ACCT-PERIOD
GLC-SYSTEM->CLC-SYSTEM
GLC-JE-TYPE->CLC-JE-TYPE
GLC-CONTROL-GROUP->CLC-CONTROL-GROUP
GLC-JE-SEQUENCE->CLC-JE-SEQUENCE
1->CLC-AMT-TYPE
GLS-CURR-CODE-1->CLC-CURRENCY-CODE
Cucontrol Two CUCONTROL Not Required
GLC-COMPANY->CLC-COMPANY
GLC-FISCAL-YEAR->CLC-FISCAL-YEAR
GLC-ACCT-PERIOD->CLC-ACCT-PERIOD
GLC-SYSTEM->CLC-SYSTEM
GLC-JE-TYPE->CLC-JE-TYPE
GLC-CONTROL-GROUP->CLC-CONTROL-GROUP
GLC-JE-SEQUENCE->CLC-JE-SEQUENCE
2->CLC-AMT-TYPE
GLS-CURR-CODE-2->CLC-CURRENCY-CODE
Glcbod GLCBOD Not Required
GLC-COMPANY->YCM-COMPANY
GLC-FISCAL-YEAR->YCM-FISCAL-YEAR
GLC-ACCT-PERIOD->YCM-ACCT-PERIOD
GLC-SYSTEM->YCM-SYSTEM
GLC-JE-TYPE->YCM-JE-TYPE
GLC-CONTROL-GROUP->YCM-CONTROL-GROUP
GLC-JE-SEQUENCE->YCM-JE-SEQUENCE
Glholdcode GLHOLDCODE Not Required
GLC-HOLD-CODE->GLH-HOLD-CODE
Glsccat 1 GLSCCAT Not Required
GLC-SOURCE-CODE->GSC-SOURCE-CODE
1->GSC-SEQ-NBR
Glsccat 2 GLSCCAT Not Required
GLC-SOURCE-CODE->GSC-SOURCE-CODE
2->GSC-SEQ-NBR
Glsccat 3 GLSCCAT Not Required
GLC-SOURCE-CODE->GSC-SOURCE-CODE
3->GSC-SEQ-NBR
Glsrccode GLSRCCODE Not Required
GLC-SOURCE-CODE->GSR-SOURCE-CODE
Glsysje GLSYSJE Not Required
GLC-COMPANY->GSJ-COMPANY
GLC-SYSTEM->GSJ-SYSTEM
GLC-FISCAL-YEAR->GSJ-FISCAL-YEAR
GLC-ACCT-PERIOD->GSJ-ACCT-PERIOD
Mxcatdef 1 MXCATDEF Required
GSC-MATRIX-CAT->MXC-MATRIX-CAT
Mxcatdef 2 MXCATDEF Not Required
GSC-MATRIX-CAT->MXC-MATRIX-CAT
Mxcatdef 3 MXCATDEF Not Required
GSC-MATRIX-CAT->MXC-MATRIX-CAT
System GLCODES Not Required
GLC-COMPANY->GCD-COMPANY
GLC-SYSTEM->GCD-SYSTEM


GLCONTROL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glcntrlau1 GLCNTRLAU
GLC-COMPANY->GCU-COMPANY
GLC-FISCAL-YEAR->GCU-FISCAL-YEAR
GLC-ACCT-PERIOD->GCU-ACCT-PERIOD
GLC-SYSTEM->GCU-SYSTEM
GLC-JE-TYPE->GCU-JE-TYPE
GLC-CONTROL-GROUP->GCU-CONTROL-GROUP
GLC-JE-SEQUENCE->GCU-JE-SEQUENCE
  GCU-ACTION
  GCU-DATE
  GCU-TIME
  GCU-UNIQUE-I-D
Gljelog GLJELOG
GLC-COMPANY->GJL-COMPANY
GLC-FISCAL-YEAR->GJL-FISCAL-YEAR
GLC-ACCT-PERIOD->GJL-ACCT-PERIOD
GLC-SYSTEM->GJL-SYSTEM
GLC-JE-TYPE->GJL-JE-TYPE
GLC-CONTROL-GROUP->GJL-CONTROL-GROUP
GLC-JE-SEQUENCE->GJL-JE-SEQUENCE
  GJL-LINE-NBR
  GJL-LOG-SEQ-NBR
Gljelog Cntrl GLJELOG
GLC-COMPANY->GJL-COMPANY
GLC-FISCAL-YEAR->GJL-FISCAL-YEAR
GLC-ACCT-PERIOD->GJL-ACCT-PERIOD
GLC-SYSTEM->GJL-SYSTEM
GLC-JE-TYPE->GJL-JE-TYPE
GLC-CONTROL-GROUP->GJL-CONTROL-GROUP
GLC-JE-SEQUENCE->GJL-JE-SEQUENCE
Zeroes->GJL-LINE-NBR
  GJL-LOG-SEQ-NBR
Gljelog Line GLJELOG
GLC-COMPANY->GJL-COMPANY
GLC-FISCAL-YEAR->GJL-FISCAL-YEAR
GLC-ACCT-PERIOD->GJL-ACCT-PERIOD
GLC-SYSTEM->GJL-SYSTEM
GLC-JE-TYPE->GJL-JE-TYPE
GLC-CONTROL-GROUP->GJL-CONTROL-GROUP
GLC-JE-SEQUENCE->GJL-JE-SEQUENCE
  GJL-LINE-NBR
  GJL-LOG-SEQ-NBR
Gltrans GLTRANS Delete Cascades
GLC-COMPANY->GLT-COMPANY
GLC-FISCAL-YEAR->GLT-FISCAL-YEAR
GLC-ACCT-PERIOD->GLT-ACCT-PERIOD
GLC-CONTROL-GROUP->GLT-CONTROL-GROUP
GLC-SYSTEM->GLT-SYSTEM
GLC-JE-TYPE->GLT-JE-TYPE
GLC-JE-SEQUENCE->GLT-JE-SEQUENCE
  GLT-LINE-NBR

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

Home
Contact Us



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