| iiCompanyId | integer | Company id |
| iiCreditorID | integer | ID of the Creditor |
| icCInvoiceType | character | Type of the invoice |
| icCInvoiceReference | character | CInvoiceReference |
| iiCInvoiceIDNotEqual | integer | If you pass in a value for this param then the query will only look for CInvoice records with CInvoiceID <> iiCInvoiceID |
each CInvoice where
first Journal (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| 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. |
| tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
| tiCompany_ID | integer | CInvoice.Company_ID | Link to Company |
| tiCreditor_ID | integer | CInvoice.Creditor_ID | Link to Creditor |
| tiJournal_ID | integer | CInvoice.Journal_ID | Daybook Code |
| 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. | ||
| 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. |
| tcCInvoiceReference | character | CInvoice.CInvoiceReference | Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the supplier. |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
QadFinancials