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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BOLSET1COMPANY, BOL-NBRPrimaryWH130, WH132, WH140, WH190, WH30.1, WH30.2, WH30.3, WH30.4 +18 more
BOLSET2COMPANY, BOL-NBRSubsetWhere BOL-PRINT-FL = "N"WH140

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredBOL-COMPANY → CPY-COMPANY
IclocationICLOCATIONRequiredBOL-COMPANY → ICL-COMPANY, BOL-INV-LOCATION → ICL-LOCATION
OecompanyOECOMPANYRequiredBOL-COMPANY → OEC-COMPANY

Programs

Updated by (4)

Referenced by (22)