Release 6.5 Techinal Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 6.5 Jan 01, 2023 rel_6.5.doc
0003.00 -----------------------------------------------------------------------
0004.00
0004.01 01) AB_UPDPROR - Configurable exit program in 5MOD at the
0004.02 AE_UPDPROR beginning/end of API UPDPROR. Enable with
0004.03 YSE tablcode.
0004.04
0005.00 02) K3S_CVRT22 - Changes to table code records/New table code records:
0006.00
0007.00 ABT - Automatic batches
0008.00
0009.00 TEMPLATE template for adding auto batch button
0010.00
0011.00 API - Setup values and info for the APIs
0012.00
0013.00 SOQPRODLIST Enable SOQ adjustment from list of
0014.00 NOTEONPRODLIST Display prime note instead of Your
0015.00
0016.00 APP - Application control
0017.00
0018.00 ALTUNIT9
0019.00 BLANKSPACEIE_CHAIN
0020.00 BLANKSPACEIE_CUSTOMR
0021.00 BLANKSPACEIE_ORDER#
0022.00 USECHAINWITHORDER#
0023.00
0024.00 BST - Best Practices Scorecard
0025.00
0026.00 DOLLARS Adjusted Dollars Score Value
0027.00 LATE Late Order Score Value
0028.00 NEW New Products Score Value
0029.00 OC Order Cycle Score Value
0030.00 ORGSUPL Organized Supplier Score Value
0031.00 PECHECK PE Check Score Value
0032.00 TIME Placed After Time Score Value
0033.00 UNITS Adjusted Units Score Value
0034.00
0035.00 DLH - Deal hold outs (new type)
0036.00
0037.00 BUFFER Hold out window to end this many
0038.00 INCLUDSTAT Include status codes for processing
0039.00 MAXSTEPS Maximum number of steps processing?
0040.00 MINSTEPS Determine step length in days
0041.00 MINUNITS Minimum steps to reach allowed in
0042.00 PROCESS Process deal hold outs
0043.00 STEPLENGTH Length of steps in days
0044.00
0045.00 FTP - FTP Settings
0046.00
0047.00 HAS - Hub and Spoke Controls
0048.00
0049.00 PFC - New Product forecast change types related to
0050.00 Hub and Spoke
0051.00
0052.00 J - Hub and Spoke divisional adjustments
0053.00 K - Hub and Spoke divisional updates
0054.00 R - Rollup averages to a location
0055.00
0056.00 RET - Retain
0057.00
0058.00 K_AUTOBCH Automatic batches
0059.00 K_DEALHLD Interface for Deal Holdouts
0060.00 K_ADJTLOG Buyer Adjustment Log
0061.00 K_BUYRALG Night Job totals for select agenda
0062.00 K_BUYRMET tasks
0063.00 K_DVTSRVG Buy Group Metrics
0064.00 K_FINALOG Financial Log Entries
0065.00 K_INTMFUB Mass Field Update Batch Interface
0066.00 K_INTORDF Best Practices Log
0067.00 K_INTORDL Log of User Actions for an Approved
0068.00 K_INVBUYR Order
0069.00 K_INVCOMP Average inventory statistics for
0070.00 K_INVLOCN location nventory statistics for
0071.00 K_INVRLOG Inventory Ratio Log Entries
0072.00 K_PRODSTA Product Summary Table
0073.00 K_SUPLDLY Supplier Log of Order Delays
0074.00 K_USRMETS User Metrics Summary File
0075.00
0076.00 RTR - Retriever Custom Tables
0077.00
0078.00 SEA - New authority records
0079.00
0080.00 ADDMFUB - AProcess deal hold outs when flag1 =
0081.00 ADEMFUB - A1 Mass Field Update Batch Entry
0082.00 APLSEZN - Apply profile to mulitple prods w filt
0083.00 DELMFUB - Delete Mass Field Update Batch
0084.00 DLEMFUB - Delete Mass Field Update Batch Entry
0085.00 DLMSEZN - Delete mulitple seasonal profiles
0086.00 GRPBCHS - Product Supplier Group Batch
0087.00 LCKMFUB - Lock Mass Field Update Batch
0088.00 PROMFUB - Process Mass Field Update Batch
0089.00 UNLMFUB - Unlock Mass Field Update Batch
0090.00 UPBMFUB - Update Mass Field Update Batch
0091.00 UPEMFUB - Update Mass Field Update Batch Entry
0092.00 LNGUPDPROD Long Term Trend Rate in Product Sett
0093.00
0094.00 SEM - New authority records
0095.00
0096.00 ABA Mass Field Update System
0097.00 ABB Deal Holdouts Log
0098.00 ABC Seasonality Manager
0099.00
0100.00 SPR - Selected records review types
0101.00
0102.00 GRP Product or Supplier Group Batches
0103.00
0104.00 YSA - Your Actions
0105.00 YAORDER Your Actions from orders screen
0106.00
0107.00 YSE - Your API Exit Points
0108.00
0109.00 AB_UPDPROR Beginning Exit Point for UPDPROR
0110.00 AE_UPDPROR Ending Exit Point for UPDPROR
0111.00
0116.00 03) K3S_ABTCL - Use these programs as templates to auto close old
0117.00 K3S_ABTBLD and create new automatic batches by BUYR/LOCN for
0118.00 K3S_ABTCLO a customer.
0119.00 K3S_ABTFND
0120.00
0121.00 04) K3S_NIGHT - This command to end the web server:
0122.00 ENDTCPSVR SERVER(HTTP) HTTPSVR(K3SWEB)
0123.00 can replace the call of AR_RLSMISC to end locks.
0124.00 A command to start the web server is also needed
0125.00 STRTCPSVR SERVER(HTTP) HTTPSVR(K3SWEB)
0126.00 after a 30 second delay.
0127.00
0128.00 05) K3S_X310CL - Remove the restart of the web server if exists
0128.01 because it is happening in K3S_NIGHT now:
0129.00 STRTCPSVR SERVER(HTTP) RESTART(HTTP)
0130.00 HTTPSVR(K3SWEB)
0131.00
0132.00 06) K3S_YRACCL - Template for Your Actions. Enable with YSA
0133.00 tablcodes.
0134.00
0135.00 07) K3S_YRSCCL - Additional parm for your screen: SOQSEQN
0136.00 K3S_YRSCRN
0137.00
0138.00 08) K3S_3041 - When multiple LOCN/PROD are going to one LOCN/PROD
0139.00 for 'C' type K_PRODLNK records,
0140.00 ensure the K_PRODFOR log transcations are relating
0141.00 to each specific K_PRODLNK record.
0142.00
0143.00
0144.00 09) K3S_5430CL - Night job hook to call program to process
0145.00 K3S_5430 deal hold outs.
0146.00
0147.00
0148.00 10) K3S_9500CL - Call new exit program K3S_9500X2 at the end
0149.00 of the reorganize job.
0150.00
0151.00 11) K3S_9500X2 - New exit program in 5MOD library to run at the
0152.00 end of the reorganize job. Can be used to
0153.00 tell the Dashboard the job is over.
0154.00
0155.00 12) K3S_9505CL - Call new exit program K3S_9505X2 at the end
0156.00 of the delete records job.
0157.00
0158.00 13) K3S_9505X2 - New exit program in 5MOD library to run at the
0159.00 end of the delete records job. Can be used to
0160.00 tell the Dashboard the job is over.
0161.00
0165.00 -----------------------------------------------------------------------
0166.00 Physical & logical files added/changed/deleted in release for K3S_5DTA
0167.00 -----------------------------------------------------------------------
0168.00
0169.00 There are 7 new Physical files and 8 new Logical files added in this release
0170.00
0171.00 New Indexes
0172.00 IX_APP_PO LF PO Screen Index for PRODAPP
0173.00 IX_LOGPROD LF Night Job Log Index
0174.00 IX_LTM_PO LF PO Screen Index for PRODLTM
0175.00 IX_ORD_PO LF PO Screen Index for INTORDD
0177.00 New Views
0178.00 K_NITECMB LF Combined LOGPROD-PRODUCT-PRODSOQ
0179.00 K_POLISTER LF Joint view on K_PRODAPP, K_INTORDD, K_PRODLTM
0181.00 New files:
0182.00 K_AUTOBCH PF Automatic batches AB
0183.00 K_AUTOBCHA LF Automatic batches REQTYPE/BIRTH/BUYR/REGN/LOCN
0184.00 K_BUYWORK PF Buyer work table BW
0185.00 K_DEALHLD PF Interface for Deal Hold Outs DH
0186.00 K_DEALHLDA LF Creating deal hold outs LOCN,DEAL,PROD,TYPE
0187.00 K_INTMFUB PF Mass Field Update Batch Interface MI
0188.00 K_LCNWORK PF Location work table MB
0189.00 K_MFUBENT PF Mass Field Update Batch Entry ME
0190.00 K_MFUBHED PF Mass Field Update Batch Header MB
0191.00
0192.00 Files changed:
0193.00 K_INTORDF PF Web - Best Practices Log FU
0194.00
0195.00 After this release installed, there should be exactly 534 objects
0196.00 in library K3S_5DTA (data files library) excluding any CUSTOM
0197.00 indexes built for the customer.
0198.00 (Rel 6.4 had 519 objects)
0199.00
0200.00 -------------------------------------------------------------------
0201.00 Programs and Files in library K3S_5MOD
0202.00 -------------------------------------------------------------------
0203.00
0204.00 -- RPGLE
0205.00 K3S_ABTBLD Automatic batches: create list to build MOD
0206.00 K3S_ABTCLO Automatic batches: close old ones MOD
0207.00 K3S_ABTFND Automatic batches: find ones to build MOD
0208.00 K3S_CVRT22 New Table Code entries MOD
0209.00 K3S_YRSCRN Your screen to customize MOD
0210.00 K3S_5430 Create deal hold outs from K_DEALHLD MOD
0211.00
0212.00 -- CLLE
0213.00 AB_UPDPROR Exit before API UPDPROR runs MOD
0214.00 AE_UPDPROR Exit after API UPDPROR runs MOD
0215.00 K3S_ABTCL Autmatic batches: close old & bld new at PEnd MOD
0216.00 K3S_NIGHT Starts night job by submitting K3S_NITECL YES MOD
0217.00 K3S_X310CL ExitBefore Final program end MOD
0218.00 K3S_YRACCL Template for Your Actions to customize MOD
0219.00 K3S_YRSCCL Your screen to customize MOD
0220.00 K3S_5430CL Create deal hold outs from K_DEALHLD MOD
0221.00 K3S_9500X2 Exit from K3S_9500CL After reorganizing MOD
0222.00 K3S_9505X2 Exit from K3S_9505CL After deleting records MOD
0223.00
0223.01 -- PF
0223.02 K_POFILE PF Interface for Purchase Order MOD
0223.03 K_POXREF PF Interface for PO Cross Reference file MOD
0223.04 K_READY PF Interface for file completion date MOD
0223.05
0224.00 -----------------------------------------------------------------------
0225.00 Programs and Files in library K3S_5OBJ
0226.00 -----------------------------------------------------------------------
0227.00
0228.00 -- RPGLE
0229.00 K3S_3041 History forcast changes log add program
0230.00
0231.00 -- CLLE
0232.00 K3S_9500CL Reorganize physical files - control
0233.00 K3S_9505CL Delete records based upon # days retention
0234.00
0235.00 -----------------------------------------------------------------------
0236.00 Changes for library QGPL/QCLSRC
0237.00 -----------------------------------------------------------------------
0238.00 None.
0229.00 K3S_3041 History forcast changes log add program
0230.00
0231.00 -- CLLE
0232.00 K3S_9500CL Reorganize physical files - control
0233.00 K3S_9505CL Delete records based upon # days retention
0234.00
0235.00 ---------------------------------------------------------------------
0236.00 Changes for library QGPL/QCLSRC
0237.00 ---------------------------------------------------------------------
0238.00 None.
0239.00
0240.00 ---------------------------------------------------------------------
0241.00 Special instructions for all customers
0242.00 ---------------------------------------------------------------------
0243.00
0244.00 The night job will need to END and START the webserver daily
0245.00 with a 30 second delay inbetween. We suggest doing this
0246.00 in K3S_NIGHT as the end of the web server will also end the
0247.00 locks from R6 PHP.
0248.00
0249.00 You will need to manually run the CHGPF command on K_INTORDF
0250.00 to add a column to the end of the file.
0251.00
0252.00 Manuall add the 4 indexes and 2 view to the 5DTA library:
0253.00 IX_APP_PO
0254.00 IX_LOGPROD
0255.00 IX_LTM_PO
0256.00 IX_ORD_PO
0257.00 K_NITECMB
0258.00 K_POLISTER
0259.00 Ensure the objects have text.
0260.00 Grant authority PUBLIC ALL to the object.
0261.00
0261.01 We are moving to new standards in the future that will require
0261.02 K_POFILE as the PO approval layout
0261.03 K_POXREF as the PO cross reference layout
0261.04 K_READY as the ready file layout
0261.05 If the customer is not already using files in 5MOD with these names
0261.06 copy in the source and object for future use.
0262.00 -----------------------------------------------------------------------
0263.00 Special instructions for some customers
0264.00 -----------------------------------------------------------------------
0265.00 None
0265.01 -----------------------------------------------------------------------
0265.02 Special notes for K3S.
0265.03 -----------------------------------------------------------------------
0265.04 AC_PSIMISC PRTF source promoted to K3S_5SRC.
0266.00 -----------------------------------------------------------------------
