Юр. лица - ref.LegalEntity

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

ref.LegalEntity Legal entity

The dictionary of legal entities and individual entrepreneurs.

FieldTypeDescription
ID* PK
int
SO+ unique record identifier
ID_Company
ref.Company
int
Company
ID_CompanySource
ref.Company
int
Data source company
ID_mapping_DataSource*
mapping.DataSource
int
Data source
ID_mapping_MDT
ref.LegalEntity
int
Master record
ID_status_Status*
Status.status.Status
int
Status of record processing
UID_DS*
varchar(255)
Data source unique record identifier
RowVersion*
binary
Row version
DateLiquidation
date
Liquidation date
DateRegistration
date
Registration date
DateActuality
date
Actualization date
FlagActive
bit
Activity flag
FlagActiveRZNLicense
bit
Possession of RZN license flag
FlagExclude
bit
Flag of exclusion from reports
FlagMovement
bit
Flag of the presence of movements
GeneralManager
varchar(100)
General manager
ID_LegalEntityActivityType
ref.LegalEntityActivityType
int
Activity type
ID_LegalEntityFormType
ref.LegalEntityFormType
int
Legal entity form type
KPP
varchar(500)
KPP
LegalAddress
varchar(500)
Address
LegalAddress_DS
varchar(500)
Source address
LegalName
varchar(500)
Name
LegalName_DS
varchar(500)
Source name
OGRN
varchar(100)
OGRN
Phone
varchar(20)
Phone
RZNLicenseDateBegin
date
Start date of RZN license
RZNLicenseNumber
nvarchar(77)
Number of RosZdravNadzor license
TIN
varchar(14)
TIN
TIN_DS
varchar(500)
Source TIN
TIN_LegalName_Computed
varchar(515)
Computed TIN
TINCleared
nvarchar(12)
Verificated TIN
URL
varchar(100)
Web site address
FlagDeleted
bit
Признак удаления записи

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

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

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

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