|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_ADJUSTMENTS_A_REFUND_GROUP |
| Schema | dbo |
| Row Count | 635020 |
| Data Size | 14504 KB |
| Index Size | 10776 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 |
||
 |
|
CHARGE_NUM |
varchar(16) |
True |
False |
False |
|||
|
|
CHARGE_TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_AR_ADJUSTMENTS_A |
int(10, 0) |
False |
False |
False |
|||
|
|
PAYMENT_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
PAYMENT_TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
REFUND_GROUP_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_ADJUSTMENTS_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_ADJUSTMENTS_A_REFUND_GROUP depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_ADJUSTMENTS_A_REFUND_GROUP)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_ADJUSTMENTS_A_REFUND_GROUP] Script Date: 03/09/2017 16:44:55 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_ADJUSTMENTS_A_REFUND_GROUP]( [ISN_AR_ADJUSTMENTS_A] [int] NOT NULL, [REFUND_GROUP_COUNT] [smallint] NOT NULL, [PAYMENT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYMENT_AMOUNT] [numeric](17, 2) NULL, [CHARGE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHARGE_NUM] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| CHARGE_NUM | CHARGE_TYPE | cnxarraycolumn | ISN_AR_ADJUSTMENTS_A | PAYMENT_TYPE | REFUND_GROUP_COUNT | RowUpdatedOn |
| VS | 3 | 9634576 | 5 | 2017-02-06T09:18:14.21-05:00 | ||
| VS | 2 | 3094856 | 5 | 2017-02-06T09:10:58.656-05:00 | ||
| VS | 0 | 2451658 | 5 | 2017-02-06T09:10:15.053-05:00 | ||
| VS | 2 | 9437459 | 5 | 2017-02-06T09:18:08.844-05:00 | ||
| VS | 0 | 5007235 | 5 | 2017-02-06T09:13:08.589-05:00 | ||
| VS | 4 | 5310015 | 5 | 2017-02-06T09:13:30.179-05:00 | ||
| VS | 3 | 7501046 | 5 | 2017-02-06T09:15:52.281-05:00 | ||
| VS | 3 | 4062211 | 5 | 2017-02-06T09:12:05.689-05:00 | ||
| MC | 1 | 2620912 | 5 | 2017-02-06T09:10:25.505-05:00 | ||
| VS | 0 | 2896877 | 5 | 2017-02-06T09:10:44.631-05:00 |
| Powered by BI Documenter |
