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.

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

PAPosted_Retainer_Fee

PAUNPOSTRETAMT

PAUnposted_Retainer_Fee