biuan SAP® BUSINESS ONE SDK
SQL Banking / Internal Reconciliation
API OITR
OITR - Internal Reconciliation Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ReconNum KEY UNIQUEReconciliation NumberInt
11
PRIMARYYes
IsCardBP or AccountVarChar
C) BP
A) G/L Account
1
ReconTypeReconciliation TypenVarChar
0
1) Automatic
2) Semi-Automatic
3) Payment
4) Credit Memo
5) Reversal
6) Zero Value
7) Cancellation
8) BoE
9) Deposit
10) Bank Statement Processing
11) Period Closing
12) Correction Invoice
13) Inventory/Expense Allocation
14) WIP
15) Deferred Tax Interim Account
16) Down Payment Allocation
17) Auto. Conversion Difference
18) Interim Document
2
ReconDateReconciliation DateDate
8
TotalTotal Reconciliation AmountNum
20
ReconCurrReconciliation CurrencynVarChar
3OCRN
Currency Codes
CanceledCanceledVarChar
Y) Yes
N) No
1
N
CancelAbsCanceling/-ed ReconciliationInt
11OITR
Internal Reconciliation		0
IsSystemSystem or ManualVarChar
Y) Yes
N) No
1
InitObjTypReconc. Initiator Object TypenVarChar
20
InitObjAbsReconc. Initiator Internal IDInt
11
CreateDateCreation DateDate
8
CreateTimeCreation TimeInt
6
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) OB Server
A) Auto Incr.
D) Data Doc.
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
ReconRule1Reconciliation Rule 1nVarChar
0
1) Due Date
2) Document Date
3) Ref. 1
4) Ref. 2
5) Ref. 3
6) Project Code
7) Control Account Code
8) Posting Period
2
ReconRule2Reconciliation Rule 2nVarChar
0
1) Due Date
2) Document Date
3) Ref. 1
4) Ref. 2
5) Ref. 3
6) Project Code
7) Control Account Code
8) Posting Period
2
ReconRule3Reconciliation Rule 3nVarChar
0
1) Due Date
2) Document Date
3) Ref. 1
4) Ref. 2
5) Ref. 3
6) Project Code
7) Control Account Code
8) Posting Period
2
IsMultiBPMultiple BP ReconciliationVarChar
N) No
Y) Yes
1
N
VersionNumVersion NumbernVarChar
11
OldMatNumPrevious Reconciliation NumberInt
11
0
ReconJEIdJE no. created by reconciliatnInt
11
BuildDescBuild DescriptornVarChar
50
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VATRegNumVAT Reg. NumbernVarChar
32

Table relationship map

SELECT statement

SELECT OITR.ReconNum AS 'Reconciliation Number', OITR.IsCard AS 'BP or Account', OITR.ReconType AS 'Reconciliation Type', OITR.ReconDate AS 'Reconciliation Date', OITR.Total AS 'Total Reconciliation Amount', OITR.ReconCurr AS 'Reconciliation Currency', OITR.Canceled AS 'Canceled', OITR.CancelAbs AS 'Canceling/-ed Reconciliation', OITR.IsSystem AS 'System or Manual', OITR.InitObjTyp AS 'Reconc. Initiator Object Type', OITR.InitObjAbs AS 'Reconc. Initiator Internal ID', OITR.CreateDate AS 'Creation Date', OITR.CreateTime AS 'Creation Time', OITR.DataSource AS 'Data Source', OITR.UserSign AS 'User Signature', OITR.ReconRule1 AS 'Reconciliation Rule 1', OITR.ReconRule2 AS 'Reconciliation Rule 2', OITR.ReconRule3 AS 'Reconciliation Rule 3', OITR.IsMultiBP AS 'Multiple BP Reconciliation', OITR.VersionNum AS 'Version Number', OITR.OldMatNum AS 'Previous Reconciliation Number', OITR.ReconJEId AS 'JE no. created by reconciliatn', OITR.BuildDesc AS 'Build Descriptor', OITR.BPLId AS 'Branch', OITR.BPLName AS 'Branch Name', OITR.VATRegNum AS 'VAT Reg. Number' FROM OITR AS OITR

Related information


Internal Reconciliation OITR SQL Table

Business Place OBPL SQL Table

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