PA00001 - Customer Vendor Master
Dynamics GP table PA00001 (Customer Vendor Master) contains 7 columns including CUSTNMBR, VENDORID, CURNCYID....
SQL Query Builder
7 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | |
| VENDORID | Vendor ID | String | 16 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| RATETPID | Rate Type ID | String | 16 | |
| CREATDDT | Created Date | Date | 4 | |
| CRUSRID | Created User ID | String | 16 | |
| MODIFDT | Modified Date | Date | 4 |
Related Tables
Tables that share columns with PA00001. Click "Join" to add to your query.