Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Organization_Group_6 | nvarchar | 500 | √ | null |
|
|
||
| Organization_Sub_Group_6 | nvarchar | 500 | √ | null |
|
|
||
| Organization | nvarchar | 500 | √ | null |
|
|
||
| Organization_code | nvarchar | 500 | √ | null |
|
|
||
| Organization_desc | nvarchar | 500 | √ | null |
|
|
||
| Responsibility_center | nvarchar | 500 | √ | null |
|
|
||
| ResponsibilityCenter_code | nvarchar | 500 | √ | null |
|
|
||
| ResponsibilityCenter_desc | nvarchar | 500 | √ | null |
|
|
||
| Financial_year | nvarchar | 500 | √ | null |
|
|
||
| Period | nvarchar | 500 | √ | null |
|
|
||
| Period_date | nvarchar | 510 | √ | 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 |
|
|
||
| PrimaryCodeGroup_code | nvarchar | 500 | √ | null |
|
|
||
| PrimaryCodeGroup_desc | nvarchar | 500 | √ | null |
|
|
||
| Primary_code | nvarchar | 500 | √ | null |
|
|
||
| PrimaryCode_code | nvarchar | 500 | √ | null |
|
|
||
| PrimaryCode_desc | nvarchar | 500 | √ | null |
|
|
||
| Secondary_code_group | nvarchar | 500 | √ | null |
|
|
||
| SecondaryCodeGroup_code | nvarchar | 500 | √ | null |
|
|
||
| SecondaryCodeGroup_desc | nvarchar | 500 | √ | null |
|
|
||
| Secondary_code | nvarchar | 500 | √ | null |
|
|
||
| SecondaryCode_code | nvarchar | 500 | √ | null |
|
|
||
| SecondaryCode_desc | nvarchar | 500 | √ | null |
|
|
||
| Actual_amt | nvarchar | 500 | √ | null |
|
|
||
| Actual_unit | nvarchar | 500 | √ | null |
|
|
||
| Budget_amt | nvarchar | 500 | √ | null |
|
|
||
| Budget_unit | nvarchar | 500 | √ | null |
|
|
||
| Status | varchar | 10 | √ | null |
|
|