Worklogs

Column	Format	Contents
SalesPersonExternalId	varchar(5)	Sales person ID.
Description	varchar(22)	Description of the event.
RunningUniqueNo	int	Sales data row ID.
EventId	int	Sales data receipt row ID.
ReceiptId	int	Sales data receipt ID.
CashierId	varchar(6)	Sales data cashier ID.
ShopId	varchar(6)	Store ID.
PosId	varchar(4)	POS ID.
RowType	varchar(7)	Work log event type (In/Out/Unknown).
Created	datetime	Timestamp of worklog.

Example Data

SQL

SELECT TOP 10 *
  FROM dbo.Worklogs

^{SalesPersonExternalId}	^Description	^{RunningUniqueNo}	^EventId	^ReceiptId	^CashierId	^ShopId
¹	^None	⁶⁶⁰	⁴³⁴³⁶	⁹⁸⁷⁰	¹	¹
¹	^None	⁶⁶¹	⁴³⁴³⁷	⁹⁸⁷⁰	¹	¹
¹	^None	⁷⁴³	⁴³⁵⁴⁹	⁹⁸⁹⁷	¹	¹
¹	^None	⁷⁴⁴	⁴³⁵⁵⁰	⁹⁸⁹⁷	¹	¹
¹	^None	⁷⁸⁸	⁴³⁵⁹⁵	⁹⁹¹⁰	¹	¹
¹	^None	⁷⁸⁹	⁴³⁵⁹⁶	⁹⁹¹⁰	¹	¹
¹	^None	⁹⁵⁷	⁴⁴⁰³⁴	⁹⁹⁸²	¹	¹
¹	^None	¹²¹⁸	⁴⁴⁵⁸⁰	¹⁰⁰⁸⁴	¹	¹
¹	^None	¹²²¹	⁴⁴⁵⁸³	¹⁰⁰⁸⁴	¹	¹
¹	^None	¹²²²	⁴⁴⁵⁸⁴	¹⁰⁰⁸⁴	¹	¹