GLBETRANS – No description in the Lawson data dictionary

System
General Ledger (GL)
Prefix
GLB
Primary key
TRANS-GROUP, SEQUENCE
Fields
15
Updated by
1 program
Referenced by
0 programs

GLBETRANS is a Lawson General Ledger table (prefix GLB); no description in the lawson data dictionary. It is indexed by TRANS-GROUP, SEQUENCE (GLBSET1). It is updated by IFEB.1. The table has 15 fields, 1 index and 0 documented relations.

About GLBETRANS

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the GLB- 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
#GLB-TRANS-GROUP PK
TRANS_GROUP		Alpha 50——
#GLB-SEQUENCE PK
SEQUENCE		Numeric 6——
#GLB-COMPANY
COMPANY		Numeric 4——
#GLB-ACCT-UNIT
ACCT_UNIT		Alpha 15——
#GLB-ACCOUNT
ACCOUNT		Numeric 6——
#GLB-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4——
#GLB-SYSTEM
SYSTEM		Alpha 2——
#GLB-ACTIVITY
ACTIVITY		Alpha 15——
#GLB-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5——
#GLB-CONTRACT
CONTRACT		Alpha 15——
#GLB-SUM-ACCT-CAT
SUM_ACCT_CAT		Alpha 5——
#GLB-CURRENCY-CODE
CURRENCY_CODE		Alpha 5——
#GLB-DATE
DATE		Numeric 8 (yyyymmdd)——
#GLB-BASE-AMOUNT
BASE_AMOUNT		Signed 18.2——
#GLB-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2——

Indexes (1)

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
GLBSET1
  1. TRANS-GROUP
  2. SEQUENCE
PrimaryIFEB.1

Programs

Updated by (1)