Amount | Amount | Calculated (calculated) | | Calculated taxable value of the line: Base Amount less Net Scheme Discount and Net Discount. When the partner account takes discounts after tax, discounts are not deducted here but from Gross Amount. The order's Total Line Amount is the sum of this field. |
ApplyPostTaxDiscount | Apply Post Tax Discount | Boolean | Yes | Whether the line's discounts are taken after tax. Copied from the order's partner account when the line's taxes are calculated; not entered on the line. |
AutoPurchaseOrderLineId | Auto Purchase Order Line | Lookup → AutoPurchaseOrderLine | | The auto order suggestion line this order line was generated from. Its quantity counts against that suggestion, so a partly accepted suggestion shows what is still pending. |
BaseAmount | Base Amount | Calculated (calculated) | | Calculated: Quantity times Unit Cost 2 when that is greater than zero, otherwise Quantity times Unit Cost. The line value before discounts and tax. |
BenefitIndex | Benefit Index | Number | | Set by the scheme engine to group benefit lines; cleared when schemes are re-applied. |
BranchId | Branch | Calculated (calculated) | | Calculated text copy of the order's branch, for filtering and grouping lines. Not a link to the branch. |
CancelledQuantity | Cancelled Quantity | Decimal | | Quantity you no longer expect from the supplier. It reduces Pending Quantity, Pending Invoice Quantity, the most that may be received against the line and the taxable value, but not Base Amount. Not on the shipped line forms: an administrator adds it to the line's record layout so that users can enter it. |
ContractDiscount | Contract Discount | Percent | | Contract discount percentage, filled from the order's discount group when the line is added (not on description-only lines). Part of Net Discount. |
ContractDiscountAmount | Contract Discount Amount | Currency | | A fixed contract discount amount, filled from the discount group when it defines an amount instead of a percentage. When greater than zero it replaces Contract Discount in Net Discount. |
ConversionRatio | Conversion Ratio | Number | | Conversion ratio from the first unit of measure to the item's base unit. |
ConversionRatio1 | Conversion Ratio 1 | Number | | Conversion ratio from the second unit of measure to the item's base unit. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Discount | Discount | Percent | | Trade discount percentage (0 to 100). Ignored when Discount Amount is greater than zero. Part of Net Discount. |
Discount2 | Cash Discount | Percent | | Cash discount percentage (0 to 100). Ignored when Cash Discount Amount is greater than zero. Part of Net Discount. |
DiscountAmount | Discount Amount | Currency | | A fixed trade discount amount. When greater than zero it replaces the Discount percentage in Net Discount. |
DiscountAmount2 | Cash Discount Amount | Currency | | A fixed cash discount amount. When greater than zero it replaces the Cash Discount percentage in Net Discount. |
ExcludeInAutoOrder | Exclude In Auto Order | Boolean | Yes | Leaves the line's pending quantity out of the inbound supply used by auto order and replenishment projections. |
ExternalId | External | Text, unique | | |
GrossAmount | Gross Amount | Calculated (calculated) | | Calculated all-in value of the line: Amount plus Tax Amount, less the discounts when they are taken after tax. Shown as the total of the line's Amounts panel. |
Id | Id | Guid | Yes | |
InventoryFulfilmentOrderLineId | Inventory Fulfillment Order Line | Lookup → InventoryFulfilmentOrderLine | | The fulfilment order line this purchase is meant to cover, set by the back order flow through auto order. The line's quantity counts as back-ordered against it. |
InventoryStockId | Stock | Lookup → InventoryStock | | The stock row (item, SKU, branch and storage location) matched to the line when it is added. The order itself never changes stock; goods receipts do. |
InvoiceQuantity | Invoice Quantity | Number | | How much of the line has been billed: the sum of the quantity on the bill lines linked to it. Maintained by the system. |
IsSchemeGenerated | Is Scheme Generated | Boolean | Yes | Set on a line the scheme engine added as a scheme benefit. Such lines are removed and rebuilt whenever schemes are re-applied or reset. |
ItemAliasId | Item Alias | Lookup → ItemAlias | | The item alias picked on the shipped create form, which the Lines tab does not use. |
ItemAlternateId | Item Alternate | Lookup → ItemAlternate | | The item alternate applied when the line was added; alternates are applied before pricing and taxes. |
ItemComponentId | Item Component | Lookup → ItemComponent | | On a component line, the package component it represents. Its minimum, maximum and mandatory settings limit the quantity you may enter, and a mandatory component cannot be removed. |
ItemId | Item | Lookup → Item | | The item being bought. Optional when the line carries a Description instead, for a charge such as freight; a line needs one or the other. Only active items can be picked; discontinued items and discount items are refused. Locked when the line came from a requisition line, and once returns exist against it. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | Shown on the shipped line forms but not stored on purchase order lines: a value entered here is not saved. |
ItemName | ItemName | Text | | Not shown on the shipped line forms. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | The line number, generated on save from document numbering (shipped series PL, the date as DDMMYYYY and a six-digit counter). |
NetDiscount | Net Discount | Calculated (calculated) | | Calculated: the trade, cash and contract discounts added together, each taken as its amount when one is set and otherwise as its percentage of the line value. The order's Total Discount Amount is the sum of this field. |
NetSchemeDiscount | Net Scheme Discount | Calculated (calculated) | | Calculated: Scheme Discount Amount when set, otherwise Base Amount times the Scheme Discount percentage. The order's Total Scheme Discount Amount is the sum of this field. |
OrderQuantity | Order Quantity | Number | | How much of the line has been sent to an on-platform supplier as a dealer order: the sum of the quantity on the sale order lines created from it. Not the ordered quantity, which is Quantity. |
OriginalItemId | Original Item | Lookup → Item | | The item originally asked for when the line was substituted with an alternate item. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PackagePurchaseOrderLineId | Purchase Order Line | Lookup → PurchaseOrderLine | | On a component line, the package line it was added under. Adding a package item adds its purchase components as their own lines; deleting the package line removes them. Component lines are received and billed in their own right. |
PartnerAccountId | Partner Account | Calculated | | Text field, not a link to an account. Read the partner account from the purchase order. |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | Calculated: Quantity minus Invoice Quantity minus Cancelled Quantity. What is still to be billed; the invoice releases draw on it. |
PendingOrderQuantity | Pending Order Quantity | Calculated (calculated) | | Calculated: Quantity minus Order Quantity. What is still to be sent as a dealer order. |
PendingQuantity | Pending Quantity | Calculated (calculated) | | Calculated: Quantity minus Receipt Quantity minus Cancelled Quantity. What is still to be released for receipt; shipment and receipt releases draw on it. The order's Total Pending Quantity is the sum of this field. |
PriceAsOnDate | Price As On Date | Date | | The date this line is priced on. Empty means the header's Price As On Date, then the order's Document Date, then today. Changing it re-prices the line. |
PriceListId | Price List | Lookup → PriceList | | The price list for this line. Empty means the order's price list, then the default purchase price list. Changing it on the line re-prices the line. |
PriceListRuleId | Price List Rule | Lookup → PriceListRule | | A price list rule to price this line from. Changing it re-prices the line. It is not filled in automatically when the line is priced. |
PurchaseOrderId | Purchase Order | Lookup → PurchaseOrder | | The purchase order the line belongs to. Required, and cannot be changed once the line is saved. |
PurchaseOrderLineNumber | PurchaseOrderLineNumber | Number | | Not shown on the shipped forms and not filled in by the system. |
PurchaseRequisitionId | Purchase Requisition | Lookup → Requisition | | The requisition the line was created from, by Add Requisition, Selective Requisition Lines or a release on the requisition. Filled automatically. |
Quantity | Quantity | Number | Yes | The quantity ordered. Must be greater than zero. When the item has planning attributes it must respect the minimum and maximum order quantity and be a multiple of the lot quantity. It cannot be lowered below the quantity already received plus returned. On a package line, changing it rescales the component lines. |
ReceiptQuantity | Receipt Quantity | Number | | How much of the line has been released to goods receipts: the sum of the ordered quantity on the goods receipt lines linked to it. It counts what was released for receipt, not what was physically counted in. Maintained by the system. |
RecordTypeId | Record Type | Guid, hidden | | |
RequestedQuantity | Requested Quantity | Number | | Not stored. The quantity you type for a line in a selective release dialog (receipt, invoice, shipment or dealer order); it must be greater than zero and no more than the line's pending quantity for that release. |
RequisitionLineId | Requisition Line | Lookup → RequisitionLine | | The requisition line this order line was created from. Its quantity counts against that requisition line so it is not ordered twice. While it is set, the line's Item and SKU cannot be changed. |
ReturnedQuantity | Returned Quantity | Number | | Quantity returned to the supplier on bill returns against this line. Maintained by the system and not editable. Once it is greater than zero, the line's Item and SKU are locked. |
SchemeBenefitId | Scheme Benefit | Lookup → SchemeBenfit | | The scheme benefit that produced this line, on scheme-generated lines. |
SchemeDiscount | Scheme Discount | Percent | | Scheme discount percentage, written by the scheme engine when a supplier scheme applies. Cleared when schemes are re-applied or reset. |
SchemeDiscount1 | Scheme Discount | Percent | | Shown on the shipped create form but not stored on purchase order lines: a value entered here is not saved. Use Scheme Discount. |
SchemeDiscountAmount | Scheme Discount Amount | Currency | | A fixed scheme discount amount, written by the scheme engine. When greater than zero it replaces the Scheme Discount percentage. |
SchemeLineId | Scheme Line | Lookup → SchemeLine | | The scheme line that discounted or produced this line. Set by the scheme engine. |
SchemeRewardPoints | Scheme Reward Points | Number | | |
ServiceOrderLineId | Service Order Line | Lookup → ServiceOrderLine | | The service order line the part was ordered for (VOR ordering). The line's quantity counts as allocated against that service order line. |
SkipScheme | Skip Scheme | Boolean | Yes | Leaves this line out of scheme evaluation. Changing it re-runs schemes on the order. |
SKUId | SKU | Lookup → SKU | | The item variant. Required when the item requires a SKU, and limited to the item's SKUs. Locked under the same conditions as Item. Changing it re-prices and re-taxes the line. |
Tax1 | Tax 1 | Currency | | Amount of the tax in the line's tax group whose posting field is Tax 1. Tax Name 1, Tax Rate 1 and Tax Type 1 describe that tax. The six tax slots are a copy taken when the line is saved, so later rate changes do not alter saved lines. |
Tax1Name | Tax Name 1 | Text | | |
Tax1Rate | Tax Rate 1 | Currency | | |
Tax1Type | Tax Type 1 | Text | | |
Tax2 | Tax 2 | Currency | | Amount of the tax whose posting field is Tax 2, described by Tax Name 2, Tax Rate 2 and Tax Type 2. |
Tax2Name | Tax Name 2 | Text | | |
Tax2Rate | Tax Rate 2 | Currency | | |
Tax2Type | Tax Type 2 | Text | | |
Tax3 | Tax 3 | Currency | | Amount of the tax whose posting field is Tax 3, described by Tax Name 3, Tax Rate 3 and Tax Type 3. |
Tax3Name | Tax Name 3 | Text | | |
Tax3Rate | Tax Rate 3 | Currency | | |
Tax3Type | Tax Type 3 | Text | | |
Tax4 | Tax 4 | Currency | | Amount of the tax whose posting field is Tax 4, described by Tax Name 4, Tax Rate 4 and Tax Type 4. |
Tax4Name | Tax Name 4 | Text | | |
Tax4Rate | Tax Rate 4 | Currency | | |
Tax4Type | Tax Type 4 | Text | | |
Tax5 | Tax 5 | Currency | | Amount of the tax whose posting field is Tax 5, described by Tax Name 5, Tax Rate 5 and Tax Type 5. |
Tax5Name | Tax Name 5 | Text | | |
Tax5Rate | Tax Rate 5 | Currency | | |
Tax5Type | Tax Type 5 | Text | | |
Tax6 | Tax 6 | Currency | | Amount of the tax whose posting field is Tax 6, described by Tax Name 6, Tax Rate 6 and Tax Type 6. |
Tax6Name | Tax Name 6 | Text | | |
Tax6Rate | Tax Rate 6 | Currency | | |
Tax6Type | Tax Type 6 | Text | | |
TaxAmount | Tax Amount | Currency | | The line's total tax, calculated from the taxes in its tax group on the taxable value (net of discounts and of any cancelled quantity). Re-calculated when the item, SKU, quantity, amount or tax group changes. |
TaxGroupId | Tax Group | Lookup → TaxGroup | | The line's tax group. Filled from the tax group rules (partner, branch, item, SKU and item group) when the line is added, or picked by you. Changing it re-calculates the line's taxes. Discount items get no tax group. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The buy price per unit. Taken from the purchase price list rule in force on the pricing date when the line is added, unless you type one. Re-resolved when the line's price list, price list rule or price date changes, or when the header Price As On Date changes. Copied to shipment and goods receipt lines on release. |
UnitCost2 | Unit Cost 2 | Currency | | A second price taken from the price list rule's second price. When it is greater than zero it is used instead of Unit Cost to calculate Base Amount. |
UOM | UOM | PickList | | Unit of measure the quantity was entered in. With UOM Quantity and Conversion Ratio, Quantity is derived from it and rounded to the item's precision. |
UOM1 | UOM 1 | PickList | | Second unit of measure. Values: Each, kWh. |
UOMQuantity | UOM Quantity | Number | | Quantity entered in the first unit of measure; converted into Quantity with Conversion Ratio. |
UOMQuantity1 | UOM Quantity1 | Number | | Quantity entered in the second unit of measure. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
