Transaction log data type (TLOG)

The transaction log (T-log) data captures the transactional sales history, used to help determine demand.

The demand forecast helps to determine the inventory levels needed to fulfill orders. The transaction log data is used for computing inventory performance cost, including estimating the chances of a stock out and key indicators predicted velocity. Each transaction log file contains a single day of data.

File name and separator

This data type uses the pipe (|) separator.

The recommended format for the file name is: TLOG_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv

Multiple CSV files can be uploaded by compressing into a tar.gz file.

Fields

Table 1. The following table displays the fields and descriptions for the transaction log data type.
Field Name Required Type Description
Transaction ID Yes INT Unique transaction identifier for the transaction
POS register ID Yes INT Register at which the transaction occurred
Sales sequence number Yes INT Unique sequence number to identify the transaction
Transaction date Yes DATE Date on which transaction occurred, using the format YYYY-MM-DD
Transaction time Yes TIME Time at which transaction occurred, using the format HH:MM:SS
Node key Yes STRING Node at which the transaction occurred
Transaction line sequence number Yes INT Sequence number within a transaction
SKU number Yes STRING SKU for the transaction
Transaction quantity Yes DECIMAL Indicates quantity of products sold in the transaction
Transaction UOM No STRING Unit of Measure for the product. Valid values are:
  • Each
  • Case
  • Pallet
  • KG
  • Pound
If no measure is included, the default is each.
Transaction type Yes STRING
The following are possible types:
  • SALE: All items that scan as regular sales
  • RETN: All Items that are returned
  • EXCH: All Items that are exchanged.
  • ADJU: An adjustment that occurs against a line, such as discounts, gift cards

The sale scan type is used to roll up the weekly aggregation of the sales.
Item status code Yes STRING
The status code for this SKU-Node pair:
  • ACTIVE: Active
  • PROMO: On promotion
  • MKDOWN : On markdown
  • DISCONT: Discontinued
SKU total retail amount Yes DECIMAL Total regular SKU retail price without discount, not including taxes.
SKU total retail amount with discounts Yes DECIMAL Total price of the SKU with discount, not including taxes.
SKU total charged amount Yes DECIMAL Total amount charged to the customer for this SKU including customer specific discounts and without taxes.
OCF code Yes STRING Omnichannel fulfillment code to indicate how the order was fulfilled, such as:
  • Ship from store
  • Buy online
  • Store
Currency No STRING The currency that is associated with the SKU total. This value needs to be in the ISO three letter currency format. For example, USD, GBP, or EUR.

Sample for TLOG_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv

trn_nbr|pos_rgst_id|sls_corr_seq_nbr|trn_date|trn_ts|node_key|trn_line_seq_nbr|sku_id|trn_qty|trn_uom|trn_type|

trn_sku_status_code|trn_tot_rtl_amt|trn_tot_rtl_amt_with_disc|trn_tot_charged_amt|ocf_code|currency

111|1|2478|2018-01-30|18:12:00|00999|2|sku_122|1|EACH|SALE|MKDOWN|49.95|13.98|13.98|SFS|USD

222|6|2112|2018-01-30|18:47:00|00333|1|sku_877|1|EACH|SALE|ACTIVE|15.95|6.00|6.00|DFT|USD

222|3|2113|2018-01-30|15:42:00|00333|1|sku_554|1|EACH|SALE|ACTIVE|59.95|46.32|46.32|DFT|GBP

333|1|3344|2018-01-30|16:45:00|87878|1|sku_747|-1|EACH|RETN|ACTIVE|6.95|-6.95|-6.95|DFT|EUR

Sample script to upload data by using the file adapter

/<Install_dir>//AsperaClientLinuxDist/asperaTransferClient.sh -jobname TLOGPush 
-contentType TLOG -server -userid -password -op UPLOAD -src -dest/TLOG 
-conf /<Install_dir>//AsperaLinuxDist/asperaTransferOption.properties