PurchLine Table

The PurchLine table contains all purchase order lines regardless whether they have been posted or not.

Configuration Key: LogisticsBasic

Methods

	Method	Description
	accountItemExtendParm_CN	Retrieves a posting account for the purchase order line with site.
	accountReceipt	Change which account is returened when getting the ledger account so that all the fixed asset transactions will use PurchReceiptFA account instead of the PurchReceipt account.
	agreementSkipAutoLink	Check whether this line should skip automatic AgreementLine matching
	allowEditReturnActionId
	allowEditScrap
	allowEditStockedProduct	Determines whether the StockedProduct field can be changed.
	allowEditTax1099
	allowInventProfileIdChange_RU	Determines if InventProfileId_RU inventory dimension could be changed
	allowPostingProfileChange_RU	Determines if PostingProfile_RU field value could be changed
	allowUpdateWithQualityOrder	Specifies whether the update of the purchase line is enabled, even if an open quality order exists.
	amountCur
	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.)
	arrived
	arrivedInPurchUnit
	assessableValue_IN	This method is used get the assessable value.
	assetLedgerDimension	Changes the account that is returned when getting the ledger dimension so that all fixed asset transactions will use the PurchRecieptFA account instead of the PurchConsump account.
	assetUpdateInventTrans
	associateWithAgreementLine	Associates the purchase line with the agreement line.
	buf2con	Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
	calcGrossAmount
	calcGrossAmountExclTax
	calcLineAmount
	calcLineAmountExclTax
	calcLineAmountForced
	calcLineAmountForcedInteraction	Calculates the line amount with user interaction if associated link to agreement line becomes invalid.
	calcLineAmountInclTax_RU
	calcLineAmountInteraction	Calculates the line amount with user interaction if associated link to agreement line becomes invalid.
	calcLineDisc
	calcLineDiscExclTax
	calcLineDiscUnit
	calcPendingLineAmounts	Calculates a sum of the LineAmount values that are in transaction and company currency for all pending invoice lines that are connected to this record in the PurchLine table.
	calcPendingMatchedQtyInvent	Calculates a sum of the InventNow quantities for invoice lines that are connected to this record in the PurchLine table that are matched to a packing slip.
	calcPendingMatchedQtyPurch	Calculates the sum of the ReceiveNow quantity for invoice lines that are connected to this PurchLine table record, which are matched to a packing slip.
	calcPendingQtyInvent	Calculates a sum of the InventNow quantities for all pending invoice lines that are connected to this record in the PurchLine table.
	calcPendingQtyPurch	Calculates a sum of the ReceiveNow quantities for all pending invoice lines that are connected to this record in the PurchLine table.
	calcPendingQtyPurchDisplay	Retrieves the sum of the ReceiveNow quantities for all pending invoice lines that are connected to this record in the PurchLine table.
	calcPrice2LineAmount
	calcPriceFromAmount
	calcProjSalesPriceIfDefault
	calcQtyOrdered
	canAgreementBeLinked	Determines whether the purchase line can be linked to an agreement line.
	canApplyAllocationOrDistributionTemplate	Indicates whether to use an allocation or distribution template to create the distributions of the transaction line.
	canAutoUpdatePurchLine	Indicates whether the table buffer is restricted by the change management functionality.
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	canEditDisc
	canEditLedgerDimensionDefaultAccount	Determines if the ledger dimension default account can be edited.
	canFinalize	Determines if the purchase order line can be finalized.
	canSubmitToWorkflow	This method are testing if the current PurchLine can be submitted to workflow.
	caption
	checkActivity
	checkAndPromptFixedLineAmount
	checkAssetBookId
	checkCFOP_BR	It validates if CFOP is present in CFOPMatrix with the correct attributes (Operation ID, Transaction Type, Direction and Location)
	checkCommitmentVendorMatchesOrderAccount	Validates that the order account for the current purchase order header matches the vendor account on the commitment related to the current purchase order line, if the commitment has a vendor account specified.
	checkCrossdocking	Checks whether the relevant cross docking quantity exceeds the ordered quantity.
	checkCurrencyCode
	checkCustomerRef
	checkCustomsTariffCode_IN	Checks the customs tariff code to see if it is valid.
	checkCustPurchaseOrderFormNum
	checkDelete
	checkFullyDistributedAndQualified	Checks if the purchase order line is fully distributed and fully qualified.
	checkIfInvoiceRegistered_IN	Checks if the invoice is registered.
	checkInitFromInventTable
	checkIntrastat	Validates the intrastat setting on the item assosiated to the order line.
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	checkInventReceivedNow	Indicates whether the received now quantity is valid.
	checkItemId
	checkItemPBAId
	checkLine_RU
	checkLineNumber	Indicates whether a line number is unique within the scope of an order; if it is not, issues an error message.
	checkMarkupCode_RU	Checks values of markup related fields
	checkMatchingPolicy	Specifies whether the matching policy can be changed.
	checkMaximumRetailPrice_IN	This method is used to check the Maximum retail price.
	checkOperationType_MX
	checkOverDelivery
	checkPostingProfile_RU
	checkPriceDate	Triggers price recalculation after a date change according to the PurchPriceDateTypeenumeration value.
	checkProcurementCategory	Validates that the ProcurementCategory field is filled correctly.
	checkProjCategory
	checkPurchCommitmentLine	Performs validations for the commitment line reference on the purchase order line.
	checkPurchQty
	checkPurchReceivedNow	Indicates whether the received now quantity is valid.
	checkPurchType
	checkPurchUnit
	checkRBOPackage	Checks whether a package line have more than one related purchase order line.
	checkRecord	Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
	checkReqActivity
	checkRestrictedDeleteActions	Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
	checkStatusChange	Checks whether it is allowed to change to status on the order line.
	checkStockedProduct	Indicates whether the StockedProduct field is not set for category based lines.
	checkTaxItemGroup
	checkTaxServiceCode_BR	It validates if TaxServiceCode is required
	checkUnderDelivery
	checkUpdatePhysical
	checkVendorName_IN	Reads the table buffer and check the existence of record.
	clear	Removes all rows from the table buffer. (Inherited from xRecord.)
	clearAddressReference
	clearAllPriceDiscChangePolicies	Clears all of the stored PriceDiscChangePolicy instances for the PurchLine table.
	clearingPeriod
	clearInventReference	Clears the inventory reference fields on the PurchLine record.
	company	Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
	companyInfo	Retrieves the CompanyInfo record associated with the current record.
	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.)
	context	Gets and sets the context property. (Inherited from xRecord.)
	convertCurrencyCode
	convertCurrencyCode_IN	This method is used to get the value in the converted currency.
	copyDimension	Retrieves a dimension set that can be applied to the defaultDimension field on this table.
	copyFromPurchLineHistory	Copies data from a PurchLineHistory record.
	corItemName	Returns the item name considering if the item is category based or not
	createAgreementLine	Creates an agreement line
	createFromTmpFrmVirtual
	createLine
	createMarkupTrans	Creates markup transactions for the purchase line.
	creditNoteLine
	data	Retrieves a row from the table. (Inherited from xRecord.)
	dataSource	Retrieves the data source of the table. (Inherited from xRecord.)
	defaultCostPriceAsSalesPrice
	defaultField	Populates default values in a field in the table. (Inherited from xRecord.)
	defaultingTax1099Amount
	defaultRow	Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
	delete
	deleteInventTrans_BR	Delete the inventTrans related to the current purchLine if order operation is configured to do not create inventory transactions.
	deliveryAddress
	deliveryCNPJCPFNUM_BR	Returns the delivery CNPJ or CPF for the current record.
	deliveryDate
	deliveryIENum_BR	Returns the delivery IE for the current record.
	deliveryLocation	Returns the RecId value of the LogisticsLocation record that is associated with selected DeliveryPostalAddress record.
	deliveryStatusImage
	deliveryStatusTxt
	deliveryTerm
	deliveryTransDateTime	Calculates the delivery date at midnight in the time zone of the site on the purchase order line.
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	discAmount
	discPercent
	displayBudgetCheckResult	Gets the image position that displays the BudgetCheckResult value for the PurchLinerecord in the image list of the BudgetCheckResult values.
	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	Performs a check 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.)
	doReCalcPricesFromBasePrompt	Prompts the user to specify whether to recalculate prices based on trade agreements.
	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.)
	editableInWorkflow	Indicates whether the user can modify the record when an active workflow is running.
	editProductDimensionsAllowed	Determines whether the product dimensions on the line can be edited.
	endDisc
	equal	Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
	exceptionCode_BR	Displays the exception code of the item in the current purchase order line.
	existInvoice	Determines whether saved unposted invoices exist for the current record.
	existInvoice_RU	Determines if invoice line exist for the current record.
	expandBOM
	fieldAccessRight	Returns the field access right. (Inherited from xRecord.)
	fieldBufferAccessRight	Returns the field access right for the current record. (Inherited from xRecord.)
	fieldChanged
	fieldState	Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
	findAgreementLine	Checks if an agreement line exists
	findApproved	Finds the original purchase line.
	fshCrossDocking	Returns the total transfer order quantity for the given purchase order line.
	getAllowRedefault	Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
	getBudgetCheckResult	Calculates the BudgetCheckResult value for the PurchLine record.
	getDebitCredit
	getDefaultingDependencies	Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
	getDeliveryEntityRecord	Gets the delivery entity record based on the postal address.
	getEffectiveLinePrice	Gets the effective price for the purchase order line.
	getExtension	Returns the table extension. (Inherited from xRecord.)
	getFieldValue	Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
	getGrossVolumePerItem	Calculates the gross volume per item for the given PurchLine record.
	getGrossWeightPerItem	Calculates the gross weight per item for the given PurchLine record.
	getInstanceRelationType	Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
	getItemType	Displays the ItemType value for the item.
	getMiscChargesAmount_IN	This method is used to get the amount.
	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.)
	getProjCreditNoteSource	Finds the original purchase line.
	getPurchCommitmentLine_PSN	Retrieves the commitment line record that the current PurchLine record is associated with.
	getPurchReqItemName	Displays the name of the item associated with the related requisitioin line.
	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.)
	getTimeOutTimerHandle	Returns the timer handle for the object. (Inherited from Object.)
	handle	Retrieves the handle of the class of the object. (Inherited from Object.)
	hasAssetAssociated	Checks whether the line has an associated asset.
	hasOnlyLineAmount
	hasRelatedTable	Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
	hasRetentionTerms	Checks to see if the Purchase Order Line item has retention terms.
	helpField	Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
	ICMSReceivableLongTerm_BR	Indicates whether the ICMS asset is receivable long term.
	inclTax
	initBarcode
	initFromAgreementLine	Creates a PurchLine table record with the values from the AgreementLine table record.
	initFromBOM
	initFromCORPurchLine	Initializes a purchLine table buffer based on a purchLine table buffer used for unconfirmed product receipts.
	initFromInventExternalForProcessing_PL
	initFromInventTable	Updates the PurchLine based on the given item.
	initFromItemOrCategory	Initiates a PurchLine table buffer from an based on a item or catagory.
	initFromOrderLineWithMultipleDeliveries	Initializes a delivery line based on its order line.
	initFromPriceDisc
	initFromProdBOM	Initializes the PurchLine record from the ProdBOM record.
	initFromProductDimensions
	initFromProjActivity
	initFromProjTable
	initFromPurchLine	Initializes a PurchLine table buffer based on another PurchLine table buffer.
	initFromPurchLine_IN	Initializes the fields of PurchLine from given PurchLine buffer.
	initFromPurchLineHistory	Initializes the history record that is based on a PurchLineHistory record.
	initFromPurchParmLine_Asset	Sets the asset-related field values of the PurchLine table.
	initFromPurchRFQLine	Initializes the PurchLine record from the PurchRFQLine record.
	initFromPurchRFQReplyLine
	initFromPurchTable
	initFromReqPO	Initializes the PurchLine record from the ReqPO record.
	initFromSalesLine	Initializes the PurchLine record from the SalesLine record.
	initFromSalesLine_IN	Initializes the fields of SalesLine from given SalesLine buffer.
	initFromTmpPurchLine	Initiates a PurchLine record with values based on TmpPurchLine record.
	initFromTmpPurchLinePrice
	initFromTmpSuppItem
	initFromVendExternalItemDescription
	initFromVendInvoice4PaymTrans_RU
	initFromVendInvoiceTrans	Initializes a PurchLine table buffer based on a packing invoice line.
	initFromVendInvoiceTrans_IN	Reads the table buffer and initialize the field of current table.
	initFromVendPackingSlipTrans	Initializes a PurchLine table buffer based on a packing slip line.
	initFromVendTable	Initializes the PurchLine record from the VendTable record.
	initName
	initPurchQty
	initValue
	initVariantId	Initializes the VariantId field in the RetailVariantId value of the current InventDim record if there is a InventDimCombination table record for the current item and its inventory dimensions available.Otherwise the VariantId field is initialized in the empty string.
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	interCompanyIsBeingUpdated
	interCompanyIsBeingUpdatedNonInventoried	Checks whether the non stocked intercompany order line is being updated.
	interCompanyLineAmount
	interCompanyOriginDisplay
	interCompanyPurchaseLeadDate
	interCompanyPurchLineExist
	interCompanyRevertMarkupTrans
	interCompanySalesLine
	interCompanySalesLineOriginal
	interCompanyUpdateNow
	inventDim
	inventDimProfileRAsset_RU
	inventProfileType_RU
	inventSiteChanged_BR	Method called wherever the InventsiteId is changed.
	inventTable
	inventTableModule
	invoiceAccount
	invoicedInTotal
	invoicedInTotalServer
	invoicedInventInTotal
	invoicedOnPackingSlipInTotal	Retrieves the quantity invoiced on packing slips.
	isAgreementLinkValid	Checks whether the link between the agreement line and the purchase line is valid.
	isCategoryBased	Specifies whether the order line is category based.
	isDropShipment	Checks whether the order line is part of a drop shipment.
	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.)
	isForProject	Checks if this line is related to a project.
	isFullyDistributed	Performs a check whether line is fully distributed.
	isInterCompanyOrder
	isInvoiceMatched	Returns true if line was partially or fully invoiced.
	isLatestPOVersionNotArchived	Checks if the last version of the purchase order that this line belongs to was not yet archived to the history tables.
	isLinkedToAgreement	Indicates whether the purchase line is linked to an agreement line.
	isMarkupCodeEnabled_RU	The field MarkupCode_RU is enabled
	isNewRecord	Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
	isPackingSlipOrInvoiceUpdated	Specifies whether the line has been packing slip or invoice updated.
	isPartOfUOWSaveChanges	(Inherited from xRecord.)
	isProjItemBased	Checks if the line is related to an item.
	isStocked	Checks whether the order line is tracked in inventory.
	isSubcontracted	Determines if the purchase line is originating from a lean subcontracting activity.
	isTangible	Determines whether the item in the order line is tangible.
	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.)
	isUserWorkItemOwner	Gets the work item status of the pending task for the current record.
	isVersioned	Determines whether the order line has been versioned, i.e. whether it has been confirmed or approved with change management enabled.
	itemIdChanged
	itemLineDisc
	itemName	Returns the item name of the purchase order line
	joinChild	Finds the join child of the current record. (Inherited from xRecord.)
	joinParent	Finds the join parent of the current record. (Inherited from xRecord.)
	ledgerDimensionClearing
	ledgerDimensionConsumption	Changes the account that is returned when getting the ledger account so that all fixed asset transactions will use the PurchReceiptFA account instead of the PurchConsump account.
	ledgerDimensionDiscount
	ledgerDimensionItem	Retrieves a ledger dimension for the purchase order line.
	ledgerDimensionOffsetAccountPckSlp
	ledgerDimensionReceipt	Changes the account that is returned when getting the ledger account so that all the fixed asset transactions will use the PurchReceiptFA account instead of the PurchReceipt account.
	ledgerDimensionVend_RU	Returns ledger dimension value for posting
	lineAmountExclTax
	lineAmountModified
	lineAmountMST
	lineAmountMSTExclTax
	lineDeliveryImageRessNo	Determines the delivery type of the line.
	lineDisc
	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.)
	markupAllowed
	matchingAgreementLine	Returns the value of the this.MatchingAgreementLine.
	mcrInventTable	Retrieves the invent table record for the item.
	merge	Merges the current table with the specified table. (Inherited from xRecord.)
	mergeDimension	Retrieves a dimension set that contains the merged combination of the current defaultDimension field on this table and the provided dimension set.
	modifiedField	Performs specific actions when a field is modified.
	modifiedFieldValue	Modify a specified field.
	modifyAssetId	Modifies the related field values when the value of the AssetId field is changed.
	modifyCreateFixedAsset	Modifies the related fields when the value of the CreateFixedAsset field is changed.
	modifyInventDim
	modifyWMSLocation	Modifies an InventDim record with WMS values.
	moduleType
	mustBeCovPlanned
	new	Initializes a new instance of the Object class. (Inherited from Object.)
	nextLineNum
	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	Updates tax information and the fiscal document texts when the CFOP is changed.
	onDeliveryPostalAddressChange_BR	Updates CFOP information when the delivery address is changed to a different state or country.
	onTaxChange_BR	Updates the current purchase order line amount when tax is changed.
	orderAccount
	ordered
	orderedInPurchUnit
	orig	Retrieves the original values of the current record. (Inherited from xRecord.)
	overDeliveryPct	Returns the allowed over-delivery percent.
	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.)
	packExtensionTable	Packs an extension table record to the container field PackedExtensions.
	packPurchLine_IN	Packs an extension table record to the container field PackedExtensions.
	packPurchLine_Intrastat	Packs PurchLine_Intrastat extension table record.
	packPurchLine_W	Packs an extension table record to the container field PackedExtensions.
	parmExchangeRateDate
	parmParentSourceDocumentLine
	parmSourceDocLineTypeEnumName
	parmSourceDocLineTypeEnumValue
	parmSourceDocumentHeader
	pdsAdvancedPriceInfo	Gets the advanced pricing extension information record for this PurchLine.
	pdsCancelRemainWeight	Sets CW item RemainInvnetPhysical to zero if PdsCWRemainInventPhysical is zero.
	pdsCheckApprovedVendorList	Method validates if the purchase line item has valid approved vendor list entry if controlled by AVL functionality.
	pdsCWArrived	Calculates and returns the CW qty arrived for the purchase order line.
	pdsCWCalcPendingMatchedQtyInvent	Calculates a sum of the PdsCWInventNow quantity for invoice lines connected to this PurchLine table record, which are matched to a packing slip.
	pdsCWCalcPendingQtyPurch	Calculates a sum of ReceiveNow quantity for all pending invoice lines connected to this PurchLine table record.
	pdsCWCalcPendingQtyPurchDisplay	Returns the sum of PdsCWInventNow quantities for all pending invoice lines connected to this PurchLine table record.
	pdsCWInvoicedInTotal	Calculates and returns the CW qty Invoiced in total for the purchase order line.
	pdsCWOrdered	Calculates and returns the CW qty ordered for the purchase order line.
	pdsCWPurchReceivedNowConversion	Converts CW qty to standard qty or standard qty to cw qty for the purchase order line.
	pdsCWQtyConversion	Converts the CW qty to the standard qty and sets the purchLine.PurchQty to the converted value.
	pdsCWQtyValidation	Validates that the catch weight quanity entered is valid.
	pdsCWReceivedInTotal	Calculates and returns the CW qty received in total for the purchase order line.
	pdsCWRegistered	Returns the CW qty registered for the purchase order line.
	pdsCWUnitId	Gets the catch weight unit for the item.
	pdsVendBatchInfo
	PISCOFINSReceivableLongTerm_BR	Indicates whether the PISCONFINS asset is receivable long term.
	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.)
	postModifyInventDimBR	Sets field values on the order line based on the changed inventory dimension.
	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
	projIdModified	Changes the purchase line based on changes in the project ID unit field.
	projQueryValueInventTransId
	projTable
	psAeditActivityPurpose
	psaGetPWPSetting
	psaInitFromForecastSales
	psaInvoicedAmount
	psaInvoicedQty
	psaPwpPercent
	purchCORremainPurchQty
	purchLine_IN	Get the PurchLine_IN table.
	purchLine_Intrastat	Retrieves PurchLine_Intrastat extension table record.
	purchLine_W	Get the PurchLine_W table.
	purchLineView_IN	Gets a PurchLineView_IN based on current buffer.
	purchQtyModifiedInteraction	Performs code with regard to changes in the purchase line when purchase quantity is changed with user interaction if associated link to agreement line becomes invalid.
	purchReceivedNowAllowEdit	Determines whether the ReceivedNow field can be edited.
	purchTable
	purchUnitModified	Changes the purchase line based on changes in the PurchUnit field.
	qtyMarked	Retrieves the amount of the inventory items marked for the purchase order line.
	qualityOrderStatusDisplay	Retrieves the status of the associated quality orders.
	quantityToDistribute	Calculates and returns the quantity to be distributed to the AccountingDistribution table.
	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.)
	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.)
	receivedInTotal
	receivedInTotalPrice
	receivedInTotalServer
	receivedInventInTotal
	receivedOnPackingSlipInTotal	Retrieves the quantity received on packing slips.
	recordLevelSecurity	Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
	reductionEntryAmount_JP	Displays the asset reduction entry amount
	reductionEntryDocumentId_JP	Displays the asset reduction entry document id
	referenceWarningTxt	Retrieves a warning message used for a line which references other entities.
	refreshAgreementLink	Refreshes the link between the AgreementLine and the PurchLine. If the current link has become invalid, or if there is no current link, this will search for the best matching AgreementLineand update the PurchLine if a new match is found.
	registered
	registeredInPurchUnit
	registeredQuantityAndServices	Gets the registered quantity for the line or the line quantity for a non-tangible line that cannot be registered.
	registeredQuantityAndServicesInPurchUnit	Gets the registered quantity for the line or the line quantity for a non-tangible line that cannot be registered.
	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.)
	reqTrans	Finds the corresponding record in the ReqTrans table for the current record in the PurchLine table.
	reread	Rereads the record from the table. (Inherited from xRecord.)
	resetDistributions	Removes and regenerates the distributions for the current document.
	resetInvent
	returnActionChanged
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	runPriceDiscPolicyDialog	Calls the runPriceDiscPolicyDialog method of the PriceDiscResultFields table map.
	salesLine
	salesPurchTable
	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
	setAddressFromPurchLine
	setAddressFromPurchTable
	setAddressFromVendTable
	setAgreementLine	Sets the AgreementLine when the procurement category is changed for a purchase line.
	setAgreementPrice
	setAgreementSkipAutoLink	Sets a value for the AgreementSkipAutoLink field of PurchLine
	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.)
	setDeliveryName	Sets the delivery name field based on the specified logistic location.
	setDepreciationStartDate
	setExciseFields_IN	Sets excise fields of purch line.
	setFieldValue	Sets the field value in the record buffer. (Inherited from xRecord.)
	setInventDimId	Applies the InventDimId parameter to the InventDimId field and applies default values, depending on the new inventory dimensions.
	setInventDimIdFromInventDim	Finds or creates an InventDimId value for the InventDim parameter and applies the found InventDimId value to the PurchLine.inventDimId field.
	setInventReceivedNow
	setListCode
	setLocation	Sets delivery address information and related information.
	setPostingProfile_RU
	setPriceAgreement
	setPriceDisc
	setPriceDiscChangePolicy	Calls the createPriceDiscChangePolicy method of the PriceDiscResultFields table map.
	setPriceDiscMarkup	Calls the setPriceDiscMarkup method on the SalesPurchLine table map.
	setPriceDiscPriceUnit	Calls the setPriceDiscPriceUnit method on the SalesPurchLine table map.
	setProjSalesPrice	Calculate and set the project sales price field.
	setPurchStatus
	setRAssetInventProfileId_RU
	setSQLTracing	Enables or disables SQL tracing mode. (Inherited from xRecord.)
	setStockedProduct	Sets the StockedProduct field for the line based on line type and item model group for the associated item.
	setTaxGroup
	setTaxGroupAndTaxItemGroupFields_BR	Set PurchLine.TaxGroup and PurchLine.TaxItemGroup based on TaxesMatrix
	setTaxInfoOfCompany_IN	Sets tax information of company.
	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.)
	setXDSContext	Sets new XDS context. (Inherited from xRecord.)
	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.)
	sourceDocumentLine
	stockedProductChanged	Applies default values or sets the inventory related field values to null when the StockedProduct field value is changed.
	submitToWorkflow	Activates the purchase order line workflow.
	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.)
	taxationOrigin_BR	Displays the origin of the item in the current purchase order line.
	taxByLine
	taxDate
	taxFiscalClassification_BR	Displays the fiscal classification code of the item in the purchase order line.
	taxPcsPrice
	taxWithholdCodeType_IN	Gets the tax withhold code type.
	templateName	Sets or gets the information about the DistributionTemplate record for creating distributions.
	timeZoneSite	Retrieves the time zone associated with the site on the current purchase order line.
	tmsVolume	Gets the transportation Volume for the PurchLine.
	tmsWeight	Gets the transportation Weight for the PurchLine.
	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.)
	totalDiscountAmount	Calculates the total discount amount.
	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.)
	type
	underDeliveryPct	Returns the allowed under-delivery percent.
	unitConvertInvent2Purch
	unitConvertPurch2Invent
	unLinkAgreementDeliveryDates	Indicates whether the link to the agreement line is valid after changes have been made; if not, the user is given an option to remove the link to the associated agreement.
	unLinkAgreementLine	Deletes the links between the purchase order line and the agreement line.
	unLinkAgreementLinePrompt	Prompts whether the user wants to delete the link between the agreement line and the purchase order line in a text box.
	update	Updates the PurchLine record.
	updateWhsCrossDock	Updates the WHSCrossDock field on the WHSPurchLine related table if available.
	updateWorkflowState	This method are setting the field WorkflowState on the current PurchLine
	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
	validateField	Validates the value of field.
	validateFieldValue	Determines whether the parameter "_fieldName" field is valid.
	validateModifyInventDim
	validateWrite	Determines whether the current record is valid and ready to be written to the database.
	validateWrite_Server	Validates if the current PurcLine table buffer can be written to the database.
	validTimeStateUpdateMode	Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
	variencePrice
	varienceQty
	varienceQtyPct
	vendTable_OrderAccount
	wait	Pauses a process. (Inherited from Object.)
	warningForReference	Show a warning for a line which references other entities.
	wasCached	Specifies the location from which the data was retrieved. (Inherited from xRecord.)
	whsCheckDeleteLoadline	Prevent the delete of purch lines that are already associated with a load line if the warehouse parameter 'Automatically delete upon order delete' is not enabled.
	whsGetLoads	Gets the WHSLoadLine record ID associated with this PurchLine.
	whsItemGrossWeight	Retrieves the gross weight for an item
	whsItemUnitVolume	Retrieves the volume for an item
	whsPurchLineForInsert
	whsVendDeliveryAddress	Displays the delivery address of the vendor. If there is not one defined, it displays the primary one.
	workflowInstructions	Retrieves the latest workflow step instructions for this record.
	workflowLastComment	Retrieves the last workflow comment for this record.
	workflowWorkItemDueDate	Retrieves the latest workflow due date for this record.
	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.)
	::checkMultipleAccountingDistExist	Indicates whether the PurchLine buffer has more than one AccountingDistributionrecords.
	::checkReceiveQty_IN	Checks whether exist the receive quantity.
	::earliestConfirmedDlv	Finds the purchase order line that have the earliest confirmed delivery date.
	::exist
	::existDifferentCurrency
	::existNonFinalizedLines	Determines if one or more purchase order lines exist that are not finalized.
	::find
	::findBySourceDocumentLine	Finds the PurchLine record.
	::findInventTransId
	::findItemIdInventDimId	Finds the specified record in the PurchLine table.
	::findPurchIdPurchType	Finds the specified record in the PurchLine table.
	::findPurchTypeItemIdVarinatId	Finds the specified record in the PurchLine table.
	::findRecId
	::getLedgerPostingType
	::getVendorLocationId_IN	Gets vendor location id.
	::hasExensionTableEnabled	Checks is there any extension table of table PurchLine is enabled.
	::highestPackageLineNum	Returns the highest package line number from the purchase order.
	::highestPurchStatus
	::historyExistsOrLatestVersionNotArchived	This method checks if the line is versioned i.e. line is archived i.e. has historical records, or the last version of the purchase order and purchase line is not archived yet.
	::initFromInventTableIL	Updates a PurchLine table buffer based on the item.
	::isDeleted	Checks whether the PurchLine record is deleted.
	::isDistributionForCreditNote	Determines if the accounting distribution originates from a credit note.
	::isTaxExist
	::isTaxUnrealized
	::lastLineNum
	::lookupCountryRegionName_RU	Performs lookup on LogisticsAddressCountryRegionTranslation table
	::lookupRetailVariantId	Performs the lookup for the RetailVariantId field.
	::lowestPurchStatus
	::modifyPurchQty
	::resetAxPurchLinePolicies	Resets the price discount policies.
	::returnedLotQty	Calulates the returned quantity and catch weight quantity for a purchase order line.These quantities include other open return lines as well partially or fully processed return lines (current purchase order line is not included).
	::setDeliveryDueWorkflowState	Sets the PurchLine workflow state for the COR: Delivery due in xx days workflow.
	::setInvReceivedWorkflowState	Sets the PurchLine workflow state for the COR: Invoice received, items not received workflow.
	::setWorkflowState	This method update the WorkflowState on the specified PurchLine

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
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.
AgreementSkipAutoLink	Extended Data Type: AgreementSkipAutoLink Type: Enum	TradeBlanketOrder	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
AssetBookId	Extended Data Type: AssetBookIdPurchSalesInvent Type: String	Asset	Value model related to the current transaction.
AssetGroup	Extended Data Type: AssetGroupId Type: String	Asset	Select a fixed asset group
AssetId	Extended Data Type: AssetIdOpen Type: String	Asset	Unique key for identification of fixed asset. The key is used when creating new assets.
AssetTransTypePurch	Extended Data Type: AssetTransTypePurchEDT Type: Enum	Asset	Which type of fixed asset transaction is to be created in connection with the purchase?
BarCode	Extended Data Type: PurchBarCode Type: String	LogisticsBasic	Bar code digits
BarCodeType	Extended Data Type: BarcodeSetupId Type: String	None	Select or view the bar code setup ID
Blocked	Extended Data Type: LineStopped Type: Enum	None	Is the line locked?
CaseTagging	Extended Data Type: RFIDCaseTagging Type: Enum	RFIDTagging	Is case tagging mandatory?
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))
Complete	Extended Data Type: LineComplete Type: Enum	None	Deliver complete line?
ConfirmedDlv	Extended Data Type: PurchLineDlvDate Type: Date	LogisticsBasic	Date for confirmed delivery.
ConfirmedTaxAmount	Extended Data Type: TaxAmountCur Type: Real	LedgerBasicSalesTax	Calculated sales tax amount in the sales tax settlement currency
ConfirmedTaxWriteCode	Extended Data Type: TaxWriteCode Type: String	LedgerBasicSalesTax	Code printed on the voucher.
CountyOrigDest	Extended Data Type: AddressCountyOrigDest Type: String	None	Intrastat county of origin/destination.
CovRef	Enumeration: PurchCovRef	LedgerAdvCashflowForecast	What is the purchase coverage planned for?
createdDateTime	Extended Data Type: CreatedDateTime Type: UtcDateTime	None
CreateFixedAsset	Extended Data Type: CreateFixedAsset Type: Enum	Asset	Select this field if a new fixed asset should be created for the purchase line when a product receipt or invoice is posted
CurrencyCode	Extended Data Type: VendCurrencyCode Type: String	None	Currency the line is invoiced in
CustomerRef	Extended Data Type: CustRefLine Type: String	LedgerBasic	Customer's reference
CustPurchaseOrderFormNum	Extended Data Type: CustPurchaseOrder Type: String	None	Customer requisition number
dataAreaId	Extended Data Type: DataAreaId Type: String	None
DefaultDimension	Extended Data Type: DimensionDefault Type: Int64	LedgerBasic	Default dimensions
DeliveryDate	Extended Data Type: PurchLineDlvDate Type: Date	LogisticsBasic	Line delivery date
DeliveryName	Extended Data Type: LogisticsDeliveryName Type: String	None	The name that is associated with the selected delivery address
DeliveryPostalAddress	Extended Data Type: LogisticsPostalAddressRecId Type: Int64	None	Reference field in a different table
DeliveryType	Extended Data Type: TradeLineDlvTypeId Type: Enum	None	Delivery type of the current order line.
DepreciationStartDate	Extended Data Type: AssetDepreciationStartDate Type: Date	Asset	Date from which the fixed asset will begin depreciating.
DiscAmount	Extended Data Type: PurchDiscAmount Type: Real	PriceDisc	The amount in the transaction currency
DiscPercent	Extended Data Type: PurchDiscPercent Type: Real	PriceDisc	Discount in percentage.
EditableInWorkflow	Extended Data Type: TradeEditableInWorkflow Type: Enum	LogisticsBasic	Are the record editable when a workflow is running?
ExternalItemId	Extended Data Type: PurchExternalItemId Type: String	LogisticsBasic	Vendor's item number
GSTHSTTaxType_CA	Enumeration: GSTHSTTaxType_CA	None	Select the GST/HST line amount type.
InterCompanyInventTransId	Extended Data Type: InventRefTransId Type: String	TradeInterCompany	Lot ID referred to.
InterCompanyOrigin	Enumeration: InterCompanyOrigin	TradeInterCompany	States whether the line was created manually (Source), or indirectly as part of an intercompany chain (Derived)
IntrastatFulfillmentDate_HU	Extended Data Type: IntrastatFulfillmentDate_HU Type: Date	ForeignTrade	Date of Intrastat fulfillment. (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.
InventInvoiceNow	Extended Data Type: InventQty Type: Real	None	Quantity now being invoiced in inventory unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
InventReceivedNow	Extended Data Type: InventQty Type: Real	None	Quantity now being received in inventory unit
InventRefId	Extended Data Type: InventRefId Type: String	None	Number of the order, project, production, or purchase referred to
InventRefTransId	Extended Data Type: InventRefTransId Type: String	LogisticsBasic	Lot ID referred to.
InventTransId	Extended Data Type: TradeInventTransId Type: String	LogisticsBasic	Identification of the item lot.
IsDeleted	Extended Data Type: VersioningIsDeleted Type: Enum	None	Is the current record deleted?
IsFinalized	Extended Data Type: PurchLineIsFinalized Type: Enum	LogisticsBasic	Indicates whether the purchase order line is finalized or not
IsInvoiceMatched	Extended Data Type: PurchLineIsInvoiceMatched Type: Enum	LogisticsBasic	Indicates whether the purchase order line is invoice matched
IsModified	Extended Data Type: VersioningIsModified Type: Enum	None	Has the current record been modified since previous version?
IsPwp	Extended Data Type: NoYesId Type: Enum	PSAPwp	Pay-when-paid (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
ItemBOMId	Extended Data Type: ItemBOMId Type: String	BOMVersion	BOM number for specific sub-BOM. If blank, the active number is used.
ItemId	Extended Data Type: ItemIdSmall Type: String	LogisticsBasic	Item number included in the line.
itemPBAId	Extended Data Type: PBAId Type: String	PBA_ProductBuilder	Product model ID
ItemRefType	Enumeration: InventRefType	None	Module and number referred to
ItemRouteId	Extended Data Type: ItemRouteId Type: String	ProdRouting	Route number for specific subroute. If blank, the active number is used.
ItemTagging	Extended Data Type: RFIDItemTagging Type: Enum	RFIDTagging	Is item tagging mandatory?
LedgerDimension	Extended Data Type: LedgerDimensionDefaultAccount Type: Int64	LedgerBasic	Ledger account for posting lines in special receipt account.
LineAmount	Extended Data Type: PurchLineAmount Type: Real	LogisticsBasic	Line amount after subtracting discounts
LineDeliveryType	Enumeration: LineDeliveryType	None	Role of line in a delivery schedule
LineDisc	Extended Data Type: PurchLineDisc Type: Real	PriceDisc	Line discount in amount per price unit.
LineHeader	Extended Data Type: LineHeader Type: String	None	Text describing the line
LineNumber	Extended Data Type: TradeLineNumber Type: Int64	LogisticsBasic	Identifies the line within the purchase order.
LinePercent	Extended Data Type: PurchLinePercent Type: Real	PriceDisc	Line discount percentage.
ManualEntryChangepolicy	Extended Data Type: PriceDiscPolicyManual Type: Int64	None	-
ManualModifiedField	Extended Data Type: FieldId Type: Integer	None	ID for the field (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MatchingAgreementLine	Extended Data Type: AgreementLineRecId Type: Int64	None	Reference to the agreement line record
MatchingPolicy	Enumeration: PurchMatchingPolicyOption	PurchInvoiceMatching	Policy for the selected PO line. Three-way: PO, product receipt, and invoice. Two-way: PO and invoice.
MCRDropShipComment	Extended Data Type: MCRDropShipComment Type: String	None	Direct delivery comments are printed on the purchase order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRDropShipment	Extended Data Type: MCRDropShipment Type: Enum	None	Item is flagged for direct delivery. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRDropShipStatus	Enumeration: MCRDropShipStatus	None	The direct delivery status (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCROrderLine2PriceHistoryRef	Extended Data Type: MCROrderLinePriceHistoryReference Type: Int64	TradeAgreements	Link between order line and a price history reference (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
modifiedDateTime	Extended Data Type: ModifiedDateTime Type: UtcDateTime	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
MultiLnDisc	Extended Data Type: PurchMultiLnDisc Type: Real	PriceDisc	Multiline discount per price unit
MultiLnPercent	Extended Data Type: PurchMultiLnPercent Type: Real	PriceDisc	The multiline discount percentage
Name	Extended Data Type: ItemFreeTxt Type: String	LogisticsBasic	Line description
OperationType_MX	Enumeration: VendorOperationType_MX	None	Operation code used for DIOT declaration.
OverDeliveryPct	Extended Data Type: PurchOverDeliveryPct Type: Real	LogisticsOverUnderDelivery	The percentage by which the product receipt quantity is allowed to exceed the order quantity
PalletTagging	Extended Data Type: RFIDPalletTagging Type: Enum	RFIDTagging	Is pallet tagging mandatory?
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))
PDSCalculationId	Extended Data Type: PDSCalculationId Type: String	PDSPotency	Set the unique identifier for a given calculation formula. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PdsCWInventReceivedNow	Extended Data Type: PdsCWQtyReceiveNow Type: Real	PdsCatchWeight	Catch weight receive now quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWQty	Extended Data Type: PdsCWInventQty Type: Real	PdsCatchWeight	Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWRemainInventFinancial	Extended Data Type: PdsCWInventQty Type: Real	PdsCatchWeight	CW quantity that has been packing slip received but not yet invoice updated. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWRemainInventPhysical	Extended Data Type: PdsCWInventQty Type: Real	PdsCatchWeight	CW quantity - not yet packing slip delivered - in the inventory unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PlanReference	Extended Data Type: PlanReferenceRefRecId Type: Int64	None	Plan reference
Port	Extended Data Type: IntrastatPortId Type: String	ForeignTrade	Port where current delivery is loaded.
PriceUnit	Extended Data Type: PriceUnit Type: Real	LogisticsBasic	Number of units the quantity applies to.
ProcurementCategory	Extended Data Type: PurchCategory Type: Int64	LogisticsBasic	Category from the procurement category hierarchy
ProjCategoryId	Extended Data Type: ProjCategoryId Type: String	ProjBasic	Category that is used as a default.
ProjId	Extended Data Type: ProjId Type: String	ProjBasic	Project identification
ProjLinePropertyId	Extended Data Type: ProjLinePropertyId Type: String	ProjBasic	Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost
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.
ProjSalesUnitId	Extended Data Type: UnitOfMeasureSymbol Type: String	None	Unit symbol
ProjTaxGroupId	Extended Data Type: ProjTaxGroup Type: String	ProjBasic	Sales tax group project invoicing.
ProjTaxItemGroupId	Extended Data Type: ProjTaxItemGroup Type: String	ProjBasic	Item sales tax group project invoicing.
ProjTransId	Extended Data Type: ProjItemTransId Type: String	ProjBasic	Identification of transaction.
ProjWorker	Extended Data Type: HcmWorkerRecId Type: Int64	ProjBasic	The name of the worker (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
PSARetainScheduleId	Extended Data Type: PSAPurchRetainScheduleId Type: String	PSAAPRetainage	Vendor retention rule id. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSATotalRetainAmount	Extended Data Type: AmountCur Type: Real	PSAAPRetainage	The amount in the transaction currency (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PurchaseType	Enumeration: PurchaseType	LogisticsBasic	Purchase type
PurchCommitmentLine_PSN	Extended Data Type: RefRecId Type: Int64	PurchFrenchRegulatory_PSN	The commitment referred to by this purchase order line
PurchId	Extended Data Type: PurchIdBase Type: String	LogisticsBasic	Purchase number that the line is attached to
PurchMarkup	Extended Data Type: PurchMarkup Type: Real	LogisticsBasic	Fixed charges on purchase price, which are independent of quantity
PurchPrice	Extended Data Type: PurchPrice Type: Real	None	Purchase price per price unit
PurchQty	Extended Data Type: PurchOrderedQty Type: Real	LogisticsBasic	Quantity ordered in purchase unit
PurchReceivedNow	Extended Data Type: PurchQty Type: Real	LogisticsBasic	Quantity received now in purchase units
PurchReqId	Extended Data Type: PurchReqId Type: String	PurchReq	Identification of the purchase requisition
PurchReqLineRefId	Extended Data Type: PurchReqLineRefId Type: Guid	PurchReq	Unique identification of line
PurchStatus	Enumeration: PurchStatus	LogisticsBasic	Line status with regard to delivery and invoicing
PurchUnit	Extended Data Type: PurchUnit Type: String	None	Unit in which the item is purchased.
QtyOrdered	Extended Data Type: InventQty Type: Real	None	Quantity ordered in the inventory unit.
RBOPackageLineNum	Extended Data Type: LineNum Type: Real	RetailHeadquarters	Identification of line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS))
RecId	Extended Data Type: RecId Type: Int64	None
recVersion	Extended Data Type: RecVersion Type: Integer	None
Remainder	Extended Data Type: InventQty Type: Real	None	Quantity for which a packing slip has not yet been received in the inventory unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
RemainInventFinancial	Extended Data Type: InventQty Type: Real	None	Quantity that has been received through a product receipt but has not yet been invoice updated.
RemainInventPhysical	Extended Data Type: InventQty Type: Real	None	Quantity for which a packing slip has not yet been received in the inventory unit
RemainPurchFinancial	Extended Data Type: PurchQty Type: Real	LogisticsBasic	Quantity that has been received through a product receipt but has not yet been invoice updated.
RemainPurchPhysical	Extended Data Type: PurchQty Type: Real	LogisticsBasic	Quantity that has not yet been received through a product receipt.
ReqAttention	Extended Data Type: PurchReqAttention Type: String	PurchReq	Attention information for the purchase requisition
ReqPlanIdSched	Extended Data Type: ReqPlanIdSched Type: String	Req	Identification of plan
ReqPOId	Extended Data Type: ReqPOId Type: String	Req	Number identifying the planned order
Requester	Extended Data Type: PurchRequester Type: Int64	None	The name of the worker
RetailLineNumEx1	Extended Data Type: LineNum Type: Real	RetailHeadquarters	Identification of line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS))
RetailPackageId	Extended Data Type: RetailPackageId Type: String	RetailHeadquarters	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS))
RetailTempValueEx2	Extended Data Type: RetailTempValueEx2 Type: Real	RetailHeadquarters	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS))
ReturnActionId	Extended Data Type: PurchReturnActionId Type: String	LogisticsBasic	What should happen with the returned items?
ReturnDispositionCodeId	Extended Data Type: ReturnDispositionCodeId Type: String	ReturnItem	Identification of the disposition code.
ReturnStatus	Enumeration: ReturnStatusLine	ReturnItem	Status of the return line.
Scrap	Enumeration: NoYes	None	No inventory transactions will be created for the line.
ServiceAddress	Extended Data Type: Addressing Type: String	TradeMultiShipTo	Address where the items are to be delivered. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
ServiceDate	Extended Data Type: DlvDate Type: Date	None	Transaction date (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
ShippingDateConfirmed	Extended Data Type: SalesShippingDateConfirmed Type: Date	LogisticsBasic	The selling company confirms that the order will be shipped on this date.
ShippingDateRequested	Extended Data Type: SalesShippingDateRequested Type: Date	LogisticsBasic	The day the selling company should ship the item in order to meet the customer's requested receipt date.
SkipDistributionUpdate	Enumeration: NoYes	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SourceDocumentLine	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
StatisticValue_LT	Extended Data Type: LtIntrastatStatisticValue Type: Real	ForeignTrade	The transaction amount, in the accounting currency (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
StatProcId	Extended Data Type: IntrastatProcId Type: String	ForeignTrade	Code for the current statistical procedure.
StatTriangularDeal	Extended Data Type: IntrastatTriangularDeal Type: Enum	ForeignTrade	Is this a triangular deal?
StockedProduct	Extended Data Type: TradeStockedProduct Type: Enum	LogisticsBasic	Track in inventory?
SystemEntryChangePolicy	Extended Data Type: PriceDiscPolicySystem Type: Int64	None	-
SystemEntrySource	Enumeration: PriceDiscSystemSource	None	-
TAMItemVendRebateGroupId	Extended Data Type: TAMItemVendRebateGroupId Type: String	TAMVendorRebate	Group of item for which a rebate is applicable. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Tax1099Amount	Extended Data Type: Tax1099Amount Type: Real	None	Amount to be reported in 1099
Tax1099Fields	Extended Data Type: Tax1099FieldsRecId Type: Int64	None	Box code on the 1099 form that the total amount is posted to.
Tax1099RecId	Extended Data Type: Tax1099RecId Type: Int64	PublicSector	Reference field in a different table
Tax1099State	Extended Data Type: Tax1099State Type: String	None	Identification of state
Tax1099StateAmount	Extended Data Type: Tax1099StateAmount Type: Real	None	Amount to be reported in 1099
TaxAutogenerated	Extended Data Type: TaxAutoGenerated Type: Enum	LedgerBasicSalesTax	Sales tax is automatically calculated or specified by user.
TaxGroup	Extended Data Type: TaxGroup Type: String	LedgerBasicSalesTax	Name of sales tax group.
TaxItemGroup	Extended Data Type: TaxItemGroup Type: String	LedgerBasicSalesTax	Group of sales tax codes that can be calculated for an item.
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))
TaxWithholdBaseCur_TH	Extended Data Type: TaxWithholdBaseCur Type: Real	LedgerBasicWithholdingTax	Adjusted withholding tax base amount
TaxWithholdGroup_TH	Extended Data Type: TaxWithholdGroup Type: String	LedgerBasicWithholdingTax	Identification of the withholding tax group.
TaxWithholdItemGroupHeading_TH	Extended Data Type: TaxWithholdItemGroupId_TH Type: Int64	None	Group of withholding tax codes that can be calculated for an item
TransactionCode	Extended Data Type: IntrastatTransactionCodeId Type: String	ForeignTrade	Code for the current transaction code.
Transport	Extended Data Type: IntrastatTransport Type: String	ForeignTrade	Specify means of transport for the current order.
UnderDeliveryPct	Extended Data Type: PurchUnderDeliveryPct Type: Real	LogisticsOverUnderDelivery	The percentage by which the product receipt quantity is allowed to be less than the order quantity
VariantId	Extended Data Type: RetailVariantId Type: String	Retail	Variant ID (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS))
VendAccount	Extended Data Type: VendAccount Type: String	None	Vendor account number.
VendGroup	Extended Data Type: VendGroupId Type: String	LedgerBasic	Vendor group
WfDeliveryDueState	Enumeration: TradeWorkflowState	LogisticsBasic	Workflow state
WfInvReceivedState	Enumeration: TradeWorkflowState	LogisticsBasic	Workflow state
WorkflowState	Enumeration: TradeWorkflowState	LogisticsBasic	Workflow state

Top

Field Groups

Field Group	Fields
AddressLookup
AddressReference
AgreementLine
All
AutoReport
Attention
Barcode
Block
BOMRoute
Calculated
CaseMoreInformation
Delivery
g1099Fields
ForeignTrade
FiscalInformation_BR
FixedAssets_RU
FixedAssets
DeliveryRef
Dimension
DiotInformation_MX
DeliveryAddress
Discount
DocumentPreview
Inventory
InvoiceMatching
ItemReference
MCRDropShip
PayWhenPaid
PdsCWInventory
PdsCWMain
PDSPotency
PlannedOrder
PlanReference
Posting
ProjectSalesPrice
ProjectCostPrice
Price
ProjectIdentification
ProjectSalesTax
ProjTransaction
PSA
PSARetainage
PurchaseLines
PurchaseQuantity
PurchLine
SalesTax
PurchReq
RFIDTagging
Status
Requisitioner
PurchReqReference
ReturnedItem
PurchCommitmentLine_PSN
TableGroup
TAMItemVendRebateGroup
WithholdingTax
Identification
Intercompany
GSTHSTTaxType_CA
InterCompanyReference
Intrastat
InterCompanyReturn

Top

Relations

Relation	Table	Lines
AccountingDistributionTemplate	AccountingDistributionTemplate
AgreementLine	AgreementLine
AssetBook	AssetBook
AssetBookTable	AssetBookTable
AssetGroup	AssetGroup
AssetTable	AssetTable
BarcodeSetup	BarcodeSetup
BOMTable	BOMTable
CFOPTable_BR	CFOPTable_BR
Common	Common
CountyOrigDest	LogisticsAddressCounty
Currency	Currency
dataAreaId	DataArea
DefaultDimension	DimensionAttributeValueSet
DeliveryPostalAddress	LogisticsPostalAddress
IntrastatPort	IntrastatPort
IntrastatStatProc	IntrastatStatProc
IntrastatTransactionCode	IntrastatTransactionCode
IntrastatTransportMode	IntrastatTransportMode
InventDim	InventDim
InventDimCombination	InventDimCombination
InventItemBarcode	InventItemBarcode
InventJournalTableRef	InventJournalTable
InventTable	InventTable
InventTransOrigin	InventTransOrigin
LedgerDimension	DimensionAttributeValueCombination
MCROrderLine2PriceHistoryRef	MCROrderLine2PriceHistoryRef
MCRSalesLineRef	SalesLine
Partition	Partitions
PBATable	PBATable
PlanReference	PlanReference
PriceDiscChangePolicyRecId1	PriceDiscChangePolicy
PriceDiscChangePolicyRecId2	PriceDiscChangePolicy
ProcurementCategory	EcoResCategory
ProdLineRef	ProdTable
ProdTableRef	ProdTable
ProjCategory	ProjCategory
ProjectSalesCurrency	Currency
ProjectTaxGroupHeading	TaxGroupHeading
ProjectTaxItemGroupHeading	TaxItemGroupHeading
ProjItemTrans	ProjItemTrans
ProjLineProperty	ProjLineProperty
ProjSalesUnitId	UnitOfMeasure
ProjTable	ProjTable
ProjWorker	HcmWorker
PSAVendorRetentionTermsTable	PSAVendorRetentionTermsTable
PurchCommitmentLine_PSN	PurchCommitmentLine_PSN
PurchReqLine	PurchReqLine
PurchReqTable	PurchReqTable
PurchReturnActionDefaults	ReturnActionDefaults
PurchTable	PurchTable
PurchUnit	UnitOfMeasure
ReqPlanSched	ReqPlanSched
Requester_FK	HcmWorker
RetailPackageTable	RetailPackageTable
ReturnDispositionCode	ReturnDispositionCode
RouteTable	RouteTable
SalesTableRef	SalesTable
smmActivities	smmActivities
SourceDocumentLine	SourceDocumentLine
State	LogisticsAddressState
TAMItemVendRebateGroup	TAMItemVendRebateGroup
Tax1099BoxDetail	Tax1099BoxDetail
Tax1099Fields	Tax1099Fields
TaxGroupHeading	TaxGroupHeading
TaxItemGroupHeading	TaxItemGroupHeading
TaxServiceCode_BR	TaxServiceCode_BR
TaxWithholdGroupHeading	TaxWithholdGroupHeading
TaxWithholdItemGroupHeading_TH	TaxWithholdItemGroupHeading_TH
VendGroup	VendGroup
VendTable	VendTable

Top

Indexes

Index	AllowDuplicates	Enabled	Fields
AgreementLineIdx	Yes	Yes
CFOPTable_BRIdx	Yes	Yes
DEL_TaxWithholdItemGroup_THIdx	Yes	Yes
ItemIdx	No	Yes
PurchIdLineNumIdx	Yes	Yes
PurchLineIdx	No	Yes
PurchStatusIdx	Yes	Yes
RBOPackageIdx	Yes	Yes
RecId	No	Yes
SourceDocumentLine	No	Yes
StatusItemIdx	Yes	Yes
Tax1099FieldsIdx	Yes	Yes
TransIdIdx	No	Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    PurchLine Table

See Also

Table Methods

Tables Overview