project QadFinancials > class BConsolid > business logic query ConsolidLayerBySourceCyLayer
Parameters
| icSourceCompanyCode | character | |
| icSourceLayerType | character | Source Layer Type |
| icTargetLayerType | character | TargetLayerType |
| icTargetLayerCode | character | |
| iiCompanyId | integer | Company id |
query condition
each ConsolidLayer where
first Consolid (inner-join) where
Consolid.Consolid_ID = ConsolidLayer.Consolid_ID AND
Consolid.ConsolidCompany_ID = iiCompanyId AND
Consolid.ConsolidSourceLayerTypCode = icSourceLayerType AND
Consolid.ConsolidTargetLayerTypCode = icTargetLayerType
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = Consolid.SourceCompany_ID AND
Company.CompanyCode = icSourceCompanyCode
first Period1 (inner-join) where
Period1.Company_Id = iiCompanyId AND
Period1.Period_ID = Consolid.FromPeriod_ID AND
first Period2 (inner-join) where
Period2.Company_Id = iiCompanyId AND
Period2.Period_ID = Consolid.ToPeriod_ID AND
first Layer (inner-join) where
Layer.Layer_ID = ConsolidLayer.Layer_ID AND
Layer.LayerCode = icTargetLayerCode
query resultset tqConsolidLayerBySourceCyLayer
| field name | data type | db field | description |
|---|
| tiConsolid_ID | integer | Consolid.Consolid_ID | Record ID |
| tiConsolidCompany_ID | integer | Consolid.ConsolidCompany_ID | Entity Code |
| tiConsolidLayer_ID | integer | ConsolidLayer.ConsolidLayer_ID | Record ID |
| tcConsolidSourceLayerTypCode | character | Consolid.ConsolidSourceLayerTypCode | Source Layer Type |
| tcConsolidStatus | character | Consolid.ConsolidStatus | Status |
| tcConsolidTargetLayerTypCode | character | Consolid.ConsolidTargetLayerTypCode | Target Layer Type |
| tiFromPeriod_ID | integer | Consolid.FromPeriod_ID | GL Calendar Year |
| tiFromPeriodPeriod | integer | Period1.PeriodPeriod | GL Period |
| tiFromPeriodYear | integer | Period1.PeriodYear | GL Calendar Year |
| tiFromPeriodYearPeriod | integer | Period1.PeriodYearPeriod | GL Calendar Year/GL Period |
| tiLayer_ID | integer | ConsolidLayer.Layer_ID | Source Layer Code |
| tcLayerCode | character | Layer.LayerCode | Layer Code |
| tiSourceCompany_ID | integer | Consolid.SourceCompany_ID | Entity Code |
| tcSourceCompanyCode | character | Company.CompanyCode | Entity Code |
| tiToPeriod_ID | integer | Consolid.ToPeriod_ID | GL Calendar Year |
| tiToPeriodPerio | integer | Period2.PeriodPeriod | GL Period |
| tiToPeriodYear | integer | Period2.PeriodYear | GL Calendar Year |
| tiToPeriodYearPeriod | integer | Period2.PeriodYearPeriod | GL Calendar Year/GL Period |
Internal usage
QadFinancials