Project Accounting

112 tables in this module

Project Accounting (PA) tables manage project budgets, timesheets, cost transactions, billing, and revenue recognition. PA tables are the most numerous module with 100+ tables covering the full project lifecycle.

Table	Description	Columns
EEPAIVRQ	PA Inventory Returned Quantities	3
GST00103	GST PA Purchasing Receipt	10
GST00104	GST PA Purchasing Receipt	10
GST00105	PA Purchasing Tax History	25
GST00111	GST PA PM Class MSTR	3
PA00000	PA Trigger Settings	3
PA000001	PA Proj Contr Activity Master	5
PA000002	PA Adjustment Activity	5
PA00401	PA Fee Master File	26
PA00402	PA Project Fee Totals Master File	51
PA00501	PA Customer MSTR	124
PA00502	PA Third Party Customer MSTR	7
PA00503	PA Third Party Customer MSTR1	9
PA00504	PA_Customer_MSTR_II	2
PA00511	PA Customer Periodic Totals MSTR	93
PA00531	PA Customer MSTR WIP SUM	10
PA00601	PA Employee MSTR	37
PA00701	PA Equipment Master File	18
PA00801	PA Miscellaneous Master File	18
PA00901	PA Vendor MSTR	17
PA01001	PA Cost Category Master File	44
PA01101	PA Contract Master File	166
PA01121	PA Contract Periodic Totals MSTR	89
PA01141	PA Contract Change Order Master	43
PA01161	PA Contract MSTR WIP SUM	10
PA01201	PA Project Master File	184
PA01221	PA Project Periodic Totals MSTR	89
PA01241	PA Project Change Order Master	40
PA01251	PA Project MSTR WIP SUM	10
PA01301	PA Budget Master File	189
PA01303	PA Budget IVItems	66
PA01304	PA Budget Periodic Totals Master File	104
PA01341	PA Budget MSTR WIP SUM	12
PA01342	PA Budget MSTR COST SUM	12
PA01403	PA Employee Rate Table LINE	25
PA01404	PA Job Title Rate Table Header	6
PA01405	PA Job Title Rate Table Line	23
PA01406	PA Equipment Rate Table HDR	6
PA01407	PA Equipment Rate Table LINE	8
PA02101	PA Project Fee Master File	47
PA05200	PA Project Fee Schedule Master File	9
PA10000	PA Timesheet Header File	44
PA10001	PA Timesheet Detail File	104
PA10100	PA Equipment Log Header File	41
PA10101	PA Equipment Log Detail File	96
PA10200	PA Miscellaneous Log Header File	41
PA10201	PA Miscellaneous Log Detail File	94
PA10500	PA Employee Expense Header File	113
PA10501	PA Employee Expense Detail File	105
PA10601	PA Purchase Order Line	32
PA10701	PA PO Receipt Work	33
PA10702	PA PO Receipt Line	80
PA10721	PA PO Receipt Line Quantities	15
PA10900	PA Inventory Transfer Work Header	32
PA10901	PA Inventory Transfer Work Detail	87
PA11300	PA Billing Contract Link	4
PA11800	PA Combined History Header file	84
PA11801	PA Combined History Detail File	111
PA11901	PA Project Closing WORK Detail	20
PA11903	PA Project Closing Work Budget	31
PA11904	PA Project Closing Work Fee	23
PA11905	PA Project Closing History Budget	31
PA11906	PA Project Closing History Fee	23
PA12000	PA Change Order Header WORK	41
PA12001	PA Change Order Detail WORK	102
PA12101	PA Change Order Fee Header WORK	21
PA12102	PA Change Order Fee Detail WORK	55
PA13100	PA Billing Header WORK	117
PA13200	PA Billing Detail WORK	63
PA13201	PA Billing Sub-Detail WORK Fee	43
PA13202	PA Billing Sub-Detail WORK TM	57
PA13203	PA Billing Sub-Detail WORK FF	40
PA23100	PA Billing Header OPEN	118
PA23200	PA Billing Detail OPEN	64
PA23201	PA Billing Sub-Detail OPEN Fee	47
PA23202	PA Billing Sub-Detail OPEN FF	45
PA23203	PA Billing Sub-Detail OPEN TM	61
PA23302	PA Rev Recognition Proj Detail WORK File	44
PA23400	PA Change Order Header OPEN	35
PA23401	PA Change Order Detail OPEN	92
PA30100	PA Timesheet Header History File	44
PA30101	PA Timesheet Detail History File	104
PA30103	PA Timesheet Distribution History	15
PA30200	PA Equipment Log Header History File	41
PA30201	PA Equipment Log Detail History File	96
PA30300	PA Miscellaneous Log History File	41
PA30301	PA Miscellaneous Log History Detail File	94
PA30500	PA Employee Expense Header History File	112
PA30501	PA Employee Expense Detail History File	106
PA30600	PA Purchase Order History	17
PA30900	PA Inventory Transfer History Header	30
PA30901	PA Inventory Transfer History Detail	87
PA31101	PA PO Receipt History	38
PA31102	PA PO Receipt Line History	94
PA33100	PA Billing Header HIST	114
PA33101	PA Applied Header Open	5
PA33200	PA Billing Detail HIST	61
PA33202	PA Billing Sub-Detail HIST FF	40
PA33203	PA Billing Sub-Detail HIST TM	58
PA33701	PA Change Order Header HIST	34
PA33702	PA Change Order Detail HIST	92
PA40601	PA Employee Class Setup	19
PA40801	PA Miscellaneous Class Setup File	15
PA40901	PA Vendor Class Setup	13
PA41001	PA Cost Category Class Setup File	30
PA43010	paTS01	10
PA50102	Customer RM Applied Work	13
PA50103	Vendor PM Applied Work	10
PA50105	RMPMOpen	21
PA89422	PA Budget Template File Lookup	82
eePAIVLN	PA Invent Transfer Line	5
palbInvc	Lockbox Invoice Work	7