Information Systems:Panel Values - Revision history

Sheilav at 21:21, 23 November 2015

2015-11-23T21:21:20Z

Sheilav at 21:20, 23 November 2015

2015-11-23T21:20:03Z

Sheilav at 21:14, 23 November 2015

2015-11-23T21:14:47Z

Sheilav: Created page with "=Panel Values= These are used in some ASW programs as selection codes for different values. For example, in ‘Sales Order Inquiry’, the one character fields before ‘doc..."

2015-11-23T21:08:54Z

Created page with "=Panel Values= These are used in some ASW programs as selection codes for different values. For example, in ‘Sales Order Inquiry’, the one character fields before ‘doc..."

New page

=Panel Values=

These are used in some ASW programs as selection codes for different values. For example, in ‘Sales Order Inquiry’, the one character fields before ‘document number’, ‘customer/supplier number’, ‘customer reference/order number’, and ‘shipment marking’ are codes that further define the value you are entering.

*VA/480B* Sales order enquiry 12/18/14 16:22:59 DMR12001
Order header
-------------------------------------------------------------------------------
O Ord. no Type Stat Handler Customer no Name Value CAD
_ 3240722 EO 20 EDI-TRIPOS 10533 MEMORIAL COMPOUNDIN 246.22
_ 3240721 EO 30 EDI-TRIPOS 10142 CENTRAL DRUG STORE 166.13
_ 3240720 WO 30 EDISO 10317 GLADWIN PHARMACY 476.95
_ 3240719 SP 20 ELIZAG 10846 REGENCY M.C. #2 74.68
_ 3240718 WO 30 EDISO 10734 PHARMASAVE #024 39.46
_ 3240717 EO 30 EDI-KROLL 11412 FRASER LAKE MEDICIN 59.40
_ 3240716 WO 30 EDISO 10418 KERRISDALE PHARMACY 66.16
_ 3240715 WO 30 EDISO 10847 REGENCY PRESCRIPTIO 988.90
_ 3240714 WO 30 EDISO 12125 AGASSIZ PHARMACY 17.16
_ 3240713 WO 30 EDISO 11047 SUPER GROCER & PHAR 42.36
_ 3240712 WO 30 EDISO 10139 CENTRAL DRUG STORE 57.88
More...
D St Doc nbr Cust/Supp nbr Item
H __ _ _______ _ ___________ ___________________________________
Whs Handler MOT OT Dsp dat range Dlv Credit card number
___ __________ ___ __ ______ ______ _ _________________________
Customer Ref/Ord no Shipment marking Batch BO
_ ____________________ _ ______________________________ _____________ _
F1=Shift info F6=View controls

For example, to find out what values can be used to indicate the type of document,

Key in a search argument of ‘panel’ and press enter.

*PL/480B* Table maintenance program selection 12/18/14 16:37:29 ASGD0181
-------------------------------------------------------------------------------
Appl Table
1 GEN Panel value control file

-------------------------------------------------------------------------------
Appl Search argument
___ ________________________

Select ‘Panel value control file’ and press enter.

*PL/480B* Panel value control file maintenance 12/18/14 16:32:23 ASGD1501
------------------------------------------------------------------------------
Subset.............. *ALL
------------------------------------------------------------------------------
Group Int val Description Database value
_ DOCTYPE I Invoice I
_ DOCTYPE N Requisition N
_ DOCTYPE O Order O
_ DOCTYPE P Pick list P
_ DOCTYPE R Reception note R
------------------------------------------------------------------------------
Group Int val Description search value App
DOCTYPE ______ ______________________________ ___
F1=Shift info F8=Select subset
Once you are in here, you will have to find what you’re looking for by using the ‘group’.
Adding a New Panel Value

To add a new item cross reference type, we have to add it to the ‘Item Cross Reference Type’ table (using option 81- table maintenance), and as a panel value.

In ‘Panel Value Control File Maintenance’, position to group ‘CROSREFTYP’.

*PL/480B* Panel value control file maintenance 12/18/14 16:46:57 ASGD1501
------------------------------------------------------------------------------
Subset.............. *ALL
------------------------------------------------------------------------------
Group Int val Description Database value
CROSREFTYP AL Alternative AL
CROSREFTYP BC Barcode BC
CROSREFTYP BN Bonus Item UPC BN
CROSREFTYP CO Competitor CO
CROSREFTYP CU Customer CU
CROSREFTYP GE Generic GE
CROSREFTYP IA Item code alias IA
CROSREFTYP MA Manufacturer MA
CROSREFTYP PR Prospect PR
CROSREFTYP RE Replacement RE
CROSREFTYP SU Substitute SU
CROSREFTYP VE Vendor/Supplier VE
------------------------------------------------------------------------------
Group Int val Description search value App

F1=Shift info F8=Select subset

We had to add ‘UP – Full UPC Code’. To do that, first look at an existing entry to see how it is set up.

*PL/480B* Panel value control file maintenance 10/23/06 16:28:22 ASGD1504
------------------------------------------------------------------------------
Group............... CROSREFTYP
Internal value...... IA
Description......... Item code alias

Database value...... IA

Reference field..... XRTY
Field length........ 2

Application code.... DIS
Identity............ 3772
Subset.............. *STDDELTA

Back on the list or panel values, press F6 to add a new value:

*PL/480B* Panel value control file maintenance 10/23/06 16:30:07 ASGD1504
------------------------------------------------------------------------------
Group............... CROSSREFTYP
Internal value...... UP
Description......... Full UPC Codes

Database value......

Reference field..... XRTY
Field length........

Application code.... DIS
Identity............ __________
Subset.............. *CUSTLOCAL

F7=Translate

‘Database value’ and ‘Field length’ cannot be filled in, but will be completed by the program. ‘Identity’ does not need to be completed.

Press F7 to make sure the language has been correctly set up.

*PL/480B* System translation file maintenance 10/23/06 16:34:58 ASTD3211
-------------------------------------------------------------------------------
System file......... SROCTLPV
Table key value..... Field-CROSREFTYP Value-UP
Field............... PVDESC Description
------------------------------------------------------------------------------
Language Translated value
EN Full UPC codes

-------------------------------------------------------------------------------

Press Enter.

- From Table Maintenance Program Selection, select ‘Languages’.

- Go into EN English

- Press enter again to get the Special Panel Value Translations screen.

- Select the entry you just added, and fill the field for Panel Value.

*PL/480B* Language table maintenance 10/23/06 16:51:13 ASGD1554
Special panel value translations
------------------------------------------------------------------------------
Language............ EN English
------------------------------------------------------------------------------

Group............... CROSREFTYP
Internal value...... UP
Panel value......... UP
Description......... Full UPC codes

Application code.... DIS
Identity............
Subset.............. *CUSTLOCAL

Reference field..... XRTY
Field length........ 2

Database value...... UP

@@ Line 41: / Line 41: @@
  _  DOCTYPE    P       Pick list                      P
  _  DOCTYPE    R       Reception note                 R
-------------------------------------------------------------------------------
+ ------------------------------------------------------------------------------
     Group      Int val Description search value       App
     DOCTYPE    ______  ______________________________ ___

@@ Line 50: / Line 50: @@
 ==Adding a New Panel Value==
-To add a new item cross reference type, we have to add it to the ‘Item Cross Reference Type’ table, and as a panel value.
+To add a new item cross reference type, we have to add it to the [[Table Maintenance Programs|‘Item Cross Reference Type’ table]], and as a panel value.
 In ‘Panel Value Control File Maintenance’, position to group ‘CROSREFTYP’.
@@ Line 75: / Line 75: @@
  F1=Shift info  F8=Select subset
 We had to add ‘UP – Full UPC Code’.  To do that, first look at an existing entry to see how it is set up.
-*PL/480B*  Panel value control file maintenance     10/23/06 16:28:22 ASGD1504
+ *PL/480B*  Panel value control file maintenance     10/23/06 16:28:22 ASGD1504
-------------------------------------------------------------------------------
+ ------------------------------------------------------------------------------
  Group............... CROSREFTYP
  Internal value...... IA
@@ Line 92: / Line 92: @@
  Identity............ 3772
  Subset.............. *STDDELTA
 Back on the list or panel values, press F6 to add a new value:
-*PL/480B*  Panel value control file maintenance     10/23/06 16:30:07 ASGD1504
+ *PL/480B*  Panel value control file maintenance     10/23/06 16:30:07 ASGD1504
-------------------------------------------------------------------------------
+ ------------------------------------------------------------------------------
  Group............... CROSSREFTYP
  Internal value...... UP
@@ Line 110: / Line 110: @@
  Subset.............. *CUSTLOCAL
-F7=Translate
+ F7=Translate
 ‘Database value’ and ‘Field length’ cannot be filled in, but will be completed by the program.  ‘Identity’ does not need to be completed.
@@ Line 124: / Line 124: @@
  Language  Translated value
    EN      Full UPC codes
  -------------------------------------------------------------------------------
 Press Enter.

@@ Line 27: / Line 27: @@
  F1=Shift info  F6=View controls
-For example, to find out what values can be used to indicate the type of document,
+For example, to find out what values can be used to indicate the type of document, go to the [[Table Maintenance Programs|maintenance program]] for 'Panel value control file'.
 Key in a search argument of ‘panel’ and press enter.
  *PL/480B*  Panel value control file maintenance     12/18/14 16:32:23 ASGD1501
@@ Line 55: / Line 44: @@
     Group      Int val Description search value       App
     DOCTYPE    ______  ______________________________ ___
  F1=Shift info  F8=Select subset
-Once you are in here, you will have to find what you’re looking for by using the ‘group’.
-To add a new item cross reference type, we have to add it to the ‘Item Cross Reference Type’ table (using option 81- table maintenance), and as a panel value.
+To add a new item cross reference type, we have to add it to the ‘Item Cross Reference Type’ table, and as a panel value.
 In ‘Panel Value Control File Maintenance’, position to group ‘CROSREFTYP’.