biuan SAP® BUSINESS ONE SDK
SQL Finance / G/L Accounts / Journal Entry Codes
DTW Financials / Chart of Accounts / Journal Entry Codes
API Chart Of Accounts / Transaction Code
OTRC - Journal Entry Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TrnsCode KEY UNIQUECodenVarChar
4
PRIMARYYes
TrnsCodDsc KEYDescriptionnVarChar
20
DESCRIPNo
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
Pcn874CtgTrans. Category for PCN874VarChar
N) None
I) Import Log
E) Export Log
O) Other
R) A/R Invoice - Palestinian Territory
P) A/P Invoice - Palestinian Territory
M) Self-Employed - Sales
C) Self-Employed - Purchase
1
N

Table relationship map

SELECT statement

SELECT OTRC.TrnsCode AS 'Code', OTRC.TrnsCodDsc AS 'Description', OTRC.Locked AS 'Locked', OTRC.DataSource AS 'Data Source', OTRC.UserSign AS 'User Signature', OTRC.Pcn874Ctg AS 'Trans. Category for PCN874' FROM OTRC AS OTRC

Related information


Transaction Code TransactionCode Property· Table: OTRC
Sets or returns this ChartOfAccount transaction code.Field name: TransCode.Length: 4 characters.This is a foreign key to the OTRC object.
· Table: OACT    Parent: Chart Of Accounts ChartOfAccounts Object· Table: OACT
OTRC 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