Release 5.1 Technical Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 5.1 Jan 01, 2014 rel_5.1.doc
0003.00 (Name in parenthesis is person who had the idea for the change)
0004.00 -----------------------------------------------------------------------
0005.00
0006.00 01) K3S_CVRT22 - Changes to table code records/New table code records:
0007.00
0008.00 APP Application codes
0009.00
0010.00 K3S_1020 OC_WARNING
0011.00 Turn off Order Cycle warning?
0012.00
0013.00 K3S_1040 LAST_21
0014.00 Description 3 text populated with:
0015.00 Control display using PR_USERA1=Y
0016.00 Flag3=1
0017.00
0018.00 K3S_1500 ALL_FROZEN
0019.00 Force order as Due for any product SOQ?
0020.00 All products in supplier are Frozen with
0021.00 Average 0
0022.00
0023.00 K3S_1500 SHUT_OFF
0024.00 Shut off SOQ when Factor=0 and
0025.00 Manl Min Unit > 0
0026.00 Number 1 field holds days to look ahead,
0027.00 maximum 15 days
0028.00
0029.00 K3S_3070 WEEKEND
0030.00 Turn off weekend activity default?
0031.00
0032.00 K3S_3600 PR_RFBIRTH
0033.00 Include Reference Birth in test?
0034.00 Flag2=1 to capture PR_RFBIRTH in K3s_9010
0035.00 Number 1 field contains number of days to test
0036.00
0037.00 K3S_8530 CPY_DEMAND
0038.00 Should demand be copied?
0039.00
0040.00 K3S_9010 CLR_PROMO
0041.00 Promo fields clear option?
0042.00 Clear Promotional Quantity,
0043.00 Begin date, and End date
0044.00 after expire
0045.00
0046.00 PE_WARNINGSYSTEM
0047.00 Turn off PE warning system?
0048.00
0049.00 STORE LEVEL
0050.00 Store Level switch on?
0051.00
0052.00 PSC Product Select codes
0053.00
0054.00 PE replaces CG (kept G as single)
0055.00 PE Period End checks PE1 thru PE5
0056.00 G Period End checks PE1 thru PE5
0057.00
0058.00 SPR Selected Products Review
0059.00
0060.00 OC All order cycle exceptions
0061.00 OC0 Order cycle not set up
0062.00 OC1 Order cycle established
0063.00 OC2 Order cycle over 6 months old
0064.00 OC3 Order cycle over 12 months old
0065.00 OC4 Order cycle over 24 months old
0066.00
0067.00 TLE Product Select codes
0068.00
0069.00 K3S_9259FM 1C - Daily Demand expanded
0070.00
0071.00 YSP Your space
0072.00
0073.00 K3S_8000 2 - All locations for a product 2 of 3
0074.00 K3S_8000 3 - All locations for a product 3 of 3
0075.00
0076.00 02) K3S_EMLRPT - Changes made to allow customers to email CSV and PDF
0077.00 of customer usage batches, PE batches, as well as
0078.00 customer created batches if the GUI and MMAIL have
0079.00 been installed.
0080.00
0081.00 03) K3S_ENDQCM - This is part of the GUI update script.
0082.00 This will end GUI related jobs in the QCMN subsystem.
0083.00
0084.00 04) K3S_FX510A - Populate APP record 'K3S_9010 NEW_SLOW'
0085.00 description 2 text to read:
0086.00 Flag 2=1 for average default (use Number 2 field)
0087.00
0088.00 05) K3S_FX510B - Generate the default 'K3S_BUYERS' User Preference
0089.00 for customers who do not have it.
0090.00
0091.00 06) K3S_FX510C – Remove previous OC1 record, which did have
0092.00 Description 1 text of 'Order Cycle established'.
0093.00 Change previous OC record to have Flag3=0, which
0094.00 enables all OCx new batches at once.
0095.00
0096.00 07) K3S_FX510D - Populate APP record 'K3S_1040 LAST_21 '
0097.00 description 3 text to read:
0098.00 Control display using PR_USERA1=Y Flag3=1
0099.00
0100.00 08) K3S_FX510E - Patch PSC Product Select Codes area for
0101.00 Table Code records. CG becomes PE on Totem Pole
0102.00
0103.00 09) K3S_OLDNEW - Write records to K_PRODLNK for product ID
0104.00 re-assignment.
0105.00
0106.00 10) K3S_PRSGET - This is part of the GUI update script.
0107.00 This will get the GUI updates via the FTP site.
0108.00
0109.00 11) K3S_PRSIN - This is part of the GUI update script.
0110.00 This is the input file for the update job.
0111.00
0112.00 12) K3S_PRSOUT - This is part of the GUI update script.
0113.00 This is the output file for the udpate job.
0114.00
0115.00 13) K3S_REL_5 - Enable all K3S servers the authorization
0116.00 to create customer permanent soft keys.
0117.00
0118.00 14) K3S_RESTOR - This is part of the GUI update script.
0119.00 This will restore all of the GUI updates.
0120.00
0121.00 15) K3S_SYSCL - Include statements to clear message queue.
0122.00 This is needed for GUI users for Today's Agenda to
0123.00 work properly.
0124.00
0125.00 16) K3S_XP8000 - Control YOUR SPACE on K3S_8000
0126.00 Enables control of the header columns for both
0127.00 '2 of 3' and '3 of 3' screens.
0128.00
0129.00 17) K3S_0010 - Logic added to to allow access to metrics.
0130.00 K3S_0010FM If a company has metrics, we can either give access to
0131.00 everyone at the company or just individual users.
0132.00 - Using new option to launch metrics
0133.00 - Deleted old logic that was used to display
0134.00 last period's metrics. We are no longer putting any
0135.00 metrics data on the main menu.
0136.00 18) K3S_1010 - When using F23=Entire Buy Group to re-create all
0137.00 suggested orders for a specific Buy Group/Location,
0138.00 by-pass any diverter orders.
0139.00
0140.00 (Glenn @ Merchants Grocery)
0141.00 19) K3S_1020 - Enable the F8= exit point text to display on the
0142.00 K3S_1020FM screen.
0143.00 New logic to Monitor for values too large for fields.
0144.00 New PE Warning System to remind buyers they have not
0145.00 completed their PE checks.
0146.00 New Order Cycle warning capability. Displays 'Last
0147.00 Update' on Order Cycle. If older than 1 year displays
0148.00 in color Red. If older than 2 years displays as
0149.00 color Red and blinking.
0150.00 On Totel Pole, PE Period End checks replace previous
0151.00 CG Changed Components check.
0152.00
0153.00 20) K3S_1030 - New PE Warning System to remind buyers they have not
0154.00 K3S_1030FM completed their PE checks. PE Period End checks
0155.00 replace previous CG Changed Components check.
0156.00 New logic to Monitor for values too large for fields.
0157.00
0158.00 (Stacey @ S. Abraham)
0159.00 21) K3S_1040 - When using Combined Suppliers which span multiple
0160.00 K3S_1040FM locations, use correct Location ID when calling
0161.00 K3S_1041 Last 21 Days demand module. This would be a
0162.00 K3S_1041FM cross-dock scenario.
0163.00 (Pete @ Core Mark)
0164.00 - New capability to display 'Last 21 days demand'
0165.00 section for only selected products.
0166.00 (Larry @ Les Schwab Tires)
0167.00 - New 'shut off' capability for Store Level
0168.00 environments, where seasonal profile exists,
0169.00 and manual minimum in play. Logic can
0170.00 'look ahead' to see what action should take
0171.00 place next month.
0172.00
0173.00 22) K3S_1046 - New capability to display Last Year information
0174.00 for the same 21 day period.
0175.00 New capability to display Last 21 Days Demand in
0176.00 environment where LC_DAILY = 0 (PTD info passed
0177.00 each day) and processing schedule understands
0178.00 customer may not run 7 days a week, and may run
0179.00 across weekends.
0180.00
0181.00 23) K3S_1047 - Approved orders display for products.
0182.00 K3S_1047FM
0183.00
0184.00 24) K3S_1050 - Approval notes can now be location specific for a
0185.00 multi-location customer.
0186.00
0187.00 25) K3S_1120 - Added logic to ensure this program can not become
0188.00 a run-away and write too many records. Set to stop
0189.00 writing at 200,000 records. File K_PRODPND used for
0190.00 pending diverter offerings. CMI at 43,000 records
0191.00 today, which is all US divisions included.
0192.00
0193.00 (Pete @ Core Mark)
0194.00 26) K3S_1500 - For Combined Suppliers, when user re-calculates
0195.00 order and decides to keep over-ridden quantities,
0196.00 program fixed to use those over-ridden quantities.
0197.00 (Larry @ Les Schwab)
0198.00 - Shut off capability for Store Level environment.
0199.00 Enable products with seasonal profiles, and Manual
0200.00 Minimum Units, to "look ahead" to determine if
0201.00 Factor 0.00 is close. Products that meet criteria
0202.00 flagged by setting PQ_NONSTCK = 1 (previously
0203.00 un-used field).
0204.00 - New capability to more easily control Safety Stock
0205.00 percentages from Supplier level. If no Product
0206.00 Safety Stock percentages exist, program will
0207.00 automatically default to Supplier Safety Stock
0208.00 percentages.
0209.00 - Total the PE1 thru PE5 checks, and store in
0210.00 previously used 'CG' Changed Components' fields.
0211.00 New visual label is 'PE' for Period End checks.
0212.00 (Lee Ann @ Central Paper)
0213.00 - All Frozen is new capability that enables buyer
0214.00 to freeze all products within a supplier to have
0215.00 average = 0, then any 1 product with a negative
0216.00 balance will prompt order as Due.
0217.00 - New logic to Monitor for values too large for fields.
0218.00
0219.00 27) K3S_1510 - New capability to more easily control Safety Stock
0220.00 percentages from Supplier level. If no Product
0221.00 Safety Stock percentages exist, program will
0222.00 automatically default to Supplier Safety Stock
0223.00 percentages.
0224.00 - New logic to test for values too large for fields.
0225.00
0226.00 (Adam @ Modern Tire)
0227.00 28) K3S_2001 - Clear the order busy fields when the Buyer ID
0228.00 is changed. Otherwise, order kept locked when buyer
0229.00 forced back to K3S Main Menu.
0230.00
0231.00 29) K3S_2008 - When adding new supplier, clear the Cash Discount
0232.00 field, and don't default to 2.0%
0233.00
0234.00 30) K3S_2030 - Remove F21=Start capability.
0235.00 K3S_2030FM
0236.00
0237.00 31) K3S_2031 - Combine '1 of 2' and '2 of 2' screens, and remove
0238.00 K3S_2031FM F20=Toggle capability.
0239.00
0240.00 (Pete @ Core-Mark)
0241.00 32) K3S_2040 - Added F7=Continue capability for the new OCx type
0242.00 K3S_2040FM Batches.
0243.00
0244.00 33) K3S_2044 - Default supplier sub code to '*' to include all
0245.00 K3S_2044CL supplier components. CL adjusted to force compare.
0246.00
0247.00 (Pete @ Core-Mark)
0248.00 34) K3S_2046CL - New process to develop 'OCx' type batches.
0249.00 K3S_2046
0250.00 K3S_2047
0251.00
0252.00 (Glenn @ Merchants Grocery)
0253.00 35) K3S_2060 - When adding the 1st bracket level for a supplier,
0254.00 go ahead and write the information, and end the
0255.00 program so user ends up back on K3S_2000, or
0256.00 K3S_1020, with choice made.
0257.00 - Do not display 'no records' when none exist, leave
0258.00 blank
0259.00
0260.00 (Pete @ Core-Mark)
0261.00 36) K3S_3000 - Fix to following scenario: Using 1=Select on a
0262.00 K3S_3000FM group of products, then using F2=Copy to all, but
0263.00 when the warning WINDOW appears, the user does not
0264.00 press F2=Copy to complete, but presses F12=Cancel.
0265.00 The F12=Cancel did not work, and what ever product
0266.00 the user was looking at, the entry fields for that
0267.00 product were copied to all products selected. Now
0268.00 F12=Cancel bails out of the warning WINDOW and
0269.00 no copying takes place.
0270.00 - Fix to keep recursive call to K3S_3070 Product
0271.00 Interface Log from taking place.
0272.00
0273.00 37) K3S_3001 - Comment out population of PR_RFBIRTH.
0274.00
0275.00 38) K3S_3004 - Comment out population of PR_RFBIRTH.
0276.00
0277.00 39) K3S_3010 - Comment out updates to PQ_CHKCHG and SO_CHKCHG
0278.00 which become new PE check warning.
0279.00
0280.00 40) K3S_3015 - Default Produck Link Type to 'D' for Daily,
0281.00 K3S_3015FM as opposed to leaving blank.
0282.00 - Control F21=Start by seeing records in subfile.
0283.00
0284.00 41) K3S_3016 - Program would loop if user tried to 4=Delete
0285.00 a record which contained invalid data, like
0286.00 supplier or product no longer in system.
0287.00
0288.00 42) K3S_3020 - Change presentation. Do display current and new
0289.00 K3S_3020FM safety stock days with .000
0290.00 When there is a small difference in the dollar
0291.00 amounts, less than a buck, do display $1.
0292.00 No longer update the CG (change) check, since we
0293.00 are now using for the PE checks.
0294.00
0295.00 43) K3S_3025 - New capability to more easily control Safety Stock
0296.00 percentages from Supplier level. If no Product
0297.00 Safety Stock percentages exist, program will
0298.00 automatically default to Supplier Safety Stock
0299.00 percentages.
0300.00
0301.00 44) K3S_3030 - New PE warning check system displays the type of
0302.00 K3S_3031 PE1 thru PE5 check this product had last period
0303.00 K3S_3030FM
0304.00 K3S_3031FM
0305.00
0306.00 (Stacey @ S. Abraham)
0307.00 45) K3S_3070 - F21=Start capability and sub-file options added
0308.00 K3S_3070FM to logic.
0309.00 - New capability to include weekend activity on
0310.00 Mondays.
0311.00
0312.00 (Pete @ Core-Mark)
0313.00 46) K3S_3080 - Ability to drill down on 'OC ' batches. This would
0314.00 include all types: OC0, OC1, OC2, OC3, and OC4.
0315.00
0316.00 47) K3S_3085 - Ability to email CSV and PDF listing of any batch
0317.00 K3S_3085CL using the 6=Edit List option if the customer has
0318.00 GUI and MMAIL.
0319.00 - K3S_3085CL moves from K3S_5OBJ to K3S_5MOD
0320.00
0321.00 (Pete @ Core-Mark)
0322.00 48) K3S_3090 - Activate new '8=Order cycle analysis' capability.
0323.00 - New default setting of '0' for ZZREVIEW, so that
0324.00 users automatically see only those products
0325.00 not yet reviewed.
0326.00
0327.00 49) K3S_3100 - Now understands how to create 'OC' Order Cycle
0328.00 Analysis batches.
0329.00
0330.00 (Vickie @ Variety Wholesalers)
0331.00 50) K3S_3140 - Change Seasonal Profile generator to reset
0332.00 past 9,999,999 enabling up to 10 million profiles.
0333.00
0334.00 51) K3S_3150 - Understands new Profile ID going from 5 to 7
0335.00
0336.00 52) K3S_3220CL - This program should now reside in 5MOD instead of 5OBJ.
0337.00 Ability to email CSV and PDF listing of any batch
0338.00 using the 6=Edit List option if the customer has
0339.00 GUI and MMAIL.
0340.00
0341.00 53) K3S_3225 - Break on supplier needed to include supplier sub code
0342.00 for correct total of products by supplier.
0343.00
0344.00 54) K3S_3300 - Default sub supplier code to '*' to include all
0345.00 K3S_3300CL supplier components for Ranking Reports.
0346.00 CL adjusted to force compare.
0347.00
0348.00 55) K3S_3350 - Default sub supplier code to '*' to include all
0349.00 K3S_3350CL supplier components for Inventory Performance
0350.00 Reports. CL adjusted to force compare.
0351.00
0352.00 56) K3S_3360 - Capture information for both MSS and USD splits
0353.00 so improve Purchase Adjustments report.
0354.00
0355.00
0356.00 57) K3S_3365 - Default sub supplier code to '*' to include all
0357.00 K3S_3361CL supplier components for Purchase Adjustments
0358.00 K3S_3362CL Reports. CLs adjusted to force compare.
0359.00 K3S_3363CL
0360.00 K3S_3364CL
0361.00 K3S_3365CL
0362.00
0363.00 (Pete @ Core-Mark International)
0364.00 58) K3S_3366 - Allocate original SOQ for both MSS and USD split
0365.00 K3S_3366CL orders to improve Purchase Adjustments report.
0366.00
0367.00 59) K3S_3420 - New capability to more easily control Safety Stock
0368.00 K3S_3420FM percentages from Supplier level. If no Product
0369.00 Safety Stock percentages exist, program will
0370.00 automatically default to Supplier Safety Stock
0371.00 percentages.
0372.00 - New F21=Start capability.
0373.00 - Added 3 more lines to subfile.
0374.00 - Combined '1 of 2' and '2 of 2' to one screen,
0375.00 therefore removing F20=Toggle capability.
0376.00 - New F17=Remove all Safety Stock records.
0377.00 - Safety Stock % now default to 0's for new records
0378.00 and not Supplier defaults, since order builder
0379.00 program now understands to pick up values there.
0380.00
- When working a specific Product screen, the
00381.00 Supplier values are shown.
0382.00
0383.00 60) K3S_3452 - Added 3 more sub file lines to Change Product
0384.00 K3S_3452FM Source program for 1=Select multiple products
0385.00 - Added Description 2 as last column.
0386.00
0387.00 (Adam @ Modern Tire, Greg @ Raben Tires)
0388.00 61) K3S_3600 - Added Reference Birth date capability to filter
0389.00 for Overstock products.
0390.00
0391.00 62) K3S_3610 - Default sub supplier code to '*' to include all
0392.00 K3S_3610CL supplier components for Overstock Products
0393.00 Reports. CL adjusted to force compare.
0394.00
0395.00 63) K3S_3710 - Default sub supplier code to '*' to include all
0396.00 K3S_3710CL supplier components for Obsolete Products
0397.00 K3S_3711CL Reports. CLs adjusted to force compare.
0398.00
0399.00 64) K3S_3750 - Default sub supplier code to '*' to include all
0400.00 K3S_3750CL supplier components for Deal Markup Report.
0401.00 CL adjusted to force compare.
0402.00
0403.00 65) K3S_3760 - Default sub supplier code to '*' to include all
0404.00 K3S_3760CL supplier components for Turns Report.
0405.00 CL adjusted to force compare.
0406.00
0407.00 66) K3S_7100CL - New capability to automatically 'C' Close out old
0408.00 K3S_7140 PEx and Wxx batches. This runs out of K3S_NITECL
0409.00 when ever a Period End occurs.
0410.00
0411.00 (Adam @ Modern Tire, Greg @ Raben Tires)
0412.00 67) K3S_8000 - New capability that includes additional '2 of 3'
0413.00 K3S_8000FM and '3 of 3' subfile lists, with customizable
0414.00 Header columns.
0415.00
0416.00 (Mike @ S. Abraham)
0417.00 68) K3S_8510 - This new capability will enable a customer to use
0418.00 K3S_8520 the K3S Hub Transfer structure to establish the
0419.00 K3S_8530 Path of Replenishment, but avoid using the K3S
0420.00 programs to copy the history and forecast. New
0421.00 APP record 'K3S_8530 CPY_DEMAND' will control
0422.00 the copy process.
0423.00
0424.00 (Pete @ Core-Mark International)
0425.00 69) K3S_9010 - New option to clear promotional information
0426.00 after End date passed.
0427.00 - New option to populate PR_RFBIRTH.
0428.00
0429.00 (Carlos @ Navarro)
0430.00 70) K3S_9011 - The user's supplier sub code was not being
0431.00 populated into the log file.
0432.00 - Stop populating field PR_RFBIRTH.
0433.00
0434.00 (Carlos @ Navarro)
0435.00 71) K3S_9017CL - The parameter &SOQSEQ# needed to be initialized
0436.00 with a VALUE of 00000.
0437.00
0438.00 (Mike @ S. Abraham)
0439.00 72) K3S_9251 - Program changed from Input Primary to Input Full
0440.00 Function on K_INTPROD so that *START logic
0441.00 could be used to re-position file cursor.
0442.00
0443.00 73) K3S_9256 - No supplier testing needed for most environments.
0444.00
0445.00 74) K3S_9259FM - New Daily Demand - Expanded program.
0446.00 K3S_9259
0447.00
0448.00 75) K3S_9300 - Protect Company Code and do not allow adjustments.
0449.00 K3S_9300FM The 3 letter code unique for K3S customers, and
0450.00 helps with K3S_1050FM, K3S_9257FM, etc.
0451.00
0452.00 76) K3S_9505 - Just a recompile because PF K_INVPROD changed.
0453.00
0454.00 -----------------------------------------------------------------------
0455.00 Physical & logical files added/changed/deleted in release for K3S_5DTA
0456.00 -----------------------------------------------------------------------
0457.00
0458.00 There were 4 Logical files deleted in this release.
0459.00
0460.00 K_INVBUYRB LF Average inventory by LOCN,BUYR,FCINT,YR,PRD
0461.00 K_INVBUYRC LF Average inventory by LOCN,FCINT,BUYR,YR,PRD
0462.00 K_INVBUYRD LF Average inventory by BUYR,LOCN,FCINT,YR,PRD
0463.00 K_INVBUYRE LF Average inventory by FCINT,BUYR,LOCN,YR,PRD
0464.00
0465.00 There were 6 Physical & Logical files changed in this release.
0466.00
0467.00 K_INVBUYR PF Average inventory statistics for buyers
0468.00 K_INVBUYRA LF Average inventory by LOCN,FCINT,YR,PRD,BUYR
0469.00 K_INVPROD PF Average inventory statistics for products
0470.00 K_INVPRODA LF Average inventory by LOCN,FCINT,YR,PRD,BUYR,SUPL
0471.00 K_INVPRODB LF Average inventory by FCINT,YR,PRD
0472.00 K_INVPRODC LF Average inventory by LCN,PRD,SPL,BUYR,FCINT,YR,PRD
0473.00
0474.00 There were 34 Physical & Logical files added in this release.
0475.00
0476.00 K_BUYRIMET PF Buyer Inventory Metrics Report
0477.00 K_BUYRMETB LF Buy Group Metrics file - by Buy Group, Year, Month
0478.00 K_COMPMET PF Company Metrics Report
0479.00 K_CUSTWRKX PF Customer Usage Transaction work file
0480.00 K_DLYPRODE LF Daily Products by LOCN,SUPLUSR,PROD,BIRTH,BATCH
0481.00 K_DVTRMET PF Diverter Metrics Report
0482.00 K_DVTRSVG PF Diverter Savings
0483.00 K_DVTRSVGA LF Diverter Savings by LOCN,SUPL,YEAR,MONTH
0484.00 K_DVTRSVGB LF Diverter Savings by YEAR,MONTH,LOCN,SUPL
0485.00 K_INVCOMPC LF Average inventory by YEAR,FCINT,PERD
0486.00 K_INVLOCNE LF Average inventory by YR,LOCN,FCINT,PRD
0487.00 K_INVPRODD LF Average inventory by BUYR,FCINT,YEAR,PRD
0488.00 K_LOCNMET PF Location Metrics Report
0489.00 K_METQRP1 PF Metrics Quarterly report work file (comp and locn)
0490.00 K_METQRP1A LF Metrics Quarterly report work file (comp and locn)
0491.00 K_METQRP2 PF Metrics Quarterly report work file (user and buyr)
0492.00 K_METQRP2A LF Metrics Quarterly report work file (user and buyr)
0493.00 K_PRDSPMET PF Supplier Metrics Performance Report
0494.00 K_PRODAPPC LF Product approved/adjusted orders LOCN,SUPL,SUB,PRD
0495.00 K_PRODLTMD LF Product Lead Time Trans ORDRECV,LOCN,PROD,SUPL
0496.00 K_PRODLTME LF Product Lead Time Trans ORDRECV,LOCN,SUPL
0497.00 K_PRODMET PF Product Metrics Report
0498.00 K_PRODSEDD LF Product Selected for Review - Batch detail REQTYPE
0499.00 K_PRODSEDX PF Product Selected for Review work file
0500.00 K_PRODSPL PF Products from suppliers metrics
0501.00 K_PRODSPLA LF Products from supl metrics by LCN,PRD,SPL,YR,MO
0502.00 K_PRODSPLB LF Products from supl metrics by YR,MO,LCN,SPL
0503.00 K_SCHEDPEC LF Schedule Period End by INTRV,YR,PER,PROC=1
0504.00 K_SUPLMET PF Supplier Metrics Report
0505.00 K_SUPLPER PF Supplier Performance Metrics
0506.00 K_SUPLPERA LF Supplier Performance Metrics by LOC,SPL,YR,MO
0507.00 K_SUPLPERB LF Supplier Performance Metrics by YR,MO,LOC,SPL
0508.00 K_SUPLPMET PF Supplier Performance Metrics Report
0509.00 K_USERMETB LF User Metrics file by COMP,YEAR,MONTH,USER,BUYER
0510.00
0511.00 After this release installed, there should be exactly 492 objects
0512.00 in library K3S_5DTA (data files library) (Rel 5.08 had 462 objects)
0513.00 LF logicals need extra care with non-standard lib names
0514.00 -----------------------------------------------------------------------
0515.00 Programs and Files in library K3S_MOD510
0516.00 -----------------------------------------------------------------------
0517.00
0518.00 -- RPGLE
0519.00 K3S_BLDQRP Build the metrics quarterly report work files
0520.00 K3S_BUYMET Write last period stats by buygroup to K_BUYRMET
0521.00 K3S_CHKEOM Determine if monthly metrics programs need to run
0522.00 K3S_CVRT22 New Table Code entries
0523.00 K3S_DVTSVG Write last months stats for diverter savings
0524.00 K3S_EMLRPT Email reports
0525.00 K3S_INVALL Run all inventory analysis programs
0526.00 K3S_INVBYR Write period statistics by BUYR to K_INVBUYR
0527.00 K3S_INVCMP Write period statistics by COMP to K_INVCOMP
0528.00 K3S_INVLCN Write period statistics by LOCN to K_INVLOCN
0529.00 K3S_INVPRD Write period statistics by PROD to K_INVPROD
0530.00 K3S_INVSPL Write period statistics by SUPL to K_INVSUPL
0531.00 K3S_INXALL Choose period for all invent analysis programs
0532.00 K3S_INXLCN Choose period for stats by LOCN to K_INVLOCN
0533.00 K3S_INXPRD Choose period for stats by PROD to K_INVPROD
0534.00 K3S_INXSPL Choose period for stats by SUPL to K_INVSUPL
0535.00 K3S_OLDNEW Write to K_PRODLNK for old to new product chg
0536.00 K3S_SPLPER Write last month stats for supl performance
0537.00 K3S_USRMET Write last period stats by USER to K_USERMET
0538.00 K3S_XP8000 Control YOUR SPACE on K3S_8000 (new)
0539.00 K3S_1050 Suggested Order Supplier Approval
0540.00 K3S_9251 Accumulate today's case demand into K_INTPROD
0541.00 K3S_9256 Update K_INTPROD with daily dem from K_INTDALY
0542.00 K3S_9259 Display daily demand - expanded
0543.00
0544.00 -- CLLE
0545.00 K3S_DVTQRY Sequence K_DVTRSVG by chosen fld using OPNQRYF
0546.00 K3S_EMLMET Email metrics reports
0547.00 K3S_ENDQCM K3S GUI. End GUI jobs in QCMN
0548.00 K3S_PRDQRY Sequence K_INVPROD by chosen field using OPNQRYF
0549.00 K3S_PRSGET K3S GUI. Get updates from FTP site
0550.00 K3S_PRSIN K3S GUI. INPUT file
0551.00 K3S_PRSOUT K3S GUI. OUTPUT file
0552.00 K3S_PRSQRY Sequence K_PRODSPL by chosen field using OPNQRYF
0553.00 K3S_QTRRPT Print the quarterly metrics reports and email
0554.00 K3S_RESTOR K3S GUI. Restore updates.
0555.00 K3S_SPLQRY Sequence K_INVSUPL by chosen field using OPNQRYF
0556.00 K3S_SPPQRY Sequence K_SUPLPER by chosen field using OPNQRYF
0557.00 K3S_SYSCL Start up for K3S users
0558.00 K3S_3085CL Selected products review batch print (prev K3S_5OBJ)
0559.00 K3S_3220CL Customer Usage Transactions report and update (prev K3S_5OBJ)
0560.00 K3S_9017CL Add products day time from customer's system
0561.00
0562.00 -- CMD
0563.00 none
0564.00
0565.00 -- DSPF
0566.00 K3S_9259FM Daily demand display - expanded
0567.00 3 programs above in red are required before buyers sign on after install
0568.00 -----------------------------------------------------------------------
0569.00 Special instructions for some customers
0570.00 -----------------------------------------------------------------------
0571.00
0572.00 Core-Mark International
0573.00 APP for K3S_9010 CLR_PROMO - set Flag1 to 1=Yes
0574.00
0575.00 Duncan Supply
0576.00 Add back DPG - BUYERS K3S_4031 - Product Group Service Level Targets
0577.00
0578.00 Franklin Machine Products
0579.00 K_DLYPRODE - LF remove from K3S_5MOD
0580.00 K3S_1046 - RPG remove from K3S_5MOD
0581.00
0582.00 -----------------------------------------------------------------------
0583.00 Special instructions for all customers
0584.00 -----------------------------------------------------------------------
0585.00
0586.00 K3S_MSGADD - This program will re-create message file K3S_MSGF. All
0587.00 customers need to have this program run to perform task.
0588.00 - Confirm object K3S_MSGADD created 1-19-2009 16:30:06
0589.00 - put K3S_5OBJ in library list
0590.00 - rename K3S_MSGF to K3S_MSGF_X
0591.00 - CALL K3S_5OBJ/K3S_MSGADD PARM(K3S_5OBJ)
0592.00
0593.00 -----------------------------------------------------------------------
0594.00
0595.00 Metrics
0596.00 Below is a list of all changes to the metrics application.
0597.00 Noted next to each item is whether it is new or changed.
0598.00 Items that should reside in K3S_5MOD are marked with the text '5MOD'
0599.00
0600.00 Important notes:
0601.00 -Physical file K_INVBUYR changed. There used to be 5 logical files
0602.00 associated with K_INBUYR. K_INVBUYRA also changed, but the other
0603.00 logicals will get deleted (K_INVBUYRB, K_INVBUYRC, K_INVBUYRD, and
0604.00 K_INVBUYRE)
0605.00
0606.00 -These screens get compiled with restore display (RSTDSP) = *YES:
0607.00 K3S_0110FM, K3S_0120FM, K3S_0130FM, K3S_0140FM, K3S_0170FM.
0608.00 K3S_0180FM, K3S_019FM, K3S_0210FM.
0609.00 This allows a window to prompt another window properly.
0610.00
0611.00 -There are 8 physical files that reference fields in another PF.
0612.00 K_BUYRIMET references fields in K_INVBUYR
0613.00 K_COMPMET references fields in K_INVCOMP
0614.00 K_DVTRMET references fields in K_DVTRSVG
0615.00 K_LOCNMET references fields in K_INVLOCN
0616.00 K_PRDSPMET references fields in K_PRODSPL
0617.00 K_PRODMET references fields in K_INVPROD
0618.00 K_SUPLMET references fields in K_INVSUPL
0619.00 K_SUPLPMET references fields in K_SUPLPER
0620.00
0621.00 -----------------------------------------------------------------------
0622.00
0623.00 *** QDDSSRC ***
0624.00
0625.00 K_BUYRIMET (new PF)
0626.00 K_BUYRMETB (new LF)
0627.00 K_COMPMET (new PF)
0628.00 K_DVTRMET (new PF)
0629.00 K_DVTRSVG (new PF)
0630.00 K_DVTRSVGA (new LF)
0631.00 K_DVTRSVGB (new LF)
0632.00 K_INVBUYR (changed PF)
0633.00 K_INVBUYRA (changed LF)
0634.00 K_INVBUYRB (LF gets deleted)
0635.00 K_INVBUYRC (LF gets deleted)
0636.00 K_INVBUYRD (LF gets deleted)
0637.00 K_INVBUYRE (LF gets deleted)
0638.00 K_INVCOMPC (new LF)
0639.00 K_INVLOCNE (new LF)
0640.00 K_INVPROD (PF changed; all logicals need a recompile)
0641.00 K_INVPRODA
0642.00 K_INVPRODB
0643.00 K_INVPRODC
0644.00 K_INVPRODD
0645.00 K_LOCNMET (new PF)
0646.00 K_METQRP1 (new PF)
0647.00 K_METQRP1A (new LF)
0648.00 K_METQRP2 (new PF)
0649.00 K_METQRP2A (new LF)
0650.00 K_PRDSPMET (new PF)
0651.00 K_PRODMET (new PF)
0652.00 K_PRODSPL (new PF)
0653.00 K_PRODSPLA (new LF)
0654.00 K_PRODSPLB (new LF)
0655.00 K_SUPLMET (new PF)
0656.00 K_SUPLPER (new PF)
0657.00 K_SUPLPERA (new LF)
0658.00 K_SUPLPERB (new LF)
0659.00 K_SUPLPMET (new PF)
0660.00 K_USERMETB (new LF)
0661.00 K3S_P0115 (new PRTF)
0662.00 K3S_P0125 (new PRTF)
0663.00 K3S_P0135 (new PRTF)
0664.00 K3S_P0145 (new PRTF)
0665.00 K3S_P0175 (new PRTF)
0666.00 K3S_P0185 (new PRTF)
0667.00 K3S_P0195 (new PRTF)
0668.00 K3S_P0200 (new PRTF)
0669.00 K3S_P0215 (new PRTF)
0670.00 K3S_0101FM (changed screen)
0671.00 K3S_0110FM (changed) ***screen must be compiled with RSTDSP=*YES
0672.00 K3S_0120FM (changed) ***screen must be compiled with RSTDSP=*YES
0673.00 K3S_0130FM (changed) ***screen must be compiled with RSTDSP=*YES
0674.00 K3S_0140FM (changed) ***screen must be compiled with RSTDSP=*YES
0675.00 K3S_0150FM (changed screen)
0676.00 K3S_0160FM (changed screen)
0677.00 K3S_0170FM (new) ***screen must be compiled with RSTDSP=*YES
0678.00 K3S_0180FM (new) ***screen must be compiled with RSTDSP=*YES
0679.00 K3S_0190FM (new) ***screen must be compiled with RSTDSP=*YES
0680.00 K3S_0210FM (new) ***screen must be compiled with RSTDSP=*YES
0681.00 K3S_1047FM (new screen)
0682.00
0683.00 *** QCLLESRC ***
0684.00 K3S_DVTQRY (new; 5MOD)
0685.00 Sequence K_DVTRSVG by chosen fld using OPNQRYF
0686.00 K3S_EMLMET (new; 5MOD)
0687.00 Email metrics reports
0688.00 K3S_PRDQRY (changed; 5MOD)
0689.00 Sequence K_INVPROD by chosen fld using OPNQRYF
0690.00 K3S_PRSQRY (new; 5MOD)
0691.00 Sequence K_PRODSPL by chosen fld using OPNQRYF
0692.00 K3S_QTRRPT (new; 5MOD)
0693.00 Print the quarterly metrics report and email
0694.00 K3S_SPLQRY (changed; 5MOD)
0695.00 Sequence K_INVSUPL by chosen fld using OPNQRYF
0696.00 K3S_SPPQRY (new; 5MOD)
0697.00 Sequence K_SUPLPER by chosen fld using OPNQRYF
0698.00
0699.00 *** QRPGLESRC ***
0700.00
0701.00 K3S_BLDQRP (new; 5MOD)
0702.00 Build the Metrics quarterly report work files
0703.00
0704.00 K3S_BUYMET (changed; 5MOD)
0705.00 Write last period stats by buy group to K_BUYRMET
0706.00
0707.00 K3S_CHKEOM (new; 5MOD)
0708.00 Determine if the monthly metrics programs need to run
0709.00
0710.00 K3S_K3S_DVTSVG (new; 5MOD)
0711.00 Write last month stats for diverter savings
0712.00
0713.00 K3S_INVALL (changed; 5MOD)
0714.00 Run all inventory analysis programs 4 last prd
0715.00
0716.00 K3S_INVBYR (changed; 5MOD)
0717.00 Write last period stats by BUYR to K_INVBUYR
0718.00
0719.00 K3S_INVCMP (changed; 5MOD)
0720.00 Write last period stats by COMP to K_INVCOMP
0721.00
0722.00 K3S_INVLCN (changed; 5MOD)
0723.00 Write last period stats by LOCN to K_INVLOCN
0724.00
0725.00 K3S_INVPRD (changed; 5MOD)
0726.00 Write last period stats by PROD to K_INVPROD
0727.00
0728.00 K3S_INVSPL (changed; 5MOD)
0729.00 Write last period stats by SUPL to K_INVSUPL
0730.00
0731.00 K3S_INXALL (changed; 5MOD)
0732.00 Run all inventory analysis programs 4 last prd
0733.00
0734.00 K3S_INXLCN (changed; 5MOD)
0735.00 Write last period stats by LOCN to K_INVLOCN
0736.00
0737.00 K3S_INXPRD (changed; 5MOD)
0738.00 Write last period stats by PROD to K_INVPROD
0739.00
0740.00 K3S_INXSPL (changed; 5MOD)
0741.00 Write last period stats by SUPL to K_INVSUPL
0742.00
0743.00 K3S_SPLPER (new; 5MOD)
0744.00 Write last month stats for supl performance
0745.00
0746.00 K3S_USRMET (changed; 5MOD)
0747.00 Write last period stats by user to K_USERMET
0748.00
0749.00 K3S_0101 (changed)
0750.00 Metrics Main Menu
0751.00
0752.00 K3S_0110 (changed)
0753.00 Period Performance Statistics by Company - Display
0754.00
0755.00 K3S_0115 (new)
0756.00 Period Performance Statistics by Company - Report
0757.00
0758.00 K3S_0120 (changed)
0759.00 Period Performance Statistics by Location-Display
0760.00
0761.00 K3S_0125 (new)
0762.00 Period Performance Statistics by Location-Report
0763.00
0764.00 K3S_0130 (changed)
0765.00 Period Performance Statistics by Supplier-Display
0766.00
0767.00 K3S_0135 (new)
0768.00 Period Performance Statistics by Supplier-Report
0769.00
0770.00 K3S_0140 (changed)
0771.00 Period Performance Statistics by Product-Display
0772.00
0773.00 K3S_0145 (new)
0774.00 Period Performance Statistics by Product - Report
0775.00
0776.00 K3S_0150 (changed)
0777.00 User Metrics
0778.00
0779.00 K3S_0160 (changed)
0780.00 Buy Group Metrics
0781.00
0782.00 K3S_0170 (new)
0783.00 Period Performance Statistics by Buyer - Display
0784.00
0785.00 K3S_0175 (new)
0786.00 Period Performance Statistics by Buyer - Report
0787.00
0788.00 K3S_0180 (new)
0789.00 Period Performance Statistics by Prod frm Supl-Dsp
0790.00
0791.00 K3S_0185 (new)
0792.00 Period Performance Statistics by Prod for Supl-Rpt
0793.00
0794.00 K3S_0190 (new)
0795.00 Supplier Performance Metrics - Display
0796.00
0797.00 K3S_0195 (new)
0798.00 Supplier Performance Metrics - Report
0799.00
0800.00 K3S_0200 (new)
0801.00 Print Quarterly Report
0802.00
0803.00 K3S_0210 (new)
0804.00 Diverter Metrics - Display
0805.00
0806.00 K3S_0215 (new)
0807.00 Diverter Metrics - Report
0808.00
0809.00 K3S_1047 (new)
0810.00 Approved orders display
0811.00