Power BI Connector for Exact Online

Build 24.0.9062

SalesInvoiceOrderChargeLines

Use this endpoint to create, read, update and delete sales invoice 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

GLAccount String False

The GL Account of the sales invoice order charge line.

GLAccountCode String False

GL account code of shipping cost or order charges

GLAccountDescription String False

GL account description of shipping cost or order charges

InvoiceID String False

The InvoiceID identifies the sales invoice

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)

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.9062