|
|
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 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
Element: Bol Nbr This field contains the Bill of Lading
number, which is a user-definable number
representing a Bill of Lading.
BOL-INV-LOCATION Alpha 5 WH33.5 WH40.1
Element: Location 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 This field contains the carrier vendor
number.
BOL-METHOD Alpha 10 WH33.5 WH40.1
Element: Method 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 WH130
BOL-NBR 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
|
