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
CA195 FB100 FB101 FB120 FB121 FB122
FB145 FB165 FB190 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 FB40.1
FB40.2 FB40.3 FB45.1 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 PO135 AC191 AC40.4 AC41.4
AC42.1 AP125 AP126 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 BR41.4 BR44.1 CB10.1 CB15.1
CB15.2 CB191 CB20.1 CB30.1 CB500 EE135
EE35.1 EE35.2 EE520 CA110 FB11.1 FB111
FB160 FB211 FB296 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL165 GL298
GL65.1 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
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
RW80.1 IC222 GLRV.1 IFAC.1 PO150 PO25.1
PO25.6 PO25.7 PO536 POIM.1
UPDATED BY
AC145 AC45.1 GL110 GL120 GL146 GL147
GL148 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 MM280 GL300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLT-COMPANY Numeric 4 AC45.1 GL110
Element: Company This is the company into which the GL146 GL148
transactions are to be interfaced. For GL167 GL190
intercompany processing, this field is GL191 GL196
considered the originating company. Must GL197 GL199
be defined in GLSYSTEM. GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-FISCAL-YEAR Numeric 4 GL146 GL148
Element: Fiscal Year This is the current fiscal year. This GL167 GL190
field is updated by Period Closing GL191 GL196
(GL199). GL197 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 GL148
Element: Accounting PerThis is the current accounting period. GL167 GL190
This field is updated by GL199 (Period GL191 GL196
Closing). GL197 GL199
01 GL290 GL40.1
13 GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-CONTROL-GROUP Numeric 8 GL146 GL148
Element: Control Group This field displays the journal entry GL167 GL190
number used for process control of the GL191 GL196
journal entry detail. GL197 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 GL148
Element: System A two-character code representing an GL167 GL190
application used within the Lawson GL191 GL196
system. (i.e.: GL = General Ledger, AP = GL197 GL199
Accounts Payable, etc.) GL290 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 GL148
Element: Journal Entry The journal entry type. GL167 GL190
N = Normal GL191 GL196
I = Intercompany GL197 GL199
A = A/R Normal GL290 GL40.1
R = A/R Intercpy GL40.2 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 GL148
Journal Entry The journal entry sequence number. GL167 GL190
Sequence 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-LINE-NBR Numeric 6 GL146 GL148
Element: Line Number This field contains the line number. 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-OBJ-ID Numeric 12 GL110 GL146
Element: Object ID Contains the object ID sequence number. GL148 GL167
Ensures that the subsystem transaction GL190 GL191
is sent to the Lawson General Ledger GL196 GL197
system. GL199 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 GL148
Element: Status This field displays the status of the GL167 GL190
transaction. GL191 GL196
0 = Unrel GL197 GL199
1 = Rel GL290 GL40.1
5 = ERROR GL40.2 GL40.3
8 = Memo GL40.6 GL40.7
9 = Hist GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-VAR-LEVELS Alpha 30 GL120 GL146
Element: Variable LevelA level that represents the location of GL148 GL167
an accounting unit in an organization's GL190 GL191
level structure. 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 AC45.1 GL146
Element: Accounting UniThe accounting unit is a shorthand GL148 GL167
notation representing the variable level GL190 GL191
number. When used in the General Ledger GL196 GL197
Account Master file, the accounting unit GL199 GL290
must be defined in the General Ledger GL40.1 GL40.2
Names file as a posting accounting unit. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ACCOUNT Numeric 6 AC45.1 GL146
Element: Account This field along with the accounting GL148 GL167
unit and subaccount make up the location GL190 GL191
(account) where amounts and other GL196 GL197
account information is stored. GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-SUB-ACCOUNT Numeric 4 AC45.1 GL146
Element: Subaccount This field along with the accounting GL148 GL167
unit and account make up the location GL190 GL191
(account) where amounts and other GL196 GL197
account information is stored. GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-SOURCE-CODE Alpha 2 GL146 GL148
Element: Source Code A two-character code assigned to a GL167 GL190
transaction to identify where the GL191 GL196
transaction was created. GL197 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 GL148
Element: Date Contains the system creation date. GL167 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 GL148
Element: Reference The reference number associated with GL167 GL190
the transaction. 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-DESCRIPTION Alpha 30 (Lower Case) GL146 GL148
Element: Description Contains the transaction description. GL167 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 18.2 GL146 GL148
Element: Base Amount The company base amount. GL167 GL190
GL191 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
GL90.6 IFGT.1
GLT-BASE-ND Numeric 1 GL146 GL148
Base Number of The number of decimal positions defined GL167 GL190
Decimals for the company base currency. GL191 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
GL90.6 IFGT.1
GLT-AUTO-REV Alpha 1 GL146 GL148
Element: Auto Reverse When the Auto Reversal field is set to GL167 GL190
"Y," the Lawson General Ledger Closing GL191 GL197
program (GL199) creates an opposite GL199 GL290
entry for this transaction in the next GL40.1 GL40.2
period. GL40.3 GL40.7
GL40.8 GL44.1
Y = Yes GL45.1 GL500
N = No IFGT.1
GLT-TO-COMPANY Numeric 4 GL110 GL146
Element: To Company The company number to which the GL148 GL167
transaction line is posted. 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-BASE-ZONE Alpha 15 GL146 GL148
Element: Base Zone The zone within the Lawson General GL167 GL190
Ledger System where the transaction GL191 GL197
originating. 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 GL148
Element: Posting Date The date assigned to the journal entry GL167 GL190
for posting. 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 AC145 AC45.1
Element: Activity Activities are the processes or GL146 GL148
procedures that produce work. Cost GL190 GL191
objects (products, services, customers, GL197 GL290
and so on) are the reasons for GL40.1 GL40.2
performing the activity. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 MM280
GLT-ACCT-CATEGORY Alpha 5 AC145 AC45.1
Element: Account CategoAccount categories are groupings of GL146 GL148
costs, revenues, or a combination of GL191 GL197
both used for reporting and inquiries GL40.1 GL40.2
for activities in the Activity GL40.3 GL40.7
Management system. All transactions are GL40.8 GL44.1
posted to an account category within an GL45.1 GL500
activity. You can assign a specific IFGT.1 MM280
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.
Valid account category types are:
cost
revenue
accrual
pass thru
GLT-CURRENCY-CODE Alpha 5 GL146 GL148
Element: Currency Code This field contains the company base GL167 GL190
currency code established in Company GL191 GL196
(GL10.1 ). GL197 GL199
GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-BASERATE Signed 14.7 GL146 GL148
Element: Base Rate The exchange rate at the time the GL167 GL190
journal entry was made. If left blank, GL191 GL196
the current exchange rate will default. GL197 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 18.2 GL146 GL148
Element: Transaction AmThis is the amount in transaction GL167 GL190
currency to be posted. This amount GL191 GL196
creates a CUAMOUNT type 1 record. 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
GL90.6 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
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 14.7 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 18.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
GL90.6 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. GL148 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 GL148
Element: Originating PrThe system code where the transaction GL167 GL191
was originally created. GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-OPERATOR Alpha 10 GL146 GL148
Element: Operator This field is used to store the login GL167 GL190
ID of the person who entered the record. GL191 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 18.2 GL146 GL148
Element: To Base AmountTo company base amount. GL197 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 GL148
To Base Number of To company base number of decimals. GL197 GL240
Decimals GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TO-BASERATE Signed 14.7 GL146 GL148
Element: To Base Rate To company base rate. GL197 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 GL148
Element: To Base CurrenTo company base currency. GL167 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 GL148
Element: Negative AdjusIndicates a negative adjustment. GL167 GL190
Y = - GL196 GL197
N GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-EFFECT-DATE Numeric 8 (yyyymmdd) GL146 GL148
Element: Effective DateThe effective date of the transaction. GL167 GL190
Used for calculating average daily GL191 GL197
balances. GL199 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: 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
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 GL500 IFGT.1
Element: Company This is the company whose currency was
converted using GL195 or GL135.
GLT-RPT-AMOUNT-1 Signed 18.2 GL146 GL148
Element: Intl Amt The transaction amount for Report GL167 GL190
Currency 1. 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
GL90.6 IFGT.1
GLT-RPT-RATE-1 Signed 14.7 GL146 GL148
Element: Currency Rate The exchange rate to convert the GL167 GL190
transaction amount to Report Currency 1. GL191 GL197
The exchange rate is defined in CU10.1 GL199 GL290
(Exchange Rate). GL310 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 GL148
Account Currency The number of decimal positions for GL167 GL190
Code Report Currency 1. GL191 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 18.2 GL146 GL148
Element: Intl Amt The transaction amount for Report GL167 GL190
Currency 2. 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
GL90.6 IFGT.1
GLT-RPT-RATE-2 Signed 14.7 GL146 GL148
Element: Currency Rate The exchange rate to convert the GL167 GL190
transaction amount to Report Currency 2. GL191 GL197
The exchange rate is defined in CU10.1 GL199 GL290
(Exchange Rate). 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 GL148
Account Currency The number of decimal positions for GL167 GL190
Code Report Currency 2. GL191 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 AC145 AC45.1
FISCAL-YEAR CA195 FB100
ACCT-PERIOD FB101 FB120
CONTROL-GROUP FB121 FB122
SYSTEM FB145 FB165
JE-TYPE FB190 FB20.1
JE-SEQUENCE FB20.3 FB20.4
LINE-NBR FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL145 GL146
GL167 GL170
GL190 GL191
...
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 GL90.6
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 AC145 AC45.1
GL146 GL147
GL190 GL197
GL256 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 PO135
MM280
GLTSET8 COMPANY KeyChange, Subset AC191 AC40.4
VAR-LEVELS Where STATUS = 1 AC41.4 AC42.1
ACCT-UNIT AP125 AP126
ACCOUNT AP25.1 AP25.2
SUB-ACCOUNT AP26.1 AP27.1
FISCAL-YEAR AP30.2 BR41.4
ACCT-PERIOD BR44.1 CB10.1
SYSTEM CB15.1 CB15.2
OBJ-ID CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 FB11.1
FB111 FB145
FB160 FB190
...
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
Fbfunddtl FBFUNDDTL Required
GLT-COMPANY -> FUD-COMPANY
GLT-ACCOUNT -> FUD-ACCOUNT
GLT-SUB-ACCOUNT -> FUD-SUB-ACCOUNT
GLT-ACCT-UNIT -> FUD-ACCT-UNIT
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
Fbdetail FBDETAIL
GLT-COMPANY -> FBD-COMPANY
GLT-ACCT-UNIT -> FBD-ACCT-UNIT
GLT-ACCOUNT -> FBD-ACCOUNT
GLT-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
FBD-BUDGET-NBR
FBD-FISCAL-YEAR
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
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
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
|