Table Spir_Order
Purpose
End-client order details (non-norwex)
Field definitions in table Spir_Order
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | OrderNo | VARCHAR(50) | N | Order number (not unique) |
| 2 | Y | OrderDate | VARCHAR(50) | N | Date order was placed (string) |
| 3 | Y | DClientID | VARCHAR(50) | N | Destination client ID |
| 4 | Y | DClientFirstName | VARCHAR(50) | N | Destination client first name |
| 5 | Y | DClientLastName | VARCHAR(50) | N | Destination client last name |
| 6 | Y | DClientCompany | VARCHAR(250) | N | Destination client company |
| 7 | Y | DClientCompanyAddress | VARCHAR(250) | N | Destination client company address |
| 8 | Y | DClientTown | VARCHAR(50) | N | Destination client town |
| 9 | Y | DClientTownCode | VARCHAR(50) | N | Destination client town zip code |
| 10 | Y | DClientAddress | VARCHAR(200) | N | Destination client address line |
| 11 | Y | DClientAddress1 | VARCHAR(200) | N | Destination client address line 2 |
| 12 | Y | DClientAddress2 | VARCHAR(200) | N | Destination client address line 3 |
| 13 | Y | DClientCountry | VARCHAR(50) | N | Destination client Country |
| 14 | Y | DClientPhone | VARCHAR(50) | N | Destination client phone |
| 15 | Y | IDIClient | VARCHAR(50) | N | Invoice client ? |
| 16 | Y | IClientID | VARCHAR(50) | N | Invoice client ID |
| 17 | Y | IClientFirstName | VARCHAR(50) | N | Invoice client first name |
| 18 | Y | IClientLastName | VARCHAR(50) | N | Invoice client last name |
| 19 | Y | IClientCompany | VARCHAR(250) | N | Invoice client company |
| 20 | Y | IClientCompanyAddress | VARCHAR(250) | N | Invoice client company address |
| 21 | Y | IClientMail | VARCHAR(100) | N | Invoice client email |
| 22 | Y | IClientTown | VARCHAR(50) | N | Invoice client town |
| 23 | Y | IClientTownCode | VARCHAR(50) | N | Invoice client zip code |
| 24 | Y | IClientAddress | VARCHAR(200) | N | Invoice client address |
| 25 | Y | IClientAddress1 | VARCHAR(200) | N | Invoice client address line 2 |
| 26 | Y | IClientAddress2 | VARCHAR(200) | N | Invoice client address line 3 |
| 27 | Y | IClientCountry | VARCHAR(50) | N | Invoice client country |
| 28 | Y | IClientPhone | VARCHAR(50) | N | Invoice client phone |
| 29 | Y | Payment_type | VARCHAR(50) | N | Payment type |
| 30 | Y | Payment_price | VARCHAR(50) | N | Payment price |
| 31 | Y | Payment_price_additional | VARCHAR(50) | N | Payment price additional |
| 32 | Y | Payment_price_shipping | VARCHAR(50) | N | Payment price shipping |
| 33 | Y | Payment_price_total | VARCHAR(50) | N | Payment price total |
| 34 | Y | Payment_discount | VARCHAR(50) | N | Payment price discount |
| 35 | Y | Payment_discount_code | VARCHAR(50) | N | Payment price discount code |
| 36 | Y | Payment_currency | VARCHAR(50) | N | Payment currency |
| 37 | Y | PersonalMessage | VARCHAR(5000) | N | message |
| 38 | Y | PersonalMessageFrom | VARCHAR(100) | N | message from |
| 39 | Y | PersonalMessageTo | VARCHAR(100) | N | message from |
| 40 | Y | Gift_wrap | VARCHAR(50) | N | Gift wrap |
| 41 | Y | Customer_comment | VARCHAR(5000) | N | Customer comment |
| 42 | Y | shipping_method | VARCHAR(100) | N | Shipping method. |
| 43 | Y | Artcode | VARCHAR(50) | N | Article code |
| 44 | Y | ArticleDescription | VARCHAR(200) | N | Article Description |
| 45 | Y | ArticleEAN | VARCHAR(100) | N | Article barcode |
| 46 | Y | QTY | NUMERIC(0,18) | N | Quantity |
| 47 | Y | Row_Price | VARCHAR(50) | N | this row price |
| 48 | Y | Row_Gift_wrap | VARCHAR(50) | N | Order gift wrao |
| 49 | Y | RSystemDate | TIMESTAMP | N | Actual system date of import |
| 50 | Y | BatchID | VARCHAR(50) | N | Batch ID |
| 51 | Y | TrackingNumber | VARCHAR(50) | N | Tracking number |
| 52 | Y | OrderReference | VARCHAR(50) | N | Original order reference |
| 53 | Y | ID | NUMERIC(0,18) | N | Unique ID |
| 54 | Y | FileName | VARCHAR(250) | N | Filename with import. |
| 55 | Y | Customer | VARCHAR(50) | N | Customer |
| 56 | Y | CustomerID | VARCHAR(50) | N | Customer ID |
| 57 | Y | SubCustomer | VARCHAR(50) | N | Sub customer |
| 58 | Y | Carrier | VARCHAR(50) | N | Carrier |
| 59 | Y | Processed | VARCHAR(1) | N | Processed Y/N ? |
| 60 | Y | ProcessedDate | TIMESTAMP | N | Processed Date |
| 61 | Y | ProcessedSent | VARCHAR(1) | N | Processed Sent Y/N |
| 62 | Y | ProcessedSentDate | TIMESTAMP | N | Processed Sent date |