Отгрузки в ТТ - data.Sales_SellOut

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

data.Sales_SellOut Shipments to outlet

Shipments to outlets, provided by distributor/chain.

FieldTypeDescription
ID* PK
bigint
SO+ unique record identifier
DateAccept
date
SKU receipt date
DateDelivery
date
Delivery date
DateInvoice
date
Invoice 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_CustomerFrom
ref.Customer
int
Shipper
ID_ref_CustomerTo
ref.Customer
int
Receiver
ID_ref_LegalEntityFrom
ref.LegalEntity
int
Shipper legal entity
ID_ref_LegalEntityTo
ref.LegalEntity
int
Consignee 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
Sales period
ID_ref_SKU*
ref.SKU
int
SKU
ID_ref_Seria
ref.Seria
int
Serial number
InvoiceNumber
varchar(100)
Invoice number
Value
float
Value of sales
ValueVAT
float
VAT costs
Volume
float
Volume of sales
DateUpdate
datetime
Update date
ID_mapping_DataSource*
mapping.DataSource
int
Data source
ID_ref_UnitType
ref.UnitType
int
Unit for sales
ID_ref_SalesType
ref.SalesType
int
Sales type
UID_DS
varchar(1000)
Data source unique record identifier
RowVersion*
binary
Row version
FlagDeleted
bit
Признак удаления записи
TenderNumber
nvarchar(30)
Tender Number
ParcelNumber
nvarchar(30)
Parcel number
ID_Order
data.Order
int
Order

split.Sales_SellOut Shipments to outlet (split)

Splitted shipments to outlets.

FieldTypeDescription
ID* PK
bigint
SO+ unique record identifier
ID_ref_CustomerFrom
ref.Customer
int
Seller
ID_ref_CustomerTo
ref.Customer
int
Customer
ID_mapping_DataSource*
mapping.DataSource
int
Data source
ID_Load*
data.Load
int
Load number
ID_ref_Company*
ref.Company
int
Company seller
ID_ref_Period*
ref.Period
int
Sales period
InvoiceNumber
varchar(100)
Invoice number
Value
float
Value of sales
ValueVAT
float
VAT costs
DateAccept
date
SKU receipt date
DateDelivery
date
Delivery date
DateInvoice
date
Invoice date
ID_ref_LegalEntityFrom
ref.LegalEntity
int
Shipper legal entity
ID_ref_LegalEntityTo
ref.LegalEntity
int
Consignee legal entity
ID_ref_SKU*
ref.SKU
int
SKU
ID_ref_UnitType
ref.UnitType
int
Unit for sales
ID_ref_SalesType
ref.SalesType
int
Sales type
FlagReturn*
bit
Return flag
FlagVAT
bit
VAT included in the volume of sales flag
Volume
float
Volume of sales
ID_SplitType*
split.SplitType
int
Split type
ID_data_Sales_SellOut
data.Sales_SellOut
bigint
Sales sellout
FlagInverse*
bit
Replaceable sales flag
RowVersion*
binary
Row version
FlagDeleted
bit
Признак удаления записи
SplitLevel*
int
Split Level

chnl.SellOut Sales channels for SellOut

FieldTypeDescription
ID* PK
data.Sales_SellOut
bigint
Record ID from SellOut table
ID_Channel
chnl.Channel
int
Sales channel
ID_CalculationStatus*
chnl.CalculationStatus
int
Sales channels calculation status
RowVersion*
binary
Row version
FlagDeleted
bit
Признак удаления записи

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

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

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

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