Actual

Summary

Transactions that have been recorded against the project, such as time or expenses. Actual is synonymous with “posted”. This table shares common themes as General ledger transactions, but is specific to the Project subledger.

Dynamics 365 Menu Item(s)

• Project management and accounting > Inquiries and reports > Transactions inquiries > Hour > Ledger updates (Button)
• Project management and accounting > Inquiries and reports > Transactions inquiries > Expense > Ledger updates (Button)
• Project management and accounting > Inquiries and reports > Transactions inquiries > Item > Ledger updates (Button)
• Project management and accounting > Inquiries and reports > Transactions inquiries > Fee > Ledger updates (Button)
• Project management and accounting > Inquiries and reports > Transactions inquiries > On-account > Ledger updates (Button)
• Project management and accounting > Transactions > Posted project transactions > View (Button tab) > View ledger updates (Button)

Legacy data model’s data entities

• PMBI_deFACTActual
• PMBI_deFACTActualv2

New data model’s data entities

• PMBI_ProjTransPostingEntity
• PMBI_PMIPTransactionGroupTransEntity
• FNBI_SqlDictionaryEntity
• PMBI_PMIPUtilizationTypeTransEntity
• PMBI_ProjRevenueTransEntity
• PMBI_ProjEmplTransEntity
• FNBI_VendTransEntity
• PMBI_ProjCostTransEntity
• PMBI_ProjItemTransEntity
• PMBI_ProjOnAccTransEntity
• PMBI_ProjTableEntity
• PMBI_ProjFundingSourceEntity
• PMBI_EnumsTableEntity
• FNBI_SystemParametersEntity
• FNBI_CompanyInfoEntity
• FNBI_LedgerEntity
• PMBI_ProjInvoiceTableEntity

Synapse link approach tables

• ProjTransPosting
• PMIPTransactionGroupTrans
• SqlDictionary
• PMIPUtilizationTypeTrans
• ProjRevenueTrans
• ProjEmplTrans
• VendTrans
• ProjCostTrans
• ProjItemTrans
• ProjOnAccTrans
• ProjTable
• ProjFundingSource
• PMBIENUMSTABLE
• SystemParameters
• CompanyInfo
• Ledger
• ProjInvoiceTable
  

Field level functional description

• ACTIVITYNUMBER: Identifier for the activity associated with the transaction.
• ActualAmount_: The actual monetary amount associated with the transaction.
• ActualAmount_Cost_Total_: The total cost amount for the transaction.
• ActualAmount_Expense_: The expense amount recorded for the transaction.
• ActualAmount_FeeMgt_: Actual amount related to fee management.
• ActualAmount_Labor_: The labor-related amount for the transaction.
• ActualAmount_Offset_: The offset amount, typically used for balancing entries.
• ActualAmount_OnAccount_: The amount recorded as on-account for the transaction.
• ActualAmount_Revenue_: The revenue amount generated by the transaction.
• ActualAmount_WIP_: The work-in-progress amount for the transaction.
• ActualGrossMargin_: The gross margin amount for the transaction.
• ActualHours_: The number of hours recorded for the transaction.
• ActualHours_Adjustment_: The number of hours adjusted in the transaction.
• ActualHours_None_: The number of hours not categorized in the transaction.
• ActualHours_NonUtilized_Client_: Non-utilized hours related to client activities.
• ActualHours_NonUtilized_Internal_: Non-utilized hours related to internal activities.
• ActualHours_NonUtilized_PTO_: Non-utilized hours due to paid time off.
• ActualHours_NonUtilized_Total_: Total non-utilized hours for the transaction.
• ActualHours_Not_Included_: Hours not included in utilization calculations.
• ActualHours_Total_: Total hours recorded for the transaction.
• ActualHours_Utilized_Bill_: Billable utilized hours.
• ActualHours_Utilized_Internal_: Utilized hours for internal purposes.
• ActualHours_Utilized_NonBill_: Non-billable utilized hours.
• ActualHours_Utilized_Total_: Total utilized hours.
• ActualInvoiceAmount_: The actual invoice amount for the transaction.
• ActualQuantity_: The actual quantity involved in the transaction.
• AdjustedHours_: Hours that have been adjusted.
• CATEGORYID: Identifier for the category associated with the transaction.
• CostSales: Indicates if the transaction is related to cost of sales (typically a flag or code).
• CurrencyID: Identifier for the currency used in the transaction.
• Customer: (Not present in the schema, so omitted.)
• Description: A textual description of the transaction.
• EmplItemID: Identifier for the employee or item associated with the transaction.
• HoursFromHoursJournals_: Hours recorded from hour journals.
• InventTransID: Inventory transaction identifier.
• ItemSalesTaxGroup: The sales tax group applicable to the item.
• LedgerOrigin: Code indicating the origin of the ledger entry.
• LEDGERTRANSDATE: The date of the ledger transaction.
• LinePropertyId: Identifier for the line property.
• PaymentDate: The date when payment was made or received.
• PaymentStatus: Status code indicating the payment state.
• PostedHoursFromTimeSheets_: Hours posted from timesheets.
• ProjAdjustRefID: Reference ID for project adjustments.
• ProjTransDate: The date of the project transaction.
• ProjTransPostingRecID: Record ID for project transaction posting.
• ProjTransPostingTransID: Transaction ID for project transaction posting.
• ReportingCurrencyCode: The code for the reporting currency.
• ReportingExchangeRateType: The type of exchange rate used for reporting.
• SalesTaxGroup: The sales tax group applicable to the transaction.
• TransactionOrigin: Origin or source of the transaction.
• UtilizationName: Name describing the utilization type.
• VendorAccountNum: Vendor account number associated with the transaction.
• VendorInvoiceDataAreaID: Data area ID for the vendor invoice.
• VendorInvoiceDate: The date of the vendor invoice.
• Voucher: The voucher number for the transaction.
• VoucherPrefix: Prefix used for the voucher number.