03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| ProjectResource | |||||||||||||||||||||||||||||
| 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 | ||||||
| CostCode | Cost Code | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Project CostCode | LAB | Text | String | OptionalUse | > | The reference of a Project Cost Code that the resource is associated with. | ||||||||||
| Name | Name | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Resource Name | A sample name | Text | String | OptionalUse | > | The name of the resource. | ||||||||||
| Rate | Rate | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Resource Charge Rate | 100 | Numeric | 8ByteDouble | RequiredUse | > | The net value of carriage for the order. | ||||||||||
| Reference | Reference | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Resource Reference | SKYEWR01 | Text | String | SpecialUse | primary="Y" | > | The reference for the resource.<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.. | |||||||||
| ResourceID | Resource 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 Resource. | ||||||||||
| Unit | Unit | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Resource Unit | A sample unit | Text | String | OptionalUse | > | The unit of the resource. | </header> | </sydd> | ||||||||