FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
WHL-COMPANY Element: Company | Numeric 4 This field contains the company number.
|
|
WHL-SYSTEM-CD Element: System Cd | Alpha 2 This field indicates from which Lawson
system the document originated.
OE = Customer Order RQ = Requisitions CX = Case Cart |
|
WHL-DOC-NBR Element: Doc Nbr | Alpha 10 (Right Justified) This field contains the document number
assigned to this shipment line.
|
|
WHL-SHIPMENT-NBR Element: Shipment Nbr | Numeric 10 This field contains the shipment
number. One document can have several
shipment numbers if the items were not
shipped at the same time.
|
|
WHL-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the shipment line
number.
|
|
WHL-LINE-TYPE Element: Line Type | Alpha 1 This field contains the type of item
found on this shipment line.
I = Inventoried Item N = Nonstock Item X = Special Item |
|
WHL-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
WHL-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field contains the description of
the line item.
|
|
WHL-LOCATION Element: Location | Alpha 5 This field contains a valid stock
location within the company inventory.
|
|
WHL-PRINTED-QTY Element: Quantity | Signed 13.4 This field contains the quantity that
was printed on the pick list to be
picked.
|
|
WHL-TRAN-UOM Element: Uom | Alpha 4 This field indicates the unit of
measure from the document.
|
|
WHL-TRAN-UOM-MULT Element: Uom Mult | Signed 13.7 This field is the conversion factor to
convert to stock unit of measure.
|
|
WHL-IN-PROCESS-QTY Element: In-Process Quantity | Signed 13.4 This field contains the in-process
quantity, which is the shipment line
quantity currently in process.
|
|
WHL-SHIPPED-QTY Element: Quantity | Signed 13.4 This field contains the quantity that
was shipped in stock unit of measure.
For catch weight items, the shipped
quantity is in secondary unit of
measure.
|
|
WHL-DELIVERED-QTY Element: Delivered Qty | Signed 13.4 This is the quantity that has been
issued or transferred to the requesting
location. This quantity is updated by
PO221 (Delivery Ticket).
|
|
WHL-CATCH-WT-QTY Element: Quantity | Signed 13.4 This field contains the catch weight
quantity in stock unit of measure.
|
|
WHL-PRE-ASMBLD-KIT Element: Pre-Assembled Kit | Signed 13.4 This field contains the make-to-order
kit quantity.
|
|
WHL-KIT-COMP-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
WHL-DETAIL-QTY Element: Detail Quantity | Signed 13.4 This field shows the total quantity of
details assigned to the shipment line.
|
|
WHL-DTL-CTW-QTY Detail Catch Weight Quantity | Signed 13.4 This field contains the catch weight
quantity for shipment lines with
details.
|
|
WHL-DETAIL-REQ Element: Detail Required | Alpha 1 This field indicates whether or not
details are required for shipment lines.
Y = Yes N = No I = Interfaced |
|
WHL-WALK-THRU-REQ Element: Walk Thru Required | Alpha 1 This field indicates that a shipment
line is out of balance.
|
|
WHL-UNIT-COST Element: Intl Cost | Signed 18.5 This field contains the unit cost of
the shipment line.
|
|
WHL-WEIGHT Element: Weight | Signed 9.3 This field contains the shipment line's
calculated weight based on the item
master stock weight and the line's
quantity in stock unit of measure.
|
|
WHL-CUBIC-FEET Element: Cubic Feet | Signed 9.3 This field contains the shipment line's
calculated cubic measurement based on
the item master stock cubic and the
shipment line's quantity in stock unit
of measure.
|
|
WHL-MSDS-REQ-FL Element: All Flag | Alpha 1 This field indicates if a Material
Safety Data Sheet is required for the
item of this shipment line. This flag is
originally set at item master.
Y = Yes N = No |
|
WHL-MSDS-DT Element: MSDS Date | Numeric 8 (yyyymmdd) This field contains the date that a
Material Safety Data Sheet is being sent
to a customer ship to for this shipment
line.
|
|
WHL-MSDS-DOCUMENT Element: Msds Document | Alpha 30 The document number that references the
Material Safety Data Sheet that is being
sent for this shipment line.
|
|
WHL-MSDS-VERSION Element: Msds Version | Alpha 4 The version number of the MSDS document
that is being sent with this shipment
line.
|
|
WHL-OPR-CODE Element: Opr Code | Alpha 10 (Lower Case) This field contains the operator code
or user ID of the person who last
updated this record.
|
|
WHL-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record
was updated.
|
|
WHL-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time
when the record was updated.
|
|
WHL-FULL-VOID-FL Element: Full Void Fl | Alpha 1 Indicates that shipment line has been
voided. No quantities will be shipped
from this line.
Y = Voided N = Not Voided |
|
WHL-REQ-COMPANY Element: Company | Numeric 4 This field contains the requesting
company.
|
|
WHL-OPEN-QUANTITY Element: Open Quantity | Derived This field contains the total of the
in-process quantity and the backorder
quantity.
|
|
WHL-PARTIAL Element: Partial | Derived This field is used to help determine if
a shipment is partial or not.
|
|
WHL-PARTIAL-VALUE Element: Partial Value | Derived This field indicates whether or not a
shipment is partial.
|
|
WHL-SUPLMNTARY-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
WHL-SUPLMNTARY-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
WHL-ICN-CODE Element: Icn Code | Alpha 8
|
|
WHL-RQSRC-MACHINE Element: Rqsrc Machine | Alpha 6
|
|
WHL-PAR-ORDER-ID Element: Par Order Id | Alpha 20
|
|
WHL-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15
|
|
RELATION NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
Atch Ser Recpt |
WHSHLDTL |
Valid When | | ITE-SER-TRACK-FL | = | "R" | |
WHL-COMPANY | -> | WHD-COMPANY |
WHL-LOCATION | -> | WHD-LOCATION |
WHL-SHIPMENT-NBR | -> | WHD-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHD-LINE-NBR |
Zeroes | -> | WHD-COMPONENT-SEQ |
| | WHD-BIN |
| | WHD-LOT |
| | WHD-SUBLOT |
| | WHD-UOM |
| | WHD-SERIAL |
|
Attached Bins |
WHSHLDTL |
Valid When | | ITE-LOT-TRACK-FL | = | "N" | |
And | | ITL-BIN-TRACK-FL | = | "Y" | |
And | | ITE-SER-TRACK-FL | = | "N" | |
WHL-COMPANY | -> | WHD-COMPANY |
WHL-LOCATION | -> | WHD-LOCATION |
WHL-SHIPMENT-NBR | -> | WHD-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHD-LINE-NBR |
Zeroes | -> | WHD-COMPONENT-SEQ |
| | WHD-BIN |
| | WHD-LOT |
| | WHD-SUBLOT |
| | WHD-UOM |
| | WHD-SERIAL |
|
Attached Lots |
WHSHLDTL |
Valid When | | ITE-LOT-TRACK-FL | = | "Y" | |
WHL-COMPANY | -> | WHD-COMPANY |
WHL-LOCATION | -> | WHD-LOCATION |
WHL-SHIPMENT-NBR | -> | WHD-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHD-LINE-NBR |
Zeroes | -> | WHD-COMPONENT-SEQ |
| | WHD-BIN |
| | WHD-LOT |
| | WHD-SUBLOT |
| | WHD-UOM |
| | WHD-SERIAL |
|
Attached Sers |
WHSHLDTL |
Valid When | | ITE-SER-TRACK-FL | = | "I" | |
WHL-COMPANY | -> | WHD-COMPANY |
WHL-LOCATION | -> | WHD-LOCATION |
WHL-SHIPMENT-NBR | -> | WHD-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHD-LINE-NBR |
Zeroes | -> | WHD-COMPONENT-SEQ |
| | WHD-BIN |
| | WHD-LOT |
| | WHD-SUBLOT |
| | WHD-UOM |
| | WHD-SERIAL |
|
Attached Uoms |
WHSHLDTL |
Valid When | | SDT- | = | WHL- | |
And | | ITE-LOT-TRACK-FL | = | "N" | |
And | | ITE-SER-TRACK-FL | = | "N" | |
And | | ITL-BIN-TRACK-FL | = | "N" | |
WHL-COMPANY | -> | WHD-COMPANY |
WHL-LOCATION | -> | WHD-LOCATION |
WHL-SHIPMENT-NBR | -> | WHD-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHD-LINE-NBR |
Zeroes | -> | WHD-COMPONENT-SEQ |
| | WHD-BIN |
| | WHD-LOT |
| | WHD-SUBLOT |
| | WHD-UOM |
| | WHD-SERIAL |
|
Bins |
SOHDETAIL |
Valid When | | ITE-LOT-TRACK-FL | = | "N" | |
And | | ITL-BIN-TRACK-FL | = | "Y" | |
And | | ITE-SER-TRACK-FL | = | "N" | |
WHL-COMPANY | -> | SDT-COMPANY |
WHL-LOCATION | -> | SDT-LOCATION |
WHL-ITEM | -> | SDT-ITEM |
| | SDT-UOM |
| | SDT-LOT |
| | SDT-SUBLOT |
| | SDT-BIN |
|
Itcomment |
ITCOMMENT |
ICC-ITEM-GROUP | -> | ICO-ITEM-GROUP |
WHL-ITEM | -> | ICO-ITEM |
| | ICO-LANGUAGE-CODE |
| | ICO-SEQ |
|
Itserial |
ITSERIAL |
Valid When | | ITE-SER-TRACK-FL | = | "R" | |
WHL-COMPANY | -> | SER-COMPANY |
WHL-ITEM | -> | SER-ITEM |
| | SER-SERIAL |
|
Itserials |
ITSERIAL |
Valid When | | ITE-SER-TRACK-FL | = | "I" | |
WHL-COMPANY | -> | SER-COMPANY |
WHL-ITEM | -> | SER-ITEM |
| | SER-SERIAL |
|
Lots |
SOHDETAIL |
Valid When | | ITE-LOT-TRACK-FL | = | "Y" | |
WHL-COMPANY | -> | SDT-COMPANY |
WHL-LOCATION | -> | SDT-LOCATION |
WHL-ITEM | -> | SDT-ITEM |
| | SDT-UOM |
| | SDT-LOT |
| | SDT-SUBLOT |
| | SDT-BIN |
|
Shiplnedtl |
WHSHLDTL |
WHL-COMPANY | -> | WHD-COMPANY |
WHL-LOCATION | -> | WHD-LOCATION |
WHL-SHIPMENT-NBR | -> | WHD-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHD-LINE-NBR |
| | WHD-COMPONENT-SEQ |
| | WHD-BIN |
| | WHD-LOT |
| | WHD-SUBLOT |
| | WHD-UOM |
| | WHD-SERIAL |
|
Sohdetail |
SOHDETAIL |
WHL-COMPANY | -> | SDT-COMPANY |
WHL-LOCATION | -> | SDT-LOCATION |
WHL-ITEM | -> | SDT-ITEM |
| | SDT-UOM |
| | SDT-LOT |
| | SDT-SUBLOT |
| | SDT-BIN |
|
Uoms |
SOHDETAIL |
Valid When | | SDT- | = | WHL- | |
And | | ITE-LOT-TRACK-FL | = | "N" | |
And | | ITE-SER-TRACK-FL | = | "N" | |
And | | ITL-BIN-TRACK-FL | = | "N" | |
WHL-COMPANY | -> | SDT-COMPANY |
WHL-LOCATION | -> | SDT-LOCATION |
WHL-ITEM | -> | SDT-ITEM |
| | SDT-UOM |
| | SDT-LOT |
| | SDT-SUBLOT |
| | SDT-BIN |
|
Whshipcomp |
WHSHIPCOMP |
WHL-COMPANY | -> | WHC-COMPANY |
WHL-LOCATION | -> | WHC-LOCATION |
WHL-SHIPMENT-NBR | -> | WHC-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHC-LINE-NBR |
| | WHC-COMPONENT-SEQ |
|
Whshlaud |
WHSHLAUD |
WHL-COMPANY | -> | WHA-COMPANY |
WHL-LOCATION | -> | WHA-LOCATION |
WHL-SHIPMENT-NBR | -> | WHA-SHIPMENT-NBR |
WHL-LINE-NBR | -> | WHA-LINE-NBR |
| | WHA-STATUS |
|