DWStaging
 dbo.FIP_PO_HDR_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_HDR_VIEW_LOG_A
  Properties
Property Value
Name FIP_PO_HDR_VIEW_LOG_A
Schema dbo
Row Count 1745178
Data Size 609928 KB
Index Size 26064 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_9C
varchar(8)
True
False
False
 
ATTACHMENT_IND
varchar(1)
True
False
False
 
BALANCE_TOT_AMT
numeric(17, 2)
True
False
False
 
BID_DATE
varchar(8)
True
False
False
 
BID_NBR
varchar(10)
True
False
False
 
BILL_TO_ADDR_CODE
varchar(2)
True
False
False
 
BLANKET_BEGIN_DATE
varchar(8)
True
False
False
 
BLANKET_END_DATE
varchar(8)
True
False
False
 
BLANKET_MAX_AMT
numeric(17, 2)
True
False
False
 
BOARD_DATE
varchar(8)
True
False
False
 
BUILDING
varchar(4)
True
False
False
 
BUYER_ID
varchar(3)
True
False
False
 
CALC_TOT_AMT
numeric(17, 2)
True
False
False
 
CANCELLED_ACTION_CODE
varchar(2)
True
False
False
 
CONTACT_FAX_NBR
varchar(10)
True
False
False
 
CONTACT_NAME
varchar(40)
True
False
False
 
CONTACT_PHONE
varchar(15)
True
False
False
 
CONTACT_ROOM
varchar(6)
True
False
False
 
CONTRACT_NBR
varchar(16)
True
False
False
 
DELIVER_DATE
varchar(8)
True
False
False
 
DELIVER_TO_NAME
varchar(40)
True
False
False
 
E_MAIL_ID
varchar(40)
True
False
False
 
ENC_TOT_AMT
numeric(17, 2)
True
False
False
 
FIN_STATUS
varchar(2)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
FOB_TERMS
varchar(3)
True
False
False
 
FREIGHT_AMT
numeric(17, 2)
True
False
False
 
FREIGHT_ITM_NBR
int(10, 0)
True
False
False
 
FREIGHT_PRE_PAY_ADD
varchar(1)
True
False
False
 
FROM_PRQ_FISCAL_YEAR
varchar(4)
True
False
False
 
FROM_PRQ_REF_NBR
varchar(8)
True
False
False
 
GL_TOT_ADJUST_AMT
numeric(17, 2)
True
False
False
 
HDR_VENDOR_ADDR
varchar(13)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_PO_HDR_VIEW_LOG_A
int(10, 0)
False
False
False
 
LOCATION_NUM
varchar(4)
True
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
 
MULTIPLE_PRQ_IND
varchar(1)
True
False
False
 
NOTES_FOR_BUYER
varchar(1)
True
False
False
 
NOTES_FOR_VENDOR
varchar(1)
True
False
False
 
PAID_TOT_AMT
numeric(17, 2)
True
False
False
 
PAY_STATUS
varchar(2)
True
False
False
 
PAYMENT_TERMS
varchar(2)
True
False
False
 
PO_PRINT_DATE
varchar(8)
True
False
False
 
PO_SIG_CODE
varchar(2)
True
False
False
 
PREV_PO_REF_INFO
varchar(12)
True
False
False
 
PROJECT_NBR
varchar(12)
True
False
False
 
QUOTE_INDICATOR
varchar(1)
True
False
False
 
REC_STATUS
varchar(2)
True
False
False
 
REF_NBR
varchar(8)
True
False
False
 
REF_TYPE
varchar(2)
True
False
False
 
REQUESTOR_NAME
varchar(40)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SHIP_TO_CODE
varchar(2)
True
False
False
 
SITE_LOCAL_NUM
varchar(1)
True
False
False
 
STATUS
varchar(2)
True
False
False
 
SUGGESTED_VENDOR
varchar(40)
True
False
False
 
TOLERANCE_FLAG
varchar(2)
True
False
False
 
TOTAL_AMT_ACCRUED
numeric(17, 2)
True
False
False
 
TOTAL_ORG_PO_AMT
numeric(17, 2)
True
False
False
 
VENDOR_ADDR_TYPE
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_PO_HDR_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_HDR_VIEW_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_PO_HDR_VIEW_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_PO_HDR_VIEW_LOG_A] Script Date: 03/09/2017 16:45:25 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_PO_HDR_VIEW_LOG_A](
    [ISN_FIP_PO_HDR_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,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NBR] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_DATE_9C] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTOR_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DELIVER_TO_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [E_MAIL_ID] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_PHONE] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_ROOM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUILDING] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SHIP_TO_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_ID] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUGGESTED_VENDOR] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HDR_VENDOR_ADDR] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DELIVER_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CANCELLED_ACTION_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIN_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,
    [FROM_PRQ_FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FROM_PRQ_REF_NBR] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MULTIPLE_PRQ_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTES_FOR_VENDOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTES_FOR_BUYER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTACHMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TERMS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOB_TERMS] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOLERANCE_FLAG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PO_PRINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_NBR] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROJECT_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOARD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BID_NBR] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BID_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BLANKET_BEGIN_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BLANKET_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BLANKET_MAX_AMT] [numeric](17, 2) NULL,
    [TOTAL_ORG_PO_AMT] [numeric](17, 2) NULL,
    [CALC_TOT_AMT] [numeric](17, 2) NULL,
    [FREIGHT_AMT] [numeric](17, 2) NULL,
    [FREIGHT_PRE_PAY_ADD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FREIGHT_ITM_NBR] [int] NULL,
    [SITE_LOCAL_NUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCATION_NUM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_TO_ADDR_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_PO_REF_INFO] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_ADDR_TYPE] [varchar](1) 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,
    [GL_TOT_ADJUST_AMT] [numeric](17, 2) NULL,
    [TOTAL_AMT_ACCRUED] [numeric](17, 2) NULL,
    [PO_SIG_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_FAX_NBR] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QUOTE_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE_9C ATTACHMENT_IND BALANCE_TOT_AMT BID_DATE BID_NBR BILL_TO_ADDR_CODE BLANKET_BEGIN_DATE BLANKET_END_DATE BOARD_DATE BUILDING BUYER_ID CALC_TOT_AMT CANCELLED_ACTION_CODE CONTACT_FAX_NBR CONTACT_NAME CONTACT_PHONE CONTACT_ROOM CONTRACT_NBR DELIVER_DATE DELIVER_TO_NAME E_MAIL_ID ENC_TOT_AMT FIN_STATUS FISCAL_YEAR FOB_TERMS FREIGHT_PRE_PAY_ADD FROM_PRQ_FISCAL_YEAR FROM_PRQ_REF_NBR HDR_VENDOR_ADDR HOLD ISN_FIP_PO_HDR_VIEW_LOG_A LOCATION_NUM LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MULTIPLE_PRQ_IND NOTES_FOR_BUYER NOTES_FOR_VENDOR PAID_TOT_AMT PAY_STATUS PAYMENT_TERMS PO_PRINT_DATE PO_SIG_CODE PREV_PO_REF_INFO PROJECT_NBR QUOTE_INDICATOR REC_STATUS REF_NBR REF_TYPE REQUESTOR_NAME RowUpdatedOn SHIP_TO_CODE SITE_LOCAL_NUM STATUS SUGGESTED_VENDOR TOLERANCE_FLAG TOTAL_ORG_PO_AMT VENDOR_ADDR_TYPE
79908896 N 60.00 AP ETA JAW 60.00 5618683628 LASHONDA JOHNSON 5618683767 00132 20091105 TRADE & INDUSTRY JOHNSONL@PBCC.EDU 60.00 EN 2010 DES Y 2010 00002792 5912160000002 1137189 1045971 0000 M 20091103 pts/64 1137189 E037615 20091103 FIP700N1 1137189 E037615 PE 30 20091103 PE 00002632 CS SALVATORE MANUELE/T&I/KATHLEEN HOROWITZ 2017-02-06T10:21:34.395-05:00 CC 1 OP PALM BEACH COMMUNITY COLLEGE - STORES 02 60.00 B
79909090 N 108.44 AP SS JAW 437.76 561 MARILEIDY GUZMAN 5618683326 00100 COSD #529497 20090920 SOCIAL SCIENCE GUZMANM@PBCC.EDU 437.76 EN 2010 DES 2010 00001719 0433908160001 1450538 1030405 0000 M 20090918 pts/201 1450538 E032885 20090918 FIP700N1 1450538 E032885 Y 329.32 PT 30 RC 00001553 PO MARILEIDY GUZMAN 2017-02-06T10:21:31.665-05:00 CC 1 OP STAPLES ADVANTAGE 02 437.76 B
79849181 N 904.08 AP SC JAW 904.08 561 SUE HUTZ 5612075077 00229 #490-000-12-ACS 20150905 SCIENCE/ SUE HUTZ 904.08 EN 2016 DES 2016 00001314 2329427370007 1526554 1630415 0000 M 20150818 pts/6 1526554 E037615 20150818 FIP700N1 1526554 E037615 Y PE 30 PE 00001169 PO SUSAN HUTZ 2017-02-06T10:23:20.569-05:00 EC 2 OP FISHER SCIENTIFIC COMPANY LLC 02 904.08 B
79869576 N 35.00 AP AD JAW 35.00 561 BERYL MANCUSO 5618683455 00201 20130425 VPBS MANCUSOB@PALMBEACHSTATE.EDU 35.00 EN 2013 DES 2013 00005260 CAFE888880001 1551291 1397998 0000 M 20130423 pts/31 1551290 E037615 20130423 FIP700N1 1551291 E037615 PE 30 20130423 PE 00005016 PO BERYL A MANCUSO 2017-02-06T10:22:36.936-05:00 PY 1 OP COLLEGE CAFE 02 35.00 B
79919276 N 15623.47 AP 20080701 20090630 CT KRW 132040.50 N 5618683047 FERN DEVERY-DUZ 5618683371 00108 20080715 DISABILITY SUPPORT SERV.` DEVERYF@PBCC.EDU 146078.47 EN 2009 DES 2009 00000234 6507695840001 852161 989645 0000 M 20090512 pts/12 852161 E019027 20090512 FIP700N1 0852161 E019027 116417.03 PT 30 20080723 RC 00000505 SC SUSAN LANG 2017-02-06T10:21:24.504-05:00 CC 1 OP NATIONWIDE INTERPRETER RESOURCE, INC. 02 24999.99 B
79949592 N 275.00 AP FC FNS 561 CHRIS WARD 5618683479 00123 20050422 CENTRAL FACILITIES OE 2005 DES 2005 00005684 5915215130001 815572 3607 0000 A 20050407 0172 815572 E010125 Y PE 30 PE 00005097 PO LINDA J LEWIS 2017-02-06T10:18:26.46-05:00 CC 1 IW ABC CUTTING CONTRACTORS INC. 02 B
79979288 N 545.68 AP 20030615 FD FNS 2500.00 5618683478 RICK DUGAN 5618683477 00100 20020722 DISTRICT FACILITIES/CATHY 2500.00 EN 2003 DES 2003 00000174 3635495970001 1050441 174580 0000 M 20021213 0028 1050440 MTAYLOR 20021213 FIP700N1 1050440 MTAYLOR 1954.32 PT 30 20020711 RC 00221384 BO CATHY DANDREA 2017-02-06T10:18:57.801-05:00 CC 1 OP ADI 02 2500.00 B
79839188 N 120.00 AP CB TLR 1000.00 5618624729 ELKE D SCHMIDT 5618624728 00103 20160815 SUMMER YOUTH COLLEGE SCHMIDTE@PALMBEACHSTATE.EDU 1000.00 EN 2017 DES 2017 00001132 6503855070004 1608027 1720351 0000 M 20160815 pts/238 1608026 E057673 20160815 FIP700N1 1608027 E057673 880.00 PT 30 20160811 RC 00001040 PO ELKE D SCHMIDT 2017-02-06T10:23:37.261-05:00 PY 5 OP FAU - 229 UNIVERSITY CENTER 02 1000.00 B
79928997 N AP SCA JAW 23896.00 5618683141 CYNTHIA TRAGER 5618683070 001012 20071005 UPWARD BOUND TRAGERC@PBCC.EDU 23896.00 EN 2008 DES 2008 00001238 2237186030001 826505 803891 0000 M 20071003 pts/19 826505 E001609 20071003 FIP700N1 0826505 E001609 Y 23896.00 CM 30 20071002 RC 00001692 PO CYNTHIA L TRAGER 2017-02-06T10:20:51.884-05:00 CC 1 CL ALL ABOARD TOURS & TRAVEL LLC 02 23896.00 B
79899284 N 300.00 AP 20110630 AD JAW 300.00 5612075405 SUE LEVINE 5612075401 00205 MA-IS-42595-16 20100715 PROVOST'S OFFICE LEVINES@PALMBEACHSTATE.EDU 300.00 EN 2011 DES 2011 00000011 OFFCDEPOT0001 758321 1115426 0000 M 20100715 pts/10 758321 E037615 20100715 FIP700N1 0758321 E037615 PE 30 RC 00000186 OS SUE R LEVINE 2017-02-06T10:21:46.547-05:00 EC 2 OP OFFICE DEPOT 02 300.00 B
Powered by BI Documenter