All public logs
Jump to navigation
Jump to search
Combined display of all available logs of KeystoneIntranet. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
- 19:33, 27 August 2024 Chanson talk contribs created page File:DeviceServerRemoteConfigA.PNG (File uploaded with MsUpload)
- 19:33, 27 August 2024 Chanson talk contribs uploaded File:DeviceServerRemoteConfigA.PNG (File uploaded with MsUpload)
- 15:34, 27 March 2024 Chanson talk contribs created page QueryGen Case: Add missing item to all Jobs (Created page with "Sometimes you want to add an detail item to all jobs. In this case, we will add the item ENVIRO.01 (adjusted to plant) to all jobs wher it is missing. In the query below we select all jobs and identify which do NOT have a product like ENVIRO. Artjob as d1 represents the detail line that should exist if ENVIRO.XX is in the job detail. Artjob as d0 is used to find a valid plant number on a product. (you can't count on the job header). <pre> select h.session_no,h.trans_...")
- 16:18, 27 February 2024 Chanson talk contribs created page Microsoft SQL Server Query Features (Created page with "===trim=== ltrim rtrim select trim(address1) from Customer ===concat=== ===replace=== Replace singele quote with 2 single quotes: <code>replace(rtrim(ltrim(NAME)),'''','''''') "DRIVER_NAME",</code> ===left, right=== ===case=== ===iif=== ===windowing functions=== ===rank=== ===derived queries=== Derived queries, fequently seen as a "with" statement... allow for querying queries.")
- 12:29, 19 February 2024 Chanson talk contribs created page Examples by Table (Created page with " *'''ACCT:''' GL Accounts *'''ARTB:''' Aging *'''CCON:''' Contact Connection *'''COMP:''' Company *'''CPRD:''' Customer Prices *'''CTCT:''' Contact *'''CUST:''' Customer Prices *'''EMPL:''' Employee - Sales and Drivers *'''ICAT:''' Item (Product) *'''ICST:''' Component Structure *'''ILOC:''' Product by Location (Similar to Plant) *'''IMST:''' Products *'''IPRC:''' Prices - by Level (Group) *'''LOCN:''' Locations (Similar to Plant) *'''PLNT:''' Plant *'''PRCC:''' Price...")
- 17:02, 21 November 2023 Chanson talk contribs created page Command Import: Rain MO Work Notes (Created page with "<pre> PLANTS=========================== SELECT * FROM PLNT INSERT INTO ARTPLANT ( PLANT_NO, SYS_LOC, PLANT_NAME, ADDRESS_1, ADDRESS_2, PHONE_NO, PLANT_TYPE, PLANT_SCREEN_ID, DIVISION_NO,PLANT_WASH_MINLD, JOB_WASH_MINLD, BATCH_CAPACITY, MEMO, IMPORTED_FLAG, LAST_CHANGE_DATETIME, LAST_CHANGE_USER, ACTIVE_FLAG ) VALUES ( '{plant_code|trim=0}', 0, '{name}', '{addr_line_1}', '{addr_line_2}', '{PHONE_Num}', 'D', '{short_name}', null, {PLANT_WASHDOWN_TIME}, {JOB_WASHDOWN_T...")
- 16:48, 21 November 2023 Chanson talk contribs created page Command Import: Hedger Work Notes (Created page with "<pre> 2022DEC19 ==Customer Class select ltrim(rtrim(sales_anl_code)) class_no, ltrim(rtrim(descry)) description, * from sanl == INSERT INTO artcucls ( CLASS_NO, DESCRIPTION, IMPORTED_FLAG, LAST_CHANGE_DATETIME, LAST_CHANGE_USER, ACTIVE_FLAG ) VALUES ( '{CLASS_NO}', '{DESCRIPTION|LEN=35}', 'Y', CAST('TODAY' AS TIMESTAMP), 'HIT', 'Y' ); == ==Price Groups SELECT RTRIM(LTRIM(replace(PRICE_CAT,'.',''))) GROUP_NO, RTRIM(LTRIM(DESCR)) DESCRIPTION, PRCC.* FROM prcc =...")
- 16:06, 21 November 2023 Chanson talk contribs created page Command Import (Created page with " ===Hedger Work Notes===")
- 12:38, 17 November 2023 Chanson talk contribs created page Dispatch Option: Status Configuration (Created page with "Custom Column Headers can be applied to the dispatch schedule screen... File:DispStatsConfig.png")
- 12:37, 17 November 2023 Chanson talk contribs created page File:DispStatsConfig.png (File uploaded with MsUpload)
- 12:37, 17 November 2023 Chanson talk contribs uploaded File:DispStatsConfig.png (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:ResetCache1.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:ResetCache1.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:RemotePlantSetup.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:RemotePlantSetup.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:RemoteLocationSetup.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:RemoteLocationSetup.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:RemoteLicenseSetup.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:RemoteLicenseSetup.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:Readmeta sql.txt (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:Readmeta sql.txt (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:Queue Properties.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:Queue Properties.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:QryUpdExtCostSlsPvt.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:QryUpdExtCostSlsPvt.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:QG Test 3.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:QG Test 3.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:QG Test 2.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:QG Test 2.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs created page File:QG Test 1.PNG (File uploaded with MsUpload)
- 18:35, 14 July 2023 Chanson talk contribs uploaded File:QG Test 1.PNG (File uploaded with MsUpload)
- 17:10, 14 July 2023 Chanson talk contribs created page File:VirtualNullModem.zip (File uploaded with MsUpload)
- 17:10, 14 July 2023 Chanson talk contribs uploaded File:VirtualNullModem.zip (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:Zonehistory.png (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:Zonehistory.png (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:XE7IBConsoleUpdateError.png (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:XE7IBConsoleUpdateError.png (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:Windows10Winver.png (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:Windows10Winver.png (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:Windows Power Options.PNG (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:Windows Power Options.PNG (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:Windows Message Queuing Feature.PNG (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:Windows Message Queuing Feature.PNG (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:WebUpdateTerminalServer.jpg (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:WebUpdateTerminalServer.jpg (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:Web Update.pdf (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:Web Update.pdf (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:Universal Link TCPIP.pdf (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs uploaded File:Universal Link TCPIP.pdf (File uploaded with MsUpload)
- 16:55, 14 July 2023 Chanson talk contribs created page File:ULINK to KEYSTONE Field Mappings.pdf (File uploaded with MsUpload)
