biuan SAP® BUSINESS ONE SDK
API RTM1
RTM1 - Rate Differences - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LineNum KEY UNIQUEReconciliation KeyInt
11
PRIMARYYes
TransIdJournal KeyInt
11OJDT
Journal Entry
JdtLineJournal RowInt
11
0
IsSysCurr KEYIs System CurrencyVarChar
Y) Yes
N) No
1
NSYS_CURRNo
AcctCodeG/L Account/BP CodenVarChar
15
BalanceBalanceNum
20
FrnBlncBalance (FC)Num
20
ValidConfirmedVarChar
Y) Yes
N) No
1
Y
RevalRateRevaluation RateNum
20
DeltaDifference in LCNum
20
FCCurrencyForeign CurrencynVarChar
3
JdtAcctCodJournal Account CodenVarChar
15
BaseRefBase ReferencenVarChar
11
JdtTypeJournal Entry TypeVarChar
P) Primary
G) Generated
W) Without Primary
U) Undefined Type
1
U
RefDatePosting DateDate
8
DueDateDue DateDate
8
TaxDateDocument DateDate
8
BPLIdBranchInt
11OBPL
Business Place
CntBlncConverted BalanceNum
20

Table relationship map

SELECT statement

SELECT RTM1.LineNum AS 'Reconciliation Key', RTM1.TransId AS 'Journal Key', RTM1.JdtLine AS 'Journal Row', RTM1.IsSysCurr AS 'Is System Currency', RTM1.AcctCode AS 'G/L Account/BP Code', RTM1.Balance AS 'Balance', RTM1.FrnBlnc AS 'Balance (FC)', RTM1.Valid AS 'Confirmed', RTM1.RevalRate AS 'Revaluation Rate', RTM1.Delta AS 'Difference in LC', RTM1.FCCurrency AS 'Foreign Currency', RTM1.JdtAcctCod AS 'Journal Account Code', RTM1.BaseRef AS 'Base Reference', RTM1.JdtType AS 'Journal Entry Type', RTM1.RefDate AS 'Posting Date', RTM1.DueDate AS 'Due Date', RTM1.TaxDate AS 'Document Date', RTM1.BPLId AS 'Branch', RTM1.CntBlnc AS 'Converted Balance' FROM RTM1 AS RTM1

Related information


Business Place OBPL SQL Table

Journal Entry OJDT 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