DashBoardWidget

Arabic: عنصر اللوحة - عناصر اللوحة English: DashBoard Widget - DashBoard Widgets

cardMenus (DashboardWidgetCardMenu) , comparisonDataMapping (DashBoardWidgetComparisonMapping) , crossFilterBindings (DashBoardWidgetCrossFilterBinding) , extraTempoColumns (DashboardWidgetFieldTempo) , inputs (DashboardWidgetInput) , params (WidgetParameterLine)

Fields

Property
Column
Arabic
English
Type
Foreign Table
analysisSet
analysisSet_id
المجموعة التحليلية
Analysis set

Reference

AnalysisSet

analysisSetId
analysisSet_id

ID

attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

attachment3
attachment3_id
مرفق 3
Attachment 3

Binary

LargeData

attachment4
attachment4_id
مرفق 4
Attachment 4

Binary

LargeData

attachment5
attachment5_id
مرفق 5
Attachment 5

Binary

LargeData

branch
branch_id
الفرع
Branch

Reference

Branch

branchId
branch_id
Branch ID
Branch ID

ID

chartConfigJSON
chartConfigJSON
Chart Config JSON
Chart Config JSON

BigText

chartTitle
chartTitle
العنوان العربي
Arabic Chart Title

Text

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

dataSource
dataSource
مصدر البيانات
Data Source

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

definition
definition_id
تعريف التقرير
Report Definition

Reference

ReportDefinition

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

enableComparison
enableComparison
تفعيل المقارنة
Enable Comparison

Boolean

englishChartTitle
englishChartTitle
العنوان الإنجليزي
English Chart Title

Text

entitySystemEntryId
entitySystemEntry_id

ID

entityType
entityType
النوع
Entity Type

EntityType

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

horizontalMode
horizontalMode
Horizontal Mode
Horizontal Mode

Boolean

htmlArabic
htmlArabic
HTML Arabic
HTML Arabic

BigText

htmlEnglish
htmlEnglish
HTML English
HTML English

BigText

id
id

ID

implRepo
implRepo_id
كتالوج التجهيز
Implementation Repository

Reference

ImplementationRepository

indexInParent
indexInParent

Integer

lastChangeVersion
lastChangeVersion

Integer

lastModifyTransactionId
LastModifyTransactionId

Text

lastUpdateDate
lastUpdateDate
تاريخ اخر تحديث
Last update Date

DateAndTime

launchType
launchType
طريقة البدء
Launch Type

RepLaunchType

legalEntity
legalEntity_id
الشركة
Legal Entity

Reference

LegalEntity

legalEntityId
legalEntity_id

ID

lockVersion
lockVersion

Integer

mainFile
mainFile_id

Binary

LargeData

mergeComparisonByColumns
mergeComparisonByColumns
دمج نتائج المقارنة حسب الأعمدة (CSV)
Merge Comparison Results By Columns (CSV)

Text

metricsCardConfig.badgePercentColumn
badgePercentColumn
Badge Percent Column
Badge Percent Column

Text

metricsCardConfig.badgePercentTempo
badgePercentTempo
Badge Percent Tempo
Badge Percent Tempo

Text

metricsCardConfig.headerColumnAr
headerColumnAr
Arabic Header Column
Arabic Header Column

Text

metricsCardConfig.headerColumnEn
headerColumnEn
English Header Column
English Header Column

Text

metricsCardConfig.headerTempoAr
headerTempoAr
Arabic Header Tempo
Arabic Header Tempo

BigText

metricsCardConfig.headerTempoEn
headerTempoEn
English Header Tempo
English Header Tempo

BigText

metricsCardConfig.iconCode
iconCode
Icon Code
Icon Code

Text

metricsCardConfig.iconCodeColumn
iconCodeColumn

Text

metricsCardConfig.linkColumn
linkColumn
Link Column
Link Column

Text

metricsCardConfig.linkTempo
linkTempo
Link Tempo
Link Tempo

BigText

metricsCardConfig.numberFormat
numberFormat
صيغة الرقم
صيغة الرقم

Text

metricsCardConfig.subtitleColumnAr
subtitleColumnAr
Arabic Subtitle Column
Arabic Subtitle Column

Text

metricsCardConfig.subtitleColumnEn
subtitleColumnEn
English Subtitle Column
English Subtitle Column

Text

metricsCardConfig.subtitleTempoAr
subtitleTempoAr
Arabic Subtitle Tempo
Arabic Subtitle Tempo

BigText

metricsCardConfig.subtitleTempoEn
subtitleTempoEn
English Subtitle Tempo
English Subtitle Tempo

BigText

metricsCardConfig.suffix
suffix
نهاية التكويد
Suffix

Text

metricsCardConfig.valueColumn
valueColumn
Value Column
Value Column

Text

metricsCardConfig.valueTempo
valueTempo
Value Tempo
Value Tempo

Text

moduleName
moduleName
Module Name
Module Name

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

pdfSample
pdfSample_id
PDF Sample
PDF Sample

Binary

LargeData

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

relatedEntity1
relatedEntity1
السجل المرتبط 1
Related Entity1

Text

relatedEntity2
relatedEntity2
السجل المرتبط 2
Related Entity2

Text

relatedToModule1
relatedToModule1
الموديول المرتبط 1
Related To Module 1

Text

relatedToModule2
relatedToModule2
الموديول المرتبط 2
Related To Module 2

Text

remarks
remark
ملاحظات
Description

BigText

reportMetadataXML
reportMetadataXML

BigText

reviewedAndApproved
reviewedAndApproved
تم مراجعته وإعتماده
Reviewed And Approved

Boolean

reviseLevel
reviseLevel
مستوى المراجعة
Revise Level

ReviseLevel

revised
primitiveValue
تمت المراجعة
Revised

Boolean

revisedBy
revisedBy_id

Reference

NaMaUser

saveToImplRepo
saveToImplRepo
الحفظ في كتالوج التجهيز
Save To Implementation Repository

Boolean

screenshot
screenshot_id
Screenshot
Screenshot

Binary

LargeData

sector
sector_id
القطاع
Sector

Reference

Sector

sectorId
sector_id

ID

systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix

Text

systemReport
systemReport
نظامي
System

Boolean

theme
theme

DashBoardTheme

timelineConfig.actionTypeColumn
actionTypeColumn
Action Type Column
Action Type Column

Text

timelineConfig.actionTypeTempo
actionTypeTempo
Action Type Tempo
Action Type Tempo

BigText

timelineConfig.colorCodeColumn
colorCodeColumn
Color Column
Color Column

Text

timelineConfig.colorCodeTempo
colorCodeTempo
Color Tempo
Color Tempo

BigText

timelineConfig.dateColumn
dateColumn
Date Column
Date Column

Text

timelineConfig.dateTempo
dateTempo
Date Tempo
Date Tempo

BigText

type
type
النوع
Type

DashBoardElementType

updateCapability
updateCapability_id
صلاحية التعديل
Update Capability

Reference

SecurityCapability

updateCapabilityId
updateCapability_id

ID

usageCapability
usageCapability_id
صلاحية الاستخدام
Usage Capability

Reference

SecurityCapability

usageCapabilityId
usageCapability_id

ID

viewCapability
viewCapability_id
صلاحية المطالعة
View Capability

Reference

SecurityCapability

viewCapabilityId
viewCapability_id

ID

wizardDataSource
wizardDataSource_id
Wizard Data Source
Wizard Data Source

Reference

DashBoardWidgetWizard

cardMenus (قائمة بطاقات - Cards Menu)

Table Name: DashboardWidgetCardMenu, Join Column: dashBoardWidget_id

Property
Column
Arabic
English
Type
Foreign Table
cardMenus.color
color
اللون
Color

Color

cardMenus.iconCode
iconCode
Icon Code
Icon Code

Text

cardMenus.id
id

ID

cardMenus.lineNumber
lineNumber

Integer

cardMenus.name1
name1
الاسم العربي
Name1

Text

cardMenus.name2
name2
الاسم الإنجليزي
Name2

Text

cardMenus.target.criteria
criteria_id
المعايير
Criteria

Reference

CriteriaDefinition

cardMenus.target.defaultsTemplate
defaultsTemplate_id
قالب القيم الافتراضية
Default Values Template

Reference

DefaultValuesTemplate

cardMenus.target.extraFieldFilter
extraFieldFilter_id
فلترة الحقول
Extra Field Filter

Reference

UserFieldFilter

cardMenus.target.targetEntity
targetEntity
النوع المستهدف
Target Entity

EntityType

cardMenus.target.targetRecord
targetRecordActualCode, targetRecordCode, targetRecordEntityType, targetRecordId
السجل
Target Record

Genericreference

cardMenus.target.type
type
النوع
Type

MenuTargetType

cardMenus.target.viewName
viewName
معرف الشاشة (اسم ملف العرض)
Layout ID (View name)

Text

comparisonDataMapping (ربط بيانات المقارنة - Comparison Data Mapping)

Table Name: DashBoardWidgetComparisonMapping, Join Column: dashBoardWidget_id

Property
Column
Arabic
English
Type
Foreign Table
comparisonDataMapping.id
id

ID

comparisonDataMapping.lineNumber
lineNumber

Integer

comparisonDataMapping.originalColumn
originalColumn
العمود الأصلي
Original Column

Text

comparisonDataMapping.previousPeriodColumn
previousPeriodColumn
عمود الفترة السابقة
Previous Period Column

Text

crossFilterBindings (ربط الفلاتر التفاعلية - Cross Filter Bindings)

Table Name: DashBoardWidgetCrossFilterBinding, Join Column: dashBoardWidget_id

Property
Column
Arabic
English
Type
Foreign Table
crossFilterBindings.crossFilter
crossFilter_id
الفلتر التفاعلي
Cross Filter

Reference

BICrossFilter

crossFilterBindings.customWhereClause
customWhereClause
شرط مخصص
Custom WHERE Clause

BigText

crossFilterBindings.id
id

ID

crossFilterBindings.lineNumber
lineNumber

Integer

crossFilterBindings.operator
operator
المعامل
Operator

Operator

crossFilterBindings.sqlLeftHandSide
sqlLeftHandSide
عمود SQL الأيسر
SQL Left Hand Side

FieldID

extraTempoColumns (Extra Tempo Columns - Extra Tempo Columns)

Table Name: DashboardWidgetFieldTempo, Join Column: dashBoardWidget_id

Property
Column
Arabic
English
Type
Foreign Table
extraTempoColumns.id
id

ID

extraTempoColumns.lineNumber
lineNumber

Integer

extraTempoColumns.name
name
الاسم
Name

Text

extraTempoColumns.tempoExpression
tempoExpression
Tempo Expression
Tempo Expression

BigText

inputs (المدخلات - Inputs)

Table Name: DashboardWidgetInput, Join Column: dashBoardWidget_id

Property
Column
Arabic
English
Type
Foreign Table
inputs.allowedValues
allowedValues
القيم المسموح بها
Allowed Values

BigText

inputs.arTitle
arTitle
العنوان العربى
Arabic Title

Text

inputs.criteriaExpression
criteriaExpression
Criteria Expression (Filter)
Criteria Expression (Filter)

BigText

inputs.defaultValue
defaultValue
القيمة الافتراضية
Default Value

Text

inputs.enTitle
enTitle
العنوان الإنجليزي
English Title

Text

inputs.id
id

ID

inputs.layout
layout
طريقة العرض
Layout

FieldLayout

inputs.lineNumber
lineNumber

Integer

inputs.listParam
listParam
List (multi-selection)
List (multi-selection)

Boolean

inputs.paramId
paramId
المعرف
Parameter Id

Text

inputs.paramType
paramType
النوع
Param Type

ParamFieldType

inputs.referencedEntityType
referencedEntityType
Referenced Entity Type
Referenced Entity Type

EntityType

inputs.required
required
إجبارى
Required

Boolean

inputs.requiredGroup
requiredGroup
Required Group
Required Group

Text

inputs.sourceParm
sourceParm
Source Paramter
Source Parmter

Text

inputs.sourceProperty
sourceProperty
Source Property
Source Property

Text

params (Parameters - Parameters)

Table Name: WidgetParameterLine, Join Column: dashBoardWidget_id

Property
Column
Arabic
English
Type
Foreign Table
params.id
id

ID

params.lineNumber
lineNumber

Integer

params.parameter
parameter
المدخل
Parameter

Text

params.parameterName
parameterName
المدخل
Parameter

Text

params.tempoExpression
tempoExpression
Tempo Expression
Tempo Expression

BigText