Tables [dbo].[FMH_Order_Detail]
Links Achieve Order ID to TW Order ID. Value in PlanItemID is used to retrieve order details to be submitted during sp call FileResult_CMS or when submitting an achieve error task (IDX_Task)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_FMH_Order_Detail_PlanItemID: PlanItemIDForeign Keys FK_FMH_Order_Detail_PlanItemID: [dbo].[Item_Plan].PlanItemIDPlanItemID[dbo].[uniqueid]9NOT NULL((0))Touchworks Order. Link to Item_Plan.ID
AchieveOrderIDvarchar(70)70NOT NULL('')Achieve order ID, configured in FMH