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 SA100
UPDATED BY
BL92.1 OE114 OE310 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 BL92.1 OE114
Element: Company This field contains the company number. 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
WHC-SYSTEM-CD Alpha 2 BL92.1 OE114
Element: 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 WH30.4 WH31.1
CX = Case Cart 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-DOC-NBR Alpha 10 (Right Justified) BL92.1 OE114
Element: Doc Nbr This field contains the document number WH130 WH132
associated with the shipment line. 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-LOCATION Alpha 5 BL92.1 OE114
Element: Location Code This field contains a valid stock WH130 WH132
location within the company inventory. 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-SHIPMENT-NBR Numeric 10 BL92.1 OE114
Element: Shipment NumbeThis 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. 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-LINE-NBR Numeric 6 BL92.1 OE114
Element: Line Number This field contains the shipment line WH130 WH132
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-COMPONENT-SEQ Numeric 3 BL92.1 OE114
Element: Sequence NumbeThis field contains the component WH130 WH132
sequence number of the component item. 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-ITEM Alpha 32 BL92.1 OE114
Element: Item Number This field contains the item WH130 WH132
identifier. 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-QUANTITY Signed 13.4 BL92.1 OE114
Element: Quantity This field contains the requested WH130 WH132
quantity of the item. 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.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
Element: Detail QuantitThis field shows the total quantity of WH130 WH132
all details assigned to component items. 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-DETAIL-REQ Alpha 1 BL92.1 OE114
Element: Detail RequireThis field indicates whether component WH130 WH132
items require details to be assigned. WH190 WH30.1
Y = Yes WH30.2 WH30.3
N = No 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-UNIT-COST Signed 18.5 BL92.1 OE114
Element: Intl Cost This field contains the unit cost of WH130 WH132
the component item. 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.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. OE114 OE310
SHIPMENT-NBR RQ300 SA100
LINE-NBR WH130 WH132
COMPONENT-SEQ 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
...
WHCSET2 COMPANY Used to find component items that need OE114 WH130
LOCATION to have details assigned. WH190 WH30.1
SHIPMENT-NBR Subset WH30.2 WH31.1
LINE-NBR Where (DETAIL-REQ = "Y" ) WH31.2 WH32.1
COMPONENT-SEQ WH32.2 WH33.1
ITEM WH33.2 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
|