|
|
SAP Business One SDK 10.0 - Database Tables Reference |
OITM Extension
Table Name: ITM10
Table Description: OITM Extension
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| ISCommCode | Commodity Code | Int | 11 | ODCI | Â | Â | Â |
| ISSubMasUn | Intrastat Additional Measure | Int | 11 | ODCI | Â | Â | Â |
| ISFactor | IS Factor Additional Measure | Num | 19.6 | - | Â | Â | Â |
| ISOrCSTImp | IS Destination State for Impor. | Int | 11 | ODCI | Â | Â | Â |
| ISOrCSTExp | IS State of Origin for Export | Int | 11 | ODCI | Â | Â | Â |
| ISNaTraImp | IS Nature of Trans. Import | Int | 11 | ODCI | Â | Â | Â |
| ISNaTraExp | IS Nature of Trans. Export | Int | 11 | ODCI | Â | Â | Â |
| ISStProImp | IS Statistical Procedure Imp. | Int | 11 | ODCI | Â | Â | Â |
| ISStProExp | IS Statistical Procedure Exp. | Int | 11 | ODCI | Â | Â | Â |
| ISOriCntry | Intrastat Country of Origin | nVarChar | 3 | OCRY | Â | Â | Â |
| ISSerCode | Intrastat Service Code | Int | 11 | ODCI | Â | Â | Â |
| ISItemType | Intrastat Item Type | VarChar | 1 | - | I | I | Item |
| Â | Â | Â | Â | Â | Â | S | Service |
| ISSerSupMt | IS Service Supply Method | nVarChar | 12 | - | I | I | Immediate |
| Â | Â | Â | Â | Â | Â | R | To More Resumptions |
| ISSerPayMt | IS Service Payment Method | nVarChar | 12 | - | X | A | Accredited to Bank Account |
| Â | Â | Â | Â | Â | Â | B | Bank Transfer |
| Â | Â | Â | Â | Â | Â | X | Other |
| ISOrCRYImp | IS Destination Country for Imp. | nVarChar | 3 | OCRY | Â | Â | Â |
| ISOrCRYExp | IS Origin Country for Export | nVarChar | 3 | OCRY | Â | Â | Â |
| ISUseWeigh | Use Wt in Add. Measure Calc. | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ISRelevant | Intrastat Relevant | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ISStatCode | Statistical Code | nVarChar | 2 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ItemCode |