SalesTable Table

The SalesTable table contains all sales order headers regardless of whether they have been posted.

Configuration Key: LogisticsBasic

Methods

	Method	Description
	accountCustLedgerDimension
	agreementDocumentTitle_RU	Gets the document title of the related agreement.
	agreementHeaderExt_RU	Retrieves the record ID of the AgreementHeaderExt_RU that is attached to the current sales order.
	agreementIsLinked
	amountDelivered
	amountInvoiced
	amountMST
	amountOrderedNotInvoiced
	amountRemainSalesFinancial
	amountRemainSalesPhysical
	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.)
	calcDue_RU
	calcEstimateForced
	calculateTieredCharges	Creates tiered misc. charges for the sales order.
	canBeDirectlyInvoiced	Determines whether the sales order can be directly invoiced through the Process Shipment feature.
	cancelPreAuthorization
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	canCreditNoteBeCreated	Determines whether a credit note can be created for this sales order.
	canCreditNoteUseCreditCard	Determines whether the a credit card can be used with a credit note.
	canCustomerBeUpdated
	canDeliverySlipBeUpdatedBR	Indicates whether a sales order can create delivery slips.
	canSubmitToWorkflow	Indicates whether submission to workflow is possible. (Inherited from xRecord.)
	canXMLBeSent
	caption	Gets and sets the caption property of a table. (Inherited from xRecord.)
	checkAccount
	checkAgainstCreditLimit
	checkAgreement_RU	Validates the AgreementHeaderExt_RU field for sales order.
	checkAndUpdateAvailableDlvDates
	checkCashPayment
	checkContactPerson
	checkCreditCard
	checkCreditCardPaymentType
	checkCreditLimit
	checkCreditNoteReason	Checks the reason that a credit note is related to a SalesTable record.
	checkCreditNoteReasonServer
	checkCurrencyCode
	checkDelete
	checkDelivery
	checkIfUpdate	Determines whether the various posting updates are allowed for the order.
	checkIntrastatFulfillDate_HU	Validates Intrastat fulfillment date.
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	checkInventProfile_RU
	checkInvoiceAccount
	checkInvoicePostingType_RU
	checkMarkupTrans_RU
	checkPayment
	checkPaymMode	Checks whether the payment mode is valid.
	checkRecord	Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
	checkReservation
	checkRestrictedDeleteActions	Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
	checkUpdate
	clear	Removes all rows from the table buffer. (Inherited from xRecord.)
	clearAddressReference
	clearAllPriceDiscChangePolicies	Removes all the previously set price discount change policies for the corresponding SalesTable record.
	clearingLedgerDimension
	clearingPeriod
	company	Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
	companyInfo	Retrieves a CompanyInfo record that is 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.)
	contactPerson
	contactPersonName
	context	Gets and sets the context property. (Inherited from xRecord.)
	contributionMargin
	convertCurrencyCode
	copyAddressToLine
	copyDimension	Returns a dimension set that can be applied to the defaultDimension field on this table.
	copyPaymentSched
	copyRMALines	Copies the lines from a return order to a sales order.
	copyThirdPartyAddressFromCust	Copies address to the SalesTable buffer.
	copyThirdPartyBillingAddressToLine
	createCarrierInfoAndThirdPartyAddress	Initializes third-party shipping address and carrier information.
	createCustTrans_BR	Returns if the invoice will create customer transactions based on SalesPurchOperationTye_BR configuration.
	createDate	Retrieves the creation date of the current record.
	createInventTrans_BR	Returns if the invoice will create inventory transactions based on SalesPurchOperationTye_BR configuration.
	createMarkupTrans	Creates markups for the sales order.
	createOneTimeAccount
	createPaymentSched
	createReplacementOrderAllowed
	createReturnMarkupTrans
	creditCardAuthorizationCode	Returns the authorization code that came from the credit card processor.
	creditCardBypassCreditLimit
	creditCardDoPreAuthorize	Authorizes a credit card for a sales order.
	creditCardPreauthorizationAmount	Returns the preauthorization amount charged to the credit card.
	customerEmail
	customerName
	customerPhone
	custTable_CustAccount
	custTable_InvoiceAccount
	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 database.
	deliveryAddress
	deliveryAddressing
	deliveryCFOPTable_BR	Retrieves the delivery cfop code of the sales order.
	deliveryCNPJCPFNUM_BR	Returns the delivery CNPJ or CPF for the current record.
	deliveryDateDisplay
	deliveryIENum_BR	Returns the delivery IE for the current record.
	deliveryLocation
	deliveryPhone	Gets the telephone number that is associated with the delivery of a sales order.
	deliveryTransDateTime
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	dispLastConsDate_JP	Displays the latest consolidation date for this sales order.
	dispLastConsId_JP	Gets latest consolidation invoice Id for this purchase order.
	displayBankDocumentInfo	Sets the title on top of the preview pane on the BankLCExportListPage form.
	displayProformaAmountForBankLC	The display method to display the total proforma invoice amount of the sales order.
	dispose	Releases resources that are used by the xRecord object. (Inherited from xRecord.)
	dlvModeMandatory
	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.)
	editContactPersonName
	editCreditCard
	editExportSales_PL	Edits the export sales value for the sales order.
	editFixedExchRate
	editReasonCode	Gets and sets the reason code.
	editReasonCodeTH	Gets and sets the reason code.
	editReasonComment	Gets and sets the reason comment.
	equal	Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
	euroTriangulation
	evaluateAddTmsChargeToRetailOrder	Evaluates whether transportation charges can be added to the retail sales order based on the TMSDlvTerm setup.
	evaluateAddTmsChargeToSalesOrder	Evaluates whether transportation charges can be added to the sales order based on the TMSDlvTerm setup.
	exchRate
	exchRateSecondary
	existDirectDelivery
	existingJournals	Indicates whether the journals exist for a SalesTable record.
	existInterCompanyPurch
	existInterCompanySales
	existMarkedSettlement
	existNonCanceledLines
	existRegisteredReceivedInvoicedLines
	existSalesLine
	existShippedNotInvoiced
	factureJourSortedList_RU
	fieldAccessRight	Returns the field access right. (Inherited from xRecord.)
	fieldBufferAccessRight	Returns the field access right for the current record. (Inherited from xRecord.)
	fieldChanged
	fieldState	Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
	fixedEuroTriangulation
	fixedExchRate
	fixedExchRateSecondary
	getAllowRedefault	Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
	getCountryRegionIdByDocumentStatus
	getDefaultingDependencies	Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
	getDeliveryEntityRecord	Gets the delivery entity record 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.)
	getFinalDiscPriceDate	Calculates date for which total discount should be calculated according to the price date type setting.
	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.)
	getTotalLineAmount	Aggregates line amounts for all lines of the sales order.
	getTransationEntity_RU	Get entity of transaction.
	handle	Retrieves the handle of the class of the object. (Inherited from Object.)
	hasCODPaymentMethod	Indicates whether the payment method of the sales order is COD.
	hasIssueFiscalDocument_BR	Determines whether issues has fiscal documents.
	hasPriceDiscChangePolicy	Indicates whether price discount policies exist for a specified record.
	hasRelatedTable	Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
	helpField	Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
	icCheckUpdateHeaderDiscounts	Determines if prices and disounts can be updated in the context of intercompany.
	initBankAccounts_LV
	initDefaultReturnAddress
	initFromContactInfo
	initFromCustConfirmJour
	initFromCustInvoiceJour
	initFromCustPackingSlipJour
	initFromCustQuotationJour
	initFromCustTable
	initFromCustTableMandatoryFields
	initFromPayment
	initFromProjInvoiceJour
	initFromProjInvoiceTable
	initFromProjTable
	initFromSalesAgreementHeader	Initiates a SalesTable record with values that are based on SalesAgreementHeaderrecord.
	initFromSalesBasket
	initFromSalesQuotationTable	Initializes a record in the SalesTable table from a record in the SalesQuotationTabletable.
	initFromSalesTable
	initInvoiceAccount
	initReturnFromSalesTable
	initTaxDefaultsFromInvoiceAccount	Copies fiscal data fields from the invoice account.
	initValue
	initValue_Server
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert	Inserts the current record into the database.
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	interCompanyAllowIndirectCreationOrig
	interCompanyAllowIndirectCreationTxt
	interCompanyCheckCurrency
	interCompanyDirectDeliveryReturn	Sets the InterCompanyAutoCreateOrders and InterCompanyAllowIndirectCreate fieldsto the value of the InterCompanyDirectDelivery field.
	interCompanyEndpointActionPolicy	Gets the intercompany trading policy for the current SalesTable table record.
	interCompanyNonICExist
	interCompanyOriginalSalesInfo
	interCompanyOriginDisplay
	interCompanyPurchTable
	interCompanyReplacementRegistered
	interCompanyTradingValueMap	Gets the intercompany trading value mapping for the current SalesTable table record.
	interCompanyUpdateNow
	invoiceName
	isBankDocumentCreated	Checks if a bank document has been created for this order.
	isBankLCCreated	Checks if a bank LC has been created for this order.
	isBankLGCreated	Checks if a bank LG has been created for this order.
	isCancellingSalesReturn_BR	Verifies whether the sales order is for cancelling a sales return previously entered.
	isCreditCardPaymentType
	isCreditCheckEligible	Checks to see whether the current sales order type is eligible for the credit limit check.
	isCreditNote_CZ	Checks to see if any of the lines associated with the current header is a credit note.
	isCreditNote_PL	Checks to see if any of the lines associated with the current header is a credit note.
	isFieldDataRetrieved	Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
	isFieldSet	Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
	isFormDataSource	Indicates whether the data source is a form. (Inherited from xRecord.)
	isInterCompanyOrder
	isInterCompanyPOInvoiceMatched	Indicates whether a related intercompany purchase order was partially or fully invoiced.
	isMarkedForBankLC	Indicates whether the sales order is marked for Letter of Credit.
	isMarkedForBankLG	Indicates whether the sales order is marked for Letter of Guarantee.
	isNewRecord	Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
	isOnlineOrder
	isPartOfUOWSaveChanges	(Inherited from xRecord.)
	isRetailSale	Indicates whether the SalesTable record is a Retail sales record
	isRetailStatement_BR	Indicates whether the SalesTable record is originated from a Retail statement
	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.)
	jumpRefIntercompanyOriginalSalesOrder	Serves as the jump reference for the original sales order that relates to the sales order.
	jumpRefIntercompanyPurchaseOrder	Serves as the jump reference for the intercompany purchase order that relates to the sales order.
	jumpRefReturnItemNum
	lastConfirm
	lastConfirmDate
	lastFacture_RU
	lastFactureNumDate_RU
	lastInvoice	Returns the document number of the last invoice posted for this sales order.
	lastInvoice4Paym_RU
	lastInvoice4PaymDate_RU
	lastInvoiceDate
	lastJournals
	lastPackingSlip
	lastPackingSlipDate
	lastPickingList
	lastPickingListDate
	lastQuotation
	lastQuotationDate
	lineMapping	Retrieves the table ID of the table considered the line table in the current header-line relationship.
	lineNumForCreditNote	Gets the line number of the sales credit note line.
	linkPhysicalTableInstance	Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
	markupAllowed
	mayBankDocumentTypeBeBankLCExport	Checks whether the Bank document type can be set to the types of Bank LC Export.
	mayBankDocumentTypeBeBankLG	Indicates whether the Bank document type can be set to the types of Bank LG.
	mayConfirmationBeUpdated
	mayInvoice4PaymBeUpdated_RU
	mayInvoiceBeUpdated
	mayPackingSlipBeUpdated
	mayPickingListBeRegistered
	mayPickingListBeUpdated
	mayProjectPackingSlipBeUpdated
	mcrAllowOpenOrder	Determines if the sales order is allowed to remain in the open order status.
	mcrAllowStatusRollback	Validates if the sales order status can be rolled back or not.
	mcrAnySalesLinesNegative	Checks if any SalesLine records have a negative quantity.
	mcrApplyPostageDisc	Calculates and applies any postage discounts to the postage of an order.
	mcrCheckShipComplete	Determines whether the sales order should be shipped as a whole
	mcrCreateExchangeHeader	Creates an exchange sales order.
	mcrDeliveryInfo	Gets the customer's default delivery address.
	mcrDisplayCustCreditMax	Displays the maximum credit allowed for the specified customer.
	mcrDisplayDeliveryName	Displays the delivery name from the SalesTable unless the order lines ship to a different address.
	mcrDisplayLastShipDate	Displays the last date something was shipped on the order.
	mcrDisplayMiscChargesTotal	Displays the total amount of miscellaneous charges.
	mcrDisplayOnHold	Displays the image for a held order.
	mcrDisplayOrderNotes	Collects all of the order notes into one string and display them.
	mcrDisplayOrderTotal	Displays the total amount of the sales order.
	mcrDisplayOrderTotalLessTax	Gets the order total less tax.
	mcrDisplayOverallOldestOverUnderpaidDate	Gets the oldest order payment created date that is over the customers credit limit.
	mcrDisplayOverallTotalOrders	Gets the number of orders in the MCRCustPaymTable that are over the customers credit limit.
	mcrDisplayPhone	Displays the phone contact information of the customer on the sales order.
	mcrDisplayProductTotal	Displays the total amount of the product.
	mcrDisplayTaxTotal	Displays the total tax amount for the sales order.
	mcrDisplayTender	Returns the tender type being used to pay for the order.
	mcrDisplayTotalDisc	Displays the total ending discount amount for the sales order.
	mcrDlvModeModified	Defaults the MCRExpedite flag based on the delivery mode.
	mcrEvalSalesOrderType	Evaluates the sales order type.
	mcrExistNonOnAccountPaym	Validates whether payments with types other than on account exist for the sales order.
	mcrExistOpenReturn	Determines whether an open return order exists for this sales order.
	mcrFraudHold	Validates whether the order has a fraud hold or not.
	mcrGetDeclinedCCAuthRecords	Builds a query to gather a list of declined credit card authorization records attached to this sales order's payment records.
	mcrGetDeliveryAddresses	Builds a query which will get all the unique delivery addresses used on all SalesLine records on this order.
	mcrGetNumExpeditedLines	Gets the count of expedited lines on this sales order.
	mcrGetPaymStatus	Calculates and returns the overall payment status for the sales order.
	mcrGetTotalPaymAmount	Calculates and returns the sum of payment amounts for this sales order.
	mcrHasExpeditedLines	Indicates whether the order has one or more SalesLine records marked as expedited.
	mcrHasMultipleCCPayments	Gets the number of credit card payments associated with this order.
	mcrHasReturn	Determines whether the sales order has a return order associated with it.
	mcrHasShipped	Checks if any part of the order has shipped.
	mcrHasTender	Determines if one or more payments using the specified tender are associated with this sales order.
	mcrInterCompanyAutoCreateOrders	Generates intercompany orders.
	mcrInterCompanyOrigSalesId	Finds the corresponding SalesId for the intercompany direct delivery sales order transaction based on the current sales order.
	mcrIsCallCenter	Returns whether the sales order is associated with a call center or not.
	mcrIsContParentOrderBillUpFront	Checks whether or not the continuity parent order is bill up front.
	mcrIsOrderFullyReturned	Validates whether or not all invoiced quantity on the order has been returned.
	mcrIsOrderInFuture	Validates the future order processing dates.
	mcrIsOrderInstallment	Validates whether or not this order has an installment plan.
	mcrIsOrderOnFraudHold	Validates whether or not the order is on fraud hold.
	mcrLineHasDifferentAddress	Checks for a different delivery address on the order lines.
	mcrLineHasNonBillAddress	Checks the order line delivery addresses against the sold-to address on the customer.
	mcrOpenSalesOrder	Updates that sales status to be that of an open order.
	mcrOrderProcessed	Determines if the current order has been processed.
	mcrOrderReleaseDate	Gets the date on which a future order will be released.
	mcrPackMCRReturnSalesTable	Packs the retail return sales table extension table into MCRReturnSalesTable field.
	mcrPackMCRSalesTable	Packs the retail sales table extension table into MCRSalesTable field.
	mcrPackMCRSalesTableShipping	Packs the retail sales table shipping extension table into MCRSalesTableShipping field.
	mcrReturnSalesTable	Recovers the retail return sales table record.
	mcrSalesManualFraudHold	Puts a sales order on manual fraud hold.
	mcrSalesOrderDetailedStatus	Displays the order sales status.
	mcrSalesTable	Recovers the retail sales table record.
	mcrSalesTableExchange	Gets the SalesTable record marked as an exchange for this record.
	mcrSalesTableOriginal	Gets the original SalesTable record associated with this records.
	mcrSalesTableShipping	Recovers the retail sales table shipping record.
	mcrShowNotes	Shows the existing notes field and allows editing.
	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 defaultDimensionfield on this table and the provided dimension set.
	modifiedField
	modifiedFieldDDC	Processes the modified field event for delivery date control fields.
	modifiedFieldValue	Modifies the specified field to the original value. (Inherited from xRecord.)
	modifiedInterCompanyOrder
	modifiedInventSiteFromParent
	modifiedOneTimeCustomer
	modifiedProjId
	moduleType
	mustBeCovPlanned
	mustDoCreditLimitAfterUpdate
	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.)
	numberOfLines
	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.)
	packingSlipTotal
	packRetailSalesTable	Packs Retail extension table into PackedExtensions field
	packSalesTable_BR	Packs brazilian extension table into PackedExtensions field
	packSalesTable_Intrastat	Packs SalesTable_Intrastat extension table record.
	packSalesTable_RU	Packs an SalesTable_RU record to the container field PackedExtensions.
	packSalesTable_W	Packs an SalesTable_W record to the container field PackedExtensions.
	partyTable_CustAccount
	payer
	payerPostalAddress
	paymDayId
	payment
	paymModeModified
	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.)
	previewPaneTitle	Sets the title on top of the preview pane.
	previewPaneTitleReturnItemNum	Sets the title on top of the preview pane.
	priceDiscChangePolicyExistOnLine	Indicates whether a line record related to the current record has a price discount policy.
	priceDiscChangePolicyUpdateLine	Updates the price discount policy fields on a set of purchase line records related to the current SalesTable record.
	projectedFreightCharge
	projTable
	qualityOrderStatusDisplay	Returns the status of the associated quality orders.
	querySalesLine
	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.)
	referencePurchTable	Gets a reference purchase table record.
	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.)
	resetLinePolicies	Resets price discount policies on the lines that are related to the current record.
	retailConcessionContractId	Gets the Retail concession contract Id
	retailPackRetailSalesTable	Packs the retail sales table extension table into RetailSalesTable field.
	retailSalesTable	Unpacks Retail extension table from PackedExtensions field
	returnChangeStatus	Changes the return status.
	returnCreateReplacement	Checks whether a replacement order can be created for the sales table that is in scope.
	returnExistReturnToCustLines	Determines if Return to cust lines exist for the sales order.
	returnItem	Indicates if the current item is the return item.
	returnReservationAllowedIsSet
	returnValidateDeleteReplaceId	Launches a dialog box that asks for confirmation of deletion of the specified return order in case a replacement order exists.
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	salesTable_BR	Recovers brazilian extension table
	salesTable_Intrastat	Retrieves SalesTable_Intrastat extension table record.
	salesTable_RU	Gets extension table record for current base table record.
	salesTable_W	Gets extension table record for current base table record.
	salesTableExtensionTH	Get the SalesTableExtensionTH table.
	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.)
	sendReturnOrderElectronically
	setAgreement_RU	Initializes sales order from the agreement.
	setConnection	Sets the user connection for this table. (Inherited from xRecord.)
	setCrossPartition	Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
	setDeliveryName	Sets the delivery name field that is based on a specified logistic location.
	setEstimate
	setFieldValue	Sets the field value in the record buffer. (Inherited from xRecord.)
	setInventSiteId
	setListCode
	setLocation	Sets the delivery address information and related information.
	setNameUsingVATNum
	setPriceDiscChangePolicy	Sets the price disc change policy.
	setPriceDiscChangePolicyMultiLine	Calls the setPriceDiscChangePolicy method with fixed price discount change parameters for the multiline discount fields.
	setPriceDiscSystemChangePolicy	Determines the policy source for selected system sources.
	setReturnAddressFromInventLocationId
	setReturnAddressFromInventSiteId
	setShipCarrierFromLogisticsLocation	Sets the ship carrier data both on the header and the line level, depending on the LogisticsLocation data.
	setShipCarrierInformation
	setSQLTracing	Enables or disables SQL tracing mode. (Inherited from xRecord.)
	setTaxGroup
	setTimeOut	Sets up the scheduled execution of a specified method. (Inherited from Object.)
	settleExchRate
	setTmp	Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
	setTmpData	Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
	setXDSContext	Sets new XDS context. (Inherited from xRecord.)
	shipCarrierLocation	Gets the record ID of the record in the LogisticsLocationRecId table that is associated with the selected ship carrier postal address.
	shipCarrierThirdPartyName
	showContactPerson
	showDocHanIcon
	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.)
	smmAmountDeliveredMST
	smmAmountInvoicedMST
	smmAmountOrderedNotInvoicedMST
	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.)
	taxModuleType
	timeZoneSite
	tmsDisplayExpressBOL	Displays the Customer's express bill of lading.
	tmsDisplayRoute	Displays the Route associated with the Sales order, if applicable.
	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.)
	totalWeightAndVolume	Calculates total weight and volume aggregated over all sales order lines.
	tpAddress
	transferCustAccount
	transferCustAccount_Server
	transferInvoiceAccount
	transferTaxDefaultsFromInvoiceAcc
	transferToOnetimeCustomer	Updates the related one time customer entity based on the sales order.
	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
	unlinkAgreement
	unlinkAgreementPrompt
	update	Updates the current record in the database.
	updateBackStatus
	updateDeadline
	updateDeadlineOnLine
	updateDocumentStatus
	updateFinalDisc
	updateLedgerCov
	updateLineFieldsBasedOnHeaderChanges_BR	It is responsible for updating the SalesLine when fiscal information on header is changed
	updateLineReasonCode	Updates the reason code for the sales lines of a sales order.
	updateLineReasonComment	Updates the reason code comments for the sales lines of a sales order.
	updateMultiLineDisc
	updateSalesLineDelete	Makes deletion-related updates to records in the SalesTable table.
	updateSalesType
	updateServiceCode_BR	Updates lines service code values
	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	Determines whether the _fieldId field is valid.
	validateFieldServer	Validates a changed field on the server side.
	validateFieldValue	(Inherited from xRecord.)
	validateWrite	Determines whether the current record is valid and ready to be written to the database.
	validateWriteServer
	validTimeStateUpdateMode	Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
	voidCreditCardPreauthorize	Voids the credit card pre-authorization for a sales order.
	wait	Pauses a process. (Inherited from Object.)
	wasCached	Specifies the location from which the data was retrieved. (Inherited from xRecord.)
	whsCheckSalesLineDeliveryPostalAddress	Validates the sales lines postal addresses for current sales order.
	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.)
	::changeReturnStatus
	::checkCustomsExportOrder_IN	Checks whether in SalesTable table exist record wiht CustomsExportOrder_IN equal yes.
	::checkExist	Indicates whether the specified record exists in the SalesTable table and displays a message if the record does not exist.
	::createSalesTable_Replacement	Creates a sales order replacement.
	::custOpenOrders
	::deleteAllLines
	::exist
	::existCustOpenOrder
	::existDlvModeNotInvoiced	Determines whether the delivery mode is used on a non-invoiced sales order.
	::existsRegQrRecInvLines
	::find
	::findByBankLG	Finds a record that is linked to a specified record in the BankLGGuarantee table.
	::findOrCreateSalesTable_ItemReq
	::findRecId
	::findReturnItemNum
	::findSalesIdLocationSalesType	Finds a SalesTable record, depending on the specified sales ID, location, and sales type.
	::findSalesIdSalesType	Finds a SalesTable record, depending on the specified sales ID and sales type.
	::getExtFieldId_BR	Retrieves the extended field ID representation.
	::getFieldIdFromExt_BR	Retrieves the field ID from extended field ID representation.
	::getFulfillmentTypeAndRate	Returns the type and rate of fulfillment needed for autoReleaseToWarhouse to release an order.
	::getTableIdFromExt_BR	Retrieves the table ID from extended field ID representation.
	::initFromCustTableIL	Initializes a record in the SalesTable table from the customer account in the SalesTable table.
	::initFromCustTableServer	Executes the SalesTable::initFromCustTableIL method after transitioning to IL.
	::jumpRefSalesIdReturnTable	Opens the sales return order form by using jump reference.
	::lookupCustomsExportOrder_IN	Provides filtered lookup functionality for the CustomsExportOrder_IN field.
	::lookupDispositionCodeId	Provides filtered lookup functionality for the DispositionCodeId field.
	::lookupDispositionCodeIdNonStocked	Provides filtered lookup functionality for the DispositionCodeId field for non-stocked items.
	::lookupWMSReception
	::lookupWMSReceptionRMA	Provides filtered look up functionality to the ReturnItemNum field.
	::mcrCalcPostingProfile	Determines and sets the posting profile of the passed in sales order.
	::mcrContinuityLineEvalResult	Gets the enumeration to indicate what type of continuity order is being dealt with.
	::mcrEvalContOrderLines	Loops through all sales lines associated with this sales order and returns a container with the number if lines that are bill up fronts with no payment schedules, bill up front with payment schedules, or regular items.
	::mcrExistCustSalesOrder	Determines whether an order exists for the passed customer.
	::mcrFindRefundChecksNotApprovedOrDeclined	Finds refund checks that have not been approved or declined.
	::mcrFindReturnByExchId	Finds the returns sales order based on the passed in exchange order SalesId.
	::mcrFindSource	Finds a sales order containing the passed MCRSourceID.
	::mcrGetOldestOutOfBalanceDate	Gets the oldest sales order that is over or under paid.
	::mcrInsertFraudHold
	::mcrIsOrderContinuityParent	Determines if the SalesTable record, found by the passed sales ID, is a continuity order parent.
	::mcrJumpRef	Passes records to the SalesTable menu function based on the passed record and string.
	::mcrlookupByInvoiceAccountInvoiceId	looks up all sales orders that have the passed customer invoice account and are related to the customer invoice journal with the passed invoice ID.
	::mcrlookupInWarehouseOrders	Looks up sales orders that are no picked or in warehouse status.
	::mcrUnReserveOrderLines	Un-reserves all of the sales order lines for the SalesId passed.
	::mcrUpdateContinuityPayments	Updates the continuity payment records when the invoice account is modified.
	::mcrUpdateSalesStatus	Updates the status and order stopped flag of the passed SalesTable record.
	::mcrUserName	Gets the user name based on the UserId.
	::meetsFulfilmentRate	Checks whether the Sales Order is fulfilled or not.
	::promptConvertCurrencyCode
	::promptCopyDeliveryAddress
	::promptCopyThirdPartyBillingAddress
	::returnUpdatedHeaderStatus
	::returnUpdateReplacement
	::returnValidateReturnItemNum	Validates the input to the return order field.
	::setSalesOrderReleasedStatus	Sets the released status for a sales order.
	::shipCarrierPostPickup
	::txtNotExist
	::updateDlvModeFromCarrierService	Updates delivery mode on sales order and optionally on related sales lines.

Top

Fields

Field	Type	Configuration key	Description
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.
AutoSummaryModuleType	Enumeration: ModuleCustSales	None	Module, Accounts receivable or Sales orders
BankAccount_LV	Extended Data Type: CompanyBankAccountId Type: String	Bank	Select the primary bank account of the legal entity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
BankCentralBankPurposeCode	Extended Data Type: BankCentralBankPurposeCode Type: String	LedgerBasic	Code used when reporting to the central bank.
BankCentralBankPurposeText	Extended Data Type: BankCentralBankPurposeText Type: String	LedgerBasic	Describe code used when reporting to the central bank.
BankDocumentType	Extended Data Type: BankDocumentFacilityNature Type: Enum	BankDocument	Select the bank document type to be used with this sales order.
CaseTagging	Extended Data Type: RFIDCaseTagging Type: Enum	RFIDTagging	Is case tagging mandatory?
CashDisc	Extended Data Type: CustCashDiscCode Type: String	LedgerBasic	Code for cash discount on invoice.
CashDiscBaseDate	Extended Data Type: CashDiscBaseDate Type: Date	LedgerBasic	The date that is used for calculating discount dates and due dates (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))
CashDiscBaseDays	Extended Data Type: CashDiscBaseDays Type: Integer	LedgerBasic	The number of days that will be added to the document date when calculating discounts and due dates (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))
CashDiscPercent	Extended Data Type: DiscPct Type: Real	None	Discount in percentage.
CommissionGroup	Extended Data Type: CommissCustomerGroup Type: String	Commission	Identification of the commission customer group
ConsTarget_JP	Extended Data Type: CustConsTarget_JP Type: Enum	LedgerBasic	This check box indicates whether the invoice for this sales order will be consolidated later. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ContactPersonId	Extended Data Type: ContactPersonId Type: String	None	Contact with customer.
CountyOrigDest	Extended Data Type: AddressCountyOrigDest Type: String	None	Intrastat county of origin/destination.
CovStatus	Extended Data Type: CovStatus Type: Integer	LedgerAdvCashflowForecast	Status of cash flow forecast for the current transaction.
createdBy	Extended Data Type: CreatedBy Type: String	None
createdDateTime	Extended Data Type: CreatedDateTime Type: UtcDateTime	None
createdTransactionId	Extended Data Type: CreatedTransactionId Type: Int64	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CreditCardApprovalAmount	Extended Data Type: AmountMST Type: Real	CreditCard	Amount sent for approval to the payment service
CreditCardAuthorization	Extended Data Type: CreditCardAuthorization Type: String	CreditCard	Authorization code that was returned from the payment service
CreditCardAuthorizationError	Extended Data Type: NoYesId Type: Enum	CreditCard	Yes, if there is a credit card capture error for this sales order
CreditCardCustRefId	Extended Data Type: RefRecId Type: Int64	CreditCard	Reference code received from the payment service
CreditNoteReasonCode	Extended Data Type: ReasonTableRefRecId Type: Int64	None	Contains stored financial reason codes and comments for entered or posted transactions or actions. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CurBankAccount_LV	Extended Data Type: CompanyBankAccountId Type: String	Bank	Select the bank account number for the currency used in the invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CurrencyCode	Extended Data Type: CustCurrencyCode Type: String	None	Currency used for invoicing
CustAccount	Extended Data Type: CustAccount Type: String	None	Customer account that generated the order.
CustBankAccount_LV	Extended Data Type: CustBankAccountId Type: String	Bank	Select the identifier of the customer's bank account (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CustGroup	Extended Data Type: CustGroupId Type: String	LedgerBasic	Customer group that order/customer is attached to.
CustInvoiceId	Extended Data Type: CustInvoiceId Type: String	LedgerBasic	Identification of the invoice.
CustomerRef	Extended Data Type: CustRef Type: String	LedgerBasic	Customer's reference
CustomsExportOrder_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))
CustomsShippingBill_IN	Extended Data Type: NoYesId Type: Enum	None	The shipping bill number. (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
DAXIntegrationID	Extended Data Type: ConnIntegrationKey Type: Guid	None	The integration key for Dynamics Connector (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Deadline	Extended Data Type: SalesDeadline Type: Date	LogisticsBasic	Last date for acceptance of the order
DefaultDimension	Extended Data Type: DimensionDefault Type: Int64	LedgerBasic	Default dimensions
dEL_CreatedTime	Extended Data Type: DEL_CreatedTime Type: Integer	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
dEL_ModifiedTime	Extended Data Type: DEL_ModifiedTime Type: Integer	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
DeliveryDate	Extended Data Type: SalesShippingDate Type: Date	LogisticsBasic	Confirmed ship date if exists, otherwise requested ship date
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	None	Reference field in a different table
DirectDebitMandate	Extended Data Type: CustDirectDebitMandateRecId Type: Int64	None	Select the direct debit mandate reference of the recipient (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
DiscPercent	Extended Data Type: SalesEndDiscPct Type: Real	PriceDisc	Total discount on the sales order, in rounded percentage
DlvMode	Extended Data Type: CustDlvModeId Type: String	None	Specify mode of delivery for the current order.
DlvReason	Extended Data Type: DlvReasonId Type: String	None	Specify reason of delivery for the current order.
DlvTerm	Extended Data Type: CustDlvTermId Type: String	None	Specify terms of delivery for the current order.
DocumentStatus	Enumeration: DocumentStatus	None	Description of the current document type.
EInvoiceAccountCode	Extended Data Type: EInvoiceAccountCode Type: String	None	When settling to a public sector organization it is possible to specify a dimension account code.
EInvoiceLineSpec	Extended Data Type: EInvoiceLineSpecific Type: Enum	None	Specify the dimension account code for settlement to the public sector organization on line level.
Email	Extended Data Type: Email Type: String	None	Internet e-mail address
EndDisc	Extended Data Type: CustEndDiscCode Type: String	PriceDisc	Specifies total order discount group of customer/order.
EnterpriseNumber	Extended Data Type: TaxEnterpriseNumber Type: String	None	Enterprise number used to identify Belgian companies.
Estimate	Extended Data Type: SalesEstimateGross Type: Real	LedgerBasic	The amount in the transaction currency
ExportReason	Extended Data Type: SalesExportReason Type: String	SalesShipments	Explanation of why the goods are being exported
FiscalDocType_PL	Enumeration: PlFiscalDocType	None	Specifies whether an invoice or a bill is printed for the customer (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
FixedDueDate	Extended Data Type: SalesFixedDueDate Type: Date	LogisticsBasic	Due date independent of terms of payment.
FixedExchRate	Extended Data Type: SalesFixedExchRate Type: Real	LogisticsBasic	Fixed exchange rate for this order. If the rate field is blank, the rate of the currency code is used.
FreightSlipType	Extended Data Type: CustFreightSlipType Type: Enum	ReturnItem	Freight company
FreightZone	Extended Data Type: CustFreightZoneId Type: String	None	The UPS zone for the customer
GiroType	Extended Data Type: PaymentStubInvoiceId Type: Enum	CustGiro	Print associated payment attachment for customer invoice?
InclTax	Extended Data Type: InclTax Type: Enum	LogisticsBasic	Do prices include sales tax?
InterCompanyAllowIndirectCreation	Extended Data Type: InterCompanyAllowIndirectCreation Type: Enum	TradeInterCompany	Allow indirect order line creation when the original sales order is a direct delivery.
InterCompanyAllowIndirectCreationOrig	Extended Data Type: InterCompanyAllowIndirectCreation Type: Enum	TradeInterCompany	Allow indirect order line creation when the original sales order is a direct delivery.
InterCompanyAutoCreateOrders	Extended Data Type: InterCompanyAutoCreateOrders Type: Enum	TradeInterCompany	Autocreate intercompany orders when you leave the sales order.
InterCompanyCompanyId	Extended Data Type: InterCompanyCompanyId Type: String	TradeInterCompany	Identification of intercompany company accounts.
InterCompanyDirectDelivery	Extended Data Type: InterCompanyDirectDelivery Type: Enum	TradeInterCompany	Deliver directly to the customer and synchronize the delivery information to the intercompany orders.
InterCompanyDirectDeliveryOrig	Extended Data Type: InterCompanyDirectDelivery Type: Enum	TradeInterCompany	Deliver directly to the customer and synchronize the delivery information to the intercompany orders.
InterCompanyOrder	Extended Data Type: InterCompanyCustomer Type: Enum	TradeInterCompany	Indicate that this an intercompany organization
InterCompanyOrigin	Enumeration: InterCompanyOrigin	TradeInterCompany	States whether the line was created manually (Source), or indirectly as part of an intercompany chain (Derived)
InterCompanyOriginalCustAccount	Extended Data Type: InterCompanyOriginalCustAccount Type: String	LogisticsBasic	The customer account number on the original sales order
InterCompanyOriginalSalesId	Extended Data Type: InterCompanyOriginalSalesId Type: String	LogisticsBasic	The original sales order from which the intercompany purchase/intercompany sales was created
InterCompanyPurchId	Extended Data Type: InterCompanyPurchId Type: String	TradeInterCompany	Identification of the intercompany purchase order.
IntrastatAddValue_LV	Extended Data Type: LvIntrastatAddValue Type: Real	ForeignTrade	The additional value to be distributed equally among the lines to calculate the statistical value (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
IntrastatFulfillmentDate_HU	Extended Data Type: IntrastatFulfillmentDate_HU Type: Date	ForeignTrade	Date of Intrastat fulfillment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventLocationId	Extended Data Type: SalesInventLocationId Type: String	LogisticsBasic	Identify the warehouse.
InventSiteId	Extended Data Type: InventSiteId Type: String	LogisticsBasic	Identify the site
InvoiceAccount	Extended Data Type: CustInvoiceAccount Type: String	None	The customer account to be invoiced
InvoiceRegister_LT	Extended Data Type: LtInvoiceAutoNumbering Type: Enum	None	Use the auto numbering. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ItemTagging	Extended Data Type: RFIDItemTagging Type: Enum	RFIDTagging	Is item tagging mandatory?
LanguageId	Extended Data Type: CustLanguageId Type: String	LedgerBasic	Language used in item names and for printing external journals
LineDisc	Extended Data Type: CustLineDiscCode Type: String	PriceDisc	Specify the line discount group of the customer/order.
Listcode	Extended Data Type: ListcodeId Type: Enum	ForeignTrade	List code to be used with the EU sales list.
ManualEntryChangepolicy	Extended Data Type: PriceDiscPolicyManual Type: Int64	None	-
MarkupGroup	Extended Data Type: CustMarkupGroupId Type: String	Markup	Charges group attached to the order
MatchingAgreement	Extended Data Type: AgreementHeaderRecId Type: Int64	None	Reference to the agreement header record
MCROrderStopped	Extended Data Type: MCROrderStopped Type: Enum	None	Is the order locked? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
modifiedBy	Extended Data Type: ModifiedBy Type: String	None
modifiedDateTime	Extended Data Type: ModifiedDateTime Type: UtcDateTime	None
modifiedTransactionId	Extended Data Type: ModifiedTransactionId Type: Int64	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MultiLineDisc	Extended Data Type: CustMultiLineDiscCode Type: String	PriceDisc	Specifies multiline discount group of customer/sales order.
NatureOfAssessee_IN	Enumeration: NatureOfAssessee_IN	None	Nature of assessee. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
NumberSequenceGroup	Extended Data Type: NumberSequenceGroupId Type: String	None	Group for allocation of different number sequences to different customers/vendors.
OneTimeCustomer	Extended Data Type: OneTimeCustomer Type: Enum	LedgerBasic	A selected check box indicates that this is a one-time customer
PackingSlipRegister_LT	Extended Data Type: LtPackingSlipAutoNumbering Type: Enum	None	Use the auto numbering. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
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))
Payment	Extended Data Type: CustPaymTermId Type: String	LedgerBasic	Terms of invoice payment
PaymentSched	Extended Data Type: PaymSchedId Type: String	PaymSched	Payment schedule to be used when invoicing.
PaymMode	Extended Data Type: CustPaymMode Type: String	LedgerBasic	Identification of the customer method of payment.
PaymSpec	Extended Data Type: CustPaymSpec Type: String	LedgerBasic	Specify payment handling for the current method of payment.
PdsBatchAttribAutoRes	Extended Data Type: PdsBatchAttribAutoRes Type: Enum	PdsBatchAttrib	Consider batch attributes when processing auto reservation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsCustRebateGroupId	Extended Data Type: PdsCustRebateGroupId Type: String	PdsRebate	Group of customer for which a rebate is applicable. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PdsRebateProgramTMAGroup	Extended Data Type: PdsRebateProgramTMAGroup Type: String	PdsRebate	Customer TMA group ID. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
Port	Extended Data Type: IntrastatPortId Type: String	ForeignTrade	Port where current delivery is loaded.
PostingProfile	Extended Data Type: CustPostingProfile Type: String	None	Posting profile being processed.
PriceGroupId	Extended Data Type: CustPriceGroup Type: String	PriceDisc	Specifies customer/sales-order price group.
ProjId	Extended Data Type: ProjId Type: String	ProjBasic	Project identification
PurchId	Extended Data Type: PurchId Type: String	LogisticsBasic	Number of attached purchase
PurchOrderFormNum	Extended Data Type: CustPurchaseOrder Type: String	None	Customer requisition number
QuotationId	Extended Data Type: QuotationId Type: String	QuotationBasic	The quotation identifier
ReceiptDateConfirmed	Extended Data Type: SalesReceiptDateConfirmed Type: Date	SalesDeliveryDateControl	The selling company confirms that the customer will receive the order on this date.
ReceiptDateRequested	Extended Data Type: SalesReceiptDateRequested Type: Date	SalesDeliveryDateControl	The date that the customer asked to receive the order on
RecId	Extended Data Type: RecId Type: Int64	None
recVersion	Extended Data Type: RecVersion Type: Integer	None
ReleaseStatus	Enumeration: WHSReleaseStatus	WHSandTMS	The release status of the order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Reservation	Enumeration: ItemReservation	None	Reserve items automatically?
ReturnDeadline	Extended Data Type: ReturnDeadline Type: Date	ReturnItem	Date the return delivery must be received.
ReturnItemNum	Extended Data Type: SalesReturnItemNum Type: String	ReturnItem	Unique number issued to authorize the return.
ReturnReasonCodeId	Extended Data Type: ReturnReasonCodeId Type: String	ReturnItem	Customer reason for returning the item(s).
ReturnReplacementCreated	Extended Data Type: ReturnReplacementCreated Type: Enum	ReturnItem	Was replacement order created before receiving the returned items?
ReturnReplacementId	Extended Data Type: ReturnReplacementId Type: String	ReturnItem	Reference to the replacement order.
ReturnStatus	Enumeration: ReturnStatusHeader	ReturnItem	Status of the return order.
SalesGroup	Extended Data Type: CommissSalesGroup Type: String	Commission	Commission sales group
SalesId	Extended Data Type: SalesIdBase Type: String	LogisticsBasic	Identification of the order.
SalesName	Extended Data Type: SalesName Type: String	LogisticsBasic	Describe the order
SalesOriginId	Extended Data Type: SalesOriginId Type: String	LogisticsBasic	Code for order origin
SalesPoolId	Extended Data Type: SalesPoolId Type: String	LogisticsBasic	Identification of the sales order pool
SalesStatus	Enumeration: SalesStatus	LogisticsBasic	Order status as to delivery and invoicing
SalesType	Enumeration: SalesType	LogisticsBasic	Type of the current order
SalesUnitId	Extended Data Type: smmSalesUnitId Type: String	SmmSM	A team of sales persons responsible for a common sales target
SettleVoucher	Extended Data Type: SalesSettlementType Type: Enum	LogisticsBasic	Specify if voucher should be settled.
ShipCarrierAccount	Extended Data Type: ShipCarrierAccount Type: String	ShipCarrier	Account number that is invoiced by the carrier
ShipCarrierAccountCode	Extended Data Type: ShipCarrierAccountCode Type: String	ShipCarrier	Account code to identify the carrier account number that will be used to bill the company
ShipCarrierBlindShipment	Extended Data Type: ShipCarrierBlindShipment Type: Enum	ShipCarrier	If selected, the return address and logo are not printed on the packing slip or invoice
ShipCarrierDeliveryContact	Extended Data Type: Name Type: String	ShipCarrier	Contact at delivery destination
ShipCarrierDlvType	Enumeration: ShipCarrierDlvType	None	Service type
ShipCarrierExpeditedShipment	Extended Data Type: ShipCarrierExpeditedShipment Type: Enum	ShipCarrier	If selected, the shipment is expedited and free minimums will not be considered
ShipCarrierFuelSurcharge	Extended Data Type: ShipCarrierFuelSurcharge Type: Enum	ShipCarrier	If selected, a fuel surcharge will be added to the shipping charges
ShipCarrierId	Extended Data Type: ShipCarrierId Type: String	ShipCarrier	Identification of the carrier service, assigned by the shipping carrier
ShipCarrierName	Extended Data Type: LogisticsShipCarrierName Type: String	None	Name or company name of third-party address.
ShipCarrierPostalAddress	Extended Data Type: LogisticsPostalAddressRecId Type: Int64	None	Reference field in a different table
ShipCarrierResidential	Extended Data Type: ShipCarrierResidentialDest Type: Enum	ShipCarrier	Identifies ship via as "residential" to determine the remote delivery surcharge rate
ShippingDateConfirmed	Extended Data Type: SalesShippingDateConfirmed Type: Date	LogisticsBasic	The selling company confirms that the order will be shipped on this date.
ShippingDateRequested	Extended Data Type: SalesShippingDateRequested Type: Date	LogisticsBasic	The day the selling company should ship the item in order to meet the customer's requested receipt date.
smmCampaignId	Extended Data Type: smmCampaignId Type: String	SmmMA	The identification of the campaign
smmSalesAmountTotal	Extended Data Type: smmSalesAmountTotal Type: Real	SmmCRM	Total amount calculated for the sales order.
SourceDocumentHeader	Extended Data Type: RefRecId Type: Int64	None	Reference field in a different table
StatProcId	Extended Data Type: IntrastatProcId Type: String	ForeignTrade	Code for the current statistical procedure.
SystemEntryChangePolicy	Extended Data Type: PriceDiscPolicySystem Type: Int64	None	-
SystemEntrySource	Enumeration: PriceDiscSystemSource	None	-
TaxGroup	Extended Data Type: TaxGroup Type: String	LedgerBasicSalesTax	A group of sales tax codes for calculating taxes on a sale or purchase
TaxPeriodPaymentCode_PL	Extended Data Type: PlTaxPeriodPaymentCode Type: String	None	Enter a time period code for VAT transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
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.
Transport	Extended Data Type: IntrastatTransport Type: String	ForeignTrade	Specify means of transport for the current order.
TransportationDocument	Extended Data Type: TransportationDocumentRecId 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))
UnitedVATInvoice_LT	Extended Data Type: UnitedVATInvoice_LT Type: Enum	None	Flag indicating united VAT invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
URL	Extended Data Type: URL Type: String	None	WWW address for Internet homepage
VATNum	Extended Data Type: VATNumJournal Type: String	LedgerBasicSalesTax	Tax exempt identification number
WorkerSalesResponsible	Extended Data Type: WorkerSalesResponsible Type: Int64	None	Worker responsible for the sales order.
WorkerSalesTaker	Extended Data Type: SalesTaker Type: Int64	None	Worker who received the order.

Top

Field Groups

Field Group	Fields
WithholdingTax_IN
WebDelivery
Intercompany
InterCompanyAdmin
InterCompanyOriginal
Inventory
InterCompanyReturn
MCRReturn
NotificationToTheCentralBank
MCRWebConfirmation
MCRCCAuthorization
MCRDefaultClassification
Overview
Overview_RU
Payment
Posting
Quotation
Reservation
Project
Other
Return
ReturnItemNum
ReturnListPage
ReturnOrder
RFIDTagging
SummaryNumber
SummaryOrder
SalesTax
SalesAmountTotal
SalesOrderTable
Status
ReturnReplacement
SummaryUpdateShow
SummaryUpdate
Warehouse
WebCategoryBrowsing
SummaryUpdateParameters
Transport
WebCategoryBrowsingReturn
Agreement
AddressDisplay
AddressLookup
AccountsReceivable
AddressReference
Administration
CaseMoreInformation
Customs_IN
CustomsMisc_IN
DeliveryAddress
ConnIntegration
Delivery
BankAccounts_LV
CreditCard
ContactInfo
CaseMoreInformation_ReturnOrder
CurrencyShow
AutoSummary
Campaign
ConsTarget_JP
Currency
DeliveryAddition
CarrierInfo
AutoReport
CarrierIssues
Commission
Agreement_RU
CustInvoice
Customer
DiscountMiscCharges
ExternalReference
FiscalDocType_PL
EInvoice
Emails
ForeignTrade
EPMiniPage
GiroMoneyTransferSlip
DeliveryAddress_RU
DeliverySummary
Dimension
Discount
HeaderToLineUpdate
Identification

Top

Relations

Relation	Table	Lines
Agreement	AgreementHeader
BankAccount_LV	BankAccountTable
BankCentralBankPurpose	BankCentralBankPurpose
CashDisc	CashDisc
CommissionCustomerGroup	CommissionCustomerGroup
CommissionSalesGroup	CommissionSalesGroup
Common	Common
ContactPerson	ContactPerson
CountyOrigDest	LogisticsAddressCounty
CreditCard	CreditCardCust
CurBankAccount_LV	BankAccountTable
Currency	Currency
CustBankAccount_LV	CustBankAccount
CustDirectDebitMandate	CustDirectDebitMandate
CustGroup	CustGroup
CustInvoiceJour	CustInvoiceJour
CustLedger	CustLedger
CustLineDiscountGroup	PriceDiscGroup
CustMarkupGroup	MarkupGroup
CustMultiLineDiscountGroup	PriceDiscGroup
CustPaymModeSpec	CustPaymModeSpec
CustPaymModeTable	CustPaymModeTable
CustPriceGroup	PriceDiscGroup
CustTotalDiscountGroup	PriceDiscGroup
dataAreaId	DataArea
DefaultDimension	DimensionAttributeValueSet
DeliveryPostalAddress_FK	LogisticsPostalAddress
DlvMode	DlvMode
DlvReason	DlvReason
DlvTerm	DlvTerm
InterCompany	DataArea
IntrastatPort	IntrastatPort
IntrastatStatProc	IntrastatStatProc
IntrastatTransactionCode	IntrastatTransactionCode
IntrastatTransportMode	IntrastatTransportMode
InventLocation	InventLocation
InventSite	InventSite
InvoiceCustomer	CustTable
LanguageTable	LanguageTable
MarkupGroup	MarkupGroup
MCRHoldCodeTrans	MCRHoldCodeTrans
MCRInstallmentPlanSalesTable	MCRInstallmentPlanSalesTable
NumberSequenceGroup	NumberSequenceGroup
OrderCustomer	CustTable
Partition	Partitions
PaymSched	PaymSched
PaymTerm	PaymTerm
PdsCustRebateGroup	PdsCustRebateGroup
PdsRebateProgramTMATable	PdsRebateProgramTMATable
PlTaxDueTable	PlTaxDueTable
PriceDiscChangePolicyRecId1	PriceDiscChangePolicy
PriceDiscChangePolicyRecId2	PriceDiscChangePolicy
ProjTable	ProjTable
PurchTable	PurchTable
PurchTableInterCompany	PurchTable
ReasonTableRef	ReasonTableRef
ReturnItemNum	SalesTable
ReturnReasonCode	ReturnReasonCode
SalesId	SalesTable
SalesOrigin	SalesOrigin
SalesPool	SalesPool
SalesTable	SalesTable
ShipCarrierPostalAddress_FK	LogisticsPostalAddress
ShipCarrierTable	ShipCarrierTable
smmCampaignTable	smmCampaignTable
smmSalesUnit	smmSalesUnit
SourceDocumentHeader	SourceDocumentHeader
TaxGroupHeading	TaxGroupHeading
TaxServiceTariff	TaxServiceTariff
TaxWithholdGroupHeadingTCS_IN	TaxWithholdGroupHeading
TaxWithholdGroupHeadingTDS_IN	TaxWithholdGroupHeading
TransportationDocument	TransportationDocument
WorkerSalesResponsible_FK	HcmWorker
WorkerSalesTaker_FK	HcmWorker

Top

Indexes

Index	AllowDuplicates	Enabled	Fields
AgreementHeaderIdx	Yes	Yes
ConsTarget_JPIdx	Yes	Yes
CustCreatedDateIdx	Yes	Yes
CustIdx	No	Yes
InvoiceAccStatusIdx	Yes	Yes
ProjIdIdx	Yes	Yes
RecId	No	Yes
ReturnNumIdx	Yes	Yes
SalesIdx	No	Yes
SalesTypeIdx	Yes	Yes
SourceDocumentIdx	No	Yes
StatusCustAccIdx	Yes	Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    SalesTable Table

See Also

Table Methods

Tables Overview