business logic query CapitalizedFixedAsset

Parameters

iiCompanyId	integer	Company id
icCandoFAAssetCode	character
icFromFAAssetCode	character
icToFAAssetCode	character
icBookCode	character
icCandoFAAssetType	character
icFromFAAssetType	character
icToFAAssetType	character
icCandoGLCode	character
icFromGLCode	character
icToGLCode	character
iiFromBreakOffPeriod	integer
iiToBreakOffPeriod	integer
icCandoFACatalogueValue2	character
icCandoFACatalogueValue3	character
icCandoFACatalogueValue4	character
icCandoFACatalogueValue5	character
icCandoFACatalogueValue6	character

query condition

each FAAsset where

FAAsset.Company_Id = iiCompanyId AND
FAAsset.FAAssetIsCapitalized = true AND
FAAsset.FAAssetCode can-do icCandoFAAssetCode AND
FAAsset.FAAssetCode >= icFromFAAssetCode AND
FAAsset.FAAssetCode <= icToFAAssetCode AND
FAAsset.FAAssetCatalogueValue2 can-do icCandoFACatalogueValue2 AND
FAAsset.FAAssetCatalogueValue3 can-do icCandoFACatalogueValue3 AND
FAAsset.FAAssetCatalogueValue4 can-do icCandoFACatalogueValue4 AND
FAAsset.FAAssetCatalogueValue5 can-do icCandoFACatalogueValue5 AND
FAAsset.FAAssetCatalogueValue6 can-do icCandoFACatalogueValue6

each FAAssetBook (inner-join) where

FAAssetBook.FAAsset_ID = FAAsset.FAAsset_ID AND
FAAssetBook.FAAssetBookCode = icBookCode

first FABookType (inner-join) where

FABookType.Company_Id = iiCompanyId AND
FABookType.FABookType_ID = FAAssetBook.FABookType_ID AND

first Layer (inner-join) where

Layer.Layer_ID = FABookType.Layer_ID AND

each FACapitalAssetBook (inner-join) where

FACapitalAssetBook.FAAssetBook_ID = FAAssetBook.FAAssetBook_ID AND

first FACapital (inner-join) where

FACapital.Company_Id = iiCompanyId AND
FACapital.FACapital_ID = FACapitalAssetBook.FACapital_ID AND

first GL (inner-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = FACapital.GL_ID AND
GL.GLCode can-do icCandoGLCode AND
GL.GLCode >= icFromGLCode AND
GL.GLCode <= icToGLCode

first PostingLine (inner-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = FACapital.PostingLine_ID AND

first Posting (inner-join) where

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

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYearPeriod >= iiFromBreakOffPeriod AND
Period.PeriodYearPeriod <= iiToBreakOffPeriod

first FAAssetType (inner-join) where

FAAssetType.Company_Id = iiCompanyId AND
FAAssetType.FAAssetType_ID = FAAsset.FAAssetType_ID AND
FAAssetType.FAAssetTypeCode can-do icCandoFAAssetType AND
FAAssetType.FAAssetTypeCode >= icFromFAAssetType AND
FAAssetType.FAAssetTypeCode <= icToFAAssetType

query resultset tqCapitalizedFixedAsset

field name	data type	db field	description
tiFAAsset_ID	integer	FAAsset.FAAsset_ID	Record ID
tcFAAssetBookDeprType	character	FAAssetBook.FAAssetBookDeprType	Depreciation Type
tiFAAssetBookPeriodsDepr	integer	FAAssetBook.FAAssetBookPeriodsDepr	Periods Depreciated
tdFAAssetBookSalvageAmountCC	decimal	FAAssetBook.FAAssetBookSalvageAmountCC	SC Salvage Amount
tdFAAssetBookSalvageAmountLC	decimal	FAAssetBook.FAAssetBookSalvageAmountLC	BC Salvage Amount
tcFAAssetCode	character	FAAsset.FAAssetCode	Code
tcFAAssetDescription	character	FAAsset.FAAssetDescription	Description
tiFAAssetType_ID	integer	FAAssetType.FAAssetType_ID	Record ID
tcFAAssetTypeCode	character	FAAssetType.FAAssetTypeCode	Code
tcFAAssetTypeDescription	character	FAAssetType.FAAssetTypeDescription	Description
tcFABookCode	character	FAAssetBook.FAAssetBookCode	Code
tdFACapitalAmountLC	decimal	FACapital.FACapitalAmountLC	BC Amount
tcFACapitalDescription	character	FACapital.FACapitalDescription	Description
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcLayerCode	character	Layer.LayerCode	Layer Code
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
tiPeriodYearPeriod	integer	Period.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).
tdPostingLineDebitCC	decimal	PostingLine.PostingLineDebitCC	SC Debit
	api annotation:		Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field.
tcPostingText	character	Posting.PostingText	Free text describing the posting.
	api annotation:		Value for this field defaults to blank
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
	api annotation:		In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FAAsset),rowid(FAAssetBook),rowid(FABookType),rowid(Layer),rowid(FACapitalAssetBook),rowid(FACapital),rowid(GL),rowid(PostingLine),rowid(Posting),rowid(Journal),rowid(Period),rowid(FAAssetType)

Internal usage

QadFinancials

method BFixedAssetReport.MovementsByAssetCode
method BFixedAssetReport.MutationsByGL
method BFixedAssetReport.TransactionsByAssetCode