biuan SAP® BUSINESS ONE SDK
API OBTC
OBTC - Internal Bank Operation Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
0PRIMARYYes
InOpCode KEY UNIQUEInternal Bank Operation Code NamenVarChar
15
CODE_NAMEYes
PstTransPosting TransactionVarChar
1) Bank Transfer
2) Incoming Bill of Exchange
3) Outgoing Bill of Exchange
4) Outgoing Checks
5) Deposit
1
1
BPorActBP or AccountVarChar
C) BP
A) Account
1
C
PstMethodBP Posting MethodVarChar
A) G/L Account from/to Bank Account
C) Business Partner from/to Bank Account
J) Bank Interim Account from/to Bank Account
E) External Reconciliation
I) Ignore
1
C
ActFeeAccount FeenVarChar
15OACT
G/L Accounts
ProjFeeProject FeenVarChar
20OPRJ
Project Codes
PrftCntFeeFee Distribution RulenVarChar
8OOCR
Distribution Rule
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6OUSR
Users
DescriptOperation DescriptionnVarChar
40
PrftCntFe2Fee Distribution Rule2nVarChar
8OOCR
Distribution Rule
PrftCntFe3Fee Distribution Rule3nVarChar
8OOCR
Distribution Rule
PrftCntFe4Fee Distribution Rule4nVarChar
8OOCR
Distribution Rule
PrftCntFe5Fee Distribution Rule5nVarChar
8OOCR
Distribution Rule
UserSign2Updating UserInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OBTC.AbsEntry AS 'Internal Number', OBTC.InOpCode AS 'Internal Bank Operation Code Name', OBTC.PstTrans AS 'Posting Transaction', OBTC.BPorAct AS 'BP or Account', OBTC.PstMethod AS 'BP Posting Method', OBTC.ActFee AS 'Account Fee', OBTC.ProjFee AS 'Project Fee', OBTC.PrftCntFee AS 'Fee Distribution Rule', OBTC.LogInstanc AS 'Log Instance', OBTC.UpdateDate AS 'Date of Update', OBTC.UserSign AS 'User Signature', OBTC.Descript AS 'Operation Description', OBTC.PrftCntFe2 AS 'Fee Distribution Rule2', OBTC.PrftCntFe3 AS 'Fee Distribution Rule3', OBTC.PrftCntFe4 AS 'Fee Distribution Rule4', OBTC.PrftCntFe5 AS 'Fee Distribution Rule5', OBTC.UserSign2 AS 'Updating User' FROM OBTC AS OBTC

Related information


OBTC SQL Table

G/L Accounts OACT SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates