Warehouse

A code that represents a warehouse. Validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; optional.

(Item) colr size othr

Four fields containing the item number and the SKU, a code that represents the special characteristics of an item, such as its color, width and size. These fields are validated against the Item table and the SKU table.

(Item) Alphanumeric, 12 positions; optional.

(SKU) Alphanumeric, three 4-position fields; optional.

Date

The date the transaction took place.

Numeric, 6 positions; optional.

Batch#

The number of the batch of the transaction.

Numeric, 7 positions; optional

Location

The code representing the area within the warehouse that contains the item or SKU. Validated against the Location table; see Creating and Maintaining Locations (WLOC).

Alphanumeric, 7 positions; optional

Transaction Code

A code that described the type of transaction performed; system-supplied codes that pertain to transactions include:

A Adjustment

C Customer Return

E Express Bill

G Item to Item Transfer

I Issue

M Make up Finished Good

R Receiving

T Transfer

V Return to Vendor

Additionally, the system creates a * transaction history record when you change the cost of a FIFO layer if you use FIFO Costing.

See Work with Inventory Transaction Codes (WITC).

Alphanumeric, 1 position; optional.

Reason

A code that represents the reason the inventory transaction was performed; not all transactions require codes. See Work with Inventory Transaction Reason Codes (WIT1).

Numeric, 2 positions; optional

User

The User ID of the person who performed the transaction.

Alphanumeric, 8 positions; optional.