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 |
| 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 |