PickListLines

 

PickListLines

 

Property

Description

Table

PKL1

Primary key

AbsoluteEntry/i,LineNumber/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: PickList -> AbsoluteEntry

Database: "PKL1"."AbsEntry"

BaseObjectType

Edm.String(20)

returns the type of object on which the pick lists entry is based.

Constraints:

Order=17

Reserve Invoice=13

Production Order (SAP)=202

Inventory Transfer Request=1250000001

Database: "PKL1"."BaseObject"

LineNumber

Edm.Int32

Database: "PKL1"."PickEntry"

OrderEntry

Edm.Int32

Database: "PKL1"."OrderEntry"

OrderRowID

Edm.Int32

Database: "PKL1"."OrderLine"

PickedQuantity

Edm.Decimal

Database: "PKL1"."PickQtty"

PickStatus

Edm.String(1)

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 for Picking=R

Picked=Y

Partially Picked=P

Partially Delivered=D

Closed=D

Database: "PKL1"."PickStatus"

PreviouslyReleasedQuantity

Edm.Decimal

Database: "PKL1"."PrevReleas"

ReleaseQuantity

Edm.Decimal

returns the quantity of the items that were released.

Database: "PKL1"."RelQtty"

 

Relations

Join to Entiy Object

Relation

PickList

AbsoluteEntry

SalesOrder

DocEntry=OrderEntry

SalesOrderLines

DocEntry=OrderEntry,LineNum=OrderRowID