03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| PURCHASE_ORDER | |||||||||||||||||||||||||||||
| 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 | ||||||
| ACCOUNT_REF | A/C | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Account Reference | SKYEWR01 | Text | String | RequiredUse | > | The account reference for the order. | ||||||||||
| ADDRESS_1 | Street1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 1 | Unit 1 | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_2 | Street2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 2 | High Street | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_3 | Town | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 3 | Sometown | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_4 | County | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 4 | Someshire | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_5 | Post Code | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 5 | ZZ00 00AA | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| AMOUNT_PREPAID | Payment Amount | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Pre-paid amount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of any pre-payment for the order. | ||||||||||
| BANK_CODE | Bank N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Bank nominal account code | 0 | Text | String | OptionalUse | > | The nominal code for banking any amount paid. | ||||||||||
| BASE_TOT_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item discounted totals (i.e. net). Does not include carriage. | ||||||||||
| BASE_TOT_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item tax amounts. | ||||||||||
| BASE_CARR_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The net value of carriage for the order. | ||||||||||
| BASE_CARR_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of tax on the carriage. | ||||||||||
| BASE_SETT_DISC_RATE | Discount % | 0 | 5 | 5 | RightAlignment | N | N | 2 | 0 | 99.99 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Early settlement discount percentage | 5 | 0 | Text | 8ByteDouble | OptionalUse | > | The percentage discount allowed for early payment of the invoice. | |||||||||
| BASE_AMOUNT_PAID | Payment Amount | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Pre-paid amount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of any pre-payment for the order. | ||||||||||
| CARR_DEPT_NUMBER | Dept | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Carriage department | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The department to be used for carriage anaylsis. | |||||||||
| CARR_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The net value of carriage for the order. | ||||||||||
| CARR_NOM_CODE | N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Carriage nominal account | 0 | Text | String | OptionalUse | > | The nominal code for any carriage charge. | ||||||||||
| CARR_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of tax on the carriage. | ||||||||||
| CARR_TAX_CODE | Tax Code | T | 0 | 3 | 3 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[1-9]?[0-9]$ | Carriage tax code | 1 | Numeric | 2ByteInt | OptionalUse | > | The tax code for any carriage charge. | |||||||||
| CONSIGNMENT_REF | Consign. No. | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Consignment Number | Any Text | Text | String | OptionalUse | > | The Consignment Number. | ||||||||||
| CONTACT_NAME | Contact name | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Contact | Duine Gasda | Text | String | OptionalUse | > | A contact name for this account. This is usually the accounts contact. | ||||||||||
| COST_CODE_ID | Cost Code ID | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Global project cost code ID | 21 | Numeric | 4ByteInt | OptionalUse | > | The Global Project Cost Code ID (new v2008/v14). | ||||||||||
| COURIER | Courier | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Courier number | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The courier used. | |||||||||
| CURRENCY | Currency | 1 | 2 | 2 | RightAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[0-9]?[0-9]$ | Transaction currency | 1 | Numeric | 2ByteInt | OptionalUse | > | Transaction Currency. Sage Documentation at Sage v7 says <em>Not Used</em>, but it appears to be the document account currency. | ||||||||||
| CURRENCY_USED | Currency Used | 1 | 2 | 2 | RightAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[0-9]?[0-9]$ | Currency used | 6 | Numeric | 2ByteInt | OptionalUse | > | Currency Used (Not Used). Sage Documentation at Sage v7 says <em>Not Used</em>. | ||||||||||
| DEL_ADDRESS_1 | Street1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 1 | Floor 1, Building A | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_2 | Street2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 2 | High Street | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_3 | Town | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 3 | Atown | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_4 | County | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 4 | Ashire | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_5 | Post Code | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 5 | ZZ99 00ZZ | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| 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. | ||||||||||
| DELIVERY_NAME | Name | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Delivery Name | A Delivery Company Name | Text | String | OptionalUse | > | The company associated with the delivery. | ||||||||||
| DISCOUNT_TYPE | Additional Disc. | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 6 | ^[0-9]*$ | ^[0-9]*$ | Additional discount scheme type | 3 | 0 | Numeric | 2ByteInt | OptionalUse | > | The type of discount scheme applicable. | |||||||||
| DUE_DATE | Due 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})?)$ | Due Date | 2451158 | JulianDateNumber | Date | OptionalUse | > | The due date associated with this document. | ||||||||||
| EURO_GROSS | Euro Gross | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Gross value in Euros | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The gross order value in Euros (if applicable). | ||||||||||
| EURO_RATE | Euro Rate | 0 | 12 | 12 | RightAlignment | Y | Y | 6 | -99999999.99 | 1000000000 | ^[\.0-9]*$ | ^[0-9]+\.[0-9]+$ | Euro Rate | 1.4 | 1 | Numeric | 8ByteDouble | OptionalUse | > | Euro Rate (if applicable). | |||||||||
| FIRST_ITEM | First Item | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | First Item Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of first item. | |||||||||
| FOREIGN_GROSS | Foreign Gross | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Gross value in foreign currency | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The gross order value in foreign currency (if applicable). | ||||||||||
| FOREIGN_RATE | Foreign Rate | 0 | 12 | 12 | RightAlignment | Y | Y | 6 | -99999999.99 | 1000000000 | ^[\.0-9]*$ | ^[0-9]+\.[0-9]+$ | Foreign Rate | 1.4 | 1 | Numeric | 8ByteDouble | OptionalUse | > | Foreign Rate (if applicable). | |||||||||
| GLOBAL_DEPT_NUMBER | Dept | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Global department | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The department to be used for order anaylsis. | |||||||||
| INTRASTAT_STATUS | Intrastat Status | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 6 | ^[0-9]*$ | ^[0-9]*$ | Intrastat reconciled status | 1 | 0 | Numeric | 2ByteInt | OptionalUse | > | The Intrastat Reconciled Status. | |||||||||
| INVOICE_NUMBER | Invoice No. | 0 | 7 | 7 | RightAlignment | Y | N | 0 | 0 | 9999999 | ^.*$ | ^.*$ | Invoice Number | 1001 | Text | String | OptionalUse | > | The number of the invoice. May be non-numeric | ||||||||||
| ITEMS_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item discounted totals (i.e. net). Does not include carriage. | ||||||||||
| ITEMS_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item tax amounts. | ||||||||||
| 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 | ^.*$ | ^.*$ | Account Name | A Sample Company Name | Text | String | OptionalUse | > | The company associated with this account. | ||||||||||
| NOTES_1 | Note 1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Note 1 | Any Text | Text | String | OptionalUse | > | A note line. | ||||||||||
| NOTES_2 | Note 2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Note 2 | Any Text | Text | String | OptionalUse | > | A note line. | ||||||||||
| NOTES_3 | Note 3 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Note 3 | Any Text | Text | String | OptionalUse | > | A note line. | ||||||||||
| ORDER_DATE | Order 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})?)$ | Order document date | 2451158 | JulianDateNumber | Date | RequiredUse | > | The main date associated with this order. | ||||||||||
| ORDER_NUMBER | Order No. | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Order Number | 21 | Numeric | 4ByteInt | SpecialUse | primary="Y" | > | The corresponding order number. | |||||||||
| ORDER_TYPE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 12 | ^[0-9]*$ | ^[0-9]*$ | Document type code | 10 | 0 | Numeric | 2ByteInt | RequiredUse | > | The type of document | |||||||||
| PAYMENT_REF | Pymt Ref | 0 | 30 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Payment Reference | Any Text | Text | String | OptionalUse | > | The Payment Reference. | ||||||||||
| PAYMENT_TYPE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 18 | ^[0-9]*$ | ^[0-9]*$ | Payment type code | 1 | Numeric | 2ByteInt | OptionalUse | > | The type of payment, choose from Sales Receipt or Sale Payment on Account | ||||||||||
| POSTED_CODE | Posted | 0 | 1 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]*$ | Has Order been posted? | Y | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the order has been posted to the ledgers. | ||||||||||
| PRINTED_CODE | Printed | 0 | 1 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]*$ | Has Order been printed? | Y | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the order has been printed. | ||||||||||
| 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). | ||||||||||
| RECURRING_REFERENCE | Recurr Ref | 0 | 8 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Recurring Reference | Any Text | Text | String | OptionalUse | > | The Recurring Reference. | ||||||||||
| SETTLEMENT_DISC_RATE | Discount % | 0 | 5 | 5 | RightAlignment | N | N | 2 | 0 | 99.99 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Early settlement discount percentage | 5 | 0 | Numeric | 8ByteDouble | OptionalUse | > | The percentage discount allowed for early payment of the order. | |||||||||
| SETTLEMENT_DUE_DAYS | Days | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Days for early settlement discount | 7 | Numeric | 2ByteInt | OptionalUse | > | The limit, in days, for payment of the order to qualify for early settlement discount | ||||||||||
| STATUS | Status | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 10 | ^[0-9]*$ | ^[0-9]*$ | Order status code | 0 | Numeric | 2ByteInt | OptionalUse | > | The order status in terms of allocation and delivery | ||||||||||
| SUPP_DISC_RATE | Disc % | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Supplier based discount rate | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The supplier based discount percentage. | ||||||||||
| SUPP_ORDER_NUMBER | Supplier Order No. | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Supplier Order Number | Any Text | Text | String | OptionalUse | > | The Supplier Order Number relating to the order. | ||||||||||
| SUPP_TEL_NUMBER | Supplier Tel. No. | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Supplier Telephone Number | 0000 00000000 | Text | String | OptionalUse | > | A contact telephone number. | ||||||||||
| TAKEN_BY | Placed by | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Order Placed By | Any Text | Text | String | OptionalUse | > | Order Placed By. | ||||||||||
| 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> | |||||||