📚 SAP Business One SDK Help

Table Name: OITR

Table Description: Internal Reconciliation

Field Description Type Size Related Default Value Constraints
ReconNum Reconciliation Number Int 11 -      
IsCard BP or Account VarChar 1 -   C BP
            A G/L Account
ReconType Reconciliation Type nVarChar 2 -   0 Manual
            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
            19 Withholding Tax Interim Account
            20 eTDS Posted to BP
ReconDate Reconciliation Date Date 8 -      
Total Total Reconciliation Amount Num 19.6 -      
ReconCurr Reconciliation Currency nVarChar 3 OCRN      
Canceled Canceled VarChar 1 - N Y Yes
            N No
CancelAbs Canceling/-ed Reconciliation Int 11 OITR 0    
IsSystem System or Manual VarChar 1 -   Y Yes
            N No
InitObjTyp Reconc. Initiator Object Type nVarChar 20 -      
InitObjAbs Reconc. Initiator Internal ID Int 11 -      
CreateDate Creation Date Date 8 -      
CreateTime Creation Time Int 6 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Auto Incr.
            D Data Doc.
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
ReconRule1 Reconciliation Rule 1 nVarChar 2 -   0 Posting Date
            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
ReconRule2 Reconciliation Rule 2 nVarChar 2 -   0 Posting Date
            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
ReconRule3 Reconciliation Rule 3 nVarChar 2 -   0 Posting Date
            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
IsMultiBP Multiple BP Reconciliation VarChar 1 - N N No
            Y Yes
VersionNum Version Number nVarChar 13 -      
OldMatNum Previous Reconciliation Number Int 11 - 0    
ReconJEId JE no. created by reconciliatn Int 11 -      
BuildDesc Build Descriptor nVarChar 50 -      
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
VATRegNum VAT Reg. Number nVarChar 32 -      
IsElectr Is Electronic VarChar 1 - N N No
            Y Yes
CreateTS Creation Time - Incl. Sec. Int 11 -      
UpdateTS Update Full Time Int 11 -      
ObjType Object Type nVarChar 20 - 321    
Key Unique Field
PRIMARY Yes ReconNum