VendInvoiceInfoLine Table

Article
04/11/2014

The VendInvoiceInfoLine table contains vendor invoice lines for a specific purchase order.

Configuration Key: LedgerBasic

Methods

	Method	Description
	accDistributionTemplateRecId	Determines the AccountingDistributionTemplateRecId value that is associated with an invoice line.
	accountItemLedgerDimension	Retrieves a posting account for the invoice line.
	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.)
	balanceToInvoice
	buf2con	Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
	calcLineAmount
	calcLineAmountForced
	calcPrice2LineAmount
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	canEditDisc
	canSubmitToWorkflow	Indicates whether submission to workflow is possible. (Inherited from xRecord.)
	caption	Gets and sets the caption property of a table. (Inherited from xRecord.)
	checkCFOP_BR	It validates if CFOP is present in CFOPMatrix with the correct attributes (Operation ID, Transaction Type, Direction and Location)
	checkIfQuantityMatch	Determines whether the current VendInvoiceInfoLine table record has a quantity matching discrepancy.
	checkIfQuantityMatch_Server
	checkIntrastat	Validates Intrastat settings on vend invoice line.
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	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.)
	clear	Removes all rows from the table buffer. (Inherited from xRecord.)
	company	Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
	companyInfo	Retrieves a CompanyInfo record that is 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.)
	copyDimension	Gets a dimension set that can be applied to the defaultDimension field.
	copyFromVendInvoiceInfoLine
	createMarkupTrans
	data	Retrieves a row from the table. (Inherited from xRecord.)
	dataSource	Retrieves the data source of the table. (Inherited from xRecord.)
	defaultField	Applies the default value to a field.
	defaultRow	Applies a default values to all fields.
	defltDimension	Determines the DimensionDefault value that is associated with this invoice line.
	delete	Implements deletion of an vendor invoice information line.
	deliveryAddress
	deliveryDate
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	discAmount
	discPercent
	displayActionableWorkflowWorkItemIcon
	displayBudgetCheckResult	Gets the image position that displays the BudgetCheckResult value for the given VendInvoiceInfoLine record in the BudgetCheckResult values image list.
	displayBudgetCheckResultText	Gets the text that represents the budget check result value for the VendInvoiceInfoLinerecord.
	displayCommodity
	displayCountryOfOrigin
	displayStateOfOrigin
	displayTriangularDeal
	displayUnitWeight
	dispose	Releases resources that are used by the xRecord object. (Inherited from xRecord.)
	distributionUpdateNeeded	Determines whether a change to the VendInvoiceInfoLine table buffer will update the associated SourceDocumentDistribution table.
	doClear	Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
	documentId
	doDelete	Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
	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.)
	editPurchUnit
	editReasonCode	Gets and sets the reason code by using a ReasonCodeMap object.
	editReasonComment	Gets and sets the reason comment using a ReasonCodeMap object.
	endDisc
	equal	Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
	existsCorrLink_RU	Determines if there is link between this record and corrected record, e.g. this record is correcting record.
	expectedPOAmount	Calculates and returns the product of the invoice quantity times the expected invoice net unit price.
	extendedPriceVarianceAmount	Finds and returns the ExtendedPriceVarianceAmount value from the VendInvoiceMatchingLine record.
	extendedPriceVarianceAmountMST	Finds and returns the ExtendedPriceVarianceAmountMST value from the VendInvoiceMatchingLine record.
	extendedPriceVarianceDisplay
	extendedPriceVarianceIcon	Retrieves an icon that indicates whether there was an extended price variance that is larger than the allowed variance.
	extendedPriceVariancePercent
	externalItemId
	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.)
	getAdvancedPricingInvoiceCalculationId	Gets the attribute-based calculation ID in the table buffer mapped.
	getAllowRedefault	Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
	getBudgetCheckResult	Calculates the BudgetCheckResult value for the given VendInvoiceInfoLine record.
	getDebitCredit
	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.)
	getItemType	Displays the ItemType value for the item.
	getMiscChargesAmount_IN	Gets misc charges 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.)
	getPurchCommitmentLine_PSN	Retrieves the commitment line that is associated with the current invoice 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.)
	grossAmount
	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	Determines whether this invoice line includes tax in the line amount.
	initDefaultAdvancedPricingCalculationId	Initializes the default value of attribute-based calculation ID in the table buffer mapped.
	initDescription
	initFromActive
	initFromAgreementLine	Creates a new VendInvoiceInfoLine table record intialized from the _agreementLine record.
	initFromPriceDisc
	initFromProductDimensions
	initFromPurchAgreementLine	Creates a new VendInvoiceInfoLine table record that is initialized from a specified AgreementLine record.
	initFromPurchLine
	initFromSaved
	initValue	Initializes the current table record.
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert	Optionally sets the status of the corresponding PurchLine to be set to Open order as there is a saved pending invoice against the PurchLine.Optionally activates the Purchase Request workflow.Create a SourceDocumentLine.
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	inventDim
	inventoried	Determines whether the item is tracked in inventory.
	inventSiteChanged_BR	Method called wherever the InventsiteId is changed.
	inventTable
	invoiceNetUnitPrice	Calculates the invoice net unit price by dividing the invoice amount by the invoice quantity.
	isAdvance	Determines whether an invoice is advanced.
	isAdvanceApplication	Indicates whether an invoice line is of type advance application.
	isCategoryBased
	isDirectInvoice	Indicates whether initialization is performed from a Purchase Agreement by checking the value of the AgreementLine and OrigPurchId fields of a VendInvoiceInfoLine buffer.
	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.)
	isInitialized	Determines if the current record has been initialized.
	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.)
	isNonPO	Determines whether an invoice line is associated with a purchase order.
	isPartOfUOWSaveChanges	(Inherited from xRecord.)
	isReverseAdvanceApplication	Indicates whether an invoice line is of type reverse advance application.
	isStocked	Checks whether the invoice line is tracked in inventory.
	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.)
	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.)
	ledgerDim	Determines the LedgerDimension that is associated with this invoice.
	lineAmountExclTax
	lineAmountModified
	lineAmountMST
	lineDisc
	lineDiscExclTax
	lineMatchingPolicy	Retreives the matching policy for this invoice line.
	linePriceVarianceAmount	Calculates and returns the product of the quantity being invoiced times the difference between invoice net unit price and the expected net unit price.
	linkPhysicalTableInstance	Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
	markupAllowed	Indicates whether the associated MarkupTrans table records may be added, changed, or deleted.
	markupLedgerAccount	Returns markup ledger account from the MarkupCode_RU record.
	matchingVarianceIcon	Determines whether the invoice line has either a quantity or price variance and returns an image.
	merge	Merges the current table with the specified table. (Inherited from xRecord.)
	mergeDimension	Gets a dimension set that holds the merged combination of the defaultDimension field and the provided dimension set.
	modifiedClosed
	modifiedCWReceiveNow
	modifiedField
	modifiedField_ServerPost	Executes modifedField logic on the server side.
	modifiedFieldValue	Modifies the specified field to the original value. (Inherited from xRecord.)
	modifiedReceiveNow	Modifies the received data now.
	modifiedReceiveNow_IN	Modifies the received data now.
	modifyInventDim
	moduleType
	mustBeDeducted	Indicates whether the order line must be deducted before an invoice is matched.
	mustBeReceived	Indicates whether the order line must be received before an invoice is matched.
	name	Displays the Name field from the order line for the category based lines.
	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	Updates tax information and the fiscal document texts when the CFOP is changed.
	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.)
	packingSlipId
	packVendInvoiceInfoLine_W	Packs a VendInvoiceInfoLine_W record into this record as an extension.
	parmExchangeRateDate
	parmParentSourceDocumentLine
	parmSourceDocLineTypeEnumName
	parmSourceDocLineTypeEnumValue
	parmSourceDocumentHeader
	pdsCWQtyMatched	Retrieves the total quantity of a matched packing slips for the current invoice line in the catch weight unit of measure.
	pdsCWUnitId	Gets the catch weight unit for the item.
	pdsPurchPrice	Gets the effective unit purchase price 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.)
	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.)
	priceGroupId
	priceVarianceIcon	Retrieves an icon that indicates whether there was a price variance more than the enabled variance.
	priceVariancePercent	Calculates and returns the difference between the expected net unit price and the invoice net unit price expressed as a percentage.
	priceVariancePercentDisplay	Calculates and returns the difference between the expected net unit price and the invoice net unit price expressed as a percentage.
	psaSetRetainage
	purchLine
	purchParmUpdate
	purchQtyMatched	Retrieves the total quantity of a matched packing slips for the current invoice line in the purchasing unit of measure.
	purchTable
	qualityOrderStatusDisplay	Retrieves the status of the associated qualtiy orders.
	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.)
	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.)
	reread	Rereads the record from the table. (Inherited from xRecord.)
	resetDistribution_RU	Removes and regenerates the distributions for the current document.
	resetDistributions	Removes and regenerates the distributions for the current document.
	resetFieldStateForAllFields	Clears the fieldstate of all fields for the Table.
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	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.)
	setAddressFromHeader
	setAddressFromInventDim
	setAddressFromVendTable
	setAdvancedPricingInvoiceCalculationId	Sets the attribute-based calculation ID in the table buffer mapped.
	setAgreementLine	Sets the AgreementLine and CurrencyCode fields when the procurement category is changed for a vendor invoice line.
	setAlcoholLicenseSeriesNum_RU	Updates the AlcoholLicenseSeriesNum_RU field of the current line.
	setCFOP_BR	Sets the default CFOP code and related fields
	setConnection	Sets the user connection for this table. (Inherited from xRecord.)
	setCrossPartition	Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
	setCWRemainAfterInvent
	setFieldValue	Sets the field value in the record buffer. (Inherited from xRecord.)
	setInventDimId	Applies the InventDimId parameter to the VendInvoiceInfoLine.inventDimId field and applies default values.
	setInventDimIdFromInventDim	Gets or sets an InventDimId value for the InventDim parameter and applies the InventDimId value to the VendInvoiceInfoLine.inventDimId field.
	setInventReceiveNow
	setLineAmount
	setLocation
	setPriceAgreement
	setPriceDisc
	setQty
	setRemainAfterInvent
	setSQLTracing	Enables or disables SQL tracing mode. (Inherited from xRecord.)
	setTax1099
	setTaxGroupAndTaxItemGroupFields_BR	Set VendInvoiceInfoLine.TaxGroup and VendInvoiceInfoLine.TaxItemGroup based on TaxesMatrix
	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.)
	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
	taxWithholdCodeType_IN	Gets the tax withhold code type.
	templateName	Gets or sets 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.)
	type	Gets the strategy used for validation and applying default values.
	update	Updates the current record in the database.
	updateAndPackAccessableValue_IN	Update and Pack AccessableValue_IN
	updateDistribution
	usageCount	Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
	useExistingTempDBTable	(Inherited from xRecord.)
	validateAmountByAgreement	Indicates whether the specified vendor invoice line amount fits the corresponding purchase agreement line.
	validateDelete	Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
	validateField
	validateField_ServerPre	Executes validateField logic on the server side.
	validateFieldValue	Validates a field value.
	validateQtyAndAmount
	validateWrite
	validateWrite_ServerPre
	validTimeStateUpdateMode	Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
	vendInvoiceInfoLine_Asset	Finds and returns the VendInvoiceInfoLine_Asset line for the given VendInvoiceInfoLine table buffer, if a line exists.
	vendInvoiceInfoLine_Project	Retrieves a VendInvoiceInfoLine_Project record for the given VendInvoiceInfoLinetable buffer.
	vendInvoiceInfoLine_W	Gets the VendInvoiceInfoLine_W record that is associated with this record.
	vendInvoiceInfoLineCorrLink_RU	Returns VendInvoiceInfoLineCorrLink_RU record for current VendInvoiceInfoLine record.
	vendInvoiceInfoSubTable
	vendInvoiceInfoTable
	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.)
	::checkQuantitySign	Validates that the signs of the supplied quantities are the same.
	::createFromActive	Inserts a new VendInvoiceInfoLine record based on the specified VendInvoiceInfoLinerecord.
	::createFromSaved	Inserts a new VendInvoiceInfoLine record based on the specified VendInvoiceInfoLinerecord.
	::deleteFromPurchParmUpdateNotPending	Delete lines from VendInvoiceInfoLine for a ParmId, but not if they are pending
	::deleteRelated	Deletes all tables which are related to the VendInvoiceInfoLine table.
	::exist	Determines whether the VendInvoiceInfoLine record occurs in the table.
	::existActiveNotSaved	Checks if there are invoice lines in the VendInvoiceInfoLine table that matches specified criteria that do not correspond to draft invoice lines saved in the VendInvoiceInfoLinetable.
	::existAnyPurch	Determines whether any unposted VendInvoiceInfoLine exists for a given PurchId.
	::existDifferentCurrency
	::existPurch
	::existTableRefId
	::existWaitingNotPending	Checks if there are invoice lines in the VendInvoiceInfoLine table that matches specified criteria that do not correspond to draft invoice lines saved in the VendInvoiceInfoLinetable.
	::findByPurchLineRefRecId	Finds the VendInvoiceInfoLine record with the specified PurchLineRecId field value.
	::findInventTransId	Retrieves a VendInvoiceInfoLine record.
	::findRecId	Finds and returns the specified invoice line for the given record ID.
	::findSourceDocumentLine	Finds a VendInvoiceInfoLine record by the SourceDocumentLine field.
	::findTableRefIdInventTransId	Finds and returns the invoice line for the given TableRefId and InventTransId fields.
	::initCorrectedInvoiceLines_RU	Creates links between VendInvoiceInfoLine records for current VendInvoiceInfoTable and VendInvoiceTrans records.
	::moveToSaved	Moves VendInvoiceInfoLine records from their active image to that of its saved image.
	::resetRequestStatus
	::setRequestStatus	Updates the RequestStatus field in the VendInvoiceInfoLine table.
	::updateFromActive	Updates the VendInvoiceInfoLine record from the supplied VendInvoiceInfoLine record, and then links the updated record with the supplied one.

Top

Fields

Field	Type	Configuration key	Description
AccountingDistributionTemplate	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
AdvanceApplicationId	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
AgreementLine_PSN	Extended Data Type: AgreementLineRecId Type: Int64	PublicSector	Reference to the agreement line record (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))
changedManually	Enumeration: NoYes	None	Has the transaction been corrected manually?
closed	Enumeration: NoYes	None	Deliver remainder is set to 0 for a partial update
CountyOrigDest	Extended Data Type: AddressCountyOrigDest Type: String	None	Intrastat county of origin/destination.
CreatedFromLine	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
currencyCode	Extended Data Type: VendCurrencyCode Type: String	None	Current currency code
dataAreaId	Extended Data Type: DataAreaId Type: String	None
DefaultDimension	Extended Data Type: DimensionDefault Type: Int64	LedgerBasic	Default dimensions
DeliveryName	Extended Data Type: VendName Type: String	LedgerBasic	The name that is associated with the selected delivery address
DeliveryPostalAddress	Extended Data Type: LogisticsPostalAddressRecId Type: Int64	None	Reference field in a different table
Description	Extended Data Type: InvoiceLineDescription Type: String	LogisticsBasic	A description of the item that was ordered
InventDimId	Extended Data Type: InventDimId Type: String	None	Identification of dimensions for the item.
InventNow	Extended Data Type: InventQty Type: Real	None	Quantity ordered in the inventory unit.
InventTransId	Extended Data Type: TradeInventTransId Type: String	LogisticsBasic	Identification of the item lot.
InvoiceAccount	Extended Data Type: VendInvoiceAccount Type: String	None	Vendor invoicing the purchase
InvoiceInfoTableRefId	Extended Data Type: TradeLineRefId Type: String	None	Reference between parent and child line.
ItemId	Extended Data Type: ItemId Type: String	LogisticsBasic	Identify item.
LineAmount	Extended Data Type: AmountCur Type: Real	None	Line amount after subtracting discounts
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.
LineType	Enumeration: PurchInvoiceLineType	None	Line type for advance
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
OrderAccount	Extended Data Type: VendAccount Type: String	None	Vendor account number.
OrigPurchId	Extended Data Type: PurchIdOrig Type: String	LogisticsBasic	Purchase that the line is generated from
ParmId	Extended Data Type: ParmId Type: String	None	Number of the reporting (one total update).
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))
PayrollLedgerDimension	Extended Data Type: LedgerDimensionDefaultAccount Type: Int64	LedgerBasic	Default main account used for posting in ledger (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PDSCalculatedUnitPrice	Extended Data Type: PDSCalculatedUnitPrice Type: Real	PDSPotency	The blended adjusted unit price for received potency items. (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))
PdsCWReceiveNow	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))
PdsCWRemainAfter	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))
PdsCWRemainBefore	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))
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
PSAIsFinal	Extended Data Type: NoYesId Type: Enum	PSAAPRetainage	Final invoice. (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))
PSAReleaseAmount	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))
PSAReleasePercent	Extended Data Type: PSAReleasePercent Type: Real	PSAAPRetainage	Release percent of invoice. (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))
PSARetainageAmount	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))
PSARetainageBalance	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))
PSARetainagePercent	Extended Data Type: PSARetainPercent Type: Real	PSAAPRetainage	Retained percent of invoice. (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))
PurchaseLineLineNumber	Extended Data Type: TradeLineNumber Type: Int64	LogisticsBasic	Identifies the line within the purchase order.
PurchCommitmentLine_PSN	Extended Data Type: RefRecId Type: Int64	PurchFrenchRegulatory_PSN	The commitment referred to by this vendor invoice 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), Microsoft Dynamics AX 2012 (FPK))
PurchLineRecId	Extended Data Type: PurchLineRefRecId Type: Int64	None	Reference field in a different table
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
PurchUnit	Extended Data Type: PurchUnit Type: String	None	Unit in which the item is purchased.
ReasonTableRef	Extended Data Type: ReasonRefRecID Type: Int64	None	Contains stored financial reason codes and comments for entered or posted transactions or actions.
ReceiveNow	Extended Data Type: PurchQty Type: Real	LogisticsBasic	Number of purchase units
RecId	Extended Data Type: RecId Type: Int64	None
recVersion	Extended Data Type: RecVersion Type: Integer	None
RemainAfter	Extended Data Type: PurchQty Type: Real	LogisticsBasic	The remaining quantity for the purchase order line not yet product receipt updated
RemainAfterInvent	Extended Data Type: InventQty Type: Real	None	Remaining quantity for the purchase order line not yet product receipt updated in base unit of measure
RemainBefore	Extended Data Type: PurchQty Type: Real	LogisticsBasic	Number of purchase units
RemainBeforeInvent	Extended Data Type: InventQty Type: Real	None	Quantity of the item in inventory unit
RemainBeforeInventPhysical	Extended Data Type: TradeRemainBeforeInventPhysical Type: Real	None	Remaining quantity not yet product receipt updated before the actual update.
RequestStatus	Enumeration: VendInvoiceRequestStatus	None	The status of the review process for the vendor invoice line
SourceDocumentLine	Extended Data Type: SourceDocumentLineRecId Type: Int64	LedgerBasic	Reference field in a different table
StatProcId	Extended Data Type: IntrastatProcId Type: String	ForeignTrade	Code for the current statistical procedure.
TableRefId	Extended Data Type: TradeLineRefId Type: String	None	Reference between parent and child line.
Tax1099Amount	Extended Data Type: Tax1099Amount Type: Real	None	The amount that will be reported on the 1099 form
Tax1099BoxDetail	Extended Data Type: RefRecId Type: Int64	PublicSector	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), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
Tax1099Fields	Extended Data Type: Tax1099FieldsRecId Type: Int64	None	Box code on the 1099 form that the total amount is posted to
Tax1099State	Extended Data Type: Tax1099State Type: String	None	The state where the delivery is made. For G or S boxes, a 1099 tab is available for more details
Tax1099StateAmount	Extended Data Type: Tax1099StateAmount Type: Real	None	The amount that will be reported to the delivery state on the state 1099 form
TaxGroup	Extended Data Type: TaxGroup Type: String	LedgerBasicSalesTax	The name of the sales tax group
TaxItemGroup	Extended Data Type: TaxItemGroup Type: String	LedgerBasicSalesTax	A group of sales tax codes that can be calculated for an item
TaxWithholdGroup	Extended Data Type: TaxWithholdGroup Type: String	LedgerBasicWithholdingTax	Identification of the withholding tax group.
TaxWithholdItemGroupHeadingId	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.
VendDirective_PSN	Extended Data Type: CustVendDirectiveRecId_PSN Type: Int64	PurchFrenchRegulatory_PSN	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))

Top

Field Groups

Field Group	Fields
AutoReport
Advance
Dimension
Discount
AutoSummary
Delivery
MiscCharges
Other
PackingSlip
PDSCalculation
Intrastat
Identification
Inventory
InventoryQuantity
DocumentPreview
ProjectCostPrice
PSAVendPaymentRetentionDetails
PurchaseLineInvoice
PdsCWPurchaseQuantity
Price
PurchaseQuantity
PurchCommitment_PSN
PurchaseLines
Reference
RequestStatus
Setup
SalesTax
SourceDocumentLine
TableGroup
Tax1099GroupFields
TaxWithholdGroup
VSSDiscount
VSSForeignTrade
VSSGeneral
VSSMeasurement

Top

Relations

Relation	Table	Lines
AccountingDistributionTemplate	AccountingDistributionTemplate
AgreementLine	AgreementLine
CountyOrigDest	LogisticsAddressCounty
Currency	Currency
dataAreaId	DataArea
DefaultDimension	DimensionAttributeValueSet
DeliveryPostalAddress_FK	LogisticsPostalAddress
IntrastatPort	IntrastatPort
IntrastatStatProc	IntrastatStatProc
IntrastatTransactionCode	IntrastatTransactionCode
IntrastatTransportMode	IntrastatTransportMode
InventDim_InventDimId	InventDim
InventTable	InventTable
InventTransOrigin	InventTransOrigin
Partition	Partitions
PayrollLedgerDimension	DimensionAttributeValueCombination
ProcurementCategory	EcoResCategory
PurchCommitmentLine_PSN	PurchCommitmentLine_PSN
PurchLine	PurchLine
PurchTable	PurchTable
PurchUnit	UnitOfMeasure
ReasonTableRef	ReasonTableRef
SourceDocumentLine	SourceDocumentLine
Tax1099BoxDetail	Tax1099BoxDetail
Tax1099Fields	Tax1099Fields
Tax1099State	LogisticsAddressState
TaxGroupHeading	TaxGroupHeading
TaxItemGroupHeading	TaxItemGroupHeading
TaxWithholdGroupHeading	TaxWithholdGroupHeading
TaxWithholdItemGroupHeading	TaxWithholdItemGroupHeading_TH
VendDirective_PSN	VendDirective_PSN
VendInvoiceInfoSubTable	VendInvoiceInfoSubTable
VendInvoiceInfoTable	VendInvoiceInfoTable
VendInvoiceJourAdvanceApplicationId	VendInvoiceJour
VendTable_InvoiceAccount	VendTable
VendTable_OrderAccount	VendTable

Top

Indexes

Index	AllowDuplicates	Enabled
AgreementLineIdx	Yes	Yes
InventTransIdx	Yes	Yes
InvoiceInfoTableRefIdx	Yes	Yes
OrigPurchIdIdx	Yes	Yes
ParmIdIdx	Yes	Yes
RecId	No	Yes
SourceDocumentLine	No	Yes
TableRefIdx	No	Yes
Tax1099BoxDetailIdx	Yes	Yes
Tax1099FieldsIdx	Yes	Yes
VendDirective_PSNIdx	Yes	Yes

Top

Inheritance Hierarchy

xRecord Class
Common Table
VendInvoiceInfoLine Table

Share via

VendInvoiceInfoLine Table

Methods

Fields

Field Groups

Relations

Indexes

Inheritance Hierarchy

See Also

Additional resources