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
| 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. |
|
||||||||||||||||||||||||||||
| GLT-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||||||||||||||||||||||||||
| GLT-ACCT-PERIOD Element: Accounting Period | Numeric 2 This is the current accounting period. This field is updated by GL199 (Period Closing). 01 13 |
|
||||||||||||||||||||||||||||
| GLT-CONTROL-GROUP Element: Control Group | Numeric 8 This field displays the journal entry number used for process control of the journal entry detail. |
|
||||||||||||||||||||||||||||
| 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.) |
|
||||||||||||||||||||||||||||
| 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 |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| GLT-LINE-NBR Element: Line Number | Numeric 6 This field contains the line number. |
|
||||||||||||||||||||||||||||
| GLT-OBJ-ID Element: Object ID | Numeric 12 Contains the object ID sequence number. Ensures that the subsystem transaction is sent to General Ledger. |
|
||||||||||||||||||||||||||||
| GLT-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. 0 = Unrel 1 = Rel 5 = ERROR 8 = Memo 9 = Hist |
|
||||||||||||||||||||||||||||
| GLT-VAR-LEVELS Element: Variable Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| GLT-SOURCE-CODE Element: Source Code | Alpha 2 A two-character code assigned to a transaction to identify where the transaction was created. |
|
||||||||||||||||||||||||||||
| GLT-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the system creation date. |
|
||||||||||||||||||||||||||||
| GLT-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference number associated with the transaction. |
|
||||||||||||||||||||||||||||
| GLT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains the transaction description. |
|
||||||||||||||||||||||||||||
| GLT-SHORT-DESC Element: Short Description | Derived Contains the short description. |
|
||||||||||||||||||||||||||||
| GLT-BASE-AMOUNT Element: Base Amount | Signed 18.2 The company base amount. |
|||||||||||||||||||||||||||||
| GLT-BASE-ND Base Number of Decimals | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||||||||||||||||||||||
| GLT-UNITS-AMOUNT Element: Units Amount | Signed 15.2 Contains the units amount associated with the transaction. |
|
||||||||||||||||||||||||||||
| 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 |
|
||||||||||||||||||||||||||||
| GLT-TO-COMPANY Element: To Company | Numeric 4 The company number to which the transaction line is posted. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| GLT-POSTING-DATE Element: Posting Date | Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| 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 |
|
||||||||||||||||||||||||||||
| GLT-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.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. |
|
||||||||||||||||||||||||||||
| GLT-TRAN-AMOUNT Element: Transaction Amount | Signed 18.2 The amount in the transaction currency. |
|
||||||||||||||||||||||||||||
| GLT-TRAN-ND Transaction Number of Decimals | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||
| GLT-ACCT-CURRENCY Element: Account Currency | Alpha 5 The account currency code. |
|
||||||||||||||||||||||||||||
| GLT-ACCT-RATE Element: Account Rate | Signed 14.7 The account exchange rate. |
|
||||||||||||||||||||||||||||
| GLT-ACCT-AMOUNT Element: Account Amount | Signed 18.2 The account amount. |
|
||||||||||||||||||||||||||||
| GLT-ACCT-ND Account Number of Decimals | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||
| GLT-ORIG-COMPANY Element: Originating Company | Numeric 4 The originating company number. |
|
||||||||||||||||||||||||||||
| GLT-ORIG-PROGRAM Element: Originating Program | Alpha 5 The system code where the transaction was originally created. |
|
||||||||||||||||||||||||||||
| GLT-OPERATOR Element: Operator | Alpha 10 This field is used to store the login ID of the person who entered the record. |
|
||||||||||||||||||||||||||||
| GLT-TO-BASE-AMT Element: To Base Amount | Signed 18.2 To company base amount. |
|
||||||||||||||||||||||||||||
| GLT-TO-BASE-ND To Base Number of Decimals | Numeric 1 To company base number of decimals. |
|
||||||||||||||||||||||||||||
| GLT-TO-BASERATE Element: To Base Rate | Signed 14.7 To company base rate. |
|
||||||||||||||||||||||||||||
| GLT-TO-BASE-CURR Element: To Base Currency | Alpha 5 To company base currency. |
|
||||||||||||||||||||||||||||
| GLT-RECONCILE Element: Reconcile | Alpha 2 Indicates the reconciliation of transactions. |
|
||||||||||||||||||||||||||||
| GLT-NEGATIVE-ADJ Element: Negative Adj | Alpha 1 Indicates a negative adjustment. Y = Yes N = No |
|
||||||||||||||||||||||||||||
| GLT-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) The effective date of the transaction. Used for calculating average daily balances. |
|
||||||||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||||||||
| GLT-SEQ-TRNS-NBR Sequence Transaction Number | Numeric 10 Contains the journal entry transaction sequence number. |
|
||||||||||||||||||||||||||||
| GLT-JBK-TRNS-NBR Journal Book Trans Nbr | Numeric 10 Contains the journal book transaction number. |
|
||||||||||||||||||||||||||||
| 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 |
|
||||||||||||||||||||||||||||
| GLT-CT-FR-COMPANY Element: Company | Numeric 4 This is the company whose currency was converted using GL195 or GL135. |
|
||||||||||||||||||||||||||||
| GLT-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 Non-base currency amount. The report currency is set up in GL10. |
|
||||||||||||||||||||||||||||
| GLT-RPT-RATE-1 Element: Curr Rate | Signed 14.7 The currency rate. |
|
||||||||||||||||||||||||||||
| GLT-RPT-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||
| GLT-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 Non-base currency amount. The report currency is set up in GL10. |
|
||||||||||||||||||||||||||||
| GLT-RPT-RATE-2 Element: Curr Rate | Signed 14.7 The currency rate. |
|
||||||||||||||||||||||||||||
| GLT-RPT-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GLTSET1 |
COMPANY FISCAL-YEAR ACCT-PERIOD CONTROL-GROUP SYSTEM JE-TYPE JE-SEQUENCE LINE-NBR |
|
| ||||||||||||||||||||||||||||||||||||
| GLTSET2 |
TO-COMPANY FISCAL-YEAR ACCT-PERIOD ACCT-UNIT ACCOUNT SUB-ACCOUNT POSTING-DATE SYSTEM CONTROL-GROUP JE-TYPE LINE-NBR COMPANY JE-SEQUENCE |
|
| ||||||||||||||||||||||||||||||||||||
| GLTSET3 |
TO-COMPANY ACCOUNT SUB-ACCOUNT ACCT-UNIT FISCAL-YEAR ACCT-PERIOD SYSTEM CONTROL-GROUP JE-TYPE JE-SEQUENCE LINE-NBR COMPANY |
|
|||||||||||||||||||||||||||||||||||||
| GLTSET6 |
TO-COMPANY FISCAL-YEAR ACCT-PERIOD ACCOUNT SUB-ACCOUNT ACCT-UNIT OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
| GLTSET7 |
OBJ-ID |
|
|||||||||||||||||||||||||||||||||||||
| GLTSET8 |
COMPANY VAR-LEVELS ACCT-UNIT ACCOUNT SUB-ACCOUNT FISCAL-YEAR ACCT-PERIOD SYSTEM OBJ-ID |
|
|||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Account | GLMASTER |
Required
| |||||||||||||||||||||
| Activity | ACACTIVITY |
Not Required
| |||||||||||||||||||||
| Category 1 | GLSCCAT |
Not Required
| |||||||||||||||||||||
| Category 3 | GLSCCAT |
Not Required
| |||||||||||||||||||||
| Categroy 2 | GLSCCAT |
Not Required
| |||||||||||||||||||||
| Chart Detail | GLCHARTDTL |
Not Required
| |||||||||||||||||||||
| Company | GLSYSTEM |
Required
| |||||||||||||||||||||
| Cuamountx 3 | CUAMOUNTX |
Not Required
| |||||||||||||||||||||
| Cuamountx 4 | CUAMOUNTX |
Not Required
| |||||||||||||||||||||
| Fbfunddtl | FBFUNDDTL |
Required
| |||||||||||||||||||||
| Glamountsx | GLAMOUNTSX |
Not Required
| |||||||||||||||||||||
| Glcondrill | GLCONDRILL |
Required
| |||||||||||||||||||||
| Glcontrol | GLCONTROL |
Required
| |||||||||||||||||||||
| Glholdcode | GLHOLDCODE |
Not Required
| |||||||||||||||||||||
| Glnames | GLNAMES |
Required
| |||||||||||||||||||||
| Glsegblock | GLSEGBLOCK |
Not Required
| |||||||||||||||||||||
| Glsrccode | GLSRCCODE |
Required
| |||||||||||||||||||||
| Glsystem | GLSYSTEM |
Required
| |||||||||||||||||||||
| Rjbridge | RJBRIDGE |
Not Required
| |||||||||||||||||||||
| Rjcontrol | RJCONTROL |
Not Required
| |||||||||||||||||||||
| Rjcontrol Intf | RJCONTROL |
Not Required
| |||||||||||||||||||||
| Source Code | GLCODES |
Not Required
| |||||||||||||||||||||
| To Company | GLSYSTEM |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acdefrev | ACDEFREV |
| ||||||||||||||||||||||||||||||||||||
| Achistdtl | ACHISTDTL |
| ||||||||||||||||||||||||||||||||||||
| Acmntschx | ACMNTSCHX |
| ||||||||||||||||||||||||||||||||||||
| Acpmhstdtl | ACPMHSTDTL |
| ||||||||||||||||||||||||||||||||||||
| Actrans | ACTRANS |
| ||||||||||||||||||||||||||||||||||||
| Amtrans | AMTRANS |
| ||||||||||||||||||||||||||||||||||||
| Apapdhist | APAPDHIST |
| ||||||||||||||||||||||||||||||||||||
| Apdistrib | APDISTRIB |
| ||||||||||||||||||||||||||||||||||||
| Apdrftdist | APDRFTDIST |
| ||||||||||||||||||||||||||||||||||||
| Ardistrib Det | ARDISTRIB |
| ||||||||||||||||||||||||||||||||||||
| Caheader | CAHEADER |
| ||||||||||||||||||||||||||||||||||||
| Cbdistrib | CBDISTRIB |
| ||||||||||||||||||||||||||||||||||||
| Eedistrib | EEDISTRIB |
| ||||||||||||||||||||||||||||||||||||
| Fbbatrans | FBBATRANS |
| ||||||||||||||||||||||||||||||||||||
| Fbdetail | FBDETAIL |
| ||||||||||||||||||||||||||||||||||||
| Glcommit | GLCOMMIT |
| ||||||||||||||||||||||||||||||||||||
| Glcommitx | GLCOMMITX |
| ||||||||||||||||||||||||||||||||||||
| Glhiscomx | GLHISCOMX |
| ||||||||||||||||||||||||||||||||||||
| Glsccat | GLSCCAT |
| ||||||||||||||||||||||||||||||||||||
| Gltrans | GLTRANS |
| ||||||||||||||||||||||||||||||||||||
| Gtmxvalue | GTMXVALUE |
Delete Cascades
| ||||||||||||||||||||||||||||||||||||
| Icmmdist | MMDIST |
| ||||||||||||||||||||||||||||||||||||
| Oedist | OEDIST |
| ||||||||||||||||||||||||||||||||||||
| Pommdist | MMDIST |
| ||||||||||||||||||||||||||||||||||||
| Pornimmdist | MMDIST |
| ||||||||||||||||||||||||||||||||||||
| Prdistrib | PRDISTRIB |
| ||||||||||||||||||||||||||||||||||||
| Sltrans | SLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.