DWStaging
 dbo.W2_FORM_A_BOX14 (Table)
  Properties
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
  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_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_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.W2_FORM_A_BOX14 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.W2_FORM_A_BOX14)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** 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
)
  Sample Data
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