ItemsIncremental: Exact Online Artikelen (Incrementeel) |
Catalogus: ExactOnlineREST
Schema: Incremental
Primaire Sleutels: ID
Label: Artikelen (Incrementeel)
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Dit is een alleen-lezen view. De Exact Online API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Exact Online ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Exact Online-API.
View Kolommen
De kolommen van de view ItemsIncremental worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
AssembledLeadDays |
int32 |
{res:itgen_eol_assembledleaddays} |
☐ |
|
AverageCost |
double |
Gemiddelde Kosten |
☐ |
The current average cost price. |
Barcode |
string |
Barcode |
☐ |
Barcode of the item. |
BatchQuantity |
double |
Batchomvang |
☐ |
|
Class_01 |
string |
Classificatie 1 |
☐ |
Item class code referring to item class with class ID 1. |
Class_02 |
string |
Classificatie 2 |
☐ |
Item class code referring to item class with class ID 2. |
Class_03 |
string |
Classificatie 3 |
☐ |
Item class code referring to item class with class ID 3. |
Class_04 |
string |
Classificatie 4 |
☐ |
Item class code referring to item class with class ID 4. |
Class_05 |
string |
Classificatie 5 |
☐ |
Item class code referring to item class with class ID 5. |
Class_06 |
string |
Classificatie 6 |
☐ |
Item class code referring to item class with class ID 6. |
Class_07 |
string |
Classificatie 7 |
☐ |
Item class code referring to item class with class ID 7. |
Class_08 |
string |
Classificatie 8 |
☐ |
Item class code referring to item class with class ID 8. |
Class_09 |
string |
Classificatie 9 |
☐ |
Item class code referring to item class with class ID 9. |
Class_10 |
string |
Classificatie 10 |
☐ |
Item class code referring to item class with class ID 10. |
Code |
string |
Code |
☐ |
Item code. |
CopyRemarks |
int16 |
Kopie Opmerkingen |
☐ |
Copy sales remarks to sales lines. |
CostPriceCurrency |
string |
Kostprijsvaluta |
☐ |
The currency of the current and proposed cost price. |
CostPriceNew |
double |
Kostprijs Nieuw |
☐ |
Proposed cost price. |
CostPriceStandard |
double |
Standaard Kostprijs |
☐ |
The current standard cost price. |
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
Description |
string |
Omschrijving |
☐ |
Description of the item. |
Division |
int32 |
Divisie |
☑ |
Division code. |
EndDate |
datetime |
Einddatum |
☐ |
Together with StartDate this determines if the item is active. |
ExtraDescription |
string |
Extra Omschrijving |
☐ |
Extra description text, slightly longer than the regular description (255 instead of 60). |
FreeBoolField_01 |
boolean |
Vrij Booleaans Veld #1 |
☐ |
Free boolean field 1. |
FreeBoolField_02 |
boolean |
Vrij Booleaans Veld #2 |
☐ |
Free boolean field 2. |
FreeBoolField_03 |
boolean |
Vrij Booleaans Veld #3 |
☐ |
Free boolean field 3. |
FreeBoolField_04 |
boolean |
Vrij Booleaans Veld #4 |
☐ |
Free boolean field 4. |
FreeBoolField_05 |
boolean |
Vrij Booleaans Veld #5 |
☐ |
Free boolean field 5. |
FreeDateField_01 |
datetime |
Vrij Datumveld #1 |
☐ |
Free date field 1. |
FreeDateField_02 |
datetime |
Vrij Datumveld #2 |
☐ |
Free date field 2. |
FreeDateField_03 |
datetime |
Vrij Datumveld #3 |
☐ |
Free date field 3. |
FreeDateField_04 |
datetime |
Vrij Datumveld #4 |
☐ |
Free date field 4. |
FreeDateField_05 |
datetime |
Vrij Datumveld #5 |
☐ |
Free date field 5. |
FreeNumberField_01 |
double |
Vrij Numeriek Veld #8 |
☐ |
Free numeric field 1. |
FreeNumberField_02 |
double |
Vrij Numeriek Veld #2 |
☐ |
Free numeric field 2. |
FreeNumberField_03 |
double |
Vrij Numeriek Veld #3 |
☐ |
Free numeric field 3. |
FreeNumberField_04 |
double |
Vrij Numeriek Veld #4 |
☐ |
Free numeric field 4. |
FreeNumberField_05 |
double |
Vrij Numeriek Veld #5 |
☐ |
Free numeric field 5. |
FreeNumberField_06 |
double |
Vrij Numeriek Veld #6 |
☐ |
Free numeric field 6. |
FreeNumberField_07 |
double |
Vrij Numeriek Veld #7 |
☐ |
Free numeric field 7. |
FreeNumberField_08 |
double |
Vrij Numeriek Veld #8 |
☐ |
Free numeric field 8. |
FreeTextField_01 |
string |
Vrij Tekstveld #1 |
☐ |
Free text field 1. |
FreeTextField_02 |
string |
Vrij Tekstveld #2 |
☐ |
Free text field 2. |
FreeTextField_03 |
string |
Vrij Tekstveld #3 |
☐ |
Free text field 3. |
FreeTextField_04 |
string |
Vrij Tekstveld #4 |
☐ |
Free text field 4. |
FreeTextField_05 |
string |
Vrij Tekstveld #5 |
☐ |
Free text field 5. |
FreeTextField_06 |
string |
Vrij Tekstveld #6 |
☐ |
Free text field 6. |
FreeTextField_07 |
string |
Vrij Tekstveld #7 |
☐ |
Free text field 7. |
FreeTextField_08 |
string |
Vrij Tekstveld #8 |
☐ |
Free text field 8. |
FreeTextField_09 |
string |
Vrij Tekstveld #9 |
☐ |
Free text field 9. |
FreeTextField_10 |
string |
Vrij Tekstveld #10 |
☐ |
Free text field 10. |
GLCosts |
guid |
Grootboek Kosten |
☐ |
GL account the cost entries will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. |
GLRevenue |
guid |
Grootboek Omzet |
☐ |
GL account the revenue will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. |
GLStock |
guid |
Grootboekrekening Voorraad |
☐ |
GL account the stock entries will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group. |
GrossWeight |
double |
Brutogewicht |
☐ |
Gross weight for international goods shipments. |
ID |
guid |
ID |
☑ |
A guid that is the unique identifier of the item. |
IsBatchItem |
int16 |
Is Batchartikel |
☐ |
Indicates if batches are used for this item. |
IsFractionAllowedItem |
boolean |
Is Fraction Toegestaan op Artikel |
☐ |
Indicates if fractions (for example 0.35) are allowed for quantities of this item. |
IsMakeItem |
int16 |
Is Maakartikel |
☐ |
Indicates that an Item is produced to Inventory, not purchased. |
IsNewContract |
int16 |
Is Nieuw Contract |
☐ |
Only used for packages (IsPackageItem=1). To indicate if this package is a new contract type package. |
IsOnDemandItem |
int16 |
Is Artikel op Aanvraag |
☐ |
Is On demand Item. |
IsPackageItem |
boolean |
Is Pakket Item |
☐ |
Indicates if the item is a package item. Can only be created in the hosting administration. |
IsPurchaseItem |
boolean |
Is Aankoopitem |
☐ |
Indicates if the item can be purchased. |
IsRegistrationCodeItem |
int16 |
Is Registratie Code Item |
☑ |
|
IsSalesItem |
boolean |
Is verkoopartikel |
☐ |
Indicates if the item can be sold. |
IsSerialItem |
boolean |
Is Serienummer Artikel |
☐ |
Indicates that serial numbers are used for this item. |
IsStockItem |
boolean |
Is Voorraadartikel |
☐ |
If you have the Trade or Manufacturing license and you check this property the item will be shown in the stock positions overview, stock counts and transaction lists. If you have the Invoice module and you check this property you will get a general journal entry based on the Stock and Costs G/L accounts of the item group. If you don�t want the general journal entry to be created you should change the Stock/Costs G/L account on the Item group page to the type Costs instead of Inventory. |
IsSubcontractedItem |
boolean |
Is Uitbesteed Item |
☐ |
Indicates if the item is provided by an outside supplier. |
IsTaxableItem |
int16 |
Is Belastbaar Artikel |
☐ |
Indicates if tax needs to be calculated for this item. |
IsTime |
int16 |
Is Tijd |
☐ |
Indicates if the item is a time unit item (for example a labor hour item). |
IsWebshopItem |
int16 |
Is Webshopartikel |
☐ |
Indicates if the item can be exported to a web shop. |
ItemGroup |
guid |
Is Artikelgroep |
☐ |
GUID of item group of the item. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
NetWeight |
double |
Netto Gewicht |
☐ |
Net weight for international goods shipments. |
NetWeightUnit |
string |
Netto Gewichtseenheid |
☐ |
Net Weight unit for international goods shipment, only available in manufacturing packages. |
Notes |
string |
Notities |
☐ |
Notes. |
Picture |
byte[] |
Afbeelding |
☐ |
|
PictureName |
string |
Naam Afbeelding |
☐ |
File name of picture. |
PictureThumbnailUrl |
string |
Miniatuurafbeelding (URL) |
☐ |
URL where thumbnail picture can be retrieved. |
PictureUrl |
string |
Afbeelding (URL) |
☐ |
URL where picture can be retrieved. |
SalesVatCode |
string |
Verkoop BTW Code |
☐ |
Code of sales VAT. |
SearchCode |
string |
Zoekcode |
☐ |
Search code of the item. |
SecurityLevel |
int32 |
Beveiligingsniveau |
☐ |
Security level (0 - 100). |
StartDate |
datetime |
Startdatum |
☐ |
Together with EndDate this determines if the item is active. |
StatisticalCode |
string |
Statistische Code |
☐ |
Statistical code. |
StatisticalNetWeight |
double |
Statistisch Nettogewicht |
☐ |
Netweight weight for statistical reporting. |
StatisticalUnits |
double |
Statistische Eenheden |
☐ |
Units for statistical reporting. |
StatisticalValue |
double |
Statistische Waarde |
☐ |
Value for statistical reporting. |
Stock |
double |
Voorraad |
☐ |
|
Timestamp |
int64 |
Tijdstempel |
☑ |
Timestamp. |
Unit |
string |
Unit |
☐ |
The standard unit of this item. |
UnitType |
string |
Unitsoort |
☐ |
Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight. |
UseExplosion |
int16 |
{res:itgen_eol_useexplosion} |
☐ |
|
24-06-2025 18:54 Versie 24.1.116-BETA+5455