Import Row Details and Status

Table Name: IMP2

Table Description: Import Row Details and Status

Field	Description	Type	Size	Related	Default Value	Constraints
SessionId	Session ID	Int	11	-
TableName	Table Name	nVarChar	100	-
RowNumber	RowNumber	Int	6	-
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
Validation	Validation Result	VarChar	1	-		N	Invalid
						Y	Ready
						R	Ready*
Simulation	Simulation Result	VarChar	1	-		N	Not Simulated
						V	Simulation Successful
						E	Error in Simulation
ImptStatus	Import Status	nVarChar	2	-		A	Added
						U	Updated
						F	Failed
						S	Skipped
ImpMsg	Import Message for Skipped or Failed Records	nVarChar	200	-
ErrMsg	Row-level simulation or special use case error message	nVarChar	200	-
ImportLog	Import Log	nVarChar	50	-