📚 SAP Business One SDK Help

Table Name: OPKL

Table Description: Pick List

Field Description Type Size Related Default Value Constraints
AbsEntry Absolute entry Int 11 -      
Name Name nVarChar 155 -      
OwnerCode Owner Code Int 6 OUSR      
OwnerName Owner Name nVarChar 155 -      
PickDate Pick Date Date 8 -      
Remarks Remarks Text 16 -      
Canceled Canceled VarChar 1 - N Y Yes
            N No
ShipType Shipping Type Int 6 -      
Status Status VarChar 1 - R R Released
            Y Picked
            P Partially Picked
            D Partially Delivered
            C Closed
Printed Printed VarChar 1 - N Y Copy
            N Original
               
LogInstac Log Instance - History Int 11 -      
ObjType Object Type nVarChar 20 ADP1 156    
UpdateDate Date of Update Date 8 -      
CreateDate Creation Date Date 8 -      
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
UseBaseUn Inventory UoM VarChar 1 - N Y Yes
            N No
QRCodeSrc QR Code Source Text 16 -      
QRCodeSPGn QR Code Source Generated from Stored Procedure Text 16 -      
CreateTS Create Time Incl. Secs. Int 11 -      
UpdateTS Update Full Time Int 11 -      
DocSubType Document Subtype nVarChar 2 - -- -- Pick List
Key Unique Field
PRIMARY Yes AbsEntry