|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_RECEIPT_A_MISC_ACCOUNT_GROUP |
| Schema | dbo |
| Row Count | 712386 |
| Data Size | 42912 KB |
| Index Size | 12080 KB |
| Create Date | 11/7/2012 11:53 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ACCOUNT_NBR |
varchar(25) |
True |
False |
False |
|||
|
|
AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DESCRIPTION |
varchar(30) |
True |
False |
False |
|||
|
|
ISN_AR_RECEIPT_A |
int(10, 0) |
False |
False |
False |
|||
|
|
MISC_ACCOUNT_GROUP_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_RECEIPT_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_RECEIPT_A_MISC_ACCOUNT_GROUP depends on)
| Name | Type |
View |
Child Dependencies (objects that depend on dbo.AR_RECEIPT_A_MISC_ACCOUNT_GROUP)
| Name | Type |
VIEW |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_RECEIPT_A_MISC_ACCOUNT_GROUP] Script Date: 03/09/2017 16:45:01 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_RECEIPT_A_MISC_ACCOUNT_GROUP]( [ISN_AR_RECEIPT_A] [int] NOT NULL, [MISC_ACCOUNT_GROUP_COUNT] [smallint] NOT NULL, [ACCOUNT_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DESCRIPTION] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AMOUNT] [numeric](17, 2) NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ACCOUNT_NBR | AMOUNT | cnxarraycolumn | DESCRIPTION | ISN_AR_RECEIPT_A | MISC_ACCOUNT_GROUP_COUNT | RowUpdatedOn |
| 10000000 2040920 | 15.00 | 0 | CPT TEST | 1208939 | 1 | 2017-02-06T09:23:17.554-05:00 |
| 10000000 1040920 | 25.00 | 0 | PERT | 3206324 | 1 | 2017-02-06T09:25:41.574-05:00 |
| 10000000 1040920 | 5.00 | 0 | MAKE-UP | 915558 | 1 | 2017-02-06T09:22:56.51-05:00 |
| 251000002000059448906 | 5.00 | 0 | DUP ID | 2163150 | 1 | 2017-02-06T09:24:27.162-05:00 |
| 10000000 3040920 | 15.00 | 0 | CPT | 547837 | 1 | 2017-02-06T09:22:28.726-05:00 |
| 10000000 5040920 | 25.00 | 0 | COMPASS | 4131168 | 1 | 2017-02-06T09:26:44.287-05:00 |
| 10000000 1040920 | 5.00 | 0 | MAKE UP EXAM | 630902 | 1 | 2017-02-06T09:22:35.808-05:00 |
| 10000000 1040920 | 25.00 | 0 | CPT | 2665323 | 1 | 2017-02-06T09:25:03.089-05:00 |
| 10000000 5040920 | 15.00 | 0 | CPT TEST | 1818546 | 1 | 2017-02-06T09:24:01.812-05:00 |
| 10000000 0048900 | 5.00 | 0 | REPLACEMENT CARED | 2270968 | 1 | 2017-02-06T09:24:34.541-05:00 |
| Powered by BI Documenter |
