03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| ProjectStatus | |||||||||||||||||||||||||||||
| Name | Label | Prefix | Postfix | Minlength | Maxlength | Widthhint | Padding | Alignment | Casesensitive | Allcaps | Dp | Minvalue | Maxvalue | Validchars | Validformat | Tooltip | Sample | Default | Nature | Storage | Usage | Primary Key | Details | ||||||
| Default | Default? | 0 | 1 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]*$ | Is Default? | Y | N | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the status is the default one. | |||||||||
| Deletion | Deletion? | 0 | 1 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]*$ | Allow Deletion? | Y | N | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the status allows deletion. | |||||||||
| Name | Name | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Project Name | A Sample Name | Text | String | RequiredUse | > | The name associated with the project. | ||||||||||
| Postings | Postings? | 0 | 2 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty\-]$ | ^[01FNTYfnty\-]*$ | Allow Postings? | Y | N | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the status allows postings. | |||||||||
| Reference | Reference | 0 | 15 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Project Reference | SKYEWR01 | Text | String | SpecialUse | primary="Y" | > | The reference for the project status.<br>Valid references consist of uppercase letters or numbers or both. As well as letters and numbers you may use <strong>-_</strong> and <strong>&</strong>. Spaces are not allowed.. | |||||||||
| StatusID | Status ID | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Unique identifier | 21 | Text | 4ByteInt | SpecialUse | > | Auto-generated Unique identifier for the Status. | </header> | </sydd> | ||||||||