Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
GeneralLedgerMonthlyBudgetsSeq | int identity | 4 | √ | null |
|
|
||
GeneralLedgerSeq | int | 4 | √ | null |
|
|
||
BudgetDate | datetime | 16,3 | √ | null |
|
|
||
Budget1 | money | 21,4 | √ | null |
|
|
||
Budget2 | money | 21,4 | √ | null |
|
|
||
Budget3 | money | 21,4 | √ | null |
|
|
||
Budget4 | money | 21,4 | √ | null |
|
|
||
Budget5 | money | 21,4 | √ | null |
|
|
||
Budget6 | money | 21,4 | √ | null |
|
|
||
Budget7 | money | 21,4 | √ | null |
|
|
||
Budget8 | money | 21,4 | √ | null |
|
|
||
Budget9 | money | 21,4 | √ | null |
|
|
||
Budget10 | money | 21,4 | √ | null |
|
|
Table contained -1 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_tGeneralLedgerMonthlyBudgets | Primary key | Asc | GeneralLedgerMonthlyBudgetsSeq |
AK_tGeneralLedgerMonthlyBudgets_BudgetDate | Performance | Asc | BudgetDate |
AK_tGeneralLedgerMonthlyBudgets_GeneralLedgerSeq | Performance | Asc | GeneralLedgerSeq |
AK_tGeneralLedgerMonthlyBudgets_GeneralLedgerSeq_BudgetDate | Must be unique | Asc/Asc | GeneralLedgerSeq + BudgetDate |