Заказы - data.Order

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

Created order for delivery or shipment of SKU

Field	Type	Description
`ID*` `PK`	`int`	SO+ unique record identifier
`Number`	`nvarchar(500)`	Order number
`Date`	`date`	Order date
`ID_Load*` `data.Load`	`int`	Load number
`ID_mapping_DataSource*` `mapping.DataSource`	`int`	Data source
`ID_ref_Company*` `ref.Company`	`int`	Company
`ID_ref_CustomerFrom` `ref.Customer`	`int`	Shipped from
`ID_ref_CustomerTo` `ref.Customer`	`int`	Shipped to
`ID_ref_Period*` `ref.Period`	`int`	Period
`ID_ref_SKU*` `ref.SKU`	`int`	SKU
`ID_ref_Seria` `ref.Seria`	`int`	Serial number
`RowVersion*`	`binary`	row version
`UID_DS`	`varchar(1000)`	Data source unique record identifier
`DateUpdate`	`datetime`	Update date
`FlagDeleted`	`bit`	Deleted row flag
`Volume`	`float`	Volume of order
`Value`	`float`	Order costs
`ValueVAT`	`float`	Order VAT
`FlagVAT`	`bit`	VAT included in the volume of ord
`DiscountAmount`	`float`	Discount amount
`DiscountPercentage`	`float`	Discount percentage
`ID_ref_UnitType` `ref.UnitType`	`int`	Unit for SKU
`ID_ref_OrderStatus` `ref.OrderStatus`	`int`	Order status
`ID_ref_OrderRejectionReason` `ref.OrderRejectionReason`	`int`	Reason of rejection order

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

На диаграмме ниже представлены поля, которые описывают заказы с точки зрения бизнеса.