Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BILLOFLAD FILE

                             Bill of Lading

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.

REFERENCED BY

WH130     WH34.1    WH34.2    WH34.3    WH34.4

UPDATED BY

WH140     WH33.5

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BOL-COMPANY          Numeric 4                                   WH33.5
Company              This field contains the company number.

BOL-BOL-NBR          Alpha 22                                    WH33.5
Bill of Lading       This field contains the Bill of Lading
Number               number, which is a user-definable number
                     representing a Bill of Lading.

BOL-INV-LOCATION     Alpha 5                                     WH33.5
Inventory Location   This field contains the location from
                     which inventory is taken for the
                     Bill of Lading.

BOL-CARRIER          Alpha 9  (Right Justified)                  WH33.5
Carrier Vendor       This field contains the carrier vendor
Number               number.

BOL-METHOD           Alpha 10                                    WH33.5
Method Code          This field contains the shipping
                     method. This is validated in the
                     Shipping Method file.

                     Shipping methods are defined in the
                     Lawson Warehouse system.

BOL-BOL-PRINT-FL     Alpha 1                                     WH140   WH33.5
Bill of Lading       This field indicates whether the Bill
Printed Flag         of Lading has printed.
                     Y = Yes
                     N = No

BOL-SHIP-COUNT       Numeric 6                                   WH33.5
Ship Count           This field contains the number of
                     shipments that share the Bill of Lading.

                         BILLOFLAD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BOLSET1   COMPANY                                                WH130   WH140
          BOL-NBR                                                WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

BOLSET2   COMPANY       Subset                                   WH140
          BOL-NBR       Where BOL-PRINT-FL = "N"

                         BILLOFLAD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            BOL-COMPANY         -> CPY-COMPANY

Iclocation     ICLOCATION   Required

                            BOL-COMPANY         -> ICL-COMPANY
                            BOL-INV-LOCATION    -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            BOL-COMPANY         -> OEC-COMPANY