Document Sequence (Window ID-112)
Window: Document Sequence
Description: Maintain System and Document Sequences
Help: The Sequence Window defines how document numbers will be sequenced. Change the way document numbers are generated. You may add a prefix or a suffix or change the current number.
Tab: Sequence
Description: Sequence Definition
Help: The Sequence Tab defines the numeric sequencing to use for documents. These can also include a alpha suffix and / or prefix.
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_Sequence.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | AD_Sequence.AD_Org_ID numeric(10) Table Direct |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | AD_Sequence.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | AD_Sequence.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
AD_Sequence.IsActive character(1) Yes-No |
| Auto numbering | Automatically assign the next number | The Auto Numbering checkbox indicates if the system will assign the next number automatically. | AD_Sequence.IsAutoSequence character(1) Yes-No |
| Used for Record ID | The document number will be used as the record key | The Used for Record ID checkbox indicates if the document id will be used as the key to the record | AD_Sequence.IsTableID character(1) Yes-No |
| Value Format | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | Validation elements:
(Space) any character _ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters & Digits NO space A any Letters & Digits NO space converted to upper case c any Letters & Digits or space C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000" |
AD_Sequence.VFormat character varying(40) String |
| Increment | The number to increment the last document number by | The Increment indicates the number to increment the last document number by to arrive at the next sequence number | AD_Sequence.IncrementNo numeric(10) Integer |
| Current Next | The next number to be used | The Current Next indicates the next number to use for this document | AD_Sequence.CurrentNext numeric(10) Integer |
| Decimal Pattern | Java Decimal Pattern | Option Decimal pattern in Java notation. Examples: 0000 will format 23 to 0023 | AD_Sequence.DecimalPattern character varying(40) String |
| Prefix | Prefix before the sequence number | The Prefix indicates the characters to print in front of the document number. | AD_Sequence.Prefix character varying(255) String |
| Suffix | Suffix after the number | The Suffix indicates the characters to append to the document number. | AD_Sequence.Suffix character varying(255) String |
| Organization level | This sequence can be defined for each organization | AD_Sequence.IsOrgLevelSequence character(1) Yes-No | |
| Org Column | Fully qualified Organization column (AD_Org_ID) | The Organization Column indicates the organization to be used in calculating this measurement. | AD_Sequence.OrgColumn character varying(60) String |
| Restart sequence every Year | Restart the sequence with Start on every 1/1 | The Restart Sequence Every Year checkbox indicates that the documents sequencing should return to the starting number on the first day of the year. | AD_Sequence.StartNewYear character(1) Yes-No |
| Date Column | Fully qualified date column | The Date Column indicates the date to be used when calculating this measurement | AD_Sequence.DateColumn character varying(60) String |
| Restart sequence every month | AD_Sequence.StartNewMonth character(1) Yes-No | ||
| Start No | Starting number/position | The Start Number indicates the starting position in the line or field number in the line | AD_Sequence.StartNo numeric(10) Integer |
Tab: Sequence No
Description:
Help:
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_Sequence_No.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | AD_Sequence_No.AD_Org_ID numeric(10) Table Direct |
| Sequence | Document Sequence | The Sequence defines the numbering sequence to be used for documents. | AD_Sequence_No.AD_Sequence_ID numeric(10) Table Direct |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
AD_Sequence_No.IsActive character(1) Yes-No |
| Year Month | YYYYMM | AD_Sequence_No.CalendarYearMonth character varying(6) String | |
| Current Next | The next number to be used | The Current Next indicates the next number to use for this document | AD_Sequence_No.CurrentNext numeric(10) Integer |
