|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_BILL_INSTR_A_INSTALLMENT_GROUP |
| Schema | dbo |
| Row Count | 52745 |
| Data Size | 1912 KB |
| Index Size | 936 KB |
| Create Date | 11/5/2012 3:48 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ADDON_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
BILL_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
BILL_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
BILL_INSTALL_NUM |
int(10, 0) |
True |
False |
False |
|||
|
|
BILLED_IND |
varchar(1) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
INSTALL_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
INSTALLMENT_GROUP_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_AR_BILL_INSTR_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_BILL_INSTR_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_BILL_INSTR_A_INSTALLMENT_GROUP depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_BILL_INSTR_A_INSTALLMENT_GROUP)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_BILL_INSTR_A_INSTALLMENT_GROUP] Script Date: 03/09/2017 16:44:56 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_BILL_INSTR_A_INSTALLMENT_GROUP]( [ISN_AR_BILL_INSTR_A] [int] NOT NULL, [INSTALLMENT_GROUP_COUNT] [smallint] NOT NULL, [BILL_INSTALL_NUM] [int] NULL, [BILL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [INSTALL_AMOUNT] [numeric](17, 2) NULL, [ADDON_AMOUNT] [numeric](17, 2) NULL, [BILL_AMOUNT] [numeric](17, 2) NULL, [BILLED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| BILL_AMOUNT | BILL_DATE | BILL_INSTALL_NUM | BILLED_IND | cnxarraycolumn | INSTALL_AMOUNT | INSTALLMENT_GROUP_COUNT | ISN_AR_BILL_INSTR_A | RowUpdatedOn |
| 262.84 | 20151106 | 1 | 0 | 262.84 | 1 | 152378 | 2017-02-06T10:48:50.97-05:00 | |
| 395.00 | 20060110 | 1 | 0 | 395.00 | 1 | 39332 | 2017-02-06T10:48:40.986-05:00 | |
| 153.60 | 20051014 | 1 | 0 | 153.60 | 1 | 38503 | 2017-02-06T10:48:40.892-05:00 | |
| 167.95 | 20050915 | 1 | 0 | 167.95 | 1 | 38065 | 2017-02-06T10:48:40.861-05:00 | |
| 590.00 | 20151007 | 1 | 0 | 590.00 | 1 | 151529 | 2017-02-06T10:48:50.861-05:00 | |
| 15.00 | 20030814 | 1 | 0 | 15.00 | 1 | 21360 | 2017-02-06T10:48:39.66-05:00 | |
| 1000.00 | 20150610 | 1 | 0 | 1000.00 | 1 | 141094 | 2017-02-06T10:48:50.83-05:00 | |
| 76.50 | 20041015 | 1 | 0 | 76.50 | 1 | 29873 | 2017-02-06T10:48:40.331-05:00 | |
| 589.00 | 20050111 | 1 | 0 | 589.00 | 1 | 31147 | 2017-02-06T10:48:40.346-05:00 | |
| 80.00 | 20050324 | 1 | 0 | 80.00 | 1 | 33422 | 2017-02-06T10:48:40.518-05:00 |
| Powered by BI Documenter |
