Quotations: Exact Online Offertes |
Catalogus: ExactOnlineREST
Schema: CRM
Primaire Sleutels: QuotationID
Label: Offertes
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Quotations 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.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
AmountDC |
double |
Bedrag Administratie Munteenheid |
☑ |
Amount in the default currency of the company. |
AmountDiscount |
double |
Kortingsbedrag |
☐ |
|
AmountDiscountExclVat |
double |
Kortingsbedrag exclusief BTW |
☐ |
|
AmountFC |
double |
Bedrag Vreemde Valuta |
☑ |
Amount in the currency of the transaction. |
CloseDate |
datetime |
Datum Gesloten |
☐ |
Date on which the customer accepted or rejected the quotation version. |
ClosingDate |
datetime |
Afsluitdatum |
☐ |
Date on which you expect to close/win the deal. |
Created |
datetime |
Gemaakt |
☑ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
Currency |
string(30) |
Valuta |
☐ |
The currency of the quotation. |
DeliveryAccount |
guid |
Levering Account |
☐ |
The account where the items should delivered. |
DeliveryAccountCode |
string(18) |
Afleverrelatie Code |
☐ |
The code of the delivery account. |
DeliveryAccountContact |
guid |
Afleverrelatie Contactpersoon |
☐ |
The contact person of the delivery account. |
DeliveryAccountContactFullName |
string(240) |
Afleverrelatie Contactpersoon Volledige Naam |
☐ |
Full name of the delivery account contact person. |
DeliveryAccountName |
string(50) |
Afleverrelatie Naam |
☐ |
The name of the delivery account. |
DeliveryAddress |
guid |
Afleveradres |
☐ |
The id of the delivery address. |
DeliveryDate |
datetime |
Leveringsdatum |
☐ |
|
Description |
string |
Omschrijving |
☐ |
The description of the quotation. |
Division |
int32 |
Divisie |
☑ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
Document |
guid |
Document |
☐ |
Document linked to the quotation. |
DocumentSubject |
string(256) |
Document Onderwerp |
☐ |
The subject of the document. |
DueDate |
datetime |
Vervaldag |
☐ |
Date after which the quotation is no longer valid. |
IncotermAddress |
string |
Incoterm-adres |
☐ |
|
IncotermCode |
string |
Incoterm-code |
☐ |
|
IncotermVersion |
int16 |
Incoterm-versie |
☐ |
|
InvoiceAccount |
guid |
Factuurrekening |
☐ |
The account to which the invoice is sent. |
InvoiceAccountCode |
string(18) |
Factuur Account Code |
☐ |
The code of the invoice account. |
InvoiceAccountContact |
guid |
Factuurrelatie Contactpersoon |
☐ |
The contact person of the invoice account. |
InvoiceAccountContactFullName |
string(240) |
Factuuraccount Volledige Naam Contactpersoon |
☐ |
Full name of the invoice account contact person. |
InvoiceAccountName |
string(50) |
Factuur Accountnaam |
☐ |
The name of the invoice account. |
Modified |
datetime |
Gewijzigd |
☑ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
Opportunity |
guid |
Verkoopkans |
☐ |
Opportunity linked to the quotation. |
OpportunityName |
string |
Verkoopkans Naam |
☐ |
The name of the opportunity. |
OrderAccount |
guid |
Verkooporder Klant |
☐ |
The account that requested the quotation. |
OrderAccountCode |
string(18) |
Bestelklant Code |
☐ |
The code of the order account. |
OrderAccountContact |
guid |
Verkooporder Relatiecontactpersoon |
☐ |
The contact person of the order account. |
OrderAccountContactFullName |
string(240) |
{res:itgen_eol_orderaccountcontactfullname} |
☐ |
Full name of the order account contact person. |
OrderAccountName |
string(50) |
Bestelling Relatienaam |
☐ |
The name of the order account. |
PaymentCondition |
string |
Betalingsvoorwaarde |
☐ |
|
PaymentConditionDescription |
string |
Betalingsconditie Omschrijving |
☐ |
|
Project |
guid |
Project |
☐ |
The project linked to the quotation. |
ProjectCode |
string(20) |
Projectcode |
☐ |
The code of the project. |
ProjectDescription |
string(60) |
Projectomschrijving |
☐ |
The description of the project. |
QuotationDate |
datetime |
Offertedatum |
☐ |
Date on which the quotation version is entered or printed. Both during entering and printing this date can be adjusted. |
QuotationID |
guid |
Offerte ID |
☑ |
Identifier of the quotation. |
QuotationNumber |
int32 |
Offertenummer |
☑ |
Unique number to indentify the quotation. By default this number is based on the setting for first available number. |
Remarks |
string |
Aantekeningen |
☐ |
Extra text that can be added to the quotation. |
SalesChannel |
guid |
Verkoopkanaal |
☐ |
|
SalesChannelCode |
string |
Verkoopkanaalcode |
☐ |
|
SalesChannelDescription |
string |
Verkoopkanaalomschrijving |
☐ |
|
SalesPerson |
guid |
Verkoper |
☐ |
The user that is responsible for the quotation version. |
SalesPersonFullName |
string(240) |
Verkoper Volledige Naam |
☐ |
Full name of the sales person. |
SelectionCode |
guid |
Selectiecode |
☐ |
ID of selection code. Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. |
SelectionCodeCode |
string |
Selectiecode |
☐ |
Code of selection code. |
SelectionCodeDescription |
string |
{res:itgen_eol_selectioncodedescription} |
☐ |
Description of selection code. |
ShippingMethod |
guid |
Verzendwijze |
☐ |
|
ShippingMethodDescription |
string |
Verzendmethode Omschrijving |
☐ |
|
Status |
int16 |
Status |
☐ |
The status of the quotation version. 5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = Accepted. |
StatusDescription |
string |
Statusomschrijving |
☐ |
The description of the status. |
VATAmountFC |
double |
BTW-bedrag Vreemde Valuta |
☐ |
Total VAT amount in the currency of the transaction. |
VersionNumber |
int32 |
Versienummer |
☑ |
Number indicating the different reviews which are made for the quotation. |
WarehouseCode |
string |
Magazijncode |
☐ |
|
WarehouseDescription |
string |
Magazijnomschrijving |
☐ |
|
WarehouseID |
guid |
Magazijn ID |
☐ |
|
YourRef |
string(30) |
Uw Referentie |
☐ |
The number by which this quotation is identified by the order account. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455