| ORDER_NUMBER |
INTEGER |
4 |
10 |
Order Reference number |
1 |
| ITEM_NUMBER |
SMALLINT |
2 |
5 |
Item number |
1 |
| JOB_NUMBER |
VARCHAR |
60 |
60 |
Job number |
|
| SERVICE_FLAG |
SMALLINT |
2 |
5 |
Product or Service item flag |
0 |
| DESCRIPTION |
VARCHAR |
60 |
60 |
Description |
Envelope - White (110 x 220) Plain |
| TEXT |
LONG VARCHAR |
32767 |
32767 |
Service item text |
|
| STOCK_CODE |
VARCHAR |
30 |
30 |
Stock code |
ENV001 |
| COMMENT_1 |
VARCHAR |
60 |
60 |
Comment 1 |
|
| COMMENT_2 |
VARCHAR |
60 |
60 |
Comment 2 |
|
| UNIT_OF_SALE |
VARCHAR |
8 |
8 |
Unit of sale |
1000 Box |
| QTY_ORDER |
DOUBLE |
8 |
15 |
Quantity ordered |
40 |
| QTY_ALLOCATED |
DOUBLE |
8 |
15 |
Quantity allocated for this order |
0 |
| QTY_DELIVERED |
DOUBLE |
8 |
15 |
Quantity previously delivered for this order |
40 |
| QTY_DESPATCH |
DOUBLE |
8 |
15 |
Quantity to despatch/despatched on this delivery |
0 |
| QTY_LAST_DESPATCH |
DOUBLE |
8 |
15 |
Quantity despatched on most recent delivery |
0 |
| FOREIGN_UNIT_PRICE |
DOUBLE |
8 |
15 |
Unit price |
6 |
| FOREIGN_DISCOUNT_AMOUNT |
DOUBLE |
8 |
15 |
Discount amount |
24 |
| UNIT_PRICE |
DOUBLE |
8 |
15 |
Unit price |
6 |
| DISCOUNT_AMOUNT |
DOUBLE |
8 |
15 |
Discount amount |
24 |
| DISCOUNT_RATE |
DOUBLE |
8 |
15 |
Discount percentage rate |
10 |
| DELIVERY_DATE |
DATE |
2 |
10 |
Delivery date |
07/01/2006 00:00:00 |
| NOMINAL_CODE |
VARCHAR |
8 |
8 |
Nominal code |
|
| 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) |
240 |
| NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (after discount) |
216 |
| TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount |
36.86 |
| GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (net after discount + tax) |
252.86 |
| FOREIGN_FULL_NET_AMOUNT |
DOUBLE |
8 |
15 |
Full net amount (before discount) |
240 |
| FOREIGN_NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (after discount) |
216 |
| FOREIGN_TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount |
36.86 |
| FOREIGN_GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (net after discount + tax) |
252.86 |
| THIS_RECORD |
INTEGER |
4 |
10 |
Record number |
2 |
| POP_ITEM_ID |
INTEGER |
4 |
10 |
Unique pop item identifier |
2 |
| QTY_ALLOCATED_TO_PROJECT |
DOUBLE |
8 |
15 |
Quantity allocated to project |
0 |
| QTY_ISSUED_TO_PROJECT |
DOUBLE |
8 |
15 |
Quantity issued to project |
0 |
| DUE_DATE |
DATE |
2 |
10 |
Due date |
|
| QTY_COMMITTED_TO_PROJECT |
DOUBLE |
8 |
15 |
Quantity committed to project (for committed cost calculation) |
0 |
| PROJECT_REF |
VARCHAR |
12 |
12 |
Reference for associated project |
|
| PROJECT_NAME |
VARCHAR |
60 |
60 |
Name of associated project |
|
| COST_CODE_REF |
VARCHAR |
8 |
8 |
Reference for associated cost code |
|
| ITEMID |
INTEGER |
4 |
10 |
Item ID |
2 |
| GENERATED_MESSAGE |
SMALLINT |
2 |
5 |
True if this message was automatically generated |
0 |
| QTY_INVOICED |
DOUBLE |
8 |
15 |
Qty Invoiced |
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:52 |
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
0 |