|
|
WHSHLDTLIN FILE
UPDATED BY
WH52.2 WH520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WDI-COMPANY Numeric 4 WH52.2
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
WDI-LOCATION Alpha 5 WH52.2
Element: Location Code This field contains a valid stocking
location within the company inventory.
WDI-SHIPMENT-NBR Numeric 10 WH52.2
Element: Shipment NumbeThis field contains the shipment
number. One order can have several
shipment numbers if the items of the
order were not shipped at the same time.
WDI-LINE-NBR Numeric 6 WH52.2
Element: Line Number This field contains the line number.
WDI-COMPONENT-SEQ Numeric 3 WH52.2
Element: Sequence NumbeThis field contains the component
sequence number.
WDI-BIN Alpha 7 WH52.2
Element: Bin This field contains a storage area for
an item or any number of items.
WDI-LOT Alpha 10 WH52.2
Element: Lot Number This field contains the identifier for
the homogeneous quantity of material.
WDI-SUBLOT Alpha 6 WH52.2
Element: Sublot Number This field contains the identifier for
a detail breakdown of a lot number.
WDI-SERIAL Alpha 16 WH52.2
Element: Serial Number
WDI-UOM Alpha 4 WH52.2
Element: Unit of MeasurThis field contains the valid stock
unit of measure for this item.
WDI-PROCESS-DATE Numeric 8 (yyyymmdd) WH52.2
Element: Process Date
WDI-UPDATE-TIME Numeric 6 WH52.2
Element: Update Time This field contains the system time
when the record was updated.
WDI-UOM-MULT Signed 13.7 WH52.2
Unit of Measure This field contains the multiplier for
Multiplier converting this unit of measure to the
stock unit of measure.
WDI-QUANTITY Signed 13.4 WH52.2
Element: Quantity This field contains the desired
quantity.
WDI-CATCH-WT-QTY Signed 13.4 WH52.2
Element: Quantity This field contains the quantity
received for catch weight shipments.
WHSHLDTLIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WDISET1 COMPANY WH52.1 WH52.2
LOCATION WH520
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
BIN
LOT
SUBLOT
SERIAL
UOM
WDISET2 COMPANY
LOCATION
PROCESS-DATE
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
BIN
LOT
SUBLOT
SERIAL
UOM
WHSHLDTLIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whshlinein WHSHLINEIN Required
WDI-COMPANY -> WLI-COMPANY (WLISET1)
WDI-LOCATION -> WLI-LOCATION
WDI-SHIPMENT-NBR -> WLI-SHIPMENT-NBR
WDI-LINE-NBR -> WLI-LINE-NBR
|
