|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Items Last Revaluation Data
Table Name: IWZ3
Table Description: Items Last Revaluation Data
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OIWZ | Â | Â | Â |
| ItemCode | Item Number | nVarChar | 50 | OITM | Â | Â | Â |
| WhCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| RevalPrice | Revaluated Price | Num | 19.6 | - | Â | Â | Â |
| BaseCurr | Item Base Currency | nVarChar | 3 | - | Â | Â | Â |
| RevalDate | Revaluation Date | Date | 8 | - | Â | Â | Â |
| RevalSum | Revaluation Sum | Num | 19.6 | - | Â | Â | Â |
| BasePrice | Base Price | Num | 19.6 | - | Â | Â | Â |
| RealAcct | Revaluation Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevalOfsac | Reval. Offset Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevalType | Revaluation Type | VarChar | 1 | - | S | S | Inventory Reval. Type |
| Â | Â | Â | Â | Â | Â | C | COGS Revaluation Type |
| ExeLine | Executed Row | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RevCancel | Revaluation Cancel | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| RvCaclDate | Reval. Acct Cancellation Date | Date | 8 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| BalanceBef | Balance Before Revaluation | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | ItemCode |
| Â | Â | WhCode |
| ABS | No | AbsEntry |