DWStaging
 dbo.FIP_PO_DET_VIEW_LOG_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_PO_DET_VIEW_LOG_A
  Properties
Property Value
Name FIP_PO_DET_VIEW_LOG_A
Schema dbo
Row Count 829187
Data Size 125280 KB
Index Size 12392 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
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_VIEW_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
True
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_VIEW_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_PO_DET_VIEW_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_PO_DET_VIEW_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_PO_DET_VIEW_LOG_A] Script Date: 03/09/2017 16:45:24 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_PO_DET_VIEW_LOG_A](
    [ISN_FIP_PO_DET_VIEW_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [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
BALANCE_TOT_AMT 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_VIEW_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER 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_STATUS RECEIVING_USER_ID RELO_PO_REF_INFO RowUpdatedOn STD_ITM_NBR TXT_NOTES_IND UNIT_COST UNIT_MEAS
JAW 7 121.69 IE 200800000640 20070817 PE 840599 444349 A 20080421 pts/74 840599 E019027 PE 000 1 1 200800000796 1.0000 PE 000 2017-02-06T10:43:59.279-05:00 121.6900 LOT
KPR 1 1400.00 CL 200700000709 20060801 2000.00 EN 1424025 394561 M 20070629 <notty> 1424025 OPER2 20070629 FIP701N1 1424025 OPER2 936.97 PT 1 1 200700000458 1.0000 936.97 RC 2017-02-06T10:43:52.478-05:00 1400.0000 YR
FNS 3 171.56 IW 200200218158 20020131 OE 1229041 13455 A 20020125 0167 1229041 SIMPSONF PE 3 1 200200040297 1.0000 PE 2017-02-06T10:42:57.331-05:00 171.5600 EA
76.16 TLR 4 76.16 OP 201700001042 20160825 76.16 EN 1044032 819048 M 20160815 pts/276 1044031 E077620 20160815 FIP701N1 1044032 E077620 PE 4 1 201700001165 2.0000 PE 2017-02-06T10:44:53.817-05:00 38.0800 BX
JAW 6 27.00 IW 201400001290 20130906 OE 1452122 710981 A 20130822 pts/219 1452122 E037615 PE 6 1 201400001419 25.0000 PE 2017-02-06T10:44:37.999-05:00 1.0800 EA
JAW 8 16.96 IW 200800005378 20080601 OE 756176 449047 A 20080506 pts/10 756176 E037615 PE 8 1 200800005914 1.0000 PE 2017-02-06T10:43:59.95-05:00 16.9600 EA
JAW 8 185.24 IW 201500000730 20140805 OE 1211468 745701 A 20140722 pts/26 1211468 E037615 PE 8 1 201500000758 2.0000 PE 2017-02-06T10:44:43.24-05:00 92.6200 EA
57.60 JAW 1 57.60 OP 200900003601 20090212 60.59 EN 1305011 496904 M 20090209 pts/34 1305011 E037615 20090209 FIP701N1 1305011 E037615 PE 000 1 1 200900003694 1.0000 PE 000 2017-02-06T10:44:06.877-05:00 57.6000 EA
JAW 3 189.35 IW 201500003548 20150225 OE 1303420 762717 A 20150210 pts/43 1303420 E037615 PE 3 1 201500003550 5.0000 PE 2017-02-06T10:44:45.674-05:00 37.8700 EA
KRW 1 8050.00 IW 201400003818 20140212 OE 800232 728567 A 20140220 pts/11 800232 E019027 PE 1 1 201400004077 1.0000 RC 2017-02-06T10:44:40.713-05:00 8050.0000 EA
Powered by BI Documenter