ItemsRead: Exact Online Artikelen

Account

guid

Account

☐

Barcode

string(20)

Barcode

☐

Barcode of the item (numeric string).

Code

string(30)

Code

☑

Item code.

CostPriceCurrency

string(30)

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.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of creator.

CreatorFullName

string(240)

Aanmaker Volledige Naam

☐

Name of creator.

DefaultSalesPrice

double

Standaard Verkoopprijs

☐

Description

string(255)

Omschrijving

☐

Description of the item.

Division

int32

Divisie

☐

Division code.

DivisionCompanyCoCNumber

string(60)

Divisie Kamer van Koophandel Nummer

☐

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Divisie IBAN Nummer

☐

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Divisie Bedrijfsnaam

☑

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Divisie RSIN Nummer

☐

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Divisie BTW Nummer

☐

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Divisie Loonbelastingnummer

☐

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Divisie Label

☑

Label of the Exact Online division.

DivisionName

string(50)

Administratie Naam

☑

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Naam Abonnementhouder

☑

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Abonnementhoudernummer

☑

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Divisie Korte Naam

☑

Short name of the Exact Online division.

EndDate

datetime

Einddatum

☐

Together with StartDate this determines if the item is active.

ID

guid

ID

☑

Primary key.

IsFractionAllowedItem

boolean

Is Fraction Toegestaan op Artikel

☐

Indicates if fractions (for example 0.35) are allowed for quantities of this item.

IsSalesItem

boolean

Is verkoopartikel

☐

Indicates if the item can be sold.

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.

IsTaxableItem

int16

Is Belastbaar Artikel

☐

Indicates if tax needs to be calculated for this 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.

ItemGroupCode

string

Artikelgroep Code

☐

Code of ItemGroup.

ItemGroupDescription

string

Artikelgroep Omschrijving

☐

Description of ItemGroup.

Margin

double

Marge

☐

Markup

double

Toeslag

☐

Modified

datetime

Gewijzigd

☐

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string(240)

Gewijzigd Volledige Naam

☐

Name of modifier.

Notes

string

Notities

☐

Notes.

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.

ProjectedStock

double

Geprojecteerde Voorraad

☐

PurchaseLeadDays

int32

Inkoop Aanloopdagen

☐

QuantityToBeConsumed

double

{res:itgen_eol_quantitytobeconsumed}

☐

QuantityToBeDelivered

double

{res:itgen_eol_quantitytobedelivered}

☐

QuantityToBeProduced

double

{res:itgen_eol_quantitytobeproduced}

☐

QuantityToBeReceived

double

{res:itgen_eol_quantitytobereceived}

☐

ReservedStock

double

Gereserveerde Voorraad

☐

SalesCurrency

string(30)

Verkoop Munteenheid

☐

Currency of sales price.

SalesPrice

double

Verkoopprijs

☐

SalesVatCode

string(3)

Verkoop BTW Code

☐

Code of SalesVat.

SalesVatCodeDescription

string(60)

Verkoop BTW Code Omschrijving

☐

Description of Sales VAT code.

StartDate

datetime

Startdatum

☐

Together with EndDate this determines if the item is active.

Stock

double

Voorraad

☐

Quantity that is in stock.

Unit

guid

Unit

☐

The standard unit of this item.

UnitCode

string(8)

Unit Code

☐

UnitDescription

string(60)

Omschrijving Unit

☐

Description of Unit.

UnitType

string(1)

Unitsoort

☐

Type of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=Weight.