MGCLatticeWithholdingTaxTransactionEntity
The MGCLatticeWithholdingTaxTransactionEntity exposes posted withholding-tax detail from the TaxWithholdTrans table. It is a read-only export entity using the system RecId as a surrogate key (mapped as SysRecId). Per-company data is scoped by DataAreaId.
- Public collection name:
LatticeWithholdingTaxTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
SysRecId | RefRecId | No | |
VendorAccountNumber | VendAccount | No | |
CustomerAccount | CustAccount | No | |
InvoiceId | InvoiceId | No | |
InvoiceAmount | AmountCur | No | |
InvoiceBaseAmount | AmountCur | No | |
InvoiceTaxWithholdAmount | TaxWithholdAmountCur | No | |
JournalNumber | LedgerJournalId | No | |
CompetenceDate | TransDate | No | |
WithholdingTaxCode | TaxWithholdCode | No | |
Mappings
| Entity field | Data source | Field |
|---|
SysRecId | TaxWithholdTrans | RecId |
VendorAccountNumber | TaxWithholdTrans | VendAccount |
CustomerAccount | TaxWithholdTrans | CustAccount |
InvoiceId | TaxWithholdTrans | Invoice |
InvoiceAmount | TaxWithholdTrans | InvoiceAmount |
InvoiceBaseAmount | TaxWithholdTrans | InvoiceBaseAmount |
InvoiceTaxWithholdAmount | TaxWithholdTrans | InvoiceTaxWithholdAmount |
JournalNumber | TaxWithholdTrans | JournalNum |
CompetenceDate | TaxWithholdTrans | CompetenceDate |
WithholdingTaxCode | TaxWithholdTrans | TaxWithholdCode |