JDBC Driver for Exact Online

Build 22.0.8462

SalesInvoices

Usage information for the operation SalesInvoices.rsd.

Columns

Name Type ReadOnly Description
InvoiceID [KEY] String True

The InvoiceID column for the table SalesInvoices.

AmountDC Double False

The AmountDC column for the table SalesInvoices.

AmountDiscount Double False

The AmountDiscount column for the table SalesInvoices.

AmountDiscountExclVat Double False

The AmountDiscountExclVat column for the table SalesInvoices.

AmountFC Double False

The AmountFC column for the table SalesInvoices.

AmountFCExclVat Double False

The AmountFCExclVat column for the table SalesInvoices.

Created Datetime False

The Created column for the table SalesInvoices.

Creator String False

The Creator column for the table SalesInvoices.

CreatorFullName String False

The CreatorFullName column for the table SalesInvoices.

Currency String False

The Currency column for the table SalesInvoices.

DeliverTo String False

The DeliverTo column for the table SalesInvoices.

DeliverToAddress String False

The DeliverToAddress column for the table SalesInvoices.

DeliverToContactPerson String False

The DeliverToContactPerson column for the table SalesInvoices.

DeliverToContactPersonFullName String False

The DeliverToContactPersonFullName column for the table SalesInvoices.

DeliverToName String False

The DeliverToName column for the table SalesInvoices.

Description String False

The Description column for the table SalesInvoices.

Discount Double False

The Discount column for the table SalesInvoices.

Division Int False

The Division column for the table SalesInvoices.

Document String False

The Document column for the table SalesInvoices.

DocumentNumber Int False

The DocumentNumber column for the table SalesInvoices.

DocumentSubject String False

The DocumentSubject column for the table SalesInvoices.

DueDate Datetime False

The DueDate column for the table SalesInvoices.

ExtraDutyAmountFC Double False

The ExtraDutyAmountFC column for the table SalesInvoices.

GAccountAmountFC Double False

The GAccountAmountFC column for the table SalesInvoices.

InvoiceDate Datetime False

The InvoiceDate column for the table SalesInvoices.

InvoiceNumber Int False

The InvoiceNumber column for the table SalesInvoices.

InvoiceTo String False

The InvoiceTo column for the table SalesInvoices.

InvoiceToContactPerson String False

The InvoiceToContactPerson column for the table SalesInvoices.

InvoiceToContactPersonFullName String False

The InvoiceToContactPersonFullName column for the table SalesInvoices.

InvoiceToName String False

The InvoiceToName column for the table SalesInvoices.

IsExtraDuty Bool False

The IsExtraDuty column for the table SalesInvoices.

Journal String False

The Journal column for the table SalesInvoices.

JournalDescription String False

The JournalDescription column for the table SalesInvoices.

Modified Datetime False

The Modified column for the table SalesInvoices.

Modifier String False

The Modifier column for the table SalesInvoices.

ModifierFullName String False

The ModifierFullName column for the table SalesInvoices.

OrderDate Datetime False

The OrderDate column for the table SalesInvoices.

OrderedBy String False

The OrderedBy column for the table SalesInvoices.

OrderedByContactPerson String False

The OrderedByContactPerson column for the table SalesInvoices.

OrderedByContactPersonFullName String False

The OrderedByContactPersonFullName column for the table SalesInvoices.

OrderedByName String False

The OrderedByName column for the table SalesInvoices.

OrderNumber Int False

The OrderNumber column for the table SalesInvoices.

PaymentCondition String False

The PaymentCondition column for the table SalesInvoices.

PaymentConditionDescription String False

The PaymentConditionDescription column for the table SalesInvoices.

PaymentReference String False

The PaymentReference column for the table SalesInvoices.

Remarks String False

The Remarks column for the table SalesInvoices.

Salesperson String False

The Salesperson column for the table SalesInvoices.

SalespersonFullName String False

The SalespersonFullName column for the table SalesInvoices.

StarterSalesInvoiceStatus Int False

The StarterSalesInvoiceStatus column for the table SalesInvoices.

StarterSalesInvoiceStatusDescription String False

The StarterSalesInvoiceStatusDescription column for the table SalesInvoices.

Status Int False

The Status column for the table SalesInvoices.

StatusDescription String False

The StatusDescription column for the table SalesInvoices.

TaxSchedule String False

The TaxSchedule column for the table SalesInvoices.

TaxScheduleCode String False

The TaxScheduleCode column for the table SalesInvoices.

TaxScheduleDescription String False

The TaxScheduleDescription column for the table SalesInvoices.

Type Int False

The Type column for the table SalesInvoices.

TypeDescription String False

The TypeDescription column for the table SalesInvoices.

VATAmountDC Double False

The VATAmountDC column for the table SalesInvoices.

VATAmountFC Double False

The VATAmountFC column for the table SalesInvoices.

WithholdingTaxAmountFC Double False

The WithholdingTaxAmountFC column for the table SalesInvoices.

WithholdingTaxBaseAmount Double False

The WithholdingTaxBaseAmount column for the table SalesInvoices.

WithholdingTaxPercentage Double False

The WithholdingTaxPercentage column for the table SalesInvoices.

YourRef String False

The YourRef column for the table SalesInvoices.

LinkedSalesInvoiceLines String False

The LinkedSalesInvoiceLines column for the table SalesInvoices.

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