Lawson Insight Technical Documentation |
|
WHSHIPCOMP
WHSHIPCOMP FILE
Shipment Line Kit Component
The Shipment Line Kit Component file contains shipment line records for
component items.
REFERENCED BY
BL123 WHD3.1
UPDATED BY
BL92.1 RQ300 WH130 WH132 WH190 WH222
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.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.7 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 WHD0.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHC-COMPANY Numeric 4 BL92.1 WH130
Element: Company This field contains the company number. 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
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-SYSTEM-CD Alpha 2 BL92.1 WH130
Element: System Cd This field indicates on which Lawson WH132 WH190
system the document originated. WH30.1 WH30.2
OE = Customer Order WH30.3 WH30.4
RQ = Requisitions WH31.1 WH31.2
CX = Case Cart WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHC-DOC-NBR Alpha 10 (Right Justified) BL92.1 WH130
Element: Doc Nbr This field contains the document number WH132 WH190
associated with the shipment line. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-LOCATION Alpha 5 BL92.1 WH130
Element: Location This field contains a valid stock WH132 WH190
location within the company inventory. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-SHIPMENT-NBR Numeric 10 BL92.1 WH130
Element: Shipment Nbr This field contains the shipment WH132 WH190
number. One document can have several WH30.1 WH30.2
shipment numbers if the items were not WH30.3 WH30.4
shipped at the same time. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-LINE-NBR Numeric 6 BL92.1 WH130
Element: Line Nbr This field contains the shipment line WH132 WH190
number. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-COMPONENT-SEQ Numeric 3 BL92.1 WH130
Element: Seq This field contains the component WH132 WH190
sequence number of the component item. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-ITEM Alpha 32 BL92.1 WH130
Element: Item This field contains the item WH132 WH190
identifier. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-QUANTITY Signed 13.4 BL92.1 WH130
Element: Quantity This field contains the requested WH132 WH190
quantity of the item. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHC-DETAIL-QTY Signed 13.4 BL92.1 WH130
Element: Detail QuantitThis field shows the total quantity of WH132 WH190
all details assigned to component items. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
WHC-DETAIL-REQ Alpha 1 BL92.1 WH130
Element: Detail RequireThis field indicates whether component WH132 WH190
items require details to be assigned. WH30.1 WH30.2
Y = Yes WH30.3 WH30.4
N = No WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHC-UNIT-COST Signed 18.5 BL92.1 WH130
Element: Intl Cost This field contains the unit cost of WH132 WH190
the component item. 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.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHSHIPCOMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHCSET1 COMPANY BL123 BL92.1
LOCATION RQ300 WH130
SHIPMENT-NBR WH132 WH190
LINE-NBR WH222 WH30.1
COMPONENT-SEQ WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
...
WHCSET2 COMPANY Subset WH130 WH190
LOCATION Where (DETAIL-REQ = "Y" ) WH30.1 WH30.2
SHIPMENT-NBR WH31.1 WH31.2
LINE-NBR WH32.1 WH32.2
COMPONENT-SEQ WH33.1 WH33.2
ITEM WH33.3 WH33.4
WH34.1 WH34.2
WH34.3 WH34.4
WHCSET3 COMPANY WH33.7 WH34.1
LOCATION WH34.2 WH34.3
SHIPMENT-NBR WH34.4
COMPONENT-SEQ
LINE-NBR
WHSHIPCOMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WHC-COMPANY -> ICC-COMPANY
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 RELATED
NAME 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
|