| iiCompanyId | integer | Company id |
| iiLinkedCInvoicePostingYear | integer | |
| icLinkedJournalCode | character | |
| iiLinkedCInvoiceVoucher | integer |
each CInvoice where
first Country1 (conditional-join) where
first Country2 (conditional-join) where
first Currency (inner-join) where
first Journal (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCInvoicePostingYear | integer | CInvoice.CInvoicePostingYear | Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly. |
| api annotation: | This field defaults to the accounting year associated with the posting date. | ||
| tdCInvoiceVatExchangeRate | decimal | CInvoice.CInvoiceVatExchangeRate | Tax Exchange Rate. The exchange rate used to calculate the tax of the invoice. The BC Tax amount is calculated using the Tax exchange rate. |
| tdCInvoiceVatRateScale | decimal | CInvoice.CInvoiceVatRateScale | Tax Rate Scale. This field indicates the scale factor applying to the tax exchange rate in use for foreign currency payments. |
| tiCInvoiceVoucher | integer | CInvoice.CInvoiceVoucher | Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field. |
| tiCompany_ID | integer | CInvoice.Company_ID | Link to Company |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcTransactionEndCountryCode | character | Country2.CountryCode | Country Code |
| tcTransactionStartCountryCode | character | Country1.CountryCode | Country Code |
| tcVatCurrencyCode | character | Currency.CurrencyCode | Currency Code |
QadFinancials