JDBC Driver for Exact Online

Build 22.0.8462

Receivables

Usage information for the operation Receivables.rsd.

Columns

Name Type Description
ID [KEY] String The ID column for the table Receivables.
Account String The Account column for the table Receivables.
AccountBankAccountID String The AccountBankAccountID column for the table Receivables.
AccountBankAccountNumber String The AccountBankAccountNumber column for the table Receivables.
AccountCode String The AccountCode column for the table Receivables.
AccountContact String The AccountContact column for the table Receivables.
AccountContactName String The AccountContactName column for the table Receivables.
AccountName String The AccountName column for the table Receivables.
AmountDC Double The AmountDC column for the table Receivables.
AmountDiscountDC Double The AmountDiscountDC column for the table Receivables.
AmountDiscountFC Double The AmountDiscountFC column for the table Receivables.
AmountFC Double The AmountFC column for the table Receivables.
BankAccountID String The BankAccountID column for the table Receivables.
BankAccountNumber String The BankAccountNumber column for the table Receivables.
CashflowTransactionBatchCode String The CashflowTransactionBatchCode column for the table Receivables.
Created Datetime The Created column for the table Receivables.
Creator String The Creator column for the table Receivables.
CreatorFullName String The CreatorFullName column for the table Receivables.
Currency String The Currency column for the table Receivables.
Description String The Description column for the table Receivables.
DirectDebitMandate String The DirectDebitMandate column for the table Receivables.
DirectDebitMandateDescription String The DirectDebitMandateDescription column for the table Receivables.
DirectDebitMandatePaymentType Int The DirectDebitMandatePaymentType column for the table Receivables.
DirectDebitMandateReference String The DirectDebitMandateReference column for the table Receivables.
DirectDebitMandateType Int The DirectDebitMandateType column for the table Receivables.
DiscountDueDate Datetime The DiscountDueDate column for the table Receivables.
Division Int The Division column for the table Receivables.
Document String The Document column for the table Receivables.
DocumentNumber Int The DocumentNumber column for the table Receivables.
DocumentSubject String The DocumentSubject column for the table Receivables.
DueDate Datetime The DueDate column for the table Receivables.
EndDate Datetime The EndDate column for the table Receivables.
EndPeriod Int The EndPeriod column for the table Receivables.
EndToEndID String The EndToEndID column for the table Receivables.
EndYear Int The EndYear column for the table Receivables.
EntryDate Datetime The EntryDate column for the table Receivables.
EntryID String The EntryID column for the table Receivables.
EntryNumber Int The EntryNumber column for the table Receivables.
GLAccount String The GLAccount column for the table Receivables.
GLAccountCode String The GLAccountCode column for the table Receivables.
GLAccountDescription String The GLAccountDescription column for the table Receivables.
InvoiceDate Datetime The InvoiceDate column for the table Receivables.
InvoiceNumber Int The InvoiceNumber column for the table Receivables.
IsBatchBooking Int The IsBatchBooking column for the table Receivables.
IsFullyPaid Bool The IsFullyPaid column for the table Receivables.
Journal String The Journal column for the table Receivables.
JournalDescription String The JournalDescription column for the table Receivables.
LastPaymentDate Datetime The LastPaymentDate column for the table Receivables.
Modified Datetime The Modified column for the table Receivables.
Modifier String The Modifier column for the table Receivables.
ModifierFullName String The ModifierFullName column for the table Receivables.
PaymentCondition String The PaymentCondition column for the table Receivables.
PaymentConditionDescription String The PaymentConditionDescription column for the table Receivables.
PaymentDays Int The PaymentDays column for the table Receivables.
PaymentDaysDiscount Int The PaymentDaysDiscount column for the table Receivables.
PaymentDiscountPercentage Double The PaymentDiscountPercentage column for the table Receivables.
PaymentInformationID String The PaymentInformationID column for the table Receivables.
PaymentMethod String The PaymentMethod column for the table Receivables.
PaymentReference String The PaymentReference column for the table Receivables.
RateFC Double The RateFC column for the table Receivables.
ReceivableBatchNumber Int The ReceivableBatchNumber column for the table Receivables.
ReceivableSelected Datetime The ReceivableSelected column for the table Receivables.
ReceivableSelector String The ReceivableSelector column for the table Receivables.
ReceivableSelectorFullName String The ReceivableSelectorFullName column for the table Receivables.
Source Int The Source column for the table Receivables.
Status Int The Status column for the table Receivables.
TransactionAmountDC Double The TransactionAmountDC column for the table Receivables.
TransactionAmountFC Double The TransactionAmountFC column for the table Receivables.
TransactionDueDate Datetime The TransactionDueDate column for the table Receivables.
TransactionEntryID String The TransactionEntryID column for the table Receivables.
TransactionID String The TransactionID column for the table Receivables.
TransactionIsReversal Bool The TransactionIsReversal column for the table Receivables.
TransactionReportingPeriod Int The TransactionReportingPeriod column for the table Receivables.
TransactionReportingYear Int The TransactionReportingYear column for the table Receivables.
TransactionStatus Int The TransactionStatus column for the table Receivables.
TransactionType Int The TransactionType column for the table Receivables.
YourRef String The YourRef column for the table Receivables.

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