📚 SAP Business One SDK Help

Table Name: IMP1

Table Description: History Table

Field Description Type Size Related Default Value Constraints
SessionId Session ID Int 11 -      
ObjectType Business Object Int 6 -      
Status Status VarChar 1 -   P Parsing
            R Ready for Import
            I Import in Progress
            C Import Completed
            E Error in Import
ImportOpt Import Option VarChar 1 -   M Import Main Object
            S Import Sub-Objects
            D Import main and sub-objects in separate files
            O Import main and sub-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