WHSHPMNTIN

UPDATED BY
WH52.1 WH520

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSI-COMPANY
Element: Company
Numeric 4
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.
WH52.1
WSI-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
WH52.1
WSI-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
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.
WH52.1
WSI-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
WH52.1
WSI-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
WH52.1
WSI-PROCESS-DATE
Element: Process Date
Numeric 8 (yyyymmdd)
WH52.1
WSI-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
WH52.1
WSI-GL-DATE
Element: Gl Date
Numeric 8 (yyyymmdd)
This field contains the general ledger posting date.
WH52.1
WSI-BOL-NBR
Element: Bol Nbr
Alpha 22
This field contains the Bill of Lading number.
WH52.1
WSI-CARRIER
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
WH52.1
WSI-METHOD
Element: Method
Alpha 10
The method.
WH52.1
WSI-TRANS-ID
Element: Trans Id
Alpha 20
WH52.1
WSI-FREIGHT-CODE
Element: Freight Code
Alpha 2
This field contains the freight code. This is must be valid in OEFRTCODE. This determines whether carrier and charge are allowed for the shipment.
WH52.1
WSI-FRT-CHG-CURR
Element: Intl Amt
Signed 18.2
WH52.1
WSI-WHS-CARTONS
Element: Whs Cartons
Numeric 6
WH52.1
WSI-CUBIC-FEET
Element: Cubic Feet
Signed 9.3
This field contains the unit cubic feet of the item based on the stocking UOM.
WH52.1
WSI-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
WH52.1
WSI-POD-RETRN-DT
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WH52.1
WSI-PICK-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WH52.1
WSI-PACK-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WH52.1
WSI-SHIP-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WH52.1
WSI-CUST-PO-NBR
Element: Cust Po Nbr
Alpha 22
WH52.1
WSI-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
WH52.1
WSI-EXT-ACCT-ENT
Element: Ext Acct Ent
Alpha 22 (Lower Case)
WH52.1
WSI-EXT-LOCATION
Element: Ext Location
Alpha 22 (Lower Case)
WH52.1
WSI-EXT-SHIP-NBR
Element: Ext Ship Nbr
Alpha 100 (Lower Case)
WH52.1
WSI-GLBL-DOC-TYPE
Element: Glbl Doc Type
Alpha 10
WH52.1
WSI-WHS-USR-FLD-01
Element: Whs Usr Fld 01
Alpha 20
WH52.1
WSI-WHS-USR-FLD-02
Element: Whs Usr Fld 02
Alpha 20
WH52.1
WSI-WHS-USR-FLD-03
Element: Whs Usr Fld 03
Alpha 20
WH52.1
WSI-WHS-USR-FLD-04
Element: Whs Usr Fld 04
Alpha 20
WH52.1
WSI-WHS-USR-FLD-05
Element: Whs Usr Fld 05
Alpha 20
WH52.1


WHSHPMNTIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSISET1 COMPANY
LOCATION
SHIPMENT-NBR
WH52.1 WH52.2
WH52.3 WH52.4
WH52.5 WH520
WSISET2 COMPANY
LOCATION
PROCESS-DATE
SHIPMENT-NBR
WSISET3 COMPANY
LOCATION
BATCH-NBR
SHIPMENT-NBR


WHSHPMNTIN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Whshtrkin WHSHTRKIN
WSI-COMPANY->WTI-COMPANY
WSI-LOCATION->WTI-LOCATION
WSI-SHIPMENT-NBR->WTI-SHIPMENT-NBR
  WTI-TRACKING-NBR


File created: Thu Jun 09 02:33:57 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.