| iiDInvoiceID | integer | |
| icDomainCode | character | |
| ilDiscountTaxAtPayment | logical |
each DInvoiceVat where
first Vat (inner-join) where
first tx2_mstr (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiDInvoice_ID | integer | DInvoiceVat.DInvoice_ID | Link to DInvoice |
| tiDInvoiceVat_ID | integer | DInvoiceVat.DInvoiceVat_ID | Record ID |
| 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. | ||
| 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. |
| 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. |
| tiDomain_ID | integer | Vat.Domain_ID | Domain |
| tctx2_domain | character | tx2_mstr.tx2_domain | Domain |
| tltx2_pmt_disc | logical | tx2_mstr.tx2_pmt_disc | Discount Tax at Payment |
| tctx2_tax_code | character | tx2_mstr.tx2_tax_code | Tax Code |
| 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. |
| tcTxtyTaxType | character | DInvoiceVat.TxtyTaxType | Tax Type. This field displays the tax type, which defaults from the tax environment. |
| 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 |
QadFinancials