| iiCompanyId | integer | Company id |
| iiDInvoicePostingYear | integer | Posting Year of the debtor invoice |
| icJournalCode | character | Journal Code |
| iiDInvoiceVoucher | integer | Voucher of the debtor invoice |
each DInvoice where
first Currency (inner-join) where
first Division (outer-join) where
first Journal (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tdDInvoiceOriginalCreditTC | decimal | DInvoice.DInvoiceOriginalCreditTC | 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. |
| tiDInvoicePostingYear | integer | DInvoice.DInvoicePostingYear | 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. | ||
| tiDInvoiceVoucher | integer | DInvoice.DInvoiceVoucher | Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(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. |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
QadFinancials