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    WH31.1    WH31.2    WH31.3    WH32.1
WH32.2    WH32.3    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
Company              This field contains the company number.

BOL-BOL-NBR          Alpha 10                                    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
Inventory Location   This field contains the location from
                     which inventory is taken for the
                     Bill of Lading.

BOL-CARRIER          Alpha 9                                     WH33.5  WH40.1
Carrier Vendor       This field contains the carrier vendor
Number               number.

BOL-METHOD           Alpha 10                                    WH33.5  WH40.1
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       WH40.1
Print Flag           of Lading has printed.
                     Y = Yes
                     N = No

BOL-SHIP-COUNT       Numeric 6                                   WH33.5  WH40.1
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  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH32.1  WH32.2
                                                                 WH32.3  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