Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Reconciled_List_Item
Touchworks 25.2
[dbo].[Reconciled_List_Item]
MS_Description
Data relating the Reconciled_List to the associated individual Orders
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ReconciledListID
[dbo].[uniqueid]
9
NOT NULL
Reconciled List. Link to Reconciled_List.ID
ItemID
[dbo].[uniqueid]
9
NOT NULL
Parent Item ID for the Order i.e Item_Medication.ID
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Detail ID for the Order i.e Medication.ID
ItemType
char(2)
2
NOT NULL
Item Type i.e. ME,AL