DWStaging
 dbo.FIP_PO_HDR (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
  Properties
Property Value
Name FIP_PO_HDR
Schema dbo
Row Count 120587
Data Size 44304 KB
Index Size 2216 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_DATE_9C
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
 
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
int(10, 0)
False
False
False
 
LOCATION_NUM
varchar(4)
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
 
POSTED_PRD_TR_JRN_TYPE
varchar(15)
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
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_PO_HDR depends on)
Name Type
View
StoredProcedure
  Child Dependencies (objects that depend on dbo.FIP_PO_HDR)
Name Type
STOREDPROCEDURE
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_PO_HDR] Script Date: 03/09/2017 16:45:24 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_PO_HDR](
    [ISN_FIP_PO_HDR] [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,
    [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,
    [POSTED_PRD_TR_JRN_TYPE] [varchar](15) 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 ADD_DATE_9C ADD_PGM ADD_TIME ADD_USER_ID ATTACHMENT_IND 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 LOCATION_NUM 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 POSTED_PRD_TR_JRN_TYPE 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
20011217 79988782 FIP700N1 0945553 SIMPSONF Y AP AD FNS 200.00 5618683585 BARBARA RICCIARDI 5618683137 00201 20011218 BARBARA RICCIARDI RICCIARB@PBCC.CC.FL.US 200.00 EN 2002 DES 2002 00039757 5923724170002 1532062 29133 0000 20011218 FIP700N1 1532062 PGREENE 200.00 CM 30 20011217 U200112CO01152H PE 00217519 PP BARBARA RICCIARDI 2017-02-06T10:53:39.603-05:00 CC 1 CL PALMS WEST CHAMBER OF COMMERCE 02 200.00 B
19990909 80009090 FIP700N1 0920417 DWINDHAM N AP AU DLW R CATHY BURNS 5614398244 00148 20000126 CATHY BURNS 9600.00 EN 2000 DES 2000 00019089 5101860320001 1633410 9024 0000 19990923 FIP700N1 1633409 MMCGANN PE 30 19990909 PE 00199403 PP CATHY BURNS 2017-02-06T10:53:36.062-05:00 CC 1 CA THE WESTERN WIND VOCAL ENSEMBLE 02 9600.00
20110509 79889490 FIP700N1 1012142 E037615 N AP FS JAW 799.00 5618624617 D. ULBRICHT/MARLA 5618624616 00101 20110519 FACILITIES/MARLA TATMANM@PALMBEACHSTATE.EDU 799.00 EN 2011 DES 2011 00005496 0000012710001 1219270 90084 0000 20110711 FIP700N1 1219270 E001609 799.00 CM 30 20110509 U201105CO00724H RC 00005002 PO MARLA L TATMAN 2017-02-06T10:53:50.866-05:00 SC 5 CL BOCA RATON SMALL ENGINES INCORPORATED 02 799.00 B
20120504 79879495 FIP700N1 0926077 E037615 N AP SC JAW 250.00 5612075247 PAT CASTRO 5612075726 00110 20120517 IEES/JAY MATTESON CASTROP@PALMBEACHSTATE.EDU 250.00 EN 2012 DES 2012 00005605 5923662620001 1540504 95785 0000 20120607 FIP700N1 1540504 E003843 250.00 CM 30 20120504 U201205CO00757H RC 00005127 PO PATRICIA A CASTRO/JAY MATTESON 2017-02-06T10:53:51.958-05:00 EC 2 CL BLUE OCEAN PRESS, INC. 02 250.00 B
20010326 79989673 FIP700N1 1203074 DWINDHAM N AP UK01 DLW 650.00 CLAUDE EDWARDS 5614398036 UK001 20010406 FAC. CENTRAL/CLAUDE/ANGIE 650.00 EN 2001 DES Y 2001 00032946 5905435350001 1008051 22361 0000 20010405 FIP700N1 1008051 MTAYLOR 650.00 CM 30 20010326 RC 00211605 PO JOHN WASUKANIS 2017-02-06T10:53:38.371-05:00 CC 1 CL ACOUSTI ENGINEERING CO OF FLORIDA INC. 02 650.00
20041216 79958783 FIP700N1 0916043 E019027 N AP CE KPR 1628.00 5618683538 SONJA WOODARD 5618683824 00100 20041217 INSTITUTE OF TEACHER ED WOODARDS@PBCC.EDU 1628.00 EN 2005 DES 2005 00003815 3415737350005 829406 54199 0000 20050302 FIP700N1 0829406 E000343 Y 1626.67 PT 30 20041216 U200502EN01531H RC 00003306 PO SUSAN CALDWELL 2017-02-06T10:53:44.19-05:00 1 CL OFFICEMAX, INC. 02 1600.00 B
20140206 79859793 FIP700N1 0939589 E037615 N AP AU JAW 662.00 5612075904 NANCY DENHOLM 5612075905 00102 20140210 NANCY DENHOLM DENHOLMN@PALMBEACHSTATE.EDU 662.00 EN 2014 DES 2014 00003940 6500952750001 1607178 102943 0000 20140206 FIP700N1 1607178 E003843 Y 662.00 CM 30 20140206 U201402CO00754H RC 00003611 PO NANCY K DENHOLM 2017-02-06T10:53:53.191-05:00 PY 2 CL KAUFMAN-DAENZER INSTRUMENTS 02 662.00 B
20020730 79979269 FIP700N1 1008216 SIMPSONF N AP STR FNS 100.08 561 BILL CASE 5612075620 001061 20020731 FACILITIES 100.08 EN 2003 DES 2003 00000807 8412487160002 925286 34726 0000 20020827 FIP700N1 0925286 NGREENE Y 100.08 CM 30 20020730 U200207CO02173H RC 00222040 PO VICKI OLECK 2017-02-06T10:53:40.695-05:00 EC 2 CL D/B/A CORPORATE EXPRESS OFFICE SUPPLIES 02 100.08 B
20130916 79869083 FIP700N1 0955363 E037615 N AP SC JAW 1119.85 5612075405 RENE' L. MILICI 5612075417 00134 S/C 425-001-12-1 20130930 BIOSCIENCE FACULTY MILICIR@PALMBEACHSTATE.EDU 1119.85 EN 2014 DES 2014 00001895 0000036010001 1318332 103856 0000 20131127 FIP700N1 1318332 E003843 1119.85 CM 30 20130916 U201309CO01684H RC 00001711 PO RENE L MILICI/VAN DER VELDE/BIOSCIENCE 2017-02-06T10:53:53.347-05:00 EC 2 CL WORKSCAPES INC - FT. LAUDERDALE 02 1119.85 B
19980930 80019069 FIP700N1 1617459 DWINDHAM N AP 19990630 UK01 DLW 700.00 N 182347 5614398275 UK001 19990630 182347 EN 1999 DES 1999 00010070 6504506550001 924080 319 0000 19990209 FIP700N1 0924080 MMCGANN PE 30 PE 00182347 BO 182347 2017-02-06T10:53:34.549-05:00 CC 1 CA DAVIES CAULKING & WATERPROOFING 02 700.00
Powered by BI Documenter