|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FIP_PRQ_DET_ACCOUNT_COMM_DETAIL |
| Schema | dbo |
| Row Count | 414571 |
| Data Size | 20192 KB |
| Index Size | 7352 KB |
| Create Date | 10/24/2012 3:19 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ACCOUNT_COMM_DETAIL_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ACCT_COMMITTED_ACCT |
varchar(25) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
COMMITMENT_WORK_AMT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
COMMITTED_AMT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
ISN_FIP_PRQ_DET |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_FIP_PRQ_DET, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FIP_PRQ_DET_ACCOUNT_COMM_DETAIL depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.FIP_PRQ_DET_ACCOUNT_COMM_DETAIL)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FIP_PRQ_DET_ACCOUNT_COMM_DETAIL] Script Date: 03/09/2017 16:45:26 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FIP_PRQ_DET_ACCOUNT_COMM_DETAIL]( [ISN_FIP_PRQ_DET] [int] NOT NULL, [ACCOUNT_COMM_DETAIL_COUNT] [smallint] NOT NULL, [ACCT_COMMITTED_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [COMMITTED_AMT] [numeric](17, 2) NULL, [COMMITMENT_WORK_AMT] [numeric](17, 2) NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ACCOUNT_COMM_DETAIL_COUNT | ACCT_COMMITTED_ACCT | cnxarraycolumn | COMMITMENT_WORK_AMT | ISN_FIP_PRQ_DET | RowUpdatedOn |
| 1 | 170100007010048062501 | 0 | 342.69 | 85823 | 2017-02-06T10:45:42.1-05:00 |
| 1 | 112501002501011065502 | 0 | 8.82 | 267124 | 2017-02-06T10:45:54.346-05:00 |
| 1 | 212401002401142066506 | 0 | 485.78 | 241218 | 2017-02-06T10:45:52.474-05:00 |
| 1 | 112703002703021064501 | 0 | 600.00 | 322779 | 2017-02-06T10:45:58.651-05:00 |
| 1 | 111210001210002065502 | 0 | 17.28 | 278400 | 2017-02-06T10:45:55.219-05:00 |
| 1 | 770760187010211075031 | 0 | 760.00 | 288897 | 2017-02-06T10:45:56.046-05:00 |
| 1 | 161210006121009365502 | 0 | 111.62 | 110957 | 2017-02-06T10:45:43.769-05:00 |
| 1 | 251000001000129466503 | 0 | 20.00 | 53080 | 2017-02-06T10:45:39.931-05:00 |
| 1 | 681260008120759066503 | 0 | 280.00 | 382002 | 2017-02-06T10:46:03.097-05:00 |
| 1 | 111119001119002065501 | 0 | 22.87 | 319727 | 2017-02-06T10:45:58.417-05:00 |
| Powered by BI Documenter |
