PayablesList: Exact Online Schuldenlijst | 
		
Catalogus: ExactOnlineREST
Schema: Financial
Primaire Sleutels: HID
Label: Schuldenlijst
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Dit is een alleen-lezen tabel. De Exact Online API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Exact Online ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Exact Online-API.
Tabelkolommen
De kolommen van de tabel PayablesList worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam  | 
Datatype  | 
Label  | 
Verplicht  | 
Documentatie  | 
|---|---|---|---|---|
AccountCode  | 
string(18)  | 
Account Code  | 
☐  | 
Code of Account.  | 
AccountId  | 
guid  | 
Account ID  | 
☑  | 
Reference to the account.  | 
AccountName  | 
string(50)  | 
Accountnaam  | 
☐  | 
Name of account.  | 
Amount  | 
double  | 
Bedrag  | 
☑  | 
Amount.  | 
AmountInTransit  | 
double  | 
Bedrag Onderweg  | 
☑  | 
Amount in transit.  | 
ApprovalStatus  | 
int16  | 
Goedkeuringsstatus  | 
☐  | 
Approval status: null - Invoice was entered before approval functionality was activated (treated as Approved for payments), 1 - N/A (used for non-electronic payment methods), 2 - Awaiting review, 3 - Awaiting approval, 4 - Approved.  | 
CurrencyCode  | 
string(30)  | 
Valuta Code  | 
☐  | 
Code of Currency.  | 
Description  | 
string  | 
Omschrijving  | 
☐  | 
Description.  | 
Division  | 
int32  | 
Divisie ID  | 
☑  | 
Unique number of the Exact Online division.  | 
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.  | 
DueDate  | 
datetime  | 
Vervaldag  | 
☑  | 
Date the invoice should be paid.  | 
EntryNumber  | 
int32  | 
Boekingnummer  | 
☑  | 
Entry number.  | 
HID  | 
int64  | 
HID  | 
☑  | 
Primary key, human readable ID.  | 
Id  | 
guid  | 
ID  | 
☐  | 
Obsolete.  | 
InvoiceDate  | 
datetime  | 
Factuurdatum  | 
☑  | 
Invoice date.  | 
InvoiceNumber  | 
int32  | 
Factuurnummer  | 
☑  | 
Invoice number. The value is 0 when the invoice number of the linked transaction is empty.  | 
JournalCode  | 
string(20)  | 
Dagboekcode  | 
☐  | 
Code of Journal.  | 
JournalDescription  | 
string(60)  | 
Dagboekomschrijving  | 
☐  | 
Description of Journal.  | 
YourRef  | 
string(30)  | 
Uw Referentie  | 
☐  | 
Your reference.  | 
24-06-2025 18:54 Versie 24.1.116-BETA+5455
Exact Online API Data Model