biuan SAP® BUSINESS ONE SDK
SQL Administration / Currency Codes
DTW Administration / Setup / Financials / Currencies
API OCRN / Currencies
OCRN - Currency Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CurrCode KEY UNIQUECurrency CodenVarChar
3
PRIMARYYes
CurrName KEYCurrencynVarChar
20
CUR_NAMENo
ChkNameName on Printed ChecksnVarChar
20
Chk100NameName of 100's on checksnVarChar
20
DocCurrCodName on Printed Docs.nVarChar
3
FrgnNameEnglishnVarChar
20
F100NameEnglish Hundredth NamenVarChar
20
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
RoundSysRoundingInt
0
4) Round to Five Hundredth
1) Round to Ten Hundredth
2) Round to One
3) Round to Ten
6
0
UserSign2Updating UserInt
6OUSR
Users
DecimalsDecimalsInt
-1) Default
0
1) 1 Digit
2) 2 Digits
3) 3 Digits
4) 4 Digits
5) 5 Digits
6) 6 Digits
6
-1
ISRCalcISR CalculationVarChar
Y) Yes
N) No
1
N
RoundPymRounding in PmntVarChar
Y) Yes
N) No
1
N
ConvUnitIs a Conventional UnitVarChar
Y) Yes
N) No
1
N
BaseCurrBase Currency for Conv. UnitnVarChar
3OCRN
Currency Codes
FactorFactorNum
20
ChkNamePlPlural for Int.DescriptionnVarChar
20
Chk100NPlPlural for Hundredth NamenVarChar
20
FrgnNamePlPlural for EnglishnVarChar
20
F100NamePlPlural for Eng. Hundredth NamenVarChar
20
ISOCurrCodISO Currency CodenVarChar
3
MaxInDiffIncoming Amt Diff. AllowedNum
20
MaxOutDiffOutgoing Amt Diff. AllowedNum
20
MaxInPcntIncoming % Diff. AllowedNum
20
MaxOutPcntOutgoing % Diff. AllowedNum
20
ISOCurrNumISO Currency NumbernVarChar
3

Table relationship map

SELECT statement

SELECT OCRN.CurrCode AS 'Currency Code', OCRN.CurrName AS 'Currency', OCRN.ChkName AS 'Name on Printed Checks', OCRN.Chk100Name AS 'Name of 100's on checks', OCRN.DocCurrCod AS 'Name on Printed Docs.', OCRN.FrgnName AS 'English', OCRN.F100Name AS 'English Hundredth Name', OCRN.Locked AS 'Locked', OCRN.DataSource AS 'Data Source', OCRN.UserSign AS 'User Signature', OCRN.RoundSys AS 'Rounding', OCRN.UserSign2 AS 'Updating User', OCRN.Decimals AS 'Decimals', OCRN.ISRCalc AS 'ISR Calculation', OCRN.RoundPym AS 'Rounding in Pmnt', OCRN.ConvUnit AS 'Is a Conventional Unit', OCRN.BaseCurr AS 'Base Currency for Conv. Unit', OCRN.Factor AS 'Factor', OCRN.ChkNamePl AS 'Plural for Int.Description', OCRN.Chk100NPl AS 'Plural for Hundredth Name', OCRN.FrgnNamePl AS 'Plural for English', OCRN.F100NamePl AS 'Plural for Eng. Hundredth Name', OCRN.ISOCurrCod AS 'ISO Currency Code', OCRN.MaxInDiff AS 'Incoming Amt Diff. Allowed', OCRN.MaxOutDiff AS 'Outgoing Amt Diff. Allowed', OCRN.MaxInPcnt AS 'Incoming % Diff. Allowed', OCRN.MaxOutPcnt AS 'Outgoing % Diff. Allowed', OCRN.ISOCurrNum AS 'ISO Currency Number' FROM OCRN AS OCRN

Related information


Currencies Currencies Object· Table: OCRN
Currencies is a business object that represents the currency codes in the Administration module. This object enables you to: Add a currency code. Retrieve a currency code by its key. Update a currency code. Remove a currency code....

Currency Codes OCRN 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