|
![]() |
Property | Value |
Name | FIP_PO_HDR_VIEW_LOG_A_BILL_TO_ADDR_LINE |
Schema | dbo |
Row Count | 8725720 |
Data Size | 418704 KB |
Index Size | 147336 KB |
Create Date | 10/24/2012 3:19 PM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
BILL_TO_ADDR_LINE |
varchar(40) |
True |
False |
False |
|||
![]() |
![]() |
BILL_TO_ADDR_LINE_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
ISN_FIP_PO_HDR_VIEW_LOG_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_FIP_PO_HDR_VIEW_LOG_A, cnxarraycolumn |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[FIP_PO_HDR_VIEW_LOG_A_BILL_TO_ADDR_LINE] Script Date: 03/09/2017 16:45:25 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FIP_PO_HDR_VIEW_LOG_A_BILL_TO_ADDR_LINE]( [ISN_FIP_PO_HDR_VIEW_LOG_A] [int] NOT NULL, [BILL_TO_ADDR_LINE_COUNT] [smallint] NOT NULL, [BILL_TO_ADDR_LINE] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
BILL_TO_ADDR_LINE | BILL_TO_ADDR_LINE_COUNT | cnxarraycolumn | ISN_FIP_PO_HDR_VIEW_LOG_A | RowUpdatedOn |
PALM BEACH STATE COLLEGE | 5 | 0 | 1309755 | 2017-02-06T10:22:44.689-05:00 |
LAKE WORTH, FL 33461-4796 | 5 | 4 | 1440180 | 2017-02-06T10:23:09.228-05:00 |
4200 CONGRESS AVENUE | 5 | 3 | 449684 | 2017-02-06T10:20:07.955-05:00 |
4200 CONGRESS AVENUE | 5 | 3 | 1710888 | 2017-02-06T10:24:01.176-05:00 |
4200 CONGRESS AVENUE | 5 | 3 | 1206070 | 2017-02-06T10:22:24.487-05:00 |
LAKE WORTH, FL 33461-4796 | 5 | 4 | 1468050 | 2017-02-06T10:23:14.532-05:00 |
4200 CONGRESS AVENUE | 5 | 3 | 1041497 | 2017-02-06T10:21:54.737-05:00 |
ATTN: ACCOUNTS PAYABLE | 5 | 1 | 1378177 | 2017-02-06T10:22:57.247-05:00 |
4200 CONGRESS AVENUE | 5 | 3 | 169133 | 2017-02-06T10:19:15.663-05:00 |
4200 CONGRESS AVENUE | 5 | 3 | 256321 | 2017-02-06T10:19:32.059-05:00 |
Powered by BI Documenter |