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

HMSDiscount

Arabic: خصم طبى - خصومات طبية English: Medical Discount - Medical Discounts

accomodationDiscountLines (HMSDiscountAccomodationLine) , attendantDiscountLines (HMSDiscountAttendantLine) , bloodDiscountLines (HMSDiscountBloodLine) , labTestDiscountLines (HMSDiscountLabTestLine) , patientCheckDiscountLines (HMSDiscountCheckLine) , pharmacyDiscountLines (HMSDiscountPharmacyLine) , phyDiscountLines (HMSDiscountPhyLine) , radiologyDiscountLines (HMSDiscountRadiologyLine) , serviceDiscountLines (HMSDiscountServiceLine) , supervisionDiscountLines (HMSDiscountSupervisionLine) , supplyDiscountLines (HMSDiscountSuppliesLine) , surgeryDiscountLines (HMSDiscountSurgeryLine)

Fields

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

Reference

AnalysisSet

analysisSetId
analysisSet_id

ID

branch
branch_id
الفرع
Branch

Reference

Branch

branchId
branch_id
Branch ID
Branch ID

ID

code
code
الكود
Code

Text

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

Color

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

Boolean

companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

createTransactionId
createTransactionId

Text

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

DateAndTime

currentApprovalCase
currentApprovalCase_id

ApprovalCase

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

Integer

customViewName
customViewName

Text

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

Date

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

Date

date3
date3
تاريخ 3
Date3

Date

date4
date4
تاريخ 4
Date4

Date

date5
date5
تاريخ 5
Date5

Date

department
department_id
الإدارة
Department

Reference

Department

departmentId
department_id

ID

description1
description1
الوصف 1
description1

Text

description2
description2
الوصف 2
description2

Text

description3
description3
الوصف 3
description3

Text

description4
description4
الوصف 4
description4

Text

description5
description5
الوصف 5
description5

Text

docCategory
docCategory_id
تصنيف سجل
Record Category

Reference

DocCategory

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

DocumentFileStatus

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

Boolean

draftXML
draftXML

BigText

editedBy
editedBy_id
بواسطة
Edited By

Reference

NaMaUser

entitySystemEntryId
entitySystemEntry_id

ID

entityType
entityType
النوع
Entity Type

EntityType

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

hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

id
id

ID

indexInParent
indexInParent

Integer

lastChangeVersion
lastChangeVersion

Integer

lastModifyTransactionId
LastModifyTransactionId

Text

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

DateAndTime

legalEntity
legalEntity_id
الشركة
Legal Entity

Reference

LegalEntity

legalEntityId
legalEntity_id

ID

lockVersion
lockVersion

Integer

mainFile
mainFile_id

Binary

LargeData

medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

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

patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

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

Boolean

priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

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

Integer

priority
priority
الأولوية
Priority

Long

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

Genericreference

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

Genericreference

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

Genericreference

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

Genericreference

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

Genericreference

remarks
remark
ملاحظات
Description

BigText

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

ReviseLevel

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

Boolean

revisedBy
revisedBy_id

Reference

NaMaUser

sector
sector_id
القطاع
Sector

Reference

Sector

sectorId
sector_id

ID

systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix

Text

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

Reference

SecurityCapability

updateCapabilityId
updateCapability_id

ID

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

Reference

SecurityCapability

usageCapabilityId
usageCapability_id

ID

validFrom
validFrom
صالح من
Valid from

Date

validTo
validTo
صالح حتي
Valid to

Date

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

Reference

SecurityCapability

viewCapabilityId
viewCapability_id

ID

accomodationDiscountLines ( - )

Table Name: HMSDiscountAccomodationLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
accomodationDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

accomodationDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

accomodationDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

accomodationDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

accomodationDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

accomodationDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

accomodationDiscountLines.id
id

ID

accomodationDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

accomodationDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

accomodationDiscountLines.lineNumber
lineNumber

Integer

accomodationDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

accomodationDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

accomodationDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

accomodationDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

accomodationDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

accomodationDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

accomodationDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

accomodationDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

accomodationDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

accomodationDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

accomodationDiscountLines.pricingData.room
room_id
الغرفة
Room

Reference

HMSRoom

accomodationDiscountLines.pricingData.roomClassification
roomClassification_id
تصنيف الغرفة
Room Classification

Reference

HMSRoomClassification

accomodationDiscountLines.priority
priority
الأولوية
Priority

Long

accomodationDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

accomodationDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

accomodationDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

accomodationDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

attendantDiscountLines ( - )

Table Name: HMSDiscountAttendantLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
attendantDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

attendantDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

attendantDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

attendantDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

attendantDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

attendantDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

attendantDiscountLines.id
id

ID

attendantDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

attendantDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

attendantDiscountLines.lineNumber
lineNumber

Integer

attendantDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

attendantDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

attendantDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

attendantDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

attendantDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

attendantDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

attendantDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

attendantDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

attendantDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

attendantDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

attendantDiscountLines.pricingData.room
room_id
الغرفة
Room

Reference

HMSRoom

attendantDiscountLines.pricingData.roomClassification
roomClassification_id
تصنيف الغرفة
Room Classification

Reference

HMSRoomClassification

attendantDiscountLines.priority
priority
الأولوية
Priority

Long

attendantDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

attendantDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

attendantDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

attendantDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

bloodDiscountLines ( - )

Table Name: HMSDiscountBloodLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
bloodDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

bloodDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

bloodDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

bloodDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

bloodDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

bloodDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

bloodDiscountLines.id
id

ID

bloodDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

bloodDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

bloodDiscountLines.lineNumber
lineNumber

Integer

bloodDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

bloodDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

bloodDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

bloodDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

bloodDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

bloodDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

bloodDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

bloodDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

bloodDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

bloodDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

bloodDiscountLines.pricingData.invItem
invItem_id
الصنف
Item

Reference

InvItem

bloodDiscountLines.priority
priority
الأولوية
Priority

Long

bloodDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

bloodDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

bloodDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

bloodDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

labTestDiscountLines ( - )

Table Name: HMSDiscountLabTestLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
labTestDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

labTestDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

labTestDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

labTestDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

labTestDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

labTestDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

labTestDiscountLines.id
id

ID

labTestDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

labTestDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

labTestDiscountLines.lineNumber
lineNumber

Integer

labTestDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

labTestDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

labTestDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

labTestDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

labTestDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

labTestDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

labTestDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

labTestDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

labTestDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

labTestDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

labTestDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

labTestDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

labTestDiscountLines.pricingData.testType
testType_id
نوع التحليل
Laboratory Test Type

Reference

HMSLabTestType

labTestDiscountLines.priority
priority
الأولوية
Priority

Long

labTestDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

labTestDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

labTestDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

labTestDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

patientCheckDiscountLines ( - )

Table Name: HMSDiscountCheckLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
patientCheckDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

patientCheckDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

patientCheckDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

patientCheckDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

patientCheckDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

patientCheckDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

patientCheckDiscountLines.id
id

ID

patientCheckDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

patientCheckDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

patientCheckDiscountLines.lineNumber
lineNumber

Integer

patientCheckDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

patientCheckDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

patientCheckDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

patientCheckDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

patientCheckDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

patientCheckDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

patientCheckDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

patientCheckDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

patientCheckDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

patientCheckDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

patientCheckDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

patientCheckDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

patientCheckDiscountLines.pricingData.medicalSpecialty
medicalSpecialty_id
التخصص الطبي
Medical Specialty

Reference

HMSMedicalSpecialty

patientCheckDiscountLines.priority
priority
الأولوية
Priority

Long

patientCheckDiscountLines.procedureType
procedureType_id
نوع الإجراء
Procedure Type

Reference

HMSProcedureType

patientCheckDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

patientCheckDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

patientCheckDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

patientCheckDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

pharmacyDiscountLines ( - )

Table Name: HMSDiscountPharmacyLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
pharmacyDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

pharmacyDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

pharmacyDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

pharmacyDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

pharmacyDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

pharmacyDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

pharmacyDiscountLines.id
id

ID

pharmacyDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

pharmacyDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

pharmacyDiscountLines.lineNumber
lineNumber

Integer

pharmacyDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

pharmacyDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

pharmacyDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

pharmacyDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

pharmacyDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

pharmacyDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

pharmacyDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

pharmacyDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

pharmacyDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

pharmacyDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

pharmacyDiscountLines.pricingData.invItem
invItem_id
الصنف
Item

Reference

InvItem

pharmacyDiscountLines.priority
priority
الأولوية
Priority

Long

pharmacyDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

pharmacyDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

pharmacyDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

pharmacyDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

phyDiscountLines ( - )

Table Name: HMSDiscountPhyLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
phyDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

phyDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

phyDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

phyDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

phyDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

phyDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

phyDiscountLines.id
id

ID

phyDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

phyDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

phyDiscountLines.lineNumber
lineNumber

Integer

phyDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

phyDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

phyDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

phyDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

phyDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

phyDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

phyDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

phyDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

phyDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

phyDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

phyDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

phyDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

phyDiscountLines.pricingData.phyTherapyType
phyTherapyType_id
نوع العلاج الطبيعى
Physical Therapy Type

Reference

HMSPhysicalTherapyType

phyDiscountLines.priority
priority
الأولوية
Priority

Long

phyDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

phyDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

phyDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

phyDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

radiologyDiscountLines ( - )

Table Name: HMSDiscountRadiologyLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
radiologyDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

radiologyDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

radiologyDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

radiologyDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

radiologyDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

radiologyDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

radiologyDiscountLines.id
id

ID

radiologyDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

radiologyDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

radiologyDiscountLines.lineNumber
lineNumber

Integer

radiologyDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

radiologyDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

radiologyDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

radiologyDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

radiologyDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

radiologyDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

radiologyDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

radiologyDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

radiologyDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

radiologyDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

radiologyDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

radiologyDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

radiologyDiscountLines.pricingData.radiologyType
radiologyType_id
نوع الأشعة
Radiology Type

Reference

HMSRadiologyType

radiologyDiscountLines.priority
priority
الأولوية
Priority

Long

radiologyDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

radiologyDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

radiologyDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

radiologyDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

serviceDiscountLines ( - )

Table Name: HMSDiscountServiceLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
serviceDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

serviceDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

serviceDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

serviceDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

serviceDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

serviceDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

serviceDiscountLines.id
id

ID

serviceDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

serviceDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

serviceDiscountLines.lineNumber
lineNumber

Integer

serviceDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

serviceDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

serviceDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

serviceDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

serviceDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

serviceDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

serviceDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

serviceDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

serviceDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

serviceDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

serviceDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

serviceDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

serviceDiscountLines.pricingData.medicalService
medicalService_id
الخدمة الطبية
Medical Service

Reference

HMSMedicalService

serviceDiscountLines.pricingData.medicalSpecialty
medicalSpecialty_id
التخصص الطبي
Medical Specialty

Reference

HMSMedicalSpecialty

serviceDiscountLines.priority
priority
الأولوية
Priority

Long

serviceDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

serviceDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

serviceDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

serviceDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

supervisionDiscountLines ( - )

Table Name: HMSDiscountSupervisionLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
supervisionDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

supervisionDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

supervisionDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

supervisionDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

supervisionDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

supervisionDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

supervisionDiscountLines.id
id

ID

supervisionDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

supervisionDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

supervisionDiscountLines.lineNumber
lineNumber

Integer

supervisionDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

supervisionDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

supervisionDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

supervisionDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

supervisionDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

supervisionDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

supervisionDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

supervisionDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

supervisionDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

supervisionDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

supervisionDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

supervisionDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

supervisionDiscountLines.pricingData.room
room_id
الغرفة
Room

Reference

HMSRoom

supervisionDiscountLines.pricingData.roomClassification
roomClassification_id
تصنيف الغرفة
Room Classification

Reference

HMSRoomClassification

supervisionDiscountLines.priority
priority
الأولوية
Priority

Long

supervisionDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

supervisionDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

supervisionDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

supervisionDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

supplyDiscountLines ( - )

Table Name: HMSDiscountSuppliesLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
supplyDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

supplyDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

supplyDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

supplyDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

supplyDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

supplyDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

supplyDiscountLines.id
id

ID

supplyDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

supplyDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

supplyDiscountLines.lineNumber
lineNumber

Integer

supplyDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

supplyDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

supplyDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

supplyDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

supplyDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

supplyDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

supplyDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

supplyDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

supplyDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

supplyDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

supplyDiscountLines.pricingData.invItem
invItem_id
الصنف
Item

Reference

InvItem

supplyDiscountLines.priority
priority
الأولوية
Priority

Long

supplyDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

supplyDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

supplyDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

supplyDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

surgeryDiscountLines ( - )

Table Name: HMSDiscountSurgeryLine, Join Column: hMSDiscount_id

Property
Column
Arabic
English
Type
Foreign Table
surgeryDiscountLines.companyEndurancePercent
companyEndurancePercent
نسبة تحمل الشركة
Company Endurance Percent

Decimal

surgeryDiscountLines.discount1MaxValue
discount1MaxValue
نسبة خصم 1 | أقصى قيمة
Discount 1 Percent | Max Value

Decimal

surgeryDiscountLines.discount1Percent
discount1Percent
نسبة خصم 1 | %
Discount 1 Percent | %

Decimal

surgeryDiscountLines.discount2MaxValue
discount2MaxValue
نسبة خصم 2 | أقصى قيمة
Discount 2 Percent | Max Value

Decimal

surgeryDiscountLines.discount2Percent
discount2Percent
نسبة خصم 2 | %
Discount 2 Percent | %

Decimal

surgeryDiscountLines.hmsDocCategory
hmsDocCategory_id
تصنيف طبى للمستند
Medical Document Category

Reference

HMSDocumentCategory

surgeryDiscountLines.id
id

ID

surgeryDiscountLines.insuranceClass
insuranceClass_id
فئة التأمين
Insurance Class

Reference

HMSInsuranceClass

surgeryDiscountLines.insuranceCompanyClass
insuranceCompanyClass_id
فئة شركة تأمين طبى
Medical Insurance Company Class

Reference

HMSInsuranceCompanyClass

surgeryDiscountLines.lineNumber
lineNumber

Integer

surgeryDiscountLines.medicalInsuranceCompany
medicalInsuranceCompany_id
شركة التأمين الطبى
Medical Insurance Company

Reference

HMSInsuranceCompany

surgeryDiscountLines.patient
patient_id
المريض
Patient

Reference

HMSPatient

surgeryDiscountLines.patientAdmission
patientAdmission_id
إستمارة دخول المريض
Patient Admission

Reference

HMSPatientAdmission

surgeryDiscountLines.patientClass
patientClass_id
فئة المريض
Patient Classification

Reference

HMSPatientClass

surgeryDiscountLines.patientEndurancePercent
patientEndurancePercent
نسبة تحمل المريض
Patient Endurance Percent

Decimal

surgeryDiscountLines.priceClassifier1
priceClassifier1_id
محدد سعر 1
Price Classifier 1

Reference

SalesPriceClassifier1

surgeryDiscountLines.priceClassifier2
priceClassifier2_id
محدد سعر 2
Price Classifier 2

Reference

SalesPriceClassifier2

surgeryDiscountLines.priceClassifier3
priceClassifier3_id
محدد سعر 3
Price Classifier 3

Reference

SalesPriceClassifier3

surgeryDiscountLines.priceClassifier4
priceClassifier4_id
محدد سعر 4
Price Classifier 4

Reference

SalesPriceClassifier4

surgeryDiscountLines.priceClassifier5
priceClassifier5_id
محدد سعر 5
Price Classifier 5

Reference

SalesPriceClassifier5

surgeryDiscountLines.pricingData.docDegree
docDegree
الدرجة
Degree

HMSDocDegree

surgeryDiscountLines.pricingData.doctor
doctor_id
الطبيب
Doctor

Reference

HMSDoctor

surgeryDiscountLines.pricingData.surgeryType
surgeryType_id
نوع العملية الجراحية
Surgery Type

Reference

HMSSurgeryType

surgeryDiscountLines.priority
priority
الأولوية
Priority

Long

surgeryDiscountLines.subsidiary
subsidiaryActualCode, subsidiaryCode, subsidiaryEntityType, subsidiaryId
الذمة
Subsidiary

Genericreference

surgeryDiscountLines.surgeryClassification
surgeryClassification_id
تصنيف العملية
Surgery Classification

Reference

HMSSurgeryClassification

surgeryDiscountLines.validFrom
validFrom
صالح من
Valid from

Date

surgeryDiscountLines.validTo
validTo
صالح حتي
Valid to

Date

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