PA50105 - RMPMOpen
Dynamics GP table PA50105 (RMPMOpen) contains 21 columns including USERID, DOCTYPE, DOCNUMBR....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| USERID | User ID | String | 16 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| DOCNUMBR | Document Number | String | 22 | ||
| VCHRNMBR | Voucher Number | String | 22 | ||
| MODULEID | Module ID | Integer | 2 | ||
| DOCDATE | Document Date | Date | 4 | ||
| DUEDATE | Due Date | Date | 4 | ||
| CustVenID | Customer Vendor ID | String | 16 | ||
| CURTRXAM | Current Trx Amount | Currency | 10 | ||
| ORCTRXAM | Originating Current Trx Amount | Currency | 10 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| VOIDSTTS | Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. | Integer | 2 | ||
Void Status values (2) 0 = Normal1 = Voided | |||||
| APPLDAMT | Applied Amount | Currency | 10 | ||
| ORAPPAMT | Originating Applied Amount | Currency | 10 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | ||
| DISAVTKN | Discount Available Taken | Currency | 10 | ||
| ORDATKN | Originating Discount Available Taken | Currency | 10 | ||
| TAXDTLID | Tax Detail ID | String | 16 | ||
| GSTDSAMT | GST Discount Amount | Currency | 10 | ||
| PPSAMDED | PPS Amount Deducted | Currency | 10 | ||
Related Tables
Tables that share columns with PA50105. Click "Join" to add to your query.