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.
|
Table Name |
|
CFGAuditTableConfig |
|
CFGAuditTableLookup |
|
CFGPREstClause |
|
CFGPREstService |
|
CFGProjectMilestoneData |
|
CFGProjectMilestoneDescriptions |
|
CFGProjectStageData |
|
CFGProjectStageDescriptions |
|
CFGProjRevenueDefaults |
|
CFGProjRevenueTemplateDetail |
|
CFGProjRevenueTemplateMaster |
|
CFGProposalCategoryData |
|
CFGProposalCategoryDescriptions |
|
CFGPRSelectedStages |
|
CFGQuickBooks |
|
ChangeDataCapture |
|
CustomDashpartCalculation |
|
CustomProposalFiles |
|
LDCustomFields |
|
PRCompetitionAssoc |
|
PRCompetitionAssocTemplate |
|
PRConsultant |
|
PRConsultantTemplate |
|
PRExpense |
|
PRExpenseTemplate |
|
PRLabor |
|
PRLaborTemplate |
|
PRMilestone |
|
PRMilestoneTemplate |
|
ProjectFromContacts |
|
PRProposals |
|
PRProposalsTemplate |
|
PRRevenue |
|
PRRevenueTemplate |
|
PRUnit |
|
PRUnitTemplate |
|
QBOAccount |
|
QBODefaultAccountMapping |
|
QBOTaxCode |
|
QBOTaxCodePurchaseTaxRate |
|
QBOTaxCodeSalesTaxRate |
|
QBOTransRef |
|
SEField |
|
SENonce |
|
tkCustomFields |
|
TransactionUDFData |
|
TransactionUDFLabels |
|
UKVATTaxReport |
|
WorkflowCLActivity |
|
Table Name |
|
CFGMobileFieldsData |
|
CFGMobileFieldsDescriptions |
|
CFGOppEstClause |
|
CFGOppEstService |
|
CFGOpportunityStageData |
|
CFGOpportunityStageDescriptions |
|
CFGOpportunityStatusData |
|
CFGOpportunityStatusDescriptions |
|
CFGOppRevenueDefaults |
|
CFGOppRevenueTemplateDetail |
|
CFGOppRevenueTemplateMaster |
|
CustomProposalOpportunity |
|
CustomProposalOpportunityGraphics |
|
CustomProposalTemplates |
|
DocumentsOpportunity |
|
FW_CFGInfoCenterFieldsData |
|
FW_CFGInfoCenterFieldsDesc |
|
MktCampaignOppAssoc |
|
OppConsultant |
|
OppExpense |
|
OppFEWBS |
|
OppLabor |
|
Opportunity |
|
OpportunityClientAssoc |
|
OpportunityCompetitionAssoc |
|
OpportunityContactAssoc |
|
OpportunityCustomTabFields |
|
OpportunityEMAssoc |
|
OpportunityFECostGroups |
|
OpportunityFEFuncGroups |
|
OpportunityFEPhases |
|
OpportunityFESpecialServices |
|
OpportunityFileLinks |
|
OpportunityFromContacts |
|
OpportunityPhoto |
|
OpportunityProjectCodes |
|
OpportunityProposals |
|
OpportunityRevenue |
|
OpportunitySubscr |
|
OppUnit |
|
Table Name |
|
None |
|
Table Name |
Column Name |
DataType |
|
ADPCode |
EMSearch |
varchar(max) |
|
AlertsData |
Config |
varchar(max) |
|
apControl |
Description |
varchar(40) |
|
AllowAssetEntries |
varchar(1) NOT NULL default ('N') |
|
|
BT |
CreateDate |
datetime |
|
BT |
CreateUser |
varchar(20) |
|
BT |
ModDate |
datetime |
|
BT |
ModUser |
varchar(20) |
|
BTA |
CreateDate |
datetime |
|
BTA |
CreateUser |
varchar(20) |
|
BTA |
ModDate |
datetime |
|
BTA |
ModUser |
varchar(20) |
|
BTF |
CreateDate |
datetime |
|
BTF |
CreateUser |
varchar(20) |
|
BTF |
ModDate |
datetime |
|
BTF |
ModUser |
varchar(20) |
|
BTTaxCodes |
CreateDate |
datetime |
|
BTTaxCodes |
CreateUser |
varchar(20) |
|
BTTaxCodes |
ModDate |
datetime |
|
BTTaxCodes |
ModUser |
varchar(20) |
|
BulkUpdate |
SearchPkey |
varchar(32) |
|
CA |
CreateDate |
datetime |
|
CA |
CreateUser |
varchar(20) |
|
CA |
ModDate |
datetime |
|
CA |
ModUser |
varchar(20) |
|
CA |
QBOAccountID |
varchar(18) |
|
CACompanyMapping |
CreateDate |
datetime |
|
CACompanyMapping |
CreateUser |
varchar(20) |
|
CACompanyMapping |
ModDate |
datetime |
|
CACompanyMapping |
ModUser |
varchar(20) |
|
cdControl |
Description |
varchar(40) |
|
CFGBankEntriesCodeData |
EntryCode |
varchar(2) NOT NULL |
|
CFGBankEntriesCodeDescriptions |
EntryCode |
varchar(2) NOT NULL |
|
CFGBanks |
ImportEnabled |
varchar(1) NOT NULL default ('N') |
|
CFGBankTextFormat |
Code |
varchar(10) NOT NULL |
|
CFGBillTaxesData |
QBOID |
varchar(18) |
|
CFGBillTaxesData |
QBOLastUpdated |
datetime |
|
CFGDatesStatus |
CreateDate |
datetime |
|
CFGDatesStatus |
CreateUser |
varchar(20) |
|
CFGDatesStatus |
ModDate |
datetime |
|
CFGDatesStatus |
ModUser |
varchar(20) |
|
CFGEKCategory |
AvailableToAPVouchers |
varchar(1) NOT NULL default ('N') |
|
CFGEKCategory |
AvailableToEXReports |
varchar(1) NOT NULL default ('Y') |
|
CFGEKCategory |
ExpenseType |
varchar(1) NOT NULL default ('O') |
|
CFGIntegrationWS |
EnablePIMContacts |
varchar(1) NOT NULL default ('N') |
|
CFGIntegrationWS |
EnablePIMEmployees |
varchar(1) NOT NULL default ('N') |
|
CFGIntegrationWS |
EnablePIMFirms |
varchar(1) NOT NULL default ('N') |
|
CFGIntegrationWS |
EnablePIMMktCampaigns |
varchar(1) NOT NULL default ('N') |
|
CFGIntegrationWS |
EnablePIMProjects |
varchar(1) NOT NULL default ('N') |
|
CFGMainData |
HMRCAccessToken |
varchar(255) |
|
CFGMainData |
HMRCRefreshToken |
varchar(255) |
|
CFGMainData |
HMRCTokenExpiration |
datetime |
|
CFGMainData |
UseFilestoGroupTransactions |
varchar(1) NOT NULL default ('Y') |
|
CFGPYAccrualsData |
WBS1ExcludeSearch |
varchar(max) |
|
CFGScreenDesignerData |
ColPos |
int NOT NULL default (0) |
|
CFGScreenDesignerData |
ColWidth |
int NOT NULL default (0) |
|
CFGScreenDesignerData |
DefaultValue |
varchar(2000) |
|
CFGScreenDesignerData |
LabelPosition |
varchar(1) |
|
CFGScreenDesignerData |
ParentID |
varchar(125) |
|
CFGScreenDesignerData |
RowHeight |
int NOT NULL default (0) |
|
CFGScreenDesignerData |
RowPos |
int NOT NULL default (0) |
|
CFGTransAutoNumBank |
AutoNumberPaymentType |
smallint NOT NULL default (0) |
|
CFGTransAutoNumBank |
AutoNumberPrefix |
varchar(5) |
|
CFGVisionSystem |
SFNextSeq |
int NOT NULL default (0) |
|
CFGVisionSystem |
TabsAdded |
varchar(1) NOT NULL default ('N') |
|
CLAddress |
QBOAddressID |
varchar(18) |
|
CLAddress |
QBOID |
varchar(18) |
|
CLAddress |
QBOIsBillingAddr |
varchar(1) NOT NULL default ('N') |
|
CLAddress |
QBOIsShippingAddr |
varchar(1) NOT NULL default ('N') |
|
CLAddress |
QBOLastUpdated |
datetime |
|
Clendor |
QBOID |
varchar(18) |
|
Clendor |
QBOLastUpdated |
datetime |
|
Contacts |
ProjectDescription |
varchar(255) |
|
Contacts |
QBOID |
varchar(18) |
|
Contacts |
QBOIsMainContact |
varchar(1) NOT NULL default ('N') |
|
Contacts |
QBOLastUpdated |
datetime |
|
Contracts |
ContractDescription |
varchar(100) |
|
crControl |
Description |
varchar(40) |
|
CustomProposal |
DocumentProperties |
varchar(max) |
|
CustomProposal |
ExtensionCategory |
varchar(10) |
|
CustomProposal |
ExtensionClass |
varchar(30) |
|
CustomProposal |
ExtensionDescription |
varchar(max) |
|
CustomProposal |
PDFFileID |
uniqueidentifier |
|
CustomProposal |
WBS1 |
varchar(30) |
|
CustomProposalElements |
FileID |
uniqueidentifier |
|
CustomProposalElements |
Seq |
int NOT NULL default (0) |
|
cvControl |
Description |
varchar(40) |
|
EMAccrualDetail |
CreateDate |
datetime |
|
EMAccrualDetail |
CreateUser |
varchar(20) |
|
EMAccrualDetail |
ModDate |
datetime |
|
EMAccrualDetail |
ModUser |
varchar(20) |
|
EMCompany |
CreateDate |
datetime |
|
EMCompany |
CreateUser |
varchar(20) |
|
EMCompany |
ModDate |
datetime |
|
EMCompany |
ModUser |
varchar(20) |
|
EMMain |
PIMID |
varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
|
EMMain |
QBOAddressID |
varchar(18) |
|
EMMain |
QBOID |
varchar(18) |
|
EMMain |
QBOLastUpdated |
datetime |
|
EMMain |
QBOVendorID |
varchar(18) |
|
erControl |
Description |
varchar(40) |
|
exControl |
Description |
varchar(40) |
|
Form1099Data |
FATCAFillingRequirement |
varchar(1) NOT NULL default ('N') |
|
FormW2Data |
DetroitLocalityIndicator |
varchar(10) |
|
FW_CFGSystem |
AutoUtilSchedWithProbCode |
smallint NOT NULL default (0) |
|
FW_CFGSystem |
EnableContractMgmt |
varchar(1) NOT NULL default ('N') |
|
FW_CFGSystem |
HeyDeltekEnabled |
varchar(1) NOT NULL default ('N') |
|
FW_CFGSystem |
HMRCClientID |
varchar(255) |
|
FW_CFGSystem |
HMRCClientSecret |
varchar(255) |
|
FW_CFGSystem |
HMRCURL |
varchar(255) |
|
FW_CFGSystem |
TestOrgSetup |
varchar(1) NOT NULL default ('Y') |
|
FW_CFGSystem |
UtilizationScheduleFlg |
varchar(1) NOT NULL default ('N') |
|
FW_Files |
ModDate |
datetime |
|
FW_Files |
ModUser |
varchar(20) |
|
FW_InfoCenterTabsData |
PageID |
varchar(50) |
|
FW_MasterJobs |
ProcessNotification |
varchar(1) NOT NULL default ('N') |
|
inControl |
Description |
varchar(40) |
|
jeControl |
Description |
varchar(40) |
|
jeMaster |
AllowAssetEntries |
varchar(1) NOT NULL default ('N') |
|
laControl |
Description |
varchar(40) |
|
miControl |
Description |
varchar(40) |
|
PR, PRDefaults, PRTemplate |
AllocMethod |
varchar(1) |
|
PR, PRDefaults, PRTemplate |
BusinessDeveloperLead |
varchar(20) |
|
PR, PRDefaults, PRTemplate |
CloseDate |
datetime |
|
PR, PRDefaults, PRTemplate |
ClosedNotes |
varchar(max) |
|
PR, PRDefaults, PRTemplate |
ClosedReason |
varchar(10) |
|
PR, PRDefaults, PRTemplate |
CustomCurrencyCode |
varchar(3) |
|
PR, PRDefaults, PRTemplate |
EstConstructionCost |
decimal(19,4) NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
EstEndDate |
datetime |
|
PR, PRDefaults, PRTemplate |
EstFees |
decimal(19,4) NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
EstStartDate |
datetime |
|
PR, PRDefaults, PRTemplate |
IQID |
varchar(50) |
|
PR, PRDefaults, PRTemplate |
IQLastUpdate |
datetime |
|
PR, PRDefaults, PRTemplate |
LabBillTable |
int NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
LabCostTable |
int NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
LostTo |
varchar(32) |
|
PR, PRDefaults, PRTemplate |
MarketingCoordinator |
varchar(20) |
|
PR, PRDefaults, PRTemplate |
OpenDate |
datetime |
|
PR, PRDefaults, PRTemplate |
PeriodOfPerformance |
decimal(19,5) NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
PIMID |
varchar(32) NOT NULL default (left(replace(newid(),'-',''),(32)) |
|
PR, PRDefaults, PRTemplate |
PreAwardWBS1 |
varchar(30) |
|
PR, PRDefaults, PRTemplate |
Probability |
smallint NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
ProposalManager |
varchar(20) |
|
PR, PRDefaults, PRTemplate |
PublicNoticeDate |
datetime |
|
PR, PRDefaults, PRTemplate |
Revenue |
decimal(19,4) NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
SFID |
varchar(18) |
|
PR, PRDefaults, PRTemplate |
SFLastModifiedDate |
datetime |
|
PR, PRDefaults, PRTemplate |
SiblingWBS1 |
varchar(30) |
|
PR, PRDefaults, PRTemplate |
SolicitationNum |
varchar(30) |
|
PR, PRDefaults, PRTemplate |
Source |
varchar(10) |
|
PR, PRDefaults, PRTemplate |
Stage |
varchar(10) |
|
PR, PRDefaults, PRTemplate |
Timescale |
varchar(1) |
|
PR, PRDefaults, PRTemplate |
TotalContractValue |
decimal(19,5) NOT NULL default (0) |
|
PR, PRDefaults, PRTemplate |
UtilizationScheduleFlg |
varchar(1) NOT NULL default ('N') |
|
PR, PRDefaults, PRTemplate |
WeightedRevenue |
decimal(19,4) NOT NULL default (0) |
|
prControl |
Description |
varchar(40) |
|
SavedOptionsDetail |
Condition |
varchar(3) |
|
SavedOptionsDetail |
SearchLevel |
int |
|
SavedOptionsDetail |
TableName |
varchar(255) |
|
SavedReportsMain |
Private |
varchar(1) NOT NULL default ('Y') |
|
SavedReportsMain |
ReportDescription |
varchar(max) |
|
SavedReportsMain |
ReportOptionApplication |
varchar(1) NOT NULL default ('N') |
|
SavedSelectionsMain |
Folder |
varchar(255) |
|
SavedSelectionsMain |
LinkedPKey |
varchar(32) |
|
SavedSelectionsMain |
Private |
varchar(1) NOT NULL default ('Y') |
|
SE |
AllowedPRCreateTypes |
varchar(10) |
|
SE |
AllowPRPromoCreate |
varchar(1) NOT NULL default ('Y') |
|
SE |
AllowSOAPAPIAccess |
varchar(1) NOT NULL default ('N') |
|
SE |
DashboardAdmin |
varchar(1) NOT NULL default ('N') |
|
SE |
OrgRowLevelID |
varchar(32) |
|
SECompany |
CreateDate |
datetime |
|
SECompany |
CreateUser |
varchar(20) |
|
SECompany |
ModDate |
datetime |
|
SECompany |
ModUser |
varchar(20) |
|
SEInfoCenter |
RowLevelReadId |
varchar(32) |
|
SEInfoCenter |
RowLevelUpdateId |
varchar(32) |
|
tsControl |
Description |
varchar(40) |
|
unControl |
Description |
varchar(40) |
|
UNTable |
CreateDate |
datetime |
|
UNTable |
CreateUser |
varchar(20) |
|
UNTable |
ModDate |
datetime |
|
UNTable |
ModUser |
varchar(20) |
|
UNUnit |
CreateDate |
datetime |
|
UNUnit |
CreateUser |
varchar(20) |
|
UNUnit |
ModDate |
datetime |
|
UNUnit |
ModUser |
varchar(20) |
|
upControl |
Description |
varchar(40) |
|
Table Name |
Column Name |
New DataType |
Old DataType |
|
AlertsDescriptions |
AlertName |
varchar(100) NOT NULL |
varchar(50) NOT NULL |
|
APApprovalMaster |
opBatch |
varchar(32) |
varchar(30) |
|
apControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
apControlDefaultTaxCodes |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
apDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
apDetailTax |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
APDocuments |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
APDocumentsDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
apMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
AuditTrail |
AuditID |
bigint NOT NULL |
uniqueidentifier NOT NULL default (newid() |
|
billConDetail |
UOM |
varchar(20) |
varchar(30) |
|
billExpDetail |
UOM |
varchar(20) |
varchar(30) |
|
BT |
Notes |
varchar(max) |
varchar(255) |
|
cdControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cdControlDefaultTaxCodes |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cdDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cdDetailTax |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cdMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
CFGActivityTypeDescriptions |
ActivityType |
varchar(25) NOT NULL |
varchar(15) NOT NULL |
|
CFGAPMain |
PrintRemit |
varchar(2) |
varchar(1) |
|
CFGARLedgerHeadingsDescriptions |
Label |
varchar(20) |
varchar(12) |
|
CFGBankEntriesCodeData |
Code |
varchar(10) NOT NULL |
varchar(2) NOT NULL |
|
CFGBankEntriesCodeDescriptions |
Code |
varchar(10) NOT NULL |
varchar(2) NOT NULL |
|
CFGBankIDTypeDescriptions |
Description |
varchar(100) NOT NULL |
varchar(50) NOT NULL |
|
CFGBillMainDescriptions |
AddOnLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
ConLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
ExpLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
FeeLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
InterestLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
LabLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
TaxLabel |
varchar(25) |
varchar(15) |
|
CFGBillMainDescriptions |
UnitLabel |
varchar(25) |
varchar(15) |
|
CFGNAICSDescriptions |
Description |
varchar(150) NOT NULL |
varchar(120) NOT NULL |
|
CFGPostControl |
Batch |
varchar(32) |
varchar(30) |
|
CFGPrefixDescriptions |
Prefix |
varchar(20) NOT NULL |
varchar(10) NOT NULL |
|
CFGProjectCodeDescriptions |
Description |
varchar(150) NOT NULL |
varchar(100) NOT NULL |
|
CFGPYWHMethodDescriptions |
Label |
varchar(20) |
varchar(10) |
|
CFGPYWHTypeDescriptions |
Label |
varchar(20) |
varchar(10) |
|
CFGRGMethodsDescriptions |
Description |
varchar(70) |
varchar(40) |
|
CFGScreenDesignerData |
ComponentType |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
CFGServiceProfileDescriptions |
Description |
varchar(50) NOT NULL |
varchar(40) NOT NULL |
|
Clendor |
AvailableForCRM |
varchar(1) NOT NULL default ('Y') |
varchar(1) NOT NULL default ('N') |
|
crControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
crDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
crMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
CustomProposal |
Name |
varchar(100) |
varchar(50) |
|
cvControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cvControlDefaultTaxCodes |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cvDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cvDetailTax |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
CVDocuments |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
CVDocumentsDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
cvMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
EMProjectAssocTemplate |
WBS1 |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
erControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
erDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
erMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
exControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
exControlDefaultTaxCodes |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
exDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
exDetailTax |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
exMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
FW_CFGCountryDesc |
Country |
varchar(50) NOT NULL |
varchar(40) NOT NULL |
|
FW_CFGCurrencyDesc |
Description |
varchar(50) |
varchar(30) |
|
FW_CFGCurrencyDesc |
MajorUnitLabelPlural |
varchar(20) |
varchar(15) |
|
FW_CFGCurrencyDesc |
MajorUnitLabelSingular |
varchar(20) |
varchar(15) |
|
FW_CFGCurrencyDesc |
MinorUnitLabelPlural |
varchar(20) |
varchar(15) |
|
FW_CFGCurrencyDesc |
MinorUnitLabelSingular |
varchar(20) |
varchar(15) |
|
ICBillingWK |
CostJEBatch |
varchar(32) |
varchar(30) |
|
ICBillingWK |
InvoiceBatch |
varchar(32) |
varchar(30) |
|
ICBillingWK |
JEBatch |
varchar(32) |
varchar(30) |
|
ICBillingWK |
LABatch |
varchar(32) |
varchar(30) |
|
ICBillingWK |
ReclassBatch |
varchar(32) |
varchar(30) |
|
ICBillingWK |
TaxJEBatch |
varchar(32) |
varchar(30) |
|
ICBillingWK |
VoucherBatch |
varchar(32) |
varchar(30) |
|
inControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
inDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
inMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
jeControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
jeControlRecurFrequency |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
jeDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
jeDetailTax |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
jeMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
laControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
laDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
laMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
miControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
miDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
miMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
prControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
prDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
prMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
SavedOptionsDetail |
Value |
varchar(max) |
varchar(255) |
|
SEUser |
DefaultPrinter |
varchar(80) NOT NULL default ('<local printer>') |
varchar(80) |
|
SPMessages |
MessageText |
varchar(400) |
varchar(250) |
|
TaxLocaleDescriptions |
Description |
varchar(50) |
varchar(30) |
|
tsControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
tsDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
tsMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
unControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
unDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
UNDocuments |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
UNDocumentsDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
unMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
upControl |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
upDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
UPDocuments |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
UPDocumentsDetail |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
upMaster |
Batch |
varchar(32) NOT NULL |
varchar(30) NOT NULL |
|
Table Name |
Column Name |
DataType |
|
apControl |
AllowAssetEntries |
varchar(1) NOT NULL default ('N') |
|
CFGBankEntriesCodeData |
BankCode |
varchar(10) NOT NULL |
|
CFGBankEntriesCodeDescriptions |
BankCode |
varchar(10) NOT NULL |
|
CFGBankImport |
ImportEnabled |
varchar(1) NOT NULL default ('N') |
|
CFGBankTextFormat |
BankCode |
varchar(10) NOT NULL |
|
CFGScreenDesignerLabels |
ColPos |
int NOT NULL default (0) |
|
CFGScreenDesignerLabels |
ColWidth |
int NOT NULL default (0) |
|
CFGScreenDesignerLabels |
LabelPosition |
varchar(1) |
|
CFGScreenDesignerLabels |
RowHeight |
int NOT NULL default (0) |
|
CFGScreenDesignerLabels |
RowPos |
int NOT NULL default (0) |
|
CFGVendorTypeData |
PeriodsToRetain |
smallint NOT NULL default (0) |
|
CFGVendorTypeData |
ProjectRetain |
varchar(1) |
|
Clendor |
Accounting |
varchar(1) NOT NULL default ('Y') |
|
Clendor |
CRM |
varchar(1) NOT NULL default ('Y') |
|
Contacts |
OpportunityDescription |
varchar(255) |
|
EMMain |
WorkPhoneExt |
varchar(8) |
|
FW_CFGSystem |
AuditingEnabledLead |
varchar(1) NOT NULL default ('N') |
|
FW_CFGSystem |
AuditingEnabledOP |
varchar(1) NOT NULL default ('N') |
|
FW_CFGSystem |
AuditingEnabledVE |
varchar(1) NOT NULL default ('N') |
|
jeControl |
AllowAssetEntries |
varchar(1) NOT NULL default ('N') |
|
SE |
ActivityAccess |
varchar(1) NOT NULL default ('F') |
|
SE |
ActivityReadWhere |
varchar(max) |
|
SE |
ActivityUpdateWhere |
varchar(max) |
|
Table Name |
New Column Name |
Old Column Name |
|
None |
|
|
|
Object Name |
Object Type |
|
PR$ValidateWBS1 |
Function |
|
stRP$tabLaborCodeSubcodes |
Function |
|
stRP$tabPlanValidate |
Function |
|
AddIndustryDefaultsAEdeDE |
Stored Proc |
|
AddIndustryDefaultsAEenGB |
Stored Proc |
|
AddIndustryDefaultsAEenUS |
Stored Proc |
|
AddIndustryDefaultsAEesES |
Stored Proc |
|
AddIndustryDefaultsAEfrCA |
Stored Proc |
|
AddIndustryDefaultsAEfrFR |
Stored Proc |
|
AddIndustryDefaultsAEnlNL |
Stored Proc |
|
AddIndustryDefaultsAEptBR |
Stored Proc |
|
AddIndustryDefaultsConsultdeDE |
Stored Proc |
|
AddIndustryDefaultsConsultenGB |
Stored Proc |
|
AddIndustryDefaultsConsultenUS |
Stored Proc |
|
AddIndustryDefaultsConsultesES |
Stored Proc |
|
AddIndustryDefaultsConsultfrCA |
Stored Proc |
|
AddIndustryDefaultsConsultfrFR |
Stored Proc |
|
AddIndustryDefaultsConsultnlNL |
Stored Proc |
|
AddIndustryDefaultsConsultptBR |
Stored Proc |
|
DeleteActivity |
Stored Proc |
|
LoadSEFieldDefaults |
Stored Proc |
|
PNConvertCompliedVisionPlans2iAccess |
Stored Proc |
|
PNConvertOneVisionPlan2iAccess |
Stored Proc |
|
QBClearAll |
Stored Proc |
|
RPSyncMultiplePR_Plan |
Stored Proc |
|
RPSyncWBSStructure |
Stored Proc |
|
stRPAddJTDAssignmentForResource |
Stored Proc |
|
stRPConvertFromOpp2ExistingPR |
Stored Proc |
|
stRPConvertMilestonesFromOppToPR |
Stored Proc |
|
stRPConvertOpp2PR_Main |
Stored Proc |
|
stRPConvertOppUDIC2PR |
Stored Proc |
|
stRPConvertStagesFromOppToPR |
Stored Proc |
|
stRPCreatePRFromUnlinkedOpp |
Stored Proc |
|
stRPRemoveOppRelatedData |
Stored Proc |
|
CFGProjectMilestone |
View |
|
CFGProjectStage |
View |
|
CFGProposalCategory |
View |
|
ClendorProjectAssocReporting |
View |
|
RecurringActivities |
View |
|
TransactionUDF |
View |
|
Object Name |
Object Type |
|
getICMetadata |
Function |
|
DeleteOpportunity |
Stored Proc |
|
LoadIndustryDefaultsMarCom |
Stored Proc |
|
LoadInfoCenterFieldsDescdeDE |
Stored Proc |
|
LoadInfoCenterFieldsDescenGB |
Stored Proc |
|
LoadInfoCenterFieldsDescenUS |
Stored Proc |
|
LoadInfoCenterFieldsDescesES |
Stored Proc |
|
LoadInfoCenterFieldsDescfrCA |
Stored Proc |
|
LoadInfoCenterFieldsDescfrFR |
Stored Proc |
|
LoadInfoCenterFieldsDescnlNL |
Stored Proc |
|
LoadInfoCenterFieldsDescptBR |
Stored Proc |
|
sp_AssocOppWithCampaignsLeadConvert |
Stored Proc |
|
DefaultNavigatorSettingsInsertSEUser |
Trigger |
|
stRPSyncOpportunityTrigger |
Trigger |
|
CFGMobileFields |
View |
|
CFGOpportunityStage |
View |
|
CFGOpportunityStatus |
View |
|
FW_CFGInfoCenterFields |
View |
|
OpportunityVEAssoc |
View |
|
Object Name |
|
None |