biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Production Order - Closure
API WOR3
WOR3 - Production Order - Closure Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal NumberInt
11
PRIMARYYes
LineNumRow NumberInt
11
LayerIDLayer IDInt
11
QuantityQuantityNum
20
RToStockReval. Amount Posted to StockNum
20
RToStockScReval. Amt Posted to Stock SCNum
20
WhsCodeWarehouse CodenVarChar
8
IVLTransSeIVL Transaction Sequence No.Int
11
IVLLayerIDIVL Layer IDInt
11
SnbSysNumSNB System NumberInt
11
SnbAbsEntSNB Abs. EntryInt
11
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT WOR3.DocEntry AS 'Document Internal Number', WOR3.LineNum AS 'Row Number', WOR3.LayerID AS 'Layer ID', WOR3.Quantity AS 'Quantity', WOR3.RToStock AS 'Reval. Amount Posted to Stock', WOR3.RToStockSc AS 'Reval. Amt Posted to Stock SC', WOR3.WhsCode AS 'Warehouse Code', WOR3.IVLTransSe AS 'IVL Transaction Sequence No.', WOR3.IVLLayerID AS 'IVL Layer ID', WOR3.SnbSysNum AS 'SNB System Number', WOR3.SnbAbsEnt AS 'SNB Abs. Entry', WOR3.LogInstanc AS 'Log Instance' FROM WOR3 AS WOR3

Related information
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