Release 5.5 Technical Notes
0001.00 -----------------------------------------------------------------------
0002.00 Notes for Release 5.5 Jan 01, 2018 rel_5.5.doc
0003.00 -----------------------------------------------------------------------
0004.00
0005.00 01) K3S_CVRT22 - Changes to table code records/New table code records:
0006.00
0007.00 API - Setup values and info for the APIs and Night JOB
0008.00
0009.00 MATH - Do we want to use EVAL (Flag 1=0) or
0010.00 %DECH (Flag 1=1) for math
0011.00
0012.00 VER - This is the version of the APIs
0013.00
0014.00 APP Application codes
0015.00
0016.00 K3S_3030 NO_FACTR_0 - Do not allow a Seasonal
0017.00 Profile to be added with a
0018.00 Factor of .00 ?
0019.00
0020.00 APR - PO Approval codes
0021.00
0022.00 HLDBEG - Hold Out Begin Date
0023.00 HLDEND - Hold Out End Date
0024.00 HLDREAS - Hold Out Reason
0025.00 LOCNFRM - Location From
0026.00 LOCNTO - Location To
0027.00 POBLANK - PO Blank Field
0028.00 POMSG1 - PO Message Line 1
0029.00 POMSG2 - PO Message Line 2
0030.00 POMSG3 - PO Message Line 3
0031.00 POMSG4 - PO Message Line 4
0032.00 POMSG5 - PO Message Line 5
0033.00 POMSG6 - PO Message Line 6
0034.00 POMSG7 - PO Message Line 7
0035.00 SKIPLT - Skip PO from LT forecast
0036.00 USERA01 - User defined alpha 1
0037.00 USERA02 - User defined alpha 2
0038.00 USERA03 - User defined alpha 3
0039.00 USERA04 - User defined alpha 4
0040.00 USERA05 - User defined alpha 5
0041.00 USERA06 - User defined alpha 6
0042.00 USERA07 - User defined alpha 7
0043.00 USERA08 - User defined alpha 8
0044.00 USERA09 - User defined alpha 9
0045.00 USERA10 - User defined alpha 10
0046.00 USERH01 - User defined header 01
0047.00 USERH02 - User defined header 02
0048.00
0049.00 BBK - Special access granted for BlackBean Users
0050.00
0051.00 RELEASE LEVEL - 5
0052.00
0053.00 DEV - Developer values
0054.00
0055.00 API - The default email address that we send
0056.00 all API dumps to
0057.00 DEL - The default amount of days to keep in
0058.00 the API Log
0059.00 ENV - This table code sets if we are in production,
0060.00 testing, or development
0061.00
0062.00 GPH - Graphing Parameters
0063.00
0064.00 XXXXX - Default jumk Buyer Group
0065.00
0066.00 MAN - Manager Dashboard Values
0067.00
0068.00 HGH - High Performance Inventory Reduction Percent
0069.00 INS - Insurance
0070.00 LOW - Low Performance Inventory Reduction Percent
0071.00 MDM - Medium Performance Inventory Reduction Percent
0072.00 MON - Cost of Money
0073.00 OBS - Obsolescence and Spoilage
0074.00 SHK - Shrinkage and Damage
0075.00 STR - Storage Costs
0076.00 TAX - Taxes
0077.00
0078.00 SEA - Security for Calling APIs
0079.00
0080.00 UPDPROD - Update Product
0081.00
0082.00 SEC - Security for Viewing Page
0083.00
0084.00 AAA - Admin
0085.00 AAB - Manager Dashboard
0086.00 AAC - Supplier Metrics
0087.00 AAD - Company Settings
0088.00 AAE - Location Settings
0089.00 AAF - Buyer Settings
0090.00
0091.00 SEM - Security for Viewing Menu Options
0092.00
0093.00 AAA - Supplier Settings
0094.00 AAB - Manager Dashboard
0095.00 AAC - Performance Metrics
0096.00 AAD - Management
0097.00 AAE - Admin
0098.00
0099.00 SER - Security Roles and Levels
0100.00
0101.00 ADMIN - Admin
0102.00 BUYER - Buyer
0103.00 MANAGER - Manager
0104.00 OWNER - Owner
0105.00 VIEWER - Viewer
0106.00
0107.00 SPR - Selected records review types
0108.00
0109.00 PDF - Products link type D - From
0110.00 PDT - Products link type D - To
0111.00
0112.00 02) K3S_CVRT25 - This fix was for library K3S_5CNV used to convert a new
0113.00 customer. When DE_FACTTYP = %
0114.00 then DE_UNITPRO must be a 1
0115.00 Program K3S_CVRT25 already patched in K3S_5CNV for new
0116.00 customer installs.
0117.00 Existing customers being patched with K3S_FX550B.
0118.00
0119.00 03) K3S_C152 - /COPY Notes system logic
0120.00
0121.00 04) K3S_FX55BA - BB Patch K_PRODUCT field PR_SEASSRC where blank
0122.00
0123.00 05) K3S_FX55BB - BB Patch K_SUPLPUR for year 2017 Approved orders
0124.00
0125.00 06) K3S_FX55BC - BB Patch 5 K_TABLCOD records
0126.00
0127.00 07) K3S_FX55BD - BB Patch K_TABLCOD APP 'PRODUCT DISPLAY'
0128.00
0129.00 08) K3S_FX550A - Patch K_NOTEPAD file for new Global definition
0130.00
0131.00 09) K3S_FX550B - Patch K_DEALENT when FACTTYP=% then UNITPRO=1
0132.00
0133.00 10) K3S_FX550C - Update K_TABLCOD with BB definitions for SPR
0134.00
0135.00 11) K3S_FX550D - Patch K_K3SRPT for Obsolete Products CSV logic
0136.00
0137.00 12) K3S_LOADDT - Load products Day Time into K_INTPRDT
0138.00
0139.00 13) K3S_PDTYP - Find Product Links Type D for From or To
0140.00
0141.00 14) K3S_0010 - Display new Release info R5.5 January 1st, 2018
0142.00 K3S_0010FM - When user had a 2nd Note line, an '*' would appear
0143.00 like a Global Note. Fixed to not display '*'.
0144.00
0145.00 15) K3S_1011 - Create fresh suggested orders for a Location
0146.00 K3S_1011FM
0147.00 K3S_1011CL
0148.00
0149.00 16) K3S_1011PR - Mid-day K3S update by Location - K_PRODUCT
0150.00
0151.00 17) K3S_1040 - Global Note exists, protect Note line
0152.00 K3S_1040FM
0153.00 K3S_1041
0154.00 K3S_1041FM
0155.00
0156.00 18) K3S_1500 - If buyer is re-calculating a suggested order,
0157.00 make sure new suggested order has Order Busy
0158.00 Flag on
0159.00 - Important notes about field PR_NONSTCK
0160.00 and field PQ_NONSTCK for future database.
0161.00
0162.00 19) K3S_1500G5 - Create suggested orders - one supplier, PR_GROUP5
0163.00
0164.00 20) K3S_1920 - Ability to split out added products via PR_GROUP5
0165.00 field. Can be run via K3S_3006CL.
0166.00
0167.00 21) K3S_3000 - Global Note exists, protect note line
0168.00 K3S_3000FM
0169.00
0170.00 22) K3S_3001 - Default Cost Divisor from Product file, unless
0171.00 entered by user.
0172.00 - Allow user to enter SOQ inconsistent with
0173.00 buy multiple if user preference for auto-rounding
0174.00 is turned OFF.
0175.00
0176.00 23) K3S_3006 - Daytime add products to K3S, stock and non-stock
0177.00 K3S_3006CL
0178.00
0179.00 24) K3S_3009 - Determine if an order is locked by user
0180.00 K3S_3009CL Check for locked order, then recalculate orders
0181.00
0182.00 25) K3S_3023 - Order includes new Stock or Non-stock make 'SO'
0183.00
0184.00
0185.00 26) K3S_3030 - Global note exists, protect Note line
0186.00 K3S_3030FM - Controlled by an APP record, block any
0187.00 K3S_3031 profiles from being added that contain
0188.00 K3S_3031FM a Factor of 0.
0189.00
0190.00 27) K3S_3043 - Adjust K_INTDALY for supplier switch
0191.00
0192.00 (Mutual)
0193.00 28) K3S_3050 - New capability to F9=Generate entries to
0194.00 K3S_3050FM Hold Out file via user's system supplier
0195.00 K3S_3052CL
0196.00 K3S_3059CL
0197.00
0198.00 (Raben)
0199.00 29) K3S_3100 - New batch types can be generated:
0200.00 PDF - Products link type D - From
0201.00 PDT - Products link type D - To
0202.00
0203.00 30) K3S_3110 - Fix calculations when looking at the past
0204.00 3 history periods with seasonal facctors:
0205.00 FHI - Forecast too high
0206.00 FLO - Forecast too low
0207.00
0208.00 31) K3S_3300CL - Fix to PARM passed to be &PRODGP4
0209.00 instead of &SUPLGP4
0210.00
0211.00 32) K3S_3434 - Weekly Distribution - close out old Wxx
0212.00 K3S_3435CL batches, so that only current is open
0213.00
0214.00 33) K3S_6010 - Remove F4= function, and protect several
0215.00 K3S_6010FM fields. No RPG changes.
0216.00
0217.00 34) K3S_7100CL - Close out old PE1-PE5 batches. Only current
0218.00 K3S_7140 PE checks stay 'O' Open.
0219.00
0220.00 35) K3S_8000 - Adjustments for Global notes.
0221.00
0222.00 36) K3S_8030 - Adjustments for Global notes.
0223.00
0224.00 (Mutual)
0225.00 37) K3S_9010 - For this program we were not capturing the
0226.00 previous supplier sub code field LG_PRVSPLB.
0227.00 The field LG_PRVSPLB was not defined in ANY
0228.00 program prior to this fix in _5DTA or _5MOD.
0229.00 It did not negatively effect showing the
0230.00 previous supplier's name field LG_PRVNAME
0231.00 since that was captured properly.
0232.00 This would effect trying to use the log file
0233.00 K_LOGPROD type '2' product changing supplier
0234.00 until all customers have this fix, where our
0235.00 thinking is to update K_INTDALY some day.
0236.00 btw... K3S_9011 did not need fix, since we
0237.00 only 'add' new products there, and don't
0238.00 switch suppliers.
0239.00
0240.00 -----------------------------------------------------------------------
0241.00 Physical & logical files added/changed/deleted in release for K3S_5DTA
0242.00 -----------------------------------------------------------------------
0243.00
0244.00 There is 1 new Physical file & 1 new Logical file added in this release
0245.00
0246.00 K_INTPRDT PF Interface products daytime stock and non-stock (IG)
0247.00 K_INTPRDTA LF Interface products daytime LOCN,SUPL,SUB,PROD
0248.00
0249.00 After this release installed, there should be exactly 497 objects
0250.00 in library K3S_5DTA (data files library) (Rel 5.4 had 495 objects)
0251.00
0252.00 -----------------------------------------------------------------------
0253.00 Programs and Files in library K3S_MOD550
0254.00 -----------------------------------------------------------------------
0255.00
0256.00 -- RPGLE
0257.00 K3S_CVRT22 New Table Code entries
0258.00 K3S_LOADDT Load products day time into K_INTPRDT
0259.00 K3S_PDTYP Find Prouct Links Type D for From or To
0260.00 K3S_1011 Create fresh suggested orders for a location
0261.00 K3S_1011PR Mid-day K3S update by Location - K_PRODUCT
0262.00 K3S_3006 Daytime add products to K3S, stock and non-stock
0263.00 K3S_3043 Adjust K_INTDALY for supplier switch
0264.00
0265.00 -- CLLE
0266.00 K3S_1011CL Mid-day K3S update by Location
0267.00 K3S_3006CL Day time add products, stock and non-stock
0268.00 K3S_3009CL Check for locked order, then re-calculate
0269.00
0270.00 -- CMD
0271.00 none
0272.00
0273.00 -- DSPF
0274.00 K3S_1011FM Mid-day K3S update for a location
0275.00
0276.00 -----------------------------------------------------------------------
0277.00 Special instructions for all customers
0278.00 -----------------------------------------------------------------------
0279.00 The one object that you must move to K3S_5MOD (or equivalent) just after
0280.00 upgrade is K3S_PDTYP. Then test either PDF or PDT for new Batch.
0281.00 -----------------------------------------------------------------------
0282.00 Special instructions for some customers
0283.00 -----------------------------------------------------------------------
0284.00
0285.00 Duncan Supply
0286.00 Add back DPG - BUYERS K3S_4031 - Product Group Service Level Targets
0287.00
0288.00 -----------------------------------------------------------------------
