project QadFinancials > class BJournalEntryMultiCy > dataset tPostingVatOneTrx

table tPostingVatOneTrx

Description

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

field namedata typedescription
PostingVat_IDinteger
Posting_IDinteger
PostingLine_IDinteger
Vat_IDinteger
VatRule_IDinteger
VatPeriod_IDinteger
PeriodMark_IDinteger
Currency_IDinteger
VatGroup_IDinteger
PostingVatBaseDebitLCdecimal(4)BC (Base/Local Currency) Base Debit amount.
PostingVatBaseDebitTCdecimal(4)TC (Transaction Currency) Base Debit amount.
PostingVatBaseDebitCCdecimal(4)SC (Statutory Currency) Base Debit amount.
PostingVatBaseCreditLCdecimal(4)BC (Base/Local Currency) Base Credit amount.
PostingVatBaseCreditTCdecimal(4)TC (Transaction Currency) Base Credit amount.
PostingVatBaseCreditCCdecimal(4)SC (Statutory Currency) Base Credit amount.
PostingVatExchangeRatedecimal(10)TC/BC Exchange Rate.
api annotation:?
PostingVatRateScaledecimal(10)Scale Factor (TC/BC).
api annotation:?
PostingVatInOutcharacterIn/Out?
api annotation:Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales.
PostingVatTaxPointDatedateThe date when this posting is taken into account in the Tax sub-adminstration.
api annotation:?
PostingVatTaxTransTypecharacterTax Transaction Type?
api annotation:Available value for this field: 29 represents "AP Payment Check (Discount at Payment)", 55 represents "AP Transactions", 22 represents "AP Invoice", 18 represents "AR Invoice", 16 represents "AR Operational Invoice", 19 represents "AR Payment (Discount at Payment)", 56 represents "AR Transactions", 45 represents "Logistic Accounting - DO Shipment", 27 represents "Logistic Accounting - PO Receipt", 43 represents "Logistic Accounting - SO Shipment", 20 represents "Purchase Order", 21 represents "Purchase Order Receipt", 25 represents "Purchase Order Return"
PostingVatTransTypecharacterTransaction Type?
api annotation:Available value for this field is: ACQUISITION represents "IC Acquisition", BOTH represents "Both", EXPORT represents "Export", IN represents "IN", OUT represents "OUT", IMPORT represents "Import", INLAND-PURCHASE represents "INLAND-PURCHASE", INLAND-SALES represents "INLAND-SALES", PURCHASE represents "Inland Purchase", SALES represents "Inland Sales", SUPPLY represents "IC Supply", TRIANGULARPURCHASE represents "Triangular Purchase", TRIANGULARSALES represents "Triangular Sales".
PostingVatTaxDebitLCdecimal(4)BC (Base Currency) Tax Debit amount.
api annotation:?
PostingVatTaxDebitCCdecimal(4)SC (Statutory Currency) Tax Debit amount.
api annotation:?
PostingVatTaxDebitTCdecimal(4)TC (Transaction Currency) Tax Debit amount.
api annotation:?
PostingVatTaxCreditLCdecimal(4)BC (Base/Local) Tax Credit amount.
api annotation:?
PostingVatTaxCreditCCdecimal(4)SC (Statutory Currency) Tax Credit amount.
api annotation:?
PostingVatTaxCreditTCdecimal(4)TC (Transaction Currency) Tax Credit amount.
api annotation:?
PostingVatTaxIDFedercharacterFederal Tax?
api annotation:?
PostingVatTaxIDStatecharacterState Tax?
api annotation:?
PostingVatTaxIDMisc1characterMiscellaneous Tax 1. For reference and documentation
purposes, enter any other tax identification numbers that are useful.
api annotation:?
PostingVatTaxIDMisc2characterMiscellaneous Tax 2
PostingVatTaxIDMisc3characterMiscellaneous Tax 3
PostingVatOwnTaxIDFedercharacterOwn Federal Tax?
api annotation:?
PostingVatOwnTaxIDStatecharacterOwn State Tax?
api annotation:?
PostingVatOwnTaxIDMisc1characterOwn Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful.
api annotation:?
PostingVatOwnTaxIDMisc2characterOwn Miscellaneous Tax 2
PostingVatOwnTaxIDMisc3characterOwn Miscellaneous Tax 3
PostingVatOwnTaxDeclaratinteger
PostingVatIsReverseChargelogical
PostingVatIsAbsRetlogical
PostingVatIsSuspDellogical
TxtyTaxTypecharacter
TxclTaxClscharacterTax Class. A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions.
api annotation:The value of Tax Class defaults to the header of transactions created for this address
TxuTaxUsagecharacterTax Usage. A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address. Common tax usages are retail, manufacturing, and industrialization.
api annotation:The value of Tax Usage defaults to the header of transactions created for this address.
TxenvTaxEnvcharacterTax Environment. A code (maximum 16 characters) that
identifies a set of tax types for a tax zone/tax class combination. On transactions, this code identifies the transaction or line-item tax environment.
api annotation:?
FromTxzTaxZonecharacterFrom Tax Zone.
api annotation:?
ToTxzTaxZonecharacterTo Tax Zone
api annotation:?
tcCurrencyCodecharacter
tdFullDebitTCdecimal(4)Amount including VAT
tdFullCreditTCdecimal(4)Amount including VAT
tdTotalVatDebitTCdecimal(4)
tdTotalVatCreditTCdecimal(4)
tcVatCodecharacterThe TaxCode for this posting. This code determines the registrations in the tax sub-ledger.
tcVatDescriptioncharacter
tcDomainCodecharacter
tcVatInOutcharacter
tcVatGroupCodecharacter
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
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