GP Tables

PA00502 - PA Third Party Customer MSTR

Dynamics GP table PA00502 (PA Third Party Customer MSTR) contains 7 columns including PAPROJNUMBER, CUSTNMBR, PAUNPOSTRETAMT....

SQL Query Builder

7 Columns

Column Description Type Length
PAPROJNUMBER PA Project Number String 16
CUSTNMBR Customer Number String 16
PAUNPOSTRETAMT PA Unposted Retention Amount Currency 10
PAPOSTRETAMT PA Actual Retention Amount Currency 10
PAUnposted_Retainer_Fee PA Unposted Retainer Fee Amount Currency 10
PAPosted_Retainer_Fee PA Actual Retainer Fee Amount Currency 10
ACCTAMNT Account Amount Currency 10

Related Tables

Tables that share columns with PA00502. Click "Join" to add to your query.

PAPosted_Retainer_Fee

PAUNPOSTRETAMT

PAUnposted_Retainer_Fee