Tableau Connector for Exact Online

Build 24.0.9060

SalesOrderOrderChargeLines

Use this endpoint to create, read, update and delete sales order shipping cost and order charge lines.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Line ID of shipping method or order charges

AmountDC Double False

Amount excluded VAT in reporting currency for shipping cost or order charges

AmountFCExclVAT Double False

Amount excluded VAT in trading currency for shipping cost or order charges

AmountFCInclVAT Double False

Amount included VAT in trading currency for shipping cost or order charges

AmountVATFC Double False

VAT amount in trading currency for shipping cost or order charges

Division Int False

Division code

IsShippingCost Bool False

Indicates whether the order charge line is shipping cost

LineNumber Int False

Line number of shipping cost and order charges

OrderCharge String False

ID of order charges is mandatory for order charge.

OrderChargeCode String False

Code of shipping method or order charges

OrderChargeDescription String False

Description from shipping method or order charges master

OrderChargesLineDescription String False

Line description of shipping cost or order charges (only available in WD Premium packages)

OrderID String False

The OrderID identifies the sales order. All the lines of a sales order have the same OrderID

VATCode String False

VAT code that is used for shipping cost or order charges

VATDescription String False

VAT description for shipping cost or order charges

VATPercentage Double False

The vat percentage of the VAT code.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060