xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Requisition Line — entity reference
REFERENCE · Last reviewed

Requisition Line — entity reference

One requested item on a Requisition. The two fulfilment routes are counted separately — PurchaseOrderQuantity is rolled up from purchase order lines tagged with this line, StockTransferQuantity from transfer outward lines — and PendingQuantity is calculated as Quantity minus both, so a partly purchased and partly transferred line shows only the remainder. Amount is simply Quantity times UnitCost, with no discount or tax term, and rolls into Requisition.TotalAmount. RequestedQuantity is virtual: it is the per-line cap the Selective release actions accept, not a record of the original ask.

Fields

FieldLabelTypeRequiredWhat it does
AmountAmountCalculated (calculated)
ApplyPostTaxDiscountApply Post Tax DiscountBoolean
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
ExcludeInAutoOrderExclude In Auto OrderBooleanYesMarks the line so that automatic order generation should leave it out. It plays no part in the manual PerformReleaseOrder or PerformReleaseTransfer paths, which consider every line that still has pending quantity.
ExternalIdExternalText
IdIdGuidYes
ItemComponentIdItem ComponentLookup → ItemComponent
ItemIdItemLookup → Item
ItemLotTypeIdItem Lot TypeLookup → ItemLotType
ModifiedByIdModified ByLookup → UserAccountYes
NameDocument NumberTextYes
OwnerIdOwnerLookup → UserAccountYes
PackageRequisitionLineIdRequisition LineLookup → RequisitionLine
PendingQuantityPending QuantityCalculated (calculated)
PriceAsOnDatePrice As On DateDate
PriceListIdPrice ListLookup → PriceList
PriceListRuleIdPrice List RuleLookup → PriceListRule
PurchaseOrderQuantityPurchase Order QuantityNumberCumulative quantity of this line already released to purchase orders. The release action does not write it directly — it is rolled up from the purchase order lines tagged with this line's id — and it is netted against Quantity, alongside StockTransferQuantity, to give PendingQuantity.
PurchaseRequisitionLineNumberPurchaseRequisitionLineNumberNumberSequence number of the line within its requisition, carried for external and printed-document ordering. It is not a foreign key and not the line's identity.
QuantityQuantityNumberYes
RecordTypeIdRecord TypeGuid, hidden
RequestedQuantityRequested QuantityNumber
RequisitionIdRequisitionLookup → Requisition
SKUIdSKULookup → SKU
StockTransferQuantityStock Transfer QuantityNumber
Tax1Tax 1Currency
Tax1NameTax Name 1Text
Tax1RateTax Rate 1Currency
Tax1TypeTax Type 1Text
Tax2Tax 2Currency
Tax2NameTax Name 2Text
Tax2RateTax Rate 2Currency
Tax2TypeTax Type 2Text
Tax3Tax 3Currency
Tax3NameTax Name 3Text
Tax3RateTax Rate 3Currency
Tax3TypeTax Type 3Text
Tax4Tax 4Currency
Tax4NameTax Name 4Text
Tax4RateTax Rate 4Currency
Tax4TypeTax Type 4Text
Tax5Tax 5Currency
Tax5NameTax Name 5Text
Tax5RateTax Rate 5Currency
Tax5TypeTax Type 5Text
Tax6Tax 6Currency
Tax6NameTax Name 6Text
Tax6RateTax Rate 6Currency
Tax6TypeTax Type 6Text
TaxAmountTax AmountCurrency
TaxGroupIdTax GroupLookup → TaxGroup
UIPropsUI PropsText
UnitCostUnit CostCurrencyEstimated cost per unit for the requested item, and the only price term on the line. Amount is exactly Quantity times this value, with no discount or tax applied.
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete
EditEditEditEdit
EditEntityEditEditEditEntity
EditInLineEditEditInlineEdit In Line
HeaderEditHeader EditEditInlineedit
ImportImportUIActionImport
NewQuick AddNewInlineNew
ProductCatalogueProduct CatalogueUIActionProduct Catalogue

Validations

ValidationApplies toError messageNotes
Quantity Rule ValidationQuantity, ErrorQuantity should be greater than 0Prevents zero or negative quantity on requisition lines

Lookup filters

FilterLookup fieldNotes
Sku For ItemSKUIdSkuForItem