CustTrans Table

Article
2014-04-11

The CustTrans table contains the posted transaction information for the customer.

Configuration Key: LedgerBasic

Methods

	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

Top

Fields

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.

Top

Field Groups

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

Top

Relations

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

Top

Indexes

Index	AllowDuplicates	Enabled
AccountDateIdx	Yes	Yes
BillOfExchangeIdx	Yes	Yes
CustBillingClassificationIdx	Yes	Yes
FK_DimensionAttributeValueSet_CustTrans	Yes	Yes
InvoiceAccountIdx	Yes	Yes
PaymIdDateIdx	Yes	Yes
RecId	No	Yes
VoucherDateIdx	Yes	Yes

Top

Inheritance Hierarchy

xRecord Class
Common Table
CustTrans Table

Share via

CustTrans Table

Methods

Fields

Field Groups

Relations

Indexes

Inheritance Hierarchy

See Also

Additional resources