WHSHIPMENT

Shipment

The Shipment file carries a record for every shipment created for every document.
UPDATED BY
RQ300 POIF.1 POIG.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHS-COMPANY
Element: Company
Numeric 4
This field contains the company number.
WHS-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on which Lawson system the document originated.
OE = Customer Order
RQ = Requisitions
CX = Case Cart
WHS-DOC-NBR
Element: Doc Nbr
Alpha 10 (Right Justified)
This field contains the document number within the shipment.
WHS-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.
WHS-DOC-TYPE
Element: Doc Type
Alpha 2
This field contains the type of document. For warehouse purposes, this is the shipping document.
SH = Shipment
WHS-CUST-SHIP-TO
Customer Ship-To
Number
Numeric 4
This field contains the ship-to customer number.
WHS-REQ-LOCATION
Element: Requesting Location
Alpha 5
This field contains the requesting location. This location can be an inventory or nonstock location.
WHS-DESTINATION
Element: Destination
Alpha 15
This field represents the destination to which shipments are being sent.
WHS-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level assigned to the document.
WHS-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
WHS-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch number assigned to the shipment when you ran Pick List Print (WH130).
WHS-STATUS
Element: Status
Numeric 1
This field contains the status of the shipment.
0 = Printed
1 = Picked
2 = Packed
3 = Shipped
4 = Released
5 = Closed
WHS-OPR-CODE
Element: Opr Code
Alpha 10 (Lower Case)
This field contains the operator code or the user ID of the person who last updated this record.
WHS-PICKING-REQ
Element: Picking Required
Alpha 1
This field indicates whether or not picking feedback is required based on the process type.
Y = Yes
N = No
WHS-PACKING-REQ
Element: Packing Required
Alpha 1
This field indicates whether or not packing feedback is required based on the process type.
Y = Yes
N = No
WHS-PRINT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WHS-PICK-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date that picking feedback was performed. The system date defaults.
WHS-PACK-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the pack date. The system date defaults but can be overridden if you are using the WH20 form series.
WHS-SHIP-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WHS-GL-DATE
Element: Gl Date
Numeric 8 (yyyymmdd)
This field contains the general ledger posting date.
WHS-EST-DEL-DATE
Element: Expected Ship Date
Numeric 8 (yyyymmdd)
This field contains the expected ship date. If you leave the field blank and no ship days are defined on the document's process level, the document date defaults. If ship days exist on the process level, ship days are added to the document date to calculate the expected ship date.
WHS-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
WHS-PO-FLAG
Element: PO Flag
Alpha 1
This field indicates whether or not shipment lines that create purchase orders are based on purchase order receipt.
Y = Based on PO Receipt
N = Not Related to PO
WHS-ROUTE
Element: Route
Numeric 4
This field contains the route number. The route assigned to the ship-to customer defaults from the Route file.
WHS-STOP
Element: Stop
Numeric 4
This field contains the stop within the route. If left blank, the stop associated with the ship-to customer defaults from the Route file.
WHS-BOL-NBR
Element: Bol Nbr
Alpha 22
This field contains the Bill of Lading number for the shipment.
WHS-CARRIER
Element: Carrier Number
Alpha 9 (Right Justified)
This field contains the carrier number. The carrier must be valid in Accounts Payable.
WHS-METHOD
Element: Method
Alpha 10
This field contains the shipping method that you defined using Shipping Method (WH11.1).
WHS-TRANS-ID
Element: Transportation ID
Alpha 20
This field contains the transportation identification, which prints on the invoice and Bill of Lading.
WHS-FREIGHT-CODE
Element: Freight Code
Alpha 2
This field contains the freight code. This must be valid in the Order Entry Freight Code file. This determines whether carrier and charge are allowed for the shipment.
WHS-FREIGHT-REQ
Element: Freight Required
Alpha 1
This field indicates whether or not freight charges are required on this shipment. Freight codes are defined in the Lawson Billing system.
WHS-FRT-CHG-CURR
Freight Charge
Currency
Signed 18.2
This field contains the freight charge amount in billing currency.
WHS-CARTONS
Element: Cartons
Numeric 6
This field contains the total number of cartons in the shipment.
WHS-CUBIC-FEET
Element: Cubic Feet
Signed 9.3
This field contains the total of all the shipment line's calculated cubic measurements based on the item master stock cubic values.
WHS-CUBIC-ADJ
Element: Cubic Adj
Signed 9.3
This field contains a shipment level adjustment to the total of all the shipment line's calculated cubic measurements.
WHS-CUBIC-TOTAL
Element: Cubic Total
Signed 9.3
This field contains the shipment's total cubic measurement which is the sum of the shipment line's calculated totals and the shipment level adjustment.
WHS-WEIGHT
Element: Weight
Signed 9.3
This field contains the total of all the shipment line's calculated weight based on the item master stock weight values.
WHS-WEIGHT-ADJ
Element: Weight Adj
Signed 9.3
This field contains a shipment level adjustment to the total of all the shipment line's calculated weight.
WHS-WEIGHT-TOTAL
Element: Weight Total
Signed 9.3
This field contains the shipment's total weight which is the sum of the shipment line's calculated totals and the shipment level adjustment.
WHS-PACK-LIST-FL
Element: Pack List Flag
Alpha 1

Y = Yes
N = No
WHS-POD-PRT-FL
Element: POD Print Flag
Alpha 1
This field represents the Proof of Delivery (POD) Print flag. WH126 (POD Print) sets this flag to Yes after printing a POD.
Y = Yes
N = No
WHS-POD-RETRN-DT
Element: POD Return Date
Numeric 8 (yyyymmdd)
This field contains the date the Proof of Delivery (POD) form is returned with an acknowledgment.
WHS-INVC-PREFIX
Element: Invc Prefix
Alpha 2
This field contains the invoice prefix that is assigned from either the billing company or process level, depending on the invoice-level option chosen.
WHS-INVC-NUMBER
Element: Invoice Number
Numeric 8
This field contains the invoice number assigned by the system.
WHS-REQ-COMPANY
Element: Company
Numeric 4
This field contains the requesting company.
WHS-DOC-NBR-NUM
Element: Doc Nbr Num
Numeric 10
This field contains the numeric version of the document number.
WHS-ORIGIN
Element: Origin
Derived
This literal helps to indicate in which Lawson system the document originated.
WHS-DAYS-LATE
Element: Days Late
Derived
This field contains the number of days after the requested date that you sent a shipment.
WHS-DAYS-LATE-COND
Element: Days Late Condition
Derived
This flag helps to indicate whether or not a shipment was late.
WHS-DAYS-LATE-CTR
Element: Days Late Counter
Derived
This flag will be either zero or one, indicating if the shipment was late or not.
WHS-LAST-DATE
Element: Last Activity Date
Derived
This field contains the last activity date for the shipment. In other words, when the last activity such as picking or packing feedback was performed.
WHS-RDY-TO-STATUS
Element: Ready To Status
Derived
This field indicates the shipment status the shipment is about to go to, based on the process type.
WHS-RDY-TO-LITERAL
Element: Ready To Literal
Derived
This literal is used to help display the status a shipment is about to go to.
WHS-INTRASTAT-NBR
Element: Intrastat Nbr
Numeric 12
The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.
WHS-FOB-CODE
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
WHS-PORT-CD
Element: Port Cd
Alpha 5
The Intrastat port code. Must be define in IN04.1 (Port Maintenance)
WHS-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
WHS-STAT-PROC
Element: Stat Proc
Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
WHS-VAT-REG-NBR
Element: Vat Reg Nbr
Alpha 12
The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.


WHSHIPMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHSSET1 COMPANY
LOCATION
SHIPMENT-NBR
WHSSET10 COMPANY
LOCATION
SHIPMENT-NBR*
Subset
WhereSTATUS <4
WHSSET11 COMPANY
LOCATION
SHIPMENT-NBR*
WHSSET2 COMPANY
LOCATION
BOL-NBR
SHIPMENT-NBR
KeyChange, Subset
Where(BOL-NBR !=Spaces)
WHSSET3 COMPANY
LOCATION
CARRIER
BOL-NBR
SHIPMENT-NBR
KeyChange
WHSSET4 COMPANY
LOCATION
BATCH-NBR
SHIPMENT-NBR
Subset
Where(STATUS =3)
WHSSET5 COMPANY
LOCATION
BATCH-NBR
SHIPMENT-NBR
WHSSET6 COMPANY
LOCATION
DOC-NBR
SHIPMENT-NBR
Subset
Where(SYSTEM-CD ="OE")
And(STATUS =4)
WHSSET7 COMPANY
SYSTEM-CD
DOC-NBR
SHIPMENT-NBR
LOCATION
POIF.1 POIG.1
RQ300
WHSSET8 COMPANY
LOCATION
SYSTEM-CD
DOC-NBR
SHIPMENT-NBR
WHSSET9 COMPANY
SHIPMENT-NBR
LOCATION


WHSHIPMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When WHS-CARRIER !=Spaces
WHS-COMPANY->CPY-COMPANY
Apvenmast APVENMAST Required
When WHS-CARRIER !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
WHS-CARRIER->VEN-VENDOR
Custorder CUSTORDER Required
When WHS-SYSTEM-CD ="OE"
WHS-COMPANY->COR-COMPANY
WDH-DOC-NBR-NUM->COR-ORDER-NBR
Iccompany ICCOMPANY Required
WHS-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Required
WHS-COMPANY->ICL-COMPANY
WHS-LOCATION->ICL-LOCATION
Oemethod OEMETHOD Not Required
Valid When WHS-METHOD !=Spaces
WHS-COMPANY->OMT-COMPANY
WHS-METHOD->OMT-METHOD
Reqheader REQHEADER Required
When WHS-SYSTEM-CD ="RQ"
WHS-REQ-COMPANY->RQH-COMPANY
WDH-DOC-NBR-NUM->RQH-REQ-NUMBER
Shipto SHIPTO Not Required
WHS-COMPANY->SHP-COMPANY
COR-CUSTOMER->SHP-CUSTOMER
WHS-CUST-SHIP-TO->SHP-SHIP-TO
Whdemndhdr WHDEMNDHDR Required
WHS-COMPANY->WDH-COMPANY
WHS-SYSTEM-CD->WDH-SYSTEM-CD
WHS-DOC-NBR->WDH-DOC-NBR
Whwhsuf WHWHSUF Not Required
WHS-COMPANY->WSU-COMPANY
WHS-LOCATION->WSU-LOCATION
WHS-SHIPMENT-NBR->WSU-SHIPMENT-NBR


WHSHIPMENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
No Details WHSHIPLINE
WHS-COMPANY->WHL-COMPANY
WHS-LOCATION->WHL-LOCATION
WHS-SHIPMENT-NBR->WHL-SHIPMENT-NBR
  WHL-LINE-NBR
Shipline WHSHIPLINE
WHS-COMPANY->WHL-COMPANY
WHS-LOCATION->WHL-LOCATION
WHS-SHIPMENT-NBR->WHL-SHIPMENT-NBR
  WHL-LINE-NBR
Shiplnedtl WHSHLDTL
WHS-COMPANY->WHD-COMPANY
WHS-LOCATION->WHD-LOCATION
WHS-SHIPMENT-NBR->WHD-SHIPMENT-NBR
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-SERIAL
  WHD-UOM
  WHD-LINE-NBR
  WHD-COMPONENT-SEQ


File created: Wed Jun 08 20:51:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.