JDBC Driver for Exact Online

Build 22.0.8462

ItemChargeRelation

Usage information for the operation ItemChargeRelation.rsd.

Columns

Name Type Description
ID [KEY] String Primary key of relationship between item and item charge
Amount String Item charge amount per unit
ChargeCode String Code of item charge
ChargeDescription String Description of item charge
ChargeID String Item charge ID
ChargeVATCode String VAT code that is used when the item charge is registered
ChargeVATDescription String Description of VAT Code
ChargeVATPercentage String VAT percentage of the VAT code
ChargeVATType String Indicates how the VAT amount should be calculated in relation to the item charge amount. B = VAT 0% (Only base amount), E = Excluding, I = Including, N = No VAT
Created String Creation date
Creator String User ID of creator
CreatorFullName String Name of creator
Currency String Currency of the item charge
Division String Division code
ItemCode String Code of item
ItemDescription String Description of item
ItemID String Item ID
Modified String Last modified date
Modifier String User ID of modifier
ModifierFullName String Name of modifier
Quantity String Quantity of the item charge requires in the item
TotalAmount String Total of item charge amount per unit x quantity

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