📚 SAP Business One SDK Help

Table Name: OIRI

Table Description: Input Service Distribution - Recipient Invoice

Field Description Type Size Related Default Value Constraints
DocEntry Internal Number Int 11 -      
DocNum Document Number Int 11 -      
Series Series Int 11 NNM1      
PostDate Posting Date Date 8 -      
DocDate Document Date Date 8 -      
DocStatus Document Status VarChar 1 - O O Open
            C Canceled
RefNo Reference No. nVarChar 100 -      
RefEntry Reference Entry Int 11 -      
RefDocDate Reference Document Date Date 8 -      
TransId Transaction Number Int 11 OJDT      
Comments Remarks nVarChar 254 -      
ObjType Object Type nVarChar 20 -      
SrcLoc Source Location Code Int 11 -      
SrcLocName Source Location Name nVarChar 100 -      
SrcGSTIN Source Location GSTIN nVarChar 15 -      
TarLoc Target Location Code Int 11 -      
TarLocName Target Location Name nVarChar 100 -      
TarGSTIN Target Location GSTIN nVarChar 15 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
LogInstanc Log Instance Int 11 -      
CreateDate Create Date Date 8 -      
UserSign2 Updating User Int 6 OUSR      
UpdateDate Date of Update Date 8 -      
JrnlMemo Journal Remarks nVarChar 254 -      
Handwrtten Manual Numbering VarChar 1 - N Y Yes
            N No
PIndicator Period Indicator nVarChar 10 OPID      
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
VATRegNum VAT Reg. Number nVarChar 32 -      
Key Unique Field
PRIMARY Yes DocEntry
INDEX Yes DocNum
    PIndicator