biuan SAP® BUSINESS ONE SDK
API OSLD
OSLD - Schedule Row Detail Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ObjType KEYObject TypenVarChar
-1)
13) A/R Reserve Invoice
17) Sales Order
18) A/P Reserve Invoice
22) Purchase Order
163) A/P Correction Reserve Invoice
165) A/R Correction Reserve Invoice
202) Production Order
1250000001) Warehouse Transfer Request
20
-1DOCLINESLDNo
DocEntryAssociated Doc EntryInt
11
DocLineNumAssociated Doc Row No.Int
11
SchdLineSchedule Row No.Int
11
ItemCodeItem CodenVarChar
20OITM
Items
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
CfmDateConfirmation DateDate
8
CfmQtyConfirmation QuantityNum
20
FixedCfmFixed Confirmation DataVarChar
Y) Yes
N) No
1
N
ReqQtyRequired QuantityNum
20

Table relationship map

SELECT statement

SELECT OSLD.AbsEntry AS 'Internal Number', OSLD.ObjType AS 'Object Type', OSLD.DocEntry AS 'Associated Doc Entry', OSLD.DocLineNum AS 'Associated Doc Row No.', OSLD.SchdLine AS 'Schedule Row No.', OSLD.ItemCode AS 'Item Code', OSLD.WhsCode AS 'Warehouse Code', OSLD.CfmDate AS 'Confirmation Date', OSLD.CfmQty AS 'Confirmation Quantity', OSLD.FixedCfm AS 'Fixed Confirmation Data', OSLD.ReqQty AS 'Required Quantity' FROM OSLD AS OSLD

Related information


Items OITM SQL Table

Warehouses OWHS 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