|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Details and Status for Import Field
Table Name: IMP3
Table Description: Details and Status for Import Field
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SessionId | Session ID | Int | 11 | - | Â | Â | Â |
| RowNumber | RowNumber | Int | 6 | - | Â | Â | Â |
| TableName | Table Name | nVarChar | 100 | - | Â | Â | Â |
| FileColNam | Column Name in the Uploaded File | nVarChar | 10 | - | Â | Â | Â |
| BOFldName | Field Name of Mapped Business Object | nVarChar | 50 | - | Â | Â | Â |
| BOFldDesc | Descriptive Field Name of Mapped Business Object | nVarChar | 100 | - | Â | Â | Â |
| FieldValue | Field Value | nVarChar | 100 | - | Â | Â | Â |
| Validation | Validation Method | VarChar | 1 | - | Â | D | Fill with Default Values |
| Â | Â | Â | Â | Â | Â | C | Clean Data |
| Â | Â | Â | Â | Â | Â | M | Validate with Metadata |
| Â | Â | Â | Â | Â | Â | V | Custom Validation |
| ValidRes | Validation Result | VarChar | 1 | - | Â | N | Not Validated |
| Â | Â | Â | Â | Â | Â | Y | Validation Successful |
| Â | Â | Â | Â | Â | Â | E | Error in Validation |
| ValidMsg | Validation Message | nVarChar | 100 | - | Â | Â | Â |
| Line_ID | Line Number | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | SessionId |
| Â | Â | RowNumber |
| Â | Â | Line_ID |