Table - dbo.DimPayable

Property	Value
Name	DimPayable
Schema	dbo
Row Count	1499496
Data Size	303688 KB
Index Size	1144 KB
Create Date	1/28/2014 9:47 AM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
FiscalYear	varchar(4)	False	False	False			The fiscal year associated with the payable
Origin	varchar(30)	False	False	False			The description of the Origin Code
OriginCode	varchar(4)	False	False	False			The code from where the payable was created
PayableAK	varchar(12)	False	False	False			Business Key for the Payable. This will be a combination of FiscalYear and Payable Number
PayableDate	datetime(23, 3)	False	False	False			The date the Payable was due to be processed
PayableNumber	varchar(8)	False	False	False			The payable number
PayableSK	int(10, 0)	False	False	False	(1 / 1)		Surrogate primary key
PayableStatus	varchar(30)	False	False	False			The description of the payable status code
PayableStatusCode	varchar(3)	False	False	False			The code for the Payable Status
PaymentDate	datetime(23, 3)	False	False	False			The date the Payment was created
PaymentType	varchar(30)	False	False	False			The description of the payment type code.
PaymentTypeCode	varchar(3)	False	False	False			The code indicating the payment type
PaymentTypeNumber	varchar(15)	False	False	False			The number assigned to the Payment during the Payment Process Execution. This can be blank if the Payable has not been paid or has been cancelled.
PaymentXrefNbr	varchar(12)	False	False	False			This number will provide informaiton that links to the Payment Details
ReferenceNumber	varchar(20)	False	False	False			The number associated with the source document from which the Payable was created.
ReferenceType	varchar(30)	False	False	False			The description of the Reference Type Code
ReferenceTypeCode	varchar(4)	False	False	False			The code associated with the reference type on the payable
RowEndDate	datetime(23, 3)	True	False	False			When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent	char(1)	False	False	False			Is this the current row for this member (Y/N)?
RowStartDate	datetime(23, 3)	False	False	False			When did this row become valid for this member?

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimPayable	True	PayableSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactPayableAmounts	Table

Name	Type
dbo.FactPayableAmounts	TABLE

Object	Property	Value
DimPayable	Display Name	Payable
DimPayable	Table Description	This table will contain a row for each payable in the system.
DimPayable	Table Type	Dimension
FiscalYear	Display Name	FiscalYear
FiscalYear	Example Values	2012
FiscalYear	MS_Description	The fiscal year associated with the payable
FiscalYear	SCD Type	1
FiscalYear	Source Field Name	FISCAL_YEAR
FiscalYear	Source System	DWStaging
FiscalYear	Source Table	AP_PAYABLE
Origin	Display Name	Origin
Origin	ETL Rules	Extracted from the UTL_CODE_TABLE_FILE, table name ORIGINS Convert to Upper/Lower case
Origin	Example Values	Credit Memo, Student, Travel Payment Request
Origin	MS_Description	The description of the Origin Code
Origin	SCD Type	1
Origin	Source System	Derived
Origin	Source Table	UTL_CODE_TABLE_FILE
OriginCode	Display Name	OriginCode
OriginCode	Example Values	STUD
OriginCode	MS_Description	The code from where the payable was created
OriginCode	SCD Type	1
OriginCode	Source Field Name	ORIGIN
OriginCode	Source System	DWStaging
OriginCode	Source Table	AP_PAYABLE
PayableAK	Display Name	PayableAK
PayableAK	ETL Rules	Concatenate FISCAL_YEAR and PAYABLE_NBR
PayableAK	Example Values	201200004786
PayableAK	MS_Description	Business Key for the Payable. This will be a combination of FiscalYear and Payable Number
PayableAK	SCD Type	key
PayableAK	Source Field Name	FISCAL_YEAR + PAYABLE_NBR
PayableAK	Source System	DWStaging
PayableAK	Source Table	AP_PAYABLE
PayableDate	Display Name	PayableDate
PayableDate	ETL Rules	If Date is NULL assign 1900-01-01
PayableDate	Example Values	2/14/2012
PayableDate	MS_Description	The date the Payable was due to be processed
PayableDate	SCD Type	1
PayableDate	Source Field Name	PAY_DATE
PayableDate	Source System	DWStaging
PayableDate	Source Table	AP_PAYABLE
PayableNumber	Display Name	PayableNumber
PayableNumber	Example Values	000004786
PayableNumber	MS_Description	The payable number
PayableNumber	SCD Type	1
PayableNumber	Source Field Name	PAYABLE_NBR
PayableNumber	Source System	DWStaging
PayableNumber	Source Table	AP_PAYABLE
PayableSK	Display Name	PayableSK
PayableSK	Example Values	1, 2, 3?
PayableSK	MS_Description	Surrogate primary key
PayableSK	SCD Type	key
PayableSK	Source System	Derived
PayableStatus	Display Name	PayableStatus
PayableStatus	ETL Rules	Extracted from FIP-STATUS-TBL-V
PayableStatus	Example Values	Paid, Pending, Cancelled
PayableStatus	MS_Description	The description of the payable status code
PayableStatus	SCD Type	1
PayableStatus	Source System	DWStaging
PayableStatus	Source Table	UTL_CODE_TABLE_FILE
PayableStatusCode	Display Name	PayableStatusCode
PayableStatusCode	Example Values	PD, PE, CA, IG
PayableStatusCode	MS_Description	The code for the Payable Status
PayableStatusCode	SCD Type	1
PayableStatusCode	Source Field Name	PAY_STATUS
PayableStatusCode	Source System	DWStaging
PayableStatusCode	Source Table	AP_PAYABLE
PaymentDate	Display Name	PaymentDate
PaymentDate	ETL Rules	If Date is NULL assign 20980101
PaymentDate	Example Values	2/14/2012
PaymentDate	MS_Description	The date the Payment was created
PaymentDate	SCD Type	1
PaymentDate	Source Field Name	PAYMENT_DATE
PaymentDate	Source System	DWStaging
PaymentDate	Source Table	AP_PAYABLE
PaymentType	Display Name	PaymentTypeCode
PaymentType	ETL Rules	Code in ETL
PaymentType	Example Values	Check, Electronic Fund Transfer, Refund to Credit Card
PaymentType	MS_Description	The description of the payment type code.
PaymentType	SCD Type	1
PaymentType	Source System	Derived
PaymentTypeCode	Display Name	PaymentTypeCode
PaymentTypeCode	Example Values	CHK, EFT, CCR
PaymentTypeCode	MS_Description	The code indicating the payment type
PaymentTypeCode	SCD Type	1
PaymentTypeCode	Source Field Name	PAYMENT_TYPE
PaymentTypeCode	Source System	DWStaging
PaymentTypeCode	Source Table	AP_PAYABLE
PaymentTypeNumber	MS_Description	The number assigned to the Payment during the Payment Process Execution. This can be blank if the Payable has not been paid or has been cancelled.
PaymentXrefNbr	Display Name	PaymentXrefNbr
PaymentXrefNbr	Example Values	20120089856
PaymentXrefNbr	MS_Description	This number will provide informaiton that links to the Payment Details
PaymentXrefNbr	SCD Type	1
PaymentXrefNbr	Source Field Name	PAYMENT_XREF
PaymentXrefNbr	Source System	DWStaging
PaymentXrefNbr	Source Table	AP_PAYABLE
ReferenceNumber	MS_Description	The number associated with the source document from which the Payable was created.
ReferenceType	Display Name	ReferenceType
ReferenceType	ETL Rules	Extracted from the UTL_CODE_TABLE_FILE, If ORIGIN = DSBR', then table name DISBTYPES, ORIGIN = 'PUR' then table-name REF-TYPE
ReferenceType	Example Values	Refund, Blanket Order
ReferenceType	MS_Description	The description of the Reference Type Code
ReferenceType	SCD Type	1
ReferenceType	Source System	Derived
ReferenceType	Source Table	UTL_CODE_TABLE_FILE
ReferenceTypeCode	Display Name	ReferenceTypeCode
ReferenceTypeCode	Example Values	RQ, RFND, GB
ReferenceTypeCode	MS_Description	The code associated with the reference type on the payable
ReferenceTypeCode	SCD Type	1
ReferenceTypeCode	Source Field Name	REF_TYPE
ReferenceTypeCode	Source System	DWStaging
ReferenceTypeCode	Source Table	AP_PAYABLE
RowEndDate	Display Folder	Exclude from cube
RowEndDate	Display Name	Row End Date
RowEndDate	ETL Rules	Standard SCD-2
RowEndDate	Example Values	1/14/1998, 12/31/9999
RowEndDate	MS_Description	When did this row become invalid? (12/31/9999 if current row)
RowEndDate	SCD Type	n/a
RowEndDate	Source System	Derived
RowIsCurrent	Display Folder	Exclude from cube
RowIsCurrent	Display Name	Row Is Current
RowIsCurrent	ETL Rules	Standard SCD-2
RowIsCurrent	Example Values	Y, N
RowIsCurrent	MS_Description	Is this the current row for this member (Y/N)?
RowIsCurrent	SCD Type	n/a
RowIsCurrent	Source System	Derived
RowStartDate	Display Folder	Exclude from cube
RowStartDate	Display Name	Row Start Date
RowStartDate	ETL Rules	Standard SCD-2
RowStartDate	Example Values	1/24/2011
RowStartDate	MS_Description	When did this row become valid for this member?
RowStartDate	SCD Type	n/a
RowStartDate	Source System	Derived

Object

Property

Value

/****** Object: Table [dbo].[DimPayable] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimPayable](
    [PayableSK] [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,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
CONSTRAINT [PK_dbo.DimPayable] PRIMARY KEY CLUSTERED
(
    [PayableSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payable' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable'

EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'This table will contain a row for each payable in the system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable'

EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'FiscalYear' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2012' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fiscal year associated with the payable' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FISCAL_YEAR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'FiscalYear'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Origin ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from the UTL_CODE_TABLE_FILE, table name ORIGINS Convert to Upper/Lower case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Credit Memo, Student, Travel Payment Request' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Origin Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'Origin'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'OriginCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'STUD' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code from where the payable was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'ORIGIN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'OriginCode'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PayableAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Concatenate FISCAL_YEAR and PAYABLE_NBR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'201200004786' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business Key for the Payable. This will be a combination of FiscalYear and Payable Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FISCAL_YEAR + PAYABLE_NBR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableAK'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PayableDate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'If Date is NULL assign 1900-01-01' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2/14/2012' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date the Payable was due to be processed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PAY_DATE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PayableNumber' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'000004786' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The payable number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PAYABLE_NBR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableNumber'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PayableSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableSK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1, 2, 3?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableSK'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableSK'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableSK'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PayableStatus ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from FIP-STATUS-TBL-V' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Paid, Pending, Cancelled' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the payable status code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatus'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PayableStatusCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'PD, PE, CA, IG' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code for the Payable Status' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PAY_STATUS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PayableStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PaymentDate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'If Date is NULL assign 20980101' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2/14/2012' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date the Payment was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PAYMENT_DATE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PaymentTypeCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentType'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Code in ETL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentType'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Check, Electronic Fund Transfer, Refund to Credit Card' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the payment type code. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentType'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentType'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentType'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PaymentTypeCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'CHK, EFT, CCR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code indicating the payment type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PAYMENT_TYPE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number assigned to the Payment during the Payment Process Execution. This can be blank if the Payable has not been paid or has been cancelled.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentTypeNumber'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'PaymentXrefNbr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'20120089856' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This number will provide informaiton that links to the Payment Details' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PAYMENT_XREF' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'PaymentXrefNbr'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number associated with the source document from which the Payable was created.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceNumber'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'ReferenceType' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from the UTL_CODE_TABLE_FILE, If ORIGIN = DSBR'', then table name DISBTYPES, ORIGIN = ''PUR'' then table-name REF-TYPE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Refund, Blanket Order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Reference Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceType'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'ReferenceTypeCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'RQ, RFND, GB' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code associated with the reference type on the payable' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'REF_TYPE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AP_PAYABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'ReferenceTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row End Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/14/1998, 12/31/9999' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Is Current' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Y, N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Start Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/24/2011' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayable', @level2type=N'COLUMN',@level2name=N'RowStartDate'

FiscalYear

Origin

OriginCode

PayableAK

PayableDate

PayableNumber

PayableSK

PayableStatus

PayableStatusCode

PaymentDate

PaymentType

PaymentTypeCode

PaymentTypeNumber

PaymentXrefNbr

ReferenceNumber

ReferenceType

ReferenceTypeCode

RowEndDate

RowIsCurrent

RowStartDate

2010

Purchasing/Receiving System

PUR

201000021422

2009-09-11T00:00:00-04:00

00021422

1522451

Paid

PD

2009-09-14T00:00:00-04:00

Check

CHK

00459438

201000421668

2010-00000074

Service Contract Order

SC

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2017

Student System

STUD

201700025342

2016-09-29T00:00:00-04:00

00025342

2191559

Paid

PD

2016-09-30T00:00:00-04:00

Electronic Fund Transfer

EFT

000000000150989

201700880521

2017-006561499001002

F/A Disbursement

FIND

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2005

Purchasing/Receiving System

PUR

200500064869

2005-04-11T00:00:00-04:00

00064869

1155183

Paid

PD

2005-04-12T00:00:00-04:00

Check

CHK

00294347

200500228784

2005-00005191

Service Contract Order

SC

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2010

Purchasing/Receiving System

PUR

201000041659

2009-11-23T00:00:00-05:00

00041659

1536950

Paid

PD

2009-11-24T00:00:00-05:00

Check

CHK

00467924

201000434987

2010-00002738

Standard Purchase Order

PO

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2006

Student System

STUD

200600054912

2006-03-17T00:00:00-05:00

00054912

1226175

Paid

PD

2006-03-17T00:00:00-05:00

Refund to Credit Card

CCR

000000000024023

200600267506

2006-000457554001002

Batch Student Refund

RFND

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2015

Student System

STUD

201500008834

2014-09-04T00:00:00-04:00

00008834

2010385

Paid

PD

2014-09-05T00:00:00-04:00

Refund to Credit Card

CCR

000000000114795

201500743945

2015-006292249001008

Batch Student Refund

RFND

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2014

Student System

STUD

201400017738

2013-09-12T00:00:00-04:00

00017738

1920433

Paid

PD

2013-09-13T00:00:00-04:00

Check

CHK

00610182

201400683352

2014-006166862001011

F/A Disbursement

FIND

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2006

Purchasing/Receiving System

PUR

200600033828

2005-12-20T00:00:00-05:00

00033828

1205796

Paid

PD

2005-12-20T00:00:00-05:00

Check

CHK

00341307

200600255648

2006-00002800

Standard Purchase Order

PO

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2015

Student System

STUD

201500013914

2014-09-25T00:00:00-04:00

00013914

2034583

Paid

PD

2014-09-26T00:00:00-04:00

Electronic Fund Transfer

EFT

000000000100039

201500749197

2015-006275978001010

F/A Disbursement

FIND

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00

2000

Purchasing/Receiving System

PUR

200000043855

2000-05-18T00:00:00-04:00

00043855

799226

Cancelled

CA

2098-01-01T00:00:00-05:00

N/A

2000-00202982

Standard Purchase Order

PO

9999-12-31T23:59:00-05:00

Y

2017-03-09T12:07:00-05:00