WHSHIPCOMP FILE
Shipment Line Kit Component
The Shipment Line Kit Component file contains shipment line records for
component items.
REFERENCED BY
BL123 SA100
UPDATED BY
BL92.1 OE114 OE310 WH130 WH132 WH190
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 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 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 RQ300
WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHC-COMPANY Numeric 4 BL92.1 OE114
Company This field contains the company number. WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
System Code This field indicates on which Lawson WH130 WH132
system the document originated. WH190 WH30.1
OE = Customer Order WH30.2 WH30.3
RQ = Requisitions WH31.1 WH31.2
CX = Case Cart WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Document Number This field contains the document number WH130 WH132
associated with the shipment line. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Location This field contains a valid stock WH130 WH132
location within the company inventory. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Shipment Number This field contains the shipment WH130 WH132
number. One document can have several WH190 WH30.1
shipment numbers if the items were not WH30.2 WH30.3
shipped at the same time. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Line Number This field contains the shipment line WH130 WH132
number. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Component Sequence This field contains the component WH130 WH132
sequence number of the component item. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Item This field contains the item WH130 WH132
identifier. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Quantity This field contains the requested WH130 WH132
quantity of the item. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Detail Quantity This field shows the total quantity of WH130 WH132
all details assigned to component items. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 OE114
Detail Required This field indicates whether component WH130 WH132
items require details to be assigned. WH190 WH30.1
Y = Yes WH30.2 WH30.3
N = No WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 13.5 BL92.1 OE114
Unit Cost This field contains the unit cost of WH130 WH132
the component item. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 Primary index used for accessing and BL123 BL92.1
LOCATION updating the table. CX100 CX20.1
SHIPMENT-NBR CX20.2 CX20.4
LINE-NBR CX20.5 CX220
COMPONENT-SEQ CX30.1 CX300
CX506 OE114
OE310 RQ300
SA100 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
...
WHCSET2 COMPANY Used to find component items that need OE114 WH130
LOCATION to have details assigned. WH190 WH30.1
SHIPMENT-NBR Subset WH31.1 WH32.1
LINE-NBR Where (DETAIL-REQ = "Y" ) WH33.1 WH33.2
COMPONENT-SEQ WH33.3 WH33.4
ITEM WH34.1 WH34.2
WH34.3 WH34.4
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-ITEM -> ITL-LOCATION
WHL-LOCATION -> 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-COMPANY -> 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
|