biuan SAP® BUSINESS ONE SDK
API RTM2
RTM2 - Rate Differences - SC Adjustment Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LineNum KEY UNIQUEReconciliation KeyInt
11
PRIMARYYes
IsSysCurrIS System CurrencyVarChar
Y) Yes
N) No
1
N
CardCode KEYBP CodenVarChar
15OCRD
Business Partner
CARD_CODENo
AcctCodeBP Control AccountnVarChar
15
TransAmtSCTotal Transaction Amount (SC)Num
20
BalDueSCTotal Balance Due (SC)Num
20

SELECT statement

SELECT RTM2.LineNum AS 'Reconciliation Key', RTM2.IsSysCurr AS 'IS System Currency', RTM2.CardCode AS 'BP Code', RTM2.AcctCode AS 'BP Control Account', RTM2.TransAmtSC AS 'Total Transaction Amount (SC)', RTM2.BalDueSC AS 'Total Balance Due (SC)' FROM RTM2 AS RTM2

Related information


Business Partner OCRD SQL Table



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