| Name | Description | Type | Additional information |
|---|---|---|---|
| SaleHeaderID | integer |
None. |
|
| SaleHeaderGuid |
Identifier to prevent duplicate processing |
Collection of byte |
None. |
| SaleHeaderIdentifierGuid | globally unique identifier |
None. |
|
| Created |
Created timestamp |
date |
None. |
| CreatedLocal |
Local created timestamp |
date |
None. |
| CreatedText |
Date and time printed on the receipt |
string |
None. |
| ItemCount |
Count of all details in sale |
integer |
None. |
| TotalAmount |
Tax inclusive sale value in cents |
integer |
None. |
| CashTender |
Cash tendered value in cents |
integer |
Data type: Currency |
| CardTender |
Card/eft tendered value in cents |
integer |
Data type: Currency |
| CheqTender |
Cheque tendered value in cents |
integer |
Data type: Currency |
| AcctTender |
Account tendered value in cents |
integer |
Data type: Currency |
| VoucherTender |
Voucher tendered value in cents |
integer |
Data type: Currency |
| LoyaltyPoints |
The value of earned points or zero if only redeemed |
integer |
None. |
| Cashout |
Cashout given in cents |
integer |
Data type: Currency |
| ChangeAmount |
Change given in cents |
integer |
Data type: Currency |
| Rounding |
Value in cents added to the total to round transaction |
integer |
None. |
| GstAmount |
Amount of GST in cents |
integer |
None. |
| TransactionDiscountTender | integer |
None. |
|
| TotalTip |
Total Amount tipped during sale |
integer |
None. |
| TranType |
The sale transaction type |
TransactionType |
None. |
| Processed |
If the sale has been processed |
Processed |
None. |
| Imported | date |
Data type: DateTime |
|
| StoreID |
Identifier of the store sale was performed at |
integer |
None. |
| OperatorG_Uid |
Identifier of the Operator that performed the sale |
Collection of byte |
None. |
| OperatorGuid |
Human readable version of the OperatorG_Uid |
globally unique identifier |
None. |
| CustomerG_Uid |
Identifier of the customer that initiated the sale |
Collection of byte |
None. |
| CustomerGuid |
Human readable version of the CustomerG_Uid |
globally unique identifier |
None. |
| CommunityIdentifier |
Identifier of the community associated with the sale |
Collection of byte |
None. |
| CommunityIdentifierGuid |
Human readable version of the CommunityIdentifier |
globally unique identifier |
None. |
| SaleIdentifier |
The unique identifier printed on the receipt |
string |
String length: inclusive between 0 and 20 |
| DeptNo | integer |
None. |
|
| ZoneID | integer |
None. |
|
| OperatorID |
Local operator ID |
integer |
None. |
| VoucherForegone |
Amount of voucher value "overage" to sale in cents |
integer |
None. |
| CardName | string |
String length: inclusive between 0 and 16 |
|
| AccountType | integer |
None. |
|
| AuthID | string |
String length: inclusive between 0 and 16 |
|
| BankRef | string |
String length: inclusive between 0 and 16 |
|
| InvRoc | string |
String length: inclusive between 0 and 16 |
|
| ResponseCode | string |
String length: inclusive between 0 and 4 |
|
| OrderNo | integer |
None. |
|
| AccountNo | integer |
None. |
|
| MachineID |
The identifier of machine transaction was performed at |
integer |
None. |
| TimeInSale |
Time the Operator spent in the entire Sale |
time interval |
None. |
| TimeInSubtotal |
Time the Operator spent in Subtotal |
time interval |
None. |
| NewID |
This will be the id in the master if for some reason only a partial upload occurs |
integer |
None. |
| TotalTaxInclusive |
The total value of taxable items (including tax) in cents |
integer |
None. |
| TotalTaxExempt |
The total value of tax exempt items in cents |
integer |
None. |
| TaxTransactionDiscount | integer |
None. |
|
| TaxTransactionDiscountTender | integer |
None. |
|
| TableNumber | integer |
None. |
|
| Note | string |
None. |
|
| Source | string |
None. |
|
| CustomerReference | string |
None. |
|
| ReceiptPrinted | boolean |
None. |
|
| DrawerID |
The drawer that sale was performed in |
integer |
None. |
| DemoID | string |
None. |
|
| ExternalTransNo |
Sale identifier provided from external sales module |
string |
String length: inclusive between 0 and 20 |
| ExternalSale |
The External Sale Provider type if the sale is external |
ExternalSalesType |
None. |
| SmartReceiptStatus | integer |
None. |
|
| RequiredExports | integer |
None. |
|
| LoyaltyMetadata | string |
None. |
|
| PriceLevelIdentifier | Collection of byte |
None. |
|
| PriceLevelIdentifierGuid | globally unique identifier |
None. |
|
| Locked | integer |
None. |
|
| OrderMetadata |
Order metadata is stored in the DB as a serialised JSON string so this is that string |
string |
None. |
| DeserialisedOrderMetadata |
Deserialised version of |
StoreSaleHeaderOrderMetadata |
None. |
| RelationChecksum |
Encrypted value used to check that the correct number of relations are attached to the sale |
string |
Relation. This field may not always be loaded or used for updates. |
| LoyaltyTender |
The value of redeemed points or zero if only earned |
integer |
Relation. This field may not always be loaded or used for updates. Data type: Currency |
| GiftCardTender |
The amount spent from gift card(s) |
integer |
Relation. This field may not always be loaded or used for updates. Data type: Currency |
| Operator | Operator |
Relation. This field may not always be loaded or used for updates. |
|
| Customer | Customer |
Relation. This field may not always be loaded or used for updates. |
|
| CommunityOrganisation | CommunityOrganisation |
Relation. This field may not always be loaded or used for updates. |
|
| Details | Collection of StoreSaleDetail |
Relation. This field may not always be loaded or used for updates. |
|
| EftReceipts | Collection of StoreEftReceipt |
Relation. This field may not always be loaded or used for updates. |
|
| Payments | Collection of StoreSalePayment |
Relation. This field may not always be loaded or used for updates. |
|
| Cards | Collection of StoreSaleCard |
Relation. This field may not always be loaded or used for updates. |
|
| CampaignHits | Collection of StoreCampaignHit |
Relation. This field may not always be loaded or used for updates. |
|
| Fuel | Collection of StoreSaleFuel |
Relation. This field may not always be loaded or used for updates. |
|
| FuelResells |
FuelResells list |
Collection of SaleDetailFuelResell |
Relation. This field may not always be loaded or used for updates. |
| CustomerOrder | Collection of DeliOrderHeader |
Relation. This field may not always be loaded or used for updates. |
|
| SurveyResponses |
Contains the answers to any surveys that were answered during this sale; |
Collection of SurveyResponse |
Relation. This field may not always be loaded or used for updates. |
| StoreName | string |
Relation. This field may not always be loaded or used for updates. |
|
| TerminalNumber | integer |
Relation. This field may not always be loaded or used for updates. |
|
| MachineName | string |
Relation. This field may not always be loaded or used for updates. |
|
| OperatorName | string |
Relation. This field may not always be loaded or used for updates. |
|
| Direction | integer |
Relation. This field may not always be loaded or used for updates. |
|
| Reason | string |
Relation. This field may not always be loaded or used for updates. |
|
| AccountG_UID | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| AccountIdentifier | globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
|
| AccountName | string |
Relation. This field may not always be loaded or used for updates. |
|
| CustomerOrderIdentifier | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| CustomerOrderIdentifierGuid | globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
|
| PriceLevelName | string |
Relation. This field may not always be loaded or used for updates. |
|
| Revision |
Used in processing external sales |
integer |
Relation. This field may not always be loaded or used for updates. |
| IngressId |
ID of the Ingress entry (Redis Stream message ID) |
string |
None. |