 |
Lawson Insight Technical Documentation |
|
GLTRANS FILE
General Ledger Transactions
The General Ledger Transaction file contains the journal entry detail
information to be posted to the Lawson General Ledger system. The transactions
are not deleted when posted and GL300 (General Ledger History Delete) should
be run to clear out information no longer needed.
REFERENCED BY
GL145 GL170 GL240 GL241 GL256 GL284
GL285 GL286 GL287 GL288 GL289 GL297
GL41.1 GL41.3 JB240 GL10.1 GL135 GL290
GL325 GL327 GL235 GL326 GL328 DA290
AC191 AP125 AP126 AP25.1 AP25.2 AP26.1
AP27.1 CB10.1 CB191 CB20.1 CB30.1 CB500
EE135 EE35.1 EE35.2 EE520 CA110 FB11.1
FB190 FB211 FB296 FB40.1 FB40.2 FB40.3
FB45.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL165 GL298 GL65.1 GL75.1 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 IC222 GLRV.1
IFAC.1 POIM.1
UPDATED BY
GL110 GL120 GL146 GL147 GL167 GL190
GL191 GL196 GL197 GL199 GL300 GL310
GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8
GL44.1 GL45.1 GL500 GL90.4 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLT-COMPANY Numeric 4 GL110 GL146
Company This is the company into which the GL167 GL190
transactions are to be interfaced. For GL191 GL196
intercompany processing, this field is GL197 GL199
considered the originating company. Must GL290 GL40.1
be defined in GLSYSTEM. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-FISCAL-YEAR Numeric 4 GL146 GL167
Fiscal Year This is the current fiscal year. This GL190 GL191
field is updated by Period Closing GL196 GL197
(GL199). GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-ACCT-PERIOD Numeric 2 GL146 GL167
Accounting Period This is the current accounting period. GL190 GL191
This field is updated by GL199 (Period GL196 GL197
Closing). GL199 GL290
01 GL40.1 GL40.2
13 GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-CONTROL-GROUP Numeric 8 GL146 GL167
Control Group This field displays the journal entry GL190 GL191
number used for process control of the GL196 GL197
journal entry detail. GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-SYSTEM Alpha 2 GL146 GL167
System A two-character code representing an GL190 GL191
application used within the Lawson GL196 GL197
system. (i.e.: GL = General Ledger, AP = GL199 GL290
Accounts Payable, etc.) GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-JE-TYPE Alpha 1 GL146 GL167
Journal Entry Type The journal entry type. GL190 GL191
N = Normal GL196 GL197
I = Intercompany GL199 GL290
A = A/R Normal GL40.1 GL40.2
R = A/R Intercpy GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-JE-TYPE-1 Derived
Journal Entry Type The journal entry type.
GLT-JE-SEQUENCE Numeric 2 GL146 GL167
Journal Entry The journal entry sequence number. GL190 GL191
Sequence GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-LINE-NBR Numeric 6 GL146 GL167
Line Number This field contains the line number. GL190 GL191
GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-OBJ-ID Numeric 12 GL110 GL146
Object ID Contains the object ID sequence number. GL167 GL190
Ensures that the subsystem transaction GL191 GL196
is sent to the Lawson General Ledger GL197 GL199
system. GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-STATUS Numeric 1 GL146 GL167
Status This field displays the status of the GL190 GL191
transaction. GL196 GL197
GL199 GL290
0 = Unrel GL40.1 GL40.2
1 = Rel GL40.3 GL40.6
5 = ERROR GL40.7 GL40.8
8 = Memo GL44.1 GL45.1
9 = Hist GL500 IFGT.1
GLT-VAR-LEVELS Alpha 30 GL120 GL146
Variable Levels A level that represents the location of GL167 GL190
an accounting unit in an organization's GL191 GL196
level structure. GL197 GL199
GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-ACCT-UNIT Alpha 15 GL146 GL167
Accounting Unit The accounting unit is a shorthand GL190 GL191
notation representing the variable level GL196 GL197
number. When used in the General Ledger GL199 GL290
Account Master file, the accounting unit GL40.1 GL40.2
must be defined in the General Ledger GL40.3 GL40.7
Names file as a posting accounting unit. GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ACCOUNT Numeric 6 GL146 GL167
Account This field along with the accounting GL190 GL191
unit and subaccount make up the location GL196 GL197
(account) where amounts and other GL199 GL290
account information is stored. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-SUB-ACCOUNT Numeric 4 GL146 GL167
Subaccount This field along with the accounting GL190 GL191
unit and account make up the location GL196 GL197
(account) where amounts and other GL199 GL290
account information is stored. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-SOURCE-CODE Alpha 2 GL146 GL167
Source Code A two-character code assigned to a GL190 GL191
transaction to identify where the GL196 GL197
transaction was created. GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-DATE Numeric 8 (yyyymmdd) GL146 GL167
Date Contains the system creation date. GL190 GL191
GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-REFERENCE Alpha 10 (Lower Case) GL146 GL167
Reference The reference number associated with GL190 GL191
the transaction. GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-DESCRIPTION Alpha 30 (Lower Case) GL146 GL167
Description Contains the transaction description. GL190 GL191
GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-SHORT-DESC Derived
Short Description Contains the short description.
GLT-BASE-AMOUNT Signed 15.2 GL146 GL167
Base Amount The base amount posted to the General GL190 GL191
Ledger Master file. GL196 GL197
GL199 GL284
GL285 GL286
GL287 GL289
GL290 GL40.1
GL40.2 GL40.3
GL40.5 GL40.6
GL40.7 GL40.8
GL41.3 GL44.1
GL45.1 GL500
GL90.1 GL90.2
GL90.4 IFGT.1
GLT-BASE-ND Numeric 1 GL146 GL167
Base Number of The number of decimal positions defined GL190 GL191
Decimals for the company base currency. GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-UNITS-AMOUNT Signed 15.2 GL146 GL167
Units Amount Contains the units amount associated GL190 GL191
with the transaction. GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.5 GL40.6
GL40.7 GL40.8
GL41.3 GL44.1
GL45.1 GL500
GL90.1 GL90.2
IFGT.1
GLT-AUTO-REV Alpha 1 GL146 GL167
Auto Reverse When the Auto Reversal field is set to GL190 GL191
"Y," the Lawson General Ledger Closing GL197 GL199
program (GL199) creates an opposite GL290 GL40.1
entry for this transaction in the next GL40.2 GL40.3
period. GL40.7 GL40.8
GL44.1 GL45.1
Y = Yes GL500 IFGT.1
N = No
GLT-TO-COMPANY Numeric 4 GL110 GL146
To Company The company number to which the GL167 GL190
transaction line is posted. GL191 GL196
GL197 GL199
GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-BASE-ZONE Alpha 15 GL146 GL167
Base Zone The zone within the Lawson General GL190 GL191
Ledger System where the transaction GL197 GL290
originating. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL167
Posting Date The date assigned to the journal entry GL190 GL191
for posting. GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-ACTIVITY Alpha 15 GL146 GL190
Activity Activities are the processes or GL191 GL197
procedures that produce work. Cost GL290 GL40.1
objects (products, services, customers, GL40.2 GL40.3
and so on) are the reasons for GL40.7 GL40.8
performing the activity. GL44.1 GL45.1
GL500 IFGT.1
GLT-ACCT-CATEGORY Alpha 5 GL146 GL191
Account Category Account categories are groupings of GL197 GL40.1
costs, revenues, or a combination of GL40.2 GL40.3
both used for reporting and inquiries GL40.7 GL40.8
for activities in the Activity GL44.1 GL45.1
Management system. All transactions are GL500 IFGT.1
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
GLT-CURRENCY-CODE Alpha 5 GL146 GL167
Currency Code This field contains the company base GL190 GL191
currency code established in Company GL196 GL197
(GL10.1 ). GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-BASERATE Signed 12.6 GL146 GL167
Base Rate The exchange rate at the time the GL190 GL191
journal entry was made. If left blank, GL196 GL197
the current exchange rate will default. GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TRAN-AMOUNT Signed 15.2 GL146 GL167
Transaction Amount This is the amount in transaction GL190 GL191
currency to be posted. This amount GL196 GL197
creates a CUAMOUNT type 1 record. GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.5
GL40.6 GL40.7
GL40.8 GL41.3
GL44.1 GL45.1
GL500 GL90.1
GL90.2 GL90.4
IFGT.1
GLT-TRAN-ND Numeric 1 GL146 GL167
Transaction Number The number of decimal positions defined GL190 GL191
of Decimals for the transaction currency. GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-ACCT-CURRENCY Alpha 5 GL146 GL167
Account Currency The account currency code. GL190 GL191
GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ACCT-RATE Signed 12.6 GL146 GL167
Account Rate The account exchange rate. GL190 GL191
GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ACCT-AMOUNT Signed 15.2 GL146 GL167
Account Amount The account amount. GL190 GL191
GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GL90.1 GL90.2
IFGT.1
GLT-ACCT-ND Numeric 1 GL146 GL167
Account Number of The number of decimals assigned to a GL190 GL191
Decimals particular account as determined by the GL196 GL197
account currency. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ORIG-COMPANY Numeric 4 GL110 GL146
Originating Company The originating company number. GL167 GL190
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ORIG-PROGRAM Alpha 5 GL146 GL167
Originating Program The system code where the transaction GL191 GL196
was originally created. GL197 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-OPERATOR Alpha 10 GL146 GL167
Operator This field is used to store the login GL190 GL191
ID of the person who entered the record. GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-TO-BASE-AMT Signed 15.2 GL146 GL197
To Base Amount To company base amount. GL40.1 GL40.2
GL40.3 GL40.5
GL40.6 GL40.7
GL40.8 GL41.3
GL44.1 GL45.1
GL500 GL90.2
IFGT.1
GLT-TO-BASE-ND Numeric 1 GL146 GL197
To Base Number of To company base number of decimals. GL240 GL40.1
Decimals GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-TO-BASERATE Signed 12.6 GL146 GL197
To Base Rate To company base rate. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TO-BASE-CURR Alpha 5 GL146 GL167
To Base Currency To company base currency. GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-RECONCILE Alpha 2 GL290 GL500
Reconcile Indicates the reconciliation of GL90.4
transactions.
GLT-NEGATIVE-ADJ Alpha 1 GL146 GL167
Negative Adjustment Indicates a negative adjustment. GL190 GL196
Y = - GL197 GL290
N GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-EFFECT-DATE Numeric 8 (yyyymmdd) GL146 GL167
Effective Date The effective date of the transaction. GL190 GL191
Used for calculating average daily GL197 GL199
balances. GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-UPDATE-DATE Numeric 8 (yyyymmdd) GL146 GL190
Update Date This field contains the date the record GL197 GL199
was posted. Used by Average Daily GL290 GL40.1
Balance to track day-to-day activity GL40.2 GL40.3
changes. GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLT-SEQ-TRNS-NBR Numeric 10 GL146 GL147
Sequence Contains the journal entry transaction GL190 GL197
Transaction Number sequence number. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLT-JBK-TRNS-NBR Numeric 10 GL146 GL190
Journal Book Trans Contains the journal book transaction GL197 GL199
Nbr number. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLT-CONSOL-AC-FLAG Alpha 1 GL110 GL500
Consol Ac Flag This field indicates whether the IFGT.1
transaction has several Activities
associated to it. If this flag is set to
(Y)es than the Activity value will be
spaces.
" " = No
Y = Yes
GLT-CT-FR-COMPANY Numeric 4 IFGT.1
Ct Fr Company This is the company whose currency was
converted using GL195 or GL135.
GLT-RPT-AMOUNT-1 Signed 15.2 GL146 GL167
Report Currency 1 The transaction amount for Report GL190 GL191
Amount Currency 1. GL196 GL197
GL199 GL290
GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GL90.1 GL90.2
GL90.4 IFGT.1
GLT-RPT-RATE-1 Signed 12.6 GL146 GL167
Rpt Rate 1 The exchange rate to convert the GL190 GL191
transaction amount to Report Currency 1. GL197 GL199
The exchange rate is defined in CU10.1 GL290 GL310
(Exchange Rate). GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-RPT-ND-1 Numeric 1 GL146 GL167
Rpt Nd 1 The number of decimal positions for GL190 GL191
Report Currency 1. GL196 GL197
GL199 GL290
GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-RPT-AMOUNT-2 Signed 15.2 GL146 GL167
Report Currency 2 The transaction amount for Report GL190 GL191
Amount Currency 2. GL196 GL197
GL199 GL290
GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GL90.1 GL90.2
GL90.4 IFGT.1
GLT-RPT-RATE-2 Signed 12.6 GL146 GL167
Rpt Rate 2 The exchange rate to convert the GL190 GL191
transaction amount to Report Currency 2. GL197 GL199
The exchange rate is defined in CU10.1 GL290 GL310
(Exchange Rate). GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-RPT-ND-2 Numeric 1 GL146 GL167
Rpt Nd 2 The number of decimal positions for GL190 GL191
Report Currency 2. GL196 GL197
GL199 GL290
GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLTSET1 COMPANY GL110 GL145
FISCAL-YEAR GL146 GL170
ACCT-PERIOD GL190 GL197
CONTROL-GROUP GL199 GL240
SYSTEM GL241 GL256
JE-TYPE GL284 GL285
JE-SEQUENCE GL286 GL287
LINE-NBR GL288 GL289
GL297 GL300
GL310 GL40.1
GL40.2 GL40.3
GL40.5 GL40.6
GL40.7 GL40.8
GL41.1 GL41.3
GL44.1 GL45.1
...
GLTSET2 TO-COMPANY KeyChange, Subset GL120 GL135
FISCAL-YEAR Where STATUS != 8 GL147 GL199
ACCT-PERIOD GL256 GL290
ACCT-UNIT GL325 GL327
ACCOUNT
SUB-ACCOUNT
POSTING-DATE
SYSTEM
CONTROL-GROUP
JE-TYPE
LINE-NBR
COMPANY
JE-SEQUENCE
GLTSET3 TO-COMPANY KeyChange, Subset GL235 GL326
ACCOUNT Where STATUS != 8 GL328 GL90.1
SUB-ACCOUNT GL90.2 GL90.4
ACCT-UNIT
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
CONTROL-GROUP
JE-TYPE
JE-SEQUENCE
LINE-NBR
COMPANY
GLTSET6 TO-COMPANY KeyChange, Subset DA290 GL256
FISCAL-YEAR Where STATUS != 8 GL290
ACCT-PERIOD
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
OBJ-ID
GLTSET7 OBJ-ID GL146 GL147
GL190 GL197
GL256 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
GLTSET8 COMPANY KeyChange, Subset AC191 AP125
VAR-LEVELS Where STATUS = 1 AP126 AP25.1
ACCT-UNIT AP25.2 AP26.1
ACCOUNT AP27.1 CB10.1
SUB-ACCOUNT CB191 CB20.1
FISCAL-YEAR CB30.1 CB500
ACCT-PERIOD EE135 EE35.1
SYSTEM EE35.2 EE520
OBJ-ID CA110 FB11.1
FB190 FB211
FB296 FB40.1
FB40.2 FB40.3
FB45.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
...
GLTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
GLT-TO-COMPANY -> GLM-COMPANY
GLT-ACCT-UNIT -> GLM-ACCT-UNIT
GLT-ACCOUNT -> GLM-ACCOUNT
GLT-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Activity ACACTIVITY Not Required
GLT-ACTIVITY -> ACV-ACTIVITY
Category 1 GLSCCAT Not Required
GLT-SOURCE-CODE -> GSC-SOURCE-CODE
1 -> GSC-SEQ-NBR
Category 3 GLSCCAT Not Required
GLT-SOURCE-CODE -> GSC-SOURCE-CODE
3 -> GSC-SEQ-NBR
Categroy 2 GLSCCAT Not Required
GLT-SOURCE-CODE -> GSC-SOURCE-CODE
2 -> GSC-SEQ-NBR
Chart Detail GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GLT-ACCOUNT -> GDT-ACCOUNT
GLT-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
GLT-COMPANY -> GLS-COMPANY
Cuamountx 3 CUAMOUNTX Not Required
GLT-COMPANY -> CAX-COMPANY
"3" -> CAX-AMT-TYPE
GLT-FISCAL-YEAR -> CAX-FISCAL-YEAR
GLT-ACCT-UNIT -> CAX-ACCT-UNIT
GLT-ACCOUNT -> CAX-ACCOUNT
GLT-SUB-ACCOUNT -> CAX-SUB-ACCOUNT
GLT-POSTING-DATE -> CAX-DATE
Cuamountx 4 CUAMOUNTX Not Required
GLT-COMPANY -> CAX-COMPANY
"4" -> CAX-AMT-TYPE
GLT-FISCAL-YEAR -> CAX-FISCAL-YEAR
GLT-ACCT-UNIT -> CAX-ACCT-UNIT
GLT-ACCOUNT -> CAX-ACCOUNT
GLT-SUB-ACCOUNT -> CAX-SUB-ACCOUNT
GLT-POSTING-DATE -> CAX-DATE
Glamountsx GLAMOUNTSX Not Required
GLT-COMPANY -> GAX-COMPANY
GLT-POSTING-DATE -> GAX-DATE
GLT-ACCT-UNIT -> GAX-ACCT-UNIT
GLT-ACCOUNT -> GAX-ACCOUNT
GLT-SUB-ACCOUNT -> GAX-SUB-ACCOUNT
Glcondrill GLCONDRILL Required
GLT-OBJ-ID -> GLD-GLT-OBJ-ID
Glcontrol GLCONTROL Required
GLT-COMPANY -> GLC-COMPANY
GLT-FISCAL-YEAR -> GLC-FISCAL-YEAR
GLT-ACCT-PERIOD -> GLC-ACCT-PERIOD
GLT-SYSTEM -> GLC-SYSTEM
GLT-JE-TYPE -> GLC-JE-TYPE
GLT-CONTROL-GROUP -> GLC-CONTROL-GROUP
GLT-JE-SEQUENCE -> GLC-JE-SEQUENCE
Glholdcode GLHOLDCODE Not Required
GLC-HOLD-CODE -> GLH-HOLD-CODE
Glsegblock GLSEGBLOCK Not Required
GLT-OBJ-ID -> GSB-GLT-OBJ-ID
Glsrccode GLSRCCODE Required
GLT-SOURCE-CODE -> GSR-SOURCE-CODE
Glsystem GLSYSTEM Required
GLT-COMPANY -> GLS-COMPANY
Rjbridge RJBRIDGE Not Required
"GLTRN" -> RJB-OBJ-TYPE
GLT-OBJ-ID -> RJB-OBJ-ID
Rjcontrol RJCONTROL Not Required
GLT-COMPANY -> RJC-COMPANY
GLT-JE-TYPE -> RJC-JE-TYPE
GLT-CONTROL-GROUP -> RJC-REC-GROUP
Rjcontrol Intf RJCONTROL Not Required
GLT-COMPANY -> RJC-COMPANY
RJB-JE-TYPE -> RJC-JE-TYPE
RJB-REC-GROUP -> RJC-REC-GROUP
Source Code GLCODES Not Required
"S" -> GCD-RECORD-TYPE
Spaces -> GCD-FOLDER-NAME
Spaces -> GCD-PROCESS-GROUP
GLT-SOURCE-CODE -> GCD-SYSTEM
Zeroes -> GCD-COMPANY
To Company GLSYSTEM Required
GLT-TO-COMPANY -> GLS-COMPANY
GLTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
GLT-OBJ-ID -> ATN-GLT-OBJ-ID
ATN-OBJ-ID
Amtrans AMTRANS
GLT-OBJ-ID -> AMT-GLT-OBJ-ID
AMT-ASSET
AMT-SEQ-NUMBER
Apapdhist APAPDHIST
GLT-OBJ-ID -> AH2-GLT-OBJ-ID
AH2-API-OBJ-ID
AH2-DIST-SEQ-NBR
Apdistrib APDISTRIB
GLT-OBJ-ID -> APD-GLT-OBJ-ID
APD-API-OBJ-ID
APD-DIST-SEQ-NBR
Apdrftdist APDRFTDIST
GLT-TO-COMPANY -> DDT-DIST-COMPANY
GLT-ACCT-UNIT -> DDT-DST-ACCT-UNIT
GLT-ACCOUNT -> DDT-DST-ACCOUNT
GLT-SUB-ACCOUNT -> DDT-DST-SUB-ACCT
GLT-POSTING-DATE -> DDT-POST-DATE
GLT-OBJ-ID -> DDT-GLT-OBJ-ID
DDT-BANK-INST-CODE
DDT-TRANS-IDENT
DDT-SEQ-NBR
Ardistrib Det ARDISTRIB
GLT-COMPANY -> AMD-GL-COMPANY
GLT-ACCT-UNIT -> AMD-ACCT-UNIT
GLT-ACCOUNT -> AMD-ACCOUNT
GLT-SUB-ACCOUNT -> AMD-SUB-ACCT
GLT-POSTING-DATE -> AMD-GL-DATE
GLT-OBJ-ID -> AMD-GLT-OBJ-ID
AMD-CREATE-DATE
AMD-CREATE-TIME
AMD-PROG-SEQ-NBR
Caheader CAHEADER
GLT-ORIG-COMPANY -> CAH-COMPANY
GLT-CONTROL-GROUP -> CAH-JE-NBR
GLT-JE-TYPE -> CAH-JE-TYPE
CAH-ALLOC-NAME
CAH-ALLOC-TYPE
Cbdistrib CBDISTRIB
GLT-TO-COMPANY -> CBD-DIST-COMPANY
GLT-ACCT-UNIT -> CBD-DIS-ACCT-UNIT
GLT-ACCOUNT -> CBD-DIS-ACCOUNT
GLT-SUB-ACCOUNT -> CBD-DIS-SUB-ACCT
GLT-OBJ-ID -> CBD-GLT-OBJ-ID
CBD-CASH-CODE
CBD-TRANS-NBR
CBD-BANK-INST-CODE
CBD-DIST-TYPE
CBD-SEQ-NBR
CBD-TRANS-IDENT
Eedistrib EEDISTRIB
GLT-OBJ-ID -> EED-GLT-OBJ-ID
EED-COMPANY
EED-VENDOR
EED-EXPENSE-NBR
EED-SEQ-NBR
Glcommit GLCOMMIT
GLT-COMPANY -> GOT-COMPANY
GLT-ACCT-UNIT -> GOT-ACCT-UNIT
GLT-ACCOUNT -> GOT-ACCOUNT
GLT-SUB-ACCOUNT -> GOT-SUB-ACCOUNT
GLT-FISCAL-YEAR -> GOT-FISCAL-YEAR
GOT-SYSTEM
Glcommitx GLCOMMITX
GLT-COMPANY -> GOX-COMPANY
GLT-ACCT-UNIT -> GOX-ACCT-UNIT
GLT-ACCOUNT -> GOX-ACCOUNT
GLT-SUB-ACCOUNT -> GOX-SUB-ACCOUNT
GLT-FISCAL-YEAR -> GOX-FISCAL-YEAR
GLT-ACCT-PERIOD -> GOX-PERIOD
GOX-SYSTEM
GOX-CURRENCY-CODE
GOX-GLT-OBJ-ID
Glsccat GLSCCAT
GLT-SOURCE-CODE -> GSC-SOURCE-CODE
GSC-SEQ-NBR
Gltrans GLTRANS
GLT-COMPANY -> GLT-COMPANY
GLT-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD -> GLT-ACCT-PERIOD
GLT-CONTROL-GROUP -> GLT-CONTROL-GROUP
GLT-SYSTEM -> GLT-SYSTEM
GLT-JE-TYPE -> GLT-JE-TYPE
GLT-JE-SEQUENCE -> GLT-JE-SEQUENCE
GLT-LINE-NBR
Gtmxvalue GTMXVALUE Delete Cascades
GLT-OBJ-ID -> GMV-OBJ-ID
GMV-MATRIX-CAT
Icmmdist MMDIST
Valid When GLT-SYSTEM = "IC"
GLT-OBJ-ID -> MMD-GLT-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Pbdistrib PBDISTRIB
GLT-COMPANY -> PDB-DIST-COMPANY
GLT-ACCT-UNIT -> PDB-DST-ACCT-UNIT
GLT-ACCOUNT -> PDB-DST-ACCOUNT
GLT-SUB-ACCOUNT -> PDB-DST-SUB-ACCT
GLT-OBJ-ID -> PDB-GLT-OBJ-ID
PDB-OBJ-ID
Pommdist MMDIST
Valid When GLT-SYSTEM = "PO"
GLT-OBJ-ID -> MMD-GLT-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Prdistrib PRDISTRIB
GLT-TO-COMPANY -> PRD-DIST-COMPANY
GLT-ACCT-UNIT -> PRD-DST-ACCT-UNIT
GLT-ACCOUNT -> PRD-DST-ACCOUNT
GLT-SUB-ACCOUNT -> PRD-DST-SUB-ACCT
GLT-OBJ-ID -> PRD-GLT-OBJ-ID
PRD-OBJ-ID
Sltrans SLTRANS
GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|