Rfqs

The following are the schemas and relationships of the Quotation tables, which are called RFQs (Request for quotation).

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Last record update	Datetime
SnapshotAt	Reference date of the transaction	Datetime
TimeKey	Incremental temporal value	String
RfqId	Primary key for the RFQ (quotation) schema	String
Summary	Quotation summary	String
ClientCode	Customer code in the quotation	String
CustomerId	Customer identifier in the quotation	String
CustomerTradingName	Customer trade name in the quotation	String
OwnerId	Quotation owner identifier	String
OwnerName	Quotation owner name	String
Deadline	Quotation delivery deadline in days	Datetime
CreatedDate	Date when the quotation was created	Datetime
Public	True if the quotation is public; otherwise, False	Boolean
Invisible	True if there is no active supplier participation; otherwise, False	Boolean
CategoryName	Category name	String
CategoryDescription	Category description	String
StatusPendencyType	Pendency status	Enum
NegotiationPhaseType	Negotiation phase type	Enum
StatusType	Quotation status type	Enum
Origin	Quotation origin	Enum
OriginalRfq	Original quotation	String
CreatedDateShortlist	Date when the quotation shortlist was created	Datetime
ContractId	Contract identifier	String
PresentValueDailyTax	Daily rate of the Present Value	Double
Note	Additional notes	String

Rfqs Schema Joins

The Rfqs schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqTasks	RfqId	Relates the Rfq rows with the RfqTasks rows
RfqResponseItems	RfqId	Relates the Rfq rows with the RfqResponseItems rows
RfqResponseItemHistory	RfqId	Relates the Rfq rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId	Relates the Rfq rows with the RfqResponseItemCounterProposals rows
RfqItems	RfqId	Relates the Rfq rows with the RfqItems rows
RfqItemRequests	RfqId	Relates the Rfq rows with the RfqItemRequests rows
RfqBorgs	RfqId	Relates the Rfq rows with the RfqBorgs rows
RfqAttendees	RfqId	Relates the Rfq rows with the RfqAttendees rows
RfqResponseTaxes	RfqId	Relates the Rfq rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the Rfq rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the Rfq rows with the RfqItemAttributeValues rows

RfqItems

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Integer
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	Long
ProductRfq	Product code/key in the quotation table. Note: The same ProductId, if present in two different quotations, will have 2 ProductRfq values	Integer
Quantity	Item quantity in the quotation	Double
ItemNumber	Item number in the quotation	Integer
ProductId	Buyer’s product registration code. Note: The same ProductId, if present in two different quotations, will have 2 ProductRfq values	Integer
Code	Quotation item code	String
ClientCode	Customer code for the quotation item	String
Measure	Unit of measure for the quotation item	String
GroupId	Group identifier for the quotation item	String
GroupClientCode	Customer code of the quotation item group	String
GroupDescription	Description of the quotation item group	String
GroupParent	Parent group of the quotation item	String
EstimatedDeadline	Estimated lead time in days for the quotation item	Integer
Status	Quotation item status	String
Description	Description of the quotation item	String
Complement	Complementary information for the quotation item	String
ProductMaterialType	Indicates whether the product is a material or a service	String
ProductGeneric	Indicates whether the product is generic. Product with code = "False" Product without code generic = "True"	Boolean
Canceled	Indicates whether the quotation item was canceled true or false	Boolean
FirstPrice	Amount submitted in the first quotation. Does not correspond to the final amount	Double
CreatedDate	Creation date of the quotation item	Datetime
ApplicationType	Material application code used for taxation purposes	String
ApplicationTypeId	Material application identifier	String
EstimatedBaselinePrice	Estimated baseline price	Double
ChosenSupplierId	ID of the supplier selected by the buyer for the item	Integer

RfqItems Schema Joins

The RfqItems schema has relationships with the following schemas:

Schema	Relationship Column	Description
Rfqs	RfqId	Relates the RFQItems rows with the RFQs rows
RfqTasks	RfqId	Relates the RFQItems rows with the RfqTasks rows
RfqBorgs	RfqId	Relates the RFQItems rows with the RfqBorgs rows
RfqAttendees	RfqId	Relates the RFQItems rows with the RfqAttendee rows
RfqResponseItems	RfqId and RfqItemId	Relates the RFQItems rows with the RfqResponseItems rows
RfqResponseItemHistory	RfqId and RfqItemId	Relates the RFQItems rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RFQItems rows with the RfqResponseItemCounterProposals rows
RfqItemRequests	RfqId and RfqItemId	Relates the RFQItems rows with the RfqItemRequests rows
RfqResponseTaxes	RfqId and RfqItemId	Relates the RFQItems rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RFQItems rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RFQItems rows with the RfqItemAttributeValues rows

RfqItemRequests

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	Long
RequestId	Primary key for the request schema	String
RequestItemId	Request item number	String
CreatedDate	Quotation creation date	Datetime

RfqItemRequests Schema Joins

The RfqItemRequests schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqTasks	RfqId	Relates the RFQItemRequests rows with the RfqTasks rows
Rfqs	RfqId	Relates the RFQItemRequests rows with the RfqItems rows
RfqBorgs	RfqId	Relates the RFQItemRequests rows with the RfqBorgs rows
RfqAttendees	RfqId	Relates the RFQItemRequests rows with the RfqAttendees rows
RfqResponseItems	RfqId and RfqItemId	Relates the RFQItemRequests rows with the RfqResponseItems rows
RfqResponseItemHistory	RfqId and RfqItemId	Relates the RFQItemRequests rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RFQItemRequests rows with the RfqResponseItemCounterProposals rows
RFQItems	RfqId and RfqItemId	Relates the RFQItemRequests rows with the RfqItems rows
Requests	RequestId	Relates the RFQItemRequests rows with the Requests rows
RequestBorgs	RequestId	Relates the RFQItemRequests rows with the RequestBorgs rows
RequestAddresses	RequestId	Relates the RFQItemRequests rows with the RequestAddresses rows
RequestItems	RequestId and RequestItemId	Relates the RFQItemRequests rows with the RequestItems rows
RequestItemBorgs	RequestId and RequestItemId	Relates the RFQItemRequests rows with the RequestItemBorgs rows
RequestItemMags	RequestId and RequestItemId	Relates the RFQItemRequests rows with the RequestItemMags rows
RequestItemStatus	RequestId and RequestItemId	Relates the RFQItemRequests rows with the RequestItemStatus rows

RfqResponseItems

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	Long
RfqAttendeeId	Identifier of the quotation participant	String
ProductRfq	Product item identifier in the quotation response	Long
AnswerDate	Response date	Datetime
Refused	True if refused, otherwise false	Boolean
Price	Item price in the quotation response	Double
Deadline	Delivery lead time in days in the quotation response	Integer
Note	Item note in the quotation response	String
IcoTerms	Incoterms	String
DeliveryDate	Item delivery date in the quotation response	Datetime
Freight	Item freight value in the quotation response	Double
TotalPrice	Total item price in the quotation response	Double
TotalWithTaxes	Total item amount with taxes in the quotation response	Double
IvaCode	VAT code	String
IvaValid	Indicates whether VAT is valid	Boolean
CurrencyCode	Currency code	String
FirstResponseValue	First response value for the quotation item. This value is not updated. If the first response is cancelled, it remains the value considered by this field	Double
SupplierName	Supplier name	String
SupplierOrigin	Supplier origin	String
SupplierOriginId	Supplier origin ID	Integer
SupplierOriginDescription	Description of supplier origin. Example: MySupplier, Marketplace	String
SupplierCode	Supplier code	String
RfqTypeId	Identifier indicating whether the quotation is private or public 0 = private, 1 = public	Integer
RfqTypeDescription	Description of quotation type private or public	String
PaymentCondition	Payment terms	String
ExpirationDate	Quotation expiration date	Datetime
BuyerName	Responsible buyer name	String
BuyerId	Responsible buyer ID	String
Measure	Unit of measure of the item in the quotation response	String
GrossPrice	Gross item price in the quotation response	Double
NetPrice	Net item price in the quotation response	Double
PresentValueNetUnitPrice	Net unit price at present value excluding taxes	Decimal
PresentValueUnitPriceWithTax	Unit price at present value including taxes	Decimal
PresentValueEqualizedUnitPrice	Equalized unit price at present value	Decimal
PresentValueTotalNetPrice	Total net price at present value excluding taxes	Decimal
PresentValueTotalWithTaxes	Total price at present value including taxes	Decimal
PresentValueTotalEqualized	Equalized total price at present value	Decimal
TargetDate	Deadline date for item delivery in the quotation response	Datetime
CreatedDate	Creation date of the quotation response	Datetime

RfqResponseItems Schema Joins

The RfqResponseItems schema has relationships with the following schemas:

Schema	Relationship Column	Description
Rfqs	RfqId	Relates the RFQResponseItems rows with the Rfqs rows
RfqTasks	RfqId	Relates the RFQResponseItems rows with the RfqTasks rows
RfqBorgs	RfqId	Relates the RFQResponseItems rows with the RfqBorgs rows
RfqResponseItemHistory	RfqId and RfqItemId	Relates the RFQResponseItems rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RFQResponseItems rows with the RfqResponseItemCounterProposals rows
RfqItems	RfqId and RfqItemId	Relates the RFQResponseItems rows with the RfqItems rows
RfqItemRequests	RfqId and RfqItemId	Relates the RFQResponseItems rows with the RfqItemRequests rows
RfqAttendees	RfqId and RfqAttendeeId	Relates the RFQResponseItems rows with the RfqAttendees rows
RfqResponseTaxes	RfqId and RfqItemId	Relates the RFQResponseItems rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RFQResponseItems rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RFQResponseItems rows with the RfqItemAttributeValues rows

RfqResponseItemHistory

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	Long
RfqAttendeeId	Identifier of the quotation participant	String
ProductId	Product identifier	Long
AnswerDate	Response date	Datetime
Price	Item price in the response	Double
Active	True if the quotation response item is active, otherwise false	Boolean
CreatedDate	Creation date of the quotation item	Datetime

RfqResponseItemHistory Schema Joins

The RfqResponseItemHistory schema has relationships with the following schemas:

Schema	Relationship Column	Description
Rfqs	RfqId	Relates the RFQResponseItemHistory rows with the Rfqs rows
RfqTasks	RfqId	Relates the RFQResponseItemHistory rows with the RfqTasks rows
RfqBorgs	RfqId	Relates the RFQResponseItemHistory rows with the RfqBorgs rows
RfqResponseItems	RfqId and RfqItemId	Relates the RFQResponseItemHistory rows with the RfqResponseItems rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RFQResponseItemHistory rows with the RfqResponseItemCounterProposals rows
RfqItems	RfqId and RfqItemId	Relates the RFQResponseItemHistory rows with the RfqItems rows
RfqItemRequests	RfqId and RfqItemId	Relates the RFQResponseItemHistory rows with the RfqItemRequests rows
RfqAttendees	RfqId and RfqAttendeeId	Relates the RFQResponseItemHistory rows with the RfqAttendees rows
RfqResponseTaxes	RfqId and RfqItemId	Relates the RFQResponseItemHistory rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RFQResponseItemHistory rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RFQResponseItemHistory rows with the RfqItemAttributeValues rows

RfqAttendees

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	String
RfqId	Primary key for the quotation schema	String
RfqAttendeeId	Identifier of the quotation participant	String
SupplierId	Supplier identifier	String
SupplierName	Supplier name	String
Freight	Freight of the quotation participant	Double
IcoTerms	For more information, see Incoterms	String
Refused	True if the quotation participant refused, otherwise false	Boolean
ReceiveDate	Quotation receipt date	Datetime
AnswerDate	Quotation response date	Datetime
CreatedDate	Quotation creation date	Datetime
ReasonForBuyerResponse	Buyer response justification	String
ResponseOwnerId	ID of the person responsible for the quotation response	Integer
Respondent	Person who responded to the quotation	String
Disqualified	Sent as "True" when the participant was excluded from the quotation	Boolean
DeliveryDeadline	Delivery lead time	Integer
Note	Note	String
PaymentConditionCode	Payment condition code	String
PaymentConditionDescription	Payment condition description	String
ContactName	Contact name	String
Currency	Quotation currency	String
BillingLimit	Billing limit	Double
ProposalValidity	Proposal validity date	Datetime
TaxOption	Tax option	String

RfqAttendees Schema Joins

The RfqAttendees schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqTasks	RfqId	Relates the RFQAttendees rows with the RfqTasks rows
Rfqs	RfqId	Relates the RFQAttendees rows with the Rfqs rows
RfqItems	RfqId	Relates the RFQAttendees rows with the RfqItems rows
RfqResponseItemCounterProposals	RfqId	Relates the RFQAttendees rows with the RfqResponseItemCounterProposals rows
RfqItemRequests	RfqId	Relates the RFQAttendees rows with the RfqItemRequests rows
RfqBorgs	RfqId	Relates the RFQAttendees rows with the RfqBorgs rows
RfqResponseItems	RfqId and RfqAttendeeId	Relates the RFQAttendees rows with the RfqResponseItems rows
RFQResponseItemHistory	RfqId and RfqAttendeeId	Relates the RFQAttendees rows with the RFQResponseItemHistory rows
RfqResponseTaxes	RfqId and RfqItemId	Relates the RFQAttendees rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RFQAttendees rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RFQAttendees rows with the RfqItemAttributeValues rows

RfqTasks

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
TaskId	Task identifier	String
RfqId	Primary key for the quotation schema	String
CreationDate	Date when RFQTasks was created	Datetime
ConclusionDate	Date when RFQTasks was completed	Datetime
Description	Task description	String
TaskTypeName	Task type name	String
Status	RFQTasks status	Integer
UserId	Internal evaluator user ID	String
TechnicalResponsible	Task technical responsible name	String
TechnicalResponsibleEmail	Task technical responsible email	String
TechnicalResponsibleComments	Technical evaluation comments	String
ApprovalNotes	Task approval notes	String

RfqTasks Schema Joins

The RfqTasks schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqAttendees	RfqId	Relates the RFQTasks rows with the RFQAttendees rows
RfqResponseItems	RfqId	Relates the RFQTasks rows with the RfqResponseItems rows
RfqResponseItemCounterProposals	RfqId	Relates the RFQTasks rows with the RfqResponseItemCounterProposals rows
Rfqs	RfqId	Relates the RFQTasks rows with the Rfqs rows
RfqItems	RfqId	Relates the RFQTasks rows with the RfqItems rows
RfqItemRequests	RfqId	Relates the RFQTasks rows with the RfqItemRequests rows
RfqBorgs	RfqId	Relates the RFQTasks rows with the RfqBorgs rows
RFQResponseItemHistory	RfqId	Relates the RFQTasks rows with the RFQResponseItemHistory rows
RfqResponseTaxes	RfqId	Relates the RFQTasks rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RFQTasks rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RFQTasks rows with the RfqItemAttributeValues rows

RfqBorgs

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
BorgId	Business unit identifier	String
Code	Business unit code	String
Name	Business unit name	String
VentId	Identifier of the Virtual Entity (VEnt) of the business unit	String
VentName	Name of the Virtual Entity (VEnt) of the business unit	String
VentType	Type of the Virtual Entity (VEnt) of the business unit	String

RfqBorgs Schema Joins

The RfqBorgs schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqAttendees	RfqId	Relates the RfqBorgs rows with the RFQAttendees rows
RfqResponseItems	RfqId	Relates the RfqBorgs rows with the RfqResponseItems rows
RfqResponseItemCounterProposals	RfqId	Relates the RfqBorgs rows with the RfqResponseItemCounterProposals rows
Rfqs	RfqId	Relates the RfqBorgs rows with the Rfqs rows
RfqItems	RfqId	Relates the RfqBorgs rows with the RfqItems rows
RfqItemRequests	RfqId	Relates the RfqBorgs rows with the RfqItemRequests rows
RfqTasks	RfqId	Relates the RfqBorgs rows with the RfqTasks rows
RFQResponseItemHistory	RfqId	Relates the RfqBorgs rows with the RFQResponseItemHistory rows
RfqResponseTaxes	RfqId	Relates the RfqBorgs rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RfqBorgs rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RfqBorgs rows with the RfqItemAttributeValues rows

RfqResponseItemCounterProposals

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
ProductId	Product item identifier in the quotation response	String
CounterProposalId	Identifier of the counterproposal for the quotation response item	String
SupplierId	Supplier identifier	Integer
OwnerId	Quotation owner identifier	Integer
Status	Counterproposal status	String
Origin	Counterproposal origin	String
CounterProposalDate	Counterproposal date	DateTime
Type	Counterproposal type	String
SuggestedPrice	Suggested counterproposal price	Double
Price	Counterproposal price	Double
ReadDate	Counterproposal read date	DateTime
AcceptRefuseDate	Date when the counterproposal was accepted or refused	DateTime
SupplierNote	Supplier note for the counterproposal	String

RfqResponseItemCounterProposals Schema Joins

The RfqResponseItemCounterProposals schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqAttendees	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RFQAttendees
RfqResponseItems	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqResponseItems
RfqBorgs	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqBorgs
Rfqs	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of Rfqs
RfqItems	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqItems
RfqItemRequests	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqItemRequests
RfqTasks	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqTasks
RFQResponseItemHistory	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RFQResponseItemHistory
RfqResponseTaxes	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqResponseTaxes
RfqAttributeValues	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqAttributeValues
RfqItemAttributeValues	RfqId	Relates the lines of RfqResponseItemCounterProposals with the lines of RfqItemAttributeValues

RfqResponseTaxes

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	Long
RfqAttendeeId	Identifier of the quotation participant	String
TaxName	Tax name. Example: Cofins, ICMS, IPI, IRRF, CIDE	String
TaxApplication	Field indicating whether a tax is applied	String
Value	Tax amount	Double
ReducedTaxRate	Reduced tax rate when applicable IBS and CBS	Double
TaxBase	Tax base for IBS and CBS	Double

RfqResponseTaxes Schema Joins

The RfqResponseTaxes schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqAttendees	RfqId and RfqAttendeeId	Relates the RfqResponseTaxes rows with the RFQAttendees rows
RfqResponseItems	RfqId and RfqItemId	Relates the RfqResponseTaxes rows with the RfqResponseItems rows
RfqBorgs	RfqId	Relates the RfqResponseTaxes rows with the RfqBorgs rows
Rfqs	RfqId	Relates the RfqResponseTaxes rows with the Rfqs rows
RfqItems	RfqId and RfqItemId	Relates the RfqResponseTaxes rows with the RfqItems rows
RfqItemRequests	RfqId and RfqItemId	Relates the RfqResponseTaxes rows with the RfqItemRequests rows
RfqTasks	RfqId	Relates the RfqResponseTaxes rows with the RfqTasks rows
RfqResponseItemHistory	RfqId and RfqItemId	Relates the RfqResponseTaxes rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RfqResponseTaxes rows with the RfqResponseItemCounterProposals rows
RfqAttributeValues	RfqId	Relates the RfqResponseTaxes rows with the RfqAttributeValues rows
RfqItemAttributeValues	RfqId	Relates the RfqResponseTaxes rows with the RfqItemAttributeValues rows

RfqAttributeValues

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	DateTime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
Name	Attribute name	String
Value	Attribute content	String
Category	Quotation category with attribute mapping by category	Integer

RfqAttributeValues Schema Joins

The RfqAttributeValues schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqAttendees	RfqId	Relates the RfqAttributeValues rows with the RFQAttendees rows
RfqResponseItems	RfqId and RfqItemId	Relates the RfqAttributeValues rows with the RfqResponseItems rows
RfqBorgs	RfqId	Relates the RfqAttributeValues rows with the RfqBorgs rows
Rfqs	RfqId	Relates the RfqAttributeValues rows with the Rfqs rows
RfqItems	RfqId and RfqItemId	Relates the RfqAttributeValues rows with the RfqItems rows
RfqItemRequests	RfqId and RfqItemId	Relates the RfqAttributeValues rows with the RfqItemRequests rows
RfqTasks	RfqId	Relates the RfqAttributeValues rows with the RfqTasks rows
RfqResponseItemHistory	RfqId and RfqItemId	Relates the RfqAttributeValues rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RfqAttributeValues rows with the RfqResponseItemCounterProposals rows
RfqResponseTaxes	RfqId and RfqItemId	Relates the RfqAttributeValues rows with the RfqResponseTaxes rows
RfqItemAttributeValues	RfqId	Relates the RfqAttributeValues rows with the RfqItemAttributeValues rows

RfqItemAttributeValues

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	DateTime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Long
RfqId	Primary key for the quotation schema	String
RfqItem	Quotation item	Long
SupplierId	Identifier of the quotation supplier	Integer
ProductId	Identifier of the quotation item product	String
Name	Attribute name	String
ItemAttributeId	Identifier of the item attribute filled for the quotation	Integer
Value	Attribute content	String

RfqItemAttributeValues Schema Joins

The RfqItemAttributeValues schema has relationships with the following schemas:

Schema	Relationship Column	Description
RfqAttendees	RfqId	Relates the RfqItemAttributeValues rows with the RFQAttendees rows
RfqResponseItems	RfqId and RfqItemId	Relates the RfqItemAttributeValues rows with the RfqResponseItems rows
RfqBorgs	RfqId	Relates the RfqItemAttributeValues rows with the RfqBorgs rows
Rfqs	RfqId	Relates the RfqItemAttributeValues rows with the Rfqs rows
RfqItems	RfqId and RfqItemId	Relates the RfqItemAttributeValues rows with the RfqItems rows
RfqItemRequests	RfqId and RfqItemId	Relates the RfqItemAttributeValues rows with the RfqItemRequests rows
RfqTasks	RfqId	Relates the RfqItemAttributeValues rows with the RfqTasks rows
RfqResponseItemHistory	RfqId and RfqItemId	Relates the RfqItemAttributeValues rows with the RfqResponseItemHistory rows
RfqResponseItemCounterProposals	RfqId and RfqItemId	Relates the RfqItemAttributeValues rows with the RfqResponseItemCounterProposals rows
RfqResponseTaxes	RfqId and RfqItemId	Relates the RfqItemAttributeValues rows with the RfqResponseTaxes rows
RfqAttributeValues	RfqId	Relates the RfqItemAttributeValues rows with the RfqAttributeValues rows

RfqTaskHistories

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Integer
TaskHistoryId	Internal identifier of the task history	Integer
TaskId	Task identifier	Integer
TaskUserId	User identifier	Integer
Action	Task status: I = Created D = Cancelled U = Updated	String
Date	Effective action date	Datetime
Note	Note	String

RfqTaskHistories Schema Joins

Schema	Relationship Column	Description
RfqTasks	TaskId	Relates the rows of RfqTaskHistories with the rows of RfqTasks.
Users	TaskUserId	Relates the rows of RfqTaskHistories with the rows of Users.

RfqTaskEvaluationResponses

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Transaction reference date	Datetime
TimeKey	Incremental temporal value	Integer
RfqTaskEvaluationResponseId	Internal identifier of the evaluation response	String
TaskEvaluationId	Internal identifier of the evaluation task	String
EvaluationCriteriaId	Internal identifier of the evaluation criterion	String
RfqId	Primary key for the quotation schema	String
SupplierId	Supplier identifier. Primary key for the supplier schema	String
TaskId	Task identifier. Primary key for the task schema (RfqTasks)	String
ResponseValue	Technical evaluation response score. The evaluator provides a rating from 0 to 10	Integer
Weight	Evaluation criterion weight	Integer

RfqTaskEvaluationResponses Schema Joins

The RfqTaskEvaluationResponses schema has relationships with the following schemas:

Schema	Relationship Column	Description
ContractItems	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of ContractItems.
Orders	RfqId and SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of Orders.
RequestItemStatus	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RequestItemStatus.
Rfqs	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of Rfqs.
RfqItems	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqItems.
RfqItemRequests	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqItemRequests.
RfqResponseItems	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqResponseItems.
RfqResponseItemHistory	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqResponseItemHistory.
RfqAttendees	RfqId and SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqAttendees.
RfqTasks	RfqId and TaskId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqTasks.
RfqBorgs	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqBorgs.
RfqResponseItemCounterProposals	RfqId and SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqResponseItemCounterProposals.
RfqResponseTaxes	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqResponseTaxes.
RfqAttributeValues	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqAttributeValues.
RfqItemAttributeValues	RfqId and SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqItemAttributeValues.
TrackingTransactions	RfqId	Relates the rows of RfqTaskEvaluationResponses with the rows of TrackingTransactions.
Contracts	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of Contracts.
Invoices	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of Invoices.
PreOrders	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of PreOrders.
ServiceSheets	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of ServiceSheets.
ServiceSheetItems	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of ServiceSheetItems.
Suppliers	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of Suppliers.
SupplierBorgs	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of SupplierBorgs.
SupplierGroups	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of SupplierGroups.
SupplierBusinessMetrics	SupplierId	Relates the rows of RfqTaskEvaluationResponses with the rows of SupplierBusinessMetrics.
RfqTaskHistories	TaskId	Relates the rows of RfqTaskEvaluationResponses with the rows of RfqTaskHistories.