Payments: Exact Online Betalingen |
Catalogus: ExactOnlineREST
Schema: Cashflow
Primaire Sleutels: ID
Label: Betalingen
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Payments worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Account |
guid |
Account |
☐ |
The supplier to which the payment has to be done. |
AccountBankAccountID |
guid |
{res:itgen_eol_accountbankaccountid} |
☐ |
The bank account of the supplier, to which the payment has to be done. |
AccountBankAccountNumber |
string(50) |
{res:itgen_eol_accountbankaccountnumber} |
☐ |
The bank account number of the supplier, to which the payment has to be done. |
AccountCode |
string(18) |
Account Code |
☐ |
The code of the supplier to which the payment has to be done. |
AccountContact |
guid |
Account Contact |
☐ |
Contact person copied from the purchase invoice linked to the related purchase entry. Used as prefered contact when sending reminders. |
AccountContactName |
string |
Naam Relatie Contactpersoon |
☐ |
Name of the contact person of the supplier. |
AccountName |
string(50) |
Accountnaam |
☐ |
Name of the supplier. |
AmountDC |
double |
Bedrag Administratie Munteenheid |
☑ |
The amount in default currency (division currency). Payments are matched on this amount. |
AmountDiscountDC |
double |
Kortingsbedrag (divisievaluta) |
☑ |
The amount of the discount in the default currency. |
AmountDiscountFC |
double |
Kortingsbedrag (vreemde valuta) |
☑ |
The amount of the discount. This is in the amount of the selected currency. |
AmountFC |
double |
Bedrag Vreemde Valuta |
☑ |
The amount of the payment. This is in the amount of the selected currency. |
BankAccountID |
guid |
Bankrekening ID |
☐ |
Own bank account from which the payment must be done. |
BankAccountNumber |
string(50) |
Bankrekeningnummer |
☐ |
Own bank account number from which the payment must be done. |
CashflowTransactionBatchCode |
string |
Kasstroom Transactie Batchcode |
☐ |
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 |
Gemaakt |
☑ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of the creator. |
Currency |
string(30) |
Valuta |
☐ |
The currency of the payment. This currency can only deviate from the division currency if the module Currency is in the license. |
Description |
string |
Omschrijving |
☐ |
Extra description for the payment that may be included in the bank export file. |
DiscountDueDate |
datetime |
Korting Vervaldag |
☐ |
Date before which the payment must be done to be eligible for discount. |
Division |
int32 |
Divisie |
☑ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
Document |
guid |
Document |
☐ |
Document that is created when processing payments. The bank export file is attached to the document. |
DocumentNumber |
int32 |
Documentnummer |
☐ |
Number of the document. |
DocumentSubject |
string(256) |
Document Onderwerp |
☐ |
Subject of the document. |
DueDate |
datetime |
Vervaldag |
☐ |
Date before which the payment must be done. |
EndDate |
datetime |
Einddatum |
☐ |
Date since when the payment is no longer an outstanding item. This is the highest invoice date of all matched payments. |
EndPeriod |
int16 |
Eindperiode |
☐ |
Period since when the payment is no longer an outstanding item. This is the highest period of all matched payments. |
EndYear |
int16 |
Einde Jaar |
☐ |
Year (of period) since when the payment is no longer an outstanding item. This is the highest year of all matched payments. Used in combination with EndPeriod. |
EntryDate |
datetime |
Boekdatum |
☐ |
Processing date of the payment. |
EntryID |
guid |
Boeking ID |
☐ |
The unique identifier for a set of payments. A payment can be split so that one part is paid on a different date. In that case the two records get a different EntryID. |
EntryNumber |
int32 |
Boekingnummer |
☐ |
Entry number of the linked transaction. |
GLAccount |
guid |
Grootboekrekening |
☐ |
G/L account of the payment. Must be of type 22 (Accounts payable). |
GLAccountCode |
string(30) |
Grootboekrekening Code |
☐ |
Code of the G/L account. |
GLAccountDescription |
string(60) |
Grootboekrekening Omschrijving |
☐ |
Description of the G/L account. |
ID |
guid |
ID |
☑ |
Identifier of the payment. |
InvoiceDate |
datetime |
Factuurdatum |
☐ |
Invoice date of the linked transaction. |
InvoiceNumber |
int32 |
Factuurnummer |
☐ |
Invoice number of the linked transaction. |
IsBatchBooking |
int16 |
Is Batchboeking |
☐ |
Boolean indicating whether the payment is part of a batch booking. |
Journal |
string(20) |
Dagboek |
☐ |
Journal of the linked transaction. |
JournalDescription |
string(60) |
Dagboekomschrijving |
☐ |
Description of the journal. |
Modified |
datetime |
Gewijzigd |
☑ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
PaymentBatchNumber |
int32 |
Betalingsbatchnummer |
☐ |
Number assigned during the of processing payments. When payments are processed a bank export file is created. This file contains one or more batches that contain one or more payments. Each batch gets a sequence number that is stored for each payment in that batch. |
PaymentCondition |
string(2) |
Betalingsvoorwaarde |
☐ |
Payment condition of the linked transaction. |
PaymentConditionDescription |
string(60) |
Betalingsconditie Omschrijving |
☐ |
Description of the payment condition. |
PaymentDays |
int32 |
Betalingsdagen |
☐ |
Number of days between invoice date and due date. |
PaymentDaysDiscount |
int32 |
Kortingsdagen Betaling |
☐ |
Number of days between invoice date and due date of the discount. |
PaymentDiscountPercentage |
double |
{res:itgen_eol_paymentdiscountpercentage} |
☐ |
Payment discount percentage. |
PaymentMethod |
string(1) |
Betalingsmethode |
☐ |
Method of payment.B = On credit (default)I = CollectionK = CashV = Credit card. |
PaymentReference |
string(60) |
Betalingsreferentie |
☐ |
Payment reference for the payment that may be included in the bank export file. |
PaymentSelected |
datetime |
Geselecteerde Betaling |
☐ |
Date and time since when the payment is selected to be paid. |
PaymentSelector |
guid |
Betalingskiezer |
☐ |
User who selected the payment to be paid. |
PaymentSelectorFullName |
string(240) |
{res:itgen_eol_paymentselectorfullname} |
☐ |
Name of the payment selector. |
RateFC |
double |
Wisselkoers Vreemde Valuta |
☐ |
Exchange rate from payment currency to division currency. AmountFC * RateFC = AmountDC. |
Source |
int32 |
Bron |
☑ |
The source of the payment. Possible values: see PaymentSources. |
Status |
int16 |
Status |
☐ |
The status of the payment. Possible values: see PaymentStatuses. |
TransactionAmountDC |
double |
Transactiebedrag Administratievaluta |
☑ |
Total amount of the linked transaction in default currency (division currency). |
TransactionAmountFC |
double |
Transactiebedrag Vreemde Valuta |
☑ |
Total amount of the linked transaction in the selected currency. |
TransactionDueDate |
datetime |
Vervaldatum Transactie |
☐ |
Due date of the linked transaction. |
TransactionEntryID |
guid |
Mutatie Invoer-ID |
☐ |
Linked transaction. Use this as reference to PurchaseEntries. |
TransactionID |
guid |
Transactie ID |
☐ |
Linked transaction line. Use this as reference to BankEntryLines and CashEntryLines. |
TransactionIsReversal |
boolean |
{res:itgen_eol_transactionisreversal} |
☑ |
Indicates if the linked transaction is a reversal entry. |
TransactionReportingPeriod |
int16 |
{res:itgen_eol_transactionreportingperiod} |
☐ |
Period of the linked transaction. |
TransactionReportingYear |
int16 |
{res:itgen_eol_transactionreportingyear} |
☐ |
Year of the linked transaction. |
TransactionStatus |
int16 |
Transactiestatus |
☐ |
Status of the linked transaction. |
TransactionType |
int32 |
Transactiesoort |
☐ |
Type of the linked transaction. |
YourRef |
string(30) |
Uw Referentie |
☐ |
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. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455