DWStaging
 dbo.FIP_REQ_DET (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_REQ_DET
  Properties
Property Value
Name FIP_REQ_DET
Schema dbo
Row Count 424887
Data Size 57736 KB
Index Size 6744 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
 
ALLOCATION_IND
varchar(1)
True
False
False
 
BALANCE_TOT_AMT
numeric(17, 2)
True
False
False
 
BID_NOTES_IND
varchar(1)
True
False
False
 
BUYER_ID
varchar(3)
True
False
False
 
CHANGE_NBR
int(10, 0)
True
False
False
 
COM_TOT_AMT
numeric(17, 2)
True
False
False
 
COMMODITY_CODE
varchar(13)
True
False
False
 
COMMODITY_TXT_IND
varchar(1)
True
False
False
 
DET_CONTRACT_NBR
varchar(16)
True
False
False
 
DET_ITM_NBR
int(10, 0)
True
False
False
 
DET_ITM_TYPE
varchar(2)
True
False
False
 
DET_LINE_ITM_AMT
numeric(17, 2)
True
False
False
 
DET_STATUS
varchar(2)
True
False
False
 
DET_YEAR_REF_NBR
varchar(12)
True
False
False
 
DISC
numeric(17, 4)
True
False
False
 
DUE_DATE
varchar(8)
True
False
False
 
FIN_STATUS
varchar(2)
True
False
False
 
FREIGHT_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_REQ_DET
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
 
NOTES_IND
varchar(1)
True
False
False
 
PREV_ITEM_SEQ
int(10, 0)
True
False
False
 
QTY_ORD
numeric(17, 4)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STD_ITM_NBR
varchar(15)
True
False
False
 
TXT_NOTES_IND
varchar(1)
True
False
False
 
UNIT_COST
numeric(17, 4)
True
False
False
 
UNIT_MEAS
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_REQ_DET
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_REQ_DET depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_REQ_DET)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_REQ_DET] Script Date: 03/09/2017 16:45:28 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_REQ_DET](
    [ISN_FIP_REQ_DET] [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,
    [DET_ITM_NBR] [int] NULL,
    [DET_LINE_ITM_AMT] [numeric](17, 2) NULL,
    [BALANCE_TOT_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,
    [COMMODITY_TXT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TXT_NOTES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BID_NOTES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALLOCATION_IND] [varchar](1) 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,
    [FIN_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHANGE_NBR] [int] NULL,
    [BUYER_ID] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STD_ITM_NBR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_CONTRACT_NBR] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_ITEM_SEQ] [int] NULL,
    [DET_ITM_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COM_TOT_AMT] [numeric](17, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ALLOCATION_IND BALANCE_TOT_AMT BID_NOTES_IND BUYER_ID COM_TOT_AMT COMMODITY_CODE COMMODITY_TXT_IND DET_CONTRACT_NBR DET_ITM_NBR DET_ITM_TYPE DET_LINE_ITM_AMT DET_STATUS DET_YEAR_REF_NBR DISC DUE_DATE FIN_STATUS FREIGHT_IND HOLD ISN_FIP_REQ_DET MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NOTES_IND QTY_ORD RowUpdatedOn STD_ITM_NBR TXT_NOTES_IND UNIT_COST UNIT_MEAS
20090519 FIP301N1 1444496 E067489 4.75 4.75 16 4.75 PR 200900006237 CO 1426580 300531 20090520 FIP301N1 1426580 E001353 5.0000 2017-02-06T10:45:10.447-05:00 0.9500 EA
20050112 FIP301N1 1050194 E011952 29.60 29.60 10 29.60 PR 200500004046 CO 1033232 191812 20050120 FIP301N1 1033232 E001859 4.0000 2017-02-06T10:44:56.329-05:00 7.4000 EA
20040316 FIP301N1 1440565 E011952 192.48 192.48 54 192.48 PR 200400006116 CO 751004 168082 20040323 FIP301N1 0751004 E001859 24.0000 2017-02-06T10:44:53.583-05:00 8.0200 EA
20110512 FIP301N1 1344449 E057663 15.96 15.96 23 15.96 PR 201100005740 20.0000 CO 756267 338184 20110516 FIP301N1 0756267 E026994 1.0000 2017-02-06T10:45:15.08-05:00 19.9500 EA
20100712 FIP301N1 1350068 E004093 467.82 467.82 29 467.82 PR 201100000396 CO 1006230 323281 20100719 FIP301N1 1006230 E026994 2.0000 2017-02-06T10:45:13.255-05:00 233.9100 EA
20140324 FIP300N9 1025120 E008147 225.00 225.00 1 225.00 PR 201400004694 CO 1207021 386500 20140325 FIP301N1 1207021 E001353 Y 1.0000 2017-02-06T10:45:20.821-05:00 225.0000 EA
20010502 FIP301N1 1549201 LKATZ 24.95 24.95 3 24.95 PR 200100034142 CO 938246 62868 20010503 FIP301N1 0938246 JBEGEER 1.0000 2017-02-06T10:44:40.698-05:00 24.9500 EA
19991004 FIP301N1 1355529 AVICKERS 648.00 648.00 1 648.00 PR 200000019751 CO 1630280 79610 19991005 FIP301N1 1630280 BBLACK 12.0000 2017-02-06T10:44:42.835-05:00 54.0000 EA
20050711 FIP301N1 0922561 E003552 8000.00 8000.00 1 8000.00 PR 200600000062 CO 908156 113083 20050721 FIP301N1 0908156 E001859 1.0000 2017-02-06T10:44:46.922-05:00 8000.0000 JOB
20010508 FIP301N1 1049565 BMANCUSO 51.60 51.60 3 51.60 PR 200100034327 CO 1459223 90442 20010510 FIP301N1 1459223 JBEGEER 1.0000 2017-02-06T10:44:44.192-05:00 51.6000 EA
Powered by BI Documenter