24 nuevas tablas en Exact Online y 84 nuevas columnas en tablas existentes

24 nuevas tablas de Exact Online

Se han añadido las siguientes 24 nuevas tablas al controlador Invantive UniversalSQL para Exact Online, elevando el número total de tablas a 1.213:

  • EmployeesIncremental
  • EmploymentCLAsIncremental
  • EmploymentContractsIncremental
  • EmploymentOrganizationsIncremental
  • EmploymentSalariesIncremental
  • EmploymentTaxAuthoritiesGeneralIncremental
  • EmploymentsIncremental
  • InternalPayments
  • ItemStorageLocationsIncremental
  • PayrollBankAccountsIncremental
  • RestoreEmployment
  • ShopOrdersIncremental
  • ShopOrderMaterialPlansIncremental
  • ShopOrderRoutingStepPlansIncremental
  • StorageLocationStockPositions
  • SyncEmployees
  • SyncEmploymentCLAs
  • SyncEmploymentContracts
  • SyncEmploymentOrganizations
  • SyncEmploymentSalaries
  • SyncEmploymentTaxAuthoritiesGeneral
  • SyncEmployments
  • SyncItemStorageLocations
  • SyncPayrollBankAccounts

Columnas nuevas

Las siguientes columnas son nuevas:

Tabla Columna
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

Disponibilidad

Las nuevas tablas y columnas están disponibles a partir de la versión 24.0.157. La disponibilidad en Invantive Cloud está prevista para la semana del 29 de abril de 2024.

Documentación

La documentación del controlador SQL de Exact Online está disponible en:

Una vista general gráfica está disponible en formato PDF en: