X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FContribute%2FProduct.xml;h=8c18004c2cd1082e9ec91c9872a1f9e2d8b4ee61;hb=d5fd88834139d3bd5be9a170e5689c50c42783e3;hp=93c401305cc30485ca3a39cc7f0573fe5f9c8297;hpb=51daafaadd025703b2f8d6e3d27898e3768908f9;p=civicrm-core.git
diff --git a/xml/schema/Contribute/Product.xml b/xml/schema/Contribute/Product.xml
index 93c401305c..8c18004c2c 100644
--- a/xml/schema/Contribute/Product.xml
+++ b/xml/schema/Contribute/Product.xml
@@ -8,200 +8,202 @@
1.4
true
- id
- int unsigned
- true
- 1.4
+ id
+ Product ID
+ int unsigned
+ true
+ 1.4
- id
- true
+ id
+ true
- name
- product_name
- Product Name
- varchar
- 255
- true
- true
- true
- Required product/premium name
- 1.4
-
-
- description
- Description
- text
- true
- Optional description of the product/premium.
- 1.4
-
-
- sku
- SKU
- varchar
- 50
- true
- Optional product sku or code.
- 1.4
-
-
- options
- Options
- text
- true
- Store comma-delimited list of color, size, etc. options for the product.
- 1.4
-
-
- image
- Image
- varchar
- 255
- Full or relative URL to uploaded image - fullsize.
- 1.4
-
-
- thumbnail
- Thumbnail
- varchar
- 255
- Full or relative URL to image thumbnail.
- 1.4
-
-
- price
- Price
- decimal
- Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record.
- 1.4
-
-
- currency
- varchar
- 3
- NULL
- 3 character string, value from config setting or input via user.
- 3.2
-
-
- name
- full_name
- numeric_code
-
-
- Select
-
-
-
- financial_type_id
- Financial Type
- int unsigned
- NULL
-
-
- id
- name
-
- FK to Financial Type.
- 4.3
+ name
+ product_name
+ Product Name
+ varchar
+ 255
+ true
+ true
+ true
+ Required product/premium name
+ 1.4
+
+
+ description
+ Description
+ text
+ true
+ Optional description of the product/premium.
+ 1.4
+
+
+ sku
+ SKU
+ varchar
+ 50
+ true
+ Optional product sku or code.
+ 1.4
+
+
+ options
+ Options
+ text
+ true
+ Store comma-delimited list of color, size, etc. options for the product.
+ 1.4
+
+
+ image
+ Image
+ varchar
+ 255
+ Full or relative URL to uploaded image - fullsize.
+ 1.4
+
+
+ thumbnail
+ Thumbnail
+ varchar
+ 255
+ Full or relative URL to image thumbnail.
+ 1.4
+
+
+ price
+ Price
+ decimal
+ Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record.
+ 1.4
+
+
+ currency
+ varchar
+ 3
+ NULL
+ 3 character string, value from config setting or input via user.
+ 3.2
+
+
+ name
+ full_name
+ name
+ symbol
+
+
+ Select
+
+
+
+ financial_type_id
+ Financial Type
+ int unsigned
+ NULL
+
+
+ id
+ name
+
+ FK to Financial Type.
+ 4.3
- financial_type_id
-
- id
- SET NULL
- 4.3
+ financial_type_id
+
+ id
+ SET NULL
+ 4.3
- min_contribution
- Minimum Contribution
- decimal
- Minimum contribution required to be eligible to select this premium.
- 1.4
-
-
- cost
- Cost
- decimal
- Actual cost of this product. Useful to determine net return from sale or using this as an incentive.
- 1.4
-
-
- is_active
- Is Active
- boolean
- true
- Disabling premium removes it from the premiums_premium join table below.
- 1.4
-
-
- period_type
- Period Type
- varchar
- 8
- 'rolling'
- Rolling means we set start/end based on current day, fixed means we set start/end for current year or month
-(e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006)
-
- CRM_Core_SelectValues::periodType
-
- 1.4
-
- Select
-
-
-
- fixed_period_start_day
- Fixed Period Start Day
- int
- 0101
- Month and day (MMDD) that fixed period type subscription or membership starts.
- 1.4
-
-
- duration_unit
- Duration Unit
- varchar
- 8
- 'year'
-
- CRM_Core_SelectValues::getPremiumUnits
-
- 1.4
-
- Select
-
-
-
- duration_interval
- Duration Interval
- int
- Number of units for total duration of subscription, service, membership (e.g. 12 Months).
- 1.4
-
-
- frequency_unit
- Frequency Unit
- varchar
- 8
- 'month'
- Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.
-
- CRM_Core_SelectValues::getPremiumUnits
-
- 1.4
-
- Select
-
-
-
- frequency_interval
- Frequency Interval
- int
- Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).
- 1.4
+ min_contribution
+ Minimum Contribution
+ decimal
+ Minimum contribution required to be eligible to select this premium.
+ 1.4
+
+
+ cost
+ Cost
+ decimal
+ Actual cost of this product. Useful to determine net return from sale or using this as an incentive.
+ 1.4
+
+
+ is_active
+ Is Active
+ boolean
+ true
+ Disabling premium removes it from the premiums_premium join table below.
+ 1.4
+
+
+ period_type
+ Period Type
+ varchar
+ 8
+ 'rolling'
+ Rolling means we set start/end based on current day, fixed means we set start/end for current year or month
+ (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006)
+
+ CRM_Core_SelectValues::periodType
+
+ 1.4
+
+ Select
+
+
+
+ fixed_period_start_day
+ Fixed Period Start Day
+ int
+ 0101
+ Month and day (MMDD) that fixed period type subscription or membership starts.
+ 1.4
+
+
+ duration_unit
+ Duration Unit
+ varchar
+ 8
+ 'year'
+
+ CRM_Core_SelectValues::getPremiumUnits
+
+ 1.4
+
+ Select
+
+
+
+ duration_interval
+ Duration Interval
+ int
+ Number of units for total duration of subscription, service, membership (e.g. 12 Months).
+ 1.4
+
+
+ frequency_unit
+ Frequency Unit
+ varchar
+ 8
+ 'month'
+ Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.
+
+ CRM_Core_SelectValues::getPremiumUnits
+
+ 1.4
+
+ Select
+
+
+
+ frequency_interval
+ Frequency Interval
+ int
+ Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).
+ 1.4