biuan SAP® BUSINESS ONE SDK
API SAL1
SAL1 - Salida - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument EntryInt
11OINV
A/R Invoice
PRIMARYYes
LineNumRow NumberInt
11
BaseEntryBase Document Internal IDInt
11
PackQtyPacking QuantityNum
20
PurPackMsrPackaging UoM NamenVarChar
8
Pack
ArsnalNameStorage Group NamenVarChar
20
ArsnalCodeStorage Group CodenVarChar
20
UnitMsrRef. UoM (Type)nVarChar
5
Unit
QuantityQuantityNum
20
FractionRemainderNum
20
Weight1WeightNum
20
LineTotalRow TotalNum
20
ItemCodeItem No.nVarChar
20OITM
Items

Table relationship map

SELECT statement

SELECT SAL1.DocEntry AS 'Document Entry', SAL1.LineNum AS 'Row Number', SAL1.BaseEntry AS 'Base Document Internal ID', SAL1.PackQty AS 'Packing Quantity', SAL1.PurPackMsr AS 'Packaging UoM Name', SAL1.ArsnalName AS 'Storage Group Name', SAL1.ArsnalCode AS 'Storage Group Code', SAL1.UnitMsr AS 'Ref. UoM (Type)', SAL1.Quantity AS 'Quantity', SAL1.Fraction AS 'Remainder', SAL1.Weight1 AS 'Weight', SAL1.LineTotal AS 'Row Total', SAL1.ItemCode AS 'Item No.' FROM SAL1 AS SAL1

Related information


A/R Invoice OINV SQL Table

Items OITM 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