BILLOFLAD – Bill of Lading

System
Warehouse (WH)
Prefix
BOL
Primary key
COMPANY, BOL-NBR
Fields
7
Updated by
4 programs
Referenced by
22 programs

BILLOFLAD is the Bill of Lading table in Lawson Warehouse (prefix BOL). It is indexed by COMPANY, BOL-NBR (BOLSET1); alternate indexes: BOLSET2. It is related 1:1 to APCOMPANY, ICLOCATION and OECOMPANY. It is updated by WH140, WH33.5, WH40.1 and WH40.2 and referenced by WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 and 14 more. The table has 7 fields, 2 indexes and 3 documented relations.

About BILLOFLAD

The Bill of Lading file contains Bill of Lading information. This information is shared by all shipment records using the same Bill of Lading. Bill of Ladings are lists of all orders sent with the person who delivers the shipment.

Fields (7)

Column = COBOL field name without the BOL- 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
#BOL-COMPANY PK
COMPANY
Numeric 4This field contains the company number.WH33.5, WH40.1
#BOL-BOL-NBR PK
BOL_NBR
Alpha 22This field contains the Bill of Lading number, which is a user-definable number representing a Bill of Lading.WH33.5, WH40.1
#BOL-INV-LOCATION
INV_LOCATION
Alpha 5This field contains the location from which inventory is taken for the Bill of Lading.WH33.5, WH40.1
#BOL-CARRIER
CARRIER
Alpha 9 (Right Justified)This field contains the carrier vendor number.WH33.5, WH40.1
#BOL-METHOD
METHOD
Alpha 10This field contains the shipping method. This is validated in the Shipping Method file. Shipping methods are defined in the Lawson Warehouse system.WH33.5, WH40.1
#BOL-BOL-PRINT-FL
BOL_PRINT_FL
Alpha 1This field indicates whether the Bill of Lading has printed.
  • Y Yes
  • N No
WH140, WH33.5, WH40.1
#BOL-SHIP-COUNT
SHIP_COUNT
Numeric 6This field contains the number of shipments that share the Bill of Lading.WH33.5, WH40.1

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
BOLSET1
  1. COMPANY
  2. BOL-NBR
PrimaryWH130, WH132, WH140, WH190, WH30.1, WH30.2, WH30.3, WH30.4 +18 more
BOLSET2
  1. COMPANY
  2. BOL-NBR
SubsetWhere BOL-PRINT-FL = "N"WH140

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
BOL-COMPANY→CPY-COMPANY
IclocationICLOCATIONRequired
BOL-COMPANY→ICL-COMPANY
BOL-INV-LOCATION→ICL-LOCATION
OecompanyOECOMPANYRequired
BOL-COMPANY→OEC-COMPANY

Programs

Updated by (4)

Referenced by (22)