Lawson Insight Technical Documentation |
|
GLTRANS
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
FB11.1 FB111 FB211 FB296 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL145 GL170
GL240 GL241 GL256 GL284 GL285 GL286
GL287 GL288 GL289 GL297 GL298 GL41.1
GL41.3 GL700 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 JB240 GL10.1 MM280 MM80.1 MM80.2
GL135 GL290 GL325 GL327 GL235 GL326
GL328 PO135 AC191 AC40.4 AC41.4 AC42.1
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 API1.1 API2.1 BR41.4 CB10.1 CB191
CB20.1 CB30.1 CB500 EE135 EE35.1 EE35.2
EE520 CA110 FB145 FB190 FB40.1 FB40.2
FB40.3 FB45.1 GL165 GL65.1 GL75.1 RW80.1
IC222 GLRV.1 IFAC.1 MA41.2 MA41.7 MA43.2
MA61.1 MAI1.1 PO150 PO25.1 PO25.6 PO25.7
PO536 POIM.1
UPDATED BY
GL110 GL120 GL146 GL147 GL167 GL190
GL191 GL196 GL197 GL199 GL310 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL44.1
GL45.1 GL500 GL90.4 IFGT.1 GL300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLT-COMPANY Numeric 4 GL110 GL146
Element: 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
Element: 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
Element: Accounting Per01d GL190 GL191
13 GL196 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-CONTROL-GROUP Numeric 8 GL146 GL167
Element: 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
Element: 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
Element: Journal Entry 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
Element: Journal Entry 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
Element: 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
Element: 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
Element: Status This field displays the status of the GL190 GL191
transaction. GL196 GL197
0 = Unrel GL199 GL290
1 = Rel GL40.1 GL40.2
5 = ERROR GL40.3 GL40.6
8 = Memo GL40.7 GL40.8
9 = Hist GL44.1 GL45.1
GL500 IFGT.1
GLT-VAR-LEVELS Alpha 30 GL120 GL146
Element: Variable Levels GL167 GL190
GL191 GL196
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
Element: Accounting UniThe 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Short DescriptContains the short description.
GLT-BASE-AMOUNT Signed 15.2 GL146 GL167
Element: 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 GL190 GL191
Decimals 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
Element: Units Amount Contains the units amount associated GL190 GL191
with the transaction. GL196 GL197
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.5
IFGT.1
GLT-AUTO-REV Alpha 1 GL146 GL167
Element: 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
Element: 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
Element: Base Zone GL190 GL191
GL197 GL290
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
Element: Posting 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-ACTIVITY Alpha 15 GL146 GL190
Element: 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
Element: Account CategoAccount 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
Element: 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
Element: 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
Element: Transaction Amount GL190 GL191
GL196 GL197
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
GL90.5 IFGT.1
GLT-TRAN-ND Numeric 1 GL146 GL167
Transaction Number GL190 GL191
of Decimals 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
Element: Account CurrenThe 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
Element: 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
Element: Account AmountThe 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
Element: Originating CoThe 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
Element: Originating PrThe 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
Element: 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.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TO-BASE-AMT Signed 15.2 GL146 GL197
Element: To Base AmountTo 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
Element: 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
Element: To Base CurrenTo 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
Element: Reconcile Indicates the reconciliation of GL90.4
transactions.
GLT-NEGATIVE-ADJ Alpha 1 GL146 GL167
Element: Negative AdjusIndicates 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
Element: 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
Element: 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
Element: Consol Ac FlagThis 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
Element: Ct Fr Company This is the company whose currency was
converted using GL195 or GL135.
GLT-RPT-AMOUNT-1 Signed 15.2 GL146 GL167
Element: Adj Amt GL190 GL191
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
Element: 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
Account Currency GL190 GL191
Code 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
Element: Rpt Rate 1 GL190 GL191
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-ND-2 Numeric 1 GL146 GL167
Element: 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 FB11.1 FB111
FISCAL-YEAR FB211 FB296
ACCT-PERIOD FB95.1 FB95.2
CONTROL-GROUP FB95.3 FB95.4
SYSTEM FB95.5 FB95.6
JE-TYPE GL110 GL145
JE-SEQUENCE GL146 GL170
LINE-NBR GL190 GL191
GL197 GL199
GL240 GL241
GL256 GL284
GL285 GL286
GL287 GL288
GL289 GL297
GL298 GL300
...
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 GL90.5
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
CONTROL-GROUP
JE-TYPE
JE-SEQUENCE
LINE-NBR
COMPANY
GLTSET6 TO-COMPANY KeyChange, Subset GL256 GL290
FISCAL-YEAR Where STATUS != 8
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 PO135
GLTSET8 COMPANY KeyChange, Subset AC191 AC40.4
VAR-LEVELS Where STATUS = 1 AC41.4 AC42.1
ACCT-UNIT AP125 AP126
ACCOUNT AP20.1 AP20.2
SUB-ACCOUNT AP20.3 AP20.4
FISCAL-YEAR AP20.5 AP20.7
ACCT-PERIOD AP23.1 AP25.1
SYSTEM AP25.2 AP26.1
OBJ-ID AP27.1 API1.1
API2.1 BR41.4
CB10.1 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA110
...
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
Acdefrev ACDEFREV
GLT-OBJ-ID -> DRD-GLT-OBJ-ID
DRD-ATN-OBJ-ID
DRD-CONTRACT
DRD-PRODUCT
DRD-PROD-VERSION
DRD-OBJ-ID
DRD-SEQ-NBR
Acmntschx ACMNTSCHX
GLT-OBJ-ID -> MSD-GLT-OBJ-ID
MSD-ATN-OBJ-ID
MSD-CONTRACT
MSD-MAINT-SCHEDULE
MSD-PRODUCT
MSD-PROD-VERSION
MSD-OBJ-ID
MSD-TRAN-DATE
Acpmhstdtl ACPMHSTDTL
GLT-OBJ-ID -> PML-GLT-OBJ-ID
PML-ATN-OBJ-ID
PML-OBJ-ID
PML-LINE-NBR
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
Pornimmdist MMDIST
Valid When GLT-SYSTEM = "PO"
GLT-OBJ-ID -> MMD-RNI-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
|