WHSHPMNTIN FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSI-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
WSI-LOCATION Alpha 5
Location Code This field contains a valid stocking
location within the company inventory.
WSI-SHIPMENT-NBR Numeric 10
Shipment Number This 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.
WSI-BATCH-NBR Numeric 6
Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
WSI-STATUS Numeric 1
Status This field displays the status of the
transaction.
WSI-PROCESS-DATE Numeric 8 (yyyymmdd)
Process Date
WSI-UPDATE-TIME Numeric 6
Update Time This field contains the system time
when the record was updated.
WSI-GL-DATE Numeric 8 (yyyymmdd)
General Ledger Date This field contains the general ledger
posting date.
WSI-BOL-NBR Alpha 22
Bill of Lading This field contains the Bill of Lading
Number number.
WSI-CARRIER Alpha 9 (Right Justified)
Carrier Vendor This is the carrier vendor number. It
Number must be a valid vendor.
WSI-METHOD Alpha 10
Method Code The method.
WSI-TRANS-ID Alpha 20
Trans Id
WSI-FREIGHT-CODE Alpha 2
Freight Code This field contains the freight code.
This is must be valid in OEFRTCODE. This
determines whether carrier and charge
are allowed for the shipment.
WSI-FRT-CHG-CURR Signed 15.2
Frt Chg Curr
WSI-WHS-CARTONS Numeric 6
Whs Cartons
WSI-CUBIC-FEET Signed 9.3
Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
WSI-WEIGHT Signed 9.3
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
WSI-POD-RETRN-DT Numeric 8 (yyyymmdd)
Pod Retrn Dt This field contains the date the POD is
returned with an acknowledgment.
WSI-PICK-DATE Numeric 8 (yyyymmdd)
Pick Date This field contains the pick date.
The system date defaults.
WSI-PACK-DATE Numeric 8 (yyyymmdd)
Pack Date This field contains the pack date. The
system date defaults but can be
overridden if you are using OE20.1 (On
Line Allocation).
WSI-SHIP-DATE Numeric 8 (yyyymmdd)
Ship Date This field contains the ship date. If
left blank, the system date defaults.
WSI-CUST-PO-NBR Alpha 22
Customer P.O. Number
WSI-VENDOR Alpha 9 (Right Justified)
Vendor ID The vendor's identification code.
WHSHPMNTIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSISET1 COMPANY
LOCATION
SHIPMENT-NBR
WSISET2 COMPANY
LOCATION
PROCESS-DATE
SHIPMENT-NBR
WSISET3 COMPANY
LOCATION
BATCH-NBR
WHSHPMNTIN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Whshcrtnin WHSHCRTNIN
WSI-COMPANY -> WCN-COMPANY (WCNSET1)
WSI-LOCATION -> WCN-LOCATION
WSI-SHIPMENT-NBR -> WCN-SHIPMENT-NBR
WCN-CARTON-NBR
Whshlinein WHSHLINEIN
WSI-COMPANY -> WLI-COMPANY
WSI-LOCATION -> WLI-LOCATION
WSI-SHIPMENT-NBR -> WLI-SHIPMENT-NBR
WLI-LINE-NBR
|
