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

How can I pull costing on job level?

Question
11
Views
0
Comments

Summary:

We have an extract linking per_ext_pay_employees_ue to a costing structure UE. Costing on job level will not pull into extract. Only on payroll assignment level

Content (required):

per_ext_pay_employees_ue linked to costing structure UE based on Extract Employee Payroll Assignment ID to costing structure ue source_id. Have also linked based on job_id to source_id to test.

Filtered by 'JOB' for source_type and job_id=source_id.

Can pull the costing based on following query (but no results in extract):

select pcaa.cost_alloc_account_id , pcaf.source_id, paaf.job_id, pcaa.segment3, pcaa.segment4, pcaa.segment8

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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