| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | MMCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | MMBRINM | Movement Indicator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | MMBRDCTP | Document Type 2 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 4 | MMBRSSR | Document Series Sub Series | String | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | MMBRNNF | Nota Fiscal Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 6 | MMDTDO | Date - Document | Date | Generic Edit | 6 | 0 | |
| 7 | MMAT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 8 | MMAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 9 | MMINC | Include Time | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | MMBRDTM | Document Type - Model | String | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | MMADTJ | Date - Applied | Date | Generic Edit | 6 | 0 | |
| 12 | MMAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | MMACTAA | Total Actuals | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | MMDSCT | Discount Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | MMBRNNFR | Document Number - Ref | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 16 | MMBRSSRF | Document Series Sub Series | String | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | MMBIPR | Amount - IPI Tax Recoverable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | MMBIPI | Amount - IPI Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | MMBRIES | State Inscription Number | String | Generic Edit | 14 | 0 | Allow NULL? |
| 20 | MMBRIPIO | IPI General Observations | String | Generic Edit | 45 | 0 | Allow NULL? |
| 21 | MMBRICF | Final Tax Payer | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | MMBRNDI | Declaration Number of Importation | String | Generic Edit | 12 | 0 | Allow NULL? |
| 23 | MMCRTY | Carrier Type | String | Generic Edit | 3 | 0 | Allow NULL? |
| 24 | MMANCR | Carrier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | MMBRQTD | Volume Quantity | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 26 | MMBRESV | Volume Type | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | MMBRPB | Gross Weight - length 9 | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 28 | MMBRPL | Liquid Weight - length 9 | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 29 | MMFRTT | Freight Terms | String | UDC | 3 | 0 | Allow NULL? |
| 30 | MM901 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 31 | MMSCRC | Security Received | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | MMAMOT | Amount - Estimated Other | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | MMBFRT | Amount - Nota Fiscal Freight | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | MMBRIDV | Vehicle Identification | String | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | MMCSLF | Flag - Cancel | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | MMUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | MMEAP | Application ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | MMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | MMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 40 | MMUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |