03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| BOM_HEADER | ||||||||||||||||||||||||||||||||
| 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 | |||||||||
| ASSEMBLY_LEVEL | Asm | 0 | 1 | 1 | RightAlignment | N | N | 0 | 0 | 9 | ^[0-9]*$ | ^[0-9]?$ | Assembly level | 1 | 0 | Numeric | 2ByteInt | SpecialUse | > | The number of levels of components and sub-assemblies below the BOM. e.g. if a BOM consists of 3 components and 1 sub-assembly, and that sub-assembly itself consists of 4 components, the level for the BOM is 2. | ||||||||||||
| LINK_LEVEL | Link | 0 | 4 | 4 | RightAlignment | N | N | 0 | 0 | 9999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?[0-9]?$ | Link level | 7 | 0 | Numeric | 2ByteInt | SpecialUse | > | The number of assemblies or sub-assemblies to which the BOM belongs directly. | ||||||||||||
| STOCK_CODE | BOM Code | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | BOM identifier | A-WIDGET-CODE | Text | String | SpecialUse | primary="Y" | > | The identifying code for a BOM, usually used to identify and sequence BOMs.<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. | </header> | </sydd> | ||||||||||