Промо-продажи из ТТ - data.PromoOfftake

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

Promo sales from the outlets/online store.

Field	Type	Description
`ID*` `PK`	`bigint`	SO+ unique record identifier
`DateAccept`	`date`	Shipment date
`DateDelivery`	`date`	Delivery date
`DateInvoice`	`date`	Invoice/reciept date
`FlagDeleted`	`bit`	Record deletion flag
`FlagReturn*`	`bit`	Return flag
`FlagVAT`	`bit`	VAT included in the volume of sales flag
`ID_doc_Invoice*` `doc.Invoice`	`bigint`	Invoice
`ID_Load*` `data.Load`	`int`	Load number
`ID_OfftakeReceipt` `data.OfftakeReceipt`	`bigint`	Receipt
`ID_ref_Company*` `ref.Company`	`int`	Company seller
`ID_ref_CustomerFrom` `ref.Customer`	`int`	Seller
`ID_ref_CustomerTo` `ref.Customer`	`int`	Customer
`ID_ref_LegalEntityFrom` `ref.LegalEntity`	`int`	Seller's legal entity
`ID_ref_LegalEntityTo` `ref.LegalEntity`	`int`	Customer's legal entity
`ID_ref_Period*` `ref.Period`	`int`	Sale period
`ID_ref_SKU*` `ref.SKU`	`int`	SKU
`ID_ref_Seria` `ref.Seria`	`int`	Serial number
`InvoiceNumber`	`varchar(100)`	Invoice/receipt number
`Value`	`float`	Value of sales
`ValueVAT`	`float`	VAT costs
`Volume`	`float`	Volume of sales
`RowVersion*`	`binary`	Row version
`DateUpdate`	`datetime`	Update date
`ID_mapping_DataSource*` `mapping.DataSource`	`int`	Data source
`ID_ref_UnitType` `ref.UnitType`	`int`	Sales unit
`ID_ref_SalesType` `ref.SalesType`	`int`	Sales type
`UID_DS`	`varchar(1000)`	Data source unique record identifier
`DiscountAmount`	`float`	Discount amount
`DiscountPercentage`	`float`	Discount percentage
`ID_Order` `data.Order`	`int`	Order
`CompensationValue`	`float`	Compensation value

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

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