DWStaging
 dbo.FIP_RECEIVING (Table)
Home  Diagrams  Documents  Images  DWStaging  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWStaging   Tables   dbo.FIP_RECEIVING
  Properties
Property Value
Name FIP_RECEIVING
Schema dbo
Row Count 359830
Data Size 37376 KB
Index Size 5784 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
ACTUAL_RECV_DATE
varchar(8)
True
False
False
 
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
BILL_OF_LADING
varchar(15)
True
False
False
 
CARRIER_NAME
varchar(30)
True
False
False
 
EXCEPTION_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_RECEIVING
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
MIN_SPLIT_QTY
int(10, 0)
True
False
False
 
NOTE_IND
varchar(1)
True
False
False
 
ORIG_QTY_REC
numeric(17, 4)
True
False
False
 
PACKING_SLIP
varchar(15)
True
False
False
 
PAID_IND
varchar(1)
True
False
False
 
PROPERTY_CTRL_IND
varchar(1)
True
False
False
 
QTY_BACKORDERED
numeric(17, 4)
True
False
False
 
QTY_PAID
numeric(17, 4)
True
False
False
 
QTY_REC
numeric(17, 4)
True
False
False
 
REC_ACTION
varchar(1)
True
False
False
 
REC_GROUP_NBR
int(10, 0)
True
False
False
 
REC_SEQ_NBR
int(10, 0)
True
False
False
 
REC_SPLIT_IND
varchar(1)
True
False
False
 
REC_YR_REF_ITM_NBR
varchar(15)
True
False
False
 
RECEIVE_ALL_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SHIPPER_NAME
varchar(30)
True
False
False
 
TOT_QTY_ACCEPTED
numeric(17, 4)
True
False
False
 
TOT_QTY_CREDITED
numeric(17, 4)
True
False
False
 
TOT_QTY_EXCEPTION
numeric(17, 4)
True
False
False
 
TOT_QTY_REFUNDED
numeric(17, 4)
True
False
False
 
TOT_QTY_RETURNED
numeric(17, 4)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_RECEIVING
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_RECEIVING depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_RECEIVING)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_RECEIVING] Script Date: 03/09/2017 16:45:27 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_RECEIVING](
    [ISN_FIP_RECEIVING] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [REC_YR_REF_ITM_NBR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_SEQ_NBR] [int] NULL,
    [REC_GROUP_NBR] [int] NULL,
    [EXCEPTION_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROPERTY_CTRL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAID_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARRIER_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SHIPPER_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_OF_LADING] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PACKING_SLIP] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QTY_REC] [numeric](17, 4) NULL,
    [QTY_PAID] [numeric](17, 4) NULL,
    [ORIG_QTY_REC] [numeric](17, 4) NULL,
    [TOT_QTY_EXCEPTION] [numeric](17, 4) NULL,
    [TOT_QTY_ACCEPTED] [numeric](17, 4) NULL,
    [TOT_QTY_RETURNED] [numeric](17, 4) NULL,
    [TOT_QTY_REFUNDED] [numeric](17, 4) NULL,
    [TOT_QTY_CREDITED] [numeric](17, 4) NULL,
    [QTY_BACKORDERED] [numeric](17, 4) NULL,
    [MIN_SPLIT_QTY] [int] NULL,
    [REC_SPLIT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVE_ALL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTUAL_RECV_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTUAL_RECV_DATE ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BILL_OF_LADING CARRIER_NAME EXCEPTION_IND HOLD ISN_FIP_RECEIVING MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NOTE_IND ORIG_QTY_REC PACKING_SLIP PAID_IND PROPERTY_CTRL_IND QTY_REC REC_ACTION REC_GROUP_NBR REC_SEQ_NBR REC_SPLIT_IND REC_YR_REF_ITM_NBR RECEIVE_ALL_IND RowUpdatedOn SHIPPER_NAME
20051213 20051213 FIP810N1 1020278 E007520 1020278 176951 80.0000 80.0000 2 1 200600002793002 2017-02-06T10:47:16.839-05:00
20060519 20060519 FIP810N1 1159568 E001732 1159568 188988 1.0000 NONE 1.0000 3 2 200600004855003 Y 2017-02-06T10:47:17.931-05:00
20061016 20061016 FIP810N1 1211184 E007520 1211184 197678 3.0000 3.0000 1 1 200700001748059 Y 2017-02-06T10:47:18.773-05:00
20081208 20081211 FIP810N1 1119414 E002118 1119414 250198 1000.0000 1000.0000 1 1 200900002893001 Y 2017-02-06T10:47:23.719-05:00
20001114 FIP810N1 1405479 JCHALHUB 1406047 37112 20001114 FIP810N1 1406047 JCHALHUB Y 6.0000 3.0000 1 1 200100208725008 2017-02-06T10:47:03.329-05:00
20041006 20041006 FIP810N1 1111024 E007520 1111024 145707 48.0000 48.0000 1 1 200500001632015 Y 2017-02-06T10:47:13.75-05:00
20080204 20080204 FIP810N1 0827554 E025895 827554 227739 2.0000 2.0000 3 1 200800001359099 2017-02-06T10:47:21.566-05:00
20040420 20040420 FIP810N1 1638515 E007520 1638515 129262 12.0000 12.0000 1 1 200400004686029 Y 2017-02-06T10:47:12.097-05:00
20070410 20070410 FIP810N1 1607597 E007520 1607597 208692 30.0000 30.0000 1 1 200700003933004 Y 2017-02-06T10:47:19.787-05:00
20010911 FIP810N1 0845348 MELENDEG 845348 59058 2.0000 2.0000 1 1 200200215417006 Y 2017-02-06T10:47:05.389-05:00
Powered by BI Documenter