VendTrans Table [AX 2012]

The VendTrans table contains the posted transaction information for the vendor.

Configuration Key: LedgerBasic

  MethodDescription
Gg930306.pubmethod(en-us,AX.60).gifabsRemainAmountMST
Gg930306.pubmethod(en-us,AX.60).gifagreementDocumentTitle_RUGets the Document title of the Agreement for this transaction.
Gg930306.pubmethod(en-us,AX.60).gifagreementId_RUGets the Agreement Id from the DefaultDimension of this transaction.
Gg930306.pubmethod(en-us,AX.60).gifallowEditCompanyBankAccountId
Gg930306.pubmethod(en-us,AX.60).gifallowEditThirdPartyBankAccountId
Gg930306.pubmethod(en-us,AX.60).gifamountExchAdj
Gg930306.pubmethod(en-us,AX.60).gifaosValidateDeleteValidates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifaosValidateInsertValidates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifaosValidateReadValidates on the server that the specified record can be read. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifaosValidateUpdateValidates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifbankCurrencyTransferId_RU
Gg930306.pubmethod(en-us,AX.60).gifbuf2conPacks the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcancelTimeOutCancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifcanSubmitToWorkflowIndicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcaptionGets and sets the caption property of a table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcheckInvalidFieldAccessGets and sets invalid field access. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcheckRecordGets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcheckRestrictedDeleteActionsGets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifclearRemoves all rows from the table buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifclearingLedgerDimension
Gg930306.pubmethod(en-us,AX.60).gifclearingPeriod
Gg930306.pubmethod(en-us,AX.60).gifcompanyGets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcon2bufUnpacks a container into the table buffers. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifconcurrencyModelGets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifcontextGets and sets the context property. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdataRetrieves a row from the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdataSourceRetrieves the data source of the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdefaultFieldPopulates default values in a field in the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdefaultRowPopulates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdeleteDeletes the current record from the database.
Gg930306.pubmethod(en-us,AX.60).gifdisableCacheGets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdispConsId_JPDisplays consolidation invoice Id for this transaction.
Gg930306.pubmethod(en-us,AX.60).gifdisplayAccountingExchangeRateCalculates and returns the ExchRate for this VendTrans in accounting currency.
Gg930306.pubmethod(en-us,AX.60).gifdisplayApprover
Gg930306.pubmethod(en-us,AX.60).gifdisplayDiscountDate
Gg930306.pubmethod(en-us,AX.60).gifdisplayDiscountUsed
Gg930306.pubmethod(en-us,AX.60).gifdisplayInvoiceDate_THDisplays the invoice date.
Gg930306.pubmethod(en-us,AX.60).gifdisplayInvoiceReceiptDate_THDisplays the invoice receipt date.
Gg930306.pubmethod(en-us,AX.60).gifdisplayPaymentHoldDisplays the vendor hold level, namely vendor, or invoice, depending on the hold type.
Gg930306.pubmethod(en-us,AX.60).gifdisplayPersonnelNumberDisplays the personnel number of the approver.
Gg930306.pubmethod(en-us,AX.60).gifdisplayRealVendName_THDisplays the real vendor name.
Gg930306.pubmethod(en-us,AX.60).gifdisplayReasonDisplays the reason code value.
Gg930306.pubmethod(en-us,AX.60).gifdisplayReasonCommentDisplays the reason comment value.
Gg930306.pubmethod(en-us,AX.60).gifdisplayRemittanceAddressGets the vendor remittance address associated with the vendor remittance location on the VendTable table.
Gg930306.pubmethod(en-us,AX.60).gifdisplayRemittanceLocationDescriptionDisplays the vendor remittance address description associated with the vendor.
Gg930306.pubmethod(en-us,AX.60).gifdisplayTax1099BoxDisplays the Tax1099Box value.
Gg930306.pubmethod(en-us,AX.60).gifdisplayTaxBranchDimensionDisplays the tax branch code depending on the default dimension.
Gg930306.pubmethod(en-us,AX.60).gifdisplayTaxInvoiceReceiptDate_THDisplays the tax invoice receipt date.
Gg930306.pubmethod(en-us,AX.60).gifdisplayTaxWithholdAmount_INGets the tax withhold amount for display.
Gg930306.pubmethod(en-us,AX.60).gifdisplayTransactionCurAmountCredit_JPDisplay method for the Transaction Currency Amount Credit.
Gg930306.pubmethod(en-us,AX.60).gifdisplayTransactionCurAmountDebit_JPDisplay method for the Transaction Currency Amount Debit.
Gg930306.pubmethod(en-us,AX.60).gifdisposeReleases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdoClearRemoves all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdocumentDateModified
Gg930306.pubmethod(en-us,AX.60).gifdocumentInvoiceDate
Gg930306.pubmethod(en-us,AX.60).gifdoDeleteDeletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdoInsertInserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdoUpdateUpdates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifdoValidateDeletePerforms the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifequalDetermines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifexchRateCurToMstGets the exchange rate from the transaction currency to the monetary standard (MST) currency.
Gg930306.pubmethod(en-us,AX.60).giffieldAccessRightReturns the field access right. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giffieldBufferAccessRightReturns the field access right for the current record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giffieldStateSets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giffiscalEstablishmentId_BRGets the fiscal establishment identifier for this vendor transaction
Gg930306.pubmethod(en-us,AX.60).gifgetAllowRedefaultReturns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetDefaultingDependenciesReturns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetExtensionReturns the table extension. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetFieldValueGets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetInstanceRelationTypeReturns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetPaymentExtension_BRGets the brazilian extension table for VendTransPayment table
Gg930306.pubmethod(en-us,AX.60).gifgetPhysicalTableNameReturn the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetPresenceFieldDataRetrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetSQLStatementGets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetTableInInstanceHierarchy (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetTableTypeIndicates the type of the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifgetTimeOutTimerHandleReturns the timer handle for the object. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifhandleRetrieves the handle of the class of the object. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifhasPendingInvoiceDetermines whether a pending invoice exists for this VendTrans table record.
Gg930306.pubmethod(en-us,AX.60).gifhasRelatedTableIndicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifhelpFieldRetrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifinitFromLedgerJournalTransApproval
Gg930306.pubmethod(en-us,AX.60).gifinitFromPostingProfile
Gg930306.pubmethod(en-us,AX.60).gifinitValueInitializes a field to the default value. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifinputStatusSets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifinsertInserts the current record into the VendTrans table.
Gg930306.pubmethod(en-us,AX.60).gifinteractiveContextSets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifinventProfileType_RU
Gg930306.pubmethod(en-us,AX.60).gifisCreditNote
Gg930306.pubmethod(en-us,AX.60).gifisFieldDataRetrievedChecks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisFieldSetChecks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisFormDataSourceIndicates whether the data source is a form. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisNewRecordReturns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisPartOfUOWSaveChanges (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisPayment_JPIndicates whether this transaction is for payment.
Gg930306.pubmethod(en-us,AX.60).gifisReimbursementDetermines whether the debit transaction is of reimbursement type.
Gg930306.pubmethod(en-us,AX.60).gifisTempDbIndicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisTmpIndicates whether this is a temporary table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifisTransForConsInvoice_JPIndicates whether this transaction is for consolidated invoice.
Gg930306.pubmethod(en-us,AX.60).gifisVATTaxAgentPaymentFromVendorFunds_RU
Gg930306.pubmethod(en-us,AX.60).gifisVendPaymEligibleForTransferChecks if the vendor invoice or payment proposal line is eligible for transfer to the payment journal depending on the vendor hold type.
Gg930306.pubmethod(en-us,AX.60).gifjoinChildFinds the join child of the current record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifjoinParentFinds the join parent of the current record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giflanguageId
Gg930306.pubmethod(en-us,AX.60).giflinkPhysicalTableInstanceChecks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifmergeMerges the current table with the specified table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifmodifiedField
Gg930306.pubmethod(en-us,AX.60).gifmodifiedFieldValueModifies the specified field to the original value. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifnewInitializes a new instance of the Object class. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifnotifyReleases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifnotifyAllReleases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifobjectOnServerDetermines whether the object is on a server. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifopen
Gg930306.pubmethod(en-us,AX.60).giforigRetrieves the original values of the current record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifoverwriteSystemfieldsGets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifownerReturns the instance that owns the object. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifpackExtensionTableIncrements the _sysExtensionSerializerExtensionTableMap to VendTrans PackedExtensions container field.
Gg930306.pubmethod(en-us,AX.60).gifpackVendTrans_WPacks the VendTrans_W associated with the current record.
Gg930306.pubmethod(en-us,AX.60).gifpossibleCashDisc
Gg930306.pubmethod(en-us,AX.60).gifpostCacheLoadIs executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifpostLoad
Gg930306.pubmethod(en-us,AX.60).gifpreRemotingIs 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.)
Gg930306.pubmethod(en-us,AX.60).gifpsaPaymTermId
Gg930306.pubmethod(en-us,AX.60).gifpsaProjId
Gg930306.pubmethod(en-us,AX.60).gifqueryCustVendSettlement
Gg930306.pubmethod(en-us,AX.60).gifqueryCustVendTransOpen
Gg930306.pubmethod(en-us,AX.60).gifqueryTimedOutIndicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifqueryTimeoutGets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifreadCommittedLock (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifreadPastGets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifrecordLevelSecurityGets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifrelatedTableSets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifremainAmountCur
Gg930306.pubmethod(en-us,AX.60).gifremainAmountMST
Gg930306.pubmethod(en-us,AX.60).gifrenamePrimaryKeyRenames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifrereadRereads the record from the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifreversed
Gg930306.pubmethod(en-us,AX.60).gifRowCountRetrieves the number of rows in the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifselectForUpdateGets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifselectLockedIndicates whether to select locked records. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifselectRefRecordSelects the record by referenced field ID. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifselectWithRepeatableReadGets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg930306.privmethod(en-us,AX.60).gifsetApprovedDate
Gg930306.pubmethod(en-us,AX.60).gifsetConnectionSets the user connection for this table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsetCrossPartitionSets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsetFieldValueSets the field value in the record buffer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsetSQLTracingEnables or disables SQL tracing mode. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsetTimeOutSets up the scheduled execution of a specified method. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifsetTmpSets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsetTmpDataSets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsetXDSContextSets new XDS context. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipAosValidationGets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipDatabaseLogGets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipDataMethodsGets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipDeleteActionsGets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipDeleteMethodGets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipEventsProvides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipPostLoadGets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifskipTTSCheckGets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifsummaryLedgerDimension
Gg930306.pubmethod(en-us,AX.60).gifsuppressWarningsGets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giftableAccessRightReturns the table access right. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giftableBufferAccessRightReturns the table access right for the current record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giftakeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giftoolTipFieldRetrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giftoolTipRecordRetrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).giftoStringReturns a string that represents the current object. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).giftraceNum
Gg930306.pubmethod(en-us,AX.60).giftransactionPerDate
Gg930306.pubmethod(en-us,AX.60).giftransData
Gg930306.pubmethod(en-us,AX.60).giftransOpen
Gg930306.pubmethod(en-us,AX.60).giftransOpenForVendBankFinds the specified record in the VendTransOpen table.
Gg930306.pubmethod(en-us,AX.60).gifttsabortAborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifttsbeginStarts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifttscommitCommits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifupdateUpdates the current record in the database.
Gg930306.pubmethod(en-us,AX.60).gifusageCountRetrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifuseExistingTempDBTable (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifvalidateDeleteDetermines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifvalidateFieldDetermines whether the _fieldIdToCheck field is valid.
Gg930306.pubmethod(en-us,AX.60).gifvalidateFieldValue (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifvalidateWriteDetermines whether the current record is valid and ready to be written. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifvalidTimeStateUpdateModeSets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifvatTaxAgentAmount_RU
Gg930306.pubmethod(en-us,AX.60).gifvatTaxAgentBaseAmount_RU
Gg930306.pubmethod(en-us,AX.60).gifvatTaxAgentBaseAmountMST_RU
Gg930306.pubmethod(en-us,AX.60).gifvendInvoiceJourRetrieves VendInvoiceJour for the given VendTrans.
Gg930306.pubmethod(en-us,AX.60).gifvendInvoiceJour_RU
Gg930306.pubmethod(en-us,AX.60).gifvendTableName
Gg930306.pubmethod(en-us,AX.60).gifvendTrans_WGets the VendTrans_W record associated with the current record.
Gg930306.pubmethod(en-us,AX.60).gifwaitPauses a process. (Inherited from Object.)
Gg930306.pubmethod(en-us,AX.60).gifwasCachedSpecifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifwriteUpdates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifxmlRetrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::balanceMST
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::calcSettlementOutsideCashDiscDate
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::checkExistIndicates whether the specified record exists in the VendTrans table and displays a message if the record does not exist.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::checkIfCanBeSettled_RU
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::checkReversal
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::chkVendTransReorg
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::exist
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::existForSubledgerJournalIndicates whether a subledger voucher is used by a vendor subledger journal transaction.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::existForSubledgerJournal_BRVerifies whether there is a VendInvoiceJour associated with the voucher and whether it generates vendor transactions.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::existsVendPaymReconciliationImport_SEBGDetermines if the VendPaymReconciliationImport_SEBG is being used as a return format on an open vendor invoice.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::find
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::findAccountVoucherDate
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::findByCompany
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::findRefVoucher_INFinds ref voucher information.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::findVoucherDate
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::findVoucherDateTypeReturns a VendTrans table record for a given voucher, transaction, and transaction type.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::getSettleInvoiceCountRetrieves the number of invoices settled with the given payment record ID.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::hasLCRelatedTransToBeReversedIndicates whether there is any Letter of Credit that is related to the VendTrans record that has to be reversed.
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::initVendBalance
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::reverseTransact
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::reverseTransactOld
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::settleTransact
Gg930306.pubmethod(en-us,AX.60).gifGg930306.static(en-us,AX.60).gif::txtNotExistGets the message to use when a specific record in the VendTrans table does not exist.
Top

FieldTypeConfiguration keyDescription
AccountingEvent Extended Data Type: RefRecId
Type: Int64
NoneReference field in a different table
AccountNum Extended Data Type: VendAccount
Type: String
NoneThe vendor that is associated with the voucher
AmountCur Extended Data Type: AmountCurDebCred
Type: Real
NoneTransaction amount in specified currency
AmountMST Extended Data Type: AmountMSTDebCred
Type: Real
NoneTransaction amount in standard currency
Approved Extended Data Type: Approved
Type: Enum
NoneHas the post been approved by the specified employee?
ApprovedDate Extended Data Type: ApprovedDate
Type: Date
NoneDate of transaction approval.
Approver Extended Data Type: HcmApprover
Type: Int64
NoneEmployee who approves the transaction.
Arrival Extended Data Type: ArrivalId
Type: Enum
VendInvoiceRegisterApprovalHas the transaction been posted to the purchase ledger without being approved?
BankCentralBankPurposeCode Extended Data Type: BankCentralBankPurposeCode
Type: String
LedgerBasicCode used when reporting to the central bank.
BankCentralBankPurposeText Extended Data Type: BankCentralBankPurposeText
Type: String
LedgerBasicDescribe code used when reporting to the central bank.
BankLCImportLine Extended Data Type: BankLCLineRefRecId
Type: Int64
BankDocumentThe shipment number of shipment details.
BankRemittanceFileId Extended Data Type: BankRemittanceFileIdVend
Type: String
VendPromissoryNoteUnique identification of the remittance file.
Cancel Extended Data Type: Cancelled
Type: Enum
NoneMay the transaction be canceled?
CashDiscCode Extended Data Type: CashDiscCode
Type: String
LedgerBasicCash discount code for subsequent approval.
Closed Extended Data Type: TransDate
Type: Date
NoneDate of total settlement of the transaction
CompanyBankAccountId Extended Data Type: CompanyBankAccountId
Type: String
BankBank account number
ConsessionSettlementId Extended Data Type: RetailConsessionSettlementId
Type: String
RetailConcessionGroup identifier. (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))
Correct Extended Data Type: Correct
Type: Enum
LedgerBasicIs the current transaction a reversing entry?
createdBy Extended Data Type: CreatedBy
Type: String
None
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
None
createdTransactionId Extended Data Type: CreatedTransactionId
Type: Int64
None
CurrencyCode Extended Data Type: VendCurrencyCode
Type: String
NoneCurrency for amount in foreign currency
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
LedgerBasicDefault dimensions
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))
DocumentDate Extended Data Type: DocumentDate
Type: Date
NoneDate of document that created this transaction
DocumentNum Extended Data Type: DocumentNum
Type: String
NoneNumber of the document that generated the transaction.
DueDate Extended Data Type: DueDate
Type: Date
LedgerBasicDue date of the transaction.
EUROTriangulation Extended Data Type: EUROTriangulation
Type: Enum
NoneSpecify whether the exchange rate is included in triangulation.
ExchAdjustment Extended Data Type: VendExchAdjustment
Type: Real
LedgerBasicAmount of the transaction exchange rate adjustment
ExchAdjustmentReporting Extended Data Type: VendExchAdjustment
Type: Real
LedgerBasicAmount of the transaction exchange rate adjustment
ExchRate Extended Data Type: ExchRate
Type: Real
NoneSpecify the cost in the foreign currency.
ExchRateSecond Extended Data Type: ExchrateSecondary
Type: Real
NoneRate of the secondary part of the currency calculation, when triangulation is used
FixedExchRate Extended Data Type: FixedExchRate
Type: Enum
NoneSpecify whether fixed exchange rate is to be used.
Invoice Extended Data Type: VendInvoiceId
Type: String
LedgerBasicInvoice number that the transaction is attached to
InvoiceProject Enumeration: NoYes
NoneSpecifies whether the vendor transaction originates from a project contract
InvoiceReleaseDate Extended Data Type: InvoiceReleaseDate
Type: UtcDateTime
NoneThe date when the hold is released for the invoice payment
JournalNum Extended Data Type: LedgerJournalId
Type: String
VendInvoiceRegisterApprovalLedger - journal batch number.
LastExchAdj Extended Data Type: TransDate
Type: Date
NoneDate of last foreign currency revaluation of the transaction
LastExchAdjRate Extended Data Type: ExchRate
Type: Real
NoneExchange rate from the last foreign currency revaluation adjustment
LastExchAdjRateReporting Extended Data Type: CurrencyExchangeRate
Type: Real
NoneThe currency exchange rate
LastExchAdjVoucher Extended Data Type: Voucher
Type: String
LedgerBasicVoucher number from the last foreign currency revaluation adjustment
LastSettleAccountNum Extended Data Type: VendAccount
Type: String
NoneThe vendor that is associated with the most recent settlement voucher
LastSettleCompany Extended Data Type: CompanyId
Type: String
NoneThe company that is associated with the most recent settlement voucher
LastSettleDate Extended Data Type: TransDate
Type: Date
NoneTransaction date
LastSettleVoucher Extended Data Type: Voucher
Type: String
LedgerBasicVoucher number in ledger.
modifiedBy Extended Data Type: ModifiedBy
Type: String
None
modifiedDateTime Extended Data Type: ModifiedDateTime
Type: UtcDateTime
None
modifiedTransactionId Extended Data Type: ModifiedTransactionId
Type: Int64
None
OffsetRecid Extended Data Type: VendTransRefRecId
Type: Int64
NoneReference field in a different table
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))
PaymId Extended Data Type: PaymId
Type: String
LedgerBasicPayment identification
PaymMode Extended Data Type: VendPaymMode
Type: String
LedgerBasicThe method of payment selected by the vendor
PaymReference Extended Data Type: VendPaymReference
Type: String
LedgerBasicReference to a specific payment.
PaymSpec Extended Data Type: VendPaymSpec
Type: String
LedgerBasicSpecify payment handling for the current method of payment.
PostingProfile Extended Data Type: VendPostingProfile
Type: String
NonePosting profile being processed.
PostingProfileApprove Extended Data Type: VendPostingProfile
Type: String
NoneNew posting profile when approving
PostingProfileCancel Extended Data Type: VendPostingProfile
Type: String
NoneNew posting profile when canceling
PostingProfileClose Extended Data Type: VendPostingProfile
Type: String
NonePosting profile of the transaction when closing.
PostingProfileReOpen Extended Data Type: VendPostingProfile
Type: String
NoneNew posting profile for the transaction when reopening
Prepayment Enumeration: NoYes
NoneMark that the payment is to be managed as a prepayment.
PromissoryNoteID Extended Data Type: VendPromissoryNoteID
Type: String
VendPromissoryNoteUnique key for identification of promissory notes. The key is used when creating new promissory notes.
PromissoryNoteSeqNum Extended Data Type: CustVendNegInstSeqNum
Type: Integer
VendPromissoryNoteSequence number for bills of exchange and promissory notes.
PromissoryNoteStatus Extended Data Type: VendPromissoryNoteStatus
Type: Enum
VendPromissoryNoteStatus of the promissory note.
RBOVendTrans Extended Data Type: RetailCustTrans
Type: Enum
RetailCustomer transaction type. (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))
ReasonRefRecId Extended Data Type: ReasonRefRecID
Type: Int64
NoneContains stored financial reason codes and comments for entered or posted transactions or actions.
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
ReleaseDateComment Extended Data Type: ReleaseDateComment
Type: String
NoneProvide an optional comment for the release date
RemittanceAddress Extended Data Type: RemittanceAddress
Type: Int64
NoneThe mailing address that will be printed on remittances and checks
RemittanceLocation Extended Data Type: RemittanceLocation
Type: Int64
NoneThe remittance address location name
ReportingCurrencyAmount Extended Data Type: AmountMSTSecondary
Type: Real
NoneThe amount in the reporting currency
ReportingCurrencyCrossRate Extended Data Type: CurrencyExchangeRate
Type: Real
NoneThe currency exchange rate
ReportingExchAdjustmentRealized Extended Data Type: VendExchAdjustmentRealized
Type: Real
LedgerBasicRealized exchange rate adjustment amount of this transaction
ReportingExchAdjustmentUnrealized Extended Data Type: VendExchAdjustmentUnrealized
Type: Real
LedgerBasicUnrealized exchange rate adjustment amount of this transaction
SettleAmountCur Extended Data Type: AmountCur
Type: Real
NoneSettled portion of the amount in foreign currency
SettleAmountMST Extended Data Type: AmountMST
Type: Real
NoneThe transaction amount, in the accounting currency
SettleAmountReporting Extended Data Type: AmountMSTSecondary
Type: Real
NoneThe amount in the reporting currency
Settlement Extended Data Type: VendAutoSettlement
Type: Enum
LedgerBasicMay transaction be settled automatically?
SettleTax1099Amount Extended Data Type: SettleTax1099Amount
Type: Real
NoneThe amount that has been paid for federal 1099 purposes.
SettleTax1099StateAmount Extended Data Type: SettleTax1099StateAmount
Type: Real
NoneThe amount that has been paid for state 1099 purposes.
Tax1099Amount Extended Data Type: Tax1099Amount
Type: Real
NoneAmount to be reported in 1099
Tax1099Date Extended Data Type: Tax1099Date
Type: Date
NoneDate of 1099 reporting.
Tax1099Fields Extended Data Type: Tax1099FieldsRecId
Type: Int64
NoneBox code on the 1099 form that the total amount is posted to.
Tax1099Num Extended Data Type: Tax1099Num
Type: String
NoneNumber of the 1099 report.
Tax1099RecId Extended Data Type: RefRecId
Type: Int64
PublicSectorReference 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))
Tax1099State Extended Data Type: Tax1099State
Type: String
NoneIdentification of state
Tax1099StateAmount Extended Data Type: Tax1099StateAmount
Type: Real
NoneAmount to be reported in 1099
TaxInvoicePurchId Extended Data Type: TaxInvoicePurchId
Type: String
NoneUnique key for invoice, allocated when invoice updating.
ThirdPartyBankAccountId Extended Data Type: BankThirdPartyAccountId
Type: String
BankBank account ID of the third-party bank account.
TransDate Extended Data Type: TransDate
Type: Date
NoneTransaction date
TransType Enumeration: LedgerTransType
NoneGeneral specification of the transaction type.
Txt Extended Data Type: TransTxt
Type: String
NoneText describing the transaction.
VendExchAdjustmentRealized Extended Data Type: VendExchAdjustmentRealized
Type: Real
LedgerBasicRealized exchange rate adjustment amount of this transaction
VendExchAdjustmentUnrealized Extended Data Type: VendExchAdjustmentUnrealized
Type: Real
LedgerBasicUnrealized exchange rate adjustment amount of this transaction
VendPaymentGroup Extended Data Type: VendPaymentGrouping
Type: String
NoneThe common code by which transactions are grouped for payment
Voucher Extended Data Type: Voucher
Type: String
LedgerBasicVoucher number that the transaction is attached to.
Top

Field GroupFields
Ledger
Miscellaneous
Payment
PostingProfiles
Project
PromissoryNote
Reason
Bank
BankLCImportGroup
CashDiscount
Dimension
Document
ExchangeAdjustment
ExchangeRates
Identification
Invoice
Journal
AutoReport
Administration
Agreement_RU
All
Amount
VendTransReferenceVoucher_IN
VendorTransactions
VendPaymentGroup
Remittance
SettlementStatus
Settlement
Tax1099Fields
Top

RelationTableLines
AccountingEventAccountingEvent
Approver_FKHcmWorker
BankAccountTableBankAccountTable
BankCentralBankPurposeBankCentralBankPurpose
BankChequePaymentTransBankChequePaymTrans
BankLCImportLineBankLCImportLine
BankRemittanceFilesVendBankRemittanceFilesVend
CashDiscCashDisc
CurrencyCurrency
DataAreaDataArea
dataAreaIdDataArea
DefaultDimensionDimensionAttributeValueSet
FactureJourAmountDifference_RUFactureJour_RU
LedgerJournalTableLedgerJournalTable
PartitionPartitions
ReasonRefReasonTableRef
RemittanceAddress_FKLogisticsPostalAddress
RemittanceLocation_FKLogisticsLocation
RetailConsessionSettlementTableRetailConsessionSettlementTable
Tax1099DetailTax1099BoxDetail
Tax1099FieldsTax1099Fields
Tax1099StateLogisticsAddressState
ThirdPartyBankAccountVendBankAccount
TmpBankPaym2InvoiceTmpBankPaym2Invoice
VendExchRateAdjustmentVendExchRateAdjustment
VendInvoiceJourVendInvoiceJour
VendLedger_PostingChangeVoucherVendLedger
VendLedger_PostingProfileVendLedger
VendLedger_PostingProfileApproveVendLedger
VendLedger_PostingProfileCancelVendLedger
VendLedger_PostingProfileCloseVendLedger
VendLedger_PostingProfileReOpenVendLedger
VendPaymentModeVendPaymModeTable
VendPaymentModeSpecVendPaymModeSpec
VendPromissoryNoteJourVendPromissoryNoteJour
VendPromissoryNoteTransVendPromissoryNoteTrans
VendStateTaxIDVendStateTaxID
VendTable_AccountNumVendTable
VendTable_LastSettleAcountNumVendTable
VendTrans_AccountNumVendTrans
VendTrans_OffsetRecidVendTrans
VendTransVoucherVendTrans
Top

IndexAllowDuplicatesEnabledFields
AccountDate1099IdxYesYes
AccountDateIdxYesYes
ApproverIdxYesYes
FK_DimensionAttributeValueSet_VendTransYesYes
journalNumYesYes
ReasonTableRefIdxYesYes
RecIdNoYes
Tax1099FieldsIdxYesYes
TransDateIdxYesYes
VoucherDateIdxYesYes
Top

Community Additions

ADD
Show: