IGT BI Data Export

 

Back Office > Data Export > Export IGT BI Data

 

Description

 

This menu item is used to Export sales data for IGT BI. Exporting can also be included as part of the End of Day process.

 

To Be Considered

 

  1. Note : Cancelled Sales related data will NOT be exported.
  2. Sales data is exported to CSV type files with the following naming convention:
     
    1. IGTItemExtract_YYYYMMDD.csv
    2. IGTTenderExtract_YYYYMMDD.csv
    3. IGTTransactionExtract_YYYYMMDD.csv

 


Export IGT BI Data

 

 

This screen is accessed from here.

 

Export Filters

 

  • From/To - Select from the drop down calendar the date range for which sales data is to be exported. Files exported will be in CSV format and where data is available will be created for each day in the date range selected. For more information ...
  • Location Group - Select from the drop down list the Location Group (Venue) for which sales data is to be exported or select << ALL >.
  • Export Path - Select/Enter the path/folder to which the exported sales data will be written.

 

Footer

 

  • Export - Select to create multiple daily CSV type files in the Export Path selected.
  • Reset - Select to open the Reset Sales Export Flag screen below to reset the export export flag for a selected Trading date.
  • Close - Select to exit.

 


Reset Sales Export Flag

 

 


Export IGT BI Data File Formats

 

  1. IGTItemExtract_YYYYMMDD.csv
     

Field Name

Field Description

Field Type

POSTransactionNumber

Transaction Number

Numeric

POSCheckNumber

Receipt Number

Numeric

ItemNumber

PLU Number

Numeric

Description

Product Description

Alphanumeric

ItemCategory

Category Description

Alphanumeric

ItemType

Master Group

Alphanumeric

SaleAmount

Sales Price (Incl.)

Numeric

Quantity

Quantity Sold

Numeric

 

  1. IGTTenderExtract_YYYYMMDD.csv
     

Field Name

Field Description

Field Type

POSTransactionNumber

Transaction Number

Numeric

POSCheckNumber

Receipt Number

Numeric

TenderType

Media Name

Alphanumeric

SaleAmount

Sales Amount (Incl.)

Numeric

DiscountAmount

Discount Amount

Numeric

 

  1. IGTTransactionExtract_YYYYMMDD.csv
     

Field Name

Field Description

Field Type

POSTransactionNumber

Transaction Number

Numeric

POSCheckNumber

Receipt Number

Numeric

PatronCardNumber

Member ID

Numeric

CashierNumber

Clerk ID

Numeric

CashierName

Clerk Name

Alphanumeric

WorkstationCostCentreName

Location Name

Alphanumeric

WorkstationID

Terminal ID

Numeric

SaleAmount

Sales Amount (Incl.)

Numeric

DiscountAmount

Discount Amount

Numeric

PointsRedeemed

Points Redeemed

Numeric

PointsAccrued

Points Awarded

Numeric

TransactionDate

Transaction Date

Date

TransactionTime

Transaction Time

Time

 


Related Topics

 

  1. Data Export
  2. End of Day
  3. Import/Export Overview