MCRRoyaltyVendTable Table

  • Article

Royalty

Configuration Key: MCRRoyalty

Methods

  Method Description
Dn711634.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif calculateRoyaltyAmount Calculates the royalty amounts based on the royalty amount type.
Dn711634.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Indicates whether submission to workflow is possible. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif checkConsumedRebateAmount Validates whether the consumed royalty amount is correct.
Dn711634.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif checkValidDate Validates whether the passed in dates are valid for this royalty.
Dn711634.pubmethod(en-us,AX.60).gif clear Removes all rows from the table buffer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif companyCurrencyCode Displays the standard currency
Dn711634.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif convertToNegativeRoyalty Returns a negative royalty amount if royalty quantity is negative or if the related sales line is a return item.
Dn711634.pubmethod(en-us,AX.60).gif cumulateGapRoyaltyTotal Creates royalties by considering the amount difference between earned royalties and royalties that were already paid.
Dn711634.pubmethod(en-us,AX.60).gif custInvoiceTrans Returns the CustInvoiceTrans record that relates to the current record.
Dn711634.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif defaultField Populates default values in a field in the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif defaultRow Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif delete Deletes the current record from the database.
Dn711634.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.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.)
Dn711634.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.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif endOfCumulationPeriod Finds the end date for the period type selected for the royalty agreement.
Dn711634.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getDefaultDimension Finds the default dimensions that should be used on the royalty postings.
Dn711634.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif initFromCustInvoiceJour Initializes the MCRRoyaltyVendTable table record with the values from an CustInvoiceJour and CustInvoiceTrans records.
Dn711634.pubmethod(en-us,AX.60).gif initFromMCRRoyaltyTablePricing Initializes the MCRRoyaltyVendTable table record with the values from MCRRoyaltyTablePricing table record.
Dn711634.pubmethod(en-us,AX.60).gif initRoyaltyClaimId Initializes the royalty Id from NumberSeq.
Dn711634.pubmethod(en-us,AX.60).gif initValue Initializes a field to the default value. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif insert Inserts the current record into the database.
Dn711634.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif ledgerPostingAmount Returns the amount to post.
Dn711634.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif mcrRoyaltyContract Returns the corresponding TAMVendRebateAgreement record.
Dn711634.pubmethod(en-us,AX.60).gif mcrRoyaltyTable Finds the associated MCRRoyaltyTable buffer.
Dn711634.pubmethod(en-us,AX.60).gif mcrRoyaltyTablePricing Finds the associated MCRRoyaltyTablePricing buffer.
Dn711634.pubmethod(en-us,AX.60).gif mcrRoyaltyVendTableCorrectedAmount Calculates the total corrected rebate amount.
Dn711634.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif modifiedField Modifies the specified field to the original. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif modifiedFieldValue Modifies the specified field to the original value. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Dn711634.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.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Dn711634.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.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Dn711634.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. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif royaltyAmountPerUnit Calculates the royalty amount when the royalty amount type is calculated per unit.
Dn711634.pubmethod(en-us,AX.60).gif royaltyTableProcess Gets the MCRRoyaltyVendTableProcess class instance.
Dn711634.pubmethod(en-us,AX.60).gif royaltyTableProcessedAmount Calculates the total processed royalty amount.
Dn711634.pubmethod(en-us,AX.60).gif royaltyTableSum Calculates the total amount and total quantities for all royalties related to the selected royalty in order to apply the correct royalty amount.
Dn711634.pubmethod(en-us,AX.60).gif royaltyTableSumAll Calculates the total royalty amount for all royalties with the passed in RecId from MCRRoyaltyTable.
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setCorrectedRoyaltyAmount Sets the corrected royalty amount on the current royalty record.
Dn711634.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setFinalStatus Sets the final status of the royalty based on its current status.
Dn711634.pubmethod(en-us,AX.60).gif setNextStatus Sets the next status of the royalty based on it's current status.
Dn711634.pubmethod(en-us,AX.60).gif setRoyaltyBalance Sets the royalty balance on the current royalty record.
Dn711634.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.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.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif startOfCumulationPeriod Finds the start date for the period type selected for the royalty agreement.
Dn711634.pubmethod(en-us,AX.60).gif status Gets the MCRRoyaltyVendTableStatusType class instance based on the royalty status.
Dn711634.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif type Gets the MCRRoyaltyVendTableStatusType class instance based on the rebate type.
Dn711634.pubmethod(en-us,AX.60).gif unitType Displays MCRRoyaltyUnitType from the MCRRoyaltyTable table.
Dn711634.pubmethod(en-us,AX.60).gif update Updates the current record. (Inherited from xRecord.)
Dn711634.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.)
Dn711634.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif validateField Determines whether the specified field is valid. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif validateFieldValue Validates changes to a field in the PdsRebateTable table.
Dn711634.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Dn711634.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif write Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::applyBatchRoyalties Creates royalties for the customer invoice transactions that falls in particular date range.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::checkIfRoyaltyClaimsExist Validates whether a royalty claim record exists based on the passed in parameters.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::cumulateRoyalties Calculates the cumulative royalty amount.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::existReferenceId Checks to see if a MCRRoyaltyVendTable exists based on passed parameters
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::existRoyaltyCode Validates whether a royalty table record exists with the passed in MCRRoyaltyCode.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::findByRecId Finds a royalty record based on the passed in RecId.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::processRoyalties Performs the royalty processing.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::processRoyaltyPayments Performs the royalty payment processing.
Dn711634.pubmethod(en-us,AX.60).gifDn711634.static(en-us,AX.60).gif ::purgeRoyalties Deletes all royalties with a status of 'Processed'.

Top

Fields

Field Type Configuration key Description
CorrectedRoyaltyAmt Extended Data Type: MCRCorrectedRoyaltyAmt
Type: Real
 MCRRoyalty Corrected royalty amount. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
 None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CurrencyCode Extended Data Type: CurrencyCode
Type: String
 None Current currency code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CustAccount Extended Data Type: AccountNum
Type: String
 None Number identifying the account. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CustInvoiceJourRefRecId Extended Data Type: PdsCustInvoiceJourRefRecId
Type: Int64
 PdsRebate Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
custInvoiceTransRefRecId Extended Data Type: PdsCustInvoiceTransRefRecId
Type: Int64
 PdsRebate Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CustomerRef Extended Data Type: PdsCustomerRef
Type: String
 PdsRebate Recurring position operation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CWSalesInvoicedQty Extended Data Type: PdsCWInventQty
Type: Real
 PdsCatchWeight Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
dataAreaId Extended Data Type: DataAreaId
Type: String
 None (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)
InventTransId Extended Data Type: InventTransId
Type: String
 LogisticsBasic Identification of the item lot. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
ItemId Extended Data Type: ItemId
Type: String
 LogisticsBasic Identify item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
ItemRoyaltyGroupId Extended Data Type: MCRItemRoyaltyGroupId
Type: String
 MCRRoyalty Item royalty group identification (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
LedgerDimension Extended Data Type: LedgerDimensionDefaultAccount
Type: Int64
 LedgerBasic Default main account used for posting in ledger (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MarkForCredit Enumeration: NoYes
 None Mark record. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRRoyaltyTableRefRecId Extended Data Type: PdsRebateAgreementRefRecId
Type: Int64
 PdsRebate Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
OffsetLedgerDimension Extended Data Type: MCRRoyaltyOffsetDimensionDefaultAccount
Type: Int64
 MCRRoyalty The account used for interim expense postings (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Partition Extended Data Type: Partition
Type: Int64
 None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
ProcessDate Extended Data Type: PdsProcessDate
Type: Date
 PdsRebate Process date. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RecId Extended Data Type: RecId
Type: Int64
 None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
recVersion Extended Data Type: RecVersion
Type: Integer
 None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyAdjustmentDate Extended Data Type: PdsRebateAdjustmentDate
Type: Date
 PdsRebate Adjustment date after a rebate recalculation following a rebate modification. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyAgreementLineRefRecId Extended Data Type: PdsRebateAgreementRefRecId
Type: Int64
 PdsRebate Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyAmt Extended Data Type: PdsRebateAmt
Type: Real
 PdsRebate Rebate amount available for consumption. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyAmtType Enumeration: MCRRoyaltyAmtType
 MCRRoyalty Indicates the type of the royalty value. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyBalance Extended Data Type: MCRRoyaltyBalance
Type: Real
 MCRRoyalty Royalty balance amount. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyCalcDate Extended Data Type: PdsRebateCalcDate
Type: Date
 PdsRebate The date on which the rebate was calculated. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyClaimId Extended Data Type: MCRRoyaltyId
Type: String
 MCRRoyalty Royalty claim ID that is generated by generate claims. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyCode Extended Data Type: MCRRoyaltyCode
Type: String
 None The code value assigned to the royalty reference (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyJournalRefNum Extended Data Type: PdsJournalRefNum
Type: String
 PdsRebate Posting journal number reference. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyMinAmt Extended Data Type: TAMRebateMinAmt
Type: Real
 TAMVendorRebate The minimum amount that must be on the purchase order to acquire the rebate. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyMinQty Extended Data Type: TAMVendRebateMinQty
Type: Integer
 TAMVendorRebate Minimum quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyPayTo Extended Data Type: VendAccount
Type: String
 None Vendor account number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyStatus Enumeration: MCRRoyaltyVendTableStatus
 MCRRoyalty Royalty status (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RoyaltyValue Extended Data Type: PdsRebateValue
Type: Real
 PdsRebate Rebate value. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesAmount Extended Data Type: SalesAmount
Type: Real
 None The total of sales price multiplied by quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesId Extended Data Type: SalesId
Type: String
 LogisticsBasic Identification of the order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesInvoiceDate Extended Data Type: InvoiceDate
Type: Date
 None Date of invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesInvoicedQty Extended Data Type: SalesInvoicedQty
Type: Real
 None Quantity that was invoiced in sales units. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesInvoiceId Extended Data Type: SalesInvoiceId
Type: String
 LogisticsBasic Identification of the invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesLineRefRecId Extended Data Type: PdsSalesLineRefRecId
Type: Int64
 PdsRebate Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesNetExtendedPrice Extended Data Type: PdsSalesNetExtdPrice
Type: Real
 PdsRebate The extended net price for the sales order line, excluding all discounts. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesPriceUnit Extended Data Type: PriceUnit
Type: Real
 LogisticsBasic Number of units the price is specified in. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
SalesTableRefRecId Extended Data Type: PdsSalesTableRefRecId
Type: Int64
 PdsRebate Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
StartingRoyaltyAmt Extended Data Type: MCRStartingRoyaltyAmt
Type: Real
 MCRRoyalty The royalty amount set at the creation of the royalty. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
VendAccount Extended Data Type: VendAccount
Type: String
 None Vendor account number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
VendRoyaltyGroupId 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)

Top

Field Groups

Field Group Fields
General
Accounts
All
AutoReport
CustTable
InventTable
MarkForCredit
Overview
References
Royalty
VendTable
SalesTable

Top

Relations

Relation Table Lines
Currency Currency
CustInvoiceJourInvoiceId CustInvoiceJour
CustInvoiceJourRef CustInvoiceJour
CustInvoiceTrans CustInvoiceTrans
CustTransOpen CustTransOpen
dataAreaId DataArea
InventTable InventTable
InventTransOrigin InventTransOrigin
LedgerDimension DimensionAttributeValueCombination
MCRRoyaltyTable MCRRoyaltyTable
MCRRoyaltyTablePricing MCRRoyaltyTablePricing
OffsetLedgerDimension DimensionAttributeValueCombination
Partition Partitions
PdsAgreementRefRecId PdsRebateAgreement
PdsRebateTable PdsRebateTable
RoyaltyCode MCRRoyaltyTable
SalesLineRef SalesLine
SalesTable SalesTable
SalesTableRef SalesTable
VendAccount VendTable
Vendtable VendTable

Top

Indexes

Index AllowDuplicates Enabled Fields
InventTransIdIdx Yes Yes
ProcessDateStatusIdx Yes Yes
RecId No Yes
RoyaltyCodeIdx No Yes
RoyaltyTableRefRecIdx Yes Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    MCRRoyaltyVendTable Table

See Also

Table Methods

Tables Overview