03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| INVOICE_ITEM | |||||||||||||||||||||||||||||
| 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 | ||||||
| ADD_DISC_RATE | Disc % | 0 | 12 | 12 | RightAlignment | Y | Y | 4 | -99.9999 | 99.9999 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9]{4}$ | Extra discount rate | 2.5575 | Numeric | 8ByteDouble | OptionalUse | > | Additional discount percentage rate. | ||||||||||
| BASE_FULL_NET | Full | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Net before discount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Item net value before any discounts. | ||||||||||
| BASE_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Discounted net | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Discounted item net value. | ||||||||||
| BASE_NETVALUE_DISCOUNT | Net Disc | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9][0-9]$ | Net discount value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Base Net discount value. | ||||||||||
| BASE_TAX | Tax | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Item Tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The Tax value for the item. | ||||||||||
| COMMENT_1 | Comment 1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Comment 1 | Any Text | Text | String | OptionalUse | > | A comment line. | ||||||||||
| COMMENT_2 | Comment 2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Comment 2 | Any Text | Text | String | OptionalUse | > | A comment line. | ||||||||||
| DELIVERY_DATE | Delivery 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})?)$ | Delivery Date | 2451158 | JulianDateNumber | Date | OptionalUse | > | The delivery date associated with this document or item. | ||||||||||
| DEPT_NUMBER | Dept | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Item department | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The department for item anaylsis. | |||||||||
| 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. | ||||||||||
| DISCOUNT_RATE | Disc % | 0 | 12 | 12 | RightAlignment | Y | Y | 4 | -99.9999 | 99.9999 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9]{4}$ | Discount rate | 25 | Numeric | 8ByteDouble | OptionalUse | > | Scheme based discount percentage rate. | ||||||||||
| EXT_ORDER_REF | Ext Ord Ref | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | External ref | Any Text | Text | String | OptionalUse | > | External ref for SOP to INV Link. | ||||||||||
| EXT_ORDER_LINE_REF | Ext Ord Line Ref | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | External line ref | 21 | Text | 4ByteInt | OptionalUse | > | External line ref for SOP to INV Link. | ||||||||||
| FULL_NET_AMOUNT | Full | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Net before discount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Item net value before any discounts. | ||||||||||
| INVOICE_NUMBER | Invoice No. | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Invoice Number | 21 | Text | 4ByteInt | OptionalUse | > | The number of the invoice. | ||||||||||
| ITEM_NUMBER | Item No | 0 | 7 | 7 | RightAlignment | N | N | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Item Number | 1 | Numeric | 2ByteInt | SpecialUse | primary="Y" | > | The number of this item within the current document | |||||||||
| ITEMID | Item ID | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Unique item identifier | 21 | Numeric | 4ByteInt | OptionalUse | > | Unique Identifier, unaffected by file maintenance routines (new v2008/v14). | ||||||||||
| JOB_REFERENCE | Job Reference | 0 | 20 | 20 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Job Costing reference | Any Text | Text | String | OptionalUse | > | A Job Costing reference | ||||||||||
| NET_AMOUNT | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Discounted net | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Discounted item net value. | ||||||||||
| NETVALUE_DISCOUNT | Net Disc | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9][0-9]$ | Net discount value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Net discount value. | ||||||||||
| NEXT_ITEM | Next Item | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | Next Item Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of next item on invoice. | |||||||||
| NOMINAL_CODE | N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Nominal account code | 0 | Text | String | OptionalUse | > | The item nominal code. | ||||||||||
| PROJECT_ID | Project ID | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Project ID | 21 | Numeric | 4ByteInt | OptionalUse | > | The Project ID (new v2008/v14). | ||||||||||
| QTY_ORDER | Order Qty | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | The item quantity | 1000 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>stockqty</validentry> | The quantity associated with this item. | |||||||||
| SERVICE_FLAG | Service | 0 | 1 | 1 | LeftAlignment | N | N | 0 | 0 | 2 | ^[0-9]*$ | ^[0-9]$ | Item type code | 1 | Numeric | 2ByteInt | OptionalUse | > | Invoice item type code. | ||||||||||
| 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 | RequiredUse | > | The stock code for the invoice item. | ||||||||||
| TAX_AMOUNT | Tax | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Item Tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The Tax value for the item. | ||||||||||
| TAX_CODE | Tax Code | T | 0 | 3 | 3 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[1-9]?[0-9]$ | Tax code | 1 | Numeric | 2ByteInt | OptionalUse | > | The item tax code. | |||||||||
| TAX_RATE | Tax Rate | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\.0-9]*$ | ^[0-9]+\.[0-9]+$ | Tax rate percentage | 17.5 | Numeric | 8ByteDouble | OptionalUse | > | The Tax Rate for the item. | ||||||||||
| TEXT | Service Text | 0 | 4096 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Text for a service item | A Service Summary | Text | String | OptionalUse | > | The text for a service item. | ||||||||||
| 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 this product. | ||||||||||
| UNIT_PRICE | Unit Price | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -9999999.999 | 100000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Item Unit Price | 1000 | 0 | ExtNumeric | 8ByteDouble | OptionalUse | > | <validentry>unitprice</validentry> | The unit price for this item | ||||||||
| RecordNumber | RecordNumber | 0 | 10 | 10 | 0 | RightAlignment | N | N | 0 | 0 | 2147483647 | ^[0-9]*$ | ^[0-9]*$ | Record number | 12 | PaddedNumeric | None | SpecialUse | primary="Y" | > | The record number. A pseudo primary index. | ||||||||
| Project | Project | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Project Reference | SKYEWR01 | Text | String | OptionalUse | > | The reference a Project that the item is attached to. | </header> | </sydd> | ||||||||