biuan SAP® BUSINESS ONE SDK
API RPD9
RPD9 - Goods Return - Drawn Dpm Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ORPD
Goods Return
PRIMARYYes
LineNumRow NumberInt
11
BaseAbsBase Document Internal IDInt
11
BaseLineBase Document RowInt
11
TargetBaseTarget or Base DocumentVarChar
B) Base
T) Target
1
B
ObjTypeBase Object TypenVarChar
20
DrawnSumNet LCNum
20
DrawnSumFcNet FCNum
20
DrawnSumScNet SCNum
20
LogInstancLog InstanceInt
11
0
ObjCodeObject TypenVarChar
20ADP1
Object Settings - History
21
ApplDrawnApplied Net LCNum
20
ApplDrawnFApplied Net FCNum
20
ApplDrawnSApplied Net SCNum
20
BaseDocNumBase Document NumberInt
11
BsDocDateBase Posting DateDate
8
BsDueDateBase Due DateDate
8
BsCardNameBase BP NamenVarChar
100
BsCommentsBase RemarksnVarChar
127
PostedBase Document PostedVarChar
Y) Yes
N) No
1
Y
VatTax LCNum
20
VatFcTax FCNum
20
VatScTax SCNum
20
GrossGross LCNum
20
GrossFcGross FCNum
20
GrossScGross SCNum
20
IsGrossIs Gross LineVarChar
N) Net Line
Y) Gross Line
1
N

Table relationship map

SELECT statement

SELECT RPD9.DocEntry AS 'Document Internal ID', RPD9.LineNum AS 'Row Number', RPD9.BaseAbs AS 'Base Document Internal ID', RPD9.BaseLine AS 'Base Document Row', RPD9.TargetBase AS 'Target or Base Document', RPD9.ObjType AS 'Base Object Type', RPD9.DrawnSum AS 'Net LC', RPD9.DrawnSumFc AS 'Net FC', RPD9.DrawnSumSc AS 'Net SC', RPD9.LogInstanc AS 'Log Instance', RPD9.ObjCode AS 'Object Type', RPD9.ApplDrawn AS 'Applied Net LC', RPD9.ApplDrawnF AS 'Applied Net FC', RPD9.ApplDrawnS AS 'Applied Net SC', RPD9.BaseDocNum AS 'Base Document Number', RPD9.BsDocDate AS 'Base Posting Date', RPD9.BsDueDate AS 'Base Due Date', RPD9.BsCardName AS 'Base BP Name', RPD9.BsComments AS 'Base Remarks', RPD9.Posted AS 'Base Document Posted', RPD9.Vat AS 'Tax LC', RPD9.VatFc AS 'Tax FC', RPD9.VatSc AS 'Tax SC', RPD9.Gross AS 'Gross LC', RPD9.GrossFc AS 'Gross FC', RPD9.GrossSc AS 'Gross SC', RPD9.IsGross AS 'Is Gross Line' FROM RPD9 AS RPD9

Related information


Goods Return ORPD SQL Table

Object Settings - History ADP1 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