NameDescriptionTypeAdditional 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