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. |