project QadFinancials > class BLayer > business logic query LayerByLayerIDLayerTypeCode

Description

LayerByLayerIDLayerTypeCode


Parameters


iiLayerIDinteger
icLayerTypeCodecharacter
icLayerCodecharacter


query condition


  each Layer where
Layer.Layer_ID = iiLayerID AND
Layer.LayerCode = icLayerCode AND
Layer.LayerTypeCode = icLayerTypeCode


query resultset tqLayerByLayerIDLayerTypeCode


field namedata typedb fielddescription
tiLayer_IDintegerLayer.Layer_IDRecord ID
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerDescriptioncharacterLayer.LayerDescriptionDescription
tlLayerIsActivelogicalLayer.LayerIsActiveActive
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Layer)


Internal usage


QadFinancials
method BAPMatching.ValJournal