| field name | data type | description |
|---|---|---|
| PostingVat_ID | integer | |
| Posting_ID | integer | |
| PostingLine_ID | integer | |
| Vat_ID | integer | |
| VatRule_ID | integer | |
| VatPeriod_ID | integer | |
| PeriodMark_ID | integer | |
| Currency_ID | integer | |
| VatGroup_ID | integer | |
| PostingVatBaseDebitLC | decimal(4) | BC (Base/Local Currency) Base Debit amount. |
| PostingVatBaseDebitTC | decimal(4) | TC (Transaction Currency) Base Debit amount. |
| PostingVatBaseDebitCC | decimal(4) | SC (Statutory Currency) Base Debit amount. |
| PostingVatBaseCreditLC | decimal(4) | BC (Base/Local Currency) Base Credit amount. |
| PostingVatBaseCreditTC | decimal(4) | TC (Transaction Currency) Base Credit amount. |
| PostingVatBaseCreditCC | decimal(4) | SC (Statutory Currency) Base Credit amount. |
| PostingVatExchangeRate | decimal(10) | TC/BC Exchange Rate. |
| api annotation: | ? | |
| PostingVatRateScale | decimal(10) | Scale Factor (TC/BC). |
| api annotation: | ? | |
| PostingVatInOut | character | In/Out? |
| api annotation: | Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales. | |
| PostingVatTaxPointDate | date | The date when this posting is taken into account in the Tax sub-adminstration. |
| api annotation: | ? | |
| PostingVatTaxTransType | character | Tax 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" | |
| PostingVatTransType | character | Transaction 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". | |
| PostingVatTaxDebitLC | decimal(4) | BC (Base Currency) Tax Debit amount. |
| api annotation: | ? | |
| PostingVatTaxDebitCC | decimal(4) | SC (Statutory Currency) Tax Debit amount. |
| api annotation: | ? | |
| PostingVatTaxDebitTC | decimal(4) | TC (Transaction Currency) Tax Debit amount. |
| api annotation: | ? | |
| PostingVatTaxCreditLC | decimal(4) | BC (Base/Local) Tax Credit amount. |
| api annotation: | ? | |
| PostingVatTaxCreditCC | decimal(4) | SC (Statutory Currency) Tax Credit amount. |
| api annotation: | ? | |
| PostingVatTaxCreditTC | decimal(4) | TC (Transaction Currency) Tax Credit amount. |
| api annotation: | ? | |
| PostingVatTaxIDFeder | character | Federal Tax? |
| api annotation: | ? | |
| PostingVatTaxIDState | character | State Tax? |
| api annotation: | ? | |
| PostingVatTaxIDMisc1 | character | Miscellaneous Tax 1. For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | ? | |
| PostingVatTaxIDMisc2 | character | Miscellaneous Tax 2 |
| PostingVatTaxIDMisc3 | character | Miscellaneous Tax 3 |
| PostingVatOwnTaxIDFeder | character | Own Federal Tax? |
| api annotation: | ? | |
| PostingVatOwnTaxIDState | character | Own State Tax? |
| api annotation: | ? | |
| PostingVatOwnTaxIDMisc1 | character | Own Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful. |
| api annotation: | ? | |
| PostingVatOwnTaxIDMisc2 | character | Own Miscellaneous Tax 2 |
| PostingVatOwnTaxIDMisc3 | character | Own Miscellaneous Tax 3 |
| PostingVatOwnTaxDeclarat | integer | |
| PostingVatIsReverseCharge | logical | |
| PostingVatIsAbsRet | logical | |
| PostingVatIsSuspDel | logical | |
| TxtyTaxType | character | |
| TxclTaxCls | character | Tax 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 | |
| TxuTaxUsage | character | Tax 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. | |
| TxenvTaxEnv | character | Tax 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: | ? | |
| FromTxzTaxZone | character | From Tax Zone. |
| api annotation: | ? | |
| ToTxzTaxZone | character | To Tax Zone |
| api annotation: | ? | |
| tcCurrencyCode | character | |
| tdFullDebitTC | decimal(4) | Amount including VAT |
| tdFullCreditTC | decimal(4) | Amount including VAT |
| tdTotalVatDebitTC | decimal(4) | |
| tdTotalVatCreditTC | decimal(4) | |
| tcVatCode | character | The TaxCode for this posting. This code determines the registrations in the tax sub-ledger. |
| tcVatDescription | character | |
| tcDomainCode | character | |
| tcVatInOut | character | |
| tcVatGroupCode | character | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials