MGCLatticeTaxTransactionEntity
The MGCLatticeTaxTransactionEntity exposes posted sales-tax detail from the TaxTrans table as a general-purpose, read-only export feed. Unlike BusinessDocumentTaxTransactionEntity (which is scoped to the business-document submission service and omits tax direction, tax item group, currency code and the accounting-currency tax base amount), this entity provides a broad projection over posted tax transactions with a RecId surrogate key for high-volume extraction.
- Public collection name:
LatticeTaxTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
SysRecId | RecId | No | |
TaxCode | TaxCode | No | |
TaxDirection | TaxDirection | No | |
TransactionDate | TransDate | No | |
Voucher | Voucher | No | |
TaxGroup | TaxGroup | No | |
TaxItemGroup | TaxItemGroup | No | |
TaxAmount | TaxAmount | No | |
TaxBaseAmount | TaxBase | No | |
SourceTaxAmountCur | TaxAmountCur | No | |
TaxRate | TaxValue | No | |
CurrencyCode | CurrencyCode | No | |
Mappings
| Entity field | Data source | Field |
|---|
SysRecId | TaxTrans | RecId |
TaxCode | TaxTrans | TaxCode |
TaxDirection | TaxTrans | TaxDirection |
TransactionDate | TaxTrans | TransDate |
Voucher | TaxTrans | Voucher |
TaxGroup | TaxTrans | TaxGroup |
TaxItemGroup | TaxTrans | TaxItemGroup |
TaxAmount | TaxTrans | TaxAmount |
TaxBaseAmount | TaxTrans | TaxBaseAmount |
SourceTaxAmountCur | TaxTrans | SourceTaxAmountCur |
TaxRate | TaxTrans | TaxValue |
CurrencyCode | TaxTrans | CurrencyCode |