|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_RECEIPT_A_ITEMS_PAID_GROUP |
| Schema | dbo |
| Row Count | 16199112 |
| Data Size | 937816 KB |
| Index Size | 273528 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 |
||
 |
|
AMOUNT_COV_DUE |
numeric(17, 2) |
True |
False |
False |
|||
|
|
AMOUNT_ORIG |
numeric(17, 2) |
True |
False |
False |
|||
|
|
AMOUNT_PAID |
numeric(17, 2) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DATE_1 |
varchar(8) |
True |
False |
False |
|||
|
|
DATE_2 |
varchar(8) |
True |
False |
False |
|||
|
|
ISN_AR_RECEIPT_A |
int(10, 0) |
False |
False |
False |
|||
|
|
ITEM_DESC |
varchar(30) |
True |
False |
False |
|||
|
|
ITEM_ID |
varchar(22) |
True |
False |
False |
|||
|
|
ITEM_STATUS |
varchar(2) |
True |
False |
False |
|||
|
|
ITEM_TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
ITEMS_PAID_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_ITEMS_PAID_GROUP depends on)
| Name | Type |
View |
Child Dependencies (objects that depend on dbo.AR_RECEIPT_A_ITEMS_PAID_GROUP)
| Name | Type |
VIEW |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_RECEIPT_A_ITEMS_PAID_GROUP] Script Date: 03/09/2017 16:45:01 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_RECEIPT_A_ITEMS_PAID_GROUP]( [ISN_AR_RECEIPT_A] [int] NOT NULL, [ITEMS_PAID_GROUP_COUNT] [smallint] NOT NULL, [ITEM_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ITEM_ID] [varchar](22) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ITEM_DESC] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DATE_1] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DATE_2] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AMOUNT_PAID] [numeric](17, 2) NULL, [AMOUNT_COV_DUE] [numeric](17, 2) NULL, [AMOUNT_ORIG] [numeric](17, 2) NULL, [ITEM_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| AMOUNT_PAID | AMOUNT_COV_DUE | cnxarraycolumn | DATE_1 | DATE_2 | ISN_AR_RECEIPT_A | ITEM_DESC | ITEM_ID | ITEM_STATUS | ITEM_TYPE | ITEMS_PAID_GROUP_COUNT | RowUpdatedOn |
| 368.60 | 3 | 3192041 | 20121 COS0700 158421 | PD | TR | 5 | 2017-02-06T09:27:30.9-05:00 | ||||
| 304.75 | 1 | 4072697 | 20142 BSC1011 178370 | PD | TR | 6 | 2017-02-06T09:29:57.432-05:00 | ||||
| 59.00 | 7 | 2258061 | 20093 AVO0573 132328 | PD | TR | 12 | 2017-02-06T09:24:43.714-05:00 | ||||
| 247.50 | 1 | 2396940 | 20101 AMH2010 122003 | PD | TR | 4 | 2017-02-06T09:25:09.048-05:00 | ||||
| 341.94 | 3 | 3785154 | 20132 PRN0213 172887 | PD | TR | 5 | 2017-02-06T09:29:07.137-05:00 | ||||
| 10.00 | 0 | 3568061 | 20131 9999999999999999 | PD | TR | 4 | 2017-02-06T09:28:30.898-05:00 | ||||
| 330.75 | 2 | 3774550 | 20132 ESC1000 167305 | PD | TR | 5 | 2017-02-06T09:29:05.203-05:00 | ||||
| 1047.00 | 5 | 3152498 | 20121 ATT2120 151115 | PD | TR | 8 | 2017-02-06T09:27:24.442-05:00 | ||||
| 330.75 | 1 | 4554620 | 20153 BSC1010 199021 | PD | TR | 5 | 2017-02-06T09:31:31.781-05:00 | ||||
| 3.00 | 2 | 641875 | 20021 EMO0198 033810 | PD | TR | 4 | 2017-02-06T09:20:10.993-05:00 |
| Powered by BI Documenter |
