JDBC Driver for Exact Online

Build 22.0.8462

Items

Usage information for the operation Items.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table Items.

Barcode String False

The Barcode column for the table Items.

Class_01 String False

The Class_01 column for the table Items.

Class_02 String False

The Class_02 column for the table Items.

Class_03 String False

The Class_03 column for the table Items.

Class_04 String False

The Class_04 column for the table Items.

Class_05 String False

The Class_05 column for the table Items.

Class_06 String False

The Class_06 column for the table Items.

Class_07 String False

The Class_07 column for the table Items.

Class_08 String False

The Class_08 column for the table Items.

Class_09 String False

The Class_09 column for the table Items.

Class_10 String False

The Class_10 column for the table Items.

Code String False

The Code column for the table Items.

CopyRemarks Int False

The CopyRemarks column for the table Items.

CostPriceCurrency String False

The CostPriceCurrency column for the table Items.

CostPriceNew Double False

The CostPriceNew column for the table Items.

CostPriceStandard Double False

The CostPriceStandard column for the table Items.

Created Datetime False

The Created column for the table Items.

Creator String False

The Creator column for the table Items.

CreatorFullName String False

The CreatorFullName column for the table Items.

Description String False

The Description column for the table Items.

Division Int False

The Division column for the table Items.

EndDate Datetime False

The EndDate column for the table Items.

ExtraDescription String False

The ExtraDescription column for the table Items.

FreeBoolField_01 Bool False

The FreeBoolField_01 column for the table Items.

FreeBoolField_02 Bool False

The FreeBoolField_02 column for the table Items.

FreeBoolField_03 Bool False

The FreeBoolField_03 column for the table Items.

FreeBoolField_04 Bool False

The FreeBoolField_04 column for the table Items.

FreeBoolField_05 Bool False

The FreeBoolField_05 column for the table Items.

FreeDateField_01 Datetime False

The FreeDateField_01 column for the table Items.

FreeDateField_02 Datetime False

The FreeDateField_02 column for the table Items.

FreeDateField_03 Datetime False

The FreeDateField_03 column for the table Items.

FreeDateField_04 Datetime False

The FreeDateField_04 column for the table Items.

FreeDateField_05 Datetime False

The FreeDateField_05 column for the table Items.

FreeNumberField_01 Double False

The FreeNumberField_01 column for the table Items.

FreeNumberField_02 Double False

The FreeNumberField_02 column for the table Items.

FreeNumberField_03 Double False

The FreeNumberField_03 column for the table Items.

FreeNumberField_04 Double False

The FreeNumberField_04 column for the table Items.

FreeNumberField_05 Double False

The FreeNumberField_05 column for the table Items.

FreeNumberField_06 Double False

The FreeNumberField_06 column for the table Items.

FreeNumberField_07 Double False

The FreeNumberField_07 column for the table Items.

FreeNumberField_08 Double False

The FreeNumberField_08 column for the table Items.

FreeTextField_01 String False

The FreeTextField_01 column for the table Items.

FreeTextField_02 String False

The FreeTextField_02 column for the table Items.

FreeTextField_03 String False

The FreeTextField_03 column for the table Items.

FreeTextField_04 String False

The FreeTextField_04 column for the table Items.

FreeTextField_05 String False

The FreeTextField_05 column for the table Items.

FreeTextField_06 String False

The FreeTextField_06 column for the table Items.

FreeTextField_07 String False

The FreeTextField_07 column for the table Items.

FreeTextField_08 String False

The FreeTextField_08 column for the table Items.

FreeTextField_09 String False

The FreeTextField_09 column for the table Items.

FreeTextField_10 String False

The FreeTextField_10 column for the table Items.

GLCosts String False

The GLCosts column for the table Items.

GLCostsCode String False

The GLCostsCode column for the table Items.

GLCostsDescription String False

The GLCostsDescription column for the table Items.

GLRevenue String False

The GLRevenue column for the table Items.

GLRevenueCode String False

The GLRevenueCode column for the table Items.

GLRevenueDescription String False

The GLRevenueDescription column for the table Items.

GLStock String False

The GLStock column for the table Items.

GLStockCode String False

The GLStockCode column for the table Items.

GLStockDescription String False

The GLStockDescription column for the table Items.

GrossWeight Double False

The GrossWeight column for the table Items.

IsBatchItem Int False

The IsBatchItem column for the table Items.

IsBatchNumberItem Int False

The IsBatchNumberItem column for the table Items.

IsFractionAllowedItem Bool False

The IsFractionAllowedItem column for the table Items.

IsMakeItem Int False

The IsMakeItem column for the table Items.

IsNewContract Int False

The IsNewContract column for the table Items.

IsOnDemandItem Int False

The IsOnDemandItem column for the table Items.

IsPackageItem Bool False

The IsPackageItem column for the table Items.

IsPurchaseItem Bool False

The IsPurchaseItem column for the table Items.

IsRegistrationCodeItem Int False

The IsRegistrationCodeItem column for the table Items.

IsSalesItem Bool False

The IsSalesItem column for the table Items.

IsSerialItem Bool False

The IsSerialItem column for the table Items.

IsSerialNumberItem Bool False

The IsSerialNumberItem column for the table Items.

IsStockItem Bool False

The IsStockItem column for the table Items.

IsSubcontractedItem Bool False

The IsSubcontractedItem column for the table Items.

IsTaxableItem Int False

The IsTaxableItem column for the table Items.

IsTime Int False

The IsTime column for the table Items.

IsWebshopItem Int False

The IsWebshopItem column for the table Items.

ItemGroup String False

The ItemGroup column for the table Items.

ItemGroupCode String False

The ItemGroupCode column for the table Items.

ItemGroupDescription String False

The ItemGroupDescription column for the table Items.

Modified Datetime False

The Modified column for the table Items.

Modifier String False

The Modifier column for the table Items.

ModifierFullName String False

The ModifierFullName column for the table Items.

NetWeight Double False

The NetWeight column for the table Items.

NetWeightUnit String False

The NetWeightUnit column for the table Items.

Notes String False

The Notes column for the table Items.

PictureName String False

The PictureName column for the table Items.

PictureThumbnailUrl String False

The PictureThumbnailUrl column for the table Items.

PictureUrl String False

The PictureUrl column for the table Items.

SalesVatCode String False

The SalesVatCode column for the table Items.

SalesVatCodeDescription String False

The SalesVatCodeDescription column for the table Items.

SearchCode String False

The SearchCode column for the table Items.

SecurityLevel Int False

The SecurityLevel column for the table Items.

StartDate Datetime False

The StartDate column for the table Items.

Stock Double False

The Stock column for the table Items.

Unit String False

The Unit column for the table Items.

UnitDescription String False

The UnitDescription column for the table Items.

UnitType String False

The UnitType column for the table Items.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462