SAP Business One SDK 10.0 - Database Tables Reference
-
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 |
| Key |
Unique |
Field |
| PRIMARY |
Yes |
AbsEntry |