title: "RequestForQuotation" category: reference tags: [entity, request-for-quotation, datamodel] source: Entities.xml date: 2026-04-17 status: published
RequestForQuotation
Type: Entity Properties: 36 Contexts: 2 Statussen: 8
DB-schema:
lookup_table_schema("RequestForQuotation")· ../tables/RequestForQuotation
Contextsbewerken
- 0: Standaard (
RequestForQuotationContext.None) - 1: Standaard (
RequestForQuotationContext.Standard)
Statussenbewerken
- -1: Trash (
RequestForQuotationStatus.Trash) - 0: None (
RequestForQuotationStatus.None) - 1: Concept (
RequestForQuotationStatus.Concept) - 2: Verzonden (
RequestForQuotationStatus.Sent) - 4: Ontvangen (
RequestForQuotationStatus.Received) - 8: Geheel besteld (
RequestForQuotationStatus.CompletelyOrdered) - 16: Gedeeltelijk besteld (
RequestForQuotationStatus.PartiallyOrdered) - 32: Afgewezen (
RequestForQuotationStatus.Rejected)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | RFQID | 5 | false | |
| ConceptDate | DateTime? | RFQCONCEPTDATE | true | ||
| ConceptEmployee | Employee | RFQCONCEPTEMPID | true | ||
| Contact | Employee | RFQCONTACTEMPID | true | ||
| ContactEmailAddress | UltimoString | RFQPURCHCNTEMAIL | 80 | true | |
| Context | Context | RFQCONTEXT | false | 1 | |
| Currency | Currency | RFQCURID | false | ||
| CurrencyConversionFactor | Int16 | RFQCURCONVFACTOR | false | ||
| CurrencyRate | Decimal | RFQCURRATE | false | 0 | |
| DataProvider | UltimoString | RFQDATAPROVIDER | 50 | true | |
| Description | UltimoString | RFQDESCR | 200 | true | |
| Exported | Boolean | RFQEXPORTED | false | ||
| ExternalId | UltimoString | RFQEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | RFQEXTERNALSTATUS | 50 | true | |
| ProviderMutationDate | DateTime? | RFQPROVIDERMUTDATE | true | ||
| PurchaseDate | DateTime? | RFQPCHDATE | true | ||
| PurchaseEmployee | Employee | RFQPCHEMPID | true | ||
| PurchaseRequest | PurchaseRequest | RFQPCHRID | true | ||
| ReceiveDate | DateTime? | RFQRECEIVEDATE | true | ||
| ReceiveEmployee | Employee | RFQRECEIVEEMPID | true | ||
| RecordCreateDate | DateTime? | RFQRECCREATEDATE | true | SYSDATETIME | |
| Reference | UltimoString | RFQREFERENCE | 41 | true | |
| RejectDate | DateTime? | RFQREJECTDATE | true | ||
| RejectEmployee | Employee | RFQREJECTEMPID | true | ||
| RejectReason | RejectionReason | RFQREJRID | true | ||
| SentDate | DateTime? | RFQSENTDATE | true | ||
| SentEmployee | Employee | RFQSENTEMPID | true | ||
| Site | Site | RFQSITID | true | ||
| StandardTotalPrice | CompanyMoney | RFQSTDTOTALPRICE | false | 0 | |
| Status | Status | RFQRECSTATUS | false | ||
| SystemCompany | Company | RFQCOMPID | false | ||
| Text | UltimoString | RFQTEXT | true | ||
| TotalPrice | TransactionMoney | RFQTOTALPRICE | false | 0 | |
| TransferNextTime | Boolean | RFQTRANSFERNEXTTIME | false | 0 | |
| ValidDate | Date? | RFQVALIDDATE | true | ||
| Vendor | Vendor | RFQVDRID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("RequestForQuotation")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("RequestForQuotation")· ../tables/RequestForQuotation DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="RequestForQuotation")Before/After Save events voor RequestForQuotation. Bron:workflows.xml.