You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Tax Employee Card/ Economic Zone

Received Response
17
Views
1
Comments
edited Oct 10, 2023 4:14AM in Payroll and Global Payroll Interface (GPI) 1 comment

I'm trying to pull the Economic Zones for Mexico, but it seems that the query I'm using is only returning one single value as "A" where other values should be found as well (e.g 'Zone B (Source: TRU-CD JUAREZ CHI Reg Pat AZ').


select

cd.name,

ao.prompt,

ri.value1,

ri.legislation_code,

ri.legislative_data_group_id


from

pay_allow_overrides_vl ao,

pay_value_defnitions_vl vd,

pay_range_items_f ri


where 1=1

and ri.value_Defn_id = vd.value_Defn_id

and vd.legislation_code = ´MX'


source_id is showing empty for Mexico employees, so there's no way to use a join for this field.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!