VendTable Table

The VendTable table contains vendors for accounts payable.

Configuration Key: LedgerBasic

Methods

  Method Description
Gg951840.pubmethod(en-us,AX.60).gif address_BR Gets logistics postal address for this vendor
Gg951840.pubmethod(en-us,AX.60).gif addressComplement_BR Gets the building name of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif balanceAllCurrency
Gg951840.pubmethod(en-us,AX.60).gif balanceCurPerDate
Gg951840.pubmethod(en-us,AX.60).gif balanceCurrency
Gg951840.pubmethod(en-us,AX.60).gif balanceMarked_RU Calculates pending (marked, but not not settled yet) settlement amounts for vendor for current document with regards to contract (agreement)
Gg951840.pubmethod(en-us,AX.60).gif balanceMST
Gg951840.pubmethod(en-us,AX.60).gif balancePerDate
Gg951840.pubmethod(en-us,AX.60).gif bankAccountNum Looks up the account number of the bank account that is referenced by the BankAccount field in this table.
Gg951840.pubmethod(en-us,AX.60).gif blockedReasonCode Retrieves a ReasonCode value for the most recent update of the OfficeAddinAccountStructureView blocked field.
Gg951840.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif canAutoCreatePurchOrder Specifies whether change management enabling is mandatory for purchase orders created for the vendor.
Gg951840.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Indicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif cashDiscName
Gg951840.pubmethod(en-us,AX.60).gif checkAccountBlocked Determines whether the vendor account for possible vendor hold.
Gg951840.pubmethod(en-us,AX.60).gif checkBlockedAll
Gg951840.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif checkInvoice
Gg951840.pubmethod(en-us,AX.60).gif checkPackingSlip
Gg951840.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif checkRelatedAgreement_RU Validates if intercompany agreement exists.
Gg951840.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif checkTaxInvoice Checks whether specified tax invoice number can be used.
Gg951840.pubmethod(en-us,AX.60).gif checkVATNumUsed
Gg951840.pubmethod(en-us,AX.60).gif cityName_BR Gets the city name of primary address
Gg951840.pubmethod(en-us,AX.60).gif clear Removes all rows from the table buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif clearingLedgerDimension
Gg951840.pubmethod(en-us,AX.60).gif clearingLedgerDimensionGroup
Gg951840.pubmethod(en-us,AX.60).gif clearingPeriod
Gg951840.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif companyInfo Retrieves a CompanyInfo record that is associated with the current record.
Gg951840.pubmethod(en-us,AX.60).gif compositionScheme Retrieves the tax related composite scheme information.
Gg951840.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif ContactPerson Looks up the related ContactPerson table.
Gg951840.pubmethod(en-us,AX.60).gif contactPersonPhone Gets the phone for the contact person.
Gg951840.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif copyDimension Retrieves a dimension set that can be applied to the defaultDimension field on this table.
Gg951840.pubmethod(en-us,AX.60).gif countryRegionId Retrieves the CountryRegionId value from the logisticsPostalAddress table.
Gg951840.pubmethod(en-us,AX.60).gif countryRegionName
Gg951840.pubmethod(en-us,AX.60).gif countyName
Gg951840.pubmethod(en-us,AX.60).gif creditMaxCur
Gg951840.pubmethod(en-us,AX.60).gif currencyName
Gg951840.pubmethod(en-us,AX.60).gif customerAccountName
Gg951840.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif defaultField Populates default values in a field in the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif defaultRow Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif delete Deletes the current record from the database.
Gg951840.pubmethod(en-us,AX.60).gif deliveryAddress Gets the delivery address of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif DirPartyTable Looks up the related DirPartyTable table.
Gg951840.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif displayVendName Retrieves the name of the vendor account for the current purchase agreement header record.
Gg951840.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif districtName_BR Gets the the district name of the vendor's primary address
Gg951840.pubmethod(en-us,AX.60).gif dlvModeName
Gg951840.pubmethod(en-us,AX.60).gif doClear Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif doDelete Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif doInsert Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif doUpdate Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif editBlockedReasonCode
Gg951840.pubmethod(en-us,AX.60).gif editContactPersonName
Gg951840.pubmethod(en-us,AX.60).gif editCustAccount Gets or sets the customer account number associated with the current vendor.
Gg951840.pubmethod(en-us,AX.60).gif editVendExceptionGroupId Gets and sets the VendInvoiceExceptionGroup table.
Gg951840.pubmethod(en-us,AX.60).gif email
Gg951840.pubmethod(en-us,AX.60).gif endDiscName
Gg951840.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif exceedMax
Gg951840.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif firstOpenPayment
Gg951840.pubmethod(en-us,AX.60).gif firstSettledPayment
Gg951840.pubmethod(en-us,AX.60).gif freeValueCur
Gg951840.pubmethod(en-us,AX.60).gif freeValueMST
Gg951840.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getPhysicalTableName Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getSettleDate
Gg951840.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getStructDepartment_RU Implementation of \Data Dictionary\Maps\CustVendTable\Methods\getStructDepartment_RU
Gg951840.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif getTaxInformationVendTable_IN get TaxInformation of Vend.
Gg951840.pubmethod(en-us,AX.60).gif getTaxWithholdGroup Gets the withholding tax group of current vendor.
Gg951840.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif graphicsByAgeAllocate
Gg951840.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif hasCurrentActivity Finds the last VendTable record transaction date.
Gg951840.pubmethod(en-us,AX.60).gif hasForecastPurch
Gg951840.pubmethod(en-us,AX.60).gif hasInventOwnerTrans_RU Validates if related owner transactions exist.
Gg951840.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif highestBalance Displays the highest balance available for a selected vendor.
Gg951840.pubmethod(en-us,AX.60).gif initFromVendGroup
Gg951840.pubmethod(en-us,AX.60).gif initValue Initializes field values in a new VendTable record.
Gg951840.pubmethod(en-us,AX.60).gif initValue_BR Initializes brazilian field
Gg951840.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif insert Inserts the current record into the database.
Gg951840.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif interCompanyTradingPartner Finds the specified record in the InterCompanyTradingPartner table that is based on the current vendor.
Gg951840.pubmethod(en-us,AX.60).gif interCompanyTradingPartnerAccount Finds the account ID of the corresponding customer for the current vendor intercompany trading relation.
Gg951840.pubmethod(en-us,AX.60).gif interCompanyTradingPartnerCompanyID Finds the company ID of the corresponding customer for the current vendor intercompany trading relation.
Gg951840.pubmethod(en-us,AX.60).gif interCompanyTradingPartnerCustomer Finds the trading partner for the corresponding customer of the current vendor intercompany trading relation.
Gg951840.pubmethod(en-us,AX.60).gif interCompanyTradingRelationActive Checks whether the current vendor is in an active intercompany trading relation.
Gg951840.pubmethod(en-us,AX.60).gif invoiceAccountLocation Gets the invoice location of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif invoiceAccountName
Gg951840.pubmethod(en-us,AX.60).gif invoiceAddress
Gg951840.pubmethod(en-us,AX.60).gif invoiceAverage Displays the average amount of invoices for a selected vendor.
Gg951840.pubmethod(en-us,AX.60).gif invoiceLocation Gets the invoice address of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif isDiverse Indicates whether a vendor has any diversity flag set on their profile.
Gg951840.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif isForeign Indicates whether a vendor is foreign.
Gg951840.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif isGTA Indicates whether a vendor is GTA.
Gg951840.pubmethod(en-us,AX.60).gif isNewRecord Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif isPaymFeeCovered_JP Checks whether bank fee is covered from vendor.
Gg951840.pubmethod(en-us,AX.60).gif isPreferential Indicates whether a vendor is a Preferential.
Gg951840.pubmethod(en-us,AX.60).gif isSSI Indicates whether a vendor is SSI.
Gg951840.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif languageId
Gg951840.pubmethod(en-us,AX.60).gif lastInvoice
Gg951840.pubmethod(en-us,AX.60).gif lastInvoiceDate Gets the last invoice date for the selected vendor.
Gg951840.pubmethod(en-us,AX.60).gif lastInvoiceTotal Gets the invoice amount on the last date for the selected vendor.
Gg951840.pubmethod(en-us,AX.60).gif lastPayment
Gg951840.pubmethod(en-us,AX.60).gif lastPaymentAmount Gets the amount last paid by the selected vendor.
Gg951840.pubmethod(en-us,AX.60).gif lastPaymentDate Gets the date on which the last payment was made for the selected vendor.
Gg951840.pubmethod(en-us,AX.60).gif lineDiscName
Gg951840.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif mcrAddress Displays the postal address of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif mcrDefaultDeliveryPostalAddress Gets the default postal address record on the vendor.
Gg951840.pubmethod(en-us,AX.60).gif mcrDisplayPartyName Displays the name of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif mcrDisplayPostalAddress Displays the primary postal address of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif mcrFindOrCreateEmail Gets or sets the email of the VendTable record.
Gg951840.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif mergeDimension Retrieves a dimension set that holds the merged combination of the current defaultDimensionfield on this table and the provided dimension set.
Gg951840.pubmethod(en-us,AX.60).gif modifiedField
Gg951840.pubmethod(en-us,AX.60).gif modifiedField_BR Performs different actions depending on the field that was modified.
Gg951840.pubmethod(en-us,AX.60).gif modifiedFieldValue Modifies the specified field to the original value. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif multiLineDiscName
Gg951840.pubmethod(en-us,AX.60).gif name
Gg951840.pubmethod(en-us,AX.60).gif nameAlias
Gg951840.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif openBalanceCur
Gg951840.pubmethod(en-us,AX.60).gif openBalanceMST
Gg951840.pubmethod(en-us,AX.60).gif openBalanceMSTDoc
Gg951840.pubmethod(en-us,AX.60).gif openBalanceMSTDue
Gg951840.pubmethod(en-us,AX.60).gif openBalanceMSTPerAgreement_RU Calculate open vendor balance with regards to contract (agreement)
Gg951840.pubmethod(en-us,AX.60).gif openInvoiceBalanceMST
Gg951840.pubmethod(en-us,AX.60).gif openInvoiceBalanceMSTDoc
Gg951840.pubmethod(en-us,AX.60).gif openInvoiceBalanceMSTDue
Gg951840.pubmethod(en-us,AX.60).gif openPaymentBalanceMST
Gg951840.pubmethod(en-us,AX.60).gif openPaymentBalanceMSTDoc
Gg951840.pubmethod(en-us,AX.60).gif openPaymentBalanceMSTDue
Gg951840.pubmethod(en-us,AX.60).gif organizationNumber Retrieves the organization number for the vendor.
Gg951840.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif parmOffsetAccount
Gg951840.pubmethod(en-us,AX.60).gif partyINN_RU Accessor method to party attributes.
Gg951840.pubmethod(en-us,AX.60).gif partyINNasOfDate_RU Accessor method to party attributes with respect to date effectivity.
Gg951840.pubmethod(en-us,AX.60).gif partyKPPasOfDate_RU Accessor method to party attributes with respect to date effectivity.
Gg951840.pubmethod(en-us,AX.60).gif partyOKATOasOfDate_RU Accessor method to party attributes with respect to date effectivity.
Gg951840.pubmethod(en-us,AX.60).gif partyOKDPasOfDate_RU Accessor method to party attributes with respect to date effectivity.
Gg951840.pubmethod(en-us,AX.60).gif partyOKPO_RU Accessor method to party attributes.
Gg951840.pubmethod(en-us,AX.60).gif partyOKPOasOfDate_RU Accessor method to party attributes with respect to date effectivity.
Gg951840.pubmethod(en-us,AX.60).gif partyType
Gg951840.pubmethod(en-us,AX.60).gif paymentType Retrieves the type of payment associated with the selected method of payment.
Gg951840.pubmethod(en-us,AX.60).gif paymName
Gg951840.pubmethod(en-us,AX.60).gif phone
Gg951840.pubmethod(en-us,AX.60).gif phoneLocal
Gg951840.pubmethod(en-us,AX.60).gif postalAddress
Gg951840.pubmethod(en-us,AX.60).gif postCacheLoad Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif 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.)
Gg951840.pubmethod(en-us,AX.60).gif previewPaneTitle
Gg951840.pubmethod(en-us,AX.60).gif priceDiscGroupName
Gg951840.pubmethod(en-us,AX.60).gif purchLedgerDimension
Gg951840.pubmethod(en-us,AX.60).gif purchOffsetLedgerDimension
Gg951840.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif queryTimeout Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif 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.)
Gg951840.pubmethod(en-us,AX.60).gif recordLevelSecurity Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif renamePrimaryKey Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table.
Gg951840.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif selectForUpdate Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setInventProfileId_RU Update Inventory profile based on Inventory profile type
Gg951840.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif settlementBuffer
Gg951840.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif showContactPerson
Gg951840.pubmethod(en-us,AX.60).gif showPartyMatchIcon
Gg951840.pubmethod(en-us,AX.60).gif skipAosValidation Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif skipDeleteActions Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif skipEvents Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif skipPostLoad Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif 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.)
Gg951840.pubmethod(en-us,AX.60).gif stateName
Gg951840.pubmethod(en-us,AX.60).gif streetName_BR Gets the street name of the vendor's primary address
Gg951840.pubmethod(en-us,AX.60).gif streetNumber_BR Gets the streetnumber of the vendor.
Gg951840.pubmethod(en-us,AX.60).gif subscriptionType_BR
Gg951840.pubmethod(en-us,AX.60).gif summaryLedgerDimension
Gg951840.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif taxGroupName
Gg951840.pubmethod(en-us,AX.60).gif telefax
Gg951840.pubmethod(en-us,AX.60).gif telex
Gg951840.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif transBuffer
Gg951840.pubmethod(en-us,AX.60).gif transOpenBuffer
Gg951840.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif ttsbegin Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif update
Gg951840.pubmethod(en-us,AX.60).gif updateInventOwnerRelation_RU Update owner-customer relation for the customer that refers to the same party as current vendor
Gg951840.pubmethod(en-us,AX.60).gif updateOffsetAccount
Gg951840.pubmethod(en-us,AX.60).gif url
Gg951840.pubmethod(en-us,AX.60).gif usageCount Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif validateCNAE_BR validate if CNAE inforamtion is correctly informed
Gg951840.privmethod(en-us,AX.60).gif validateCNPJCPF_BR
Gg951840.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database.
Gg951840.pubmethod(en-us,AX.60).gif validateField Determines whether the p1 field is valid.
Gg951840.pubmethod(en-us,AX.60).gif validateField_BR Validates brazilian fields
Gg951840.pubmethod(en-us,AX.60).gif validateFieldValue (Inherited from xRecord.)
Gg951840.privmethod(en-us,AX.60).gif validateIENum_BR validate if IE inforamtion is correctly informed
Gg951840.pubmethod(en-us,AX.60).gif validateIRSData
Gg951840.privmethod(en-us,AX.60).gif validateVendContactPerson
Gg951840.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written to the database.
Gg951840.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif vendBankAccount_BR
Gg951840.pubmethod(en-us,AX.60).gif vendBankAgency_BR
Gg951840.pubmethod(en-us,AX.60).gif vendBankcode_BR
Gg951840.pubmethod(en-us,AX.60).gif vendBankDAC_BR
Gg951840.pubmethod(en-us,AX.60).gif vendCNPJ_BR
Gg951840.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg951840.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif write Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg951840.pubmethod(en-us,AX.60).gif zipCode_BR Gets the zipcode fo vendor's primary address
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::addFilterToExcludeBlockedForPurchasing Adds the query range filters to the specified query to filter out vendors that are blocked for purchasing.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::blocked
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::blockedReleaseDate Gets the BlockedReleaseDate field value.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::calcHighestBalance Calculates the highest balance available for a selected vendor.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::calcInvoiceAverage Calculates the average amount of invoices for a selected vendor.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::canVendorBeUpdated
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::changeDefaultAccounts
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::checkCreditLimit
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::checkExist Indicates whether the specified record exists in the VendTable table and displays a message if the record does not exist.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::checkExistAndOpen Checks the vendor account against the vendor hold and also if the account exists.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::checkW9Received Determines whether the W9 form has been received for the vendor with the vendor account passed in.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::compositionSchemeEnabled Retrieves the composite scheme status.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::createOneTimeAccount
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::createOneTimeAccountValidate
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::exist
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::find
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::findByCompany Finds the specified record in the VendTable table.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::findByDataAreaId Finds the specified record in the VendTable table.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::findByLedgerDimension
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::findByPartyInCompany Finds the specified record in the VendTable table.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::findByPartyRecId
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::findRecId
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::getDefaultRemittanceLocation Gets the default check remittance address for a vendor.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::getVendorName Gets the name of the party of the specified vendor that is in a specified data area.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::groupId
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::isVendorBlocked Indicates whether the vendor is blocked.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::isVendReleaseDateExpired Checks the validity of a vendor release date for possible vendor hold.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::jumpRefAccountNum_SA Provides the Go To Main Table functionality for the VendTable table.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::jumpRefVendor Opens the VendTable form for the specific vendor in the specific data area
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::lookupAccountNumCurrencyDeal_RU Create Vendor lookup for vendors that are also banks
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::lookupGTAVendor_IN Lookup GTA vender information.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::lookupNonLedgerDefaultAccountNum
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::lookupVendAccountItem
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::lookupVendor
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::lookupVendTable Provides a lookup for the VendTable table.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::promptAddress
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::txtNotExist Gets the message to use when a specific record in the VendTable table does not exist.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::updateOnHold
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::validateCISNationalInsuranceNum Validates the value of CISNationalInsuranceNum field as per the defined pattern.
Gg951840.pubmethod(en-us,AX.60).gifGg951840.static(en-us,AX.60).gif ::validateCISVerificationNum Validates the value of CISVerificationNum feild as per the defined pattern.

Top

Fields

Field Type Configuration key Description
AccountNum Extended Data Type: VendAccount
Type: String
None Vendor account number.
BankAccount Extended Data Type: VendBankAccountId
Type: String
Bank Identify vendor's bank account.
BankCentralBankPurposeCode Extended Data Type: BankCentralBankPurposeCode
Type: String
LedgerBasic Code used when reporting to the central bank.
BankCentralBankPurposeText Extended Data Type: BankCentralBankPurposeText
Type: String
LedgerBasic Describe code used when reporting to the central bank.
BankCentralBankTransTypeCur_RU Extended Data Type: BankCentralBankTransTypeCur_RU
Type: String
Bank Currency operation code according to central bank. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
BankOrderOfPayment_RU Extended Data Type: BankOrderOfPayment_RU
Type: String
Bank Order of payment: operating, tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
BidOnly Extended Data Type: VendBidOnly
Type: Enum
LedgerBasic Specify whether the vendor submits quotations and proposals to you, but you have not purchased from the vendor
BirthCountyCode_IT Extended Data Type: AddressCountyCode_IT
Type: String
None Enter birth province of the vendor
BirthDate Extended Data Type: TransDate
Type: Date
None Enter birth date of the vendor. Used in Certification report.
BirthPlace Extended Data Type: AddressCity
Type: String
LedgerBasic Enter birth place of the vendor. Used in Certification report.
Blocked Extended Data Type: VendBlocked
Type: Enum
LedgerBasic Specify which transaction type, if any, is on hold for the vendor
BlockedReleaseDate Extended Data Type: VendBlockedReleaseDate
Type: UtcDateTime
None The date when the hold is released for the vendor
CashAccountingRegime_ES Extended Data Type: TaxReportCashAccountingRegime_ES
Type: Enum
LedgerBasicSalesTax Spanish VAT books (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CashDisc Extended Data Type: VendCashDiscCode
Type: String
LedgerBasic Terms of cash discount on invoices from the vendor.
CCMNum_BR Extended Data Type: CCMNum_BR
Type: String
None Vendor's registration number for the city. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ChangeRequestAllowOverride Enumeration: NoYes
None Should it be possible to override change management settings per purchase order?
ChangeRequestEnabled Extended Data Type: VersioningChangeRequestRequired
Type: Enum
None Should change management be activated?
ChangeRequestOverride Enumeration: NoYes
None Should it be possible to override change management setting per vendor?
CISCompanyRegNum Extended Data Type: VendCISCompanyRegNum
Type: String
None The company registration number (CRN) of the vendor (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CISNationalInsuranceNum Extended Data Type: VendCISNationalInsuranceNum
Type: String
None The national insurance number (NINO) of the vendor (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CISStatus Enumeration: VendCISStatus
None Status of a vendor in the Construction Industry Scheme (CIS) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CISUniqueTaxPayerRef Extended Data Type: VendCISUniqueTaxPayerRef
Type: String
None The Unique Taxpayer Reference (UTR) number of the vendor (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CISVerificationDate Extended Data Type: VendCISVerificationDate
Type: Date
None The date when the Construction Industry Scheme (CIS) status of the vendor is verified by HMRC (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CISVerificationNum Extended Data Type: VendCISVerificationNum
Type: String
None The verification number issued by HMRC when you verify the Construction Industry Scheme (CIS) status of a vendor (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ClearingPeriod Extended Data Type: VendClearingPeriod
Type: String
LedgerAdvCashflowForecast Terms of payment for period from due date to payment.
CNAE_BR Extended Data Type: CNAE_BR
Type: String
None National classification of company economic activity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CNPJCPFNum_BR Extended Data Type: CNPJCPFNum_BR
Type: String
None Tax registration number of the company/person. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CommercialRegister Extended Data Type: CommercialRegister
Type: String
None Enter the name of the commercial register (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CommercialRegisterInsetNumber Extended Data Type: CommercialRegisterInsetNumber
Type: String
None Enter the inset number in the commercial register (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CommercialRegisterSection Extended Data Type: CommercialRegisterSection
Type: String
None Enter the section of the commercial register (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CompanyChainId Extended Data Type: smmChainId
Type: String
SmmCRM Chain which the company is a member of
CompanyIdSiret Extended Data Type: CompanyIdSiret
Type: String
None Siret number of the company.
CompanyNAFCode Extended Data Type: CompanyNAFRecId
Type: Int64
None NAF code of the company.
CompanyType_MX Enumeration: CompanyType_MX
None Type of company
ConsDay_JP Extended Data Type: VendConsDay_JP
Type: Integer
LedgerBasic Enter the consolidation day to consolidate purchase orders for a vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ContactPersonId Extended Data Type: ContactPersonId
Type: String
None The contact identification number
createdBy Extended Data Type: CreatedBy
Type: String
None
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
None
CreditMax Extended Data Type: VendCreditMaxMST
Type: Real
LedgerBasic Vendor's credit limit to us. The amount is specified in accounting currency (0 = No maximum).
CreditRating Extended Data Type: VendCreditRating
Type: String
LedgerBasic Credit rating of vendor.
Curp_MX Extended Data Type: Curp_MX
Type: String
None CURP - Federal Tax Number.
Currency Extended Data Type: VendCurrencyCode
Type: String
None The currency used by the vendor for invoicing
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DBA Extended Data Type: DBA
Type: String
None Doing business as
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
LedgerBasic Default dimensions
DefaultInventStatusId Extended Data Type: WHSDefaultStatusId
Type: String
WHSandTMS The default inventory status ID on inventory transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
dEL_CreatedTime Extended Data Type: DEL_CreatedTime
Type: Integer
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Extended Data Type: DEL_ModifiedTime
Type: Integer
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DestinationCodeId Extended Data Type: VendDestinationCodeId
Type: String
None Identification of destination code.
DiotCountryCode_MX Extended Data Type: DiotCountryCode_MX
Type: String
None Country/Region code used for DIOT declaration.
DisabledOwned Extended Data Type: VendDisabledOwned
Type: Enum
LedgerBasic Select if the primary owner of the vendor has a disability
DlvMode Extended Data Type: VendDlvModeId
Type: String
None Specify normal mode of delivery for vendor.
DlvTerm Extended Data Type: VendDlvTermId
Type: String
None Specify standard terms of delivery for vendor.
EndDisc Extended Data Type: VendEndDiscCode
Type: String
PriceDisc Total discount attaches the vendor to a total discount group.
EnterpriseCode Extended Data Type: EnterpriseCode
Type: String
None Enter the enterprise code of the vendor’s company (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
EnterpriseNumber Extended Data Type: TaxEnterpriseNumber
Type: String
None Enterprise number used to identify Belgian companies.
EthnicOriginId Extended Data Type: HcmEthnicOriginId
Type: String
HRMAdministration Identification of the ethnic origin of the person
FactoringAccount Extended Data Type: BankVendFactoringAccount
Type: String
None Vendor account number.
FemaleOwned Extended Data Type: FemaleOwner
Type: Enum
None Is the owner a woman?
FineCode_BR Extended Data Type: VendFineCode_BR
Type: String
None Code that defines the fine rates and terms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
FiscalCode Extended Data Type: FiscalCode
Type: String
None Enter fiscal code for the vendor.
ForeignEntityIndicator Extended Data Type: Tax1099ForeignEntityIndicator
Type: Enum
None Select whether the company is owned by an entity outside of the United States.
ForeignResident_RU Extended Data Type: ForeignResident_RU
Type: Enum
None Foreign counteragent flag. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ForeignTaxRegistration_MX Extended Data Type: ForeignTaxRegistration_MX
Type: String
None Tax ID registration for foreign vendors.
FreightZone Extended Data Type: VendFreightZoneId
Type: String
None Identification of UPS zone.
Heir_IT Extended Data Type: Heir_IT
Type: Enum
None Select this check box if the vendor is an heir to the company.
HUBZone Extended Data Type: VendHUBZone
Type: Enum
LedgerBasic Select if the vendor is located in a HUBZone
ICMSContributor_BR Extended Data Type: ICMSContributor_BR
Type: Enum
None Is the vendor an ICMS contributor? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
IENum_BR Extended Data Type: IENum_BR
Type: String
None Vendor's registration number for the state. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InclTax Extended Data Type: InclTax
Type: Enum
LogisticsBasic Do prices include sales tax?
INSSCEI_BR Extended Data Type: INSSCEI_BR
Type: String
None Brazilian Security Institute number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
IntBank_LV Extended Data Type: VendBankAccountId
Type: String
Bank Identify vendor's bank account. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InterestCode_BR Extended Data Type: VendInterestCode_BR
Type: String
None Code that defines the interest rates and terms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventLocation Extended Data Type: InventLocationId
Type: String
LogisticsBasic Warehouse proposal for the vendor
InventProfileId_RU Extended Data Type: InventProfileId_RU
Type: String
InventTrackingGTDProfileOwner Inventory profile. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventProfileType_RU Enumeration: InventProfileType_RU
InventTrackingGTDProfileOwner Kind of activity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventSiteId Extended Data Type: InventSiteId
Type: String
LogisticsBasic Site proposal for the vendor.
InvoiceAccount Extended Data Type: VendInvoiceAccount
Type: String
None Vendor account used when invoicing
IsPaymFeeCovered_JP Extended Data Type: VendPaymFeeCovered_JP
Type: Enum
LedgerBasic Indicates whether the vendor pays the bank payment fee for electronic payments (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
IsResident_LV Extended Data Type: LvResident
Type: Enum
None Is the company a resident? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ItemBuyerGroupId Extended Data Type: ItemBuyerGroupId
Type: String
LogisticsBasic Identification of the buyer group.
LineDisc Extended Data Type: VendLineDiscCode
Type: String
PriceDisc Line discount group used for purchase
LineOfBusinessId Extended Data Type: VendLineOfBusinessId
Type: String
LedgerBasic The line of business in which the vendor operates
LocallyOwned Extended Data Type: VendLocallyOwned
Type: Enum
LedgerBasic Specify whether the vendor meets your guidelines for a local owner.
LvPaymTransCodes Extended Data Type: PaymTransCodeRecId
Type: Int64
None Default payment transaction code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
MainContactWorker Extended Data Type: smmBusRelAccResponsibleWorker
Type: Int64
SmmCRM The employee responsible for the vendor information
MandatoryVatDate_PL Extended Data Type: PlMandatoryVatDate
Type: Enum
LedgerBasicVatDueDate_W Select the check box if the VAT date is required. Or, you can enter the VAT date in the Posted sales tax form. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
MarkupGroup Extended Data Type: VendMarkupGroupId
Type: String
Markup Charges group applicable to vendor
MatchingPolicy Enumeration: PurchMatchingPolicyWithNotSetOption
PurchInvoiceMatching Default policy for PO lines. Three-way: PO, product receipt, and invoice. Two-way: PO and invoice.
Memo Extended Data Type: VendMemo
Type: VarString
SmmCRM Vendor memo
MinorityOwned Extended Data Type: MinorityOwner
Type: Enum
None Does the owner belong to a minority?
modifiedBy Extended Data Type: ModifiedBy
Type: String
None
modifiedDateTime Extended Data Type: ModifiedDateTime
Type: UtcDateTime
None
MultiLineDisc Extended Data Type: VendMultiLineDiscCode
Type: String
PriceDisc Multiline discount used to control discounts across several purchase lines
NameControl Extended Data Type: NameControl
Type: String
None Name control from 1099 mail label.
Nationality_MX Extended Data Type: VendorNationality_MX
Type: String
None Nationality of vendor.
NIT_BR Extended Data Type: NIT_BR
Type: String
None Worker identification number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
NonTaxable_BR Enumeration: NoYes
None Generate and print an entrance fiscal document at vendor invoice posting (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
numberSequenceGroup Extended Data Type: NumberSequenceGroupId
Type: String
None Group for allocation of different number sequences to different customers/vendors.
OffsetAccountType Enumeration: LedgerJournalACType
None Offset account type
OffsetLedgerDimension Extended Data Type: DimensionDynamicDefaultAccount
Type: Int64
LedgerBasic Default offset account suggested in daily journal.
OneTimeVendor Extended Data Type: OneTimeSupplier
Type: Enum
LedgerBasic Is the vendor a one-time supplier?
OperationType_MX Enumeration: VendorOperationType_MX
None Operation code used for DIOT declaration.
OrganizationNumber Extended Data Type: OrganizationNumber
Type: String
None The organization number of the vendor.
OrgId Extended Data Type: OrgId
Type: String
None The ID number used by the Icelandic government to identify individuals and organizations
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))
Party Extended Data Type: DirPartyRecId
Type: Int64
None Reference field in a different table
PaymDayId Extended Data Type: VendPaymDayId
Type: String
LedgerBasic Identification of payment days
PaymId Extended Data Type: VendPaymId
Type: String
LedgerBasic Payment identification used upon payment.
PaymMode Extended Data Type: VendPaymMode
Type: String
LedgerBasic Method of payment code for vendor payment proposal
PaymSched Extended Data Type: VendPaymSchedId
Type: String
PaymSched Payment schedule to be used when invoicing.
PaymSpec Extended Data Type: PaymSpec
Type: String
None Specify payment handling for the current method of payment.
PaymTermId Extended Data Type: VendPaymTermId
Type: String
LedgerBasic Code for terms in connection with payment
PriceGroup Extended Data Type: VendPriceGroup
Type: String
PriceDisc Vendor's price group used for price proposal upon purchase
PurchAmountPurchaseOrder Extended Data Type: PurchAmountPurchaseOrder
Type: Enum
LogisticsBasic Print prices and amounts on purchase order?
PurchCalendarId Extended Data Type: PurchCalendarId
Type: String
None Vendor's work-days calendar. Used to calculate order date and delivery date.
PurchPoolId Extended Data Type: VendPurchPoolId
Type: String
LogisticsBasic Specify the purchase order pool that purchase orders from vendors will be placed in
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
RegNum_W Extended Data Type: CompanyRegNum
Type: String
None Company registration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ResidenceForeignCountryRegionId Extended Data Type: AddressCountryRegionId
Type: String
None Enter the country/region of residence for the vendor. Used in Certification report.
Rfc_MX Extended Data Type: Rfc_MX
Type: String
None RFC - Federal Tax Number.
SecondTIN Enumeration: NoYes
None Select Yes to indicate notification by the IRS twice within three calendar years that the vendor (payee) provided an incorrect name and/or TIN combination
SegmentId Extended Data Type: smmSegmentId
Type: String
SmmCRM Segment assigned to prospect
SeparateDivisionId_RU Extended Data Type: SeparateDivisionId_RU
Type: String
None Separate division identifier. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ServiceCodeOnDlvAddress_BR Extended Data Type: TaxServiceCodeOnDlvAddress_BR
Type: Enum
None Specifies service codes and IBGE city code is based on delivery address city (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SmallBusiness Extended Data Type: VendSmallBusiness
Type: Enum
LedgerBasic Specify whether the vendor meets your guidelines for being a small business
StateInscription_MX Extended Data Type: StateInscription_MX
Type: String
None State inscription number
StructDepartment_RU Extended Data Type: StructDepartment_RU
Type: String
LedgerBasic Organization department for Russian invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SubsegmentId Extended Data Type: smmSubsegmentId
Type: String
SmmCRM Subsegment for assignment to prospect (for selected segment)
SuppItemGroupId Extended Data Type: VendSuppItemGroupId
Type: String
SuppItem Manages the supplementary items for the vendor when supplementary items are calculated.
TAMRebateGroupID Extended Data Type: TAMVendRebateGroupId
Type: String
TAMVendorRebate Group of vendors for which a rebate is applicable. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Tax1099Fields Extended Data Type: Tax1099FieldsRecId
Type: Int64
None Box code on the 1099 form that the total amount is posted to.
Tax1099NameChoice Enumeration: Tax1099NameChoice
None This option gives you the choice of which name to use for 1099 purposes either the vendor's name or DBA (Doing Business As) name
Tax1099RegNum Extended Data Type: Tax1099RegNum
Type: String
None Registration number with federal authorities for 1099 reporting.
Tax1099Reports Extended Data Type: Tax1099Reporting
Type: Enum
None Create 1099 form for purchase from vendor.
TaxGroup Extended Data Type: TaxGroup
Type: String
LedgerBasicSalesTax A group of sales tax codes for calculating taxes on a sale or purchase
TaxIDType Enumeration: TaxIDType
None Select the type of IRS ID that was entered.
TaxPeriodPaymentCode_PL Extended Data Type: PlTaxPeriodPaymentCode
Type: String
None Enter a time period code for VAT transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxWithholdCalculate Extended Data Type: NoYesId
Type: Enum
None Shall withholding tax be calculated for vendor payment transactions in journals?
TaxWithholdGroup Extended Data Type: TaxWithholdGroup
Type: String
LedgerBasicWithholdingTax Withholding tax group, which will be used as default for vendor payment transactions in journals.
TaxWithholdVendorType_TH Enumeration: TaxWithholdVendorType_TH
None Withholding tax vendor type
UnitedVATInvoice_LT Extended Data Type: UnitedVATInvoice_LT
Type: Enum
None Flag indicating united VAT invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
UseCashDisc Enumeration: UseCashDisc
None In which way is the cash discount to be used? (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))
VATNum Extended Data Type: VATNum
Type: String
LedgerBasicSalesTax Vendor's tax exempt number for extracting statistics
VATOperationCode_RU Extended Data Type: VATOperationCode_RU
Type: String
LedgerBasicSalesTax Operation code for VAT declaration. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VATPartnerKind_RU Enumeration: VATPartnerKind_RU
LedgerBasicSalesTax Partner type in tax agent payments. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VATTaxAgent_RU Enumeration: NoYes
LedgerBasicSalesTax The company is a tax agent for the vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VendConsumption_BR Extended Data Type: CustVendFinalUser_BR
Type: Enum
None Is the purchase for self-consumption? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VendExceptionGroup Extended Data Type: RefRecId
Type: Int64
None Reference field in a different table
VendGroup Extended Data Type: VendGroupId
Type: String
LedgerBasic Vendor group that the vendor is attached to.
VendIncomeCode_BR Extended Data Type: VendIncomeCode_BR
Type: String
None Income code of the vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VendInvoiceDeclaration_IS Extended Data Type: InvoiceDeclarationId_IS
Type: Int64
None Classification of vendor invoices used for instance for reporting to authorities.
VendItemGroupId Extended Data Type: VendItemGroupId
Type: String
LogisticsBasic Vendor group for external item descriptions
VendorType_MX Enumeration: VendorType_MX
None Type of vendor code used for DIOT declaration.
VendPriceToleranceGroupId Extended Data Type: VendPriceToleranceGroupId
Type: String
PurchInvoiceMatching Identification of vendor price tolerance group for accounts payable invoice matching
VeteranOwned Extended Data Type: VendVeteranOwned
Type: Enum
LedgerBasic Select if the primary owner of the vendor is a service veteran
W9 Extended Data Type: VendW9
Type: Enum
None Has the vendor W-9 been received?
W9Included Extended Data Type: VendW9Excluded
Type: Enum
None Select this check box to verify whether this vendor has provided a W-9 form
YourAccountNum Extended Data Type: VendAccountExt
Type: String
LedgerBasic Our account number with vendor

Top

Field Groups

Field Group Fields
FiscalInformation_BR
Handheld
Identification
InventoryStatus
InterCompany
AddressLookup
Administration
AutoLookup
AutoReport
AutoSummary
BalanceAllCurrency
Budget
CaseMoreInformation
ChangeRequest
CompanyChain
ConsDay_JP
ConstructionIndustryScheme
CompanyFrench
ContactInfo
Credit
Dimension
Currency
Delivery
DiotInformation_MX
Posting
Payment
PurchaseDiscount
PurchaseOrder
RetailIdentification
SalesTax
Segment
Services_BR
Subsegment
SupplementaryItem
TAMRebate
Tax1099
TaxRegistration_MX
VATBook_ES
VATTaxAgent_RU
VendInvoiceDeclaration
VendorProfile
Vendor_RU
VendProfile
VendProfileBusinessDetails
VendProfileSalesTax
WebCategoryBrowsing
WithholdTaxGroup
VendProfileTax1099Options
VendProfileBusinessDetailsSummaryFields
WithholdingTax
MainContact
InvoiceReport_RU
National_BR
Invoice
Memo
InventProfile_RU
InvoiceMatching
NotificationToTheCentralBank
OffsetAccount

Top

Relations

Relation Table Lines
AccountNum VendTable
BankCentralBankPurpose BankCentralBankPurpose
BirthCounty LogisticsAddressCounty
Branches_RU Branches_RU
CashDisc CashDisc
CompanyNAFCode CompanyNAFCode
ContactPerson ContactPerson
Currency Currency
CustVendItemGroup CustVendItemGroup
dataAreaId DataArea
DefaultDimension DimensionAttributeValueSet
DestinationCode DestinationCode
DirAddressBookParty DirAddressBookPartyAllView
DirPartyView DirPartyView
DlvMode DlvMode
DlvTerm DlvTerm
FactoringAccount VendTable
HcmEthnicOrigin HcmEthnicOrigin
InventBuyerGroup InventBuyerGroup
InventLocation InventLocation
InventProfile_RU InventProfile_RU
InventProfileId_RU InventProfile_RU
InventSite InventSite
InvoiceAccount VendTable
InvoiceDeclarationId_FK VendInvoiceDeclaration_IS
LineOfBusiness LineOfBusiness
LogisticsAddressCountryRegion LogisticsAddressCountryRegion
LvPaymTransCodes LvPaymTransCodes
MainContactWorker HcmWorker
MarkupGroup MarkupGroup
NumberSequenceGroup NumberSequenceGroup
OffsetLedgerDimension DimensionAttributeValueCombination
Partition Partitions
Party_FK DirPartyTable
PaymDay PaymDay
PaymSched PaymSched
PaymTerm PaymTerm
PaymTermClearingPeriod PaymTerm
PlTaxDueTable PlTaxDueTable
PriceDiscGroupEndDisc PriceDiscGroup
PriceDiscGroupLineDisc PriceDiscGroup
PriceDiscGroupMultiLineDisc PriceDiscGroup
PriceDiscGroupPriceGroup PriceDiscGroup
PurchPool PurchPool
ResidenceForeignCountryRegionId LogisticsAddressCountryRegion
smmBusRelChainGroup smmBusRelChainGroup
smmBusRelSegmentGroup smmBusRelSegmentGroup
smmBusRelSubSegmentGroup smmBusRelSubSegmentGroup
SuppItemGroup SuppItemGroup
TAMVendRebateGroup TAMVendRebateGroup
Tax1099Fields Tax1099Fields
TaxGroupHeading TaxGroupHeading
TaxWithholdGroupHeading TaxWithholdGroupHeading
VATNum TaxVATNumTable
VATOperationCode_RU VATOperationCodeTable_RU
VendBankAccount VendBankAccount
VendCertification VendCertification
VendExceptionGroup VendExceptionGroup
VendFineCode_BR VendFineSetup_BR
VendGroup VendGroup
VendInterestSetup_BR VendInterestSetup_BR
VendPaymentModeSpec VendPaymModeSpec
VendPaymModeTable VendPaymModeTable
VendPriceToleranceGroup VendPriceToleranceGroup
WHSInventStatus WHSInventStatus
WorkCalendarTable WorkCalendarTable

Top

Indexes

Index AllowDuplicates Enabled Fields
AccountIdx No Yes
DEL_NameAliasIDx Yes Yes
DEL_PartyIdx Yes Yes
DEL_PhoneIdx Yes Yes
HcmWorkerIdx Yes Yes
LvPaymTransCodesIdx Yes Yes
Party No Yes
PlTaxDueTableIdx Yes Yes
RecId No Yes
Tax1099FieldsIdx Yes Yes
VendInvoiceDeclaration_ISIdx Yes Yes
VendTableAcctIdx Yes Yes
YourAccountNumIdx Yes Yes

Top

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateReadUpdateDelete. The Application Object Server authorizes each create, read, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    VendTable Table

See Also

Table Methods

Tables Overview