03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| SALES_DEL_ADDR | |||||||||||||||||||||||||||||
| 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 account. | ||||||||||
| ADDRESS_1 | Street1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 1 | Unit 1 | Text | String | OptionalUse | > | The address for the 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 the account. | ||||||||||
| ADDRESS_3 | Town | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 3 | Sometown | Text | String | OptionalUse | > | The address for the account. | ||||||||||
| ADDRESS_4 | County | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 4 | Someshire | Text | String | OptionalUse | > | The address for the 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 the account. | ||||||||||
| ADDRESS_REF | Reference No. | 0 | 4 | 4 | LeftAlignment | N | N | 0 | 0 | 9999 | ^[0-9]*$ | ^[0-9]?[0-9]?[0-9]?[0-9]$ | Address reference number | 1 | Numeric | 2ByteInt | RequiredUse | > | Address reference number | ||||||||||
| CONTACT_NAME | Contact | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Contact Name | Te Boidheachd | Text | String | OptionalUse | > | A contact name for the address. | ||||||||||
| COUNTRY_CODE | Country Code | 0 | 2 | 2 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9]*$ | ^[A-Z0-9]*$ | Country Code | GB | Text | String | RequiredUse | > | The address country code. | ||||||||||
| DEFAULT_REF | Default | 0 | 4 | 4 | LeftAlignment | N | N | 0 | 0 | 9999 | ^[0-9]*$ | ^[0-9]+$ | Default indicator | 1 | 0 | Numeric | 2ByteInt | RequiredUse | > | Default delivery address indicator | |||||||||
| DESCRIPTION | Description | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Address description | Works Depot | Text | String | RequiredUse | > | The description associated with the address. | ||||||||||
| 0 | 255 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account email address | info@skyewright.co.uk | Text | String | OptionalUse | > | The email address for the address. | ||||||||||||
| FAX | Fax | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account fax number | 1111 11111111 | Text | String | OptionalUse | > | The fax number for the account. | ||||||||||
| NAME | Name | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Name | A Sample Company Name | Text | String | OptionalUse | > | The company associated with the address. | ||||||||||
| REFERENCE | Ref | 0 | 12 | 12 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054' ]*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054' ]{8}\d{4}$ | Address Reference | SKYEWRIG0001 | Text | String | SpecialUse | primary="Y" | > | The reference for the address. | |||||||||
| 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 | RequiredUse | > | The tax code to be used by default for transactions associated with the address | |||||||||
| TELEPHONE | Telephone | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account telephone number | 0000 00000000 | Text | String | OptionalUse | > | The telephone number for the account. | ||||||||||
| VAT_NUMBER | VAT Number | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account VAT registration number | GB 000 0000 00 | Text | String | OptionalUse | > | The VAT registration number for the address. | </header> | </sydd> | ||||||||