biuan SAP® BUSINESS ONE SDK
API OWKO / Work Orders
OWKO - Production Instructions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OrderNum KEY UNIQUEInstruction KeyInt
11
0PRIMARYYes
StatusProcessing StatusVarChar
O) Work Instructions
I) Work Instructions
E) Production Completed
1
O
CanceledOrder Canceled Yes/NoVarChar
Y) Canceled
N) Not Canceled
1
N
OrderDateOrder DateDate
8
ProdctDateWork Start DateDate
8
ExpFinishDExpected Completion DateDate
8
FinishDateWork Finish DateDate
8
FinishUserName of Person Receiving InstructionsnVarChar
8OUSR
Users
CardCodeSold-to Party CodenVarChar
15OCRD
Business Partner
CustomNameSold-to Party NamenVarChar
100
NumInCustmCustomer Ref. No.nVarChar
16
TotalOrderOrder TotalNum
20
TotalCurrTotal CurrencynVarChar
3
DocTimeGeneration TimeInt
6
MemoRemarksnVarChar
127
SerialNum KEY UNIQUEInstruction NumberInt
11
SERIALYes
CntctCodeContact PersonInt
11OCPR
Contact Persons
0
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
TransferedPostponed to Next YearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
Series KEYSeriesInt
6NNM1
Documents Numbering - Series
SERIESNo
ActWorkCodActive Account CodenVarChar
15OACT
G/L Accounts
ActWorkSumWork TotalNum
20
JrnlMemoJournal RemarksnVarChar
50
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
68
UserSignUser SignatureInt
6OUSR
Users
PriceListPrice ListInt
6OPLN
Price Lists
1
FinncPriodPosting PeriodInt
11OFPR
Posting Period
SysRateSystem RateNum
20

Table relationship map

SELECT statement

SELECT OWKO.OrderNum AS 'Instruction Key', OWKO.Status AS 'Processing Status', OWKO.Canceled AS 'Order Canceled Yes/No', OWKO.OrderDate AS 'Order Date', OWKO.ProdctDate AS 'Work Start Date', OWKO.ExpFinishD AS 'Expected Completion Date', OWKO.FinishDate AS 'Work Finish Date', OWKO.FinishUser AS 'Name of Person Receiving Instructions', OWKO.CardCode AS 'Sold-to Party Code', OWKO.CustomName AS 'Sold-to Party Name', OWKO.NumInCustm AS 'Customer Ref. No.', OWKO.TotalOrder AS 'Order Total', OWKO.TotalCurr AS 'Total Currency', OWKO.DocTime AS 'Generation Time', OWKO.Memo AS 'Remarks', OWKO.SerialNum AS 'Instruction Number', OWKO.CntctCode AS 'Contact Person', OWKO.UpdateDate AS 'Date of Update', OWKO.CreateDate AS 'Creation Date', OWKO.Transfered AS 'Postponed to Next Year', OWKO.Instance AS 'Instance', OWKO.Series AS 'Series', OWKO.ActWorkCod AS 'Active Account Code', OWKO.ActWorkSum AS 'Work Total', OWKO.JrnlMemo AS 'Journal Remarks', OWKO.DataSource AS 'Data Source', OWKO.ObjType AS 'Object Type', OWKO.UserSign AS 'User Signature', OWKO.PriceList AS 'Price List', OWKO.FinncPriod AS 'Posting Period', OWKO.SysRate AS 'System Rate' FROM OWKO AS OWKO

Related information


Work Orders WorkOrders Object· Table: OWKO
WorkOrders is a business object that represents the work orders in the Inventory and Production module. This object is applicable only if work orders are already exist in the Company database. From release 2005, this object is replaced by the...

OWKO SQL Table

G/L Accounts OACT SQL Table

Business Partner OCRD SQL Table

Contact Persons OCPR SQL Table

Users OUSR SQL Table

Posting Period OFPR SQL Table

Object Settings - History ADP1 SQL Table

Price Lists OPLN SQL Table

Documents Numbering - Series NNM1 SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates