|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | BUDGET_PREP_FILE_AMOUNT_GROUP |
| Schema | dbo |
| Row Count | 13554 |
| Data Size | 328 KB |
| Index Size | 656 KB |
| Create Date | 10/24/2012 1:57 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
AMOUNT |
decimal(9, 0) |
True |
False |
False |
|||
|
|
AMOUNT_GROUP_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
CHANGE_REASON |
varchar(50) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
CONTROL_AMOUNT |
decimal(9, 0) |
True |
False |
False |
|||
|
|
ISN_BUDGET_PREP_FILE |
int(10, 0) |
False |
False |
False |
|||
|
|
ORIG_AMOUNT |
decimal(9, 0) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_BUDGET_PREP_FILE, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.BUDGET_PREP_FILE_AMOUNT_GROUP depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.BUDGET_PREP_FILE_AMOUNT_GROUP)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[BUDGET_PREP_FILE_AMOUNT_GROUP] Script Date: 03/09/2017 16:45:07 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[BUDGET_PREP_FILE_AMOUNT_GROUP]( [ISN_BUDGET_PREP_FILE] [int] NOT NULL, [AMOUNT_GROUP_COUNT] [smallint] NOT NULL, [AMOUNT] [decimal](9, 0) NULL, [CONTROL_AMOUNT] [decimal](9, 0) NULL, [ORIG_AMOUNT] [decimal](9, 0) NULL, [CHANGE_REASON] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| AMOUNT | AMOUNT_GROUP_COUNT | CHANGE_REASON | cnxarraycolumn | ISN_BUDGET_PREP_FILE | ORIG_AMOUNT | RowUpdatedOn |
| 26885 | 1 | 0 | 19924 | 26885 | 2017-02-06T11:18:32.08-05:00 | |
| 397416 | 1 | 0 | 41267 | 397416 | 2017-02-06T11:18:34.186-05:00 | |
| 500 | 1 | 0 | 95158 | 500 | 2017-02-06T11:18:39.178-05:00 | |
| 1200 | 1 | 0 | 78367 | 1200 | 2017-02-06T11:18:37.946-05:00 | |
| 7796 | 1 | 0 | 77424 | 2017-02-06T11:18:37.852-05:00 | ||
| 1500 | 1 | 0 | 60542 | 1500 | 2017-02-06T11:18:36.136-05:00 | |
| 40000 | 1 | 0 | 42193 | 40000 | 2017-02-06T11:18:34.311-05:00 | |
| 67000 | 1 | 0 | 76804 | 67000 | 2017-02-06T11:18:37.759-05:00 | |
| 500 | 1 | 0 | 40659 | 500 | 2017-02-06T11:18:34.139-05:00 | |
| 520 | 1 | 0 | 23492 | 2017-02-06T11:18:34.061-05:00 |
| Powered by BI Documenter |
