03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| SCHEME_DISCOUNT_ITEM | |||||||||||||||||||||||||||||
| 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 | ||||||
| STOCK_CODE | Stock Code | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Stock identifier | A-STOCK-CODE | Text | String | SpecialUse | > | The identifying code for the stock item. | ||||||||||
| SCHEME | Scheme | 0 | 1 | 1 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-E]*$ | ^[A-E]*$ | Scheme name | A | Text | String | SpecialUse | > | The identifying code for the scheme. | ||||||||||
| LEVEL | Level | 0 | 2 | 2 | RightAlignment | N | N | 0 | 0 | 10 | ^[0-9]*$ | ^[0-9]*$ | Discount Step Level | 1 | Numeric | 2ByteInt | SpecialUse | > | Discount step within the scheme | ||||||||||
| QTY | Quantity | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Trigger quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The trigger quantity for this discount | ||||||||
| RATE | Disc % | 0 | 12 | 12 | RightAlignment | Y | Y | 4 | -99.9999 | 99.9999 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9]{4}$ | Discount rate | 25 | Numeric | 8ByteDouble | OptionalUse | > | Discount percentage rate. | </header> | </sydd> | ||||||||