project QadFinancials > class BCInvoice > business logic query CInvoiceByIDForRegistrationNr

Description

Simple query that returns a minimal set of fields and that allows a condition on CInvoiceID


Parameters


iiCInvoiceIDintegerID of the invoice
iiCompanyIdintegerCompany id


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = iiCInvoiceID


query resultset tqCInvoiceByIDForRegistrationNr


field namedata typedb fielddescription
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
ttCInvoicePostingDatedateCInvoice.CInvoicePostingDatePosting Date. This filed indicates the date on which the invoice is to be posted.
api annotation:This field defaults from the invoice creation date.
tiCInvoicePostingPeriodintegerCInvoice.CInvoicePostingPeriodGL Period.This field indicates the period when the invoice to be posted.
If this field is modified, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the period associated with the posting date.
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.
tiCInvoiceRegistrationNrintegerCInvoice.CInvoiceRegistrationNrRegistration number. This field displays the sequential number assigned to each invoice upon initial entry in the system.
tiCompany_IDintegerCInvoice.Company_IDLink to Company
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(CInvoice)


Internal usage


QadFinancials
method BAPMatching.AddAPMatching
method BBankEntry.AdditionalUpdatesInvCIMovements