|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_CONTRACT_A_ACCOUNT_GROUP |
| Schema | dbo |
| Row Count | 164471 |
| Data Size | 9032 KB |
| Index Size | 3200 KB |
| Create Date | 11/7/2012 8:27 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ACCOUNT_GROUP_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_AR_CONTRACT_A |
int(10, 0) |
False |
False |
False |
|||
|
|
OFFSET_ACCOUNT |
varchar(25) |
True |
False |
False |
|||
|
|
RECEIVABLE_ACCOUNT |
varchar(25) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
SPLIT_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
SPLIT_PERCENTAGE |
numeric(17, 4) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_CONTRACT_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_CONTRACT_A_ACCOUNT_GROUP depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_CONTRACT_A_ACCOUNT_GROUP)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_CONTRACT_A_ACCOUNT_GROUP] Script Date: 03/09/2017 16:44:58 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_CONTRACT_A_ACCOUNT_GROUP]( [ISN_AR_CONTRACT_A] [int] NOT NULL, [ACCOUNT_GROUP_COUNT] [smallint] NOT NULL, [RECEIVABLE_ACCOUNT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OFFSET_ACCOUNT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SPLIT_AMOUNT] [numeric](17, 2) NULL, [SPLIT_PERCENTAGE] [numeric](17, 4) NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ACCOUNT_GROUP_COUNT | cnxarraycolumn | ISN_AR_CONTRACT_A | OFFSET_ACCOUNT | RECEIVABLE_ACCOUNT | RowUpdatedOn | SPLIT_PERCENTAGE |
| 1 | 0 | 20616 | 58000001 0013100 | 2017-02-06T10:48:53.341-05:00 | 100.0000 | |
| 1 | 0 | 132248 | 58000001 0013106 | 2017-02-06T10:49:02.109-05:00 | 100.0000 | |
| 1 | 0 | 118193 | 10000000 0017200 | 2017-02-06T10:49:01.204-05:00 | 100.0000 | |
| 1 | 0 | 62550 | 10000000 0013100 | 2017-02-06T10:48:57.038-05:00 | 100.0000 | |
| 1 | 0 | 95340 | 58000001 0013106 | 2017-02-06T10:48:59.768-05:00 | 100.0000 | |
| 1 | 0 | 5082 | 10000000 0022504 | 10000000 0013100 | 2017-02-06T10:48:51.984-05:00 | 100.0000 |
| 1 | 0 | 153203 | 10000000 0013100 | 2017-02-06T10:49:03.481-05:00 | 100.0000 | |
| 1 | 0 | 124454 | 58000001 0013106 | 2017-02-06T10:49:01.594-05:00 | 100.0000 | |
| 1 | 0 | 114529 | 58000001 0013106 | 2017-02-06T10:49:00.97-05:00 | 100.0000 | |
| 1 | 0 | 131715 | 58000001 0013100 | 2017-02-06T10:49:02.062-05:00 | 100.0000 |
| Powered by BI Documenter |
