Юр. лица - ref.LegalEntity
Спецификация
ref.LegalEntity Legal entity
The dictionary of legal entities and individual entrepreneurs.
| Field | Type | Description |
|---|---|---|
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 | Признак удаления записи |
Связанные объекты
Представления отображают поля актуальные для обозначенной предметной области.
Бизнес-представление
Юр. лицо можно описать с разных бизнес-сторон с использованием полей и справочников, представленных ниже.