biuan SAP® BUSINESS ONE SDK
API UWOR3
UWOR3 - 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 UWOR3.DocEntry AS 'Document Internal Number', UWOR3.LineNum AS 'Row Number', UWOR3.LayerID AS 'Layer ID', UWOR3.Quantity AS 'Quantity', UWOR3.RToStock AS 'Reval. Amount Posted to Stock', UWOR3.RToStockSc AS 'Reval. Amt Posted to Stock SC', UWOR3.WhsCode AS 'Warehouse Code', UWOR3.IVLTransSe AS 'IVL Transaction Sequence No.', UWOR3.IVLLayerID AS 'IVL Layer ID', UWOR3.SnbSysNum AS 'SNB System Number', UWOR3.SnbAbsEnt AS 'SNB Abs. Entry', UWOR3.LogInstanc AS 'Log Instance' FROM UWOR3 AS UWOR3

Related information




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