SHPBOD – No description in the Lawson data dictionary

System: Billing (BL)
Prefix: BBB
Primary key: COMPANY, CUSTOMER, SHIP-TO
Fields: 9
Updated by: 0 programs
Referenced by: 0 programs

SHPBOD is a Lawson Billing table (prefix BBB); no description in the lawson data dictionary. It is indexed by COMPANY, CUSTOMER, SHIP-TO (BBBSET1); alternate indexes: BBBSET2. It is related 1:1 to SHIPTO. The table has 9 fields, 2 indexes and 1 documented relation.

About SHPBOD

No description in the Lawson data dictionary.

Fields (9)

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

Field / column	Type	Description & values	Updated by
`BBB-COMPANY` PK COMPANY	Numeric 4	—	—
`BBB-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	—	—
`BBB-SHIP-TO` PK SHIP_TO	Numeric 4	—	—
`BBB-BOD-ACCT-ENT` BOD_ACCT_ENT	Alpha 22 (Lower Case)	—	—
`BBB-BOD-LOCATION` BOD_LOCATION	Alpha 22 (Lower Case)	—	—
`BBB-BOD-DOC-ID` BOD_DOC_ID	Alpha 100 (Lower Case)	—	—
`BBB-BOD-SOR` BOD_SOR	Alpha 1	—	—
`BBB-BOD-REVISION` BOD_REVISION	Alpha 22 (Lower Case)	—	—
`BBB-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
`BBBSET1`	`COMPANY`, `CUSTOMER`, `SHIP-TO`	Primary		WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3, WH30.4 +18 more
`BBBSET2`	`BOD-DOC-ID`, `BOD-ACCT-ENT`, `BOD-LOCATION`, `BOD-REVISION`			—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Shipto	SHIPTO	Required		`BBB-COMPANY` → `SHP-COMPANY (SHPSET1)`, `BBB-CUSTOMER` → `SHP-CUSTOMER`, `BBB-SHIP-TO` → `SHP-SHIP-TO`

Programs

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