ReceivablesBulk: Exact Online Receivables
read only per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Cashflow - Chiavi primarie:
ID - Label: Receivables
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile solo recuperare i dati.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/bulk/Cashflow/Receivables - Metadati:
/api/v1/{division}/bulk/Cashflow/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 20,000 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella ReceivablesBulk. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filtri sulla piattaforma | The customer from which the receivable will come. | |
Account |
guid |
itgen_eol_accountbankaccountid | The bank account of the customer, from which the receivable will come. | ||
Account |
varchar2 |
itgen_eol_accountbankaccountnumber | The bank account number of the customer, from which the receivable will come. | ||
Account |
varchar2 |
Codice conto | The code of the customer from which the receivable will come. | ||
Account |
guid |
Contatti dell'account | Contact person copied from the purchase invoice linked to the related purchase entry. | ||
Account |
varchar2 |
Nome del referente dell'account | Name of the contact person of the customer. | ||
Account |
varchar2 |
Codice paese dell'account | Country code of the customer. | ||
Account |
varchar2 |
Nome dell'account | Name of the customer. | ||
Amount |
double |
Valuta della divisione degli importi | The amount in default currency (division currency).Receivables are matched on this amount. | ||
Amount |
double |
Importo dello sconto (valuta della divisione) | The amount of the discount in the default currency. | ||
Amount |
double |
Importo dello sconto (valuta estera) | The amount of the discount.This is in the amount of the selected currency. | ||
Amount |
double |
Importo in valuta estera | The amount of the receivable.This is in the amount of the selected currency. | ||
Bank |
guid |
Codice conto corrente | Own bank account to which the receivable will be done. | ||
Bank |
varchar2 |
Numero di conto bancario | Own bank account number to which the receivable will be done. | ||
Cashflow |
varchar2 |
Codice lotto delle transazioni di flusso di cassa | 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 |
Created | Creation date. | ||
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of the creator. | ||
Creator |
varchar2 |
Nome completo del creatore | Name of the creator. | ||
Currency |
varchar2 |
Currency | The currency of the receivable.This currency can only deviate from the division currency if the module Currency is in the license. | ||
Description |
varchar2 |
Description | Description. | ||
Direct |
guid |
Mandato di addebito diretto | Direct Debit Mandate used to collect the receivable. | ||
Direct |
varchar2 |
Descrizione dell'autorizzazione all'addebito diretto | Description of the mandate. | ||
Direct |
int16 |
Tipo di pagamento: mandato di addebito diretto | Payment type of the mandate.0 = One off payment 1 = Recurrent payment. | ||
Direct |
varchar2 |
Riferimento dell'autorizzazione all'addebito diretto | Unique mandate reference. | ||
Direct |
int16 |
Tipo di mandato di addebito diretto | Type of the mandate.0 = Core 1 = Business-to-business. | ||
Discount |
datetime |
Data di scadenza dello sconto | Date before which the payment by the customer must be done to be eligible for discount. | ||
Division |
int32 |
ID dell'azienda | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filtri sulla piattaforma | Document that is created when processing collections.The bank export file is attached to the document. | |
Document |
int32 |
Numero del documento | Number of the document. | ||
Document |
varchar2 |
Oggetto del documento | Subject of the document. | ||
Due |
datetime |
Scadenza | Date before which the payment by the customer must be done. | ||
End |
datetime |
Data di fine | filtri sulla piattaforma | Date since when the receivable is no longer an outstanding item.This is the highest invoice date of all matched receivables. | |
End |
int16 |
Fine di periodo | Period since when the receivable is no longer an outstanding item.This is the highest period of all matched receivables. | ||
End |
varchar2 |
ID end-to-end | The value of the tag 'EndToEndID' when generating a SEPA file. | ||
End |
int16 |
Fine dell'anno | 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. | ||
Entry |
datetime |
Data di ingresso | Processing date of the receivable. | ||
Entry |
guid |
ID di ingresso | filtri sulla piattaforma | 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. | |
Entry |
int32 |
Numero di ingresso | Entry number of the linked transaction. | ||
GL |
guid |
Conto di contabilità generale | filtri sulla piattaforma | G/L account of the payment.Must be of type 20 (Accounts receivable). | |
GL |
varchar2 |
Codice conto GL | Code of the G/L account. | ||
GL |
varchar2 |
Descrizione del conto GL | Description of the G/L account. | ||
ID |
guid |
ID | filtri sulla piattaforma | Identifier of the receivable. | |
Invoice |
datetime |
Data della fattura | filtri sulla piattaforma | Invoice date of the linked transaction. | |
Invoice |
int32 |
Numero della fattura | filtri sulla piattaforma | Invoice number of the linked transaction. | |
Is |
int16 |
Che cos'è la prenotazione in blocco? | Boolean indicating whether the receivable is part of a batch booking. | ||
Is |
char |
Interamente pagato | Boolean indicating whether the receivable was fully paid by the customer. | ||
Journal |
varchar2 |
Journal | Journal of the linked transaction. | ||
Journal |
varchar2 |
Descrizione del diario | Description of the journal. | ||
Last |
datetime |
Data dell'ultimo pagamento | Last payment date. | ||
Modified |
datetime |
Modified | Last modified date. | ||
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of modifier. | ||
Modifier |
varchar2 |
Nome completo modificato | Name of modifier. | ||
Order |
int32 |
Numero dell'ordine | writable | ||
Payment |
varchar2 |
Condizione di pagamento | Payment condition of the linked transaction. | ||
Payment |
varchar2 |
Descrizione delle condizioni di pagamento | Description of the payment condition. | ||
Payment |
int32 |
Giorni di pagamento | Number of days between invoice date and due date. | ||
Payment |
int32 |
Sconto "Payment Days" | Number of days between invoice date and due date of the discount. | ||
Payment |
double |
itgen_eol_paymentdiscountpercentage | Payment discount percentage. | ||
Payment |
varchar2 |
ID delle informazioni di pagamento | PaymentInformationID tag from the SEPA xml file. | ||
Payment |
varchar2 |
Metodo di pagamento | Method of payment.B = On credit (default) I = Collection K = Cash V = Credit card. | ||
Payment |
varchar2 |
Riferimento di pagamento | Payment reference for the receivable that may be included In the bank export file. | ||
RateFC |
double |
Tasso di cambio valuta estera | Exchange rate from receivable currency to division currency.AmountFC * RateFC = AmountDC. | ||
Receivable |
int32 |
Numero di lotto dei crediti | Number assigned during the processing of receivables. | ||
Receivable |
datetime |
Credito selezionato | Date and time since when the receivable is selected to be collected. | ||
Receivable |
guid |
Selettore dei crediti | User who selected the receivable to be collected. | ||
Receivable |
varchar2 |
itgen_eol_receivableselectorfullname | Name of the receivable selector. | ||
Source |
int32 |
Source | filtri sulla piattaforma | The source of the receivable.1 = manual 2 = reconcile 3 = match 4 = import 5 = process. | |
Status |
int16 |
Status | filtri sulla piattaforma | The status of the receivable.20 = open 30 = selected - receivable is selected to be collected 40 = processed - collection has been done 50 = matched - receivable is matched with one or more other outstanding items or financial statement lines. | |
Transaction |
double |
Importo della transazione Valuta di divisione | Total amount of the linked transaction in default currency (division currency). | ||
Transaction |
double |
Importo della transazione Valuta estera | Total amount of the linked transaction in the selected currency. | ||
Transaction |
datetime |
Data di scadenza della transazione | Due date of the linked transaction. | ||
Transaction |
guid |
ID registrazione transazione | Linked transaction.Use this as reference to SalesEntries. | ||
Transaction |
guid |
ID della transazione | filtri sulla piattaforma | Linked transaction line.Use this as reference to BankEntryLines and CashEntryLines. | |
Transaction |
char |
itgen_eol_transactionisreversal | Indicates if the linked transaction is a reversal entry. | ||
Transaction |
int16 |
itgen_eol_transactionreportingperiod | Period of the linked transaction. | ||
Transaction |
int16 |
itgen_eol_transactionreportingyear | Year of the linked transaction. | ||
Transaction |
int16 |
Stato della transazione | Status of the linked transaction. | ||
Transaction |
int32 |
Tipo di transazione | filtri sulla piattaforma | Type of the linked transaction. | |
Your |
varchar2 |
Il tuo Riferimento | 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. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Receivables |
Account |
BankAccounts.ID |
Key | |
Receivables |
Account |
Contacts.ID |
Key | |
Receivables |
Account |
Accounts.ID |
Key | |
Receivables |
Bank |
BankAccounts.ID |
Key | |
Receivables |
Creator |
Users. |
Key | |
Receivables |
Currency |
Currencies.Code |
Key | |
Receivables |
Direct |
DirectDebitMandates.ID |
Key | |
Receivables |
Document |
Documents.ID |
Key | |
Receivables |
GL |
GLAccounts.ID |
Key | |
Receivables |
Journal |
Journals.Code |
Key | |
Receivables |
Modifier |
Users. |
Key | |
Receivables |
Receivable |
Users. |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: