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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET6 SET7 SET8
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 SET8
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 SET2 SET3 SET6 SET8
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 SET2 SET3 SET6 SET8
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 SET2 SET3 SET6 SET8
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 SET2 SET3 SET6
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 SET2 SET9
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 10—GL110, GL146, GL148, GL167, GL190, GL191, GL196, GL197 +11 more
#GLT-LAST-UPDT-DATE SET9
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 8—AC145, AC45.1, GL110, GL120, GL146, GL147, GL148, GL167 +19 more
#GLT-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AC145, AC45.1, GL110, GL120, GL146, GL147, GL148, GL167 +19 more

Indexes (7)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLTSET1
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. CONTROL-GROUP
  5. SYSTEM
  6. JE-TYPE
  7. JE-SEQUENCE
  8. LINE-NBR
PrimaryAC145, AC45.1, CA195, FB100, FB101, FB120, FB121, FB122 +22 more (list truncated in source)
GLTSET2
  1. TO-COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. POSTING-DATE
  8. SYSTEM
  9. CONTROL-GROUP
  10. JE-TYPE
  11. LINE-NBR
  12. COMPANY
  13. JE-SEQUENCE
KeyChange, SubsetWhere STATUS != 8AD325, GL120, GL135, GL147, GL199, GL256, GL290, GL325 +2 more
GLTSET3
  1. TO-COMPANY
  2. ACCOUNT
  3. SUB-ACCOUNT
  4. ACCT-UNIT
  5. FISCAL-YEAR
  6. ACCT-PERIOD
  7. SYSTEM
  8. CONTROL-GROUP
  9. JE-TYPE
  10. JE-SEQUENCE
  11. LINE-NBR
  12. COMPANY
KeyChange, SubsetWhere STATUS != 8AD325, FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1 +22 more (list truncated in source)
GLTSET6
  1. TO-COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. ACCT-UNIT
  7. OBJ-ID
KeyChange, SubsetWhere STATUS != 8GL256, GL290, ML290
GLTSET7
  1. OBJ-ID
AC145, AC45.1, FB11.1, FB111, FB160, FB211, FB296, FB60.1 +22 more (list truncated in source)
GLTSET8
  1. COMPANY
  2. VAR-LEVELS
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. FISCAL-YEAR
  7. ACCT-PERIOD
  8. SYSTEM
  9. OBJ-ID
KeyChange, SubsetWhere STATUS = 1AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)
GLTSET9
  1. COMPANY
  2. POSTING-DATE
  3. LAST-UPDT-DATE
  4. FISCAL-YEAR
  5. ACCT-PERIOD
  6. CONTROL-GROUP
  7. SYSTEM
  8. JE-TYPE
  9. JE-SEQUENCE
  10. LINE-NBR
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERACACTIVITYGLSCCATGLCHARTDTLGLSYSTEMCUAMOUNTXFBFUNDDTLGLAMOUNTSXGLCONDRILLGLCONTROLGLHOLDCODEGLNAMESGLSEGBLOCKGLSRCCODE+4 more belowACDEFREVACHISTDTLACMNTSCHXACPMHSTDTLACTRANSAMTRANSAPAPDHISTAPDISTRIBAPDRFTDISTARDISTRIBCAHEADERCBDISTRIBEEDISTRIBFBBATRANS+11 more belowGLTRANS

One to one (24) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequired
GLT-TO-COMPANY→GLM-COMPANY (GLMSET2)
GLT-ACCT-UNIT→GLM-ACCT-UNIT
GLT-ACCOUNT→GLM-ACCOUNT
GLT-SUB-ACCOUNT→GLM-SUB-ACCOUNT
ActivityACACTIVITYNot Required
GLT-ACTIVITY→ACV-ACTIVITY
Category 1GLSCCATNot Required
GLT-SOURCE-CODE→GSC-SOURCE-CODE
1→GSC-SEQ-NBR
Category 3GLSCCATNot Required
GLT-SOURCE-CODE→GSC-SOURCE-CODE
3→GSC-SEQ-NBR
Categroy 2GLSCCATNot Required
GLT-SOURCE-CODE→GSC-SOURCE-CODE
2→GSC-SEQ-NBR
Chart DetailGLCHARTDTLNot Required
GLS-CHART-NAME→GDT-CHART-NAME
GLT-ACCOUNT→GDT-ACCOUNT
GLT-SUB-ACCOUNT→GDT-SUB-ACCOUNT
CompanyGLSYSTEMRequired
GLT-COMPANY→GLS-COMPANY
Cuamountx 3CUAMOUNTXNot 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 4CUAMOUNTXNot 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
FbfunddtlFBFUNDDTLRequired
GLT-COMPANY→FUD-COMPANY
GLT-ACCOUNT→FUD-ACCOUNT
GLT-SUB-ACCOUNT→FUD-SUB-ACCOUNT
GLT-ACCT-UNIT→FUD-ACCT-UNIT
GlamountsxGLAMOUNTSXNot 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
GlcondrillGLCONDRILLRequired
GLT-OBJ-ID→GLD-GLT-OBJ-ID
GlcontrolGLCONTROLRequired
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
GlholdcodeGLHOLDCODENot Required
GLC-HOLD-CODE→GLH-HOLD-CODE
GlnamesGLNAMESRequired
GLT-TO-COMPANY→GLN-COMPANY
GLT-ACCT-UNIT→GLN-ACCT-UNIT
GlsegblockGLSEGBLOCKNot Required
GLT-OBJ-ID→GSB-GLT-OBJ-ID
GlsrccodeGLSRCCODERequired
GLT-SOURCE-CODE→GSR-SOURCE-CODE
GlsystemGLSYSTEMRequired
GLT-COMPANY→GLS-COMPANY
GltransbodGLTRANSBODNot 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
RjbridgeRJBRIDGENot Required
"GLTRN"→RJB-OBJ-TYPE
GLT-OBJ-ID→RJB-OBJ-ID
RjcontrolRJCONTROLNot Required
GLT-COMPANY→RJC-COMPANY
GLT-JE-TYPE→RJC-JE-TYPE
GLT-CONTROL-GROUP→RJC-REC-GROUP
Rjcontrol IntfRJCONTROLNot Required
GLT-COMPANY→RJC-COMPANY
RJB-JE-TYPE→RJC-JE-TYPE
RJB-REC-GROUP→RJC-REC-GROUP
Source CodeGLCODESNot Required
"S"→GCD-RECORD-TYPE
Spaces→GCD-FOLDER-NAME
Spaces→GCD-PROCESS-GROUP
GLT-SOURCE-CODE→GCD-SYSTEM
Zeroes→GCD-COMPANY
To CompanyGLSYSTEMRequired
GLT-TO-COMPANY→GLS-COMPANY

One to many (27) — child tables

RelationTableRulesConditionField map
AcdefrevACDEFREV
GLT-OBJ-ID→DRD-GLT-OBJ-ID
—→DRD-ATN-OBJ-ID
—→DRD-CONTRACT
—→DRD-PRODUCT
—→DRD-PROD-VERSION
—→DRD-OBJ-ID
—→DRD-SEQ-NBR
AchistdtlACHISTDTL
GLT-OBJ-ID→HDT-GLT-OBJ-ID
—→HDT-OBJ-ID
—→HDT-LINE-NBR
AcmntschxACMNTSCHX
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
AcpmhstdtlACPMHSTDTL
GLT-OBJ-ID→PML-GLT-OBJ-ID
—→PML-ATN-OBJ-ID
—→PML-OBJ-ID
—→PML-LINE-NBR
ActransACTRANS
GLT-OBJ-ID→ATN-GLT-OBJ-ID
—→ATN-OBJ-ID
AmtransAMTRANS
GLT-OBJ-ID→AMT-GLT-OBJ-ID
—→AMT-ASSET
—→AMT-SEQ-NUMBER
ApapdhistAPAPDHIST
GLT-OBJ-ID→AH2-GLT-OBJ-ID
—→AH2-API-OBJ-ID
—→AH2-DIST-SEQ-NBR
ApdistribAPDISTRIB
GLT-OBJ-ID→APD-GLT-OBJ-ID
—→APD-API-OBJ-ID
—→APD-DIST-SEQ-NBR
ApdrftdistAPDRFTDIST
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 DetARDISTRIB
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
CaheaderCAHEADER
GLT-ORIG-COMPANY→CAH-COMPANY
GLT-CONTROL-GROUP→CAH-JE-NBR
GLT-JE-TYPE→CAH-JE-TYPE
—→CAH-ALLOC-NAME
—→CAH-ALLOC-TYPE
CbdistribCBDISTRIB
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
EedistribEEDISTRIB
GLT-OBJ-ID→EED-GLT-OBJ-ID
—→EED-COMPANY
—→EED-VENDOR
—→EED-EXPENSE-NBR
—→EED-SEQ-NBR
FbbatransFBBATRANS
GLT-OBJ-ID→FBT-GLT-OBJ-ID
—→FBT-UNIQUE-I-D
FbdetailFBDETAIL
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
GlcommitGLCOMMIT
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
GlcommitxGLCOMMITX
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
GlhiscomxGLHISCOMX
"Y"→GHX-SYS-OBJ-TYPE
GLT-OBJ-ID→GHX-SYS-OBJ-ID
—→GHX-UNIQUE-I-D
GlsccatGLSCCAT
GLT-SOURCE-CODE→GSC-SOURCE-CODE
—→GSC-SEQ-NBR
GltransGLTRANS
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
GtmxvalueGTMXVALUEDelete Cascades
GLT-OBJ-ID→GMV-OBJ-ID
—→GMV-MATRIX-CAT
IcmmdistMMDISTValid 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
OedistOEDIST
GLT-OBJ-ID→ODI-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-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
PornimmdistMMDISTValid 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
PrdistribPRDISTRIB
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
SltransSLTRANS
GLT-OBJ-ID→SLT-GLT-OBJ-ID
—→SLT-OBJ-ID

Programs

Updated by (88)

Referenced by (345)