Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
GLYear | smallint | 2 | null |
|
|
|||
GLCode | varchar | 15 | null |
|
|
|||
GLDescription | varchar | 50 | null |
|
|
|||
GLActiveFlag | bit | 1 | null |
|
|
|||
GLCostCentreCode | varchar | 15 | null |
|
|
|||
GLCostCentreDescription | varchar | 100 | √ | null |
|
|
||
GLYearToDate | money | 21,4 | √ | null |
|
|
||
GLCurrent | money | 21,4 | √ | null |
|
|
||
ProfitLossFlag | bit | 1 | null |
|
|
|||
LastYearMovement | money | 21,4 | null |
|
|
|||
StartYearBalance | money | 21,4 | null |
|
|
|||
GLReportingMonthEndDate | datetime | 16,3 | null |
|
|
|||
GLBudgetYearToDate | money | 21,4 | √ | null |
|
|
||
GLBudgetCurrent | money | 21,4 | √ | null |
|
|
||
GLBudgetFullYear | money | 21,4 | √ | null |
|
|
||
GLCOACode | varchar | 10 | null |
|
|
|||
GLDivisionCode | varchar | 15 | √ | null |
|
|
||
GLComment | varchar | 2147483647 | √ | null |
|
|
||
ProfitLossControlAccountFlag | bit | 1 | √ | null |
|
|
||
LastYearBalance | money | 21,4 | null |
|
|
Table contained 0 rows