DWStaging
 dbo.FIP_PO_HDR_VIEW_LOG_A_BILL_TO_ADDR_LINE (Table)
  Properties
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
  Columns
 
 
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
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_PO_HDR_VIEW_LOG_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_PO_HDR_VIEW_LOG_A_BILL_TO_ADDR_LINE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_PO_HDR_VIEW_LOG_A_BILL_TO_ADDR_LINE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** 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
)
  Sample Data
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