Движение

mdlp.Movement Movement MDLP

FieldTypeDescription
ID* PK
bigint
SO+ unique record identifier
Date
date
Date
ID_data_Load*
data.Load
int
Load number
ID_mapping_DataSource*
mapping.DataSource
int
Data source
ID_ref_Period*
ref.Period
int
Period
ID_ref_CompanyEmitent
ref.Company
int
Emitent Name
ID_ref_CustomerFrom
ref.Customer
int
ref.Customer
ID_ref_CustomerTo
ref.Customer
int
ref.Customer
ID_ref_LegalEntityFrom
ref.LegalEntity
int
ref.LegalEntity
ID_ref_LegalEntityTo
ref.LegalEntity
int
ref.LegalEntity
ID_ref_SKU
ref.SKU
int
SKU
ID_ref_Seria
ref.Seria
int
Serial number
ID_FinancingSource
mdlp.FinancingSource
int
Financing source
Volume
int
Объём, уп.
UID_DS
varchar(1000)
Data source unique record identifier
RowVersion*
binary
Row version
FlagDeleted
bit
Признак удаления записи
DateUpdateMDLP
datetime
Date update
OperationNumber
varchar(100)
Operation number