| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | DInvoice ID |
| iiPeriodYear | integer | Period Year |
| iiJournalId | integer | Journal ID |
| icJournalCode | character | Daybook Code |
| iiDInvoiceVoucher | integer | Voucher |
| ilDInvoiceIsOpen | logical | Is the invoice still open ? |
each DInvoice where
first Journal (inner-join) where
first Period (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tiDebtor_ID | integer | DInvoice.Debtor_ID | Link to Debtor |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiDInvoiceCurrency_ID | integer | DInvoice.DInvoiceCurrency_ID | Currency Code |
| tlDInvoiceIsOpen | logical | DInvoice.DInvoiceIsOpen | Open.This field indicates if the invoice has been completely paid. This field is updated automatically when complete payment is confirmed. This field is read-only. |
| api annotation: | PartialUpdate = yes - defaults to true | ||
| 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. |
| tiJournal_ID | integer | DInvoice.Journal_ID | Daybook Code |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPeriod_ID | integer | DInvoice.Period_ID | Link to Period |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
QadFinancials