|
![]() |
Property | Value |
Name | ADJUSTMENT_A_ADJ_TAX_INFO |
Schema | dbo |
Row Count | 108535 |
Data Size | 2464 KB |
Index Size | 2256 KB |
Create Date | 10/25/2012 3:55 PM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
ADJ_TAX_EXEMPT |
bit(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
ADJ_TAX_INFO_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
ADJ_TAX_TYPE_CODE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
ISN_ADJUSTMENT_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_ADJUSTMENT_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].[ADJUSTMENT_A_ADJ_TAX_INFO] Script Date: 03/09/2017 16:44:50 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ADJUSTMENT_A_ADJ_TAX_INFO]( [ISN_ADJUSTMENT_A] [int] NOT NULL, [ADJ_TAX_INFO_COUNT] [smallint] NOT NULL, [ADJ_TAX_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADJ_TAX_EXEMPT] [bit] NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ADJ_TAX_EXEMPT | ADJ_TAX_INFO_COUNT | ADJ_TAX_TYPE_CODE | cnxarraycolumn | ISN_ADJUSTMENT_A | RowUpdatedOn |
false | 10 | MEDICARE | 2 | 17626 | 2017-02-06T11:16:25.205-05:00 |
false | 5 | AEIC | 3 | 4466 | 2017-02-06T11:16:22.256-05:00 |
false | 5 | 4 | 6121 | 2017-02-06T11:16:22.599-05:00 | |
false | 10 | 6 | 17672 | 2017-02-06T11:16:25.236-05:00 | |
false | 5 | AEIC | 3 | 11322 | 2017-02-06T11:16:23.411-05:00 |
false | 5 | AEIC | 3 | 6364 | 2017-02-06T11:16:22.646-05:00 |
false | 5 | 4 | 1568 | 2017-02-06T11:16:21.726-05:00 | |
false | 5 | WITHHOLD | 0 | 10626 | 2017-02-06T11:16:23.301-05:00 |
true | 5 | 2 | 615 | 2017-02-06T11:16:21.554-05:00 | |
false | 10 | 9 | 15549 | 2017-02-06T11:16:24.378-05:00 |
Powered by BI Documenter |