|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Templates for Inventory JE
Table Name: OIMT
Table Description: Templates for Inventory JE
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ValuatType | Document Valuation Type | VarChar | 1 | - | N | A | Â |
| Â | Â | Â | Â | Â | Â | F | Â |
| Â | Â | Â | Â | Â | Â | S | Â |
| Â | Â | Â | Â | Â | Â | N | unDefined |
| TransType | Transaction type | Int | 11 | - | -1 | Â | Â |
| BaseType | Base Transaction Type | Int | 6 | - | -1 | Â | Â |
| TemplateId | Template ID | Int | 6 | - | -1 | Â | Â |
| LocalizId | Localization Identifier | nVarChar | 2 | - | XX | XX | All Localizations |
| Action | Action Type | Int | 6 | - | 0 | Â | Â |
| JEPosting | Posting Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | C | Complete |
| Â | Â | Â | Â | Â | Â | P | Partial |
| LineActTyp | Line Account Type | Int | 6 | - | 2 | 2 | LINE_ACCT_TYPE |
| TmpType | Template Type | Int | 6 | - | 0 | Â | Â |
| Total | Total Type | VarChar | 1 | - | M | M | Total from Message |
| Â | Â | Â | Â | Â | Â | C | Total from Calculator |
| Â | Â | Â | Â | Â | Â | F | Total from Formula |
| Key | Unique | Field |
| PRIMARY | Yes | TemplateId |
| SECONDARY | Yes | TransType |
| Â | Â | BaseType |
| Â | Â | ValuatType |
| Â | Â | LocalizId |
| Â | Â | Action |
| Â | Â | TmpType |