DWOperations
 dbo.Verify_dbo_DimPayable (Table)
Home  Diagrams  Documents  Images  DWOperations  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:  DWOperations   Tables   dbo.Verify_dbo_DimPayable
  Properties
Property Value
Name Verify_dbo_DimPayable
Schema dbo
Row Count 1499495
Data Size 280776 KB
Index Size 1064 KB
Create Date 1/28/2014 9:48 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
FiscalYear
varchar(4)
False
False
False
 
Origin
varchar(30)
False
False
False
 
OriginCode
varchar(4)
False
False
False
 
PayableAK
varchar(12)
False
False
False
 
PayableDate
datetime(23, 3)
False
False
False
 
PayableNumber
varchar(8)
False
False
False
 
PayableStatus
varchar(30)
False
False
False
 
PayableStatusCode
varchar(3)
False
False
False
 
PaymentDate
datetime(23, 3)
False
False
False
 
PaymentType
varchar(30)
False
False
False
 
PaymentTypeCode
varchar(3)
False
False
False
 
PaymentTypeNumber
varchar(15)
False
False
False
 
PaymentXrefNbr
varchar(12)
False
False
False
 
ReferenceNumber
varchar(20)
False
False
False
 
ReferenceType
varchar(30)
False
False
False
 
ReferenceTypeCode
varchar(4)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
In Primary Key
VerifyPayableSK
int(10, 0)
False
False
False
(1 / 1)
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyPayableSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimPayable depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimPayable)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimPayable] Script Date: 03/09/2017 17:21:47 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimPayable](
    [VerifyPayableSK] [int] IDENTITY(1,1) NOT NULL,
    [PayableAK] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalYear] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayableNumber] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OriginCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Origin] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReferenceTypeCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReferenceType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReferenceNumber] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentTypeNumber] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayableStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayableStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayableDate] [datetime] NOT NULL,
    [PaymentDate] [datetime] NOT NULL,
    [PaymentXrefNbr] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_DimPayable] PRIMARY KEY CLUSTERED 
(
    [VerifyPayableSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
FiscalYear Origin OriginCode PayableAK PayableDate PayableNumber PayableStatus PayableStatusCode PaymentDate PaymentType PaymentTypeCode PaymentTypeNumber PaymentXrefNbr ReferenceNumber ReferenceType ReferenceTypeCode RowIsDuplicate RowIsSelected VerifyPayableSK
2006 STUDENT SYSTEM STUD 200600013348 2005-09-22T00:00:00-04:00 00013348 PAID PD 2005-09-23T00:00:00-04:00 Check CHK 00333070 200600245283 2006-000402246001007 F/A DISBURSEMENT FIND N Y 1327547
2015 STUDENT SYSTEM STUD 201500050342 2015-02-12T00:00:00-05:00 00050342 PAID PD 2015-02-13T00:00:00-05:00 Check CHK 00653917 201500772612 2015-006321487001008 F/A DISBURSEMENT FIND N Y 778654
2006 STUDENT SYSTEM STUD 200600014862 2005-09-22T00:00:00-04:00 00014862 PAID PD 2005-09-23T00:00:00-04:00 Check CHK 00332880 200600244201 2006-000423050001003 F/A DISBURSEMENT FIND N Y 1479281
2016 PURCHASING/RECEIVING SYSTEM PUR 201600024703 2015-10-01T00:00:00-04:00 00024703 PAID PD 2015-10-02T00:00:00-04:00 Check CHK 00671826 201600816420 2016-00001201 LIBRARY BLANKET ORDER LB N Y 1426274
1999 PURCHASING/RECEIVING SYSTEM PUR 199900018812 1999-02-25T00:00:00-05:00 00018812 PAID PD 1999-02-25T00:00:00-05:00 Check CHK 00311008 199900011165 1999-00195643 BLANKET ORDER BO N Y 160795
2014 STUDENT SYSTEM STUD 201400052764 2014-01-23T00:00:00-05:00 00052764 PAID PD 2014-01-24T00:00:00-05:00 Check CHK 00622284 201400708729 2014-006199038001042 F/A DISBURSEMENT FIND N Y 520948
1999 STUDENT SYSTEM STUD 199900012830 1999-02-02T00:00:00-05:00 00012830 PAID PD 1999-02-02T00:00:00-05:00 Check CHK 00307965 199900008117 PELL--2 FINANCIAL AID F/A N Y 1432061
2011 STUDENT SYSTEM STUD 201100105216 2011-06-27T00:00:00-04:00 00105216 PAID PD 2011-06-28T00:00:00-04:00 Electronic Fund Transfer EFT 000000000037023 201100542658 2011-005590427001013 F/A DISBURSEMENT FIND N Y 874463
2001 PURCHASING/RECEIVING SYSTEM PUR 200100008994 2000-09-12T00:00:00-04:00 00008994 PAID PD 2000-09-12T00:00:00-04:00 Check CHK 00130623 200100056004 2001-00206832 STANDARD PURCHASE ORDER PO N Y 633992
2003 STUDENT SYSTEM STUD 200300013196 2002-09-13T00:00:00-04:00 00013196 PAID PD 2002-09-16T00:00:00-04:00 Check CHK 00196797 200300121174 2003-000194552001002 BATCH STUDENT REFUND RFND N Y 296716
Powered by BI Documenter