Temp Tran Data

Unique identifier for the item

Department number associated with the SKU

Class number associated with the SKU

Subclass number associated with the SKU

Indicates whether or not the item is a pack item

This field contains the Location Type

This field contains the Store if the LOC_TYPE = S

Identifies the date the transaction was written

Identifies the transaction type

This field indicates the type of adjustment for which this record is written to correct a previous error

The number of units involved in the transaction

Contains the total cost associated with the transaction. This field is stored in the local currency.

Contains the retail value of the transaction. This field is stored in the local currency.

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.

Contains the old unit retail before the change for transaction types 11 to 16. Otherwise this field will be empty. This field is stored in the local currency.

Contains the newunit retail before the change for transaction types 11 to 16. Otherwise this field will be empty. This field is stored in the local currency.

Identifies the Oracle Retail module where the record was written

This field will contain the type of sale for SKU

This field will contain the VAT rate at the selling store

This field will contain the average cost for the SKU from the SKU/Location table

System generated Timestamp Oracle Retail target column TIMESTAMP on TEMP_TRAN_DATA.

Contains the unique identifier for a sale transaction.

Contains the unique identifier for a sale file.