PA50102 - Customer RM Applied Work
Dynamics GP table PA50102 (Customer RM Applied Work) contains 13 columns including USERID, CUSTNMBR, CPRCSTNM....
SQL Query Builder
13 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| USERID | User ID | String | 16 | |
| CUSTNMBR | Customer Number | String | 16 | |
| CPRCSTNM | Corporate Customer Number | String | 16 | |
| APFRDCTY | Apply From Document Type | Integer | 2 | |
| APFRDCNM | Apply From Document Number | String | 22 | |
| APTODCTY | Apply To Document Type | Integer | 2 | |
| APTODCNM | Apply To Document Number | String | 22 | |
| APPTOAMT | Apply To Amount | Currency | 10 | |
| ORAPTOAM | Originating Apply To Amount | Currency | 10 | |
| DISTKNAM | Discount Taken Amount | Currency | 10 | |
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | |
| FROMCURR | Apply From Currency ID | String | 16 | |
| paRefundApply | paRefundApply | Integer | 2 |
Related Tables
Tables that share columns with PA50102. Click "Join" to add to your query.