 |
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
UPDATED BY
GL110 GL120 GL146 GL167 GL190 GL191
GL196 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 GL199 GL290
considered the originating company. Must GL40.1 GL40.2
be defined in GLSYSTEM. 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 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 GL199
Closing). GL290 GL40.1
01 GL40.2 GL40.3
13 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 GL199
journal entry detail. 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 GL199
system. (i.e.: GL = General Ledger, AP = GL290 GL40.1
Accounts Payable, etc.) 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 GL199
I = Intercompany GL290 GL40.1
A = A/R Normal GL40.2 GL40.3
R = A/R Intercpy 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 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 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 GL199 GL290
system. 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 GL199
0 = Unrel GL290 GL40.6
1 = Rel GL45.1 GL500
5 = ERROR IFGT.1
8 = Memo
9 = Hist
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. 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 GL199
number. When used in the General Ledger GL290 GL40.1
Account Master file, the accounting unit GL40.2 GL40.3
must be defined in the General Ledger GL40.7 GL40.8
Names file as a posting accounting unit. 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 GL199
(account) where amounts and other GL290 GL40.1
account information is stored. 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 GL199
(account) where amounts and other GL290 GL40.1
account information is stored. 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 GL199
transaction was created. 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 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 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 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 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 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 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 GL199 GL290
program (GL199) creates an opposite GL40.1 GL40.2
entry for this transaction in the next GL40.3 GL40.7
period. GL40.8 GL44.1
GL45.1 GL500
Y = Yes 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
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 GL290 GL40.1
originating. 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 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 GL290
procedures that produce work. Cost GL40.1 GL40.2
objects (products, services, customers, GL40.3 GL40.7
and so on) are the reasons for GL40.8 GL44.1
performing the activity. GL45.1 GL500
IFGT.1
GLT-ACCT-CATEGORY Alpha 5 GL146 GL191
Account Category Account categories are groupings of GL40.1 GL40.2
costs, revenues, or a combination of GL40.3 GL40.7
both used for reporting and inquiries GL40.8 GL44.1
for activities in the Activity GL45.1 GL500
Management system. All transactions are 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 GL199
(GL10.1 ). 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 GL199
the current exchange rate will default. 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 GL199
creates a CUAMOUNT type 1 record. 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 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 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 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 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 GL40.1
account currency. 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
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. 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 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 GL40.1
To Base Amount To company base amount. 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 GL240
To Base Number of To company base number of decimals. GL40.1 GL40.2
Decimals GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TO-BASERATE Signed 12.6 GL146 GL40.1
To Base Rate To company base rate. 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 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 = - GL290 GL40.1
N 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 GL199 GL290
balances. 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 GL199 GL290
was posted. Used by Average Daily GL45.1 GL500
Balance to track day-to-day activity
changes.
GLT-SEQ-TRNS-NBR Numeric 10 GL146 GL190
Sequence Contains the journal entry transaction GL199 GL45.1
Transaction Number sequence number. GL500
GLT-JBK-TRNS-NBR Numeric 10 GL146 GL190
Journal Book Trans Contains the journal book transaction GL199 GL45.1
Nbr number. 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 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. GL199 GL290
The exchange rate is defined in CU10.1 GL310 GL40.1
(Exchange Rate). 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 GL196
Report Currency 1. 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 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. GL199 GL290
The exchange rate is defined in CU10.1 GL310 GL40.1
(Exchange Rate). 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 GL196
Report Currency 2. 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 GL199
CONTROL-GROUP GL240 GL241
SYSTEM GL256 GL284
JE-TYPE GL285 GL286
JE-SEQUENCE GL287 GL288
LINE-NBR 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 GL500
...
GLTSET2 TO-COMPANY KeyChange, Subset GL120 GL135
FISCAL-YEAR Where STATUS != 8 GL199 GL256
ACCT-PERIOD GL290 GL325
ACCT-UNIT 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 GL256 GL290
FISCAL-YEAR Where STATUS != 8
ACCT-PERIOD
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
OBJ-ID
GLTSET7 OBJ-ID GL146 GL190
GL256 GL45.1
IFGT.1
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
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
Oedist OEDIST
GLT-OBJ-ID -> ODI-GLT-OBJ-ID
ODI-INVC-PREFIX
ODI-INVC-NUMBER
ODI-AUTH-NO
ODI-LINE-NBR
ODI-SEQ
ODI-POSTING-TYPE
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
|