 |
Lawson Insight Technical Documentation |
|
WHSHIPCOMP FILE
Shipment Line Kit Component
The Shipment Line Kit Component file contains shipment line records for
component items.
UPDATED BY
WH130 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 RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHC-COMPANY Numeric 4 WH130 WH132
Company This field contains the company number. 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 WH130 WH132
System Code This field indicates on which Lawson WH190 WH30.1
system the document originated. WH30.2 WH30.3
OE = Customer Order WH30.4 WH31.1
RQ = Requisitions WH31.2 WH31.3
CX = Case Cart 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) WH130 WH132
Doc Nbr This field contains the document number WH190 WH30.1
associated with the shipment line. 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 WH130 WH132
Location Code This field contains a valid stock WH190 WH30.1
location within the company inventory. 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 WH130 WH132
Shipment Number This field contains the shipment WH190 WH30.1
number. One document can have several WH30.2 WH30.3
shipment numbers if the items were not WH30.4 WH31.1
shipped at the same time. 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 WH130 WH132
Line Number This field contains the shipment line WH190 WH30.1
number. 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 WH130 WH132
Component Sequence This field contains the component WH190 WH30.1
Number sequence number of the component item. 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 WH130 WH132
Item Number This field contains the item WH190 WH30.1
identifier. 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 WH130 WH132
Quantity This field contains the requested WH190 WH30.1
quantity of the item. 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 WH130 WH132
Detail Quantity This field shows the total quantity of WH190 WH30.1
all details assigned to component items. 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 WH130 WH132
Detail Required This field indicates whether component WH190 WH30.1
items require details to be assigned. WH30.2 WH30.3
Y = Yes WH30.4 WH31.1
N = No 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 13.5 WH130 WH132
Unit Cost This field contains the unit cost of WH190 WH30.1
the component item. 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 Primary index used for accessing and RQ300 WH130
LOCATION updating the table. WH132 WH190
SHIPMENT-NBR WH222 WH30.1
LINE-NBR WH30.2 WH30.3
COMPONENT-SEQ 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
...
WHCSET2 COMPANY Used to find component items that need WH130 WH190
LOCATION to have details assigned. WH30.1 WH30.2
SHIPMENT-NBR Subset WH31.1 WH31.2
LINE-NBR Where (DETAIL-REQ = "Y" ) 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 This index was created as a solution to WH33.7 WH34.1
LOCATION the Find Next/Prev Flag error. It is WH34.2 WH34.3
SHIPMENT-NBR only used where a modify must be done WH34.4
COMPONENT-SEQ within a 850-FIND-NLT or 850-FIND-BEGRNG
LINE-NBR loop.
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
|