Tables [dbo].[Order_Document_Mapper]
Table for linking documents to orders.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_Order_Document_Mapper_OrderActivityHeaderID: OrderActivityHeaderID\PlanItemIDForeign Keys FK_Order_Document_Mapper_OrderActivityHeaderID: [dbo].[Order_Activity_Header].OrderActivityHeaderIDOrderActivityHeaderID[dbo].[uniqueid]9NOT NULLKey to the Order_Activity_Header table
Primary Key PK_Order_Document_Mapper_OriginatingDocuemntID_PlanItemID: OriginatingDocumentID\PlanItemIDForeign Keys FK_Order_Document_Mapper_OriginatingDocumentID: [dbo].[Document].OriginatingDocumentIDOriginatingDocumentID[dbo].[uniqueid]9NOT NULLKey to the Document table. This points to the first version of the document.
Primary Key PK_Order_Document_Mapper_OriginatingDocuemntID_PlanItemID: OriginatingDocumentID\PlanItemIDCluster Key CIX_Order_Document_Mapper_OrderActivityHeaderID: OrderActivityHeaderID\PlanItemIDForeign Keys FK_Order_Document_Mapper_PlanItemID_Plan_Item_ID: [dbo].[Plan_Item].PlanItemIDPlanItemID[dbo].[uniqueid]9NOT NULLOrder level instace id.Link to Plan_Item.ID
DocumentID[dbo].[uniqueid]9NOT NULLAttached version of DocumentID. Link to Document.DocumentID
Check Constraints CK_Order_Document_Mapper_IsDocumentLinkedtoResult_Yes_Or_No : ([IsDocumentLinkedtoResult]='N' OR [IsDocumentLinkedtoResult]='Y')IsDocumentLinkedtoResult[dbo].[BOOL]1NOT NULL('N')Holds value Y or N. Y indicates attached document is considered as Result.
N indicates attached documents are considered as Additional documentation.
Check Constraints CK_Order_Document_Mapper_IsDocumentRemovedFLAG_Yes_Or_No : ([IsDocumentRemovedFLAG]='N' OR [IsDocumentRemovedFLAG]='Y')IsDocumentRemovedFLAG[dbo].[BOOL]1NOT NULL('N')Holds value Y or N.
Y indicates attached document is removed.