JDBC Driver for Exact Online

Build 24.0.9060

PurchaseInvoiceLines

Usage information for the operation PurchaseInvoiceLines.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table PurchaseInvoiceLines.

Amount Double False

The Amount column for the table PurchaseInvoiceLines.

CostCenter String False

The CostCenter column for the table PurchaseInvoiceLines.

CostUnit String False

The CostUnit column for the table PurchaseInvoiceLines.

Currency String False

The Currency column for the table PurchaseInvoiceLines.

Description String False

The Description column for the table PurchaseInvoiceLines.

Discount Double False

The Discount column for the table PurchaseInvoiceLines.

Expense String False

The Expense column for the table PurchaseInvoiceLines.

ExpenseDescription String False

The ExpenseDescription column for the table PurchaseInvoiceLines.

InvoiceID String False

The InvoiceID column for the table PurchaseInvoiceLines.

InvoiceType Int False

The InvoiceType column for the table PurchaseInvoiceLines.

Item String False

The Item column for the table PurchaseInvoiceLines.

ItemUnit String False

The ItemUnit column for the table PurchaseInvoiceLines.

LineNumber Int False

The LineNumber column for the table PurchaseInvoiceLines.

Modified Datetime False

The Modified column for the table PurchaseInvoiceLines.

NetPrice Double False

The NetPrice column for the table PurchaseInvoiceLines.

Notes String False

The Notes column for the table PurchaseInvoiceLines.

Project String False

The Project column for the table PurchaseInvoiceLines.

PurchaseOrderLine String False

The PurchaseOrderLine column for the table PurchaseInvoiceLines.

Quantity Double False

The Quantity column for the table PurchaseInvoiceLines.

QuantityInDefaultUnits Double False

The QuantityInDefaultUnits column for the table PurchaseInvoiceLines.

Rebill Bool False

The Rebill column for the table PurchaseInvoiceLines.

Unit String False

The Unit column for the table PurchaseInvoiceLines.

UnitPrice Double False

The UnitPrice column for the table PurchaseInvoiceLines.

VATAmount Double False

The VATAmount column for the table PurchaseInvoiceLines.

VATCode String False

The VATCode column for the table PurchaseInvoiceLines.

VATPercentage Double False

The VATPercentage column for the table PurchaseInvoiceLines.

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