DWStaging
 dbo.FIP_PO_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_PO_DET
  Properties
Property Value
Name FIP_PO_DET
Schema dbo
Row Count 413336
Data Size 76752 KB
Index Size 6560 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
 
BAL_AMT_ACCRUED
numeric(17, 2)
True
False
False
 
BAL_QTY_ACCRUED
numeric(17, 4)
True
False
False
 
BALANCE_TOT_AMT
numeric(17, 2)
True
False
False
 
BUYER_ID
varchar(3)
True
False
False
 
COMMODITY_CODE
varchar(13)
True
False
False
 
DET_COMMITTED_AMT
numeric(17, 2)
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
 
ENC_TOT_AMT
numeric(17, 2)
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_PO_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
 
PAID_TOT_AMT
numeric(17, 2)
True
False
False
 
PAY_STATUS
varchar(2)
True
False
False
 
PREV_PO_INFO
varchar(15)
True
False
False
 
PRQ_ITM_NBR
int(10, 0)
True
False
False
 
PRQ_SEQ_NBR
int(10, 0)
True
False
False
 
PRQ_YR_REF_NBR
varchar(12)
True
False
False
 
QTY_ORD
numeric(17, 4)
True
False
False
 
REC_AMT_ACCRUED
numeric(17, 2)
True
False
False
 
REC_AMT_PAYABLES
numeric(17, 2)
True
False
False
 
REC_QTY_ACCRUED
numeric(17, 4)
True
False
False
 
REC_QTY_PAYABLES
numeric(17, 4)
True
False
False
 
REC_QTY_REC_TO_DATE
numeric(17, 4)
True
False
False
 
REC_STATUS
varchar(2)
True
False
False
 
RECEIVING_USER_ID
varchar(8)
True
False
False
 
RELO_PO_REF_INFO
varchar(15)
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_PO_DET
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_PO_DET depends on)
Name Type
View
StoredProcedure
  Child Dependencies (objects that depend on dbo.FIP_PO_DET)
Name Type
STOREDPROCEDURE
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_PO_DET] Script Date: 03/09/2017 16:45:24 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_PO_DET](
    [ISN_FIP_PO_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,
    [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,
    [TXT_NOTES_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,
    [REC_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIN_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,
    [PRQ_YR_REF_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRQ_ITM_NBR] [int] NULL,
    [PRQ_SEQ_NBR] [int] NULL,
    [DET_COMMITTED_AMT] [numeric](17, 2) NULL,
    [REC_QTY_PAYABLES] [numeric](17, 4) NULL,
    [REC_AMT_PAYABLES] [numeric](17, 2) NULL,
    [REC_QTY_ACCRUED] [numeric](17, 4) NULL,
    [REC_AMT_ACCRUED] [numeric](17, 2) NULL,
    [BAL_AMT_ACCRUED] [numeric](17, 2) NULL,
    [BAL_QTY_ACCRUED] [numeric](17, 4) NULL,
    [DET_ITM_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_PO_INFO] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RELO_PO_REF_INFO] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENC_TOT_AMT] [numeric](17, 2) NULL,
    [BALANCE_TOT_AMT] [numeric](17, 2) NULL,
    [PAID_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 BUYER_ID COMMODITY_CODE DET_ITM_NBR DET_ITM_TYPE DET_LINE_ITM_AMT DET_STATUS DET_YEAR_REF_NBR DUE_DATE ENC_TOT_AMT FIN_STATUS FREIGHT_IND HOLD ISN_FIP_PO_DET MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAID_TOT_AMT PAY_STATUS PREV_PO_INFO PRQ_ITM_NBR PRQ_SEQ_NBR PRQ_YR_REF_NBR QTY_ORD REC_AMT_PAYABLES REC_QTY_PAYABLES REC_QTY_REC_TO_DATE REC_STATUS RECEIVING_USER_ID RELO_PO_REF_INFO RowUpdatedOn STD_ITM_NBR TXT_NOTES_IND UNIT_COST UNIT_MEAS
20040831 FIP701N1 0927496 E010125 FNS 3 5.88 CL 200500001459 20040915 5.88 EN 927502 182167 20040930 FIA310N1 0818485 E002800 5.88 CM 3 1 200500001706 12.0000 5.88 12.0000 12.0000 RC E007520 2017-02-06T10:45:32.864-05:00 0.4900 EA
20030624 FIP701N1 1659506 E010125 FNS 14 12.48 CL 200300229047 20030627 12.48 EN 1659537 144805 20030717 FIA310N1 1102142 E002800 12.48 CM 14 1 200300008365 24.0000 12.48 24.0000 24.0000 RC E001093 2017-02-06T10:45:27.155-05:00 0.5200 EA
20120222 FIP701N1 0950543 E037615 JAW 1 39.98 CL 201200003993 20120309 39.98 EN 950545 340507 20120319 FIA310N1 1118553 E032885 39.98 CM 1 1 201200004309 2.0000 39.98 2.0000 2.0000 RC E025895 2017-02-06T10:45:56.826-05:00 19.9900 EA
20100817 FIP701N1 1528356 E037615 JAW 16 138.60 CL 201100001162 20100830 138.60 EN 1528366 316179 20100825 FIA310N1 0925142 E032885 138.60 CM 16 1 201100000495 1.0000 138.60 1.0000 1.0000 RC E025895 2017-02-06T10:45:53.035-05:00 138.6000 CS
20060215 FIP701N1 1117113 E010125 NPS 5 72.00 CL 200600003958 20060228 72.00 EN 1117122 214343 20060411 FIA310N1 1045074 E001609 57.60 PT 5 1 200600004092 6.0000 57.60 6.0000 6.0000 RC E007520 2017-02-06T10:45:37.903-05:00 12.0000 EA
20040217 FIP701N1 1321275 E010125 FNS 5 6.98 CL 200400004779 20040218 6.98 EN 1321284 163373 20040224 FIA310N1 1019317 E002800 6.98 CM 5 1 200400005262 2.0000 6.98 2.0000 2.0000 RC E007520 2017-02-06T10:45:29.885-05:00 3.4900 EA
20020801 FIP701N1 1557274 SIMPSONF FNS 1 10.69 CL 200300222183 20020805 10.69 EN 1557281 115773 20020812 FIA310N1 1150418 NGREENE 10.69 CM 2 1 200300000919 1.0000 10.69 1.0000 1.0000 RC MTATMAN 2017-02-06T10:45:22.927-05:00 10.6900 EA
20070402 FIP701N1 1404401 E037615 JAW 2 7.00 CL 200700004452 20070428 7.00 EN 1404404 238891 20070426 FIA310N1 1155298 E001609 7.00 CM 2 1 200700004828 1.0000 7.00 1.0000 1.0000 RC E007520 2017-02-06T10:45:41.725-05:00 7.0000 EA
20000918 FIP701N1 1356441 DWINDHAM DLW 5 20.00 CL 200100207331 20000924 20.00 EN 901020 47772 20000926 FIP701N1 0901020 NGREENE 20.00 CM 5 1 200100027916 20.0000 20.00 20.0000 20.0000 RC ESPENCER 2017-02-06T10:45:12.771-05:00 1.0000 EA
20040127 FIP701N1 1450275 E010125 FNS 12 3.24 CL 200400004318 20040128 3.24 EN 1450289 28208 20040203 FIA310N1 0823333 E002800 3.24 CM 12 1 200400004582 2.0000 3.24 2.0000 2.0000 RC E001732 2017-02-06T10:45:09.745-05:00 1.6200 DZ
Powered by BI Documenter