|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Production Instructions
Table Name: OWKO
Table Description: Production Instructions
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| OrderNum | Instruction Key | Int | 11 | - | 0 | Â | Â |
| Status | Processing Status | VarChar | 1 | - | O | O | Work Instructions |
| Â | Â | Â | Â | Â | Â | I | Work Instructions |
| Â | Â | Â | Â | Â | Â | E | Production Completed |
| Canceled | Order Canceled Yes/No | VarChar | 1 | - | N | Y | Canceled |
| Â | Â | Â | Â | Â | Â | N | Not Canceled |
| OrderDate | Order Date | Date | 8 | - | Â | Â | Â |
| ProdctDate | Work Start Date | Date | 8 | - | Â | Â | Â |
| ExpFinishD | Expected Completion Date | Date | 8 | - | Â | Â | Â |
| FinishDate | Work Finish Date | Date | 8 | - | Â | Â | Â |
| FinishUser | Name of Person Receiving Instructions | nVarChar | 8 | OUSR | Â | Â | Â |
| CardCode | Sold-to Party Code | nVarChar | 15 | OCRD | Â | Â | Â |
| CustomName | Sold-to Party Name | nVarChar | 200 | - | Â | Â | Â |
| NumInCustm | Customer Ref. No. | nVarChar | 16 | - | Â | Â | Â |
| TotalOrder | Order Total | Num | 19.6 | - | Â | Â | Â |
| TotalCurr | Total Currency | nVarChar | 3 | - | Â | Â | Â |
| DocTime | Generation Time | Int | 6 | - | Â | Â | Â |
| Memo | Remarks | nVarChar | 254 | - | Â | Â | Â |
| SerialNum | Instruction Number | Int | 11 | - | Â | Â | Â |
| CntctCode | Contact Person | Int | 11 | OCPR | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| Transfered | Postponed to Next Year | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Instance | Instance | Int | 6 | - | 0 | Â | Â |
| Series | Series | Int | 11 | NNM1 | Â | Â | Â |
| ActWorkCod | Active Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| ActWorkSum | Work Total | Num | 19.6 | - | Â | Â | Â |
| JrnlMemo | Journal Remarks | nVarChar | 254 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 68 | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| PriceList | Price List | Int | 6 | OPLN | 1 | Â | Â |
| FinncPriod | Posting Period | Int | 11 | OFPR | Â | Â | Â |
| SysRate | System Rate | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | OrderNum |
| SERIAL | Yes | SerialNum |
| Â | Â | Instance |
| SERIES | No | Series |