business logic query DInvoiceForBLWIReport

Description

Select DInvoices

Parameters

iiCompanyId	integer	Company id
icCountryCode	character	Country Code
ilIsOpen	logical
iiYearPeriod	integer

query condition

each DInvoice where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoiceIsOpen = ilIsOpen

first Country (inner-join) where

Country.Country_ID = DInvoice.TransactionEndCountry_ID AND
Country.CountryCode <> icCountryCode

first BLWICountry (conditional-join) where

BLWICountry.BLWICountry_ID = Country.BLWICountry_ID AND

first Currency (inner-join) where

Currency.Currency_ID = DInvoice.DInvoiceCurrency_ID AND

first Debtor (inner-join) where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DInvoice.Debtor_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND

each Address (inner-join) where

Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = DInvoice.Period_ID AND
Period.PeriodYearPeriod <= iiYearPeriod

query resultset tqDInvoiceForBLWIReport

field name	data type	db field	description
tcBLWICountryCode	character	BLWICountry.BLWICountryCode	BLWI Country Code
tiCountry_ID	integer	Country.Country_ID	Record ID
tcCountryCode	character	Country.CountryCode	Country Code
tcCountryDescription	character	Country.CountryDescription	Description
tlCountryIsActive	logical	Country.CountryIsActive	Active
tlCountryIsEUCountry	logical	Country.CountryIsEUCountry	EU Member
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiDInvoice_ID	integer	DInvoice.DInvoice_ID	Record ID
tdDInvoiceBalanceLC	decimal	DInvoice.DInvoiceBalanceLC	BC Balance. This field displays the sum of the debit and credit amounts of all posting lines in base currency. This field is calculated by the system using the TC Balance and the Exchange rate.
tdDInvoiceBalanceTC	decimal	DInvoice.DInvoiceBalanceTC	Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency.
ttDInvoicePostingDate	date	DInvoice.DInvoicePostingDate	Posting 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.
tcDInvoiceType	character	DInvoice.DInvoiceType	Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined.
	api annotation:		PartialUpdate = yes - defaults to Invoice
tiPeriod_ID	integer	DInvoice.Period_ID	Link to Period

Internal usage

QadFinancials

method BBLWIReport.CreateBWLIReportFromDInvoices