R5.08 Technical

Release 5.08 Technical Notes

0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 5.08  Jan 01, 2013                      rel_5.08.doc 
0003.00       (Name in parenthesis is person who had the idea for the change)  
0004.00 -----------------------------------------------------------------------
0005.00                                                                        
0006.00 01) K3S_ADDSCD - This program will now 'add' the job K3S_5UPDPR during 
0007.00                  the conversion process.  This job downloads the       
0008.00                  GUI updates from FTP.K3S.COM                          
0009.00                                                                        
0010.00                  (Metrics)                                              
0011.00 02) K3S_BCKFIL - One time use program to back fill metrics             
0012.00                  data. This runs on just one period at a time, and     
0013.00                  thus can be called multiple times to populate         
0014.00                  multiple completed periods.                           
0015.00                                                                        
0016.00                  (Metrics)                                              
0017.00 03) K3S_BUYMET - Write last period stats by buyer to K_BUYRMET file.   
0018.00                                
0019.00 04) K3S_CVRT22 - Changes to table code records/New table code records: 
0020.00    
0021.00                     APP Application codes                              
0022.00                                                                        
0023.00                          F1=HELP   ENABLE                              
0024.00                              Enable F1=Help?                           
0025.00                                                                        
0026.00                          K3S_0010  F06ALLOW                            
0027.00                              New tablcode to allow F6 access to Metrics
0028.00                                                                        
0029.00                          K3S_1010  OCT_FILTER                          
0030.00                               Order Cycle Type filter?                 
0031.00                                                                        
0032.00                          K3S_1010  OSV_8_ALL                           
0033.00                               Display by supplier name/location        
0034.00                                                  (total company)       
0035.00                                                                         
0036.00                          K3S_1040  FLIP                                
0037.00                               Flip the Demand block and Days block     
0038.00                                                              for GUI?  
0039.00                                                                        
0040.00                          K3S_3016  DEFAULT_C                           
0041.00                               Default entry type to -C- Copy?          
0042.00                                                                        
0043.00                          K3S_8000  CURSOR_POS                          
0044.00                               Start cursor at sub-file?                
0045.00                                                                         
0046.00                          K3S_8011  GET_COST                            
0047.00                               Get transfer cost from external cost     
0048.00                                                                         
0049.00                          K3S_9010  NEW_SLOW                            
0050.00                               Added capability to default average      
0051.00                               by setting Flag2=1, and placing          
0052.00                               default average into Number2 field.      
0053.00                                                                        
0054.00                     OCT Order cycle types                               
0055.00                               0  Order Cycle not set up                
0056.00                               1  Order Cycle established               
0057.00                               2  Order Cycle over 6 months old         
0058.00                               3  Order Cycle over 12 months old        
0059.00                               4  Order Cycle over 24 months old        
0060.00                                                                        
0061.00                     PIR Product Interface Log                          
0062.00                               New type 'h' Non-stock products          

0063.00                                                                        
0064.00                     RET K_DLYSVCE                                      
0065.00                             New RET tablecode record to have records   
0066.00                             older than 365 days deleted from the system
0067.00                                                                         
0068.00                     RET K_INVPROD                                      
0069.00                             New RET tablecode record to have records   
0070.00                             older than 365 days deleted from the system
0071.00                                                                        
0072.00                     RET K_INVSUPL                                      
0073.00                             New RET tablecode record to have records   
0074.00                             older than 365 days deleted from the system
0075.00                                                                        
0076.00                     SPR Selected records review types                   
0077.00                              ND1  No demand for 1 year                 
0078.00                              ND2  No demand for 2 years                
0079.00                              ND3  No demand for 3 years                 
0080.00                                                                        
0081.00                     TLE Title of screens                               
0082.00                              K3S_0101FM1R - Metrics Main Menu          
0083.00                                                                         

0084.00 05) K3S_ENDQCM - Part of the K3S GUI update job to                     
0085.00                  end jobs in QCMN.                                     
0086.00                  This should ultimately reside in QGPL/QCLSRC if       
0087.00                  a customer ends up using K3S GUI and the              
0088.00                  K3S_5UPDPR scheduled job.                             
0089.00                                                                         
0090.00 06) K3S_GETALT - Get alternate source offerings (shell program)        
0091.00                                                                        
0092.00                  (Metrics)                                              
0093.00 07) K3S_INVALL - Run all inventory analysis programs 4 last prd        
0094.00     K3S_INVBYR - Write period statistics by BUYR to K_INVBUYR          
0095.00     K3S_INVCMP - Write period statistics by COMP to K_INVCOMP          
0096.00     K3S_INVLCN - Write period statistics by LOCN to K_INVLOCN          
0097.00     K3S_INVPRD - Write period statistics by PROD to K_INVPROD          
0098.00     K3S_INVSPL - Write period statistics by SUPL to K_INVSUPL           
0099.00     K3S_INXALL - Run all inventory analysis programs 4 last prd        
0100.00     K3S_INXBYR - Choose period for stats by BUYR to K_INVBUYR          
0101.00     K3S_INXLCN - Write last period stats by LOCN to K_INVLOCN          
0102.00     K3S_INXPRD - Write last period stats by PROD to K_INVPROD          
0103.00     K3S_INXSPL - Write last period stats by SUPL to K_INVSUPL          
0104.00                                                                        
0105.00                  (Brantley @ K3S)                                      
0106.00 08) K3S_LSTORD - New program to be called from K3S_1021CL, and         
0107.00                  enables the email of the Supplier Suggested           
0108.00                  Order List using MMAIL.                               
0109.00                                                                        
0110.00                  (Brantley @ K3S)                                      
0111.00 09) K3S_NIGHT  - Added statement to remove the customer's library      
0112.00                  from the library list before the SBMJOB.              
0113.00                                                                        
0114.00                  (Metrics)                                              
0115.00 10) K3S_PRDQRY - Sequence K_INTPROD by chosen field using OPNQRYF      
0116.00                                                                        
0117.00 11) K3S_PRSGET - Part of the K3S GUI update job to                      
0118.00                  get the updatates for K3S GUI and Presto from         
0119.00                  FTP.K3S.COM                                           
0120.00                  This should ultimately reside in QGPL/QCLSRC if       
0121.00                  a customer ends up using K3S GUI and the              
0122.00                  K3S_5UPDPR scheduled job.                             
0123.00                                                                        
0124.00 12) K3S_PRSIN  - Part of the K3S GUI update job which will             
0125.00                  hold the FTP input.                                   

0126.00                  This should ultimately reside in QGPL/QCLSRC if       
0127.00                  a customer ends up using K3S GUI and the              
0128.00                  K3S_5UPDPR scheduled job.                             
0129.00                                                                        
0130.00 13) K3S_PRSOUT - Part of the K3S GUI update job which will             
0131.00                  hold the FTP output.                                  
0132.00                  This should ultimately reside in QGPL/QCLSRC if       
0133.00                  a customer ends up using K3S GUI and the              
0134.00                  K3S_5UPDPR scheduled job.                             
0135.00                                                                        
0136.00 14) K3S_RESTOR - Part of the K3S GUI update job to                      
0137.00                  restore the updates for K3S GUI and Presto.           
0138.00                  This should ultimately reside in QGPL/QCLSRC if       
0139.00                  a customer ends up using K3S GUI and the               
0140.00                  K3S_5UPDPR scheduled job.                             
0141.00                                                                        
0142.00                  (Metrics)                                             
0143.00 15) K3S_SELREC - Changes made as part of enhanments for                
0144.00                  Metrics. DS_BIRTH descending.                         
0145.00                                                                        
0146.00                  (Metrics)                                             

0147.00 16) K3S_SPLQRY - Sequence K_INVSUPL by chosen field using OPNQRYF      
0148.00                                                                        
0149.00                  (Metrics)                                             
0150.00 17) K3S_USRMET - Write last period stats by User to K_USERMET          
0151.00                                                                        
0152.00 18) K3S_X310CL - Added statements which will run the necessary         
0153.00                  pieces to collect data for Metrics.                   
0154.00                  These will need to be un-commented in order to        
0155.00                  turn on data collection.                               
0156.00                                                                        
0157.00 19) K3S_0010   - Logic to control display of Metrics information       
0158.00     K3S_0010FM - Display new Release info R5.08 January 1st, 2013      
0159.00                                                                        
0160.00                  (Tim @ K3S)                                           
0161.00 20) K3S_0031   - Ranking Reports Menu fix. User was able to            
0162.00                  press ENTER without a valid report option             
0163.00                  entered. All valid report options now edited.         
0164.00                                                                        
0165.00                  (Metrics)                                             
0166.00 21) K3S_0100   - Period performance statistics by buyer                
0167.00     K3S_0100FM - Period performance statistics by buyer                

0168.00     K3S_0101   - Metrics Main Menu                                     
0169.00     K3S_0101FM - Metrics Main Menu                                     
0170.00     K3S_0110   - Period performance statistics by company              
0171.00     K3S_0110FM - Period performance statistics by company              
0172.00     K3S_0120   - Period performance statistics by locations            
0173.00     K3S_0120FM - Period performance statistics by locations            
0174.00     K3S_0130   - Period performance statistics by suppliers            
0175.00     K3S_0130FM - Period performance statistics by suppliers            
0176.00     K3S_0140   - Period performance statistics by products             
0177.00     K3S_0140FM - Period performance statistics by products              
0178.00     K3S_0150   - User Metrics Display                                  
0179.00     K3S_0150FM - User Metrics Display                                  
0180.00     K3S_0160   - Buy Group Metrics Display                             
0181.00     K3S_0160FM - Buy Group Metrics Display                             
0182.00                                                                        
0183.00                  (Allen @ House-Hasson Hardware)                       
0184.00 22) K3S_1010   - New capability to display all suggested orders by     
0185.00     K3S_1010FM   Supplier Name. A new logical file K_SUPLSOQL is       
0186.00                  added in this release. A new APP record labeled       
0187.00                  'K3S_1010  OSV_8_ALL' is used to set on this          
0188.00                  capability.                                           

0189.00                  (Tracy @ JT Davenport)                                
0190.00                - Added capability to drill down by supplier sub code,  
0191.00                  enabling Store Level users to view specific           
0192.00                  commodity groups.                                     
0193.00                  (K3S enhancement)                                      
0194.00                - Added capability to display suggested orders by new   
0195.00                  Order Cycle Type, which is a filter on the list.      
0196.00                  APP record 'K3S_1010  OCT_FILTER' controls new logic. 
0197.00                                                                        
0198.00                  (Tracy @ JT Davenport)                                
0199.00 23) K3S_1015   - Added capability to drill down by supplier sub code,  
0200.00                  enabling Store Level users to view specific           
0201.00                  commodity groups.                                     
0202.00                                                                        
0203.00 24) K3S_1021CL - Supplier suggested order list option, moves from      
0204.00                  K3S_5OBJ to K3S_5MOD in this release. It now contains 
0205.00                  logic to make it possible for emailing list through   
0206.00                  MMAIL tool.                                           
0207.00                                                                        
0208.00                  (Debbie @ Variety Wholesalers)                        
0209.00 25) K3S_1040   - Provided a new APP record that will enable a customer 

0210.00     K3S_1040FM   to flip the Demand block and Days block to match      
0211.00     K3S_1041     the green screen order.  APP 'K3S_1040  FLIP'         
0212.00     K3S_1041FM                                                          
0213.00                                                                        
0214.00                  (K3S)                                                 
0215.00 26) K3S_1500   - New Order Cycle Filter logic installed.               
0216.00                  (Wayne @ Liberty USA)                                 
0217.00                - Enhancement from R5.06 needed a fix.                  
0218.00                    -the enhancement was:                                
0219.00                  New capability to have $0 cost products within a      
0220.00                  supplier line, that all use Man Min/Max, and then     
0221.00                  also set supplier to Fixed Cycle, to have the         
0222.00                  Fixed Cycle date automatically advance, without       
0223.00                  having to F5=Approve order.                           
0224.00                    -the fix is:                                        
0225.00                  Ensure the entire supplier line has $0 cost products, 
0226.00                  and all using Man Min/Max (not a portion of supl line)
0227.00                                                                        
0228.00                  (Leanne @ JL Gaddy)                                   
0229.00 27) K3S_1900   - When using the Product Group splits (1 through 5),    
0230.00                  allow any entries, and don't edit against PGR type.   

0231.00                                                                         
0232.00 28) K3S_2000   - Fix allowing option 5 - By your criteria, to be       
0233.00                  used as the default for new suppliers.                
0234.00                - Adjustment when new supplier added, that the field    
0235.00                  SO_USERA1 is populated with a '1' for new sug order.  
0236.00                  (Tracy @ JT Davenport)                                
0237.00                - Added capability to drill down by supplier sub code,  
0238.00                  enabling Store Level users to view specific           
0239.00                  commodity groups.                                     
0240.00                                                                         
0241.00                  (K3S enhancement)                                     
0242.00 29) K3S_2004   - Ensure record written for update to order cycle       
0243.00                                                                        
0244.00                  (K3S enhancement)                                     
0245.00 30) K3S_2020   - For Daily Replenishment, enable Order Cycle to be     
0246.00     K3S_2020FM   entered with a value of 0.                            
0247.00                - For new records, default Saturday and Sunday to have  
0248.00                  values of 0 for Order Cycle and Lead Time.            
0249.00                                                                        
0250.00                  (K3S enhancement)                                     
0251.00 31) K3S_2040   - Display the last date Order Cycle value was updated.  

0252.00     K3S_2040FM                                                         
0253.00                                                                         
0254.00                  (Gary @ SAS)                                          
0255.00 32) K3S_2070   - Found during training at SAS. Supplier sub-code       
0256.00     K3S_2070FM   was not allowing lower-case. Added CHECK(LC) to       
0257.00                  allow lower-case. No RPG change, just recompile.      
0258.00                                                                        
0259.00                  (Larry @ Les Schwab)                                   
0260.00 33) K3S_2100   - Suppliers Group 3 - Order Cycle update request.       
0261.00     K3S_2100FM   Shell program, can be used for customization          
0262.00     K3S_2110     at customer sites.                                    
0263.00     K3S_2110CL                                                         
0264.00                                                                        
0265.00                  (Pete @ Core Mark)                                    
0266.00 34) K3S_3000   - When buyer changes average, the System Status         
0267.00                  was not changing from 'N' to 'R','L' or 'S'.          
0268.00                  Also fixed was 'F2=Copy to all' when average          
0269.00                  adjusted and System Status was 'N'.                   
0270.00                  (Pete @ Core Mark)                                    
0271.00                - When in F21=Start mode, adjustments to the            
0272.00                  Units 6,7,8,9 Over-ride fields, were not              

0273.00                  updating the Current fields, which meant              
0274.00                  waiting for a night job. Now values update            
0275.00                  immediately, and can be used in today's               
0276.00                  suggested order.                                      
0277.00                  (K3S found)                                           
0278.00                - Mis-spelled word, 'msut' to 'must' for edit           
0279.00                  'Cost must be >= 0'.                                  
0280.00                                                                        
0281.00 35) K3S_3001   - Populate SO_USERA1 with '1' when new suggested        
0282.00                  order added.                                          
0283.00                                                                        
0284.00                  (FMP)                                                 
0285.00 36) K3S_3004   - Write non-stock products to K3S database from         
0286.00                  external source. Can be used for 'Special Orders'     
0287.00                                                                        
0288.00                  (Debbie @ K3S)                                        
0289.00 37) K3S_3007   - Column for 'Excl auto' did not display 0 value,       
0290.00     K3S_3007FM   only the 1 value. Now displays both 0 and 1 values    
0291.00                  to match database. No RPG changes made.               
0292.00                                                                        
0293.00                  (Mark @ Duncan Supply)                                

0294.00 38) K3S_3016   - When copy to all locations used, 1-Yes, the last      
0295.00                  location copied ended up on the display screen. Fix   
0296.00                  resets From/To locations to initial value.            
0297.00                  (Larry @ Les Schwab)                                   
0298.00                - New capability to default the entry screen for new    
0299.00                  records to be 'C' Copy, instead of 'D' Daily.         
0300.00                                                                         
0301.00                  (Brantley @ K3S)                                      
0302.00 39) K3S_3025   - Expanded 'Results' window so users no longer have     
0303.00     K3S_3025FM   to toggle to see all the data.                        
0304.00                - Included a 'Day total' column.                        
0305.00                - Included a weekly average to display for all          
0306.00                  forecast intervals, which makes comparisons easier    
0307.00                  for the user.                                         
0308.00                                                                        
0309.00                  (Larry @ Les Schwab Tires)                            
0310.00 40) K3S_3035   - Fix for Standard Deviation method when going into     
0311.00                  Create New Profile. DEVP value tested to be 0, and    
0312.00                  if so default with 20%. Value then passed to          
0313.00                  K3S_M080 for Exponential Smoothing.                   
0314.00                                                                        

0315.00                  (Brantley @ K3S)                                      
0316.00 41) K3S_3050   - Line count work field needed to be increased to       
0317.00     K3S_3050FM    allow for more subfile records.                      
0318.00                  (Tim @ K3S)                                           
0319.00                - When using Generate Entries function, the Supplier    
0320.00                   sub-code needed to allow Lower Case entry.           
0321.00                                                                        
0322.00                  (Brantley @ K3S)                                      
0323.00 42) K3S_3051   - Line count work field needed to be increased to       
0324.00                   allow for more subfile records.                      
0325.00                                                                        
0326.00                  (Brantley @ K3S)                                      
0327.00 43) K3S_3054   - Line count work field needed to be increased to       
0328.00                   allow for more subfile records.                      
0329.00                                                                         
0330.00                  (Larry @ Les Schwab)                                  
0331.00 44) K3S_3061   - Update all product lead times within a group.         
0332.00                  Developed for Les Schwab. Can be used as a            
0333.00                  shell program.                                        
0334.00                                                                        
0335.00                  (Lloyd @ Les Schwab)                                   

0336.00 45) K3S_3075   - Remove K_PRODLNK records that contain deleted         
0337.00                   suppliers.                                           
0338.00                                                                         
0339.00                  (Adam @ Modern Tire)                                  
0340.00 46) K3S_3090   - Added text for '*' Asterisk to gather all Supplier    
0341.00     K3S_3090FM   Sub-code values.                                       
0342.00                                                                        
0343.00                  (Larry @ Les Schwab)                                  
0344.00 47) K3S_3091   - Batches F8= Products to update request.               
0345.00     K3S_3091FM   Shell program, can be used for customization          
0346.00     K3S_3091CL   at customer sites.                                    
0347.00     K3S_3092                                                           
0348.00                                                                         
0349.00                  (Scott @ Parts Central)                               
0350.00 48) K3S_3110   - Added new capability for 3 batches:                   
0351.00                     ND1 - No demand in 1 year                          
0352.00                     ND2 - No demand in 2 years                         
0353.00                     ND3 - No demand in 3 years                         
0354.00                                                                         
0355.00                  (Adam @ Modern Tire)                                  
0356.00 49) K3S_3301   - When running both Ranking Report options 16 and 26,   

0357.00     K3S_3340     negative profit values were causing problems in the   
0358.00                  percentage calculations. Fix is to only accumulate    
0359.00                  positive profit values to determine percentage.       
0360.00                                                                         
0361.00                  (Brantley @ K3S)                                      
0362.00 50) K3S_3430   - Values less than 1% were not showing the decimal      
0363.00     K3S_3430FM   point. Changes made to make sure decimal point        
0364.00     K3S_3431     always shows. All adjustments were screen changes.    
0365.00     K3S_3431FM   No RPG changes required. Just recompiled.             
0366.00     K3S_3432                                                           
0367.00     K3S_3432FM                                                         
0368.00     K3S_3438                                                           
0369.00     K3S_3438FM                                                         
0370.00                                                                         
0371.00                  (K3S)                                                 
0372.00 51) K3S_3582   - Check product for demand in previous 3 years          
0373.00                                                                         
0374.00                  (Adam @ Modern Tire)                                  
0375.00 52) K3S_3711CL - Improved logic for 'Consolidated' Obsolete Products   
0376.00     K3S_3717     report, for multi-location environment.               
0377.00     K3S_3718                                                           

0378.00                                                                        
0379.00                  (Jonathan @ Resnick)                                   
0380.00 53) K3S_3900   - In Today's Agenda, the regular combined supplier      
0381.00                  parts should contain SO_USERA1, so they don't         
0382.00                  show up in the 'suppliers not set up' group.          
0383.00                  4 statements added for SO_USERA1 = '1'                
0384.00                                                                        
0385.00                  (Pete @ Core Mark)                                    
0386.00 54) K3S_6010   - Buyer was able to generate Supplier Note record       
0387.00     K3S_6020     that was missing Location ID and Supplier ID.         
0388.00     K3S_6020FM   Fix will keep that condition from re-occuring,        
0389.00                  since PARMs provided to K3S_6010 are now              
0390.00                  sent on to K3S_6020 with F6=Add process.              
0391.00                                                                        
0392.00                  (Ted @ Franklin Machine Products)                     
0393.00 55) K3S_8000   - Ability to have cursor start at Product ID versus     
0394.00     K3S_8000FM    the 1st record in sub-file. New APP record           
0395.00                   'K3S_8000  CURSOR_POS' will enable either choice.    
0396.00                                                                        
0397.00                  (Tim @ K3S)                                           
0398.00 56) K3S_8010   - F6=Add function not necessary. Remove from screen     

0399.00     K3S_8010FM    and also the F24= function list. No RPG changes      
0400.00                   required, just re-compile.                           
0401.00                                                                         
0402.00                  (Allen @ House-Hasson Hardware)                       
0403.00 57) K3S_8011   - Retrieve cost from external source. This enables      
0404.00     K3S_8011FM    cost to come from outside K3S database.              
0405.00     K3S_8011CL - Needed to control display of 'Excess..' label and     
0406.00                   value fields.                                        
0407.00                  (Adam  @ Modern Tire)                                 
0408.00                - Default Transfer Quantity limited to From Location    
0409.00                   onhand quantity.                                     
0410.00                                                                        
0411.00                  (Felicia @ Garland C Norris)                          
0412.00 58) K3S_9010   - Do not include products not yet received in the       
0413.00                  Count Days Out of Stock Logic.                        
0414.00                  (Larry @ Les Schwab Tires)                            
0415.00                - New capability to default average for products        
0416.00                  when APP record 'K3S_9010  NEW_SLOW' being used       
0417.00                  and Flag2=1, by placing default average into          
0418.00                  Number2 field.                                        
0419.00                                                                        

0420.00                  (Larry @ Les Schwab Tires)                             
0421.00 59) K3S_9011   - Day Time add of new products to K3S database will     
0422.00                  follow same path of K3S_9010 Nite Time logic, and     
0423.00                  use APP record 'K3S_9010  NEW_SLOW' to automatically  
0424.00                  set new products System Status to 'S' Slow.           
0425.00                  (Larry @ Les Schwab Tires)                            
0426.00                - New capability to default average for products        
0427.00                  when APP record 'K3S_9010  NEW_SLOW' being used       
0428.00                  and Flag2=1, by placing default average into          
0429.00                  Number2 field.                                        
0430.00                - Populate SO_USERA1 = '1'                              
0431.00                                                                        
0432.00                  (Brantley @ K3S)                                      
0433.00 60) K3S_9505   - Added 3 more files (K_INVPROD,K_INVSUPL,K_DLYSVCE)    
0434.00                  to check for deletion based upon how old the          
0435.00                  records are.                                          
0436.00                                                                         
0437.00 -----------------------------------------------------------------------
0438.00 Physical & logical files added/changed during this release in K3S_5DTA 
0439.00 -----------------------------------------------------------------------
0440.00                                                                        

0441.00 There were 19 Physical & Logical files changed in this release.        
0442.00                                                                        
0443.00 K_INVBUYR  - Average inventory statistics for buyers                   
0444.00 K_INVBUYRA - Average inventory by LOCN,FCINT,YR,PRD,BUYR               
0445.00 K_INVBUYRB - Average inventory by LOCN,BUYR,FCINT,YR,PRD               
0446.00 K_INVBUYRC - Average inventory by LOCN,FCINT,BUYR,YR,PRD               
0447.00 K_INVBUYRD - Average inventory by BUYR,LOCN,FCINT,YR,PRD               
0448.00 K_INVBUYRE - Average inventory by FCINT,BUYR,LOCN,YR,PRD               
0449.00 K_INVCOMP  - Average inventory statistics for the company              
0450.00 K_INVCOMPA - Average inventory by FCINT,YR,PRD                         
0451.00 K_INVCOMPB - Average inventory by YEAR,PERD,FCINT                      
0452.00 K_INVLOCN  - Average inventory statistics for locations                
0453.00 K_INVLOCNA - Average inventory by LOCN,FCINT,YR,PRD                    
0454.00 K_INVLOCNB - Average inventory by LOCN,YR,FCINT,PRD                    
0455.00 K_INVLOCNC - Average inventory by YR,FCINT,LOCN,PRD                    
0456.00 K_INVLOCND - Average inventory by FCINT,LOCN,YR,PRD                    
0457.00 K_INVPROD  - Average inventory statistics for products                 
0458.00 K_INVPRODA - Average inventory by LOCN,FCINT,YR,PRD,BUYR,SUPL          
0459.00 K_INVPRODB - Average inventory by FCINT,YR,PRD                         
0460.00 K_INVSUPL  - Average inventory statistics for suppliers                
0461.00 K_INVSUPLA - Average inventory by LOCN,FCINT,YR,PRD,BUYR,SUPL           

0462.00                                                                        
0463.00 There were 14 Physical & Logical files added in this release.          
0464.00                                                                        
0465.00 K_BUYRMET  - Buy Group Metrics file                                    
0466.00 K_BUYRMETA - Buy Group Metrics file - by Buy Group, Year, Month        
0467.00 K_INVPRODC - Average inventory by LOCN,PROD,SUPL,BUYR,FCINT,YR,PRD     
0468.00 K_INVSUPLB - Average inventory by BUYR,LOCN,FCINT,YEAR,PERD            
0469.00 K_INVSUPLC - Average inventory by LOCN,SUPL,BUYR,FCINT,YEAR,PERD       
0470.00 K_PRODAPPB - Product appr/adj orders by YEAR,MONTH,BUYR,USER,PO#       
0471.00 K_PRODSEBB - Product Sel Rvw Hdr - STATUS,ACTBUYR,ACTUSER              
0472.00 K_SUPLAPVB - Supplier Approval Defaults by LOCN,SUPL,SUPLSUB           
0473.00 K_SUPLSOQL - Supplier Suggested Orders by NAME,LOCN                    
0474.00 K_SUPLSOQM - Supplier Suggested Orders by BUYR                         
0475.00 K_USERMET  - User Metrics file                                         
0476.00 K_USERMETA - User Metrics file by USER,BUYR,YEAR,MONTH                 
0477.00 K_USRMETS  - User Metrics Summary file                                  
0478.00 K_USRMETSA - User Metrics Summary file by YEAR,MONTH,POsAprv,USER      
0479.00                                                                        
0480.00 After this release installed,  there should be exactly 462 objects     
0481.00 in library K3S_5DTA (data files library) (Rel 5.07 had 448 objects)    
0482.00                                                                        

0483.00 -----------------------------------------------------------------------
0484.00 Special conditions for some customers                                  
0485.00 -----------------------------------------------------------------------
0486.00                                                                        
0487.00 Duncan - add back DPG - BUYERS  K3S_4031 - Product Group Service Level 
0488.00                                            Targets.                    
0489.00                                                                        
0490.00 -----------------------------------------------------------------------
0491.00 Programs and Files in library K3S_MOD508                               
0492.00 -----------------------------------------------------------------------
0493.00                                                                         
0494.00 -- RPGLE                                                               
0495.00 K3S_BUYMET   Write last period stats by buygroup to K_BUYRMET          
0496.00 K3S_CVRT22   New Table Code entries                                     
0497.00 K3S_INVALL   Run all inventory analysis programs                       
0498.00 K3S_INVBYR   Write period statistics by BUYR to K_INVBUYR              
0499.00 K3S_INVCMP   Write period statistics by COMP to K_INVCOMP               
0500.00 K3S_INVLCN   Write period statistics by LOCN to K_INVLOCN              
0501.00 K3S_INVPRD   Write period statistics by PROD to K_INVPROD              
0502.00 K3S_INVSPL   Write period statistics by SUPL to K_INVSUPL              
0503.00 K3S_INXALL   Choose period for all invent analysis programs            

0504.00 K3S_INXBYR   Choose period for stats by BUYR to K_INVBUYR              
0505.00 K3S_INXLCN   Choose period for stats by LOCN to K_INVLOCN              
0506.00 K3S_INXPRD   Choose period for stats by PROD to K_INVPROD              
0507.00 K3S_INXSPL   Choose period for stats by SUPL to K_INVSUPL              
0508.00 K3S_LSTORD   Email List Order from K3S_1010 screen                     
0509.00 K3S_USRMET   Write last period stats by USER to K_USERMET              
0510.00 K3S_2100     Suppliers group 3 - Order Cycle update request            
0511.00 K3S_2110     Suppliers group 3 - Order Cycle update process            
0512.00 K3S_3061     Update Product Lead Times via K_SUP1SRV                   
0513.00 K3S_3091     Batches F8= Products to update request                    
0514.00 K3S_3092     Batches F8= Products to update process                    
0515.00 K3S_3900     Add products to K3S-Replenish combined suppliers          
0516.00                                                                        
0517.00 -- CLLE                                                                
0518.00 K3S_BCKFIL   Back file metrics files at start up                        
0519.00 K3S_GETALT   Get alternate source entries into K_ALTSRC file           
0520.00 K3S_NIGHT    Starts night job by submitting K3S_NITECL                 
0521.00 K3S_PRDQRY   Sequence K_INVPROD by chosen field using OPNQRYF           
0522.00 K3S_PRSGET   K3S GUI. Get updates from FTP site                        
0523.00 K3S_PRSIN    K3S GUI. INPUT file                                       
0524.00 K3S_PRSOUT   K3S GUI. OUTPUT file                                      

0525.00 K3S_RESTOR   K3S GUI. Restore updates.                                 
0526.00 K3S_SELREC   Use OPNQRYF to select K_DLYSVCE rec to process            
0527.00 K3S_SPLQRY   Sequence K_INVSUPL by chosen field using OPNQRYF          
0528.00 K3S_X310CL   Exit - Before final program end.                          
0529.00 K3S_1021CL   Supplier suggested order list                             
0530.00 K3S_2110CL   Suppliers Group 3 - Order Cycle update process            
0531.00 K3S_3091CL   Batches F8= Products to update process                    
0532.00 K3S_8011CL   Get transfer cost from external source                    
0533.00                                                                        
0534.00 -- CMD                                                                  
0535.00 none                                                                   
0536.00                                                                        
0537.00 -- DSPF                                                                 
0538.00 K3S_2100FM   Suppliers group 3 - Order Cycle update request            
0539.00 K3S_3091FM   Batches F8= Products to update request                    
0540.00                                                                         
0541.00 -- PF                                                                  
0542.00 K_ALTSRC - Flat file to hold diverter offerings                        
0543.00                                                                        
0544.00 -----------------------------------------------------------------------
0545.00 Programs in library K3S_5CNV                                           

0546.00 -----------------------------------------------------------------------
0547.00                                                                         
0548.00 -- RPGLE                                                               
0549.00 none                                                                   
0550.00                                                                         
0551.00 -- CLLE                                                                
0552.00 none                                                                   
0553.00                                                                         
0554.00 -- CMD                                                                 
0555.00 none                                                                   
0556.00                                                                         
0557.00 -- DSPF                                                                
0558.00 none                                                                   
0559.00                                                                         
0560.00 -----------------------------------------------------------------------
0561.00 Implementation steps for this release                                  
0562.00 -----------------------------------------------------------------------
0563.00                                                                        
0564.00 K3S_X310CL holds source code for Metrics processing                    
0565.00                                                                        
0566.00 K3S_1021CL moves from K3S_5OBJ to K3S_5MOD in this release.            

0567.00                                                                        
0568.00 K3S_3900   4 statements added to populate SO_USERA1 = '1'              
0569.00