business logic query CInvoiceMovementForBLWIReport

Description

Select CInvoiceMovement for BWLI

Parameters

icType	character
iiYearPeriod	integer
icCountryCode	character	Country Code
iiCompanyId	integer	Company id
icBLWICodeFrom	character
icBLWICodeTo	character

query condition

each CInvoiceMovement where

CInvoiceMovement.Company_Id = iiCompanyId AND
CInvoiceMovement.CInvoiceMovementType <> icType

first CInvoice (inner-join) where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = CInvoiceMovement.CInvoice_ID AND

first BLWIGroup (inner-join) where

BLWIGroup.BLWIGroup_ID = CInvoice.BLWIGroup_ID AND
BLWIGroup.BLWIGroupCode >= icBLWICodeFrom AND
BLWIGroup.BLWIGroupCode <= icBLWICodeTo

first Country (inner-join) where

Country.Country_ID = CInvoice.TransactionStartCountry_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 = CInvoice.CInvoiceCurrency_ID AND

first Period1 (inner-join) where

Period1.Company_Id = iiCompanyId AND
Period1.Period_ID = CInvoice.Period_ID AND
Period1.PeriodYearPeriod <= iiYearPeriod

first PostingLine (inner-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = CInvoiceMovement.PostingLine_ID AND

first Posting (inner-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND

first Period2 (inner-join) where

Period2.Company_Id = iiCompanyId AND
Period2.Period_ID = Posting.Period_ID AND
Period2.PeriodYearPeriod > iiYearPeriod

query resultset tqCInvoiceMovementForBLWIReport

field name	data type	db field	description
tcBLWICountryCode	character	BLWICountry.BLWICountryCode	BLWI Country Code
tiBLWIGroup_ID	integer	BLWIGroup.BLWIGroup_ID	Record ID
tcBLWIGroupCode	character	BLWIGroup.BLWIGroupCode	BLWI Group Code
tcBLWIGroupDescription	character	BLWIGroup.BLWIGroupDescription	Description
tiCInvoice_ID	integer	CInvoiceMovement.CInvoice_ID	Link to CInvoice
tcCInvoiceMovementType	character	CInvoiceMovement.CInvoiceMovementType	CInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc).
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
tiCurrency_ID	integer	Currency.Currency_ID	Record ID
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcCurrencyDescription	character	Currency.CurrencyDescription	Currency Description
tiPeriodYearPeriod	integer	Period2.PeriodYearPeriod	GL Calendar Year/GL Period
ttPostingDate	date	Posting.PostingDate	The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tiPostingLine_ID	integer	CInvoiceMovement.PostingLine_ID	Link to PostingLine
tdPostingLineCreditLC	decimal	PostingLine.PostingLineCreditLC	BC Credit
	api annotation:		Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field.
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
tdPostingLineDebitLC	decimal	PostingLine.PostingLineDebitLC	BC Debit
	api annotation:		Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field.
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit

Internal usage

QadFinancials

method BBLWIReport.CreateBWLIReportFromCInvoiceMovement