Tsfdetail

This field contains a number that uniquely identifies the transfer within the system.

This field contains a sequence number when combined with the transfer number will make this row unique. This field is used to make up the primary key. A unique key is placed on the columns (tsf_no, sku, prepack_id, inv_status), which would normally make up the key, but because the fields prepack_id and inv_status can contain nulls, a sequence is used for the primary key and a unique key is placed on the other keys.

This field holds the unique alphanumeric value that identifies the item.

This field contains the inventory status, if one exists, for the transfer detail record. The inventory status field corresponds to the inventory status type found on the INV_STATUS_TYPES table. If a value exists in this field and the tsfhead.inventory_status is Unavailable, then the transfer will move from the specified unavailable inventory disposition (e.g. Trouble, etc.) at the from location to the same unavailable inventory disposition at the to location.

This field holds the unit cost of the item that will be used for this specific transfer if being transferred at something other than current WAC. This field should only have a value for intercompany transfers.