PurchaseInvoices: Exact Online Purchase Invoices
insert update delete per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Purchase - Chiavi primarie:
ID - Label: Purchase Invoices
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/purchase/PurchaseInvoices - Metadati:
/api/v1/{division}/purchase/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| 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 PurchaseInvoices. 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 |
|---|---|---|---|---|---|
Amount |
double |
Amount | writable | The amount including VAT in the currency of the invoice. | |
Amount |
double |
Valuta della divisione degli importi | filters on the platform, writable | ||
Amount |
double |
Importo Sconto | filters on the platform, writable | ||
Amount |
double |
Importo Sconto IVA esclusa | filtri sulla piattaforma | ||
Amount |
double |
Importo in valuta estera, IVA esclusa | filtri sulla piattaforma | ||
Contact |
guid |
Persona di contatto | filters on the platform, writable | Guid identifying the contact person of the supplier. | |
Currency |
varchar2 |
Currency | writable | The code of the currency of the invoiced amount. | |
Description |
varchar2 |
Description | writable | The description of the invoice. | |
Discount |
double |
Discount | filtri sulla piattaforma | ||
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 | filters on the platform, writable | Guid identifying a document that is attached to the invoice. | |
Due |
datetime |
Scadenza | writable | The date before which the invoice has to be paid. | |
Entry |
int32 |
Numero di ingresso | filters on the platform, writable | The unique number of the purchase invoice.The entry number is based on a setting in the purchase journal and incremented for each new purchase invoice. | |
Exchange |
double |
Tasso di cambio | writable | The exchange rate between the invoice currency and the default currency of the division. | |
Financial |
int16 |
Periodo finanziario | writable | Financial period. | |
Financial |
int16 |
Esercizio finanziario | writable | The financial year in which the invoice is entered. | |
ID |
guid |
ID | filters on the platform, writable | A GUID that is the unique identifier of the purchase invoice. | |
Invoice |
datetime |
Data della fattura | filters on the platform, writable | The date on which the supplier entered the invoice. | |
Journal |
varchar2 |
Journal | filters on the platform, writable | The code of the purchase journal in which the invoice is entered. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Payment |
varchar2 |
Condizione di pagamento | filters on the platform, writable | The code of the payment condition that is used to calculate the due date and discount. | |
Payment |
varchar2 |
Riferimento di pagamento | writable | Unique reference to match payments and invoices. | |
Remarks |
varchar2 |
Remarks | writable | The user can enter remarks related to the invoice here. | |
Source |
int16 |
Source | writable | Indicates the origin of the invoice.1 Manual entry, 3 Purchase invoice, 4 Purchase order, 5 Web service. | |
Status |
int16 |
Status | writable | Lo stato della fattura.10 Draft, 20 Open, 50 Processed. | |
Supplier |
guid |
Supplier | filters on the platform, writable | Guid that identifies the supplier. | |
Type |
int16 |
Type | writable | Indicates the type of the purchase invoice.8030 Direct purchase invoice, 8031 Direct purchase invoice (Credit), 8033 Purchase invoice, 8034 Purchase invoice (Credit). | |
VAT |
double |
Importo IVA | writable | The total VAT amount of the purchase invoice. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Guid that identifies the warehouse that will receive the purchased goods.This is mandatory for creating a direct purchase invoice. | |
Your |
varchar2 |
Il tuo Riferimento | writable | The invoice number provided by the supplier. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Purchase |
Contact |
Contacts.ID |
Key | |
Purchase |
Currency |
Currencies.Code |
Key | |
Purchase |
Document |
Documents.ID |
Key | |
Purchase |
Journal |
Journals.Code |
Key | |
Purchase |
Supplier |
Accounts.ID |
Key | |
Purchase |
Warehouse |
Warehouses.ID |
Key |
Riferito da
- PurchaseInvoiceLines
InvoiceID(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: