24 new Exact Online tables
The following 24 new tables have been added to the Invantive UniversalSQL-driver for Exact Online, bringing the total number of tables to 1.213:
EmployeesIncrementalEmploymentCLAsIncrementalEmploymentContractsIncrementalEmploymentOrganizationsIncrementalEmploymentSalariesIncrementalEmploymentTaxAuthoritiesGeneralIncrementalEmploymentsIncrementalInternalPaymentsItemStorageLocationsIncrementalPayrollBankAccountsIncrementalRestoreEmploymentShopOrdersIncrementalShopOrderMaterialPlansIncrementalShopOrderRoutingStepPlansIncrementalStorageLocationStockPositionsSyncEmployeesSyncEmploymentCLAsSyncEmploymentContractsSyncEmploymentOrganizationsSyncEmploymentSalariesSyncEmploymentTaxAuthoritiesGeneralSyncEmploymentsSyncItemStorageLocationsSyncPayrollBankAccounts
New columns
The following columns are new:
| Table | Column |
|---|---|
AccountsBulk |
PeppolIdentifierType |
AccountsBulk |
PeppolIdentifier |
AccountsFullTextSearch |
PeppolIdentifierType |
AccountsFullTextSearch |
PeppolIdentifier |
AccountsRead |
PeppolIdentifierType |
AccountsRead |
PeppolIdentifier |
Accounts |
PeppolIdentifierType |
Accounts |
PeppolIdentifier |
CostEntryExpensesByProject |
DefaultItemCode |
CostEntryExpensesByProject |
DefaultItemDescription |
CostEntryExpensesByProject |
DefaultItem |
CostEntryRecentExpensesByProject |
DefaultItemCode |
CostEntryRecentExpensesByProject |
DefaultItemDescription |
CostEntryRecentExpensesByProject |
DefaultItem |
DirectDebitMandates |
AttachmentFileName |
DirectDebitMandates |
Attachment |
Employees |
PictureThumbnailUrl |
Employees |
Picture |
EmploymentContracts |
EmploymentNumber |
EmploymentOrganizations |
EmploymentNumber |
EmploymentSalaries |
AmountTypeDescription |
EmploymentSalaries |
AmountType |
EmploymentSalaries |
BillabilityTarget |
EmploymentSalaries |
Description |
EmploymentSalaries |
EmploymentNumber |
EmploymentSalaries |
ExternalRate |
EmploymentSalaries |
FrequencyDescription |
EmploymentSalaries |
IntercompanyRate |
EmploymentSalaries |
SalaryBasedTypeDescription |
EmploymentSalaries |
SalaryBasedType |
EmploymentSalaries |
WageScalePeriod |
EmploymentSalaries |
WageScaleStep |
EmploymentSalaries |
WageScale |
EmploymentTaxAuthoritiesGeneral |
EmploymentNumber |
Employments |
EmploymentNumber |
HourEntryActivitiesByProject |
DefaultItemCode |
HourEntryActivitiesByProject |
DefaultItemDescription |
HourEntryActivitiesByProject |
DefaultItem |
HourEntryRecentActivitiesByProject |
DefaultItemCode |
HourEntryRecentActivitiesByProject |
DefaultItemDescription |
HourEntryRecentActivitiesByProject |
DefaultItem |
LeaveAbsenceHoursByDay |
ExternalLeaveAbsenceType |
MailMessagesReceived |
SkipRecipientMailBoxAddressOverride |
MailMessagesSent |
SkipRecipientMailBoxAddressOverride |
Me |
PackageCode |
Projects |
BlockInvoicing |
PurchaseInvoiceLines |
AmountDC |
PurchaseInvoices |
AmountDC |
PurchaseOrders |
AmountDiscountExclVat |
PurchaseOrders |
AmountDiscount |
PurchaseOrders |
AmountFCExclVat |
PurchaseOrders |
Discount |
RestoreEmployment |
EmployeeFullName |
RestoreEmployment |
EmployeeHID |
RestoreEmployment |
Employee |
RestoreEmployment |
EmploymentEndDate |
RestoreEmployment |
ID |
RestoreEmployment |
IsAnonymized |
RestoreEmployment |
ReasonEndFlex |
RestoreEmployment |
ReasonEnd |
ShopOrders |
ShopOrderMaterialPlansNonIssuedByproductsCount |
ShopOrders |
ShopOrderMaterialPlansNonIssuedMaterialsCount |
SyncAccounts |
PeppolIdentifierType |
SyncAccounts |
PeppolIdentifier |
SyncProjects |
BlockInvoicing |
SyncPurchaseOrderLines |
AmountDiscountExclVat |
SyncPurchaseOrderLines |
AmountDiscount |
SyncPurchaseOrderLines |
AmountFCExclVat |
SyncStorageLocationStockPositions |
QuantityToPicked |
SyncStorageLocationStockPositions |
ReservedPick |
SyncStorageLocationStockPositions |
SerialBatchReservedStock |
TimeAndBillingActivitiesAndExpenses |
DefaultItemCode |
TimeAndBillingActivitiesAndExpenses |
DefaultItemDescription |
TimeAndBillingActivitiesAndExpenses |
DefaultItem |
TimeAndBillingEntryRecentActivitiesAndExpenses |
DefaultItemCode |
TimeAndBillingEntryRecentActivitiesAndExpenses |
DefaultItemDescription |
TimeAndBillingEntryRecentActivitiesAndExpenses |
DefaultItem |
WBSActivities |
ReleaseInvoiceTermDate |
WBSActivities |
ReleaseInvoiceTermHasSpecifyDate |
WBSActivities |
ReleaseInvoiceTerm |
WBSExpenses |
Completed |
WBSExpenses |
ReleaseInvoiceTermDate |
WBSExpenses |
ReleaseInvoiceTermHasSpecifyDate |
WBSExpenses |
ReleaseInvoiceTerm |
Availability
The new tables and columns are available starting release 24.0.157. The availability on Invantive Cloud is scheduled for the week of April 29, 2024.
Documentation
The documentation of the Exact Online SQL-driver is available at:
A graphical overview is available as PDF on: