WLEM Master file

This table shows the fields and descriptions for the WLEM Master file:

Field

Description

Actual Qty The actual quantity that is entered into the system, expressed in stocking units.
Address The address from the master file.
Adjustment Code The adjustment code is sent by TWL based on the transaction.
Adjustment Reason The transaction type from TWL.
Analysis Code The ABC Classification code from Product Warehouse Product Setup-WL Setup that is released to TWL.
Bin Loc 1 The bin locations on the Product Warehouse Product Setup record.
Bin Loc 2 The bin locations on the Product Warehouse Product Setup record.
Case Qty The field from the Product Warehouse Product Setup-WL Setup that is released to TWL.
Category

The product category from the Product Setup record.

Code/Carrier

The SA Table Code Value Setup record that is being transferred to TWL.
Counter Bin The counter location from Product Warehouse Product Setup-WL Setup that is released to TWL.
Country The country in which the TWL warehouse resides.
Cross Reference The vendor’s part number.

Cube

The product’s cubic dimensions from Product Setup.
DUNS # The number from the Vendor Setup that is released to TWL.
EDI Cd The EDI code from Vendor Setup that is released to TWL.
Expected Qty The quantity that the system expected. The quantity is expressed in stocking units.
Extended Type The product’s serial or lot designation from the Product Warehouse Product Setup record.
Fax Phone The fax number from Vendor Setup that is released to TWL.
Function The system function that contains the static data. These functions are listed in the file as a character code:
  • icsp: Product Setup
  • icsw: Product Warehouse Product Setup
  • icsd: Product Warehouse Description Setup
  • sasc: SA Company Setup
  • sastt: SA Table Code Value Setup
  • wtee: Transfer Exception Receipt Entry
  • wl: Warehouse Logistics
Height The product’s height from the Product Setup record.
Inner Pack The field from the Product Warehouse Product Setup-WL Setup that is released to TWL.
Kit Build Dept The department the prebuilt kit is assembled in, from the Product Warehouse Product Setup-WL Setup that is released to TWL.
Kit Type If the product is a kit, the type of kit from Product Setup is displayed.
Length The product’s length, from the Product Setup record.
MSDS Product Indicates whether this product requires an MSDS sheet.
MSDS Sheet # The information sheet that is associated with the MSDS product.
Name Depending on the master file, the name of the company or warehouse, for example.
Our Product The system product number that is cross-referenced to a vendor’s product number.
Pallet Qty The field from the Product Warehouse Product Setup-WL Setup that is released to TWL.
Phone The phone number from Vendor Setup that is released to TWL.
Product The system’s product name.
Salesrep The sales representative from Vendor Setup that is released to TWL.
Ship From The ship-from location from Vendor Setup that is released to TWL.
Spec/Non-stock For stock adjustments, the special or nonstock designation.
Stat These status types are listed in the file as a letter:
  • A: Active; records are ready for processing
  • I: Inactive; records have been processed and are ready for deletion
  • O: Open; records are in the process of building the transaction files in the system
  • E: Error; records were found during processing
  • W: Work in Process; records are in the process of being transmitted
  • V: Vendor Return; records are held for manual release
Status The Product Setup or Product Warehouse Product Setup product status.
Stk Qty The number of stocking units in a cross-reference unit for a product.
Table Type The SA Table Code Value Setup type that is transferred to TWL.
Type The cross-reference type.
Unit/Unit Stock The stocking unit from the product’s Product Setup record.
Update Type These transactions are listed in the file as:
  • a: add
  • c: change
  • d: delete
Vendor # The Vendor Setup vendor number that is released to TWL.
Weight The product’s weight, from the Product Setup record.
Whse Zone The field from the Product Warehouse Product Setup-WL Setup that is released to TWL.
Width The product’s width, from the Product Setup record.