What are the tables that storing Canadian payroll transactions

(0) Share

Report

Posted on by Alaa Ramadan

4,130

Hi,

I am trying to figure out which tables in GP 2013 storing Canadian payroll transactions(both work & history), they all start with CPYxxxxx

all what I need is the count of transactions in those tables :)

Any help greatly appreciated

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

soma 24,410 on at

Like (0)

Report

Please have a look on the Payroll Tables from Victoria Yudin-MVP in below link and add the prefix code CPY(Canadian Payroll) instead of UPR for the US payroll tables.

victoriayudin.com/.../payroll-tables

And try the below query for counting transactions from your Canadian Payroll tables.

Select count(*) from CPY10200 -- Work Master

Select count(*) from CPY10302 -- Transaction

Select count(*) from CPY30300 -- Transaction History

Hope this helps!!!

Was this reply helpful? Yes No
Alaa Ramadan 4,130 on at

Like (0)

Report

Thanks Soma, but The Canadian payroll has a different naming structure

there is no such tables in the DB with those names below :

CPY10200 -- Work Master

CPY10302 -- Transaction

CPY30300 -- Transaction History

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Have you checked this Extracting payroll data from GP

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

CPY30260 is the current payroll year transaction table for posted payroll transactions (the master have been updated on a payroll run).

Key Fields are:

BACHNUMB

PEmployeeID

PDate

Punits (Divide by 100)

PLineTotal

PIncomeCode (even though it is called IncomeCode it is all pay code types -- deductions, benefits, etc)

When a payroll year is closed, the data is pushed to CPY50260. It has PYear column added to the table structure but otherwise is identical to the CPY30260 table.

Hope this helps.

Was this reply helpful? Yes No
Alaa Ramadan 4,130 on at

Like (0)

Report

Perfect! thank you!

Is there any other working table holding this information before posting similar to the other modules?

many thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

CPY30100 is the transaction entry table. This is the pre-batch calculation date (from time entry). If you use the import utility for importing timesheets it populates this table. I have used stored procedures to populate this table also. (e-Connect does not have a node to populate this table)

Was this reply helpful? Yes No