field name | data type | db field | description |
tiConsolidationCompany_ID | integer | ConsolidPeriodXref.ConsolidationCompany_ID | Consolidation Entity |
tiConsolidationPeriod_ID | integer | ConsolidPeriodXref.ConsolidationPeriod_ID | Consolidation Period |
ttConsolidPeriodEndDate | date | Period1.PeriodEndDate | End Date |
ttConsolidPeriodStartDate | date | Period1.PeriodStartDate | Start Date |
tiConsolidPeriodXref_ID | integer | ConsolidPeriodXref.ConsolidPeriodXref_ID | Record ID |
tiPeriod_ID | integer | Period1.Period_ID | Record ID |
tlPeriodIsPostingGLAllowed | logical | Period2.PeriodIsPostingGLAllowed | GL |
tcConsolidCompanyCode | character | Company.CompanyCode | Entity Code |
tiPeriodYear | integer | Period2.PeriodYear | GL Calendar Year |
tiPeriodPeriod | integer | Period2.PeriodPeriod | GL Period |
tiConsolidPeriodYear | integer | Period1.PeriodYear | GL Calendar Year |
tiConsolidPeriodPeriod | integer | Period1.PeriodPeriod | GL Period |
tiCompany_ID | integer | ConsolidPeriodXref.Company_ID | Link to Company |
tiSourcePeriod_ID | integer | ConsolidPeriodXref.Period_ID | Source GL Period |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(ConsolidPeriodXref),rowid(Company),rowid(Period1),rowid(Period2) |