project QadFinancials > class BLayer > business logic query LayerPrim

Description

Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.


Parameters


iiLayerIdintegerLayerId
icLayerCodecharacterLayer Code


query condition


  each Layer where
Layer.Layer_ID = iiLayerId and
Layer.LayerCode = icLayerCode


query resultset tqLayerPrim


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


Internal usage


QadFinancials
method BBudgetReporting.BudgetDetail1
method BBudgetReporting.CalculateMeasure
method BFRWAnalysisCode.ValidateComponentPreFRWAnCodeElemDet
method BGLReport.GetBusinessFields
method BLayer.ApiStdMaintainTT
method BLayer.DataLoadByInput
method BFRWCube.ValidateComponentAllLayers
read related business field(s) on tAllocationLayer.Layer_ID
read related business field(s) on tConsolidLayer.Layer_ID
read related business field(s) on tFABookType.Layer_ID
read related business field(s) on tFRWCubeLayer.Layer_ID
read related business field(s) on tJournal.Layer_ID
read related business field(s) on tRevalHeader.Layer_ID
read related business field(s) on tRevalHeader.Source1Layer_ID
read related business field(s) on tRevalHeader.Source2Layer_ID
read related business field(s) on tRevalHeader.Source3Layer_ID
read related business field(s) on tYearClosing.Layer_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAllocationLayer.Layer_ID
validate related business field(s) on tConsolidLayer.Layer_ID
validate related business field(s) on tFABookType.Layer_ID
validate related business field(s) on tFRWCubeLayer.Layer_ID
validate related business field(s) on tJournal.Layer_ID
validate related business field(s) on tRevalHeader.Layer_ID
validate related business field(s) on tRevalHeader.Source1Layer_ID
validate related business field(s) on tRevalHeader.Source2Layer_ID
validate related business field(s) on tRevalHeader.Source3Layer_ID