| INVOICE_NUMBER |
INTEGER |
4 |
10 |
Invoice reference number |
1 |
| ITEM_NUMBER |
SMALLINT |
2 |
5 |
Item number |
1 |
| JOB_NUMBER |
VARCHAR |
60 |
60 |
Job number |
|
| SERVICE_FLAG |
SMALLINT |
2 |
5 |
Service invoice/credit flag |
0 |
| DESCRIPTION |
VARCHAR |
60 |
60 |
Description |
AT Mini Tower Case |
| TEXT |
LONG VARCHAR |
32767 |
32767 |
Service invoice/credit text |
|
| STOCK_CODE |
VARCHAR |
30 |
30 |
Stockcode |
CAS001 |
| COMMENT_1 |
VARCHAR |
60 |
60 |
Comment 1 |
|
| COMMENT_2 |
VARCHAR |
60 |
60 |
Comment 2 |
|
| UNIT_OF_SALE |
VARCHAR |
8 |
8 |
Unit of sale |
Each |
| QUANTITY |
DOUBLE |
8 |
15 |
Quantity |
1 |
| FOREIGN_UNIT_PRICE |
DOUBLE |
8 |
15 |
Unit price |
14.25 |
| FOREIGN_DISCOUNT_AMOUNT |
DOUBLE |
8 |
15 |
Discount amount |
0 |
| UNIT_PRICE |
DOUBLE |
8 |
15 |
Unit price |
14.25 |
| DISCOUNT_AMOUNT |
DOUBLE |
8 |
15 |
Discount amount |
0 |
| DISCOUNT_RATE |
DOUBLE |
8 |
15 |
Discount percentage rate |
0 |
| DELIVERY_DATE |
DATE |
2 |
10 |
Delivery date |
|
| NOMINAL_CODE |
VARCHAR |
8 |
8 |
Nominal code |
4000 |
| DEPT_NUMBER |
SMALLINT |
2 |
5 |
Department number |
1 |
| DEPT_NAME |
VARCHAR |
60 |
60 |
Department name |
Sales |
| TAX_CODE_ID |
SMALLINT |
2 |
5 |
Tax code |
1 |
| TAX_CODE |
VARCHAR |
3 |
3 |
Tax code (T0 to T99) |
T1 |
| ADD_DISC_RATE |
DOUBLE |
8 |
15 |
Additional discount percentage rate |
0 |
| TAX_RATE |
DOUBLE |
8 |
15 |
Tax rate |
17.5 |
| FULL_NET_AMOUNT |
DOUBLE |
8 |
15 |
Full net amount (before discount) |
14.25 |
| NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (after discount) |
14.25 |
| TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount |
2.43 |
| GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (net after discount + tax) |
16.68 |
| FOREIGN_FULL_NET_AMOUNT |
DOUBLE |
8 |
15 |
Full net amount (before discount) |
14.25 |
| FOREIGN_NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (after discount) |
14.25 |
| FOREIGN_TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount |
2.43 |
| FOREIGN_GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (net after discount + tax) |
16.68 |
| EXT_ORDER_REF |
VARCHAR |
30 |
30 |
External Order Ref for SOP to Invoice Link |
|
| EXT_ORDER_LINE_REF |
INTEGER |
4 |
10 |
External Order Line Ref for SOP to Invoice Link |
0 |
| PROJECT_ID |
INTEGER |
4 |
10 |
ID of linked Project |
0 |
| ITEMID |
INTEGER |
4 |
10 |
Item ID |
2 |
| NEGOTIATION_DISC_NET |
DOUBLE |
8 |
15 |
Negotiation discount net (foreign currency) |
0 |
| NEGOTIATION_DISC_NET_BASE |
DOUBLE |
8 |
15 |
Negotiation discount net (base currency) |
0 |
| GENERATED_MESSAGE |
SMALLINT |
2 |
5 |
True if this message was automatically generated |
0 |
| EC_VAT_DESCRIPTION_ID |
INTEGER |
4 |
10 |
The unique ID of the EC VAT Description applied to this item line |
0 |
| 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 |