| AccountingControlCenterClosing | AssignedTo | nvarchar(max) |
| AccountingControlCenterClosing | Category | nvarchar(100) NOT NULL |
| AccountingControlCenterClosing | Comments | nvarchar(max) |
| AccountingControlCenterClosing | Company | nvarchar(14) |
| AccountingControlCenterClosing | CreateDate | datetime |
| AccountingControlCenterClosing | CreateUser | nvarchar(32) |
| AccountingControlCenterClosing | FiscalPeriod | int NOT NULL |
| AccountingControlCenterClosing | Hidden | varchar(1) NOT NULL |
| AccountingControlCenterClosing | LastPosting | datetime |
| AccountingControlCenterClosing | ModDate | datetime |
| AccountingControlCenterClosing | ModUser | nvarchar(32) |
| AccountingControlCenterClosing | PKey | varchar(32) NOT NULL |
| AccountingControlCenterClosing | Postings | char(1) |
| AccountingControlCenterClosing | Process | nvarchar(100) NOT NULL |
| AccountingControlCenterClosing | Status | char(1) NOT NULL |
| AccountingControlCenterClosing | Type | char(1) NOT NULL |
| ApiAuthorization | ModuleID | varchar(10) |
| CancelledInvoices | CancelledBy | nvarchar(32) |
| CancelledInvoices | CancelledDate | datetime NOT NULL |
| CancelledInvoices | Invoice | nvarchar(12) NOT NULL |
| CancelledInvoices | WBS1 | nvarchar(30) NOT NULL |
| CancelledInvoices | WorkflowID | nvarchar(32) NOT NULL |
| CFGApprovalType | AllowCancel | bit NOT NULL |
| CFGBanks | SEPABuildingNumber | nvarchar(16) |
| CFGBanks | SEPAPostCode | nvarchar(16) |
| CFGBanks | SEPAStreetName | nvarchar(70) |
| CFGBanks | SEPATownName | nvarchar(35) |
| CFGGlobalSharedServices | AssistantV3URL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | AssistantV4URL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | AuthKeyName | nvarchar(50) NOT NULL |
| CFGGlobalSharedServices | AuthURL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | DocumentSearchURL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | GPTURL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | IDRURL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | Region | varchar(5) NOT NULL |
| CFGGlobalSharedServices | RegisterURL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | TokenExchangeURL | nvarchar(255) NOT NULL |
| CFGGlobalSharedServices | VPMCPURL | nvarchar(255) NOT NULL |
| CFGInsightTypeCompletedSteps | Step | varchar(50) NOT NULL |
| CFGInsightTypeCompletedSteps | Type | varchar(50) NOT NULL |
| CFGInsightTypesEnabled | Active | bit NOT NULL |
| CFGModuleConfiguration | IsIntegration | bit NOT NULL |
| CFGPursuitScoreLevels | Description | nvarchar(500) |
| CFGPursuitScoreLevels | FromScore | decimal(3,1) NOT NULL |
| CFGPursuitScoreLevels | LevelID | varchar(32) NOT NULL |
| CFGPursuitScoreLevels | PKey | int NOT NULL |
| CFGPursuitScoreLevels | Title | nvarchar(250) |
| CFGPursuitScoreLevels | ToScore | decimal(3,1) NOT NULL |
| CFGRMSettings | DayScaleTablePopulatingStatus | varchar(1) NOT NULL |
| CFGRMSettings | ProcessingStartedAt | datetime |
| CFGRMSettings | UseDayScaleTableForPlanning | varchar(1) NOT NULL |
| crDetail | Document | nvarchar(max) |
| crDetail | DocumentToolTipColumn | nvarchar(max) |
| CRDocuments | AssociateNew | char(1) NOT NULL |
| CRDocuments | Batch | nvarchar(32) NOT NULL |
| CRDocuments | FileApplicationType | nvarchar(250) |
| CRDocuments | FileDescription | nvarchar(500) |
| CRDocuments | FileDescriptionSaved | nvarchar(500) |
| CRDocuments | FileID | uniqueidentifier NOT NULL |
| CRDocuments | FileName | nvarchar(250) |
| CRDocuments | FileNameSaved | nvarchar(250) |
| CRDocuments | MasterPKey | nvarchar(32) NOT NULL |
| CRDocuments | Seq | int NOT NULL |
| CRDocumentsDetail | Batch | nvarchar(32) NOT NULL |
| CRDocumentsDetail | DetailPKey | nvarchar(44) NOT NULL |
| CRDocumentsDetail | FileID | uniqueidentifier NOT NULL |
| CRDocumentsDetail | MasterPKey | nvarchar(32) NOT NULL |
| CustomDashpart | Description | nvarchar(max) |
| EMCompany | SEPABuildingNumber | nvarchar(16) |
| EMCompany | SEPACountry | nvarchar(2) |
| EMCompany | SEPAPostCode | nvarchar(16) |
| EMCompany | SEPAStreetName | nvarchar(70) |
| EMCompany | SEPATownName | nvarchar(35) |
| FW_CFGSystem | AccountingControlCenterEffectivePeriod | int |
| FW_CFGSystem | EnableAccountingControlCenter | char(1) NOT NULL |
| FW_CustomColumnsData | Description | nvarchar(max) |
| FW_CustomGridsData | Description | nvarchar(max) |
| FW_FileDeletionQueue | FileID | uniqueidentifier NOT NULL |
| FW_FileDeletionQueue | StorageProvider | varchar(20) NOT NULL |
| FW_UDICData | Description | nvarchar(max) |
| IDRJobQueue | UICultureName | varchar(10) |
| IntegrationTransactionMapping | Account | nvarchar(13) |
| IntegrationTransactionMapping | Application | nvarchar(250) NOT NULL |
| IntegrationTransactionMapping | EarningCode | nvarchar(100) |
| IntegrationTransactionMapping | OrgLevel1 | nvarchar(30) |
| IntegrationTransactionMapping | OrgLevel2 | nvarchar(30) |
| IntegrationTransactionMapping | OrgLevel3 | nvarchar(30) |
| IntegrationTransactionMapping | OrgLevel4 | nvarchar(30) |
| IntegrationTransactionMapping | OrgLevel5 | nvarchar(30) |
| IntegrationTransactionMapping | PKey | int NOT NULL |
| IntegrationTransactionMapping | UID | varchar(32) NOT NULL |
| IntegrationTransactionMapping | WBS1 | nvarchar(30) |
| IntegrationTransactionMapping | WBS2 | nvarchar(30) |
| IntegrationTransactionMapping | WBS3 | nvarchar(30) |
| IntegrationTransactionSettings | Application | nvarchar(250) NOT NULL |
| IntegrationTransactionSettings | CreateTransactionEntry | bit NOT NULL |
| IntegrationTransactionSettings | Payee | nvarchar(50) |
| IntegrationTransactionSettings | Payment | nvarchar(50) |
| IntegrationTransactionSettings | TransType | nvarchar(2) |
| PRPursuitScore | GeneratedDate | datetime NOT NULL |
| PRPursuitScore | PKey | int NOT NULL |
| PRPursuitScore | PRUID | nvarchar(32) NOT NULL |
| PRPursuitScore | Score | decimal(5,2) NOT NULL |
| PRPursuitScoreFactors | FactorID | varchar(32) NOT NULL |
| PRPursuitScoreFactors | PKey | int NOT NULL |
| PRPursuitScoreFactors | PRUID | nvarchar(32) NOT NULL |
| PRPursuitScoreFactors | Reason | nvarchar(max) |
| PRPursuitScoreFactors | Score | smallint NOT NULL |
| PRPursuitScoreFactors | Skipped | bit NOT NULL |
| PRPursuitScoreFactors | Value | nvarchar(max) |
| RPConsultantDayTPD | ConsultantID | varchar(32) |
| RPConsultantDayTPD | CreateDate | datetime |
| RPConsultantDayTPD | CreateUser | nvarchar(42) |
| RPConsultantDayTPD | DayID | bigint NOT NULL |
| RPConsultantDayTPD | PlanID | varchar(32) NOT NULL |
| RPConsultantDayTPD | PlannedBill | decimal(19,4) NOT NULL |
| RPConsultantDayTPD | PlannedCost | decimal(19,4) NOT NULL |
| RPConsultantDayTPD | PlannedDate | datetime NOT NULL |
| RPConsultantDayTPD | TaskID | varchar(32) NOT NULL |
| RPDailyAssignmentRecords | AssignmentID | varchar(32) |
| RPDailyAssignmentRecords | ID | bigint NOT NULL |
| RPDailyAssignmentRecords | IsPublished | bit NOT NULL |
| RPDailyAssignmentRecords | PlanID | varchar(32) NOT NULL |
| RPDailyAssignmentRecords | TaskID | varchar(32) |
| RPDailyConsultantRecords | ConsultantID | varchar(32) |
| RPDailyConsultantRecords | ID | bigint NOT NULL |
| RPDailyConsultantRecords | IsPublished | bit NOT NULL |
| RPDailyConsultantRecords | PlanID | varchar(32) NOT NULL |
| RPDailyConsultantRecords | TaskID | varchar(32) |
| RPDailyExpenseRecords | ExpenseID | varchar(32) |
| RPDailyExpenseRecords | ID | bigint NOT NULL |
| RPDailyExpenseRecords | IsPublished | bit NOT NULL |
| RPDailyExpenseRecords | PlanID | varchar(32) NOT NULL |
| RPDailyExpenseRecords | TaskID | varchar(32) |
| RPDailyUnitRecords | ID | bigint NOT NULL |
| RPDailyUnitRecords | IsPublished | bit NOT NULL |
| RPDailyUnitRecords | PlanID | varchar(32) NOT NULL |
| RPDailyUnitRecords | TaskID | varchar(32) |
| RPDailyUnitRecords | UnitID | varchar(32) |
| RPExpenseDayTPD | CreateDate | datetime |
| RPExpenseDayTPD | CreateUser | nvarchar(42) |
| RPExpenseDayTPD | DayID | bigint NOT NULL |
| RPExpenseDayTPD | ExpenseID | varchar(32) |
| RPExpenseDayTPD | PlanID | varchar(32) NOT NULL |
| RPExpenseDayTPD | PlannedBill | decimal(19,4) NOT NULL |
| RPExpenseDayTPD | PlannedCost | decimal(19,4) NOT NULL |
| RPExpenseDayTPD | PlannedDate | datetime NOT NULL |
| RPExpenseDayTPD | TaskID | varchar(32) NOT NULL |
| RPLaborDayTPD | AssignmentID | varchar(32) |
| RPLaborDayTPD | CreateDate | datetime |
| RPLaborDayTPD | CreateUser | nvarchar(42) |
| RPLaborDayTPD | DayID | bigint NOT NULL |
| RPLaborDayTPD | PlanID | varchar(32) NOT NULL |
| RPLaborDayTPD | PlannedBill | decimal(19,4) NOT NULL |
| RPLaborDayTPD | PlannedCost | decimal(19,4) NOT NULL |
| RPLaborDayTPD | PlannedDate | datetime NOT NULL |
| RPLaborDayTPD | PlannedHrs | decimal(19,4) NOT NULL |
| RPLaborDayTPD | TaskID | varchar(32) NOT NULL |
| RPUnitDayTPD | CreateDate | datetime |
| RPUnitDayTPD | CreateUser | nvarchar(42) |
| RPUnitDayTPD | DayID | bigint NOT NULL |
| RPUnitDayTPD | PlanID | varchar(32) NOT NULL |
| RPUnitDayTPD | PlannedBill | decimal(19,4) NOT NULL |
| RPUnitDayTPD | PlannedCost | decimal(19,4) NOT NULL |
| RPUnitDayTPD | PlannedDate | datetime NOT NULL |
| RPUnitDayTPD | PlannedQty | decimal(19,4) NOT NULL |
| RPUnitDayTPD | TaskID | varchar(32) NOT NULL |
| RPUnitDayTPD | UnitID | varchar(32) |
| VEAccounting | SEPABuildingNumber | nvarchar(16) |
| VEAccounting | SEPACountry | nvarchar(2) |
| VEAccounting | SEPAPostCode | nvarchar(16) |
| VEAccounting | SEPAStreetName | nvarchar(70) |
| VEAccounting | SEPATownName | nvarchar(35) |