Compartilhar via


SalesParameters Table

The SalesParameters table contains setup data that is used by the sales order module.

Configuration Key: LogisticsBasic

Methods

  Method Description
Gg871617.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Indicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif clear Removes all rows from the table buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif defaultField Populates default values in a field in the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif defaultRow Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif delete Deletes the current record from the database.
Gg871617.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif doClear Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif doDelete Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif doInsert Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif doUpdate Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getPhysicalTableName Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif initValue Initializes field values in a new SalesParameters record.
Gg871617.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif insert Inserts the record into the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isNewRecord Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif mcrUnacceptableMargin Indicates the margin percent range that is considered unacceptable.
Gg871617.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif modifiedField
Gg871617.pubmethod(en-us,AX.60).gif modifiedFieldValue Modifies the specified field to the original value. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif postCacheLoad Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif postSplitSiteBR Indicates whether a packing slip posting should be split based on site.
Gg871617.pubmethod(en-us,AX.60).gif 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.)
Gg871617.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif queryTimeout Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif 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.)
Gg871617.pubmethod(en-us,AX.60).gif recommendedSpecQty
Gg871617.pubmethod(en-us,AX.60).gif recordLevelSecurity Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif reduceOnHand
Gg871617.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif renamePrimaryKey Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif selectForUpdate Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipAosValidation Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipDeleteActions Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipEvents Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif skipPostLoad Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif 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.)
Gg871617.pubmethod(en-us,AX.60).gif splitDeliveryInformation
Gg871617.pubmethod(en-us,AX.60).gif splitSite
Gg871617.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif ttsbegin Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif update Updates the current record in the database.
Gg871617.pubmethod(en-us,AX.60).gif usageCount Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif useBillOfLadingOnInvoice
Gg871617.pubmethod(en-us,AX.60).gif useBillOfLadingOnPackingSlip
Gg871617.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif useShippingStat
Gg871617.pubmethod(en-us,AX.60).gif useShippingStatOnInvoice
Gg871617.pubmethod(en-us,AX.60).gif useShippingStatOnPackingSlip
Gg871617.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif validateField Determines whether the _p1 field is valid.
Gg871617.pubmethod(en-us,AX.60).gif validateFieldValue (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written to the database.
Gg871617.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg871617.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif write Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::allowedNumSeqGroup
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::createNumberSeqGroupRef
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::exist
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::find
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::mcrLogisticsRegistrationEnabled Method to indicate the picking list registration parameter has changed.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::nameAndOrDescription
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numberSeqModule
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefConfirmId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefCustCorrectInvoiceId_M15_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefCustInvoiceId_M15_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefGoodsInRouteVoucher_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefInvoice4PaymId_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefInvoiceId Gets the number sequence for InvoiceId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefPackingSlipId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefPriceDiscJournalNum
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefPrintoutJournalNum_CustInvM15_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefPrintoutJourNum_CustCorrInvM15_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefQuotationConfirmId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefQuotationId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefQuotationIdBase
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefReturnItemNum
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesAgreementId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesCorrectCreditNoteId_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesCorrectCreditNoteVoucher_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesCorrectInvoiceId_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesCorrectInvoiceVoucher_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesCreditNoteId Gets the number sequence for SalesCreditNoteId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesCreditNoteVoucher
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesDebitNoteId Gets the number sequence for sales debit note Id.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesDebitNoteVoucher Gets the number sequence for sales debit note voucher.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesInvoiceVoucher
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesMarkupVoucher_RU
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesPackageVoucher Retrieves the number sequence reference for posting package deposits.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesPackingSlipCorrectionVoucher Retrieves the number sequence reference for the sales packing slip correction voucher.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesPackingSlipVoucher
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesQuotationId
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesRevisionInvoiceId_RU Number sequence reference for sales revision invoice id.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesTaxInvoiceId Gets the number sequence for sales tax invoice Id.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefSalesTaxInvoiceVoucher Gets the number sequence for sales tax invoice voucher.
Gg871617.pubmethod(en-us,AX.60).gifGg871617.static(en-us,AX.60).gif ::numRefShippingBillVoucher_IN Gets number reference of shipping bill voucher.

Top

Fields

Field Type Configuration key Description
AccesLevelInvoiced Enumeration: SalesPurchAccesLevel
None Specify the acceptable level for changes
AgreementPriceDisc_RU Extended Data Type: AgreementPriceDisc_RU
Type: Enum
TradeBlanketOrder Use price/discount per agreement. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ApplySmartRoundingAfterConversion Enumeration: NoYes
None Determines if smart rounding should be applied after currency conversion
ATPApplyDemandTimeFence Extended Data Type: SalesATPApplyDemandTimeFence
Type: Integer
SalesDeliveryDateControl Time period in days, going forward from today, when delayed demand orders are considered as issues. This applies only if the delivery date control is set to ATP or ATP + Issue margin.
ATPApplySupplyTimeFence Extended Data Type: SalesATPApplySupplyTimeFence
Type: Integer
SalesDeliveryDateControl Time period in days, going forward from today, when delayed supply orders are considered as receipts. This applies only if the delivery date control is set to ATP or ATP + Issue margin.
ATPBackwardDemandTimeFence Extended Data Type: SalesATPBackwardDemandTimeFence
Type: Integer
SalesDeliveryDateControl Time period in days, going backward from today, for considering delayed demand orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin.
ATPBackwardSupplyTimeFence Extended Data Type: SalesATPBackwardSupplyTimeFence
Type: Integer
SalesDeliveryDateControl Time period in days, going backward from today, for considering delayed supply orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin.
ATPInclPlannedOrders Extended Data Type: SalesATPInclPlannedOrders
Type: Enum
SalesDeliveryDateControl If selected, planned orders are included in the ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin.
ATPTimeFence Extended Data Type: SalesATPTimeFence
Type: Integer
SalesDeliveryDateControl Time period in days, going forward from today, for calculating ATP. This applies only if the delivery date control is set to ATP or ATP + Issue margin.
BillOfLading Extended Data Type: SalesShippingId
Type: Enum
SalesShipments Create bill of lading when dispatching the shipment?
BOLcarrierName Extended Data Type: WMSCarrierName
Type: String
SalesShipments Name of carrier.
BOLfreightChargeTerms Enumeration: WMSFreightChargeTerms
SalesShipments Who is to pay freight?
BOLfreightCounted Enumeration: WMSFreightCounted
SalesShipments Who counted the items?
BOLFreightedBy Enumeration: WMSFreightedBy
SalesShipments Who is doing the freighting?
BOLlanguageId Extended Data Type: LanguageId
Type: String
SalesShipments Select the language for the current text.
BOLtrailerLoaded Enumeration: WMSTrailerLoaded
SalesShipments Who loaded the items?
CancelSales Enumeration: NoYes
None When an order is deleted, it is marked as voided.
CreditNoteDateControl_HU Enumeration: DateControl
None Warning type if document date is later than invoice date with more than the pre-defined number of days. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CreditNoteDocumentDateControlType_W Enumeration: DateControlType_W
None Set up the document date control for posting credit notes (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CreditNoteInvoiceDateControlType_W Enumeration: DateControlType_W
None Set up the invoice date control for posting credit notes (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
CustQuotationTypeId Extended Data Type: SalesQuotationTypeId
Type: String
QuotationBasic Type of sale (first time)
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DateOfExchRate_W Enumeration: DateOfExchRate_W
None The date based on which the exchange rate is calculated (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))
DeleteHeading Enumeration: NoYes
None Delete order automatically upon complete invoicing?
DeleteLine Enumeration: NoYes
None Delete order lines automatically upon complete invoicing?
Delivery2Invoice Extended Data Type: Delivery2Invoice
Type: String
LedgerAdvCashflowForecast Specify code that indicates the period between delivery and invoicing.
DeliveryDateControlType Enumeration: SalesDeliveryDateControlType
SalesDeliveryDateControl Select for automatic calculation of possible ship and receipt dates.
DeliveryDateUpdateInLines Enumeration: DeliveryDateUpdateInLines
SalesDeliveryDateControl The default value for update delivery dates in lines prompt. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Disc Extended Data Type: SalesLineMultiLn
Type: Enum
PriceDisc Determines total discount if both line and multiline discount are allocated.
DocumentDateControl_HU Enumeration: DateControl
None Warning type if document date differs from system date. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DocumentDateControlType_W Enumeration: DateControlType_W
None Set up the document date control for posting invoices (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
DomesticSalesTaxGroup_PL Extended Data Type: PlSalesDomesticTaxGroup
Type: String
LedgerBasicSalesTax Tax group used when lack of SAD document. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
EmplPhoneTypeId Enumeration: LogisticsElectronicAddressMethodType
None The method of communication used to contact employees (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
EPSalesOriginId Extended Data Type: SalesOriginId
Type: String
LogisticsBasic The origin of sales orders entered through the Enterprise Portal
ExchangeRateType Extended Data Type: ExchangeRateTypeRecId
Type: Int64
None The identification of the exchange rate type
FiscalItemPrintCode_PL Enumeration: PlFiscalItemPrintCode
None Select a printer code for the fiscal document (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
GenericCurrency Extended Data Type: CurrencyCode
Type: String
None Current currency code
InventBaileeSearchPriority_RU Enumeration: InventBaileeSearchPriority_RU
LogisticsBasic Matching priority of storage cost calculation item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventProfileId_RU Extended Data Type: InventProfileId_RU
Type: String
InventTrackingGTDProfileOwner Inventory profile. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventProfileSplitLines_RU Extended Data Type: InventProfileSplitLines_RU
Type: Enum
InventTrackingGTDProfileOwner Split automatically sales order lines by inventory profiles. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InventProfileUseRelated_RU Extended Data Type: InventProfileUseRelated_RU
Type: Enum
InventTrackingGTDProfileOwner Allow to use inventory profiles in order lines compatible with the inventory profile specified in the order? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InvoiceDateControl_HU Enumeration: DateControl
None Warning type if document date is later than invoice date with more than the pre-defined number of days. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InvoiceDateControlType_W Enumeration: DateControlType_W
None Set up the invoice date for posting invoices (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
InvoicePostingType_RU Enumeration: SalesInvoicePostingType_RU
LedgerBasic Default customer invoice posting type. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
IsMatchingAgreementSearchEnabled Extended Data Type: AgreementSearchEnabled
Type: Enum
TradeBlanketOrder Is automatic search for matching agreements enabled when new orders are created
Key Extended Data Type: ParametersKey
Type: Integer
None Unique identification
LeadTimeSalesDefault Extended Data Type: LeadTimeSalesDefault
Type: Integer
LogisticsBasic Default lead time or lead time in number of days
LineDiscCalculation_PL Enumeration: PlLineDiscCalcType
None Changes in sales will affect changes in purchase module. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
MarkupHeading Extended Data Type: MarkupHeading
Type: Enum
Markup Allocate main charges automatically for the order?
MarkupLine Extended Data Type: MarkupLine
Type: Enum
Markup Allocate line charges automatically for the order?
MCRAcceptableSalesMargin Extended Data Type: MCRAcceptableSalesMargin
Type: Real
TradeMarginAlert Sales trade acceptable margin percentage alert. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRAllowOutOfBalance Enumeration: NoYes
MCRCallCenter Allows orders that are underpaid or overpaid to be processed. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRCheckHoldNumberOfDays Extended Data Type: MCRCheckHoldNumberOfDays
Type: Integer
MCRCallCenter The number of days that a sales order will be placed on hold if there is a check on the order which exceeds the check hold threshold amount. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRCheckHoldThresholdAmt Extended Data Type: MCRCheckHoldThresholdAmt
Type: Real
MCRCallCenter If a check exceeds this amount, the payment will be placed on check hold until released. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRCopyNotes Enumeration: NoYes
LogisticsBasic Copy notes from customer and items to the sales order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRDefQuoteConvHoldCode Extended Data Type: MCRHoldCode
Type: String
MCRCallCenter Hold code assigned to quotes when an error occurs during conversion. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCREnableMarginAlert Extended Data Type: MCREnableMarginAlert
Type: Enum
TradeMarginAlert Enable the call center directed selling process including order scripts, catalog request, and additional item information. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRHoldCodeNoteType Extended Data Type: MCRHoldCodeNoteType
Type: String
LogisticsBasic Enter the type of note that should default when entering a hold code comment. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRHoldOrderDisplayColor Extended Data Type: MCRHoldOrderDisplayColor
Type: Integer
LogisticsBasic This is the background color for held orders on the sales order forms. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCROverpaidReviewThreshold Extended Data Type: AmountCur
Type: Real
MCRCallCenter The over-payment amount at which a company wants an order to be reviewed. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCROverUnderPaymentPrompt Enumeration: NoYes
MCRCallCenter Prompts the user to not allow out of balance sales orders to be processed. Otherwise payments will always be processed. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRPickStagingUseReservation Enumeration: NoYes
MCRCallCenter Utilizes reservation with pick staging. Reservation will not work if items are set up with location active but not set for physical inventory. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRPromptForItemList Enumeration: NoYes
LogisticsBasic Indicates the user should be prompted with available item lists to copy from when entering a sales order. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRQuestionableSalesMargin Extended Data Type: MCRQuestionableSalesMargin
Type: Real
TradeMarginAlert Sales trade questionable margin percentage alert. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRResourceNum_Acceptable Extended Data Type: MCRResourceNum
Type: Integer
TradeMarginAlert Alert image for acceptable margin (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRResourceNum_Questionable Extended Data Type: MCRResourceNum
Type: Integer
TradeMarginAlert Alert image for questionable margin (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRResourceNum_Unacceptable Extended Data Type: MCRResourceNum
Type: Integer
TradeMarginAlert Alert image for unacceptable margin (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
MCRUnderpaidReviewThreshold Extended Data Type: AmountCur
Type: Real
MCRCallCenter The under-payment amount at which a company wants an order to be reviewed. (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
NumberOfDays_HU Extended Data Type: NumberOfDays
Type: Integer
None The number of days that are used for invoice date control and credit note date control. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
OrderBatchTaskSize Extended Data Type: FormletterBatchTaskSize
Type: Integer
LogisticsBasic The maximum number of documents to be processed in parallel in each batch task in the batch job
OrderEntryStatistics Enumeration: NoYes
None Activate order entry statistics.
OrderType Enumeration: SalesType
LogisticsBasic Type that an order must be created with automatically.
OverDelivery Extended Data Type: SalesOverDelivery
Type: Enum
LogisticsOverUnderDelivery Activate overdelivery
PackingSlipByInvent_PL Extended Data Type: NoYesId
Type: Enum
None Individual delivery note numbering for every location. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (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))
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))
PickinglistDefaultLanguage Extended Data Type: PickinglistDefaultLanguage
Type: Enum
LogisticsBasic Use the default language code from the company information when printing the picking list.
PickRouteStatusOnUpdate Enumeration: WMSPickRouteStatusOnUpdate
None Status of the picking route after posting.
PostExciseInLedger_PL Enumeration: NoYes
None Do you want the excise tax to be posted on separate account? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PostPackingSlip Extended Data Type: SalesPostPackingSlip
Type: Enum
LogisticsBasic Post packing slips in ledger?
PrePrintLevelShippingLabel Extended Data Type: SalesShippingReportType
Type: Enum
SalesShipments Specify paper format for the current report.
PriceDateType Enumeration: SalesPriceDateType
LogisticsBasic Specifies the date for which price will be calculated.
PromptQty Enumeration: NoYes
None Recommend a value for quantity field when posting documents
PromptTransfer Enumeration: NoYes
None Prompt for transfer of customer and invoice details?
QuotationNumOfDaysExpiryDate Extended Data Type: SalesQuotationNumOfDays
Type: Integer
QuotationBasic Day of year
QuotationNumOfDaysFollowUpDate Extended Data Type: SalesQuotationNumOfDays
Type: Integer
QuotationBasic Day of year
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
ReduceInvoice Enumeration: NoYes
None Reduce lines automatically during invoice update?
ReducePackingSlip Enumeration: NoYes
None Reduce the lines automatically during packing slip update?
ReducePickingList Enumeration: NoYes
None Automatically reduce line quantity during picking list update if on-hand quantity is insufficient.
Reservation Enumeration: ItemReservation
None Specify a default value for reservation
ReturnPeriodOfValidity Extended Data Type: ReturnPeriodOfValidity
Type: Integer
ReturnItem Number of days a customer RMA will be valid. This will calculate the Estimation date of arrival of items as system date plus period of validity.
SalesOriginId Extended Data Type: SalesOriginId
Type: String
LogisticsBasic Specify default value of order origin.
SalesPoolId Extended Data Type: SalesPoolId
Type: String
LogisticsBasic Specify default value for sales order pool.
SettleVoucher Extended Data Type: SalesSettlementType
Type: Enum
LogisticsBasic Specify which settlement is made, when a credit note is created
ShippingStat Extended Data Type: SalesShippingId
Type: Enum
SalesShipments When is the specification of the shipping statistics to be entered?
SplitDeliveryConfirmation Extended Data Type: TradeSplitDeliveryAddress
Type: Enum
TradeMultiShipTo Create one journal for each delivery address.
SplitDeliveryInvoice Extended Data Type: TradeSplitDeliveryAddress
Type: Enum
TradeMultiShipTo Create one journal for each delivery address.
SplitDeliveryPackingSlip Extended Data Type: TradeSplitDeliveryAddress
Type: Enum
TradeMultiShipTo Create one journal for each delivery address.
SplitDeliveryPickingList Extended Data Type: TradeSplitDeliveryAddress
Type: Enum
TradeMultiShipTo Create one journal for each delivery address.
SplitInventOwnerIdInvoice_RU Enumeration: NoYes
None Create one journal for each value of inventory dimension owner. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SplitInventProfileTypePackingSlip_RU Enumeration: NoYes
None Create separate journal for each kind of activity. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SplitInvoiceByServiceCode_BR Extended Data Type: TaxSplitServiceCode_BR
Type: Enum
None Create a journal for each service code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SplitPostingProfilePackingSlip_RU Enumeration: NoYes
None Create separate journal for each posting profile. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SplitSiteInvoice Extended Data Type: TradeSplitSite
Type: Enum
LogisticsBasic Create one journal for each site
SplitSitePackingSlip Extended Data Type: TradeSplitSite
Type: Enum
LogisticsBasic Create one journal for each site
SplitSitePickingList Extended Data Type: TradeSplitSite
Type: Enum
LogisticsBasic Create one journal for each site
StructDepartment_RU Extended Data Type: StructDepartment_RU
Type: String
LedgerBasic Organization department for Russian invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SubDelivery Extended Data Type: SalesUnderDelivery
Type: Enum
LogisticsOverUnderDelivery Activate underdelivery
SummaryErrorTolerance Enumeration: ErrorTolerance
None How should the application respond in case of discrepancy between the orders to be summary updated?
SummaryUpdateBy Enumeration: AccountOrder
None Default value of summary updates when several orders are to be posted at the same time.
TaxWithholdCalculate_BR Extended Data Type: TaxWithholdCalculate_TH
Type: Enum
None Shall withholding tax be calculated for vendor payment transactions in journals? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxWithholdCalculateCrossCompany_BR Extended Data Type: TaxWithholdCalculateCrossCompany_BR
Type: Enum
None Withholding tax accumulated base amount will sum payments among all companies of Centralized Payment (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxWithholdCompany_BR Extended Data Type: SelectableDataArea
Type: String
None ID for the company you can select (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TransportationDocumentOnPackingSlip Extended Data Type: NoYesId
Type: Enum
None Check to enable the transportation document table on the Post packing slip form.
TransportInvoiceType_RU Enumeration: TransportInvoiceType_RU
None Type of transportation document according to Rules of cargo transportation by means of motor transport. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
UseSettleExchRate Enumeration: NoYes
None Use the exchange rate from the designated transactions when posting the sales order? All exchange rates for the designated transactions must be identical.
ValidDays Extended Data Type: SalesValidDays
Type: Integer
LogisticsBasic Number of days a sales order is valid

Top

Field Groups

Field Group Fields
SplitDeliveryInformation
SalesQuotation
ShipmentLayout
SalesParameters
SplitInventProfileType_RU
SplitInventOwnerId_RU
SplitPostingProfile_RU
TransportationDocument
TaxWithholding_BR
UpdateOfShipments
SplitServiceCode_BR
SummaryUpdate
Updates
Agreements
AgreementPriceDisc_RU
AutoReport
DefaultValues
FiscalDoc_PL
InventBailee_RU
Excise_PL
ConfirmationLayout
Batch
CreditNoteDateControl_W
DateControl
GenericCurrencyAndSmartRounding
BillOfLading
CashflowForecast
DeliveryControl
InventProfile_RU
InvoiceDateControl_W
InvoiceLayout
Invoice
MCRAll
MCRItemList
Prices
PrintGroup
Posting
PaperFormat
MCRSalesOrderTransfer
PackingSlip
PickingList
PickingListLayout
PackingSlipLayout
QuotationLayout
RMA

Top

Relations

Relation Table Lines
BillOfLadingLanguageTable LanguageTable
BillOfLadingSalesCarrier SalesCarrier
dataAreaId DataArea
DefaultSalesOrigin SalesOrigin
DefaultSalesPool SalesPool
DeliveryToInvoicePaymTerm PaymTerm
DomesticSalesTaxGroup TaxGroupHeading
EPDefaultSalesOrigin SalesOrigin
ExchangeRateType ExchangeRateType
GenericCurrency Currency
InventProfile_RU InventProfile_RU
MCRDefQuoteConvHoldCode MCRHoldCodeTable
MCRHoldCodeNoteType DocuType
Partition Partitions
SalesQuotationTypeGroup SalesQuotationTypeGroup
TaxWithholdCompany_BR DataArea

Top

Indexes

Index AllowDuplicates Enabled Fields
Key No Yes
RecId No Yes
TaxGroupHeadingIdx Yes Yes

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    SalesParameters Table

See Also

Table Methods

Tables Overview