Export_orders
The document corresponds to the WinBIZ standard import. This format is not directly compatible (a pre processing is needed on the document).
The corresponding IMPROVED functionality is available in the API Winbiz Cloud with the method DocumentImport
|
Field Number |
Description
|
OsCommerce field
|
Type
|
|
1 |
Document Nb. |
orders.orders_id |
N(5) |
|
2 |
Document type |
12 |
N(2) |
|
3 |
Date |
orders.date_purchased (parse date) |
YYYYMMDD |
|
4 |
Hour |
orders.date_purchased (parse hour) |
HH:MM |
|
5 |
|
|
|
|
6 |
Total amount in local currency |
orders_total.value |
N(10,2) |
|
7 |
Currency ISO code |
orders.currency |
C(3) |
|
8 - 13 |
|
|
|
|
14 |
Document format |
0 |
N(1) |
|
15 -16 |
|
|
|
|
17 |
Reserved 2 |
orders.orders_id |
N(5) |
|
18 |
Reserved 3 |
|
|
|
19 |
Reserved 4 |
Order’s comments (orders_status_history.comments) |
|
|
20 |
Address code |
orders.customers_id |
N(5) |
|
21 |
Civil title |
customers.customers_gender (m/f) |
C(1) |
|
22 |
Company name |
orders.customers_company |
|
|
23 |
Last name |
determined according to orders.customers_name and customers |
C(32) |
|
24 |
First name |
determined according to orders.customers_name and customers |
C(32) |
|
25 |
Address line 1 |
orders.billing_street_address |
C(64) |
|
26 |
Address line 2 |
orders.billing_suburb |
C(64) |
|
27 |
ZIP |
orders.billing_postcode |
C(10) |
|
28 |
City |
orders.billing_city |
C(32) |
|
29 |
Country ISO code |
determined according to countries.countries_iso_code_3 |
C(3) |
|
30 |
Country name |
orders.billing_country |
C(64) |
|
31 |
|
|
C(2) |
|
32 |
Telephone 1 |
customers.customers_telephone |
C(32) |
|
33 |
|
|
|
|
34 |
Fax |
customers.customers_fax |
C(32) |
|
35 |
|
|
|
|
36 |
|
customers.customers_email_address |
C(96) |
|
37 - 39 |
|
|
|
|
40 |
Creation date |
customers_info.customers_info_date_account_created |
YYYYMMDD |
|
41 |
Birthdate |
customers.customers_dob |
YYYYMMDD |
|
42 |
|
|
|
|
43 |
|
Delivery address (only if different from the billing address) |
|
|
44-47 |
|
|
|
|
48 |
Line nr. |
|
N(4) |
|
49 |
Line type |
1 |
N(1) |
|
50 |
Item code |
orders_products.products_model or #BOITEM# or #SHIPPINGCOST# or #LOWORDERFEE# |
C(12) |
|
51 |
Description |
orders_products.products_name |
C(64) |
|
52 |
|
|
|
|
53 |
Quantity |
orders_products.products_quantity |
N(2) |
|
54 |
Price in local currency |
orders_products.products_price |
N(15,4) |
|
55 |
|
|
|
|
56 |
Discount % |
discount % for the line. In order to specify an amount, see field 67 |
N(7,3) |
|
57 |
Amount |
orders_products.final_price |
N(15,4) |
|
58 - 60 |
|
|
|
|
61 |
VAT % |
orders_products.products_tax |
N(7,4) |
|
62 |
VAT Included/excluded |
2 |
N(1) |
|
63 - 66 |
|
|
|
|
67 |
Discount Amount |
amount of the discount for the line. In order to specify a %, see field 56. The amount doesn't need to be negative. |
N(7,3) |
|
68 - 73 |
|
|
|
|
74 |
Item update |
0 |
N(1) |
|
75 - 133 |
|
|
|
Remarks:
This data structure is very similar to the one of the standard import of documents.
It is also possible, following the import debtor payments structure to import the payments of each document.