JDBC Driver for Exact Online

Build 22.0.8462

TransactionLines

Usage information for the operation TransactionLines.rsd.

Columns

Name Type Description
ID [KEY] String The ID column for the table TransactionLines.
Account String The Account column for the table TransactionLines.
AccountCode String The AccountCode column for the table TransactionLines.
AccountName String The AccountName column for the table TransactionLines.
AmountDC Double The AmountDC column for the table TransactionLines.
AmountFC Double The AmountFC column for the table TransactionLines.
AmountVATBaseFC Double The AmountVATBaseFC column for the table TransactionLines.
AmountVATFC Double The AmountVATFC column for the table TransactionLines.
Asset String The Asset column for the table TransactionLines.
AssetCode String The AssetCode column for the table TransactionLines.
AssetDescription String The AssetDescription column for the table TransactionLines.
CostCenter String The CostCenter column for the table TransactionLines.
CostCenterDescription String The CostCenterDescription column for the table TransactionLines.
CostUnit String The CostUnit column for the table TransactionLines.
CostUnitDescription String The CostUnitDescription column for the table TransactionLines.
Created Datetime The Created column for the table TransactionLines.
Creator String The Creator column for the table TransactionLines.
CreatorFullName String The CreatorFullName column for the table TransactionLines.
Currency String The Currency column for the table TransactionLines.
Date Datetime The Date column for the table TransactionLines.
Description String The Description column for the table TransactionLines.
Division Int The Division column for the table TransactionLines.
Document String The Document column for the table TransactionLines.
DocumentNumber Int The DocumentNumber column for the table TransactionLines.
DocumentSubject String The DocumentSubject column for the table TransactionLines.
DueDate Datetime The DueDate column for the table TransactionLines.
EntryID String The EntryID column for the table TransactionLines.
EntryNumber Int The EntryNumber column for the table TransactionLines.
ExchangeRate Double The ExchangeRate column for the table TransactionLines.
ExtraDutyAmountFC Double The ExtraDutyAmountFC column for the table TransactionLines.
ExtraDutyPercentage Double The ExtraDutyPercentage column for the table TransactionLines.
FinancialPeriod Int The FinancialPeriod column for the table TransactionLines.
FinancialYear Int The FinancialYear column for the table TransactionLines.
GLAccount String The GLAccount column for the table TransactionLines.
GLAccountCode String The GLAccountCode column for the table TransactionLines.
GLAccountDescription String The GLAccountDescription column for the table TransactionLines.
InvoiceNumber Int The InvoiceNumber column for the table TransactionLines.
Item String The Item column for the table TransactionLines.
ItemCode String The ItemCode column for the table TransactionLines.
ItemDescription String The ItemDescription column for the table TransactionLines.
JournalCode String The JournalCode column for the table TransactionLines.
JournalDescription String The JournalDescription column for the table TransactionLines.
LineNumber Int The LineNumber column for the table TransactionLines.
LineType Int The LineType column for the table TransactionLines.
Modified Datetime The Modified column for the table TransactionLines.
Modifier String The Modifier column for the table TransactionLines.
ModifierFullName String The ModifierFullName column for the table TransactionLines.
Notes String The Notes column for the table TransactionLines.
OffsetID String The OffsetID column for the table TransactionLines.
OrderNumber Int The OrderNumber column for the table TransactionLines.
PaymentDiscountAmount Double The PaymentDiscountAmount column for the table TransactionLines.
PaymentReference String The PaymentReference column for the table TransactionLines.
Project String The Project column for the table TransactionLines.
ProjectCode String The ProjectCode column for the table TransactionLines.
ProjectDescription String The ProjectDescription column for the table TransactionLines.
Quantity Double The Quantity column for the table TransactionLines.
SerialNumber String The SerialNumber column for the table TransactionLines.
Status Int The Status column for the table TransactionLines.
Subscription String The Subscription column for the table TransactionLines.
SubscriptionDescription String The SubscriptionDescription column for the table TransactionLines.
TrackingNumber String The TrackingNumber column for the table TransactionLines.
TrackingNumberDescription String The TrackingNumberDescription column for the table TransactionLines.
Type Int The Type column for the table TransactionLines.
VATCode String The VATCode column for the table TransactionLines.
VATCodeDescription String The VATCodeDescription column for the table TransactionLines.
VATPercentage Double The VATPercentage column for the table TransactionLines.
VATType String The VATType column for the table TransactionLines.
YourRef String The YourRef column for the table TransactionLines.

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