FBDTLBOD – No description in the Lawson data dictionary

System: General Ledger (GL)
Prefix: YBQ
Primary key: COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields: 12
Updated by: 1 program
Referenced by: 1 program

FBDTLBOD is a Lawson General Ledger table (prefix YBQ); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (YBQSET1); alternate indexes: YBQSET2. It is related 1:1 to FBDETAIL. It is updated by GLBO.1 and referenced by GL750. The table has 12 fields, 2 indexes and 1 documented relation.

About FBDTLBOD

No description in the Lawson data dictionary.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`YBQ-COMPANY` PK COMPANY	Numeric 4	—	GLBO.1
`YBQ-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	—	GLBO.1
`YBQ-BUDGET-NBR` PK BUDGET_NBR	Numeric 3	—	GLBO.1
`YBQ-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	—	GLBO.1
`YBQ-ACCOUNT` PK ACCOUNT	Numeric 6	—	GLBO.1
`YBQ-SUB-ACCOUNT` PK SUB_ACCOUNT	Numeric 4	—	GLBO.1
`YBQ-BOD-ACCT-ENT` BOD_ACCT_ENT	Alpha 22 (Lower Case)	—	GLBO.1
`YBQ-BOD-LOCATION` BOD_LOCATION	Alpha 22 (Lower Case)	—	GLBO.1
`YBQ-BOD-DOC-ID` BOD_DOC_ID	Alpha 100 (Lower Case)	—	GLBO.1
`YBQ-BOD-SOR` BOD_SOR	Alpha 1	—	GLBO.1
`YBQ-BOD-REVISION` BOD_REVISION	Alpha 22 (Lower Case)	—	GLBO.1
`YBQ-BOD-VAR-ID` BOD_VAR_ID	Alpha 22 (Lower Case)	—	GLBO.1

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
`YBQSET1`	`COMPANY`, `FISCAL-YEAR`, `BUDGET-NBR`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`	Primary		GL750, GLBO.1
`YBQSET2`	`BOD-DOC-ID`, `BOD-ACCT-ENT`, `BOD-LOCATION`, `BOD-REVISION`			GLBO.1, GLBO.2

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Fbdetail	FBDETAIL	Required		`YBQ-COMPANY` → `FBD-COMPANY`, `YBQ-FISCAL-YEAR` → `FBD-FISCAL-YEAR`, `YBQ-BUDGET-NBR` → `FBD-BUDGET-NBR`, `YBQ-ACCT-UNIT` → `FBD-ACCT-UNIT`, `YBQ-ACCOUNT` → `FBD-ACCOUNT`, `YBQ-SUB-ACCOUNT` → `FBD-SUB-ACCOUNT`

FBDTLBOD – No description in the Lawson data dictionary

About FBDTLBOD

Fields (12)

Indexes (2)

Relations

One to one (1) — lookups and parents

Programs

Updated by (1)

Referenced by (1)