iiCompanyId | integer | Company id |
iiFromYearPeriod | integer | From Period Year Period: (Year * 100) + period |
iiToYearPeriod | integer | To Period Year Period: (Year * 100) + period |
field name | data type | db field | description |
---|---|---|---|
tiCompany_ID | integer | Period.Company_ID | Link to Company |
tiPeriod_ID | integer | Period.Period_ID | Record ID |
ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
tlPeriodIsPostingGLAllowed | logical | Period.PeriodIsPostingGLAllowed | GL |
tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
ttPeriodStartDate | date | Period.PeriodStartDate | Start Date |
tcPeriodStatus | character | Period.PeriodStatus | Status |
tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Period) |