Query to pull Legal Entity Registration Number

 SELECT XREG.registered_name,XJUR.name,XREG.REGISTRATION_NUMBER
     FROM XLE_JURISDICTIONS_TL XJUR , XLE_REGISTRATIONS XREG 
where 1=1
and XJUR.jurisdiction_id = XREG.jurisdiction_id
and XJUR.language='US'
and XJUR.name='Quebec Provincial Tax'--Jurisdiction Name, which you will find on Manage Legal Entity Registrations Page    
and XREG.source_table='XLE_ENTITY_PROFILES'
and XREG.registered_name='XYZ'--LE Name

Global Transfer HDL

METADATA|WorkRelationship|LegalEmployerName|PersonNumber|DateStart|WorkerType|ActualTerminationDate|EnterpriseSeniorityDate|LastWorkingDate|OnMilitaryServiceFlag|PrimaryFlag|GlobalTransferFlag|ActionCode|RehireRecommendationFlag

MERGE|WorkRelationship|AL Legal Employer Name|20000001|2021/12/01|E||2019/06/01||N|Y|Y|GLB_TRANSFER|Y

METADATA|WorkTerms|ActionCode|AssignmentStatusTypeCode|AssignmentNumber|AssignmentType|WorkerType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|GradeCode|PeriodOfServiceId(SourceSystemId)|PersonNumber|DateStart|LegalEmployerName|BusinessUnitId|PersonTypeCode

MERGE|WorkTerms|GLB_TRANSFER|ACTIVE_PROCESS|ET20000001-1|ET|E|4712/12/31|Y|1|2021/12/01|Grad1||20000001|2021/12/01|AL Legal Employer Name|300000045830045|Regular

METADATA|Assignment|ActionCode|PersonNumber|EffectiveStartDate|EffectiveEndDate|AssignmentNumber|WorkTermsNumber|AssignmentType|EffectiveSequence|EffectiveLatestChange|BusinessUnitId|DateProbationEnd|WorkerCategory|AssignmentCategory|GradeCode|HourlySalariedCode|PositionCode|JobCode|LocationId|ManagerFlag|OrganizationId|DateStart|LegalEmployerName|PersonTypeCode|PrimaryAssignmentFlag|AssignmentStatusTypeCode|WorkerType

MERGE|Assignment|GLB_TRANSFER|20000001|2021/12/01|4712/12/31|E20000001-1|ET20000001-1|E|1|Y|300000045830045||Senior Management|Full-time Regular|Grad1|S|123134||300000002378027||300000001871927|2021/12/01|AL Legal Employer Name|Regular|Y|ACTIVE_PROCESS|E