invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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.
AmountDC double Valuta della divisione degli importi filters on the platform, writable
AmountDiscount double Importo Sconto filters on the platform, writable
AmountDiscountExclVat double Importo Sconto IVA esclusa filtri sulla piattaforma
AmountFCExclVat double Importo in valuta estera, IVA esclusa filtri sulla piattaforma
ContactPerson guid Persona di contatto filters on the platform, writable Guid identifying the contact person of the supplier.
Currency varchar2(30) 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.
DivisionCompanyCoCNumber varchar2(60) Numero di iscrizione alla Camera di Commercio della Divisione writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Codice IBAN della divisione writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisione - Nome dell'azienda writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numero di divisione RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Partita IVA della divisione writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Codice fiscale salariale della divisione writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Etichetta della divisione writable Label of the Exact Online division.
DivisionName varchar2(50) Nome dell'amministrazione writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nome del titolare dell'abbonamento writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Numero di abbonato writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName 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.
DueDate datetime Scadenza writable The date before which the invoice has to be paid.
EntryNumber 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.
ExchangeRate double Tasso di cambio writable The exchange rate between the invoice currency and the default currency of the division.
FinancialPeriod int16 Periodo finanziario writable Financial period.
FinancialYear 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.
InvoiceDate datetime Data della fattura filters on the platform, writable The date on which the supplier entered the invoice.
Journal varchar2(20) 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.
ModifiedUtc datetime Modificato (UTC) writable Last modified date in UTC.
PaymentCondition varchar2(2) Condizione di pagamento filters on the platform, writable The code of the payment condition that is used to calculate the due date and discount.
PaymentReference varchar2(60) 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).
VATAmount 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.
YourRef varchar2(60) Il tuo Riferimento writable The invoice number provided by the supplier.

Chiavi

Key Column Si riferisce a Kind Description
PurchaseInvoices_ContactPerson_Contacts_fk ContactPerson Contacts.ID Key
PurchaseInvoices_Currency_Currencies_fk Currency Currencies.Code Key
PurchaseInvoices_Document_Documents_fk Document Documents.ID Key
PurchaseInvoices_Journal_Journals_fk Journal Journals.Code Key
PurchaseInvoices_Supplier_Accounts_fk Supplier Accounts.ID Key
PurchaseInvoices_Warehouse_Warehouses_fk Warehouse Warehouses.ID Key

Riferito da

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: