SalesLine Table

The SalesLine table contains all sales order lines regardless of whether they have been posted.

Configuration Key: LogisticsBasic

Methods

	Method	Description
	accountClearingLedgerDimension
	accountConsumptionLedgerDimension
	accountCustLedgerDimension
	accountDiscLedgerDimension
	accountGoodsInRouteOffset_RU
	accountIssueLedgerDimension
	accountSalesLedgerDimension
	agreementSkipAutoLink	Check whether this line should skip automatic AgreementLine matching.
	aiExistsOnOriginalInvoice	Verifies if an advance invoice exists for the original invoice being corrected.
	allowUpdateWithQualityOrder	Determines whether the update of the sales line is enabled.
	amountCur
	amountExclTax
	amountMST
	aosValidateDelete	Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
	aosValidateInsert	Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
	aosValidateRead	Validates on the server that the specified record can be read. (Inherited from xRecord.)
	aosValidateUpdate	Validates on the server that the specified record can be updated. (Inherited from xRecord.)
	associateWithAgreementLine	Associates the sales line with the agreement line.
	buf2con	Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
	calcCostAmount
	calcGrossAmount
	calcGrossAmountExclTax
	calcLineAmount
	calcLineAmountExclTax
	calcLineAmountForced
	calcLineAmountForcedInteraction	Calculates of line amount forced with user interaction if associated link to agreement order line becomes invalid.
	calcLineAmountInclTax_RU
	calcLineAmountInteraction	Calculates the line amount from a user interaction when the associated link to an agreement order.line is invalid.
	calcLineDisc
	calcLineDiscExclTax
	calcPackingUnit
	calcPackingUnitQty
	calcPrice2LineAmount
	calcQtyOrdered
	calcReturnCostAmount
	calculateCostPrice	Calculates cost price using given InventDim record.
	canAgreementBeLinked	Determines whether the sales line can be linked to an agreement line.
	canBeInvoiced
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	canEditDisc
	canSubmitToWorkflow	Indicates whether submission to workflow is possible. (Inherited from xRecord.)
	caption	Gets and sets the caption property of a table. (Inherited from xRecord.)
	checkActivity
	checkAndPromptFixedLineAmount
	checkCurrencyCode
	checkCustomsTariffCode_IN	Checks customs tariff code.
	checkDelete
	checkIfMarked
	checkIfUpdate
	checkInitFromInventTable
	checkIntrastat	Validates the intrastat setting on the item associated to the order line.
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	checkItemId
	checkItemPBAId
	checkMaximumRetailPrice_IN	This method is used to check the Maximum retail price.
	checkOverDelivery
	checkPostingProfile_RU
	checkPriceDate	Triggers a price recalculation after a date change according to the price date type setting.
	checkProjCategory
	checkRecord	Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
	checkReqActivity
	checkReservation
	checkReservationField
	checkRestrictedDeleteActions	Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
	checkSalesCategory	Check that the sales category field is filled correctly.
	checkSalesType
	checkSalesUnit
	checkStatusChange	Determines whether the status of an order line can be changed.
	checkStockedProduct	Checks that the StockedProduct field is not set for category based lines.
	checkTaxItemGroup
	checkUnderDelivery
	checkUpdatePhysical
	checkUpdatePicked
	clear	Removes all rows from the table buffer. (Inherited from xRecord.)
	clearAddressReference
	clearAllPriceDiscChangePolicies	Removes the price discount change policies for a sales line that have been previously set.
	clearInventReference	Clears the inventory reference fields on the SalesLine record.
	company	Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
	companyInfo	Retrieves the CompanyInfo record associated with the current record.
	con2buf	Unpacks a container into the table buffers. (Inherited from xRecord.)
	concurrencyModel	Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
	configId
	configIdChanged
	context	Gets and sets the context property. (Inherited from xRecord.)
	convertCurrencyCode
	convertToDeliverySchedule	Converts an order line into a delivery schedule with a single delivery line.
	copyDimension	Copies a dimension set that can be applied to the defaultDimension field on this table.
	copyShipCarrierInformation
	createAlternativeItem	Replaces the current item with an alternative item if an alternative item has been set up.
	createFromSalesQuotationLine
	createFromTmpFrmVirtual
	createLine
	createMarkupTrans
	createReplacement	Creates the replacement lines for each entry in the return replacement table that exist for a sales or return order line.
	createReturnMarkupTrans
	createReturnReservationLine
	createReturnReservationLineNonStocked
	createSourceDocumentLine	Creates the SourceDocumentLine record if one does not exist.
	createWarningIfNotReserved	Creates a warning if the currrent sales line is not reserved completely and it should have been.
	creditNoteLine
	custClassification
	data	Retrieves a row from the table. (Inherited from xRecord.)
	dataSource	Retrieves the data source of the table. (Inherited from xRecord.)
	defaultDeliveryName	Retrieves the default delivery name for the sales order line.
	defaultField	Populates default values in a field in the table. (Inherited from xRecord.)
	defaultRow	Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
	delete
	deleteInventTrans_BR	Delete the inventTrans related to the current salesLine if order operation is configured to do not create inventory transactions.
	deliveredInTotal
	deliveredInTotalServer
	deliveredInventInTotal
	deliveryAddress
	deliveryCNPJCPFNUM_BR	Returns the delivery CNPJ or CPF for the current record.
	deliveryDate
	deliveryIENum_BR	Returns the delivery IE for the current record.
	deliveryLocation
	deliveryTerm
	deliveryTransDateTime	Calculates the delivery date at midnight in the time zone of the site on the sales order line.
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	discAmount
	discPct_BR	Checks if the actual discount percentage should be changed by SuframaDiscount_BR field value
	discPercent	Displays the discount percentage.
	dispose	Releases resources that are used by the xRecord object. (Inherited from xRecord.)
	doClear	Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
	doDelete	Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
	doInsert	Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
	doReCalcPricesFromBasePrompt	Prompts the user who has a dialog box whether they wants to recalculate prices, depending on trade agreements.
	doUpdate	Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
	doValidateDelete	Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
	editProductDimensionsAllowed	Determines whether the item directions on the line can be edited.
	editReasonCode	Gets and sets a reason code.
	editReasonComment	Gets and sets the reason comment.
	effectiveSalesPrice	Gets the effective sales price.
	endDisc
	equal	Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
	eventNotificationUserId	Retrieves the sales order line responsible user ID that is used for notification.
	expandBOM
	fieldAccessRight	Returns the field access right. (Inherited from xRecord.)
	fieldBufferAccessRight	Returns the field access right for the current record. (Inherited from xRecord.)
	fieldChanged	Determines whether a field in a SalesLine buffer is changed.
	fieldState	Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
	getAllowRedefault	Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
	getDefaultingDependencies	Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
	getDeliveryEntityRecord	Gets the delivery entity record that is based on the postal address.
	getExtension	Returns the table extension. (Inherited from xRecord.)
	getFieldValue	Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
	getGrossVolumePerItem	Calculates the gross volume per item for the specified SalesLine record.
	getGrossWeightPerItem	Calculates the gross weight per item for the specified SalesLine record.
	getInstanceRelationType	Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
	getMiscChargesAmount_IN	This method is used to get the amount.
	getPhysicalTableName	Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
	getPresenceFieldData	Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
	getPurchQty	Get the quantity to be put into the field PurchQty for creating a new PurchLine record.
	getSQLStatement	Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
	getTableInInstanceHierarchy	(Inherited from xRecord.)
	getTableType	Indicates the type of the table. (Inherited from xRecord.)
	getTimeOutTimerHandle	Returns the timer handle for the object. (Inherited from Object.)
	handle	Retrieves the handle of the class of the object. (Inherited from Object.)
	hasInventTransGoodsInRoute_RU
	hasInventTransToDelivery_RU
	hasOnlyLineAmount
	hasPriceDiscChangePolicy	Determines whether any price discount policies exist for a SalesLine record.
	hasRelatedTable	Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
	helpField	Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
	inclTax
	initBarcode
	initFiscalDocumentType_BR	Creates a fiscal document type reference for this sales line.
	initFromAgreementLine	Initializes the SalesLine record from the AgreementLine record.
	initFromBOM
	initFromCustConfirmTrans	Initializes a SalesLine table buffer based on an CustConfirmTrans table buffer.
	initFromCustExternalItemDescription
	initFromCustInvoice4PaymTrans_RU
	initFromCustInvoiceTrans	Initializes a SalesLine table buffer based on an CustInvoiceTrans table buffer.
	initFromCustPackingSlipTrans	Initializes a SalesLine table buffer based on an CustPackingSlipTrans table buffer.
	initFromCustQuotationTrans	Initializes a SalesLine table buffer that is based on a CustQuotationTrans table buffer.
	initFromCustTable
	initFromInventTable	Updates the SalesLine based on the given item.
	initFromItemOrCategory
	initFromOrderLineWithMultipleDeliveries	Initializes a delivery line, depending on the order line.
	initFromPriceDisc
	initFromProductDimensions
	initFromProjActivity
	initFromProjInvoiceItem	Initializes a SalesLine table buffer that is based on a ProjInvoiceItem table buffer.
	initFromProjTable
	initFromProjTable_IN	Initializing the India Tax Information related fields of ProjJournalTransTaxExtensionIN table from given projTableTaxExtensionIN record..
	initFromPurchLine	Initializes a SalesLine record with values that are based on a PurchLine record.
	initFromPurchLineInterCompany_IN	Initializing the TaxInformation_IN field of SalesLine table from given PurchLine record.
	initFromRetailStoreTable_IN	Inits India tax information of sales line from retail store table.
	initFromSalesBasketLine	Initializes a SalesLine record with values that are based on a SalesBasketLine record.
	initFromSalesBasketLinePBA
	initFromSalesCreateReleaseOrderLineTmp	Initializes a SalesLine record from a SalesCreateReleaseOrderLineTmp record.
	initFromSalesLine	Initializes a SalesLine table buffer based on another SalesLine table buffer.
	initFromSalesLine_IN	Initializes the fields of SalesLine from given SalesLine buffer.
	initFromSalesLineView_IN	Initializes the SalesLine record from the view SalesLineView_IN.
	initFromSalesQuotationLine	Initializes a SalesLine record from a SalesQuotationLine record.
	initFromSalesQuotationLine_BR	Initializes the SalesLine record from the SalesQuotationLine record.
	initFromSalesTable
	initFromSMAServiceOrderTable	Initializes the SalesLine record with data from the SMAServiceOrderTable record buffer.
	initFromTmpSuppItem
	initName
	initRetailVariantId
	initSalesQty
	initValue
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert	Inserts the sales line to the database.
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	interCompanyIsBeingUpdated
	interCompanyIsBeingUpdatedNonInventoried	Indicates whether the non-stocked intercompany order line is being updated.
	interCompanyLineAmount
	interCompanyOriginalCustAccount
	interCompanyOriginDisplay
	interCompanyPurchLine	Gets the purchase line that is linked to the sales line through intercompany.
	interCompanyReturnItemInventTransId
	interCompanySalesId
	interCompanySalesLineExist
	interCompanyUpdateNow	Determines whether an intercompany order line should be updated.
	inventDim
	inventDimAllowsWHSProcessing	Determines if the sales line is valid for warehouse management processing based on the inventory dimensions.
	inventProfileType_RU
	inventTable
	invoiceAccount
	invoicedInTotal
	invoicedInTotalServer	Gets the total invoiced quantity for the line that is in the sales unit.
	invoicedInventInTotal
	isAgreementLinkValid	Determines whether the link between agreement line and the sales line is valid.
	isCategoryBased	Checks whether the order line is category based.
	isDropShipment	Checks whether the order line is part of a drop shipment.
	isDropShipmentPOLineInvoiceMatched	Checks whether a related direct delivery purchase order line was partially or fully invoiced.
	isFieldDataRetrieved	Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
	isFieldSet	Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
	isFormDataSource	Indicates whether the data source is a form. (Inherited from xRecord.)
	isInterCompanyOrder	Checks whether an order line is an intercompany order line.
	isInterCompanyOrderLineInvoiceMatched	Checks whether a related intercompany purchase order line was partially or fully invoiced.
	isLinkedToAgreement	Indicates whether the sales line is linked to an agreement line.
	isLinkedToProdConsumed
	isNewRecord	Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
	isPackingSlipOrInvoiceUpdated	Determines whether the line has been packing slip or invoice updated.
	isPartOfUOWSaveChanges	(Inherited from xRecord.)
	isReturnLineScrapped
	isReturnReservationLine	Checks if the SalesLine record in scope is a return order reservation line.
	isStocked	Checks whether the order line is tracked in inventory.
	isTangible	Determines whether the item in the order line is tangible.
	isTempDb	Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
	isTmp	Indicates whether this is a temporary table. (Inherited from xRecord.)
	itemIdChanged	Updates the SalesLine based on the item change.
	itemLineDisc
	itemName
	joinChild	Finds the join child of the current record. (Inherited from xRecord.)
	joinParent	Finds the join parent of the current record. (Inherited from xRecord.)
	ledgerDimensionSales
	lineAmountExclTax
	lineAmountModified
	lineAmountMST
	lineAmountMSTExclTax
	lineDeliveryImageRessNo	Determines the delivery type of a line.
	lineDisc
	linkInventDim2Dimension	Defaults the value of the SalesLine.dimension field, depending on the InventDimrecord buffer values.
	linkPhysicalTableInstance	Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
	markupAllowed
	matchingAgreementLine	Gets the record ID of the indicated record.
	mayConfirmationBeUpdated	Determines if the SalesLine record may be confirmed.
	mayInvoice4PaymBeUpdated_RU
	mayInvoiceBeUpdated	Determines if the SalesLine record may be invoiced.
	mayPackingSlipBeUpdated	Determines if the SalesLine record may be packing slip updated.
	mayPickingListBeRegistrated
	mayPickingListBeUpdated	Determines if the SalesLine record may be picked.
	mayProjectPackingSlipBeUpdated
	mcrAllowPartialPickedEdit	Determines if the partially picked sales line is allowed to be edited.
	mcrAutoChangeTaxGroup	Changes the tax group if auto tax search is turned on.///
	mcrCanContinuityLinePick	Looks at the payment schedules since they are the things that would stop it from processing.
	mcrCheckComplete	Checks whether the ship complete is checked.
	mcrCheckSalesPrice	Checks the sales line where the item is a gift card.
	mcrConvertShipToParentToReg	Converts a Ship To Parent line back to a regular line.
	mcrCreateContinuityCust	Creates a continuity line through the axSalesLine class.
	mcrDefaultLocationId	Determines the default location based on the order entry, item, and quantity.
	mcrDeleteOrderLineEvents	Deletes any order events that are related to the sales line that is being deleted.
	mcrDeliverPackedInTotalSalesUnit	Returns the total sales quantity that is packed for the sales line.
	mcrDeliverPickedInTotalSalesUnit	Displays the total of the deliver now and picked values.
	mcrDeliveryAddressing	Returns the delivery address.
	mcrDisplayConfigId	Returns the inventory configuration.
	mcrDisplayInventColorId	Returns the color of the item.
	mcrDisplayInventSizeId	Returns the item size.
	mcrDisplayInventStyleId	Returns the item style.
	mcrDisplayLineAssociation	Displays the line association image.
	mcrDisplayMarginPercentStr	Displays the margin percentage.
	mcrDisplayPhone	Displays the delivery customers phone number.
	mcrDisplayPriceOverride	Displays the price override icon.
	mcrDisplayPricePerUnit	Displays the price per unit.
	mcrDisplayUnitAmount	Displays the unit amount.
	mcrDlvModeModified	Sets the MCRExpedite flag based on the delivery mode.
	mcrGetPhoneNumbers	Retrieves a list of phone numbers.
	mcrGetReturnedQty	Gets the returned quantity.
	mcrGetSalesLineAmount	Formats the line amount for display and confirmation letter.
	mcrGetSalesPrice	Formats the line price for display and confirmation letter.
	mcrHasReturn	Finds whether the sales line has a return sales line.
	mcrInitFromSourceCodeSetup	Validates that the source entered on the sales line is effective.
	mcrInitShipToParent	Initializes the ship to parent values.
	mcrInterCompanySalesLineOrig	Retrieves the source sales line.
	mcrInventTable	Retrieves the invent table record for the item.
	mcrInventUnitOfMeasureClass	Returns the unit of measure.
	mcrInvoicedQty	Returns the sales quantity on the sales line.
	mcrIsAddressElementMandatory	Determines whether the specified delivery address field is mandatory, based on the country.
	mcrIsLineFullyReturned	Checks if all of the invoiced quantity on the line has been returned.
	mcrNextChildLineNum	Gets a line number for a child line (supplimentry item, kit component, ship to child) so that they stay grouped together with the parent line.
	mcrOriginalInvoicedInTotal	Returns the sales quantity invoiced.
	mcrOriginalMCRReturnedInventInTotal	Returns the quantity of returned inventory.
	mcrPackMCRSalesLine	Packs retail sales line extension table into MCRSalesLine field.
	mcrPackMCRSalesLineDropShipment	Packs retail sales line drop shipment extension table into MCRSalesLineDropShipment field.
	mcrPackMCRSalesLinePriceOverride	Packs retail sales line price override extension table into MCRSalesLinePriceOverride field.
	mcrPickedLineQuantity	Retrieves the picked inventory on the line.
	mcrPreviouslyReturnedCreditFromReturn	Returns the quantity credited from a previous return.
	mcrPreviouslyReturnedNoCreditReturn	Returns the quantity not credited from a previous return.
	mcrPricePerSalesQty	Calculates the price per sales quantity.
	mcrQtyInvoice	Returns the quantity invoiced.
	mcrQtyInvoicePerBatch	Returns the quantity invoiced per batch.
	mcrQtyInvoicePerBatchOrig	The quantity invoiced per original batch.
	mcrRemainInventPhysical	Retrieves the remaining physical inventory.
	mcrRepriceChildShipToLine	Reprices all of the child ship to lines when the parent price changes.
	mcrRetailGiftCardTable	Finds the RetailGiftCardTable for the current record.
	mcrReturnedExpectedQuantity	Gets the total quantity expected to be returned for the sales line.
	mcrReturnedInventInTotal	Gets the total quantity returned for the sales line.
	mcrSalesLine	Recovers the retail sales line record.
	mcrSalesLineDetailedStatus	Retrieves the sales line's detailed status.
	mcrSalesLineDropShipment	Recovers the retail sales line drop shipment record.
	mcrSalesLinePriceOverride	Recovers the retail sales line price override record.
	mcrSalesQtyDelivered	Displays the delivered sales quantity.
	mcrSalesQtyNotDelivered	Displays the sales unit quantity that has not been delivered.
	mcrSalesQtyOnOrder	Displays the on order quantity for the sales line.
	mcrSalesQtyReserved	Retrieves the reserved quantity of the sales line.
	mcrSetShipToParentStatus	Updates the sale status to canceled on the ship to parent when the all child sales lines are cancelled.
	mcrTotalQtyCredited	Retuns the total quantity credited.
	mcrTotalQtyCreditedBatch	Returns the total quantity credited by batch.
	mcrTotalQtyNotInvoiced	Displays the total quantity not cancelled or invoiced.
	mcrUpdateContCustLines	Changes the quantity of the continuty customer lines to match the new sales line quantity.
	mcrUpdatePrices	Gets the updated prices.
	merge	Merges the current table with the specified table. (Inherited from xRecord.)
	mergeDimension	Retrieves a dimension set that contains the merged combination of the current defaultDimension field on the SalesLine table and the provided dimension set.
	modifiedField	Perform any necessary initialization or validation when the given field is modified.
	modifiedFieldDDC	Processes the modified field event for delivery date control fields.
	modifiedFieldValue	Modifies a specified field.
	modifyInventDim	Updates the related fields when an inventory dimension field is modified.
	modifyWMSLocation	Modifies an InventDim record with WMS values.
	moduleType
	mustBeCovPlanned
	new	Initializes a new instance of the Object class. (Inherited from Object.)
	nextLineNum
	notify	Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
	notifyAll	Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
	objectOnServer	Determines whether the object is on a server. (Inherited from Object.)
	onCFOPChange_BR	Fires several actions as a result of a change in CFOPTable_BR field in SalesLine table.
	onDeliveryPostalAddressChange_BR	Updates CFOP as a consequence of address change if state and country differs from the previous address.
	onOrder	Gets the on order quantity for the line in sales unit.
	onOrderInSalesUnit	Gets an on order quantity for a line in sales unit.
	onTaxChange_BR	Updates tax information of sales line.
	orderAccount
	orig	Retrieves the original values of the current record. (Inherited from xRecord.)
	originalInvoiceId_W
	overDeliveryPct	Retrieves the over delivery percent that is allowed.
	overwriteSystemfields	Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
	owner	Returns the instance that owns the object. (Inherited from Object.)
	packSalesLine_BR	Packs brazilian extension table into PackedExtensions field
	packSalesLine_IN	Packs the sales line information.
	packSalesLine_Intrastat	Packs SalesLine_Intrastat extension table record.
	packSalesLinePricingCalculation	Packs PDSSalesLinePricingCalculation extension table record.
	pdsCalculatedLineAmount	Displays the adjusted net amount if the related item is potency enabled and has an an advanced-based pricing calculation.
	pdsCalculatedUnitPrice	Displays the adjusted unit price if the related item is potency enabled and has an an advanced-based pricing calculation.
	pdsCalculationId	Calculates and displays the calculation ID if the related item is potency enabled and has an an advanced-based pricing calculation.
	pdsCancelRemainWeight	Set the remaining sales inventory quantity to 0 if the catch weight quantity of a catch weight item goes to 0
	pdsCopySalesLinePricingCalculation	Copies a PDSSalesLinePricingCalculation buffer to the one associated with this sales order line.
	pdsCWDeliveredInTotal
	pdsCWDeliveredInTotalServer
	pdsCWExpRetQtyConversion	Update the expected return quantity if this record's item is a catch weight item.
	pdsCWInvoicedInTotal
	pdsCWOnOrder	Calculates the catch weight quantity that is on order for a given sales line.
	pdsCWPickedInTotal
	pdsCWQtyActivateRemainder
	pdsCWQtyConversion
	pdsCWQtyOnPickNotReserved	Calculates the catch weight quantity that is on warehouse management order but not reserved physical.
	pdsCWQtyValidation
	pdsCWRemainInventFinancial_RU	Gets remain financial quantity in pdsCW units.
	pdsCWRemainInventPhysical_RU	Gets remain physical quantity in pdsCW units.
	pdsCWReservedOnOrder	Calculates the catch wieght quantity that has been reserved on expected receipts for a given sales order line.
	pdsCWReservedOnPick	Calculates the catch weight quantity that has been reserved on current on hand for the sales order line and where the reservation is related to an output order.
	pdsCWReservedPhysical	Calculates the catch weight quantity that has been reserved on current on hand for the sales order line.
	pdsCWReserveQty
	pdsCWSalesDeliverNowConversion
	pdsCWUnitId	Gets the catch weight unit for the item.
	pdsSalesLinePricingCalculation	Get the PDSSalesLinePricingCalculation table.
	pdsSellableDays	Determines the number of days from the sales line's shipping date that the product must be sellable.
	pdsSetPricingCalculation	Sets the pricing calculation extension table with the specified attribute pricing ID.
	pdsUpdateReservation	Indicates whether the field update in progress requires a re-reservation of inventory.
	pdsUpdateReservationRequired	Indicates whether the field update in progress requires a re-reservation of inventory.
	pdsUpdateReservationServer
	pdsUpdReservePrompt
	pickedInTotalInventUnit
	pickedInTotalInventUnitServer
	pickedInTotalSalesUnit
	pickedInTotalSalesUnitServer
	populateReplaceLineTaxInfo_IN	Populates replace line tax info.
	postCacheLoad	Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
	postingGoodsInRouteOffset_RU
	postingOperations
	postingSales
	postLoad	Is executed after a record is read. (Inherited from xRecord.)
	postModifiedField_BR	Executes after a modification in a Brazilian field.
	postModifyInventDimBR	Sets fiscal document type for passed invent dim.
	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.)
	priceDate	Retrieves the date for which price must be calculated according to the price date type setting.
	priceGroupId
	prodConsumedInventTransOriginIds
	projIdChanged
	projIdModified	Modifies the sales line, depending on the changes in the project ID unit field.
	projProposalId
	projTable
	qtyActivateRemainder
	qtyEstimatedIssue
	qtyMarked	Retrieves the amount of the inventory items that are marked for the sales order line.
	qtyOnPick
	qtyOnPickNotReserved
	qualityOrderStatusDisplay	Retrieves the status of the associated quality orders if the quality management is being used.
	queryTimedOut	Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
	queryTimeout	Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
	readCommittedLock	(Inherited from xRecord.)
	readPast	Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
	recordLevelSecurity	Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
	referenceWarningTxt
	refreshAgreementLink	Refreshes the link between the AgreementLine and the SalesLine. If the current link has become invalid, or if there is no current link, this will search for the best matching AgreementLineand possibly update the PurchLine if a new match is found.
	registeredInSalesUnit	Calculates the registered quantity for the sales line in the sales unit.
	relatedTable	Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
	remainInventFinancial_RU
	remainInventPhysical_RU
	remainReturnLotQty
	remainSalesFinancial_RU
	remainSalesPhysical_RU
	renamePrimaryKey	Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
	reqTrans	Finds the corresponding record in the ReqTrans table for the current sales line record.
	reread	Rereads the record from the table. (Inherited from xRecord.)
	reservedOnOrder
	reservedOnOrderInSalesUnit
	reservedOnPick
	reservedPhysical
	reservedPhysicalInSalesUnit
	reserveQty
	resetInvent
	returnCreateReplacement	Determines whether a replacement order should be created for the sales line in scope.
	returnCreateScrap	Determines whether the items returned on the SalesLine record in scope should be scrapped.
	returnDeleteReservationLine	Deletes the return reservation lines.
	returnDispositionCode	Finds the ReturnDispositionCode record related to the SalesLine record in scope.
	returnExistMoreOpenLines	Determines whether any more open return lines exist for a sales order.
	returnItem	Determines whether the current item is a return item.
	returnLineAmount	Calculates the line amount for the return of items.
	returnLineArrivalUpdate	Determines based on the sign of the parameter if called as part of a registration or a cancellation and call the appropriate instance method.
	returnLineRegisterUpdate	Updates return related fields in the product registration scenario.
	returnLineResetToExpected	Updates the return related fields in the product cancel registration scenario.
	returnLineScrap	Scraps the lot that is returned on the SalesLine in scope.
	returnLineUpdate	Handles the special actions that are needed for return orders.
	returnUpdateBasedOnDispcode	Updates the return status on both SalesTable and SalesLine records.
	returnUpdateLinePrePosting	Performs the posting of preliminary updates to a record.
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	runPriceDiscPolicyDialog	Calls the runPriceDiscPolicyDialog method of the PriceDiscResultFields table map.
	salesLine_BR	Recovers brazilian extension table
	salesLine_IN	Get the SalesLine_IN table.
	salesLine_Intrastat	Retrieves SalesLine_Intrastat extension table record.
	salesLineView_IN	Returns a view associated with the current record.
	salesPurchTable
	salesQtyModified
	salesQtyModifiedInteraction	Executes the code that relates to changes in the sales line when the sales quantity is changed by user interaction when the associated link to an agreement line is invalid.
	salesTable
	salesTableName
	salesUnitModified	Changes the sales line, depending on changes in the sales unit field.
	selectForUpdate	Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
	selectLocked	Indicates whether to select locked records. (Inherited from xRecord.)
	selectRefRecord	Selects the record by referenced field ID. (Inherited from xRecord.)
	selectWithRepeatableRead	Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
	setAddressFromProjTable
	setAddressFromSalesLine
	setAddressFromSalesTable
	setAddressFromSalesTable_BR	Executes after the execution of the original setAddressFromSalesTable_BR method.
	setAgreementSkipAutoLink	Sets a value for the AgreementSkipAutoLink field of SalesLine
	setAlternativeItem	Encapsulates the logic that replaces the items with an alternative item setup.
	setCFOP_BR	It is responsible for setting CFOP code
	setCFOPFromSalesTable_BR	It sets CFOP field based on SalesTable
	setConnection	Sets the user connection for this table. (Inherited from xRecord.)
	setCrossPartition	Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
	setDeliveryDateControlType	Sets the delivery date control type for the current sales line.
	setDeliveryName	Sets the delivery name field based on a specified logistic location.
	setExpectedReturnQuantityFromCWQuantity	Sets the expected return quantity from the CW return quantity.
	setFieldValue	Sets the field value in the record buffer. (Inherited from xRecord.)
	setInventDeliverNow
	setInventDimId	Applies the InventDimId parameter to the SalesLine.inventDimId field and defaults, depending on the new inventory dimensions.
	setInventDimIdFromInventDim	Finds or creates an InventDimId value for the given InventDim table and applies the found InventDimId to the SalesLine.inventDimId field.
	setInventSumLogTTS	Implements logic to control whether changes to the sales line are tracked.
	setListCode
	setLocation	Sets the delivery address information and the related information.
	setPdsSameLot	Sets the same batch parameter for the sales line.
	setPostingProfile_RU
	setPriceAgreement
	setPriceDisc
	setPriceDiscChangePolicy	Calls the createPriceDiscChangePolicy method of the PriceDiscResultFields table.
	setPriceDiscMarkup	Calls the setPriceDiscMarkup method of the SalesPurchLine table map.
	setPriceDiscPriceUnit	Calls the setPriceDiscPriceUnit method of the SalesPurchLine table map.
	setProjLinePropertyId
	setReturnLineStatus	Sets a return line status that is based on an update document.
	setSalesStatus
	setServiceCodeId_BR	Calls the method to set TaxServiceCode_BR field in its extension table and packs it.
	setSQLTracing	Enables or disables SQL tracing mode. (Inherited from xRecord.)
	setStockedProduct	Sets the StockedProduct field for the line, depending on line type and item model group for the associated item.
	setSuframaDiscount_BR
	setTaxGroup
	setTaxGroupAndTaxItemGroupFields_BR	Set SalesQuotationLine.TaxGroup and SalesQuotationLine.TaxItemGroup based on TaxesMatrix
	setTaxItemGroup
	setThirdPartyAddressFromSalesTable
	setTimeOut	Sets up the scheduled execution of a specified method. (Inherited from Object.)
	setTmp	Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
	setTmpData	Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
	setXDSContext	Sets new XDS context. (Inherited from xRecord.)
	shipCarrierLocation	Gets the record ID of the LogisticsLocationRecId value that is associated with the selected ShipCarrierPostalAddress field value.
	showPriceMatchIcon	Shows the icon if the sales line contains the credit voucher ID.
	skipAosValidation	Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
	skipDatabaseLog	Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
	skipDataMethods	Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
	skipDeleteActions	Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
	skipDeleteMethod	Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
	skipEvents	Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
	skipPostLoad	Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
	skipTTSCheck	Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
	stockedProductChanged	Applies default values or sets the inventory related field values to null when the StockedProduct field value is changed.
	suppressWarnings	Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
	tableAccessRight	Returns the table access right. (Inherited from xRecord.)
	tableBufferAccessRight	Returns the table access right for the current record. (Inherited from xRecord.)
	takeOwnershipOfTempDBTable	(Inherited from xRecord.)
	taxDate
	taxPcsPrice
	timeZoneSite	Retrieves the time zone associated with the site on the current sales order line.
	tmsVolume	Gets the volume of the inventory associated with the Sales line.
	tmsWeight	Gets the weight of the inventory associated with the Sales line.
	toolTipField	Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
	toolTipRecord	Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
	toString	Returns a string that represents the current object. (Inherited from Object.)
	ttsabort	Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
	ttsbegin	Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
	ttscommit	Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
	type
	underDeliveryPct	Calculates the under delivery percent that is allowed.
	unitConvertInvent2Sales
	unitConvertSales2Invent	Converts the specified quantity from a sales unit to an inventory unit.
	unlinkAgreementDeliveryDates	Validates whether the link to the agreement line is valid after the changes and gives the user an option to remove the link to the associated agreement line to make the changes valid.
	unLinkAgreementLine	Deletes the link between the sales order line and an agreement line.
	unLinkAgreementLinePrompt	Displays a text box that asks the user whether to delete the link between the agreement line and sales order line.
	unLinkReleasedAgreementLine	Deletes the links between a sales order line and an agreement line.
	update
	updateAndPackAccessableValue_IN	Update and pack the AccessableValue_IN
	updateCreditNoteMarking_PL
	updateDeliveryCFOP_BR
	updateDeliveryCFOPTax_BR	Determines the taxgroup and taxitemgroup from CFOPMatrix_BR table updates it to the salesline tax groups for Sales and itemRequirement cases.
	updateLoadLines	Update WHSLoadLine table and tracked quantities in WHSSalesLine table.
	updateMarkupTransTaxGroups_BR
	usageCount	Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
	useExistingTempDBTable	(Inherited from xRecord.)
	useWMSOrder
	validateDelete
	validateField	Validates the salesLine fields.
	validateField_Server
	validateFieldValue	(Inherited from xRecord.)
	validateModifyInventDim
	validateWrite
	validateWrite_server
	validTimeStateUpdateMode	Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
	wait	Pauses a process. (Inherited from Object.)
	warningForReference
	wasCached	Specifies the location from which the data was retrieved. (Inherited from xRecord.)
	whsDisplayCustAvailCredit	Finds a customer's available credit.
	whsDisplayCustName	Finds the name of the customer associated with the Sales order.
	whsDisplayItemName	Finds the name of the item on the Sales order line.
	whsDisplaySalesOrgin	Finds the Sales origin ID.
	whsGetLoads	Method to display the load tied to a sales line.
	whsHasLoadTable	Indicates whether SalesLine is linked to WHSLoadTable.
	whsImageIdx	Returns an integer that specifies an image to be displayed.
	whsItemGrossWeight	Finds the volume of the item on the order line.
	whsItemUnitVolume	Finds the unit volume for the item on the order line.
	whsNotFullyReserved	Finds the quantity that has not been completely reserved.
	whsQtyInWorkSalesUnit	Finds the work quantity for the sales order line.
	whsResPhyPickedDeliveredQty	Finds the picked reserved inventory amount.
	whsWHSEAddress	Gets the warehouse address for display.
	write	Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
	writeRetailSalesLine	Creates a RetailSalesLine record if necessary conditions are met.
	xml	Retrieves an XML string that represents the current object. (Inherited from xRecord.)
	::canRegisterReturnQtyTrackingDim	Indicates whether a quantity can be returned for a given batch or serial number.
	::changeReturnOrderType	Creates or deletes inventory transactions related to Return orders.
	::createFromTmpFrmVirtualIL	Executes the creation of sales order lines based on TmpFrmVirtual records in IL.
	::createFromTmpFrmVirtualServer	Executes the creation of sales order lines based on TmpFrmVirtual records on the server.
	::createItemRequirementFromPOLine	Creates a SalesLine record of type item requirement.
	::createSalesLine	Creates sales lines from passed in temporary table.
	::exist
	::existDifferentCurrency
	::find
	::findInventTransId
	::findItemIdInventDimId	Finds the specified record in the SalesLine table.
	::findItemIdVariantId	Finds the specified record in the SalesLine table.
	::findRecId
	::findSourceDocumentLine	Finds the specified record in the SalesLine table.
	::getInventQtyFromCWUnit	Returns the inventory quantity for an PdsCWInventQty based on inventory transactions.
	::getSalesLinePotencyPricingDetails	Gets the potency pricing details of the sales line with the specified ID.
	::highestSalesStatus
	::initFromInventTableIL	Updates a SalesLine table buffer that is based on an item.
	::isTaxExist
	::isTaxUnrealized
	::jumpRefInventTransIdSalesOrder	Opens a sales order form by using jump reference.
	::lastDeliveryScheduleLineNum	Retrieves the last line number that is used by the delivery lines linked to the specified order line.
	::lastLineNum
	::mcrCalcContinuityLineTax	Calculates line tax.
	::mcrExistOpenReturnLine	Searches for open return lines.
	::mcrFindReturnLineForExchange	Finds the SalesLine record that is being returned for exchange.
	::mcrInvoiceShipToChildExists	Checks if any invoiced lines exist for a given multiple ship to parent so that we can lock down fields that may affect the price.
	::mcrTotalWeight	Gets the total weight.
	::modifyExpectedRetQty	Rounds the expected return quantity according to the unit setup.
	::modifySalesQty	Updates a SalesLine table buffer based on changed sales quantity.
	::modifySalesQtyIL	Updates a SalesLine table buffer based on a changed sales quantity.
	::pdsCWFullVisItemStdQty	Returns the full visibility catch weight quantity picked.
	::pdsMRCCheckRestrictedForAllSalesLines	Checks the regulatory compliance of all sales lines in the current sales order.
	::pdsRemainReturnLotQtyAllCreditNote	Calculates the returned quantities for a sales order line.
	::qtyDeliveryToCreditNote_RU
	::remainReturnLotQtyAllCreditNote	Calculates the returned quantity for a sales order line.
	::resetAxSalesLinePolicies	Resets the price discount policies.
	::setConfirmedDatesUsingUIStrategy	Calculates and updates the confirmed dates of a SalesLine record.
	::splitReturnLine	Splits a return order line into two return order lines.
	::updateSalesLine_IN

Top

Fields

Field	Type	Configuration key	Description
ActivityNumber	Extended Data Type: ProjActivityNumber Type: String	ProjBasic	The activity number
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.
AgreementSkipAutoLink	Extended Data Type: AgreementSkipAutoLink Type: Enum	TradeBlanketOrder	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
AssetId_RU	Extended Data Type: RAssetIdOpen Type: String	RAsset	Unique key for identification of fixed asset. The key is used when creating new assets. (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
Blocked	Extended Data Type: LineStopped Type: Enum	None	Is the line locked?
CaseTagging	Extended Data Type: RFIDCaseTagging Type: Enum	RFIDTagging	Is case tagging mandatory?
Complete	Extended Data Type: LineComplete Type: Enum	None	Deliver complete line?
ConfirmedDlv	Extended Data Type: SalesShippingDate Type: Date	LogisticsBasic	Confirmed ship date if exists, otherwise requested ship date
CostPrice	Extended Data Type: ReturnCostPrice Type: Real	LogisticsBasic	Cost price per unit of the returned item.
CountryRegionName_RU	Extended Data Type: AddressCountryRegionName Type: String	None	Country/region name. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CountyOrigDest	Extended Data Type: AddressCountyOrigDest Type: String	None	Intrastat county of origin/destination.
createdBy	Extended Data Type: CreatedBy Type: String	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
createdDateTime	Extended Data Type: CreatedDateTime Type: UtcDateTime	None
CreditNoteInternalRef_PL	Extended Data Type: CreditNoteInternalRef_W 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))
CreditNoteReasonCode	Extended Data Type: ReasonTableRefRecId Type: Int64	None	Contains stored financial reason codes and comments for entered or posted transactions or actions. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CurrencyCode	Extended Data Type: CustCurrencyCode Type: String	None	Currency the line is invoiced in
CustAccount	Extended Data Type: CustAccount Type: String	None	Customer account
CustGroup	Extended Data Type: CustGroupId Type: String	LedgerBasic	Customer group
CustomerLineNum	Extended Data Type: CustLineNum Type: Integer	None	Customer's line number.
CustomerRef	Extended Data Type: CustRefLine Type: String	LedgerBasic	Customer's reference
CustomsDocDate_MX	Extended Data Type: CustomsDocDate_MX Type: Date	None	Date of custom number.
CustomsDocNumber_MX	Extended Data Type: CustomsDocNumber_MX Type: String	None	Document number of import document.
CustomsName_MX	Extended Data Type: CustomsName_MX Type: String	None	Name of custom.
dataAreaId	Extended Data Type: DataAreaId Type: String	None
DefaultDimension	Extended Data Type: DimensionDefault Type: Int64	LedgerBasic	Default 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)
dEL_ModifiedTime	Extended Data Type: DEL_ModifiedTime Type: Integer	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
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
DeliveryTaxGroup_BR	Extended Data Type: TaxGroup Type: String	LedgerBasicSalesTax	Delivery sales tax code group used to calculate taxes on the delivery slip (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DeliveryTaxItemGroup_BR	Extended Data Type: TaxItemGroup Type: String	LedgerBasicSalesTax	Item sales tax code group used to calculate item taxes on the delivery slip (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DeliveryType	Extended Data Type: TradeLineDlvTypeId Type: Enum	None	Delivery type of the current order line.
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)
EInvoiceAccountCode	Extended Data Type: EInvoiceAccountCode Type: String	None	When settling to a public sector organization it is possible to specify a dimension account code.
ExpectedRetQty	Extended Data Type: ReturnExpectedRetQty Type: Real	ReturnItem	Quantity to be returned.
ExternalItemId	Extended Data Type: SalesExternalItemId Type: String	LogisticsBasic	Customer item number.
InterCompanyInventTransId	Extended Data Type: InventRefTransId Type: String	TradeInterCompany	Lot ID referred to.
InterCompanyOrigin	Enumeration: InterCompanyOrigin	TradeInterCompany	States whether the line was created manually (Source), or indirectly as part of an intercompany chain (Derived)
IntrastatFulfillmentDate_HU	Extended Data Type: IntrastatFulfillmentDate_HU Type: Date	ForeignTrade	Date of Intrastat fulfillment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
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.
InventTransIdReturn	Extended Data Type: TradeInventTransIdReturn Type: String	LogisticsBasic	Lot ID for items being returned
InvoiceGTDId_RU	Extended Data Type: CustFreeInvoiceGTDId_RU Type: String	LedgerBasic	Customs declaration number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
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
ItemReplaced	Extended Data Type: ReturnItemReplaced Type: Enum	ReturnItem	Is sales line created for returned item?
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: LineHeader Type: String	None	Text describing the line
LineNum	Extended Data Type: LineNum Type: Real	None	Used for sorting (COUNTER)
LinePercent	Extended Data Type: SalesLinePercent Type: Real	PriceDisc	Line discount percentage.
ManualEntryChangepolicy	Extended Data Type: PriceDiscPolicyManual Type: Int64	None	-
MatchingAgreementLine	Extended Data Type: AgreementLineRecId Type: Int64	None	Reference to the agreement line record
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)
modifiedBy	Extended Data Type: ModifiedBy Type: String	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
modifiedDateTime	Extended Data Type: ModifiedDateTime Type: UtcDateTime	None
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
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))
PdsBatchAttribAutoRes	Extended Data Type: PdsBatchAttribAutoRes Type: Enum	PdsBatchAttrib	Consider batch attributes when processing auto reservation. (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))
PdsCWExpectedRetQty	Extended Data Type: PdsCWExpectedRetQty Type: Real	PdsCatchWeight	Expected catch weight quantity to be returned. (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))
PdsCWInventDeliverNow	Extended Data Type: PdsCWInventQty Type: Real	PdsCatchWeight	Catch weight quantity delivered now in catch weight units. (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))
PdsCWRemainInventFinancial	Extended Data Type: PdsCWInventQty Type: Real	PdsCatchWeight	CW quantity that has been packing slip delivered but not yet invoice updated. (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	CW quantity - not yet packing slip delivered - in the inventory unit. (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))
PdsExcludeFromRebate	Extended Data Type: PdsExcludeFromRebate Type: Enum	PdsRebate	Exclude sales transactions created from this sales agreement from the rebate calculation (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))
PdsItemRebateGroupId	Extended Data Type: PdsItemRebateGroupId Type: String	PdsRebate	Group of item for which a rebate is applicable. (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))
PdsSameLot	Extended Data Type: PdsSameLot Type: Enum	PdsSameLot	Indicates if the inventory that will be reserved for this sales order line needs to come from the same lot. (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))
PdsSameLotOverride	Extended Data Type: PdsSameLotOverride Type: Enum	PdsSameLot	Manual override of same batch selection field. (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.
PostingProfile_RU	Extended Data Type: CustPostingProfile Type: String	None	Posting profile being processed. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PriceAgreementDate_RU	Extended Data Type: PriceAgreementDate_RU Type: Date	None	Date for price determining in price agreement. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PriceUnit	Extended Data Type: PriceUnit Type: Real	LogisticsBasic	Number of units the quantity applies to.
ProjCategoryId	Extended Data Type: ProjCategoryId Type: String	ProjBasic	Category that is used as a default.
ProjId	Extended Data Type: ProjId Type: String	ProjBasic	Project identification
ProjLinePropertyId	Extended Data Type: ProjLinePropertyId Type: String	ProjBasic	Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost
ProjTransId	Extended Data Type: ProjItemTransId Type: String	ProjBasic	Identification of transaction.
PropertyNumber_MX	Extended Data Type: PropertyNumber_MX Type: String	None	Register number of property.
PSAContractLineNum	Extended Data Type: String30 Type: String	PSAContractLine	Billing rule 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), Microsoft Dynamics AX 2012 (FPK))
PSAProjProposalInventQty	Extended Data Type: Qty Type: Real	Project3	Number of units (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))
PSAProjProposalQty	Extended Data Type: Qty Type: Real	Project3	Number of units (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))
PurchorderFormNum	Extended Data Type: CustPurchaseOrder Type: String	None	Customer requisition number
QtyOrdered	Extended Data Type: InventQty Type: Real	None	Quantity ordered in the inventory unit.
ReceiptDateConfirmed	Extended Data Type: SalesReceiptDateConfirmed Type: Date	SalesDeliveryDateControl	The selling company confirms that the customer will receive the order on this date.
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
RefReturnInvoiceTrans_W	Extended Data Type: RefReturnInvoiceTrans_W Type: Int64	LedgerBasic	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))
RemainInventFinancial	Extended Data Type: InventQty Type: Real	None	Quantity that has been packing slip delivered but not yet invoice updated.
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.
Reservation	Enumeration: ItemReservation	None	Reserve items automatically?
RetailBlockQty	Extended Data Type: RetailBlockQty Type: Real	Retail	Quantity of items that will be blocked (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RetailVariantId	Extended Data Type: RetailVariantId Type: String	Retail	Variant ID (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))
ReturnAllowReservation	Extended Data Type: ReturnAllowReservation Type: Enum	None	Treat lot as On Order
ReturnArrivalDate	Extended Data Type: ReturnArrivalDate Type: Date	ReturnItem	Date when the return delivery was received.
ReturnClosedDate	Extended Data Type: ReturnClosedDate Type: Date	ReturnItem	Date when the return line was invoiced or cancelled.
ReturnDeadline	Extended Data Type: ReturnDeadline Type: Date	ReturnItem	Date the return delivery must be received.
ReturnDispositionCodeId	Extended Data Type: ReturnDispositionCodeId Type: String	ReturnItem	Identification of the disposition code.
ReturnStatus	Enumeration: ReturnStatusLine	ReturnItem	Status of the return line.
SalesCategory	Extended Data Type: SalesCategory Type: Int64	LogisticsBasic	Category from the sales category hierarchy
SalesDeliverNow	Extended Data Type: SalesQty Type: Real	None	Quantity delivered now in sales units
SalesGroup	Extended Data Type: CommissSalesGroup Type: String	Commission	Commission sales group
SalesId	Extended Data Type: SalesIdBase Type: String	LogisticsBasic	Specify the order number that the line is attached to.
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: SalesOrderedQty Type: Real	None	Quantity ordered in the sales unit
SalesStatus	Enumeration: SalesStatus	LogisticsBasic	Line status with regard to delivery and invoicing
SalesType	Enumeration: SalesType	LogisticsBasic	Order line type
SalesUnit	Extended Data Type: SalesUnit Type: String	None	Unit the item is sold in.
Scrap	Enumeration: NoYes	None	For returned item specifies whether it is to be considered as scrap.
ServiceOrderId	Extended Data Type: SMAServiceOrderId Type: String	SMAManagement	Identification of service order
ShipCarrierAccount	Extended Data Type: ShipCarrierAccount Type: String	ShipCarrier	Account number that is invoiced by the carrier
ShipCarrierAccountCode	Extended Data Type: ShipCarrierAccountCode Type: String	ShipCarrier	Account code to identify the carrier account number that will be used to bill the company
ShipCarrierDlvType	Enumeration: ShipCarrierDlvType	ShipCarrier	Service type
ShipCarrierId	Extended Data Type: ShipCarrierId Type: String	ShipCarrier	Identification of the carrier service, assigned by the shipping carrier
ShipCarrierName	Extended Data Type: LogisticsShipCarrierName Type: String	None	Name or company name of third-party address.
ShipCarrierPostalAddress	Extended Data Type: LogisticsPostalAddressRecId Type: Int64	ShipCarrier	Reference field in a different table
ShippingDateConfirmed	Extended Data Type: SalesShippingDateConfirmed Type: Date	LogisticsBasic	The selling company confirms that the order will be shipped on this date.
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.
SourceDocumentLine	Extended Data Type: SourceDocumentLineRecId Type: Int64	LedgerBasic	Reference field in a different table
StatisticValue_LT	Extended Data Type: LtIntrastatStatisticValue Type: Real	ForeignTrade	The transaction amount, in the accounting currency (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
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?
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
TaxItemGroup	Extended Data Type: TaxItemGroup Type: String	LedgerBasicSalesTax	Group of sales tax codes that can be calculated for an item.
TaxWithholdGroup	Extended Data Type: TaxWithholdGroup Type: String	LedgerBasicWithholdingTax	Identification of the withholding tax group.
TaxWithholdItemGroupHeading_TH	Extended Data Type: TaxWithholdItemGroupId_TH Type: Int64	None	Group of withholding tax codes that can be calculated for an item
TransactionCode	Extended Data Type: IntrastatTransactionCodeId Type: String	ForeignTrade	Code for the current transaction code.
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
All
Barcode
Discount
FixedAssets_RU
ExternalReference
AddressLookup
AddressDisplay
AddressReference
CustomerRef
AllVar
DeliverySalesTax_BR
Dimension
CarrierInfo
EletronicInvoice_MX
Delivery
AgreementLine
Commission
BOMRoute
DeliveryAddress
AutoReport
Identification
EInvoice
ForeignTrade
Block
Intercompany
InterCompanyReference
Inventory
PdsItemRebateGroup
MCRBroker
Personalization
MCRGift
Posting
ProjectSalesPrice
ItemReference
MCRPotencies
PdsCWMain
ProjectAmount
ProjectIdentification
OrderLines
PdsRebate
Price
MCRUngrouped
ProjectSalesTax
PackagingMaterial
ProjectCostPrice
Other
PdsCWInventory
PdsSameLot
ProjectTransaction
PSA
Retail
Quantity
RetailInventoryBlocking
OrderLine
MCRTemplateLines
MCRPriceGroup
PdsCWQty
ItemProject
Market
Status
SalesOrderProject
TableGroup
ServiceOrder
ReturnGroupRMA
RFIDTagging
Return
SalesTax
ReturnGroup
SalesQuantity
WithholdingTax

Top

Relations

Relation	Table	Lines
AgreementLine	AgreementLine
BarcodeSetup	BarcodeSetup
BOMTable	BOMTable
CommissionSalesGroup	CommissionSalesGroup
Common	Common
CountyOrigDest	LogisticsAddressCounty
Currency	Currency
CustGroup	CustGroup
CustInvoiceTrans	CustInvoiceTrans
CustLedger	CustLedger
CustTable	CustTable
dataAreaId	DataArea
DefaultDimension	DimensionAttributeValueSet
DeliveryPostalAddress_FK	LogisticsPostalAddress
DeliveryTaxGroupHeading_BR	TaxGroupHeading
DeliveryTaxItemGroupHeading_BR	TaxItemGroupHeading
DlvMode	DlvMode
DlvTerm	DlvTerm
IntrastatPort	IntrastatPort
IntrastatStatProc	IntrastatStatProc
IntrastatTransactionCode	IntrastatTransactionCode
IntrastatTransportMode	IntrastatTransportMode
InventDim	InventDim
InventItemBarcode	InventItemBarcode
InventTable	InventTable
InventTransferTableRef	InventTransferTable
InventTransOrigin	InventTransOrigin
InventTransOriginReturn	InventTransOrigin
LedgerDimension	DimensionAttributeValueCombination
MCRContinuityCustLine	MCRContinuityCustLine
MCRCustInvoiceTrans	CustInvoiceTrans
MCROrderLine2PriceHistoryRef	MCROrderLine2PriceHistoryRef
MCRPurchLineRef	PurchLine
PackingUnit	UnitOfMeasure
Partition	Partitions
PBATable	PBATable
PdsItemRebateGroup	PdsItemRebateGroup
PriceDiscChangePolicyRecId1	PriceDiscChangePolicy
PriceDiscChangePolicyRecId2	PriceDiscChangePolicy
ProdTableRef	ProdTable
ProjCategory	ProjCategory
ProjItemTrans	ProjItemTrans
ProjLineProperty	ProjLineProperty
ProjTable	ProjTable
PSAContractLineItems	PSAContractLineItems
PurchTableRef	PurchTable
RAssetTable	RAssetTable
ReasonTableRef	ReasonTableRef
RetailVariantId	InventDimCombination
ReturnDispositionCode	ReturnDispositionCode
RouteTable	RouteTable
SalesCategory	EcoResCategory
SalesTable	SalesTable
SalesTableRef	SalesTable
SalesUnit	UnitOfMeasure
ShipCarrierPostalAddress_FK	LogisticsPostalAddress
ShipCarrierTable	ShipCarrierTable
SMAServiceOrderTable	SMAServiceOrderTable
smmActivities	smmActivities
SourceDocumentLine	SourceDocumentLine
TaxGroupHeading	TaxGroupHeading
TaxItemGroupHeading	TaxItemGroupHeading
TaxServiceTariff	TaxServiceTariff
TaxWithholdGroupHeading	TaxWithholdGroupHeading
TaxWithholdItemGroupHeading_TH	TaxWithholdItemGroupHeading_TH
VendInvoiceTrans_W	VendInvoiceTrans

Top

Indexes

Index	AllowDuplicates	Enabled	Fields
AgreementLineIdx	Yes	Yes
InventDimIdx	Yes	Yes
InventRefTransIdx	Yes	Yes
InventTransIdReturnIdx	Yes	Yes
ItemIdx	No	Yes
PSAContractLineItemsIdx	Yes	Yes
RecId	No	Yes
SalesLineIdx	No	Yes
SalesTypeIdx	Yes	Yes
SourceDocumentLineIdx	No	Yes
StatusItemIdx	Yes	Yes
TransIdIdx	No	Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    SalesLine Table

See Also

Table Methods

Tables Overview