invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SalesInvoicesExploded: Exact Online Sales Invoices (Exploded)

read only per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: SalesInvoice
  • Primaire sleutels: SilID
  • Label: Sales Invoices (Exploded)

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /api/v1/{division}/salesinvoice/SalesInvoices?$expand=SalesInvoiceLines
  • Metagegevens: /api/v1/{division}/salesinvoice/$metadata

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 5
Aantal rijen per minuut bij volledige scan 7,200
Aantal rijen per minuut in een Query 300
Aantal rijen per minuut schrijven 300

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel SalesInvoicesExploded worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
AmountDC double Bedrag Administratie Munteenheid filters on the platform, writable, ::ancestor.::ancestor.AmountDC
AmountFC double Bedrag Vreemde Valuta filters on the platform, writable, ::ancestor.::ancestor.AmountFC
Created datetime Created filters on the platform, writable, ::ancestor.::ancestor.Created
Creator guid Creator filters on the platform, writable, ::ancestor.::ancestor.Creator
CreatorFullName varchar2 Aanmaker Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.CreatorFullName
Currency varchar2 Currency filters on the platform, writable, ::ancestor.::ancestor.Currency
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
Document guid Document filters on the platform, writable, ::ancestor.::ancestor.Document
DocumentNumber int32 Documentnummer filters on the platform, writable, ::ancestor.::ancestor.DocumentNumber
DocumentSubject varchar2 Document Onderwerp filters on the platform, writable, ::ancestor.::ancestor.DocumentSubject
DueDate datetime Vervaldag filters on the platform, writable, ::ancestor.::ancestor.DueDate
InvoiceDate datetime Factuurdatum filters on the platform, writable, ::ancestor.::ancestor.InvoiceDate
InvoiceID guid Factuur ID filters on the platform, writable, ::ancestor.::ancestor.InvoiceID
InvoiceNumber int32 Factuurnummer filters on the platform, writable, ::ancestor.::ancestor.InvoiceNumber
InvoiceTo guid Factuur aan filters on the platform, writable, ::ancestor.::ancestor.InvoiceTo
InvoiceToContactPerson guid Factuur aan Contactpersoon filters on the platform, writable, ::ancestor.::ancestor.InvoiceToContactPerson
InvoiceToContactPersonFullName varchar2 Factuur voor Contactpersoon Volledige naam filters on the platform, writable, ::ancestor.::ancestor.InvoiceToContactPersonFullName
InvoiceToName varchar2 Factuur aan Naam filters on the platform, writable, ::ancestor.::ancestor.InvoiceToName
Journal varchar2 Journal filters on the platform, writable, ::ancestor.::ancestor.Journal
JournalDescription varchar2 Dagboekomschrijving filters on the platform, writable, ::ancestor.::ancestor.JournalDescription
Modified datetime Modified filters on the platform, writable, ::ancestor.::ancestor.Modified
Modifier guid Modifier filters on the platform, writable, ::ancestor.::ancestor.Modifier
ModifierFullName varchar2 Gewijzigd Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.ModifierFullName
OrderDate datetime Besteldatum filters on the platform, writable, ::ancestor.::ancestor.OrderDate
OrderNumber int32 Ordernummer filters on the platform, writable, ::ancestor.::ancestor.OrderNumber
OrderedBy guid Besteld door filters on the platform, writable, ::ancestor.::ancestor.OrderedBy
OrderedByContactPerson guid Besteld door Contactpersoon filters on the platform, writable, ::ancestor.::ancestor.OrderedByContactPerson
OrderedByContactPersonFullName varchar2 Besteld door Contactpersoon Volledige naam filters on the platform, writable, ::ancestor.::ancestor.OrderedByContactPersonFullName
OrderedByName varchar2 Besteld door Naam filters on the platform, writable, ::ancestor.::ancestor.OrderedByName
PaymentCondition varchar2 Betalingsvoorwaarde filters on the platform, writable, ::ancestor.::ancestor.PaymentCondition
PaymentConditionDescription varchar2 Betalingsconditie Omschrijving filters on the platform, writable, ::ancestor.::ancestor.PaymentConditionDescription
PaymentReference varchar2 Betalingskenmerk filters on the platform, writable, ::ancestor.::ancestor.PaymentReference
Remarks varchar2 Remarks filters on the platform, writable, ::ancestor.::ancestor.Remarks
Salesperson guid Verkoper filters on the platform, writable, ::ancestor.::ancestor.Salesperson
SalespersonFullName varchar2 Verkoper Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.SalespersonFullName
SilAmountDC double Verkoopregelbedrag Administratievaluta writable, AmountDC
SilAmountFC double Verkoopregelbedrag Vreemde Valuta writable, AmountFC
SilCostCenter varchar2 Verkoopregel Kostenplaats writable, CostCenter
SilCostCenterDescription varchar2 itgen_eol_silcostcenterdescription writable, CostCenterDescription
SilCostUnit varchar2 Verkoopregel Kostendrager writable, CostUnit
SilCostUnitDescription varchar2 itgen_eol_silcostunitdescription writable, CostUnitDescription
SilDeliveryDate datetime Verkooprregel Leverdatum writable, DeliveryDate
SilDescription varchar2 Verkoopregelomschrijving writable, Description
SilDiscount double Verkoopregelkorting writable, Discount
SilDivision int32 Verkoopregeladministratie writable, Division
SilEmployee guid Verkoopregelmedewerker writable, Employee
SilEmployeeFullName varchar2 Verkoopregel Medewerker Volledige Naam writable, EmployeeFullName
SilEndTime datetime Verkoopregel Eindtijd writable, EndTime
SilGLAccount guid Verkoopregel Grootboekrekening writable, GLAccount
SilGLAccountDescription varchar2 itgen_eol_silglaccountdescription writable, GLAccountDescription
SilID guid Verkoopregel-ID writable, ID
SilInvoiceID guid Verkoopregel Factuur-ID writable, InvoiceID
SilItem guid Verkoopregelartikel writable, Item
SilItemCode varchar2 Verkoopregelartikelcode writable, ItemCode
SilItemDescription varchar2 Verkoopregelartikelomschrijving writable, ItemDescription
SilLineNumber int32 Verkoopregelnummer writable, LineNumber
SilNetPrice double Verkoopregel Nettoprijs writable, NetPrice
SilNotes varchar2 Verkoopregelnotities writable, Notes
SilPricelist guid Verkoopregel Prijslijst writable, Pricelist
SilPricelistDescription varchar2 itgen_eol_silpricelistdescription writable, PricelistDescription
SilProject guid Verkoopregel Project writable, Project
SilProjectDescription varchar2 itgen_eol_silprojectdescription writable, ProjectDescription
SilQuantity double Verkoopregel Hoeveelheid writable, Quantity
SilSalesOrder guid Verkooporder writable, SalesOrder
SilSalesOrderLine guid Verkoopregel writable, SalesOrderLine
SilSalesOrderLineNumber int32 itgen_eol_silsalesorderlinenumber writable, SalesOrderLineNumber
SilSalesOrderNumber int32 Verkoopregel Ordernummer writable, SalesOrderNumber
SilStartTime datetime Verkoopregel Starttijd writable, StartTime
SilSubscription guid Verkoopregel Abonnement writable, Subscription
SilSubscriptionDescription varchar2 itgen_eol_silsubscriptiondescription writable, SubscriptionDescription
SilTaxSchedule guid Verkoopregel Belastingschema writable, TaxSchedule
SilTaxScheduleCode varchar2 Verkoopregel Belastingschemacode writable, TaxScheduleCode
SilTaxScheduleDescription varchar2 itgen_eol_siltaxscheduledescription writable, TaxScheduleDescription
SilUnitCode varchar2 Verkoopregel Eenheidscode writable, UnitCode
SilUnitDescription varchar2 Verkoopregel Eenheidsomschrijving writable, UnitDescription
SilUnitPrice double Verkooplijn Eenheidsprijs writable, UnitPrice
SilVATAmountDC double Verkoopregel BTW-bedrag Administratievaluta writable, VATAmountDC
SilVATAmountFC double Verkoopregel BTW-bedrag Vreemde Valuta writable, VATAmountFC
SilVATCode varchar2 Verkoopregel BTW-code writable, VATCode
SilVATCodeDescription varchar2 itgen_eol_silvatcodedescription writable, VATCodeDescription
SilVATPercentage double Verkoopregel BTW-percentage writable, VATPercentage
StarterSalesInvoiceStatus int16 Verkoopfactuurstatus writable, ::ancestor.::ancestor.StarterSalesInvoiceStatus
StarterSalesInvoiceStatusDescription varchar2 itgen_eol_startersalesinvoicestatusdescription writable, ::ancestor.::ancestor.StarterSalesInvoiceStatusDescription
Status int16 Status filters on the platform, writable, ::ancestor.::ancestor.Status
StatusDescription varchar2 Statusomschrijving filters on the platform, writable, ::ancestor.::ancestor.StatusDescription
TaxSchedule guid Belastingplan filters on the platform, writable, ::ancestor.::ancestor.TaxSchedule
TaxScheduleCode varchar2 Belasting Planningscode filters on the platform, writable, ::ancestor.::ancestor.TaxScheduleCode
TaxScheduleDescription varchar2 Belasting Planningsomschrijving filters on the platform, writable, ::ancestor.::ancestor.TaxScheduleDescription
Type int32 Type filters on the platform, writable, ::ancestor.::ancestor.Type
TypeDescription varchar2 Soort Omschrijving filters on the platform, writable, ::ancestor.::ancestor.TypeDescription
VATAmountDC double BTW Bedrag Administratie Valuta filters on the platform, writable, ::ancestor.::ancestor.VATAmountDC
VATAmountFC double BTW-bedrag Vreemde Valuta filters on the platform, writable, ::ancestor.::ancestor.VATAmountFC
YourRef varchar2(60) Uw Referentie filters on the platform, writable, ::ancestor.::ancestor.YourRef

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: