Tran Data

This field contains unique alphanumeric identifier for the item on the transaction.

This field contains the Department number associated with the item for which transaction records are posted.

This field contains the Class number associated with the item for which transaction records are posted.

This field contains the Subclass number associated with the item for which transaction records are posted.

This field indicates whether or not the item is a pack item. Since transaction data records are not posted for pack items, this field is not used anymore and is defaulted to either NULL or N.

This field contains type of the location for which the transaction is posted. Valid Values are : S = Store , W = Warehouse, E = External Finisher.

This field contains the unique identifier for the location for which the transaction is posted. The location will be a store if Location type is S, a Warehouse or Internal Finisher if Location type is W and a External Finisher if Location type is E.

This field contains the date at which the transaction record was recorded into the transaction data table.

This field contains the unique numerical code to identify different transaction types.

This field indicates the type of adjustment for which this record is written to correct a previous error. Valid values are: C- Cost adjustment U - Unit adjustment A - ALC (Actual Landed Cost) adjustment.

This field contains the number of units of the item involved in the transaction.

This field contains the total cost associated of the transaction in the local currency of the location where the transaction took place.

This field contains the total retail value of the transaction in the local currency of the location where the transaction took place.

This field contains the Reference number associated with the transaction. The reference number can be used for identifying related transactions or reporting purposes, etc. For example, this field would contain the order number for a transaction type of 20 related to purchase orders.

This field contains the Reference number associated with the transaction. The reference number can be used for identifying related transactions or reporting purposes, etc. For example, The value could be an order number, an Advance Shipment Notification identifying number, a promotion number, etc.

This field contains the reference number associated with a transaction. It is used for defining the General Ledger account relationship along with dept, class, subclass, location, and tran_code, etc. For example: if tran_code is 22 or 23, then this field contains an Inventory Adjustment Reason Code; if tran_code is 37 or 38, then this field contains From_loc or To_loc for the Intercompany Transfer; if tran_code is 63 or 64, then this field contains Work Order Activity ID; if tran_code is 87 or 88, then this field contains the VAT code associated with the transaction.

This field contains the old unit retail of the item before the change taking place becuase of markup or mardown activities, recorded in the transaction types 11 to 16. This field is populated only for these transaction codes, otherwise, it will remain empty. This field is stored in the local currency.

This field contains the new unit retail of the item because of the change in the original retail. The change in the original retail takes place becuase of markup or mardown activities and recorded in the transaction types 11 to 16. This field is populated only for these transaction codes, otherwise, it will remain empty. This field is stored in the local currency.

This field identifies the Oracle Retail module which inserted the record into the transaction data table.

This field contains the type of sale for an item. Valid values are Regular, Clearance, and Promotion. This field will only contain a value for Net Sales transaction records (transaction code - 1).

This field contains the Vat rate at the selling store and recorded only for Net Sales transaction records (transaction code -1). For other transaction records, it remains empty.

This field contains the average cost for the item from the SKU/Location table only for the Net Sales transaction record (transaction code - 1) and held in the local currency of the location.

This field contains the time at which the transaction record was recorded into the transaction data table.

This field is used to store pack number for transaction items if it was part of a pack.

This field contains the transaction cost exclusive of Estimate Landed Cost for the Purchases transaction (Transaction Code - 20).

This field is always equal to the current RMS system date at which the transaction record was inserted into the transaction data table.

This field contains the import purchase order location type used for deal income calculation.

This field contains the import purchase order location used for deal income calculation.

This field contains the total cost value of the transaction in the local currency of the import purchase order location used for deal income calculation.

This field contains the total retail value of the transaction in the local currency of the import purchase order location used for deal income calculation.

Contains the unique identifier for a sale transaction.

Contains the unique identifier for a sale file.

This is a sequence-based ID to uniquely identify a TRAN_DATA record. As of now, this only holds a value when the inventory layer tracking functionality is used and only for tran_code 30/32.