| iiCompanyId | integer | Company id |
| iiCInvoiceID | integer |
each CInvoice where
each CInvoiceVat (outer-join) where
first Vat (outer-join) where
first Domains (outer-join) where
first Currency (inner-join) where
first PaymentCondition (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
| tiCInvoiceCurrency_ID | integer | CInvoice.CInvoiceCurrency_ID | Currency Code |
| tdCInvoiceExchangeRate | decimal | CInvoice.CInvoiceExchangeRate | Exchange Rate. The exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted. |
| tdCInvoiceOriginalCreditLC | decimal | CInvoice.CInvoiceOriginalCreditLC | BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate. |
| tdCInvoiceOriginalCreditTC | decimal | CInvoice.CInvoiceOriginalCreditTC | TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same. |
| tdCInvoiceOriginalDebitLC | decimal | CInvoice.CInvoiceOriginalDebitLC | BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate. |
| tdCInvoiceOriginalDebitTC | decimal | CInvoice.CInvoiceOriginalDebitTC | TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same. |
| tdCInvoiceRateScale | decimal | CInvoice.CInvoiceRateScale | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
| tcCInvoiceType | character | CInvoice.CInvoiceType | Invoice Type. This field identifies the invoice type. The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined. |
| tiCInvoiceVat_ID | integer | CInvoiceVat.CInvoiceVat_ID | Record ID |
| tlCInvoiceVatIsAccrRcpUs | logical | CInvoiceVat.CInvoiceVatIsAccrRcpUs | CInvoiceVatIsAccrRcpUS Tax is accrued at receipt. This is a parameter of the tax rate code in GTM. |
| tdCInvoiceVatNonRecTaxAmtTC | decimal | CInvoiceVat.CInvoiceVatNonRecTaxAmtTC | Non-Rev Tax Amount. This field displays the percentage of tax that is not recoverable. Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe. |
| tdCInvoiceVatVatCreditLC | decimal | CInvoiceVat.CInvoiceVatVatCreditLC | 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. |
| tdCInvoiceVatVatCreditTC | decimal | CInvoiceVat.CInvoiceVatVatCreditTC | 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. |
| tdCInvoiceVatVatDebitLC | decimal | CInvoiceVat.CInvoiceVatVatDebitLC | 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. |
| tdCInvoiceVatVatDebitTC | decimal | CInvoiceVat.CInvoiceVatVatDebitTC | 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. |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDomain_ID | integer | Vat.Domain_ID | Domain |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiNormalPaymentCondition_ID | integer | CInvoice.NormalPaymentCondition_ID | Credit Terms Code |
| tcPaymentConditionCode | character | PaymentCondition.PaymentConditionCode | Credit Terms Code |
| tdPaymentConditionPercentage | decimal | PaymentCondition.PaymentConditionPercentage | Discount Percentage |
| tiReason_ID | integer | CInvoice.Reason_ID | Invoice Status Code |
| tiVat_ID | integer | Vat.Vat_ID | Record ID |
| tcVatCode | character | Vat.VatCode | Tax Code |
| tcVatInOut | character | Vat.VatInOut | Tax In/Out |
QadFinancials