CustTrans Table [AX 2012]
The CustTrans table contains the posted transaction information for the customer.
Configuration Key: LedgerBasic| Method | Description | |
|---|---|---|
![]() | agreementDocumentTitle_RU | Gets the Document title of the Agreement for this transaction. |
![]() | agreementId_RU | Gets the Agreement Id from the DefaultDimension of this transaction. |
![]() | allowEditCompanyBankAccountId | |
![]() | allowEditThirdPartyBankAccountId | |
![]() | amountExchAdj | |
![]() | 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.) |
![]() | bankCurrencyTransferId_RU | |
![]() | 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.) |
![]() | canSettle_RU | |
![]() | 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.) |
![]() | clearingLedgerDimension | |
![]() | clearingPeriod | |
![]() | company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) |
![]() | companyInfo | Retrieves the CompanyInfo record associated with the current record. |
![]() | con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) |
![]() | concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) |
![]() | context | Gets and sets the context property. (Inherited from xRecord.) |
![]() | copyDimension | Retrieves a dimension set that can be applied to the defaultDimension field on this table. |
![]() | custInvoiceJour_RU | |
![]() | custPaymManTrans | |
![]() | custPaymManTransHist | |
![]() | custTableName | |
![]() | custTrans_W | Gets the CustTrans_W record associated with the current record. |
![]() | custTransExtensionTH | Gets the extension information of current customer transaction. |
![]() | 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.) |
![]() | dispAmountCur | |
![]() | dispConsId_JP | Displays consolidation invoice Id for this transaction. |
![]() | displayAccountingExchangeRate | Returns the ExchRate field in a format ready to be displayed on a form. |
![]() | displayLastInterestDate | |
![]() | displayTaxBranchDimension | Displays the tax branch code depending on the default dimension. |
![]() | displayTransactionCurAmountCredit_JP | Display method for the Transaction Currency Amount Credit. |
![]() | displayTransactionCurAmountDebit_JP | Display method for the Transaction Currency Amount Debit. |
![]() | displayUtilizedCashDisc | |
![]() | 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.) |
![]() | documentDateModified | |
![]() | 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.) |
![]() | exchRateCurToMst | Gets the exchange rate from the transaction currency to the monetary standard (MST) currency. |
![]() | 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.) |
![]() | findOpenSettlementRecID_BR | Finds a record in the CustSettlement table. |
![]() | fiscalEstablishmentId_BR | Displays the fiscal establishment of the current transaction. |
![]() | getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) |
![]() | getBillingClassification | |
![]() | 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.) |
![]() | getPaymentExtension_BR | Gets the CustTransPayment_BR table record |
![]() | 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.) |
![]() | initFromPostingProfile | |
![]() | initFromRBOTransactionTable | |
![]() | initValue | Initializes a field to the default value. (Inherited from xRecord.) |
![]() | inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
![]() | insert | Inserts the current record into the CustTrans table. |
![]() | interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
![]() | inventProfileType_RU | |
![]() | isCreditNote | |
![]() | 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.) |
![]() | isInterest | |
![]() | isInvoice | |
![]() | isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) |
![]() | isParentOrAdjustingInvoice | Checks that the CustTrans table is a parent or adjusting invoice. |
![]() | isPartOfUOWSaveChanges | (Inherited from xRecord.) |
![]() | isPayment | |
![]() | isReimbursement | Indicates whether the debit transaction is of reimbursement type. |
![]() | isSettled_BR | Verifies whether the customer transaction is settled. |
![]() | 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.) |
![]() | isTransForConsInvoice_JP | Indicates whether this transaction is for consolidated invoice. |
![]() | joinChild | Finds the join child of the current record. (Inherited from xRecord.) |
![]() | joinParent | Finds the join parent of the current record. (Inherited from xRecord.) |
![]() | languageId | |
![]() | lastCollectionLetterRecId | |
![]() | lastUpdatedCollectionLetter | |
![]() | lastUpdatedInterest | |
![]() | linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) |
![]() | mcrDisplayBalance | Determines the accounts receivables balance for the customer. |
![]() | mcrDisplayPayments | Calculates and returns the total amount of payments made by the customer. |
![]() | mcrDisplayTotals | Calculates the total AR balance less the payments made by the customer. |
![]() | mcrGetCustomerBalance | Gets the customer balance. |
![]() | mcrGetCustomerPayments | Retrieves customer payments for the customer associated with the current CustTrans record. |
![]() | merge | Merges the current table with the specified table. (Inherited from xRecord.) |
![]() | mergeDimension | Returns a dimension set that holds the merged combination of the current defaultDimension field on this table and the provided dimension set. |
![]() | modifiedField | |
![]() | 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.) |
![]() | open | |
![]() | orig | Retrieves the original values of the current record. (Inherited from xRecord.) |
![]() | originalPaymTrans_RU | |
![]() | 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.) |
![]() | packCustTrans_W | Packs the CustTrans_W associated with the current record. |
![]() | packExtensionTable | Packs a SysExtensionSerializerExtensionMap extension table's buffer inside the record's internal cache. |
![]() | paymentTerms | |
![]() | paymentTermsListPage | |
![]() | possibleCashDisc | |
![]() | postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) |
![]() | postLoad | |
![]() | prepaidNetAmount | |
![]() | prepaidTaxAmount | |
![]() | preRemoting | Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.) |
![]() | previewPaneTitle | |
![]() | queryCustInvoiceJour | |
![]() | queryCustVendSettlement | |
![]() | queryCustVendTransOpen | |
![]() | queryProjInvoiceJour | Returns a Query object that is used to iterate over related ProjInvoiceJour table records. |
![]() | 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.) |
![]() | remainAmountCur | |
![]() | remainAmountMST | |
![]() | 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.) |
![]() | resetAmountsToDate | Resets the transaction amounts to what they were on the specified date. |
![]() | reversed | |
![]() | 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.) |
![]() | settledPrepaidAmountCur | |
![]() | 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.) |
![]() | summaryLedgerDimension | |
![]() | 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.) |
![]() | traceNum | |
![]() | transactionPerDate | Resets the transaction amounts to what they were on the specified date. |
![]() | transData | |
![]() | transOpen | |
![]() | 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.) |
![]() | validateDelete | Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.) |
![]() | validateField | Determines whether the _fieldIdToCheck field is valid. |
![]() | validateFieldValue | (Inherited from xRecord.) |
![]() | 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.) |
![]() ![]() | ::balanceMST | |
![]() ![]() | ::calcSettlementOutsideCashDiscDate | |
![]() ![]() | ::checkIfCanBeSettled_RU | |
![]() ![]() | ::checkReversal | |
![]() ![]() | ::chkCustTransReorg | |
![]() ![]() | ::custEndBalanceMSTPostingProfile | Returns the accounting currency customer balance for the provided posting profile through the given end date. |
![]() ![]() | ::custPaymManAmountMST | |
![]() ![]() | ::custStartBalanceMSTPostingProfile | |
![]() ![]() | ::existForSubledgerJournal | Indicates whether the specified subledger voucher is used by a customer subledger journal transaction. |
![]() ![]() | ::find | |
![]() ![]() | ::findByCompany | Finds a CustTrans record in the given company. |
![]() ![]() | ::findByVoucher | Finds a CustTrans record in the given company. |
![]() ![]() | ::findFromInvoice | |
![]() ![]() | ::findRefVoucher_IN | To find the CustTrans based on given voucher. |
![]() ![]() | ::findVoucherDate | |
![]() ![]() | ::findVoucherDateType | Returns a CustTrans table record for a given voucher, transaction, and transaction type. |
![]() ![]() | ::hasLCRelatedTransToBeReversed | Indicates whether there is any Letter of Credit-related CustTrans to reverse. |
![]() ![]() | ::initCustBalance | |
![]() ![]() | ::mcrFindFromVoucher | Finds the CustTrans record based on the passed parameters. |
![]() ![]() | ::prepaymentTrans_RU | |
![]() ![]() | ::reverseTransact | |
![]() ![]() | ::reverseTransactOld | |
![]() ![]() | ::settleTransact |
| Field | Type | Configuration key | Description |
|---|---|---|---|
| AccountingEvent |
Extended Data Type:
RefRecId Type: Int64 | None | Reference field in a different table |
| AccountNum |
Extended Data Type:
CustAccount Type: String | None | The customer that is associated with the voucher |
| AmountCur |
Extended Data Type:
AmountCurDebCred Type: Real | None | Transaction amount in specified currency |
| AmountMST |
Extended Data Type:
AmountMSTDebCred Type: Real | None | Transaction amount in standard currency |
| Approved |
Extended Data Type:
Approved Type: Enum | None | Has transaction been approved? |
| Approver |
Extended Data Type:
HcmApprover Type: Int64 | None | Worker who approved the record. |
| BankCentralBankPurposeCode |
Extended Data Type:
BankCentralBankPurposeCode Type: String | LedgerBasic | Code used when reporting to the central bank. |
| BankCentralBankPurposeText |
Extended Data Type:
BankCentralBankPurposeText Type: String | LedgerBasic | Describe code used when reporting to the central bank. |
| BankLCExportLine |
Extended Data Type:
BankLCLineRefRecId Type: Int64 | BankDocument | The shipment number of shipment details. |
| BankRemittanceFileId |
Extended Data Type:
BankRemittanceFileIdCust Type: String | CustBillOfExchange | Unique identification of the remittance file. |
| BillOfExchangeID |
Extended Data Type:
CustBillOfExchangeID Type: String | CustBillOfExchange | Unique key for identification of bills of exchange. The key is used when creating new bills of exchange. |
| BillOfExchangeSeqNum |
Extended Data Type:
CustVendNegInstSeqNum Type: Integer | CustVendNegotiableInstrument | Sequence number for bills of exchange and promissory notes. |
| BillOfExchangeStatus |
Extended Data Type:
CustBillOfExchangeStatus Type: Enum | CustVendNegotiableInstrument | Status of the bill of exchange. |
| CancelledPayment |
Extended Data Type:
Cancelled Type: Enum | None | Is this a canceled payment? |
| CashDiscCode |
Extended Data Type:
CashDiscCode Type: String | LedgerBasic | Cash discount code for subsequent approval. |
| CashPayment |
Enumeration:
NoYes | None | Should COD payments be in cash and not by check? |
| Closed |
Extended Data Type:
TransDate Type: Date | None | Date of total settlement of the transaction |
| CollectionLetter |
Enumeration:
NoYes | CustCollectionLetter | May a collection letter be issued for the transaction? |
| CollectionLetterCode |
Enumeration:
CustCollectionLetterCode | CustCollectionLetter | Collection letter code used for further collection letters. |
| CompanyBankAccountId |
Extended Data Type:
CompanyBankAccountId Type: String | Bank | Bank account number |
| ConcessionContractId |
Extended Data Type:
RetailConcessionContractId Type: String | RetailConcession | Concession contract ID (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| ConcessionSettlementId |
Extended Data Type:
RetailConsessionSettlementId Type: String | RetailConcession | Group identifier. (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)) |
| ControlNum |
Extended Data Type:
Num Type: String | LogisticsBasic | Preprinted control number from COD label |
| Correct |
Extended Data Type:
Correct Type: Enum | LedgerBasic | Is the current transaction a reversing entry? |
| createdBy |
Extended Data Type:
CreatedBy Type: String | None | |
| createdDateTime |
Extended Data Type:
CreatedDateTime Type: UtcDateTime | None | |
| createdTransactionId |
Extended Data Type:
CreatedTransactionId Type: Int64 | None | |
| CurrencyCode |
Extended Data Type:
CustCurrencyCode Type: String | None | Currency for amount in foreign currency |
| CustBillingClassification |
Extended Data Type:
RefRecId Type: Int64 | PublicSector | The billing classification that is assigned to this transaction. (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)) |
| CustExchAdjustmentRealized |
Extended Data Type:
CustExchAdjustmentRealized Type: Real | LedgerBasic | Realized exchange rate adjustment amount of this transaction |
| CustExchAdjustmentUnrealized |
Extended Data Type:
CustExchAdjustmentUnrealized Type: Real | LedgerBasic | Unrealized exchange rate adjustment amount of this transaction |
| dataAreaId |
Extended Data Type:
DataAreaId Type: String | None | |
| DefaultDimension |
Extended Data Type:
DimensionDefault Type: Int64 | LedgerBasic | Default dimensions |
| dEL_CreatedTime |
Extended Data Type:
DEL_CreatedTime Type: Integer | None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, 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)) |
| DeliveryMode |
Extended Data Type:
CustDlvModeId Type: String | None | Mode of delivery for delivery of items |
| DirectDebitMandate |
Extended Data Type:
CustDirectDebitMandateRecId Type: Int64 | None | Select the direct debit mandate reference of the recipient (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DocumentDate |
Extended Data Type:
DocumentDate Type: Date | None | Date of document that created this transaction |
| DocumentNum |
Extended Data Type:
DocumentNum Type: String | None | Number of the document that generated the transaction. |
| DueDate |
Extended Data Type:
DueDate Type: Date | LedgerBasic | Due date of the transaction. |
| EUROTriangulation |
Extended Data Type:
EUROTriangulation Type: Enum | None | Specify whether the exchange rate is included in triangulation. |
| ExchAdjustment |
Extended Data Type:
CustExchAdjustment Type: Real | LedgerBasic | Amount of the transaction exchange rate adjustment |
| ExchAdjustmentReporting |
Extended Data Type:
CustExchAdjustment Type: Real | LedgerBasic | Amount of the transaction exchange rate adjustment |
| ExchRate |
Extended Data Type:
ExchRate Type: Real | None | Specify the cost in the foreign currency. |
| ExchRateSecond |
Extended Data Type:
ExchrateSecondary Type: Real | None | Rate of the secondary part of the currency calculation, when triangulation is used |
| FixedExchRate |
Extended Data Type:
FixedExchRate Type: Enum | None | Specify whether fixed exchange rate is to be used. |
| Interest |
Extended Data Type:
CustInterestCalculate Type: Enum | CustInterest | May interest be calculated on the transaction? |
| Invoice |
Extended Data Type:
InvoiceId Type: String | None | Invoice number that the transaction is attached to |
| InvoiceProject |
Enumeration:
NoYes | None | Specifies whether the customer transaction originates from an project contract |
| LastExchAdj |
Extended Data Type:
TransDate Type: Date | None | Date of last foreign currency revaluation of the transaction |
| LastExchAdjRate |
Extended Data Type:
ExchRate Type: Real | None | Exchange rate from the last foreign currency revaluation adjustment |
| LastExchAdjRateReporting |
Extended Data Type:
CurrencyExchangeRate Type: Real | None | The currency exchange rate |
| LastExchAdjVoucher |
Extended Data Type:
Voucher Type: String | LedgerBasic | Voucher number from the last foreign currency revaluation adjustment |
| LastSettleAccountNum |
Extended Data Type:
CustAccount Type: String | None | The customer that is associated with the most recent settlement voucher |
| LastSettleCompany |
Extended Data Type:
CompanyId Type: String | None | The company that is associated with the most recent settlement voucher |
| LastSettleDate |
Extended Data Type:
TransDate Type: Date | None | Date of voucher that decreased this transaction most recently. |
| LastSettleVoucher |
Extended Data Type:
Voucher Type: String | LedgerBasic | Voucher number that decreased this transaction most recently. |
| MCRPaymOrderID |
Extended Data Type:
MCRPaymOrderId Type: String | MCRPayment | Identification of the order (sales order, free-text invoice, etc.) associated with this payment (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| modifiedBy |
Extended Data Type:
ModifiedBy Type: String | None | |
| modifiedDateTime |
Extended Data Type:
ModifiedDateTime Type: UtcDateTime | None | |
| modifiedTransactionId |
Extended Data Type:
ModifiedTransactionId Type: Int64 | None | |
| OffsetRecid |
Extended Data Type:
CustTransRefRecId Type: Int64 | None | Reference field in a different table |
| OrderAccount |
Extended Data Type:
CustAccount Type: String | None | Order account related to the transaction |
| 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)) |
| PaymId |
Extended Data Type:
PaymId Type: String | LedgerBasic | Payment identification |
| PaymManBatch |
Extended Data Type:
PaymManBatch Type: String | PaymMan | Identification of the reporting batch. |
| PaymManLackDate |
Extended Data Type:
PaymManLackDate Type: Date | PaymMan | Time limit for feedback from the bank on payments |
| PaymMethod |
Enumeration:
NetCurrent | None | Method of payment, for instance net, current month or current quarter. |
| PaymMode |
Extended Data Type:
CustPaymMode Type: String | LedgerBasic | Code for method of payment concerning customer payment |
| PaymReference |
Extended Data Type:
CustPaymReference Type: String | LedgerBasic | Reference to a specific payment. |
| PaymSpec |
Extended Data Type:
CustPaymSpec Type: String | LedgerBasic | Specify payment handling for the current method of payment. |
| PostingProfile |
Extended Data Type:
CustPostingProfile Type: String | None | Posting profile used when creating this transaction |
| PostingProfileClose |
Extended Data Type:
CustPostingProfile Type: String | None | Posting profile of the transaction when closing. |
| Prepayment |
Enumeration:
NoYes | None | Mark that the payment is to be managed as a prepayment. |
| ReasonRefRecId |
Extended Data Type:
ReasonRefRecID Type: Int64 | None | Contains stored financial reason codes and comments for entered or posted transactions or actions. |
| RecId |
Extended Data Type:
RecId Type: Int64 | None | |
| recVersion |
Extended Data Type:
RecVersion Type: Integer | None | |
| ReportingCurrencyAmount |
Extended Data Type:
AmountMSTSecondary Type: Real | None | The amount in the reporting currency |
| ReportingCurrencyCrossRate |
Extended Data Type:
CurrencyExchangeRate Type: Real | None | The currency exchange rate |
| ReportingExchAdjustmentRealized |
Extended Data Type:
CustExchAdjustmentRealized Type: Real | LedgerBasic | Realized exchange rate adjustment amount of this transaction |
| ReportingExchAdjustmentUnrealized |
Extended Data Type:
CustExchAdjustmentUnrealized Type: Real | LedgerBasic | Unrealized exchange rate adjustment amount of this transaction |
| RetailCustTrans |
Extended Data Type:
RetailCustTrans Type: Enum | Retail | Customer transaction type. (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)) |
| RetailStoreId |
Extended Data Type:
RetailStoreId Type: String | Retail | Identification of store (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)) |
| RetailTerminalId |
Extended Data Type:
RetailTerminalId Type: String | Retail | Identification of POS terminal (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)) |
| RetailTransactionId |
Extended Data Type:
RetailTransactionId Type: String | RetailHeadquarters | Identification of the transaction (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)) |
| SettleAmountCur |
Extended Data Type:
AmountCur Type: Real | None | Settled portion of the amount in foreign currency |
| SettleAmountMST |
Extended Data Type:
AmountMST Type: Real | None | Settled amount in standard currency. |
| SettleAmountReporting |
Extended Data Type:
AmountMSTSecondary Type: Real | None | The amount in the reporting currency |
| Settlement |
Extended Data Type:
CustAutoSettlement Type: Enum | LedgerBasic | May transaction be settled automatically? |
| TaxInvoiceSalesId |
Extended Data Type:
TaxInvoiceSalesId Type: String | None | Unique key for invoice, allocated when invoice updating. |
| ThirdPartyBankAccountId |
Extended Data Type:
BankThirdPartyAccountId Type: String | Bank | Bank account ID of the third-party bank account. |
| TransDate |
Extended Data Type:
TransDate Type: Date | None | Transaction date |
| TransType |
Enumeration:
LedgerTransType | None | Transaction type specified when recording this transaction |
| Txt |
Extended Data Type:
TransTxt Type: String | None | Transaction text that has been created for the transaction. |
| Voucher |
Extended Data Type:
Voucher Type: String | LedgerBasic | Voucher number that the transaction is attached to. |
| Field Group | Fields |
|---|---|
| Identification | |
| ExchangeRates | |
| Invoice | |
| Ledger | |
| MCRCustCredit | |
| Payment | |
| Misc | |
| PaymMan | |
| Reason | |
| Project | |
| Administration | |
| Amount | |
| Bank | |
| AutoReport | |
| Agreement_RU | |
| BankLCExportGroup | |
| BillingClassification | |
| CaseMoreInformation | |
| BillOfExchange | |
| CashDiscount | |
| CustomerTransactions | |
| CustTransReferenceVoucher_IN | |
| Dimension | |
| Consession | |
| CollectionLetter | |
| ExchangeAdjustment | |
| Document | |
| Retail | |
| SettlementStatus | |
| Settlement |
| Relation | Table | Lines |
|---|---|---|
| AccNumRetailConcessionContractTable | RetailConcessionContractTable | |
| AccountingEvent | AccountingEvent | |
| BankAccountTable | BankAccountTable | |
| BankCentralBankPurpose | BankCentralBankPurpose | |
| BankLCExportLine | BankLCExportLine | |
| BankRemittanceFilesCust | BankRemittanceFilesCust | |
| CashDisc | CashDisc | |
| Currency | Currency | |
| CustBillingClassification | CustBillingClassification | |
| CustBillOfExchangeJour | CustBillOfExchangeJour | |
| CustBillOfExchangeTrans | CustBillOfExchangeTrans | |
| CustCollectionLetterJour | CustCollectionLetterJour | |
| CustDirectDebitMandate | CustDirectDebitMandate | |
| CustExchRateAdjustment | CustExchRateAdjustment | |
| CustInterestJour | CustInterestJour | |
| CustInvoiceJour | CustInvoiceJour | |
| CustLedger_PostingProfile | CustLedger | |
| CustLedger_PostingProfileClose | CustLedger | |
| CustPaymentModeSpec | CustPaymModeSpec | |
| CustPaymManFile | CustPaymManFile | |
| CustPaymModeTable | CustPaymModeTable | |
| CustTable_AccountNum | CustTable | |
| CustTable_LastSettleAccountNum | CustTable | |
| CustTable_OrderAccount | CustTable | |
| CustTrans | CustTrans | |
| CustTrans_OffsetRecid | CustTrans | |
| CustTransVoucher | CustTrans | |
| DataArea | DataArea | |
| dataAreaId | DataArea | |
| DefaultDimension | DimensionAttributeValueSet | |
| DlvMode | DlvMode | |
| FactureJourAmountDifference_RU | FactureJour_RU | |
| FactureJourPrepayment_RU | FactureJour_RU | |
| HcmWorker | HcmWorker | |
| Partition | Partitions | |
| ProjInvoiceJour | ProjInvoiceJour | |
| ReasonRef | ReasonTableRef | |
| RetailConcessionContractTable | RetailConcessionContractTable | |
| RetailConsessionSettlementTable | RetailConsessionSettlementTable | |
| RetailStoreTable | RetailStoreTable | |
| RetailTerminalTable | RetailTerminalTable | |
| RetailTransactionTable | RetailTransactionTable | |
| ThirdPartyBankAccountId | CustBankAccount | |
| TmpBankPaym2Invoice | TmpBankPaym2Invoice |
Community Additions
ADD
Show:
