JDBC Driver for Exact Online

Build 22.0.8462

SalesOrderHeaders

null

Columns

Name Type ReadOnly Description
Timestamp Long False

AmountDC Double False

AmountDiscount Double False

AmountDiscountExclVat Double False

AmountFC Double False

AmountFCExclVat Double False

ApprovalStatus Int False

ApprovalStatusDescription String False

Approved Datetime False

Approver String False

ApproverFullName String False

Created Datetime False

Creator String False

CreatorFullName String False

Currency String False

DeliverTo String False

DeliverToContactPerson String False

DeliverToContactPersonFullName String False

DeliverToName String False

DeliveryAddress String False

DeliveryDate Datetime False

DeliveryStatus Int False

DeliveryStatusDescription String False

Description String False

Discount Double False

Division Int False

Document String False

DocumentNumber Int False

DocumentSubject String False

ID [KEY] String True

IncotermAddress String False

IncotermCode String False

IncotermVersion Int False

InvoiceStatus Int False

InvoiceStatusDescription String False

InvoiceTo String False

InvoiceToContactPerson String False

InvoiceToContactPersonFullName String False

InvoiceToName String False

Modified Datetime False

Modifier String False

ModifierFullName String False

Notes String False

OrderDate Datetime False

OrderedBy String False

OrderedByContactPerson String False

OrderedByContactPersonFullName String False

OrderedByName String False

OrderID String False

OrderNumber Int False

PaymentCondition String False

PaymentConditionDescription String False

PaymentReference String False

Project String False

ProjectCode String False

ProjectDescription String False

Remarks String False

SalesChannel String False

SalesChannelCode String False

SalesChannelDescription String False

Salesperson String False

SalespersonFullName String False

SelectionCode String False

SelectionCodeCode String False

SelectionCodeDescription String False

ShippingMethod String False

ShippingMethodCode String False

ShippingMethodDescription String False

Status Int False

StatusDescription String False

VATAmount Double False

VATCode String False

VATCodeDescription String False

WarehouseCode String False

WarehouseDescription String False

WarehouseID String False

YourRef String False

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