PaymentsBulk: Exact Online Payments
read only per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Cashflow - Chiavi primarie:
ID - Label: Payments
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/Payments - 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 PaymentsBulk. 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 supplier to which the payment has to be done. | |
Account |
guid |
itgen_eol_accountbankaccountid | filtri sulla piattaforma | The bank account of the supplier, to which the payment has to be done. | |
Account |
varchar2 |
itgen_eol_accountbankaccountnumber | The bank account number of the supplier, to which the payment has to be done. | ||
Account |
varchar2 |
Codice conto | The code of the supplier to which the payment has to be done. | ||
Account |
guid |
Contatti dell'account | Contact person copied from the purchase invoice linked to the related purchase entry.Used as prefered contact when sending reminders. | ||
Account |
varchar2 |
Nome del referente dell'account | Name of the contact person of the supplier. | ||
Account |
varchar2 |
Nome dell'account | Name of the supplier. | ||
Amount |
double |
Valuta della divisione degli importi | The amount in default currency (division currency).Payments 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 payment.This is in the amount of the selected currency. | ||
Bank |
guid |
Codice conto corrente | filtri sulla piattaforma | Own bank account from which the payment must be done. | |
Bank |
varchar2 |
Numero di conto bancario | Own bank account number from which the payment must be done. | ||
Cashflow |
varchar2 |
Codice lotto delle transazioni di flusso di cassa | 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 |
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 payment.This currency can only deviate from the division currency if the module Currency is in the license. | ||
Description |
varchar2 |
Description | Extra description for the payment that may be included in the bank export file. | ||
Discount |
datetime |
Data di scadenza dello sconto | Date before which the payment 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 payments.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 must be done. | ||
End |
datetime |
Data di fine | filtri sulla piattaforma | Date since when the payment is no longer an outstanding item.This is the highest invoice date of all matched payments. | |
End |
int16 |
Fine di periodo | Period since when the payment is no longer an outstanding item.This is the highest period of all matched payments. | ||
End |
int16 |
Fine dell'anno | 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. | ||
Entry |
datetime |
Data di ingresso | filtri sulla piattaforma | Processing date of the payment. | |
Entry |
guid |
ID di ingresso | filtri sulla piattaforma | 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. | |
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 22 (Accounts payable). | |
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 payment. | |
Invoice |
datetime |
Data della fattura | Invoice date of the linked transaction. | ||
Invoice |
int32 |
Numero della fattura | Invoice number of the linked transaction. | ||
Is |
int16 |
Che cos'è la prenotazione in blocco? | Boolean indicating whether the payment is part of a batch booking. | ||
Journal |
varchar2 |
Journal | Journal of the linked transaction. | ||
Journal |
varchar2 |
Descrizione del diario | Description of the journal. | ||
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. | ||
Payment |
int32 |
Numero di lotto di pagamento | 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. | ||
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 |
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 payment that may be included in the bank export file. | ||
Payment |
datetime |
Modalità di pagamento selezionata | Date and time since when the payment is selected to be paid. | ||
Payment |
guid |
Selettore di pagamento | User who selected the payment to be paid. | ||
Payment |
varchar2 |
itgen_eol_paymentselectorfullname | Name of the payment selector. | ||
RateFC |
double |
Tasso di cambio valuta estera | Exchange rate from payment currency to division currency.AmountFC * RateFC = AmountDC. | ||
Source |
int32 |
Source | filtri sulla piattaforma | The source of the payment.1 = manual 2 = reconcile 3 = match 4 = import 5 = process. | |
Status |
int16 |
Status | filtri sulla piattaforma | The status of the payment.20 = open 30 = selected - payment is selected to be paid 40 = processed - payment has been done 50 = matched - payment 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 PurchaseEntries. | ||
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 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. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Payments |
Account |
BankAccounts.ID |
Key | |
Payments |
Account |
Contacts.ID |
Key | |
Payments |
Account |
Accounts.ID |
Key | |
Payments |
Bank |
BankAccounts.ID |
Key | |
Payments |
Creator |
Users. |
Key | |
Payments |
Currency |
Currencies.Code |
Key | |
Payments |
Document |
Documents.ID |
Key | |
Payments |
GL |
GLAccounts.ID |
Key | |
Payments |
Journal |
Journals.Code |
Key | |
Payments |
Modifier |
Users. |
Key | |
Payments |
Payment |
Users. |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: