RTM2 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Finance / Rate Differences - SC Adjustment Rows

API RTM2

RTM2 - Rate Differences - SC Adjustment Rows Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
LineNum ^KEY ^UNIQUE	Reconciliation Key	Int		11			PRIMARY	Yes
IsSysCurr	IS System Currency	VarChar	Y) Yes N) No	1		N
CardCode ^KEY	BP Code	nVarChar		15	OCRD Business Partner		CARD_CODE	No
AcctCode	BP Control Account	nVarChar		15
TransAmtSC	Total Transaction Amount (SC)	Num		20
BalDueSC	Total 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

OCRD SQL Table

biuan SAP® BUSINESS ONE

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