SalesQuotationLine Table
The SalesQuotationLine table contains sales quotation lines.
Configuration Key: QuotationBasic
Methods
| Method | Description | |
|---|---|---|
.gif "Public method") |
accountConsumption | |
|
accountDisc | |
|
accountIssue | |
|
accountSales | |
|
amountExclTax | |
|
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.) |
|
assessableValue_IN | Gets the assessable value. |
|
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) |
|
busRelAccount | |
|
calcGrossAmount | |
|
calcGrossAmountExclTax | |
|
calcLineAmount | |
|
calcLineAmountExclTax | |
|
calcLineAmountForced | |
|
calcLineDiscExclTax | |
|
calcPackingUnit | |
|
calcPackingUnitQty | |
|
calcPrice2LineAmount | |
|
calcQtyOrdered | |
|
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.) |
|
checkCFOP_BR | Validates whether CFOP is present in the CFOPMatrix table and has the correct attributes (operation ID, transaction type, direction, and location). |
|
checkCurrencyCode | |
|
checkCustomsTariffCode_IN | Checks the customs tariff code. |
|
checkDelete | |
|
checkFindProjJournalTxt | |
|
checkInitFromInventTable | |
|
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) |
|
checkInventDim | Validates product and mandatory dimensions. |
|
checkItemId | |
|
checkItemPBAId | |
|
checkLedgerDimension | |
|
checkMaximumRetailPrice_IN | Checks the maximum retail price. |
|
checkPriceDate | Triggers price recalculation after date change according to the price date type setting. |
|
checkQuotationType | |
|
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.) |
|
checkSalesCategory | Check that the sales category field is filled correctly. |
|
checkSalesUnit | |
|
checkTaxItemGroup | |
|
checkUpdatePhysical | |
|
clear | Removes all rows from the table buffer. (Inherited from xRecord.) |
|
clearAddressReference | |
|
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.) |
|
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 the SalesQuotationLine table. |
|
createFromTmpFrmVirtual | Creates a sales quotation line from a TmpFrmVirtual record buffer. |
|
createLine | Creates a sales quotation line. |
|
createMarkupTrans | |
|
creditNoteLine | |
|
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 | |
|
deleteInventTrans_BR | Deletes the inventTrans record that is related to the current salesQuotationLine record if the order operation is configured so that it does not create inventory transactions. |
|
deliveryAddress | |
|
deliveryLocation | |
|
deliveryName | |
|
deliveryTerm | |
|
deliveryTransDateTime | |
|
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) |
|
discAmount | |
|
discPercent | |
|
displayAddress_IN | Gets the address information for display. |
|
displayDeliveryName | |
|
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) |
|
dlvAddress | |
|
dlvDate | |
|
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.) |
|
editProductDimensionsAllowed | Determines whether the product directions on the line can be edited. |
|
endDisc | |
|
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) |
|
exciseManufacture_IN | Gets the correct value of ExciseManufacture_IN for given parameters. |
|
exciseNone_IN | Gets the correct value of ExciseNone_IN for given parameters. |
|
exciseTraders_IN | Gets the correct value of ExciseTraders_IN for given parameters. |
|
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.) |
|
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.) |
|
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) |
|
getMiscChargesAmount_IN | Gets 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.) |
|
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.) |
|
hasOnlyLineAmount | |
|
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 | |
|
initFromCustExternalItemDescription | |
|
initFromCustQuotationConfirmTrans | |
|
initFromCustQuotationTrans | |
|
initFromCustTable | |
|
initFromEmplTable | |
|
initFromInventTable | |
|
initFromItemOrCategory | |
|
initFromOrderLineWithMultipleDeliveries | Initializes a delivery line based on its order line. |
|
initFromPriceDisc | |
|
initFromProductDimensions | |
|
initFromProjCategoryId | |
|
initFromProjInvoiceItem | |
|
initFromProjTable | |
|
initFromSalesQuotationBasketLine | |
|
initFromSalesQuotationLine | |
|
initFromSalesQuotationLine_IN | Initializes the fields of a SalesQuotationLine record from a given SalesQuotationLine buffer. |
|
initFromSalesQuotationTable | |
|
initFromTmpSuppItem | |
|
initItemDim | |
|
initName | |
.gif "Private method") |
initRetailVariantId | |
|
initSalesQty | |
|
initValue | Initializes field values in a new SalesQuotationLine record. |
|
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
|
insert | |
|
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
|
inventDim | |
|
inventTable | |
|
invoiceAccount | |
|
isCategoryBased | Checks whether the order line is category based. |
|
isDropShipment | Determines whether the order line is part of a drop shipment. |
|
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.) |
|
isItemOrNoneAndCategoryBased | Indicates whether the line has transaction type of item or none, and category based. |
|
isLinkedToAgreement | Identifies that the sales quotation line is linked to an agreement line. |
|
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) |
|
isPartOfUOWSaveChanges | (Inherited from xRecord.) |
|
isStocked | Indicates whether the order line is tracked in inventory. |
|
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 | |
|
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.) |
|
lineAmountExclTax | |
|
lineAmountModified | |
|
lineAmountMST | |
|
lineAmountMSTExclTax | |
|
lineDeliveryImageRessNo | Determines the delivery type of a line. |
|
lineDisc | |
|
linkInventDim2Dimension | Applies default SalesQuotationLine.dimension values that are based on the InventDim record buffer values. |
|
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) |
|
logisticsAddress_IN | Reads the LogisticsPostalAddress table for the specified RegistrationLocation value (location ID). |
|
markupAllowed | |
|
matchingAgreementLine | Retrieves the value of the related MatchingAgreementLine class. |
|
mcrCalcCostPrice | Calculates the cost price of the item on the SalesQuotationLine. |
|
mcrCreateFromTmpFrmVirtual | Creates a sales quotation line from a TmpFrmVirtual record buffer. |
|
mcrDeleteRelatedLineItems | Deletes the line(s) record. |
|
mcrDisplayMarginPercentStr | Displays the margin percentage. |
|
mcrDisplayPhone | Displays the phone for the address of the current record. |
|
mcrNextChildLineNum | Gets a line number for a child line. |
|
mcrPackMCRSalesParmLine | Packs the sales quotation line information. |
|
mcrPackMCRSalesQuotationLine | Packs the sales quotation line information. |
|
mcrPackMCRSalesQuotationLineOverride | Packs the sales quotation line information. |
|
mcrPricePerSalesQty | Gets the price per quantity value. |
|
mcrSalesQuotationLine | Recovers SalesQuotationLine extension table |
|
mcrSalesQuotationLineOverride | Gets SalesQuotationLineOverride extension table |
|
merge | Merges the current table with the specified table. (Inherited from xRecord.) |
|
mergeDimension | Retrieves a dimension set that holds the merged combination of the current defaultDimension field on this table and the provided dimension set. |
|
modifiedField | |
|
modifiedField_Project | |
|
modifiedField_Sales | |
|
modifiedFieldDDC | Processes the modified field event for delivery date control fields. |
|
modifiedFieldValue | Executes when a field has been modified. |
|
modifyInventDim | |
|
moduleType | |
|
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 | Is executed when the CFOP value is changed. |
|
onDeliveryPostalAddressChange_BR | Is executed after the delivery postal address is changed. |
|
onTaxChange_BR | Is executed when the tax group is changed. |
|
orderAccount | |
|
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.) |
|
party | |
|
pdsCWQtyConversion | Updates the sales quantity from the converted catch weight quantity. |
|
pdsCWQtyModified | Updates quantities based on changed catch weight value. |
|
pdsCWUnitId | Gets the catch weight unit for the item. |
|
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) |
|
postDiscPercent_BR | Retrieves the discount percentage. |
|
postingSales | |
|
postLoad | Is executed after a record is read. (Inherited from xRecord.) |
|
postModifyInventDim_BR | Is executed after the inventory dimension is changed. |
|
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 the price has to be calculated according to the price date type setting. |
|
priceGroupId | |
|
projId | |
|
psaDeleteActivityEstimates | |
|
psaUpdateActivityEstimates | |
|
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.) |
|
runPriceDiscPolicyDialog | Calls the runPriceDiscPolicyDialog method of the PriceDiscResultFields table map. |
|
salesPurchTable | |
|
salesQtyModified | |
|
salesQuotationTable | |
|
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.) |
|
setAddressFromSalesQuotationLine | |
|
setAddressFromSalesQuotationTable | |
|
setCFOP_BR | Is responsible for setting the CFOP code. |
|
setConnection | Sets the user connection for this table. (Inherited from xRecord.) |
|
setCostSalesPrice | |
|
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) |
|
setDeliveryDateControlType | Sets the delivery date control type for the current sales quotation line. |
|
setDeliveryName | Sets the delivery name field by using a specified logistic location. |
|
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) |
|
setInventDeliverNow | |
|
setInventDimId | Applies the InventDimId parameter to the SalesQuotationLine.inventDimId field and assigns default values that are based on the new inventory dimensions. |
|
setInventDimIdFromInventDim | Finds or creates an InventDimId value for the InventDim parameter and applies the found InventDimId to the SalesQuotationLine.inventDimId field. |
|
setLineAmount | |
|
setLineProperty | |
|
setListCode | |
|
setLocation | |
|
setPriceAgreement | |
|
setPriceDisc | |
|
setPriceDiscChangePolicy | Calls the setPriceDiscChangePolicy method of the PriceDiscResultFields table map. |
|
setPriceDiscMarkup | Calls setPriceDiscMarkup method on the SalesPurchLine table map. |
|
setPriceDiscPriceUnit | The method calls the setPriceDiscPriceUnit method on the SalesPurchLine table map. |
|
setQuotationStatus | |
|
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) |
|
setStockedProduct | Sets the StockedProduct field for the line based on line type and item model group for the associated item. |
|
setSuframaDiscount_BR | Calculates the SUFRAMA discount. |
|
setTaxGroup | |
|
setTaxGroupAndTaxItemGroupFields_BR | Sets the SalesQuotationLine.TaxGroup and SalesQuotationLine.TaxItemGroup values, based on the TaxesMatrix record. |
|
setTaxInfoOfCompany_IN | Reads the table buffer and sets the field to the required value. |
|
setTaxItemGroup | |
|
setTemplateFieldSpecieal | |
|
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.) |
|
skipMarkup | |
|
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 nullNothingnullptrunita null reference (Nothing in Visual Basic) 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.) |
|
taxPcsPrice | |
|
timeZoneSite | |
|
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 | |
|
update | |
|
updateMarkupTransTaxGroups_BR | Updates the markup transaction, based on the tax group and tax item group. |
|
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. |
|
validateField | Validates a passed in field. |
|
validateFieldValue | (Inherited from xRecord.) |
|
validateProjectDate | Checks the project transaction date valid or not. |
|
validateWrite | Determines whether the current record is valid and ready to be written to the database. |
|
validateWrite_Server | |
|
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 | |
|
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) |
.gif "Static member") |
::createQuotationLineFromTemplate | |
|
::exist | |
|
::existDifferentCurrency | |
|
::existItemId | Whether a record exists for the specified item. |
|
::find | |
|
::findInventTransId | |
|
::findPSARefRecId | |
|
::findRecId | |
|
::lastDeliveryScheduleLineNum | Retrieves the last line number that is used by the delivery lines linked to the specified order line. |
|
::lastLineNum | |
|
::mcrCreateFromTmpFrmVirtualIL | Executes the creation of sales order quotation lines based on TmpFrmVirtual records in IL. |
|
::mcrCreateFromTmpFrmVirtualServer | Executes the creation of sales order lines based on TmpFrmVirtual records on the server. |
|
::modifySalesQty | |
|
::resetAxSalesQuotationLinePolicies | Resets the price discount policies. |
|
::updateTransfered2Forecast | |
|
::updateTransfered2ItemReq |
Top
Fields
| Field | Type | Configuration key | Description |
|---|---|---|---|
| AccountType | Enumeration: LedgerJournalACType |
None | Account type that specifies the type of account the transaction will be applied to. |
| AddressRefRecId | Extended Data Type: AddressRefRecId Type: Int64 |
None | Reference field in a different table |
| AddressRefTableId | Extended Data Type: AddressRefTableId Type: Integer |
None | Table the transaction refers to. |
| AssessableValue_IN | Extended Data Type: AmountCur Type: Real |
None | Assessable value for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| BarCode | Extended Data Type: SalesBarCode Type: String |
LogisticsBasic | Bar code digits |
| BarCodeType | Extended Data Type: BarcodeSetupId Type: String |
None | Select or view the bar code setup ID |
| CaseTagging | Extended Data Type: RFIDCaseTagging Type: Enum |
RFIDTagging | Is case tagging mandatory? |
| CFOPTable_BR | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| Company | Extended Data Type: SelectableDataArea Type: String |
None | ID for the company you can select |
| CompanyLocation_IN | Extended Data Type: LogisticsLocationRecId Type: Int64 |
None | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ConfirmedDlv | Extended Data Type: SalesShippingDate Type: Date |
LogisticsBasic | Confirmed ship date if exists, otherwise requested ship date |
| Consignment_IN | Extended Data Type: NoYesId Type: Enum |
None | Is this a consignment transaction? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| CostPrice | Extended Data Type: ReturnCostPrice Type: Real |
LogisticsBasic | Cost price per unit of the returned item. |
| CountyOrigDest | Extended Data Type: AddressCountyOrigDest Type: String |
None | Intrastat county of origin/destination. |
| createdDateTime | Extended Data Type: CreatedDateTime Type: UtcDateTime |
None | |
| CurrencyCode | Extended Data Type: CustCurrencyCode Type: String |
None | Currency the line is invoiced in |
| CustAccount | Extended Data Type: CustAccount Type: String |
None | Customer account |
| CustomerRef | Extended Data Type: CustRefLine Type: String |
LedgerBasic | Customer's reference |
| CustomsTariffCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Customs tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| dataAreaId | Extended Data Type: DataAreaId Type: String |
None | |
| DefaultDimension | Extended Data Type: DimensionDefault Type: Int64 |
LedgerBasic | Default dimensions |
| DeliveryDateControlType | Enumeration: SalesDeliveryDateControlType |
SalesDeliveryDateControl | Select for automatic calculation of possible ship and receipt dates. |
| DeliveryName | Extended Data Type: LogisticsDeliveryName Type: String |
None | The name that is associated with the selected delivery address |
| DeliveryPostalAddress | Extended Data Type: LogisticsPostalAddressRecId Type: Int64 |
TradeMultiShipTo | Reference field in a different table |
| DirectSettlement_IN | Enumeration: DirectSettlement_IN |
None | Excise register to update the excise amount to, without using the settlement process. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| DlvMode | Extended Data Type: DlvModeId Type: String |
None | The means by which the order will be delivered |
| DlvTerm | Extended Data Type: SalesDlvTermId Type: String |
None | Specify terms of delivery for the current order line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DSA_IN | Extended Data Type: NoYesId Type: Enum |
None | Update the Daily Stock Account (DSA)? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| EndDate | Extended Data Type: TransDate Type: Date |
None | End date is used with per code. |
| ExciseRecordType_IN | Enumeration: ExciseRecordType_IN |
None | Excise record type to update the excise amount to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ExciseTariffCodes_IN | Extended Data Type: RefRecId Type: Int64 |
None | Excise tariff code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ExciseType_IN | Enumeration: ExciseType_IN |
None | Excise-type category of the company. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ExportOrder_IN | Extended Data Type: NoYesId Type: Enum |
None | Identifies the order as export order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ExternalItemId | Extended Data Type: SalesExternalItemId Type: String |
LogisticsBasic | Customer item number. |
| InventDeliverNow | Extended Data Type: InventQty Type: Real |
None | Quantity now being delivered in the inventory unit |
| InventDimId | Extended Data Type: InventDimId Type: String |
None | Identification of dimensions for the item. |
| InventRefId | Extended Data Type: InventRefId Type: String |
None | Number of the order, project, production, or purchase referred to |
| InventRefTransId | Extended Data Type: InventRefTransId Type: String |
LogisticsBasic | Lot ID referred to. |
| InventRefType | Enumeration: InventRefType |
None | Module and number referred to |
| InventTransId | Extended Data Type: TradeInventTransId Type: String |
LogisticsBasic | Identification of the item lot. |
| ItemBOMId | Extended Data Type: ItemBOMId Type: String |
BOMVersion | BOM number for specific sub-BOM. If blank, the active number is used. |
| ItemId | Extended Data Type: ItemIdSmall Type: String |
LogisticsBasic | Item number in order line |
| ItemPBAId | Extended Data Type: PBAId Type: String |
PBA_ProductBuilder | Product model ID |
| ItemRouteId | Extended Data Type: ItemRouteId Type: String |
ProdRouting | Route number for specific subroute. If blank, the active number is used. |
| ItemTagging | Extended Data Type: RFIDItemTagging Type: Enum |
RFIDTagging | Is item tagging mandatory? |
| LedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LogisticsBasic | Ledger account for posting lines to a specific sales account. |
| LineAmount | Extended Data Type: SalesLineAmount Type: Real |
LogisticsBasic | Sales amount of the line, including discount |
| LineDeliveryType | Enumeration: LineDeliveryType |
None | Role of line in a delivery schedule |
| LineDisc | Extended Data Type: SalesLineDisc Type: Real |
PriceDisc | Line discount in amount per price unit. |
| LineHeader | Extended Data Type: ItemFreeTxt Type: String |
LogisticsBasic | Standard item description. |
| LineNum | Extended Data Type: LineNum Type: Real |
None | Quotation line number. |
| LinePercent | Extended Data Type: SalesLinePercent Type: Real |
PriceDisc | Line discount percentage. |
| LinePropertyId | Extended Data Type: ProjLinePropertyId Type: String |
ProjBasic | Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost |
| ManualEntryChangepolicy | Extended Data Type: PriceDiscPolicyManual Type: Int64 |
None | - |
| MaximumRetailPrice_IN | Extended Data Type: MaximumRetailPrice_IN Type: Real |
None | Maximum retail price for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| MCROrderLine2PriceHistoryRef | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| MultiLnDisc | Extended Data Type: SalesMultiLnDisc Type: Real |
PriceDisc | Multiline discount per price unit |
| MultiLnPercent | Extended Data Type: SalesMultiLnPercent Type: Real |
PriceDisc | The multiline discount percentage |
| Name | Extended Data Type: ItemFreeTxt Type: String |
LogisticsBasic | Line description |
| NewSalesPrice | Extended Data Type: SalesPrice Type: Real |
None | New sales price after price simulation. |
| NewTotalContributionRatio | Extended Data Type: Price Type: Real |
None | New contribution ratio after price simulation. |
| OffsetAccountType | Enumeration: LedgerJournalACType |
None | Specify account type of the selected account, for instance ledger, customer or vendor. |
| OffsetCompany | Extended Data Type: SelectableDataArea Type: String |
LedgerAdvIntercompanyAccounting | Abbreviation of the company accounts where the current line is to be offset. |
| OffsetLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Offset account for the transaction. |
| OffsetTxt | Extended Data Type: LedgerJournalTransTxt Type: String |
None | Any additional text for offset transaction. |
| OrigCostPrice | Extended Data Type: CostPrice Type: Real |
None | Cost price in standard currency. |
| OverDeliveryPct | Extended Data Type: SalesOverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity |
| PackingUnit | Extended Data Type: InventPackingUnit Type: String |
InventPackaging | Unit the item is packed in |
| PackingUnitQty | Extended Data Type: InventPackingUnitQty Type: Real |
InventPackaging | Quantity of packing units |
| PalletTagging | Extended Data Type: RFIDPalletTagging Type: Enum |
RFIDTagging | Is pallet tagging mandatory? |
| Partition | Extended Data Type: Partition Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PdsCWDeliverNow | Extended Data Type: PdsCWInventQty Type: Real |
PdsCatchWeight | Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PdsCWQty | Extended Data Type: PdsCWInventQty Type: Real |
PdsCatchWeight | Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PdsCWRemainInventPhysical | Extended Data Type: PdsCWInventQty Type: Real |
PdsCatchWeight | Catch weight quantity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| Port | Extended Data Type: IntrastatPortId Type: String |
ForeignTrade | Port where current delivery is loaded. |
| PriceCalcId | Extended Data Type: PriceCalcId Type: String |
BOM | Unique identification of the calculation. |
| PriceUnit | Extended Data Type: PriceUnit Type: Real |
LogisticsBasic | Number of units the quantity applies to. |
| ProjActivity | Extended Data Type: smmActivityNumber Type: String |
Project3 | The activity number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| ProjCategoryId | Extended Data Type: QuotationProjCategory Type: String |
ProjQuotation | Category that is used as a default. |
| ProjDescription | Extended Data Type: Description Type: String |
None | Brief description of transaction |
| ProjectWorker | Extended Data Type: ProjWorkerRecId Type: Int64 |
None | The name of the worker |
| ProjTransType | Enumeration: QuotationProjTransType |
QuotationBasic | Specifies the project transaction types used when transferring to the project |
| PSARefRecId | Extended Data Type: RefRecId Type: Int64 |
Project3 | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| QtyOrdered | Extended Data Type: InventQty Type: Real |
None | Quantity ordered in the inventory unit. |
| QuotationId | Extended Data Type: QuotationIdBase Type: String |
QuotationBasic | The quotation identifier |
| QuotationStatus | Enumeration: SalesQuotationStatus |
QuotationBasic | Quotation status types |
| QuotationType | Enumeration: QuotationType |
QuotationBasic | Type of quotation |
| ReceiptDateRequested | Extended Data Type: SalesReceiptDateRequested Type: Date |
SalesDeliveryDateControl | The date that the customer asked to receive the order on |
| RecId | Extended Data Type: RecId Type: Int64 |
None | |
| recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
| RemainInventPhysical | Extended Data Type: InventQty Type: Real |
None | Quantity - not yet packing slip delivered - in the inventory unit |
| RemainSalesFinancial | Extended Data Type: SalesQty Type: Real |
None | Quantity that has been packing slip delivered but not yet invoice updated. |
| RemainSalesPhysical | Extended Data Type: SalesQty Type: Real |
None | Quantity that has not yet been packing slip delivered. |
| RetailVariantId | Extended Data Type: RetailVariantId Type: String |
Retail | Item variants (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| SalesCategory | Extended Data Type: SalesCategory Type: Int64 |
LogisticsBasic | Category from the sales category hierarchy |
| SalesDeliverNow | Extended Data Type: SalesQty Type: Real |
None | Quantity that is delivered now. |
| SalesGroup | Extended Data Type: CommissSalesGroup Type: String |
Commission | Employee who 'sold' the line. |
| SalesMarkup | Extended Data Type: SalesMarkup Type: Real |
LogisticsBasic | Fixed charges on sales price, which are independent of quantity |
| SalesPrice | Extended Data Type: SalesPrice Type: Real |
None | Sales price of line per price unit |
| SalesQty | Extended Data Type: SalesQty Type: Real |
None | Quantity ordered in the sales unit |
| SalesTaxFormTypes_IN | Extended Data Type: SalesTaxFormTypesRecId_IN Type: Int64 |
None | India sales tax form type for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| SalesUnit | Extended Data Type: SalesUnit Type: String |
None | Unit the item is sold in. |
| ServiceCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Service code for the transaction line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ShippingDateRequested | Extended Data Type: SalesShippingDateRequested Type: Date |
LogisticsBasic | The day the selling company should ship the item in order to meet the customer's requested receipt date. |
| StartDate | Extended Data Type: TransDate Type: Date |
None | Date which the budget amount applies from. |
| StatProcId | Extended Data Type: IntrastatProcId Type: String |
ForeignTrade | Code for the current statistical procedure. |
| StatTriangularDeal | Extended Data Type: IntrastatTriangularDeal Type: Enum |
ForeignTrade | Is this a triangular deal? |
| StockedProduct | Extended Data Type: TradeStockedProduct Type: Enum |
LogisticsBasic | Track in inventory? |
| SuframaDiscount_BR | Extended Data Type: SalesLinePercent Type: Real |
PriceDisc | SUFRAMA discount percentage. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| SystemEntryChangePolicy | Extended Data Type: PriceDiscPolicySystem Type: Int64 |
None | - |
| SystemEntrySource | Enumeration: PriceDiscSystemSource |
None | - |
| TaxAutoGenerated | Extended Data Type: TaxAutoGenerated Type: Enum |
LedgerBasicSalesTax | Sales tax is automatically calculated or specified by user. |
| TaxGroup | Extended Data Type: TaxGroup Type: String |
LedgerBasicSalesTax | A group of sales tax codes for calculating taxes on a sale or purchase |
| TaxInventVATCommodityCode_IN | Extended Data Type: RefRecId Type: Int64 |
None | VAT commodity codes for item per state. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| TaxItemGroup | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Group of sales tax codes that can be calculated for an item. |
| TCSGroup_IN | Extended Data Type: TaxWithholdGroup Type: String |
LedgerBasicWithholdingTax | TCS group for calculation of withholding tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| TDSGroup_IN | Extended Data Type: TaxWithholdGroup Type: String |
LedgerBasicWithholdingTax | TDS group for calculation of withholding tax. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| TransactionCode | Extended Data Type: IntrastatTransactionCodeId Type: String |
ForeignTrade | Code for the current transaction code. |
| TransDate | Extended Data Type: ProjTransDate Type: Date |
ProjBasic | Project transaction date |
| Transferred2Forecast | Extended Data Type: NoYesId Type: Enum |
None | Indicates whether the line has been transferred to a forecast |
| Transferred2ItemReq | Extended Data Type: NoYesId Type: Enum |
None | Indicates whether the line has been transferred to an item requirement |
| Transferred2Journal | Extended Data Type: NoYesId Type: Enum |
None | Has line been transferred to journal? |
| Transport | Extended Data Type: IntrastatTransport Type: String |
ForeignTrade | Specify means of transport for the current order. |
| UnderDeliveryPct | Extended Data Type: SalesUnderDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to be less than the order quantity |
Top
Field Groups
| Field Group | Fields |
|---|---|
| AccountSelection | |
| AddressDisplay | |
| AddressReference | |
| AddressLookup | |
| All | |
| AutoReport | |
| Barcode | |
| Amount | |
| Commission | |
| CompanyLocation_IN | |
| CompanyInformation_IN | |
| Customs_IN | |
| CustomerRef | |
| Delivery | |
| DeliveryAddress | |
| Dimension | |
| Discount | |
| ExportOrder_IN | |
| FiscalInformation_BR | |
| Identification | |
| Integration | |
| Excise_IN | |
| ForeignTrade | |
| Inventory | |
| ItemReference | |
| ItemRouteId | |
| OffsetAccount | |
| PackagingMaterial | |
| PdsCWInventory | |
| RFIDtagging | |
| SalesQuantity | |
| ProjectTransferredStatus | |
| ProjItem | |
| ProjQuantity | |
| QuotationLine | |
| QuotationLines | |
| ProjTransOverview | |
| QuotationStatus | |
| ReturnGroup | |
| VAT_IN | |
| WithholdingTax_IN | |
| Price_IN | |
| PriceSimulation | |
| ProjActivityInfo | |
| ProjDates | |
| ProjectCostAmount | |
| ProjectSalesAmount | |
| PdsCWMain | |
| Posting | |
| Price | |
| SalesTax_IN | |
| ServiceTax_IN | |
| SalesTax | |
| SuframaDiscount_BR | |
| TableGroup |
Top
Relations
| Relation | Table | Lines |
|---|---|---|
| BarcodeSetup | BarcodeSetup | |
| BOMCalcTable | BOMCalcTable | |
| BOMTable | BOMTable | |
| CFOPTable_BR | CFOPTable_BR | |
| CommissionSalesGroup | CommissionSalesGroup | |
| Common | Common | |
| CompanyDataArea | DataArea | |
| CompanyLocation_IN | LogisticsLocation | |
| CountyOrigDest | LogisticsAddressCounty | |
| Currency | Currency | |
| CustomsTariffCodeTable_IN | CustomsTariffCodeTable_IN | |
| CustTable | CustTable | |
| dataAreaId | DataArea | |
| DefaultDimension | DimensionAttributeValueSet | |
| DeliveryPostalAddress_FK | LogisticsPostalAddress | |
| DlvMode | DlvMode | |
| DlvTerm | DlvTerm | |
| ExciseTariffCodes_IN | ExciseTariffCodes_IN | |
| IntrastatPort | IntrastatPort | |
| IntrastatStatProc | IntrastatStatProc | |
| IntrastatTransactionCode | IntrastatTransactionCode | |
| IntrastatTransportMode | IntrastatTransportMode | |
| InventDim | InventDim | |
| InventItemBarcode | InventItemBarcode | |
| InventSum | InventSum | |
| InventTable | InventTable | |
| InventTransOrigin | InventTransOrigin | |
| LedgerDimension | DimensionAttributeValueCombination | |
| MCROrderLine2PriceHistoryRef | MCROrderLine2PriceHistoryRef | |
| OffsetAssetTable | AssetTable | |
| OffsetBank | BankAccountTable | |
| OffsetCompanyDataArea | DataArea | |
| OffsetCustTable | CustTable | |
| OffsetLedgerDimension | DimensionAttributeValueCombination | |
| OffsetProject | ProjTable | |
| OffsetVendTable | VendTable | |
| PackingUnit | UnitOfMeasure | |
| Partition | Partitions | |
| PBATable | PBATable | |
| PriceDiscChangePolicyRecId1 | PriceDiscChangePolicy | |
| PriceDiscChangePolicyRecId2 | PriceDiscChangePolicy | |
| ProjCategoryCost | ProjCategory | |
| ProjCategoryFee | ProjCategory | |
| ProjCategoryHour | ProjCategory | |
| ProjCategoryItem | ProjCategory | |
| ProjectWorker | HcmWorker | |
| ProjLineProperty | ProjLineProperty | |
| PSAActivityEstimates | PSAActivityEstimates | |
| RetailVariantId | InventDimCombination | |
| RouteTable | RouteTable | |
| SalesCategory | EcoResCategory | |
| SalesQuotationTable | SalesQuotationTable | |
| SalesTaxFormTypes_IN | SalesTaxFormTypes_IN | |
| SalesUnit | UnitOfMeasure | |
| ServiceCodeTable_IN | ServiceCodeTable_IN | |
| smmActivities | smmActivities | |
| TaxGroupHeading | TaxGroupHeading | |
| TaxInventVATCommodityCode_IN | TaxInventVATCommodityCode_IN | |
| TaxItemGroupHeading | TaxItemGroupHeading | |
| TaxWithholdGroupHeadingTCS_IN | TaxWithholdGroupHeading | |
| TaxWithholdGroupHeadingTDS_IN | TaxWithholdGroupHeading |
Top
Indexes
| Index | AllowDuplicates | Enabled | Fields |
|---|---|---|---|
| CFOPTable_BRIdx | Yes | Yes | |
| CompanyLocation_INIdx | Yes | Yes | |
| CustomsTariffCodeTable_INIdx | Yes | Yes | |
| ExciseTariffCodes_INIdx | Yes | Yes | |
| ItemIdx | Yes | Yes | |
| ProjectWorkerIdx | Yes | Yes | |
| QuotationLineIdx | No | Yes | |
| QuotationTransTypeIdx | Yes | Yes | |
| RecId | No | Yes | |
| SalesTaxFormTypes_INIdx | Yes | Yes | |
| ServiceCodeTable_INIdx | Yes | Yes | |
| TransIdIdx | No | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
SalesQuotationLine Table