Calculated Attribute expressions can be written using the following available functions. Use Cases follow the available functions table.
When using Print Publisher, these functions only return a value if a publication version is selected. For information on selecting a version, refer to the Publication Versions section of the Getting Started documentation here.
In addition to using commercial value functions for publications, they can also be used without actually publishing anything. For example, you can use price sheets stored in an eCatalog hierarchy to maintain price information.
Note: The [effective date] parameter uses 'ISO Date and Time' format (YYYY-MM-DD 24:MI:SS). If not supplied, the current date / time are assumed.
|
Function |
Parameters |
Description |
|---|---|---|
|
TERMQTYMAX |
('termslisttype-id', 'break-no'[, effectivedate]) |
Return the maximum quantity of the supplied 'termslist type id' for the current publication version or eCatalog in the supplied break-no for the given effective date. [effective date] is optional. |
|
TERMQTYMIN |
('termslisttype-id', 'break-no'[, effectivedate]) |
Return the minimum quantity of the supplied 'termslist type id' for the current publication version or eCatalog in the supplied break-no for the given effective date. [effective date] is optional. |
|
TERMUNIT |
('termslisttype-id', 'break-no'[, effectivedate]) |
Returns the name of the unit of the term of the supplied 'termslist type id' for the current publication version or eCatalog in the supplied break-no for the given effective date. [effective date] is optional. |
|
TERMUNITID |
('termslisttype-id', 'break-no'[, effectivedate]) |
Returns the ID of the unit of the term of the supplied 'termslist type id' for the current publication version or eCatalog in the supplied break-no for the given effective date. [effective date] is optional. |
|
TERMVAL |
('termslisttype-id', 'break-no'[, effectivedate]) |
Returns the term value of the supplied 'termslist type id ' for the current publication version or eCatalog hierarchy in the supplied 'break no' for the given effective date. [effective date] is optional. |
|
TERMVALID |
('termslist-id', 'break-no'[, effectivedate]) |
Return the term value of the supplied 'termslist id' for the current publication version or eCatalog in the supplied break-no for the given effective date. [effective date] is optional. |
Use Cases
For examples of these functions, refer to Commercial Examples here.
For a scenario using commercial value functions, refer to Commercial Data Scenario here.