|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Item Imformation of MI
Table Name: MIN2
Table Description: Item Imformation of MI
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| MinvNum | Monthly Invoice Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocType | Document Type | nVarChar | 20 | - | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| DocDate | Document Date | Date | 8 | - | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | - | Â | Â | Â |
| ItemName | Item Name | nVarChar | 200 | - | Â | Â | Â |
| ItemPrice | Item Price | Num | 19.6 | - | Â | Â | Â |
| ItemCurr | Item Currency | nVarChar | 3 | - | Â | Â | Â |
| itemRate | Currency Exchange Rate | Num | 19.6 | - | Â | Â | Â |
| ItemQuan | Item Quantity | Num | 19.6 | - | Â | Â | Â |
| ItemType | Item Type | VarChar | 1 | - | I | I | Â |
| Â | Â | Â | Â | Â | Â | E | Â |
| Â | Â | Â | Â | Â | Â | D | Â |
| Â | Â | Â | Â | Â | Â | R | Â |
| Â | Â | Â | Â | Â | Â | T | Â |
| Â | Â | Â | Â | Â | Â | S | Â |
| Â | Â | Â | Â | Â | Â | P | Â |
| Â | Â | Â | Â | Â | Â | W | Â |
| ItemTotal | Item Total | Num | 19.6 | - | Â | Â | Â |
| TaxAmount | Tax Amount | Num | 19.6 | - | Â | Â | Â |
| LineTotal | Row Total | Num | 19.6 | - | Â | Â | Â |
| Entry | Monthly Invoice Entry | Int | 11 | OMIN | Â | Â | Â |
| AbsEntry | Document Entry | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Entry |
| Â | Â | DocType |
| Â | Â | AbsEntry |
| Â | Â | LineNum |