4,084
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
AR
*This post is locked for comments
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)
Perfect! thank you!
Is there any other working table holding this information before posting similar to the other modules?
many thanks!
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.
Have you checked this Extracting payroll data from GP
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
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!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (