| iiDInvoiceId | integer | DInvoice Id |
each DInvoiceVat where
first Vat (inner-join) where
first Domains (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiDInvoice_ID | integer | DInvoiceVat.DInvoice_ID | Link to DInvoice |
| tlDInvoiceVatIsAbsRet | logical | DInvoiceVat.DInvoiceVatIsAbsRet | Retained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government. |
| tlDInvoiceVatIsTaxable | logical | DInvoiceVat.DInvoiceVatIsTaxable | Taxable. This field indicates if the invoice is taxable. |
| api annotation: | This field defaults to true if the customer is taxable. | ||
| tdDInvoiceVatVatBaseCreditCC | decimal | DInvoiceVat.DInvoiceVatVatBaseCreditCC | SC Base Amount CR. This field displays the credit base amount in the statutory currency. This field is calculated by the system using the TC Base Amount CR and the SC rate. |
| tdDInvoiceVatVatBaseCreditLC | decimal | DInvoiceVat.DInvoiceVatVatBaseCreditLC | BC Base Amount CR. This field displays the credit base amount in the base currency. This field is calculated by the system using the TC Base Amount CR and the Exchange rate. |
| tdDInvoiceVatVatBaseCreditTC | decimal | DInvoiceVat.DInvoiceVatVatBaseCreditTC | TC Base Amount CR. This field displays the credit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tdDInvoiceVatVatBaseDebitCC | decimal | DInvoiceVat.DInvoiceVatVatBaseDebitCC | SC Base Amount DR. This field displays the debit base amount in the statutory currency. This field is calculated by the system using the TC Base Amount DR and the SC rate. |
| tdDInvoiceVatVatBaseDebitLC | decimal | DInvoiceVat.DInvoiceVatVatBaseDebitLC | BC Base Amount DR. This field displays the debit base amount in the base currency. This field is calculated by the system using the TC Base Amount DR and the Exchange rate. |
| tdDInvoiceVatVatBaseDebitTC | decimal | DInvoiceVat.DInvoiceVatVatBaseDebitTC | TC Base Amount DR. This field displays the debit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tdDInvoiceVatVatCreditCC | decimal | DInvoiceVat.DInvoiceVatVatCreditCC | SC Tax Amount CR. This field displays the credit tax amount in the statutory currency. This field is calculated by the system using the TC Tax Amount CR and the SC rate. |
| tdDInvoiceVatVatCreditLC | decimal | DInvoiceVat.DInvoiceVatVatCreditLC | BC Tax Amount CR. This field displays the debit tax amount in the base currency. This field is calculated by the system using the TC Tax Amount CR and the Exchange rate. |
| tdDInvoiceVatVatCreditTC | decimal | DInvoiceVat.DInvoiceVatVatCreditTC | TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tdDInvoiceVatVatDebitCC | decimal | DInvoiceVat.DInvoiceVatVatDebitCC | SC Tax Amount DR. This field displays the debit tax amount in the statutory currency. This field is calculated by the system using the TC Tax Amount DR and the SC rate. |
| tdDInvoiceVatVatDebitLC | decimal | DInvoiceVat.DInvoiceVatVatDebitLC | BC Tax Amount DR. This field displays the debit tax amount in the base currency. This field is calculated by the system using the TC Tax Amount DR and the Exchange rate. |
| tdDInvoiceVatVatDebitTC | decimal | DInvoiceVat.DInvoiceVatVatDebitTC | TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcTxclTaxCls | character | DInvoiceVat.TxclTaxCls | Tax Class. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax class being applied, if any. |
| api annotation: | This field default from the customer, and can be modified. | ||
| tcTxenvTaxEnv | character | DInvoiceVat.TxenvTaxEnv | Tax Environment. This field is automatically calculated based on the customer and ship-to address details, and can be modified. |
| tcTxuTaxUsage | character | DInvoiceVat.TxuTaxUsage | Tax Usage. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax usage being applied, if any. Select a different tax class if necessary. |
| api annotation: | This field defaults from the customer,and can be modified. | ||
| tiVat_ID | integer | DInvoiceVat.Vat_ID | Domain |
| tcVatCode | character | Vat.VatCode | Tax Code |
| tcVatInOut | character | Vat.VatInOut | Tax In/Out |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DInvoiceVat),rowid(Vat),rowid(Domains) |
QadFinancials