Customer Transaction Settlement

Summary

Customer Transaction settlement fact consist of settled transaction related information of customer.

Dynamics 365 Menu Item(s)

• Accounts receivable > Customers > All customers > Transactions > View settlements

New data model’s data entities

• FNBI_CustSettlementEntity

Synapse link approach tables

• CustSettlement
  

Field level functional description

• ACCOUNTNUM: The unique account number identifying the customer involved in the transaction settlement.
• CANBEREVERSED: Indicates whether the transaction settlement can be reversed (typically a flag or code).
• CUSTCASHDISCDATE: The date on which a cash discount is applied to the customer transaction.
• DUEDATE: The date by which the payment or settlement is due.
• EUSALESLIST: A code or description related to EU sales listing, used for tax or compliance reporting.
• EXCHADJUSTMENT: The amount of exchange rate adjustment applied to the transaction in the accounting currency.
• EXCHADJUSTMENTREPORTING: The amount of exchange rate adjustment applied to the transaction in the reporting currency.
• LASTINTERESTDATE: The most recent date on which interest was calculated or applied to the transaction.
• OFFSETACCOUNTNUM: The account number of the offsetting account involved in the settlement.
• OFFSETCOMPANY: The company code or identifier for the offsetting company in the transaction.
• OFFSETTRANSVOUCHER: The voucher number or reference for the offsetting transaction.
• PENNYDIFF: The difference amount due to rounding (penny difference) in the settlement.
• SETTLEAMOUNTCUR: The amount settled in the transaction currency.
• SETTLEAMOUNTMST: The amount settled in the accounting currency.
• SETTLEAMOUNTREPORTING: The amount settled in the reporting currency.
• SETTLEMENTGROUP: The code or identifier for the settlement group.
• SETTLEMENTVOUCHER: The voucher number or reference for the settlement transaction.
• SETTLETAX1099AMOUNT: The amount of tax reported for 1099 purposes in the settlement.
• SETTLETAX1099STATEAMOUNT: The amount of state tax reported for 1099 purposes in the settlement.
• TRANSCOMPANY: The company code or identifier for the company where the transaction occurred.
• TRANSDATE: The date of the transaction settlement.
• TRANSRECID: The unique record identifier for the transaction.
• UTILIZEDCASHDISC: The amount of cash discount utilized in the settlement.
• CURRENCYCODE: The code representing the currency used in the transaction.
• AccountingCurrencyID: The identifier for the accounting currency used in the transaction.
• CREATEDBY: The user or process that created the transaction settlement record.
• CREATEDDATETIME: The date and time when the transaction settlement record was created.
• DataAreaID: The identifier for the data area or legal entity associated with the transaction.
• OFFSETRECID: The unique record identifier for the offsetting transaction.
• RECID: The unique record identifier for the settlement record.
• RECVERSION: The version number of the record, used for data management and concurrency control.
• PARTITION: The partition number or code used for data segregation and management.