Automatic Transaction Numbering

Automatic transaction number assignment is established on Automatic Transaction Numbering (ADNT) with the tracking of the last number assigned occurring on Unique Numbers (UNUM). The creation of the transaction numbering rule does not automatically create a Unique Number entry. That creation occurs the first time the numbering rule is used. As there are numbering options on Application Parameter and Transaction Control setup pages, please ensure setup between the three is in sync so that errors are not issued upon transaction creation.

The fields on Automatic Transaction Numbering (ADNT) are as follows:

Field Name

Field Description

Fiscal Year

Transaction numbering setup is done on a yearly basis.

Transaction Code

Each numbering rule must contain a transaction code.

Department

Transaction numbering rules must have a value in this field which is either Department for a numbering scheme unique to that department or a value of **** for a numbering scheme shared by departments without a unique numbering scheme assigned.

Prefix

Transaction numbering rules must have a value in this field that is from one to four characters in length or a value of ****. A prefix is commonly used to identify transactions created for a specific reason or from a specific source or batch program. Any characters, numbers, or symbols can be used in a prefix.

There may be site specific reasons for not including certain symbols in prefix values because of transaction ID parsing that may occur for integrations. Such restrictions are most often enforced though security on this page and responsible individuals with that security.

Usage

Three values control the usage of an automatic numbering scheme:

  • Not Restricted – The scheme can be open to online and batch program.

  • Internal – The scheme can only be used on the Transaction Catalog and other online pages for creating transactions.

  • External- The scheme cannot be used online and can only be used by a batch program.

Required

When true, an online or batch attempt to create a transaction that matches the numbering scheme will not be allowed. Automatic numbering must be used.

Include Date

When true, the transaction ID generated will have a data component reflecting the period in time when the transaction was created. If a prefix is used, the date will follow.

Date Format

When the Include Date indication is true, one of the various Date Format choices other than None must be selected.

  • None - No date of any kind included

  • YY - Year

  • CCYY - Century, Year

  • YYMMDD - Year, Month, Day

  • CCYYMMDD - Century, Year, Month, Day

  • DDMMYY - Day, Month, Year

  • DDMMCCYY - Day, Month, Century, Year

  • MMDDYY - Month, Day, Year

  • MMDDCCYY - Month, Day, Century, Year

If either YY or CCYY is used, the system will place the YY or CCYY value of the default Fiscal Year of the Application Date as defined on Calendar Date (CLDT). For all other Date Format values, the application will use the Application Date in one of several formats. With these formats, the year will be the Calendar Year as opposed to the Fiscal Year with YY and CCYY.

Number From

Every automatic numbering scheme must have a starting number. If 0 is used, the first number will be 1.

Number To

Every automatic numbering scheme must have an ending number. As there often is no hard limit to the upper end of a numbering scheme, a series of 9’s is used that equals the Format Field Length – Prefix – Date in length.

Last Number

A display from the Unique Numbers record showing the last number assigned to a transaction.

Format Field Length

The defined length of the auto generated Transaction ID. Twenty is the maximum length of a transaction ID to include any Prefix, Date and numbering range.

Transaction numbering can be controlled in many different ways. Numbering is always done at the transaction code level. Numbering will always restart each fiscal year unless the Number From value in a new year is set to equal the Last Number value from the prior year. Numbering then will occur in one of these manners:

  1. A sequence of numbers will occur for all departments without a prefix. Established as **** in the Department and Prefix fields.

  2. A sequence of numbers will occur for all departments with a certain prefix. Established as **** in the Department field and a Prefix value other than ****.

  3. A sequence of numbers will occur for a single department without a prefix. Established as a Department value other than **** and a Prefix value of ****.

  4. A sequence of numbers will occur for a single department within a certain prefix. Established as values other than **** in the Department and Prefix fields.