ManPageW DocumentSequence
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
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.
Table Name : AD_Sequence
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
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. | Name
VARCHAR2 String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
Auto numbering | Automatically assign the next number | The Auto Numbering checkbox indicates if the system will assign the next number automatically. | IsAutoSequence
CHAR(1) YesNo |
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 | IsTableID
CHAR(1) YesNo |
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" |
VFormat
NVARCHAR2(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 | IncrementNo
NUMBER(10) Integer |
Current Next | The next number to be used | The Current Next indicates the next number to use for this document | CurrentNext
NUMBER(10) Integer |
Decimal Pattern | Java Decimal Pattern | Option Decimal pattern in Java notation. Examples: 0000 will format 23 to 0023 | DecimalPattern
NVARCHAR2(40) String |
Start No | Starting number/position | The Start Number indicates the starting position in the line or field number in the line | StartNo
NUMBER(10) Integer |
Date Column | Fully qualified date column | The Date Column indicates the date to be used when calculating this measurement | DateColumn
NVARCHAR2(60) String |
Prefix | Prefix before the sequence number | The Prefix indicates the characters to print in front of the document number. | Prefix
NVARCHAR2(255) String |
Suffix | Suffix after the number | The Suffix indicates the characters to append to the document number. | Suffix
NVARCHAR2(255) String |