Window: Document Sequence
[Created: 11/06/1999 - Updated: 02/01/2000 ]
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
[Created: 19/06/1999 - Updated: 02/01/2000 ]
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.
Tab Level: 0
Table 10: Sequence - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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", or ~regex | Validation elements:~regex - Validates a regular expression (Space) any character_Space (fixed character)lany Letter a..Z NO spaceLany Letter a..Z NO space converted to upper caseoany Letter a..Z or spaceOany Letter a..Z or space converted to upper caseaany Letters & Digits NO spaceAany Letters & Digits NO space converted to upper casecany Letters & Digits or spaceCany Letters & Digits or space converted to upper case0Digits 0..9 NO space9Digits 0..9 or spaceExample 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(124) 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(124) 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
[Created: 15/03/2012 - Updated: 12/07/2012 ]
Description:
Help:
Tab Level: 1
Table 20: Sequence No - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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 |