This topic has not yet been rated - Rate this topic

SalesLineDelete Table [AX 2012]

The SalesLineDelete table contains voided sales order lines.

Configuration Key: LogisticsBasic
  MethodDescription
Gg871373.pubmethod(en-us,AX.60).gifaosValidateDeleteValidates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifaosValidateInsertValidates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifaosValidateReadValidates on the server that the specified record can be read. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifaosValidateUpdateValidates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifbuf2conPacks the table buffers of an xRecord object into an X++ container. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcancelTimeOutCancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifcanSubmitToWorkflowIndicates whether a record can be submitted to workflow. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcaptionGets or sets the caption property of a table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcheckInvalidFieldAccessGets or sets the invalid field access. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcheckRecordGets or sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcheckRestrictedDeleteActionsGets or sets the property that indicates whether a record can be deleted (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifclearRemoves all rows from the table buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcompanyGets or sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcon2bufUnpacks a container into table buffers. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifconcurrencyModelGets or sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifcontextGets or sets the context property. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdataRetrieves a row from the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdataSourceRetrieves the data source of the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdefaultFieldSets a field in the table to its default value. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdefaultRowSets the value of the fields that are in the table in the non-interactive case to their default values. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdeleteDeletes the current record from the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdisableCacheGets or sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdisposeReleases the resources that are used by the xRecord object. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdoClearRemoves all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdoDeleteDeletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdoInsertInserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdoUpdateUpdates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifdoValidateDeletePerforms the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifequalDetermines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giffieldAccessRightGets the field access right for a specified field. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giffieldBufferAccessRightGets the field access right for the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giffieldStateGets or sets the state of a field in the table buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetAllowRedefaultGets the list of fields that can redefault. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetDefaultingDependenciesGets a container that contains the defaulting dependencies. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetExtensionGets the table extension. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetFieldValueGets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetInstanceRelationTypeGets the table name that corresponds to the given Instance Relation Type ID. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetPhysicalTableNameGets the physical table name or, for a SQL Temp DB table, the table instance name. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetPresenceFieldDataRetrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetSQLStatementGets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetTableInInstanceHierarchy (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetTableTypeIndicates the type of the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifgetTimeOutTimerHandleReturns the timer handle for the object. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifhandleRetrieves the handle of the class of the object. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifhasRelatedTableWhether table has foreign key constraint buffer linked with it or not. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifhelpFieldRetrieves a String that contains the help text for the specified field. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifinitFromSalesLine
Gg871373.pubmethod(en-us,AX.60).gifinitFromSalesLineForeignTradeCategoryInitializes the SalesLinedelete record from the SalesLineForeignTradeCategory record.
Gg871373.pubmethod(en-us,AX.60).gifinitValueInitializes a field by using the default value of the field. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifinputStatusGets or sets the current input status of the table buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifinsertInserts the record into the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifinteractiveContextGets or sets the current interactive context of the table buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifinventDim
Gg871373.pubmethod(en-us,AX.60).gifinventTable
Gg871373.pubmethod(en-us,AX.60).gifisFieldDataRetrievedIndicates whether data in the given field has been retrieved. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifisFieldSetIndicates whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifisFormDataSourceIndicates whether the data source is a form. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifisNewRecordIndicates whether the record is a new record that has not been persisted. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifisPartOfUOWSaveChanges (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifisTempDbIndicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifisTmpIndicates whether this is a temporary table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifitemName
Gg871373.pubmethod(en-us,AX.60).gifjoinChildFinds the join child of the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifjoinParentFinds the join parent of the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giflinkPhysicalTableInstanceChecks whether the link for the physical table instance that corresponds to the record exists. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifmergeMerges the current table with the specified table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifmodifiedFieldModifies the specified field to its original value. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifmodifiedFieldValueModifies the specified field to its original value. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifnewInitializes a new instance of the Object class. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifnotifyReleases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifnotifyAllReleases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifobjectOnServerDetermines whether the object is on a server. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).giforigRetrieves the original values of the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifoverwriteSystemfieldsGets or sets the property that indicates whether system fields may be overwritten. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifownerReturns the instance that owns the object. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifpostCacheLoadExecutes after data is hit from cache for select on the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifpostLoadExecutes after a record is read. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifpreRemotingExecutes before a cross tier call is about to execute for the table that would pack its state to the other tier. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifqueryTimedOutIndicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifqueryTimeoutGets or sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifreadCommittedLock (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifreadPastGets or sets the property that indicates whether to skip rows that are locked by other processes when it reads a record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifrecordLevelSecurityGets or sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifrelatedTableGets or sets the related buffer from a link to a table buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifrenamePrimaryKeyRenames the foreign keys in other tables according to the change of the primary key value that corresponds to this table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifrereadRereads the record from the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifRowCountRetrieves the number of rows in the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifselectForUpdateGets or sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifselectLockedIndicates whether to select locked records. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifselectRefRecordSelects the record by its referenced field ID. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifselectWithRepeatableReadGets or sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetConnectionSets the user connection for this table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetCrossPartitionSets or resets cross partition for the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetFieldValueSets the field value in the record buffer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetSQLTracingEnables or disables SQL tracing mode. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetTimeOutSets up the scheduled execution of a specified method. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifsetTmpSets the table not to be persisted to the database. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetTmpDataSets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsetXDSContextSets new XDS context. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipAosValidationGets or sets the property that indicates whether to skip AOS validation (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipDatabaseLogGets or sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipDataMethodsGets or sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipDeleteActionsGets or sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipDeleteMethodGets or sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipEventsProvides the ability to stop the calling of the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipPostLoadGets and sets the property that indicates whether to skip executing xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifskipTTSCheckGets or sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifsuppressWarningsGets or sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giftableAccessRightRetrieves the table access right for a table. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giftableBufferAccessRightRetrieves the table access right for the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giftoolTipFieldRetrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giftoolTipRecordRetrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).giftoStringReturns a string that represents the current object. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifttsabortAborts a transaction that was started by a call to the xRecord.ttsbegin method. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifttsbeginStarts a transaction that can be either committed by the xRecord.ttscommit method or aborted by the xRecord.ttsabort method. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifttscommitCommits a transaction that was started by a call to the xRecord.ttsbegin method. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifupdateUpdates the current record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifusageCountRetrieves the current number of references to the object by using the value of the reference counter. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifvalidateDeleteChecks whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifvalidateFieldChecks whether the specified field is valid. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifvalidateFieldValue (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifvalidateWriteChecks whether the current record is valid and can be written. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifvalidTimeStateUpdateModeThis method sets valid time state update mode on the pointer. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifwaitPauses a process. (Inherited from Object.)
Gg871373.pubmethod(en-us,AX.60).gifwasCachedSpecifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifwriteCreates a new record or updates an existing record. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifxmlRetrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg871373.pubmethod(en-us,AX.60).gifGg871373.static(en-us,AX.60).gif::createFromSalesLine
Gg871373.pubmethod(en-us,AX.60).gifGg871373.static(en-us,AX.60).gif::exist
Top
FieldTypeConfiguration keyDescription
ActivityNumber Extended Data Type: ProjActivityNumber
Type: String
ProjBasicThe activity number
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
None
dataAreaId Extended Data Type: DataAreaId
Type: String
None
InventDimId Extended Data Type: InventDimId
Type: String
NoneIdentification of dimensions for the item.
InventTransId Extended Data Type: TradeInventTransId
Type: String
LogisticsBasicIdentification of the item lot.
ItemId Extended Data Type: ItemIdSmall
Type: String
LogisticsBasicItem number in order line
LineAmount Extended Data Type: SalesLineAmount
Type: Real
LogisticsBasicSales amount of the line, including discount
LineNum Extended Data Type: LineNum
Type: Real
NoneUsed for sorting (COUNTER)
Name Extended Data Type: ItemFreeTxt
Type: String
LogisticsBasicLine description
Partition Extended Data Type: Partition
Type: Int64
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R2 (SYS))
ProjCategoryId Extended Data Type: ProjCategoryId
Type: String
ProjBasicCategory that is used as a default.
ProjId Extended Data Type: ProjId
Type: String
ProjBasicProject identification
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
SalesCategory Extended Data Type: SalesCategory
Type: Int64
LogisticsBasicCategory from the sales category hierarchy
SalesId Extended Data Type: SalesIdDelete
Type: String
LogisticsBasicIdentification of the order.
SalesLine Extended Data Type: PackedTable
Type: Container
NonePacked table.
SalesLineforeignTradeCategory Extended Data Type: PackedTable
Type: Container
NonePacked table.
SalesType Enumeration: SalesType
LogisticsBasicOrder line type
Top
Field GroupFields
InventoryDimensions
OrderLines
TableGroup
AutoReport
Inventory
Identification
Project
Top
RelationTableLines
dataAreaIdDataArea
InventDimInventDim
InventTableInventTable
InventTransOriginInventTransOrigin
PartitionPartitions
ProjCategoryProjCategory
ProjTableProjTable
SalesCategoryEcoResCategory
SalesTableDeleteSalesTableDelete
smmActivitiessmmActivities
Top
IndexAllowDuplicatesEnabledFields
ItemIdxNoYes
RecIdNoYes
SalesLineIdxNoYes
TransIdIdxNoYes
Top
xRecord Class
  Common Table
    SalesLineDelete Table
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.