JDBC Driver for Exact Online

Build 22.0.8462

PurchaseEntryLines

Usage information for the operation PurchaseEntryLines.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table PurchaseEntryLines.

AmountDC Double False

The AmountDC column for the table PurchaseEntryLines.

AmountFC Double False

The AmountFC column for the table PurchaseEntryLines.

Asset String False

The Asset column for the table PurchaseEntryLines.

AssetDescription String False

The AssetDescription column for the table PurchaseEntryLines.

CostCenter String False

The CostCenter column for the table PurchaseEntryLines.

CostCenterDescription String False

The CostCenterDescription column for the table PurchaseEntryLines.

CostUnit String False

The CostUnit column for the table PurchaseEntryLines.

CostUnitDescription String False

The CostUnitDescription column for the table PurchaseEntryLines.

Description String False

The Description column for the table PurchaseEntryLines.

Division Int False

The Division column for the table PurchaseEntryLines.

EntryID String False

The EntryID column for the table PurchaseEntryLines.

From Datetime False

The From column for the table PurchaseEntryLines.

GLAccount String False

The GLAccount column for the table PurchaseEntryLines.

GLAccountCode String False

The GLAccountCode column for the table PurchaseEntryLines.

GLAccountDescription String False

The GLAccountDescription column for the table PurchaseEntryLines.

IntraStatArea String False

The IntraStatArea column for the table PurchaseEntryLines.

IntraStatCountry String False

The IntraStatCountry column for the table PurchaseEntryLines.

IntraStatDeliveryTerm String False

The IntraStatDeliveryTerm column for the table PurchaseEntryLines.

IntraStatTransactionA String False

The IntraStatTransactionA column for the table PurchaseEntryLines.

IntraStatTransportMethod String False

The IntraStatTransportMethod column for the table PurchaseEntryLines.

LineNumber Int False

The LineNumber column for the table PurchaseEntryLines.

Notes String False

The Notes column for the table PurchaseEntryLines.

PrivateUsePercentage Double False

The PrivateUsePercentage column for the table PurchaseEntryLines.

Project String False

The Project column for the table PurchaseEntryLines.

ProjectDescription String False

The ProjectDescription column for the table PurchaseEntryLines.

Quantity Double False

The Quantity column for the table PurchaseEntryLines.

SerialNumber String False

The SerialNumber column for the table PurchaseEntryLines.

StatisticalNetWeight Double False

The StatisticalNetWeight column for the table PurchaseEntryLines.

StatisticalNumber String False

The StatisticalNumber column for the table PurchaseEntryLines.

StatisticalQuantity Double False

The StatisticalQuantity column for the table PurchaseEntryLines.

StatisticalValue Double False

The StatisticalValue column for the table PurchaseEntryLines.

Subscription String False

The Subscription column for the table PurchaseEntryLines.

SubscriptionDescription String False

The SubscriptionDescription column for the table PurchaseEntryLines.

To Datetime False

The To column for the table PurchaseEntryLines.

TrackingNumber String False

The TrackingNumber column for the table PurchaseEntryLines.

TrackingNumberDescription String False

The TrackingNumberDescription column for the table PurchaseEntryLines.

Type Int False

The Type column for the table PurchaseEntryLines.

VATAmountDC Double False

The VATAmountDC column for the table PurchaseEntryLines.

VATAmountFC Double False

The VATAmountFC column for the table PurchaseEntryLines.

VATBaseAmountDC Double False

The VATBaseAmountDC column for the table PurchaseEntryLines.

VATBaseAmountFC Double False

The VATBaseAmountFC column for the table PurchaseEntryLines.

VATCode String False

The VATCode column for the table PurchaseEntryLines.

VATCodeDescription String False

The VATCodeDescription column for the table PurchaseEntryLines.

VATNonDeductiblePercentage Double False

The VATNonDeductiblePercentage column for the table PurchaseEntryLines.

VATPercentage Double False

The VATPercentage column for the table PurchaseEntryLines.

WithholdingAmountDC Double False

The WithholdingAmountDC column for the table PurchaseEntryLines.

WithholdingTax String False

The WithholdingTax column for the table PurchaseEntryLines.

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