SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: WKO1
Table Description: Production Instructions - Rows
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| OrderNum |
Instruction Key |
Int |
11 |
OWKO |
|
|
|
| LineID |
Row Number |
Int |
11 |
- |
0 |
|
|
| ItemCode |
Item No. |
nVarChar |
50 |
OITT |
|
|
|
| Descript |
Item Description |
nVarChar |
200 |
- |
|
|
|
| Quantity |
Item Quantity |
Num |
19.6 |
- |
|
|
|
| Price |
Item Price |
Num |
19.6 |
- |
|
|
|
| Currency |
Price Currency |
nVarChar |
3 |
OCRN |
|
|
|
| WhsCode |
Item Warehouse |
nVarChar |
8 |
OWHS |
|
|
|
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| ActWorkCod |
Active Account Code |
nVarChar |
15 |
OACT |
|
|
|
| ActWorkSum |
Total Work |
Num |
19.6 |
- |
|
|
|
| ProdUpgNum |
Production Upgrade No. |
Int |
11 |
OWOR |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
OrderNum |
| |
|
LineID |
| CURRENCY |
No |
Currency |