TSF Item Cost

This is a system generated identifier, used as primary key for this table.

This field holds a valid transfer number on the transfer head uniquely identifying the transfer. For 2- legged transfer, this could be either the first leg or the second leg of the transfer.

This field contains the unique alphanumeric value identifying the item that is being transferred. In case of 2-legged transfers this will contain the item being transferred that particular leg of the transfer. For example, Item 1 can be trasformed to Item 2 in the 2nd leg of a 2-legged transfer.

This field holds the parent transfer number holding the different legs of the transfer and populated only for the second leg of a 2-legged transfer.

This field contains the total quantity of the item on the transfer.

This field holds the average transfer price of the item held in the ITEM column, i.e. if the ITEM is on first leg, this is the average transfer price of the first leg item. For second leg of a 2-legged transfer or single-legged transfers, this will be in the currency of the final receiving location and for For first leg of a 2-legged transfer, it will be in the currency of the initial sending location.

This field holds the total quantity of the item (held in ITEM column) that has been shipped. It is populated for the inter-company leg of the transfer, i.e. when crossing transfer entity, or ICT_LEG_IND = Y or single-legged (inter-company) transfer only.

This field contains the unique alphanumeric value identifying the item. This holds the transformed item if item in ITEM column is on the first leg of a 2-legged transfer and is transformed, and will be the item on the 2nd leg of transfer. This column is populated only for the first leg of the two-legged transfers.

This field specifies that the particular transfer is which leg of a 2-legged transfer or a single-legged transfer. Valid values are 1,2 and S.1= first leg of a 2-legged transfer, 2=second leg of a 2-legged transfer, S=single-legged transfer.

This field specifies which leg for 2-legged inter-company transfer is inter-company transfer and which one is intra-company. Possible values are Y, N and Null. Since in the case of 2-legged inter-company transfers, the finisher has to be part of the same transfer entity as one of the two locations, one leg of the transfer will be a inter-company transfer and other leg will be intra-compnay transfer. A Y value means this leg is the inter-company leg of a 2-legged inter-company transfer. A N value means this leg is the intra-company leg of a 2-legged inter-company transfer. NULL means single-legged transfer or intra-company 2-legged transfer.