| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | DInvoice ID |
| iiPeriodYear | integer | Period Year |
| iiJournalId | integer | Journal ID |
| icJournalCode | character | Daybook Code |
| iiDInvoiceVoucher | integer | Voucher |
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 |
| 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 |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DInvoice),rowid(Journal),rowid(Period) |
QadFinancials