Information Systems:Panel Values
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