Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
TableRecordID | int identity | 4 | √ | null |
|
|
||
Organization_Group_6 | nvarchar | 500 | √ | null |
|
|
||
Organization_Sub_Group_6 | nvarchar | 500 | √ | null |
|
|
||
Organization | nvarchar | 500 | √ | null |
|
|
||
Responsibility_center | nvarchar | 500 | √ | null |
|
|
||
Financial_year | nvarchar | 500 | √ | null |
|
|
||
Period | nvarchar | 500 | √ | null |
|
|
||
Account_type | nvarchar | 500 | √ | null |
|
|
||
Revenue_and_expense_type_level_1 | nvarchar | 500 | √ | null |
|
|
||
Grouping_of_primary_code_group___A | nvarchar | 500 | √ | null |
|
|
||
Primary_code_group | nvarchar | 500 | √ | null |
|
|
||
Primary_code | nvarchar | 500 | √ | null |
|
|
||
Secondary_code_group | nvarchar | 500 | √ | null |
|
|
||
Secondary_code | nvarchar | 500 | √ | null |
|
|
||
Actual_amt | nvarchar | 500 | √ | null |
|
|
||
Actual_unit | nvarchar | 500 | √ | null |
|
|
||
Budget_amt | nvarchar | 500 | √ | null |
|
|
||
Budget_unit | nvarchar | 500 | √ | null |
|
|
||
CreatedDate | datetime | 16,3 | √ | (getdate()) |
|
|
||
Status | varchar | 10 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK__Espresso__2DFA759CC1D39224 | Primary key | Asc | TableRecordID |
IX_Espresso_FinancialYear_Period | Performance | Asc/Asc | Financial_year + Period |
Diagram producer might be missing
No diagrams were produced please see application output for any errors