|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Inventory Revaluation - History - Rows
Table Name: AMR1
Table Description: Inventory Revaluation - History - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OMRV | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| Dscription | Item/Service Description | nVarChar | 200 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| Price | Price | Num | 19.6 | - | Â | Â | Â |
| LineTotal | Row Total | Num | 19.6 | - | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| RIncmAcct | Inv. Reval. Increment Account | nVarChar | 15 | - | Â | Â | Â |
| RDcrmAcct | Inv. Reval. Decrement Account | nVarChar | 15 | - | Â | Â | Â |
| RToStock | Reval. Amount Posted to Stock | Num | 19.6 | - | Â | Â | Â |
| RActPrice | Inv. Reval. Actual Price | Num | 19.6 | - | Â | Â | Â |
| ROnHand | In Stock at Reval. | Num | 19.6 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | 162 | Â | Â |
| EvalSystem | Cost Accounting Method | VarChar | 1 | OITM | Â | A | Moving Average |
| Â | Â | Â | Â | Â | Â | S | Standard |
| Â | Â | Â | Â | Â | Â | F | FIFO |
| Â | Â | Â | Â | Â | Â | B | Serial/Batch |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| UnitMsr | Unit of Measure | nVarChar | 100 | - | Â | Â | Â |
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| Â | Â | LogInstanc |
| Â | Â | ObjType |
| ITEM_WHS | No | ItemCode |
| Â | Â | WhsCode |
| ITEM | No | ItemCode |