biuan SAP® BUSINESS ONE SDK
API APKL
APKL - Pick List - History 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 APKL.AbsEntry AS 'Absolute entry', APKL.Name AS 'Name', APKL.OwnerCode AS 'Owner Code', APKL.OwnerName AS 'Owner Name', APKL.PickDate AS 'Pick Date', APKL.Remarks AS 'Remarks', APKL.Canceled AS 'Canceled', APKL.ShipType AS 'Shipping Type', APKL.Status AS 'Status', APKL.Printed AS 'Printed', APKL.LogInstac AS 'Log Instance - History', APKL.ObjType AS 'Object Type', APKL.UpdateDate AS 'Date of Update', APKL.CreateDate AS 'Creation Date', APKL.UserSign AS 'User Signature', APKL.UserSign2 AS 'Updating User', APKL.UseBaseUn AS 'Inventory UoM' FROM APKL AS APKL

Related information


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