DMFSalesLineEntity Table
The SalesLine table contains all sales order lines regardless of whether they have been posted.
Configuration Key: DMF
Methods
Method | Description | |
---|---|---|
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.) | |
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) | |
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) | |
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) | |
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) | |
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) | |
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.) | |
context | Gets and sets the context property. (Inherited from xRecord.) | |
data | Retrieves a row from the table. (Inherited from xRecord.) | |
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) | |
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 | Deletes the current record from the table. (Inherited from xRecord.) | |
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
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.) | |
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.) | |
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) | |
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) | |
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.) | |
getExtension | Returns the table extension. (Inherited from xRecord.) | |
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) | |
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) | |
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.) | |
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.) | |
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.) | |
initFromDMFSalesline | Initialises SalesTable table from DMFSalesLineEntity table. | |
initValue | Initializes a field to the default value. (Inherited from xRecord.) | |
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) | |
insert | Inserts the record into the table. (Inherited from xRecord.) | |
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
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.) | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
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.) | |
joinChild | Finds the join child of the current record. (Inherited from xRecord.) | |
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) | |
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
merge | Merges the current table with the specified table. (Inherited from xRecord.) | |
modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) | |
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) | |
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
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.) | |
orig | Retrieves the original values of the current record. (Inherited from xRecord.) | |
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.) | |
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) | |
postLoad | Is executed after a record is read. (Inherited from xRecord.) | |
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.) | |
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.) | |
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) | |
renamePrimaryKey | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) | |
reread | Rereads the record from the table. (Inherited from xRecord.) | |
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) | |
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.) | |
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) | |
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.) | |
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.) | |
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.) | |
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.) | |
update | Updates the current record. (Inherited from xRecord.) | |
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) | |
useExistingTempDBTable | (Inherited from xRecord.) | |
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.) | |
validateField | By-pass validation to the changes of a field in the table DMFSalesLineEntity record. | |
validateFieldValue | (Inherited from xRecord.) | |
validateInStaging | Validates record in staging | |
validateWrite | Do not checks if the DMFSalesLineEntityrecord can be saved. | |
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) | |
wait | Pauses a process. (Inherited from Object.) | |
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) | |
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) | |
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) | |
::validateDates | Function that validates date string. | |
::validateSalesQuantity | Validates sales quantity. |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
ActivityNumber | Extended Data Type: ProjActivityNumber Type: String |
ProjBasic | The activity number (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) |
BarCode | Extended Data Type: SalesBarCode Type: String |
LogisticsBasic | Bar code digits (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
BarCodeType | Extended Data Type: BarcodeSetupId Type: String |
None | Select or view the bar code setup ID (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Blocked | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is the line locked? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CaseTagging | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is case tagging mandatory? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Complete | Extended Data Type: DMFNoYesStr Type: String |
DMF | Deliver complete line? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
configId | Extended Data Type: EcoResItemConfigurationName Type: String |
Config | Descriptive name of configuration (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ConfirmedDlv | Extended Data Type: SalesShippingDate Type: Date |
LogisticsBasic | Confirmed ship date if exists, otherwise requested ship date (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CostPrice | Extended Data Type: ReturnCostPrice Type: Real |
LogisticsBasic | Cost price per unit of the returned item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
CountyOrigDest | Extended Data Type: AddressCountyOrigDest Type: String |
None | Intrastat county of origin/destination. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CurrencyCode | Extended Data Type: CustCurrencyCode Type: String |
None | Currency the line is invoiced in (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustAccount | Extended Data Type: CustAccount Type: String |
None | Customer account (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustGroup | Extended Data Type: CustGroupId Type: String |
LedgerBasic | Customer group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustomerLineNum | Extended Data Type: CustLineNum Type: Integer |
None | Customer's line number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustomerRef | Extended Data Type: CustRefLine Type: String |
LedgerBasic | Customer's reference (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustomsDocDate_MX | Extended Data Type: CustomsDocDate_MX Type: Date |
None | Date of custom number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustomsDocNumber_MX | Extended Data Type: CustomsDocNumber_MX Type: String |
None | Document number of import document. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustomsName_MX | Extended Data Type: CustomsName_MX Type: String |
None | Name of custom. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DefaultDimension | Extended Data Type: DMFDefaultDimensionStr Type: String |
DMF | <Dimension1>:<Dimension2>:...<DimensionN> (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DefinitionGroup | Extended Data Type: DMFDefinationGroupName Type: String |
DMF | Processing group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryAddress | Extended Data Type: Addressing Type: String |
LedgerBasic | View the formatted information for the address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryCity | Extended Data Type: AddressCity Type: String |
LedgerBasic | City for ZIP/postal code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryCountryRegionId | Extended Data Type: AddressCountryRegionId Type: String |
None | Country/region of delivery address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryCounty | Extended Data Type: AddressCountyId Type: String |
None | County of delivery address. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryDateControlType | Extended Data Type: DMFSalesDeliveryDateControlType Type: String |
DMF | Select for automatic calculation of possible ship and receipt dates. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryLocationRole | Extended Data Type: DMFLocationRole Type: String |
DMF | Location role (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryName | Extended Data Type: LogisticsDeliveryName Type: String |
None | The name that is associated with the selected delivery address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryState | Extended Data Type: AddressStateId Type: String |
None | Identification of state (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryStreet | Extended Data Type: AddressStreet Type: String |
LedgerBasic | Enter the street of the address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
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) |
DeliveryType | Extended Data Type: DMFTradeLineDlvType Type: String |
DMF | Delivery type of the current order line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DeliveryZipCode | Extended Data Type: AddressZipCodeId Type: String |
LedgerBasic | ZIP/postal code in delivery address (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DlvMode | Extended Data Type: DlvModeId Type: String |
None | The means by which the order will be delivered (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. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ExecutionId | Extended Data Type: DMFExecutionId Type: String |
DMF | Identification mark in staging (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ExpectedRetQty | Extended Data Type: ReturnExpectedRetQty Type: Real |
ReturnItem | Quantity to be returned. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ExternalItemId | Extended Data Type: SalesExternalItemId Type: String |
LogisticsBasic | Customer item number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InterCompanyInventTransId | Extended Data Type: InventRefTransId Type: String |
TradeInterCompany | Lot ID referred to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InterCompanyOrigin | Extended Data Type: DMFInterCompanyOrigin Type: String |
DMF | States whether the line was created manually (Source), or indirectly as part of an intercompany chain (Derived) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
inventBatchId | Extended Data Type: InventBatchId Type: String |
LogisticsBasic | Batch dimension. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventColorId | Extended Data Type: EcoResItemColorName Type: String |
EcoResProductColor | Descriptive name of color (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventDeliverNow | Extended Data Type: InventQty Type: Real |
None | Quantity now being delivered in the inventory unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventLocationId | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventRefId | Extended Data Type: InventRefId Type: String |
None | Number of the order, project, production, or purchase referred to (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventRefTransId | Extended Data Type: InventRefTransId Type: String |
LogisticsBasic | Lot ID referred to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventRefType | Extended Data Type: DMFInventRefTypeStr Type: String |
DMF | Module and number referred to (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
inventSerialId | Extended Data Type: InventSerialId Type: String |
LogisticsBasic | Serial number dimension. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventSiteId | Extended Data Type: InventSiteId Type: String |
LogisticsBasic | Identify the site (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventSizeId | Extended Data Type: EcoResItemSizeName Type: String |
EcoResProductSize | Descriptive name of size (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventStyleId | Extended Data Type: EcoResItemStyleName Type: String |
EcoResProductStyle | Descriptive name of style (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventTransId | Extended Data Type: TradeInventTransId Type: String |
LogisticsBasic | Identification of the item lot. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventTransIdReturn | Extended Data Type: TradeInventTransIdReturn Type: String |
LogisticsBasic | Lot ID for items being returned (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
IsSelected | Extended Data Type: DMFIsSelected Type: Enum |
DMF | Select the record for migration from staging to target (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ItemBOMId | Extended Data Type: ItemBOMId Type: String |
BOMVersion | BOM number for specific sub-BOM. If blank, the active number is used. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ItemId | Extended Data Type: ItemIdSmall Type: String |
LogisticsBasic | Item number in order line (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ItemPBAId | Extended Data Type: PBAId Type: String |
PBA_ProductBuilder | Product model ID (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ItemReplaced | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is sales line created for returned item? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ItemRouteId | Extended Data Type: ItemRouteId Type: String |
ProdRouting | Route number for specific subroute. If blank, the active number is used. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ItemTagging | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is item tagging mandatory? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LedgerDimension | Extended Data Type: DMFLedgerDimension Type: String |
DMF | Ledger account for posting lines to a specific sales account. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LineAmount | Extended Data Type: SalesLineAmount Type: Real |
LogisticsBasic | Sales amount of the line, including discount (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LineDeliveryType | Extended Data Type: DMFLineDeliveryType Type: String |
DMF | Role of line in a delivery schedule (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LineDisc | Extended Data Type: SalesLineDisc Type: Real |
PriceDisc | Line discount in amount per price unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LineHeader | Extended Data Type: LineHeader Type: String |
None | Text describing the line (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LineNum | Extended Data Type: LineNum Type: Real |
None | Used for sorting (COUNTER) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LinePercent | Extended Data Type: SalesLinePercent Type: Real |
PriceDisc | Line discount percentage. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_CalculatedAmount | Extended Data Type: AmountCur Type: Real |
None | Calculated value of the charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_CurrencyCode | Extended Data Type: CurrencyCode Type: String |
None | Currency to be used for invoicing (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_DocumentStatus | Extended Data Type: DMFDocumentStatus Type: String |
DMF | Description of the current document type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_InterCompanyCompanyId | Extended Data Type: InterCompanyCompanyId Type: String |
TradeInterCompany | Identification of intercompany company accounts. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_InterCompanyInvoiceId | Extended Data Type: InterCompanyInvoiceId Type: String |
None | Number of the invoice received from the intercompany company (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_InterCompanyMarkupUseValue | Extended Data Type: DMFNoYesStr Type: String |
DMF | Calculate charge amount from intercompany charge amount (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_InterCompanyMarkupValue | Extended Data Type: InterCompanyMarkupValue Type: Real |
Markup | Calculated value from the intercompany sales order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_IsDeleted | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is the current record deleted? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_IsModified | Extended Data Type: DMFNoYesStr Type: String |
DMF | Has the current record been modified since previous version? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_Keep | Extended Data Type: DMFNoYesStr Type: String |
DMF | Keep charges transaction after invoicing (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_LineNum | Extended Data Type: LineNum Type: Real |
None | Identification of line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_MarkupCategory | Extended Data Type: DMFMarkupCategory Type: String |
DMF | Charges category applicable to the line (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_MarkupCode | Extended Data Type: MarkupCode Type: String |
Markup | Identification of the charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_ModuleCategory | Extended Data Type: DMFHeadingLine Type: String |
DMF | Category in module (header, line) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_ModuleType | Extended Data Type: DMFModuleInventCustVend Type: String |
DMF | Specify which module the charges group is attached to (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_OrigTableId | Extended Data Type: MarkupTransOrigRefTableId Type: Integer |
Markup | Table the transaction refers to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_Posted | Extended Data Type: AmountCur Type: Real |
None | Debited amount in the General ledger module (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TaxAmount | Extended Data Type: TaxAmountCur Type: Real |
LedgerBasicSalesTax | Calculated sales tax amount in the sales tax settlement currency (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TaxAutogenerated | Extended Data Type: DMFNoYesStr Type: String |
DMF | Sales tax is automatically calculated or specified by user. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TaxGroup | Extended Data Type: TaxGroup Type: String |
LedgerBasicSalesTax | A group of sales tax codes for calculating taxes on a sale or purchase (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TaxItemGroup | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Group of sales tax codes that can be calculated for an item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TaxWriteCode | Extended Data Type: TaxWriteCode Type: String |
LedgerBasicSalesTax | Code printed on the voucher. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TransDate | Extended Data Type: TransDate Type: Date |
None | Posting date used (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_TransTableId | Extended Data Type: MarkupTransRefTableId Type: Integer |
None | Table the transaction refers to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_Txt | Extended Data Type: TransTxt Type: String |
None | Description of the charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_Value | Extended Data Type: MarkupValue Type: Real |
Markup | Value attached to the charges category (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MarkUpTrans_Voucher | Extended Data Type: Voucher Type: String |
LedgerBasic | Voucher number employed (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 (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MultiLnPercent | Extended Data Type: SalesMultiLnPercent Type: Real |
PriceDisc | The multiline discount percentage (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Name | Extended Data Type: ItemFreeTxt Type: String |
LogisticsBasic | Line description (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
OverDeliveryPct | Extended Data Type: SalesOverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
PackingUnit | Extended Data Type: InventPackingUnit Type: String |
InventPackaging | Unit the item is packed in (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
PackingUnitQty | Extended Data Type: InventPackingUnitQty Type: Real |
InventPackaging | Quantity of packing units (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
PalletTagging | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is pallet tagging mandatory? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Partition | Extended Data Type: Partition Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
PdsBatchAttribAutoRes | Extended Data Type: DMFNoYesStr Type: String |
DMF | Consider batch attributes when processing auto reservation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
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) |
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) |
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) |
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) |
PdsExcludeFromRebate | Extended Data Type: DMFNoYesStr Type: String |
DMF | 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) |
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) |
PdsSameLot | Extended Data Type: DMFNoYesStr Type: String |
DMF | 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) |
PdsSameLotOverride | Extended Data Type: DMFNoYesStr Type: String |
DMF | Manual override of same batch selection field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Port | Extended Data Type: IntrastatPortId Type: String |
ForeignTrade | Port where current delivery is loaded. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
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) |
PriceUnit | Extended Data Type: PriceUnit Type: Real |
LogisticsBasic | Number of units the quantity applies to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ProjCategoryId | Extended Data Type: ProjCategoryId Type: String |
ProjBasic | Category that is used as a default. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ProjId | Extended Data Type: ProjId Type: String |
ProjBasic | Project identification (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ProjLinePropertyId | Extended Data Type: ProjLinePropertyId Type: String |
ProjBasic | Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ProjTransId | Extended Data Type: ProjItemTransId Type: String |
ProjBasic | Identification of transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
PropertyNumber_MX | Extended Data Type: PropertyNumber_MX Type: String |
None | Register number of property. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
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) |
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) |
PurchorderFormNum | Extended Data Type: CustPurchaseOrder Type: String |
None | Customer requisition number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReceiptDateConfirmed | Extended Data Type: SalesReceiptDateConfirmed Type: Date |
SalesDeliveryDateControl | The selling company confirms that the customer will receive the order on this date. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReceiptDateRequested | Extended Data Type: SalesReceiptDateRequested Type: Date |
SalesDeliveryDateControl | The date that the customer asked to receive the order on (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RecId | Extended Data Type: RecId Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Reservation | Extended Data Type: DMFItemReservation Type: String |
DMF | Reserve items automatically? (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) |
ReturnAllowReservation | Extended Data Type: DMFNoYesStr Type: String |
DMF | Treat lot as On Order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReturnArrivalDate | Extended Data Type: ReturnArrivalDate Type: Date |
ReturnItem | Date when the return delivery was received. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReturnClosedDate | Extended Data Type: ReturnClosedDate Type: Date |
ReturnItem | Date when the return line was invoiced or cancelled. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReturnDeadline | Extended Data Type: ReturnDeadline Type: Date |
ReturnItem | Date the return delivery must be received. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReturnDispositionCodeId | Extended Data Type: ReturnDispositionCodeId Type: String |
ReturnItem | Identification of the disposition code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ReturnStatus | Extended Data Type: DMFReturnStatusHeader Type: String |
DMF | Status of the return order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RowId | Extended Data Type: Integer Type: Integer |
None | Integer. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesCategory | Extended Data Type: DMFSalesCategory Type: String |
DMF | Category from the sales category hierarchy (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesDeliverNow | Extended Data Type: SalesQty Type: Real |
None | Quantity delivered now in sales units (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesGroup | Extended Data Type: CommissSalesGroup Type: String |
Commission | Commission sales group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesId | Extended Data Type: SalesId Type: String |
LogisticsBasic | Specify the order number that the line is attached to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesMarkup | Extended Data Type: SalesMarkup Type: Real |
LogisticsBasic | Fixed charges on sales price, which are independent of quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesPrice | Extended Data Type: SalesPrice Type: Real |
None | Sales price of line per price unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesQty | Extended Data Type: SalesOrderedQty Type: Real |
None | Quantity ordered in the sales unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesStatus | Extended Data Type: DMFSalesStatus Type: String |
DMF | Order status as to delivery and invoicing (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesType | Extended Data Type: DMFSalesType Type: String |
DMF | Type of the current order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SalesUnit | Extended Data Type: SalesUnit Type: String |
None | Unit the item is sold in. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Scrap | Extended Data Type: DMFNoYesStr Type: String |
DMF | For returned item specifies whether it is to be considered as scrap. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SearchKey | Extended Data Type: Integer Type: Integer |
None | The search key field used for fast look up of policies. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ServiceOrderId | Extended Data Type: SMAServiceOrderId Type: String |
SMAManagement | Identification of service order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShipCarrierAccount | Extended Data Type: ShipCarrierAccount Type: String |
ShipCarrier | Account number that is invoiced by the carrier (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShipCarrierAccountCode | Extended Data Type: ShipCarrierAccountCode Type: String |
ShipCarrier | Account code to identify the carrier account number that will be used to bill the company (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShipCarrierDlvType | Extended Data Type: DMFShipCarrierDlvType Type: String |
DMF | Service type (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShipCarrierId | Extended Data Type: ShipCarrierId Type: String |
ShipCarrier | Identification of the carrier service, assigned by the shipping carrier (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShipCarrierName | Extended Data Type: LogisticsShipCarrierName Type: String |
None | Name or company name of third-party address. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShippingDateConfirmed | Extended Data Type: SalesShippingDateConfirmed Type: Date |
LogisticsBasic | The selling company confirms that the order will be shipped on this date. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SkipUpdate | Extended Data Type: DMFInterCompanySkipUpdate Type: String |
DMF | Defines how intercompany updates should be handled. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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) |
StatProcId | Extended Data Type: IntrastatProcId Type: String |
ForeignTrade | Code for the current statistical procedure. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
StatTriangularDeal | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is this a triangular deal? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SystemEntrySource | Extended Data Type: DMFPriceDiscSystemSource Type: String |
DMF | - (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TaxAutogenerated | Extended Data Type: DMFNoYesStr Type: String |
DMF | Sales tax is automatically calculated or specified by user. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TaxGroup | Extended Data Type: TaxGroup Type: String |
LedgerBasicSalesTax | A group of sales tax codes for calculating taxes on a sale or purchase (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TaxItemGroup | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Group of sales tax codes that can be calculated for an item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TaxWithholdGroup | Extended Data Type: TaxWithholdGroup Type: String |
LedgerBasicWithholdingTax | Identification of the withholding tax group. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TaxWithholdItemGroupHeading_TH | Extended Data Type: DMFTaxWithholdItemGroupId_TH Type: String |
DMF | Group of withholding tax codes that can be calculated for an item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TransactionCode | Extended Data Type: IntrastatTransactionCodeId Type: String |
ForeignTrade | Code for the current transaction code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TransferStatus | Enumeration: DMFTransferStatus |
None | Transfer status for active record (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Transport | Extended Data Type: IntrastatTransport Type: String |
ForeignTrade | Specify means of transport for the current order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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 (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
wMSLocationId | Extended Data Type: WMSLocationId Type: String |
WMSBasic | Location in a warehouse. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
wMSPalletId | Extended Data Type: WMSPalletId Type: String |
WMSPallet | Unique ID for the pallet (Serial Shipping Container Code) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Top
Field Groups
Field Group | Fields |
---|---|
ExclusionList | |
AutoReport | |
DMF |
Top
Relations
Relation | Table | Lines |
---|---|---|
CustLedger | CustLedger | |
DMFExecution | DMFExecution | |
InventDimCombination | InventDimCombination | |
Partition | Partitions | |
RAssetId | RAssetTable | |
SalesLine | SalesLine |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
RecId | No | Yes | |
SalesLine | No | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
DMFSalesLineEntity Table