|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Inventory Components for Production
Table Name: UIVL2
Table Description: Inventory Components for Production
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Transseq | Transaction sequence | Int | 11 | - | Â | Â | Â |
| MessageID | Message ID | Int | 11 | OILM | Â | Â | Â |
| LineID | Line ID | Int | 11 | - | Â | Â | Â |
| POLine | Line in Production Order | Int | 11 | - | Â | Â | Â |
| ItemType | Item Type | Int | 11 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| LocType | Location Type | Int | 6 | - | Â | Â | Â |
| LocCode | Location Code | nVarChar | 8 | - | Â | Â | Â |
| LayerTSeq | FIFO Layer Transaction Sequence | Int | 11 | - | -1 | Â | Â |
| LayerId | Layer ID | Int | 11 | - | -1 | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| TotalLC | Inventory Total LC | Num | 19.6 | - | Â | Â | Â |
| BaseAbsEnt | Abs. Entry of Base Doc. | Int | 11 | - | -1 | Â | Â |
| BaseType | Base Transaction Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| Â | Â | Â | Â | Â | Â | 60 | Goods Issue |
| BaseLine | Base Line Number | Int | 11 | - | -1 | Â | Â |
| StgSeqNum | Stage Sequence Number | Int | 11 | - | Â | Â | Â |
| StgEntry | Stage Entry | Int | 11 | ORST | Â | Â | Â |
| StgDesc | Stage Description | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | MessageID |
| Â | Â | LineID |