vGLMonthlyMovementInColumnsAllYears


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GLYearEndDate datetime 16,3 √ null
GLYear smallint 2 null
GLCode varchar 15 null
GLDescription varchar 50 null
GLActiveFlag bit 1 null
ProfitLossFlag bit 1 null
GLCostCentreCode varchar 15 null
GLCostCentreDescription varchar 100 √ null
GLCOACode varchar 10 null
GLCOADescription varchar 100 √ null
GLDivisionCode varchar 15 √ null
GLDivisionDescription varchar 50 √ null
StartYearBalance money 21,4 null
GLPeriod1 money 21,4 √ null
GLPeriod2 money 21,4 √ null
GLPeriod3 money 21,4 √ null
GLPeriod4 money 21,4 √ null
GLPeriod5 money 21,4 √ null
GLPeriod6 money 21,4 √ null
GLPeriod7 money 21,4 √ null
GLPeriod8 money 21,4 √ null
GLPeriod9 money 21,4 √ null
GLPeriod10 money 21,4 √ null
GLPeriod11 money 21,4 √ null
GLPeriod12 money 21,4 √ null
BudgetPeriod1 money 21,4 √ null
BudgetPeriod2 money 21,4 √ null
BudgetPeriod3 money 21,4 √ null
BudgetPeriod4 money 21,4 √ null
BudgetPeriod5 money 21,4 √ null
BudgetPeriod6 money 21,4 √ null
BudgetPeriod7 money 21,4 √ null
BudgetPeriod8 money 21,4 √ null
BudgetPeriod9 money 21,4 √ null
BudgetPeriod10 money 21,4 √ null
BudgetPeriod11 money 21,4 √ null
BudgetPeriod12 money 21,4 √ null
GLComment varchar 2147483647 √ null
BudgetApprovedPeriod1 money 21,4 √ null
BudgetApprovedPeriod2 money 21,4 √ null
BudgetApprovedPeriod3 money 21,4 √ null
BudgetApprovedPeriod4 money 21,4 √ null
BudgetApprovedPeriod5 money 21,4 √ null
BudgetApprovedPeriod6 money 21,4 √ null
BudgetApprovedPeriod7 money 21,4 √ null
BudgetApprovedPeriod8 money 21,4 √ null
BudgetApprovedPeriod9 money 21,4 √ null
BudgetApprovedPeriod10 money 21,4 √ null
BudgetApprovedPeriod11 money 21,4 √ null
BudgetApprovedPeriod12 money 21,4 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views