project QadFinancials > class BCInvoice > business logic query CInvoiceForAPMValidation

Description

CInvoiceForAPMValidation: query that retursn the normal paymewnt condition for a CI


Parameters


iiCompanyIdintegerCompany id
iiYearinteger
icJournalCodecharacter
iiVoucherinteger
iiCInvoiceRegistrationNrintegerCInvoiceRegistrationNr


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoicePostingYear = iiYear AND
CInvoice.CInvoiceVoucher = iiVoucher AND
CInvoice.CInvoiceRegistrationNr = iiCInvoiceRegistrationNr

      first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = CInvoice.Journal_ID AND
Journal.JournalCode = icJournalCode

      first PaymentCondition (inner-join) where
PaymentCondition.PaymentCondition_ID = CInvoice.NormalPaymentCondition_ID AND


query resultset tqCInvoiceForAPMValidation


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.
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
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.
tiCompany_IDintegerCInvoice.Company_IDLink to Company
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiPaymentCondition_IDintegerPaymentCondition.PaymentCondition_IDRecord ID
tcPaymentConditionCodecharacterPaymentCondition.PaymentConditionCodeCredit Terms Code
tiCInvoiceRegistrationNrintegerCInvoice.CInvoiceRegistrationNrRegistration number. This field displays the sequential number assigned to each invoice upon initial entry in the system.


Internal usage


QadFinancials
method BAPMatching.GetPendingVouchersValidate
method BCInvoiceAPMatching.ApiEDICInvoiceAPMatchingImport