project QadFinancials > class BDInvoice > business logic query DInvoiceByUniqueIndexFields

Description

This query is used for the TPM deduction detail maintenance part.


Parameters


iiInvoiceYearinteger
iiVoucherinteger
iiCompanyIdintegerCompany id
iiJournalIdinteger


query condition


  each DInvoice where
DInvoice.Company_ID = iiCompanyId AND
DInvoice.Journal_ID = iiJournalId AND
DInvoice.DInvoicePostingYear = iiInvoiceYear AND
DInvoice.DInvoiceVoucher = iiVoucher


query resultset tqDInvoiceByUniqueIndexFields


field namedata typedb fielddescription
tiCompany_IDintegerDInvoice.Company_IDLink to Company
tiDInvoice_IDintegerDInvoice.DInvoice_IDRecord ID
ttDInvoicePostingDatedateDInvoice.DInvoicePostingDatePosting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print.
This field is updated when the invoice is validated and saved.
api annotation:This field defaults from the invoice creation 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.
tiJournal_IDintegerDInvoice.Journal_IDDaybook Code


Internal usage


QadFinancials
method BDDocument.ApiGetDInvoiceIdByUniqueIndexFields