PA50103 - Vendor PM Applied Work
Dynamics GP table PA50103 (Vendor PM Applied Work) contains 10 columns including APTVCHNM, VCHRNMBR, VENDORID....
SQL Query Builder
10 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| APTVCHNM | Apply To Voucher Number | String | 22 | ||
| VCHRNMBR | Voucher Number | String | 22 | ||
| VENDORID | Vendor ID | String | 16 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| APTODCNM | Apply To Document Number | String | 22 | ||
| APPLDAMT | Applied Amount | Currency | 10 | ||
| DOCDATE | Document Date | Date | 4 | ||
| CUSTNMBR | Customer Number | String | 16 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
Related Tables
Tables that share columns with PA50103. Click "Join" to add to your query.