IERMTRXI - ieTrxRMImport
Dynamics GP table IERMTRXI (ieTrxRMImport) contains 18 columns including CMRECNUM, SEQUENCE1, RMDNUMWK....
SQL Query Builder
18 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CMRECNUM | Record Number | Currency | 10 | ||
| SEQUENCE1 | Sequence | Currency | 10 | ||
| RMDNUMWK | RM Document Number-WORK | String | 18 | ||
| CUSTNMBR | Customer Number | String | 16 | ||
| CUSTNAME | Customer 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 | |||||
| DOCDESCR | Document Description | String | 32 | ||
| DOCAMNT | Document Amount | Currency | 10 | ||
| SLSAMNT | Sales 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 IERMTRXI. Click "Join" to add to your query.