| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | IMCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | IMBRINM | Movement Indicator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | IMBRSSR | Document Series Sub Series | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | IMBRNNF | Nota Fiscal Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 5 | IMAT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 6 | IMAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 7 | IMLID0 | Line Number | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | IMLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 9 | IMA201 | Work Order Type | String | UDC (48 OT) | 2 | 0 | Allow NULL? |
| 10 | IMDSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | IMDSC2 | Description - Line 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 12 | IMMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 13 | IMBRCFOP | CFOP | String | Generic Edit | 5 | 0 | Allow NULL? |
| 14 | IMBRTPO | Operation Type | String | Generic Edit | 3 | 0 | Allow NULL? |
| 15 | IMBCLF | Fiscal Classification | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | IMUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 17 | IMUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | IMLIQW | Liquid Weight | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | IMUPRC | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 20 | IMAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | IMDSCT | Discount Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | IMBRROM | Romaneio Number | String | Generic Edit | 12 | 0 | Allow NULL? |
| 23 | IMABCX | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 24 | IMBFRT | Amount - Nota Fiscal Freight | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | IMSCRC | Security Received | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | IMAOTH | Amount - Other Charges | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | IMTM01 | Federal Additional Tax Method1 | String | Generic Edit | 2 | 0 | Allow NULL? |
| 28 | IMBRIPID | Tax Indicator IPI | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | IMBRPCIPI | IPI Rate | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 30 | IMBIPR | Amount - IPI Tax Recoverable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | IMBIPI | Amount - IPI Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | IMBRSTEA | Situation of State Tax (A) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | IMBRSTEB | Situation of State Tax (B) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | IMBRIIC | Indicator of ICMS Tax | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | IMBRPICM | ICMS Rate | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 36 | IMBBCL | Amount - ICMS Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 37 | IMBICP | Amount - ICMS to be Paid | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | IMBVIS | Amount - ICMS Substitute | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 39 | IMBICM | Amount - ICMS Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 40 | IMBBIR | Amount - ICMS Reduced Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 41 | IMBRDFIC | Difference of ICMS Rate | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 42 | IMUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | IMEAP | Application ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 44 | IMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | IMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 46 | IMUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |