|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Inventory Revaluation
Table Name: OMRV
Table Description: Inventory Revaluation
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocDate | Posting Date | Date | 8 | - | Â | Â | Â |
| Ref1 | Reference 1 | nVarChar | 11 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 11 | - | Â | Â | Â |
| Comments | Remarks | nVarChar | 254 | - | Â | Â | Â |
| JrnlMemo | Journal Remarks | nVarChar | 254 | - | Â | Â | Â |
| TransId | Transaction Number | Int | 11 | OJDT | Â | Â | Â |
| DocTime | Generation Time | Int | 6 | - | Â | Â | Â |
| RevalType | Inventory Valuation Type | VarChar | 1 | - | P | P | Price Change |
| Â | Â | Â | Â | Â | Â | M | Inventory Debit/Credit |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| Series | Series | Int | 11 | NNM1 | Â | Â | Â |
| TaxDate | Document Date | Date | 8 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Upgrade |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| StationID | Workstation ID | Int | 11 | CSTN | Â | Â | Â |
| RIncmAcct | Invent. Reval. Expense Account | nVarChar | 15 | - | Â | Â | Â |
| RExpnAcct | Invent. Reval. Expense Account | nVarChar | 15 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | 162 | Â | Â |
| SeqCode | Sequence Code | Int | 6 | - | Â | Â | Â |
| Serial | Serial Number | Int | 11 | - | Â | Â | Â |
| SeriesStr | Series String | nVarChar | 3 | - | Â | Â | Â |
| SubStr | Subseries String | nVarChar | 3 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| InflaReval | Inflation-Based Revaluation | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SupplCode | Supplementary Code | nVarChar | 254 | - | Â | Â | Â |
| CardCode | Customer/Vendor Code | nVarChar | 15 | OCRD | Â | Â | Â |
| CardName | Customer/Vendor Name | nVarChar | 200 | - | Â | Â | Â |
| CreatedBy | Entry Creation Origin | VarChar | 1 | - | M | M | Created Manually by User |
| Â | Â | Â | Â | Â | Â | W | Created by Production Cost Recalculation Wizard |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| NUM | No | DocNum |
| SERIES | No | Series |