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 GL145 GL170 GL240 GL241 GL256 GL284 GL285 GL286 GL287 GL288 GL289 GL297 GL41.1 GL41.3 JB240 GL10.1 GL135 GL290 GL324 GL325 GL327 GL235 GL326 GL328 GL75.1 UPDATED BY GL110 GL120 GL146 GL167 GL190 GL191 GL196 GL199 GL300 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL90.4 GL951 IFGT.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY GLT-COMPANY Numeric 4 GL110 GL146 Company This is the company into which the GL167 GL190 transactions are to be interfaced. For GL191 GL196 intercompany processing, this field is GL199 GL290 considered the originating company. Must GL40.1 GL40.2 be defined in GLSYSTEM. GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-FISCAL-YEAR Numeric 4 GL146 GL167 Fiscal Year This is the current fiscal year. This GL190 GL191 field is updated by GL199 (Period GL196 GL199 Closing). GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACCT-PERIOD Numeric 2 GL146 GL167 Accounting Period This is the current accounting period. GL190 GL191 This field is updated by GL199 (Period GL196 GL199 Closing). GL290 GL40.1 GL40.2 GL40.3 01 GL40.7 GL40.8 13 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-CONTROL-GROUP Numeric 8 GL146 GL167 Control Group This field contains the journal entry GL190 GL191 number used for process control of the GL196 GL199 journal entry detail. GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-SYSTEM Alpha 2 GL146 GL167 System A two-character code representing an GL190 GL191 application used within the Lawson GL196 GL199 system. (i.e.: GL = General Ledger, AP = GL290 GL40.1 Accounts Payable, etc.) GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-JE-TYPE Alpha 1 GL146 GL167 Journal Entry Type The journal entry type. GL190 GL191 N = Normal GL196 GL199 I = Intercompany GL290 GL40.1 A = A/R Normal GL40.2 GL40.3 R = A/R Intercpy GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-JE-TYPE-1 Derived Journal Entry Type The journal entry type. GLT-JE-SEQUENCE Numeric 2 GL146 GL167 Journal Entry The journal entry sequence number. GL190 GL191 Sequence GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-LINE-NBR Numeric 6 GL146 GL167 Line Number This field contains the line number. GL190 GL191 GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-OBJ-ID Numeric 12 GL110 GL146 Object ID Contains the object ID sequence number. GL167 GL190 Ensures that the subsystem transaction GL191 GL196 is sent to the Lawson General Ledger GL199 GL290 system. GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-STATUS Numeric 1 GL146 GL167 Status This field contains the status of the GL190 GL191 transaction. GL196 GL199 0 = Unrel GL290 GL40.7 1 = Rel GL45.1 GL500 5 = ERROR GL951 IFGT.1 8 = Memo 9 = Hist GLT-VAR-LEVELS Alpha 30 GL120 GL146 Variable Levels A level that represents the location of GL167 GL190 an accounting unit in an organization's GL191 GL196 level structure. GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACCT-UNIT Alpha 15 GL146 GL167 Accounting Unit The accounting unit is a shorthand GL190 GL191 notation representing the variable level GL196 GL199 number. When used in the General Ledger GL290 GL40.1 Account Master file, the accounting unit GL40.2 GL40.3 must be defined in the General Ledger GL40.8 GL40.9 Names file as a posting accounting unit. GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACCOUNT Numeric 6 GL146 GL167 Account This field along with the accounting GL190 GL191 unit and subaccount make up the location GL196 GL199 (account) where amounts and other GL290 GL40.1 account information is stored. GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-SUB-ACCOUNT Numeric 4 GL146 GL167 Subaccount This field along with the accounting GL190 GL191 unit and account make up the location GL196 GL199 (account) where amounts and other GL290 GL40.1 account information is stored. GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-SOURCE-CODE Alpha 2 GL146 GL167 Source Code A two-character code assigned to a GL190 GL191 transaction to identify where the GL196 GL199 transaction was created. GL290 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-DATE Numeric 8 (yyyymmdd) GL146 GL167 Date Contains the system creation date. GL190 GL191 GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-REFERENCE Alpha 10 (Lower Case) GL146 GL167 Reference The reference number associated with GL190 GL191 the transaction. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-DESCRIPTION Alpha 30 (Lower Case) GL146 GL167 Description Contains the transaction description. GL190 GL191 GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-SHORT-DESC Derived Short Description Contains the short description. GLT-BASE-AMOUNT Signed 15.2 GL146 GL167 Base Amount The base amount posted to the General GL190 GL191 Ledger Master file. GL196 GL199 GL284 GL285 GL286 GL287 GL289 GL290 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL40.9 GL41.3 GL44.1 GL45.1 GL500 GL90.1 GL90.2 GL90.4 GL951 IFGT.1 GLT-BASE-ND Numeric 1 GL146 GL167 Base Number of The number of decimal positions defined GL190 GL191 Decimals for the company base currency. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-UNITS-AMOUNT Signed 15.2 GL146 GL167 Units Amount Contains the units amount associated GL190 GL191 with the transaction. GL196 GL290 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL40.9 GL41.3 GL44.1 GL45.1 GL500 GL90.1 GL90.2 GL951 IFGT.1 GLT-AUTO-REV Alpha 1 GL146 GL167 Auto Reverse When the Auto Reversal field is set to GL190 GL191 "Y," the Lawson General Ledger Closing GL199 GL290 program (GL199) creates an opposite GL40.1 GL40.2 entry for this transaction in the next GL40.3 GL40.8 period. GL40.9 GL44.1 GL45.1 GL500 Y = Yes GL951 IFGT.1 N = No GLT-YEAR-CODE Alpha 1 GL146 GL167 Year Code Contains the code for the current, GL190 GL191 next, or last year. GL196 GL199 GL40.1 GL40.2 C = Current GL40.3 GL40.7 N = Next GL40.8 GL40.9 L = Last GL44.1 GL45.1 F = Closing GL500 GL951 IFGT.1 GLT-TO-COMPANY Numeric 4 GL110 GL146 To Company The company number to which the GL167 GL190 transaction line is posted. GL191 GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-BASE-ZONE Alpha 15 GL146 GL167 Base Zone The zone within the Lawson General GL190 GL191 Ledger System where the transaction GL290 GL40.1 originating. GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL167 Posting Date The date assigned to the journal entry GL190 GL191 for posting. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACTIVITY Alpha 15 GL146 GL190 Activity Activities are the processes or GL191 GL290 procedures that produce work. Cost GL40.1 GL40.2 objects (products, services, customers, GL40.3 GL40.8 and so on) are the reasons for GL40.9 GL44.1 performing the activity. Activities and GL45.1 GL500 cost object activities are used GL951 IFGT.1 synonymously in the Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two kinds of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries. GLT-ACCT-CATEGORY Alpha 5 GL146 GL191 Account Category Account categories are groupings of GL40.1 GL40.2 costs, revenues, or a combination of GL40.3 GL40.8 both used for reporting and inquiries GL40.9 GL44.1 for activities in the Activity GL45.1 GL500 Management system. All transactions are GL951 IFGT.1 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. GLT-CURRENCY-CODE Alpha 5 GL146 GL167 Currency Code This field contains the company base GL190 GL191 currency code established in GL10.1 GL196 GL199 (Company). GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-BASERATE Signed 12.6 GL146 GL167 Base Rate The exchange rate at the time the GL190 GL191 journal entry was made. If left blank, GL196 GL199 the current exchange rate will default. GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-TRAN-AMOUNT Signed 15.2 GL146 GL167 Transaction Amount This is the amount in transaction GL190 GL191 currency to be posted. This amount GL196 GL199 creates a CUAMOUNT type 1 record. GL290 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL40.9 GL41.3 GL44.1 GL45.1 GL500 GL90.1 GL90.2 GL90.4 GL951 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 GL199 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACCT-CURRENCY Alpha 5 GL146 GL167 Account Currency The account currency code. GL190 GL191 GL196 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACCT-RATE Signed 12.6 GL146 GL167 Account Rate The account exchange rate. GL190 GL191 GL196 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ACCT-AMOUNT Signed 15.2 GL146 GL167 Account Amount The account amount. GL190 GL191 GL196 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL90.1 GL90.2 GL951 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 GL40.1 account currency. GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ORIG-COMPANY Numeric 4 GL110 GL146 Originating Company The originating company number. GL167 GL190 GL196 GL199 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-ORIG-PROGRAM Alpha 5 GL146 GL167 Originating Program The system code where the transaction GL191 GL196 was originally created. GL290 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-OPERATOR Alpha 10 GL146 GL167 Operator This field is used to store the login GL190 GL191 ID of the person who entered the record. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-TO-BASE-AMT Signed 15.2 GL146 GL40.1 To Base Amount To company base amount. GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL40.9 GL41.3 GL44.1 GL45.1 GL500 GL90.2 GL951 IFGT.1 GLT-TO-BASE-ND Numeric 1 GL146 GL240 To Base Number of To company base number of decimals. GL40.1 GL40.2 Decimals GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-TO-BASERATE Signed 12.6 GL146 GL40.1 To Base Rate To company base rate. GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-TO-BASE-CURR Alpha 5 GL146 GL190 To Base Currency To company base currency. GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-RECONCILE Alpha 2 GL290 GL500 Reconcile Indicates the reconciliation of GL90.4 GL951 transactions. GLT-NEGATIVE-ADJ Alpha 1 GL146 GL167 Negative Indicates a negative adjustment. GL190 GL196 Y = - GL199 GL290 N GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-EFFECT-DATE Numeric 8 (yyyymmdd) GL146 GL190 Effecitve Date The effective date of the transaction. GL191 GL199 Used for calculating average daily GL290 GL40.1 balances. GL40.2 GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL951 IFGT.1 GLT-UPDATE-DATE Numeric 8 (yyyymmdd) GL146 GL190 Update This field contains the date the record GL199 GL290 was posted. Used by Average Daily GL45.1 GL500 Balance to track day-to-day activity GL951 changes. GLT-SEQ-TRNS-NBR Numeric 10 GL146 GL190 Sequence Contains the journal entry transaction GL199 GL45.1 Transaction Number sequence number. GL500 GL951 GLT-JBK-TRNS-NBR Numeric 10 GL146 GL190 Journal Book Trans Contains the journal book transaction GL199 GL45.1 Nbr number. GL500 GL951 GLT-CONSOL-AC-FLAG Alpha 1 GL110 GL500 Consol Activity This 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 IFGT.1 From Company This is the company whose currency was converted using GL195 or GL135. GLT-RPT-AMOUNT-1 Signed 15.2 GL146 GL167 Report Currency 1 The transaction amount for Report GL190 GL191 Amount Currency 1. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL90.1 GL90.2 GL90.4 IFGT.1 GLT-RPT-RATE-1 Signed 12.6 GL146 GL190 Exchange Rate The exchange rate to convert the GL191 GL199 transaction amount to Report Currency 1. GL290 GL40.1 The exchange rate is defined in CU10.1 GL40.2 GL40.3 (Exchange Rate). GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 IFGT.1 GLT-RPT-ND-1 Numeric 1 GL146 GL167 Report Currency 1 The number of decimal positions for GL190 GL191 Code Report Currency 1. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 IFGT.1 GLT-RPT-AMOUNT-2 Signed 15.2 GL146 GL167 Report Currency 2 The transaction amount for Report GL190 GL191 Amount Currency 2. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL90.1 GL90.2 GL90.4 IFGT.1 GLT-RPT-RATE-2 Signed 12.6 GL146 GL190 Exchange Rate The exchange rate to convert the GL191 GL199 transaction amount to Report Currency 2. GL290 GL40.1 The exchange rate is defined in CU10.1 GL40.2 GL40.3 (Exchange Rate). GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 IFGT.1 GLT-RPT-ND-2 Numeric 1 GL146 GL167 Report Currency 2 The number of decimal positions for GL190 GL191 Code Report Currency 2. GL196 GL199 GL290 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1 GL45.1 GL500 IFGT.1 GLTRANS FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN GLTSET1 COMPANY GL110 GL145 FISCAL-YEAR GL146 GL170 ACCT-PERIOD GL190 GL199 CONTROL-GROUP GL240 GL241 SYSTEM GL256 GL284 JE-TYPE GL285 GL286 JE-SEQUENCE GL287 GL288 LINE-NBR GL289 GL297 GL300 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL40.9 GL41.1 GL41.3 GL44.1 GL45.1 GL500 GL90.4 ... GLTSET2 TO-COMPANY KeyChange, Subset GL120 GL135 FISCAL-YEAR Where STATUS != 8 GL199 GL256 ACCT-PERIOD GL290 GL324 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 FISCAL-YEAR ACCT-PERIOD SYSTEM CONTROL-GROUP JE-TYPE JE-SEQUENCE LINE-NBR COMPANY GLTSET4 CT-FR-COMPANY KeyChange, Duplicates, Subset FISCAL-YEAR Where CT-FR-COMPANY != Zeroes ACCT-PERIOD And SOURCE-CODE = "CH" ACCT-UNIT ACCOUNT SUB-ACCOUNT POSTING-DATE SYSTEM CONTROL-GROUP JE-TYPE LINE-NBR COMPANY JE-SEQUENCE GLTSET6 TO-COMPANY KeyChange, Subset GL256 GL290 FISCAL-YEAR Where STATUS != 8 ACCT-PERIOD ACCOUNT SUB-ACCOUNT ACCT-UNIT OBJ-ID GLTSET7 OBJ-ID GL146 GL170 GL190 GL256 GL45.1 GL75.1 IFGT.1 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 Glamountsx GLAMOUNTSX 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 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-ORIG-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 GLSRCCODE Not Required GLT-SOURCE-CODE -> GSR-SOURCE-CODE 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 Apdistrib APDISTRIB Valid When GLT-SYSTEM = "AP" And GLT-SOURCE-CODE != "BE" GLT-TO-COMPANY -> APD-DIST-COMPANY GLT-ACCT-UNIT -> APD-DIS-ACCT-UNIT GLT-ACCOUNT -> APD-DIS-ACCOUNT GLT-SUB-ACCOUNT -> APD-DIS-SUB-ACCT GLT-POSTING-DATE -> APD-DISTRIB-DATE 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 Ardistrib Sum 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 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-SEQ-NBR Comments GLCOMMENT GLT-COMPANY -> GCM-COMPANY "J" -> GCM-RECORD-TYPE GLT-SYSTEM -> GCM-SYSTEM GLT-FISCAL-YEAR -> GCM-FISCAL-YEAR GLT-ACCT-PERIOD -> GCM-ACCT-PERIOD GLT-CONTROL-GROUP -> GCM-CONTROL-GROUP GLT-JE-TYPE -> GCM-JE-TYPE GLT-JE-SEQUENCE -> GCM-JE-SEQUENCE GCM-SEQUENCE-NBR Eedistrib EEDISTRIB GLT-TO-COMPANY -> EED-DIST-COMPANY GLT-ACCT-UNIT -> EED-EXP-ACCT-UNIT GLT-ACCOUNT -> EED-EXP-ACCOUNT GLT-SUB-ACCOUNT -> EED-EXP-SUB-ACCT GLT-POSTING-DATE -> EED-DISTRIB-DATE GLT-OBJ-ID -> EED-GLT-OBJ-ID EED-COMPANY EED-VENDOR EED-EXPENSE-NBR EED-SEQ-NBR 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-NBR 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-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ Prdistrib PRDISTRIB GLT-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 |