03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| PRICELIST | |||||||||||||||||||||||||||||
| 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 | ||||||
| CURRENCY | Currency | 1 | 2 | 2 | LeftAlignment | Y | N | 0 | 0 | 99 | ^[0-9]*$ | ^[1-9]?[0-9]$ | Default currency for list | 10 | Text | 2ByteInt | OptionalUse | > | The type of curency that the price list uses. | ||||||||||
| HAS_STATIC_PRICES | Has Static Prices | 1 | 1 | 1 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]$ | Static price setting | 1 | 0 | Boolean | 2ByteInt | OptionalUse | > | Prices remain static? | |||||||||
| IMPORT_FILE | Import File | 0 | 259 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Default path for import file | temp | Text | String | OptionalUse | > | Default path for import file. | ||||||||||
| LAST_UPDATED | Last Updated | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Date of last update | 2451158 | JulianDateNumber | Date | OptionalUse | > | Date of last update. | ||||||||||
| NAME | Name | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | List Name | A Sample List Name | Text | String | RequiredUse | > | The name associated with the list. | ||||||||||
| REFERENCE | Reference | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | List Reference | SKYEWR01 | Text | String | SpecialUse | > | <p>The reference for the price list, usually used to identify and sequence lists.<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.Numbers sort before letters, so ACC9 appears before ACCA.</p><p>N.B. For Line 50 >v9 the full list reference is a compound of Type and Reference.</p> | ||||||||||
| TYPE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 85 | ^[0-9]*$ | ^[0-9]*$ | Price type | 80 | 80 | Numeric | 2ByteInt | OptionalUse | > | Price type. Introduced @ v10. Pre-v10 the TYPE is effectively always 80, i.e. "P". | |||||||||
| PrimaryKey | PrimaryKey | 0 | 9 | 9 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | List Reference | PSKYEWR01 | Text | String | SpecialUse | primary="Y" | > | A pseudo primary index. This is to allow for pre-v10 where Reference is effectively the primary key and v10 or greater where the primary key is a compound of Type and Reference. Pre-v10 the TYPE is effectively always "P" | |||||||||
| 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> | |||||||