Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BILLOFLAD


                             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

BL92.1    OE114     WH130     WH132     WH190     WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH34.1
WH34.2    WH34.3    WH34.4    WH520     WH830

UPDATED BY

WH140     WH33.5    WH40.1    WH40.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BOL-COMPANY            Numeric 4                                 WH33.5  WH40.1
Element: Company       This field contains the company number.

BOL-BOL-NBR            Alpha 22                                  WH33.5  WH40.1
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  WH40.1
Element: Location Code This field contains the location from
                       which inventory is taken for the
                       Bill of Lading.

BOL-CARRIER            Alpha 9  (Right Justified)                WH33.5  WH40.1
Element: Vendor ID     This field contains the carrier vendor
                       number.

BOL-METHOD             Alpha 10                                  WH33.5  WH40.1
Element: 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
Element: All Flag      This field indicates whether the Bill     WH40.1
                       of Lading has printed.
                       Y = Yes
                       N = No

BOL-SHIP-COUNT         Numeric 6                                 WH33.5  WH40.1
Element: 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                                                BL92.1  OE114
          BOL-NBR                                                WH130   WH132
                                                                 WH140   WH190
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

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