Продажи из ТТ - data.Sales_Offtake

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

data.Sales_Offtake Sales from the outlet

Sales from the outlets/online store.

FieldTypeDescription
ID* PK
bigint
SO+ unique record identifier
DateAccept
date
Shipment date
DateDelivery
date
Delivery date
DateInvoice
date
Invoice/reciept date
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_ref_Company*
ref.Company
int
Company seller
ID_ref_CompanySupplier
ref.Company
int
Company Supplier
ID_ref_CustomerFrom
ref.Customer
int
Point of sale
ID_ref_CustomerTo
ref.Customer
int
Buyer
ID_ref_LegalEntityFrom
ref.LegalEntity
int
Shipper legal entity
ID_ref_LegalEntityTo
ref.LegalEntity
int
Сonsignee legal entity
ID_ref_CustomerSeller
ref.Customer
int
Seller
ID_ref_CustomerPayer
ref.Customer
int
Payer
ID_ref_LegalEntitySeller
ref.LegalEntity
int
Seller's legal entity
ID_ref_LegalEntityPayer
ref.LegalEntity
int
Payer'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
ID_Order
data.Order
int
Order
FlagDeleted
bit
Признак удаления записи

Связанные объекты

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

Бизнес-представление

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