Receivables: Exact Online Debiteuren |
Catalogus: ExactOnlineREST
Schema: Cashflow
Primaire Sleutels: ID
Label: Debiteuren
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 Receivables 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 customer from which the receivable will come. |
AccountBankAccountID |
guid |
{res:itgen_eol_accountbankaccountid} |
☐ |
The bank account of the customer, from which the receivable will come. |
AccountBankAccountNumber |
string(50) |
{res:itgen_eol_accountbankaccountnumber} |
☐ |
The bank account number of the customer, from which the receivable will come. |
AccountCode |
string(18) |
Account Code |
☐ |
The code of the customer from which the receivable will come. |
AccountContact |
guid |
Account Contact |
☐ |
Contact person copied from the purchase invoice linked to the related purchase entry. |
AccountContactName |
string |
Naam Relatie Contactpersoon |
☐ |
Name of the contact person of the customer. |
AccountCountry |
string |
Relatie Landcode |
☐ |
Country code of the customer. |
AccountName |
string(50) |
Accountnaam |
☐ |
Name of the customer. |
AmountDC |
double |
Bedrag Administratie Munteenheid |
☑ |
The amount in default currency (division currency). Receivables 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 receivable. This is in the amount of the selected currency. |
BankAccountID |
guid |
Bankrekening ID |
☐ |
Own bank account to which the receivable will be done. |
BankAccountNumber |
string(50) |
Bankrekeningnummer |
☐ |
Own bank account number to which the receivable will be done. |
CashflowTransactionBatchCode |
string |
Kasstroom Transactie Batchcode |
☐ |
When processing receivables, all receivable 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 creator. |
Currency |
string(30) |
Valuta |
☐ |
The currency of the receivable. This currency can only deviate from the division currency if the module Currency is in the license. |
Description |
string |
Omschrijving |
☐ |
Description. |
DirectDebitMandate |
guid |
Machtiging Automatische Incasso |
☐ |
Direct Debit Mandate used to collect the receivable. |
DirectDebitMandateDescription |
string |
Mandaatomschrijving Automatische Incasso |
☐ |
Description of the mandate. |
DirectDebitMandatePaymentType |
int16 |
Soort Automatische Incassomachtiging |
☐ |
Payment type of the mandate. Possible values: see DirectDebitMandatePaymentTypes. |
DirectDebitMandateReference |
string |
Incassomandaat Referentie |
☐ |
Unique mandate reference. |
DirectDebitMandateType |
int16 |
Soort Automatische Incassomachtiging |
☐ |
Type of the mandate. Possible values: see DirectDebitMandateTypes. |
DiscountDueDate |
datetime |
Korting Vervaldag |
☐ |
Date before which the payment by the customer 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 collections. 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 by the customer must be done. |
EndDate |
datetime |
Einddatum |
☐ |
Date since when the receivable is no longer an outstanding item. This is the highest invoice date of all matched receivables. |
EndPeriod |
int16 |
Eindperiode |
☐ |
Period since when the receivable is no longer an outstanding item. This is the highest period of all matched receivables. |
EndToEndID |
string |
Eind-tot-eind ID |
☐ |
The value of the tag 'EndToEndID' when generating a SEPA file. |
EndYear |
int16 |
Einde Jaar |
☐ |
Year (of period) since when the receivable is no longer an outstanding item. This is the highest year of all matched receivables. Used in combination with EndPeriod. |
EntryDate |
datetime |
Boekdatum |
☐ |
Processing date of the receivable. |
EntryID |
guid |
Boeking ID |
☐ |
The unique identifier for a set of receivables. A receivable can be split so that one part is received 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 20 (Accounts receivable). |
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 receivable. |
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 receivable is part of a batch booking. |
IsFullyPaid |
boolean |
Volledig Betaald |
☑ |
Boolean indicating whether the receivable was fully paid by the customer. |
Journal |
string(20) |
Dagboek |
☐ |
Journal of the linked transaction. |
JournalDescription |
string(60) |
Dagboekomschrijving |
☐ |
Description of the journal. |
LastPaymentDate |
datetime |
Laatste Betalingsdatum |
☐ |
Last payment date. |
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. |
OrderNumber |
int32 |
Ordernummer |
☐ |
|
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. |
PaymentInformationID |
string |
Betalingsinformatie ID |
☐ |
PaymentInformationID tag from the SEPA xml file. |
PaymentMethod |
string |
Betalingsmethode |
☐ |
Method of payment. Possible values: see PaymentMethods. |
PaymentReference |
string(60) |
Betalingsreferentie |
☐ |
Payment reference for the receivable that may be included In the bank export file. |
RateFC |
double |
Wisselkoers Vreemde Valuta |
☐ |
Exchange rate from receivable currency to division currency. AmountFC * RateFC = AmountDC. |
ReceivableBatchNumber |
int32 |
Ontvangsten Batchnummer |
☐ |
Number assigned during the processing of receivables. |
ReceivableSelected |
datetime |
Ontvangbaar Geselecteerd |
☐ |
Date and time since when the receivable is selected to be collected. |
ReceivableSelector |
guid |
Ontvangbaarkiezer |
☐ |
User who selected the receivable to be collected. |
ReceivableSelectorFullName |
string(240) |
{res:itgen_eol_receivableselectorfullname} |
☐ |
Name of the receivable selector. |
Source |
int32 |
Bron |
☑ |
The source of the receivable. Possible values: see Sources. |
Status |
int16 |
Status |
☐ |
The status of the receivable. Possible values: see Statuses. |
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 SalesEntries. |
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. In case the receivable 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