Mrt

Mass Return Transfer No. Unique number identifying the mass return transfer, populated by an oracle sequence.

A descriptive name for the MRT to make identification of an MRT easier.

The Warehouse which will be receiving the merchandise from the MRT. This is the primary key to the table WH.

Depending on the setting of the system_options RTV/RAC indicator, this field needs to be specified to be across legal entities or not. If the indicator is set to intra-company transfer, then the value will default to intra-company transfer. If the indicator is set to inter-company transfer, then the user can select inter-company or intra-company. This selection will determine if the transfer price or transfer cost is editable on an Mass Return Transfer.

The status of the Mass Return Transfer. Valid values are: I - Input S - Submitted A - Approved R - RTV created C - Closed

This field holds the last day upon which a store can ship the requested merchandise to the warehouse.

Contains the values Available or Unavailable to indicate what type of stock is being returned CODE_TYPE = TSIT.

Indicates whether to include the entire available SOH for the Mass Return Transfer, or a manually entered quantity CODE_TYPE = QYTP

The currency code that the user will see the whole of the mass transfer in.

The date the Mass Return Transfer status was set to Closed.

Additional information concerning the MRT or RTV.

Supplier number for RTV. Oracle Retail target column SUPPLIER on MRT.

This is the Rtv reason used in creating the RTV record and the values of which are held in the CODE_HEAD CODE_TYPE LTVR.

The date upon which the RTV will be auto- generated. If this date is not filled in, the RTV will never be auto generated.

This date indicates the last date that an RTV can be send to a supplier. It will populate the not after date on the RTV_HEAD table.

tatus of the RTV. This will only be activated if the RTV creation date has been entered. CODE_TYPE = RTVS.

Authorisation Number for the RTV: user-entered, usually furnished by the supplier.

The percentage of cost charged by the supplier for re-stocking.

Indicates whether to include the existing receiving warehouse quantities in the RTV.

Holds the date when the associated transfers have been created.