IEPMTRXI - ieTrxPMImport
Dynamics GP table IEPMTRXI (ieTrxPMImport) contains 19 columns including CMRECNUM, SEQUENCE1, VCHRNMBR....
SQL Query Builder
19 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CMRECNUM | Record Number | Currency | 10 | ||
| SEQUENCE1 | Sequence | Currency | 10 | ||
| VCHRNMBR | Voucher Number | String | 22 | ||
| VENDORID | Vendor ID | String | 16 | ||
| VENDNAME | Vendor Name | String | 66 | ||
| DOCDATE | Document Date | Date | 4 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| VNDDOCNM | Vendor Document Number | String | 22 | ||
| DSCRIPTN | Description | String | 32 | ||
| DOCAMNT | Document Amount | Currency | 10 | ||
| PRCHAMNT | Purchases Amount | Currency | 10 | ||
| TRDISAMT | Trade Discount Amount | Currency | 10 | ||
| FRTAMNT | Freight Amount | Currency | 10 | ||
| MSCCHAMT | Misc Charges Amount | Currency | 10 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| PYMTRMID | Payment Terms ID | String | 22 | ||
| SHIPMTHD | Shipping Method | String | 16 | ||
| ADRSCODE | Address Code | String | 16 | ||
| TAXSCHID | Tax Schedule ID | String | 16 | ||
Related Tables
Tables that share columns with IEPMTRXI. Click "Join" to add to your query.