01344 645950
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| STOCK_MEMO | |||||||||||||||||||||||||||||||||||||||
| 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-WIDGET-CODE | Text | String | SpecialUse | primary="Y" | > | The identifying code for a stock item, usually used to identify and sequence stock items.<br>Valid codes consist of uppercase letters or numbers or both. Numbers sort before letters, so <strong>PROD1</strong> appears before <strong>PRODA</strong>. As well as letters and numbers you may use <strong>.-#</strong> and <strong>_</strong>. Spaces are not allowed. | |||||||||||||||||||
| TEXT | Memo Text | 0 | 32768 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Memo text | Some memo notes | Text | String | OptionalUse | > | Memo text | ||||||||||||||||||||
| RecordNumber | RecordNumber | 0 | 10 | 10 | 0 | RightAlignment | N | N | 0 | 0 | 2147483647 | ^[0-9]*$ | ^[0-9]*$ | Record number | 12 | PaddedNumeric | None | SpecialUse | > | The record number. | </header> | </sydd> | |||||||||||||||||
