|
|
SAP Business One SDK 10.0 - Database Tables Reference |
FIFO Based Sales Return
Table Name: UIVE
Table Description: FIFO Based Sales Return
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TreeID | Tree ID | Int | 11 | - | 0 | Â | Â |
| ParentID | Parent ID | Int | 11 | - | -1 | Â | Â |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| LocType | Location Type | Int | 6 | - | Â | Â | Â |
| LocCode | Location Code | nVarChar | 8 | - | Â | Â | Â |
| TransSeq | Transaction Sequence No. | Int | 11 | UIVL | Â | Â | Â |
| LayerID | Layer ID | Int | 11 | - | Â | Â | Â |
| LayerInQty | Layer In Quantity | Num | 19.6 | - | Â | Â | Â |
| LayerOutQ | Layer Out Quantity | Num | 19.6 | - | Â | Â | Â |
| LayerVal | Layer Value | Num | 19.6 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | UITM | Â | Â | Â |
| EntryTreeI | Entry Tree ID | Int | 11 | - | Â | Â | Â |
| LayerCogs | Layer - Cost of Goods Sold | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| TRANS_SEQ | No | TransSeq |
| Â | Â | LayerID |
| TreeID | No | TreeID |