| Name | Description | Type | Additional information |
|---|---|---|---|
| SalesOrderReference |
The unique reference for this sales order. |
string |
Required Max length: 8 |
| SalesOrderDate |
The date when the order was placed by the client. |
date |
Required |
| DeliveryDate |
The date when the order is expected to be delivered to the client. |
date |
Required |
| ClientCode |
The code of the client placing the order. The client must already exist in the SIMS database. |
string |
Required Max length: 6 |
| CurrencyCode |
The transaction's currency code. The default is the SIMS company's base currency which is usually "EUR". |
string |
Required Max length: 3 |
| ExchangeRate |
The transaction's exchange rate. The default is 1. |
decimal number |
Required |
| TotalValue |
The total sales order value. |
decimal number |
N/A |
| TotalVat |
The total VAT for this sales order. |
decimal number |
N/A |
| DiscountRate |
The default discount rate used in this sales order's lines. |
decimal number |
N/A |
| DiscountAmount |
The sales order's total discount amount. |
decimal number |
N/A |
| PettyDiscount |
The petty discount amount given. |
decimal number |
N/A |
| Address1 |
The client's address line 1. |
string |
Max length: 35 |
| Address2 |
The client's address line 2. |
string |
Max length: 35 |
| Address3 |
The client's address line 3. |
string |
Max length: 35 |
| Address4 |
The client's address line 4. |
string |
Max length: 35 |
| Address5 |
The client's address line 5. |
string |
Max length: 35 |
| InternalReference |
Any internal reference. |
string |
Max length: 10 |
| ClientReference |
Any external reference used to refer to this sales order (e.g. quotation number, etc) |
string |
Max length: 10 |
| PaymentTerms |
The terms dictating how payments should be affected (e.g. Cash, 30 days credit, etc) |
string |
Max length: 45 |
| Remarks |
Any remarks related to this sales order. |
string |
Max length: 254 |
| SalesmanCode |
The code of the salesman who placed this order, if applicable. This code must already exist in the SIMS database. |
string |
Required Max length: 4 |
| Deposit |
The deposit amount paid by the client. |
decimal number |
N/A |
| Contact |
The contact person's name. |
string |
N/A |
| DeliveryInstructions |
The delivery instructions for this order (free text). |
string |
N/A |
| CreatedBy |
The ID of the user who created this order. This is usually set to "WEB" when the order is placed from a website. |
string |
Required Max length: 3 |
| Created |
The date when the sales order was created. |
date |
Required |
| AmendedBy |
The ID of the user who last amended this order. This is usually set to "WEB" when the order is placed from a website. |
string |
Required Max length: 3 |
| Amended |
The date when the sales order was last amended. |
date |
Required |
| DeliveryType |
The delivery type of this sales order, used to group deliveries, such as frozen and not frozen goods. |
string |
Max length: 2 |
| MediaType |
The Media Type of the sales order. |
string |
Max length: 10 |