|
|
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 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: Opt 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: Item Count
BILLOFLAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BOLSET1 COMPANY WH130 WH132
BOL-NBR 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
|
