Date Effective Patterns (White paper) [AX 2012]
Updated: July 12, 2011
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This white paper describes how to use date effective tables, also known as valid time state tables, to store and track object history in Microsoft Dynamics AX 2012.
The difference between the two types of valid time state tables
How valid time state tables are integrated with the security framework
Various update modes
How to use the validtimestate keyword in queries
Scenarios that are not supported by the framework
The paper also suggests design patterns for forms that use valid time state tables.