Skip to main content
All CollectionsSystem
Definition Order Line Field
Definition Order Line Field

The Field Definition and data type for Order line table

Updated over 3 months ago

Field Name

Description

Edit

Type

Actual Cost hrs

The actual hours cost used on this order line

Calculated

Number

Article category

The category under which the product or service falls.

Defined

Text

Article Group

The Product or Article group or category under which this item falls.

Defined

Text

Article no

The Article No identifier of the product or service.

Defined

Text

Article Note

Notes specific to the article in the order line.

Defined

Text

Code

A code related to the article, used for internal or external reference.

Editable

Text

Contribution

The amount of contribution or profit generated from this line item.

Defined

Number

Creator

The user or person who created the order line.

Defined

Text

Currency

The currency in which the transaction is recorded.

Defined

Text

Customer name

The name of the Customer

Defined

Text

Delivery date

The expected or scheduled date for delivery of the items.

Defined

Date

Department

The department responsible for fulfilling this order line.

Editable

Text

Description

A description or details of the product or service on this line.

Editable

Text

Discount %

The discount applied to this line item, if any.

Editable

Percent

Exchange rate

The exchange rate applied if the transaction is in a foreign currency.

Editable

Number

Finance Account

The financial account associated with the order or item for tracking purposes.

Editable

Text

GM%

Gross Margin percentage on this line item, showing profitability.

Calculated

Percent

GM% Article

The standard gross margin percentage expected for this Product or Article

Defined

Percent

GM% Historic

The historical gross margin percentage for tracking trends.

Calculated

Percent

Height

The height of the item, if applicable (typically for physical products).

Editable

Number

Hidden

If the line item is hidden from the view, possibly for internal purposes. This will hide this line on Reports.

Editable

True/False

Hrs earned

When you multiply Planned Hours by the percentage of Progress, you get the Earned Hours, which represents the amount of work that has been completed according to the plan, given the current progress.

Calculated

Number

Hrs plan earned

When you multiply Planned Hours by the percentage of Progress, you get the Earned Hours, which represents the amount of work that should have been completed according to the plan, given the current progress.

Calculated

Number

Hrs used

The total hours that have been used for this line item.

Calculated

Number

Length

The length of the item, if applicable (typically for physical products).

Editable

Number

Location

The physical or virtual location of the item, typically in a warehouse or storage area.

Editable

Text

Material

The material composition or type related to the item (if applicable).

Editable

Text

Net commission

The net commission earned on this item.

Calculated

Number

Net Invoiced

The net amount that has been invoiced, excluding taxes.

Calculated

Number

Net total

The net total for this item, excluding taxes.

Calculated

Number

Note

Any notes or comments added related to this order line.

Editable

Text

Note line

Line-specific notes for internal tracking.

Editable

Text

Order category

The category of the order to which this item belongs.

Defined

Text

Order category number

The number identifying the order category.

Defined

Text

Outstanding payment

The payment that is still outstanding for this item.

Calculated

Number

Picture path

The file path to a picture or image associated with the item.

Defined

Text

Plan Cost hrs

The hours cost planned used on this order line

Calculated

Number

Plan End date

The date when the task, order, or project associated with the item is expected to end.

Editable

Date

Plan Start date

The date when the task or order related to this item started.

Editable

Date

Planned progress %

The percentage of progress that was planned or scheduled for this line item.

Calculated

Percent

Planned start

The date the production for this item is expected to start.

Editable

Date

PN/SN

The part number (PN) or serial number (SN) associated with this item.

Editable

Text

Priority prod order

The priority level assigned to this production order.

Editable

Number

Product master

The master reference or template for this product.

Editable

True/False

Progress

The progress made on this line item, typically shown as a percentage.

Editable

Percent

Project

The project associated with this line item.

Editable

Text

Qty

The quantity of the item.

Editable

Number

Qty invoices

The quantity that has been invoiced so far.

Calculated

Number

Qty reported

The quantity reported, typically in terms of usage or production.

Calculated

Number

Shipped qty

The quantity that has been shipped so far.

Calculated

Number

Stock movement code

The stock keeping unit (SKU) or stock code for the item.

Editable

Number

Sum cost documents

The sum of all cost documents related to this item.

Calculated

Number

Supplier Art No

The supplier's article number for this item.

Defined

Text

Thickness

The thickness of the item, if applicable (typically for physical products).

Editable

Number

Time tracking open

Whether manual time tracking is open or available for this item.

Editable

True/False

Total Cost

The total cost associated with this order line.

Calculated

Number

Total currency

The total amount in the currency used for the transaction.

Calculated

Number

Total price

The total amount for this line item.

Calculated

Number

Unit

The unit of measurement for the quantity of this item (e.g., pcs, kg).

Editable

Text

Unit price

The price per unit for this item.

Editable

Number

Vat amount

The local VAT amount applicable.

Calculated

Number

Vat amount local

The VAT amount applicable to this line item.

Calculated

Number

Vat code

The VAT code or category used for this item.

Editable

Text

Width

The width of the product

Editable

Number

Did this answer your question?