|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FIP_PO_DET_ACCOUNT_DET |
| Schema | dbo |
| Row Count | 417237 |
| Data Size | 28096 KB |
| Index Size | 7400 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_DET_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ACCT_CUSTODIAL_ACCT |
varchar(25) |
True |
False |
False |
|||
|
|
ACCT_NBR |
varchar(25) |
True |
False |
False |
|||
|
|
AMT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DET_ITM_NBR |
int(10, 0) |
True |
False |
False |
|||
|
|
DET_STATUS |
varchar(2) |
True |
False |
False |
|||
|
|
DET_YEAR_REF_NBR |
varchar(12) |
True |
False |
False |
|||
|
|
EXTRA_COST_IND |
varchar(1) |
True |
False |
False |
|||
|
|
ISN_FIP_PO_DET |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
SPLIT_PCT |
numeric(17, 4) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_FIP_PO_DET, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FIP_PO_DET_ACCOUNT_DET depends on)
| Name | Type |
View |
|
View |
Child Dependencies (objects that depend on dbo.FIP_PO_DET_ACCOUNT_DET)
| Name | Type |
VIEW |
|
VIEW |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FIP_PO_DET_ACCOUNT_DET] Script Date: 03/09/2017 16:45:24 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FIP_PO_DET_ACCOUNT_DET]( [ISN_FIP_PO_DET] [int] NOT NULL, [ACCOUNT_DET_COUNT] [smallint] NOT NULL, [DET_YEAR_REF_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DET_ITM_NBR] [int] NULL, [DET_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACCT_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ACCT_CUSTODIAL_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SPLIT_PCT] [numeric](17, 4) NULL, [AMT] [numeric](17, 2) NULL, [EXTRA_COST_IND] [varchar](1) 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
| ACCOUNT_DET_COUNT | ACCT_CUSTODIAL_ACCT | ACCT_NBR | cnxarraycolumn | DET_ITM_NBR | DET_STATUS | DET_YEAR_REF_NBR | EXTRA_COST_IND | ISN_FIP_PO_DET | RowUpdatedOn | SPLIT_PCT |
| 1 | 212401002401052065501 | 0 | 15 | CL | 201000005130 | X | 310280 | 2017-02-06T10:45:43.613-05:00 | 100.0000 | |
| 1 | 153030005303015065502 | 0 | 1 | CL | 200400004203 | X | 143600 | 2017-02-06T10:45:31.414-05:00 | 100.0000 | |
| 1 | 777420447010311075021 | 0 | 2 | CL | 199900194804 | X | 6444 | 2017-02-06T10:45:21.726-05:00 | 100.0000 | |
| 1 | 251000002000039466504 | 0 | 3 | CL | 201400005022 | X | 376346 | 2017-02-06T10:45:48.48-05:00 | 100.0000 | |
| 1 | 112501002501011065502 | 0 | 2 | CL | 200200214247 | X | 72379 | 2017-02-06T10:45:26.25-05:00 | 100.0000 | |
| 1 | 161110006111009165502 | 0 | 3 | CL | 200600005713 | X | 219948 | 2017-02-06T10:45:36.967-05:00 | 100.0000 | |
| 1 | 251000001000019460506 | 0 | 2 | CL | 200000204574 | X | 38068 | 2017-02-06T10:45:23.941-05:00 | 100.0000 | |
| 1 | 146000004600001065502 | 0 | 6 | CL | 200000200148 | X | 23896 | 2017-02-06T10:45:22.927-05:00 | 100.0000 | |
| 1 | 163100006310019662504 | 0 | 2 | CL | 200200214825 | X | 74201 | 2017-02-06T10:45:26.375-05:00 | 100.0000 | |
| 1 | 170200007020048071004 | 0 | 1 | CL | 200000200521 | X | 82913 | 2017-02-06T10:45:26.983-05:00 | 100.0000 |
| Powered by BI Documenter |
