invantive documentation
Invantive Support ForumsLog In / Sign Up

SyncItems: Exact Online Items

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: Sync
  • Primary Keys: Timestamp
  • Label: Items

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/sync/Logistics/Items
  • Metadata: /api/v1/{division}/sync/Logistics/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 20,000
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table SyncItems are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AssembledLeadDays int32 itgen_eol_assembledleaddays
AverageCost double Average Cost
Barcode varchar2 Barcode
BatchQuantity double Batch Quantity
Class_01 varchar2 Classification 1
Class_02 varchar2 Classification 2
Class_03 varchar2 Classification 3
Class_04 varchar2 Classification 4
Class_05 varchar2 Classification 5
Class_06 varchar2 Classification 6
Class_07 varchar2 Classification 7
Class_08 varchar2 Classification 8
Class_09 varchar2 Classification 9
Class_10 varchar2 Classification 10
Code varchar2 Code
CopyRemarks int16 Copy Remarks
CostPriceCurrency varchar2 Cost Price Currency
CostPriceNew double Cost Price New
CostPriceStandard double Cost Price Standard
Created datetime Created
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator
CustomField varchar2 Custom Field
Description varchar2 Description
Division int32 Division
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
EndDate datetime End Date
ExtraDescription varchar2 Extra Description
FreeBoolField_01 char Free Boolean Field #1
FreeBoolField_02 char Free Boolean Field #2
FreeBoolField_03 char Free Boolean Field #3
FreeBoolField_04 char Free Boolean Field #4
FreeBoolField_05 char Free Boolean Field #5
FreeDateField_01 datetime Free Date Field #1
FreeDateField_02 datetime Free Date Field #2
FreeDateField_03 datetime Free Date Field #3
FreeDateField_04 datetime Free Date Field #4
FreeDateField_05 datetime Free Date Field #5
FreeNumberField_01 double Free Number Field #1
FreeNumberField_02 double Free Number Field #2
FreeNumberField_03 double Free Number Field #3
FreeNumberField_04 double Free Number Field #4
FreeNumberField_05 double Free Number Field #5
FreeNumberField_06 double Free Number Field #6
FreeNumberField_07 double Free Number Field #7
FreeNumberField_08 double Free Number Field #8
FreeTextField_01 varchar2 Free Text Field #1
FreeTextField_02 varchar2 Free Text Field #2
FreeTextField_03 varchar2 Free Text Field #3
FreeTextField_04 varchar2 Free Text Field #4
FreeTextField_05 varchar2 Free Text Field #5
FreeTextField_06 varchar2 Free Text Field #6
FreeTextField_07 varchar2 Free Text Field #7
FreeTextField_08 varchar2 Free Text Field #8
FreeTextField_09 varchar2 Free Text Field #9
FreeTextField_10 varchar2 Free Text Field #10
GLCosts guid GL Costs
GLCostsWorkInProgress guid itgen_eol_glcostsworkinprogress
GLRevenue guid GL Revenue
GLRevenueWorkInProgress guid itgen_eol_glrevenueworkinprogress
GLStock guid GL Account Stock
GrossWeight double Gross Weight
ID guid ID
IsBatchItem int16 Is Batch Item
IsFractionAllowedItem char Is Fraction Allowed on Item
IsMakeItem int16 Is Make Item
IsNewContract int16 Is New Contract
IsOnDemandItem int16 Is On-demand Item
IsPackageItem char Is Package Item
IsPurchaseItem char Is Purchase Item
IsRegistrationCodeItem int16 Is Registration Code Item
IsSalesItem char Is Sales Item
IsSerialItem char Is Serial Item
IsStockItem char Is Stock Item
IsSubcontractedItem char Is Subcontracted Item
IsTaxableItem int16 Is Taxable Item
IsTime int16 Is Time
IsWebshopItem int16 Is Webshop Item
ItemGroup guid Is Item Group
Modified datetime Modified
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier
NetWeight double Net Weight
NetWeightUnit varchar2 Net Weight Unit
Notes varchar2 Notes
Picture blob Picture
PictureName varchar2 Picture Name
PictureThumbnailUrl varchar2 Picture Thumbnail (URL)
PictureUrl varchar2 Picture (URL)
SalesVatCode varchar2 Sales VAT Code
SearchCode varchar2 Search Code
SecurityLevel int32 Security Level
StartDate datetime Start Date
StatisticalCode varchar2 Statistical Code Statistical code.
StatisticalNetWeight double Statistical Net Weight Netweight weight for statistical reporting.
StatisticalUnits double Statistical Units Units for statistical reporting.
StatisticalValue double Statistical Value Value for statistical reporting.
Stock double Stock
Timestamp int64 Timestamp filters on the platform
Unit varchar2 Unit
UnitType varchar2 Unit Type
UseExplosion int16 itgen_eol_useexplosion

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: