project QadFinancials > class BCInvoice > business logic query CInvoiceForInvCertification


Parameters


iiCompanyIdintegerCompany id
iiJournalIdintegerDaybook ID
ilCInvoiceIsERSlogicalCInvoice Is ERS invoice
ilCInvoiceIsInitialStatuslogicalCInvoice Is Initial


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.Journal_ID = iiJournalId AND
CInvoice.CInvoiceIsERS = ilCInvoiceIsERS AND
CInvoice.CInvoiceIsInitialStatus = ilCInvoiceIsInitialStatus


query sort order


CInvoice.Company_ID (ascending)
CInvoice.Journal_ID (ascending)
CInvoice.CInvoicePostingYear (ascending)
CInvoice.CInvoiceVoucher (ascending)
CInvoice.CInvoiceIsERS (ascending)


query resultset tqCInvoiceForInvCertification


field namedata typedb fielddescription
tlCInvoiceIsInitialStatuslogicalCInvoice.CInvoiceIsInitialStatusInitial Status. This field indicates if the invoice is in initial status.
api annotation:This field defaults from the Initial Status field of the Invoice status code.
tiCompany_IDintegerCInvoice.Company_IDLink to Company
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
tcCInvoiceInvCertSignatureCurrcharacterCInvoice.CInvoiceInvCertSignatureCurrSignature Current Invoice
tlCInvoiceIsERSlogicalCInvoice.CInvoiceIsERSERS: This field indicates if the invoice is created using Evaluated Receipts Settlement (ERS) functions.
tiCInvoicePostingYearintegerCInvoice.CInvoicePostingYearYear.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.
tiCInvoiceVoucherintegerCInvoice.CInvoiceVoucherVoucher. 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.
tiJournal_IDintegerCInvoice.Journal_IDDaybook Code


Internal usage


QadFinancials
method BCInvoice.PreSave