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 | Description |
|---|---|---|
| ProductId | int | Product identifier |
| Product | varchar | Product name |
| SKU | varchar | Stock keeping unit |
| ExternalProductCode | varchar | External system product code |
| ProductPricingId | int | Unique identifier for the pricing record |
| CaseOptionValue | varchar | Case option name/value |
| Size | int | Size/units per case |
| Price | decimal(18,2) | Product price |
| FacingsPerCase | int | Number of facings per case |
| CasesPerFacing | decimal(18,2) | Number of cases per facing |
| UnPackUnitValue | varchar | Unpacking unit name/value |
| IsDeleted | bit | Soft delete flag |
| ClientName | varchar | Name of the client |
| ClientCode | varchar | Code of the client |
| CreatedOn | datetime | Record creation timestamp |
| CreatedBy | varchar | Username of creator |
| ModifiedOn | datetime | Record modification timestamp |
| ModifiedBy | varchar | Username of last modifier |