03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| PRICE | |||||||||||||||||||||||||||||
| 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 | ||||||
| DISCOUNT_TYPE | Discount Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 6 | ^[0-9]*$ | ^[0-9]*$ | Discount type | 0 | 0 | Numeric | 2ByteInt | RequiredUse | > | Discount type. | |||||||||
| EXT_REF | Ext. Ref. | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | External Reference | SKYEWR01 | Text | String | SpecialUse | > | The external reference for the price, i.e. a price list reference or a customer reference. | ||||||||||
| REFERENCE | Reference | 0 | 39 | 39 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054' ]*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054' ]*$ | Price Reference | SSKYEWR01WIDGET | Text | String | SpecialUse | primary="Y" | > | The reference for the price list. | |||||||||
| ROUNDER_METHOD | Rounder Method | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[0-9]*$ | Rounder method | 0 | Numeric | 2ByteInt | OptionalUse | > | Rounder method | ||||||||||
| ROUNDER_DIRECTION | Rounder Direction | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[0-9]*$ | Rounder direction | 0 | Numeric | 2ByteInt | OptionalUse | > | Rounder direction | ||||||||||
| ROUNDER_MULTIPLE_OF | Rounding Multiple | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Rounding Multiple | 1 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | Rounding Multiple | |||||||||
| ROUNDER_ADJUSTMENT | Rounding Adjustment | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Rounding Adjustment | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | Rounding Adjustment | |||||||||
| STOCK_CODE | Stock Code | 0 | 30 | 20 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Relevant stock code | A-WIDGET-CODE | Text | String | RequiredUse | > | Relevant stock code. | ||||||||||
| STORED_PRICE | Stored Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Stored sales price | 1000 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | The stored price for manually recalculated prices. | |||||||||
| TYPE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 85 | ^[0-9]*$ | ^[0-9]*$ | Price type | 80 | 80 | Numeric | 2ByteInt | RequiredUse | > | Price type. | |||||||||
| VALUE | Value | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Value or percentage | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | Value or percentage depenging on the discount type. | ||||||||
| 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> | |||||||