JDBC Driver for Exact Online

Build 22.0.8462

PaymentTerms

Usage information for the operation PaymentTerms.rsd.

Columns

Name Type Description
TimeStamp Datetime TimeStamp.
Account String The supplier to which the payment has to be done.
AccountBankAccountID String The bank account of the supplier, to which the payment has to be done.
AccountBankAccountNumber String The bank account number of the supplier, to which the payment has to be done.
AccountCode String The code of the supplier to which the payment has to be done.
AccountContact String Contact person copied from the purchase invoice linked to the related purchase entry. Used as prefered contact when sending reminders.
AccountContactName String Name of the contact person of the supplier.
AccountCountry String Country
AccountName String Name of the supplier.
AmountDC Double The amount in default currency (division currency). Payments are matched on this amount.
AmountDiscountDC Double The amount of the discount in the default currency.
AmountDiscountFC Double The amount of the discount. This is in the amount of the selected currency.
AmountFC Double The amount of the payment. This is in the amount of the selected currency.
ApprovalStatus Int Shows the approval status of the payment.
BankAccountID String Own bank account from which the payment must be done.
BankAccountNumber String Own bank account number from which the payment must be done.
CashflowTransactionBatchCode String When processing payments, all payments with the same processing data are put in a batch. This field contains the code of that batch.
Created Datetime Creation date.
Creator String User ID of the creator.
CreatorFullName String Name of the creator.
Currency String The currency of the payment. This currency can only deviate from the division currency if the module Currency is in the license.
Description String Extra description for the payment that may be included in the bank export file.
DirectDebitMandate String Direct Debit Mandate used to collect the PaymentTerms.
DirectDebitMandateDescription String Description of the mandate.
DirectDebitMandatePaymentType Int Payment type of the mandate. other:parententityset=
DirectDebitMandateReference String Unique mandate reference.
DirectDebitMandateType Int Type of the mandate.
DiscountDueDate Datetime Date before which the payment must be done to be eligible for discount.
Division Int Division code.
Document String Document that is created when processing payments.
DocumentNumber Int Number of the document.
DocumentSubject String Subject of the document.
DueDate Datetime Date before which the payment must be done.
EndDate Datetime Date since when the payment is no longer an outstanding item.
EndPeriod Int Period since when the payment is no longer an outstanding item.
EndToEndID String The value of the tag 'EndToEndID' when generating a SEPA file.
EndYear Int Year (of period) since when the payment is no longer an outstanding item.
EntryDate Datetime Processing date of the payment.
EntryID String The unique identifier for a set of payments.
EntryNumber Int Entry number of the linked transaction.
GLAccount String G/L account of the payment. Must be of type 22.
GLAccountCode String Code of the G/L account.
GLAccountDescription String Description of the G/L account.
ID String Identifier of the PaymentTerms.
InvoiceDate Datetime Invoice date of the linked transaction.
InvoiceNumber Int Invoice number of the linked transaction.
IsBatchBooking Int Boolean indicating whether the payment is part of a batch booking.
IsFullyPaid Bool Boolean indicating whether the receivable was fully paid by the customer.
Journal String Journal of the linked transaction.
JournalDescription String Description of the journal.
LastPaymentDate Datetime Last payment date.
LineType Int Determines if the record is a payment or receipt. In case of payment the value is 22, in case of receipt the value is 20
Modified Datetime Last modified date.
Modifier String User
ModifierFullName String Name of modifier.
PaymentBatchNumber Int Number assigned during the of processing payments.
PaymentCondition String Payment condition of the linked transaction.
PaymentConditionDescription String Description of the payment condition.
PaymentDays Int Number of days between invoice date and due date.
PaymentDaysDiscount Int Number of days between invoice date and due date of the discount.
PaymentDiscountPercentage Double Payment discount percentage.
PaymentInformationID String PaymentInformationID tag from the SEPA xml file.
PaymentMethod String Method of payment.
PaymentReference String Payment reference for the payment that may be included in the bank export file.
PaymentSelected Datetime Date and time since when the payment is selected to be paid.
PaymentSelector String User who selected the payment to be paid.
PaymentSelectorFullName String Name of the payment selector.
RateFC Double Exchange rate from payment currency to division currency. AmountFC * RateFC = AmountDC.
ReceivableBatchNumber Int Number assigned during the processing of receivables.
ReceivableSelected Datetime Date and time since when the receivable is selected to be collected.
ReceivableSelector String User who selected the receivable to be collected.
ReceivableSelectorFullName String Name of the receivable selector.
Source Int The source of the payment.
Status Int The status of the payment.
TransactionAmountDC Double Total amount of the linked transaction in default currency.
TransactionAmountFC Double Total amount of the linked transaction in the selected currency.
TransactionDueDate Datetime Due date of the linked transaction.
TransactionEntryID String Linked transaction. Use this as reference to PurchaseEntries.
TransactionID String Linked transaction line. Use this as reference to PurchaseEntryLines.
TransactionIsReversal Bool Indicates if the linked transaction is a reversal entry.
TransactionReportingPeriod Int Period of the linked transaction.
TransactionReportingYear Int Year of the linked transaction.
TransactionStatus Int Status of the linked transaction.
TransactionType Int Type of the linked transaction.
YourRef String Invoice number of the supplier. In case the payment belongs to a bank entry line and is matched with one invoice, YourRef is filled with the YourRef of this invoice.

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