u s i n g   S y s t e m ; 
 
 u s i n g   S y s t e m . C o l l e c t i o n s . G e n e r i c ; 
 
 u s i n g   S y s t e m . C o m p o n e n t M o d e l ; 
 
 u s i n g   S y s t e m . C o m p o n e n t M o d e l . D a t a A n n o t a t i o n s ; 
 
 u s i n g   S y s t e m . C o m p o n e n t M o d e l . D a t a A n n o t a t i o n s . S c h e m a ; 
 
 u s i n g   S y s t e m . R u n t i m e . S e r i a l i z a t i o n ; 
 
 u s i n g   S n a p O b j e c t s . D a t a ; 
 
 u s i n g   D W N e t . D a t a ; 
 
 u s i n g   N e w t o n s o f t . J s o n ; 
 
 u s i n g   S y s t e m . C o l l e c t i o n s ; 
 
 
 
 n a m e s p a c e   L a n c e _ P S 
 
 { 
 
         [ D a t a W i n d o w ( " d _ r p t _ m a s _ l a b e l _ s v p _ d r u g " ,   D w S t y l e . D e f a u l t ) ] 
 
         # r e g i o n   D w S e l e c t A t t r i b u t e     
 
         [ D w S e l e c t ( " S E L E C T   s u b s t r ( t o _ c h a r ( I M A S T R A N S L O G . C A P S R X N B R ) , 1 , l e n g t h ( t o _ c h a r ( I M A S T R A N S L O G . C A P S R X N B R ) )   -   1 1 ) | | ' - ' | |   \ r \ n   " 
 
                                     + " t o _ c h a r ( t o _ n u m b e r ( s u b s t r ( t o _ c h a r ( I M A S T R A N S L O G . C A P S R X N B R ) , ( l e n g t h ( t o _ c h a r ( I M A S T R A N S L O G . C A P S R X N B R ) ) - 1 1 ) + 1 , 9 9 ) ) ) | | ' - ' | | t o _ c h a r ( I M A S T R A N S L O G . F I L L N B R ) | | ' - ' | | t o _ c h a r ( I M A S T R A N S L O G . D O S E N B R )   C A P S R X N B R ,   \ r \ n   " 
 
                                     + " T O _ C H A R ( I M A S T R A N S L O G . t r a n s n u m ) ,   \ r \ n   " 
 
                                     + " P A T I E N T . P A T I E N T L A S T N A M E | | ' ,   ' | | P A T I E N T . P A T I E N T F I R S T N A M E   P A T I E N T N A M E ,   \ r \ n   " 
 
                                     + " C U S T O M E R . C U S T C O D E ,   \ r \ n   " 
 
                                     + " t o _ c h a r ( I M A S T R A N S L O G . E N T D A T E , ' m m / d d / y y y y   h h 2 4 : m i ' ) ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D . D R A W N A M T ,   \ r \ n   " 
 
                                     + " I T E M D R U G . D R U G C O D E ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D . L O T N U M ,   \ r \ n   " 
 
                                     + " t o _ c h a r ( I M A S A D D G R I D . E X P R E , ' m m / d d / y y y y ' ) ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D . R O W C O L O R ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D . G R I D R O W N U M ,   \ r \ n   " 
 
                                     + " I M A S T R A N S L O G . H O O D ,   \ r \ n   " 
 
                                     + " M I X U S E R . F I R S T N A M E | | '   ' | | M I X U S E R . L A S T N A M E   M I X E D B Y ,   \ r \ n   " 
 
                                     + " P H A R M U S E R . F I R S T N A M E | | '   ' | | P H A R M U S E R . L A S T N A M E   V E R I F I E D B Y ,   \ r \ n   " 
 
                                     + " P H A R M U S E R . F I R S T N A M E | | '   ' | | P H A R M U S E R . L A S T N A M E   V I S U A L B Y ,   \ r \ n   " 
 
                                     + " P H A R M U S E R . F I R S T N A M E | | '   ' | | P H A R M U S E R . L A S T N A M E   C L E A R E D B Y ,   \ r \ n   " 
 
                                     + " M I X U S E R . F I R S T N A M E | | '   ' | | M I X U S E R . L A S T N A M E ,   \ r \ n   " 
 
                                     + " I M A S T R A N S L O G R E J E C T . R E A S O N ,   \ r \ n   " 
 
                                     + " t o _ c h a r ( I M A S T R A N S L O G . E N T D A T E   +   d e c o d e ( D R U G O R D E R . E X P I R A T I O N U O M , ' D A Y S ' , D R U G O R D E R . E X P I R A T I O N N B R   *   2 4 , D R U G O R D E R . E X P I R A T I O N N B R   ) /   2 4 , ' m m / d d / y y y y   h h 2 4 : m i ' )   E X P I R E S ,   \ r \ n   " 
 
                                     + " I T E M D R U G . D R U G N A M E ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D . D O S E A M T ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D . N D C C O D E ,   \ r \ n   " 
 
                                     + " S T O R A G E T E M P . D E S C R I P T I O N   \ r \ n   " 
 
                                     + " F R O M   I M A S T R A N S L O G ,   \ r \ n   " 
 
                                     + " I M A S A D D G R I D ,   \ r \ n   " 
 
                                     + " O R D E R B A S E ,   \ r \ n   " 
 
                                     + " d r u g o r d e r ,   \ r \ n   " 
 
                                     + " C U S T O M E R ,   \ r \ n   " 
 
                                     + " P A T I E N T ,   \ r \ n   " 
 
                                     + " I T E M D R U G ,   \ r \ n   " 
 
                                     + " C A P S U S E R   M I X U S E R ,   \ r \ n   " 
 
                                     + " C A P S U S E R   P H A R M U S E R ,   \ r \ n   " 
 
                                     + " I M A S T R A N S L O G R E J E C T ,   \ r \ n   " 
 
                                     + " I M A S S T A T U S ,   \ r \ n   " 
 
                                     + " S T O R A G E T E M P   \ r \ n   " 
 
                                     + " W H E R E   (   o r d e r b a s e . c a p s r x n b r   =   I M A S T R A N S L O G . c a p s r x n b r )   a n d   \ r \ n   " 
 
                                     + " (   o r d e r b a s e . c a p s r x n b r   =   d r u g o r d e r . c a p s r x n b r )   a n d   \ r \ n   " 
 
                                     + " (   c u s t o m e r . c u s t i d   =   o r d e r b a s e . c u s t i d   )   a n d   \ r \ n   " 
 
                                     + " (   p a t i e n t . p a t i e n t i d   =   o r d e r b a s e . p a t i e n t i d   )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . c a p s r x n b r   =   I M A S A D D G R I D . c a p s r x n b r   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . d o s e n b r   =   I M A S A D D G R I D . d o s e n b r   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . f i l l n b r   =   I M A S A D D G R I D . f i l l n b r   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . t r a n s n u m   =   I M A S A D D G R I D . t r a n s n u m   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S A D D G R I D . I T E M D R U G I D   =   I T E M D R U G . I T E M D R U G I D   )   A N D   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . D R A W N U S E R I D   =   M I X U S E R . C A P S U S E R I D   ( + )   )   A N D   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . P H A R M U S E R I D   =   P H A R M U S E R . C A P S U S E R I D   ( + )   )   A N D   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . c a p s r x n b r   =   I M A S T R A N S L O G R E J E C T . c a p s r x n b r   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . d o s e n b r   =   I M A S T R A N S L O G R E J E C T . d o s e n b r   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . f i l l n b r   =   I M A S T R A N S L O G R E J E C T . f i l l n b r   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . t r a n s n u m   =   I M A S T R A N S L O G R E J E C T . t r a n s n u m   ( + ) )   a n d   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . F L A V O R   =   ' S V P '   )   A N D   \ r \ n   " 
 
                                     + " (   D R U G O R D E R . S T O R A G E T E M P I D   =   S T O R A G E T E M P . S T O R A G E T E M P I D   )   A N D   \ r \ n   " 
 
                                     + " (   I M A S T R A N S L O G . S T A T U S I D   =   I M A S S T A T U S . S T A T U S I D   )   A N D   \ r \ n   " 
 
                                     + " (   I M A S S T A T U S . M N E M O N I C   i n   ( ' E N D ' , ' R E J E C T ' )   )     A N D   \ r \ n   " 
 
                                     + " I M A S T R A N S L O G . p h a r m a c y i d   =   : P _ P H A R M A C Y I D   a n d   \ r \ n   " 
 
                                     + " (   O r d e r B a s e . C u s t I d   l i k e   : P _ C U S T I D   )   a n d   \ r \ n   " 
 
                                     + " I M A S T R A N S L O G . E N T D A T E   > =   : P _ F R O M D A T E   a n d   \ r \ n   " 
 
                                     + " I M A S T R A N S L O G . E N T D A T E   < =   : P _ T H R O U G H D A T E " ) ] 
 
         # e n d r e g i o n 
 
         [ D w P a r a m e t e r ( " P _ P H A R M A C Y I D " ,   t y p e o f ( d o u b l e ? ) ) ] 
 
         [ D w P a r a m e t e r ( " P _ C U S T I D " ,   t y p e o f ( s t r i n g ) ) ] 
 
         [ D w P a r a m e t e r ( " P _ F R O M D A T E " ,   t y p e o f ( D a t e T i m e ? ) ) ] 
 
         [ D w P a r a m e t e r ( " P _ T H R O U G H D A T E " ,   t y p e o f ( D a t e T i m e ? ) ) ] 
 
         p u b l i c   c l a s s   D _ R p t _ M a s _ L a b e l _ S v p _ D r u g 
 
         { 
 
                 [ D w C o l u m n ( " c a p s r x n b r " ) ] 
 
                 p u b l i c   s t r i n g   C a p s r x n b r   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " t r a n s l o g m a " ,   " t r a n s n u m " ) ] 
 
                 p u b l i c   s t r i n g   T r a n s l o g m a _ T r a n s n u m   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " p a t i e n t n a m e " ) ] 
 
                 p u b l i c   s t r i n g   P a t i e n t n a m e   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " c u s t o m e r " ,   " c u s t c o d e " ) ] 
 
                 p u b l i c   s t r i n g   C u s t c o d e   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " d a t e e n t " ) ] 
 
                 p u b l i c   s t r i n g   D a t e e n t   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " d o s e a m t " ) ] 
 
                 p u b l i c   d o u b l e ?   D o s e a m t   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " d r u g c o d e " ) ] 
 
                 p u b l i c   s t r i n g   D r u g c o d e   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " l o t n u m " ) ] 
 
                 p u b l i c   s t r i n g   L o t n u m   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " e x p i r e s " ) ] 
 
                 p u b l i c   s t r i n g   E x p i r e s   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " r o w c o l o r " ) ] 
 
                 p u b l i c   s t r i n g   R o w c o l o r   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " g r i d r o w n u m " ) ] 
 
                 p u b l i c   d o u b l e ?   M a n a d d g r i d _ G r i d r o w n u m   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " t r a n s l o g m a " ,   " h o o d " ) ] 
 
                 p u b l i c   s t r i n g   H o o d   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " m i x e d b y " ) ] 
 
                 p u b l i c   s t r i n g   M i x e d b y   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " v e r i f i e d b y " ) ] 
 
                 p u b l i c   s t r i n g   V e r i f i e d b y   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " t r a n s l o g m a " ,   " v i s u a l b y " ) ] 
 
                 p u b l i c   s t r i n g   V i s u a l b y   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " t r a n s l o g m a " ,   " c l e a r e d b y " ) ] 
 
                 p u b l i c   s t r i n g   C l e a r e d b y   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m a n a d d g r i d " ,   " c a p s u s e r " ) ] 
 
                 p u b l i c   s t r i n g   T e c h u s e r _ C a p s u s e r   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " r e a s o n " ) ] 
 
                 p u b l i c   s t r i n g   R e a s o n   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " o r d e r e x p i r e s " ) ] 
 
                 p u b l i c   s t r i n g   O r d e r e x p i r e s   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " d r u g n a m e " ) ] 
 
                 p u b l i c   s t r i n g   D r u g n a m e   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " m i x a m t " ) ] 
 
                 p u b l i c   d o u b l e ?   M i x a m t   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " n d c c o d e " ) ] 
 
                 p u b l i c   s t r i n g   N d c c o d e   {   g e t ;   s e t ;   } 
 
 
 
                 [ D w C o l u m n ( " s t o r a g e t e m p " ) ] 
 
                 p u b l i c   s t r i n g   S t o r a g e t e m p   {   g e t ;   s e t ;   } 
 
 
 
         } 
 
 
 
 } 