Продукты - sku

Спецификация

Dictionary of reference SKU, loaded from the source. Uploaded into the dictionary as SKU level as well as stock number.

Field	Type	Description
`ID*` `PK`	`int`	SO+ unique record identifier
`Name`	`nvarchar(500)`	Name
`FlagActive`	`bit`	Activity flag
`ID_CompanySource` `company`	`int`	Data source company
`ID_CompanyProducer` `company`	`int`	Company producer
`ID_Company` `company`	`int`	Company
`ID_mapping_DataSource*` `data-source`	`int`	Data source
`ID_mapping_MDT` `sku`	`int`	Master record
`ID_status_Status*` `status`	`int`	Status of record processing
`UID_DS*`	`nvarchar(255)`	Data source unique record identifier
`RowVersion*`	`bigint`	Row version
`AdditionalInformation`	`nvarchar(255)`	Additional information
`CodeCompany`	`nvarchar(255)`	Product code of the data source company
`CodeManufacturer`	`nvarchar(255)`	Code of the company producer
`EANDesc`	`nvarchar(255)`	EAN code
`GTIN`	`varchar(255)`	GTIN
`HSCode`	`nvarchar(255)`	Harmonized System Code
`FlagOld*`	`bit`	SKU isn't produced by the producer anymore flag
`FlagPromo*`	`bit`	Promo SKU flag
`ID_Brand` `brand`	`int`	Brand
`ID_SubBrand` `sub-brand`	`int`	Subbrand
`ID_ProductType` `product-type`	`int`	Product type
`ID_UnitType` `unit-type`	`int`	Unit for SKU
`ID_VAT` `vat`	`tinyint`	VAT
`VolumeInBox`	`int`	Volume in the box
`VolumeInPack`	`int`	Volume in the shrink pack
`VolumeInPiece`	`float`	Volume in the package
`ID_ProductPackaging` `product-packaging`	`int`	Type of product packaging
`ID_PackagingMaterial` `packaging-material`	`int`	Packaging material
`FlagMovement*`	`bit`	SKU movement flag
`ID_Segment` `segment`	`int`	Segment
`MDT_DateCreate*`	`datetime`	Record creation date

Представления отображают поля актуальные для обозначенной предметной области.

Продукты можно описать с разных бизнес-сторон с использованием полей и справочников, представленных ниже.