Products

Below are the schemas and relationships for the Products schema.

---

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Reference date of the transaction.	Datetime
Description	Product description	String
ProductId	Unique product identifier	String
Measure	Product unit of measure	String
Code	Product code	String
GroupDescription	Description of the product group	String
GroupId	Product group code	String
ClientGroupCode	Product group code in the client's system	String
ParentGroup	Parent product group	Integer
Status	Product status: N = Normal (Active), B = Blocked	String
Complement	Product complement	String
ClientCode	Client code	String
EstimatedPrice	Estimated product price	Double
EstimatedDeadline	Estimated delivery deadline for the product	Integer
IsGeneric	Indicates if the product is generic (true or false)	Boolean
ICMS	ICMS rate	Double
ToleranceMargin	Tolerance margin	Double
MRPItem	Identifies if the product is an MRP Item	Boolean
ProductIdentificationCode	Product identification code (NBM and NCM)	String
IsPermanentAssets	Indicates if the product is a fixed/permanent asset	Boolean
HasContract	Indicates if the product has a contract	Boolean
IsCritical	Indicates if the product is critical	Boolean
HasSubItem	Indicates if the product has sub-items	Boolean
WFStatus	Indicates if the WF has been sent	String
Owner	Product owner	String
CreatedDate	Product creation date	Datetime
UpdatedDate	Product update date	Datetime
IsStored	Indicates if the product is stored	Boolean
Note	Product header notes	String
LastPurchasePrice	Price of the last purchase	Double
LastPurchaseDate	Date of the last purchase	Datetime
RegistrationOrigin	Indicates the origin of the product registration	String
AvailableQuantity	Available quantity of the product	Double
HasStock	Indicates if the product has stock	Boolean
Lifespan	Product lifespan	Double
MonthlyConsumption	Monthly consumption of the product	Double
CriticalLimit	Critical limit of the product	Double
AccountingDate	Product accounting date	Datetime
MaterialType	Material type of the product (material or service)	String
TaxClassificationService	Tax classification for the service	String
Currency	Product currency	String
IVA	Value-added tax (VAT)	Double
NumOfUnitsInPackage	Number of product units in a package	Double
BaselinePrice	Reference price	Double

Products Schema Joins

The Products schema has relationships with the following schemas:

Schema	Relationship Column	Description
ContractItems	ContractId	Relates Products rows to ContractItems rows
RequestItems	RequestItemId	Relates Products rows to RequestItems rows
OrderItems	OrderId	Relates Products rows to OrderItems rows
RFQItems	RfqId	Relates Products rows to RFQItems rows
RFQResponseItems	RfqId	Relates Products rows to RFQResponseItems rows
RFQResponseItemCounterProposals	RfqId	Relates Products rows to RFQResponseItemCounterProposals rows
RfqResponseItemHistory	RfqId	Relates Products rows to RfqResponseItemHistory rows
ProductAttributes	ProductId	Relates Products rows to ProductAttributes rows

ProductAttributes

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Reference date of the transaction	Datetime
TimeKey	Incremental temporal value	Integer
ProductId	Unique product identifier	String
Name	Attribute name	String
Description	Attribute description	String
Value	Attribute content	String

ProductAttributes Schema Joins

The ProductAttributes schema has relationships with the following schemas:

Schema	Relationship Column	Description
ContractItems	ProductId	Relates the rows of ProductAttributes with the rows of ContractItems.
OrderItems	ProductId	Relates the rows of ProductAttributes with the rows of OrderItems.
Products	ProductId	Relates the rows of ProductAttributes with the rows of Products.
RequestItems	ProductId	Relates the rows of ProductAttributes with the rows of RequestItems.
RfqItems	ProductId	Relates the rows of ProductAttributes with the rows of RfqItems.
RfqResponseItemHistory	ProductId	Relates the rows of ProductAttributes with the rows of RfqResponseItemHistory.
RfqResponseItemCounterProposals	ProductId	Relates the rows of ProductAttributes with the rows of RfqResponseItemCounterProposals.
RfqItemAttributeValues	ProductId	Relates the rows of ProductAttributes with the rows of RfqItemAttributeValues.

ProductImages

Column	Description	Type
Id	Internal identifier	String
IsFirst	Indicates whether the image to be associated should be the main product image.	Boolean
Key	Document ID	String
Url	Redirect link to download the image	String

ProductImages Schema Joins

The ProductImages schema has relationships with the following schemas:

Schema	Relationship Column	Description
Products	ProductId	Relates the rows of ProductImages with the rows of Products.