WHSHIPCOMP

Shipment Line Kit Component

The Shipment Line Kit Component file contains shipment line records for component items.
UPDATED BY
RQ300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHC-COMPANY
Element: Company		Numeric 4
This field contains the company number.
WHC-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
WHC-DOC-NBR
Element: Doc Nbr		Alpha 10 (Right Justified)
This field contains the document number associated with the shipment line.
WHC-LOCATION
Element: Location		Alpha 5
This field contains a valid stock location within the company inventory.
WHC-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.
WHC-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the shipment line number.
WHC-COMPONENT-SEQ
Element: Seq		Numeric 3
This field contains the component sequence number of the component item.
WHC-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
WHC-QUANTITY
Element: Quantity		Signed 13.4
This field contains the requested quantity of the item.
WHC-DETAIL-QTY
Element: Detail Quantity		Signed 13.4
This field shows the total quantity of all details assigned to component items.
WHC-DETAIL-REQ
Element: Detail Required		Alpha 1
This field indicates whether component items require details to be assigned.
Y = Yes
N = No
WHC-UNIT-COST
Element: Intl Cost		Signed 18.5
This field contains the unit cost of the component item.


WHSHIPCOMP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHCSET1 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
RQ300
WHCSET2 COMPANY
LOCATION
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
ITEM
Subset
Where(DETAIL-REQ ="Y")
WHCSET3 COMPANY
LOCATION
SHIPMENT-NBR
COMPONENT-SEQ
LINE-NBR


WHSHIPCOMP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WHC-COMPANY->ICC-COMPANY (ICCSET1)
Iclocation ICLOCATION Required
WHC-COMPANY->ICL-COMPANY
WHC-LOCATION->ICL-LOCATION
Itemloc ITEMLOC Required
WHC-COMPANY->ITL-COMPANY
WHC-LOCATION->ITL-LOCATION
WHC-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
WHC-ITEM->ITE-ITEM
Shipline WHSHIPLINE Required
WHC-COMPANY->WHL-COMPANY
WHC-LOCATION->WHL-LOCATION
WHC-SHIPMENT-NBR->WHL-SHIPMENT-NBR
WHC-LINE-NBR->WHL-LINE-NBR
Shipment WHSHIPMENT Required
WHC-COMPANY->WHS-COMPANY
WHC-LOCATION->WHS-LOCATION
WHC-SHIPMENT-NBR->WHS-SHIPMENT-NBR
Whdemndhdr WHDEMNDHDR Required
WHC-COMPANY->WDH-COMPANY
WHC-SYSTEM-CD->WDH-SYSTEM-CD
WHC-DOC-NBR->WDH-DOC-NBR


WHSHIPCOMP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Shiplnedtl WHSHLDTL
WHC-COMPANY->WHD-COMPANY
WHC-LOCATION->WHD-LOCATION
WHC-SHIPMENT-NBR->WHD-SHIPMENT-NBR
WHC-LINE-NBR->WHD-LINE-NBR
WHC-COMPONENT-SEQ->WHD-COMPONENT-SEQ
  WHD-BIN
  WHD-LOT
  WHD-SUBLOT
  WHD-UOM
  WHD-SERIAL

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

Home
Contact Us



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