RM30202 - RM Apply Reprint Journal File
Dynamics GP table RM30202 (RM Apply Reprint Journal File) contains 21 columns including CUSTNMBR, APTODCNM, APTODCTY....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | |
| APTODCNM | Apply To Document Number | String | 22 | |
| APTODCTY | Apply To Document Type | Integer | 2 | |
| APPTOAMT | Apply To Amount | Currency | 10 | |
| APFRDCNM | Apply From Document Number | String | 22 | |
| APFRDCTY | Apply From Document Type | Integer | 2 | |
| APFRDCDT | Apply From Document Date | Date | 4 | |
| TRXSORCE | TRX Source | String | 14 | |
| DISTKNAM | Discount Taken Amount | Currency | 10 | |
| WROFAMNT | Write Off Amount | Currency | 10 | |
| DATE1 | Date | Date | 4 | |
| GLPOSTDT | GL Posting Date | Date | 4 | |
| POSTED | Posted | Boolean | 2 | |
| GSTDSAMT | GST Discount Amount | Currency | 10 | |
| PPSAMDED | PPS Amount Deducted | Currency | 10 | |
| TAXDTLID | Tax Detail ID | String | 16 | |
| ORAPTOAM | Originating Apply To Amount | Currency | 10 | |
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | |
| ORDATKN | Originating Discount Available Taken | Currency | 10 | |
| ORWROFAM | Originating Write Off Amount | Currency | 10 | |
| RLGANLOS | Realized Gain-Loss Amount | Currency | 10 |
Related Tables
Tables that share columns with RM30202. Click "Join" to add to your query.