Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The VendParameters table contains the setup information for accounts payable.
Configuration Key: LedgerBasic
Methods
Method | Description | |
---|---|---|
![]() |
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 database. |
![]() |
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.) |
![]() |
editUseInvoiceMatching | Gets or sets the status of the Use enumeration type of invoice matching for the current company. |
![]() |
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 VendParameters 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.) |
![]() |
isPurchAgreementAccountStructureValid | Validates the value of the PurchAgreementAccountStructure_PSN field in the VendParameters table. |
![]() |
isPurchAgreementFinancialDimensionValid | Validates the value of the PurchAgreementFinancialDimension_PSN field in the VendParameters table. |
![]() |
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.) |
![]() |
merge | Merges the current table with the specified table. (Inherited from xRecord.) |
![]() |
modifiedField | Performs a specific task based on the field modified. |
![]() |
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) |
![]() |
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 | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) |
![]() |
reread | Rereads the record from the table. (Inherited from xRecord.) |
![]() |
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) |
![]() |
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 in the database. |
![]() |
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) |
![]() |
useExistingTempDBTable | (Inherited from xRecord.) |
![]() |
useExtendedPriceMatching | Calculates and returns the status of the UseExtendedPriceMatching value for the current company. |
![]() |
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. |
![]() |
validateField | Determines whether the specified field is valid. |
![]() |
validateFieldValue | (Inherited from xRecord.) |
![]() |
validateMatchingPolicy | Checks whether the matching policy field can be changed. |
![]() |
validateMatchingPolicyAllowOverride | Checks whether the matching policy enable override field can be changed. |
![]() |
validateWrite | Determines whether the current record is valid and ready to be written to the database. |
![]() |
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.) |
![]() ![]() |
::canVatProcessGroupByBeModified_RU | |
![]() ![]() |
::cashDiscAmount | |
![]() ![]() |
::cashDiscAmount_IN | Gets the cash discount amount for given parameters. |
![]() ![]() |
::cashDiscDate | |
![]() ![]() |
::checkDocumentDate | Validates invoice document date. |
![]() ![]() |
::exist | |
![]() ![]() |
::find | |
![]() ![]() |
::getDefaultInternalInvoiceGroup | Determines what the internal default group value should be based on the parameters defined in the VendParameters table. |
![]() ![]() |
::mcrNumRefBrokerClaimInvoice | Gets broker claim invoice reference. |
![]() ![]() |
::mcrNumRefRoyalty | Creates the sequence number for royalties. |
![]() ![]() |
::mcrNumRefRoyaltyClaim | Creates sequence number for royaltie claims. |
![]() ![]() |
::mcrNumRefRoyaltyVendInvoiceId | Creates sequence number for vendor invoice. |
![]() ![]() |
::numberSeqModule | |
![]() ![]() |
::numRefInventBaileeReceiptReportId_RU | |
![]() ![]() |
::numRefOneTimeSupplierAccount | |
![]() ![]() |
::numRefOverdueCITPITJournalId_W | Gets the number sequence for the vendor overdue debt CIT and PIT journal. |
![]() ![]() |
::numRefOverdueVATJournalId_W | Gets the number sequence for the vendor overdue debt VAT journal. |
![]() ![]() |
::numRefOverdueVATVoucher_W | Gets the number sequence for voucher used for posting the vendor overdue debt VAT journal. |
![]() ![]() |
::numRefProductReceiptFinalizationVoucher | Gets the number sequence for product receipt finalization voucher. |
![]() ![]() |
::numRefPurchBookId_RU | |
![]() ![]() |
::numRefPurchBookVATProcessVoucherId_RU | |
![]() ![]() |
::numRefRTax25DebtCreditVoucher | |
![]() ![]() |
::numRefTax1099Num | |
![]() ![]() |
::numRefTaxWithholdPND3Number | Gets the number sequence for withholding tax certification number for PND 3. |
![]() ![]() |
::numRefTaxWithholdPND53Number | Gets the number sequence for withholding tax certification number for PND 53. |
![]() ![]() |
::numRefVendAccount | |
![]() ![]() |
::numRefVendAdvanceInvoiceId_CZ | |
![]() ![]() |
::numRefVendAmountDiffFactureId_RU | |
![]() ![]() |
::numRefVendCloseVoucher | |
![]() ![]() |
::numRefVendConsId_JP | Gets the number sequence for Vend Consolidation Invoice. |
![]() ![]() |
::numRefVendDirectiveId | Finds a number sequence reference for the VendDirectiveId_PSN extended data type. |
![]() ![]() |
::numRefVendExchAdjVoucher | |
![]() ![]() |
::numRefVendExternalInvoice_RU | |
![]() ![]() |
::numRefVendFactureId_RU | |
![]() ![]() |
::numRefVendInternalInvoiceNum | Finds the number sequence reference for vendor internal invoice. |
![]() ![]() |
::numRefVendInvoice4PaymId_RU | |
![]() ![]() |
::numRefVendPaymentVoucher | |
![]() ![]() |
::numRefVendPromissoryNoteID | |
![]() ![]() |
::numRefVendRoutingSlipId | Finds a number sequence reference for the VendRoutingSlipId_PSN extended data type. |
![]() ![]() |
::numRefVendUnrealizedRevId | Gets the number sequence for Vendor reversal journal. |
![]() ![]() |
::validateVendInvoiceGroupsCanBeDisabled | Validates whether the AP Invoice Grouping feature can be disabled based on the existing invoices. |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
AccountDisc | Enumeration: ItemVend |
LogisticsBasic | Should posting of discount primarily follow vendor or item? |
AccountReceipt | Enumeration: ItemVend |
LogisticsBasic | Should receipt transactions primarily follow vendor or item? |
AdvancePostingProfile | Extended Data Type: VendPostingProfile Type: String |
None | Posting profile used when the invoice is marked as a prepayment |
AgreementCreditLine_RU | Extended Data Type: AgreementCreditLimit_RU Type: Enum |
TradeBlanketOrder | Check credit limit per agreement? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AmountDiffBookCorrection_RU | Enumeration: NoYes |
None | Include amount difference in additional list for previous period of purchase book. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AssetPaymentAllocation_RU | Enumeration: RAssetPaymentAllocation |
RAsset | Specify FA payment allocation method in Purch Book. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
AutoSettle | Extended Data Type: AutoSettle Type: Enum |
None | Settle automatically when posting journal? |
BudgetSettle | Extended Data Type: LedgerAllocateKeyId Type: String |
None | Allocation key used for budget reduction as regards purchase level |
CashDisc | Enumeration: UnspecificSpecific |
None | Should use of calculated cash discount be 'unspecific' or 'specific'? |
CashDiscForCreditNote | Extended Data Type: CashDiscForCreditNote Type: Enum |
None | Calculate discounts if a credit note has payment terms |
CashDiscForPartialPaym | Extended Data Type: CashDiscForPartialPaym Type: Enum |
None | Allow discounts to be calculated if an invoice is only partially paid |
CashDiscVAT | Extended Data Type: VendCashDiscVat Type: Enum |
LedgerBasic | Cash discount is calculated on invoice amount incl. sales tax (that is plus sales tax). |
CheckInvoice | Extended Data Type: VendReuseInvoice Type: Enum |
LedgerBasic | Should duplicate invoice numbers per supplier be checked for? |
CheckTaxInvoice | Extended Data Type: VendReuseTaxInvoice Type: Enum |
TaxThailandGovCertification | Should duplicate tax invoice numbers per supplier be checked for? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ClearingLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerAdvCashflowForecast | Liquidity account for settling payments |
ConfirmingInvoices | Enumeration: NoYes |
None | Invoice field will be taken into account for grouping transactions and treatment of confirming. |
CopyInvoiceDimension_RU | Enumeration: NoYes |
None | Copy financial dimensions from invoice to payment when using payment proposal. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CreateFactureUnpostPrepayment_RU | Extended Data Type: NoYesId Type: Enum |
LedgerBasicSalesTax | Create factures on nonposted payments in postponed mode. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
CreditError | Extended Data Type: VendCreditError Type: Enum |
LedgerBasic | Consider vendor credit note as correction to invoice? |
CreditInvoicingReport | Enumeration: NoYes |
None | Shows to the user the information about the credit invoicing feature in the vendor invoice report. |
CreditMaxCheck | Extended Data Type: VendCreditMaxCheck Type: Enum |
LedgerBasic | Apply what level of credit limit control when invoicing? |
CreditNoteSettlementType | Extended Data Type: PurchSettlementType Type: Enum |
LogisticsBasic | Specify which settlement is made, when a credit note is created |
CustomsLandingChargesPct_IN | Extended Data Type: Percent Type: Real |
None | Percentage to be defined for landing charges. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
dataAreaId | Extended Data Type: DataAreaId Type: String |
None | |
DebtsTransitLedgerDimension_RU | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Transit general ledger account for redraw debt. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DefaultVend | Extended Data Type: VendAccount Type: String |
None | One-time vendor account used for one-time supplier |
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)) |
DimSettlementCtrlType_RU | Enumeration: DimSettlementCtrlType_RU |
LedgerBasic | Control of settlement by dimension. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DisplayExtendedPriceToleranceIcon | Extended Data Type: DisplayExtendedPriceToleranceIcon Type: Enum |
PurchInvoiceMatching | Show an icon if the invoiced amount for the PO line is different from the PO net amount |
DisplayMiscChargeToleranceIcon | Extended Data Type: DisplayInvoiceMiscChargeMatchIcon Type: Enum |
PurchInvoiceMatching | Show charges matching icon if amount variance is greater than tolerance or if variance is greater than or less than tolerance |
DisplayPriceMatchIcon | Extended Data Type: DisplayPriceMatchIcon Type: Enum |
PurchInvoiceMatching | Show an icon if price is greater than PO price or if price is greater than or less than PO price |
DisplayTotalPriceMatchIcon | Extended Data Type: DisplayTotalPriceMatchIcon Type: Enum |
PurchInvoiceMatching | Show an icon if actual invoice total is greater than expected total or if actual total is greater than or less than expected invoice total |
DocumentDateForIntracomVAT_W | Enumeration: NoYes |
IntracomVAT_W | Select the check box to use the document date for intra-community VAT payable register transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
DoPrintTransportationDocument | Extended Data Type: TransportationDocumentPrint Type: Enum |
None | Print transportation details on external documents (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Due2Payment | Extended Data Type: PaymTermId Type: String |
LedgerAdvCashflowForecast | Terms of payment for period from due date to payment. |
DueToTransDate | Enumeration: NoYes |
None | The method of getting the transaction date for promissory notes journals will be changed. |
ExtendedPriceToleranceAmount | Extended Data Type: ExtendedPriceToleranceAmount Type: Real |
PurchInvoiceMatching | The amount by which the cumulative invoice price total can exceed a matched total purchase price, in the accounting currency |
ExtendedPriceTolerancePercentage | Extended Data Type: ExtendedPriceTolerancePercentage Type: Real |
PurchInvoiceMatching | The percent by which the cumulative invoice price total can exceed a matched total purchase price |
FactureIssuePeriod_RU | Extended Data Type: Integer Type: Integer |
LedgerBasicSalesTax | Number of calendar days for facture issue. Used in incoming VAT processing. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
IntracomVAT | Enumeration: NoYes |
None | Select the checkbox to apply the intra-community VAT to the vendor invoices |
Invoice2Due | Extended Data Type: PaymTermId Type: String |
LedgerAdvCashflowForecast | Terms of payment for period between invoice date and due date |
InvoicePeriod | Extended Data Type: PaymTermId Type: String |
LedgerAdvCashflowForecast | Specify code that specifies the period between invoicing. |
ItemDimAdjustLineControl_RU | Enumeration: NoYes |
None | Control item dimension for original and correcting invoice lines (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
KeepSalesTaxAdjustmentsForPO | Enumeration: NoYes |
LedgerBasicSalesTax | If selected, overrides to sales tax amounts on vendor invoices are preserved. Otherwise, sales tax engine calculations may remove actual sales tax amount overrides. |
Key | Extended Data Type: ParametersKey Type: Integer |
None | Unique identification |
MandatoryInvoiceVATNum | Extended Data Type: MandatoryInvoiceVATNum Type: Enum |
LedgerBasic | Select the countries/regions where a tax exempt number is required before making out an invoice. |
MandatoryTaxGroup | Extended Data Type: CustVendMandatoryTaxGroup Type: Enum |
None | Specify whether sales tax group for vendors should be mandatory. |
MandatoryVATNum | Extended Data Type: MandatoryAccountVATNum Type: Enum |
LedgerBasic | A tax exempt number must be specified for regular vendors attached to the selected countries/regions. |
MatchedPackingSlipsInquiry | Extended Data Type: NoYesId Type: Enum |
LedgerBasic | Enables display of matched product receipt details for posted invoices. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
MatchingPolicy | Enumeration: PurchMatchingPolicyOption |
PurchInvoiceMatching | Default policy for PO lines. Three-way: PO, product receipt, and invoice. Two-way: PO and invoice. |
MatchingPolicyAllowOverride | Enumeration: PurchMatchingPolicyOverrideOption |
PurchInvoiceMatching | Determines the level of control that can be overridden on the PO line |
MaxMSTDiff | Extended Data Type: AmountMST Type: Real |
None | Specify maximum penny difference for settlements. |
MaxMSTOverUnder | Extended Data Type: AmountMST Type: Real |
None | Specify maximum overpayment or underpayment amount |
MCRBrokerClaimJournal | Extended Data Type: LedgerJournalNameId Type: String |
TradeBroker | The journal name used to create the vendor liability (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRBrokerDifferentialJournal | Extended Data Type: LedgerJournalNameId Type: String |
TradeBroker | The journal name used to post the canceled brokerage amount (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRBrokerExpenseJournal | Extended Data Type: LedgerJournalNameId Type: String |
TradeBroker | The journal name used to post to the broker expense account (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRBrokerExpenseLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
TradeBroker | The account used for expenses related to brokerage (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRBrokerManualJourPost | Enumeration: NoYes |
TradeBroker | Defines whether the journal should be posted automatically or manually (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRProcurementCategory | Extended Data Type: MCRProcurementCategory Type: Int64 |
MCRRoyalty | The category used on vendor invoice lines to post royalty liability (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRRoyaltyJournalName | Extended Data Type: LedgerJournalNameId Type: String |
MCRRoyalty | The journal name used to royalty accrual postings (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRRoyaltyLedgerDimension | Extended Data Type: MCRRoyaltyLedgerDimensionDefaultAccount Type: Int64 |
MCRRoyalty | The account used for interim liability postings (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRRoyaltyOffsetLedgerDimension | Extended Data Type: MCRRoyaltyOffsetDimensionDefaultAccount Type: Int64 |
MCRRoyalty | The account used for interim expense postings (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MCRStartingDayOfWeekPeriod | Extended Data Type: MCRRoyaltyStartingDayOfWeek Type: Enum |
MCRRoyalty | Starting day of week used by the royalty cumulation function (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MiscChargeTolerancePercentage | Extended Data Type: MarkupVariancePercent Type: Real |
PurchInvoiceMatching | Percentage variance between charges. |
MixedPayment | Enumeration: NoYes |
None | Do you want a warning when the payment proposal returns more than one method of payment? |
modifiedBy | Extended Data Type: ModifiedBy Type: String |
None | |
modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | |
NotesJournalsValidations | Enumeration: NoYes |
None | Validations will not be launched on promissory notes journals for the Spanish localization. |
OverdueCITPITDimensionAttribute_W | Extended Data Type: OverdueCITPITDimensionAttribute_W Type: Int64 |
None | The dimension that is used to distribute overdue amounts in Corporate Income Tax (CIT) and Personal Income Tax (PIT) journals (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
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)) |
PolicyViolationAction | Enumeration: InvoicePolicyViolationStatus |
LedgerBasic | Choose whether to reject an invoice that fails to validate, or whether to allow it with a warning |
PostChargeAccount | Enumeration: NoYes |
LogisticsBasic | Post to charge account in ledger? |
PostingProfile | Extended Data Type: VendPostingProfile Type: String |
None | Posting profile used as a default |
PostingProfileInvoiceRemit | Extended Data Type: VendPostingProfile Type: String |
VendPromissoryNote | Posting profile for invoice remit |
PostingProfileNotes | Extended Data Type: VendPostingProfile Type: String |
VendPromissoryNote | Posting profile for promissory notes. |
PostingProfileRemitNotes | Extended Data Type: VendPostingProfile Type: String |
VendPromissoryNote | Posting profile for remitting promissory notes. |
PostInvoiceMatchDiscrepancies | Extended Data Type: PostInvoiceMatchDiscrepancies Type: Enum |
PurchInvoiceMatching | Allows you to require approval to post an invoice with an allowed matching discrepancy |
PostPackingSlip | Extended Data Type: PurchPostPackingSlip Type: Enum |
LogisticsBasic | Post product receipts in ledger? |
PrepaymentHandlingLayout_W | Enumeration: PrepaymentHandlingLayout_W |
CustVendJournalizeSettlementTrans_W | Select the form layout to handle the prepayments (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PrepaymentPostingProfile | Extended Data Type: VendPostingProfile Type: String |
None | Posting profile used when payment is marked as prepayment |
PrimaryRelation_BR | Enumeration: ItemVend |
None | Primary relation to select tax groups from the taxes matrix. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ProhibitVATinVendJournal_CZ | Extended Data Type: CzProhibitVATinVendJournal Type: Enum |
None | Prohibit VAT posting in vendor payment journal. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
PurchAgreementAccountStructure_PSN | Extended Data Type: RefRecId Type: Int64 |
PurchFrenchRegulatory_PSN | The account structure that is used to limit access to purchase agreements to authorized departments (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)) |
PurchAgreementFinancialDimension_PSN | Extended Data Type: RefRecId Type: Int64 |
PurchFrenchRegulatory_PSN | The financial dimension that is used to limit access to purchase agreements to specific entities (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)) |
RecId | Extended Data Type: RecId Type: Int64 |
None | |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
ReversePrepayment_W | Extended Data Type: NoYesId Type: Enum |
CustVendJournalizeSettlementTrans_W | Select the check box to reverse a prepayment on an invoice date (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
RTax25ProfitTable | Extended Data Type: RTax25ProfitTableProfit Type: Int64 |
LedgerBasic | Tax dimension expense code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
RTax25UnrealisedRevenueLedgerDimension | Extended Data Type: LedgerDimensionDefaultAccount Type: Int64 |
LedgerBasic | Ledger account for unrealized revenues posting. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
SettlePrepaymentVATType_W | Enumeration: CustSettlePrepaymentVATType_RU |
CustVendJournalizeSettlementTrans_W | Select the VAT transaction type to settle a transaction (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
ShowAmountDebitCredit_JP | Extended Data Type: LedgerShowAmountDebitCredit_CN Type: Enum |
LedgerBasic | Check whether the display of the amount currency is to be divided into debit and credit amounts. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ShowOlderSettlements | Extended Data Type: CustVendShowOlderSettlements Type: Enum |
LedgerBasic | If selected, settlements made before version 2.5 can be referred to closed-transaction editing. |
TaxGroup_W | Extended Data Type: TaxGroup Type: String |
CustVendJournalizeSettlementTrans_W | Select the group of sales tax codes that will be used to calculate taxes (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxItemGroup_W | Extended Data Type: TaxItemGroup Type: String |
CustVendJournalizeSettlementTrans_W | Select the sales tax code that will be used to calculate sales tax on the item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TaxOnPrepayment | Extended Data Type: NoYesId Type: Enum |
None | Specifies that sales tax must be deducted from payments with prepayments. |
TaxPeriodPaymentCode_PL | Extended Data Type: PlTaxPeriodPaymentCode Type: String |
None | Enter a time period code for VAT transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
TotalPriceTolerancePercentage | Extended Data Type: TotalPriceTolerancePercentage Type: Real |
PurchInvoiceMatching | Acceptable percentage variance between expected invoice totals and actual invoice totals |
UseDocumentDate | Enumeration: NoYes |
LogisticsBasic | Use invoice document date when entering vendor and sales tax? |
UseExtendedPriceMatching | Extended Data Type: UseExtendedPriceMatching Type: Enum |
PurchInvoiceMatching | Match the purchase price total with the cumulative invoice price total for lines |
UseInvoiceMatching | Extended Data Type: UseInvoiceMatching Type: Enum |
PurchInvoiceMatching | Enables setup of price tolerance percentage differences between invoice prices and PO prices |
UseMiscChargeMatching | Extended Data Type: UseInvoiceMiscChargeMatching Type: Enum |
PurchInvoiceMatching | If selected, the purchase order charges and invoice charges are compared to the tolerance |
UsePurchConsumpAccount_RU | Enumeration: NoYes |
None | If this check box is selected, the Purchase expenditure for product account is used to post a purchase invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
UseTotalPriceMatching | Extended Data Type: UseTotalPriceMatching Type: Enum |
PurchInvoiceMatching | If selected, the variance between expected invoice totals and actual invoice totals is compared to the tolerance |
UseVendAdvanceInvoice_RU | Enumeration: NoYes |
None | Use prepayment invoice in purchase orders (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VatProcessGroupBy_RU | Enumeration: NoYes |
LedgerBasicSalesTax | Group by lot ID during VAT processing procedure (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VendConsInvoice_JP | Extended Data Type: VendConsUseInvoice_JP Type: Enum |
LedgerBasic | Enable or disable the check box to use a consolidated invoice for the vendor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
VendDiscountOffsetMethod_psn | Enumeration: DiscountOffsetMethod |
PublicSector | Select the accounts to offset when applying discounts (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)) |
VendInvoiceDefaultGroupType | Enumeration: VendInvoiceDefaultGroupType |
None | Select the value to use for new invoice groups. Users can overwrite this value on the invoice form. |
VendInvoiceDocDate | Enumeration: VendInvoiceDocDate |
LedgerBasic | Specify a system response to occur when a vendor invoice is posted without a document date or with a document date after the posting date. |
VendInvoiceGroupingEnable | Extended Data Type: VendInvoiceGroupEnable Type: Enum |
None | Select this check box to activate invoice groups for vendor invoices |
VendInvoiceInternalDefaultGroup | Extended Data Type: VendInvoiceInternalDefaultGroup Type: String |
None | Enter the custom code to use for new invoice groups. Users can overwrite this code on the invoice. |
VendInvoicePolicy | Enumeration: NoYes |
None | Select this check box to apply validation rules to vendor invoices entered through the journal |
VendInvoiceRefNumValidation_FI | Extended Data Type: VendInvoiceRefNumValidation_FI Type: Enum |
None | Enables vendor invoice reference number validation. |
VendInvoiceWebServiceDefaultGroup | Extended Data Type: VendInvoiceWebServicesDefaultGroup Type: String |
None | Enter the custom code to use for invoices created by the web service |
VendNameFromVATNum | Enumeration: NoYes |
None | If this check box is selected, the vendor name is taken from the Tax Exempt table when a customer invoice is printed. |
VendPaymentGroupingEnable | Extended Data Type: VendPaymentGroupEnable Type: Enum |
None | Select this check box to let users add invoices to payment groups |
VendTaxRegisterApproval | Enumeration: VendTaxRegisterApproval |
VendInvoiceRegisterApproval | Specify whether sales tax is to be posted upon invoice registration or upon invoice approval. |
W9Validation | Extended Data Type: VendW9Validation Type: Enum |
None | Select this check box to let users verify whether a vendor has provided a W-9 form |
Top
Field Groups
Field Group | Fields |
---|---|
CreditRating | |
General | |
Customs_IN | |
DimSettlementControl_RU | |
Invoice | |
Invoice_ES | |
Invoice_FI | |
InvoiceGrouping | |
InvoiceMatching | |
InvoiceRules | |
OverdueCITPITJournal_W | |
Posting | |
MCRAllVar | |
PaymentProposal | |
MCRAccounts | |
PrePayment | |
PromissoryNotesJornals | |
Vendor | |
TransportationDocument | |
PurchaseBook_RU | |
PurchAgreement_PSN | |
PromissoryNotesProcess | |
SalesTax | |
TaxesMatrix_BR | |
Settlement | |
PromissoryNotes | |
CashflowForecast | |
AutoReport | |
Advance | |
ClosedTransactionEditing | |
CorrectingFacture_RU | |
CreditorDebts_RU |
Top
Relations
Relation | Table | Lines |
---|---|---|
ClearingLedgerDimension | DimensionAttributeValueCombination | |
dataAreaId | DataArea | |
DebtsTransitLedgerDimension_RU | DimensionAttributeValueCombination | |
EcoResCategory | EcoResCategory | |
LedgerAllocateKey | LedgerAllocateKey | |
MCRBrokerClaimJournal | LedgerJournalName | |
MCRBrokerDifferentialJournal | LedgerJournalName | |
MCRBrokerExpenseJournal | LedgerJournalName | |
MCRBrokerExpenseLedgerDimension | DimensionAttributeValueCombination | |
MCRRoyaltyJournalName | LedgerJournalName | |
MCRRoyaltyLedgerDimension | DimensionAttributeValueCombination | |
MCRRoyaltyOffsetLedgerDimension | DimensionAttributeValueCombination | |
OverdueCITPITDimensionAttribute_W | DimensionAttribute | |
Partition | Partitions | |
PaymTerm_Due2Payment | PaymTerm | |
PaymTerm_Invoice2Due | PaymTerm | |
PaymTerm_InvoicePeriod | PaymTerm | |
PlTaxDueTable | PlTaxDueTable | |
PurchAgreementAccountStructure_PSN | DimensionHierarchy | |
PurchAgreementFinancialDimension_PSN | DimensionAttribute | |
RTax25ProfitTable | RTax25ProfitTable | |
RTax25UnrealisedRevenueLedgerDimension | DimensionAttributeValueCombination | |
TaxGroupHeading | TaxGroupHeading | |
TaxItemGroupHeading | TaxItemGroupHeading | |
VendLedger_AdvancePostingProfile | VendLedger | |
VendLedger_PostingProfile | VendLedger | |
VendLedger_PostingProfileInvoiceRemit | VendLedger | |
VendLedger_PostingProfileNotes | VendLedger | |
VendLedger_PostingProfileRemitNotes | VendLedger | |
VendLedger_PrepaymentPostingProfile | VendLedger | |
VendTable | VendTable |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
DimensionAttributeValueCombinationIdx | Yes | Yes | |
FK_DimensionAttributeValueCombination_Ve | Yes | Yes | |
Key | No | Yes | |
PlTaxDueTableIdx | Yes | Yes | |
RecId | No | Yes | |
RTax25ProfitTableIdx | Yes | Yes | |
RTax25UnrealisedRevenueLedgerDimIdx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
VendParameters Table