MGCLatticeBankAccountTransactionEntity
The MGCLatticeBankAccountTransactionEntity exposes bank account transactions from BankAccountTrans (root) joined to BankAccountTable for the bank account name. Read-only, minimal projection intended for high-volume treasury/reconciliation export feeds. Keyed on a RecId surrogate (SysRecId).
- Public collection name:
LatticeBankAccountTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
BankAccountId | CompanyBankAccountId | No | |
TransactionDate | TransDate | No | |
Voucher | Voucher | No | |
BankTransactionType | BankTransactionType | No | |
TransactionText | TransactionTextLarge | No | |
Reconciled | NoYes | No | |
AccountingCurrencyAmount | AmountMST | No | |
AmountCurrency | AmountCur | No | |
CurrencyCode | CurrencyCode | No | |
BankAccountName | Name | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
BankAccountId | BankAccountTrans | AccountId |
TransactionDate | BankAccountTrans | TransDate |
Voucher | BankAccountTrans | Voucher |
BankTransactionType | BankAccountTrans | BankTransType |
TransactionText | BankAccountTrans | Txt |
Reconciled | BankAccountTrans | Reconciled |
AccountingCurrencyAmount | BankAccountTrans | AmountMST |
AmountCurrency | BankAccountTrans | AmountCur |
CurrencyCode | BankAccountTrans | CurrencyCode |
BankAccountName | BankAccountTable | Name |
SysRecId | BankAccountTrans | RecId |