biuan SAP® BUSINESS ONE SDK
SQL Finance / Rate Differences
API ORTM
ORTM - Rate Differences Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LineNum KEY UNIQUEReconciliation KeyInt
11
PRIMARYYes
RtmdatePosting DateDate
8
AcctCodeG/L Account/BP CodenVarChar
15
IsCardCardVarChar
Y) Yes
N) No
1
N
ActCurrncyDocument Valuation CurrencynVarChar
3
ActRateDocument Revaluation RateNum
20
BalanceBalanceNum
20
FrnBlncFC BalanceNum
20
TransNumTransaction NumberInt
11
0
ValidConfirmedVarChar
Y) Yes
N) No
1
N
DeltaDifference in LCNum
20
IsSysCurr KEYIn System CurrencyVarChar
Y) Yes
N) No
1
NSYS_CURRNo
StornoDateReversal DateDate
8
RevalRateRevaluation RateNum
20
UserSignUser SignatureInt
6OUSR
Users
BPLIdBranchInt
11OBPL
Business Place
CntBlncConverted BalanceNum
20
TransAmtSCTransaction Amount TotalNum
20
BalDueSCBalance Due TotalNum
20
SCAdjustSC AdjustmentVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ORTM.LineNum AS 'Reconciliation Key', ORTM.Rtmdate AS 'Posting Date', ORTM.AcctCode AS 'G/L Account/BP Code', ORTM.IsCard AS 'Card', ORTM.ActCurrncy AS 'Document Valuation Currency', ORTM.ActRate AS 'Document Revaluation Rate', ORTM.Balance AS 'Balance', ORTM.FrnBlnc AS 'FC Balance', ORTM.TransNum AS 'Transaction Number', ORTM.Valid AS 'Confirmed', ORTM.Delta AS 'Difference in LC', ORTM.IsSysCurr AS 'In System Currency', ORTM.StornoDate AS 'Reversal Date', ORTM.RevalRate AS 'Revaluation Rate', ORTM.UserSign AS 'User Signature', ORTM.BPLId AS 'Branch', ORTM.CntBlnc AS 'Converted Balance', ORTM.TransAmtSC AS 'Transaction Amount Total', ORTM.BalDueSC AS 'Balance Due Total', ORTM.SCAdjust AS 'SC Adjustment' FROM ORTM AS ORTM

Related information


Business Place OBPL SQL Table

Users OUSR 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