|
|
WHSHPMNTIN FILE
UPDATED BY
WH52.1 WH520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSI-COMPANY Numeric 4 WH52.1
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.
WSI-LOCATION Alpha 5 WH52.1
Element: Location Code This field contains a valid stocking
location within the company inventory.
WSI-SHIPMENT-NBR Numeric 10 WH52.1
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.
WSI-BATCH-NBR Numeric 6 WH52.1
Element: Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
WSI-STATUS Numeric 1 WH52.1
Element: Status This field displays the status of the
transaction.
WSI-PROCESS-DATE Numeric 8 (yyyymmdd) WH52.1
Element: Process Date
WSI-UPDATE-TIME Numeric 6 WH52.1
Element: Update Time This field contains the system time
when the record was updated.
WSI-GL-DATE Numeric 8 (yyyymmdd) WH52.1
Element: General LedgerThis field contains the general ledger
posting date.
WSI-BOL-NBR Alpha 22 WH52.1
Bill of Lading This field contains the Bill of Lading
Number number.
WSI-CARRIER Alpha 9 (Right Justified) WH52.1
Element: Vendor ID This is the carrier vendor number. It
must be a valid vendor.
WSI-METHOD Alpha 10 WH52.1
Element: Method Code The method.
WSI-TRANS-ID Alpha 20 WH52.1
Element: Trans Id
WSI-FREIGHT-CODE Alpha 2 WH52.1
Element: 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 18.2 WH52.1
Element: Intl Amt
WSI-WHS-CARTONS Numeric 6 WH52.1
Element: Whs Cartons
WSI-CUBIC-FEET Signed 9.3 WH52.1
Element: Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
WSI-WEIGHT Signed 9.3 WH52.1
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
WSI-POD-RETRN-DT Numeric 8 (yyyymmdd) WH52.1
Element: Date This field contains the date the POD is
returned with an acknowledgment.
WSI-PICK-DATE Numeric 8 (yyyymmdd) WH52.1
Element: Date This field contains the pick date.
The system date defaults.
WSI-PACK-DATE Numeric 8 (yyyymmdd) WH52.1
Element: 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) WH52.1
Element: Date This field contains the ship date. If
left blank, the system date defaults.
WSI-CUST-PO-NBR Alpha 22 WH52.1
Element: Customer P.O. Number
WSI-VENDOR Alpha 9 (Right Justified) WH52.1
Element: Vendor ID The vendor's identification code.
WHSHPMNTIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSISET1 COMPANY WH52.1 WH52.2
LOCATION WH52.3 WH52.4
SHIPMENT-NBR WH520
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
|
