RetailParameters Table
The RetailParameters table holds the retail headquarters parameters defined.
Configuration Key: RetailHeadquarters
Methods
| Method | Description | |
|---|---|---|
.gif "Public method") |
aosValidateDelete | Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.) |
|
aosValidateInsert | Validates on the server that the specified record can be inserted. (Inherited from xRecord.) |
|
aosValidateRead | Validates on the server that the specified record can be read. (Inherited from xRecord.) |
|
aosValidateUpdate | Validates on the server that the specified record can be updated. (Inherited from xRecord.) |
|
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) |
|
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
|
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) |
|
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) |
|
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) |
|
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) |
|
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) |
|
clear | Removes all rows from the table buffer. (Inherited from xRecord.) |
|
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) |
|
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) |
|
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) |
|
context | Gets and sets the context property. (Inherited from xRecord.) |
|
data | Retrieves a row from the table. (Inherited from xRecord.) |
|
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) |
|
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) |
|
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) |
|
delete | Deletes the current record from the table. (Inherited from xRecord.) |
|
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) |
|
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) |
|
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) |
|
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) |
|
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) |
|
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) |
|
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) |
|
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) |
|
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) |
|
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) |
|
fieldState | Sets or returns the state of a field in the table buffer. (Inherited from xRecord.) |
|
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) |
|
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) |
|
getExtension | Returns the table extension. (Inherited from xRecord.) |
|
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) |
|
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) |
|
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) |
|
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) |
|
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) |
|
getTableInInstanceHierarchy | (Inherited from xRecord.) |
|
getTableType | Indicates the type of the table. (Inherited from xRecord.) |
|
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
|
handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
|
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) |
|
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) |
|
initValue | Initializes field values in a new RetailParameters record. |
|
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
|
insert | Inserts the record into the table. (Inherited from xRecord.) |
|
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
|
isFieldDataRetrieved | Checks whether the data of the given field has been retrieved. (Inherited from xRecord.) |
|
isFieldSet | Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.) |
|
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) |
|
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) |
|
isPartOfUOWSaveChanges | (Inherited from xRecord.) |
|
isTempDb | Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.) |
|
isTmp | Indicates whether this is a temporary table. (Inherited from xRecord.) |
|
joinChild | Finds the join child of the current record. (Inherited from xRecord.) |
|
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) |
|
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) |
|
localStoreName | Displays the name of the OMOperatingUnit operating unit. |
|
merge | Merges the current table with the specified table. (Inherited from xRecord.) |
|
modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) |
|
modifiedFieldValue | Modifies the specified field to its original value. |
|
new | Initializes a new instance of the Object class. (Inherited from Object.) |
|
notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
|
notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
|
objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
|
orig | Retrieves the original values of the current record. (Inherited from xRecord.) |
|
overwriteSystemfields | Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.) |
|
owner | Returns the instance that owns the object. (Inherited from Object.) |
|
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) |
|
postLoad | Is executed after a record is read. (Inherited from xRecord.) |
|
preRemoting | Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.) |
|
queryTimedOut | Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.) |
|
queryTimeout | Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.) |
|
readCommittedLock | (Inherited from xRecord.) |
|
readPast | Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.) |
|
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) |
|
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) |
|
renamePrimaryKey | Calls the errorOnRename method of the RetailConnActionManagement class. |
|
reread | Rereads the record from the table. (Inherited from xRecord.) |
|
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) |
|
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) |
|
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) |
|
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) |
|
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) |
|
setConnection | Sets the user connection for this table. (Inherited from xRecord.) |
|
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) |
|
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) |
|
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) |
|
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
|
setTmp | Sets the table so that it is not persisted to the database. (Inherited from xRecord.) |
|
setTmpData | Sets the contents of the temporary table to the specified data. (Inherited from xRecord.) |
|
setXDSContext | Sets new XDS context. (Inherited from xRecord.) |
|
skipAosValidation | Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.) |
|
skipDatabaseLog | Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.) |
|
skipDataMethods | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) |
|
skipDeleteActions | Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.) |
|
skipDeleteMethod | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) |
|
skipEvents | Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.) |
|
skipPostLoad | Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.) |
|
skipTTSCheck | Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.) |
|
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) |
|
tableAccessRight | Returns the table access right. (Inherited from xRecord.) |
|
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) |
|
takeOwnershipOfTempDBTable | (Inherited from xRecord.) |
|
toolTipField | Retrieves the HelpText value for the specified field. (Inherited from xRecord.) |
|
toolTipRecord | Retrieves the ToolTip value for the current record. (Inherited from xRecord.) |
|
toString | Returns a string that represents the current object. (Inherited from Object.) |
|
ttsabort | Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) |
|
ttsbegin | Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.) |
|
ttscommit | Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) |
|
update | Updates the current record. (Inherited from xRecord.) |
|
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) |
|
useExistingTempDBTable | (Inherited from xRecord.) |
|
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.) |
|
validateField | Indicates whether the _fieldIdToCheck field is valid. |
|
validateFieldValue | (Inherited from xRecord.) |
|
validateItemSalesStatisticsOn | Indicates whether the sales statistics entries are changed. |
|
validatePasswordStrength | Validate the Password Strength based on the Retail POS Parameters value |
|
validatePasswordStrengthbyType | Validate password strength based on password type. |
|
validateWrite | Determines whether the current record is valid and ready to be written. (Inherited from xRecord.) |
|
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) |
|
wait | Pauses a process. (Inherited from Object.) |
|
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) |
|
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) |
|
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) |
.gif "Static member") |
::autoSettle | Sets the settlement type based on the transaction type. |
|
::find | Finds the specified record in the RetailParameters table. |
|
::findCrossCompany | Finds the specified record in the RetailParameters table. |
|
::isRetailEnabledAndInUse | Indicates whether retail configuration key is enabled and being used for the current LE. |
|
::isRetailInUse | Indicates whether retail functionality is being used for the current LE. |
|
::numberSeqModule | Gets the module that is currently assigned. |
|
::numRefAssemblyOrderName | Finds a number sequence reference for assembly order name. |
|
::numRefAssortmentId | Finds a number sequence reference for the assortment number. |
|
::numRefCreditVoucherId | Finds a number sequence reference for Credit voucher number. |
|
::numRefDiscountCode | Finds a number sequence reference for discount code. |
|
::numRefGiftCardId | Finds a number sequence reference for gift card number. |
|
::numRefInvoiceId | Finds a number sequence reference for Invoice number. |
|
::numRefLoyaltyAdjustmentId | Finds a number sequence reference for Retail loyalty adjustment ID. |
|
::numRefLoyaltyCardId | Finds a number sequence reference for Loyalty card number. |
|
::numRefLoyaltyCardNumber | Finds a number sequence reference for Retail loyalty card number. |
|
::numRefLoyaltyCustId | Finds a number sequence reference for Loyal customer numbers. |
|
::numRefMassUpdateWorksheetId | Finds a number sequence reference for Mass update work sheet. |
|
::numRefMixAndMatchId | Finds a number sequence reference for mix and match group. |
|
::numRefMultibuyDiscountId | Finds a number sequence reference for multibuy number. |
|
::numRefOfferId | Finds a number sequence reference for offer number. |
|
::numRefRetailReturnPolicyNumber | Finds a number sequence reference for Retail return policy number. |
|
::numRefSalesCreditNoteId | Finds a number sequence reference for credit note. |
|
::numRefSalesOrderId | Finds a number sequence reference for sales order number. |
|
::numRefStoreId | Finds a number sequence reference for store number. |
|
::numRefTerminalId | Finds a number sequence reference for Retail terminal Number. |
|
::numRefThresholdDiscountId | Finds a number sequence reference for Threshold discount. |
|
::numRefVariantId | Finds a number sequence reference for variant number. |
Top
Fields
| Field | Type | Configuration key | Description |
|---|---|---|---|
| AccountExportProfile | Extended Data Type: RetailSmbAccountExportProfileRecId Type: Int64 |
Retail | The profile that defines which accounts are to be exported. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AccountingExportFileName | Extended Data Type: Filename Type: String |
None | The prefix used when creating accounting export files. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AccountingExportFilePath | Extended Data Type: FilePath Type: String |
None | The folder where account export files will be created. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AccountingExportTransformFile | Extended Data Type: FilenameOpen Type: String |
None | The path to an XSLT file which will be applied to each account export file as it is created. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| aggregateBeforePosting | Extended Data Type: RetailRetailAggregateYesNo Type: Enum |
None | (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)) |
| AggregateCustPayments_RU | Enumeration: NoYes |
None | Post customer payments as a sum or as separate lines (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AggregateIncomeExpense_RU | Enumeration: NoYes |
None | Post income/expense amount as a sum or as separate lines (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AggregateSalesReturns_RU | Enumeration: NoYes |
None | Summarize sales and return transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AggregateTenderFlow_RU | Enumeration: NoYes |
None | Post added or removed amount as a sum or as separate lines (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AutomaticReturnOfLoyaltyPayment_RU | Extended Data Type: NoYesId Type: Enum |
None | Select this check box to automatically calculate the number of points to refund for a return transaction (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| autoSettle | Extended Data Type: RetailAutoSettle Type: Enum |
None | Automatic settlement of RBO sales (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)) |
| AwardPointsForPartialRedemption_RU | Extended Data Type: NoYesId Type: Enum |
None | Select this check box to award loyalty points for the remaining amount that is paid in cash when you redeem loyalty points (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| BuyersPushRespectAssortments | Enumeration: RetailReplenishmentRespectAssortments |
Retail | Indicates if and how assortments should be respected for replenishment (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)) |
| CancellationCharge | Extended Data Type: RetailCancellationCharge Type: Real |
Retail | Specify the amount of the charge for cancelling an order (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)) |
| CancellationChargeCode | Extended Data Type: MarkupCode Type: String |
Markup | Select the code for the cancellation charge to use for orders (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)) |
| CrossDockingRespectAssortments | Enumeration: RetailReplenishmentRespectAssortments |
Retail | Indicates if and how assortments should be respected for replenishment (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)) |
| dataAreaId | Extended Data Type: DataAreaId Type: String |
None | (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)) |
| defaultCustomerPosting | Extended Data Type: RetailDefaultCustomerPosting Type: Enum |
Retail | (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)) |
| DefaultCustPaymentJournalName_RU | Extended Data Type: LedgerJournalNameId Type: String |
LedgerBasic | The name of the journal that is used to post customer payments (except cash payments) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| defaultInventJournalName | Extended Data Type: JournalNameId Type: String |
None | Select the default inventory journal for stock counts (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)) |
| DefaultJournalName4CategoryPrice | Extended Data Type: PriceDiscJournalName Type: String |
PriceDisc | Identification of the journal name. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefaultLedgerJournalName_RU | Extended Data Type: LedgerJournalNameId Type: String |
LedgerBasic | The name of the journal that is used to post transactions other than customer payments (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefaultOrdertype | Enumeration: RetailCustomerOrderType |
Retail | Select the default order type for new customer orders (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)) |
| DefaultPriceType_IN | Enumeration: PriceType_IN |
None | Identification of the price type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| DefaultRCashJournalName | Extended Data Type: LedgerJournalNameId Type: String |
LedgerBasic | The name of the journal that is used to post customer cash payments (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefaultTransferType_IN | Enumeration: TransferType_IN |
None | Identification of the transfer type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| dEL_ModifiedTime | Extended Data Type: DEL_ModifiedTime Type: Integer |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| detailSummary | Extended Data Type: RetailStatmentDetailSummary Type: Enum |
Retail | Specify summation level (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)) |
| DiscountAccountLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (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)) |
| discountOfferActivityType | Extended Data Type: RetailInventItemActivityTypeId Type: String |
Retail | (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)) |
| EANLicenseNo | Extended Data Type: RetailEANLicenseNo Type: String |
None | (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)) |
| ElectronicDeliveryModeCode | Extended Data Type: DlvModeId Type: String |
None | The means by which the order will be delivered (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| EventNotificationProfileId | Extended Data Type: RetailEventNotificationProfileId Type: String |
None | The field identifies retail Email notification profile (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ExpirationDate | Extended Data Type: RetailExpirationDate Type: Integer |
Retail | Default number of days after which the sales quotation expires (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)) |
| GiftCardCompany | Extended Data Type: DataAreaId Type: String |
None | Gift card company (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| GiftcardItem | Extended Data Type: ItemId Type: String |
LogisticsBasic | Identify item. (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)) |
| GiftCardLedgerJournalName | Extended Data Type: LedgerJournalNameId Type: String |
LedgerBasic | Journal (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| GiftCardPrepaymentCustAccount_RU | Extended Data Type: CustAccount Type: String |
None | Customer account number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| GiftCardPrepaymentPostingProfile_RU | Extended Data Type: CustPostingProfile Type: String |
None | The customer posting profile that applies to the customer payment journal that is generated for an issued and paid gift card (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventLocationIdForInventory | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (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)) |
| InventLocationIdForPurchaseOrder | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (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)) |
| InventLocationIdForSalesOrder | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (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)) |
| ItemLabelLastAction | Extended Data Type: RetailLabelLastAction Type: String |
Retail | (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)) |
| ItemLabelsForNegativeStock | Extended Data Type: RetailItemLabelsForNegativeStock Type: Enum |
Retail | (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)) |
| itemSalesStatisticsOn | Enumeration: RetailNoneItemGroupDepartment |
Retail | (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)) |
| JournalNameForKitPricing | Extended Data Type: PriceDiscJournalName Type: String |
PriceDisc | The name of the journal that is used for creating trade agreements for kit variants. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| key | Extended Data Type: ParametersKey Type: Integer |
None | Unique identification (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)) |
| ledgerAccountType | Extended Data Type: RetailBookingLedgerAccountType Type: Enum |
Retail | "Standard Microsoft Dynamics AX ledger, periodic discount ledgers, no ledger" (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)) |
| maxSalesOrdersPerTask | Extended Data Type: RetailSalesOrdersPerTask Type: Integer |
Retail | Maximum sales orders is allowed in each batch task. (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)) |
| MCRGiftCardVoidJournalName | Extended Data Type: LedgerJournalNameId Type: String |
LedgerBasic | Journal name that will be used to create a general ledger record when a gift certificate is voided. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| MinimumDepositForSalesOrder | Extended Data Type: RetailCustomerOrderDeposit Type: Real |
None | Specify the minimum deposit required for sales orders (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)) |
| MinimumPasswordLength | Extended Data Type: RetailPOSPasswordLength Type: Integer |
Retail | The minimum number of characters that is required for the user password. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| mixAndMatchActivityType | Extended Data Type: RetailInventItemActivityTypeId Type: String |
Retail | (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)) |
| MixMatchLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (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)) |
| modifiedBy | Extended Data Type: ModifiedBy Type: String |
None | (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)) |
| modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | (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)) |
| multibuyActivityType | Extended Data Type: RetailInventItemActivityTypeId Type: String |
Retail | (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)) |
| MultiBuyLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (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)) |
| OfferLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (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)) |
| OverRideSystemLookup | Extended Data Type: RetailConnOverRideSystemLookup Type: Enum |
None | (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)) |
| parallelSOPosting | Enumeration: NoYes |
None | Allow parallel batch tasks during statement posting. (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)) |
| 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 | Code for the terms of payment (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| paymentStatistics | Enumeration: NoYes |
None | (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)) |
| PaymMode | Extended Data Type: CustPaymMode Type: String |
LedgerBasic | Identification of the customer method of payment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PickUpDeliveryModeCode | Extended Data Type: DlvModeId Type: String |
None | The means by which the order will be delivered (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| postBankedSum | Extended Data Type: RetailPostBankedSum Type: Enum |
Retail | Post banked amount as a sum or separate lines (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)) |
| postCustDisc | Extended Data Type: RetailPostCustDisc Type: Enum |
Retail | (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)) |
| PostFacture_RU | Enumeration: NoYes |
None | Post a facture automatically when a retail sales invoice is posted (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| postInfocodeDisc | Extended Data Type: RetailPostInfocodeDisc Type: Enum |
Retail | (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)) |
| postLineDisc | Extended Data Type: RetailPostLineDisc Type: Enum |
Retail | (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)) |
| postPeriodicDisc | Extended Data Type: RetailPostPeriodicDisc Type: Enum |
Retail | (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)) |
| PostSafeSum | Extended Data Type: RetailPostSafeSum Type: Enum |
Retail | Post safe amount as a sum or separate lines. (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)) |
| postSalesOrderWhenPaid | Extended Data Type: RetailPostSalesOrderWhenPaid Type: Enum |
Retail | Determines whether sales order is posted when it's paid (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)) |
| postTotalDisc | Extended Data Type: RetailPostTotalDisc Type: Enum |
Retail | (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)) |
| PrepaymentLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (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)) |
| PrePaymentLedgerJournalName | Extended Data Type: RetailPrePaymentLedgerJournalNameId Type: String |
LedgerBasic | Identification of the journal name. (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)) |
| ProcessGiftCardsAsPrepayments_RU | Extended Data Type: NoYesId Type: Enum |
None | Select this check-box to process Issue gift card and Add to gift card operations as customer prepayments. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ProcessReturnsAsInOriginalSaleShift_RU | Extended Data Type: NoYesId Type: Enum |
None | Process the return made in a later shift similar to processing a return made in the same shift (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ProposeRefundPaymentAmount_RU | Extended Data Type: NoYesId Type: Enum |
None | Select this check box to initialize the refund amounts based on the payment methods. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| receiptEmailFilename | Extended Data Type: RetailReceiptEmailFilename Type: String |
Retail | The file name of the receipt's email attachment (excluding the file extension) (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)) |
| receiptEmailSubject | Extended Data Type: RetailReceiptEmailSubject Type: String |
Retail | Text displayed in the subject of the receipt's email message (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)) |
| receiptEmailText | Extended Data Type: RetailReceiptEmailText Type: VarString |
Retail | Text displayed in the body of the receipt's email message (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)) |
| receiptOption | Extended Data Type: RetailReceiptOption Type: Enum |
Retail | Specifies the receipt options for POS customers (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)) |
| RecId | Extended Data Type: RecId Type: Int64 |
None | (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)) |
| recVersion | Extended Data Type: RecVersion Type: Integer |
None | (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)) |
| ReplenishmentAssortmentsCoverageDays | Extended Data Type: RetailReplAssortmentsCoverageDays Type: Integer |
Retail | Number of additional coverage days to add for replenishment date affectivity. (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)) |
| RequireNumericChar | Extended Data Type: RetailPOSParameterNumericChar Type: Enum |
Retail | Password requires numeric character (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| RequireSpecialChar | Extended Data Type: RetailPOSParameterSpecialChar Type: Enum |
Retail | Password requires special character (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| RequireUppercase | Extended Data Type: RetailPOSParameterUpperCase Type: Enum |
Retail | Password requires uppercase (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ReturnDispositionCodeId | Extended Data Type: ReturnDispositionCodeId Type: String |
ReturnItem | Identification of the disposition code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| ShelfLabelLastAction | Extended Data Type: RetailLabelLastAction Type: String |
Retail | (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)) |
| ShippingChargeCode | Extended Data Type: MarkupCode Type: String |
Markup | Select the code for the shipping charge to use for orders (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)) |
| staffStatistics | Enumeration: NoYes |
None | (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)) |
| systemInUse | Enumeration: NoYes |
None | Has the Retail module been initialized? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| terminalStatistics | Enumeration: NoYes |
None | (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)) |
| ThresholdLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| TotalDiscountLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Default main account used for posting in ledger (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)) |
| UseDefaultLedgerAccount | Extended Data Type: NoYesId Type: Enum |
None | (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)) |
| UseDefaultTradeDates_W | Enumeration: NoYes |
None | Use the posting date as the sales date for retail invoice transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| UseRetailReturnTaxGroup_W | Enumeration: NoYes |
None | Use the sales tax group that is specified for the customer for return transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Top
Field Groups
| Field Group | Fields |
|---|---|
| AccountingExport | |
| ActivityTypes | |
| Aggregation | |
| All | |
| CardPayments | |
| DefaultWarehouse | |
| AutoReport | |
| Booking | |
| ChargeCodes | |
| EventNotificationProfile | |
| Giftcard | |
| Loyalty_RU | |
| PasswordStrength | |
| Payment_RU | |
| ReplenishmentIndiaSpecial | |
| PeriodicDiscount | |
| RefundProcessing_RU | |
| ReceiptEmail | |
| ReplenishmentRespectAssortments | |
| ReturnInLaterShift_RU | |
| SalesOrders | |
| Settlement | |
| Statement |
Top
Relations
| Relation | Table | Lines |
|---|---|---|
| AccountingExportProfile | RetailSmbAccountExportProfile | |
| CustLedger_GiftCardPrepaymentProfile_RU | CustLedger | |
| CustPaymModeTable | CustPaymModeTable | |
| dataAreaId | DataArea | |
| DefaultCustPaymentJournalName_RU | LedgerJournalName | |
| DefaultIncomeExpenseJournalName_RU | LedgerJournalName | |
| DefaultRCashJournalName | LedgerJournalName | |
| DimensionAttributeValueCombination | DimensionAttributeValueCombination | |
| DimensionAttributeValueCombination1 | DimensionAttributeValueCombination | |
| DimensionAttributeValueCombination2 | DimensionAttributeValueCombination | |
| DimensionAttributeValueCombination3 | DimensionAttributeValueCombination | |
| DimensionAttributeValueCombination5 | DimensionAttributeValueCombination | |
| DimensionAttributeValueCombination6 | DimensionAttributeValueCombination | |
| DlvMode_Electronic | DlvMode | |
| DlvMode_PickUp | DlvMode | |
| GiftCardCompany | DataArea | |
| GiftCardJournalName | LedgerJournalName | |
| GiftCardPrepaymentCustAccount_RU | CustTable | |
| InventJournalName | InventJournalName | |
| InventLocation | InventLocation | |
| InventLocation1 | InventLocation | |
| InventLocation2 | InventLocation | |
| InventTable | InventTable | |
| LedgerJournalName | LedgerJournalName | |
| MarkUpTable_Cancellation | MarkupTable | |
| MarkupTable_Shipping | MarkupTable | |
| MCRLedgerJournalName | LedgerJournalName | |
| Partition | Partitions | |
| PaymTerm | PaymTerm | |
| PrepaymentDimensionAttrValueCombination | DimensionAttributeValueCombination | |
| PriceDiscAdmName | PriceDiscAdmName | |
| PriceDiscAdmName1 | PriceDiscAdmName | |
| RetailEventNotificationProfile | RetailEventNotificationProfile | |
| RetailInventItemActivityType | RetailInventItemActivityType | |
| RetailInventItemActivityType1 | RetailInventItemActivityType | |
| RetailInventItemActivityType2 | RetailInventItemActivityType | |
| ReturnDispositionCode | ReturnDispositionCode |
Top
Indexes
| Index | AllowDuplicates | Enabled | Fields |
|---|---|---|---|
| DimensionAttributeValueCombinationIdx | Yes | Yes | |
| DimensionAttributeValueCombinationIdx1 | Yes | Yes | |
| DimensionAttributeValueCombinationIdx2 | Yes | Yes | |
| DimensionAttributeValueCombinationIdx3 | Yes | Yes | |
| DimensionAttributeValueCombinationIdx5 | Yes | Yes | |
| DlvModeIdx | Yes | Yes | |
| keyIdx | No | Yes | |
| RecId | No | Yes | |
| ReturnDispositionCodeIdx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
RetailParameters Table