Arabic: ذمة 2 English: Subsidiary 2
details (Subsidiary2Line) , details2 (Subsidiary2Line2) , details3 (Subsidiary2Line3) , details4 (Subsidiary2Line4)
Fields
Property
Column
Arabic
English
Type
Foreign Table
altCode
altCode
الكود الإنجليزي
English Code
Text
analysisSetId
analysisSet_id
ID
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
bankInfo.bankBranch
bankInfoBankBranch
الفرع
Bank Branch
Text
bankInfo.bankCountry
bankInfoBankCountry
البلد
Bank Country
Text
bankInfo.bankName
bankInfoBankName
بنك
Bank
Text
bankInfo.bankTitle
bankInfoBankTitle
عنوان البنك
Bank Title
Text
bankInfo.ibanNumber
bankInfoIbanNumber
رقم IBAN
IBAN Number
Text
bankInfo.intermediaryBankName
bankInfoIntermediaryBankName
اسم البنك الوسيط
Intermediary Bank Name
Text
bankInfo.swiftCode
bankInfoSwiftCode
كود السويفت
Swift Code
Text
birthDate
birthDate
تاريخ الميلاد
Birth date
Date
branchId
branch_id
Branch ID
Branch ID
ID
code
code
الكود
Code
Text
colorCode
colorCode
كود اللون
Color Code
Color
commitedBefore
commitedBefore
تم الحفظ مسبقا
Commited Before
Boolean
contactInfo.address.address1
address1
عنوان 1
Address 1
Text
contactInfo.address.address2
address2
رقم المبني
Building Number
Text
contactInfo.address.area
addressArea
المنطقة
Area
Text
contactInfo.address.buildingNumber
buildingNumber
رقم المبني
Building Number
Text
contactInfo.address.city
addressCity
المدينة
City
Text
contactInfo.address.country
addressCountry
الدولة
Country
Text
contactInfo.address.countryCode
countryCode
كود الدولة
Country Code
Text
contactInfo.address.district
district
الحي
District
Text
contactInfo.address.landPlotNumber
landPlotNumber
رقم تعريفي للأرض
Land Plot Number
Text
contactInfo.address.mapLocation
mapLocation
الموقع على الخريطة
Map Location
LatLng
contactInfo.address.postalCode
postalCode
الكود البريدي
Postal Code
Text
contactInfo.address.state
addressState
المحافظة
State
Text
contactInfo.address.street
street
شارع
Street
Text
contactInfo.email
email
إيميل
E-mail
contactInfo.faxNumber
faxNumber
الفاكس
Fax
PhoneNumber
contactInfo.mobile
mobile
الموبايل
Mobile
PhoneNumber
contactInfo.telephone1
telephone1
تليفون 1
Phone 1
PhoneNumber
contactInfo.telephone2
telephone2
تليفون 2
Phone 2
PhoneNumber
contactInfo.website
website
موقع الكتروني
Website
Text
createTransactionId
createTransactionId
Text
creationDate
creationDate
تاريخ الإنشاء
Creation Date
DateAndTime
currentVersion
currentVersion
النسخة الحالية
Current Version
Integer
customViewName
customViewName
Text
d10
d10
Date
d11
d11
Date
d12
d12
Date
d13
d13
Date
d14
d14
Date
d15
d15
Date
d16
d16
Date
d17
d17
Date
d18
d18
Date
d19
d19
Date
d20
d20
Date
d6
d6
Date
d7
d7
Date
d8
d8
Date
d9
d9
Date
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
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
draftCreated
draftCreated
تم إنشاء مسودة
Draft Created
Boolean
draftXML
draftXML
BigText
entitySystemEntryId
entitySystemEntry_id
ID
entityType
entityType
النوع
Entity Type
EntityType
fillDate1WithLineInsertion
fillDate1WithLineInsertion
ملء تاريخ 1 اليا مع ادخال سطر
Fill Date 1 Automaticaly With Line Insertion
Boolean
fillTime1WithLineInsertion
fillTime1WithLineInsertion
ملء وقت 1 اليا مع ادخال سطر
Fill Time 1 Automaticaly With Line Insertion
Boolean
firstAuthorId
firstAuthor_id
ID
fromTime
fromTime
من وقت
From-Time
Time
generatedByLine
generatedByLine
كود سطر الإنشاء
generated By Line
Text
generatedDocsCount
generatedDocsCount
Integer
generatedFrom
generatedFromActualCode, generatedFromCode, generatedFromEntityType, generatedFromId
تم إنشاؤه من
Generated From
Genericreference
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
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
n21
n21
Decimal
n22
n22
Decimal
n23
n23
Decimal
n24
n24
Decimal
n25
n25
Decimal
n26
n26
Decimal
n27
n27
Decimal
n28
n28
Decimal
n29
n29
Decimal
n3
n3
رقم 3
Number 3
Decimal
n30
n30
Decimal
n31
n31
Decimal
n32
n32
Decimal
n33
n33
Decimal
n34
n34
Decimal
n35
n35
Decimal
n36
n36
Decimal
n37
n37
Decimal
n38
n38
Decimal
n39
n39
Decimal
n4
n4
رقم 4
Number 4
Decimal
n40
n40
Decimal
n41
n41
Decimal
n42
n42
Decimal
n43
n43
Decimal
n44
n44
Decimal
n45
n45
Decimal
n46
n46
Decimal
n47
n47
Decimal
n48
n48
Decimal
n49
n49
Decimal
n5
n5
رقم 5
Number 5
Decimal
n50
n50
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
name1
name1
الاسم العربي
Name1
Text
name2
name2
الاسم الإنجليزي
Name2
Text
parentCode
parentCode
Text
passport.end
passportEnd
تاريخ الأنتهاء
End at
Date
passport.issue
passportIssue
تاريخ الإصدار
Issue
Date
passport.number
passportNumber
رقم
Number
Text
preventUsage
preventUsage
منع الاستعمال
Prevent Usage
Boolean
printCount
printCount
عدد مرات الطباعة
Print Count
Integer
ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id
Genericreference
ref11
ref11ActualCode, ref11Code, ref11EntityType, ref11Id
Genericreference
ref12
ref12ActualCode, ref12Code, ref12EntityType, ref12Id
Genericreference
ref13
ref13ActualCode, ref13Code, ref13EntityType, ref13Id
Genericreference
ref14
ref14ActualCode, ref14Code, ref14EntityType, ref14Id
Genericreference
ref15
ref15ActualCode, ref15Code, ref15EntityType, ref15Id
Genericreference
ref16
ref16ActualCode, ref16Code, ref16EntityType, ref16Id
Genericreference
ref17
ref17ActualCode, ref17Code, ref17EntityType, ref17Id
Genericreference
ref18
ref18ActualCode, ref18Code, ref18EntityType, ref18Id
Genericreference
ref19
ref19ActualCode, ref19Code, ref19EntityType, ref19Id
Genericreference
ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
ref20
ref20ActualCode, ref20Code, ref20EntityType, ref20Id
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
remarkDate
remarkDate
تاريخ الملاحظة
Remark Date
Date
remarks
remark
ملاحظات
Description
BigText
residency.end
residencyEnd
تاريخ الأنتهاء
End at
Date
residency.issue
residencyIssue
تاريخ الإصدار
Issue
Date
residency.number
residencyNumber
رقم
Number
Text
revised
primitiveValue
تمت المراجعة
Revised
Boolean
sectorId
sector_id
ID
subsidiaryAccounts.forceNoDebtAgesTracking
forceNoDebtAgesTracking
منع متابعة أعمار الديون لهذه الذمة - حتي و إن تم تفعيلها للحساب
Do Not Track Debt Ages For This Subsidiary - Even if it was activated in the account
Boolean
subsidiaryAccounts.parentParty
parentPartyActualCode, parentPartyCode, parentPartyEntityType, parentPartyId
الجهة الأعلي (البديل المحاسبي)
Parent Party (Accounting Alternative)
Genericreference
subsidiaryAccounts.tax1Exempt
tax1Exempt
غير خاضع لضريبة 1
Tax 1 Exempt
Boolean
subsidiaryAccounts.tax2Exempt
tax2Exempt
غير خاضع لضريبة 2
Tax 2 Exempt
Boolean
subsidiaryAccounts.tax3Exempt
tax3Exempt
غير خاضع لضريبة 3
Tax 3 Exempt
Boolean
subsidiaryAccounts.tax4Exempt
tax4Exempt
غير خاضع لضريبة 4
Tax 4 Exempt
Boolean
systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix
Text
taxInfo.commercialRegNo
taxInfoCommercialRegNo
رقم السجل التجاري
Commercial Registration Number
Text
taxInfo.companyType
taxInfoCompanyType
الكيان القانونى للشركة
The legal entity of the company
taxInfo.crNationalNumber
taxInfoCrNationalNumber
الرقم الوطني الموحد
Commercial Registration National Number
Text
taxInfo.dealWay
taxInfoDealWay
ط تعامل
Deal Way
Text
taxInfo.dealWayCode
taxInfoDealWayCode
كود
Code
Text
taxInfo.fileNo
taxInfoFileNo
رقم الملف
File No
Text
taxInfo.idNumber
taxInfoIdNumber
رقم البطاقة الشخصيه
Id Number
Text
taxInfo.mission
taxInfoMission
المأمورية
Mission
Text
taxInfo.missionCode
taxInfoMissionCode
كود
Code
Text
taxInfo.specialNumber
taxInfoSpecialNumber
الرقم المميز
Special Number
Text
taxInfo.supplier
taxInfoSupplier
مورد
Supplier
Text
taxInfo.taxRegNo
taxInfoTaxRegNo
رقم التسجيل الضريبى
Tax Registeration NO
Text
time1
time1
وقت 1
Time 1
Time
time2
time2
وقت 2
Time 2
Time
time3
time3
وقت 3
Time 3
Time
time4
time4
وقت 4
Time 4
Time
time5
time5
وقت 5
Time 5
Time
toTime
toTime
إلى وقت
To-Time
Time
updateCapabilityId
updateCapability_id
ID
usageCapabilityId
usageCapability_id
ID
viewCapabilityId
viewCapability_id
ID
details (التفاصيل - Details)
Table Name: Subsidiary2Line, Join Column: subsidiary2_id
Property
Column
Arabic
English
Type
Foreign Table
details.b1
b1
Boolean 1
Boolean 1
Boolean
details.b2
b2
Boolean 2
Boolean 2
Boolean
details.b3
b3
Boolean 3
Boolean 3
Boolean
details.b4
b4
Boolean 4
Boolean 4
Boolean
details.b5
b5
Boolean 5
Boolean 5
Boolean
details.date1
date1
تـــاريخ 1
Date 1
Date
details.date2
date2
تـــاريخ 2
Date 2
Date
details.date3
date3
تاريخ 3
Date3
Date
details.date4
date4
تاريخ 4
Date4
Date
details.date5
date5
تاريخ 5
Date5
Date
details.id
id
ID
details.lineNumber
lineNumber
Integer
details.longText1
longText1
نص كبير 1
Long Text 1
BigText
details.longText2
longText2
نص كبير 2
Long Text 2
BigText
details.longText3
longText3
نص كبير 3
Long Text 3
BigText
details.longText4
longText4
نص كبير 4
Long Text 4
BigText
details.longText5
longText5
نص كبير 5
Long Text 5
BigText
details.number1
number1
رقم 1
Number 1
Decimal
details.number10
number10
Decimal
details.number11
number11
Decimal
details.number12
number12
Decimal
details.number13
number13
Decimal
details.number14
number14
Decimal
details.number15
number15
Decimal
details.number16
number16
Decimal
details.number17
number17
Decimal
details.number18
number18
Decimal
details.number19
number19
Decimal
details.number2
number2
رقم 2
Number 2
Decimal
details.number20
number20
Decimal
details.number21
number21
Decimal
details.number22
number22
Decimal
details.number23
number23
Decimal
details.number24
number24
Decimal
details.number25
number25
Decimal
details.number26
number26
Decimal
details.number27
number27
Decimal
details.number28
number28
Decimal
details.number29
number29
Decimal
details.number3
number3
Decimal
details.number30
number30
Decimal
details.number31
number31
Decimal
details.number32
number32
Decimal
details.number33
number33
Decimal
details.number34
number34
Decimal
details.number35
number35
Decimal
details.number36
number36
Decimal
details.number37
number37
Decimal
details.number38
number38
Decimal
details.number39
number39
Decimal
details.number4
number4
Decimal
details.number40
number40
Decimal
details.number41
number41
Decimal
details.number42
number42
Decimal
details.number43
number43
Decimal
details.number44
number44
Decimal
details.number45
number45
Decimal
details.number46
number46
Decimal
details.number47
number47
Decimal
details.number48
number48
Decimal
details.number49
number49
Decimal
details.number5
number5
Decimal
details.number50
number50
Decimal
details.number6
number6
Decimal
details.number7
number7
Decimal
details.number8
number8
Decimal
details.number9
number9
Decimal
details.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
details.ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id
Genericreference
details.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
details.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3
Genericreference
details.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4
Genericreference
details.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5
Genericreference
details.ref6
ref6ActualCode, ref6Code, ref6EntityType, ref6Id
مرجع 6
Reference 6
Genericreference
details.ref7
ref7ActualCode, ref7Code, ref7EntityType, ref7Id
مرجع 7
Reference 7
Genericreference
details.ref8
ref8ActualCode, ref8Code, ref8EntityType, ref8Id
Genericreference
details.ref9
ref9ActualCode, ref9Code, ref9EntityType, ref9Id
Genericreference
details.text1
text1
نــــص 1
Text 1
Text
details.text10
text10
10 نص
text 10
Text
details.text11
text11
Text
details.text12
text12
Text
details.text13
text13
Text
details.text14
text14
Text
details.text15
text15
Text
details.text16
text16
Text
details.text17
text17
Text
details.text18
text18
Text
details.text19
text19
Text
details.text2
text2
نـــــص 2
Text 2
Text
details.text20
text20
Text
details.text21
text21
Text
details.text22
text22
Text
details.text23
text23
Text
details.text24
text24
Text
details.text25
text25
Text
details.text26
text26
Text
details.text27
text27
Text
details.text28
text28
Text
details.text29
text29
Text
details.text3
text3
نص 3
text3
Text
details.text30
text30
Text
details.text4
text4
نص 4
text4
Text
details.text5
text5
نص 5
text5
Text
details.text6
text6
6 نص
Text 6
Text
details.text7
text7
7 نص
Text 7
Text
details.text8
text8
8 نص
Text 8
Text
details.text9
text9
9 نص
Text 9
Text
details.time1
time1
وقت 1
Time 1
Time
details.time2
time2
وقت 2
Time 2
Time
details.time3
time3
وقت 3
Time 3
Time
details.time4
time4
وقت 4
Time 4
Time
details.time5
time5
وقت 5
Time 5
Time
details2 ( - )
Table Name: Subsidiary2Line2, Join Column: subsidiary2_id
Property
Column
Arabic
English
Type
Foreign Table
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.id
id
ID
details2.lineNumber
lineNumber
Integer
details2.longText1
longText1
نص كبير 1
Long Text 1
BigText
details2.longText2
longText2
نص كبير 2
Long Text 2
BigText
details2.longText3
longText3
نص كبير 3
Long Text 3
BigText
details2.longText4
longText4
نص كبير 4
Long Text 4
BigText
details2.longText5
longText5
نص كبير 5
Long Text 5
BigText
details2.number1
number1
رقم 1
Number 1
Decimal
details2.number10
number10
Decimal
details2.number11
number11
Decimal
details2.number12
number12
Decimal
details2.number13
number13
Decimal
details2.number14
number14
Decimal
details2.number15
number15
Decimal
details2.number16
number16
Decimal
details2.number17
number17
Decimal
details2.number18
number18
Decimal
details2.number19
number19
Decimal
details2.number2
number2
رقم 2
Number 2
Decimal
details2.number20
number20
Decimal
details2.number21
number21
Decimal
details2.number22
number22
Decimal
details2.number23
number23
Decimal
details2.number24
number24
Decimal
details2.number25
number25
Decimal
details2.number26
number26
Decimal
details2.number27
number27
Decimal
details2.number28
number28
Decimal
details2.number29
number29
Decimal
details2.number3
number3
Decimal
details2.number30
number30
Decimal
details2.number31
number31
Decimal
details2.number32
number32
Decimal
details2.number33
number33
Decimal
details2.number34
number34
Decimal
details2.number35
number35
Decimal
details2.number36
number36
Decimal
details2.number37
number37
Decimal
details2.number38
number38
Decimal
details2.number39
number39
Decimal
details2.number4
number4
Decimal
details2.number40
number40
Decimal
details2.number41
number41
Decimal
details2.number42
number42
Decimal
details2.number43
number43
Decimal
details2.number44
number44
Decimal
details2.number45
number45
Decimal
details2.number46
number46
Decimal
details2.number47
number47
Decimal
details2.number48
number48
Decimal
details2.number49
number49
Decimal
details2.number5
number5
Decimal
details2.number50
number50
Decimal
details2.number6
number6
Decimal
details2.number7
number7
Decimal
details2.number8
number8
Decimal
details2.number9
number9
Decimal
details2.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
details2.ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id
Genericreference
details2.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
details2.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3
Genericreference
details2.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4
Genericreference
details2.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5
Genericreference
details2.ref6
ref6ActualCode, ref6Code, ref6EntityType, ref6Id
مرجع 6
Reference 6
Genericreference
details2.ref7
ref7ActualCode, ref7Code, ref7EntityType, ref7Id
مرجع 7
Reference 7
Genericreference
details2.ref8
ref8ActualCode, ref8Code, ref8EntityType, ref8Id
Genericreference
details2.ref9
ref9ActualCode, ref9Code, ref9EntityType, ref9Id
Genericreference
details2.text1
text1
نــــص 1
Text 1
Text
details2.text10
text10
10 نص
text 10
Text
details2.text11
text11
Text
details2.text12
text12
Text
details2.text13
text13
Text
details2.text14
text14
Text
details2.text15
text15
Text
details2.text16
text16
Text
details2.text17
text17
Text
details2.text18
text18
Text
details2.text19
text19
Text
details2.text2
text2
نـــــص 2
Text 2
Text
details2.text20
text20
Text
details2.text21
text21
Text
details2.text22
text22
Text
details2.text23
text23
Text
details2.text24
text24
Text
details2.text25
text25
Text
details2.text26
text26
Text
details2.text27
text27
Text
details2.text28
text28
Text
details2.text29
text29
Text
details2.text3
text3
نص 3
text3
Text
details2.text30
text30
Text
details2.text4
text4
نص 4
text4
Text
details2.text5
text5
نص 5
text5
Text
details2.text6
text6
6 نص
Text 6
Text
details2.text7
text7
7 نص
Text 7
Text
details2.text8
text8
8 نص
Text 8
Text
details2.text9
text9
9 نص
Text 9
Text
details2.time1
time1
وقت 1
Time 1
Time
details2.time2
time2
وقت 2
Time 2
Time
details2.time3
time3
وقت 3
Time 3
Time
details2.time4
time4
وقت 4
Time 4
Time
details2.time5
time5
وقت 5
Time 5
Time
details3 ( - )
Table Name: Subsidiary2Line3, Join Column: subsidiary2_id
Property
Column
Arabic
English
Type
Foreign Table
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.id
id
ID
details3.lineNumber
lineNumber
Integer
details3.longText1
longText1
نص كبير 1
Long Text 1
BigText
details3.longText2
longText2
نص كبير 2
Long Text 2
BigText
details3.longText3
longText3
نص كبير 3
Long Text 3
BigText
details3.longText4
longText4
نص كبير 4
Long Text 4
BigText
details3.longText5
longText5
نص كبير 5
Long Text 5
BigText
details3.number1
number1
رقم 1
Number 1
Decimal
details3.number10
number10
Decimal
details3.number11
number11
Decimal
details3.number12
number12
Decimal
details3.number13
number13
Decimal
details3.number14
number14
Decimal
details3.number15
number15
Decimal
details3.number16
number16
Decimal
details3.number17
number17
Decimal
details3.number18
number18
Decimal
details3.number19
number19
Decimal
details3.number2
number2
رقم 2
Number 2
Decimal
details3.number20
number20
Decimal
details3.number21
number21
Decimal
details3.number22
number22
Decimal
details3.number23
number23
Decimal
details3.number24
number24
Decimal
details3.number25
number25
Decimal
details3.number26
number26
Decimal
details3.number27
number27
Decimal
details3.number28
number28
Decimal
details3.number29
number29
Decimal
details3.number3
number3
Decimal
details3.number30
number30
Decimal
details3.number31
number31
Decimal
details3.number32
number32
Decimal
details3.number33
number33
Decimal
details3.number34
number34
Decimal
details3.number35
number35
Decimal
details3.number36
number36
Decimal
details3.number37
number37
Decimal
details3.number38
number38
Decimal
details3.number39
number39
Decimal
details3.number4
number4
Decimal
details3.number40
number40
Decimal
details3.number41
number41
Decimal
details3.number42
number42
Decimal
details3.number43
number43
Decimal
details3.number44
number44
Decimal
details3.number45
number45
Decimal
details3.number46
number46
Decimal
details3.number47
number47
Decimal
details3.number48
number48
Decimal
details3.number49
number49
Decimal
details3.number5
number5
Decimal
details3.number50
number50
Decimal
details3.number6
number6
Decimal
details3.number7
number7
Decimal
details3.number8
number8
Decimal
details3.number9
number9
Decimal
details3.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
details3.ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id
Genericreference
details3.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
details3.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3
Genericreference
details3.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4
Genericreference
details3.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5
Genericreference
details3.ref6
ref6ActualCode, ref6Code, ref6EntityType, ref6Id
مرجع 6
Reference 6
Genericreference
details3.ref7
ref7ActualCode, ref7Code, ref7EntityType, ref7Id
مرجع 7
Reference 7
Genericreference
details3.ref8
ref8ActualCode, ref8Code, ref8EntityType, ref8Id
Genericreference
details3.ref9
ref9ActualCode, ref9Code, ref9EntityType, ref9Id
Genericreference
details3.text1
text1
نــــص 1
Text 1
Text
details3.text10
text10
10 نص
text 10
Text
details3.text11
text11
Text
details3.text12
text12
Text
details3.text13
text13
Text
details3.text14
text14
Text
details3.text15
text15
Text
details3.text16
text16
Text
details3.text17
text17
Text
details3.text18
text18
Text
details3.text19
text19
Text
details3.text2
text2
نـــــص 2
Text 2
Text
details3.text20
text20
Text
details3.text21
text21
Text
details3.text22
text22
Text
details3.text23
text23
Text
details3.text24
text24
Text
details3.text25
text25
Text
details3.text26
text26
Text
details3.text27
text27
Text
details3.text28
text28
Text
details3.text29
text29
Text
details3.text3
text3
نص 3
text3
Text
details3.text30
text30
Text
details3.text4
text4
نص 4
text4
Text
details3.text5
text5
نص 5
text5
Text
details3.text6
text6
6 نص
Text 6
Text
details3.text7
text7
7 نص
Text 7
Text
details3.text8
text8
8 نص
Text 8
Text
details3.text9
text9
9 نص
Text 9
Text
details3.time1
time1
وقت 1
Time 1
Time
details3.time2
time2
وقت 2
Time 2
Time
details3.time3
time3
وقت 3
Time 3
Time
details3.time4
time4
وقت 4
Time 4
Time
details3.time5
time5
وقت 5
Time 5
Time
details4 ( - )
Table Name: Subsidiary2Line4, Join Column: subsidiary2_id
Property
Column
Arabic
English
Type
Foreign Table
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.id
id
ID
details4.lineNumber
lineNumber
Integer
details4.longText1
longText1
نص كبير 1
Long Text 1
BigText
details4.longText2
longText2
نص كبير 2
Long Text 2
BigText
details4.longText3
longText3
نص كبير 3
Long Text 3
BigText
details4.longText4
longText4
نص كبير 4
Long Text 4
BigText
details4.longText5
longText5
نص كبير 5
Long Text 5
BigText
details4.number1
number1
رقم 1
Number 1
Decimal
details4.number10
number10
Decimal
details4.number11
number11
Decimal
details4.number12
number12
Decimal
details4.number13
number13
Decimal
details4.number14
number14
Decimal
details4.number15
number15
Decimal
details4.number16
number16
Decimal
details4.number17
number17
Decimal
details4.number18
number18
Decimal
details4.number19
number19
Decimal
details4.number2
number2
رقم 2
Number 2
Decimal
details4.number20
number20
Decimal
details4.number21
number21
Decimal
details4.number22
number22
Decimal
details4.number23
number23
Decimal
details4.number24
number24
Decimal
details4.number25
number25
Decimal
details4.number26
number26
Decimal
details4.number27
number27
Decimal
details4.number28
number28
Decimal
details4.number29
number29
Decimal
details4.number3
number3
Decimal
details4.number30
number30
Decimal
details4.number31
number31
Decimal
details4.number32
number32
Decimal
details4.number33
number33
Decimal
details4.number34
number34
Decimal
details4.number35
number35
Decimal
details4.number36
number36
Decimal
details4.number37
number37
Decimal
details4.number38
number38
Decimal
details4.number39
number39
Decimal
details4.number4
number4
Decimal
details4.number40
number40
Decimal
details4.number41
number41
Decimal
details4.number42
number42
Decimal
details4.number43
number43
Decimal
details4.number44
number44
Decimal
details4.number45
number45
Decimal
details4.number46
number46
Decimal
details4.number47
number47
Decimal
details4.number48
number48
Decimal
details4.number49
number49
Decimal
details4.number5
number5
Decimal
details4.number50
number50
Decimal
details4.number6
number6
Decimal
details4.number7
number7
Decimal
details4.number8
number8
Decimal
details4.number9
number9
Decimal
details4.ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1
Genericreference
details4.ref10
ref10ActualCode, ref10Code, ref10EntityType, ref10Id
Genericreference
details4.ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2
Genericreference
details4.ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3
Genericreference
details4.ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4
Genericreference
details4.ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5
Genericreference
details4.ref6
ref6ActualCode, ref6Code, ref6EntityType, ref6Id
مرجع 6
Reference 6
Genericreference
details4.ref7
ref7ActualCode, ref7Code, ref7EntityType, ref7Id
مرجع 7
Reference 7
Genericreference
details4.ref8
ref8ActualCode, ref8Code, ref8EntityType, ref8Id
Genericreference
details4.ref9
ref9ActualCode, ref9Code, ref9EntityType, ref9Id
Genericreference
details4.text1
text1
نــــص 1
Text 1
Text
details4.text10
text10
10 نص
text 10
Text
details4.text11
text11
Text
details4.text12
text12
Text
details4.text13
text13
Text
details4.text14
text14
Text
details4.text15
text15
Text
details4.text16
text16
Text
details4.text17
text17
Text
details4.text18
text18
Text
details4.text19
text19
Text
details4.text2
text2
نـــــص 2
Text 2
Text
details4.text20
text20
Text
details4.text21
text21
Text
details4.text22
text22
Text
details4.text23
text23
Text
details4.text24
text24
Text
details4.text25
text25
Text
details4.text26
text26
Text
details4.text27
text27
Text
details4.text28
text28
Text
details4.text29
text29
Text
details4.text3
text3
نص 3
text3
Text
details4.text30
text30
Text
details4.text4
text4
نص 4
text4
Text
details4.text5
text5
نص 5
text5
Text
details4.text6
text6
6 نص
Text 6
Text
details4.text7
text7
7 نص
Text 7
Text
details4.text8
text8
8 نص
Text 8
Text
details4.text9
text9
9 نص
Text 9
Text
details4.time1
time1
وقت 1
Time 1
Time
details4.time2
time2
وقت 2
Time 2
Time
details4.time3
time3
وقت 3
Time 3
Time
details4.time4
time4
وقت 4
Time 4
Time
details4.time5
time5
وقت 5
Time 5
Time