ORDER_NUMBER |
INTEGER |
4 |
10 |
Order number |
1 |
ORDER_OR_QUOTE |
VARCHAR |
60 |
60 |
Order/Quote label |
Purchase Order |
ORDER_DATE |
DATE |
2 |
10 |
Order Date |
05/01/2016 00:00:00 |
DELIVERY_DATE |
DATE |
2 |
10 |
Delivery date |
|
ORDER_STATUS_CODE |
TINYINT |
1 |
3 |
Order status code |
0 |
ORDER_STATUS |
VARCHAR |
60 |
60 |
Order status description |
|
DELIVERY_STATUS_CODE |
TINYINT |
1 |
3 |
Delivery status code |
2 |
DELIVERY_STATUS |
VARCHAR |
60 |
60 |
Delivery status description |
Complete |
ACCOUNT_REF |
VARCHAR |
8 |
8 |
Account reference |
WIS002 |
NAME |
VARCHAR |
60 |
60 |
Name |
Wiseman Paper Products |
ADDRESS_1 |
VARCHAR |
60 |
60 |
Address line 1 |
Wiseman House |
ADDRESS_2 |
VARCHAR |
60 |
60 |
Address line 2 |
Freddicks Way, Bell Estate |
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 |
NE1 2ED |
C_ADDRESS_1 |
VARCHAR |
60 |
60 |
Compact Address line 1 |
Wiseman House |
C_ADDRESS_2 |
VARCHAR |
60 |
60 |
Compact Address line 2 |
Freddicks Way, Bell Estate |
C_ADDRESS_3 |
VARCHAR |
60 |
60 |
Compact Address line 3 |
Newcastle Upon Tyne |
C_ADDRESS_4 |
VARCHAR |
60 |
60 |
Compact Address line 4 |
NE1 2ED |
C_ADDRESS_5 |
VARCHAR |
60 |
60 |
Compact Address line 5 |
|
DEL_NAME |
VARCHAR |
60 |
60 |
Delivery name |
Wiseman Paper Products |
DEL_ADDRESS_1 |
VARCHAR |
60 |
60 |
Delivery address line 1 |
Sage House |
DEL_ADDRESS_2 |
VARCHAR |
60 |
60 |
Delivery address line 2 |
Benton Park Road |
DEL_ADDRESS_3 |
VARCHAR |
60 |
60 |
Delivery address line 3 |
Newcastle Upon Tyne |
DEL_ADDRESS_4 |
VARCHAR |
60 |
60 |
Delivery address line 4 |
|
DEL_ADDRESS_5 |
VARCHAR |
60 |
60 |
Delivery address line 5 |
NE7 7LZ |
VAT_REG_NUMBER |
VARCHAR |
20 |
20 |
VAT Registration Number |
|
REFERENCE |
VARCHAR |
7 |
7 |
Reference |
|
CONTACT_NAME |
VARCHAR |
30 |
30 |
Contact name |
Kathy Jordan |
TAKEN_BY |
VARCHAR |
60 |
60 |
Order taken by |
|
SUPP_ORDER_NUMBER |
VARCHAR |
60 |
60 |
Supplier's order number |
|
SUPP_TEL_NUMBER |
VARCHAR |
30 |
30 |
Supplier's telephone number |
0191 987 3897 |
NOTES_1 |
VARCHAR |
60 |
60 |
Notes 1 |
|
NOTES_2 |
VARCHAR |
60 |
60 |
Notes 2 |
|
NOTES_3 |
VARCHAR |
60 |
60 |
Notes 3 |
|
SUPP_DISC_RATE |
DOUBLE |
8 |
15 |
Supplier Discount |
10 |
FOREIGN_ITEMS_NET |
DOUBLE |
8 |
15 |
Net amount (goods but not carriage) |
527.4 |
FOREIGN_ITEMS_TAX |
DOUBLE |
8 |
15 |
Tax amount (goods but not carriage) |
89.99 |
FOREIGN_ITEMS_GROSS |
DOUBLE |
8 |
15 |
Gross amount (goods but not carriage) |
617.39 |
ITEMS_NET |
DOUBLE |
8 |
15 |
Net amount (goods but not carriage) |
527.4 |
ITEMS_TAX |
DOUBLE |
8 |
15 |
Tax amount (goods but not carriage) |
89.99 |
ITEMS_GROSS |
DOUBLE |
8 |
15 |
Gross amount (goods but not carriage) |
617.39 |
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 |
527.4 |
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 |
89.99 |
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 |
COURIER_NUMBER |
SMALLINT |
2 |
5 |
Courier Number |
1 |
COURIER_NAME |
VARCHAR |
60 |
60 |
Courier Name |
UKMail |
CONSIGNMENT |
VARCHAR |
30 |
30 |
Consignment Reference |
|
CARR_NOM_CODE |
VARCHAR |
8 |
8 |
Carriage nominal code |
|
CARR_TAX_CODE |
VARCHAR |
3 |
3 |
Carriage tax code (T0 to T99) |
T1 |
CARR_DEPT_NUMBER |
SMALLINT |
2 |
5 |
Carriage department number |
2 |
CARR_DEPT_NAME |
VARCHAR |
60 |
60 |
Carriage department name |
Purchasing |
FOREIGN_CARR_NET |
DOUBLE |
8 |
15 |
Carriage net amount |
0 |
FOREIGN_CARR_TAX |
DOUBLE |
8 |
15 |
Carriage tax amount |
0 |
FOREIGN_CARR_GROSS |
DOUBLE |
8 |
15 |
Carriage gross amount (carriage net + carriage tax) |
0 |
CARR_NET |
DOUBLE |
8 |
15 |
Carriage net amount |
0 |
CARR_TAX |
DOUBLE |
8 |
15 |
Carriage tax amount |
0 |
CARR_GROSS |
DOUBLE |
8 |
15 |
Carriage gross amount (carriage net + carriage tax) |
0 |
FOREIGN_INVOICE_NET |
DOUBLE |
8 |
15 |
Invoice net amount (goods and carriage net) |
527.4 |
FOREIGN_INVOICE_TAX |
DOUBLE |
8 |
15 |
Invoice tax amount (goods and carriage tax) |
89.99 |
FOREIGN_INVOICE_GROSS |
DOUBLE |
8 |
15 |
Invoice gross amount (goods and carriage gross) |
617.39 |
INVOICE_NET |
DOUBLE |
8 |
15 |
Invoice net amount (goods and carriage net) |
527.4 |
INVOICE_TAX |
DOUBLE |
8 |
15 |
Invoice tax amount (goods and carriage tax) |
89.99 |
INVOICE_GROSS |
DOUBLE |
8 |
15 |
Invoice gross amount (goods and carriage gross) |
617.39 |
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 |
30 |
SETTLEMENT_DISC_RATE |
DOUBLE |
8 |
15 |
Settlement discount % rate |
2.5 |
FOREIGN_SETTLEMENT_DISC_AMOUNT |
DOUBLE |
8 |
15 |
Settlement discount amount (reduction) |
13.19 |
FOREIGN_SETTLEMENT_TOTAL |
DOUBLE |
8 |
15 |
Invoice total after settlement discount |
601.96 |
SETTLEMENT_DISC_AMOUNT |
DOUBLE |
8 |
15 |
Settlement discount amount (reduction) |
13.19 |
SETTLEMENT_TOTAL |
DOUBLE |
8 |
15 |
Invoice total after settlement discount |
601.96 |
PAYMENT_REF |
VARCHAR |
30 |
30 |
Payment reference |
|
PRINTED |
VARCHAR |
1 |
1 |
Printed flag - y or blank |
|
PRINTED_CODE |
TINYINT |
1 |
3 |
Printed flag - 1/0 |
0 |
POSTED |
VARCHAR |
1 |
1 |
Posted flag - y or blank |
|
POSTED_CODE |
TINYINT |
1 |
3 |
Posted flag - 1/0 |
0 |
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 |
|
PAYMENT_TYPE |
TINYINT |
1 |
3 |
Payment Type: 0 - Already received. 3 - SR. 4 - SA. |
0 |
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 |
|
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:52 |
RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
0 |