Infor Birst
Updates to FSM Data Lake Replication Sets
New business classes and fields are added to the replication sets delivered with FSM:
Business classes:
FSM_GL_ST-FSM_AllocationSnapshot
FSM_GL_ST-FSM_AllocationSnapshotDetail
FSM_TC_ST-FSM_TrueCostAssetBookPeriod
FSM_TC_ST-FSM_TrueCostCapacityVolumes
FSM_TC_ST-FSM_TrueCostCostBehavior
FSM_TC_ST-FSM_TrueCostCostBehaviorSummary
FSM_TC_ST-FSM_TrueCostAllocationRun
FSM_TC_ST-FSM_TrueCostCapacity
FSM_TC_ST-FSM_TrueCostCapacityDetail
FSM_TC_ST-FSM_TrueCostCapacityUnutilized
FSM_TC_ST-FSM_TrueCostCapacityVolume
FSM_TC_ST-FSM_TrueCostOperatingExpenses
FSM_TC_ST-FSM_TrueCostPeriodRun
FSM_TC_ST-FSM_TrueCostReportsandCharts
FSM_TC_ST-FSM_TrueCostResourceIntensityFactor
FSM_TC_ST-FSM_TrueCostResourceIntensityFactorData
FSM_TC_ST-FSM_TrueCostResourceList
FSM_TC_ST-FSM_TrueCostResourceUnitCost
FSM_TC_ST-FSM_TrueCostResourceUnitCostDetails
FSM_TC_ST-FSM_TrueCostResourceUtilizationDriver
FSM_TC_ST-FSM_TrueCostResourceUtilizationDriverEvent
FSM_TC_ST-FSM_TrueCostRunParameter
FSM_TC_ST-FSM_TrueCostRunParameterPeriod
Fields:
FSM_AP_ST-FSM_PayablesInvoice-BankInstructions1
FSM_AP_ST-FSM_PayablesInvoice-BankInstructions2
FSM_AP_ST-FSM_PayablesInvoice-BankInstructions3
FSM_AP_ST-FSM_PayablesInvoice-BankInstructions4
FSM_AP_ST-FSM_PayablesInvoice-CertificationDate
FSM_AP_ST-FSM_PayablesInvoice-CertificationNumber
FSM_AP_ST-FSM_PayablesInvoice-EAMWorkOrder
FSM_AP_ST-FSM_PayablesInvoice-EAMWorkOrderActivity
FSM_AP_ST-FSM_PayablesInvoice-IDMDocumentPID
FSM_AP_ST-FSM_PayablesInvoice-IDMInvoiceSentToVendor
FSM_AP_ST-FSM_PayablesInvoice-IDMJob
FSM_AP_ST-FSM_PayablesInvoice-IDMPrinter
FSM_AP_ST-FSM_PayablesInvoice-InvoiceRoutingCodeGroup
FSM_AP_ST-FSM_PayablesInvoice-InvoiceRoutingCodeGroupLevel
FSM_AP_ST-FSM_PayablesInvoice-MatchReferenceNumber
FSM_AP_ST-FSM_PayablesInvoice-RequiresApproval
FSM_AP_ST-FSM_PayablesInvoice-VATSplitPayment
FSM_GL_ST-FSM_Allocation-AutoReverse
FSM_GL_ST-FSM_AllocationControl-TrueCostAllocationControl
FSM_GL_ST-FSM_AllocationControl-TrueCostConfiguration
FSM_GL_ST-FSM_AllocationLine-Active
FSM_GL_ST-FSM_AllocationLine-AllocateLifeToDate
FSM_GL_ST-FSM_AllocationLine-AutoReverse
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForAccount
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForAccountingUnit
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension1
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension10
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension2
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension3
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension4
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension5
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension6
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension7
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension8
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDimension9
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForDistinctDimensions
FSM_GL_ST-FSM_AllocationLine-ComputeOverridesForProject
FSM_GL_ST-FSM_AllocationLine-FromAllocationLineOverrideSet
FSM_GL_ST-FSM_AllocationLine-FromMultipleDimensionCompute
FSM_GL_ST-FSM_AllocationLine-FromOverrideOption
FSM_GL_ST-FSM_AllocationLine-FromOverrideSetDetailCompute
FSM_GL_ST-FSM_AllocationLine-FromOverrideSetOption
FSM_GL_ST-FSM_AllocationLine-ProcessAllPostingBalance
FSM_GL_ST-FSM_AllocationLine-SourceSystemCode
FSM_GL_ST-FSM_AllocationLine-ToAllocationLineOverrideSet
FSM_GL_ST-FSM_AllocationLine-ToMultipleDimensionCompute
FSM_GL_ST-FSM_AllocationLine-ToOverrideOption
FSM_GL_ST-FSM_AllocationLine-ToOverrideSetDetailCompute
FSM_GL_ST-FSM_AllocationLine-ToOverrideSetOption
FSM_GL_ST-FSM_AllocationLine-TreatBlankFromAccountAsEmpty
FSM_GL_ST-FSM_AllocationLine-TreatBlankToAccountAsEmpty
FSM_GL_ST-FSM_AllocationRun-AllocationSnapshot
FSM_GL_ST-FSM_AllocationRun-AutoReverseDate
FSM_GL_ST-FSM_AllocationRun-CollectingReconciliationData
FSM_GL_ST-FSM_AllocationRun-CostBehaviorSummaryStatusGenerated
FSM_GL_ST-FSM_AllocationRun-CostsStatus
FSM_GL_ST-FSM_AllocationRun-DirectActualsTotal
FSM_GL_ST-FSM_AllocationRun-DirectActualsWithCostObjects
FSM_GL_ST-FSM_AllocationRun-DirectCoreWithoutCostObjects
FSM_GL_ST-FSM_AllocationRun-ErrorMessage
FSM_GL_ST-FSM_AllocationRun-IndirectCoreWithCostObjects
FSM_GL_ST-FSM_AllocationRun-IndirectCoreWithoutCostObjects
FSM_GL_ST-FSM_AllocationRun-MultiMonthAllocation
FSM_GL_ST-FSM_AllocationRun-PublishForBirstReport
FSM_GL_ST-FSM_AllocationRun-ReverseOriginalJournal
FSM_GL_ST-FSM_AllocationRun-RunDescription
FSM_GL_ST-FSM_AllocationRun-RunEndDate
FSM_GL_ST-FSM_AllocationRun-RunName
FSM_GL_ST-FSM_AllocationRun-RunStartDate
FSM_GL_ST-FSM_AllocationRun-TotalsCalculated
FSM_GL_ST-FSM_AllocationRun-TrueCostConfiguration
FSM_GL_ST-FSM_AllocationRun-UnitCostDriver
FSM_GL_ST-FSM_AllocationSnapshot-AllocationPeriod
FSM_GL_ST-FSM_AllocationSnapshot-AllocationSnapshot
FSM_GL_ST-FSM_AllocationSnapshot-AllocationSourceSystem
FSM_GL_ST-FSM_AllocationSnapshot-Calendar
FSM_GL_ST-FSM_AllocationSnapshot-DateCreated
FSM_GL_ST-FSM_AllocationSnapshot-FinanceEnterpriseGroup
FSM_GL_ST-FSM_AllocationSnapshot-LastCounter
FSM_GL_ST-FSM_AllocationSnapshot-Ledger
FSM_GL_ST-FSM_AllocationSnapshot-Scenario
FSM_GL_ST-FSM_AllocationSnapshot-Status
FSM_GL_ST-FSM_AllocationSnapshot-UniqueID
FSM_GL_ST-FSM_AllocationSnapshot-create stamp
FSM_GL_ST-FSM_AllocationSnapshot-update stamp
FSM_GL_ST-FSM_AllocationSnapshotDetail-AllocationSnapshot
FSM_GL_ST-FSM_AllocationSnapshotDetail-AllocationSnapshotDetail
FSM_GL_ST-FSM_AllocationSnapshotDetail-AllocationSourceSystem
FSM_GL_ST-FSM_AllocationSnapshotDetail-CurrencyCode
FSM_GL_ST-FSM_AllocationSnapshotDetail-EntityYearPeriod
FSM_GL_ST-FSM_AllocationSnapshotDetail-FinanceCodeBlock
FSM_GL_ST-FSM_AllocationSnapshotDetail-FinanceEnterpriseGroup
FSM_GL_ST-FSM_AllocationSnapshotDetail-ReportCurrencyAmount
FSM_GL_ST-FSM_AllocationSnapshotDetail-System
FSM_GL_ST-FSM_AllocationSnapshotDetail-TransactionAmount
FSM_GL_ST-FSM_AllocationSnapshotDetail-UniqueID
FSM_GL_ST-FSM_AllocationSnapshotDetail-UnitsAmount
FSM_GL_ST-FSM_AllocationSnapshotDetail-create stamp
FSM_GL_ST-FSM_AllocationSnapshotDetail-update stamp
FSM_GL_ST-FSM_AllocationTransactionDetail-AutoReverse
FSM_GL_ST-FSM_AllocationTransactionDetail-FromPreviousStep
FSM_GL_ST-FSM_FinanceEnterpriseGroup-AllBalanceSheetAccounts
FSM_GL_ST-FSM_FinanceEnterpriseGroup-AutoReverseWithinSamePeriod
FSM_GL_ST-FSM_FinanceEnterpriseGroup-BypassCubeRefreshOnPost
FSM_GL_ST-FSM_FinanceEnterpriseGroup-FundAccounting
FSM_GL_ST-FSM_FinanceEnterpriseGroup-FundDimension
FSM_GL_ST-FSM_FinanceEnterpriseGroup-IncludeUREInAverageDailyBalance
FSM_GL_ST-FSM_FinanceEnterpriseGroup-NettingJournalApproval
FSM_GL_ST-FSM_FinanceEnterpriseGroup-ProjectBurdenDate
FSM_GL_ST-FSM_FinanceEnterpriseGroup-ThirdPartyInvoicePrint
FSM_GL_ST-FSM_ProjectContractInvoice-CertificationDate
FSM_GL_ST-FSM_ProjectContractInvoice-CertificationNumber
FSM_GL_ST-FSM_ProjectContractInvoice-EmailCount
FSM_GL_ST-FSM_ProjectContractInvoice-PrintStatus
FSM_GL_ST-FSM_ProjectContractInvoice-RetainageInvoice
FSM_GL_ST-FSM_ProjectContractInvoice-TotalAdjustment
FSM_GL_ST-FSM_ProjectContractInvoice-TotalAdvance
FSM_GL_ST-FSM_ProjectContractInvoice-TotalAllowance
FSM_GL_ST-FSM_ProjectContractInvoice-TotalFees
FSM_GL_ST-FSM_ProjectContractInvoice-TotalInvoiceAmount
FSM_GL_ST-FSM_ProjectContractInvoice-TotalPassThrough
FSM_GL_ST-FSM_ProjectContractInvoice-TotalRetainage
FSM_GL_ST-FSM_ProjectContractInvoice-TotalRetainedTax
FSM_GL_ST-FSM_ProjectContractInvoice-TotalRetainer
FSM_GL_ST-FSM_ProjectContractInvoice-TotalTax
FSM_GL_ST-FSM_ProjectContractInvoice-TotalUnits
FSM_IC_ST-FSM_Item-ClinicalSystemUse
FSM_IC_ST-FSM_Item-ConsignCode
FSM_IC_ST-FSM_Item-Discontinued
FSM_IC_ST-FSM_Item-HSNSACCode
FSM_IC_ST-FSM_Item-Item_CreateStamp
FSM_IC_ST-FSM_Item-Item_UpdateStamp
FSM_IC_ST-FSM_Item-MajorPPEClass
FSM_IC_ST-FSM_Item-MinorPPEClass
FSM_IC_ST-FSM_Item-NotAvailableForUse
FSM_IC_ST-FSM_Item-UDITracked
FSM_IC_ST-FSM_Item-UOMConversion
Removed the ProjectDateRange field from FSM_GL_ST-FSM_Project. ProjectDateRange.BeginDate and ProjectDateRange.EndDate already existed in the rep set with Replicate Names: Begin Date and End Date
Use this information to test the enhancement:
- Verify that the new replication classes and fields have been added.
Important note: The new business classes must be registered and the FSM_IMS connection point must be updated.
- In FSM Admin Console, select the replication sets that begin with FSM_ and end with _ST and click Validate Schemas.
- Wait for a minute. Select each replication set that has a red ! in front of the rep set
name and click Register Out Of Data Schemas.
Note that schema registration is not necessary for the Columnar Replication Sets, which have names that begin with "FSM_COLUMNAR_".
- Go to ION Desk > Connect > Data Flows > Connection points > FSM_IMS and click the refresh icon to add the new business classes.
- Go to ION Desk > Connect > Document flows and add the new business class. Reactivate the Document flow after the new business classes have been added.
Dependencies:
FSM Birst Analytics content
JT-1548279