PurchReqLine Table

Article
2014-04-11

The PurchReqLine table contains purchase requisition lines.

Configuration Key: PurchReq

Methods

	Method	Description
	allowFieldEdit	Indicates whether the purchase requisition line field is editable.
	amountExclTax
	amountMST
	aosValidateDelete	Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
	aosValidateInsert	Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
	aosValidateRead	Validates on the server that the specified record can be read. (Inherited from xRecord.)
	aosValidateUpdate	Validates on the server that the specified record can be updated. (Inherited from xRecord.)
	buf2con	Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
	buildAssetRuleTmpAssetQualifierLookup	Builds a AssetRuleTmpAssetQualifierLookup record based on the policy for the current line.
	buyingLegalEntity2DataArea	Displays the dataAreaId field of the selected record.
	calcGrossAmount
	calcGrossAmountExclTax
	calcLineAmount
	calcLineAmountExclTax
	calcLineAmountForced
	calcLineDisc
	calcLineDiscExclTax
	calcPrice2LineAmount
	calcWorkflowExpiryDate	Calculates the expiry date of the workflow item that is assigned to the current user.
	canApplyAllocationOrDistributionTemplate	Indicates whether the use of an allocation or distribution template is applicable.
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	canConsolidate
	canCreatePurchaseOrder
	canEditDefaultMainAccount
	canEditDisc
	canGenerateRFQ	Determines whether request for quote can be generated for a purchase requisition.
	canRecordPreEncumbrance	Determines whether the pre encumbrance can be recorded for the purchase requisition line.
	canSubmit	Indicates whether the purchase requisition can be submitted to workflow.
	canSubmitToWorkflow	Indicates whether submission to workflow is possible. (Inherited from xRecord.)
	caption	Gets and sets the caption property of a table. (Inherited from xRecord.)
	categoryName	Display the category name of the selected category record.
	checkCFOP	Indicates whether CFOP is present and valid.
	checkCFPS_BR	Validates CFPS entered is of type Purch or Both
	checkCustomsTariffCode_IN	Checks if the tariff code of PurchReqLine is valid.
	checkDelete
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	checkMaximumRetailPrice_IN	Checks if maximum retail price is valid.
	checkRecord	Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
	checkRestrictedDeleteActions	Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
	checkSubmitOnBehalf	Indicates whether the current employee can submit on behalf of another employee.
	checkUpdate
	clear	Removes all rows from the table buffer. (Inherited from xRecord.)
	clearAddressReference
	company	Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
	con2buf	Unpacks a container into the table buffers. (Inherited from xRecord.)
	concurrencyModel	Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
	consolidationOpportunityId	Gets the ID of the consolidation opportunity of the selected PR line.
	consolidationTargetedEndDate	Gets the targeted end date of the selected PR line.
	consolidationVendorQuoteNumber	Gets the vendor quote number of the selected PR line.
	context	Gets and sets the context property. (Inherited from xRecord.)
	convertCurrencyCode
	copyBusinessJustification
	copyDimension	Returns a dimension set that can be applied to the defaultDimension field on this table.
	createCancelEventAndDistributions	Creates an accounting event that is used for reversing a budget fund reservation.
	createLine
	createMarkupTrans
	createSourceDocumentLine	Creates the associated SourceDocumentLine record.
	data	Retrieves a row from the table. (Inherited from xRecord.)
	dataSource	Retrieves the data source of the table. (Inherited from xRecord.)
	defaultAddress
	defaultAddressQuery
	defaultField	Populates default values in a field in the table. (Inherited from xRecord.)
	defaultRow	Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
	delete
	deleteSourceDocumentLine	Deletes the associated SourceDocumentLine record.
	deliveryAddress
	deliveryLocation	Returns the RecId value of the LogisticsLocation record that is associated with selected DeliveryPostalAddress record.
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	discAmount
	discPercent
	displayAddress_IN	Gets the address information for display.
	displayBudgetCheckResult	Gets the image position that displays the BudgetCheckResult value for the specified PurchReqLine record in the BudgetCheckResult values image list.
	displayConsolidationOpportunityId	Gets the purchase requisition consolidation opportunity ID.
	displayConsolidationStatus	Gets the purchase requisition consolidation opportunity status.
	displayDiscountAmount	Displays the total discount for the line.
	displayLineAmount	Displays the gross line amount, ((unit price * qty) + PurchMarkup), excludes discounts and taxes.
	displayMarkupTransAmount	Displays the miscellaneous charges for the line.
	displayProjBudgetCheckResult	Gets the image position that displays the ProjBudgetCheckResult value for the specified PurchReqLine record in the ProjBudgetCheckResult values image list.
	displaypurchAgreementHeaderstatus	Gets the purchase agreement status.
	displayPurchReqProcessingResult
	displayTaxAmount	Displays the tax amount for the line.
	displayTaxationOrigin_BR	This method is used to display the Taxation Origin.
	displayTaxFiscalClassification_BR	This method is used to display the Fiscal Classification Code.
	displayTotalAmount	Displays the total amount for the line.
	dispose	Releases resources that are used by the xRecord object. (Inherited from xRecord.)
	doClear	Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
	doDelete	Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
	doDistributionsExist	Determines whether any distributions exist for a line.
	doInsert	Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
	doUpdate	Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
	doValidateDelete	Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
	editItemName
	editPurchAgreementId	Gets the ID of the purchase agreement.
	editReasonCode	Gets and sets the reason code.
	equal	Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
	evaluatePurchAgreement	Evaluates the foreign key reference to the AgreementLine table.
	exciseManufacture_IN	Gets the correct value of ExciseManufacture_IN for given parameters.
	exciseNone_IN	Gets the correct value of ExciseNone_IN for given parameters.
	exciseTraders_IN	Gets the correct value of ExciseTraders_IN for given parameters.
	existFirmedLine	Determines whether there is any firmed order line relating to the requisition line.
	fieldAccessRight	Returns the field access right. (Inherited from xRecord.)
	fieldBufferAccessRight	Returns the field access right for the current record. (Inherited from xRecord.)
	fieldState	Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
	forInventory
	getAllowRedefault	Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
	getBudgetCheckResult	Calculates the BudgetCheckResult value for the specified PurchReqLine record.
	getConfirmReceiptText
	getDefaultingDependencies	Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
	getExtension	Returns the table extension. (Inherited from xRecord.)
	getFieldValue	Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
	getInstanceRelationType	Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
	getKmVirtualNetworkAnswerTable	Retrieves a record in the KmVirtualNetworkAnswerTable table if a questionnaire has been completed.
	getMaximumRetailPrice_IN	Gets maximum retail price for the given currency code.
	getMiscChargesAmount_IN	Gets misc charges amount.
	getOrderModifiedDate
	getOrderStatus
	getPhysicalTableName	Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
	getPresenceFieldData	Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
	getProjBudgetCheckResult	Calculates the ProjBudgetCheckResult value for the specified PurchReqLine record.
	getSQLStatement	Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
	getTableInInstanceHierarchy	(Inherited from xRecord.)
	getTableType	Indicates the type of the table. (Inherited from xRecord.)
	getTaxGroup	Gets the tax group that is associated with the line.
	getTimeOutTimerHandle	Returns the timer handle for the object. (Inherited from Object.)
	getUnitPrice
	handle	Retrieves the handle of the class of the object. (Inherited from Object.)
	hasIndirectTaxFieldChanged_IN	Determines whether a change to the PurchLine table buffer on india fields should update the associated SourceDocumentDistribution table.
	hasRelatedTable	Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
	helpField	Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
	inclTax
	initAssetGroup
	initCatalogItem	Initializes a new purchase requisition line with the item that is selected from the catalog.
	initDeliveryPostalAddress
	initFromAgreementLine	Initializes a PurchReqLine record from the AgreementLine record.
	initFromEcoResCategory
	initFromForecastSales
	initFromInventTable
	initFromPriceDisc
	initFromProjActivity
	initFromProjTable
	initFromPurchReqLine
	initFromPurchReqTable	Copies initial values from a purchase requisition header to a purchase requisition line.
	initFromPurchRFQLine
	initFromVendExternalItemDescription
	initFromVendTable
	initName
	initNonCatalogItem	Initializes a new purchase requisition line by using the selected non-catalog item.
	initTransDate	Applies a default value to the transaction date field.
	initValue	Initializes field values in a new PurchReqLine record.
	initVendAccount	Initializes the VendAccount field in a PurchReqLine record.
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert	Inserts the current record into the database.
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	internalCalendarId
	inventDim
	inventTable
	isCatalogItem	Determines whether the line type is a PurchReqLineType::Item value.
	isCategoryBased	Indicates whether the order line is category based.
	isConsumption	Checks if the purpose of the requisition line is RequisitionPurpose::Consumption.
	isDimensionLineEntityChanged	Indicates whether any of the line entities have changed.
	isFieldDataRetrieved	Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
	isFieldSet	Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
	isFormDataSource	Indicates whether the data source is a form. (Inherited from xRecord.)
	isFullyDistributed	Checks whether a line is fully distributed.
	isInferredDraft	Determines whether a record is in draft status.
	isNewRecord	Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
	isPartOfUOWSaveChanges	(Inherited from xRecord.)
	isPurchAgreementLineLinkValid	Evaluates the foreign key reference to AgreementLine table.
	isRFQPending	Indicates whether the request for quote is pending.
	isTempDb	Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
	isTmp	Indicates whether this is a temporary table. (Inherited from xRecord.)
	isVendAccountEnabled	Determines whether the VendAccount field is enabled for editing on forms.
	isVendorBlocked	Indicates whether the vendor is blocked.
	isVendorProposalEnabled	Indicates whether the vendor proposal functionality is enabled for editing on forms.
	isWorkflowOnPurchReqTable	Indicates whether the workflow is on the PurchReqTable record that corresponds to the current PurchReqLine record.
	itemLineDisc
	itemName
	joinChild	Finds the join child of the current record. (Inherited from xRecord.)
	joinParent	Finds the join parent of the current record. (Inherited from xRecord.)
	ledgerDimensionItemExtendParm_CN	Retrieves a ledger dimension from invent posting for an invent account type with site.
	lineDisc	Gets the line discount group that is associated with the vendor in the PurchReqLine record.
	lineNotPosted	Checks whether the line is not confirmed or completed.
	linkInventDim2Dimension	Applies default PurchLine.dimension values, depending on the InventDim record buffer values.
	linkPhysicalTableInstance	Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
	mcrDisplayUnitPricePBUOM	Displays the purchase price.
	merge	Merges the current table with the specified table. (Inherited from xRecord.)
	mergeDimension	Returns a dimension set that holds the merged combination of the current defaultDimension field on this table and the provided dimension set.
	modifiedField	Defines the reaction on a changed field value.
	modifiedFieldExecute
	modifiedFieldLineAmount	Resets the values of price fields in the PurchReqLine record.
	modifiedFieldValue
	modifiedFieldVendAccount	Reinitializes a field that is related to the vendor account in the PurchReqLine record.
	modifyInventDim	Occurs when a inventDim value has changed.
	modifyWMSLocation	Modifies a InventDim record with WMS values.
	moduleType
	new	Initializes a new instance of the Object class. (Inherited from Object.)
	notify	Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
	notifyAll	Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
	objectOnServer	Determines whether the object is on a server. (Inherited from Object.)
	onCFOPChange_BR	Gets executed when cfop is changed and sets the Item Sales Tax and Sales Tax groups
	onDeliveryPostalAddressChange_BR	Gets executed when the delivery postal address is changed and sets the CFOP lookup accordingly
	operatingUnit2DataArea	Display the name of the selected record.
	orderAccount
	orig	Retrieves the original values of the current record. (Inherited from xRecord.)
	overwriteSystemfields	Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
	owner	Returns the instance that owns the object. (Inherited from Object.)
	parmExchangeRateDate
	parmParentSourceDocumentLine
	parmSourceDocLineTypeEnumName
	parmSourceDocLineTypeEnumValue
	parmSourceDocumentHeader
	pdsCWUnitId	Gets the catch weight unit for the item.
	performBudgetCheck	Performs a budget check for the line.
	postCacheLoad	Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
	postLoad	Is executed after a record is read. (Inherited from xRecord.)
	preRemoting	Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.)
	priceDate	Retrieves the date for which to calculate the price according to the PriceDateType field.
	priceGroupId	Get a PriceGroupId value that corresponds to the vendor on the PurchReqLine record.
	procCategoryPolicyParameter	Retrieves the procCategoryPolicyParameter record that is associated with the PurchReqLine record.
	procurementCategory	Gets a record in the EcoResCategory table that corresponds to the ProcurementCategory field in a record in the PurchReqLine table.
	procurementCategoryCode	Gets the purchase requisition procurement category name.
	procurementCategoryFriendlyName	Gets the purchase requisition procurement category friendly name.
	promptAndConvertCurrencyCode
	psaEditActivityPurpose
	purchLine	Gets a record in the PurchLine table that is associated with the current PurchReqLine record.
	purchLineStatus
	purchReqId	Displays the purchase requisition ID of the selected record.
	purchReqName	Gets the purchase requisition name of the selected record.
	purchReqTable
	purchRFQCaseLine	Gets a record in the purchRFQCaseLine table that corresponds to the specified record in the PurchReqLine table.
	purchRFQStatus
	purchStatus
	purchTable
	queryTimedOut	Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
	queryTimeout	Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
	questionnaireAggregateStatus
	readCommittedLock	(Inherited from xRecord.)
	readPast	Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
	recordLevelSecurity	Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
	relatedTable	Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
	renamePrimaryKey	Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
	requiredAction	Gets the required action for the task that is assigned to the PurchReqLine record.
	requiredActionDueDate	Gets the due date for the required action on the PurchReqLine record.
	requisitionerName	Gets the requisitioner name for display.
	reread	Rereads the record from the table. (Inherited from xRecord.)
	resetCompanySpecificFields	Resets the field values if the value of a legal entity is changed.
	rfqCaseId
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	salesPurchTable
	selectedQualifierText	Gets the description of the selected qualifier.
	selectForUpdate	Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
	selectLocked	Indicates whether to select locked records. (Inherited from xRecord.)
	selectRefRecord	Selects the record by referenced field ID. (Inherited from xRecord.)
	selectWithRepeatableRead	Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
	setAddressFromInventDim	Sets the address on a line according to the specifics of the inventory dimension.
	setCFOP_BR	It is responsible for setting CFOP code
	setConnection	Sets the user connection for this table. (Inherited from xRecord.)
	setCrossPartition	Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
	setDataAreaForModifiedField	Sets the value of the DataArea field if a corresponding field value is modified.
	setDefaultCompany	Sets the default company corresponding to the buying legal entity of PurchReqLine record. Otherwise, sets the default company to the value specified by the _dataAreaId parameter.
	setDefaultDimension	Creates the default dimension by using the entity dimension specifiers from the line.
	setDeliveryName	Sets the delivery name field based on the specified logistic location.
	setFieldValue	Sets the field value in the record buffer. (Inherited from xRecord.)
	setInventDimId	Applies the InventDimId parameter to the PurchReqLine.inventDimId field and assigns default values that are based on the new inventory dimensions.
	setInventDimIdFromInventDim	Finds or creates an InventDimId value for the InventDim parameter and applies the found InventDimId to the PurchReqLine.inventDimId field.
	setLocation
	setPriceAgreement
	setPriceDisc
	setProjSalesPrice	Calculate and set the project sales price field.
	setSQLTracing	Enables or disables SQL tracing mode. (Inherited from xRecord.)
	setTaxGroup	Sets a value for the tax group and tax group data area fields.
	setTaxGroupAndTaxItemGroupFields_BR	Sets PurchReqLine.TaxGroup and PurchReqLine.TaxItemGroup based on TaxesMatrix
	setTaxInfoOfCompany_IN	Sets company tax information.
	setTimeOut	Sets up the scheduled execution of a specified method. (Inherited from Object.)
	setTmp	Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
	setTmpData	Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
	setTransDate
	setXDSContext	Sets new XDS context. (Inherited from xRecord.)
	shipToOption
	skipAosValidation	Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
	skipDatabaseLog	Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
	skipDataMethods	Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
	skipDeleteActions	Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
	skipDeleteMethod	Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
	skipEvents	Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
	skipPostLoad	Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
	skipTTSCheck	Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
	suppressWarnings	Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
	tableAccessRight	Returns the table access right. (Inherited from xRecord.)
	tableBufferAccessRight	Returns the table access right for the current record. (Inherited from xRecord.)
	takeOwnershipOfTempDBTable	(Inherited from xRecord.)
	taxDate
	taxPcsPrice
	templateName	Sets or gets the information about the AccountingDistributionTemplate record for creating distributions.
	toolTipField	Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
	toolTipRecord	Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
	toString	Returns a string that represents the current object. (Inherited from Object.)
	ttsabort	Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
	ttsbegin	Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
	ttscommit	Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
	unitOfMeasureSymbolById	Displays the unit symbol of the selected record.
	update	Ensures that the transaction date is valid before updating the record.
	updateAccountingDate	Updates the current accounting date of the source document line of a purchase requisition line.
	updateAssetGroup	Updates the asset group based on the policy.
	usageCount	Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
	useExistingTempDBTable	(Inherited from xRecord.)
	validateDelete	Determines whether the current record is valid and ready to be deleted from the database.
	validateField	Determines whether the _fieldIdToCheck field is valid.
	validateFieldValue
	validateVendAccount
	validateWrite	Determines whether the data is valid and ready to be written.
	validTimeStateUpdateMode	Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
	vendCategoryStatus	Gets the vendor category status from the current PurchReqLine record.
	vendInvoiceId
	vendInvoiceJour
	vendInvoiceStatus
	vendName	Provides the vendor name to display.
	vendStatus	Retrieves the vendor status for display.
	wait	Pauses a process. (Inherited from Object.)
	wasCached	Specifies the location from which the data was retrieved. (Inherited from xRecord.)
	write	Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
	xml	Retrieves an XML string that represents the current object. (Inherited from xRecord.)
	::addCatalogPolicyRuleToCatalogQuery	Adds catalog policy filtering to a query.
	::buildProductGroupIdCatagoryLookupQuery	Builds a query for the InventProductGroup table that only returns category product groups.
	::clearPurchLineRef
	::exist
	::existLine	Determines whether there is any line to copy for a purchase requisition.
	::existsStatus	Determins if a requisition line exists with a specific status for a requisition.
	::find
	::findBySourceDocumentLine	Finds the PurchReqLine record.
	::findCheapestVendor
	::findLine	Finds the specified record in the PurchReqLine table.
	::findLineRefId	Finds a specified record in the PurchReqLine table.
	::findPrimaryVendor
	::findVendors	Finds the default and cheapest vendor applicable for an item.
	::getAgreementLookupQuery	Gets a query object that is used to fetch applicable agreements to a record in the PurchReqLine table.
	::getCatalogPolicyRuleRecId	Gets the record ID of an applicable catalog rule.
	::getEditableDimensionAttributeSetId
	::getVendorLookupQuery
	::initCatalogItemServer	Initializes a new purchase requisition line with the item that is selected from the catalog.
	::initNonCatalogItemServer	Initializes a new purchase requisition line by using the selected non-catalog item.
	::lastLineNum
	::lastSequenceNumber
	::lookupAgreementLine	Generates a lookup for the agreement field.
	::lookupAgreementLineDataSet	Gets a lookup that displays records from the AgreementLine table.
	::lookupItemId	Sets and executes a query that pulls all records from the CatProcurementCatalogProductSiteAll table that filtered with catalog policy.
	::lookupRequester	Creates and displays a lookup from which the user can select a requester.
	::lookupVendAccount	Presents the user with a lookup that displays records from the VendTable table.
	::lookupvendAccountDataSet	Presents the user with a lookup that displays records from the VendTable table.
	::modifiedFieldServer	Defines the reaction on a changed field value.
	::modifyInventLocation
	::modifyPurchQty
	::showProcessingErrorInfoLog	Shows processing errors that are related to a PurchReqLine table.
	::vendSearchName2AccountNum	Gets the vendor account that matches the search name that is passed in to the method.

Top

Fields

Field	Type	Configuration key	Description
AccountingDistributionTemplate	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
ActivityNumber	Extended Data Type: ProjActivityNumber Type: String	ProjBasic	The activity number
ActivityNumberDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
AddressRefRecId	Extended Data Type: AddressRefRecId Type: Int64	None	Reference field in a different table
AddressRefTableId	Extended Data Type: AddressRefTableId Type: Integer	None	Table the transaction refers to.
AssetGroup	Extended Data Type: AssetGroupId Type: String	Asset	Select a fixed asset group
AssetGroupDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
AssetRuleQualifierOption	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
AssetRuleQualifierOptionLocal	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
Attention	Extended Data Type: PurchReqAttention Type: String	PurchReq	Attention information for the purchase requisition
BusinessJustification	Extended Data Type: BusinessJustificationRefRecId Type: Int64	None	Reference field in a different table
BuyingLegalEntity	Extended Data Type: RefRecId Type: Int64	None	The legal entity that is purchasing the products
CFOPTable_BR	Extended Data Type: RefRecId Type: Int64	None	CFOP code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CFPSTable_BR	Extended Data Type: RefRecId Type: Int64	None	CFPS code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CompanyLocation_IN	Extended Data Type: LogisticsLocationRecId Type: Int64	None	Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
createdBy	Extended Data Type: CreatedBy Type: String	None
createdDateTime	Extended Data Type: CreatedDateTime Type: UtcDateTime	None
CurrencyCode	Extended Data Type: CurrencyCode Type: String	None	Current currency code
CustomsTariffCodeTable_IN	Extended Data Type: RefRecId Type: Int64	None	Customs tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DefaultDimension	Extended Data Type: DimensionDefault Type: Int64	LedgerBasic	Default dimensions
DeliveryName	Extended Data Type: VendName Type: String	LedgerBasic	Name of vendor.
DeliveryPostalAddress	Extended Data Type: LogisticsPostalAddressRecId Type: Int64	None	Reference field in a different table
DSA_IN	Enumeration: NoYes	None	Update the Daily Stock Account (DSA)? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExciseRecordType_IN	Enumeration: ExciseRecordType_IN	None	Excise record type to update the excise amount to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExciseTariffCodes_IN	Extended Data Type: RefRecId Type: Int64	None	Excise tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExciseType_IN	Enumeration: ExciseType_IN	None	Excise-type category of the company. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExternalItemId	Extended Data Type: ExternalItemId Type: String	LogisticsBasic	Customer/vendor identification of the item.
GTAServiceCategory_IN	Enumeration: GTAServiceCategory_IN	None	The service category for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventDimId	Extended Data Type: InventDimId Type: String	None	Identification of dimensions for the item.
InventDimIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
InventLocationId	Extended Data Type: InventLocationId Type: String	LogisticsBasic	Identify the warehouse.
InventLocationIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
IsModified	Extended Data Type: VersioningIsModified Type: Enum	None	Has the current record been modified since previous version?
IsPreEncumbranceRequired	Enumeration: UnknownNoYes	None
IsPrepayment	Enumeration: NoYes	None	Is prepayment required for this purchase requisition line?
IsPurchaseOrderGenerationManual	Extended Data Type: NoYesId Type: Enum	None	Indicates whether purchase order is to be manually generated.
IsSaved	Extended Data Type: NoYesId Type: Enum	LedgerAdv2BudgetCtrl
ItemId	Extended Data Type: ItemIdSmall Type: String	LogisticsBasic	Identify item.
ItemIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
ItemIdNonCatalog	Extended Data Type: PurchReqItemIdNonCatalog Type: String	PurchReq	Identify item.
LineAmount	Extended Data Type: PurchLineAmount Type: Real	LogisticsBasic	Line amount after subtracting discounts
LineComplete	Extended Data Type: LineComplete Type: Enum	None	Deliver complete line?
LineDisc	Extended Data Type: PurchLineDisc Type: Real	PriceDisc	Line discount in amount per price unit.
LineNum	Extended Data Type: LineNum Type: Real	None	Identification of line.
LinePercent	Extended Data Type: PurchLinePercent Type: Real	PriceDisc	Line discount percentage.
LineRefId	Extended Data Type: PurchReqLineRefId Type: Guid	PurchReq	Unique identification of line
LineType	Enumeration: PurchReqLineType	PurchReq	The source of the purchase requisition line item
MaximumRetailPrice_IN	Extended Data Type: MaximumRetailPrice_IN Type: Real	None	Maximum retail price for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Name	Extended Data Type: ItemFreeTxt Type: String	LogisticsBasic	Standard item description.
NonRecoverablePercent_IN	Extended Data Type: Percent Type: Real	None	Enter the percentage of purchase amount not used to manufacture taxable items. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Partition	Extended Data Type: Partition Type: Int64	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PrePaymentDetails	Extended Data Type: PurchReqLinePrePaymentDetails Type: String	PurchReq	Enter details for the prepayment.
PriceDiscountTransfer	Enumeration: PurchReqPriceDiscountTransfer	PurchReq	The method used when transferring prices and discounts for catalog items from a purchase requisition to a purchase order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
PriceUnit	Extended Data Type: PriceUnit Type: Real	LogisticsBasic	Number of units the price is specified in.
ProcurementCategory	Extended Data Type: EcoResCategoryId Type: Int64	LogisticsBasic	Category identifier
ProjCategoryId	Extended Data Type: ProjCategoryId Type: String	ProjBasic	Category that is used as a default.
ProjCategoryIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
ProjId	Extended Data Type: ProjId Type: String	ProjBasic	Project identification
ProjIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
ProjLinePropertyId	Extended Data Type: ProjLinePropertyId Type: String	ProjBasic	Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost
ProjLinePropertyIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
ProjSalesCurrencyId	Extended Data Type: CurrencyCode Type: String	None	Currency in which the project is invoiced.
ProjSalesPrice	Extended Data Type: ProjSalesPriceCost Type: Real	ProjBasic	Sales price per unit calculated in the current sales currency.
ProjSalesUnitOfMeasure	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
ProjTaxGroupId	Extended Data Type: ProjTaxGroup Type: String	ProjBasic	Sales tax group project invoicing.
ProjTaxGroupIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
ProjTaxItemGroupId	Extended Data Type: ProjTaxItemGroup Type: String	ProjBasic	Item sales tax group project invoicing.
ProjTaxItemGroupIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
ProjTransId	Extended Data Type: ProjItemTransId Type: String	ProjBasic	Identification of transaction.
ProjTransIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
PurchAgreement	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
PurchId	Extended Data Type: PurchId Type: String	LogisticsBasic	Identification of the purchase.
PurchIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
PurchLineCreated	Extended Data Type: PurchReqPurchLineCreated Type: Enum	PurchReq
PurchMarkup	Extended Data Type: PurchMarkup Type: Real	LogisticsBasic	Fixed charges on price, applied once for each invoice
PurchPrice	Extended Data Type: PurchReqPrice Type: Real	PurchReq	Purchase price per price unit.
PurchQty	Extended Data Type: InventQty Type: Real	None	Quantity ordered in the inventory unit.
PurchReqConsolidationStatus	Enumeration: PurchReqConsolidationStatus	PurchReqConsolidation	Purchase requisition consolidation status
PurchReqTable	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
PurchRFQCaseId	Extended Data Type: PurchRFQCaseId Type: String	LogisticsBasic	Identification of the request for quotation case
PurchRFQCaseIdDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
PurchUnitOfMeasure	Extended Data Type: UnitOfMeasureRecId Type: Int64	None	Unit in which the item is purchased.
ReasonRefRecId	Extended Data Type: ReasonRefRecID Type: Int64	None	Contains stored financial reason codes and comments for entered or posted transactions or actions.
ReceivingOperatingUnit	Extended Data Type: RefRecId Type: Int64	None	The operating unit that is receiving the products
RecId	Extended Data Type: RecId Type: Int64	None
recVersion	Extended Data Type: RecVersion Type: Integer	None
RequiredDate	Extended Data Type: PurchReqRequiredDate Type: Date	PurchReq	The date the supplier is requested to deliver the products
Requisitioner	Extended Data Type: PurchReqRequesterRefRecId Type: Int64	None	The worker who requests the product
RequisitionPurpose	Enumeration: RequisitionPurpose	PurchReq	The purpose of the requisition (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RequisitionStatus	Enumeration: PurchReqRequisitionStatus	None	Purchase requisition line status
RFQRequirement	Extended Data Type: PurchReqRFQRequirementType Type: Enum	PurchReq	The request for quotation requirements for the purchase requisition line
SalesTaxFormTypes_IN	Extended Data Type: SalesTaxFormTypesRecId_IN Type: Int64	None	India sales tax form type for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SequenceNumber	Extended Data Type: SequenceNumber Type: Integer	None	Line position
ServiceCodeTable_IN	Extended Data Type: RefRecId Type: Int64	None	Service code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SourceDocumentLine	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
TaxGroup	Extended Data Type: TaxGroup Type: String	LedgerBasicSalesTax	A group of sales tax codes for calculating taxes on a sale or purchase
TaxGroupDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
TaxItemGroup	Extended Data Type: TaxItemGroup Type: String	LedgerBasicSalesTax	Group of sales tax codes that can be calculated for an item.
TaxItemGroupDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
TaxServiceCode_BR	Extended Data Type: TaxServiceCodeId_BR Type: String	None	Fiscal classification applied for services (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TransDate	Extended Data Type: PurchReqAccountingDate Type: Date	None	The date used to record the accounting entry in the general ledger and to validate budget funds available
URL	Extended Data Type: URL Type: String	None	WWW address for Internet homepage
VATGoodsType_IN	Enumeration: VATGoodsType_IN	None	VAT items type for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VendAccount	Extended Data Type: VendAccount Type: String	None	Vendor account number.
VendAccountDataArea	Extended Data Type: DataAreaId Type: String	None	ID for an area of data
VendorLocation_IN	Extended Data Type: LogisticsLocationRecId Type: Int64	None	Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VendQuoteNumber	Extended Data Type: VendQuoteNumber Type: String	None	Consolidation quotation number from aggregation

Top

Field Groups

Field Group	Fields
Other
PrePaymentDetails
Aggregation
Administrator
AllVar
Amount
AssetGroup
Attention
AutoIdentification
AutoReport
AutoSummary
CompanyInformation_IN
CompanyLocation_IN
CurrencyCode
BusinessJustification
Customs_IN
Dates
DeliveryAddress
DeliveryPostalAddress
DeliveryRef
Dimension
Discount
Excise_IN
FiscalInformation_BR
Identification
InternalInformation
Inventory
Item
AccountingDistributionTemplate
AddressDisplay
AddressLookup
AddressReference
Administration
NonCatalogItem
ItemDetails
MarkUP
PriceDiscountTransfer
Price
PriceBasis_IN
ProjectCostPrice
ProjectIdentification
ProcurementCategory
PurchaseQuantity
PurchaseReqLines
ProjectTransaction
PurchaseAgreement
ProjectSalesTax
ProjectSalesPrice
References
RequiredDate
RequisitionPurpose
PurchRFQCaseId
ReferenceStatus
Requisitioner
RFQType
SalesTax
Status
SequenceNumber
ServiceTax_IN
System
SalesTax_IN
ShipTo
SourceDocumentLine
URL
VAT_IN
UnitPrice
TableGroup
VendorInformation_IN
WorkflowPreview
Vendor
nonCatalogItemDetails
Organization

Top

Relations

Relation	Table	Lines
AccountingDistributionTemplate	AccountingDistributionTemplate
ActivityNumber	smmActivities
AssetGroup	AssetGroup
AssetRuleQualifierOption	AssetRuleQualifierOption
AssetRuleQualifierOptionLocal	AssetRuleQualifierOptionLocal
CFOPTable_BR	CFOPTable_BR
CFPSTable_BR	CFPSTable_BR
Common	Common
CompanyInfo	CompanyInfo
CompanyLocation_IN	LogisticsLocation
Currency	Currency
CurrencyCode	Currency
CustomsTariffCodeTable_IN	CustomsTariffCodeTable_IN
DefaultDimension	DimensionAttributeValueSet
DeliveryPostalAddress	LogisticsPostalAddress
EcoResCategory	EcoResCategory
ExciseTariffCodes_IN	ExciseTariffCodes_IN
InventDim	InventDim
InventLocation	InventLocation
InventTable	InventTable
OMOperatingUnit	OMOperatingUnit
Partition	Partitions
ProjCategory	ProjCategory
ProjItemTrans	ProjItemTrans
ProjLineProperty	ProjLineProperty
ProjSalesUnitOfMeasure	UnitOfMeasure
ProjTable	ProjTable
ProjTaxGroupHeading	TaxGroupHeading
ProjTaxItemGroupHeading	TaxItemGroupHeading
PurchaseAgreement	AgreementLine
PurchReqBusinessJustificationCodes	PurchReqBusinessJustificationCodes
PurchReqTable	PurchReqTable
PurchRFQCaseTable	PurchRFQCaseTable
PurchTable	PurchTable
PurchUnitOfMeasure	UnitOfMeasure
ReasonRef	ReasonTableRef
Requisitioner	HcmWorker
SalesTaxFormTypes_IN	SalesTaxFormTypes_IN
ServiceCodeTable_IN	ServiceCodeTable_IN
smmActivities	ProjActivity
SourceDocumentLine	SourceDocumentLine
TaxGroupHeading	TaxGroupHeading
TaxItemGroupHeading	TaxItemGroupHeading
TaxServiceCode_BR	TaxServiceCode_BR
VendorLocation_IN	LogisticsLocation
VendTable	VendTable

Top

Indexes

Index	AllowDuplicates	Enabled
CFOPTable_BRIdx	Yes	Yes
CFPSTable_BRIdx	Yes	Yes
LineIdx	Yes	Yes
LineRefIdIdx	No	Yes
LineStatusIdx	Yes	Yes
PlanningIdx	Yes	Yes
PositionIdx	No	Yes
RecId	No	Yes
SourceDocumentLineIdx	No	Yes

Top

Inheritance Hierarchy

xRecord Class
Common Table
PurchReqLine Table

Share via

PurchReqLine Table

Methods

Fields

Field Groups

Relations

Indexes

Inheritance Hierarchy

See Also

Additional resources