| REFERENCE |
VARCHAR |
12 |
12 |
Delivery address reference |
COMPANY 0001 |
| ADDRESS_REF |
INTEGER |
4 |
10 |
Address reference number |
1 |
| DESCRIPTION |
VARCHAR |
60 |
60 |
Description |
Head Office |
| NAME |
VARCHAR |
60 |
60 |
Name |
Stationery & Computer Mart UK Ltd |
| ADDRESS_1 |
VARCHAR |
60 |
60 |
Address Line 1 |
Sage House |
| ADDRESS_2 |
VARCHAR |
60 |
60 |
Address Line 2 |
Benton Park Road |
| ADDRESS_3 |
VARCHAR |
60 |
60 |
Address Line 3 |
Newcastle Upon Tyne |
| ADDRESS_4 |
VARCHAR |
60 |
60 |
Address Line 4 |
|
| ADDRESS_5 |
VARCHAR |
60 |
60 |
Address Line 5 |
NE7 7LZ |
| TELEPHONE |
VARCHAR |
30 |
30 |
Telephone Number |
0191 955 3000 |
| FAX |
VARCHAR |
30 |
30 |
Fax Number |
0191 955 3001 |
| E_MAIL |
VARCHAR |
255 |
255 |
E-mail Address |
[email protected] |
| CONTACT_NAME |
VARCHAR |
30 |
30 |
Contact Name |
Maureen Bridges |
| TAX_CODE |
SMALLINT |
2 |
5 |
Tax code |
1 |
| COUNTRY_CODE |
VARCHAR |
2 |
2 |
Country Code |
GB |
| VAT_REG_NUMBER |
VARCHAR |
20 |
20 |
Vat Registration number |
|
| TELEPHONE_2 |
VARCHAR |
30 |
30 |
Other Telephone Number |
|
| ADDRESS_TYPE_NAME |
VARCHAR |
60 |
60 |
Address Type |
Delivery |
| ADDRESS_TYPE |
TINYINT |
1 |
3 |
Address Type |
0 |
| CONTACT_ROLE |
VARCHAR |
30 |
30 |
Contact Role |
|
| NOTES |
VARCHAR |
200 |
200 |
Notes |
|
| RECORD_CREATE_DATE |
|
16 |
0 |
Date and time when the record was created. |
03/08/2016 17:49:08 |
| RECORD_MODIFY_DATE |
|
16 |
0 |
Date and time when the record was modified. |
04/08/2017 14:18:53 |
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
0 |