MGCLatticeCustomerTransactionEntity
The MGCLatticeCustomerTransactionEntity exposes posted customer transactions from CustTrans, with the remaining (open) balance in transaction and accounting currency summed from the transaction's CustTransOpen records. Read-only and DMF/OData enabled with a lean, explicitly projected field set for high-volume receivables extract and BYOD scenarios. Keyed on the CustTrans surrogate RecId (export-oriented).
- Public collection name:
LatticeCustomerTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
CustomerAccount | CustAccount | No | |
Voucher | Voucher | No | |
TransactionType | LedgerTransType | No | |
TransactionDate | TransDate | No | |
DueDate | DueDate | No | |
InvoiceId | InvoiceId | No | |
DocumentNumber | DocumentNum | No | |
PaymReference | CustPaymReference | No | |
ClosedDate | TransDate | No | |
AccountingCurrencyAmount | AmountMSTDebCred | No | |
TransactionCurrencyAmount | AmountCurDebCred | No | |
CurrencyCode | CustCurrencyCode | No | |
SettledAccountingCurrencyAmount | AmountMST | No | |
SettledTransactionCurrencyAmount | AmountCur | No | |
RemainingAccountingCurrencyAmount | AmountMST | No | |
RemainingTransactionCurrencyAmount | AmountCur | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
CustomerAccount | CustTrans | AccountNum |
Voucher | CustTrans | Voucher |
TransactionType | CustTrans | TransType |
TransactionDate | CustTrans | TransDate |
DueDate | CustTrans | DueDate |
InvoiceId | CustTrans | Invoice |
DocumentNumber | CustTrans | DocumentNum |
PaymReference | CustTrans | PaymReference |
ClosedDate | CustTrans | Closed |
AccountingCurrencyAmount | CustTrans | AmountMST |
TransactionCurrencyAmount | CustTrans | AmountCur |
CurrencyCode | CustTrans | CurrencyCode |
SettledAccountingCurrencyAmount | CustTrans | SettleAmountMST |
SettledTransactionCurrencyAmount | CustTrans | SettleAmountCur |
SysRecId | CustTrans | RecId |