| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CMRECNUM | Record Number |
Currency | 10 | View | |
| SEQUENCE1 | Sequence |
Currency | 10 | View | |
| RMDNUMWK | RM Document Number-WORK |
String | 18 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CUSTNAME | Customer Name |
String | 66 | View | |
| DOCDATE | Document Date |
Date | 4 | View | |
| DOCTYPE | Document Type |
Integer | 2 | View | |
| DOCDESCR | Document Description |
String | 32 | View | |
| DOCAMNT | Document Amount |
Currency | 10 | View | |
| SLSAMNT | Sales Amount |
Currency | 10 | View | |
| TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
| FRTAMNT | Freight Amount |
Currency | 10 | View | |
| MSCCHAMT | Misc Charges Amount |
Currency | 10 | View | |
| TAXAMNT | Tax Amount |
Currency | 10 | View | |
| PYMTRMID | Payment Terms ID |
String | 22 | View | |
| SHIPMTHD | Shipping Method |
String | 16 | View | |
| ADRSCODE | Address Code |
String | 16 | View | |
| TAXSCHID | Tax Schedule ID |
String | 16 | View |