MGCLatticeVendorTransactionEntity
The MGCLatticeVendorTransactionEntity exposes posted vendor transactions from VendTrans, with the remaining (open) balance in transaction and accounting currency summed from the transaction's VendTransOpen records. Read-only and DMF/OData enabled with a lean, explicitly projected field set for high-volume payables extract and BYOD scenarios. Keyed on the VendTrans surrogate RecId (export-oriented). It is the accounts payable counterpart of MGCLatticeCustomerTransactionEntity.
- Public collection name:
LatticeVendorTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
VendorAccountNumber | VendAccount | No | |
Voucher | Voucher | No | |
TransactionType | LedgerTransType | No | |
TransactionDate | TransDate | No | |
DueDate | DueDate | No | |
InvoiceId | VendInvoiceId | No | |
DocumentNumber | DocumentNum | No | |
ClosedDate | TransDate | No | |
AccountingCurrencyAmount | AmountMSTDebCred | No | |
TransactionCurrencyAmount | AmountCurDebCred | No | |
CurrencyCode | VendCurrencyCode | No | |
SettledAccountingCurrencyAmount | AmountMST | No | |
SettledTransactionCurrencyAmount | AmountCur | No | |
RemainingAccountingCurrencyAmount | AmountMST | No | |
RemainingTransactionCurrencyAmount | AmountCur | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
VendorAccountNumber | VendTrans | AccountNum |
Voucher | VendTrans | Voucher |
TransactionType | VendTrans | TransType |
TransactionDate | VendTrans | TransDate |
DueDate | VendTrans | DueDate |
InvoiceId | VendTrans | Invoice |
DocumentNumber | VendTrans | DocumentNum |
ClosedDate | VendTrans | Closed |
AccountingCurrencyAmount | VendTrans | AmountMST |
TransactionCurrencyAmount | VendTrans | AmountCur |
CurrencyCode | VendTrans | CurrencyCode |
SettledAccountingCurrencyAmount | VendTrans | SettleAmountMST |
SettledTransactionCurrencyAmount | VendTrans | SettleAmountCur |
SysRecId | VendTrans | RecId |