GLTRANSBOD – No description in the Lawson data dictionary

System: General Ledger (GL)
Prefix: YBZ
Primary key: COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR
Fields: 14
Updated by: 0 programs
Referenced by: 0 programs

GLTRANSBOD is a Lawson General Ledger table (prefix YBZ); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR (YBZSET1); alternate indexes: YBZSET2. It is related 1:1 to GLTRANS. The table has 14 fields, 2 indexes and 1 documented relation.

About GLTRANSBOD

No description in the Lawson data dictionary.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`YBZ-COMPANY` PK COMPANY	Numeric 4	—	—
`YBZ-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	—	—
`YBZ-ACCT-PERIOD` PK ACCT_PERIOD	Numeric 2	—	—
`YBZ-CONTROL-GROUP` PK CONTROL_GROUP	Numeric 8	—	—
`YBZ-SYSTEM` PK SYSTEM	Alpha 2	—	—
`YBZ-JE-TYPE` PK JE_TYPE	Alpha 1	—	—
`YBZ-JE-SEQUENCE` PK JE_SEQUENCE	Numeric 2	—	—
`YBZ-LINE-NBR` PK LINE_NBR	Numeric 6	—	—
`YBZ-BOD-ACCT-ENT` BOD_ACCT_ENT	Alpha 22 (Lower Case)	—	—
`YBZ-BOD-LOCATION` BOD_LOCATION	Alpha 22 (Lower Case)	—	—
`YBZ-BOD-DOC-ID` BOD_DOC_ID	Alpha 100 (Lower Case)	—	—
`YBZ-BOD-SOR` BOD_SOR	Alpha 1	—	—
`YBZ-BOD-REVISION` BOD_REVISION	Alpha 22 (Lower Case)	—	—
`YBZ-BOD-VAR-ID` BOD_VAR_ID	Alpha 22 (Lower Case)	—	—

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`YBZSET1`	`COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `CONTROL-GROUP`, `SYSTEM`, `JE-TYPE`, `JE-SEQUENCE`, `LINE-NBR`	Primary		GL750
`YBZSET2`	`BOD-DOC-ID`, `BOD-ACCT-ENT`, `BOD-LOCATION`, `BOD-REVISION`			—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Gltrans	GLTRANS	Required		`YBZ-COMPANY` → `GLT-COMPANY (GLTSET1)`, `YBZ-FISCAL-YEAR` → `GLT-FISCAL-YEAR`, `YBZ-ACCT-PERIOD` → `GLT-ACCT-PERIOD`, `YBZ-CONTROL-GROUP` → `GLT-CONTROL-GROUP`, `YBZ-SYSTEM` → `GLT-SYSTEM`, `YBZ-JE-TYPE` → `GLT-JE-TYPE`, `YBZ-JE-SEQUENCE` → `GLT-JE-SEQUENCE`, `YBZ-LINE-NBR` → `GLT-LINE-NBR`

Programs

No Lawson programs are documented as updating or referencing this table.