JDBC Driver for Exact Online

Build 22.0.8462

SalesInvoiceLines

Usage information for the operation SalesInvoiceLines.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table SalesInvoiceLines.

AmountDC Double False

The AmountDC column for the table SalesInvoiceLines.

AmountFC Double False

The AmountFC column for the table SalesInvoiceLines.

CostCenter String False

The CostCenter column for the table SalesInvoiceLines.

CostCenterDescription String False

The CostCenterDescription column for the table SalesInvoiceLines.

CostUnit String False

The CostUnit column for the table SalesInvoiceLines.

CostUnitDescription String False

The CostUnitDescription column for the table SalesInvoiceLines.

DeliveryDate Datetime False

The DeliveryDate column for the table SalesInvoiceLines.

Description String False

The Description column for the table SalesInvoiceLines.

Discount Double False

The Discount column for the table SalesInvoiceLines.

Division Int False

The Division column for the table SalesInvoiceLines.

Employee String False

The Employee column for the table SalesInvoiceLines.

EmployeeFullName String False

The EmployeeFullName column for the table SalesInvoiceLines.

EndTime Datetime False

The EndTime column for the table SalesInvoiceLines.

ExtraDutyAmountFC Double False

The ExtraDutyAmountFC column for the table SalesInvoiceLines.

ExtraDutyPercentage Double False

The ExtraDutyPercentage column for the table SalesInvoiceLines.

GLAccount String False

The GLAccount column for the table SalesInvoiceLines.

GLAccountDescription String False

The GLAccountDescription column for the table SalesInvoiceLines.

InvoiceID String False

The InvoiceID column for the table SalesInvoiceLines.

Item String False

The Item column for the table SalesInvoiceLines.

ItemCode String False

The ItemCode column for the table SalesInvoiceLines.

ItemDescription String False

The ItemDescription column for the table SalesInvoiceLines.

LineNumber Int False

The LineNumber column for the table SalesInvoiceLines.

NetPrice Double False

The NetPrice column for the table SalesInvoiceLines.

Notes String False

The Notes column for the table SalesInvoiceLines.

Pricelist String False

The Pricelist column for the table SalesInvoiceLines.

PricelistDescription String False

The PricelistDescription column for the table SalesInvoiceLines.

Project String False

The Project column for the table SalesInvoiceLines.

ProjectDescription String False

The ProjectDescription column for the table SalesInvoiceLines.

ProjectWBS String False

The ProjectWBS column for the table SalesInvoiceLines.

ProjectWBSDescription String False

The ProjectWBSDescription column for the table SalesInvoiceLines.

Quantity Double False

The Quantity column for the table SalesInvoiceLines.

SalesOrder String False

The SalesOrder column for the table SalesInvoiceLines.

SalesOrderLine String False

The SalesOrderLine column for the table SalesInvoiceLines.

SalesOrderLineNumber Int False

The SalesOrderLineNumber column for the table SalesInvoiceLines.

SalesOrderNumber Int False

The SalesOrderNumber column for the table SalesInvoiceLines.

StartTime Datetime False

The StartTime column for the table SalesInvoiceLines.

Subscription String False

The Subscription column for the table SalesInvoiceLines.

SubscriptionDescription String False

The SubscriptionDescription column for the table SalesInvoiceLines.

TaxSchedule String False

The TaxSchedule column for the table SalesInvoiceLines.

TaxScheduleCode String False

The TaxScheduleCode column for the table SalesInvoiceLines.

TaxScheduleDescription String False

The TaxScheduleDescription column for the table SalesInvoiceLines.

UnitCode String False

The UnitCode column for the table SalesInvoiceLines.

UnitDescription String False

The UnitDescription column for the table SalesInvoiceLines.

UnitPrice Double False

The UnitPrice column for the table SalesInvoiceLines.

VATAmountDC Double False

The VATAmountDC column for the table SalesInvoiceLines.

VATAmountFC Double False

The VATAmountFC column for the table SalesInvoiceLines.

VATCode String False

The VATCode column for the table SalesInvoiceLines.

VATCodeDescription String False

The VATCodeDescription column for the table SalesInvoiceLines.

VATPercentage Double False

The VATPercentage column for the table SalesInvoiceLines.

Pseudo-Columns

Name Type Description
Modified Datetime

The Modified column for the table SalesInvoiceLines.

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