| 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 |
PC Combo Pack 4 |
| TEXT |
LONG VARCHAR |
32767 |
32767 |
Service item text |
|
| STOCK_CODE |
VARCHAR |
30 |
30 |
Stock code |
PC004 |
| COMMENT_1 |
VARCHAR |
60 |
60 |
Comment 1 |
|
| COMMENT_2 |
VARCHAR |
60 |
60 |
Comment 2 |
|
| UNIT_OF_SALE |
VARCHAR |
8 |
8 |
Unit of sale |
Each |
| QTY_ORDER |
DOUBLE |
8 |
15 |
Quantity ordered |
5 |
| QTY_ALLOCATED |
DOUBLE |
8 |
15 |
Quantity allocated for this order |
0 |
| QTY_DELIVERED |
DOUBLE |
8 |
15 |
Quantity previously delivered for this order |
5 |
| 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 |
765 |
| FOREIGN_DISCOUNT_AMOUNT |
DOUBLE |
8 |
15 |
Discount amount |
765 |
| UNIT_PRICE |
DOUBLE |
8 |
15 |
Unit price |
765 |
| DISCOUNT_AMOUNT |
DOUBLE |
8 |
15 |
Discount amount |
765 |
| DISCOUNT_RATE |
DOUBLE |
8 |
15 |
Discount percentage rate |
20 |
| DELIVERY_DATE |
DATE |
2 |
10 |
Delivery date |
04/01/2006 00:00:00 |
| 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) |
3825 |
| NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (after discount) |
3060 |
| TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount |
522.11 |
| GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (net after discount + tax) |
3582.11 |
| FOREIGN_FULL_NET_AMOUNT |
DOUBLE |
8 |
15 |
Full net amount (before discount) |
3825 |
| FOREIGN_NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (after discount) |
3060 |
| FOREIGN_TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount |
522.11 |
| FOREIGN_GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (net after discount + tax) |
3582.11 |
| 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 |
| THIS_RECORD |
INTEGER |
4 |
10 |
Record number |
2 |
| POP_ITEM_ID |
INTEGER |
4 |
10 |
Unique pop item identifier |
2 |
| DUE_DATE |
DATE |
2 |
10 |
Due date |
|
| 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 |
| 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 |