DWStaging
 dbo.FIP_CO_HDR_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_CO_HDR_A
  Properties
Property Value
Name FIP_CO_HDR_A
Schema dbo
Row Count 44901
Data Size 7504 KB
Index Size 696 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
ACCRUAL_TOT_AMT
numeric(17, 2)
True
False
False
 
ACCRUAL_TOT_AMT_B
numeric(17, 2)
True
False
False
 
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
 
BALANCE_TOT_AMT
numeric(17, 2)
True
False
False
 
BALANCE_TOT_AMT_B
numeric(17, 2)
True
False
False
 
BID_DATE
varchar(8)
True
False
False
 
BID_DATE_B
varchar(8)
True
False
False
 
BID_NBR
varchar(10)
True
False
False
 
BID_NBR_B
varchar(10)
True
False
False
 
BILL_TO_ADDR_CODE
varchar(2)
True
False
False
 
BILL_TO_ADDR_CODE_B
varchar(2)
True
False
False
 
BLANKET_BEGIN_DATE
varchar(8)
True
False
False
 
BLANKET_BEGIN_DATE_B
varchar(8)
True
False
False
 
BLANKET_END_DATE
varchar(8)
True
False
False
 
BLANKET_END_DATE_B
varchar(8)
True
False
False
 
BLANKET_MAX_AMT
numeric(17, 2)
True
False
False
 
BLANKET_MAX_AMT_B
numeric(17, 2)
True
False
False
 
BOARD_DATE
varchar(8)
True
False
False
 
BOARD_DATE_B
varchar(8)
True
False
False
 
BUYER_ID
varchar(3)
True
False
False
 
BUYER_ID_B
varchar(3)
True
False
False
 
CALC_TOT_AMT
numeric(17, 2)
True
False
False
 
CALC_TOT_AMT_B
numeric(17, 2)
True
False
False
 
CANCELLED_ACTION_CODE
varchar(2)
True
False
False
 
CANCELLED_ACTION_CODE_B
varchar(2)
True
False
False
 
CHG_ORD_NBR
int(10, 0)
True
False
False
 
CHG_ORD_NEEDS_PRINTED_IND
varchar(1)
True
False
False
 
CHG_ORD_NOTE_IND
varchar(1)
True
False
False
 
CHG_ORD_PRINT_DATE
varchar(8)
True
False
False
 
CONTRACT_NBR
varchar(16)
True
False
False
 
CONTRACT_NBR_B
varchar(16)
True
False
False
 
DELIVER_DATE
varchar(8)
True
False
False
 
DELIVER_DATE_B
varchar(8)
True
False
False
 
ENC_TOT_AMT
numeric(17, 2)
True
False
False
 
ENC_TOT_AMT_B
numeric(17, 2)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
FOB_TERMS
varchar(3)
True
False
False
 
FOB_TERMS_B
varchar(3)
True
False
False
 
FREIGHT_AMT
numeric(17, 2)
True
False
False
 
FREIGHT_AMT_B
numeric(17, 2)
True
False
False
 
FREIGHT_ITM_NBR
int(10, 0)
True
False
False
 
FREIGHT_ITM_NBR_B
int(10, 0)
True
False
False
 
FREIGHT_PRE_PAY_ADD
varchar(1)
True
False
False
 
FREIGHT_PRE_PAY_ADD_B
varchar(1)
True
False
False
 
GL_TOT_ADJUST_AMT
numeric(17, 2)
True
False
False
 
GL_TOT_ADJUST_AMT_B
numeric(17, 2)
True
False
False
 
HDR_VENDOR_ADDR
varchar(13)
True
False
False
 
HDR_VENDOR_ADDR_B
varchar(13)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_CO_HDR_A
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
 
PAID_TOT_AMT
numeric(17, 2)
True
False
False
 
PAID_TOT_AMT_B
numeric(17, 2)
True
False
False
 
PAYMENT_TERMS
varchar(2)
True
False
False
 
PAYMENT_TERMS_B
varchar(2)
True
False
False
 
PO_PRINT_DATE
varchar(8)
True
False
False
 
PO_PRINT_DATE_B
varchar(8)
True
False
False
 
PROJECT_NBR
varchar(12)
True
False
False
 
PROJECT_NBR_B
varchar(12)
True
False
False
 
REC_STATUS
varchar(2)
True
False
False
 
REC_STATUS_B
varchar(2)
True
False
False
 
REF_NBR
varchar(8)
True
False
False
 
REF_TYPE
varchar(2)
True
False
False
 
REF_TYPE_B
varchar(2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SHIP_TO_CODE
varchar(2)
True
False
False
 
SHIP_TO_CODE_B
varchar(2)
True
False
False
 
STATUS
varchar(2)
True
False
False
 
STATUS_B
varchar(2)
True
False
False
 
SUGGESTED_VENDOR
varchar(40)
True
False
False
 
SUGGESTED_VENDOR_B
varchar(40)
True
False
False
 
TOLERANCE_FLAG
varchar(2)
True
False
False
 
TOLERANCE_FLAG_B
varchar(2)
True
False
False
 
TRANSACTION_STATUS
varchar(2)
True
False
False
 
TRANSACTION_STATUS_B
varchar(2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_CO_HDR_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_CO_HDR_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.FIP_CO_HDR_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_CO_HDR_A] Script Date: 03/09/2017 16:45:22 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_CO_HDR_A](
    [ISN_FIP_CO_HDR_A] [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,
    [CHG_ORD_NBR] [int] NULL,
    [CHG_ORD_NEEDS_PRINTED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHG_ORD_NOTE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHG_ORD_PRINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_TYPE] [varchar](2) 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,
    [REC_STATUS] [varchar](2) 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,
    [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,
    [BILL_TO_ADDR_CODE] [varchar](2) 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,
    [ACCRUAL_TOT_AMT] [numeric](17, 2) NULL,
    [GL_TOT_ADJUST_AMT] [numeric](17, 2) NULL,
    [TRANSACTION_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_TYPE_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SHIP_TO_CODE_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_ID_B] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUGGESTED_VENDOR_B] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HDR_VENDOR_ADDR_B] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DELIVER_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CANCELLED_ACTION_CODE_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REC_STATUS_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TERMS_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOB_TERMS_B] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOLERANCE_FLAG_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PO_PRINT_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_NBR_B] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROJECT_NBR_B] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOARD_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BID_NBR_B] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BID_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BLANKET_BEGIN_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BLANKET_END_DATE_B] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BLANKET_MAX_AMT_B] [numeric](17, 2) NULL,
    [CALC_TOT_AMT_B] [numeric](17, 2) NULL,
    [FREIGHT_AMT_B] [numeric](17, 2) NULL,
    [FREIGHT_PRE_PAY_ADD_B] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FREIGHT_ITM_NBR_B] [int] NULL,
    [BILL_TO_ADDR_CODE_B] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENC_TOT_AMT_B] [numeric](17, 2) NULL,
    [BALANCE_TOT_AMT_B] [numeric](17, 2) NULL,
    [PAID_TOT_AMT_B] [numeric](17, 2) NULL,
    [ACCRUAL_TOT_AMT_B] [numeric](17, 2) NULL,
    [GL_TOT_ADJUST_AMT_B] [numeric](17, 2) NULL,
    [TRANSACTION_STATUS_B] [varchar](2) 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 BID_DATE BID_DATE_B BID_NBR BID_NBR_B BILL_TO_ADDR_CODE BILL_TO_ADDR_CODE_B BLANKET_BEGIN_DATE BLANKET_BEGIN_DATE_B BLANKET_END_DATE BLANKET_END_DATE_B BOARD_DATE BOARD_DATE_B BUYER_ID BUYER_ID_B CALC_TOT_AMT CALC_TOT_AMT_B CANCELLED_ACTION_CODE CANCELLED_ACTION_CODE_B CHG_ORD_NBR CHG_ORD_NEEDS_PRINTED_IND CHG_ORD_NOTE_IND CHG_ORD_PRINT_DATE CONTRACT_NBR CONTRACT_NBR_B DELIVER_DATE DELIVER_DATE_B FISCAL_YEAR FOB_TERMS FOB_TERMS_B FREIGHT_PRE_PAY_ADD FREIGHT_PRE_PAY_ADD_B HDR_VENDOR_ADDR HDR_VENDOR_ADDR_B HOLD ISN_FIP_CO_HDR_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAYMENT_TERMS PAYMENT_TERMS_B PO_PRINT_DATE PO_PRINT_DATE_B PROJECT_NBR PROJECT_NBR_B REC_STATUS REC_STATUS_B REF_NBR REF_TYPE REF_TYPE_B RowUpdatedOn SHIP_TO_CODE SHIP_TO_CODE_B STATUS STATUS_B SUGGESTED_VENDOR SUGGESTED_VENDOR_B TOLERANCE_FLAG TOLERANCE_FLAG_B TRANSACTION_STATUS TRANSACTION_STATUS_B
20130916 FIP700N1 1331570 E082561 1000.00 500.00 1 Y 2014 0000038391 00000383900 851098 38722 20140324 FIP700N1 0851098 E019027 00001722 2017-02-06T11:12:19.706-05:00
20060206 FIP700N1 0930048 E019027 N 2 Y 2006 6160012181 6160012180001 1613592 22377 20060802 FIP700N1 1228422 E000343 00003734 2017-02-06T11:12:16.96-05:00 CL OP
20100615 FIP700N1 0828335 E037615 3 Y 2010 7422259282 74222592800 956409 31302 20100804 FIP700N1 0956408 E019027 00005686 2017-02-06T11:12:18.427-05:00
20100728 FIP700N1 0758145 E037615 1 Y 2011 1353695004 13536950000 1351426 31287 20100803 FIP700N1 1351426 E037615 00000689 2017-02-06T11:12:18.411-05:00
20080723 FIP700N1 0808314 E019027 5 Y Y 2009 6507695841 65076958400 1455543 28005 20090602 FIP700N1 1033425 E001609 00000505 2017-02-06T11:12:17.881-05:00 OP CL
20080402 FIP700N1 0939012 E019027 N 1 Y 2008 5929594421 5929594420001 1019454 26667 20080402 FIP700N1 0947018 E019027 00004520 2017-02-06T11:12:17.662-05:00 CL OP
20110725 FIP700N1 1428041 E019027 60000.00 35000.00 2 Y 2012 5617617292 56176172900 1522552 33864 20111026 FIP700N1 1522552 E019027 00000594 2017-02-06T11:12:18.863-05:00
20160823 FIP700N1 1527226 E019027 1 Y 2017 CAFE888881 CAFE8888800 1117216 44743 20161104 FIP700N1 1117215 E019027 00001167 2017-02-06T11:12:20.735-05:00
19981118 FIP700N1 1020566 DWINDHAM 489.20 500.00 N 1 Y 1999 1333213 4992 19990917 FIP700N1 1333202 MMCGANN 00194152 2017-02-06T11:12:13.996-05:00 CL OP
20110830 FIP700N1 0854007 E037615 5367.50 3420.00 2 Y 2012 5220811783 52208117800 1002351 34369 20120326 FIP700N1 1002351 E037615 00001359 2017-02-06T11:12:18.957-05:00
Powered by BI Documenter