| INVOICE_NUMBER |
INTEGER |
4 |
10 |
Invoice number |
1 |
| INVOICE_TYPE_CODE |
TINYINT |
1 |
3 |
Invoice type code |
0 |
| INVOICE_TYPE |
VARCHAR |
60 |
60 |
Invoice type description |
Product Invoice |
| INVOICE_OR_CREDIT |
VARCHAR |
60 |
60 |
Invoice/Credit/Quote/Proforma label |
Invoice |
| INVOICE_DATE |
DATE |
2 |
10 |
Invoice Date |
02/01/2016 00:00:00 |
| ACCOUNT_REF |
VARCHAR |
8 |
8 |
Account reference |
A1D001 |
| NAME |
VARCHAR |
60 |
60 |
Name |
A1 Design Services |
| ADDRESS_1 |
VARCHAR |
60 |
60 |
Address line 1 |
67a Station Road |
| ADDRESS_2 |
VARCHAR |
60 |
60 |
Address line 2 |
|
| ADDRESS_3 |
VARCHAR |
60 |
60 |
Address line 3 |
Blackpool |
| ADDRESS_4 |
VARCHAR |
60 |
60 |
Address line 4 |
Lancashire |
| ADDRESS_5 |
VARCHAR |
60 |
60 |
Address line 5 |
BP12 7HT |
| C_ADDRESS_1 |
VARCHAR |
60 |
60 |
Compact Address line 1 |
67a Station Road |
| C_ADDRESS_2 |
VARCHAR |
60 |
60 |
Compact Address line 2 |
Blackpool |
| C_ADDRESS_3 |
VARCHAR |
60 |
60 |
Compact Address line 3 |
Lancashire |
| C_ADDRESS_4 |
VARCHAR |
60 |
60 |
Compact Address line 4 |
BP12 7HT |
| C_ADDRESS_5 |
VARCHAR |
60 |
60 |
Compact Address line 5 |
|
| DEL_NAME |
VARCHAR |
60 |
60 |
Delivery name |
A1 Design Services |
| DEL_ADDRESS_1 |
VARCHAR |
60 |
60 |
Delivery address line 1 |
67a Station Road |
| DEL_ADDRESS_2 |
VARCHAR |
60 |
60 |
Delivery address line 2 |
|
| DEL_ADDRESS_3 |
VARCHAR |
60 |
60 |
Delivery address line 3 |
Blackpool |
| DEL_ADDRESS_4 |
VARCHAR |
60 |
60 |
Delivery address line 4 |
Lancashire |
| DEL_ADDRESS_5 |
VARCHAR |
60 |
60 |
Delivery address line 5 |
BP12 7HT |
| VAT_REG_NUMBER |
VARCHAR |
20 |
20 |
VAT Registration Number |
|
| ORDER_NUMBER |
VARCHAR |
7 |
7 |
Corresponding order number |
|
| ORDER_NUMBER_NUMERIC |
INTEGER |
4 |
10 |
Numeric verison of ORDER_NUMBER (NB Not always the corresponding order number) |
0 |
| CONTACT_NAME |
VARCHAR |
30 |
30 |
Contact name |
Jim Thomas |
| TAKEN_BY |
VARCHAR |
60 |
60 |
Order taken by |
George |
| CUST_ORDER_NUMBER |
VARCHAR |
60 |
60 |
Customer's order number |
7667 |
| CUST_TEL_NUMBER |
VARCHAR |
30 |
30 |
Customer's telephone number |
01742 876 234 |
| NOTES_1 |
VARCHAR |
60 |
60 |
Notes 1 |
Please notify our head office |
| NOTES_2 |
VARCHAR |
60 |
60 |
Notes 2 |
as soon as possible with any |
| NOTES_3 |
VARCHAR |
60 |
60 |
Notes 3 |
delivery descrepencies. |
| CUST_DISC_RATE |
DOUBLE |
8 |
15 |
Customer Discount |
0 |
| FOREIGN_ITEMS_NET |
DOUBLE |
8 |
15 |
Net amount (goods but not carriage) |
1123.04 |
| FOREIGN_ITEMS_TAX |
DOUBLE |
8 |
15 |
Tax amount (goods but not carriage) |
191.63 |
| FOREIGN_ITEMS_GROSS |
DOUBLE |
8 |
15 |
Gross amount (goods but not carriage) |
1314.67 |
| ITEMS_NET |
DOUBLE |
8 |
15 |
Net amount (goods but not carriage) |
1123.04 |
| ITEMS_TAX |
DOUBLE |
8 |
15 |
Tax amount (goods but not carriage) |
191.63 |
| ITEMS_GROSS |
DOUBLE |
8 |
15 |
Gross amount (goods but not carriage) |
1314.67 |
| TAX_RATE_1 |
DOUBLE |
8 |
15 |
Highest tax rate |
20 |
| TAX_RATE_2 |
DOUBLE |
8 |
15 |
Second highest tax rate |
0 |
| TAX_RATE_3 |
DOUBLE |
8 |
15 |
Third highest tax rate |
0 |
| TAX_RATE_4 |
DOUBLE |
8 |
15 |
Fourth highest tax rate |
0 |
| TAX_RATE_5 |
DOUBLE |
8 |
15 |
Fifth highest tax rate |
0 |
| NET_AMOUNT_1 |
DOUBLE |
8 |
15 |
Net amount at highest tax rate |
1123.04 |
| NET_AMOUNT_2 |
DOUBLE |
8 |
15 |
Net amount at second highest tax rate |
0 |
| NET_AMOUNT_3 |
DOUBLE |
8 |
15 |
Net amount at third highest tax rate |
0 |
| NET_AMOUNT_4 |
DOUBLE |
8 |
15 |
Net amount at fourth highest tax rate |
0 |
| NET_AMOUNT_5 |
DOUBLE |
8 |
15 |
Net amount at fifth highest tax rate |
0 |
| TAX_AMOUNT_1 |
DOUBLE |
8 |
15 |
Tax amount at highest tax rate |
191.63 |
| TAX_AMOUNT_2 |
DOUBLE |
8 |
15 |
Tax amount at second highest tax rate |
0 |
| TAX_AMOUNT_3 |
DOUBLE |
8 |
15 |
Tax amount at third highest tax rate |
0 |
| TAX_AMOUNT_4 |
DOUBLE |
8 |
15 |
Tax amount at fourth highest tax rate |
0 |
| TAX_AMOUNT_5 |
DOUBLE |
8 |
15 |
Tax amount at fifth highest tax rate |
0 |
| GLOBAL_NOM_CODE |
VARCHAR |
8 |
8 |
Global nominal code |
|
| GLOBAL_DETAILS |
VARCHAR |
60 |
60 |
Global details |
|
| GLOBAL_TAX_CODE |
VARCHAR |
3 |
3 |
Global tax code (T0 to T99) |
T1 |
| GLOBAL_DEPT_NUMBER |
SMALLINT |
2 |
5 |
Global department number |
0 |
| GLOBAL_DEPT_NAME |
VARCHAR |
60 |
60 |
Global department name |
Default |
| COURIER_NUMBER |
SMALLINT |
2 |
5 |
Courier Number |
2 |
| COURIER_NAME |
VARCHAR |
60 |
60 |
Courier Name |
DHL |
| CONSIGNMENT |
VARCHAR |
30 |
30 |
Consignment Reference |
4645487 |
| CARR_NOM_CODE |
VARCHAR |
8 |
8 |
Carriage nominal code |
4905 |
| CARR_TAX_CODE |
VARCHAR |
3 |
3 |
Carriage tax code (T0 to T99) |
T1 |
| CARR_DEPT_NUMBER |
SMALLINT |
2 |
5 |
Carriage department number |
1 |
| CARR_DEPT_NAME |
VARCHAR |
60 |
60 |
Carriage department name |
Sales |
| FOREIGN_CARR_NET |
DOUBLE |
8 |
15 |
Carriage net amount |
100 |
| FOREIGN_CARR_TAX |
DOUBLE |
8 |
15 |
Carriage tax amount |
17.5 |
| FOREIGN_CARR_GROSS |
DOUBLE |
8 |
15 |
Carriage gross amount (carriage net + carriage tax) |
117.5 |
| CARR_NET |
DOUBLE |
8 |
15 |
Carriage net amount |
100 |
| CARR_TAX |
DOUBLE |
8 |
15 |
Carriage tax amount |
17.5 |
| CARR_GROSS |
DOUBLE |
8 |
15 |
Carriage gross amount (carriage net + carriage tax) |
117.5 |
| FOREIGN_INVOICE_NET |
DOUBLE |
8 |
15 |
Invoice net amount (goods and carriage net) |
1223.04 |
| FOREIGN_INVOICE_TAX |
DOUBLE |
8 |
15 |
Invoice tax amount (goods and carriage tax) |
209.13 |
| FOREIGN_INVOICE_GROSS |
DOUBLE |
8 |
15 |
Invoice gross amount (goods and carriage gross) |
1432.17 |
| INVOICE_NET |
DOUBLE |
8 |
15 |
Invoice net amount (goods and carriage net) |
1223.04 |
| INVOICE_TAX |
DOUBLE |
8 |
15 |
Invoice tax amount (goods and carriage tax) |
209.13 |
| INVOICE_GROSS |
DOUBLE |
8 |
15 |
Invoice gross amount (goods and carriage gross) |
1432.17 |
| CURRENCY |
TINYINT |
1 |
3 |
Which foreign currency |
1 |
| CURRENCY_TYPE |
TINYINT |
1 |
3 |
Foreign or Euro currency |
0 |
| EURO_GROSS |
DOUBLE |
8 |
15 |
Gross amount in Euros |
0 |
| EURO_RATE |
DOUBLE |
8 |
15 |
Euro exchange rate |
0 |
| FOREIGN_RATE |
DOUBLE |
8 |
15 |
Foreign exchange rate |
1 |
| SETTLEMENT_DUE_DAYS |
SMALLINT |
2 |
5 |
Settlement days |
15 |
| SETTLEMENT_DISC_RATE |
DOUBLE |
8 |
15 |
Settlement discount % rate |
2.5 |
| FOREIGN_SETTLEMENT_DISC_AMOUNT |
DOUBLE |
8 |
15 |
Settlement discount amount (reduction) |
28.09 |
| FOREIGN_SETTLEMENT_TOTAL |
DOUBLE |
8 |
15 |
Invoice total after settlement discount |
1396.37 |
| FOREIGN_AMOUNT_PREPAID |
DOUBLE |
8 |
15 |
Amount prepaid |
0 |
| SETTLEMENT_DISC_AMOUNT |
DOUBLE |
8 |
15 |
Settlement discount amount (reduction) |
28.09 |
| SETTLEMENT_TOTAL |
DOUBLE |
8 |
15 |
Invoice total after settlement discount |
1396.37 |
| AMOUNT_PREPAID |
DOUBLE |
8 |
15 |
Amount prepaid |
0 |
| PAYMENT_REF |
VARCHAR |
30 |
30 |
Payment reference |
|
| PRINTED |
VARCHAR |
1 |
1 |
Printed flag - y or blank |
Y |
| PRINTED_CODE |
TINYINT |
1 |
3 |
Printed flag - 1/0 |
1 |
| POSTED |
VARCHAR |
1 |
1 |
Posted flag - y or blank |
Y |
| POSTED_CODE |
TINYINT |
1 |
3 |
Posted flag - 1/0 |
1 |
| QUOTE_EXPIRY_DATE |
DATE |
2 |
10 |
Quote expiry date |
|
| QUOTE_STATUS |
VARCHAR |
60 |
60 |
Quote status |
|
| QUOTE_STATUS_ID |
TINYINT |
1 |
3 |
Quote status Id |
0 |
| RECURRING_REF |
VARCHAR |
11 |
11 |
Recurring entry reference |
|
| DUNS_NUMBER |
VARCHAR |
9 |
9 |
DUNS Number |
|
| NET_VALUE_DISCOUNT_NET |
DOUBLE |
8 |
15 |
Net value discount value (foreign currency) |
0 |
| NET_VALUE_DISCOUNT_NET_BASE |
DOUBLE |
8 |
15 |
Net value discount (base currency) |
0 |
| NET_VALUE_DISCOUNT_RATE |
DOUBLE |
8 |
15 |
Net value discount percentage |
0 |
| NET_VALUE_DISCOUNT_DESC |
VARCHAR |
60 |
60 |
Net value discount description |
|
| NET_VALUE_DISCOUNT_COMMENT_1 |
VARCHAR |
60 |
60 |
Net value discount comment 1 |
|
| NET_VALUE_DISCOUNT_COMMENT_2 |
VARCHAR |
60 |
60 |
Net value discount comment 2 |
|
| PAYMENT_TYPE |
TINYINT |
1 |
3 |
Payment Type: 0 - Already received. 3 - SR. 4 - SA. |
3 |
| BANK_REF |
VARCHAR |
8 |
8 |
Bank account used for payment |
1200 |
| GDN_NUMBER |
INTEGER |
4 |
10 |
GDN Reference |
0 |
| PROJECT_ID |
INTEGER |
4 |
10 |
ID of linked Project |
0 |
| ANALYSIS_1 |
VARCHAR |
30 |
30 |
Analysis 1 |
|
| ANALYSIS_2 |
VARCHAR |
30 |
30 |
Analysis 2 |
|
| ANALYSIS_3 |
VARCHAR |
30 |
30 |
Analysis 3 |
|
| PAYMENT_DUE_DATE |
DATE |
2 |
10 |
Invoice Payment Due Date |
|
| 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 |