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
RfqId	Primary key for the <glossary:RFQ> schema (quotation)	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	Pending 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
PresentValueDailyTax	Present value daily rate	Double
ContractId	Contract identifier	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
RfqId	Primary key for the quotation schema	String
RfqItemId	Item number of the quotation	String
ProductRfq	Product code/key in the quotation table. Note: The same ProductId in two different quotations will have 2 ProductRfq	Integer
Quantity	Quantity of the item in the quotation	Double
ItemNumber	Item number in the quotation	Integer
ProductId	Product registration code of the buyer. Note: The same ProductId in two different quotations will have 2 ProductRfq	Integer
Code	Item code of the quotation	String
ClientCode	Client's item code in the quotation	String
Measure	Unit of measure of the item in the quotation	String
GroupId	Group identifier of the item in the quotation	String
GroupClientCode	Client's group code of the item in the quotation	String
GroupDescription	Description of the item group in the quotation	String
GroupParent	Parent group of the item in the quotation	String
EstimatedDeadline	Estimated deadline in days for the item in the quotation	Integer
Status	Status of the item in the quotation	String
Description	Description of the item in the quotation	String
Complement	Complement of the item in the quotation	String
ProductMaterialType	Indicates if the product is a material or a service	String
ProductGeneric	Indicates if the product is generic. Product with code = "False", product without code (generic) = "True"	Boolean
Canceled	Indicates if the item in the quotation was canceled (true or false)	Boolean
FirstPrice	Amount sent in the first quotation. Does not correspond to the final amount.	Double
CreatedDate	Date of creation of the item in the quotation	Datetime

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
RfqId	Primary key for the schema of the quotation	String
RfqItemId	Quotation item number	String
RequestId	Primary key for the schema of the Request	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	Client identifier	String
UpdatedAt	Date of last record update	Datetime
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	String
RfqAttendeeId	Identifier of the quotation participant	String
ProductRfq	Identifier of the product item in the quotation response	Integer
AnswerDate	Response date	Datetime
Refused	True if refused, otherwise False	Boolean
Price	Item price in the quotation response	Double
Deadline	Deadline (in days) for item delivery in the quotation response	Integer
Ipi	IPI tax rate	Double
IpiIncluded	Indicates if IPI is included	String
Icms	ICMS tax rate	Double
IcmsIncluded	Indicates if ICMS is included	String
Note	Observation for the item in the quotation response	String
IcoTerms	Incoterms	String
DeliveryDate	Item delivery date in the quotation response	Datetime
Freight	Freight cost of the item in the quotation response	Double
TotalPrice	Total item price in the quotation response	Double
TotalWithTaxes	Total item value including taxes in the quotation response	Double
IvaCode	VAT code	String
IvaValid	Valid VAT	Boolean
CurrencyCode	Currency code	String
FirstResponseValue	First response value of the item in the quotation. This value is not updated, so if the first response is "canceled", it will still be considered the first response by this field.	Double
SupplierName	Supplier name	String
SupplierOrigin	Supplier origin	String
SupplierCode	Supplier code	String
PaymentCondition	Payment terms	String
ExpirationDate	Expiration date of the quotation	Datetime
BuyerName	Name of the responsible buyer	String
BuyerId	ID of the responsible buyer	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	Present net unit price (without taxes)	Double
PresentValueUnitPriceWithTax	Present unit price with taxes	Double
PresentValueEqualizedUnitPrice	Present equalized unit price	Double
PresentValueTotalNetPrice	Present total net price (without taxes)	Double
PresentValueTotalWithTaxes	Present total price with taxes	Double
PresentValueTotalEqualized	Present total equalized price	Double
TargetDate	Target 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	Client identifier	String
UpdatedAt	Date of the last record update	Datetime
RfqId	Primary key for the quotation schema	String
RfqItemId	Quotation item number	String
RfqAttendeeId	Identifier of the quotation participant	String
ProductId	Product identifier	Long
AnswerDate	Response date	Datetime
Price	Price of the quotation response item	Double
Active	True if the quotation response item is active, otherwise False	Boolean
CreatedDate	Creation date of the quotation response 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
RfqId	Primary key for the RFQ schema	String
RfqAttendeeId	Identifier of the RFQ participant	String
SupplierId	Supplier identifier	String
SupplierName	Supplier name	String
Freight	Freight of the RFQ participant	Double
IcoTerms	<glossary:Incoterms>	String
Refused	True if the RFQ participant refused, otherwise False	Boolean
ReceiveDate	Date the RFQ was received	Datetime
AnswerDate	Date of the RFQ response	Datetime
CreatedDate	Date the RFQ was created	Datetime
ReasonForBuyerResponse	Buyer's response justification	String
ResponseOwnerId	Id of the person responsible for the RFQ response	Integer
Respondent	Person who responded to the RFQ	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	Client identifier	String
UpdatedAt	Date of last record update	Datetime
TaskId	Task identifier	String
RfqId	Primary key for the RFQ schema	String
CreationDate	Date when the RFQTasks was created	Datetime
ConclusionDate	Date when the RFQTasks was concluded	Datetime
Description	Description of the task type	String
Status	Status of the RFQTasks	Integer
TechnicalResponsible	Name of the task's technical responsible	String
TechnicalResponsibleEmail	Email of the task's technical responsible	String
TechnicalResponsibleComments	Notes on the technical evaluation	String
ApprovalNotes	Notes on the task approval	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
RfqId	Primary key for the RFQ schema	String
BorgId	Business unit identifier	String
Code	Business unit code	String
Name	Business unit name	String
VentId	Virtual Entity (VEnt) identifier 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	Client identifier	String
UpdatedAt	Date of the last record update	Datetime
RfqId	Primary key for the RFQ schema	String
ProductId	Identifier of the product item in the RFQ response	String
CounterProposalId	Identifier of the counterproposal for the RFQ response item	String
Status	Status of the counterproposal	String
Origin	Origin of the counterproposal	String
CounterProposalDate	Date of the counterproposal	DateTime
Type	Type of the counterproposal	String
SuggestedPrice	Suggested price of the counterproposal	Double
Price	Price of the counterproposal	Double
ReadDate	Date when the counterproposal was read	DateTime
AcceptRefuseDate	Date when the counterproposal was accepted or refused	DateTime
SupplierNote	Supplier's note on 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	Client identifier	String
UpdatedAt	Date of last record update	Datetime
RfqId	Primary key for the RFQ schema	String
RfqItemId	RFQ item number	String
RfqAttedeeId	Identifier of the RFQ participant	String
TaxName	Tax name. Example: Cofins, ICMS, IPI	String
TaxApplication	Field to indicate if any tax is applied	String
Value	Tax value	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	Client identifier	String
UpdatedAt	Date of the last record update	DateTime
RfqId	Primary key for the quotation schema	String
Name	Attribute name	String
Value	Attribute content	String
Category	Quotation category linking attributes 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	Client identifier	String
UpdatedAt	Date of last record update	DateTime
RfqId	Primary key for the quotation schema	String
RfqItem	Quotation item	Integer
SupplierId	Identifier of the quotation supplier	Integer
ProductId	Identifier of the quotation item product	String
Name	Attribute name	String
ItemAttributeId	Indicates the Id of the item attribute filled for a specific 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