PM80500 - PM Reprint Posting Journal Apply To File
Dynamics GP table PM80500 (PM Reprint Posting Journal Apply To File) contains 26 columns including TRXSORCE, VCHRNMBR, DOCTYPE....
SQL Query Builder
26 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| TRXSORCE | TRX Source | String | 14 | ||
| VCHRNMBR | Voucher Number | String | 22 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| APFRDCNM | Apply From Document Number | String | 22 | ||
| VENDORID | Vendor ID | String | 16 | ||
| APTVCHNM | Apply To Voucher Number | String | 22 | ||
| APTODCTY | Apply To Document Type | Integer | 2 | ||
| APTODCNM | Apply To Document Number | String | 22 | ||
| APPLDAMT | Applied Amount | Currency | 10 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| WROFAMNT | Write Off Amount | Currency | 10 | ||
| PPSAMDED | PPS Amount Deducted | Currency | 10 | ||
| GSTDSAMT | GST Discount Amount | Currency | 10 | ||
| TAXDTLID | Tax Detail ID | String | 16 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| PTDUSRID | Posted User ID | String | 16 | ||
| TEN99AMNT | 1099 Amount | Currency | 10 | ||
| DISAVTKN | Discount Available Taken | Currency | 10 | ||
| DOCDATE | Document Date | Date | 4 | ||
| APTODCDT | Apply To Document Date | Date | 4 | ||
| KEYSOURC | Key Source | String | 42 | ||
| ORAPPAMT | Originating Applied Amount | Currency | 10 | ||
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | ||
| ORWROFAM | Originating Write Off Amount | Currency | 10 | ||
| ORDATKN | Originating Discount Available Taken | Currency | 10 | ||
| RLGANLOS | Realized Gain-Loss Amount | Currency | 10 | ||
Related Tables
Tables that share columns with PM80500. Click "Join" to add to your query.