DataSource

Raw JSON

Arabic: مصدر بيانات - مصادر بيانات

English: Data Source - Data Sources

fields (DataSourceFieldLine) , parameters (DataSourceParameterLine) , securityConstraints (DataSourceSecurityConstraints) , sortFields (DataSourceSortFieldLine) , unionTables (DataSourceUnionTablesLine) , userAliases (DataSourceUserAliasesLine) , whereLines (DataSourceWhereLine)

Fields

Property

Column

Arabic

English

Type

Foreign Table

allowAllMainTableFieldsForUse

allowAllMainTableFieldsForUse

إتاحة كل حقول الجدول الرئيسي للاستخدام

Allow All Main Table Fields For Use

Boolean

analysisSet

analysisSet_id

المجموعة التحليلية

Analysis set

Reference

AnalysisSet

analysisSetId

analysisSet_id

ID

branch

branch_id

الفرع

Branch

Reference

Branch

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

currentApprovalCase

currentApprovalCase_id

ApprovalCase

currentVersion

currentVersion

النسخة الحالية

Current Version

Integer

customViewName

customViewName

Text

dataModelXml

dataModelXml

BigText

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

department

department_id

الإدارة

Department

Reference

Department

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

docCategory

docCategory_id

تصنيف سجل

Record Category

Reference

DocCategory

documentFileStatus

documentFileStatus

حالة المستند

Document File Status

DocumentFileStatus

draftCreated

draftCreated

تم إنشاء مسودة

Draft Created

Boolean

draftXML

draftXML

BigText

editedBy

editedBy_id

بواسطة

Edited By

Reference

NaMaUser

entitySystemEntryId

entitySystemEntry_id

ID

entityType

entityType

النوع

Entity Type

EntityType

finalStaticDeclareStatements

finalStaticDeclareStatements

Final Static Declare Statements

Final Static Declare Statements

BigText

finalStaticHavingCondition

finalStaticHavingCondition

Final Static Having Condition

Final Static Having Condition

BigText

finalStaticWhereCondition

finalStaticWhereCondition

Final Static Where Condition

Final Static Where Condition

BigText

firstAuthor

firstAuthor_id

منشئ السجل

First Author

Reference

NaMaUser

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

GenerationType

group

group_id

المجموعة

Group

Reference

MasterGroup

id

id

ID

includeDrafts

includeDrafts

يشمل المسودات

Include Drafts

Boolean

indexInParent

indexInParent

Integer

lastChangeVersion

lastChangeVersion

Integer

lastModifyTransactionId

LastModifyTransactionId

Text

lastUpdateDate

lastUpdateDate

تاريخ اخر تحديث

Last update Date

DateAndTime

legalEntity

legalEntity_id

الشركة

Legal Entity

Reference

LegalEntity

legalEntityId

legalEntity_id

ID

lockVersion

lockVersion

Integer

mainFile

mainFile_id

Binary

LargeData

mainTable

mainTable

الجدول الرئيسي

Main Table

FieldID

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

ReviseLevel

revised

primitiveValue

تمت المراجعة

Revised

Boolean

revisedBy

revisedBy_id

Reference

NaMaUser

sector

sector_id

القطاع

Sector

Reference

Sector

sectorId

sector_id

ID

selectQueryPartPrefix

selectQueryPartPrefix

Select Query Part Prefix

Select Query Part Prefix

BigText

sqlQuery

sqlQuery

SQL Query

SQL Query

BigText

staticDeclareStatements

staticDeclareStatements

Static Declare Statements

Static Declare Statements

BigText

staticHavingCondition

staticHavingCondition

Static Having Condition

Static Having Condition

BigText

staticWhereCondition

staticWhereCondition

Static Where Condition

Static Where Condition

BigText

systemGeneratedCodePrefix

systemGeneratedCodePrefix

System Generated Code Prefix

System Generated Code Prefix

Text

tableType

tableType

Table Type

Table Type

TableType

updateCapability

updateCapability_id

صلاحية التعديل

Update Capability

Reference

SecurityCapability

updateCapabilityId

updateCapability_id

ID

usageCapability

usageCapability_id

صلاحية الاستخدام

Usage Capability

Reference

SecurityCapability

usageCapabilityId

usageCapability_id

ID

usedInPOS

usedInPOS

مستخدم لنقاط البيع

Used In POS

Boolean

viewCapability

viewCapability_id

صلاحية المطالعة

View Capability

Reference

SecurityCapability

viewCapabilityId

viewCapability_id

ID

fields (الحقول - Fields)

Table Name: DataSourceFieldLine, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

fields.arabicTitle

arabicTitle

العنوان بالعربية

Arabic Title

Text

fields.barcodeType

barcodeType

نوع الباركود

Barcode Type

BarcodeType

fields.conditionalStyleGrid

conditionalStyleGrid

رقم جدول التنسيق الشرطي

Conditional Style Grid

Integer

fields.configuration

configuration

Configuration

Configuration

BigText

fields.currencyField

currencyField

حقل العملة

Currency Field

FieldID

fields.customHyperLinkExpression

customHyperLinkExpression

Custom Hyper Link Expression

Custom Hyper Link Expression

BigText

fields.customJasperExpression

customJasperExpression

Custom Jasper Expression

Custom Jasper Expression

BigText

fields.customPattern

customPattern

Custom Pattern

Custom Pattern

Text

fields.customSqlExpression

customSqlExpression

Custom SQL Expression

Custom SQL Expression

BigText

fields.displayAttachmentAsImage

displayAttachmentAsImage

إظهار المرفق كصورة في التقرير

Display Attachment As Image

Boolean

fields.displayFieldAs

displayFieldAs

إظهار الرقم كـ

Display Number As

DisplayNumberAs

fields.displayReferenceAs

displayReferenceAs

إظهار المرجع كـ

Display Reference As

DisplayReferenceAs

fields.doNotAddLinkToReferences

doNotAddLinkToReferences

عدم إضافة لينك للمرجع

Do Not Add Link To References

Boolean

fields.englishTitle

englishTitle

العنوان بالإنجليزية

English Title

Text

fields.fieldId

fieldId

الحقل

On Field

FieldID

fields.fieldType

fieldType

نوع الحقل

Field Type

WizardFieldType

fields.fieldWidth

fieldWidth

العرض

Width

Decimal

fields.finalHyperLinkExpression

finalHyperLinkExpression

Final Hyper Link Expression

Final Hyper Link Expression

BigText

fields.finalJasperExpression

finalJasperExpression

Final Jasper Expression

Final Jasper Expression

BigText

fields.finalSqlExpression

finalSqlExpression

Final Sql Expression

Final Sql Expression

BigText

fields.hasTotalInSummary

hasTotalInSummary

تجميع في الإجماليات

Has Total In Summary

Boolean

fields.hidden

hidden

إخفاء

Hidden

Boolean

fields.id

id

ID

fields.lineNumber

lineNumber

Integer

fields.mainFieldId

mainFieldId

الحقل الرئيسي (في حالة حقل بديل لحقل)

Main Field Id (In Case Alternative Field)

Text

fields.mergedArabicTitle

mergedArabicTitle

Merged Arabic Title

Merged Arabic Title

Text

fields.mergedEnglishTitle

mergedEnglishTitle

Merged English Title

Merged English Title

Text

fields.namaFieldType

namaFieldType

Field Type

Field Type

Text

fields.namaId

namaId

Nama Id

Nama Id

Text

fields.patternField

patternField

Pattern Field

Pattern Field

FieldID

fields.patternType

patternType

Pattern Type

Pattern Type

PatternType

fields.referenceOrderBy

referenceOrderBy

ترتيب المرجع بـ

Reference Order By

ReferenceOrderBy

fields.showRunningTotalInsteadOfValue

showRunningTotalInsteadOfValue

إظهار الإجمالي الحالي في التفاصيل بدلا من القيمة

Show Running Total Instead Of Value

ShowRunningTotalInsteadOfValue

fields.showTotalInGroup1Section

showTotalInGroup1Section

Show Total In Group 1 Section

Show Total In Group 1 Section

GroupSection

fields.showTotalInGroup2Section

showTotalInGroup2Section

Show Total In Group 2 Section

Show Total In Group 2 Section

GroupSection

fields.showTotalInGroup3Section

showTotalInGroup3Section

Show Total In Group 3 Section

Show Total In Group 3 Section

GroupSection

fields.showTotalInGroup4Section

showTotalInGroup4Section

Show Total In Group 4 Section

Show Total In Group 4 Section

GroupSection

fields.showTotalInGroup5Section

showTotalInGroup5Section

Show Total In Group 5 Section

Show Total In Group 5 Section

GroupSection

fields.sqlAggregationType

sqlAggregationType

SQL Aggregation Type

SQL Aggregation Type

SqlAggregationType

fields.sqlColumns

sqlColumns

Text

fields.style

style_id

Style

Style

Reference

ReportStyle

fields.summaryConditionalStyleGrid

summaryConditionalStyleGrid

رقم جدول التنسيق الشرطي للإجماليات

Summary Conditional Style Grid

Integer

fields.summaryStyle

summaryStyle_id

Summary Style

Summary Style

Reference

ReportStyle

fields.totalPosition

totalPosition

Total Position

Total Position

TotalPosition

fields.type

type

النوع

Type

WizardFieldType

fields.unionHandling

unionHandling

Union Handling

Union Handling

BigText

fields.useUOMParameterForQtyConversion

useUOMParameterForQtyConversion

استعمال مدخل الوحدة لتحويل الكمية

Use UOM Parameter for Qty Conversion

Boolean

fields.userAlias

userAlias

User Alias

User Alias

Text

fields.widthSize

widthSize

مقاس العرض

Width Size

GridSizeEnum

parameters (المدخلات - Parameters)

Table Name: DataSourceParameterLine, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

parameters.allowedValues

allowedValues

القيم المسموح بها

Allowed Values

BigText

parameters.allowedValuesAr

allowedValuesAr

Arabic Allowed Values

Arabic Allowed Values

BigText

parameters.allowedValuesEn

allowedValuesEn

English Allowed Values

English Allowed Values

BigText

parameters.arabicTitle

arabicTitle

العنوان بالعربية

Arabic Title

Text

parameters.barcodeType

barcodeType

نوع الباركود

Barcode Type

BarcodeType

parameters.conditionalStyleGrid

conditionalStyleGrid

رقم جدول التنسيق الشرطي

Conditional Style Grid

Integer

parameters.configuration

configuration

Configuration

Configuration

BigText

parameters.currencyField

currencyField

حقل العملة

Currency Field

FieldID

parameters.customHyperLinkExpression

customHyperLinkExpression

Custom Hyper Link Expression

Custom Hyper Link Expression

BigText

parameters.customJasperExpression

customJasperExpression

Custom Jasper Expression

Custom Jasper Expression

BigText

parameters.customPattern

customPattern

Custom Pattern

Custom Pattern

Text

parameters.customSqlExpression

customSqlExpression

Custom SQL Expression

Custom SQL Expression

BigText

parameters.defaultValue

defaultValue

القيمة الافتراضية

Default Value

Text

parameters.defaultValueDate

defaultValueDate

القيمة الافتراضية لحقل التاريخ

Date Default Value

Date

parameters.defaultValueDateTime

defaultValueDateTime

القيمة الافتراضية لحقل التاريخ والوقت

Date And Time Default Value

DateAndTime

parameters.defaultValueDateTimeWithBetween

defaultValueDateTimeWithBetween

القيمة الافتراضية لحقل التاريخ والوقت (تعمل مع Between)

Date And Time Default Value (works with Between)

DateAndTime

parameters.defaultValueDateWithBetween

defaultValueDateWithBetween

القيمة الافتراضية لحقل التاريخ (تعمل مع Between)

Date Default Value (works with Between)

Date

parameters.defaultValueTime

defaultValueTime

القيمة الافتراضية لحقل الوقت

Time Default Value

Time

parameters.defaultValueTimeWithBetween

defaultValueTimeWithBetween

القيمة الافتراضية لحقل الوقت (تعمل مع Between)

Time Default Value (works with Between)

Time

parameters.defaultValueWithBetween

defaultValueWithBetween

القيمة الافتراضية (تعمل مع Between)

Default Value (works with Between)

Text

parameters.displayAttachmentAsImage

displayAttachmentAsImage

إظهار المرفق كصورة في التقرير

Display Attachment As Image

Boolean

parameters.displayFieldAs

displayFieldAs

إظهار الرقم كـ

Display Number As

DisplayNumberAs

parameters.displayReferenceAs

displayReferenceAs

إظهار المرجع كـ

Display Reference As

DisplayReferenceAs

parameters.doNotAddLinkToReferences

doNotAddLinkToReferences

عدم إضافة لينك للمرجع

Do Not Add Link To References

Boolean

parameters.englishTitle

englishTitle

العنوان بالإنجليزية

English Title

Text

parameters.fieldId

fieldId

الحقل

On Field

FieldID

parameters.fieldWidth

fieldWidth

العرض

Width

Decimal

parameters.filter

filter

Filter

Filter

BigText

parameters.filterType

filterType

نوع الفلتر

Filter Type

FilterType

parameters.finalHyperLinkExpression

finalHyperLinkExpression

Final Hyper Link Expression

Final Hyper Link Expression

BigText

parameters.finalJasperExpression

finalJasperExpression

Final Jasper Expression

Final Jasper Expression

BigText

parameters.finalSqlExpression

finalSqlExpression

Final Sql Expression

Final Sql Expression

BigText

parameters.generatedParameterName

generatedParameterName

Generated Parameter Name

Generated Parameter Name

Text

parameters.hasTotalInSummary

hasTotalInSummary

تجميع في الإجماليات

Has Total In Summary

Boolean

parameters.hidden

hidden

إخفاء

Hidden

Boolean

parameters.id

id

ID

parameters.layout

layout

طريقة العرض

Layout

FieldLayout

parameters.lineNumber

lineNumber

Integer

parameters.listDisplayType

listDisplayType

نوع عرض القائمة

List Display Type

ListDisplayType

parameters.mainFieldId

mainFieldId

الحقل الرئيسي (في حالة حقل بديل لحقل)

Main Field Id (In Case Alternative Field)

Text

parameters.mergedArabicTitle

mergedArabicTitle

Merged Arabic Title

Merged Arabic Title

Text

parameters.mergedEnglishTitle

mergedEnglishTitle

Merged English Title

Merged English Title

Text

parameters.namaFieldType

namaFieldType

Field Type

Field Type

Text

parameters.namaId

namaId

Nama Id

Nama Id

Text

parameters.paramType

paramType

النوع

Param Type

ParamFieldType

parameters.parameterType

parameterType

نوع المدخل

Parameter Type

ParameterType

parameters.patternField

patternField

Pattern Field

Pattern Field

FieldID

parameters.patternType

patternType

Pattern Type

Pattern Type

PatternType

parameters.refDefaultValue

refDefaultValueActualCode, refDefaultValueCode, refDefaultValueEntityType, refDefaultValueId

القيمة الافتراضية لحقل المرجع

Reference Default Value

Genericreference

parameters.refDefaultValueWithBetween

refDefaultValueWithBetweenActualCode, refDefaultValueWithBetweenCode, refDefaultValueWithBetweenEntityType, refDefaultValueWithBetweenId

القيمة الافتراضية لحقل المرجع (تعمل مع Between)

Reference Default Value (works with Between)

Genericreference

parameters.refEntityType

refEntityType

نوع المرجع

Reference Entity Type

EntityType

parameters.referenceOrderBy

referenceOrderBy

ترتيب المرجع بـ

Reference Order By

ReferenceOrderBy

parameters.required

required

إجبارى

Required

Boolean

parameters.requiredGroup

requiredGroup

Required Group

Required Group

Text

parameters.showAsDateRange

showAsDateRange

عرض كنطاق تاريخ

Show as Date Range

Boolean

parameters.showInsideReport

showInsideReport

إظهار بداخل التقرير

Show Inside Report

Boolean

parameters.showRunningTotalInsteadOfValue

showRunningTotalInsteadOfValue

إظهار الإجمالي الحالي في التفاصيل بدلا من القيمة

Show Running Total Instead Of Value

ShowRunningTotalInsteadOfValue

parameters.showTotalInGroup1Section

showTotalInGroup1Section

Show Total In Group 1 Section

Show Total In Group 1 Section

GroupSection

parameters.showTotalInGroup2Section

showTotalInGroup2Section

Show Total In Group 2 Section

Show Total In Group 2 Section

GroupSection

parameters.showTotalInGroup3Section

showTotalInGroup3Section

Show Total In Group 3 Section

Show Total In Group 3 Section

GroupSection

parameters.showTotalInGroup4Section

showTotalInGroup4Section

Show Total In Group 4 Section

Show Total In Group 4 Section

GroupSection

parameters.showTotalInGroup5Section

showTotalInGroup5Section

Show Total In Group 5 Section

Show Total In Group 5 Section

GroupSection

parameters.sourceParameter

sourceParameter

Source Parameter

Source Parameter

Text

parameters.sourceProperty

sourceProperty

Source Property

Source Property

FieldID

parameters.sqlAggregationType

sqlAggregationType

SQL Aggregation Type

SQL Aggregation Type

SqlAggregationType

parameters.sqlColumns

sqlColumns

Text

parameters.style

style_id

Style

Style

Reference

ReportStyle

parameters.summaryConditionalStyleGrid

summaryConditionalStyleGrid

رقم جدول التنسيق الشرطي للإجماليات

Summary Conditional Style Grid

Integer

parameters.summaryStyle

summaryStyle_id

Summary Style

Summary Style

Reference

ReportStyle

parameters.totalPosition

totalPosition

Total Position

Total Position

TotalPosition

parameters.type

type

النوع

Type

WizardFieldType

parameters.unionHandling

unionHandling

Union Handling

Union Handling

BigText

parameters.useUOMParameterForQtyConversion

useUOMParameterForQtyConversion

استعمال مدخل الوحدة لتحويل الكمية

Use UOM Parameter for Qty Conversion

Boolean

parameters.userAlias

userAlias

User Alias (In Case SQL Expression)

User Alias (In Case SQL Expression)

Text

parameters.widthSize

widthSize

مقاس العرض

Width Size

GridSizeEnum

securityConstraints (Security Constraints - Security Constraints)

Table Name: DataSourceSecurityConstraints, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

securityConstraints.fieldId

fieldId

الحقل

On Field

FieldID

securityConstraints.firstAuthor

firstAuthor

منشئ السجل

First Author

Boolean

securityConstraints.id

id

ID

securityConstraints.lineNumber

lineNumber

Integer

securityConstraints.loginAnalysisSet

loginAnalysisSet

المجموعة التحليلية للدخول

Login Analysis Set

Boolean

securityConstraints.loginBranch

loginBranch

فرع الدخول

Login Branch

Boolean

securityConstraints.loginDepartment

loginDepartment

قسم الدخول

Login Department

Boolean

securityConstraints.loginEmployee

loginEmployee

Login Employee

Login Employee

Boolean

securityConstraints.loginLegalEntity

loginLegalEntity

شركة الدخول

Login Legal Entity

Boolean

securityConstraints.loginSector

loginSector

قطاع الدخول

Login Sector

Boolean

securityConstraints.updateCapability

updateCapability

صلاحية التعديل

Update Capability

Boolean

securityConstraints.usageCapability

usageCapability

صلاحية الاستخدام

Usage Capability

Boolean

securityConstraints.viewCapability

viewCapability

صلاحية المطالعة

View Capability

Boolean

sortFields (حقول الترتيب - Sort Fields)

Table Name: DataSourceSortFieldLine, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

sortFields.arabicTitle

arabicTitle

العنوان بالعربية

Arabic Title

Text

sortFields.barcodeType

barcodeType

نوع الباركود

Barcode Type

BarcodeType

sortFields.conditionalStyleGrid

conditionalStyleGrid

رقم جدول التنسيق الشرطي

Conditional Style Grid

Integer

sortFields.configuration

configuration

Configuration

Configuration

BigText

sortFields.currencyField

currencyField

حقل العملة

Currency Field

FieldID

sortFields.customHyperLinkExpression

customHyperLinkExpression

Custom Hyper Link Expression

Custom Hyper Link Expression

BigText

sortFields.customJasperExpression

customJasperExpression

Custom Jasper Expression

Custom Jasper Expression

BigText

sortFields.customPattern

customPattern

Custom Pattern

Custom Pattern

Text

sortFields.customSqlExpression

customSqlExpression

Custom SQL Expression

Custom SQL Expression

BigText

sortFields.displayAttachmentAsImage

displayAttachmentAsImage

إظهار المرفق كصورة في التقرير

Display Attachment As Image

Boolean

sortFields.displayFieldAs

displayFieldAs

إظهار الرقم كـ

Display Number As

DisplayNumberAs

sortFields.displayReferenceAs

displayReferenceAs

إظهار المرجع كـ

Display Reference As

DisplayReferenceAs

sortFields.doNotAddLinkToReferences

doNotAddLinkToReferences

عدم إضافة لينك للمرجع

Do Not Add Link To References

Boolean

sortFields.englishTitle

englishTitle

العنوان بالإنجليزية

English Title

Text

sortFields.fieldId

fieldId

الحقل

On Field

FieldID

sortFields.fieldWidth

fieldWidth

العرض

Width

Decimal

sortFields.finalHyperLinkExpression

finalHyperLinkExpression

Final Hyper Link Expression

Final Hyper Link Expression

BigText

sortFields.finalJasperExpression

finalJasperExpression

Final Jasper Expression

Final Jasper Expression

BigText

sortFields.finalSqlExpression

finalSqlExpression

Final Sql Expression

Final Sql Expression

BigText

sortFields.hasTotalInSummary

hasTotalInSummary

تجميع في الإجماليات

Has Total In Summary

Boolean

sortFields.hidden

hidden

إخفاء

Hidden

Boolean

sortFields.id

id

ID

sortFields.lineNumber

lineNumber

Integer

sortFields.mainFieldId

mainFieldId

الحقل الرئيسي (في حالة حقل بديل لحقل)

Main Field Id (In Case Alternative Field)

Text

sortFields.mergedArabicTitle

mergedArabicTitle

Merged Arabic Title

Merged Arabic Title

Text

sortFields.mergedEnglishTitle

mergedEnglishTitle

Merged English Title

Merged English Title

Text

sortFields.namaFieldType

namaFieldType

Field Type

Field Type

Text

sortFields.namaId

namaId

Nama Id

Nama Id

Text

sortFields.patternField

patternField

Pattern Field

Pattern Field

FieldID

sortFields.patternType

patternType

Pattern Type

Pattern Type

PatternType

sortFields.referenceOrderBy

referenceOrderBy

ترتيب المرجع بـ

Reference Order By

ReferenceOrderBy

sortFields.showRunningTotalInsteadOfValue

showRunningTotalInsteadOfValue

إظهار الإجمالي الحالي في التفاصيل بدلا من القيمة

Show Running Total Instead Of Value

ShowRunningTotalInsteadOfValue

sortFields.showTotalInGroup1Section

showTotalInGroup1Section

Show Total In Group 1 Section

Show Total In Group 1 Section

GroupSection

sortFields.showTotalInGroup2Section

showTotalInGroup2Section

Show Total In Group 2 Section

Show Total In Group 2 Section

GroupSection

sortFields.showTotalInGroup3Section

showTotalInGroup3Section

Show Total In Group 3 Section

Show Total In Group 3 Section

GroupSection

sortFields.showTotalInGroup4Section

showTotalInGroup4Section

Show Total In Group 4 Section

Show Total In Group 4 Section

GroupSection

sortFields.showTotalInGroup5Section

showTotalInGroup5Section

Show Total In Group 5 Section

Show Total In Group 5 Section

GroupSection

sortFields.sortDirection

sortDirection

اتجاه الترتيب

Sort Direction

SortDirection

sortFields.sqlAggregationType

sqlAggregationType

SQL Aggregation Type

SQL Aggregation Type

SqlAggregationType

sortFields.sqlColumns

sqlColumns

Text

sortFields.style

style_id

Style

Style

Reference

ReportStyle

sortFields.summaryConditionalStyleGrid

summaryConditionalStyleGrid

رقم جدول التنسيق الشرطي للإجماليات

Summary Conditional Style Grid

Integer

sortFields.summaryStyle

summaryStyle_id

Summary Style

Summary Style

Reference

ReportStyle

sortFields.totalPosition

totalPosition

Total Position

Total Position

TotalPosition

sortFields.type

type

النوع

Type

WizardFieldType

sortFields.unionHandling

unionHandling

Union Handling

Union Handling

BigText

sortFields.useUOMParameterForQtyConversion

useUOMParameterForQtyConversion

استعمال مدخل الوحدة لتحويل الكمية

Use UOM Parameter for Qty Conversion

Boolean

sortFields.usedAsDefaultValueToParameterNumber

usedAsDefaultValueToParameterNumber

يستعمل كقيمة افتراضية للمدخل رقم

Used As Default Value To Parameter Number

Integer

sortFields.userAlias

userAlias

User Alias

User Alias

Text

sortFields.widthSize

widthSize

مقاس العرض

Width Size

GridSizeEnum

unionTables (Union Tables - Union Tables)

Table Name: DataSourceUnionTablesLine, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

unionTables.id

id

ID

unionTables.lineNumber

lineNumber

Integer

unionTables.unionTable

unionTable

Union Table

Union Table

FieldID

userAliases (User Aliases - User Aliases)

Table Name: DataSourceUserAliasesLine, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

userAliases.id

id

ID

userAliases.lineNumber

lineNumber

Integer

userAliases.propertyName

propertyName

Property Name

Property Name

Text

userAliases.systemAlias

systemAlias

System Alias

System Alias

Text

userAliases.tableName

tableName

Table Name

Table Name

Text

userAliases.userAlias

userAlias

User Alias

User Alias

Text

whereLines (Where Lines - Where Lines)

Table Name: DataSourceWhereLine, Join Column: dataSource_id

Property

Column

Arabic

English

Type

Foreign Table

whereLines.doNotQuote

doNotQuote

Do Not Quote

Do Not Quote

Boolean

whereLines.id

id

ID

whereLines.lhsFieldId

lhsFieldId

LHS Field Id

LHS Field Id

FieldID

whereLines.lineNumber

lineNumber

Integer

whereLines.operator

operator

المعامل

Operator

FilterType

whereLines.rhsDefaultValueDate

rhsDefaultValueDate

RHS Default Value Date

RHS Default Value Date

Date

whereLines.rhsDefaultValueDateTime

rhsDefaultValueDateTime

RHS Default Value Date Time

RHS Default Value Date Time

DateAndTime

whereLines.rhsDefaultValueDateTimeWithBetween

rhsDefaultValueDateTimeWithBetween

RHS Default Value Date Time (Works with Between)

RHS Default Value Date Time (Works with Between)

DateAndTime

whereLines.rhsDefaultValueDateWithBetween

rhsDefaultValueDateWithBetween

RHS Default Value Date (Works with Between)

RHS Default Value Date (Works with Between)

Date

whereLines.rhsDefaultValueTime

rhsDefaultValueTime

RHS Default Value Time

RHS Default Value Time

Time

whereLines.rhsDefaultValueTimeWithBetween

rhsDefaultValueTimeWithBetween

RHS Default Value Time (Works with Between)

RHS Default Value Time (Works with Between)

Time

whereLines.rhsFieldId

rhsFieldId

RHS Field Id

RHS Field Id

FieldID

whereLines.rhsRefDefaultValue

rhsRefDefaultValueActualCode, rhsRefDefaultValueCode, rhsRefDefaultValueEntityType, rhsRefDefaultValueId

RHS Reference Default Value

RHS Reference Default Value

Genericreference

whereLines.rhsRefDefaultValueWithBetween

rhsRefDefaultValueWithBetweenActualCode, rhsRefDefaultValueWithBetweenCode, rhsRefDefaultValueWithBetweenEntityType, rhsRefDefaultValueWithBetweenId

RHS Reference Default Value (Works with Between)

RHS Reference Default Value (Works with Between)

Genericreference

whereLines.rhsValue

rhsValue

RHS Value

RHS Value

Text

whereLines.rhsValueWithBetween

rhsValueWithBetween

RHS Value (Works with Between)

RHS Value (Works with Between)

Text

whereLines.specialValue

specialValue

Special Value

Special Value

Text