|
![]() |
Property | Value |
Name | W2_FORM_A_BOX14 |
Schema | dbo |
Row Count | 22581 |
Data Size | 512 KB |
Index Size | 424 KB |
Create Date | 11/5/2012 9:58 AM |
Description |
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_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_W2_FORM_A, cnxarraycolumn |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[W2_FORM_A_BOX14] Script Date: 03/09/2017 16:46:37 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[W2_FORM_A_BOX14]( [ISN_W2_FORM_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 ) |
BOX14_AMOUNT | BOX14_CODE | BOX14_COUNT | cnxarraycolumn | ISN_W2_FORM_A | RowUpdatedOn |
1183.60 | E | 1 | 0 | 19950 | 2017-02-06T11:17:29.602-05:00 |
957.70 | C | 1 | 0 | 14587 | 2017-02-06T11:17:29.04-05:00 |
1169.74 | E | 1 | 0 | 23533 | 2017-02-06T11:17:29.883-05:00 |
1429.42 | C | 1 | 0 | 8724 | 2017-02-06T11:17:28.525-05:00 |
102.36 | C | 1 | 0 | 13139 | 2017-02-06T11:17:28.915-05:00 |
1088.14 | C | 1 | 0 | 2395 | 2017-02-06T11:17:28.073-05:00 |
28.63 | C | 1 | 0 | 511 | 2017-02-06T11:17:27.933-05:00 |
129.03 | E | 1 | 0 | 18221 | 2017-02-06T11:17:29.399-05:00 |
716.15 | E | 1 | 0 | 18788 | 2017-02-06T11:17:29.493-05:00 |
1411.90 | C | 1 | 0 | 5780 | 2017-02-06T11:17:28.307-05:00 |
Powered by BI Documenter |