DWStaging
 dbo.FIP_CO_DET_A (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_CO_DET_A
  Properties
Property Value
Name FIP_CO_DET_A
Schema dbo
Row Count 66521
Data Size 5512 KB
Index Size 1032 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
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
 
BUYER_ID
varchar(3)
True
False
False
 
BUYER_ID_B
varchar(3)
True
False
False
 
CHG_ORD_ITEM_ACTION
varchar(2)
True
False
False
 
CHG_ORD_NBR
int(10, 0)
True
False
False
 
CHG_ORD_NOTE_IND
varchar(1)
True
False
False
 
COMMODITY_CODE
varchar(13)
True
False
False
 
COMMODITY_CODE_B
varchar(13)
True
False
False
 
DET_ITM_NBR
int(10, 0)
True
False
False
 
DET_ITM_TYPE
varchar(2)
True
False
False
 
DET_ITM_TYPE_B
varchar(2)
True
False
False
 
DET_LINE_ITM_AMT
numeric(17, 2)
True
False
False
 
DET_LINE_ITM_AMT_B
numeric(17, 2)
True
False
False
 
DET_STATUS
varchar(2)
True
False
False
 
DET_STATUS_B
varchar(2)
True
False
False
 
DET_YEAR_REF_NBR
varchar(12)
True
False
False
 
DISC
numeric(17, 4)
True
False
False
 
DISC_B
numeric(17, 4)
True
False
False
 
DUE_DATE
varchar(8)
True
False
False
 
DUE_DATE_B
varchar(8)
True
False
False
 
FREIGHT_IND
varchar(1)
True
False
False
 
FREIGHT_IND_B
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_CO_DET_A
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
 
QTY_ORD
numeric(17, 4)
True
False
False
 
QTY_ORD_B
numeric(17, 4)
True
False
False
 
REC_QTY_REC_TO_DATE
numeric(17, 4)
True
False
False
 
REC_QTY_REC_TO_DATE_B
numeric(17, 4)
True
False
False
 
REC_STATUS
varchar(2)
True
False
False
 
REC_STATUS_B
varchar(2)
True
False
False
 
RECEIVING_USER_ID
varchar(8)
True
False
False
 
RECEIVING_USER_ID_B
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STD_ITM_NBR
varchar(15)
True
False
False
 
STD_ITM_NBR_B
varchar(15)
True
False
False
 
UNIT_COST
numeric(17, 4)
True
False
False
 
UNIT_COST_B
numeric(17, 4)
True
False
False
 
UNIT_MEAS
varchar(6)
True
False
False
 
UNIT_MEAS_B
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_CO_DET_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_CO_DET_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_CO_DET_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_CO_DET_A] Script Date: 03/09/2017 16:45:21 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_CO_DET_A](
    [ISN_FIP_CO_DET_A] [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,
    [DET_YEAR_REF_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHG_ORD_NBR] [int] NULL,
    [DET_ITM_NBR] [int] NULL,
    [CHG_ORD_NOTE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHG_ORD_ITEM_ACTION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_LINE_ITM_AMT] [numeric](17, 2) NULL,
    [QTY_ORD] [numeric](17, 4) NULL,
    [UNIT_MEAS] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNIT_COST] [numeric](17, 4) NULL,
    [DISC] [numeric](17, 4) NULL,
    [COMMODITY_CODE] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STD_ITM_NBR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FREIGHT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVING_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_QTY_REC_TO_DATE] [numeric](17, 4) NULL,
    [BUYER_ID] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_ITM_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_LINE_ITM_AMT_B] [numeric](17, 2) NULL,
    [QTY_ORD_B] [numeric](17, 4) NULL,
    [UNIT_MEAS_B] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNIT_COST_B] [numeric](17, 4) NULL,
    [DISC_B] [numeric](17, 4) NULL,
    [COMMODITY_CODE_B] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STD_ITM_NBR_B] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FREIGHT_IND_B] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DUE_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_STATUS_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_STATUS_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVING_USER_ID_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_QTY_REC_TO_DATE_B] [numeric](17, 4) NULL,
    [BUYER_ID_B] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_ITM_TYPE_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BUYER_ID BUYER_ID_B CHG_ORD_ITEM_ACTION CHG_ORD_NBR CHG_ORD_NOTE_IND COMMODITY_CODE COMMODITY_CODE_B DET_ITM_NBR DET_ITM_TYPE DET_ITM_TYPE_B DET_LINE_ITM_AMT DET_LINE_ITM_AMT_B DET_STATUS DET_STATUS_B DET_YEAR_REF_NBR DUE_DATE DUE_DATE_B FREIGHT_IND FREIGHT_IND_B HOLD ISN_FIP_CO_DET_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID QTY_ORD REC_STATUS REC_STATUS_B RECEIVING_USER_ID RECEIVING_USER_ID_B RowUpdatedOn STD_ITM_NBR STD_ITM_NBR_B UNIT_COST UNIT_COST_B UNIT_MEAS UNIT_MEAS_B
MO 1 Y 1 3000.00 2500.00 201700000991 1459526 66504 2017-02-06T11:09:02.318-05:00 3000.0000 2500.0000
MO 2 Y 1 CL OP 199900193768 1419430 4449 2017-02-06T11:08:54.44-05:00
MO 2 Y 1 86000.00 79000.00 200800000125 1407066 39672 2017-02-06T11:08:58.964-05:00 86000.0000 79000.0000
MO 4 Y 1 945.00 1015.00 201500001917 1054410 61134 2017-02-06T11:09:01.663-05:00 945.0000 1015.0000
KPR AD 1 Y 3 4112.25 OP 200800002638 20071219 1436492 41459 1.0000 RC 2017-02-06T11:08:59.167-05:00 4112.2500 JOB
MO 1 Y 6 566.00 608.00 201100000814 1241375 48139 2017-02-06T11:09:00.056-05:00 56.6000 60.8000
MO 1 Y 31 91.30 91.32 CL OP 200000198864 1726552 9129 2017-02-06T11:08:54.955-05:00 7.6083 7.6100
KPR AD 1 Y 1 14999.00 OP 200500002689 20041111 1108432 29503 1.0000 RC 2017-02-06T11:08:57.622-05:00 14999.0000 YR
KRW AD 1 Y 1 102395.55 OP 201300000458 20120809 1424138 55490 1.0000 RC 2017-02-06T11:09:00.929-05:00 102395.5500 LOT
JAW AD 1 Y 8 38.00 OP 201100005470 20110623 Y 844552 50411 1.0000 RC 2017-02-06T11:09:00.321-05:00 38.0000 EA
Powered by BI Documenter