Юр. лица - legal-entity

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

Legal entity

The dictionary of legal entities and individual entrepreneurs.

FieldTypeDescription
ID* PK
int
SO+ unique record identifier
ID_Company
int
Company
ID_CompanySource
int
Data source company
ID_mapping_DataSource*
int
Data source
ID_mapping_MDT
int
Master record
ID_status_Status*
int
Status of record processing
UID_DS*
nvarchar(255)
Data source unique record identifier
RowVersion*
bigint
Row version
DateLiquidation
date
Liquidation date
FlagActive
bit
Activity flag
FlagActiveRZNLicense
bit
Possession of RZN license flag
FlagMovement
bit
Flag of the presence of movements
FlagExclude
bit
Exclusion flag
GeneralManager
nvarchar(100)
General manager
ID_LegalEntityActivityType
int
Activity type
ID_LegalEntityFormType
int
Legal entity form type
KPP
nvarchar(500)
KPP
LegalAddress
nvarchar(500)
Address
LegalAddress_DS
nvarchar(500)
Source address
LegalName
nvarchar(500)
Name
LegalName_DS
nvarchar(500)
Source name
OGRN
nvarchar(100)
OGRN
Phone
nvarchar(20)
Phone
RZNLicenseDateBegin
date
Start date of RZN license
RZNLicenseNumber
nvarchar(77)
Number of RosZdravNadzor license
TIN
nvarchar(12)
TIN
TIN_DS
nvarchar(500)
Source TIN
TIN_LegalName_Computed
nvarchar(515)
Computed TIN
TINCleared
nvarchar(12)
Verificated TIN
URL
nvarchar(100)
Web site address
DateActuality
date
Data actuality date
MDT_DateCreate*
datetime
Record creation date

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

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

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

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