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
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 GL122 GL145 GL170
GL240 GL241 GL256 GL284 GL285 GL286
GL287 GL288 GL289 GL297 GL41.1 GL41.3
JB240 CU01.1 CU01.2 CU02.1 CU02.2 CU03.1
CU10.1 CU10.2 CU20.1 CU20.3 GL00.1 GL00.2
GL00.3 GL00.6 GL00.7 GL00.8 GL00.9 GL02.1
GL02.2 GL02.3 GL02.6 GL03.2 GL03.4 GL10.1
GL121 GL20.1 GL20.2 GL20.4 GL135 GL290
GL325 ML290 GL235 GL326 GL328 PO135
AC191 AC40.4 AC41.4 AC42.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 AP510
AP520 API1.1 API2.1 BR41.4 BR44.1 CB10.1
CB15.1 CB15.2 CB150 CB191 CB20.1 CB222
CB30.1 CB45.1 CB46.1 CB500 CB543 CB544
CB55.1 CB554 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
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 DR100 IC12.1 IC140
IC141 IC142 IC145 IC222 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 EX545
GLRV.1 IFAC.1 IFEB.1 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 ML165 ML65.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 POIK.1 POIM.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830


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
GL90.6 IFGT.1 MM280 MM80.1 MM80.2 GL300
PO278 AD325 GL327 FB11.1 FB111 FB160
FB211 FB296 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL298 GL299 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

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
ML290
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 ML290
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 ML290
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 ML290
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 ML290
GLT-JE-TYPE
Element: Journal Entry Type		Alpha 1
The journal entry type. N = Normal I = Inter-company A = AR Normal R = AR Intercompany
I = 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 ML290
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 ML290
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
ML290
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
ML290
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 ML290
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 ML290
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
ML290
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
ML290
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
ML290
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
ML290
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 ML290
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 ML290
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 ML290
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
ML290
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
ML290
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
ML290
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
ML290
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
ML290
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
ML290
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 ML290
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.
AC145 AC45.1
GL146 GL148
GL190 GL191
GL197 GL290
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 MM280
MM80.1 MM80.2
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
AC145 AC45.1
GL146 GL148
GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
MM280 MM80.1
MM80.2
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 ML290
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 ML290
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
ML290
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 ML290
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 ML290
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
ML290
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
ML290
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 ML290
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 ML290
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
ML290
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 ML290
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
ML290
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 ML290
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 ML290
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
ML290
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 ML290
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 ML290
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
ML290
GLT-CREATED-BY
Element: Operator		Alpha 10
GL110 GL146
GL148 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GLT-LAST-UPDT-DATE
Element: Date		Numeric 8 (yyyymmdd)
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 IFGT.1
MM280 MM80.1
MM80.2
GLT-LAST-UPDT-TIME
Element: Time		Numeric 8
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 IFGT.1
MM280 MM80.1
MM80.2
GLT-LAST-UPDATE-BY
Element: Operator		Alpha 10
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 IFGT.1
MM280 MM80.1
MM80.2


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
...
AC145 AC45.1
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
GL122 GL145
GL146 GL167
GL170 GL190
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
AD325 GL120
GL135 GL147
GL199 GL256
GL290 GL325
GL327 ML290
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
...
AD325 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
GLTSET6 TO-COMPANY
FISCAL-YEAR
ACCT-PERIOD
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
OBJ-ID
KeyChange, Subset
WhereSTATUS !=8
GL256 GL290
ML290
GLTSET7 OBJ-ID
...
AC145 AC45.1
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
GLTSET8 COMPANY
VAR-LEVELS
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
OBJ-ID
KeyChange, Subset
WhereSTATUS =1
...
AC191 AC40.4
AC41.4 AC42.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 AP510
AP520 API1.1
API2.1 BR41.4
BR44.1 CB10.1
GLTSET9 COMPANY
POSTING-DATE
LAST-UPDT-DATE
FISCAL-YEAR
ACCT-PERIOD
CONTROL-GROUP
SYSTEM
JE-TYPE
JE-SEQUENCE
LINE-NBR
KeyChange


GLTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
GLT-TO-COMPANY->GLM-COMPANY (GLMSET2)
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
Gltransbod GLTRANSBOD Not Required, Delete Cascades
GLT-COMPANY->YBZ-COMPANY
GLT-FISCAL-YEAR->YBZ-FISCAL-YEAR
GLT-ACCT-PERIOD->YBZ-ACCT-PERIOD
GLT-CONTROL-GROUP->YBZ-CONTROL-GROUP
GLT-SYSTEM->YBZ-SYSTEM
GLT-JE-TYPE->YBZ-JE-TYPE
GLT-JE-SEQUENCE->YBZ-JE-SEQUENCE
GLT-LINE-NBR->YBZ-LINE-NBR
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
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
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: Thu Jun 09 02:14:13 2016

Home
Contact Us



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