Tables [dbo].[Reconciled_List_Item]
Data relating the Reconciled_List to the associated individual Orders
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key cix_Reconciled_List_Item_ReconciledListIDItemID: ReconciledListID\ItemIDForeign Keys FK_Reconciled_List_Item_Reconciled_List: [dbo].[Reconciled_List].ReconciledListIDReconciledListID[dbo].[uniqueid]9NOT NULLReconciled List. Link to Reconciled_List.ID
Cluster Key cix_Reconciled_List_Item_ReconciledListIDItemID: ReconciledListID\ItemIDItemID[dbo].[uniqueid]9NOT NULLParent Item ID for the Order i.e Item_Medication.ID
ItemChildID[dbo].[uniqueid]9NOT NULLDetail ID for the Order i.e Medication.ID
ItemTypechar(2)2NOT NULLItem Type i.e. ME,AL