Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.FMH_Order_Detail
Touchworks 25.2
[dbo].[FMH_Order_Detail]
MS_Description
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)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
PlanItemID
[dbo].[uniqueid]
9
NOT NULL
((0))
Touchworks Order. Link to Item_Plan.ID
AchieveOrderID
varchar(70)
70
NOT NULL
('')
Achieve order ID, configured in FMH