Product Pricing Schema
- File Name:
productpricing.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains product pricing information including case configurations, sizing options, and unpacking unit details.
Fields
📋 Includes Common Fields: Client Information, Audit Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| ProductId | int | NOT NULL | Product identifier |
| Product | nvarchar(250) | NOT NULL | Product name |
| SKU | varchar(50) | NOT NULL | Stock keeping unit |
| ExternalProductCode | nvarchar(250) | NULL | External system product code |
| ProductPricingId | int | NOT NULL | Unique identifier for the pricing record |
| CaseOptionValue | varchar(500) | NULL | Case option name/value (from Lookup) |
| Size | int | NOT NULL | Size/units per case |
| Price | decimal(18,2) | NOT NULL | Product price |
| FacingsPerCase | decimal(6,2) | NOT NULL | Number of facings per case |
| CasesPerFacing | decimal(6,2) | NULL | Number of cases per facing (computed) |
| UnPackUnitValue | varchar(500) | NULL | Unpacking unit name/value (from Lookup) |
| IsDeleted | tinyint | NOT NULL | Soft delete flag (0=Active, 1=Deleted) |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |
| CreatedOn | datetime | NOT NULL | Record creation timestamp |
| CreatedBy | varchar(50) | NOT NULL | Username of creator |
| ModifiedOn | datetime | NOT NULL | Record modification timestamp |
| ModifiedBy | varchar(50) | NOT NULL | Username of last modifier |