DiscountCoupon

Arabic: قسيمة خصومات - قسيمة خصومات English: Discount Coupon - Discount Coupon

details (DiscountCouponLine)

Fields

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

AnalysisSet

analysisSetId
analysisSet_id
ID
attachment1
attachment1_id
مرفق 1
Attachment 1
Binary

LargeData

attachment2
attachment2_id
مرفق 2
Attachment 2
Binary

LargeData

attachment3
attachment3_id
مرفق 3
Attachment 3
Binary

LargeData

attachment4
attachment4_id
مرفق 4
Attachment 4
Binary

LargeData

attachment5
attachment5_id
مرفق 5
Attachment 5
Binary

LargeData

branch
branch_id
الفرع
Branch
Reference

Branch

branchId
branch_id
Branch ID
Branch ID
ID
code
code
الكود
Code
Text
colorCode
colorCode
كود اللون
Color Code
Color
commitedBefore
commitedBefore
تم الحفظ مسبقا
Commited Before
Boolean
couponType
couponType_id
نوع القسيمة
Coupon Type
Reference

DiscountCouponType

couponValue.amount
couponValueAmount
المبلغ
Amount
Decimal
couponValue.currency
couponValueCurrency_id
العملة
Currency
Reference

Currency

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
discountCouponBook
discountCouponBook_id
دفتر قسيمة خصومات
Discount Coupon Book
Reference

DiscountCouponBook

discountCouponType
discountCouponType
طريفة حساب القسيمة
Discount Coupon Calculation Type
Enum
docCategory
docCategory_id
تصنيف سجل
Record Category
Reference

DocCategory

documentFileStatus
documentFileStatus
حالة المستند
Document File Status
Enum
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
fromDate
fromDate
من تاريخ
From Date
Date
genFrom
genFromActualCode, genFromCode, genFromEntityType, genFromId
منشأه من
Generated From
Genericreference
genFromInvoiceIsReturned
genFromInvoiceIsReturned
تم عمل مردود للفاتورة المنشأه للقسيمه
Generated From Invoice Is Returned
Boolean
generatedByLine
generatedByLine
كود سطر الإنشاء
generated By Line
Text
generatedDocsCount
generatedDocsCount
Integer
generatedFrom
generatedFromActualCode, generatedFromCode, generatedFromEntityType, generatedFromId
تم إنشاؤه من
Generated From
Genericreference
generationType
generationType
نوع الإنشاء
Generation Type
Enum
group
group_id
المجموعة
Group
Reference

MasterGroup

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

maxCouponValue
maxCouponValue
اقصي قيمة للكوبون(خاص بالنسبة)
Maximum Coupon Value (Used With Percentage Type)
Decimal
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
otpToken
otpToken
Customer Token
Customer Token
Text
parentCode
parentCode
Text
percentage
percentage
النسبة
Percentage
Decimal
preventUsage
preventUsage
منع الاستعمال
Prevent Usage
Boolean
printCount
printCount
عدد مرات الطباعة
Print Count
Integer
redeemed
redeemed
Redeemed
Redeemed
Boolean
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
registerId
registerId
ID
remaining
remaining
المتبقي
Remaining
Decimal
remarks
remark
ملاحظات
Description
BigText
reversed
reversed
Reversed
Reversed
Boolean
reversedBy
reversedByActualCode, reversedByCode, reversedByEntityType, reversedById
Genericreference
reviseLevel
reviseLevel
مستوى المراجعة
Revise Level
Enum
revised
primitiveValue
تمت المراجعة
Revised
Boolean
revisedBy
revisedBy_id
Reference

NaMaUser

rewardPointTransRequestId
rewardPointTransRequestId
Text
rewardPointTransactionId
rewardPointTransactionId
Reward Point Transaction ID
Reward Point Transaction ID
Text
rewardPointTransactionTime
rewardPointTransactionTime
Reward Point Transaction Time
Reward Point Transaction Time
DateAndTime
rewardPointsConfig
rewardPointsConfig_id
إعدادات نقاط المكافأة
Reward Points Configuration
Reference

RewardPointsConfig

sector
sector_id
القطاع
Sector
Reference

Sector

sectorId
sector_id
ID
status
status
الحالة
Status
Enum
systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix
Text
target
targetActualCode, targetCode, targetEntityType, targetId
الجهة
Taregt
Genericreference
toDate
toDate
إلى تاريخ
To Date
Date
updateCapability
updateCapability_id
صلاحية التعديل
Update Capability
Reference

SecurityCapability

updateCapabilityId
updateCapability_id
ID
usageCapability
usageCapability_id
صلاحية الاستخدام
Usage Capability
Reference

SecurityCapability

usageCapabilityId
usageCapability_id
ID
useAsDiscountInInvoices
useAsDiscountInInvoices
استعمال الكوبون كتخفيض في الفواتير
Use As Discount In Invoices
Boolean
usedInInvoices
usedInInvoices
مستخدمة سابقا
Used In Invoices
Boolean
usedOnce
usedOnce
تستخدم مره واحده
Used Once
Boolean
viewCapability
viewCapability_id
صلاحية المطالعة
View Capability
Reference

SecurityCapability

viewCapabilityId
viewCapability_id
ID
voucherType
voucherType
نوع الخصم
Voucher Type
Enum

details (التفاصيل - Details)

Table Name: DiscountCouponLine, Join Column: discountCoupon_id

Property
Column
Arabic
English
Type
Foreign Table
details.id
id
ID
details.invoiceCode
invoiceCode
كود الفاتورة
Invoice Code
Text
details.invoiceId
invoiceId
Invoice Id
Invoice Id
ID
details.lineNumber
lineNumber
Integer
details.registerCode
registerCode
كود الماكينة
Register Code
Text
details.salesInvoice
salesInvoiceActualCode, salesInvoiceCode, salesInvoiceEntityType, salesInvoiceId
فاتورة المبيعات
Sales Invoice
Genericreference
details.value
value
القيمة
Value
Decimal