03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| STOCK | |||||||||||||||||||||||||||||||||||||||
| 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 product assembly. e.g. if a product assembly consists of 3 components and 1 sub-assembly, and that sub-assembly itself consists of 4 components, the level for the product assembly is 2. | |||||||||||||||||||
| AVERAGE_COST_PRICE | Ave. Cost Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Current average purchase price | 500 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitcost</validentry> | The average purchase price for the product based on the current stock history | ||||||||||||||||||
| COMMODITY_CODE | Com. Code Desc | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Commodity Code description | Code | Text | String | OptionalUse | > | The EC Intrastat commodity code description for the product. | ||||||||||||||||||||
| COMPONENT_CODE_1 | Component 1 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_2 | Component 2 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_3 | Component 3 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_4 | Component 4 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_5 | Component 5 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_6 | Component 6 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_7 | Component 7 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_8 | Component 8 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_9 | Component 9 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_CODE_10 | Component 10 | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Component identifier | A-PART-CODE | Text | String | OptionalUse | > | The identifying code for a component. | ||||||||||||||||||||
| COMPONENT_QTY_1 | Component 1 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_2 | Component 2 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_3 | Component 3 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_4 | Component 4 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_5 | Component 5 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_6 | Component 6 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_7 | Component 7 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_8 | Component 8 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_9 | Component 9 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| COMPONENT_QTY_10 | Component 10 Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Component quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity for a component | ||||||||||||||||||
| CUSTOM_1 | Custom1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | A product custom field | Some Product Custom Data | Text | String | OptionalUse | > | A text based custom field. | ||||||||||||||||||||
| CUSTOM_2 | Custom2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | A product custom field | Some Product Custom Data | Text | String | OptionalUse | > | A text based custom field. | ||||||||||||||||||||
| CUSTOM_3 | Custom3 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | A product custom field | Some Product Custom Data | Text | String | OptionalUse | > | A text based custom field. | ||||||||||||||||||||
| DEPT_NUMBER | Dept | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Default product department | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The department to be used by default for actions associated with the product | |||||||||||||||||||
| DESCRIPTION | Description | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Product description | A Sample Product Name | Text | String | OptionalUse | > | The name of the product associated with this code. | ||||||||||||||||||||
| FIRST_TRAN | First Tran | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | First Transaction Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of first transaction for product. | |||||||||||||||||||
| IGNORE_STK_LVL_FLAG | Item Type | 0 | 1 | 1 | LeftAlignment | N | N | 0 | 0 | 2 | ^[0-9]*$ | ^[0-9]$ | Item type code | 1 | Numeric | 2ByteInt | OptionalUse | > | Stock item type. | ||||||||||||||||||||
| INTRASTAT_COMMODITY_CODE | IntraStat Com. Code | 0 | 8 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Intrastat Commodity Code | 1234 | Text | String | OptionalUse | > | The EC Intrastat commodity code for the product. | ||||||||||||||||||||
| ITEM_TYPE | Type | 0 | 1 | 1 | LeftAlignment | N | N | 0 | 0 | 2 | ^[0-9]*$ | ^[0-9]$ | Product type code | 1 | Numeric | 2ByteInt | OptionalUse | > | Type code for the product. | ||||||||||||||||||||
| LAST_PURCHASE_DATE | Last Purchase Date | 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})?)$ | Last recorded purchase date | 2451158 | JulianDateNumber | Date | OptionalUse | > | The date of the most recent purchase for the product. | ||||||||||||||||||||
| LAST_PURCHASE_PRICE | Cost Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Last purchase price | 500 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitcost</validentry> | The last purchase price for the product | ||||||||||||||||||
| LAST_SALE_DATE | Last Sale Date | 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})?)$ | Last recorded sale date | 2451158 | JulianDateNumber | Date | OptionalUse | > | The date of the most recent sale for the product. | ||||||||||||||||||||
| LAST_TRAN | Last Tran | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | Last Transaction Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of last transaction for product. | |||||||||||||||||||
| 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. | ||||||||||||||||||||
| 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 product belongs directly. | |||||||||||||||||||
| LOCATION | Location | 0 | 16 | 16 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | The location of the product | A01-S02-B03 | Text | String | OptionalUse | > | The location of the product. | ||||||||||||||||||||
| NOMINAL_CODE | N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Product Nominal code | 0 | Text | String | OptionalUse | > | The nominal code. | ||||||||||||||||||||
| PURCHASE_REF | Supplier A/C | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Supplier Account Reference | SKYEWR01 | Text | String | OptionalUse | > | The account reference for the supplier of the product, usually used to identify and sequence accounts.<br>Valid references consist of uppercase letters or numbers or both. Numbers sort before letters, so ACC1 appears before ACCA.<br><strong>Tip:</strong> If you are a manufacturer, consider having a <em>supplier</em> account such as SELF to use as the supplier reference for self-manufactured products. | ||||||||||||||||||||
| PURCHASE_NOMINAL_CODE | N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Product purchase nominal code | 0 | Text | String | OptionalUse | > | The default nominal code for purchasing. | ||||||||||||||||||||
| QTY_ALLOCATED | Allocated | 0 | 16 | 12 | RightAlignment | Y | Y | 2 | -1E+11 | 1E+12 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Allocated stock quantity | 100 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The allocated stock level for the product | ||||||||||||||||||
| QTY_IN_STOCK | In Stock | 0 | 16 | 12 | RightAlignment | Y | Y | 2 | -1E+11 | 1E+12 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Product current stock level | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The recorded stock level for the product | ||||||||||||||||||
| QTY_LAST_ORDER | Last Order Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Last order quantity | 100 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity last used on a purchase order | ||||||||||||||||||
| QTY_LAST_STOCK_TAKE | Last Stock Take | 0 | 16 | 12 | RightAlignment | Y | Y | 2 | -1E+11 | 1E+12 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Last stock take quantity | 100 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The physical quantity at the last stock check | ||||||||||||||||||
| QTY_ON_ORDER | On Order | 0 | 14 | 12 | RightAlignment | Y | Y | 2 | -10000000000 | 1E+11 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | On order stock quantity | 100 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity currently on purchase order | ||||||||||||||||||
| QTY_REORDER | Re-order Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Product Re-order quantity | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The usual re-order quantity for the product | ||||||||||||||||||
| QTY_REORDER_LEVEL | Re-order Level | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Product Re-order level | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | If the stock level for the product falls below this value, more stock should be ordered | ||||||||||||||||||
| RECORD_CREATE_DATE | Create Date | 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 creation | 2451158 | JulianDateNumber | Date | OptionalUse | > | Date of record creation | ||||||||||||||||||||
| RECORD_DELETED | Deleted | 0 | 7 | 1 | LeftAlignment | N | N | 0 | -9999999 | 9999999 | ^[0-9\-]*$ | ^[0-9\-]*$ | Deleted flag | 1 | 0 | Numeric | 2ByteInt | OptionalUse | > | Record deleted flag. | |||||||||||||||||||
| RECORD_MODIFY_DATE | Modify Date | 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 modification | 2451158 | JulianDateNumber | Date | OptionalUse | > | Date of last modification | ||||||||||||||||||||
| SALES_PRICE | Sales Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Product sales price | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | The standard list sales price for the product | ||||||||||||||||||
| STOCK_CAT | Category | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[1-9][0-9]?[0-9]?$ | Category number | 1 | Numeric | 2ByteInt | OptionalUse | > | The category number associated with the product | ||||||||||||||||||||
| STOCK_CODE | Product Code | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Product identifier | A-WIDGET-CODE | Text | String | SpecialUse | primary="Y" | > | The identifying code for a product, usually used to identify and sequence products.<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. | |||||||||||||||||||
| STOCK_TAKE_DATE | Last Stock Take | 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})?)$ | Last stock take date | 2451158 | JulianDateNumber | Date | OptionalUse | > | The date of the most recent stock take for the product. | ||||||||||||||||||||
| SUPPLIER_PART_NUMBER | Part No. | 0 | 16 | 16 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Supplier's Part Reference | Our-Product-99 | Text | String | OptionalUse | > | The reference code for the product used by your supplier. | ||||||||||||||||||||
| TAX_CODE | Tax Code | T | 0 | 3 | 3 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[1-9]?[0-9]$ | Default tax code | 1 | Numeric | 2ByteInt | OptionalUse | > | The tax code to be used by default for transactions associated with the product | |||||||||||||||||||
| UNIT_OF_SALE | Unit of Sale | 0 | 8 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Unit of Sale | Units | Text | String | OptionalUse | > | The unit of sale for the product. | ||||||||||||||||||||
| UNIT_WEIGHT | Unit Weight | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Product unit weight | 5 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The weight for one unit of the product | ||||||||||||||||||
| WEB_DESCRIPTION | Web Description | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Web product description | A Sample Product Name | Text | String | OptionalUse | > | The name of the product associated with this code for use on Web pages. | ||||||||||||||||||||
| WEB_IMAGE | Web Image | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Web image file name | sample.bmp | ImageFilename | String | OptionalUse | > | The name of an image file associated with this code for use on Web pages. | ||||||||||||||||||||
| WEB_LONGDESCRIPTION | Web Detail | 0 | 1023 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Web long description | Some details about the product | Text | String | OptionalUse | > | A detailed description of the product associated with this code for use on Web pages. | ||||||||||||||||||||
| WEB_PUBLISH | Publish to Web | 0 | 1 | 1 | LeftAlignment | N | N | 0 | 0 | 2 | ^[0-9]*$ | ^[0-9]$ | Web publish flag | 1 | Numeric | 2ByteInt | OptionalUse | > | Should this product be included on web pages? | ||||||||||||||||||||
| WEB_SPECIAL_OFFER | Special Offer | 0 | 1 | 1 | LeftAlignment | N | N | 0 | 0 | 2 | ^[0-9]*$ | ^[0-9]$ | Web special offer flag | 1 | Numeric | 2ByteInt | OptionalUse | > | Is this product on 'special offer'? | ||||||||||||||||||||
| 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> | |||||||||||||||||