JDBC Driver for Exact Online

Build 22.0.8462

PurchaseEntries

Usage information for the operation PurchaseEntries.rsd.

Columns

Name Type ReadOnly Description
EntryID [KEY] String True

The EntryID column for the table PurchaseEntries.

AmountDC Double False

The AmountDC column for the table PurchaseEntries.

AmountFC Double False

The AmountFC column for the table PurchaseEntries.

BatchNumber Int False

The BatchNumber column for the table PurchaseEntries.

Created Datetime False

The Created column for the table PurchaseEntries.

Creator String False

The Creator column for the table PurchaseEntries.

CreatorFullName String False

The CreatorFullName column for the table PurchaseEntries.

Currency String False

The Currency column for the table PurchaseEntries.

Description String False

The Description column for the table PurchaseEntries.

Division Int False

The Division column for the table PurchaseEntries.

Document String False

The Document column for the table PurchaseEntries.

DocumentNumber Int False

The DocumentNumber column for the table PurchaseEntries.

DocumentSubject String False

The DocumentSubject column for the table PurchaseEntries.

DueDate Datetime False

The DueDate column for the table PurchaseEntries.

EntryDate Datetime False

The EntryDate column for the table PurchaseEntries.

EntryNumber Int False

The EntryNumber column for the table PurchaseEntries.

ExternalLinkDescription String False

The ExternalLinkDescription column for the table PurchaseEntries.

ExternalLinkReference String False

The ExternalLinkReference column for the table PurchaseEntries.

GAccountAmountFC Double False

The GAccountAmountFC column for the table PurchaseEntries.

InvoiceNumber Int False

The InvoiceNumber column for the table PurchaseEntries.

Journal String False

The Journal column for the table PurchaseEntries.

JournalDescription String False

The JournalDescription column for the table PurchaseEntries.

Modified Datetime False

The Modified column for the table PurchaseEntries.

Modifier String False

The Modifier column for the table PurchaseEntries.

ModifierFullName String False

The ModifierFullName column for the table PurchaseEntries.

OrderNumber Int False

The OrderNumber column for the table PurchaseEntries.

PaymentCondition String False

The PaymentCondition column for the table PurchaseEntries.

PaymentConditionDescription String False

The PaymentConditionDescription column for the table PurchaseEntries.

PaymentReference String False

The PaymentReference column for the table PurchaseEntries.

ProcessNumber Int False

The ProcessNumber column for the table PurchaseEntries.

Rate Double False

The Rate column for the table PurchaseEntries.

ReportingPeriod Int False

The ReportingPeriod column for the table PurchaseEntries.

ReportingYear Int False

The ReportingYear column for the table PurchaseEntries.

Reversal Bool False

The Reversal column for the table PurchaseEntries.

Status Int False

The Status column for the table PurchaseEntries.

StatusDescription String False

The StatusDescription column for the table PurchaseEntries.

Supplier String False

The Supplier column for the table PurchaseEntries.

SupplierName String False

The SupplierName column for the table PurchaseEntries.

Type Int False

The Type column for the table PurchaseEntries.

TypeDescription String False

The TypeDescription column for the table PurchaseEntries.

VATAmountDC Double False

The VATAmountDC column for the table PurchaseEntries.

VATAmountFC Double False

The VATAmountFC column for the table PurchaseEntries.

YourRef String False

The YourRef column for the table PurchaseEntries.

LinkedPurchaseEntryLines String False

The LinkedPurchaseEntryLines column for the table PurchaseEntries.

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