Arabic: إعدادات استيراد سجلات English: Record Import Configuration - Record Import Configurations
detail1Fields (RecordImportConfigDetail1Field) , detail2Fields (RecordImportConfigDetail2Field) , detail3Fields (RecordImportConfigDetail3Field) , detail4Fields (RecordImportConfigDetail4Field) , detail5Fields (RecordImportConfigDetail5Field) , headerFields (RecordImportConfigHeaderField)
Fields
Property
Column
Arabic
English
Type
Foreign Table
analysisSetId
analysisSet_id
ID
branchId
branch_id
Branch ID
Branch ID
ID
code
code
الكود
Code
Text
colorCode
colorCode
كود اللون
Color Code
Color
commitedBefore
commitedBefore
تم الحفظ مسبقا
Commited Before
Boolean
createTransactionId
createTransactionId
Text
creationDate
creationDate
تاريخ الإنشاء
Creation Date
DateAndTime
currentVersion
currentVersion
النسخة الحالية
Current Version
Integer
customViewName
customViewName
Text
date1
date1
تـــاريخ 1
Date 1
Date
date2
date2
تـــاريخ 2
Date 2
Date
date3
date3
تاريخ 3
Date3
Date
date4
date4
تاريخ 4
Date4
Date
date5
date5
تاريخ 5
Date5
Date
departmentId
department_id
ID
description1
description1
الوصف 1
description1
Text
description2
description2
الوصف 2
description2
Text
description3
description3
الوصف 3
description3
Text
description4
description4
الوصف 4
description4
Text
description5
description5
الوصف 5
description5
Text
detail1.detailField
d1DetailField
معرف السطور
Detail Field
FieldID
detail1.detailLinkField
d1DetailLinkField
Detail Link Field
Detail Link Field
FieldID
detail1.headerLinkField
d1HeaderLinkField
Header Link Field
Header Link Field
FieldID
detail1.ignoreLinesFromEnd
d1IgnoreLinesFromEnd
Ignore Lines From End
Ignore Lines From End
Integer
detail1.ignoreLinesFromTop
d1IgnoreLinesFromTop
Ignore Lines From Top
Ignore Lines From Top
Integer
detail1.sheetNameOrIndex
d1SheetNameOrIndex
اسم الشيت أو رقمه
Sheet Name Or Index
Text
detail1.skipLineIfMatchedWith
d1SkipLineIfMatchedWith
Skip Line If Matched With Query
Skip Line If Matched With Query
BigText
detail1.titlesRowNumber
d1TitlesRowNumber
رقم سطر عناوين الخلايا
Cell Titles Row Number
Integer
detail1.uniqueByExpression
d1UniqueByExpression
Unique By Expression
Unique By Expression
BigText
detail1.uniqueByExpressionType
d1UniqueByExpressionType
Unique By Expression Type
Unique By Expression Type
Enum
detail1.workbookId
d1WorkbookId
معرف الملف
Workbook ID
Text
detail2.detailField
d2DetailField
معرف السطور
Detail Field
FieldID
detail2.detailLinkField
d2DetailLinkField
Detail Link Field
Detail Link Field
FieldID
detail2.headerLinkField
d2HeaderLinkField
Header Link Field
Header Link Field
FieldID
detail2.ignoreLinesFromEnd
d2IgnoreLinesFromEnd
Ignore Lines From End
Ignore Lines From End
Integer
detail2.ignoreLinesFromTop
d2IgnoreLinesFromTop
Ignore Lines From Top
Ignore Lines From Top
Integer
detail2.sheetNameOrIndex
d2SheetNameOrIndex
اسم الشيت أو رقمه
Sheet Name Or Index
Text
detail2.skipLineIfMatchedWith
d2SkipLineIfMatchedWith
Skip Line If Matched With Query
Skip Line If Matched With Query
BigText
detail2.titlesRowNumber
d2TitlesRowNumber
رقم سطر عناوين الخلايا
Cell Titles Row Number
Integer
detail2.uniqueByExpression
d2UniqueByExpression
Unique By Expression
Unique By Expression
BigText
detail2.uniqueByExpressionType
d2UniqueByExpressionType
Unique By Expression Type
Unique By Expression Type
Enum
detail2.workbookId
d2WorkbookId
معرف الملف
Workbook ID
Text
detail3.detailField
d3DetailField
معرف السطور
Detail Field
FieldID
detail3.detailLinkField
d3DetailLinkField
Detail Link Field
Detail Link Field
FieldID
detail3.headerLinkField
d3HeaderLinkField
Header Link Field
Header Link Field
FieldID
detail3.ignoreLinesFromEnd
d3IgnoreLinesFromEnd
Ignore Lines From End
Ignore Lines From End
Integer
detail3.ignoreLinesFromTop
d3IgnoreLinesFromTop
Ignore Lines From Top
Ignore Lines From Top
Integer
detail3.sheetNameOrIndex
d3SheetNameOrIndex
اسم الشيت أو رقمه
Sheet Name Or Index
Text
detail3.skipLineIfMatchedWith
d3SkipLineIfMatchedWith
Skip Line If Matched With Query
Skip Line If Matched With Query
BigText
detail3.titlesRowNumber
d3TitlesRowNumber
رقم سطر عناوين الخلايا
Cell Titles Row Number
Integer
detail3.uniqueByExpression
d3UniqueByExpression
Unique By Expression
Unique By Expression
BigText
detail3.uniqueByExpressionType
d3UniqueByExpressionType
Unique By Expression Type
Unique By Expression Type
Enum
detail3.workbookId
d3WorkbookId
معرف الملف
Workbook ID
Text
detail4.detailField
d4DetailField
معرف السطور
Detail Field
FieldID
detail4.detailLinkField
d4DetailLinkField
Detail Link Field
Detail Link Field
FieldID
detail4.headerLinkField
d4HeaderLinkField
Header Link Field
Header Link Field
FieldID
detail4.ignoreLinesFromEnd
d4IgnoreLinesFromEnd
Ignore Lines From End
Ignore Lines From End
Integer
detail4.ignoreLinesFromTop
d4IgnoreLinesFromTop
Ignore Lines From Top
Ignore Lines From Top
Integer
detail4.sheetNameOrIndex
d4SheetNameOrIndex
اسم الشيت أو رقمه
Sheet Name Or Index
Text
detail4.skipLineIfMatchedWith
d4SkipLineIfMatchedWith
Skip Line If Matched With Query
Skip Line If Matched With Query
BigText
detail4.titlesRowNumber
d4TitlesRowNumber
رقم سطر عناوين الخلايا
Cell Titles Row Number
Integer
detail4.uniqueByExpression
d4UniqueByExpression
Unique By Expression
Unique By Expression
BigText
detail4.uniqueByExpressionType
d4UniqueByExpressionType
Unique By Expression Type
Unique By Expression Type
Enum
detail4.workbookId
d4WorkbookId
معرف الملف
Workbook ID
Text
detail5.detailField
d5DetailField
معرف السطور
Detail Field
FieldID
detail5.detailLinkField
d5DetailLinkField
Detail Link Field
Detail Link Field
FieldID
detail5.headerLinkField
d5HeaderLinkField
Header Link Field
Header Link Field
FieldID
detail5.ignoreLinesFromEnd
d5IgnoreLinesFromEnd
Ignore Lines From End
Ignore Lines From End
Integer
detail5.ignoreLinesFromTop
d5IgnoreLinesFromTop
Ignore Lines From Top
Ignore Lines From Top
Integer
detail5.sheetNameOrIndex
d5SheetNameOrIndex
اسم الشيت أو رقمه
Sheet Name Or Index
Text
detail5.skipLineIfMatchedWith
d5SkipLineIfMatchedWith
Skip Line If Matched With Query
Skip Line If Matched With Query
BigText
detail5.titlesRowNumber
d5TitlesRowNumber
رقم سطر عناوين الخلايا
Cell Titles Row Number
Integer
detail5.uniqueByExpression
d5UniqueByExpression
Unique By Expression
Unique By Expression
BigText
detail5.uniqueByExpressionType
d5UniqueByExpressionType
Unique By Expression Type
Unique By Expression Type
Enum
detail5.workbookId
d5WorkbookId
معرف الملف
Workbook ID
Text
documentFileStatus
documentFileStatus
حالة المستند
Document File Status
Enum
draftCreated
draftCreated
تم إنشاء مسودة
Draft Created
Boolean
draftXML
draftXML
BigText
entitySystemEntryId
entitySystemEntry_id
ID
entityType
entityType
النوع
Entity Type
EntityType
firstAuthorId
firstAuthor_id
ID
generatedByLine
generatedByLine
كود سطر الإنشاء
generated By Line
Text
generatedDocsCount
generatedDocsCount
Integer
generatedFrom
generatedFromActualCode, generatedFromCode, generatedFromEntityType, generatedFromId
تم إنشاؤه من
Generated From
Genericreference
generationType
generationType
نوع الإنشاء
Generation Type
Enum
header.doNotAddRecords
hDoNotAddRecords
عدم إضافة السجلات (تحديث فقط)
Do Not Add Records (Update Only)
Boolean
header.doNotUpdateRecords
hDoNotUpdateRecords
عدم تحديث السجلات الموجودة (إضافة فقط)
Do Not Update Records (Add Only)
Boolean
header.ignoreLinesFromEnd
hIgnoreLinesFromEnd
Ignore Lines From End
Ignore Lines From End
Integer
header.ignoreLinesFromTop
hIgnoreLinesFromTop
Ignore Lines From Top
Ignore Lines From Top
Integer
header.importedType
hImportedType
نوع السجل الذي تريد استيراده
Imported Type
EntityType
header.saveAsDraft
hSaveAsDraft
الحفظ كمسودة
Save As Draft
Boolean
header.sheetNameOrIndex
hSheetNameOrIndex
اسم الشيت أو رقمه
Sheet Name Or Index
Text
header.skipLineIfMatchedWith
hSkipLineIfMatchedWith
Skip Line If Matched With Query
Skip Line If Matched With Query
BigText
header.titlesRowNumber
hTitlesRowNumber
رقم سطر عناوين الخلايا
Cell Titles Row Number
Integer
header.uniqueByExpression
hUniqueByExpression
Unique By Expression
Unique By Expression
BigText
header.uniqueByExpressionType
hUniqueByExpressionType
Unique By Expression Type
Unique By Expression Type
Enum
header.workbookId
hWorkbookId
معرف الملف
Workbook ID
Text
id
id
ID
indexInParent
indexInParent
Integer
lastChangeVersion
lastChangeVersion
Integer
lastModifyTransactionId
LastModifyTransactionId
Text
lastUpdateDate
lastUpdateDate
تاريخ اخر تحديث
Last update Date
DateAndTime
legalEntityId
legalEntity_id
ID
lockVersion
lockVersion
Integer
n1
n1
رقم 1
Number 1
Decimal
n2
n2
رقم 2
Number 2
Decimal
n3
n3
رقم 3
Number 3
Decimal
n4
n4
رقم 4
Number 4
Decimal
n5
n5
رقم 5
Number 5
Decimal
name1
name1
الاسم العربي
Name1
Text
name2
name2
الاسم الإنجليزي
Name2
Text
parentCode
parentCode
Text
preventUsage
preventUsage
منع الاستعمال
Prevent Usage
Boolean
printCount
printCount
عدد مرات الطباعة
Print Count
Integer
ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3
Genericreference
ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4
Genericreference
ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5
Genericreference
remarks
remark
ملاحظات
Description
BigText
reviseLevel
reviseLevel
مستوى المراجعة
Revise Level
Enum
revised
primitiveValue
تمت المراجعة
Revised
Boolean
sectorId
sector_id
ID
sheetHTML
sheetHTML
Sheet HTML
Sheet HTML
BigText
systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix
Text
updateCapabilityId
updateCapability_id
ID
usageCapabilityId
usageCapability_id
ID
viewCapabilityId
viewCapability_id
ID
detail1Fields (حقول سطور 1 - Details 1 Fields)
Table Name: RecordImportConfigDetail1Field, Join Column: recordImportConfig_id
Property
Column
Arabic
English
Type
Foreign Table
detail1Fields.cellName
cellName
الخلية
Cell Name
Text
detail1Fields.cellTitle
cellTitle
عنوان الخلية
Cell Title
Text
detail1Fields.constantDateValue
constantDateValue
تاريخ
Constant Date Value
DateAndTime
detail1Fields.constantRefValue
constantRefValueActualCode, constantRefValueCode, constantRefValueEntityType, constantRefValueId
مرجع
Constant Reference Value
Genericreference
detail1Fields.constantValue
constantValue
القيمة الثابتة
Constant Value
Text
detail1Fields.dateFormats
dateFormats
Date Formats (Separate by ##)
Date Formats (Separate by ##)
Text
detail1Fields.expression
expression
Expression
Expression
BigText
detail1Fields.expressionType
expressionType
Expression Type
Expression Type
Enum
detail1Fields.fieldId
fieldId
الحقل
On Field
FieldID
detail1Fields.fieldType
fieldType
نوع الحقل
Field Type
Text
detail1Fields.id
id
ID
detail1Fields.lineNumber
lineNumber
Integer
detail1Fields.remarks
remarks
ملاحظات
Description
BigText
detail1Fields.skipFieldIfEmptyOrZero
skipFieldIfEmptyOrZero
تجاهل الحقل إذا كان فارغا
Skip Field If Empty Or Zero
Boolean
detail1Fields.skipRowIfEmptyOrZero
skipRowIfEmptyOrZero
تجاهل السطر بالكامل إذا كان الحقل فارغا
Skip Row If Empty Or Zero
Boolean
detail1Fields.useAsUniquenessKey
useAsUniquenessKey
يستعمل لمنع التكرار
Use As Uniqueness Key
Boolean
detail2Fields (حقول سطور 2 - Details 2 Fields)
Table Name: RecordImportConfigDetail2Field, Join Column: recordImportConfig_id
Property
Column
Arabic
English
Type
Foreign Table
detail2Fields.cellName
cellName
الخلية
Cell Name
Text
detail2Fields.cellTitle
cellTitle
عنوان الخلية
Cell Title
Text
detail2Fields.constantDateValue
constantDateValue
تاريخ
Constant Date Value
DateAndTime
detail2Fields.constantRefValue
constantRefValueActualCode, constantRefValueCode, constantRefValueEntityType, constantRefValueId
مرجع
Constant Reference Value
Genericreference
detail2Fields.constantValue
constantValue
القيمة الثابتة
Constant Value
Text
detail2Fields.dateFormats
dateFormats
Date Formats (Separate by ##)
Date Formats (Separate by ##)
Text
detail2Fields.expression
expression
Expression
Expression
BigText
detail2Fields.expressionType
expressionType
Expression Type
Expression Type
Enum
detail2Fields.fieldId
fieldId
الحقل
On Field
FieldID
detail2Fields.fieldType
fieldType
نوع الحقل
Field Type
Text
detail2Fields.id
id
ID
detail2Fields.lineNumber
lineNumber
Integer
detail2Fields.remarks
remarks
ملاحظات
Description
BigText
detail2Fields.skipFieldIfEmptyOrZero
skipFieldIfEmptyOrZero
تجاهل الحقل إذا كان فارغا
Skip Field If Empty Or Zero
Boolean
detail2Fields.skipRowIfEmptyOrZero
skipRowIfEmptyOrZero
تجاهل السطر بالكامل إذا كان الحقل فارغا
Skip Row If Empty Or Zero
Boolean
detail2Fields.useAsUniquenessKey
useAsUniquenessKey
يستعمل لمنع التكرار
Use As Uniqueness Key
Boolean
detail3Fields (حقول سطور 3 - Details 3 Fields)
Table Name: RecordImportConfigDetail3Field, Join Column: recordImportConfig_id
Property
Column
Arabic
English
Type
Foreign Table
detail3Fields.cellName
cellName
الخلية
Cell Name
Text
detail3Fields.cellTitle
cellTitle
عنوان الخلية
Cell Title
Text
detail3Fields.constantDateValue
constantDateValue
تاريخ
Constant Date Value
DateAndTime
detail3Fields.constantRefValue
constantRefValueActualCode, constantRefValueCode, constantRefValueEntityType, constantRefValueId
مرجع
Constant Reference Value
Genericreference
detail3Fields.constantValue
constantValue
القيمة الثابتة
Constant Value
Text
detail3Fields.dateFormats
dateFormats
Date Formats (Separate by ##)
Date Formats (Separate by ##)
Text
detail3Fields.expression
expression
Expression
Expression
BigText
detail3Fields.expressionType
expressionType
Expression Type
Expression Type
Enum
detail3Fields.fieldId
fieldId
الحقل
On Field
FieldID
detail3Fields.fieldType
fieldType
نوع الحقل
Field Type
Text
detail3Fields.id
id
ID
detail3Fields.lineNumber
lineNumber
Integer
detail3Fields.remarks
remarks
ملاحظات
Description
BigText
detail3Fields.skipFieldIfEmptyOrZero
skipFieldIfEmptyOrZero
تجاهل الحقل إذا كان فارغا
Skip Field If Empty Or Zero
Boolean
detail3Fields.skipRowIfEmptyOrZero
skipRowIfEmptyOrZero
تجاهل السطر بالكامل إذا كان الحقل فارغا
Skip Row If Empty Or Zero
Boolean
detail3Fields.useAsUniquenessKey
useAsUniquenessKey
يستعمل لمنع التكرار
Use As Uniqueness Key
Boolean
detail4Fields (حقول سطور 4 - Details 4 Fields)
Table Name: RecordImportConfigDetail4Field, Join Column: recordImportConfig_id
Property
Column
Arabic
English
Type
Foreign Table
detail4Fields.cellName
cellName
الخلية
Cell Name
Text
detail4Fields.cellTitle
cellTitle
عنوان الخلية
Cell Title
Text
detail4Fields.constantDateValue
constantDateValue
تاريخ
Constant Date Value
DateAndTime
detail4Fields.constantRefValue
constantRefValueActualCode, constantRefValueCode, constantRefValueEntityType, constantRefValueId
مرجع
Constant Reference Value
Genericreference
detail4Fields.constantValue
constantValue
القيمة الثابتة
Constant Value
Text
detail4Fields.dateFormats
dateFormats
Date Formats (Separate by ##)
Date Formats (Separate by ##)
Text
detail4Fields.expression
expression
Expression
Expression
BigText
detail4Fields.expressionType
expressionType
Expression Type
Expression Type
Enum
detail4Fields.fieldId
fieldId
الحقل
On Field
FieldID
detail4Fields.fieldType
fieldType
نوع الحقل
Field Type
Text
detail4Fields.id
id
ID
detail4Fields.lineNumber
lineNumber
Integer
detail4Fields.remarks
remarks
ملاحظات
Description
BigText
detail4Fields.skipFieldIfEmptyOrZero
skipFieldIfEmptyOrZero
تجاهل الحقل إذا كان فارغا
Skip Field If Empty Or Zero
Boolean
detail4Fields.skipRowIfEmptyOrZero
skipRowIfEmptyOrZero
تجاهل السطر بالكامل إذا كان الحقل فارغا
Skip Row If Empty Or Zero
Boolean
detail4Fields.useAsUniquenessKey
useAsUniquenessKey
يستعمل لمنع التكرار
Use As Uniqueness Key
Boolean
detail5Fields (حقول سطور 5 - Details 5 Fields)
Table Name: RecordImportConfigDetail5Field, Join Column: recordImportConfig_id
Property
Column
Arabic
English
Type
Foreign Table
detail5Fields.cellName
cellName
الخلية
Cell Name
Text
detail5Fields.cellTitle
cellTitle
عنوان الخلية
Cell Title
Text
detail5Fields.constantDateValue
constantDateValue
تاريخ
Constant Date Value
DateAndTime
detail5Fields.constantRefValue
constantRefValueActualCode, constantRefValueCode, constantRefValueEntityType, constantRefValueId
مرجع
Constant Reference Value
Genericreference
detail5Fields.constantValue
constantValue
القيمة الثابتة
Constant Value
Text
detail5Fields.dateFormats
dateFormats
Date Formats (Separate by ##)
Date Formats (Separate by ##)
Text
detail5Fields.expression
expression
Expression
Expression
BigText
detail5Fields.expressionType
expressionType
Expression Type
Expression Type
Enum
detail5Fields.fieldId
fieldId
الحقل
On Field
FieldID
detail5Fields.fieldType
fieldType
نوع الحقل
Field Type
Text
detail5Fields.id
id
ID
detail5Fields.lineNumber
lineNumber
Integer
detail5Fields.remarks
remarks
ملاحظات
Description
BigText
detail5Fields.skipFieldIfEmptyOrZero
skipFieldIfEmptyOrZero
تجاهل الحقل إذا كان فارغا
Skip Field If Empty Or Zero
Boolean
detail5Fields.skipRowIfEmptyOrZero
skipRowIfEmptyOrZero
تجاهل السطر بالكامل إذا كان الحقل فارغا
Skip Row If Empty Or Zero
Boolean
detail5Fields.useAsUniquenessKey
useAsUniquenessKey
يستعمل لمنع التكرار
Use As Uniqueness Key
Boolean
headerFields (حقول الهيدر - Header Fields)
Table Name: RecordImportConfigHeaderField, Join Column: recordImportConfig_id
Property
Column
Arabic
English
Type
Foreign Table
headerFields.cellName
cellName
الخلية
Cell Name
Text
headerFields.cellTitle
cellTitle
عنوان الخلية
Cell Title
Text
headerFields.constantDateValue
constantDateValue
تاريخ
Constant Date Value
DateAndTime
headerFields.constantRefValue
constantRefValueActualCode, constantRefValueCode, constantRefValueEntityType, constantRefValueId
مرجع
Constant Reference Value
Genericreference
headerFields.constantValue
constantValue
القيمة الثابتة
Constant Value
Text
headerFields.dateFormats
dateFormats
Date Formats (Separate by ##)
Date Formats (Separate by ##)
Text
headerFields.expression
expression
Expression
Expression
BigText
headerFields.expressionType
expressionType
Expression Type
Expression Type
Enum
headerFields.fieldId
fieldId
الحقل
On Field
FieldID
headerFields.fieldType
fieldType
نوع الحقل
Field Type
Text
headerFields.id
id
ID
headerFields.lineNumber
lineNumber
Integer
headerFields.remarks
remarks
ملاحظات
Description
BigText
headerFields.skipFieldIfEmptyOrZero
skipFieldIfEmptyOrZero
تجاهل الحقل إذا كان فارغا
Skip Field If Empty Or Zero
Boolean
headerFields.skipRowIfEmptyOrZero
skipRowIfEmptyOrZero
تجاهل السطر بالكامل إذا كان الحقل فارغا
Skip Row If Empty Or Zero
Boolean
headerFields.useAsUniquenessKey
useAsUniquenessKey
يستعمل لمنع التكرار
Use As Uniqueness Key
Boolean