|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | W2_FORM_LOG_A_BOX14 |
| Schema | dbo |
| Row Count | 145603 |
| Data Size | 3416 KB |
| Index Size | 2488 KB |
| Create Date | 11/5/2012 9:58 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
BOX14_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
BOX14_CODE |
varchar(2) |
True |
False |
False |
|||
|
|
BOX14_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_W2_FORM_LOG_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_W2_FORM_LOG_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.W2_FORM_LOG_A_BOX14 depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.W2_FORM_LOG_A_BOX14)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[W2_FORM_LOG_A_BOX14] Script Date: 03/09/2017 16:46:38 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[W2_FORM_LOG_A_BOX14]( [ISN_W2_FORM_LOG_A] [int] NOT NULL, [BOX14_COUNT] [smallint] NOT NULL, [BOX14_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BOX14_AMOUNT] [numeric](17, 2) NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| BOX14_AMOUNT | BOX14_CODE | BOX14_COUNT | cnxarraycolumn | ISN_W2_FORM_LOG_A | RowUpdatedOn |
| 923.10 | C | 1 | 0 | 56196 | 2017-02-06T10:51:24.413-05:00 |
| 214.76 | C | 1 | 0 | 75156 | 2017-02-06T10:51:25.551-05:00 |
| 314.12 | C | 2 | 0 | 46646 | 2017-02-06T10:51:23.898-05:00 |
| 772.29 | C | 1 | 0 | 15389 | 2017-02-06T10:51:22.135-05:00 |
| 511.03 | C | 1 | 0 | 116875 | 2017-02-06T10:51:27.891-05:00 |
| 901.22 | C | 1 | 0 | 64548 | 2017-02-06T10:51:24.959-05:00 |
| 636.23 | E | 1 | 0 | 99338 | 2017-02-06T10:51:26.877-05:00 |
| 299.79 | C | 1 | 0 | 69436 | 2017-02-06T10:51:25.271-05:00 |
| 502.86 | C | 1 | 0 | 44183 | 2017-02-06T10:51:23.757-05:00 |
| 506.17 | C | 1 | 0 | 135615 | 2017-02-06T10:51:28.89-05:00 |
| Powered by BI Documenter |
