GLTRANS – General Ledger Transactions

System
General Ledger (GL)
Prefix
GLT
Primary key
COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR
Fields
62
Updated by
88 programs
Referenced by
345 programs

GLTRANS is the General Ledger Transactions table in Lawson General Ledger (prefix GLT). It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR (GLTSET1); alternate indexes: GLTSET2, GLTSET3, GLTSET6, GLTSET7, GLTSET8 and GLTSET9. It is related 1:1 to GLMASTER, ACACTIVITY, GLSCCAT, GLCHARTDTL, GLSYSTEM, CUAMOUNTX, FBFUNDDTL, GLAMOUNTSX and 10 more and 1:M to ACDEFREV, ACHISTDTL, ACMNTSCHX, ACPMHSTDTL, ACTRANS, AMTRANS, APAPDHIST, APDISTRIB and 17 more. It is updated by AC145, AC45.1, AD325, FB11.1, FB111, FB160, FB211, FB296 and 80 more and referenced by AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 and 337 more. The table has 62 fields, 7 indexes and 51 documented relations.

About GLTRANS

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.

Fields (62)

Column = COBOL field name without the GLT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GLT-COMPANY PK
COMPANY
Numeric 4This 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 +13 more
GLT-FISCAL-YEAR PK
FISCAL_YEAR
Numeric 4Contains the fiscal year for the data stored on this record.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-ACCT-PERIOD PK
ACCT_PERIOD
Numeric 2This is the current accounting period. This field is updated by GL199 (Period Closing). 01 13GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-CONTROL-GROUP PK
CONTROL_GROUP
Numeric 8This field displays the journal entry number used for process control of the journal entry detail.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-SYSTEM PK
SYSTEM
Alpha 2A 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 +12 more
GLT-JE-TYPE PK
JE_TYPE
Alpha 1The journal entry type. N = Normal I = Inter-company
  • A AR Normal R = AR Intercompany
  • I Intercompany
GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-JE-TYPE-1
JE_TYPE_1
DerivedThe journal entry type.
GLT-JE-SEQUENCE PK
JE_SEQUENCE
Numeric 2The journal entry sequence number.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +11 more
GLT-OBJ-ID
OBJ_ID
Numeric 12Contains the object ID sequence number. Ensures that the subsystem transaction is sent to General Ledger.GL110, GL146, GL148, GL167, GL190, GL191, GL196, GL197 +13 more
GLT-STATUS
STATUS
Numeric 1This 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 +12 more
GLT-VAR-LEVELS
VAR_LEVELS
Alpha 30A level that represents the location of an accounting unit in an organization's level structure.GL120, GL146, GL148, GL167, GL190, GL191, GL196, GL197 +12 more
GLT-ACCT-UNIT
ACCT_UNIT
Alpha 15The 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 +11 more
GLT-ACCOUNT
ACCOUNT
Numeric 6This 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 +11 more
GLT-SUB-ACCOUNT
SUB_ACCOUNT
Numeric 4This 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 +11 more
GLT-SOURCE-CODE
SOURCE_CODE
Alpha 2A two-character code assigned to a transaction to identify where the transaction was created.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +11 more
GLT-DATE
DATE
Numeric 8 (yyyymmdd)Contains the system creation date.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-REFERENCE
REFERENCE
Alpha 10 (Lower Case)The reference number associated with the transaction.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)Contains the transaction description.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-SHORT-DESC
SHORT_DESC
DerivedContains the short description.
GLT-BASE-AMOUNT
BASE_AMOUNT
Signed 18.2The company base amount.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +23 more
GLT-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +11 more
GLT-UNITS-AMOUNT
UNITS_AMOUNT
Signed 15.2Contains the units amount associated with the transaction.GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL290 +17 more
GLT-AUTO-REV
AUTO_REV
Alpha 1When 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 +11 more
GLT-TO-COMPANY
TO_COMPANY
Numeric 4The company number to which the transaction line is posted.GL110, GL146, GL148, GL167, GL190, GL191, GL196, GL197 +13 more
GLT-BASE-ZONE
BASE_ZONE
Alpha 15A 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 +9 more
GLT-POSTING-DATE
POSTING_DATE
Numeric 8 (yyyymmdd)The date assigned to the journal entry for posting.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-ACTIVITY
ACTIVITY
Alpha 15Activities 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 +12 more
GLT-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5Account 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 thruAC145, AC45.1, GL146, GL148, GL190, GL191, GL197, GL40.1 +11 more
GLT-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-BASERATE
BASERATE
Signed 14.7The 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 +12 more
GLT-TRAN-AMOUNT
TRAN_AMOUNT
Signed 18.2The amount in the transaction currency.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +19 more
GLT-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +8 more
GLT-ACCT-CURRENCY
ACCT_CURRENCY
Alpha 5The account currency code.GL146, GL167, GL190, GL191, GL196, GL197, GL290, GL40.1 +10 more
GLT-ACCT-RATE
ACCT_RATE
Signed 14.7The account exchange rate.GL146, GL167, GL190, GL191, GL196, GL197, GL290, GL40.1 +10 more
GLT-ACCT-AMOUNT
ACCT_AMOUNT
Signed 18.2The account amount.GL146, GL167, GL190, GL191, GL196, GL197, GL290, GL40.1 +13 more
GLT-ACCT-ND
ACCT_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL146, GL167, GL190, GL191, GL196, GL197, GL40.1, GL40.2 +7 more
GLT-ORIG-COMPANY
ORIG_COMPANY
Numeric 4The originating company number.GL110, GL146, GL148, GL167, GL190, GL191, GL196, GL197 +10 more
GLT-ORIG-PROGRAM
ORIG_PROGRAM
Alpha 5The system code where the transaction was originally created.GL146, GL148, GL167, GL191, GL196, GL197, GL290, GL40.1 +9 more
GLT-OPERATOR
OPERATOR
Alpha 10This field is used to store the login ID of the person who entered the record.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +12 more
GLT-TO-BASE-AMT
TO_BASE_AMT
Signed 18.2To company base amount.GL146, GL148, GL197, GL40.1, GL40.2, GL40.3, GL40.5, GL40.6 +8 more
GLT-TO-BASE-ND
TO_BASE_ND
Numeric 1To company base number of decimals.GL146, GL148, GL197, GL240, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
GLT-TO-BASERATE
TO_BASERATE
Signed 14.7To company base rate.GL146, GL148, GL197, GL40.1, GL40.2, GL40.3, GL40.6, GL40.7 +5 more
GLT-TO-BASE-CURR
TO_BASE_CURR
Alpha 5To company base currency.GL146, GL148, GL167, GL190, GL197, GL40.1, GL40.2, GL40.3 +7 more
GLT-RECONCILE
RECONCILE
Alpha 2Indicates the reconciliation of transactions.GL199, GL290, GL40.6, GL500, GL90.4, ML290
GLT-NEGATIVE-ADJ
NEGATIVE_ADJ
Alpha 1Indicates a negative adjustment.
  • Y Yes
  • N No
GL146, GL148, GL167, GL190, GL196, GL197, GL290, GL40.1 +9 more
GLT-EFFECT-DATE
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 +10 more
GLT-UPDATE-DATE
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 +7 more
GLT-SEQ-TRNS-NBR
SEQ_TRNS_NBR
Numeric 10Contains the journal entry transaction sequence number.GL146, GL147, GL190, GL197, GL199, GL40.1, GL40.2, GL40.3 +5 more
GLT-JBK-TRNS-NBR
JBK_TRNS_NBR
Numeric 10Contains the journal book transaction number.GL146, GL190, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.7 +4 more
GLT-CONSOL-AC-FLAG
CONSOL_AC_FLAG
Alpha 1This 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 " " = NoGL110, GL500, IFGT.1
GLT-CT-FR-COMPANY
CT_FR_COMPANY
Numeric 4This is the company whose currency was converted using GL195 or GL135.GL500, IFGT.1
GLT-RPT-AMOUNT-1
RPT_AMOUNT_1
Signed 18.2Non-base currency amount. The report currency is set up in GL10.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +18 more
GLT-RPT-RATE-1
RPT_RATE_1
Signed 14.7The currency rate.GL146, GL148, GL167, GL190, GL191, GL197, GL199, GL290 +12 more
GLT-RPT-ND-1
RPT_ND_1
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +13 more
GLT-RPT-AMOUNT-2
RPT_AMOUNT_2
Signed 18.2Non-base currency amount. The report currency is set up in GL10.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +18 more
GLT-RPT-RATE-2
RPT_RATE_2
Signed 14.7The currency rate.GL146, GL148, GL167, GL190, GL191, GL197, GL199, GL290 +12 more
GLT-RPT-ND-2
RPT_ND_2
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL146, GL148, GL167, GL190, GL191, GL196, GL197, GL199 +13 more
GLT-CREATED-BY
CREATED_BY
Alpha 10GL110, GL146, GL148, GL167, GL190, GL191, GL196, GL197 +11 more
GLT-LAST-UPDT-DATE
LAST_UPDT_DATE
Numeric 8 (yyyymmdd)AC145, AC45.1, GL110, GL120, GL146, GL147, GL148, GL167 +19 more
GLT-LAST-UPDT-TIME
LAST_UPDT_TIME
Numeric 8AC145, AC45.1, GL110, GL120, GL146, GL147, GL148, GL167 +19 more
GLT-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10AC145, AC45.1, GL110, GL120, GL146, GL147, GL148, GL167 +19 more

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLTSET1COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBRPrimaryAC145, AC45.1, CA195, FB100, FB101, FB120, FB121, FB122 +22 more (list truncated in source)
GLTSET2TO-COMPANY, FISCAL-YEAR, ACCT-PERIOD, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, POSTING-DATE, SYSTEM, CONTROL-GROUP, JE-TYPE, LINE-NBR, COMPANY, JE-SEQUENCEKeyChange, SubsetWhere STATUS != 8AD325, GL120, GL135, GL147, GL199, GL256, GL290, GL325 +2 more
GLTSET3TO-COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, CONTROL-GROUP, JE-TYPE, JE-SEQUENCE, LINE-NBR, COMPANYKeyChange, SubsetWhere STATUS != 8AD325, FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1 +22 more (list truncated in source)
GLTSET6TO-COMPANY, FISCAL-YEAR, ACCT-PERIOD, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, OBJ-IDKeyChange, SubsetWhere STATUS != 8GL256, GL290, ML290
GLTSET7OBJ-IDAC145, AC45.1, FB11.1, FB111, FB160, FB211, FB296, FB60.1 +22 more (list truncated in source)
GLTSET8COMPANY, VAR-LEVELS, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, OBJ-IDKeyChange, SubsetWhere STATUS = 1AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)
GLTSET9COMPANY, POSTING-DATE, LAST-UPDT-DATE, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBRKeyChange

Relations

One to one (24) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredGLT-TO-COMPANYGLM-COMPANY (GLMSET2), GLT-ACCT-UNITGLM-ACCT-UNIT, GLT-ACCOUNTGLM-ACCOUNT, GLT-SUB-ACCOUNTGLM-SUB-ACCOUNT
ActivityACACTIVITYNot RequiredGLT-ACTIVITYACV-ACTIVITY
Category 1GLSCCATNot RequiredGLT-SOURCE-CODEGSC-SOURCE-CODE, 1GSC-SEQ-NBR
Category 3GLSCCATNot RequiredGLT-SOURCE-CODEGSC-SOURCE-CODE, 3GSC-SEQ-NBR
Categroy 2GLSCCATNot RequiredGLT-SOURCE-CODEGSC-SOURCE-CODE, 2GSC-SEQ-NBR
Chart DetailGLCHARTDTLNot RequiredGLS-CHART-NAMEGDT-CHART-NAME, GLT-ACCOUNTGDT-ACCOUNT, GLT-SUB-ACCOUNTGDT-SUB-ACCOUNT
CompanyGLSYSTEMRequiredGLT-COMPANYGLS-COMPANY
Cuamountx 3CUAMOUNTXNot RequiredGLT-COMPANYCAX-COMPANY, 3CAX-AMT-TYPE, GLT-FISCAL-YEARCAX-FISCAL-YEAR, GLT-ACCT-UNITCAX-ACCT-UNIT, GLT-ACCOUNTCAX-ACCOUNT, GLT-SUB-ACCOUNTCAX-SUB-ACCOUNT, GLT-POSTING-DATECAX-DATE
Cuamountx 4CUAMOUNTXNot RequiredGLT-COMPANYCAX-COMPANY, 4CAX-AMT-TYPE, GLT-FISCAL-YEARCAX-FISCAL-YEAR, GLT-ACCT-UNITCAX-ACCT-UNIT, GLT-ACCOUNTCAX-ACCOUNT, GLT-SUB-ACCOUNTCAX-SUB-ACCOUNT, GLT-POSTING-DATECAX-DATE
FbfunddtlFBFUNDDTLRequiredGLT-COMPANYFUD-COMPANY, GLT-ACCOUNTFUD-ACCOUNT, GLT-SUB-ACCOUNTFUD-SUB-ACCOUNT, GLT-ACCT-UNITFUD-ACCT-UNIT
GlamountsxGLAMOUNTSXNot RequiredGLT-COMPANYGAX-COMPANY, GLT-POSTING-DATEGAX-DATE, GLT-ACCT-UNITGAX-ACCT-UNIT, GLT-ACCOUNTGAX-ACCOUNT, GLT-SUB-ACCOUNTGAX-SUB-ACCOUNT
GlcondrillGLCONDRILLRequiredGLT-OBJ-IDGLD-GLT-OBJ-ID
GlcontrolGLCONTROLRequiredGLT-COMPANYGLC-COMPANY, GLT-FISCAL-YEARGLC-FISCAL-YEAR, GLT-ACCT-PERIODGLC-ACCT-PERIOD, GLT-SYSTEMGLC-SYSTEM, GLT-JE-TYPEGLC-JE-TYPE, GLT-CONTROL-GROUPGLC-CONTROL-GROUP, GLT-JE-SEQUENCEGLC-JE-SEQUENCE
GlholdcodeGLHOLDCODENot RequiredGLC-HOLD-CODEGLH-HOLD-CODE
GlnamesGLNAMESRequiredGLT-TO-COMPANYGLN-COMPANY, GLT-ACCT-UNITGLN-ACCT-UNIT
GlsegblockGLSEGBLOCKNot RequiredGLT-OBJ-IDGSB-GLT-OBJ-ID
GlsrccodeGLSRCCODERequiredGLT-SOURCE-CODEGSR-SOURCE-CODE
GlsystemGLSYSTEMRequiredGLT-COMPANYGLS-COMPANY
GltransbodGLTRANSBODNot Required, Delete CascadesGLT-COMPANYYBZ-COMPANY, GLT-FISCAL-YEARYBZ-FISCAL-YEAR, GLT-ACCT-PERIODYBZ-ACCT-PERIOD, GLT-CONTROL-GROUPYBZ-CONTROL-GROUP, GLT-SYSTEMYBZ-SYSTEM, GLT-JE-TYPEYBZ-JE-TYPE, GLT-JE-SEQUENCEYBZ-JE-SEQUENCE, GLT-LINE-NBRYBZ-LINE-NBR
RjbridgeRJBRIDGENot Required"GLTRN"RJB-OBJ-TYPE, GLT-OBJ-IDRJB-OBJ-ID
RjcontrolRJCONTROLNot RequiredGLT-COMPANYRJC-COMPANY, GLT-JE-TYPERJC-JE-TYPE, GLT-CONTROL-GROUPRJC-REC-GROUP
Rjcontrol IntfRJCONTROLNot RequiredGLT-COMPANYRJC-COMPANY, RJB-JE-TYPERJC-JE-TYPE, RJB-REC-GROUPRJC-REC-GROUP
Source CodeGLCODESNot Required"S"GCD-RECORD-TYPE, SpacesGCD-FOLDER-NAME, SpacesGCD-PROCESS-GROUP, GLT-SOURCE-CODEGCD-SYSTEM, ZeroesGCD-COMPANY
To CompanyGLSYSTEMRequiredGLT-TO-COMPANYGLS-COMPANY

One to many (27) — child tables

RelationTableRulesConditionField map
AcdefrevACDEFREVGLT-OBJ-IDDRD-GLT-OBJ-ID, DRD-ATN-OBJ-ID, DRD-CONTRACT, DRD-PRODUCT, DRD-PROD-VERSION, DRD-OBJ-ID, DRD-SEQ-NBR
AchistdtlACHISTDTLGLT-OBJ-IDHDT-GLT-OBJ-ID, HDT-OBJ-ID, HDT-LINE-NBR
AcmntschxACMNTSCHXGLT-OBJ-IDMSD-GLT-OBJ-ID, MSD-ATN-OBJ-ID, MSD-CONTRACT, MSD-MAINT-SCHEDULE, MSD-PRODUCT, MSD-PROD-VERSION, MSD-OBJ-ID, MSD-TRAN-DATE
AcpmhstdtlACPMHSTDTLGLT-OBJ-IDPML-GLT-OBJ-ID, PML-ATN-OBJ-ID, PML-OBJ-ID, PML-LINE-NBR
ActransACTRANSGLT-OBJ-IDATN-GLT-OBJ-ID, ATN-OBJ-ID
AmtransAMTRANSGLT-OBJ-IDAMT-GLT-OBJ-ID, AMT-ASSET, AMT-SEQ-NUMBER
ApapdhistAPAPDHISTGLT-OBJ-IDAH2-GLT-OBJ-ID, AH2-API-OBJ-ID, AH2-DIST-SEQ-NBR
ApdistribAPDISTRIBGLT-OBJ-IDAPD-GLT-OBJ-ID, APD-API-OBJ-ID, APD-DIST-SEQ-NBR
ApdrftdistAPDRFTDISTGLT-TO-COMPANYDDT-DIST-COMPANY, GLT-ACCT-UNITDDT-DST-ACCT-UNIT, GLT-ACCOUNTDDT-DST-ACCOUNT, GLT-SUB-ACCOUNTDDT-DST-SUB-ACCT, GLT-POSTING-DATEDDT-POST-DATE, GLT-OBJ-IDDDT-GLT-OBJ-ID, DDT-BANK-INST-CODE, DDT-TRANS-IDENT, DDT-SEQ-NBR
Ardistrib DetARDISTRIBGLT-COMPANYAMD-GL-COMPANY, GLT-ACCT-UNITAMD-ACCT-UNIT, GLT-ACCOUNTAMD-ACCOUNT, GLT-SUB-ACCOUNTAMD-SUB-ACCT, GLT-POSTING-DATEAMD-GL-DATE, GLT-OBJ-IDAMD-GLT-OBJ-ID, AMD-CREATE-DATE, AMD-CREATE-TIME, AMD-PROG-SEQ-NBR
CaheaderCAHEADERGLT-ORIG-COMPANYCAH-COMPANY, GLT-CONTROL-GROUPCAH-JE-NBR, GLT-JE-TYPECAH-JE-TYPE, CAH-ALLOC-NAME, CAH-ALLOC-TYPE
CbdistribCBDISTRIBGLT-TO-COMPANYCBD-DIST-COMPANY, GLT-ACCT-UNITCBD-DIS-ACCT-UNIT, GLT-ACCOUNTCBD-DIS-ACCOUNT, GLT-SUB-ACCOUNTCBD-DIS-SUB-ACCT, GLT-OBJ-IDCBD-GLT-OBJ-ID, CBD-CASH-CODE, CBD-TRANS-NBR, CBD-BANK-INST-CODE, CBD-DIST-TYPE, CBD-SEQ-NBR, CBD-TRANS-IDENT
EedistribEEDISTRIBGLT-OBJ-IDEED-GLT-OBJ-ID, EED-COMPANY, EED-VENDOR, EED-EXPENSE-NBR, EED-SEQ-NBR
FbbatransFBBATRANSGLT-OBJ-IDFBT-GLT-OBJ-ID, FBT-UNIQUE-I-D
FbdetailFBDETAILGLT-COMPANYFBD-COMPANY, GLT-ACCT-UNITFBD-ACCT-UNIT, GLT-ACCOUNTFBD-ACCOUNT, GLT-SUB-ACCOUNTFBD-SUB-ACCOUNT, FBD-BUDGET-NBR, FBD-FISCAL-YEAR
GlcommitGLCOMMITGLT-COMPANYGOT-COMPANY, GLT-ACCT-UNITGOT-ACCT-UNIT, GLT-ACCOUNTGOT-ACCOUNT, GLT-SUB-ACCOUNTGOT-SUB-ACCOUNT, GLT-FISCAL-YEARGOT-FISCAL-YEAR, GOT-SYSTEM
GlcommitxGLCOMMITXGLT-COMPANYGOX-COMPANY, GLT-ACCT-UNITGOX-ACCT-UNIT, GLT-ACCOUNTGOX-ACCOUNT, GLT-SUB-ACCOUNTGOX-SUB-ACCOUNT, GLT-FISCAL-YEARGOX-FISCAL-YEAR, GLT-ACCT-PERIODGOX-PERIOD, GOX-SYSTEM, GOX-CURRENCY-CODE, GOX-GLT-OBJ-ID
GlhiscomxGLHISCOMX"Y"GHX-SYS-OBJ-TYPE, GLT-OBJ-IDGHX-SYS-OBJ-ID, GHX-UNIQUE-I-D
GlsccatGLSCCATGLT-SOURCE-CODEGSC-SOURCE-CODE, GSC-SEQ-NBR
GltransGLTRANSGLT-COMPANYGLT-COMPANY, GLT-FISCAL-YEARGLT-FISCAL-YEAR, GLT-ACCT-PERIODGLT-ACCT-PERIOD, GLT-CONTROL-GROUPGLT-CONTROL-GROUP, GLT-SYSTEMGLT-SYSTEM, GLT-JE-TYPEGLT-JE-TYPE, GLT-JE-SEQUENCEGLT-JE-SEQUENCE, GLT-LINE-NBR
GtmxvalueGTMXVALUEDelete CascadesGLT-OBJ-IDGMV-OBJ-ID, GMV-MATRIX-CAT
IcmmdistMMDISTValid When GLT-SYSTEM = "IC"GLT-OBJ-IDMMD-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
OedistOEDISTGLT-OBJ-IDODI-GLT-OBJ-ID, ODI-INVC-PREFIX, ODI-INVC-NUMBER, ODI-AUTH-NO, ODI-LINE-NBR, ODI-SEQ, ODI-POSTING-TYPE
PommdistMMDISTValid When GLT-SYSTEM = "PO"GLT-OBJ-IDMMD-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
PornimmdistMMDISTValid When GLT-SYSTEM = "PO"GLT-OBJ-IDMMD-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
PrdistribPRDISTRIBGLT-COMPANYPRD-DIST-COMPANY, GLT-OBJ-IDPRD-GLT-OBJ-ID, GLT-ACCT-UNITPRD-DST-ACCT-UNIT, GLT-ACCOUNTPRD-DST-ACCOUNT, GLT-SUB-ACCOUNTPRD-DST-SUB-ACCT, PRD-OBJ-ID
SltransSLTRANSGLT-OBJ-IDSLT-GLT-OBJ-ID, SLT-OBJ-ID

Programs

Updated by (88)

Referenced by (345)