Deltek Vantagepoint 7.0 to Deltek Vantagepoint 7.1 Database Changes

Deltek generates this information using a live connection to the development database. Tables and columns related to features in a future release may appear in the data dictionary without descriptions, or with the phrase reserved for future use. You may also see tables and columns for features that you have not purchased or enabled.

New Tables

Table Name

billTaxSection

DocumentTemplateSecurity

inTaxSection

LedgerTaxSection

PurchaseTemplateImages

PurchaseTemplatePODetail

PurchaseTemplateRFQDetail

SEMergeTemplateDocuments

UserActivity

Removed Tables

Table Name

FW_Dictionary

Renamed Tables

Table Name

None

New Columns Added to Existing Tables

Table Name	Column Name	DataType
CAB	MasterPKey	varchar(32) NOT NULL
CABDetail	DetailPKey	varchar(32) NOT NULL
CABDetail	MasterPKey	varchar(32) NOT NULL
CFGBillMainData	TaxByLine	varchar(1)
CFGBillMainData	TaxBySection	varchar(1)
CFGFeatureFlag	Hidden	bit NOT NULL
CFGStatesData	PKey	varchar(32) NOT NULL
CFGStatesDescriptions	PKey	varchar(32) NOT NULL
CFGTKCategory	AutoAddApprovedAbsReqHours	varchar(1) NOT NULL
EMCompany	ExcludeAutoAddApprovedAbsReqHours	varchar(1) NOT NULL
EMCompany	ExcludeAutoAddHours	varchar(1) NOT NULL
FW_CFGSystem	EnableDigitalAssistant	varchar(1) NOT NULL
FW_CFGSystem	FilesAllowed	nvarchar(max)
FW_CFGSystem	OpenIDAuthority	nvarchar(255)
FW_CFGSystem	OpenIDClientID	nvarchar(255)
FW_CFGSystem	OpenIDMetadata	nvarchar(max)
FW_CFGSystem	OpenIDSecret	nvarchar(255)
FW_CustomColumnsData	ShowGroupingSymbol	varchar(1) NOT NULL
PNAssignment	HoursType	varchar(1) NOT NULL
PNSubAssignment	Category	smallint NOT NULL
PNSubAssignment	HoursType	varchar(1) NOT NULL
PurchaseTemplate	ActuateReport	varchar(100)
PurchaseTemplate	Address1	nvarchar(50)
PurchaseTemplate	Address2	nvarchar(50)
PurchaseTemplate	Address3	nvarchar(50)
PurchaseTemplate	Address4	nvarchar(50)
PurchaseTemplate	Agreement	varchar(100)
PurchaseTemplate	AuthLeftMargin	decimal(19,4) NOT NULL
PurchaseTemplate	AuthorizedBy	nvarchar(25)
PurchaseTemplate	AuthTopMargin	decimal(19,4) NOT NULL
PurchaseTemplate	Byline	nvarchar(50)
PurchaseTemplate	FirmAlign	varchar(10)
PurchaseTemplate	FirmLeftPos	decimal(19,4) NOT NULL
PurchaseTemplate	FirmName	nvarchar(50)
PurchaseTemplate	FirmTopPos	decimal(19,4) NOT NULL
PurchaseTemplate	Footer	varchar(255)
PurchaseTemplate	LongDate	nvarchar(255)
PurchaseTemplate	MediumDate	nvarchar(255)
PurchaseTemplate	PageBreakBottomClause	varchar(1) NOT NULL
PurchaseTemplate	PageBreakTopClause	varchar(1) NOT NULL
PurchaseTemplate	PageHeight	decimal(19,4) NOT NULL
PurchaseTemplate	PageSize	varchar(10)
PurchaseTemplate	PageWidth	decimal(19,4) NOT NULL
PurchaseTemplate	PrintBottomClause	varchar(1) NOT NULL
PurchaseTemplate	PrintFirmAddress	varchar(1) NOT NULL
PurchaseTemplate	PrintFirmByLine	varchar(1) NOT NULL
PurchaseTemplate	PrintFirmName	varchar(1) NOT NULL
PurchaseTemplate	PrintFooterLine	varchar(1) NOT NULL
PurchaseTemplate	PrintPageNumbers	varchar(1) NOT NULL
PurchaseTemplate	PrintSysFirmName	varchar(1) NOT NULL
PurchaseTemplate	PrintTopClause	varchar(1) NOT NULL
PurchaseTemplate	ShortDate	nvarchar(255)
PurchaseTemplate	SigDate	nvarchar(255)
PurchaseTemplate	SigDateLabelWidth	decimal(19,4) NOT NULL
PurchaseTemplate	SigDateLineWidth	decimal(19,4) NOT NULL
PurchaseTemplate	SigFileHeight	decimal(19,4) NOT NULL
PurchaseTemplate	SigLabelWidth	decimal(19,4) NOT NULL
PurchaseTemplate	SigLeftMargin	decimal(19,4) NOT NULL
PurchaseTemplate	SigLineWidth	decimal(19,4) NOT NULL
PurchaseTemplate	Signature	nvarchar(255)
PurchaseTemplate	SignatureFile	nvarchar(255)
PurchaseTemplate	SignatureUsed	varchar(1) NOT NULL
PurchaseTemplate	SigTopMargin	decimal(19,4) NOT NULL
PurchaseTemplate	TemplateID	varchar(32) NOT NULL
PurchaseTemplate	TopClauseHeader	varchar(10)
PurchaseTemplate	UnitOfMeasure	varchar(10)
RPAssignment	HoursType	varchar(1) NOT NULL
RPSubAssignment	Category	smallint NOT NULL
RPSubAssignment	HoursType	varchar(1) NOT NULL
SE	AccessAllMergeTemplateDocuments	varchar(1) NOT NULL
SE	AllowAccessPSALedgerAPI	varchar(1) NOT NULL
SE	DigitalAssistant	varchar(1) NOT NULL

 

Changes to Existing Columns

 

Table Name	Column Name	New DataType	Old DataType
ApprovalItem	ApplicationKey	varchar(32)	nvarchar(255) NOT NULL

Removed Columns

Table Name	Column Name	DataType

 

Renamed Columns

Table Name	New Column Name	Old Column Name
None

New Objects

Object Name	Object Type
GetVisionAuditingDetail	Function
APApprovalMasterCompanyVendorInvoiceInvoiceDateIDX	Index
CABMasterPKeyIDX	Index
CABDetailDetailPKeyIDX	Index
CABDetailPKeyIDX	Index
EKDetailEmployeeReportDateReportNameSeqIDX	Index
EKMasterEmployeeReportDateReportNameIDX	Index
SEFieldInfoCenterAreaGridIDComponentIDIDX	Index
tkDetailEndDateEmployeeEmployeeCompanySeqTransDateIDX	Index
tkMasterEndDateEmployeeEmployeeCompanyIDX	Index
FeatureFlagPurchaseTemplateEditor	Stored Proc

 

Removed Objects

Object Name	Object Type
EKDetailPKeyIDX	Index
EKMasterPKeyIDX	Index
tkDetailEndDateEmployeeIDX	Index
tkDetailPKeyIDX	Index
tkMasterPKeyIDX	Index

 

Renamed Objects

Object Name

None