UWKO1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Inventory and Production / Production Instructions - Rows

API UWKO1

UWKO1 - Production Instructions - Rows Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
OrderNum ^KEY ^UNIQUE	Instruction Key	Int	11	OWKO Production Instructions		PRIMARY	Yes
LineID	Row Number	Int	11		0
ItemCode	Item No.	nVarChar	20	OITT Product Tree
Descript	Item Description	nVarChar	100
Quantity	Item Quantity	Num	20
Price	Item Price	Num	20
Currency ^KEY	Price Currency	nVarChar	3	OCRN Currency Codes		CURRENCY	No
WhsCode	Item Warehouse	nVarChar	8	OWHS Warehouses
FinncPriod	Posting Period	Int	11	OFPR Posting Period
ActWorkCod	Active Account Code	nVarChar	15	OACT G/L Accounts
ActWorkSum	Total Work	Num	20
ProdUpgNum	Production Upgrade No.	Int	11	OWOR Production Order

Table relationship map

SELECT statement

SELECT
   UWKO1.OrderNum AS 'Instruction Key', 
   UWKO1.LineID AS 'Row Number', 
   UWKO1.ItemCode AS 'Item No.', 
   UWKO1.Descript AS 'Item Description', 
   UWKO1.Quantity AS 'Item Quantity', 
   UWKO1.Price AS 'Item Price', 
   UWKO1.Currency AS 'Price Currency', 
   UWKO1.WhsCode AS 'Item Warehouse', 
   UWKO1.FinncPriod AS 'Posting Period', 
   UWKO1.ActWorkCod AS 'Active Account Code', 
   UWKO1.ActWorkSum AS 'Total Work', 
   UWKO1.ProdUpgNum AS 'Production Upgrade No.'
FROM UWKO1 AS UWKO1

Related information

OACT SQL Table

OCRN SQL Table

OFPR SQL Table

OITT SQL Table

OWKO SQL Table

OWOR SQL Table

OWHS SQL Table

biuan SAP® BUSINESS ONE

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