| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PRODUCT_GUID | Internal Unique ID of Product | varbinary | 16 | 0 | | | | |
| 3 | UNIT | Units of Measure of Product | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | VALID_TO | Valid To (Time Stamp) | decimal | 15 | 0 | | | | |
| 5 | NUMERATOR | Numerator for Conversion to the Base Unit of Measure | int | 10 | 0 | | | | Allow NULL? |
| 6 | DENOMINATOR | Denominator for Conversion to the Base Unit of Measure | int | 10 | 0 | | | | Allow NULL? |
| 7 | EXPONENT10 | Base 10 Exponent for Conversion to the Base Unit of Measure | smallint | 5 | 0 | | | | |
| 8 | GROSS_WEIGHT | Gross Weight | decimal | 13 | 3 | | | | |
| 9 | NET_WEIGHT | Net Weight | decimal | 13 | 3 | | | | |
| 10 | WEIGHT_UNIT | Weight Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | VOLUME | Volume Occupied by the Product per Volume Unit | decimal | 13 | 3 | | | | |
| 12 | VOLUME_UNIT | Unit for the Volume of a Product | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | LENGTH | Length of the Product or of the Packaging of the Product | decimal | 13 | 3 | | | | |
| 14 | WIDTH | Width of the Product or of the Packaging of the Product | decimal | 13 | 3 | | | | |
| 15 | HEIGHT | Height of the Product or of the Packaging of the Product | decimal | 13 | 3 | | | | |
| 16 | UNIT_OF_DIM | Unit in Which Length/Width/Height Is Measured | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | IS_BASE_UNIT | Base Unit of Measure | char | 1 | 0 | | | | Allow NULL? |
| 18 | COMM_PR_UNIT | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
| 19 | VALID_FROM | Valid From (Time Stamp) | decimal | 15 | 0 | | | | |
| 20 | UPNAME | Name of the User Who Last Changed the Set | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | LOGSYS | Original System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | UPDATE_TYPE | Type of Change | char | 1 | 0 | | | | Allow NULL? |
