JDBC Driver for Exact Online

Build 22.0.8462

Payments

Usage information for the operation Payments.rsd.

Columns

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

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