PA00503 - PA Third Party Customer MSTR1
Dynamics GP table PA00503 (PA Third Party Customer MSTR1) contains 9 columns including PAPROJNUMBER, CUSTNMBR, PAUNPOSTRETAMT....
SQL Query Builder
9 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 | |
| PA_Unposted_Billed_Reten | PA Unposted Billed Retention | Currency | 10 | |
| PA_Actual_Billed_Retenti | PA Actual Billed Retention | Currency | 10 | |
| ACCTAMNT | Account Amount | Currency | 10 |
Related Tables
Tables that share columns with PA00503. Click "Join" to add to your query.