Amount | Amount | Calculated (calculated) | | The line value: quantity times unit cost plus the line's tax amount. Rolls up into the requisition's Total Amount. |
ApplyPostTaxDiscount | Apply Post Tax Discount | Boolean | | Not used on requisition lines: they carry no discounts, so tax is always worked out on quantity times unit cost. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
ExcludeInAutoOrder | Exclude In Auto Order | Boolean | Yes | Leaves the line out of the auto-order calculations that count open requisitions. It has no effect on the release actions. |
ExternalId | External | Text | | An identifier from another system, for imports and integrations. Not shown on the shipped forms. |
Id | Id | Guid | Yes | |
ItemComponentId | Item Component | Lookup → ItemComponent | | The package component this line represents. Filled automatically and carried to the purchase order line on release. |
ItemId | Item | Lookup → Item | | The requested item. Required. Inactive items, discontinued items and Discounted Items are refused when the line is added. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot type of the requested item, for reference. Shown on the line's record page only, and not copied to the purchase order or transfer line on release. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | Yes | The line's number, generated on save from the Requisition Line Name Setting (series RL, the document date and a six-digit counter). |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PackageRequisitionLineId | Requisition Line | Lookup → RequisitionLine | | The package line this component line belongs to. Filled automatically when a package item is added; deleting the package line deletes its component lines. |
PendingQuantity | Pending Quantity | Calculated (calculated) | | Quantity minus Purchase Order Quantity minus Stock Transfer Quantity: what a release can still take. Recalculated whenever the line is saved. |
PriceAsOnDate | Price As On Date | Date | | The date the line's price is taken from; the requisition's price date or document date when empty. Not on the shipped forms. Changing it reprices the line. |
PriceListId | Price List | Lookup → PriceList | | The price list used for this line; the requisition's price list when empty. Not on the shipped forms. Changing it reprices the line. |
PriceListRuleId | Price List Rule | Lookup → PriceListRule | | A reference to a price list rule. Automatic pricing does not fill it, and it is not on the shipped forms; changing it makes xMatix work out the line's price again from the price list. |
PurchaseOrderQuantity | Purchase Order Quantity | Number | | The total Quantity of the purchase order lines released from this line. Maintained by the system when those lines are added, changed or deleted. A Cancelled Quantity on the purchase order line is not subtracted, so cancelling does not make the quantity pending again. |
PurchaseRequisitionLineNumber | PurchaseRequisitionLineNumber | Number | | Sequence number of the line within its requisition. |
Quantity | Quantity | Number | Yes | How much is requested. Must be greater than zero, and cannot be lowered below the quantity already on purchase orders. On a package component line it must also stay within the component's minimum and maximum, and cannot change when the component's quantity is not editable. |
RecordTypeId | Record Type | Guid, hidden | | |
RequestedQuantity | Requested Quantity | Number | | The quantity entered for this line in a selective release dialog. Must be greater than zero and no more than Pending Quantity. Not stored, so it always reads zero on the line's record page. |
RequisitionId | Requisition | Lookup → Requisition | | The requisition this line belongs to. Set when the line is added from the requisition's Lines tab. |
SKUId | SKU | Lookup → SKU | | The item variant. Required when the item requires a SKU; limited to the item's SKUs, and a SKU of another item is refused. |
StockTransferQuantity | Stock Transfer Quantity | Number | | The total Quantity of the outward transfer lines released from this line. Maintained by the system when those lines are added, changed or deleted. |
Tax1 | Tax 1 | Currency | | The amount of the first tax component on the line, filled by the tax calculation from the line's tax group. |
Tax1Name | Tax Name 1 | Text | | The name of the first tax component, copied from the tax. |
Tax1Rate | Tax Rate 1 | Currency | | The rate of the first tax component, copied from the tax. |
Tax1Type | Tax Type 1 | Text | | The type of the first tax component, copied from the tax. |
Tax2 | Tax 2 | Currency | | The amount of the second tax component on the line, filled by the tax calculation from the line's tax group. |
Tax2Name | Tax Name 2 | Text | | The name of the second tax component, copied from the tax. |
Tax2Rate | Tax Rate 2 | Currency | | The rate of the second tax component, copied from the tax. |
Tax2Type | Tax Type 2 | Text | | The type of the second tax component, copied from the tax. |
Tax3 | Tax 3 | Currency | | The amount of the third tax component on the line, filled by the tax calculation from the line's tax group. |
Tax3Name | Tax Name 3 | Text | | The name of the third tax component, copied from the tax. |
Tax3Rate | Tax Rate 3 | Currency | | The rate of the third tax component, copied from the tax. |
Tax3Type | Tax Type 3 | Text | | The type of the third tax component, copied from the tax. |
Tax4 | Tax 4 | Currency | | The amount of the fourth tax component on the line, filled by the tax calculation from the line's tax group. |
Tax4Name | Tax Name 4 | Text | | The name of the fourth tax component, copied from the tax. |
Tax4Rate | Tax Rate 4 | Currency | | The rate of the fourth tax component, copied from the tax. |
Tax4Type | Tax Type 4 | Text | | The type of the fourth tax component, copied from the tax. |
Tax5 | Tax 5 | Currency | | The amount of the fifth tax component on the line, filled by the tax calculation from the line's tax group. |
Tax5Name | Tax Name 5 | Text | | The name of the fifth tax component, copied from the tax. |
Tax5Rate | Tax Rate 5 | Currency | | The rate of the fifth tax component, copied from the tax. |
Tax5Type | Tax Type 5 | Text | | The type of the fifth tax component, copied from the tax. |
Tax6 | Tax 6 | Currency | | The amount of the sixth tax component on the line, filled by the tax calculation from the line's tax group. |
Tax6Name | Tax Name 6 | Text | | The name of the sixth tax component, copied from the tax. |
Tax6Rate | Tax Rate 6 | Currency | | The rate of the sixth tax component, copied from the tax. |
Tax6Type | Tax Type 6 | Text | | The type of the sixth tax component, copied from the tax. |
TaxAmount | Tax Amount | Currency | | The line's tax, recalculated when the item, SKU, quantity, amount or tax group changes. Each tax in the group is quantity times unit cost times its rate. |
TaxGroupId | Tax Group | Lookup → TaxGroup | | The line's taxes, chosen from the tax group rules when the line is added. Not copied on release; the purchase order line works out its own taxes. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The expected price per unit. On a new line the purchase price list price is filled in unless a cost was typed; picking a different item on the add form reprices the line, or clears the cost to zero when the new item has no price. Copied to the purchase order or transfer line on release. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
