MGCLatticeRetailTransactionEntity
The MGCLatticeRetailTransactionEntity exposes POS transaction headers from RetailTransactionTable (root). Read-only, lean projection intended for high-volume retail analytics/export feeds. Keyed on a RecId surrogate (SysRecId). Unlike the standard public+DMF RetailTransactionEntity, this exposes Store and Channel directly alongside ReceiptId in a minimal field set.
- Public collection name:
LatticeRetailTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
Store | RetailStoreId | No | |
Terminal | RetailTerminalId | No | |
ReceiptId | RetailReceiptId | No | |
Channel | RefRecId | No | |
TransactionDate | TransDate | No | |
TransactionTime | RetailTransTime | No | |
Staff | RetailStaffId | No | |
CustomerAccount | RetailAsyncCustAccount | No | |
TransactionStatus | RetailTransEntryStatus | No | |
TransactionType | RetailTransactionType | No | |
GrossAmount | RetailGrossAmount | No | |
NetAmount | RetailNetAmount | No | |
CostAmount | RetailCostAmount | No | |
PaymentAmount | RetailPaymentAmount | No | |
CurrencyCode | CurrencyCode | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
Store | RetailTransactionTable | store |
Terminal | RetailTransactionTable | terminal |
ReceiptId | RetailTransactionTable | receiptId |
Channel | RetailTransactionTable | Channel |
TransactionDate | RetailTransactionTable | transDate |
TransactionTime | RetailTransactionTable | transTime |
Staff | RetailTransactionTable | staff |
CustomerAccount | RetailTransactionTable | custAccount |
TransactionStatus | RetailTransactionTable | entryStatus |
TransactionType | RetailTransactionTable | type |
GrossAmount | RetailTransactionTable | grossAmount |
NetAmount | RetailTransactionTable | netAmount |
CostAmount | RetailTransactionTable | costAmount |
PaymentAmount | RetailTransactionTable | paymentAmount |
CurrencyCode | RetailTransactionTable | currency |
SysRecId | RetailTransactionTable | RecId |