24 nieuwe Exact Online-tabellen
De volgende 24 nieuwe tabellen zijn toegevoegd aan de Invantive UniversalSQL-driver voor Exact Online, waarmee het totale aantal tabellen op 1.213 komt:
EmployeesIncrementalEmploymentCLAsIncrementalEmploymentContractsIncrementalEmploymentOrganizationsIncrementalEmploymentSalariesIncrementalEmploymentTaxAuthoritiesGeneralIncrementalEmploymentsIncrementalInternalPaymentsItemStorageLocationsIncrementalPayrollBankAccountsIncrementalRestoreEmploymentShopOrdersIncrementalShopOrderMaterialPlansIncrementalShopOrderRoutingStepPlansIncrementalStorageLocationStockPositionsSyncEmployeesSyncEmploymentCLAsSyncEmploymentContractsSyncEmploymentOrganizationsSyncEmploymentSalariesSyncEmploymentTaxAuthoritiesGeneralSyncEmploymentsSyncItemStorageLocationsSyncPayrollBankAccounts
Nieuwe kolommen
De volgende kolommen zijn nieuw:
| Tabel | Kolom |
|---|---|
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 |
Beschikbaarheid
De nieuwe tabellen en kolommen zijn beschikbaar vanaf release 24.0.157. De beschikbaarheid op Invantive Cloud staat gepland voor de week van 29 april 2024.
Documentatie
De documentatie van de Exact Online SQL-driver is beschikbaar op:
Een grafisch overzicht is beschikbaar als PDF op: