project QadFinancials > class BJournalEntryMultiCy > dataset tPostingVatDelayOneTrx

table tPostingVatDelayOneTrx

API annotation

Sp7 - this table is not currently used and does not need to be populated.

Description

This temp-table is declared 'like' tPostingVatDelay in BPosting. It contains all the Vat Delay records for all entities within one cross company transaction.

field namedata typedescription
Vat_IDinteger
VatRule_IDinteger
PostingLine_IDinteger
VatPeriod_IDinteger
PeriodMark_IDinteger
PostingVatDelay_IDinteger
Currency_IDinteger
Posting_IDinteger
PostingVatDelayBaseDebLCdecimal(4)BC (Base/Local Currency) Base Debit amount.
api annotation:?
PostingVatDelayBaseCredLCdecimal(4)BC (Base/Local Currency) Base Credit amount.
api annotation:?
PostingVatDelayBaseDebTCdecimal(4)TC (Trasaction Currency) Base Debit amount.
api annotation:?
PostingVatDelayBaseCredTCdecimal(4)TC (Transaction Currency) Base Credit amount.
api annotation:?
PostingVatDelayBaseDebCCdecimal(4)SC (Statutory Currency) Base Debit amount.
api annotation:?
PostingVatDelayBaseCredCCdecimal(4)SC (Statutory Currency) Base Credit amount.
PostingVatDelayTaxPntDatedateTax Point Date?
PostingVatDelayVATBalLCdecimal(4)BC (Base/Local Currency) Tax Balance.
PostingVatDelayVATOrigLCdecimal(4)BC (Base/Local Currency) Tax Original.
PostingVatDelayIsOpenlogicalOpen?
PostingVatDelayExchRatedecimal(10)Exchange Rate?
PostingVatDelayRateScaledecimal(10)Scale Factor?
PostingVatDelayTaxIDFedercharacterFederal Tax ID?
PostingVatDelayTaxIDStatecharacterState Tax ID?
PostingVatDelayTaxIDMisc1characterMiscellaneous Tax 1.
PostingVatDelayTaxIDMisc2characterMiscellaneous Tax 2.
PostingVatDelayTaxIDMisc3characterMiscellaneous Tax 3.
PostingVatDelayOwnTaxIDFedcharacterOwn Federal Tax ID?
PostingVatDelayOwnTaxIDStcharacterOwn State Tax ID?
PostingVatDelayOwnTaxIDM1characterOwn Miscellaneous Tax 1 ID.
PostingVatDelayOwnTaxIDM2characterOwn Miscellaneous Tax 2 ID.
PostingVatDelayOwnTaxIDM3characterOwn Miscellaneous Tax 3 ID.
PostingVatDelayOwnTaxDeclintegerOwn Tax Declaration.
tcVatCodecharacter
tcVatDescriptioncharacter
tdFullDebitTCdecimal(4)
tdFullCreditTCdecimal(4)
tdTotalVatDebitTCdecimal(4)
tdTotalVatCreditTCdecimal(4)
tcCurrencyCodecharacter
tcDomainCodecharacter
tcVatInOutcharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BJournalEntryMultiCy.ApiCreateMultiCyPostings
method BJournalEntryMultiCy.CreateMultiCyPostings