Продукты - ref.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`	`varchar(500)`	Name
`FlagActive`	`bit`	Activity flag
`ID_CompanySource` `ref.Company`	`int`	Data source company
`ID_CompanyProducer` `ref.Company`	`int`	Company producer
`ID_Company` `ref.Company`	`int`	Company
`ID_mapping_DataSource*` `mapping.DataSource`	`int`	Data source
`ID_mapping_MDT` `ref.SKU`	`int`	Master record
`ID_status_Status*` `status.Status`	`int`	Status of record processing
`UID_DS*`	`varchar(255)`	Data source unique record identifier
`RowVersion*`	`binary`	Row version
`AdditionalInformation`	`varchar(255)`	Row version
`CodeCompany`	`varchar(255)`	Product code of the data source company
`CodeManufacturer`	`varchar(255)`	Code of the company producer
`EANDesc`	`varchar(255)`	EAN code
`GTIN`	`varchar(255)`	GTIN
`HSCode`	`varchar(255)`	Harmonized System Code
`FlagOld*`	`bit`	SKU isn't produced by the producer anymore flag
`FlagPromo*`	`bit`	Promo SKU flag
`ID_Brand` `ref.Brand`	`int`	Brand
`ID_SubBrand` `ref.SubBrand`	`int`	Subbrand
`ID_ProductType` `ref.ProductType`	`int`	Product type
`ID_UnitType` `ref.UnitType`	`int`	Unit for SKU
`ID_VAT` `ref.VAT`	`tinyint`	VAT
`VolumeInBox`	`int`	Volume in the box
`VolumeInPack`	`int`	Volume in the shrink pack
`VolumeInPiece`	`float`	Volume in the package
`ID_ProductPackaging` `ref.ProductPackaging`	`int`	Type of product packaging
`ID_PackagingMaterial` `ref.PackagingMaterial`	`int`	Packaging material
`MDT_DateCreate*`	`datetime`	Record creation date
`FlagDeleted`	`bit`	Признак удаления записи

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

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

Системные поля и справочники.