| ACCOUNT_REF |
VARCHAR |
8 |
8 |
Account Reference |
A1D001 |
| NAME |
VARCHAR |
60 |
60 |
Account Name |
A1 Design Services |
| ADDRESS_1 |
VARCHAR |
60 |
60 |
Account Address Line1 |
67a Station Road |
| ADDRESS_2 |
VARCHAR |
60 |
60 |
Account Address Line2 |
|
| ADDRESS_3 |
VARCHAR |
60 |
60 |
Account Address Line3 |
Blackpool |
| ADDRESS_4 |
VARCHAR |
60 |
60 |
Account Address Line4 |
Lancashire |
| ADDRESS_5 |
VARCHAR |
60 |
60 |
Account Address Line5 |
BP12 7HT |
| C_ADDRESS_1 |
VARCHAR |
60 |
60 |
Compact Account Address Line1 |
67a Station Road |
| C_ADDRESS_2 |
VARCHAR |
60 |
60 |
Compact Account Address Line2 |
Blackpool |
| C_ADDRESS_3 |
VARCHAR |
60 |
60 |
Compact Account Address Line3 |
Lancashire |
| C_ADDRESS_4 |
VARCHAR |
60 |
60 |
Compact Account Address Line4 |
BP12 7HT |
| C_ADDRESS_5 |
VARCHAR |
60 |
60 |
Compact Account Address Line5 |
|
| CONTACT_NAME |
VARCHAR |
30 |
30 |
Contact Name |
Ian Cairns |
| TELEPHONE |
VARCHAR |
30 |
30 |
Telephone Number |
01742 876 234 |
| TELEPHONE_2 |
VARCHAR |
30 |
30 |
Telephone Number (2) |
01742 876 235 |
| FAX |
VARCHAR |
30 |
30 |
Fax Number |
01742 876 236 |
| E_MAIL |
VARCHAR |
255 |
255 |
E-Mail Address |
[email protected] |
| E_MAIL2 |
VARCHAR |
255 |
255 |
E-Mail Address (2) |
|
| E_MAIL3 |
VARCHAR |
255 |
255 |
E-Mail Address (3) |
|
| DIRECT_DEBITS_EMAIL |
VARCHAR |
255 |
255 |
Direct Debit Email |
[email protected] |
| WEB_ADDRESS |
VARCHAR |
255 |
255 |
World Wide Web Address |
www.sage.co.uk |
| TRADE_CONTACT |
VARCHAR |
30 |
30 |
Trade Contact |
Malcolm Leverret |
| DEL_NAME |
VARCHAR |
60 |
60 |
Delivery Name |
A1 Design Services |
| DEL_ADDRESS_1 |
VARCHAR |
60 |
60 |
Delivery Address Line1 |
67a Station Road |
| DEL_ADDRESS_2 |
VARCHAR |
60 |
60 |
Delivery Address Line2 |
|
| DEL_ADDRESS_3 |
VARCHAR |
60 |
60 |
Delivery Address Line3 |
Blackpool |
| DEL_ADDRESS_4 |
VARCHAR |
60 |
60 |
Delivery Address Line4 |
Lancashire |
| DEL_ADDRESS_5 |
VARCHAR |
60 |
60 |
Delivery Address Line5 |
BP12 7HT |
| DEL_CONTACT_NAME |
VARCHAR |
30 |
30 |
Delivery Contact Name |
Jim Thomas |
| DEL_TELEPHONE |
VARCHAR |
30 |
30 |
Delivery Telephone Number |
01742 876 234 |
| DEL_FAX |
VARCHAR |
30 |
30 |
Delivery Fax Number |
01742 876 235 |
| ANALYSIS_1 |
VARCHAR |
30 |
30 |
Analysis 1 |
Trade |
| ANALYSIS_2 |
VARCHAR |
30 |
30 |
Analysis 2 |
George |
| ANALYSIS_3 |
VARCHAR |
30 |
30 |
Analysis 3 |
Lancashire |
| DEPT_NUMBER |
SMALLINT |
2 |
5 |
Department Number |
0 |
| DEPT_NAME |
VARCHAR |
60 |
60 |
Department Name |
Default |
| STATUS_NUMBER |
SMALLINT |
2 |
5 |
Status Number |
0 |
| STATUS_TEXT |
VARCHAR |
60 |
60 |
Status Text |
Open |
| DEF_TAX_CODE |
VARCHAR |
3 |
3 |
Default tax code (T0 to T99) |
T1 |
| DEF_NOM_CODE |
VARCHAR |
8 |
8 |
Default Nominal Code |
4000 |
| VAT_REG_NUMBER |
VARCHAR |
20 |
20 |
VAT Registration Number |
GB238 3839 38 |
| CURRENCY |
TINYINT |
1 |
3 |
Currency |
1 |
| COUNTRY_CODE |
VARCHAR |
2 |
2 |
Country Code |
GB |
| DISCOUNT_TYPE |
TINYINT |
1 |
3 |
Discount Type (inv total/stock record) |
0 |
| DISCOUNT_RATE |
DOUBLE |
8 |
15 |
Discount Rate |
0 |
| PRICING_REF |
VARCHAR |
8 |
8 |
Default Price List |
TRADEA |
| SETTLEMENT_DISC_RATE |
DOUBLE |
8 |
15 |
Settlement Discount Rate |
2.5 |
| SETTLEMENT_DUE_DAYS |
SMALLINT |
2 |
5 |
Settlement Due Days |
15 |
| PAYMENT_DUE_DAYS |
SMALLINT |
2 |
5 |
Payment Due Days |
30 |
| PAYMENT_DUE_FROM |
SMALLINT |
2 |
5 |
Payment due from option |
0 |
| PAYMENT_DUE_FROM_TEXT |
VARCHAR |
60 |
60 |
Payment due from option text |
Days after invoice date |
| CREDIT_LIMIT |
DOUBLE |
8 |
15 |
Credit Limit |
1000 |
| ACCOUNT_ON_HOLD |
TINYINT |
1 |
3 |
Account On Hold |
0 |
| TERMS |
VARCHAR |
30 |
30 |
Terms |
30 days nett |
| RESTRICT_MAIL |
SMALLINT |
2 |
5 |
Mail On Hold |
1 |
| TERMS_AGREED |
SMALLINT |
2 |
5 |
Terms Agreed Flag |
1 |
| DATE_ACCOUNT_OPENED |
DATE |
2 |
10 |
Date Account Opened |
02/01/2017 00:00:00 |
| DATE_NEXT_CREDIT |
DATE |
2 |
10 |
Date of Next Credit Review |
01/02/2018 00:00:00 |
| DATE_LAST_CREDIT |
DATE |
2 |
10 |
Date of Last Credit Review |
04/12/2017 00:00:00 |
| CREDIT_POSITION |
VARCHAR |
19 |
19 |
Credit Position |
Good |
| CREDIT_POS_CODE |
SMALLINT |
2 |
5 |
Credit Position Code |
0 |
| CAN_CHARGE |
SMALLINT |
2 |
5 |
Can Apply Credit Charges to this Account |
1 |
| USE_BACS |
SMALLINT |
2 |
5 |
Flag to Use BACS Reference |
0 |
| BACS_REF |
VARCHAR |
60 |
60 |
BACS Reference for Electronic Transfer |
|
| BUREAU_CODE |
SMALLINT |
2 |
5 |
Credit Bureau code |
2 |
| CREDIT_REF |
VARCHAR |
60 |
60 |
Credit Reference |
TS3811 |
| DATE_CREDIT_APPLIED |
DATE |
2 |
10 |
Date of Credit Application |
02/01/2017 00:00:00 |
| DATE_CREDIT_RECEIVED |
DATE |
2 |
10 |
Date Credit Application Received |
02/01/2017 00:00:00 |
| OVERRIDE_TAX_CODE |
TINYINT |
1 |
3 |
Override stock tax code in invoicing |
0 |
| LAST_PAYMENT_DATE |
DATE |
2 |
10 |
Date of Last Payment |
27/04/2017 00:00:00 |
| FIRST_INV_DATE |
DATE |
2 |
10 |
Date of First Invoice |
02/01/2017 00:00:00 |
| AVERAGE_PAY_DAYS |
DOUBLE |
8 |
15 |
Average Time To Pay |
0 |
| LAST_INV_DATE |
DATE |
2 |
10 |
Last Invoice Date |
15/03/2017 00:00:00 |
| BALANCE |
DOUBLE |
8 |
15 |
Balance |
0 |
| FOREIGN_BALANCE |
DOUBLE |
8 |
15 |
Foreign Balance |
0 |
| TURNOVER_MTD |
DOUBLE |
8 |
15 |
Turnover Month To Date |
5220.54 |
| TURNOVER_YTD |
DOUBLE |
8 |
15 |
Turnover Year To Date |
5220.54 |
| PRIOR_YEAR |
DOUBLE |
8 |
15 |
Turnover Last Year |
0 |
| BANK_NAME |
VARCHAR |
60 |
60 |
Bank Name |
|
| BANK_ADDRESS_1 |
VARCHAR |
60 |
60 |
Bank Address Line1 |
|
| BANK_ADDRESS_2 |
VARCHAR |
60 |
60 |
Bank Address Line2 |
|
| BANK_ADDRESS_3 |
VARCHAR |
60 |
60 |
Bank Address Line3 |
|
| BANK_ADDRESS_4 |
VARCHAR |
60 |
60 |
Bank Address Line4 |
|
| BANK_ADDRESS_5 |
VARCHAR |
60 |
60 |
Bank Address Line5 |
|
| BANK_SORT_CODE |
VARCHAR |
10 |
10 |
Bank Sort Code |
|
| BANK_ACCOUNT_NAME |
VARCHAR |
60 |
60 |
Bank Account Name |
|
| BANK_ACCOUNT_NUMBER |
VARCHAR |
60 |
60 |
Bank Account Number |
|
| BANK_IBAN |
VARCHAR |
60 |
60 |
IBAN Number |
|
| BANK_BIC |
VARCHAR |
60 |
60 |
BIC/SWIFT Code |
|
| BANK_ROLLNUMBER |
VARCHAR |
60 |
60 |
Roll number |
|
| BANK_ADDITIONALREF1 |
VARCHAR |
60 |
60 |
Additional References |
|
| BANK_ADDITIONALREF2 |
VARCHAR |
60 |
60 |
Additional References |
|
| BANK_ADDITIONALREF3 |
VARCHAR |
60 |
60 |
Additional References |
|
| DONOR_TITLE |
VARCHAR |
4 |
4 |
Donor Title |
|
| DONOR_FORENAME |
VARCHAR |
35 |
35 |
Donor Forename |
|
| DONOR_SURNAME |
VARCHAR |
35 |
35 |
Donor Surname |
|
| DEFAULT_FUND_ID |
INTEGER |
4 |
10 |
Default Fund Number |
0 |
| GIFT_AID |
SMALLINT |
2 |
5 |
Gift Aid is enabled |
0 |
| INVOICE_BF |
DOUBLE |
8 |
15 |
Invoices Brought Forward |
0 |
| INVOICE_MTH1 |
DOUBLE |
8 |
15 |
Invoices Month 1 |
1432.17 |
| INVOICE_MTH2 |
DOUBLE |
8 |
15 |
Invoices Month 2 |
3511.88 |
| INVOICE_MTH3 |
DOUBLE |
8 |
15 |
Invoices Month 3 |
1173.07 |
| INVOICE_MTH4 |
DOUBLE |
8 |
15 |
Invoices Month 4 |
0 |
| INVOICE_MTH5 |
DOUBLE |
8 |
15 |
Invoices Month 5 |
0 |
| INVOICE_MTH6 |
DOUBLE |
8 |
15 |
Invoices Month 6 |
0 |
| INVOICE_MTH7 |
DOUBLE |
8 |
15 |
Invoices Month 7 |
0 |
| INVOICE_MTH8 |
DOUBLE |
8 |
15 |
Invoices Month 8 |
0 |
| INVOICE_MTH9 |
DOUBLE |
8 |
15 |
Invoices Month 9 |
0 |
| INVOICE_MTH10 |
DOUBLE |
8 |
15 |
Invoices Month 10 |
0 |
| INVOICE_MTH11 |
DOUBLE |
8 |
15 |
Invoices Month 11 |
0 |
| INVOICE_MTH12 |
DOUBLE |
8 |
15 |
Invoices Month 12 |
0 |
| INVOICE_CF |
DOUBLE |
8 |
15 |
Invoices Carry Forward |
0 |
| CREDIT_BF |
DOUBLE |
8 |
15 |
Credits Brought Forward |
0 |
| CREDIT_MTH1 |
DOUBLE |
8 |
15 |
Credits Month 1 |
0 |
| CREDIT_MTH2 |
DOUBLE |
8 |
15 |
Credits Month 2 |
0 |
| CREDIT_MTH3 |
DOUBLE |
8 |
15 |
Credits Month 3 |
0 |
| CREDIT_MTH4 |
DOUBLE |
8 |
15 |
Credits Month 4 |
0 |
| CREDIT_MTH5 |
DOUBLE |
8 |
15 |
Credits Month 5 |
0 |
| CREDIT_MTH6 |
DOUBLE |
8 |
15 |
Credits Month 6 |
0 |
| CREDIT_MTH7 |
DOUBLE |
8 |
15 |
Credits Month 7 |
0 |
| CREDIT_MTH8 |
DOUBLE |
8 |
15 |
Credits Month 8 |
0 |
| CREDIT_MTH9 |
DOUBLE |
8 |
15 |
Credits Month 9 |
0 |
| CREDIT_MTH10 |
DOUBLE |
8 |
15 |
Credits Month 10 |
0 |
| CREDIT_MTH11 |
DOUBLE |
8 |
15 |
Credits Month 11 |
0 |
| CREDIT_MTH12 |
DOUBLE |
8 |
15 |
Credits Month 12 |
0 |
| CREDIT_CF |
DOUBLE |
8 |
15 |
Credits Carry Forward |
0 |
| PAYMENT_BF |
DOUBLE |
8 |
15 |
Payments Brought Forward |
0 |
| PAYMENT_MTH1 |
DOUBLE |
8 |
15 |
Payments Month 1 |
1432.17 |
| PAYMENT_MTH2 |
DOUBLE |
8 |
15 |
Payments Month 2 |
0 |
| PAYMENT_MTH3 |
DOUBLE |
8 |
15 |
Payments Month 3 |
3511.88 |
| PAYMENT_MTH4 |
DOUBLE |
8 |
15 |
Payments Month 4 |
1173.07 |
| PAYMENT_MTH5 |
DOUBLE |
8 |
15 |
Payments Month 5 |
0 |
| PAYMENT_MTH6 |
DOUBLE |
8 |
15 |
Payments Month 6 |
0 |
| PAYMENT_MTH7 |
DOUBLE |
8 |
15 |
Payments Month 7 |
0 |
| PAYMENT_MTH8 |
DOUBLE |
8 |
15 |
Payments Month 8 |
0 |
| PAYMENT_MTH9 |
DOUBLE |
8 |
15 |
Payments Month 9 |
0 |
| PAYMENT_MTH10 |
DOUBLE |
8 |
15 |
Payments Month 10 |
0 |
| PAYMENT_MTH11 |
DOUBLE |
8 |
15 |
Payments Month 11 |
0 |
| PAYMENT_MTH12 |
DOUBLE |
8 |
15 |
Payments Month 12 |
0 |
| PAYMENT_CF |
DOUBLE |
8 |
15 |
Payments Carry Forward |
0 |
| DUNS_NUMBER |
VARCHAR |
9 |
9 |
DUNS Number |
|
| PRIORITY |
SMALLINT |
2 |
5 |
Priority |
0 |
| PROMISED_PAYMENT |
DOUBLE |
8 |
15 |
Latest amount promised to be paid. |
500 |
| PROMISED_PAYMENT_DATE |
DATE |
2 |
10 |
Date on which the last promise to pay was made. |
25/09/2008 00:00:00 |
| REPORT_PASSWORD |
VARCHAR |
31 |
31 |
Password used to encrypt secure PDFs |
|
| LETTERS_VIA_EMAIL |
SMALLINT |
2 |
5 |
Send letters via email? |
0 |
| PAYMENT_METHOD_ID |
INTEGER |
4 |
10 |
Unique ID of the payment method used by this account |
3 |
| DECLARATION_VALID_FROM |
DATE |
2 |
10 |
Donor Declaration Valid From |
|
| INACTIVE_FLAG |
TINYINT |
1 |
3 |
Inactive Flag - Yes/No |
0 |
| MANDATEID |
VARCHAR |
37 |
37 |
Mandate ID |
|
| STATUS |
TINYINT |
1 |
3 |
Mandate status |
0 |
| STATUS_DESCRIPTION |
VARCHAR |
25 |
25 |
Mandate status description |
|
| LAST_REFRESHED_DATE |
|
16 |
0 |
Date mandate last refreshed |
|
| RECORD_CREATE_DATE |
|
16 |
0 |
Date and time when the record was created. |
27/04/2010 17:16:57 |
| RECORD_MODIFY_DATE |
|
16 |
0 |
Date and time when the record was modified. |
04/08/2017 14:18:49 |
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
0 |