biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Production Order / Production Order - Rows
DTW Production Order - Rows
API Production Orders / Production Orders Lines
WOR1 - Production Order - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal NumberInt
11OWOR
Production Order		PRIMARYYes
LineNumRow NumberInt
11
ItemCode KEYItem No.nVarChar
20
ITEM_WHSNo
BaseQtyBase QuantityNum
20
PlannedQtyPlanned Quantity - RowsNum
20
IssuedQtyIssued QuantityNum
20
IssueTypeProduction Order Issue TypeVarChar
M) Manual
B) Backflush
1
wareHouseWarehousenVarChar
8OWHS
Warehouses
VisOrderVisual OrderInt
11
WipActCodeWIP Account CodenVarChar
15OACT
G/L Accounts
CompTotalTotal Completed SumNum
20
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
LocCodeLocation CodeInt
11OLCT
Location
LogInstancLog InstanceInt
11
0
LoadFrBOMChild qty was loaded from BOMInt
0
1) Planned qty calculated from BOM
2) Planned qty calculated from recalculated baseQty value
6
0
ProjectProject CodenVarChar
20OPRJ
Project Codes
UomEntryUoM EntryInt
11OUOM
UoM Master Data		0
UomCodeUoM CodenVarChar
20
ItemTypeItem TypeInt
4) Item
290) Resource
-18) Text
11
4
AdditQtyAdditional QuantityNum
20
LineTextRow TextText
16
PickStatusPick StatusVarChar
Y) Picked
N) Not Picked
R) Release for Picking
P) Partially Picked
1
N
PickQtyPick QuantityNum
20
PickIdNoPick List ID NumberInt
11
ReleaseQtyReleased QuantityNum
20
ResAllocResource AllocationVarChar
D) On Due Date
B) Automatic
1

Table relationship map

SELECT statement

SELECT WOR1.DocEntry AS 'Document Internal Number', WOR1.LineNum AS 'Row Number', WOR1.ItemCode AS 'Item No.', WOR1.BaseQty AS 'Base Quantity', WOR1.PlannedQty AS 'Planned Quantity - Rows', WOR1.IssuedQty AS 'Issued Quantity', WOR1.IssueType AS 'Production Order Issue Type', WOR1.wareHouse AS 'Warehouse', WOR1.VisOrder AS 'Visual Order', WOR1.WipActCode AS 'WIP Account Code', WOR1.CompTotal AS 'Total Completed Sum', WOR1.OcrCode AS 'Distribution Rule', WOR1.OcrCode2 AS 'Distribution Rule2', WOR1.OcrCode3 AS 'Distribution Rule3', WOR1.OcrCode4 AS 'Distribution Rule4', WOR1.OcrCode5 AS 'Distribution Rule5', WOR1.LocCode AS 'Location Code', WOR1.LogInstanc AS 'Log Instance', WOR1.LoadFrBOM AS 'Child qty was loaded from BOM', WOR1.Project AS 'Project Code', WOR1.UomEntry AS 'UoM Entry', WOR1.UomCode AS 'UoM Code', WOR1.ItemType AS 'Item Type', WOR1.AdditQty AS 'Additional Quantity', WOR1.LineText AS 'Row Text', WOR1.PickStatus AS 'Pick Status', WOR1.PickQty AS 'Pick Quantity', WOR1.PickIdNo AS 'Pick List ID Number', WOR1.ReleaseQty AS 'Released Quantity', WOR1.ResAlloc AS 'Resource Allocation' FROM WOR1 AS WOR1

Related information


Production Orders Lines ProductionOrders_Lines Object· Table: WOR1
The ProductionOrders_Lines is a child object of the ProductionOrders object. Each line represents a component (item) of the product. Source table: WOR1.
   Parent: Production Orders ProductionOrders Object· Table: OWOR
Production Order OWOR SQL Table

Location OLCT SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

UoM Master Data OUOM SQL Table

Warehouses OWHS SQL Table

G/L Accounts OACT SQL Table
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