Deltek Vantagepoint 2025.4 to Deltek Vantagepoint 2026.1 Database Changes

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.

NewTables

TableName
CFGEmailAllowed
Insight
InsightCategoryUserSubscription
InsightEmployee
UKGIntegrationLog
XChargeLastRunNumber
XChargeRun
XChargeRunLA

NewColumns

TableName ColumnName DataType
ApiAuthorization EnableIntegration bit NOT NULL
ApiAuthorization SystemIntegration bit NOT NULL
ApiAuthorization Website nvarchar(255)
CFGBillMainData DefaultApprovalWorkflow varchar(32)
CFGVisionSystem BatchSize int NOT NULL
FW_CFGSystem EnableApprovalsAI bit NOT NULL
FW_CFGSystem SingleSignOnDefault bit NOT NULL
FW_Files Status int NOT NULL
FW_Files StorageProvider varchar(20) NOT NULL
FW_Files TargetedContentType nvarchar(200)
InvoiceApproval UnbilledAmount decimal(19,4) NOT NULL
InvoiceApproval WriteOffAmount decimal(19,4) NOT NULL
PRSummaryMain TotalBilledWithInterest decimal(19,4) NOT NULL
PRSummaryMain TotalBilledWithInterestBillingCurrency decimal(19,4) NOT NULL
PRSummaryMain TotalBilledWithInterestProjectCurrency decimal(19,4) NOT NULL
PRSummarySub TotalBilledWithInterest decimal(19,4) NOT NULL
PRSummarySub TotalBilledWithInterestBillingCurrency decimal(19,4) NOT NULL
PRSummarySub TotalBilledWithInterestProjectCurrency decimal(19,4) NOT NULL
SEUser AccountSearchSort varchar(10)
SEUser AppPreferredView varchar(10)
SEUser DefaultRecordSelectionType varchar(20)
SEUser DefaultTheme varchar(10)
SEUser InsightCategories varchar(256)
SEUser ProjectSearchSort varchar(10)
SEUser ViewLeadsInContact bit NOT NULL
XChargeWk XChargeRunPKey int NOT NULL

ModifiedColumns

TableName ColumnName OldDataType NewDataType
ApiAuthorization ConsumerKey varchar(128) NOT NULL varchar(128)
ApiAuthorization Scopes nvarchar(15) NOT NULL nvarchar(15)
SEUser decimalSymbol varchar(1) varchar(1) NOT NULL
SEUser ShortDateFormat nvarchar(50) nvarchar(50) NOT NULL

RemovedTables

TableName
CFGSalesforceMapping

RemovedColumns

TableName ColumnName DataType
CFGVisionSystem SFApiVersion nvarchar(25)
CFGVisionSystem SFConsumerKey nvarchar(255)
CFGVisionSystem SFConsumerSecret nvarchar(255)
CFGVisionSystem SFEnabled varchar(1) NOT NULL
CFGVisionSystem SFErrorOption varchar(1) NOT NULL
CFGVisionSystem SFImportOption varchar(1) NOT NULL
CFGVisionSystem SFImportStages nvarchar(max)
CFGVisionSystem SFInstanceUrl nvarchar(255)
CFGVisionSystem SFInterval int NOT NULL
CFGVisionSystem SFLastUpdate datetime
CFGVisionSystem SFNextSeq int NOT NULL
CFGVisionSystem SFNotificationRole nvarchar(20)
CFGVisionSystem SFOAuthToken nvarchar(255)
CFGVisionSystem SFPassword nvarchar(255)
CFGVisionSystem SFRefreshToken nvarchar(255)
CFGVisionSystem SFSandbox varchar(1) NOT NULL
CFGVisionSystem SFScreenDesigner varchar(1) NOT NULL
CFGVisionSystem SFUsername nvarchar(255)
CFGVisionSystem SFWorkflow varchar(1) NOT NULL

NewObjects

ParentObjectName ChildObjectName ObjectType
BILD BILDXferWBS1XferWBS2XferWBS3IDX Index
CFGPostControl CFGPostControlCompanyPeriodPostSeqIDX Index
EQICBooks EQICBooksEquipBookCodeIDX Index
Insight InsightApplicationKeyIDX Index
InsightEmployee InsightEmployeeInsightIDEmployeeIDX Index
LedgerAR LedgerARWBS1WBS2WBS3PeriodAutoEntryTransTypeIDX Index
PR PRPUIDIDX Index
PR PRWBS2WBS3ReadyForProcessingIDX Index

RemovedObjects

ParentObjectName ChildObjectName ObjectType
Clendor ClendorSFIDIDX Index
Contacts ContactsSFIDIDX Index
LedgerAR LedgerARWBS1WBS2WBS3IDX Index
PR PRWBS1WBS2WBS3IDX Index
PR PRWBS2WBS3IDX Index