Database Changes from Deltek Vantagepoint 3.5
Contents
| Database Changes |
| New Tables |
| Removed Tables |
| Renamed Tables |
| New Columns Added to Existing Tables |
| Changes to Existing Columns |
| Removed Columns |
| Renamed Columns |
| New Objects |
| Removed Objects |
| Renamed Objects |
This section lists the database table and column changes included in this release.
|
|
Deltek creates the Data Dictionary 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. |
| Table Name |
| None |
| Table Name |
| None |
| Table Name |
| None |
New Columns Added to Existing Tables
|
Table Name |
Column Name |
Data Type |
| CFGQuickbooks | AuthorizeUrl (3.5.1) | nvarchar(1000) |
| CFGQuickbooks | BatchSize (3.5.1) | int NOT NULL |
| CFGQuickbooks | RefreshTokenExpiresOn (3.5.1) | datetime |
| CFGQuickbooks | State (3.5.1) | nvarchar(100) |
| CFGQuickbooks | UserInfoEndpointUrl (3.5.1) | nvarchar(100) |
| FW_CFGSystem | VPConnectHMAC (3.5.1) | nvarchar(255) |
| CustomProposal | LinkedSF330 (3.5.2) | varchar(32) |
| CustomProposal | ProposalType (3.5.2) | varchar(20) |
| Activity | OccurrenceDate (3.5.3) | datetime |
| RecurrActivityException | TranType (3.5.3) | varchar(1) NOT NULL |
| ApprovalErrorLog | OriginalTimesheetData (3.5.3) | nvarchar(max) |
| FW_CFGSystem | FinalInvoicePDFEnabled (3.5.3) | varchar(1) NOT NULL |
| billInvMaster | FinalInvoiceFileID (3.5.3) | uniqueidentifier |
| billInvMaster | EditedFileType (3.5.3) | nvarchar(4) |
| FW_CFGSystem | VPConnectLocation (3.5.4) | nvarchar(255) NOT NULL |
| Activity | TimeZoneOffset (3.5.4) | bigint NOT NULL |
| Form1099Data | Exclude1099NEC (3.5.5) | varchar(1) NOT NULL default ('N') |
| Form1099Data | NonqualifiedDeferredCompensation (3.5.5) | decimal(19,4) NOT NULL default (0) |
| FW_CFGSysConfig | HMRCUniqueID (3.5.9) | uniqueidentifier NOT NULL |
| CFGDeltekOperations | VisionUpgrade (3.5.11) | varchar(1) NOT NULL |
| CFGDeltekOperations | VisionUpgradeDate(3.5.11) | datetime |
| GLSummary | CBCreditAmount (3.5.11) | decimal(19,4) NOT NULL |
| GLSummary | CBDebitAmount (3.5.11) | decimal(19,4) NOT NULL |
| GLSummary | CreditAmount (3.5.11) | decimal(19,4) NOT NULL |
| GLSummary | DebitAmount (3.5.11) | decimal(19,4) NOT NULL |
| GLSummary | TransType (3.5.11) | nvarchar(2) NOT NULL |
| ContractDetails | ContractDetailsID (3.5.12) | bigint NOT NULL |
| ContractDetailsTemplate | ContractDetailsTemplateID (3.5.12) | bigint NOT NULL |
| Contracts | ContractsID (3.5.12) | bigint NOT NULL |
| ContractsTemplate | ContractsTemplateID (3.5.12) | bigint NOT NULL |
|
Table Name |
Column Name |
New DataType |
Old DataType |
| CFGQuickBooks | BaseUrl (3.5.2) | nvarchar(255) | nvarchar(100) |
| CFGQuickBooks | DiscoveryUrl (3.5.2) | nvarchar(255) | nvarchar(100) |
| CFGQuickBooks | RedirectUrl (3.5.2) | nvarchar(255) | nvarchar(100) |
| SavedOptionsDetail | OptionName (3.5.2) | nvarchar(250) NOT NULL | nvarchar(80) NOT NULL |
| SavedInvoices | FileType (3.5.3) | nvarchar(4) | nvarchar(3) |
| KeyConvertWork | OldKey (3.5.4) | nvarchar(32) | varchar(32) |
| KeyConvertWork | OldKey2 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertWork | OldKey3 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertWork | NewKey (3.5.4) | nvarchar(32) | varchar(32) |
| KeyConvertWork | NewKey2 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertWork | NewKey3 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertLog | OldKey (3.5.4) | nvarchar(32) | varchar(32) |
| KeyConvertLog | OldKey2 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertLog | OldKey3 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertLog | NewKey (3.5.4) | nvarchar(32) | varchar(32) |
| KeyConvertLog | NewKey2 (3.5.4) | nvarchar(30) | nvarchar(7) |
| KeyConvertLog | NewKey3 (3.5.4) | nvarchar(30) | nvarchar(7) |
|
Table Name |
Column Name |
Data Type |
| ClientCustomTabFields | Vendor (3.5.11) | nvarchar(20) |
| VendorCusomTabFields | Vendor (3.5.11) | nvarchar(20) |
| Column Name | New Column Name | Old Column Name |
| None |
|
Object Name |
Object Type |
| ApprovalItemHistoryItem_UIDIDX (3.5.1) | Index |
| sp_stRPFixDuplicateAssignments (3.5.2) | Stored Procedure |
| sp_stRPFixTPDOnlyOnWBSLevel (3.5.2) | Stored Procedure |
| RecurrActivityExceptionTranTypeIDX (3.5.3) | Index |
| APPPChecksPostSeqVendorBankCodeIDX (3.5.3) | Index |
| ApprovalItemApplicationIDApprovalLevelIDX (3.5.4) | Index |
| ApprovalItemApplicationIDApprovalLevelItemParentIDX (3.5.7) | Index |
| ApprovalItemApplicationIDApprovalLevelItemTypeIDX (3.5.7) | Index |
| ApprovalItemAssignUSR_IDIDX (3.5.7) | Index |
| CFGScreenDesignerDataInfocenterAreaComponentIDIDX (3.5.7) | Index |
| CFGScreenDesignerDataInfocenterAreaGridIDIDX (3.5.7) | Index |
| CFGScreenDesignerLabelsInfoCenterAreaGridIDIDX (3.5.7) | Index |
| InvoiceApproverEmployeeIDX (3.5.7) | Index |
| PNTaskTaskIDIDX (3.5.7) | Index |
| POCommitmentWBSIDX (3.5.7) | Index |
| PODetailCOPKeyIDX (3.5.7) | Index |
| SERoleIDX (3.5.7) | Index |
| tkMasterSubmittedIDX (3.5.7) | Index |
| WorkflowActionsActionTypeActiveIDX (3.5.7) | Index |
| WorkflowActionsEventIDActionTypeIDX (3.5.7) | Index |
| WorkflowActionsEventIDActiveIDX (3.5.7) | Index |
| WorkflowConditionsIDIDX (3.5.7) | Index |
| PRSubLevelIDX (3.5.8) | Index |
| UNUnitNameUnitUnitTableIDX (3.5.8) | Index |
| ClearCustomFKColumns (3.5.10) | Stored Procedure |
| ContractDetailsWBS1WBS2WBS3ContractNumberIDX (3.5.12) | Index |
| ContractDetailsTemplateWBS1WBS2WBS3ContractNumberIDX (3.5.12) | Index |
| ContractsWBS1ContractNumberIDX (3.5.12) | Index |
| ContractsTemplateWBS1ContractNumberIDX (3.5.12) | Index |
| Object Name | Object Type |
| ApprovalItemApplicationIDApprovalLevelIDX (3.5.7) | Index |
| DeleteFirm (3.5.10) | Stored Procedure |
| Object Name |
| None |