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 |
The Field Definition and data type for Order line table
Updated over 2 months ago