biuan SAP® BUSINESS ONE SDK
DTW Inventory / Pick and Pack / Pick List
API OPKL / / Pick Lists
OPKL - Pick List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbsolute entryInt
11
PRIMARYYes
NameNamenVarChar
127
OwnerCodeOwner CodeInt
6OUSR
Users
OwnerNameOwner NamenVarChar
127
PickDatePick DateDate
8
RemarksRemarksText
16
CanceledCanceledVarChar
Y) Yes
N) No
1
N
ShipTypeShipping TypeInt
6
StatusStatusVarChar
R) Released
Y) Picked
P) Partially Picked
D) Partially Delivered
C) Closed
1
R
PrintedPrintedVarChar
Y) Copy
N) Original
1
N
LogInstacLog Instance - HistoryInt
11
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
156
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
UseBaseUnInventory UoMVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OPKL.AbsEntry AS 'Absolute entry', OPKL.Name AS 'Name', OPKL.OwnerCode AS 'Owner Code', OPKL.OwnerName AS 'Owner Name', OPKL.PickDate AS 'Pick Date', OPKL.Remarks AS 'Remarks', OPKL.Canceled AS 'Canceled', OPKL.ShipType AS 'Shipping Type', OPKL.Status AS 'Status', OPKL.Printed AS 'Printed', OPKL.LogInstac AS 'Log Instance - History', OPKL.ObjType AS 'Object Type', OPKL.UpdateDate AS 'Date of Update', OPKL.CreateDate AS 'Creation Date', OPKL.UserSign AS 'User Signature', OPKL.UserSign2 AS 'Updating User', OPKL.UseBaseUn AS 'Inventory UoM' FROM OPKL AS OPKL

Related information


Pick Lists PickLists Object· Table: OPKL
The PickLists object supports the picking process of items from the warehouse. The picking process is applicable only for items that are already approved in sales orders. Source table: OPKL.

OPKL SQL Table

Object Settings - History ADP1 SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates