Date Financial

Summary

Date transaction was posted to the General ledger.

Dynamics 365 Menu Item(s)

• General ledger > Ledger setup > Fiscal calendars

Legacy data model’s data entities

• PMBI_deDateFinancial

New data model’s data entities

• FNBI_LedgerEntity
• FNBI_CompanyInfoEntity
• FNBI_FiscalCalendarEntity
• FNBI_FiscalCalendarYearEntity
• FNBI_FiscalCalendarPeriodEntity
• FNBI_BIDateGregorianEntity
• FNBI_BIDateDimensionValueEntity
• FNBI_BIDateDimensionEntity
• FNBI_BIDateDimensionTranslationsEntity
• PMBI_EnumsTableEntity

Synapse link approach tables

• Ledger
• CompanyInfo
• FiscalCalendar
• FiscalCalendarYear
• FiscalCalendarPeriod
• BIDateGregorian
• BIDateDimensionValue
• BIDateDimension
• BIDateDimensionTranslations
• PMBIENUMSTABLE
  

Field level functional description

• DataAreaID: Identifier for the legal entity or company associated with the financial date.
• DateFinancial_Date: The specific financial date for the record.
• DateFinancial_DateName: Textual representation or name of the financial date.
• DateFinancial_DateNumber: Numeric representation of the financial date, often used for sorting or calculations.
• DateFinancial_MonthDate: The first date of the month for the financial period.
• DateFinancial_MonthName: Name of the month for the financial date.
• DateFinancial_MonthNumber: Numeric value representing the month of the financial date.
• DateFinancial_QuarterDate: The first date of the quarter for the financial period.
• DateFinancial_QuarterName: Name of the quarter for the financial date.
• DateFinancial_QuarterNumber: Numeric value representing the quarter of the financial date.
• DateFinancial_Short Month: Abbreviated name of the month for the financial date.
• DateFinancial_WeekDate: The first date of the week for the financial period.
• DateFinancial_WeekName: Name of the week for the financial date.
• DateFinancial_WeekNumber: Numeric value representing the week of the financial date.
• DateFinancial_Week_Format: Formatted representation of the week for reporting or display purposes.
• Day: Day of the month for the financial date.
• DotNetCulture: Culture or locale code used for formatting dates and times.
• FiscalMonthNumber: Numeric value representing the fiscal month.
• FiscalPeriodName: Name of the fiscal period for the financial date.
• FiscalQuarterNumber: Numeric value representing the fiscal quarter.
• FiscalYearName: Name of the fiscal year for the financial date.
• Month: Name or code of the month for the financial date.
• Quarter: Numeric value representing the quarter for the financial date.
• Week: Name or code of the week for the financial date.
• Year: Numeric value representing the year for the financial date.