📚 SAP Business One SDK Help

Table Name: OIMP

Table Description: Import to Microsoft Excel

Field Description Type Size Related Default Value Constraints
SessionId Session ID Int 11 -      
ObjectType Business Object Int 6 -      
FileObNam Mapped Business Object for the Uploaded File nVarChar 100 -      
FileName Uploaded File Name nVarChar 100 -      
DocName Uploaded Document Name nVarChar 100 -      
FileHeader File Contains Header VarChar 1 - N N No
            Y Yes
MappingMtd Mapping Method VarChar 1 - M M Manual
            P Predefined Template
            S Saved Template
SavedTempl Save Template Code nVarChar 100 -      
RelatedObj Allow Related Object Creation VarChar 1 - N N No
            Y Yes
Status Status VarChar 1 -   P Parsing
            R Ready for Import
            I Import in Progress
            C Import Completed
            E Error in Import
ImportOpt Import Option nVarChar 2 - IM IM Parent Object Only
            IS Child Object Only
            SP Parent and Child Objects
            SO Child Objects Only
            MP Parent and Child Objects
            MO Child Objects Only
            IO Import parent and child objects in one file
ImportMtd Import Method nVarChar 2 - AO AU Add new records and update existing records
            AO Add new records without updating existing records
            UO Update existing records without adding new records
ErrorOpt Error Option nVarChar 2 -   C Cancel import and perform rollback when one or more errors occur
            IA Ignore all errors and process valid records
            R Perform a rollback when the number of errors reaches or exceeds the defined threshold ({NumberOfErrors}).
            IU Ignore up to {No. defined in NumberOfErrors} errors and process valid records
NumOfErr Number of Errors Int 11 -      
CreateDate Created Date Date 8 -      
UpdateDate Updated Date Date 8 -      
CreatedBy Created by User Int 6 OUSR      
UpdatedBy Updated By Int 6 OUSR      
Key Unique Field
PRIMARY Yes SessionId