Entity.Property - add ability to designate Default value

[#1]

Please enhance Entity.Property definitions as follows:

1. For each Entity.Property, please add the ability to designate a default value.
2. Please also make this default configuration information available for run-time inspection via the Entity Interface.
3. Please allow dynamic values (via expressions, etc.) - where the nature of the Default value configuration may change based on the Data Type.
4. Please provide useful default value short-cuts for specific Sage/SLX property types (ex.Picklist)
5. Please allow designation of a Property defaultvalue as being copied from the Parent Entity
6. Please automatically generate and incorporate setting these default behaviors into the Entity CRUD method used for Entity OnCreate() event handler.

Examples of default short-cuts for specific Sage/SLX property types

Picklists

Be able to designate a static value, or DefaultPicklistItem.Code / .Value / .Id

Date/DateTime

For example - for a Date or DateTime property data type; in addition to a static datetime value the default should also be able to be expressed as various datetime functions including NowUTC, NowLocalTz, TodayUTC, TodayLocalTZ, various handy DateTime shortcuts (FirstDayOfWeek, LastDayOfWeek, FirstDaOfMonth, LastDayOfMonth, etc.).

Expressions or Code-Snippets as Defaults

Expressions, or better still full code snippets should be allowed as Default property value definitions in order to support special business logic needs

Designate a parent property

It is sometimes useful to define a default property value as being retrieved from a specific Parent property if the parent record already exists.

For example - adding a Contact to a preexisting Account. Phone numbers, webURLs. and work Address are examples where it would be useful to be able to express the business logic in terms of Default values to be copied from the Parent Entity (or some related Entity) and then automatically set at run-time during the Entity OnCreate() event.

[#2]

I've got a whole arsenal of date calculations that I could add to this mix. At least 20 of them. There are some good examples in products like KnowledgeSync as well.

[#3]

Hi Mike - If you can spare a little time to dig those out, would be great to post here. I will try to dig a few up from KnowledgeSync, TaskCentre, SQL Scheduler, etc. as well.

[#4]

How about:

 FirstBusinessDayAfterHoliday

LastBusinessDayBeforeHoliday

I had to build these out in TC - it's a little tricky but VERY useful when it comes to automatically scheduling activities. 

[#5]

Just finishing up the SLX Master's Series training today - In the Experts Interviews with  John P. and Jeff H. some mention was made about the SData specification and Template Requests indicating that the Template woudl be returned with various property default values and system generated values.

Possibly we can marry these two concepts together for SData feeds that are created by AA (aka Dynamic feeds).