 |
Lawson Insight Technical Documentation |
|
WHSHIPCOMP FILE
Shipment Line Kit Component
The Shipment Line Kit Component file contains shipment line records for
component items.
REFERENCED BY
BL123
UPDATED BY
WH130 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 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHC-COMPANY Numeric 4 WH130 WH33.1
Company This field contains the company number. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-SYSTEM-CD Alpha 2 WH130 WH33.1
System Code This field indicates on which Lawson WH33.2 WH33.3
system the document originated. WH33.4 WH33.5
OE = Customer Order WH33.6 WH33.8
RQ = Requisitions WH33.9 WH34.1
CX = Case Cart WH34.2 WH34.3
WH34.4
WHC-DOC-NBR Alpha 10 (Right Justified) WH130 WH33.1
Doc Nbr This field contains the document number WH33.2 WH33.3
associated with the shipment line. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-LOCATION Alpha 5 WH130 WH33.1
Location Code This field contains a valid stock WH33.2 WH33.3
location within the company inventory. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-SHIPMENT-NBR Numeric 10 WH130 WH33.1
Shipment Number This field contains the shipment WH33.2 WH33.3
number. One document can have several WH33.4 WH33.5
shipment numbers if the items were not WH33.6 WH33.7
shipped at the same time. WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-LINE-NBR Numeric 6 WH130 WH33.1
Line Number This field contains the shipment line WH33.2 WH33.3
number. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-COMPONENT-SEQ Numeric 3 WH130 WH33.1
Component Sequence This field contains the component WH33.2 WH33.3
Number sequence number of the component item. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-ITEM Alpha 32 WH130 WH33.1
Item Number This field contains the item WH33.2 WH33.3
identifier. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-QUANTITY Signed 13.4 WH130 WH33.1
Quantity This field contains the requested WH33.2 WH33.3
quantity of the item. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHC-DETAIL-QTY Signed 13.4 WH130 WH33.1
Detail Quantity This field shows the total quantity of WH33.2 WH33.3
all details assigned to component items. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHC-DETAIL-REQ Alpha 1 WH130 WH33.1
Detail Required This field indicates whether component WH33.2 WH33.3
items require details to be assigned. WH33.4 WH33.5
Y = Yes WH33.6 WH33.8
N = No WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHC-UNIT-COST Signed 13.5 WH130 WH33.1
Unit Cost This field contains the unit cost of WH33.2 WH33.3
the component item. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHSHIPCOMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHCSET1 COMPANY Primary index used for accessing and BL123 RQ300
LOCATION updating the table. WH130 WH33.1
SHIPMENT-NBR WH33.2 WH33.3
LINE-NBR WH33.4 WH33.5
COMPONENT-SEQ 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 WH33.1
LOCATION to have details assigned. WH33.2 WH33.3
SHIPMENT-NBR Subset WH33.4 WH34.1
LINE-NBR Where (DETAIL-REQ = "Y" ) WH34.2 WH34.3
COMPONENT-SEQ WH34.4
ITEM
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-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
|