Difference between revisions of "Auto Values"
Jump to navigation
Jump to search
Line 26: | Line 26: | ||
|A number starting at 1 when the sequence is first used and incremented by one each time the sequence is used and will never be reset for the entire life of the sequence. | |A number starting at 1 when the sequence is first used and incremented by one each time the sequence is used and will never be reset for the entire life of the sequence. | ||
|} | |} | ||
+ | |||
|- | |- | ||
Line 39: | Line 40: | ||
|A number starting at 1 at the beginning of each day, and incremented by one each time the sequence is used. This is the daily incremental value for this specific sequence instance. | |A number starting at 1 at the beginning of each day, and incremented by one each time the sequence is used. This is the daily incremental value for this specific sequence instance. | ||
|} | |} | ||
+ | |||
|- | |- | ||
Line 52: | Line 54: | ||
|A number starting at 1 at the beginning of each month, and incremented by one each time the sequence is used. This is the monthly incremental value for this specific sequence instance. | |A number starting at 1 at the beginning of each month, and incremented by one each time the sequence is used. This is the monthly incremental value for this specific sequence instance. | ||
|} | |} | ||
+ | |||
+ | |||
|- | |- | ||
|nowrap="1"|'''seqy(''' ''z'', ''r'' ''')''' | |nowrap="1"|'''seqy(''' ''z'', ''r'' ''')''' |
Revision as of 17:29, 20 February 2015
Home > Administration > Data > Auto Values
Introduction
The Auto Values feature lets an administrator define how auto-generated values, such as reference IDs, are constructed. Places where more than a sequence number (000001234) is required, an Auto Value can be modified to include dates, time, location, teams, user IDs and more. There are many situations where this type of sequence is much more preferable over a simple numeric sequences. Some examples include:
- Shipment numbers
- Document or Article Reference Numbers
- Stock Item Codes
- Asset ID's
- Access Code numbers
Available Auto Value Component Parts
The following lists of component parts are available to construct an auto value.
seq( z, r ) |
| ||||||||||||||||||||||
seqd( z, r ) |
| ||||||||||||||||||||||
seqm( z, r ) |
| ||||||||||||||||||||||
seqy( z, r ) |
| ||||||||||||||||||||||
| |||||||||||||||||||||||
date( [part] ) |
| ||||||||||||||||||||||
udate( [part] ) |
| ||||||||||||||||||||||
uuid( [type] ) |
| ||||||||||||||||||||||
sess( prop_name ) |
| ||||||||||||||||||||||
param(param_name) |
| ||||||||||||||||||||||
rec( column_name ) |
|