biuan SAP® BUSINESS ONE SDK
API ITR1
ITR1 - Internal Reconciliation - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ReconNum KEY UNIQUEReconciliation NumberInt
11OITR
Internal Reconciliation
PRIMARYYes
LineSeqRow NumberInt
11
ShortNameBP/Account CodenVarChar
15
TransId KEYTransaction Internal IDInt
11OJDT
Journal Entry
JournalNo
TransRowIdTransaction Row NumberInt
11
SrcObjTyp KEYSource Object TypenVarChar
30) Journal Transactions
13) Invoices
18) Purchases
24) Receipts
46) Outgoing Payments
14) Revert Invoices
19) Revert Purchases
203) Down Payment Incoming
204) Down Payment Outgoing
163) Correction A/P Invoice
164) Correction A/P Invoice Reversals
165) Correction A/R Invoice
166) Correction A/R Invoice Reversals
20
ObjectNo
SrcObjAbsSource Object Internal IDInt
11
ReconSumReconciliation AmountNum
20
ReconSumFCReconciliation Amount (FC)Num
20
ReconSumSCReconciliation Amount (SC)Num
20
FrgnCurrForeign CurrencynVarChar
3OCRN
Currency Codes
SumMthCurrAmt in Reconciliation CurrencyNum
20
IsCreditCredit or DebitVarChar
C) Credit
D) Debit
1
AccountAccount CodenVarChar
15OACT
G/L Accounts
CashDisSumCash Discount AmountNum
20
WTSumWithholding Tax AmountNum
20
WTSumFCWithholding Tax Amount (FC)Num
20
WTSumSCWithholding Tax Amount (SC)Num
20
ExpSumFreight AmountNum
20
ExpSumFCFreight Amount (FC)Num
20
ExpSumSCFreight Amount (SC)Num
20
netBefDiscNet Before Discount SumNum
20
MIEntryMI Entry Include this Recon.Int
11
0
MITypeMI Type Include this Recon.nVarChar
270) A/R Monthly Invoice
140000014) A/P Monthly Invoice
20

Table relationship map

SELECT statement

SELECT ITR1.ReconNum AS 'Reconciliation Number', ITR1.LineSeq AS 'Row Number', ITR1.ShortName AS 'BP/Account Code', ITR1.TransId AS 'Transaction Internal ID', ITR1.TransRowId AS 'Transaction Row Number', ITR1.SrcObjTyp AS 'Source Object Type', ITR1.SrcObjAbs AS 'Source Object Internal ID', ITR1.ReconSum AS 'Reconciliation Amount', ITR1.ReconSumFC AS 'Reconciliation Amount (FC)', ITR1.ReconSumSC AS 'Reconciliation Amount (SC)', ITR1.FrgnCurr AS 'Foreign Currency', ITR1.SumMthCurr AS 'Amt in Reconciliation Currency', ITR1.IsCredit AS 'Credit or Debit', ITR1.Account AS 'Account Code', ITR1.CashDisSum AS 'Cash Discount Amount', ITR1.WTSum AS 'Withholding Tax Amount', ITR1.WTSumFC AS 'Withholding Tax Amount (FC)', ITR1.WTSumSC AS 'Withholding Tax Amount (SC)', ITR1.ExpSum AS 'Freight Amount', ITR1.ExpSumFC AS 'Freight Amount (FC)', ITR1.ExpSumSC AS 'Freight Amount (SC)', ITR1.netBefDisc AS 'Net Before Discount Sum', ITR1.MIEntry AS 'MI Entry Include this Recon.', ITR1.MIType AS 'MI Type Include this Recon.' FROM ITR1 AS ITR1

Related information


G/L Accounts OACT SQL Table

Currency Codes OCRN SQL Table

Internal Reconciliation OITR SQL Table

Journal Entry OJDT 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