Nama ERP Data ModelNama ERP Data Model
Modules
Search
Namasoft.com
Documentation
GitHub
Modules
Search
Namasoft.com
Documentation
GitHub
  • CRMTroubleTicket

CRMTroubleTicket

Arabic: طلب دعم - طلب دعم English: Trouble Ticket - Trouble Ticket

details1 (CRMTroubleTicketLine1) , details10 (CRMTroubleTicketLine10) , details11 (CRMTroubleTicketLine11) , details12 (CRMTroubleTicketLine12) , details13 (CRMTroubleTicketLine13) , details2 (CRMTroubleTicketLine2) , details3 (CRMTroubleTicketLine3) , details4 (CRMTroubleTicketLine4) , details5 (CRMTroubleTicketLine5) , details6 (CRMTroubleTicketLine6) , details7 (CRMTroubleTicketLine7) , details8 (CRMTroubleTicketLine8) , details9 (CRMTroubleTicketLine9) , employees (TicketEmployeeLine) , executionLines (CRMTroubleTicketExecutionLine) , remakLines (CRMTroubleTicketRemarksLine)

Fields

Property
Column
Arabic
English
Type
Foreign Table
actualFixPeriod.uom
actualFixPeriodUom
الوحدة
Unit

TimePeriodType

actualFixPeriod.value
actualFixPeriodValue
القيمة
Value

Decimal

analysisSet
analysisSet_id
المجموعة التحليلية
Analysis set

Reference

AnalysisSet

analysisSetId
analysisSet_id

ID

applicationLog
applicationLog
ال Log
Application Log

BigText

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

b1
b1
Boolean 1
Boolean 1

Boolean

b10
b10

Boolean

b11
b11

Boolean

b12
b12

Boolean

b13
b13

Boolean

b14
b14

Boolean

b15
b15

Boolean

b16
b16

Boolean

b17
b17

Boolean

b18
b18

Boolean

b19
b19

Boolean

b2
b2
Boolean 2
Boolean 2

Boolean

b20
b20

Boolean

b3
b3
Boolean 3
Boolean 3

Boolean

b4
b4
Boolean 4
Boolean 4

Boolean

b5
b5
Boolean 5
Boolean 5

Boolean

b6
b6

Boolean

b7
b7

Boolean

b8
b8

Boolean

b9
b9

Boolean

book
book_id
الدفتر
Book

Reference

DocumentBook

branch
branch_id
الفرع
Branch

Reference

Branch

branchId
branch_id
Branch ID
Branch ID

ID

cancelledBy
cancelledBy_id
ألغي بواسطة
Cancelled By

Reference

DocumentCancelDocument

closingDate
closingDate
تاريخ الإغلاق
Closed Date

Date

code
code
الكود
Code

Text

colorCode
colorCode
كود اللون
Color Code

Color

commitedBefore
commitedBefore
تم الحفظ مسبقا
Commited Before

Boolean

complaint
complaint_id
الشكوي - الإقتراح
Complaint

Reference

CRMComplaint

contact.address.address1
contactAddressAddress1
عنوان 1
Address 1

Text

contact.address.address2
contactAddressAddress2
رقم المبني
Building Number

Text

contact.address.area
contactAddressArea
المنطقة
Area

Text

contact.address.buildingNumber
contactAddressBuildingNumber
رقم المبني
Building Number

Text

contact.address.city
contactAddressCity
المدينة
City

Text

contact.address.country
contactAddressCountry
الدولة
Country

Text

contact.address.countryCode
contactAddressCountryCode
كود الدولة
Country Code

Text

contact.address.district
contactAddressDistrict
الحي
District

Text

contact.address.landPlotNumber
contactAddressLandPlotNumber
رقم تعريفي للأرض
Land Plot Number

Text

contact.address.mapLocation
contactAddressMapLocation
الموقع على الخريطة
Map Location

LatLng

contact.address.postalCode
contactAddressPostalCode
الكود البريدي
Postal Code

Text

contact.address.region
contactAddressRegion_id
موقع جغرافي
Address region

Reference

AddressRegion

contact.address.state
contactAddressState
المحافظة
State

Text

contact.address.street
contactAddressStreet
شارع
Street

Text

contact.email
contactEmail
إيميل
E-mail

Email

contact.faxNumber
contactFaxNumber
الفاكس
Fax

PhoneNumber

contact.mobile
contactMobile
الموبايل
Mobile

PhoneNumber

contact.telephone1
contactTelephone1
تليفون 1
Phone 1

PhoneNumber

contact.telephone2
contactTelephone2
تليفون 2
Phone 2

PhoneNumber

contact.website
contactWebsite
موقع الكتروني
Website

Text

coveringDocID
coveringDocID

ID

createTransactionId
createTransactionId

Text

creationDate
creationDate
تاريخ الإنشاء
Creation Date

DateAndTime

currentApprovalCase
currentApprovalCase_id

ApprovalCase

currentVersion
currentVersion
النسخة الحالية
Current Version

Integer

customViewName
customViewName

Text

customer
customer_id
العميل
Customer

Reference

Customer

customerContact
customerContact_id
معلومات الاتصال بالعميل
Customer Contact

Reference

Contact

date1
date1
تـــاريخ 1
Date 1

Date

date10
date10
تاريخ 10
Date10

Date

date11
date11
تاريخ 11
Date11

Date

date12
date12
تاريخ 12
Date12

Date

date13
date13

Date

date14
date14

Date

date15
date15

Date

date16
date16

Date

date17
date17

Date

date18
date18

Date

date19
date19

Date

date2
date2
تـــاريخ 2
Date 2

Date

date20
date20

Date

date3
date3
تاريخ 3
Date3

Date

date4
date4
تاريخ 4
Date4

Date

date5
date5
تاريخ 5
Date5

Date

date6
date6
تاريخ 6
Date6

Date

date7
date7
تاريخ 7
Date7

Date

date8
date8
تاريخ 8
Date8

Date

date9
date9
تاريخ 9
Date9

Date

department
department_id
الإدارة
Department

Reference

Department

departmentId
department_id

ID

description1
description1
الوصف 1
description1

Text

description10
description10
الوصف 10
description 10

Text

description11
description11
الوصف 11
description 11

Text

description12
description12
الوصف 12
description 12

Text

description13
description13
الوصف 13
description 13

Text

description14
description14
الوصف 14
description 14

Text

description15
description15
الوصف 15
description 15

Text

description16
description16
الوصف 16

Text

description17
description17
الوصف 17

Text

description18
description18
الوصف 18

Text

description19
description19
الوصف 19

Text

description2
description2
الوصف 2
description2

Text

description20
description20
الوصف 20

Text

description21
description21
الوصف 21

Text

description22
description22
الوصف 22

Text

description23
description23
الوصف 23

Text

description24
description24
الوصف 24

Text

description25
description25
الوصف 25

Text

description26
description26
الوصف 26

Text

description27
description27
الوصف 27

Text

description28
description28
الوصف 28

Text

description29
description29
الوصف 29

Text

description3
description3
الوصف 3
description3

Text

description30
description30
الوصف 30

Text

description4
description4
الوصف 4
description4

Text

description5
description5
الوصف 5
description5

Text

description6
description6
الوصف 6
description 6

Text

description7
description7
الوصف 7
description 7

Text

description8
description8
الوصف 8
description 8

Text

description9
description9
الوصف 9
description 9

Text

developmentRequest
developmentRequest_id
طلب تطوير
development request

Reference

CRMDevelopmentRequest

dimensionsHistoryXml
dimensionsHistoryXml

BigText

discussion1
discussion1
نقاش 1
Discussion 1

BigText

discussion10
discussion10
نقاش 10
Discussion 10

BigText

discussion11
discussion11
نقاش 11
Discussion 11

BigText

discussion12
discussion12
نقاش 12
Discussion 12

BigText

discussion13
discussion13
نقاش 13
Discussion 13

BigText

discussion14
discussion14
نقاش 14
Discussion 14

BigText

discussion15
discussion15
نقاش 15
Discussion 15

BigText

discussion16
discussion16
نقاش 16
Discussion 16

BigText

discussion17
discussion17
نقاش 17
Discussion 17

BigText

discussion18
discussion18
نقاش 18
Discussion 18

BigText

discussion19
discussion19
نقاش 19
Discussion 19

BigText

discussion2
discussion2
نقاش 2
Discussion 2

BigText

discussion20
discussion20
نقاش 20
Discussion 20

BigText

discussion3
discussion3
نقاش 3
Discussion 3

BigText

discussion4
discussion4
نقاش 4
Discussion 4

BigText

discussion5
discussion5
نقاش 5
Discussion 5

BigText

discussion6
discussion6
نقاش 6
Discussion 6

BigText

discussion7
discussion7
نقاش 7
Discussion 7

BigText

discussion8
discussion8
نقاش 8
Discussion 8

BigText

discussion9
discussion9
نقاش 9
Discussion 9

BigText

docCategory
docCategory_id
تصنيف الدعم
Document category

Reference

DocCategory

documentFileStatus
documentFileStatus
حالة المستند
Document File Status

DocumentFileStatus

draftCreated
draftCreated
تم إنشاء مسودة
Draft Created

Boolean

draftXML
draftXML

BigText

editedBy
editedBy_id
بواسطة
Edited By

Reference

NaMaUser

empDiscussion1
empDiscussion1_id
نقاش 1
Discussion 1

Reference

NaMaUser

empDiscussion10
empDiscussion10_id
نقاش 10
Discussion 10

Reference

NaMaUser

empDiscussion11
empDiscussion11_id
نقاش 11
Discussion 11

Reference

NaMaUser

empDiscussion12
empDiscussion12_id
نقاش 12
Discussion 12

Reference

NaMaUser

empDiscussion13
empDiscussion13_id
نقاش 13
Discussion 13

Reference

NaMaUser

empDiscussion14
empDiscussion14_id
نقاش 14
Discussion 14

Reference

NaMaUser

empDiscussion15
empDiscussion15_id
نقاش 15
Discussion 15

Reference

NaMaUser

empDiscussion16
empDiscussion16_id
نقاش 16
Discussion 16

Reference

NaMaUser

empDiscussion17
empDiscussion17_id
نقاش 17
Discussion 17

Reference

NaMaUser

empDiscussion18
empDiscussion18_id
نقاش 18
Discussion 18

Reference

NaMaUser

empDiscussion19
empDiscussion19_id
نقاش 19
Discussion 19

Reference

NaMaUser

empDiscussion2
empDiscussion2_id
نقاش 2
Discussion 2

Reference

NaMaUser

empDiscussion20
empDiscussion20_id
نقاش 20
Discussion 20

Reference

NaMaUser

empDiscussion3
empDiscussion3_id
نقاش 3
Discussion 3

Reference

NaMaUser

empDiscussion4
empDiscussion4_id
نقاش 4
Discussion 4

Reference

NaMaUser

empDiscussion5
empDiscussion5_id
نقاش 5
Discussion 5

Reference

NaMaUser

empDiscussion6
empDiscussion6_id
نقاش 6
Discussion 6

Reference

NaMaUser

empDiscussion7
empDiscussion7_id
نقاش 7
Discussion 7

Reference

NaMaUser

empDiscussion8
empDiscussion8_id
نقاش 8
Discussion 8

Reference

NaMaUser

empDiscussion9
empDiscussion9_id
نقاش 9
Discussion 9

Reference

NaMaUser

empIDs
empIDs

Text

entitySystemEntryId
entitySystemEntry_id

ID

entityType
entityType
النوع
Entity Type

EntityType

errorMessage
errorMessage
رسالة الخطأ
Error Message

BigText

escaletedTo
escaletedTo_id
تصعيد الي
escaleted to

Reference

Employee

estimatedFixPeriod.uom
estimatedFixPeriodUom
الوحدة
Unit

TimePeriodType

estimatedFixPeriod.value
estimatedFixPeriodValue
القيمة
Value

Decimal

expectedExecutionDate
expectedExecutionDate
تاريخ التنفيذ المتوقع
Expected Execution Date

Date

externalResponsible
externalResponsibleActualCode, externalResponsibleCode, externalResponsibleEntityType, externalResponsibleId
الجهة الخارجية المسند إليها
External Responsible

Genericreference

firstAuthor
firstAuthor_id
منشئ السجل
First Author

Reference

NaMaUser

firstAuthorId
firstAuthor_id

ID

fiscalPeriod
fiscalPeriod_id
الفترة
Fiscal Period

Reference

FiscalPeriod

fiscalYear
fiscalYear_id
السنة المالية
Fiscal Year

Reference

FiscalYear

fromDoc
fromDoc_ActualCode, fromDoc_Code, fromDoc_type, fromDoc_id
بناءا على
From Document

Genericreference

fromDocsCount
fromDocsCount
عدد سندات بناء على
From Docs Count

Integer

generatedByLine
generatedByLine
كود سطر الإنشاء
generated By Line

Text

generatedDocsCount
generatedDocsCount

Integer

generatedFrom
generatedFromActualCode, generatedFromCode, generatedFromEntityType, generatedFromId
تم إنشاؤه من
Generated From

Genericreference

generationType
generationType
نوع الإنشاء
Generation Type

GenerationType

id
id

ID

indexInParent
indexInParent

Integer

issueDate
issueDate
تاريخ التحرير
Issue Date

Date

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

manualRef1
manualRef1
رقم المستند اليدوي
Manual Ref1

Text

mediator
mediator_id
الوسيط
Mediator

Reference

CRMMediator

n1
n1
رقم 1
Number 1

Decimal

n10
n10
رقم 10
Number 10

Decimal

n11
n11
رقم 11
Number 11

Decimal

n12
n12
رقم 12
Number 12

Decimal

n13
n13
رقم 13
Number 13

Decimal

n14
n14
رقم 14
Number 14

Decimal

n15
n15
رقم 15
Number 15

Decimal

n16
n16
رقم 16
Number 16

Decimal

n17
n17
رقم 17
Number 17

Decimal

n18
n18
رقم 18
Number 18

Decimal

n19
n19
رقم 19
Number 19

Decimal

n2
n2
رقم 2
Number 2

Decimal

n20
n20
رقم 20
Number 20

Decimal

n3
n3
رقم 3
Number 3

Decimal

n4
n4
رقم 4
Number 4

Decimal

n5
n5
رقم 5
Number 5

Decimal

n6
n6
رقم 6
Number 6

Decimal

n7
n7
رقم 7
Number 7

Decimal

n8
n8
رقم 8
Number 8

Decimal

n9
n9
رقم 9
Number 9

Decimal

openShift
openShift_id
فتح وردية
Open Shift

Reference

CSHOpenShift

parentCode
parentCode

Text

preventUsage
preventUsage
منع الاستعمال
Prevent Usage

Boolean

preventUseAsFromDoc
preventUseAsFromDoc

Boolean

printCount
printCount
عدد مرات الطباعة
Print Count

Integer

product
productActualCode, productCode, productEntityType, productId
المنتج
Product

Genericreference

purged
purged
Purged
Purged

Boolean

rbook
rbook_id
دفتر الايصالات
Receipt Book

Reference

ReceiptBook

ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id

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

ref6
ref6ActualCode, ref6Code, ref6EntityType, ref6Id
مرجع 6
Reference 6

Genericreference

ref7
ref7ActualCode, ref7Code, ref7EntityType, ref7Id
مرجع 7
Reference 7

Genericreference

ref8
ref8ActualCode, ref8Code, ref8EntityType, ref8Id

Genericreference

ref9
ref9ActualCode, ref9Code, ref9EntityType, ref9Id

Genericreference

relatedTo1
relatedTo1ActualCode, relatedTo1Code, relatedTo1EntityType, relatedTo1Id
مرتبط ب1
Related to 1

Genericreference

relatedTo2
relatedTo2ActualCode, relatedTo2Code, relatedTo2EntityType, relatedTo2Id
مرتبط ب2
Related to 2

Genericreference

relativeWeight
relativeWeight
الوزن النسبى
Relative weight

Text

remark1
remark1

BigText

remark10
remark10

BigText

remark11
remark11

BigText

remark12
remark12

BigText

remark13
remark13

BigText

remark14
remark14

BigText

remark15
remark15

BigText

remark16
remark16

BigText

remark17
remark17

BigText

remark18
remark18

BigText

remark19
remark19

BigText

remark2
remark2

BigText

remark20
remark20

BigText

remark3
remark3

BigText

remark4
remark4

BigText

remark5
remark5

BigText

remark6
remark6

BigText

remark7
remark7

BigText

remark8
remark8

BigText

remark9
remark9

BigText

remarks
remark
الوصف
Description

BigText

responsible
responsible_id
الموظف المسئول
Responsible Employee

Reference

Employee

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

ReviseLevel

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

Boolean

revisedBy
revisedBy_id

Reference

NaMaUser

rpaper
rpaper_id
الايصال
Receipt Paper

Reference

ReceiptPaper

sector
sector_id
القطاع
Sector

Reference

Sector

sectorId
sector_id

ID

serialNumber
serialNumber
الرقم المسلسل
Serial Number

BigText

status
status
الحالة
Status

TicketStatus

techSupportRemarks
techSupportRemarks
ملاحظات الدعم الفني
Tech Support Remarks

BigText

term
term_id
توجيه المستند
Term

Reference

DocumentTerm

termConfigXml
termConfigXml

BigText

theSeverity
theSeverity
مستوي الصعوبة
Severity

TicketSeverity

ticketDate
ticketDate
تاريخ الطلب
Ticket Date

Date

ticketType
ticketType
نوع التذكرة
Ticket Type

TicketType

timeDiscussion1
timeDiscussion1
تاريخ نقاش 1
Discussion Date 1

DateAndTime

timeDiscussion10
timeDiscussion10
تاريخ نقاش 10
Discussion Date 10

DateAndTime

timeDiscussion11
timeDiscussion11
تاريخ نقاش 11
Discussion Date 11

DateAndTime

timeDiscussion12
timeDiscussion12
تاريخ نقاش 12
Discussion Date 12

DateAndTime

timeDiscussion13
timeDiscussion13
تاريخ نقاش 13
Discussion Date 13

DateAndTime

timeDiscussion14
timeDiscussion14
تاريخ نقاش 14
Discussion Date 14

DateAndTime

timeDiscussion15
timeDiscussion15
تاريخ نقاش 15
Discussion Date 15

DateAndTime

timeDiscussion16
timeDiscussion16
تاريخ نقاش 16
Discussion Date 16

DateAndTime

timeDiscussion17
timeDiscussion17
تاريخ نقاش 17
Discussion Date 17

DateAndTime

timeDiscussion18
timeDiscussion18
تاريخ نقاش 18
Discussion Date 18

DateAndTime

timeDiscussion19
timeDiscussion19
تاريخ نقاش 19
Discussion Date 19

DateAndTime

timeDiscussion2
timeDiscussion2
تاريخ نقاش 2
Discussion Date 2

DateAndTime

timeDiscussion20
timeDiscussion20
تاريخ نقاش 20
Discussion Date 20

DateAndTime

timeDiscussion3
timeDiscussion3
تاريخ نقاش 3
Discussion Date 3

DateAndTime

timeDiscussion4
timeDiscussion4
تاريخ نقاش 4
Discussion Date 4

DateAndTime

timeDiscussion5
timeDiscussion5
تاريخ نقاش 5
Discussion Date 5

DateAndTime

timeDiscussion6
timeDiscussion6
تاريخ نقاش 6
Discussion Date 6

DateAndTime

timeDiscussion7
timeDiscussion7
تاريخ نقاش 7
Discussion Date 7

DateAndTime

timeDiscussion8
timeDiscussion8
تاريخ نقاش 8
Discussion Date 8

DateAndTime

timeDiscussion9
timeDiscussion9
تاريخ نقاش 9
Discussion Date 9

DateAndTime

totalExecutionTime
totalExecutionTime
إجمالي وقت التنفيذ
Total Execution Time

Decimal

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

Reference

SecurityCapability

updateCapabilityId
updateCapability_id

ID

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

Reference

SecurityCapability

usageCapabilityId
usageCapability_id

ID

userComplaint
userComplaint_id

Reference

CRMComplaint

userStatus
userStatus

TicketStatus

valueDate
valueDate
التاريخ الفعلي
Value Date

Date

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

Reference

SecurityCapability

viewCapabilityId
viewCapability_id

ID

details1 ( - )

Table Name: CRMTroubleTicketLine1, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details1.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details1.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details1.b1
b1
Boolean 1
Boolean 1

Boolean

details1.b2
b2
Boolean 2
Boolean 2

Boolean

details1.b3
b3
Boolean 3
Boolean 3

Boolean

details1.b4
b4
Boolean 4
Boolean 4

Boolean

details1.b5
b5
Boolean 5
Boolean 5

Boolean

details1.date1
date1
تـــاريخ 1
Date 1

Date

details1.date2
date2
تـــاريخ 2
Date 2

Date

details1.date3
date3
تاريخ 3
Date3

Date

details1.date4
date4
تاريخ 4
Date4

Date

details1.date5
date5
تاريخ 5
Date5

Date

details1.description1
description1
الوصف 1
description1

Text

details1.description10
description10
الوصف 10
description 10

Text

details1.description2
description2
الوصف 2
description2

Text

details1.description3
description3
الوصف 3
description3

Text

details1.description4
description4
الوصف 4
description4

Text

details1.description5
description5
الوصف 5
description5

Text

details1.description6
description6
الوصف 6
description 6

Text

details1.description7
description7
الوصف 7
description 7

Text

details1.description8
description8
الوصف 8
description 8

Text

details1.description9
description9
الوصف 9
description 9

Text

details1.id
id

ID

details1.lineNumber
lineNumber

Integer

details1.n1
n1
رقم 1
Number 1

Decimal

details1.n2
n2
رقم 2
Number 2

Decimal

details1.n3
n3
رقم 3
Number 3

Decimal

details1.n4
n4
رقم 4
Number 4

Decimal

details1.n5
n5
رقم 5
Number 5

Decimal

details1.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details1.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details1.remark1
remark1

BigText

details1.remark2
remark2

BigText

details10 ( - )

Table Name: CRMTroubleTicketLine10, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details10.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details10.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details10.b1
b1
Boolean 1
Boolean 1

Boolean

details10.b2
b2
Boolean 2
Boolean 2

Boolean

details10.b3
b3
Boolean 3
Boolean 3

Boolean

details10.b4
b4
Boolean 4
Boolean 4

Boolean

details10.b5
b5
Boolean 5
Boolean 5

Boolean

details10.date1
date1
تـــاريخ 1
Date 1

Date

details10.date2
date2
تـــاريخ 2
Date 2

Date

details10.date3
date3
تاريخ 3
Date3

Date

details10.date4
date4
تاريخ 4
Date4

Date

details10.date5
date5
تاريخ 5
Date5

Date

details10.description1
description1
الوصف 1
description1

Text

details10.description10
description10
الوصف 10
description 10

Text

details10.description2
description2
الوصف 2
description2

Text

details10.description3
description3
الوصف 3
description3

Text

details10.description4
description4
الوصف 4
description4

Text

details10.description5
description5
الوصف 5
description5

Text

details10.description6
description6
الوصف 6
description 6

Text

details10.description7
description7
الوصف 7
description 7

Text

details10.description8
description8
الوصف 8
description 8

Text

details10.description9
description9
الوصف 9
description 9

Text

details10.id
id

ID

details10.lineNumber
lineNumber

Integer

details10.n1
n1
رقم 1
Number 1

Decimal

details10.n2
n2
رقم 2
Number 2

Decimal

details10.n3
n3
رقم 3
Number 3

Decimal

details10.n4
n4
رقم 4
Number 4

Decimal

details10.n5
n5
رقم 5
Number 5

Decimal

details10.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details10.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details10.remark1
remark1

BigText

details10.remark2
remark2

BigText

details11 ( - )

Table Name: CRMTroubleTicketLine11, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details11.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details11.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details11.b1
b1
Boolean 1
Boolean 1

Boolean

details11.b2
b2
Boolean 2
Boolean 2

Boolean

details11.b3
b3
Boolean 3
Boolean 3

Boolean

details11.b4
b4
Boolean 4
Boolean 4

Boolean

details11.b5
b5
Boolean 5
Boolean 5

Boolean

details11.date1
date1
تـــاريخ 1
Date 1

Date

details11.date2
date2
تـــاريخ 2
Date 2

Date

details11.date3
date3
تاريخ 3
Date3

Date

details11.date4
date4
تاريخ 4
Date4

Date

details11.date5
date5
تاريخ 5
Date5

Date

details11.description1
description1
الوصف 1
description1

Text

details11.description10
description10
الوصف 10
description 10

Text

details11.description2
description2
الوصف 2
description2

Text

details11.description3
description3
الوصف 3
description3

Text

details11.description4
description4
الوصف 4
description4

Text

details11.description5
description5
الوصف 5
description5

Text

details11.description6
description6
الوصف 6
description 6

Text

details11.description7
description7
الوصف 7
description 7

Text

details11.description8
description8
الوصف 8
description 8

Text

details11.description9
description9
الوصف 9
description 9

Text

details11.id
id

ID

details11.lineNumber
lineNumber

Integer

details11.n1
n1
رقم 1
Number 1

Decimal

details11.n2
n2
رقم 2
Number 2

Decimal

details11.n3
n3
رقم 3
Number 3

Decimal

details11.n4
n4
رقم 4
Number 4

Decimal

details11.n5
n5
رقم 5
Number 5

Decimal

details11.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details11.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details11.remark1
remark1

BigText

details11.remark2
remark2

BigText

details12 ( - )

Table Name: CRMTroubleTicketLine12, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details12.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details12.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details12.b1
b1
Boolean 1
Boolean 1

Boolean

details12.b2
b2
Boolean 2
Boolean 2

Boolean

details12.b3
b3
Boolean 3
Boolean 3

Boolean

details12.b4
b4
Boolean 4
Boolean 4

Boolean

details12.b5
b5
Boolean 5
Boolean 5

Boolean

details12.date1
date1
تـــاريخ 1
Date 1

Date

details12.date2
date2
تـــاريخ 2
Date 2

Date

details12.date3
date3
تاريخ 3
Date3

Date

details12.date4
date4
تاريخ 4
Date4

Date

details12.date5
date5
تاريخ 5
Date5

Date

details12.description1
description1
الوصف 1
description1

Text

details12.description10
description10
الوصف 10
description 10

Text

details12.description2
description2
الوصف 2
description2

Text

details12.description3
description3
الوصف 3
description3

Text

details12.description4
description4
الوصف 4
description4

Text

details12.description5
description5
الوصف 5
description5

Text

details12.description6
description6
الوصف 6
description 6

Text

details12.description7
description7
الوصف 7
description 7

Text

details12.description8
description8
الوصف 8
description 8

Text

details12.description9
description9
الوصف 9
description 9

Text

details12.id
id

ID

details12.lineNumber
lineNumber

Integer

details12.n1
n1
رقم 1
Number 1

Decimal

details12.n2
n2
رقم 2
Number 2

Decimal

details12.n3
n3
رقم 3
Number 3

Decimal

details12.n4
n4
رقم 4
Number 4

Decimal

details12.n5
n5
رقم 5
Number 5

Decimal

details12.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details12.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details12.remark1
remark1

BigText

details12.remark2
remark2

BigText

details13 ( - )

Table Name: CRMTroubleTicketLine13, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details13.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details13.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details13.b1
b1
Boolean 1
Boolean 1

Boolean

details13.b2
b2
Boolean 2
Boolean 2

Boolean

details13.b3
b3
Boolean 3
Boolean 3

Boolean

details13.b4
b4
Boolean 4
Boolean 4

Boolean

details13.b5
b5
Boolean 5
Boolean 5

Boolean

details13.date1
date1
تـــاريخ 1
Date 1

Date

details13.date2
date2
تـــاريخ 2
Date 2

Date

details13.date3
date3
تاريخ 3
Date3

Date

details13.date4
date4
تاريخ 4
Date4

Date

details13.date5
date5
تاريخ 5
Date5

Date

details13.description1
description1
الوصف 1
description1

Text

details13.description10
description10
الوصف 10
description 10

Text

details13.description2
description2
الوصف 2
description2

Text

details13.description3
description3
الوصف 3
description3

Text

details13.description4
description4
الوصف 4
description4

Text

details13.description5
description5
الوصف 5
description5

Text

details13.description6
description6
الوصف 6
description 6

Text

details13.description7
description7
الوصف 7
description 7

Text

details13.description8
description8
الوصف 8
description 8

Text

details13.description9
description9
الوصف 9
description 9

Text

details13.id
id

ID

details13.lineNumber
lineNumber

Integer

details13.n1
n1
رقم 1
Number 1

Decimal

details13.n2
n2
رقم 2
Number 2

Decimal

details13.n3
n3
رقم 3
Number 3

Decimal

details13.n4
n4
رقم 4
Number 4

Decimal

details13.n5
n5
رقم 5
Number 5

Decimal

details13.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details13.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details13.remark1
remark1

BigText

details13.remark2
remark2

BigText

details2 ( - )

Table Name: CRMTroubleTicketLine2, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details2.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details2.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details2.b1
b1
Boolean 1
Boolean 1

Boolean

details2.b2
b2
Boolean 2
Boolean 2

Boolean

details2.b3
b3
Boolean 3
Boolean 3

Boolean

details2.b4
b4
Boolean 4
Boolean 4

Boolean

details2.b5
b5
Boolean 5
Boolean 5

Boolean

details2.date1
date1
تـــاريخ 1
Date 1

Date

details2.date2
date2
تـــاريخ 2
Date 2

Date

details2.date3
date3
تاريخ 3
Date3

Date

details2.date4
date4
تاريخ 4
Date4

Date

details2.date5
date5
تاريخ 5
Date5

Date

details2.description1
description1
الوصف 1
description1

Text

details2.description10
description10
الوصف 10
description 10

Text

details2.description2
description2
الوصف 2
description2

Text

details2.description3
description3
الوصف 3
description3

Text

details2.description4
description4
الوصف 4
description4

Text

details2.description5
description5
الوصف 5
description5

Text

details2.description6
description6
الوصف 6
description 6

Text

details2.description7
description7
الوصف 7
description 7

Text

details2.description8
description8
الوصف 8
description 8

Text

details2.description9
description9
الوصف 9
description 9

Text

details2.id
id

ID

details2.lineNumber
lineNumber

Integer

details2.n1
n1
رقم 1
Number 1

Decimal

details2.n2
n2
رقم 2
Number 2

Decimal

details2.n3
n3
رقم 3
Number 3

Decimal

details2.n4
n4
رقم 4
Number 4

Decimal

details2.n5
n5
رقم 5
Number 5

Decimal

details2.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details2.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details2.remark1
remark1

BigText

details2.remark2
remark2

BigText

details3 ( - )

Table Name: CRMTroubleTicketLine3, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details3.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details3.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details3.b1
b1
Boolean 1
Boolean 1

Boolean

details3.b2
b2
Boolean 2
Boolean 2

Boolean

details3.b3
b3
Boolean 3
Boolean 3

Boolean

details3.b4
b4
Boolean 4
Boolean 4

Boolean

details3.b5
b5
Boolean 5
Boolean 5

Boolean

details3.date1
date1
تـــاريخ 1
Date 1

Date

details3.date2
date2
تـــاريخ 2
Date 2

Date

details3.date3
date3
تاريخ 3
Date3

Date

details3.date4
date4
تاريخ 4
Date4

Date

details3.date5
date5
تاريخ 5
Date5

Date

details3.description1
description1
الوصف 1
description1

Text

details3.description10
description10
الوصف 10
description 10

Text

details3.description2
description2
الوصف 2
description2

Text

details3.description3
description3
الوصف 3
description3

Text

details3.description4
description4
الوصف 4
description4

Text

details3.description5
description5
الوصف 5
description5

Text

details3.description6
description6
الوصف 6
description 6

Text

details3.description7
description7
الوصف 7
description 7

Text

details3.description8
description8
الوصف 8
description 8

Text

details3.description9
description9
الوصف 9
description 9

Text

details3.id
id

ID

details3.lineNumber
lineNumber

Integer

details3.n1
n1
رقم 1
Number 1

Decimal

details3.n2
n2
رقم 2
Number 2

Decimal

details3.n3
n3
رقم 3
Number 3

Decimal

details3.n4
n4
رقم 4
Number 4

Decimal

details3.n5
n5
رقم 5
Number 5

Decimal

details3.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details3.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details3.remark1
remark1

BigText

details3.remark2
remark2

BigText

details4 ( - )

Table Name: CRMTroubleTicketLine4, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details4.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details4.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details4.b1
b1
Boolean 1
Boolean 1

Boolean

details4.b2
b2
Boolean 2
Boolean 2

Boolean

details4.b3
b3
Boolean 3
Boolean 3

Boolean

details4.b4
b4
Boolean 4
Boolean 4

Boolean

details4.b5
b5
Boolean 5
Boolean 5

Boolean

details4.date1
date1
تـــاريخ 1
Date 1

Date

details4.date2
date2
تـــاريخ 2
Date 2

Date

details4.date3
date3
تاريخ 3
Date3

Date

details4.date4
date4
تاريخ 4
Date4

Date

details4.date5
date5
تاريخ 5
Date5

Date

details4.description1
description1
الوصف 1
description1

Text

details4.description10
description10
الوصف 10
description 10

Text

details4.description2
description2
الوصف 2
description2

Text

details4.description3
description3
الوصف 3
description3

Text

details4.description4
description4
الوصف 4
description4

Text

details4.description5
description5
الوصف 5
description5

Text

details4.description6
description6
الوصف 6
description 6

Text

details4.description7
description7
الوصف 7
description 7

Text

details4.description8
description8
الوصف 8
description 8

Text

details4.description9
description9
الوصف 9
description 9

Text

details4.id
id

ID

details4.lineNumber
lineNumber

Integer

details4.n1
n1
رقم 1
Number 1

Decimal

details4.n2
n2
رقم 2
Number 2

Decimal

details4.n3
n3
رقم 3
Number 3

Decimal

details4.n4
n4
رقم 4
Number 4

Decimal

details4.n5
n5
رقم 5
Number 5

Decimal

details4.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details4.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details4.remark1
remark1

BigText

details4.remark2
remark2

BigText

details5 ( - )

Table Name: CRMTroubleTicketLine5, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details5.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details5.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details5.b1
b1
Boolean 1
Boolean 1

Boolean

details5.b2
b2
Boolean 2
Boolean 2

Boolean

details5.b3
b3
Boolean 3
Boolean 3

Boolean

details5.b4
b4
Boolean 4
Boolean 4

Boolean

details5.b5
b5
Boolean 5
Boolean 5

Boolean

details5.date1
date1
تـــاريخ 1
Date 1

Date

details5.date2
date2
تـــاريخ 2
Date 2

Date

details5.date3
date3
تاريخ 3
Date3

Date

details5.date4
date4
تاريخ 4
Date4

Date

details5.date5
date5
تاريخ 5
Date5

Date

details5.description1
description1
الوصف 1
description1

Text

details5.description10
description10
الوصف 10
description 10

Text

details5.description2
description2
الوصف 2
description2

Text

details5.description3
description3
الوصف 3
description3

Text

details5.description4
description4
الوصف 4
description4

Text

details5.description5
description5
الوصف 5
description5

Text

details5.description6
description6
الوصف 6
description 6

Text

details5.description7
description7
الوصف 7
description 7

Text

details5.description8
description8
الوصف 8
description 8

Text

details5.description9
description9
الوصف 9
description 9

Text

details5.id
id

ID

details5.lineNumber
lineNumber

Integer

details5.n1
n1
رقم 1
Number 1

Decimal

details5.n2
n2
رقم 2
Number 2

Decimal

details5.n3
n3
رقم 3
Number 3

Decimal

details5.n4
n4
رقم 4
Number 4

Decimal

details5.n5
n5
رقم 5
Number 5

Decimal

details5.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details5.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details5.remark1
remark1

BigText

details5.remark2
remark2

BigText

details6 ( - )

Table Name: CRMTroubleTicketLine6, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details6.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details6.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details6.b1
b1
Boolean 1
Boolean 1

Boolean

details6.b2
b2
Boolean 2
Boolean 2

Boolean

details6.b3
b3
Boolean 3
Boolean 3

Boolean

details6.b4
b4
Boolean 4
Boolean 4

Boolean

details6.b5
b5
Boolean 5
Boolean 5

Boolean

details6.date1
date1
تـــاريخ 1
Date 1

Date

details6.date2
date2
تـــاريخ 2
Date 2

Date

details6.date3
date3
تاريخ 3
Date3

Date

details6.date4
date4
تاريخ 4
Date4

Date

details6.date5
date5
تاريخ 5
Date5

Date

details6.description1
description1
الوصف 1
description1

Text

details6.description10
description10
الوصف 10
description 10

Text

details6.description2
description2
الوصف 2
description2

Text

details6.description3
description3
الوصف 3
description3

Text

details6.description4
description4
الوصف 4
description4

Text

details6.description5
description5
الوصف 5
description5

Text

details6.description6
description6
الوصف 6
description 6

Text

details6.description7
description7
الوصف 7
description 7

Text

details6.description8
description8
الوصف 8
description 8

Text

details6.description9
description9
الوصف 9
description 9

Text

details6.id
id

ID

details6.lineNumber
lineNumber

Integer

details6.n1
n1
رقم 1
Number 1

Decimal

details6.n2
n2
رقم 2
Number 2

Decimal

details6.n3
n3
رقم 3
Number 3

Decimal

details6.n4
n4
رقم 4
Number 4

Decimal

details6.n5
n5
رقم 5
Number 5

Decimal

details6.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details6.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details6.remark1
remark1

BigText

details6.remark2
remark2

BigText

details7 ( - )

Table Name: CRMTroubleTicketLine7, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details7.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details7.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details7.b1
b1
Boolean 1
Boolean 1

Boolean

details7.b2
b2
Boolean 2
Boolean 2

Boolean

details7.b3
b3
Boolean 3
Boolean 3

Boolean

details7.b4
b4
Boolean 4
Boolean 4

Boolean

details7.b5
b5
Boolean 5
Boolean 5

Boolean

details7.date1
date1
تـــاريخ 1
Date 1

Date

details7.date2
date2
تـــاريخ 2
Date 2

Date

details7.date3
date3
تاريخ 3
Date3

Date

details7.date4
date4
تاريخ 4
Date4

Date

details7.date5
date5
تاريخ 5
Date5

Date

details7.description1
description1
الوصف 1
description1

Text

details7.description10
description10
الوصف 10
description 10

Text

details7.description2
description2
الوصف 2
description2

Text

details7.description3
description3
الوصف 3
description3

Text

details7.description4
description4
الوصف 4
description4

Text

details7.description5
description5
الوصف 5
description5

Text

details7.description6
description6
الوصف 6
description 6

Text

details7.description7
description7
الوصف 7
description 7

Text

details7.description8
description8
الوصف 8
description 8

Text

details7.description9
description9
الوصف 9
description 9

Text

details7.id
id

ID

details7.lineNumber
lineNumber

Integer

details7.n1
n1
رقم 1
Number 1

Decimal

details7.n2
n2
رقم 2
Number 2

Decimal

details7.n3
n3
رقم 3
Number 3

Decimal

details7.n4
n4
رقم 4
Number 4

Decimal

details7.n5
n5
رقم 5
Number 5

Decimal

details7.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details7.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details7.remark1
remark1

BigText

details7.remark2
remark2

BigText

details8 ( - )

Table Name: CRMTroubleTicketLine8, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details8.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details8.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details8.b1
b1
Boolean 1
Boolean 1

Boolean

details8.b2
b2
Boolean 2
Boolean 2

Boolean

details8.b3
b3
Boolean 3
Boolean 3

Boolean

details8.b4
b4
Boolean 4
Boolean 4

Boolean

details8.b5
b5
Boolean 5
Boolean 5

Boolean

details8.date1
date1
تـــاريخ 1
Date 1

Date

details8.date2
date2
تـــاريخ 2
Date 2

Date

details8.date3
date3
تاريخ 3
Date3

Date

details8.date4
date4
تاريخ 4
Date4

Date

details8.date5
date5
تاريخ 5
Date5

Date

details8.description1
description1
الوصف 1
description1

Text

details8.description10
description10
الوصف 10
description 10

Text

details8.description2
description2
الوصف 2
description2

Text

details8.description3
description3
الوصف 3
description3

Text

details8.description4
description4
الوصف 4
description4

Text

details8.description5
description5
الوصف 5
description5

Text

details8.description6
description6
الوصف 6
description 6

Text

details8.description7
description7
الوصف 7
description 7

Text

details8.description8
description8
الوصف 8
description 8

Text

details8.description9
description9
الوصف 9
description 9

Text

details8.id
id

ID

details8.lineNumber
lineNumber

Integer

details8.n1
n1
رقم 1
Number 1

Decimal

details8.n2
n2
رقم 2
Number 2

Decimal

details8.n3
n3
رقم 3
Number 3

Decimal

details8.n4
n4
رقم 4
Number 4

Decimal

details8.n5
n5
رقم 5
Number 5

Decimal

details8.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details8.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details8.remark1
remark1

BigText

details8.remark2
remark2

BigText

details9 ( - )

Table Name: CRMTroubleTicketLine9, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
details9.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

details9.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

details9.b1
b1
Boolean 1
Boolean 1

Boolean

details9.b2
b2
Boolean 2
Boolean 2

Boolean

details9.b3
b3
Boolean 3
Boolean 3

Boolean

details9.b4
b4
Boolean 4
Boolean 4

Boolean

details9.b5
b5
Boolean 5
Boolean 5

Boolean

details9.date1
date1
تـــاريخ 1
Date 1

Date

details9.date2
date2
تـــاريخ 2
Date 2

Date

details9.date3
date3
تاريخ 3
Date3

Date

details9.date4
date4
تاريخ 4
Date4

Date

details9.date5
date5
تاريخ 5
Date5

Date

details9.description1
description1
الوصف 1
description1

Text

details9.description10
description10
الوصف 10
description 10

Text

details9.description2
description2
الوصف 2
description2

Text

details9.description3
description3
الوصف 3
description3

Text

details9.description4
description4
الوصف 4
description4

Text

details9.description5
description5
الوصف 5
description5

Text

details9.description6
description6
الوصف 6
description 6

Text

details9.description7
description7
الوصف 7
description 7

Text

details9.description8
description8
الوصف 8
description 8

Text

details9.description9
description9
الوصف 9
description 9

Text

details9.id
id

ID

details9.lineNumber
lineNumber

Integer

details9.n1
n1
رقم 1
Number 1

Decimal

details9.n2
n2
رقم 2
Number 2

Decimal

details9.n3
n3
رقم 3
Number 3

Decimal

details9.n4
n4
رقم 4
Number 4

Decimal

details9.n5
n5
رقم 5
Number 5

Decimal

details9.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

details9.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

details9.remark1
remark1

BigText

details9.remark2
remark2

BigText

employees (الموظفين - Employees)

Table Name: TicketEmployeeLine, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
employees.date1
date1
تـــاريخ 1
Date 1

Date

employees.date2
date2
تـــاريخ 2
Date 2

Date

employees.date3
date3
تاريخ 3
Date3

Date

employees.date4
date4
تاريخ 4
Date4

Date

employees.date5
date5
تاريخ 5
Date5

Date

employees.employee
employee_id
الفني
Technician

Reference

Employee

employees.id
id

ID

employees.lineColor
lineColor
Line Color
Line Color

Color

employees.lineNumber
lineNumber

Integer

employees.n1
n1
رقم 1
Number 1

Decimal

employees.n2
n2
رقم 2
Number 2

Decimal

employees.n3
n3
رقم 3
Number 3

Decimal

employees.n4
n4
رقم 4
Number 4

Decimal

employees.n5
n5
رقم 5
Number 5

Decimal

employees.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

employees.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

employees.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3

Genericreference

employees.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4

Genericreference

employees.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5

Genericreference

employees.remarks
remarks
ملاحظات
Description

BigText

employees.t1
t1

Time

employees.t2
t2

Time

employees.t3
t3

Time

employees.t4
t4

Time

employees.t5
t5

Time

employees.text1
text1
نــــص 1
Text 1

Text

employees.text2
text2
نـــــص 2
Text 2

Text

employees.text3
text3
نص 3
text3

Text

employees.text4
text4
نص 4
text4

Text

employees.text5
text5
نص 5
text5

Text

executionLines ( - )

Table Name: CRMTroubleTicketExecutionLine, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
executionLines.date1
date1
تـــاريخ 1
Date 1

Date

executionLines.date2
date2
تـــاريخ 2
Date 2

Date

executionLines.date3
date3
تاريخ 3
Date3

Date

executionLines.date4
date4
تاريخ 4
Date4

Date

executionLines.date5
date5
تاريخ 5
Date5

Date

executionLines.empTotalExecutionTime
empTotalExecutionTime
إجمالي وقت التنفيذ للموظف
Employee Total Execution Time

Decimal

executionLines.employee
employee_id
الموظف
Employee

Reference

Employee

executionLines.endDateTime
endDateTime
تاريخ و وقت النهاية
End Date And Time

DateAndTime

executionLines.executionTime
executionTime
وقت التنفيذ
Execution Time

Decimal

executionLines.id
id

ID

executionLines.lineColor
lineColor
Line Color
Line Color

Color

executionLines.lineNumber
lineNumber

Integer

executionLines.n1
n1
رقم 1
Number 1

Decimal

executionLines.n2
n2
رقم 2
Number 2

Decimal

executionLines.n3
n3
رقم 3
Number 3

Decimal

executionLines.n4
n4
رقم 4
Number 4

Decimal

executionLines.n5
n5
رقم 5
Number 5

Decimal

executionLines.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

executionLines.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

executionLines.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3

Genericreference

executionLines.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4

Genericreference

executionLines.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5

Genericreference

executionLines.remarks
remarks
ملاحظات
Description

BigText

executionLines.startDateTime
startDateTime
تاريخ و وقت البدء
Start Date And Time

DateAndTime

executionLines.status
status
الحالة
Status

TicketStatus

executionLines.t1
t1

Time

executionLines.t2
t2

Time

executionLines.t3
t3

Time

executionLines.t4
t4

Time

executionLines.t5
t5

Time

executionLines.text1
text1
نــــص 1
Text 1

Text

executionLines.text2
text2
نـــــص 2
Text 2

Text

executionLines.text3
text3
نص 3
text3

Text

executionLines.text4
text4
نص 4
text4

Text

executionLines.text5
text5
نص 5
text5

Text

executionLines.troubleTicketDocId
troubleTicketDocId

ID

remakLines ( - )

Table Name: CRMTroubleTicketRemarksLine, Join Column: cRMTroubleTicket_id

Property
Column
Arabic
English
Type
Foreign Table
remakLines.attachment1
attachment1_id
مرفق 1
Attachment 1

Binary

LargeData

remakLines.attachment10
attachment10_id
مرفق 10
Attachment10

Binary

LargeData

remakLines.attachment2
attachment2_id
مرفق 2
Attachment 2

Binary

LargeData

remakLines.attachment3
attachment3_id
مرفق 3
Attachment 3

Binary

LargeData

remakLines.attachment4
attachment4_id
مرفق 4
Attachment 4

Binary

LargeData

remakLines.attachment5
attachment5_id
مرفق 5
Attachment 5

Binary

LargeData

remakLines.attachment6
attachment6_id
مرفق 6
Attachment6

Binary

LargeData

remakLines.attachment7
attachment7_id
مرفق 7
Attachment7

Binary

LargeData

remakLines.attachment8
attachment8_id
مرفق 8
Attachment8

Binary

LargeData

remakLines.attachment9
attachment9_id
مرفق 9
Attachment9

Binary

LargeData

remakLines.b1
b1
Boolean 1
Boolean 1

Boolean

remakLines.b10
b10

Boolean

remakLines.b2
b2
Boolean 2
Boolean 2

Boolean

remakLines.b3
b3
Boolean 3
Boolean 3

Boolean

remakLines.b4
b4
Boolean 4
Boolean 4

Boolean

remakLines.b5
b5
Boolean 5
Boolean 5

Boolean

remakLines.b6
b6

Boolean

remakLines.b7
b7

Boolean

remakLines.b8
b8

Boolean

remakLines.b9
b9

Boolean

remakLines.date1
date1
تـــاريخ 1
Date 1

Date

remakLines.date10
date10
تاريخ 10
Date10

Date

remakLines.date2
date2
تـــاريخ 2
Date 2

Date

remakLines.date3
date3
تاريخ 3
Date3

Date

remakLines.date4
date4
تاريخ 4
Date4

Date

remakLines.date5
date5
تاريخ 5
Date5

Date

remakLines.date6
date6
تاريخ 6
Date6

Date

remakLines.date7
date7
تاريخ 7
Date7

Date

remakLines.date8
date8
تاريخ 8
Date8

Date

remakLines.date9
date9
تاريخ 9
Date9

Date

remakLines.description1
description1
الوصف 1
description1

BigText

remakLines.description10
description10
الوصف 10
description 10

BigText

remakLines.description2
description2
الوصف 2
description2

BigText

remakLines.description3
description3
الوصف 3
description3

BigText

remakLines.description4
description4
الوصف 4
description4

BigText

remakLines.description5
description5
الوصف 5
description5

BigText

remakLines.description6
description6
الوصف 6
description 6

BigText

remakLines.description7
description7
الوصف 7
description 7

BigText

remakLines.description8
description8
الوصف 8
description 8

BigText

remakLines.description9
description9
الوصف 9
description 9

BigText

remakLines.id
id

ID

remakLines.lineNumber
lineNumber

Integer

remakLines.longRemarks
longRemarks
ملاحظات
Remarks

BigText

remakLines.n1
n1
رقم 1
Number 1

Decimal

remakLines.n10
n10
رقم 10
Number 10

Decimal

remakLines.n2
n2
رقم 2
Number 2

Decimal

remakLines.n3
n3
رقم 3
Number 3

Decimal

remakLines.n4
n4
رقم 4
Number 4

Decimal

remakLines.n5
n5
رقم 5
Number 5

Decimal

remakLines.n6
n6
رقم 6
Number 6

Decimal

remakLines.n7
n7
رقم 7
Number 7

Decimal

remakLines.n8
n8
رقم 8
Number 8

Decimal

remakLines.n9
n9
رقم 9
Number 9

Decimal

remakLines.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

remakLines.ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id

Genericreference

remakLines.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

remakLines.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3

Genericreference

remakLines.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4

Genericreference

remakLines.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5

Genericreference

remakLines.ref6
ref6ActualCode, ref6Code, ref6EntityType, ref6Id
مرجع 6
Reference 6

Genericreference

remakLines.ref7
ref7ActualCode, ref7Code, ref7EntityType, ref7Id
مرجع 7
Reference 7

Genericreference

remakLines.ref8
ref8ActualCode, ref8Code, ref8EntityType, ref8Id

Genericreference

remakLines.ref9
ref9ActualCode, ref9Code, ref9EntityType, ref9Id

Genericreference

Edit On github
Last Updated:: 4/19/26, 12:24 AM