DWStaging
 dbo.FIP_VENDOR_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_VENDOR_LOG_A
  Properties
Property Value
Name FIP_VENDOR_LOG_A
Schema dbo
Row Count 156360
Data Size 24968 KB
Index Size 2752 KB
Create Date 2/18/2014 11:14 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCT_NBR
varchar(25)
True
False
False
 
ADDRESS_1099_IND
varchar(1)
True
False
False
 
ALLOW_WEB_PROFILE
varchar(1)
True
False
False
 
CERTIFIED_MINORITY_IND
varchar(1)
True
False
False
 
COLLEGE_ASSOCIATION
varchar(1)
True
False
False
 
DB_DUNS_NBR
varchar(9)
True
False
False
 
EDI_CAPABLE
varchar(1)
True
False
False
 
EFT_BANK_ACCT
varchar(20)
True
False
False
 
EFT_BANK_ACCT_TYPE
varchar(1)
True
False
False
 
EFT_BANK_CODE
varchar(9)
True
False
False
 
EFT_FLAG
varchar(1)
True
False
False
 
EFT_TEST_FLAG
varchar(1)
True
False
False
 
EXEMPT_FATCA
varchar(2)
True
False
False
 
EXEMPT_PAYEE_CODE
varchar(2)
True
False
False
 
FLAG_1099
varchar(1)
True
False
False
 
FOB_TERMS
varchar(3)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_PAYMENT
varchar(1)
True
False
False
 
ISN_FIP_VENDOR_LOG_A
int(10, 0)
False
False
False
 
KEEP_VENDOR_FLAG
varchar(1)
True
False
False
 
LAST_ACTIVITY_DATE
varchar(8)
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
 
NOTE_IND
varchar(1)
True
False
False
 
ONLINE_CATALOG_EXIST
varchar(1)
True
False
False
 
PAYMENT_TERMS
varchar(2)
True
False
False
 
PREV_PCARD_YTD_TOTAL
numeric(12, 2)
True
False
False
 
PREV_YTD_TOTAL
numeric(12, 2)
True
False
False
 
PREVIOUS_YTD_PAID
numeric(13, 2)
True
False
False
 
PUBLIC_TRADE_CORP_FLAG
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
TAX_ID
varchar(9)
True
False
False
 
TERM_DATE
varchar(8)
True
False
False
 
VA_ACTIVE_ADDRESS_IND
varchar(1)
True
False
False
 
VA_ADDRESS_TYPE
varchar(1)
True
False
False
 
VA_CITY
varchar(40)
True
False
False
 
VA_COUNTRY
varchar(3)
True
False
False
 
VA_INTERNET_ADDRESS
varchar(40)
True
False
False
 
VA_MAILING_ADDRESS_NAME
varchar(40)
True
False
False
 
VA_STATE
varchar(2)
True
False
False
 
VA_VENDOR_CODE
varchar(9)
True
False
False
 
VA_VENDOR_SEQ_NBR
int(10, 0)
True
False
False
 
VA_ZIP
varchar(11)
True
False
False
 
VC_COMMODITY_CODE
varchar(13)
True
False
False
 
VC_VENDOR
varchar(9)
True
False
False
 
VENDOR_ASSIGNED_ACCOUNT
varchar(20)
True
False
False
 
VENDOR_CODE
varchar(9)
True
False
False
 
VENDOR_EMAIL_ADDRESS
varchar(40)
True
False
False
 
VENDOR_NAME
varchar(40)
True
False
False
 
VENDOR_STATUS
varchar(1)
True
False
False
 
VENDOR_TYPE
varchar(1)
True
False
False
 
WEB_ADDRESS
varchar(40)
True
False
False
 
WEB_VENDOR_ID
varchar(9)
True
False
False
 
WITHHOLD_IND
varchar(1)
True
False
False
 
YTD_PAID
numeric(13, 2)
True
False
False
 
YTD_PCARD_TOTAL
numeric(12, 2)
True
False
False
 
YTD_TOTAL
numeric(12, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_VENDOR_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_VENDOR_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_VENDOR_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_VENDOR_LOG_A] Script Date: 03/09/2017 16:45:31 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_VENDOR_LOG_A](
    [ISN_FIP_VENDOR_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,
    [VENDOR_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FLAG_1099] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [KEEP_VENDOR_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_ACTIVITY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAX_ID] [varchar](9) 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,
    [NOTE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_PAYMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [YTD_TOTAL] [numeric](12, 2) NULL,
    [VENDOR_ASSIGNED_ACCOUNT] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_VENDOR_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_VENDOR_SEQ_NBR] [int] NULL,
    [VA_ADDRESS_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_MAILING_ADDRESS_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_CITY] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_ZIP] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_INTERNET_ADDRESS] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VA_ACTIVE_ADDRESS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_VENDOR] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VC_COMMODITY_CODE] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCT_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_YTD_TOTAL] [numeric](12, 2) NULL,
    [PUBLIC_TRADE_CORP_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_BANK_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_BANK_ACCT] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_TEST_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [YTD_PAID] [numeric](13, 2) NULL,
    [PREVIOUS_YTD_PAID] [numeric](13, 2) NULL,
    [CERTIFIED_MINORITY_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDRESS_1099_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_BANK_ACCT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [YTD_PCARD_TOTAL] [numeric](12, 2) NULL,
    [PREV_PCARD_YTD_TOTAL] [numeric](12, 2) NULL,
    [WEB_ADDRESS] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_EMAIL_ADDRESS] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WEB_VENDOR_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALLOW_WEB_PROFILE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DB_DUNS_NBR] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ONLINE_CATALOG_EXIST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EDI_CAPABLE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLEGE_ASSOCIATION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WITHHOLD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXEMPT_PAYEE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXEMPT_FATCA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCT_NBR ADDRESS_1099_IND ALLOW_WEB_PROFILE CERTIFIED_MINORITY_IND COLLEGE_ASSOCIATION DB_DUNS_NBR EDI_CAPABLE EFT_BANK_ACCT EFT_BANK_ACCT_TYPE EFT_BANK_CODE EFT_FLAG EFT_TEST_FLAG EXEMPT_FATCA EXEMPT_PAYEE_CODE FLAG_1099 FOB_TERMS HOLD HOLD_PAYMENT ISN_FIP_VENDOR_LOG_A KEEP_VENDOR_FLAG LAST_ACTIVITY_DATE LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NOTE_IND ONLINE_CATALOG_EXIST PAYMENT_TERMS PREV_YTD_TOTAL PUBLIC_TRADE_CORP_FLAG RowUpdatedOn TAX_ID TERM_DATE VA_ACTIVE_ADDRESS_IND VA_ADDRESS_TYPE VA_CITY VA_COUNTRY VA_INTERNET_ADDRESS VA_MAILING_ADDRESS_NAME VA_STATE VA_VENDOR_CODE VA_VENDOR_SEQ_NBR VA_ZIP VC_COMMODITY_CODE VC_VENDOR VENDOR_ASSIGNED_ACCOUNT VENDOR_CODE VENDOR_EMAIL_ADDRESS VENDOR_NAME VENDOR_STATUS VENDOR_TYPE WEB_ADDRESS WEB_VENDOR_ID WITHHOLD_IND YTD_PAID YTD_TOTAL
N 801214 89239 Y A 20090924 pts/8 801214 E019027 30 2017-02-06T10:48:12.672-05:00 592693659 000000691 EXECUTIVE ELECTRIC, INC. A E
N N 1659363 25941 Y M 20040216 0104 1659363 E010125 20040216 FIP001N1 1659363 E010125 30 2017-02-06T10:48:01.175-05:00 432031718 432031718 SEMA MAGAZINE, INC. A E
1545496 41113 M 20050706 0259 1545496 E028685 20050706 FIP005N1 1545496 E028685 2017-02-06T10:48:03.983-05:00 A B WEST PALM BEACH US WOLL FL 742722883 3 33407
N 907060 89101 Y 20090918 M 20090921 pts/96 907060 E003651 20090921 FIP001N1 0907060 E003651 30 79806.83 Y 2017-02-06T10:48:12.641-05:00 205021902 000000238 GENERAL SUPPLY & SERVICES, INC. D/B/A A E 56314.00
N 1051493 48315 Y M 20060331 0105 1051493 E010125 20060331 FIP001N1 1051493 E010125 PP 2017-02-06T10:48:05.309-05:00 T00000915 T00000915 ADA/DPG 50 A M
N 1606293 17933 Y 20030529 M 20030603 0079 1606293 E010125 20030603 FIP001N1 1606293 E010125 Y 30 122424.12 2017-02-06T10:47:59.693-05:00 591644139 1402500 591644139 CENTRAL AUDIO VISUAL, INC. I E 91648.89
Y 1315542 148843 Y M 20150224 pts/41 1315542 E037615 20150224 FIP001N1 1315542 E037615 PP 2017-02-06T10:48:23.233-05:00 753259645 000004596 ST. PETERSBURG/CLEARWATER AIRPORT ASSOC. A A
Y 1429427 131172 Y 20111212 M 20120119 pts/66 1429427 E037615 20120119 FIP001N1 1429427 E037615 30 9635.40 2017-02-06T10:48:20.238-05:00 030426916 PAL002 030426916 CARAS LLC A E 2369.86
N 1003146 131705 Y 20111026 M 20120131 pts/22 1003146 E019027 20120131 FIP001N1 1003146 E019027 00 2017-02-06T10:48:20.316-05:00 593668188 000000497 MGC FT. PIERCE CORPORATION D/B/A A E 140.00
1311498 24201 M 20031209 0183 1311498 E010125 20031209 FIP005N1 1311498 E010125 2017-02-06T10:48:00.878-05:00 A B DALLAS US D/B/A/ CHEERLEADER & DANZTEAM TX 752737680 1 753910711 2002.05
Powered by BI Documenter