hasokeric

WITH fk_info AS (
    SELECT
        JSON_QUERY(
            '[' + STRING_AGG(
                CONVERT(nvarchar(max),
                JSON_QUERY(N'{"schema": "' + COALESCE(REPLACE(kcu.CONSTRAINT_SCHEMA, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS +
                            '", "table": "' + COALESCE(REPLACE(kcu.TABLE_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS +
                            '", "column": "' + COALESCE(REPLACE(kcu.COLUMN_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS +
                            '", "foreign_key_name": "' + COALESCE(REPLACE(kcu.CONSTRAINT_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS +
                            '", "reference_table": "' + COALESCE(REPLACE(rcu.TABLE_NAME, '"', ''), '') COLLATE SQL_Latin1_General_CP1_CI_AS +

hasokeric

   +----------------------------+
   |    File Transmission Record |
   +----------------------------+
             |
             v
   +----------------------------+   <--------- First physical record(s) on file
   |     File Header Record     |   <--------- Type 1 - File Header Record
   +----------------------------+   <--------- One per file - first logical record on file
             |
             v

hasokeric

using System;
using System.Linq;
					
public class Program
{
	public static void Main()
	{
		Func<string, int> GetCheckDigit = _routingNumber =>
			(10 - _routingNumber.Where(char.IsDigit)
							.Select((digit, index) => (digit - '0') * new[] { 3, 7, 1 }[index % 3])

hasokeric

Dashboard/App Studio Problems & Ideas

PROBLEMS

1. Can't Update a Base App Created by Someone Else

Description	Details
Problem	Happened with dbd template created by Michael; I could not update. Also after we upgraded - since Michael exported and imported all into Prod, he became the "owner" of all dashboards.
Workaround	IAI Workaround: BPM (see Custom Kinetic Application Base layer not available to another developer). Another option: Add a security group. See Anybody with dashboard developer.

hasokeric

ERP Part Numbering Standards for Manufacturing

Epicor Recommendations: Part Numbering

Introduction

This document serves as a guideline for developing and using good part numbering techniques within a manufacturing company. It addresses accidental and overly complex part numbering schemes which may become unmanageable and highlights that a part number is generally NOT a description of the part.

Definition

A part number should not attempt to be descriptive as it could lead to complications over time, such as changes in manufacturing or purchasing processes. The focus is on using the part number as a primary index within an ERP system.

hasokeric

#!/bin/bash

# We don't need return codes for "$(command)", only stdout is needed.
# Allow `[[ -n "$(command)" ]]`, `func "$(command)"`, pipes, etc.
# shellcheck disable=SC2312

set -u

abort() {
  printf "%s\n" "$@" >&2

hasokeric

// Count up the UnderIssuedMtls and UnderReportedOprs to show in the ShipDtl grid on Summary Tab

foreach (var row in ttShipDtl.Where(x => x.OurJobShipQty > 0).ToList())
{
    // Get all the UnderIssuedMtl Count
    int UnderIssuedMtlCount = (from jp in Db.JobPart
                               join jm in Db.JobMtl on new { jp.Company, jp.JobNum } equals new { jm.Company, jm.JobNum }
                               where jp.Company == row.Company &&
                                     jp.JobNum == row.JobNum &&
                                     jp.PartNum == row.PartNum &&

hasokeric

//var x = defaultImpl.CreateEmpty(result);
//this.resultHolder.Attach(QueryResultDataSetUbaqTableset.FromDataSet(result));

ResultsUbaqRow row = (ResultsUbaqRow)result.Results.NewRow();

row.SysRowID = Guid.NewGuid();
row.Calculated_RowStatus = "Meow";
row.RowIdent = row.SysRowID.ToString();
row.RowMod = "A";
var z = ((ResultsUbaqTable)result.Results);

hasokeric

swa deploy .\build\ --env production --app-name swa

hasokeric

var resourceGroupRows = Db.ResourceGroup.Where(x => x.Company == Session.CompanyID
        && x.Inactive == false
        && 
    ).ToList();

var resourceCalRows = Db.ResourceCal.Where(x => x.Company == Session.CompanyID
        && x.SpecialDay >= DateTime.Today
    ).Join(Db.ResourceGroup,
            rc => new { rc.Company, rc.ResourceGrpID, Inactive = false },
            rg => new { rg.Company, rg.ResourceGrpID, rg.Inactive },