Table idempiere9.adempiere.m_promotionreward
Setup reward for the promotion

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
ad_org_id numeric 10 NULL::numeric Organizational entity within client
amount numeric 0  √  null Amount in a defined currency
c_charge_id numeric 10  √  null Additional document charges
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
distributionsorting bpchar 1  √  null Quantity distribution sorting by unit price
isactive bpchar 1 'Y'::bpchar The record is active in the system
isforalldistribution bpchar 1 'N'::bpchar This reward is for all distribution
issamedistribution bpchar 1  √  'Y'::bpchar Use the same distribution for source and target
m_promotiondistribution_id numeric 10  √  null
m_promotiondistribution.m_promotiondistribution_id mpromotiondistribution_mpromot R
Promotion Distribution
m_promotionreward_id numeric 10 Promotion Reward
m_promotion_id numeric 10
m_promotion.m_promotion_id mpromotion_mpromotionreward R
Promotion
m_targetdistribution_id numeric 10  √  null
m_promotiondistribution.m_promotiondistribution_id mtargetdistribution_mpromotion R
Get product from target distribution to apply the promotion reward
qty numeric 0  √  null Quantity
rewardtype bpchar 1 Type of reward which consists of percentage discount, flat discount or absolute amount
seqno numeric 10 NULL::numeric Method of ordering records; lowest number comes first
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
m_promotionreward_uu varchar 36  √  NULL::character varying M_PromotionReward_UU

Table contained 0 rows at 2021-12-25 14:54 +0100

Indexes:
Column(s) Type Sort Constraint Name
m_promotionreward_id Primary key Asc m_promotionreward_key
m_promotionreward_uu Must be unique Asc m_promotionreward_uu_idx

Close relationships  within of separation: