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. |
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