DWStaging
 dbo.FIP_TABLES (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_TABLES
  Properties
Property Value
Name FIP_TABLES
Schema dbo
Row Count 712
Data Size 72 KB
Index Size 48 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
 
ADDRESS_TYPE_CODE
varchar(1)
True
False
False
 
ADDRESS_TYPE_DESC
varchar(15)
True
False
False
 
BCC_CATEGORY
varchar(4)
True
False
False
 
BCC_ID
varchar(3)
True
False
False
 
BILL_TO_ADDR_CODE
varchar(2)
True
False
False
 
BUYER_AUTHORIZATION_LIMIT
numeric(17, 2)
True
False
False
 
BUYER_BUILDING
varchar(25)
True
False
False
 
BUYER_FAX
varchar(15)
True
False
False
 
BUYER_ID
varchar(3)
True
False
False
 
BUYER_INTERNET_ADDRESS
varchar(40)
True
False
False
 
BUYER_NAME
varchar(25)
True
False
False
 
BUYER_PHONE
varchar(15)
True
False
False
 
BUYER_ROOM_NBR
varchar(5)
True
False
False
 
CAT_CODE
varchar(4)
True
False
False
 
CAT_DESCRIPTION
varchar(25)
True
False
False
 
DISC_CODE
varchar(3)
True
False
False
 
DISC_DESC
numeric(17, 2)
True
False
False
 
DOC_TYPE
varchar(2)
True
False
False
 
EMAIL_ACTION
varchar(8)
True
False
False
 
EXCLUDE_ALL
varchar(1)
True
False
False
 
FED_TAX_DESC
varchar(30)
True
False
False
 
FED_TAX_ID
varchar(9)
True
False
False
 
FOB_TERMS_CODE
varchar(3)
True
False
False
 
FOB_TERMS_DESC
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_TABLES
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
 
MINORITY_CODE
varchar(3)
True
False
False
 
MINORITY_CODE_DESC
varchar(25)
True
False
False
 
PAYMENT_TERMS_CODE
varchar(2)
True
False
False
 
PAYMENT_TERMS_DESC
varchar(25)
True
False
False
 
PO_CLAUSE_CODE
varchar(1)
True
False
False
 
PO_TOLERANCE_AMOUNT
numeric(17, 2)
True
False
False
 
PO_TOLERANCE_CODE
varchar(2)
True
False
False
 
PO_TOLERANCE_PERCENT
numeric(17, 3)
True
False
False
 
PURCH_AGENT_CODE
varchar(1)
True
False
False
 
PURCH_AGENT_TITLE
varchar(40)
True
False
False
 
PURCH_STA_ACT_CODE
varchar(2)
True
False
False
 
PURCH_STA_ACT_DESC
varchar(20)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SALES_TAX_EXEMPT_CODE
varchar(14)
True
False
False
 
SALES_TAX_EXEMPT_DESC
varchar(30)
True
False
False
 
SHIP_TO_ADDRESS_CODE
varchar(2)
True
False
False
 
STATUS_CODE
varchar(2)
True
False
False
 
STATUS_DESC
varchar(15)
True
False
False
 
TABLE_BROWSE_PGM
varchar(8)
True
False
False
 
TABLE_DESC
varchar(200)
True
False
False
 
TABLE_MAINT_PGM
varchar(8)
True
False
False
 
TABLE_MENU_NAME
varchar(45)
True
False
False
 
TABLE_PRINT_PGM
varchar(8)
True
False
False
 
TABLE_STATUS
varchar(1)
True
False
False
 
UNIT_MEAS_CODE
varchar(6)
True
False
False
 
UNIT_MEAS_DESC
varchar(25)
True
False
False
 
VENDOR_TYPE_CODE
varchar(1)
True
False
False
 
VENDOR_TYPE_DESC
varchar(15)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_TABLES
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_TABLES depends on)
Name Type
View
View
  Child Dependencies (objects that depend on dbo.FIP_TABLES)
Name Type
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_TABLES] Script Date: 03/09/2017 16:45:29 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_TABLES](
    [ISN_FIP_TABLES] [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,
    [TABLE_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_BROWSE_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_PRINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_MENU_NAME] [varchar](45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNIT_MEAS_CODE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNIT_MEAS_DESC] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MINORITY_CODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MINORITY_CODE_DESC] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_TYPE_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_TYPE_DESC] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDRESS_TYPE_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDRESS_TYPE_DESC] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TERMS_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TERMS_DESC] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOB_TERMS_CODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOB_TERMS_DESC] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SHIP_TO_ADDRESS_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_ID] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_PHONE] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_FAX] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_INTERNET_ADDRESS] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_BUILDING] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_ROOM_NBR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BCC_ID] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BCC_CATEGORY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAT_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAT_DESCRIPTION] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_DESC] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISC_CODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISC_DESC] [numeric](17, 2) NULL,
    [PURCH_STA_ACT_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PURCH_STA_ACT_DESC] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_TO_ADDR_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALES_TAX_EXEMPT_CODE] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALES_TAX_EXEMPT_DESC] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FED_TAX_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FED_TAX_DESC] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PURCH_AGENT_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PURCH_AGENT_TITLE] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PO_TOLERANCE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PO_TOLERANCE_AMOUNT] [numeric](17, 2) NULL,
    [PO_TOLERANCE_PERCENT] [numeric](17, 3) NULL,
    [TABLE_DESC] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PO_CLAUSE_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_AUTHORIZATION_LIMIT] [numeric](17, 2) NULL,
    [EMAIL_ACTION] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DOC_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXCLUDE_ALL] [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_PGM ADD_TIME ADD_USER_ID ADDRESS_TYPE_CODE ADDRESS_TYPE_DESC BCC_CATEGORY BCC_ID BILL_TO_ADDR_CODE BUYER_BUILDING BUYER_FAX BUYER_ID BUYER_INTERNET_ADDRESS BUYER_NAME BUYER_PHONE BUYER_ROOM_NBR CAT_CODE CAT_DESCRIPTION DISC_CODE DOC_TYPE EMAIL_ACTION EXCLUDE_ALL FED_TAX_DESC FED_TAX_ID FOB_TERMS_CODE FOB_TERMS_DESC HOLD ISN_FIP_TABLES MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MINORITY_CODE MINORITY_CODE_DESC PAYMENT_TERMS_CODE PAYMENT_TERMS_DESC PO_CLAUSE_CODE PO_TOLERANCE_CODE PURCH_AGENT_CODE PURCH_AGENT_TITLE PURCH_STA_ACT_CODE PURCH_STA_ACT_DESC RowUpdatedOn SALES_TAX_EXEMPT_CODE SALES_TAX_EXEMPT_DESC SHIP_TO_ADDRESS_CODE STATUS_CODE STATUS_DESC TABLE_BROWSE_PGM TABLE_DESC TABLE_MAINT_PGM TABLE_MENU_NAME TABLE_PRINT_PGM TABLE_STATUS UNIT_MEAS_CODE UNIT_MEAS_DESC VENDOR_TYPE_CODE VENDOR_TYPE_DESC
20130529 FIP181N1 0839268 E019027 537 2017-02-06T11:27:40.798-05:00 RO A
19950923 FIP910N1 1053510 ZSSJL 7 66 19951130 FIP910N1 1942103 ZMEAL 2017-02-06T11:27:40.736-05:00 PR PURCH REQ
20081208 FIP181N1 1023065 E037615 407 20160105 FIP181N1 1056308 E019027 2017-02-06T11:27:40.767-05:00 BB A
19950620 FIP174N1 1228535 ZMEAL P PAY ADDRESS 2 5 0 2017-02-06T11:27:40.736-05:00 A
20050505 FIP192N1 1316565 E019027 CA 1437020 598 20131217 FIP192N1 1437020 E019027 2017-02-06T11:27:40.798-05:00 A
19971022 FIP187N1 1625290 DIMAIO 1625290 264 2017-02-06T11:27:40.751-05:00 A
20081112 FIP181N1 0935353 E019027 534 20120717 FIP181N1 0940004 E019027 2017-02-06T11:27:40.798-05:00 RK A
19971023 FIP178N1 1024569 MCCOLLUM 1024569 55 2017-02-06T11:27:40.736-05:00 A
19991215 FIP171N1 1637376 REYNOLDS 1637376 177 2017-02-06T11:27:40.751-05:00 A DAYS DAYS
20120411 FIP181N1 1010231 WINDHAM 1010231 382 2017-02-06T11:27:40.767-05:00 CA A
Powered by BI Documenter