business logic query DeductionCatLineSafExcelInteg

query condition

each DeductionCatLineSaf where

first Saf (inner-join) where

Saf.Saf_ID = DeductionCatLineSaf.Saf_ID AND

first SafConcept (inner-join) where

SafConcept.SafConcept_ID = Saf.SafConcept_ID AND

field name	data type	db field	description
tiDeductionCatLine_ID	integer	DeductionCatLineSaf.DeductionCatLine_ID	Link to DeductionCatLine
tiDeductionCatLineSaf_ID	integer	DeductionCatLineSaf.DeductionCatLineSaf_ID	Record ID
tiSaf_ID	integer	DeductionCatLineSaf.Saf_ID	Link to Saf
tcSafCode	character	Saf.SafCode	SAF Code
tcSafConceptCode	character	SafConcept.SafConceptCode	SAF Concept Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(DeductionCatLineSaf),rowid(Saf),rowid(SafConcept)

QadFinancials