project QadFinancials > class BDInvoice > business logic query DInvoiceByYearJournalVoucher


Parameters


iiCompanyIdintegerCompany id
iiDInvoicePostingYearintegerPosting Year of the debtor invoice
icJournalCodecharacterJournal Code
iiDInvoiceVoucherintegerVoucher of the debtor invoice


query condition


  each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoicePostingYear = iiDInvoicePostingYear AND
DInvoice.DInvoiceVoucher = iiDInvoiceVoucher

      first Currency (inner-join) where
Currency.Currency_ID = DInvoice.DInvoiceCurrency_ID AND

      first Division (outer-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = DInvoice.Division_ID AND

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


query resultset tqDInvoiceByYearJournalVoucher


field namedata typedb fielddescription
tiCompany_IDintegerDInvoice.Company_IDLink to Company
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiDInvoice_IDintegerDInvoice.DInvoice_IDRecord ID
tdDInvoiceOriginalCreditTCdecimalDInvoice.DInvoiceOriginalCreditTCTC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
tiDInvoicePostingYearintegerDInvoice.DInvoicePostingYearYear.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.
tiDInvoiceVoucherintegerDInvoice.DInvoiceVoucherVoucher.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.
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).


Internal usage


QadFinancials
method BDDocument.ApiStdMaintainTT
method BDDocument.DataLoadByInput
method BSelfBill.ApiCreateInvPrepayPaymentValidate