PickList

 

PickList

 

Property

Description

Table

OPKL

Primary key

AbsoluteEntry/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

AbsoluteEntry

Edm.Int32

Returns the identification key of the pick list row as assinged by SAP Business One when adding a new enrty.

Entity Relation: PickListLines -> AbsoluteEntry

Database: "OPKL"."AbsEntry"

Name

Edm.String(20)

Sets or returns the name of the employee who is responsible for the picking (picker).

Database: "OPKL"."Name"

OwnerName

Edm.String(20)

Database: "OPKL"."OwnerName"

OwnerCode

Edm.Int32

Sets or returns the code of the user who prepares the pick list. This is a foreign key to the Users object (see InternalKey).

This is a foreign key to the Users object.

 

Database: "OPKL"."OwnerCode"

PickDate

Edm.DateTimeOffset

Database: "OPKL"."PickDate"

Remarks

Edm.String(16000)

Database: "OPKL"."Remarks"

Status

Edm.String(1)

Returns a valid value that specifies the status of the pick list. For example: released for picking, already picked, and so on

0=The pick list is released for picking.

1=All the items have been picked.

2=Only part of the items, specified in the pick list, have been picked.

3=Part of the items have been delivered. The lines for the delivered items cannot be updated.

4=The pick list is closed. No additional items can be picked or delivered

 

Constraints:

Released=R

Picked=Y

Partially Delivered=P

Partially Delivered=D

Closed=C

Database: "OPKL"."Status"

 

Relations

Join to Entiy Object

Relation

PickListLines

AbsoluteEntry