Customer Transactions

Summary

Customer Transactions fact consist of Transaction related information of the customers

Dynamics 365 Menu Item(s)

• Accounts receivable > Customers > All customers > Transactions

New data model’s data entities

• FNBI_CustTransEntity
• PMBI_EnumsTableEntity

Synapse link approach tables

• CustTrans
• PMBIENUMSTABLE

Field level functional description

• ACCOUNTINGEVENT: Reference to the accounting event linked to the transaction.
• ACCOUNTINGCURRENCYID: Identifier for the accounting currency.
• ACCOUNTNUM: Customer account number involved in the transaction.
• AMOUNTCUR: Transaction amount in the original currency.
• AMOUNTCUR_: Calculated transaction amount in the original currency.
• AMOUNTMST: Transaction amount in the accounting (base) currency.
• AMOUNTMST_: Calculated transaction amount in the accounting (base) currency.
• APPROVED: Indicates if the transaction is approved.
• APPROVER: Identifier for the person who approved the transaction.
• AvgDaysOutstanding: Average number of days the transaction was outstanding.
• BANKCENTRALBANKPURPOSECODE: Code indicating the purpose of the transaction for central bank reporting.
• BANKCENTRALBANKPURPOSETEXT: Description of the transaction purpose for central bank reporting.
• BANKLCEXPORTLINE: Reference to the bank letter of credit export line.
• BANKREMITTANCEFILEID: Identifier for the bank remittance file.
• BILLOFEXCHANGEID: Identifier for the bill of exchange.
• BILLOFEXCHANGESEQNUM: Sequence number for the bill of exchange.
• BILLOFEXCHANGESTATUS: Status code for the bill of exchange.
• CANCELLEDPAYMENT: Indicates if the payment was cancelled.
• CASHPAYMENT: Indicates if the transaction was a cash payment.
• CASHDISCBASEDATE: Base date for calculating cash discounts.
• CASHDISCCODE: Code for the cash discount applied.
• CLOSED: Date when the transaction was closed.
• COLLECTIONLETTER: Indicates if a collection letter was issued.
• COLLECTIONLETTERCODE: Code for the collection letter.
• COMPANYBANKACCOUNTID: Identifier for the company’s bank account used in the transaction.
• CONTROLNUM: Control number for the transaction.
• CORRECT: Indicates if the transaction is a correction.
• CREATEDBY: User who created the transaction.
• CREATEDDATETIME: Date and time when the transaction was created.
• CREATEDTRANSACTIONID: Identifier for the created transaction.
• CURRENCYCODE: Currency code used in the transaction.
• CUSTBILLINGCLASSIFICATION: Classification code for customer billing.
• CUSTEXCHADJUSTMENTREALIZED: Realized exchange adjustment amount for the customer.
• CUSTEXCHADJUSTMENTUNREALIZED: Unrealized exchange adjustment amount for the customer.
• DAYS_TOPAY: Number of days taken to pay the transaction.
• DEFAULTDIMENSION: Identifier for the default financial dimension associated with the transaction.
• DELIVERYMODE: Mode of delivery for the transaction.
• DIRECTDEBITMANDATE: Identifier for the direct debit mandate.
• DOCUMENTDATE: Date of the transaction document.
• DOCUMENTNUM: Document number for the transaction.
• DUEDATE: Due date for payment of the transaction.
• EUROTRIANGULATION: Indicates if euro triangulation was used.
• EXCHADJUSTMENT: Exchange adjustment amount for the transaction.
• EXCHADJUSTMENTREPORTING: Exchange adjustment amount in the reporting currency.
• EXCHRATE: Exchange rate applied to the transaction.
• EXCHRATESECOND: Secondary exchange rate, if applicable.
• FIXEDEXCHRATE: Indicates if a fixed exchange rate was used.
• INVOICE: Invoice number associated with the transaction.
• INVOICEPROJECT: Indicates if the transaction is related to a project invoice.
• INTEREST: Indicates if interest was applied.
• LASTEXCHADJ: Date of the last exchange adjustment.
• LASTEXCHADJRATE: Last exchange adjustment rate applied.
• LASTEXCHADJRATEREPORTING: Last exchange adjustment rate in the reporting currency.
• LASTEXCHADJVOUCHER: Voucher number for the last exchange adjustment.
• LASTSETTLEACCOUNTNUM: Account number used in the last settlement.
• LASTSETTLECOMPANY: Company code used in the last settlement.
• LASTSETTLEDATE: Date of the last settlement.
• LASTSETTLEVOUCHER: Voucher number for the last settlement.
• MCRPAYMORDERID: Identifier for the payment order.
• MODIFIEDBY: User who last modified the transaction.
• MODIFIEDDATETIME: Date and time when the transaction was last modified.
• MODIFIEDTRANSACTIONID: Identifier for the modified transaction.
• OFFSETRECID: Reference to the offset record ID.
• ORDERACCOUNT: Account number for the order related to the transaction.
• PARTITION: Partition identifier for the transaction.
• PAYMID: Identifier for the payment.
• PAYMMETHOD: Payment method code.
• PAYMMODE: Payment mode code.
• PAYMREFERENCE: Reference for the payment.
• PAYMSCHEDID: Identifier for the payment schedule.
• PAYMSPEC: Payment specification code.
• PAYMTERMID: Identifier for the payment terms.
• PMIPPROJID: Project ID associated with the transaction.
• PMIPPROJINVOICEID: Project invoice ID associated with the transaction.
• POSTINGPROFILE: Posting profile used for the transaction.
• POSTINGPROFILECLOSE: Posting profile used for closing the transaction.
• PREPAYMENT: Indicates if the transaction is a prepayment.
• RECID: Unique record identifier for the transaction.
• REPORTINGCURRENCYAMOUNT: Amount in the reporting currency.
• REPORTINGCURRENCYCROSSRATE: Cross rate for the reporting currency.
• REPORTINGCURRENCYEXCHRATE: Exchange rate for the reporting currency.
• REPORTINGCURRENCYEXCHRATESECONDARY: Secondary exchange rate for the reporting currency.
• REPORTINGEXCHADJUSTMENTREALIZED: Realized exchange adjustment in the reporting currency.
• REPORTINGEXCHADJUSTMENTUNREALIZED: Unrealized exchange adjustment in the reporting currency.
• REASONREFRECID: Reference ID for the reason code.
• RETAILCUSTTRANS: Indicates if the transaction is a retail customer transaction.
• RETAILSTOREID: Identifier for the retail store.
• RETAILTERMINALID: Identifier for the retail terminal.
• RETAILTRANSACTIONID: Identifier for the retail transaction.
• SETTLEAMOUNTCUR: Settled amount in the original currency.
• SETTLEAMOUNTMST: Settled amount in the accounting currency.
• SETTLEAMOUNTREPORTING: Settled amount in the reporting currency.
• SETTLEMENT: Settlement reference number.
• TAXINVOICESALESID: Identifier for the tax invoice sales.
• THIRDPARTYBANKACCOUNTID: Identifier for the third-party bank account.
• TransTypeName: Name of the transaction type.
• TRANSDATE: Date of the transaction.
• TRANSTYPE: Code for the transaction type.
• Trans_Date: Date of the transaction (alternate field).
• TXT: Text description or note for the transaction.
• VOUCHER: Voucher number for the transaction.
• WeekDate: Week date associated with the transaction.