GLTRANS

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
FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7
FB21.1 FB30.1 FB31.1


UPDATED BY
GL110 GL120 GL146 GL147 GL148 GL167
GL190 GL191 GL196 GL197 GL199 GL310
GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8
GL40.5 GL44.1 GL45.1 GL500 GL90.4 GL90.1
GL90.2 GL90.5 GL90.6 GL90.7 IFGT.1 MM280
FB145 FB190 FB40.1 FB40.2 FB40.3 FB45.1
GL145 GL170 GL240 GL241 GL256 GL284
GL285 GL286 GL287 GL288 GL289 GL297
GL300 GL41.1 GL41.3 JB240 GL10.1 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 GL299
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 AP125 AP126 AP131 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 AP30.4 AP520 API1.1 API2.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 GL76.1 RW80.1 EX545 GLRV.1
IFAC.1 IFEB.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POII.1 POIJ.1 POIM.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLT-COMPANY
Element: Company		Numeric 4
This is the company into which the transactions are to be interfaced. For intercompany processing, this field is considered the originating company. Must be defined in GLSYSTEM.
GL110 GL146
GL148 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-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
Contains the fiscal year for the data stored on this record.
GL146 GL148
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-ACCT-PERIOD
Element: Accounting Period		Numeric 2
This is the current accounting period. This field is updated by GL199 (Period Closing).
01
13
GL146 GL148
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-CONTROL-GROUP
Element: Control Group		Numeric 8
This field displays the journal entry number used for process control of the journal entry detail.
GL146 GL148
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-SYSTEM
Element: System		Alpha 2
A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)
GL146 GL148
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-JE-TYPE
Element: Journal Entry Type		Alpha 1
The journal entry type. N = Normal I = Inter-company A = AR Normal R = AR Intercompany
GL146 GL148
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-JE-TYPE-1
Element: Journal Entry Type		Derived
The journal entry type.
GLT-JE-SEQUENCE
Journal Entry
Sequence		Numeric 2
The journal entry sequence number.
GL146 GL148
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-LINE-NBR
Element: Line Number		Numeric 6
This field contains the line number.
GL146 GL148
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
Element: Object ID		Numeric 12
Contains the object ID sequence number. Ensures that the subsystem transaction is sent to General Ledger.
GL110 GL146
GL148 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-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction. 0 = Unrel 1 = Rel 5 = ERROR 8 = Memo 9 = Hist
GL146 GL148
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-VAR-LEVELS
Element: Variable Levels		Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
GL120 GL146
GL148 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
Element: Accounting Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
GL146 GL148
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-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
GL146 GL148
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-SUB-ACCOUNT
Element: Subaccount		Numeric 4
This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.
GL146 GL148
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-SOURCE-CODE
Element: Source Code		Alpha 2
A two-character code assigned to a transaction to identify where the transaction was created.
GL146 GL148
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-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the system creation date.
GL146 GL148
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
Element: Reference		Alpha 10 (Lower Case)
The reference number associated with the transaction.
GL146 GL148
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-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the transaction description.
GL146 GL148
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
Element: Short Description		Derived
Contains the short description.
GLT-BASE-AMOUNT
Element: Base Amount		Signed 18.2
The company base amount.
GL146 GL148
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
Base Number of
Decimals		Numeric 1
The number of decimal positions defined for the company base currency.
GL146 GL148
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-UNITS-AMOUNT
Element: Units Amount		Signed 15.2
Contains the units amount associated with the transaction.
GL146 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.5
GL90.6 IFGT.1
GLT-AUTO-REV
Element: Auto Reverse		Alpha 1
When the Auto Reversal field is set to "Y," the Lawson General Ledger Closing program (GL199) creates an opposite entry for this transaction in the next period. Y = Yes N = No
GL146 GL148
GL167 GL190
GL191 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TO-COMPANY
Element: To Company		Numeric 4
The company number to which the transaction line is posted.
GL110 GL146
GL148 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-BASE-ZONE
Element: Base Zone		Alpha 15
A zone identifies a group of accounting units that stay in balance when transactions pass between defined zone areas.
GL146 GL148
GL167 GL190
GL191 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-POSTING-DATE
Element: Posting Date		Numeric 8 (yyyymmdd)
The date assigned to the journal entry for posting.
GL146 GL148
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-ACTIVITY
Element: Activity		Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
GL146 GL148
GL190 GL191
GL197 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 MM280
GLT-ACCT-CATEGORY
Element: Account Category		Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are 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. Valid account category types are: cost revenue accrual pass thru
GL146 GL148
GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
MM280
GLT-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
GL146 GL148
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-BASERATE
Element: Base Rate		Signed 14.7
The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.
GL146 GL148
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-TRAN-AMOUNT
Element: Transaction Amount		Signed 18.2
The amount in the transaction currency.
GL146 GL148
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
Transaction Number
of Decimals		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-ACCT-CURRENCY
Element: Account Currency		Alpha 5
The account currency code.
GL146 GL167
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
Element: Account Rate		Signed 14.7
The account exchange rate.
GL146 GL167
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
Element: Account Amount		Signed 18.2
The account amount.
GL146 GL167
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
Account Number of
Decimals		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL146 GL167
GL190 GL191
GL196 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-ORIG-COMPANY
Element: Originating Company		Numeric 4
The originating company number.
GL110 GL146
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
Element: Originating Program		Alpha 5
The system code where the transaction was originally created.
GL146 GL148
GL167 GL191
GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login ID of the person who entered the record.
GL146 GL148
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-TO-BASE-AMT
Element: To Base Amount		Signed 18.2
To company base amount.
GL146 GL148
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
To Base Number of
Decimals		Numeric 1
To company base number of decimals.
GL146 GL148
GL197 GL240
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-TO-BASERATE
Element: To Base Rate		Signed 14.7
To company base rate.
GL146 GL148
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-TO-BASE-CURR
Element: To Base Currency		Alpha 5
To company base currency.
GL146 GL148
GL167 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-RECONCILE
Element: Reconcile		Alpha 2
Indicates the reconciliation of transactions.
GL199 GL290
GL40.6 GL500
GL90.4
GLT-NEGATIVE-ADJ
Element: Negative Adj		Alpha 1
Indicates a negative adjustment. Y = Yes N = No
GL146 GL148
GL167 GL190
GL196 GL197
GL290 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GLT-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
The effective date of the transaction. Used for calculating average daily balances.
GL146 GL148
GL167 GL190
GL191 GL197
GL199 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-UPDATE-DATE
Element: Update Date		Numeric 8 (yyyymmdd)
This field contains the date the record was posted. Used by Average Daily Balance to track day-to-day activity changes.
GL146 GL190
GL197 GL199
GL290 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLT-SEQ-TRNS-NBR
Sequence
Transaction Number		Numeric 10
Contains the journal entry transaction sequence number.
GL146 GL147
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLT-JBK-TRNS-NBR
Journal Book Trans
Nbr		Numeric 10
Contains the journal book transaction number.
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLT-CONSOL-AC-FLAG
Element: Consol Ac Flag		Alpha 1
This field indicates whether the 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
" " = No
GL110 GL500
IFGT.1
GLT-CT-FR-COMPANY
Element: Company		Numeric 4
This is the company whose currency was converted using GL195 or GL135.
GL500 IFGT.1
GLT-RPT-AMOUNT-1
Element: Intl Amt		Signed 18.2
Non-base currency amount. The report currency is set up in GL10.
GL146 GL148
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
Element: Curr Rate		Signed 14.7
The currency rate.
GL146 GL148
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
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL146 GL148
GL167 GL190
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
Element: Intl Amt		Signed 18.2
Non-base currency amount. The report currency is set up in GL10.
GL146 GL148
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
Element: Curr Rate		Signed 14.7
The currency rate.
GL146 GL148
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
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL146 GL148
GL167 GL190
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
FISCAL-YEAR
ACCT-PERIOD
CONTROL-GROUP
SYSTEM
JE-TYPE
JE-SEQUENCE
LINE-NBR
...
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 GL110
GL145 GL146
GL167 GL170
GL190 GL191
GL197 GL199
GLTSET2 TO-COMPANY
FISCAL-YEAR
ACCT-PERIOD
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
POSTING-DATE
SYSTEM
CONTROL-GROUP
JE-TYPE
LINE-NBR
COMPANY
JE-SEQUENCE
KeyChange, Subset
WhereSTATUS !=8
GL120 GL135
GL147 GL199
GL256 GL290
GL325 GL327
GLTSET3 TO-COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
CONTROL-GROUP
JE-TYPE
JE-SEQUENCE
LINE-NBR
COMPANY
KeyChange, Subset
WhereSTATUS !=8
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL235 GL298
GL299 GL326
GL328 GL90.1
GL90.2 GL90.4
GL90.5 GL90.6
GL90.7 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GLTSET6 TO-COMPANY
FISCAL-YEAR
ACCT-PERIOD
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
OBJ-ID
KeyChange, Subset
WhereSTATUS !=8
GL256 GL290
GLTSET7 OBJ-ID
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL146 GL147
GL190 GL197
GL256 GL298
GL299 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL90.6 GL94.1
GL94.2 GL94.3
GLTSET8 COMPANY
VAR-LEVELS
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
OBJ-ID
KeyChange, Subset
WhereSTATUS =1
...
AP125 AP126
AP131 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
AP30.4 AP520
API1.1 API2.1
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
CB30.1 CB45.1


GLTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
Glnames GLNAMES Required
GLT-TO-COMPANY->GLN-COMPANY
GLT-ACCT-UNIT->GLN-ACCT-UNIT
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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Achistdtl ACHISTDTL
GLT-OBJ-ID->HDT-GLT-OBJ-ID
  HDT-OBJ-ID
  HDT-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
Fbbatrans FBBATRANS
GLT-OBJ-ID->FBT-GLT-OBJ-ID
  FBT-UNIQUE-I-D
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
Glhiscomx GLHISCOMX
"Y"->GHX-SYS-OBJ-TYPE
GLT-OBJ-ID->GHX-SYS-OBJ-ID
  GHX-UNIQUE-I-D
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

File created: Wed Jun 08 20:48:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.