Set of dictionaries appropriate for majority of enterprise systems.
For internal organization structure see @ubitybase/org module
Used ubs_setting keys
-
cdn.organization.accessAddGovByRoles- comma separated use role names for whom is allowed to add/edit organization withisGovAuthority == true. If empty - allowed for any role -
cdn.organization.allowAutoGenerateOKPOBoolean. Iftrueandcdn.organization.OKPOCodeif not filled will generate if automatically during insertion. Defaultfalse
Classes
- cdn_address_ns
- cdn_adminunit_ns
- cdn_bank_ns
- cdn_building_ns
- cdn_city_ns
- cdn_citytype_ns
- cdn_classifier_ns
- cdn_classifieritem_ns
- cdn_contact_ns
- cdn_contacttype_ns
- cdn_corrindex_ns
- cdn_country_ns
- cdn_currency_ns
- cdn_department_ns
- cdn_deptype_ns
- cdn_employee_ns
- cdn_language_ns
- cdn_nationality_ns
- cdn_orgaccount_ns
- cdn_organization_ns
- cdn_orgbusinesstype_ns
- cdn_orgownershiptype_ns
- cdn_person_ns
- cdn_personcategory_ns
- cdn_personclass_ns
- cdn_personsocialstatus_ns
- cdn_postindex_ns
- cdn_profession_ns
- cdn_region_ns
- cdn_regiontype_ns
- cdn_staffunittype_ns
- cdn_street_ns
Types
# cdnAddressAttrs inner
Properties
ID: numberaddressType: string | ubmEnumAttrsAddress type
value: stringAddress
subjectID: numberSubject
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnAdminunitAttrs inner
Properties
ID: numberparentAdminUnitID: number | cdnAdminunitAttrsParent
code: stringCode
name: stringName
fullName: stringFull name
adminUnitType: string | ubmEnumAttrsAdmin unit type
caption: stringCaption
mi_unityEntity: stringmi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnBankAttrs inner
Properties
ID: numberMFO: stringBank code
code: stringOrganization code
name: stringName
fullName: stringFull name
phones: stringPhones
address: stringAddress
countryID: number | cdnCountryAttrsCountry
cityID: number | cdnCityAttrsCity
description: stringDescription
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnBuildingAttrs inner
Properties
ID: numberstreetID: number | cdnStreetAttrsStreet
postIndexID: number | cdnPostindexAttrsZip
code: stringNum
description: stringDescription
buildingType: string | ubmEnumAttrsType
mi_data_id: number | cdnBuildingAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnCityAttrs inner
Properties
ID: number | cdnAdminunitAttrsparentAdminUnitID: number | cdnAdminunitAttrsParent
code: stringCode
name: stringName
caption: stringCaption
description: stringDescription
postalCode: stringPostal code
phoneCode: stringPhone code
cityTypeID: number | cdnCitytypeAttrsType
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnCitytypeAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnClassifierAttrs inner
Properties
ID: number | ubmQueryAttrscode: stringCode
name: stringName
description: stringDescription
orderByAttr: string | ubmEnumAttrsClassifier items order
ubql: *UBQL (JSON)
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnClassifieritemAttrs inner
Properties
ID: numbercode: stringSystem code
name: stringName
classifierID: number | cdnClassifierAttrsClassifier
parentID: number | cdnClassifieritemAttrsParent
hierarchyLevel: numberLevel
mi_treePath: stringmi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnContactAttrs inner
Properties
ID: numbercontactTypeID: number | cdnContacttypeAttrsContact type
value: stringContact
subjectID: numberSubject
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnContacttypeAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnCorrindexAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
fullName: stringFull name
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnCountryAttrs inner
Properties
ID: number | cdnAdminunitAttrscode: stringCode
name: stringName
fullName: stringFull name
intCode: numberDigital code
symbol2: stringISO code
symbol3: stringIOC code
description: stringDescription
phoneCode: stringPhone code
currencyID: number | cdnCurrencyAttrsCurrency
capitalID: number | cdnCityAttrsCapital
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnCurrencyAttrs inner
Properties
ID: numberintCode: numberDigital code
code3: string3-character code
name: stringName
curMult: numberDefault multiplicity
description: stringDescription
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnDepartmentAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
fullName: stringFull name
description: stringDescription
nameGen: stringName in genitive case
nameDat: stringName in dative case
fullNameGen: stringFull name in genitive case
fullNameDat: stringFull name in dative case
depTypeID: number | cdnDeptypeAttrsType
organizationID: number | cdnOrganizationAttrsOrganization
mi_data_id: number | cdnDepartmentAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnDeptypeAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnEmployeeAttrs inner
Properties
ID: numberlastName: stringLast name
firstName: stringFirst name
middleName: stringMiddle name
description: stringDescription
sexType: string | ubmEnumAttrsGender
uniqNum: stringEmployee number
suffix: stringSuffix
shortFIO: stringLast name with initials
fullFIO: stringFull name
apply: stringTreatment
lastNameGen: stringLast name in genitive
lastNameDat: stringLast name in dative
firstNameGen: stringFirst name in genitive
firstNameDat: stringFirst name in dative
middleNameGen: stringMiddle name in genitive
middleNameDat: stringMiddle name in dative
shortFIOGen: stringShort name in genitive
shortFIODat: stringShort name in dative
fullFIOGen: stringFull name in genitive
fullFIODat: stringFull name in dative
applyGen: stringTreatment in genitive
applyDat: stringTreatment in dative
departmentID: number | cdnDepartmentAttrsDepartment
organizationID: number | cdnOrganizationAttrsOrganization
addrText: stringAddressee formulation
mi_data_id: number | cdnEmployeeAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnLanguageAttrs inner
Properties
ID: numbercode: stringISO 639-1 code
languageName: stringLanguage name
nativeName: stringNative name (Endonym)
isRTL: booleanIs right-to-left
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnNationalityAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
nameM: stringName(male)
nameF: stringName(female)
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnOrgaccountAttrs inner
Properties
ID: numberorganizationID: number | cdnOrganizationAttrsOrganization
currencyID: number | cdnCurrencyAttrsCurrency
bankID: number | cdnBankAttrsBank
code: stringCode
acctype: string | ubmEnumAttrsType
description: stringDescription
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnOrganizationAttrs inner
Properties
ID: numbercode: stringInternal code
OKPOCode: stringCCEO
taxCode: stringTax number
vatCode: stringVAT number
name: stringOrganization name
fullName: stringOrganization full name
nameGen: stringName in genitive case
nameDat: stringName in dative case
fullNameGen: stringFull name in genitive case
fullNameDat: stringFull name in dative case
description: stringOrganization description
orgBusinessTypeID: number | cdnOrgbusinesstypeAttrsOrganization type
orgOwnershipTypeID: number | cdnOrgownershiptypeAttrsOwnership type
corrIndexID: number | cdnCorrindexAttrsIndex of correspondent
addrText: stringAddressee formulation
caption: stringCaption
countryID: number | cdnCountryAttrsCountry
mi_data_id: number | cdnOrganizationAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnOrgbusinesstypeAttrs inner
Properties
ID: numbercode: stringCode
shortName: stringAcronim
name: stringName
fullName: stringDescription
isGovAuthority: booleanGov. authority
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnOrgownershiptypeAttrs inner
Properties
ID: numbercode: stringCode
shortName: stringAcronim
name: stringName
fullName: stringFull name
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnPersonAttrs inner
Properties
ID: numberlastName: stringLast name
firstName: stringFirst name
middleName: stringMiddle name
identCard: stringIdentity card
workPlacePos: stringPlace of work, position
birthDate: DateBirthday
description: stringDescription
sexType: string | ubmEnumAttrsGender
suffix: stringSuffix
shortFIO: stringShort name
fullFIO: stringFull name
apply: stringApply
photo: stringPhoto
lastNameGen: stringLast name in genitive
lastNameDat: stringLast name in dative
firstNameGen: stringFirst name in genitive
firstNameDat: stringFirst name in dative
middleNameGen: stringMiddle name in genitive
middleNameDat: stringMiddle name in dative
shortFIOGen: stringShort name in genitive
shortFIODat: stringShort name in dative
fullFIOGen: stringFull name in genitive
fullFIODat: stringFull name in dative
applyGen: stringApply in genitive
applyDat: stringApply in dative
regionID: number | cdnRegionAttrsRegion
socialstatusID: number | cdnPersonsocialstatusAttrsSocial status
categoryID: number | cdnPersoncategoryAttrsCategory
nationality: number | cdnNationalityAttrsNationality
resident: booleanResident?
classID: number | cdnPersonclassAttrsPerson classification
mi_data_id: number | cdnPersonAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnPersoncategoryAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnPersonclassAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnPostindexAttrs inner
Properties
ID: numbercode: stringIndex
streetID: number | cdnStreetAttrsStreet
description: stringDescription
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnProfessionAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
description: stringCaption
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnRegionAttrs inner
Properties
ID: number | cdnAdminunitAttrsparentAdminUnitID: number | cdnAdminunitAttrsParent
code: stringCode
regionTypeID: number | cdnRegiontypeAttrsType
name: stringName
caption: stringCaption
fullName: stringFull name
description: stringDescription
phoneCode: stringPhone code
centerID: number | cdnCityAttrsCenter
mi_data_id: number | cdnRegionAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnRegiontypeAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnStaffunittypeAttrs inner
Properties
ID: numbercode: stringCode
name: stringName
mi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
# cdnStreetAttrs inner
Properties
ID: numbername: stringName
fullName: stringFull name
code: stringCode
streetType: string | ubmEnumAttrsType
cityID: number | cdnCityAttrsCity
mi_data_id: number | cdnStreetAttrsmi_dateFrom: Datemi_dateTo: Datemi_owner: number | ubaUserAttrsmi_createDate: Datemi_createUser: number | ubaUserAttrsmi_modifyDate: Datemi_modifyUser: number | ubaUserAttrsmi_deleteDate: Datemi_deleteUser: number | ubaUserAttrs
