Registrations

The Registrations view object consolidates the detailed registration information of legal entities and establishments, such as registration number, place of registration, and legal address.

Data store key : FscmTopModelAM.FinExtractAM.XleBiccExtractAM.RegistrationExtractPVO

Primary Keys : RegistrationRegistrationId

Initial Extract Date : RegistrationCreationDate

Incremental Extract Date : RegistrationLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
RegistrationAlternateRegisteredName The alternate name of the respective registration.
RegistrationCreatedBy The user who created the registration.
RegistrationCreationDate The date and time when the registration was created.
RegistrationEffectiveFrom The effective start date of the registration.
RegistrationEffectiveTo The effective end date of the registration.
RegistrationIdentifyingFlag Indicates whether the registration may be used for identification purposes. A list of accepted values is defined in the lookup type YES_NO.
RegistrationIssuingAuthorityId The unique identifier of the issuing legal authority.
RegistrationIssuingAuthoritySiteId The unique identifier of the issuing legal authority site address.
RegistrationJurisdictionId The jurisdiction for which a legal entity or establishment is registered. This is the foreign key to the XLE_JURISDICTIONS_B table.
RegistrationLastUpdateDate The date and time when the registration was last updated.
RegistrationLastUpdateLogin The session login associated with the user who last updated the registration.
RegistrationLastUpdatedBy The user who last updated the registration.
RegistrationLocationId The location identifier of the registered address.
RegistrationObjectVersionNumber The number of times the registration has been updated.
RegistrationPlaceOfRegistration The place of registration.
RegistrationRegisteredName The name of the respective registration.
RegistrationRegistrationId The unique identifier of the registration. This is the primary key of the Registrations view object.
RegistrationRegistrationNumber The registration number of the respective registration.
RegistrationSourceId The identifier for the registered legal entity or establishment of the registration.
RegistrationSourceTable The name of the source table for the registered legal entity or establishment of the registration. It can be either XLE_ENTITY_PROFILES or XLE_ETB_PROFILES.