Project Transaction Date

Summary

Date of project transactions; the date the work was performed.

Dynamics 365 Menu Item(s)

• Organization administration > Setup > Calendars > Date dimensions

Legacy data model’s data entities

• PMBI_deProjTransDate

New data model’s data entities

• FNBI_BIDateDimensionEntity
• FNBI_BIDateDimensionValueEntity
• FNBI_BIDateDimensionTranslationsEntity

Synapse link approach tables

• BIDateDimension
• BIDateDimensionValue
• BIDateDimensionTranslations
  

Field level functional description

• DotNetCulture: The culture or locale code used for formatting dates and times (e.g., en-US).
• ProjTransDate_Date: The specific date of the project transaction.
• ProjTransDate_DateName: The name or label for the transaction date (e.g., day of the week or custom label).
• ProjTransDate_DateNumber: A numeric representation of the transaction date, often used for sorting or calculations.
• ProjTransDate_MonthDate: The date representing the first day of the month for the transaction.
• ProjTransDate_MonthDay: The day of the month for the transaction date.
• ProjTransDate_MonthName: The name of the month for the transaction date.
• ProjTransDate_MonthNumber: The numeric value of the month for the transaction date.
• ProjTransDate_MonthToDate: A label or flag indicating if the transaction is within the month-to-date period.
• ProjTransDate_QuarterDate: The date representing the first day of the quarter for the transaction.
• ProjTransDate_QuarterName: The name of the quarter for the transaction date.
• ProjTransDate_QuarterToDate: A label or flag indicating if the transaction is within the quarter-to-date period.
• ProjTransDate_QuartnerNumber: The numeric value of the quarter for the transaction date.
• ProjTransDate_Short Month: The abbreviated name of the month for the transaction date.
• ProjTransDate_Week_Format: The formatted representation of the week for the transaction date.
• ProjTransDate_WeekDate: The date representing the first day of the week for the transaction.
• ProjTransDate_WeekName: The name of the week or week label for the transaction date.
• ProjTransDate_WeekNumber: The numeric value of the week for the transaction date.
• Project Date: The date associated with the project, possibly used for reporting or filtering.
• ProjTransDate_YearDate: The date representing the first day of the year for the transaction.
• ProjTransDate_YearName: The name of the year or year label for the transaction date.
• ProjTransDate_YearNumber: The numeric value of the year for the transaction date.
• ProjTransDate_YearToDate: A label or flag indicating if the transaction is within the year-to-date period.