Data fields in orders

Danish version Top  Previous  Next

Orders and orderlines contains a lot of fields to accomodate many different ways of setting up the system for precisely your company's way of doing business

 

Please refer to the list below to understand the meaning of the fields:

 

English title

Danish title

Database field

Description

Product

Produkt

OrderDetail.ProductName

The name of the product. Normally taken directly from the price list.

Quantity

Kvantitet

OrderDetail.Quantity

Number or amount. Entered as a decimal number eg. 12 licenses or 23,4 tons of cement.

Account

Konto

OrderDetail.Account

Account name. Must be chosen among the sales accounts. Normally taken directly from the price list.

Owner

Ejer

OrderDetail.Owner

The user who is responsible for the orderline/forecast.

Period

Periode

OrderDetail.PeriodId

Month as taken from the business calendar in the system. For a given oprder you may have order lines with different period, in cases of phased delivery.

Value

Værdi

OrderDetail.Value

The value of the order line in standard currency. The customer sees it as the price. The value is is affected by both quantity and discount: Value = Quantity * Unit Price * (1-Discount)

Weight

Vægt

OrderDetail.Weight

The weighting factor that is used as long as the order line is not yet completed.

The weighting factor is determined by whether the order belongs to a project or not.
1. Project: Automatic depending on project scores checked.

2. Company: Manually entered.

Weighted Value

Vægtet værdi

Beregnet felt

Computed as Weight * Value

Value1..4

Værdi1..4

OrderDetail.Value1..4

Fields to be used for any economic information of your choice. The values will be scaled by quantity but not influenced by discount

ListValue

Listepris

OrderDetail.ListValue

The value of the orderline before discount. Protected

Discount

Rabat

OrderDetail.Discount

Discount. Shown as a percentage (but saved as a factor). If a value is entered value is calculated. If a value is entered the discount is calculated.

DiscUnitValue

DiscUnitValue

OrderDetail.DiscUnitValue

Unit price after discount. Protected

Status

Status

OrderDetail.Status

Textfield. Can be used to register a status when interfacing with other systems.

Completed

Afsluttet

OrderDetail.Completed

Completed (when not Lost) means that the order line has been approved and sold. Weighting is then 100%

Lost

Tabt

OrderDetail.Lost

Lost means that the orderline was not sold. Weighting is hen 0%

By choosing lost you do not have to delete the order line and you avoid loosing valuable information. Also for sales where the customer accepts only parts of a proposal it is usefull to have won/lost
 

 


Page url: http://www.channelcrmhelp.com/index.html?net_felter_i_ordrer_og_ordrelinier.htm