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 PO278 GL135 GL290 GL325 GL327
FB11.1 FB111 FB160 FB211 FB296 FB60.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL235 GL298 GL326 GL328 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 PO135 AC191 AC40.4
AC41.4 AC42.1 AP125 AP126 AP170 AP193
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 AP520 API1.1 API2.1 BR41.4 BR44.1
CB10.1 CB15.1 CB15.2 CB150 CB191 CB20.1
CB30.1 CB45.1 CB46.1 CB500 CB543 CB544
CB55.1 CB554 EE135 EE35.1 EE35.2 EE520
CA110 GL165 GL65.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 RW80.1 GLRV.1 IFAC.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.2 MA61.1
MAI1.1 PO150 PO25.1 PO25.6 PO25.7 PO536
POIM.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1
RQ500 RQIB.1 RQIF.1 RQIJ.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 MM80.1 MM80.2 GL300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLT-COMPANY Numeric 4 GL110 GL146
Element: Company This is the company into which the GL148 GL167
transactions are to be interfaced. For GL190 GL191
intercompany processing, this field is GL196 GL197
considered the originating company. Must GL199 GL290
be defined in GLSYSTEM. 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 Contains the fiscal year for the data GL167 GL190
stored on this record. 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-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 General Ledger. GL196 GL197
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 GL146 GL148
Element: Accounting UniThe accounting unit is a shorthand GL167 GL190
notation representing the variable level GL191 GL196
number. When used in the General Ledger GL197 GL199
Account Master file, the accounting unit GL290 GL40.1
must be defined in the General Ledger GL40.2 GL40.3
Names file as a posting accounting unit. GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-ACCOUNT Numeric 6 GL146 GL148
Element: Account This field along with the accounting GL167 GL190
unit and subaccount make up the location GL191 GL196
(account) where amounts and other GL197 GL199
account information is stored. GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-SUB-ACCOUNT Numeric 4 GL146 GL148
Element: Subaccount This field along with the accounting GL167 GL190
unit and account make up the location GL191 GL196
(account) where amounts and other GL197 GL199
account information is stored. 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.6
Y = Yes GL40.7 GL40.8
N = No GL44.1 GL45.1
GL500 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 A zone identifies a group of accounting GL167 GL190
units that stay in balance when GL191 GL197
transactions pass between defined zone GL290 GL40.1
areas. 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
MM80.1 MM80.2
GLT-ACCT-CATEGORY Alpha 5 AC145 AC45.1
Element: Account CategoAccount categories are groupings of GL146 GL148
costs, revenues, or a combination of GL190 GL191
both used for reporting and inquiries GL197 GL40.1
for activities in the Activity GL40.2 GL40.3
Management system. All transactions are GL40.7 GL40.8
posted to an account category within an GL44.1 GL45.1
activity. You can assign a specific GL500 IFGT.1
General Ledger account or range of MM280 MM80.1
accounts (company, accounting unit, MM80.2
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 Amount GL167 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
GL90.6 IFGT.1
GLT-TRAN-ND Numeric 1 GL146 GL167
Transaction Number The number of decimals assigned to a GL190 GL191
of Decimals particular account as determined by the GL196 GL197
account currency. 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.6 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 Adj Indicates 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: Effect Date The 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 GL167 GL190
GL191 GL196
GL197 GL199
GL290 GL310
GL40.1 GL40.2
GL40.3 GL40.5
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: Curr Rate The currency rate. GL167 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-1 Numeric 1 GL146 GL148
Element: Acct Nd The number of decimals assigned to a GL167 GL190
particular account as determined by the GL191 GL196
account currency. 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 GL167 GL190
GL191 GL196
GL197 GL199
GL290 GL310
GL40.1 GL40.2
GL40.3 GL40.5
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: Curr Rate The currency rate. GL167 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 GL148
Element: Acct Nd The number of decimals assigned to a GL167 GL190
particular account as determined by the GL191 GL196
account currency. 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 FB11.1 FB111
ACCOUNT Where STATUS != 8 FB160 FB211
SUB-ACCOUNT FB296 FB60.1
ACCT-UNIT FB95.1 FB95.2
FISCAL-YEAR FB95.3 FB95.4
ACCT-PERIOD FB95.5 FB95.6
SYSTEM GL235 GL298
CONTROL-GROUP GL326 GL328
JE-TYPE GL90.1 GL90.2
JE-SEQUENCE GL90.4 GL90.5
LINE-NBR GL90.6 GL94.1
COMPANY GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
...
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 MM80.1
MM80.2
GLTSET8 COMPANY KeyChange, Subset AC191 AC40.4
VAR-LEVELS Where STATUS = 1 AC41.4 AC42.1
ACCT-UNIT AP125 AP126
ACCOUNT AP170 AP193
SUB-ACCOUNT AP20.1 AP20.2
FISCAL-YEAR AP20.3 AP20.4
ACCT-PERIOD AP20.5 AP20.7
SYSTEM AP21.1 AP23.1
OBJ-ID AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
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
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
Achistdtl ACHISTDTL
GLT-OBJ-ID -> HDT-GLT-OBJ-ID
HDT-OBJ-ID
HDT-LINE-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
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
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-COMPANY -> PRD-DIST-COMPANY
GLT-OBJ-ID -> PRD-GLT-OBJ-ID
GLT-ACCT-UNIT -> PRD-DST-ACCT-UNIT
GLT-ACCOUNT -> PRD-DST-ACCOUNT
GLT-SUB-ACCOUNT -> PRD-DST-SUB-ACCT
PRD-OBJ-ID
Sltrans SLTRANS
GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|