BILLTOBOD – No description in the Lawson data dictionary

System
Accounts Receivable (AR)
Prefix
YCK
Primary key
CUST-GROUP, CUSTOMER, BILL-TO
Fields
9
Updated by
0 programs
Referenced by
0 programs

BILLTOBOD is a Lawson Accounts Receivable table (prefix YCK); no description in the lawson data dictionary. It is indexed by CUST-GROUP, CUSTOMER, BILL-TO (YCKSET1); alternate indexes: YCKSET2. It is related 1:1 to BILLTO. The table has 9 fields, 2 indexes and 1 documented relation.

About BILLTOBOD

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the YCK- 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
#YCK-CUST-GROUP PK
CUST_GROUP		Alpha 5——
#YCK-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)——
#YCK-BILL-TO PK
BILL_TO		Numeric 4——
#YCK-BOD-DOC-ID SET2
BOD_DOC_ID		Alpha 100 (Lower Case)——
#YCK-BOD-ACCT-ENT SET2
BOD_ACCT_ENT		Alpha 22 (Lower Case)——
#YCK-BOD-LOCATION SET2
BOD_LOCATION		Alpha 22 (Lower Case)——
#YCK-BOD-SOR
BOD_SOR		Alpha 1——
#YCK-BOD-REVISION SET2
BOD_REVISION		Alpha 22 (Lower Case)——
#YCK-BOD-VAR-ID
BOD_VAR_ID		Alpha 22 (Lower Case)——

Indexes (2)

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
YCKSET1
  1. CUST-GROUP
  2. CUSTOMER
  3. BILL-TO
PrimaryAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +8 more
YCKSET2
  1. BOD-DOC-ID
  2. BOD-ACCT-ENT
  3. BOD-LOCATION
  4. BOD-REVISION
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BILLTOBILLTOBOD

One to one (1) — lookups and parents

RelationTableRulesConditionField map
BilltoBILLTORequired
YCK-CUST-GROUP→ABS-CUST-GROUP (ABSSET1)
YCK-CUSTOMER→ABS-CUSTOMER
YCK-BILL-TO→ABS-BILL-TO

Programs

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