Difference between revisions of "Database Views"

Latest revision as of 19:06, 10 October 2014

Views used by application.

VIEW	Description
VIEW_AUTO_LABELLER_PRINTER	Used by the Interface module to monitor any changes to the process orders assigned to Auto Labelling Lines.
VIEW_PALLET_EXPIRY	Used by Pallet Enquiries and Pallet Label Reports
VIEW_PALLET_HISTORY_EXPIRY	Used by Pallet History Enquiries
VIEW_QM_RESULTS	Used by the Quality Module to return sample results.

@@ Line 1: / Line 1: @@
-`view_auto_labeller_printer`
+Views used by application.
-`view_pallet_expiry`
-`view_pallet_history_expiry`
-`view_qm_results`
 {| class="wikitable"
 |-
 ! VIEW
-! Role
 ! Description
 |-
-| view_auto_labeller_printer
+| VIEW_AUTO_LABELLER_PRINTER
-| spare
+| Used by the Interface module to monitor any changes to the process orders assigned to Auto Labelling Lines.
-| 10.62.255.115
 |-
-| view_pallet_expiry
+| VIEW_PALLET_EXPIRY
-| Wisbech Purina & Wincanton
+| Used by Pallet Enquiries and Pallet Label Reports
-| 10.62.255.116
 |-
-| view_pallet_history_expiry
+| VIEW_PALLET_HISTORY_EXPIRY
-| spare
+| Used by Pallet History Enquiries
-| 10.62.255.201
+|-
+| VIEW_QM_RESULTS
+| Used by the Quality Module to return sample results.
 |-
-| view_qm_results
-| Wisbech Purina & Wincanton
-| 10.62.255.116
 |}