VendInvoiceInfoTable Table

The VendInvoiceInfoTable table contains the vendor invoices for one or more purchase orders.

Configuration Key: LedgerBasic

Methods

	Method	Description
	accDistributionTemplateRecId	Determines the AccountingDistributionTemplateRecId value that is associated with the invoice.
	adjustDueDateOnAddressChange	Adjusts the due date on a VendInvoiceInfoTable record to a valid business day if a third-party rule exists.
	adjustDueDateOnPaymentMethodChange	Adjusts the due date on a VendInvoiceInfoTable record to a valid business day if a calendar rule restricted to the payment method exists.
	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.)
	approveVariance	Approves the price and quantity variances for the invoice represented by the current VendInvoiceInfoTable record.
	buf2con	Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	canSubmitToWorkflow
	caption	Gets and sets the caption property of a table. (Inherited from xRecord.)
	cashDiscCode	Determines the CashDiscCode value that is associated with the invoice.
	checkAccountingDate	Validates the accounting date of the current VendInvoiceInfoTable record.
	checkAgreement_RU	Checks if agreement suitable for current invoice
	checkCurrencyCode
	checkIfLines
	checkIfMatched	Indicates whether the invoice that is represented by the current VendInvoiceInfoTable record matches a related purchase order.
	checkIfMatchedIcon	Determines whether the invoice represented by current VendInvoiceInfoTable table record matches the corresponding purchase order.
	checkIfMatchedTotals	Determine whether the difference between the expected totals and the invoice totals exceeds the allowed percentage.
	checkIfVarianceApproved	Determines whether the invoice represented by current VendInvoiceInfoTable record has approved variances.
	checkIfWorkflowCompletedIcon	Determines whether the invoice that is represented by the current VendInvoiceInfoTablerecord has completed the workflow process.
	checkIntrastatFulfillDate_HU	Checks Intrastat fulfillment date.
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	checkMarkupTrans	Validates a MarkupTrans record associated with the current VendInvoiceInfoTablerecord and the corresponding child VendInvoiceInfoSubTable record to post.
	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.)
	cleanupAfterRearrange
	clear
	clearVarianceApproved
	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.)
	copyDimension	Retrieves a dimension set that can be applied to the defaultDimension field..
	copyFromHeader
	copyPaymentSched
	correctionType_RU	Returns type of facture currection for current record.
	createMarkupTrans
	createPaymentSched
	data	Retrieves a row from the table. (Inherited from xRecord.)
	dataSource	Retrieves the data source of the table. (Inherited from xRecord.)
	defaultDimension	Determines the DefaultDimension value that is associated with the invoice.
	defaultField	Applies default value to a field.
	defaultRow	Applies default values to all fields.
	delete	Deletes the VendInvoiceInfoTable table and related tables.
	deleteWithoutDeleteActions	Deletes related tables on the VendInvoiceInfoTable hierarchy below VendInvoiceInfoTable without using cascading delete actions.
	deliveryAddress
	deliveryCNPJCPFNUM_BR	Returns the delivery CNPJ or CPF for the current record.
	deliveryIENum_BR	Returns the delivery IE for the current record.
	deliveryLocation_BR	Retrieves the RecId field of the LogisticsLocation record that is associated with the specified DeliveryPostalAddress record.
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	displayBudgetCheckResult	Gets the image position that displays the BudgetCheckResult enumeration value for the given VendInvoiceInfoTable record in the BudgetCheckResult values image list.
	displayInvoiceStatus	Displays the invoice status of unposted invoices.
	displayPurchID
	displayRemittanceAddress	Gets the vendor remittance address associated with the vendor remittance location on the VendInvoiceInfoTable table.
	dispose	Releases resources that are used by the xRecord object. (Inherited from xRecord.)
	distributionUpdateNeeded	Determines whether a change to the VendInvoiceInfoTable 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.)
	documentDate
	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.)
	editExchRate	Sets or retrieves the current exchange rate.
	editExchRateSecond	Sets or retrieves the secondary exchange rate.
	editIsVendorAdvance
	editPurchID
	equal	Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
	existLine
	existUnallocatedMiscCharge	Indicates whether there are unallocated miscellaneous charges for the current invoice.
	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.)
	firstPackingSlipDate_ES	Returns the earliest delivery date from packing slips matched to current invoice.
	getAccessKey_BR	Retrieves the access key related to the current vendor invoice
	getAllowRedefault	Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
	getBudgetCheckResult	Calculates the BudgetCheckResult value for the given VendInvoiceInfoTable record.
	getDefaultingDependencies	Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
	getEUROTriangulation
	getExchRateDate	Returns the date used to select an exchange rate.
	getExtension	Returns the table extension. (Inherited from xRecord.)
	getFieldValue	Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
	getFiscalEstablishment	Retrieves the fiscal establishments of the current VendInvoiceInfoTable table record.
	getInstanceRelationType	Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
	getLinesItemIds_BR	Returns a list with the names of the items associated with the current vendor invoice
	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.)
	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.)
	hasPrepaymentApplicationLines
	hasRelatedTable	Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
	hasToIssueFiscalDocument_BR	Checks if the fiscal document must be issued by this company for this vendor invoice.
	helpField	Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
	initFromActiveHeader	Initializes the current VendInvoiceInfoTable record with the data in the specified VendInvoiceInfoTable record.
	initFromExchRates
	initFromPurchAgreementHeader_RU	Initiates a VendInvoiceInfoTable record with values based on PurchAgreementHeader record.
	initFromPurchTable
	initFromSavedHeader	Initializes the current VendInvoiceInfoTable record with the data in the specified VendInvoiceInfoTable record.
	initTotals
	initValue	Initializes a field to the default value. (Inherited from xRecord.)
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert	Inserts the current table record into the database.
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	isAdvance	Determines whether an invoice is advance.
	isArranged
	isCancelDocument_BR	Indicates whether this invoice is associated with a cancellation purchase order.
	IsCurrencyCodeDifferentThanCompany_BR	Verifies if the currency code from the current vendor invoice record is different from the currency code of the default company.
	isDirectInvoice	Indicates whether this invoice is associated with a purchase agreement.
	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.)
	isForeignerVendor_BR	Verifies if the vendor is a foreigner.
	isFormDataSource	Indicates whether the data source is a form. (Inherited from xRecord.)
	isForNfe_BR	Tells whether the current vendor invoice is an electronic fiscal document (NF-e)
	isInclTax	Determines whether the invoice includes tax in the line amount.
	isNewRecord	Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
	isNfeNotIssuingNorReversing_BR	Indicates whether the current vendor invoice is a Nf-e federal issued by third party and is not a reversing scenario
	isNonPO	Indicates whether this invoice is associated with a purchase order.
	isPartOfUOWSaveChanges	(Inherited from xRecord.)
	isTempDb	Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
	IsTheFiscalDocumentIssuer_BR	Checks if the fiscal document will be issued by the current fiscal establishment or if a fiscal document issued by this fiscal establishment will be updated.
	isTmp	Indicates whether this is a temporary table. (Inherited from xRecord.)
	joinChild	Finds the join child of the current record. (Inherited from xRecord.)
	joinParent	Finds the join parent of the current record. (Inherited from xRecord.)
	ledgerVoucher	Determines the Voucher value that is associated with the invoice.
	linkPhysicalTableInstance	Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
	lookupPurchId	Implements the custom lookup on the PurchaseId field.
	markupAllowed	Determines whether the associated MarkupTrans records may be added, changed, or deleted.
	merge	Merges the current table with the specified table. (Inherited from xRecord.)
	mergeDimension	Retrieves a dimension set that holds the merged combination of the current defaultDimensionfield in this table and the provided dimension set.
	modifiedField
	modifiedFieldValue	Modifies the specified field to the original value. (Inherited from xRecord.)
	modifieMarkupGroup
	moveToSaved	Moves an active VendInvoiceInfoTable to its saved image.
	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.)
	numberOfLines
	objectOnServer	Determines whether the object is on a server. (Inherited from Object.)
	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
	packVendInvoiceInfoTable_Officials	Packs a VendInvoiceInfoTable_Officials into VendInvoiceInfoTable
	packVendInvoiceInfoTable_RU	Packs a VendInvoiceInfoTable_RU into VendInvoiceInfoTable
	packVendInvoiceInfoTable_W	Packs a VendInvoiceInfoTable_W into VendInvoiceInfoTable
	parmExchangeRateDate
	parmParentSourceDocumentLine
	parmSourceDocHeaderTypeEnumName
	parmSourceDocHeaderTypeEnumValue
	parmSourceDocLineTypeEnumName
	parmSourceDocLineTypeEnumValue
	parmSourceDocumentHeader
	paymDayId
	payment
	paymModeModified
	postCacheLoad	Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
	postingProfile	Determines the CashDiscCode value that is associated with the invoice.
	postLoad	Is executed after a record is read. (Inherited from xRecord.)
	preRemoting	Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.)
	processingTime
	promptCopyTaxGroupToMarkupTrans
	purchParmUpdate
	purchTable
	queryLine
	querySubTable
	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.)
	resetParmId	Sets the ParmId for the VendInvoiceInfoTable and all subTable records
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	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.)
	setAgreement_RU	Initializes record with default dimension for agreement dimension attribute and, if chosen by user, with other data from agreement
	setConnection	Sets the user connection for this table. (Inherited from xRecord.)
	setCrossPartition	Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
	setDatesByFiscalDocumentType_BR	Changes FiscalDocumentType_BR TransDate field looking to InvoiceIssueDate field in FiscalDocumentType_BR and applies this change to DocumentDate field.
	setFieldValue	Sets the field value in the record buffer. (Inherited from xRecord.)
	setInventProfileId_RU	Clears InventProfileId_RU field if InventProfileType_RU not match
	setSQLTracing	Enables or disables SQL tracing mode. (Inherited from xRecord.)
	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.)
	showHeaderTitle	Displays the invoice header title of the VendInvoiceInfoTable table.
	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.)
	sourceDocumentLineExchRateUpdateNeeded	Determines whether a change to the VendInvoiceInfoTable table buffer will update the associated SourceDocumentLine records.
	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	Indicates the date to use when calculating taxes.
	templateName	Gets or sets the DistributionTemplate 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.)
	totalPriceVarianceAmount	Retrieves the sum of the LinePriceVarianceAmount fields for all invoice lines.
	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.
	updateAlcoholLicenseSeriesNum_RU	Updates vendor invoice lines by setting alcohol licenses info.
	updateDate	Indicates whether the TransDate value or DocumentDate value is used when it sets various values to their default value.
	updatedLineDistributionNeeded	Determines whether a change to the PurchTable table will update the record in the AccountingDistribution table that is associated with the PurchLine record.
	updateFromVendLines	Sets values in the VendInvoiceInfoTable table by using a VendInvoiceInfoLine record.
	updateLineAgreementDimension_RU
	updateMarkupTransTaxGroup
	updateParmJobStatusContainErrors
	updateParmJobStatusExecuted
	updateVendInvoiceInfoLine_BR	Updates vendor invoice lines adding default CFOP
	usageCount	Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
	useDocumentDate	Determines whether the TransDate or DocumentDate extended data type should be used when defaulting various values.
	useExistingTempDBTable	(Inherited from xRecord.)
	validateDelete	Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
	validateField	Determines whether the specified field is valid.
	validateFieldValue	(Inherited from xRecord.)
	validateLineDeliveryAddress_BR	Determines whether the delivery address field is valid.
	validateQtyAndAmount
	validateWrite
	validateWrite_ServerPre	Determines whether the current record is valid and ready to be written to the database.
	validTimeStateUpdateMode	Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
	vendInvoiceInfoTable_Officials	Retrieves VendInvoiceInfoTable_Officials extension table record.
	vendInvoiceInfoTable_RU
	vendInvoiceInfoTable_W
	vendInvoiceInfoTableExtensionTH	Get the VendInvoiceInfoTableExtensionTH table.
	vendTable_InvoiceAccount
	vendTable_OrderAccount
	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.)
	::checkIfMatchedOnServer	Indicates whether the invoice that is represented by the current VendInvoiceInfoTable record matches a related purchase order.
	::clearPurchLineReceiveNow	Sets PurchReceivedNow of table PurchLine to 0 for all lines on an invoice.
	::convertPurchTableFieldToVendInvoice
	::createFromActiveHeader	Inserts a new VendInvoiceInfoTable record with the specified VendInvoiceInfoTablerecord.
	::deepCopyFromActiveToSaved	Copies data from the VendInvoiceInfoTable table structure of an active invoice into the table structure of a saved invoice.
	::deepCopyFromActiveToSavedIL	Copies data from the VendInvoiceInfoTable table structure of an active invoice into the table structure of a saved invoice.
	::deepCopyFromSavedToActive	Copies data from the VendInvoiceInfoTable table structure of a saved invoice into the table structure of an active invoice.
	::deepCopyFromSavedToActiveIL	Copies data from the VendInvoiceInfoTable table structure of a saved invoice into the table structure of an active invoice.
	::defaultEUROTriangulation
	::defaultExchRate
	::defaultExchRateSecondary
	::deleteActiveWithoutUpdate
	::deleteAllRelated	Deletes all related tables to the document header and lines.
	::deleteDrafts
	::deleteParmUpdate	Performs necessary cleanup when the process encounters a failure.
	::deletePendingPrepayments	Deletes the pending prepayment VendInvoiceInfoTable records for a purchase order ID provided.
	::deleteRelated	Deletes all tables which are related to the VendInvoiceInfoTable table except for the VendInvoiceInfoSubTable table.
	::deleteTableRefId	Deletes an invoice for the given ParmId and TableRefId fields.
	::exist	Determines if the invoice exists in the table for the given ParmId and TableRefId fields.
	::existActive	Checks whether an active invoice occurs in the VendInvoiceInfoTable table
	::existActiveNoLines	Indicates whether there is an active invoice header for the specified TableRefId or PurchId records.
	::existActivePurchId	Determines whether a purchase order has an invoice being edited for posting.
	::existActiveTableRefId	Determines whether there is an active invoice header for the specified TableLineRefId record.
	::existPrepayPendingForPurchOrder	Checks whether a pending prepayment invoice exists for the specified purchase order ID.
	::existSaved	Checks whether a saved invoice exists in the VendInvoiceInfoTable table
	::find	Finds and returns the invoice for the given ParmId and TableRefId fields, if one exists.
	::findDeliveryInformation
	::findPurchId
	::findRecId	Finds and returns the invoice table record for the given record ID.
	::findSourceDocumentHeader	Finds a VendInvoiceInfoTable record based on the record ID of a SourceDocumentHeaderrecord.
	::findSourceDocumentLine	Finds a VendInvoiceInfoTable record based on the record ID a SourceDocumentLinerecord.
	::getActiveList	Retrieves a list of the active invoices for the given PurchId.
	::initPurchTableFromNonPO
	::lookupVendInvoiceGroup
	::moveInvoiceToSaved	Moves data from the VendInvoiceInfoTable table structure of an active invoice into that of a saved invoice.
	::rearrangeInitFromPO
	::resetRequestStatus
	::setMatchStatus	Updates the MatchStatus field in the specified VendInvoiceInfoTable record.
	::setRequestStatus	Updates the RequestStatus field in the specified VendInvoiceInfoTable record.
	::updateFromActive	Updates the VendInvoiceInfoTable record from the specified VendInvoiceInfoTablerecord.
	::updateWorkFlowRequestStatus	Updates the Request status field for the original record exists for the Invoice
	::updateWorkflowTrackingStatus	Updates the ContextRecId ID of the WorkflowTrackingStatusTable table for a vendor invoice.
	::warningInvoiceInUse	Provides message indicating that one of the invoices is in use.

Top

Fields

Field	Type	Configuration key	Description
AccountingDistributionTemplate	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
Approved	Extended Data Type: Approved Type: Enum	None	Has transaction been approved?
Approver	Extended Data Type: HcmApprover Type: Int64	None	Worker who approved the record.
BankLCImportLine	Extended Data Type: BankLCLineRefRecId Type: Int64	BankDocument	The shipment number of shipment details.
BatchAdministration	Extended Data Type: BatchAdministration Type: Enum	None	Run batch administration?
CashDisc	Extended Data Type: VendCashDiscAmount Type: Real	None	Cash discount granted when payment is made before a given date.
CashDiscCode	Extended Data Type: VendCashDiscCode Type: String	LedgerBasic	The code for the cash discount that will be included on the invoice
CashDiscDate	Extended Data Type: VendCashDiscDate Type: Date	None	Cash discount date to be used when creating vendor transaction.
CashDiscPercent	Extended Data Type: DiscPct Type: Real	None	Discount in percentage.
CountyOrigDest	Extended Data Type: AddressCountyOrigDest Type: String	None	Intrastat county of origin/destination.
createdBy	Extended Data Type: CreatedBy Type: String	None
createdDateTime	Extended Data Type: CreatedDateTime Type: UtcDateTime	None
CurrencyCode	Extended Data Type: VendCurrencyCode Type: String	None	Currency the purchase is invoiced in.
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: InvoiceDescription Type: String	None	The description of the invoice
DocumentDate	Extended Data Type: DocumentDate Type: Date	None	The date of external document
DocumentNum	Extended Data Type: DocumentNum Type: String	None	Number of the document that generated the transaction
DocumentOrigin	Enumeration: DocumentOrigin	None	The source of the document
EndDateTime	Extended Data Type: EndDateTime Type: UtcDateTime	None	End Datetime help text
EndDisc	Extended Data Type: PurchEndDiscAmount Type: Real	PriceDisc	Total invoice discount
EnterpriseNumber	Extended Data Type: TaxEnterpriseNumber Type: String	None	Enterprise number used to identify Belgian companies.
EUROTriangulation	Extended Data Type: EUROTriangulation Type: Enum	None	Specify whether the exchange rate is included in triangulation.
ExchRate	Extended Data Type: VendExchRate Type: Real	None	Exchange rate of invoice currency (%1 = 1.0)
ExchRateSecondary	Extended Data Type: ExchrateSecondary Type: Real	None	Rate of the secondary part of the currency calculation, when triangulation is used
FixedDueDate	Extended Data Type: PurchFixedDueDate Type: Date	LogisticsBasic	The due date is independent of the terms of payment.
FixedExchRate	Extended Data Type: FixedExchRate Type: Enum	None	Specify whether fixed exchange rate is to be used.
Hold	Extended Data Type: Hold Type: Enum	None	If selected, the invoice document will be saved but not posted
IgnoreCalculatedSalesTax	Enumeration: NoYes	LedgerBasicSalesTax	If selected, only actual sales tax amounts received on electronic PO invoices are used
InclTax	Extended Data Type: InclTax Type: Enum	LogisticsBasic	Do prices include sales tax?
InventLocationId	Extended Data Type: PurchInventLocationId Type: String	LogisticsBasic	Identify the warehouse.
InventSiteId	Extended Data Type: InventSiteId Type: String	LogisticsBasic	Identify the site
InvoiceAccount	Extended Data Type: VendInvoiceAccount Type: String	None	Vendor invoicing the purchase
InvoiceReleaseDate	Extended Data Type: InvoiceReleaseDate Type: UtcDateTime	None	The date when the hold is released for the invoice payment
InvoiceRoundOff	Extended Data Type: RoundOff Type: Real	None	Rounding-off of invoice amount.
InvoiceType	Enumeration: PurchInvoiceType	None	The type of invoice submitted by the vendor
LastMatchVariance	Extended Data Type: LastMatchVariance Type: Enum	PurchInvoiceMatching	The result of invoice matching the last time the document was saved
ListCode	Extended Data Type: ListcodeId Type: Enum	ForeignTrade	List code to be used with the EU sales list. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Log	Extended Data Type: LogText Type: String	None	Log error messages
LogisticsElectronicAddress	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
MarkupGroup	Extended Data Type: VendMarkupGroupId Type: String	Markup	Charges group attached to the purchase
MatchStatus	Enumeration: VendInvoiceMatchStatus	None
Num	Extended Data Type: Num Type: String	None	Invoice number
NumberSequenceGroup	Extended Data Type: NumberSequenceGroupId Type: String	None	Group for allocation of different number sequences to different customers/vendors.
OrderAccount	Extended Data Type: VendAccount Type: String	None	Vendor account number.
Ordering	Enumeration: DocumentStatus	None	Description of the current document type.
ParmId	Extended Data Type: ParmId Type: String	None	Number of the reporting (one total update).
ParmJobStatus	Enumeration: ParmJobStatus	None	Status of the current 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))
Payment	Extended Data Type: VendPaymTermId Type: String	LedgerBasic	Terms of payment for the received invoice
PaymentSched	Extended Data Type: PaymSchedId Type: String	PaymSched	Select the payment plan that may have been set up with the vendor for the current purchase order
PaymId	Extended Data Type: PaymId Type: String	LedgerBasic	Payment identification used for the payment of invoices
PaymMode	Extended Data Type: VendPaymMode Type: String	LedgerBasic	The method of payment for the vendor
PaymSpec	Extended Data Type: PaymSpec Type: String	None	The specification code for the selected method of payment
PoolRecId	Extended Data Type: LedgerJournalTransRefRecId Type: Int64	None	Reference field in a different table
Port	Extended Data Type: IntrastatPortId Type: String	ForeignTrade	Port where current delivery is loaded.
PostingProfile	Extended Data Type: VendPostingProfile Type: String	None	Posting profile being processed.
PurchAgreementHeader_PSN	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))
PurchId	Extended Data Type: PurchId Type: String	LogisticsBasic	Identification of the purchase.
PurchName	Extended Data Type: PurchName Type: String	LogisticsBasic	Purchase description
ReCalculate	Enumeration: boolean	None
RecId	Extended Data Type: RecId Type: Int64	None
recVersion	Extended Data Type: RecVersion Type: Integer	None
ReleaseDateComment	Extended Data Type: ReleaseDateComment Type: String	None	Provide an optional comment for the release date
RemittanceLocation	Extended Data Type: RemittanceLocation Type: Int64	None	The remittance address location name
RequestStatus	Enumeration: VendInvoiceRequestStatus	None	The status of the review process for the vendor invoice
SettleVoucher	Extended Data Type: PurchSettlementType Type: Enum	LogisticsBasic	Specify if voucher should be settled.
SourceDocumentHeader	Extended Data Type: SourceDocumentHeaderRecId Type: Int64	LedgerBasic	Reference field in a different table
SourceDocumentLine	Extended Data Type: SourceDocumentLineRecId Type: Int64	LedgerBasic	Reference field in a different table
StartDateTime	Extended Data Type: StartDateTime Type: UtcDateTime	None	Start DateTime help text
StatProcId	Extended Data Type: IntrastatProcId Type: String	ForeignTrade	Code for the current statistical procedure.
Storno	Enumeration: NoYes	None	Correction +/- (Debit/Credit) to transaction
TableRefId	Extended Data Type: TradeLineRefId Type: String	None	Reference between parent and child line.
TaxGroup	Extended Data Type: TaxGroup Type: String	LedgerBasicSalesTax	Sales tax group for calculation of sales tax on purchase
TaxRoundOff	Extended Data Type: TaxAmountCur Type: Real	LedgerBasicSalesTax	Rounding in relation to sales tax amount of invoice
TransactionCode	Extended Data Type: IntrastatTransactionCodeId Type: String	ForeignTrade	Code for the current transaction code.
TransDate	Extended Data Type: TransDate Type: Date	None	Transaction date
Transport	Extended Data Type: IntrastatTransport Type: String	ForeignTrade	Specify means of transport for the current order.
TransportationDocument	Extended Data Type: TransportationDocumentRecId Type: Int64	None	Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VarianceApproved	Extended Data Type: VarianceApproved Type: Enum	PurchInvoiceMatching	If selected, invoices with matching errors are approved for posting
VarianceApprovedDateTime	Extended Data Type: VarianceApprovedDateTime Type: UtcDateTime	PurchInvoiceMatching	The date and time that the invoice was approved to post with matching discrepancies
VarianceApprover	Extended Data Type: HcmApprover Type: Int64	None	Worker who approved the record.
VarianceComment	Extended Data Type: VarianceComment Type: String	PurchInvoiceMatching	Enter a comment associated with the approval of posting with matching discrepancies
VATNum	Extended Data Type: VATNumJournal Type: String	LedgerBasicSalesTax	Tax exempt identification number
VendBankAccountID	Extended Data Type: VendBankAccountId Type: String	Bank	The bank account for the vendor
VendInvoiceGroup	Extended Data Type: VendInvoiceGrouping Type: String	None	The group that this invoice belongs to
VendInvoiceSaveStatus	Enumeration: VendInvoiceSaveStatus	None	Indicates whether the invoice document has been created (New) or if it has been saved (Pending)
VendorRequestedWorkerEmail	Extended Data Type: Email Type: String	None	The e-mail address of the requested approver for the invoice
VendPaymentGroup	Extended Data Type: VendPaymentGrouping Type: String	None	The common code by which transactions are grouped for payment

Top

Field Groups

Field Group	Fields
ForeignTrade
Administration
Approved
Amount
AutoReport
AutoSummary
BankLCImportGroup
BankManagement
CashDiscount
Correction
Currency
CurrencyShow
Dimension
Document
Delivery
DocumentPreview
FixedDueDate
Identification
ImportDeclaration_BR
Inventory
LogisticsElectronicAddress
OtherDates
Posting_RU
Prepay
InvoiceDetails
PaymentInvoice
Posting
Payment
InvoiceGrouping
ProcessingTime
PurchaseTable
RequestStatus
SalesTax
Remittance
SourceDocument
VarianceApproval
Vendor
VSSDeliveryAddress
VSSDiscount
VendPaymentGroup
VSSForeignTrade
VSSGeneral
VSSElectronicAddress
VSSCurrency
VSSOtherInvoiceDetails
VSSPayment
VSSInvoicDates
VSSRemittance
VSSInventory
VSSInvoiceDetails
VSSSalesTax

Top

Relations

Relation	Table	Lines
AccountingDistributionTemplate	AccountingDistributionTemplate
Approver_FK	HcmWorker
BankLCImportLine	BankLCImportLine
CashDisc	CashDisc
CountyOrigDest	LogisticsAddressCounty
Currency	Currency
dataAreaId	DataArea
DefaultDimension	DimensionAttributeValueSet
DeliveryPostalAddress_FK	LogisticsPostalAddress
IntrastatPort	IntrastatPort
IntrastatStatProc	IntrastatStatProc
IntrastatTransactionCode	IntrastatTransactionCode
IntrastatTransportMode	IntrastatTransportMode
InventLocation	InventLocation
InventSite	InventSite
LedgerJournalTrans	LedgerJournalTrans
LogisticsElectronicAddress_FK	LogisticsElectronicAddress
MarkupGroup	MarkupGroup
NumberSequenceGroup	NumberSequenceGroup
Partition	Partitions
PaymSched	PaymSched
PaymTerm	PaymTerm
PurchAgreementHeader_PSN	PurchAgreementHeader
PurchParmUpdate	PurchParmUpdate
PurchTable_PurchId	PurchTable
RemittanceLocation_FK	LogisticsLocation
SourceDocumentHeader	SourceDocumentHeader
SourceDocumentLine	SourceDocumentLine
TaxGroupHeading	TaxGroupHeading
TaxWorkRegulation	TaxWorkRegulation
TransportationDocument	TransportationDocument
VarianceApprover_FK	HcmWorker
VendBankAccount	VendBankAccount
VendInvoiceInfoTable	VendInvoiceInfoTable
VendLedger	VendLedger
VendPaymModeSpec	VendPaymModeSpec
VendPaymModeTable	VendPaymModeTable
VendTable_InvoiceAccount	VendTable
VendTable_OrderAccount	VendTable

Top

Indexes

Index	AllowDuplicates	Enabled	Fields
ApproverIdx	Yes	Yes
DEL_PostingProfile_RU_Idx	Yes	Yes
ParmIdPurchIdIdx	Yes	Yes
PurchAgreementHeader_PSNIdx	Yes	Yes
PurchIdx	Yes	Yes
RecId	No	Yes
SDHeaderIdx	No	Yes
SDLineIdx	No	Yes
TableRefIdx	No	Yes
VarianceApproverIdx	Yes	Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    VendInvoiceInfoTable Table

See Also

Table Methods

Tables Overview