invantive documentation
Invantive SupportforenAnmelden / Eintragen

InvoiceEmailInvoiceLinesByDocumentNumber: Fortnox Invoice Email Invoice Lines by Document Number

read only REST

  • Katalog: Fortnox
  • Schema: Invoices
  • Label: Invoice Email Invoice Lines by Document Number

Send an invoice as email You can use the properties in the EmailInformation to customize the e-mail message on each invoice.

Es können nur Daten abgerufen werden.

Zusammenfassung

You can use the properties in the EmailInformation to customize the e-mail message on each invoice.

API-Quelle

  • Endpunkt: /3/invoices/{DocumentNumber}/email
  • Operation: get /3/invoices/{DocumentNumber}/email

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 356
Anzahl der Vollscan-Zeilen pro Minute 85,000
Anzahl der Query-Zeilen pro Minute 168

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

Name Datentyp Required Default Documentation
DocumentNumber `` identifies the invoice
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
todate `` Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Tabellenspalten

Die Spalten der Tabelle InvoiceEmailInvoiceLinesByDocumentNumber sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
AccountNumber int32 Kontonummer writable, AccountNumber
AccountingMethod varchar2 Bilanzierungsmethode writable, ::ancestor.AccountingMethod
Address1 varchar2 Adresszeile 1 writable, ::ancestor.Address1
Address2 varchar2 Adresszeile 2 writable, ::ancestor.Address2
AdministrationFee double Verwaltungsgebühr writable, ::ancestor.AdministrationFee
AdministrationFeeVAT double Administration Fee VAT writable, ::ancestor.AdministrationFeeVAT
ArticleNumber varchar2 Artikelnummer writable, ArticleNumber
Balance double Balance writable, ::ancestor.Balance
BasisTaxReduction double Steuerermäßigung auf der Bemessungsgrundlage writable, ::ancestor.BasisTaxReduction
Booked char Booked writable, ::ancestor.Booked
Cancelled char Cancelled writable, ::ancestor.Cancelled
City varchar2(1024) City writable, ::ancestor.City
Comments varchar2(1024) Comments writable, ::ancestor.Comments
ContractReference int32 Geschäftszeichen / Bezug writable, ::ancestor.ContractReference
ContributionPercent varchar2 Beitragsprozentsatz writable, ContributionPercent
ContributionPercent_2 double Beitragsprozentsatz 2 writable, ::ancestor.ContributionPercent
ContributionValue varchar2 Beitragswert writable, ContributionValue
ContributionValue_2 double Beitragswert 2 writable, ::ancestor.ContributionValue
CostCenter varchar2 Kostenstelle writable, CostCenter
CostCenter_2 varchar2 Kostenstelle 2 writable, ::ancestor.CostCenter
Country varchar2 Country writable, ::ancestor.Country
Credit varchar2 Credit writable, ::ancestor.Credit
CreditInvoiceReference varchar2 Geschäftszeichen der Gutschriftsrechnung writable, ::ancestor.CreditInvoiceReference
Currency varchar2 Currency writable, ::ancestor.Currency
CurrencyRate double Währung writable, ::ancestor.CurrencyRate
CurrencyUnit int32 Währungseinheit writable, ::ancestor.CurrencyUnit
CustomerName varchar2 Name des Kunden writable, ::ancestor.CustomerName
CustomerNumber varchar2 Kundennummer writable, ::ancestor.CustomerNumber
DeliveredQuantity varchar2 Gelieferte Menge writable, DeliveredQuantity
DeliveryAddress1 varchar2(1024) Lieferadresse 1 writable, ::ancestor.DeliveryAddress1
DeliveryAddress2 varchar2(1024) Lieferadresse 2 writable, ::ancestor.DeliveryAddress2
DeliveryCity varchar2(1024) Stadt der Lieferung writable, ::ancestor.DeliveryCity
DeliveryCountry varchar2 Land der Lieferung writable, ::ancestor.DeliveryCountry
DeliveryDate datetime Liefertermin writable, ::ancestor.DeliveryDate
DeliveryName varchar2(1024) Name des Lieferanten writable, ::ancestor.DeliveryName
DeliveryZipCode varchar2(1024) Postleitzahl für die Lieferung writable, ::ancestor.DeliveryZipCode
Description varchar2(255) Description writable, Description
Discount double Discount writable, Discount
DiscountType varchar2 Rabatttyp writable, DiscountType
DocumentNumber varchar2 Dokumentnummer writable, ::ancestor.DocumentNumber
DueDate datetime Fälligkeitsdatum writable, ::ancestor.DueDate
EDIInformation_EDIGlobalLocationNumber varchar2(13) EDI-Informationen – Globale EDI-Standortnummer writable, ::ancestor.EDIInformation.EDIGlobalLocationNumber
EDIInformation_EDIGlobalLocationNumberDelivery varchar2(13) EDI-Informationen – EDI Global Location Number – Übermittlung writable, ::ancestor.EDIInformation.EDIGlobalLocationNumberDelivery
EDIInformation_EDIInvoiceExtra1 varchar2 EDI-Informationen – EDI-Rechnung Extra 1 writable, ::ancestor.EDIInformation.EDIInvoiceExtra1
EDIInformation_EDIInvoiceExtra2 varchar2 EDI-Informationen – EDI-Rechnung Extra 2 writable, ::ancestor.EDIInformation.EDIInvoiceExtra2
EDIInformation_EDIOurElectronicReference varchar2 EDI-Informationen EDI – Unser elektronisches Geschäftszeichen / Bezug writable, ::ancestor.EDIInformation.EDIOurElectronicReference
EDIInformation_EDIStatus varchar2 EDI-Informationen EDI-Status writable, ::ancestor.EDIInformation.EDIStatus
EDIInformation_EDIYourElectronicReference varchar2 EDI-Informationen – EDI: Ihr elektronisches Geschäftszeichen / Bezug writable, ::ancestor.EDIInformation.EDIYourElectronicReference
EUQuarterlyReport char EU-Quartalsbericht writable, ::ancestor.EUQuarterlyReport
EmailInformation_EmailAddressBCC varchar2 E-Mail-Informationen E-Mail-Adresse Bcc writable, ::ancestor.EmailInformation.EmailAddressBCC
EmailInformation_EmailAddressCC varchar2 E-Mail-Informationen E-Mail-Adresse CC writable, ::ancestor.EmailInformation.EmailAddressCC
EmailInformation_EmailAddressFrom varchar2 E-Mail-Informationen Absender-E-Mail-Adresse writable, ::ancestor.EmailInformation.EmailAddressFrom
EmailInformation_EmailAddressTo varchar2 E-Mail-Informationen E-Mail-Adresse An writable, ::ancestor.EmailInformation.EmailAddressTo
EmailInformation_EmailBody varchar2(20000) E-Mail-Informationen E-Mail-Text writable, ::ancestor.EmailInformation.EmailBody
EmailInformation_EmailSubject varchar2(100) E-Mail-Informationen E-Mail-Betreff writable, ::ancestor.EmailInformation.EmailSubject
ExternalInvoiceReference1 varchar2(80) Externe Geschäftszeichen / Bezug 1 writable, ::ancestor.ExternalInvoiceReference1
ExternalInvoiceReference2 varchar2(80) Externe Geschäftszeichen / Bezug 2 writable, ::ancestor.ExternalInvoiceReference2
FinalPayDate datetime Letzter Zahlungstermin writable, ::ancestor.FinalPayDate
Freight double Freight writable, ::ancestor.Freight
FreightVAT double Mehrwertsteuer auf Frachtkosten writable, ::ancestor.FreightVAT
Gross double Gross writable, ::ancestor.Gross
HouseWork char Hausarbeit writable, HouseWork
HouseWorkHoursToReport int32 Zu erstellenden Berichten über die im Haushalt zu meldenden Arbeitsstunden writable, HouseWorkHoursToReport
HouseWorkType varchar2 Haus-Arbeitstyp writable, HouseWorkType
HouseWork_2 char Hausarbeit 2 writable, ::ancestor.HouseWork
InvoiceDate datetime Rechnungsdatum writable, ::ancestor.InvoiceDate
InvoicePeriodEnd datetime Ende des Abrechnungszeitraums writable, ::ancestor.InvoicePeriodEnd
InvoicePeriodReference varchar2 Geschäftszeichen / Bezug zum Rechnungszeitraum writable, ::ancestor.InvoicePeriodReference
InvoicePeriodStart datetime Beginn des Abrechnungszeitraums writable, ::ancestor.InvoicePeriodStart
InvoiceType varchar2 Rechnungsart writable, ::ancestor.InvoiceType
Language varchar2 Language writable, ::ancestor.Language
LastRemindDate datetime Letzter Termin zur Erinnerung writable, ::ancestor.LastRemindDate
Net double Net writable, ::ancestor.Net
NotCompleted char Notcompleted writable, ::ancestor.NotCompleted
NoxFinans char Nox Finans writable, ::ancestor.NoxFinans
OCR varchar2 Ocr writable, ::ancestor.OCR
OfferReference varchar2 Angebotsgeschäftszeichen / Bezug writable, ::ancestor.OfferReference
OrderReference varchar2 Auftragsreferenz writable, ::ancestor.OrderReference
OrganisationNumber varchar2 Organisationsnummer writable, ::ancestor.OrganisationNumber
OurReference varchar2(50) Ourreference writable, ::ancestor.OurReference
OutboundDate datetime Versanddatum writable, ::ancestor.OutboundDate
PaymentWay varchar2 Zahlungsart writable, ::ancestor.PaymentWay
Phone1 varchar2(1024) Telefon 1 writable, ::ancestor.Phone1
Phone2 varchar2(1024) Telefon 2 writable, ::ancestor.Phone2
Price double Price writable, Price
PriceExcludingVAT double Preis ohne Mehrwertsteuer writable, PriceExcludingVAT
PriceList varchar2 Preisliste writable, ::ancestor.PriceList
PrintTemplate varchar2 Druck-Schablone writable, ::ancestor.PrintTemplate
Project varchar2 Project writable, Project
Project_2 varchar2 Projekt 2 writable, ::ancestor.Project
Remarks varchar2(1024) Remarks writable, ::ancestor.Remarks
Reminders int32 Reminders writable, ::ancestor.Reminders
RoundOff double Abrunden writable, ::ancestor.RoundOff
RowId int32 Zeilen-ID writable, RowId
Sent char Sent writable, ::ancestor.Sent
StockPointCode varchar2 Lager-Artikelnummer writable, StockPointCode
TaxReduction int32 Steuersenkung writable, ::ancestor.TaxReduction
TaxReductionType varchar2 Art der Steuerermäßigung writable, ::ancestor.TaxReductionType
TermsOfDelivery varchar2 Lieferbedingungen writable, ::ancestor.TermsOfDelivery
TermsOfPayment varchar2 Zahlungsbedingungen writable, ::ancestor.TermsOfPayment
TimeBasisReference int32 Zeitliche Bezugsgrundlage writable, ::ancestor.TimeBasisReference
Total double Total writable, Total
TotalExcludingVAT double Gesamtbetrag ohne Mehrwertsteuer writable, TotalExcludingVAT
TotalToPay double Zu zahlender Gesamtbetrag writable, ::ancestor.TotalToPay
TotalVAT double Total VAT writable, ::ancestor.TotalVAT
Total_2 double Insgesamt 2 writable, ::ancestor.Total
Unit varchar2 Unit writable, Unit
VAT int32 VAT writable, VAT
VATCode varchar2 Umsatzsteuer-IDNr. writable, VATCode
VATIncluded char Vatincluded writable, ::ancestor.VATIncluded
VoucherNumber int32 Gutscheinnummer writable, ::ancestor.VoucherNumber
VoucherSeries varchar2 Gutscheinserie writable, ::ancestor.VoucherSeries
VoucherYear int32 Gutscheinjahr writable, ::ancestor.VoucherYear
WarehouseReady char Auf Lager writable, ::ancestor.WarehouseReady
WayOfDelivery varchar2 Versandart writable, ::ancestor.WayOfDelivery
YourOrderNumber varchar2(75) Ihre Bestellnummer writable, ::ancestor.YourOrderNumber
YourReference varchar2(50) Ihre Referenz writable, ::ancestor.YourReference
ZipCode varchar2(1024) Postleitzahl writable, ::ancestor.ZipCode
c_url varchar2 URL aufrufen writable, ::ancestor.@url
c_urlTaxReductionList varchar2 Liste der URL-Steuerermäßigungen writable, ::ancestor.@urlTaxReductionList

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: