Share via


SalesQuotationLine Table

The SalesQuotationLine table contains sales quotation lines.

Configuration Key: QuotationBasic

Methods

  Method Description
Gg856359.pubmethod(en-us,AX.60).gif accountConsumption
Gg856359.pubmethod(en-us,AX.60).gif accountDisc
Gg856359.pubmethod(en-us,AX.60).gif accountIssue
Gg856359.pubmethod(en-us,AX.60).gif accountSales
Gg856359.pubmethod(en-us,AX.60).gif amountExclTax
Gg856359.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif assessableValue_IN Gets the assessable value.
Gg856359.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif busRelAccount
Gg856359.pubmethod(en-us,AX.60).gif calcGrossAmount
Gg856359.pubmethod(en-us,AX.60).gif calcGrossAmountExclTax
Gg856359.pubmethod(en-us,AX.60).gif calcLineAmount
Gg856359.pubmethod(en-us,AX.60).gif calcLineAmountExclTax
Gg856359.pubmethod(en-us,AX.60).gif calcLineAmountForced
Gg856359.pubmethod(en-us,AX.60).gif calcLineDiscExclTax
Gg856359.pubmethod(en-us,AX.60).gif calcPackingUnit
Gg856359.pubmethod(en-us,AX.60).gif calcPackingUnitQty
Gg856359.pubmethod(en-us,AX.60).gif calcPrice2LineAmount
Gg856359.pubmethod(en-us,AX.60).gif calcQtyOrdered
Gg856359.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif canEditDisc
Gg856359.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Indicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif checkCFOP_BR Validates whether CFOP is present in the CFOPMatrix table and has the correct attributes (operation ID, transaction type, direction, and location).
Gg856359.pubmethod(en-us,AX.60).gif checkCurrencyCode
Gg856359.pubmethod(en-us,AX.60).gif checkCustomsTariffCode_IN Checks the customs tariff code.
Gg856359.pubmethod(en-us,AX.60).gif checkDelete
Gg856359.pubmethod(en-us,AX.60).gif checkFindProjJournalTxt
Gg856359.pubmethod(en-us,AX.60).gif checkInitFromInventTable
Gg856359.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif checkInventDim Validates product and mandatory dimensions.
Gg856359.pubmethod(en-us,AX.60).gif checkItemId
Gg856359.pubmethod(en-us,AX.60).gif checkItemPBAId
Gg856359.pubmethod(en-us,AX.60).gif checkLedgerDimension
Gg856359.pubmethod(en-us,AX.60).gif checkMaximumRetailPrice_IN Checks the maximum retail price.
Gg856359.pubmethod(en-us,AX.60).gif checkPriceDate Triggers price recalculation after date change according to the price date type setting.
Gg856359.pubmethod(en-us,AX.60).gif checkQuotationType
Gg856359.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif checkSalesCategory Check that the sales category field is filled correctly.
Gg856359.pubmethod(en-us,AX.60).gif checkSalesUnit
Gg856359.pubmethod(en-us,AX.60).gif checkTaxItemGroup
Gg856359.pubmethod(en-us,AX.60).gif checkUpdatePhysical
Gg856359.pubmethod(en-us,AX.60).gif clear Removes all rows from the table buffer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif clearAddressReference
Gg856359.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif companyInfo Retrieves the CompanyInfo record associated with the current record.
Gg856359.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif convertCurrencyCode
Gg856359.pubmethod(en-us,AX.60).gif convertToDeliverySchedule Converts an order line into a delivery schedule with a single delivery line.
Gg856359.pubmethod(en-us,AX.60).gif copyDimension Copies a dimension set that can be applied to the defaultDimension field on the SalesQuotationLine table.
Gg856359.pubmethod(en-us,AX.60).gif createFromTmpFrmVirtual Creates a sales quotation line from a TmpFrmVirtual record buffer.
Gg856359.pubmethod(en-us,AX.60).gif createLine Creates a sales quotation line.
Gg856359.pubmethod(en-us,AX.60).gif createMarkupTrans
Gg856359.pubmethod(en-us,AX.60).gif creditNoteLine
Gg856359.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif defaultField Populates default values in a field in the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif defaultRow Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif delete
Gg856359.pubmethod(en-us,AX.60).gif deleteInventTrans_BR Deletes the inventTrans record that is related to the current salesQuotationLine record if the order operation is configured so that it does not create inventory transactions.
Gg856359.pubmethod(en-us,AX.60).gif deliveryAddress
Gg856359.pubmethod(en-us,AX.60).gif deliveryLocation
Gg856359.pubmethod(en-us,AX.60).gif deliveryName
Gg856359.pubmethod(en-us,AX.60).gif deliveryTerm
Gg856359.pubmethod(en-us,AX.60).gif deliveryTransDateTime
Gg856359.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif discAmount
Gg856359.pubmethod(en-us,AX.60).gif discPercent
Gg856359.pubmethod(en-us,AX.60).gif displayAddress_IN Gets the address information for display.
Gg856359.pubmethod(en-us,AX.60).gif displayDeliveryName
Gg856359.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif dlvAddress
Gg856359.pubmethod(en-us,AX.60).gif dlvDate
Gg856359.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.)
Gg856359.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.)
Gg856359.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.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif editProductDimensionsAllowed Determines whether the product directions on the line can be edited.
Gg856359.pubmethod(en-us,AX.60).gif endDisc
Gg856359.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif exciseManufacture_IN Gets the correct value of ExciseManufacture_IN for given parameters.
Gg856359.pubmethod(en-us,AX.60).gif exciseNone_IN Gets the correct value of ExciseNone_IN for given parameters.
Gg856359.pubmethod(en-us,AX.60).gif exciseTraders_IN Gets the correct value of ExciseTraders_IN for given parameters.
Gg856359.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getDeliveryEntityRecord Gets the delivery entity record that is based on the postal address.
Gg856359.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getMiscChargesAmount_IN Gets the amount.
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif hasOnlyLineAmount
Gg856359.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif inclTax
Gg856359.pubmethod(en-us,AX.60).gif initFromCustExternalItemDescription
Gg856359.pubmethod(en-us,AX.60).gif initFromCustQuotationConfirmTrans
Gg856359.pubmethod(en-us,AX.60).gif initFromCustQuotationTrans
Gg856359.pubmethod(en-us,AX.60).gif initFromCustTable
Gg856359.pubmethod(en-us,AX.60).gif initFromEmplTable
Gg856359.pubmethod(en-us,AX.60).gif initFromInventTable
Gg856359.pubmethod(en-us,AX.60).gif initFromItemOrCategory
Gg856359.pubmethod(en-us,AX.60).gif initFromOrderLineWithMultipleDeliveries Initializes a delivery line based on its order line.
Gg856359.pubmethod(en-us,AX.60).gif initFromPriceDisc
Gg856359.pubmethod(en-us,AX.60).gif initFromProductDimensions
Gg856359.pubmethod(en-us,AX.60).gif initFromProjCategoryId
Gg856359.pubmethod(en-us,AX.60).gif initFromProjInvoiceItem
Gg856359.pubmethod(en-us,AX.60).gif initFromProjTable
Gg856359.pubmethod(en-us,AX.60).gif initFromSalesQuotationBasketLine
Gg856359.pubmethod(en-us,AX.60).gif initFromSalesQuotationLine
Gg856359.pubmethod(en-us,AX.60).gif initFromSalesQuotationLine_IN Initializes the fields of a SalesQuotationLine record from a given SalesQuotationLine buffer.
Gg856359.pubmethod(en-us,AX.60).gif initFromSalesQuotationTable
Gg856359.pubmethod(en-us,AX.60).gif initFromTmpSuppItem
Gg856359.pubmethod(en-us,AX.60).gif initItemDim
Gg856359.pubmethod(en-us,AX.60).gif initName
Gg856359.privmethod(en-us,AX.60).gif initRetailVariantId
Gg856359.pubmethod(en-us,AX.60).gif initSalesQty
Gg856359.pubmethod(en-us,AX.60).gif initValue Initializes field values in a new SalesQuotationLine record.
Gg856359.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif insert
Gg856359.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif inventDim
Gg856359.pubmethod(en-us,AX.60).gif inventTable
Gg856359.pubmethod(en-us,AX.60).gif invoiceAccount
Gg856359.pubmethod(en-us,AX.60).gif isCategoryBased Checks whether the order line is category based.
Gg856359.pubmethod(en-us,AX.60).gif isDropShipment Determines whether the order line is part of a drop shipment.
Gg856359.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif isItemOrNoneAndCategoryBased Indicates whether the line has transaction type of item or none, and category based.
Gg856359.pubmethod(en-us,AX.60).gif isLinkedToAgreement Identifies that the sales quotation line is linked to an agreement line.
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif isStocked Indicates whether the order line is tracked in inventory.
Gg856359.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif itemIdChanged
Gg856359.pubmethod(en-us,AX.60).gif itemLineDisc
Gg856359.pubmethod(en-us,AX.60).gif itemName
Gg856359.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif lineAmountExclTax
Gg856359.pubmethod(en-us,AX.60).gif lineAmountModified
Gg856359.pubmethod(en-us,AX.60).gif lineAmountMST
Gg856359.pubmethod(en-us,AX.60).gif lineAmountMSTExclTax
Gg856359.pubmethod(en-us,AX.60).gif lineDeliveryImageRessNo Determines the delivery type of a line.
Gg856359.pubmethod(en-us,AX.60).gif lineDisc
Gg856359.pubmethod(en-us,AX.60).gif linkInventDim2Dimension Applies default SalesQuotationLine.dimension values that are based on the InventDim record buffer values.
Gg856359.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif logisticsAddress_IN Reads the LogisticsPostalAddress table for the specified RegistrationLocation value (location ID).
Gg856359.pubmethod(en-us,AX.60).gif markupAllowed
Gg856359.pubmethod(en-us,AX.60).gif matchingAgreementLine Retrieves the value of the related MatchingAgreementLine class.
Gg856359.pubmethod(en-us,AX.60).gif mcrCalcCostPrice Calculates the cost price of the item on the SalesQuotationLine.
Gg856359.pubmethod(en-us,AX.60).gif mcrCreateFromTmpFrmVirtual Creates a sales quotation line from a TmpFrmVirtual record buffer.
Gg856359.pubmethod(en-us,AX.60).gif mcrDeleteRelatedLineItems Deletes the line(s) record.
Gg856359.pubmethod(en-us,AX.60).gif mcrDisplayMarginPercentStr Displays the margin percentage.
Gg856359.pubmethod(en-us,AX.60).gif mcrDisplayPhone Displays the phone for the address of the current record.
Gg856359.pubmethod(en-us,AX.60).gif mcrNextChildLineNum Gets a line number for a child line.
Gg856359.pubmethod(en-us,AX.60).gif mcrPackMCRSalesParmLine Packs the sales quotation line information.
Gg856359.pubmethod(en-us,AX.60).gif mcrPackMCRSalesQuotationLine Packs the sales quotation line information.
Gg856359.pubmethod(en-us,AX.60).gif mcrPackMCRSalesQuotationLineOverride Packs the sales quotation line information.
Gg856359.pubmethod(en-us,AX.60).gif mcrPricePerSalesQty Gets the price per quantity value.
Gg856359.pubmethod(en-us,AX.60).gif mcrSalesQuotationLine Recovers SalesQuotationLine extension table
Gg856359.pubmethod(en-us,AX.60).gif mcrSalesQuotationLineOverride Gets SalesQuotationLineOverride extension table
Gg856359.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif mergeDimension Retrieves a dimension set that holds the merged combination of the current defaultDimension field on this table and the provided dimension set.
Gg856359.pubmethod(en-us,AX.60).gif modifiedField
Gg856359.pubmethod(en-us,AX.60).gif modifiedField_Project
Gg856359.pubmethod(en-us,AX.60).gif modifiedField_Sales
Gg856359.pubmethod(en-us,AX.60).gif modifiedFieldDDC Processes the modified field event for delivery date control fields.
Gg856359.pubmethod(en-us,AX.60).gif modifiedFieldValue Executes when a field has been modified.
Gg856359.pubmethod(en-us,AX.60).gif modifyInventDim
Gg856359.pubmethod(en-us,AX.60).gif moduleType
Gg856359.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif nextLineNum
Gg856359.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.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif onCFOPChange_BR Is executed when the CFOP value is changed.
Gg856359.pubmethod(en-us,AX.60).gif onDeliveryPostalAddressChange_BR Is executed after the delivery postal address is changed.
Gg856359.pubmethod(en-us,AX.60).gif onTaxChange_BR Is executed when the tax group is changed.
Gg856359.pubmethod(en-us,AX.60).gif orderAccount
Gg856359.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif party
Gg856359.privmethod(en-us,AX.60).gif pdsCWQtyConversion Updates the sales quantity from the converted catch weight quantity.
Gg856359.pubmethod(en-us,AX.60).gif pdsCWQtyModified Updates quantities based on changed catch weight value.
Gg856359.pubmethod(en-us,AX.60).gif pdsCWUnitId Gets the catch weight unit for the item.
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif postDiscPercent_BR Retrieves the discount percentage.
Gg856359.pubmethod(en-us,AX.60).gif postingSales
Gg856359.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif postModifyInventDim_BR Is executed after the inventory dimension is changed.
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif priceDate Retrieves the date for which the price has to be calculated according to the price date type setting.
Gg856359.pubmethod(en-us,AX.60).gif priceGroupId
Gg856359.pubmethod(en-us,AX.60).gif projId
Gg856359.pubmethod(en-us,AX.60).gif psaDeleteActivityEstimates
Gg856359.pubmethod(en-us,AX.60).gif psaUpdateActivityEstimates
Gg856359.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Gg856359.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.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif runPriceDiscPolicyDialog Calls the runPriceDiscPolicyDialog method of the PriceDiscResultFields table map.
Gg856359.pubmethod(en-us,AX.60).gif salesPurchTable
Gg856359.pubmethod(en-us,AX.60).gif salesQtyModified
Gg856359.pubmethod(en-us,AX.60).gif salesQuotationTable
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setAddressFromSalesQuotationLine
Gg856359.pubmethod(en-us,AX.60).gif setAddressFromSalesQuotationTable
Gg856359.privmethod(en-us,AX.60).gif setCFOP_BR Is responsible for setting the CFOP code.
Gg856359.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setCostSalesPrice
Gg856359.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setDeliveryDateControlType Sets the delivery date control type for the current sales quotation line.
Gg856359.pubmethod(en-us,AX.60).gif setDeliveryName Sets the delivery name field by using a specified logistic location.
Gg856359.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setInventDeliverNow
Gg856359.pubmethod(en-us,AX.60).gif setInventDimId Applies the InventDimId parameter to the SalesQuotationLine.inventDimId field and assigns default values that are based on the new inventory dimensions.
Gg856359.pubmethod(en-us,AX.60).gif setInventDimIdFromInventDim Finds or creates an InventDimId value for the InventDim parameter and applies the found InventDimId to the SalesQuotationLine.inventDimId field.
Gg856359.pubmethod(en-us,AX.60).gif setLineAmount
Gg856359.pubmethod(en-us,AX.60).gif setLineProperty
Gg856359.pubmethod(en-us,AX.60).gif setListCode
Gg856359.pubmethod(en-us,AX.60).gif setLocation
Gg856359.pubmethod(en-us,AX.60).gif setPriceAgreement
Gg856359.pubmethod(en-us,AX.60).gif setPriceDisc
Gg856359.pubmethod(en-us,AX.60).gif setPriceDiscChangePolicy Calls the setPriceDiscChangePolicy method of the PriceDiscResultFields table map.
Gg856359.pubmethod(en-us,AX.60).gif setPriceDiscMarkup Calls setPriceDiscMarkup method on the SalesPurchLine table map.
Gg856359.pubmethod(en-us,AX.60).gif setPriceDiscPriceUnit The method calls the setPriceDiscPriceUnit method on the SalesPurchLine table map.
Gg856359.pubmethod(en-us,AX.60).gif setQuotationStatus
Gg856359.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setStockedProduct Sets the StockedProduct field for the line based on line type and item model group for the associated item.
Gg856359.privmethod(en-us,AX.60).gif setSuframaDiscount_BR Calculates the SUFRAMA discount.
Gg856359.pubmethod(en-us,AX.60).gif setTaxGroup
Gg856359.pubmethod(en-us,AX.60).gif setTaxGroupAndTaxItemGroupFields_BR Sets the SalesQuotationLine.TaxGroup and SalesQuotationLine.TaxItemGroup values, based on the TaxesMatrix record.
Gg856359.pubmethod(en-us,AX.60).gif setTaxInfoOfCompany_IN Reads the table buffer and sets the field to the required value.
Gg856359.pubmethod(en-us,AX.60).gif setTaxItemGroup
Gg856359.pubmethod(en-us,AX.60).gif setTemplateFieldSpecieal
Gg856359.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif skipMarkup
Gg856359.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.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif stockedProductChanged Applies default values or sets the inventory related field values to nullNothingnullptrunita null reference (Nothing in Visual Basic) when the StockedProduct field value is changed.
Gg856359.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif taxPcsPrice
Gg856359.pubmethod(en-us,AX.60).gif timeZoneSite
Gg856359.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif type
Gg856359.pubmethod(en-us,AX.60).gif update
Gg856359.privmethod(en-us,AX.60).gif updateMarkupTransTaxGroups_BR Updates the markup transaction, based on the tax group and tax item group.
Gg856359.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.)
Gg856359.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database.
Gg856359.pubmethod(en-us,AX.60).gif validateField Validates a passed in field.
Gg856359.pubmethod(en-us,AX.60).gif validateFieldValue (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif validateProjectDate Checks the project transaction date valid or not.
Gg856359.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written to the database.
Gg856359.pubmethod(en-us,AX.60).gif validateWrite_Server
Gg856359.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg856359.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gif write
Gg856359.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::createQuotationLineFromTemplate
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::exist
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::existDifferentCurrency
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::existItemId Whether a record exists for the specified item.
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::find
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::findInventTransId
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::findPSARefRecId
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::findRecId
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::lastDeliveryScheduleLineNum Retrieves the last line number that is used by the delivery lines linked to the specified order line.
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::lastLineNum
Gg856359.privmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::mcrCreateFromTmpFrmVirtualIL Executes the creation of sales order quotation lines based on TmpFrmVirtual records in IL.
Gg856359.privmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::mcrCreateFromTmpFrmVirtualServer Executes the creation of sales order lines based on TmpFrmVirtual records on the server.
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::modifySalesQty
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::resetAxSalesQuotationLinePolicies Resets the price discount policies.
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::updateTransfered2Forecast
Gg856359.pubmethod(en-us,AX.60).gifGg856359.static(en-us,AX.60).gif ::updateTransfered2ItemReq

Top

Fields

Field Type Configuration key Description
AccountType Enumeration: LedgerJournalACType
None Account type that specifies the type of account the transaction will be applied to.
AddressRefRecId Extended Data Type: AddressRefRecId
Type: Int64
None Reference field in a different table
AddressRefTableId Extended Data Type: AddressRefTableId
Type: Integer
None Table the transaction refers to.
AssessableValue_IN Extended Data Type: AmountCur
Type: Real
None Assessable value for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
BarCode Extended Data Type: SalesBarCode
Type: String
LogisticsBasic Bar code digits
BarCodeType Extended Data Type: BarcodeSetupId
Type: String
None Select or view the bar code setup ID
CaseTagging Extended Data Type: RFIDCaseTagging
Type: Enum
RFIDTagging Is case tagging mandatory?
CFOPTable_BR Extended Data Type: RefRecId
Type: Int64
None Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Company Extended Data Type: SelectableDataArea
Type: String
None ID for the company you can select
CompanyLocation_IN Extended Data Type: LogisticsLocationRecId
Type: Int64
None Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ConfirmedDlv Extended Data Type: SalesShippingDate
Type: Date
LogisticsBasic Confirmed ship date if exists, otherwise requested ship date
Consignment_IN Extended Data Type: NoYesId
Type: Enum
None Is this a consignment transaction? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CostPrice Extended Data Type: ReturnCostPrice
Type: Real
LogisticsBasic Cost price per unit of the returned item.
CountyOrigDest Extended Data Type: AddressCountyOrigDest
Type: String
None Intrastat county of origin/destination.
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
None
CurrencyCode Extended Data Type: CustCurrencyCode
Type: String
None Currency the line is invoiced in
CustAccount Extended Data Type: CustAccount
Type: String
None Customer account
CustomerRef Extended Data Type: CustRefLine
Type: String
LedgerBasic Customer's reference
CustomsTariffCodeTable_IN Extended Data Type: RefRecId
Type: Int64
None Customs tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
LedgerBasic Default dimensions
DeliveryDateControlType Enumeration: SalesDeliveryDateControlType
SalesDeliveryDateControl Select for automatic calculation of possible ship and receipt dates.
DeliveryName Extended Data Type: LogisticsDeliveryName
Type: String
None The name that is associated with the selected delivery address
DeliveryPostalAddress Extended Data Type: LogisticsPostalAddressRecId
Type: Int64
TradeMultiShipTo Reference field in a different table
DirectSettlement_IN Enumeration: DirectSettlement_IN
None Excise register to update the excise amount to, without using the settlement process. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DlvMode Extended Data Type: DlvModeId
Type: String
None The means by which the order will be delivered
DlvTerm Extended Data Type: SalesDlvTermId
Type: String
None Specify terms of delivery for the current order line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
DSA_IN Extended Data Type: NoYesId
Type: Enum
None Update the Daily Stock Account (DSA)? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
EndDate Extended Data Type: TransDate
Type: Date
None End date is used with per code.
ExciseRecordType_IN Enumeration: ExciseRecordType_IN
None Excise record type to update the excise amount to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExciseTariffCodes_IN Extended Data Type: RefRecId
Type: Int64
None Excise tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExciseType_IN Enumeration: ExciseType_IN
None Excise-type category of the company. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExportOrder_IN Extended Data Type: NoYesId
Type: Enum
None Identifies the order as export order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ExternalItemId Extended Data Type: SalesExternalItemId
Type: String
LogisticsBasic Customer item number.
InventDeliverNow Extended Data Type: InventQty
Type: Real
None Quantity now being delivered in the inventory unit
InventDimId Extended Data Type: InventDimId
Type: String
None Identification of dimensions for the item.
InventRefId Extended Data Type: InventRefId
Type: String
None Number of the order, project, production, or purchase referred to
InventRefTransId Extended Data Type: InventRefTransId
Type: String
LogisticsBasic Lot ID referred to.
InventRefType Enumeration: InventRefType
None Module and number referred to
InventTransId Extended Data Type: TradeInventTransId
Type: String
LogisticsBasic Identification of the item lot.
ItemBOMId Extended Data Type: ItemBOMId
Type: String
BOMVersion BOM number for specific sub-BOM. If blank, the active number is used.
ItemId Extended Data Type: ItemIdSmall
Type: String
LogisticsBasic Item number in order line
ItemPBAId Extended Data Type: PBAId
Type: String
PBA_ProductBuilder Product model ID
ItemRouteId Extended Data Type: ItemRouteId
Type: String
ProdRouting Route number for specific subroute. If blank, the active number is used.
ItemTagging Extended Data Type: RFIDItemTagging
Type: Enum
RFIDTagging Is item tagging mandatory?
LedgerDimension Extended Data Type: LedgerDimensionDefaultAccount
Type: Int64
LogisticsBasic Ledger account for posting lines to a specific sales account.
LineAmount Extended Data Type: SalesLineAmount
Type: Real
LogisticsBasic Sales amount of the line, including discount
LineDeliveryType Enumeration: LineDeliveryType
None Role of line in a delivery schedule
LineDisc Extended Data Type: SalesLineDisc
Type: Real
PriceDisc Line discount in amount per price unit.
LineHeader Extended Data Type: ItemFreeTxt
Type: String
LogisticsBasic Standard item description.
LineNum Extended Data Type: LineNum
Type: Real
None Quotation line number.
LinePercent Extended Data Type: SalesLinePercent
Type: Real
PriceDisc Line discount percentage.
LinePropertyId Extended Data Type: ProjLinePropertyId
Type: String
ProjBasic Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost
ManualEntryChangepolicy Extended Data Type: PriceDiscPolicyManual
Type: Int64
None -
MaximumRetailPrice_IN Extended Data Type: MaximumRetailPrice_IN
Type: Real
None Maximum retail price for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
MCROrderLine2PriceHistoryRef Extended Data Type: RefRecId
Type: Int64
None Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
modifiedDateTime Extended Data Type: ModifiedDateTime
Type: UtcDateTime
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MultiLnDisc Extended Data Type: SalesMultiLnDisc
Type: Real
PriceDisc Multiline discount per price unit
MultiLnPercent Extended Data Type: SalesMultiLnPercent
Type: Real
PriceDisc The multiline discount percentage
Name Extended Data Type: ItemFreeTxt
Type: String
LogisticsBasic Line description
NewSalesPrice Extended Data Type: SalesPrice
Type: Real
None New sales price after price simulation.
NewTotalContributionRatio Extended Data Type: Price
Type: Real
None New contribution ratio after price simulation.
OffsetAccountType Enumeration: LedgerJournalACType
None Specify account type of the selected account, for instance ledger, customer or vendor.
OffsetCompany Extended Data Type: SelectableDataArea
Type: String
LedgerAdvIntercompanyAccounting Abbreviation of the company accounts where the current line is to be offset.
OffsetLedgerDimension Extended Data Type: LedgerDimensionDefaultAccount
Type: Int64
LedgerBasic Offset account for the transaction.
OffsetTxt Extended Data Type: LedgerJournalTransTxt
Type: String
None Any additional text for offset transaction.
OrigCostPrice Extended Data Type: CostPrice
Type: Real
None Cost price in standard currency.
OverDeliveryPct Extended Data Type: SalesOverDeliveryPct
Type: Real
LogisticsOverUnderDelivery The percentage by which the product receipt quantity is allowed to exceed the order quantity
PackingUnit Extended Data Type: InventPackingUnit
Type: String
InventPackaging Unit the item is packed in
PackingUnitQty Extended Data Type: InventPackingUnitQty
Type: Real
InventPackaging Quantity of packing units
PalletTagging Extended Data Type: RFIDPalletTagging
Type: Enum
RFIDTagging Is pallet tagging mandatory?
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))
PdsCWDeliverNow Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeight Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWQty Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeight Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCWRemainInventPhysical Extended Data Type: PdsCWInventQty
Type: Real
PdsCatchWeight Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
Port Extended Data Type: IntrastatPortId
Type: String
ForeignTrade Port where current delivery is loaded.
PriceCalcId Extended Data Type: PriceCalcId
Type: String
BOM Unique identification of the calculation.
PriceUnit Extended Data Type: PriceUnit
Type: Real
LogisticsBasic Number of units the quantity applies to.
ProjActivity Extended Data Type: smmActivityNumber
Type: String
Project3 The activity number (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))
ProjCategoryId Extended Data Type: QuotationProjCategory
Type: String
ProjQuotation Category that is used as a default.
ProjDescription Extended Data Type: Description
Type: String
None Brief description of transaction
ProjectWorker Extended Data Type: ProjWorkerRecId
Type: Int64
None The name of the worker
ProjTransType Enumeration: QuotationProjTransType
QuotationBasic Specifies the project transaction types used when transferring to the project
PSARefRecId Extended Data Type: RefRecId
Type: Int64
Project3 Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
QtyOrdered Extended Data Type: InventQty
Type: Real
None Quantity ordered in the inventory unit.
QuotationId Extended Data Type: QuotationIdBase
Type: String
QuotationBasic The quotation identifier
QuotationStatus Enumeration: SalesQuotationStatus
QuotationBasic Quotation status types
QuotationType Enumeration: QuotationType
QuotationBasic Type of quotation
ReceiptDateRequested Extended Data Type: SalesReceiptDateRequested
Type: Date
SalesDeliveryDateControl The date that the customer asked to receive the order on
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
RemainInventPhysical Extended Data Type: InventQty
Type: Real
None Quantity - not yet packing slip delivered - in the inventory unit
RemainSalesFinancial Extended Data Type: SalesQty
Type: Real
None Quantity that has been packing slip delivered but not yet invoice updated.
RemainSalesPhysical Extended Data Type: SalesQty
Type: Real
None Quantity that has not yet been packing slip delivered.
RetailVariantId Extended Data Type: RetailVariantId
Type: String
Retail Item variants (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))
SalesCategory Extended Data Type: SalesCategory
Type: Int64
LogisticsBasic Category from the sales category hierarchy
SalesDeliverNow Extended Data Type: SalesQty
Type: Real
None Quantity that is delivered now.
SalesGroup Extended Data Type: CommissSalesGroup
Type: String
Commission Employee who 'sold' the line.
SalesMarkup Extended Data Type: SalesMarkup
Type: Real
LogisticsBasic Fixed charges on sales price, which are independent of quantity
SalesPrice Extended Data Type: SalesPrice
Type: Real
None Sales price of line per price unit
SalesQty Extended Data Type: SalesQty
Type: Real
None Quantity ordered in the sales unit
SalesTaxFormTypes_IN Extended Data Type: SalesTaxFormTypesRecId_IN
Type: Int64
None India sales tax form type for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SalesUnit Extended Data Type: SalesUnit
Type: String
None Unit the item is sold in.
ServiceCodeTable_IN Extended Data Type: RefRecId
Type: Int64
None Service code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ShippingDateRequested Extended Data Type: SalesShippingDateRequested
Type: Date
LogisticsBasic The day the selling company should ship the item in order to meet the customer's requested receipt date.
StartDate Extended Data Type: TransDate
Type: Date
None Date which the budget amount applies from.
StatProcId Extended Data Type: IntrastatProcId
Type: String
ForeignTrade Code for the current statistical procedure.
StatTriangularDeal Extended Data Type: IntrastatTriangularDeal
Type: Enum
ForeignTrade Is this a triangular deal?
StockedProduct Extended Data Type: TradeStockedProduct
Type: Enum
LogisticsBasic Track in inventory?
SuframaDiscount_BR Extended Data Type: SalesLinePercent
Type: Real
PriceDisc SUFRAMA discount percentage. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SystemEntryChangePolicy Extended Data Type: PriceDiscPolicySystem
Type: Int64
None -
SystemEntrySource Enumeration: PriceDiscSystemSource
None -
TaxAutoGenerated Extended Data Type: TaxAutoGenerated
Type: Enum
LedgerBasicSalesTax Sales tax is automatically calculated or specified by user.
TaxGroup Extended Data Type: TaxGroup
Type: String
LedgerBasicSalesTax A group of sales tax codes for calculating taxes on a sale or purchase
TaxInventVATCommodityCode_IN Extended Data Type: RefRecId
Type: Int64
None VAT commodity codes for item per state. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxItemGroup Extended Data Type: TaxItemGroup
Type: String
LedgerBasicSalesTax Group of sales tax codes that can be calculated for an item.
TCSGroup_IN Extended Data Type: TaxWithholdGroup
Type: String
LedgerBasicWithholdingTax TCS group for calculation of withholding tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TDSGroup_IN Extended Data Type: TaxWithholdGroup
Type: String
LedgerBasicWithholdingTax TDS group for calculation of withholding tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TransactionCode Extended Data Type: IntrastatTransactionCodeId
Type: String
ForeignTrade Code for the current transaction code.
TransDate Extended Data Type: ProjTransDate
Type: Date
ProjBasic Project transaction date
Transferred2Forecast Extended Data Type: NoYesId
Type: Enum
None Indicates whether the line has been transferred to a forecast
Transferred2ItemReq Extended Data Type: NoYesId
Type: Enum
None Indicates whether the line has been transferred to an item requirement
Transferred2Journal Extended Data Type: NoYesId
Type: Enum
None Has line been transferred to journal?
Transport Extended Data Type: IntrastatTransport
Type: String
ForeignTrade Specify means of transport for the current order.
UnderDeliveryPct Extended Data Type: SalesUnderDeliveryPct
Type: Real
LogisticsOverUnderDelivery The percentage by which the product receipt quantity is allowed to be less than the order quantity

Top

Field Groups

Field Group Fields
AccountSelection
AddressDisplay
AddressReference
AddressLookup
All
AutoReport
Barcode
Amount
Commission
CompanyLocation_IN
CompanyInformation_IN
Customs_IN
CustomerRef
Delivery
DeliveryAddress
Dimension
Discount
ExportOrder_IN
FiscalInformation_BR
Identification
Integration
Excise_IN
ForeignTrade
Inventory
ItemReference
ItemRouteId
OffsetAccount
PackagingMaterial
PdsCWInventory
RFIDtagging
SalesQuantity
ProjectTransferredStatus
ProjItem
ProjQuantity
QuotationLine
QuotationLines
ProjTransOverview
QuotationStatus
ReturnGroup
VAT_IN
WithholdingTax_IN
Price_IN
PriceSimulation
ProjActivityInfo
ProjDates
ProjectCostAmount
ProjectSalesAmount
PdsCWMain
Posting
Price
SalesTax_IN
ServiceTax_IN
SalesTax
SuframaDiscount_BR
TableGroup

Top

Relations

Relation Table Lines
BarcodeSetup BarcodeSetup
BOMCalcTable BOMCalcTable
BOMTable BOMTable
CFOPTable_BR CFOPTable_BR
CommissionSalesGroup CommissionSalesGroup
Common Common
CompanyDataArea DataArea
CompanyLocation_IN LogisticsLocation
CountyOrigDest LogisticsAddressCounty
Currency Currency
CustomsTariffCodeTable_IN CustomsTariffCodeTable_IN
CustTable CustTable
dataAreaId DataArea
DefaultDimension DimensionAttributeValueSet
DeliveryPostalAddress_FK LogisticsPostalAddress
DlvMode DlvMode
DlvTerm DlvTerm
ExciseTariffCodes_IN ExciseTariffCodes_IN
IntrastatPort IntrastatPort
IntrastatStatProc IntrastatStatProc
IntrastatTransactionCode IntrastatTransactionCode
IntrastatTransportMode IntrastatTransportMode
InventDim InventDim
InventItemBarcode InventItemBarcode
InventSum InventSum
InventTable InventTable
InventTransOrigin InventTransOrigin
LedgerDimension DimensionAttributeValueCombination
MCROrderLine2PriceHistoryRef MCROrderLine2PriceHistoryRef
OffsetAssetTable AssetTable
OffsetBank BankAccountTable
OffsetCompanyDataArea DataArea
OffsetCustTable CustTable
OffsetLedgerDimension DimensionAttributeValueCombination
OffsetProject ProjTable
OffsetVendTable VendTable
PackingUnit UnitOfMeasure
Partition Partitions
PBATable PBATable
PriceDiscChangePolicyRecId1 PriceDiscChangePolicy
PriceDiscChangePolicyRecId2 PriceDiscChangePolicy
ProjCategoryCost ProjCategory
ProjCategoryFee ProjCategory
ProjCategoryHour ProjCategory
ProjCategoryItem ProjCategory
ProjectWorker HcmWorker
ProjLineProperty ProjLineProperty
PSAActivityEstimates PSAActivityEstimates
RetailVariantId InventDimCombination
RouteTable RouteTable
SalesCategory EcoResCategory
SalesQuotationTable SalesQuotationTable
SalesTaxFormTypes_IN SalesTaxFormTypes_IN
SalesUnit UnitOfMeasure
ServiceCodeTable_IN ServiceCodeTable_IN
smmActivities smmActivities
TaxGroupHeading TaxGroupHeading
TaxInventVATCommodityCode_IN TaxInventVATCommodityCode_IN
TaxItemGroupHeading TaxItemGroupHeading
TaxWithholdGroupHeadingTCS_IN TaxWithholdGroupHeading
TaxWithholdGroupHeadingTDS_IN TaxWithholdGroupHeading

Top

Indexes

Index AllowDuplicates Enabled Fields
CFOPTable_BRIdx Yes Yes
CompanyLocation_INIdx Yes Yes
CustomsTariffCodeTable_INIdx Yes Yes
ExciseTariffCodes_INIdx Yes Yes
ItemIdx Yes Yes
ProjectWorkerIdx Yes Yes
QuotationLineIdx No Yes
QuotationTransTypeIdx Yes Yes
RecId No Yes
SalesTaxFormTypes_INIdx Yes Yes
ServiceCodeTable_INIdx Yes Yes
TransIdIdx No Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    SalesQuotationLine Table

See Also

Table Methods

Tables Overview