Клиенты - customer

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

Outlets, warehouses and other sales work entities of sales chain.

Field	Type	Description
`ID*` `PK`	`int`	SO+ unique record identifier
`ID_Company` `company`	`int`	Company
`ID_mapping_DataSource*` `data-source`	`int`	Data source
`ID_mapping_MDT` `customer`	`int`	Master record
`ID_status_Status*` `status`	`int`	Status of record processing
`ID_CompanySource` `company`	`int`	Data source company
`FlagActive`	`bit`	Activity flag
`WorkHours`	`nvarchar(255)`	Working hours
`Address_DS`	`nvarchar(4000)`	Source address
`Latitude_DS`	`varchar(12)`	Source latitude
`Longitude_DS`	`varchar(12)`	Source longitude
`CodeCompany`	`nvarchar(255)`	Data source company code
`ID_ReferenceType` `reference-type`	`char(2)`	reference-type
`ID_CustomerType` `customer-type`	`int`	Customer type
`ID_LegalEntity` `legal-entity`	`int`	Legal entity
`ID_OutletFormat` `outlet-format`	`int`	Outlet format
`LocationDetails`	`nvarchar(500)`	Location extra details
`Name`	`nvarchar(500)`	Name
`ID_mdlp_CounterPartyStatus` `counter-party-status`	`int`	Counter Party Status
`UID_DS*`	`nvarchar(4000)`	Data source unique record identifier
`RowVersion*`	`bigint`	Row version
`ID_TradeType` `trade-type`	`int`	Trade type
`MDT_DateCreate*`	`datetime`	Record creation date

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

Клиента можно описать с разных бизнес-сторон с использованием полей и справочников, представленных ниже.