|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Pick List - Rows
Table Name: PKL1
Table Description: Pick List - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OPKL | Â | Â | Â |
| PickEntry | Row Number | Int | 11 | - | Â | Â | Â |
| OrderEntry | Order Entry | Int | 11 | - | Â | Â | Â |
| OrderLine | Order Row ID | Int | 11 | - | Â | Â | Â |
| PickQtty | Picked Quantity | Num | 19.6 | - | Â | Â | Â |
| PickStatus | Pick Status | VarChar | 1 | - | R | R | Released for Picking |
| Â | Â | Â | Â | Â | Â | Y | Picked |
| Â | Â | Â | Â | Â | Â | P | Partially Picked |
| Â | Â | Â | Â | Â | Â | D | Partially Delivered |
| Â | Â | Â | Â | Â | Â | C | Closed |
| RelQtty | Released Quantity | Num | 19.6 | - | Â | Â | Â |
| LogInsac | Log Instance - History | Int | 11 | - | Â | Â | Â |
| PrevReleas | Previously Released Quantity | Num | 19.6 | - | Â | Â | Â |
| BaseObject | Base Object Type | Int | 11 | - | Â | 17 | Order |
| Â | Â | Â | Â | Â | Â | 13 | Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 202 | Production Order |
| Â | Â | Â | Â | Â | Â | 1250000001 | Inventory Transfer Request |
| Â | Â | Â | Â | Â | Â | 0 | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | PickEntry |
| ORDER | No | OrderEntry |
| Â | Â | OrderLine |