Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our PA scripts. All of our scripts for Dynamics GP can be found here
PA Scripts
No records to display.
Module List > Module COMPANY..PA tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.

 Display Name
 GST00103GST PA Purchasing Receipt
 GST00104GST PA Purchasing Receipt
 GST00105PA Purchasing Tax History
 PA000001PA Proj Contr Activity Master
 PA000002PA Adjustment Activity
 PA00001Customer Vendor Master
 PA00002Customer Checks Setup
 PA00010Bank Account Master
 PA00401PA Fee Master File
 PA00402PA Project Fee Totals Master File
 PA00501PA Customer MSTR
 PA00502PA Third Party Customer MSTR
 PA00503PA Third Party Customer MSTR1
 PA00511PA Customer Periodic Totals MSTR
 PA00512PA Customer CO Periodic Totals MSTR
 PA00521PA Customer MSTR SUM
 PA00531PA Customer MSTR WIP SUM
 PA00532PA Customer MSTR COST SUM
 PA00601PA Employee MSTR
 PA00701PA Equipment Master File
 PA00801PA Miscellaneous Master File
 PA00901PA Vendor MSTR
PA01001PA Cost Category Master File

The PA_Cost_Category_MSTR table contains the identifying document information for a cost category.

PA01101PA Contract Master File
 PA01111PA Contract Revenue Sources Master File
 PA01121PA Contract Periodic Totals MSTR
 PA01122PA Contract CO Periodic Totals MSTR
 PA01131PA Contract MSTR SUM
 PA01141PA Contract Change Order Master
 PA01151PA Contract Customer List MSTR
 PA01161PA Contract MSTR WIP SUM
 PA01162PA Contract MSTR COST SUM
PA01201PA Project Master File
 PA01202PA MC Project Master File
 PA01211PA Project Revenue Sources Master File
 PA01221PA Project Periodic Totals MSTR
 PA01222PA Project CO Periodic Totals MSTR
 PA01231PA Project MSTR SUM
 PA01241PA Project Change Order Master
 PA01251PA Project MSTR WIP SUM
 PA01252PA Project MSTR COST SUM
PA01301PA Budget Master File
 PA01303PA Budget IVItems
 PA01304PA Budget Periodic Totals Master File
 PA01341PA Budget MSTR WIP SUM
 PA01402PA Employee Rate Table HDR
 PA01403PA Employee Rate Table LINE
 PA01404PA Job Title Rate Table Header
 PA01405PA Job Title Rate Table Line
 PA01406PA Equipment Rate Table HDR
 PA01407PA Equipment Rate Table LINE
 PA01408PA Project Access List MSTR
 PA01409PA Project Equipment List MSTR
 PA01410PA Project Customer List Master
 PA01601PA Billing Notes Master
 PA01801PA Location Format Setup
 PA01901PA Key Master
 PA02000PA Billing Cycle MSTR
 PA02001PA Combined History Setup
 PA02010PA RR Cycle MSTR
 PA02101PA Project Fee Master File
 PA02301PA Customer Billing Cycle Link File
 PA02401PA Contract Billing Cycle Link File
 PA02501PA Contract RR Cycle Link File
 PA02601PA Customer RR Cycle Link File
 PA02701PA Change Order Key Master
 PA03400PA Generic File Log
 PA05100PA Project Billing Master File
 PA05100APA Project Billing Master File
 PA05200PA Project Fee Schedule Master File
The PA_Project_Fee_Schedule_MSTR table contains the date effectivity schedule information of fees
 PA41701APA Project Source Setup
 PDK00101PDK Timesheet Delegates
 PDK00102PDK Employee Expense Delegates
 PDK00200Palette Master
 PDK00300PDK Timesheet Template Header
 PDK00301PDK Timesheet Template LINE
 PDK00400Work Menu Master
 PDK00700Window Notes Master
 PDK01601PDK Billing Notes Master
 PDK03900PDK Record Notes Master
 PT00101Project Costing Master
 Display Name
 PA10000PA Timesheet Header File
 PA10001PA Timesheet Detail File
 PA10003PA Timesheet Distribution WORK
 PA10100PA Equipment Log Header File
 PA10101PA Equipment Log Detail File
 PA10103PA Equipment Log Distribution WORK
 PA10200PA Miscellaneous Log Header File
 PA10201PA Miscellaneous Log Detail File
 PA10203PA Miscellaneous Log Distribution WORK
 PA10500PA Employee Expense Header File
 PA10501PA Employee Expense Detail File
 PA10502PA Employee Expense Tax WORK file
 PA10504PA Employee Expense Distribution WORK
 PA10600PA Purchase Order Work
 PA10601PA Purchase Order Line
 PA10602PA Purchase Order Tax
 PA10701PA PO Receipt Work
 PA10702PA PO Receipt Line
 PA10704PA PO Tax
 PA10705PA PO Distribution Work
 PA10721PA PO Receipt Line Quantities
 PA10731PA PO Shipment Invoice Apply
 PA10802PA Billing Distribution WORK
 PA10900PA Inventory Transfer Work Header
 PA10901PA Inventory Transfer Work Detail
 PA10902PA Inventory Serial and Lot Number Work
 PA10903PA Inventory Distribution WORK
 PA10904PA Invenotry Transfer Tax WORK file
 PA10905PA Inventory Transaction Bin Quantities Work
 PA11000PA Billing Commissions LINK
 PA11100PA Billing Tax Detail
 PA11300PA Billing Contract Link
 PA11400PA Billing Project Link
 PA11500PA Billing Contracts
 PA11700PA Billing Subline Tax Detail
 PA11800PA Combined History Header file
 PA11801PA Combined History Detail File
 PA11900PA Project Closing WORK Header
 PA11901PA Project Closing WORK Detail
 PA11902PA Project Closing Distribution WORK
 PA11903PA Project Closing Work Budget
 PA11904PA Project Closing Work Fee
 PA11905PA Project Closing History Budget
 PA11906PA Project Closing History Fee
 PA12000PA Change Order Header WORK
 PA12001PA Change Order Detail WORK
 PA12101PA Change Order Fee Header WORK
 PA12102PA Change Order Fee Detail WORK
 PA12103PA Change Order Fee Schedule WORK
 PA13100PA Billing Header WORK
 PA13200PA Billing Detail WORK
 PA13201PA Billing Sub-Detail WORK Fee
 PA13202PA Billing Sub-Detail WORK TM
 PA13203PA Billing Sub-Detail WORK FF
 PA13204PA Distribution Work File
 PA13300PA Aging WIP Reconcile Control
 PA13400PA Aging Reconcile Control
 PA14100PA Cost Trx Add On The Fly
 PA14300PA PO Project Assignment
 PA14301PA PO Project Assignment Detail
 PA14400PA PO Receivings Assignment
 PA14401PA PO Receivings Assignment Detail
 PA61020PA Project Billing Cycle Link File
 PA61040PA Project RR Cycle Link File
 PA91301PA Contract Segment Override Header
 PA91304PA Contract Segment Override Detail
 PDK10000PDK Timesheet HDR
 PDK10001PDK Timesheet LINE
 PDK10500PDK Employee Expense HDR
 PDK10501PDK Employee Expense LINE
 PDK10502PDK Employee Expense Tax WORK
 PDK10503PDK eExpense
 PT10000Project Distributions
 PTE00300PTE Timesheet Template Header
 PTE00301PTE Timesheet Template Line
 PTE00601PTE Employee Master
 PTE00602PTE Timesheet Delegates
 PTE00603PTE Employee Expense Delegates
 PTE10000PTE Timesheet Header
 PTE10001PTE Timesheet Line
 PTE10500PTE Employee Expense Header
 PTE10501PTE Employee Expense Line
 Display Name
 PA23000PA Applied OPEN
 PA23010PA Applied Sub Detail OPEN
 PA23100PA Billing Header OPEN
 PA23101PA Applied Header History
 PA23200PA Billing Detail OPEN
 PA23201PA Billing Sub-Detail OPEN Fee
 PA23202PA Billing Sub-Detail OPEN FF
 PA23203PA Billing Sub-Detail OPEN TM
 PA23301PA Rev Recognition Header Work File
 PA23302PA Rev Recognition Proj Detail WORK File
 PA23303PA Rev Recognition Fee DTL Work File
 PA23304PA Rev Recognition Budget DTL Work File
 PA23305PA Rev Recognition Distribution Work
 PA23400PA Change Order Header OPEN
 PA23401PA Change Order Detail OPEN
 PA23500PA Change Order Fee Header OPEN
 PA23501PA Change Order Fee Detail OPEN
 PA23502PA Change Order Fee Schedule OPEN
 PA92301PA Contract Template Seg Override Header
 PA92304PA Contract Template Seg Override Detail
Work Tables
 Display Name
 PA30000PA Posting Definitions Master History
 PA30100PA Timesheet Header History File
 PA30101PA Timesheet Detail History File
 PA30103PA Timesheet Distribution History
 PA30200PA Equipment Log Header History File
 PA30201PA Equipment Log Detail History File
 PA30203PA Equipment Log Distribution History
 PA30300PA Miscellaneous Log History File
 PA30301PA Miscellaneous Log History Detail File
 PA30303PA Miscellaneous Log Distribution History
 PA30500PA Employee Expense Header History File
 PA30501PA Employee Expense Detail History File
 PA30503PA Employee Expense Tax WORK HIstory file
 PA30504PA Employee Expense Distribution History
 PA30600PA Purchase Order History
 PA30601PA Purchase Order Line History
 PA30602PA Purchase Order Tax History
 PA30703PA Billing Distribution History
 PA30900PA Inventory Transfer History Header
 PA30901PA Inventory Transfer History Detail
 PA30902PA Item Serial and Lot Number History
 PA30903PA Inventory Distribution History
 PA30904PA Invenotry Transfer Tax HiST file
 PA30905PAInventory Transaction Bin Quantities Histo
 PA31101PA PO Receipt History
 PA31102PA PO Receipt Line History
 PA31103PA PO Tax History
 PA33100PA Billing Header HIST
 PA33101PA Applied Header Open
 PA33200PA Billing Detail HIST
 PA33201PA Billing Sub-Detail HIST Fee
 PA33202PA Billing Sub-Detail HIST FF
 PA33203PA Billing Sub-Detail HIST TM
 PA33204PA Billing Commissions HIST
 PA33205PA Billing Tax Detail Hist
 PA33206PA Billing Subline Tax Detail Hist
 PA33301PA Rev Recognition Header HIST File
 PA33302PA Rev Recognition Budget DTL HIST File
 PA33303PA Rev Recognition Fee DTL HIST File
 PA33304PA Rev Recognition Proj Detail HIST File
 PA33305PA Rev Recognition Distribution History
 PA33401PA Billing Apply Distribution History
 PA33501PA Project Closing History
 PA33502PA Project Closing Distribution HIST
 PA33601PA Applied History File
 PA33602PA Applied Sub Detail History File
 PA33701PA Change Order Header HIST
 PA33702PA Change Order Detail HIST
 Display Name
 eePAIVLNPA Invent Transfer Line
 EEPAIVRQPA Inventory Returned Quantities
 PA40101PA U of M Schedule Setup
 PA40102PA U of M Schedule Detail Setup
 PA40201PA Budget Template File
 PA40202PA Budget Template IV Items
 PA40203PA Project Template Fee Sched Master File
 PA40501PA Customer Class Setup
 PA40601PA Employee Class Setup
 PA40701PA Equipment Class Setup File
 PA40801PA Miscellaneous Class Setup File
 PA40901PA Vendor Class Setup
 PA41001PA Cost Category Class Setup File
 PA41101PA Contract Class Setup File
 PA41201PA Project Class Setup File
 PA41301PA Segment Override Header
 PA41302PA Segment Override Line
 PA41303PA Segment Override Template Header
 PA41304PA Segment Override Template Detail
 PA41401PA Project Access Template SETP
 PA41409PA Project Equipment Template SETP
 PA41501PA Contract TemplateFile
 PA41601PA Project Template File
 PA41701PA Project Budget Setup
 PA41801PA Timesheet Setup
 PA41901PA Equipment Log Setup
 PA42001PA Miscellaneous Log Setup
 PA42201PA Purchase Order Setup
 PA42401PA Employee Expense Setup
 PA42501PA Biller Module Setup
 PA42601PA Bill Format Setup
 PA42602PA Bill Format Print SETP
 PA42701PA Inventory Transfer Setup
 PA42801PA Customer Class Billing Cycle Link
 PA42802PA Customer Class RR Cycle Link
 PA42901PA Contract Billing Cycle Link
 PA42902PA Contr Templ RR Cycle Link
 PA43001PA Accounts Setup File
 PA43002PA Accounts Template Setup File
 PA43101PA User Defined Bill Format SETP
 PA43102PA User Defined Bill Format DTL SETP
 PA50100Customer Checks Work
 PA50102Customer RM Applied Work
 PA50103Vendor PM Applied Work
 PA60020PA Project Template Billing Cycle Link File
 PA60030PA Project Template RR Cycle Link File
 PA60040PA Project Template Fee Master
 PA70101PA Project Series Report Options
 PA89422PA Budget Template File Lookup
 PDK70101PDK Report Options
 PDK70300Report Option Names
 PT40100Project Costing Setup
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables