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:
EmployeesIncrementalEmploymentCLAsIncrementalEmploymentContractsIncrementalEmploymentOrganizationsIncrementalEmploymentSalariesIncrementalEmploymentTaxAuthoritiesGeneralIncrementalEmploymentsIncrementalInternalPaymentsItemStorageLocationsIncrementalPayrollBankAccountsIncrementalRestoreEmploymentShopOrdersIncrementalShopOrderMaterialPlansIncrementalShopOrderRoutingStepPlansIncrementalStorageLocationStockPositionsSyncEmployeesSyncEmploymentCLAsSyncEmploymentContractsSyncEmploymentOrganizationsSyncEmploymentSalariesSyncEmploymentTaxAuthoritiesGeneralSyncEmploymentsSyncItemStorageLocationsSyncPayrollBankAccounts
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: