Open nmfujimoto opened 3 years ago
What Column Alias drop-down option displays the Program EDI Condition mapping fields?
Ran the below query in the database to correct the Alias name:
UPDATE dbo.SYSTM000ColumnsAlias SET ColAliasName = REPLACE(ColAliasName, 'esh ', ''), ColCaption = REPLACE(ColCaption, 'esh ', ''), ColGridAliasName = REPLACE(ColGridAliasName, 'esh ', ''), ColDescription = REPLACE(ColDescription, 'esh ', '') Where ColAliasName Like 'esh%'
UPDATE dbo.SYSTM000ColumnsAlias SET ColAliasName = REPLACE(ColAliasName, 'I D', 'ID'), ColCaption = REPLACE(ColCaption, 'I D', 'ID'), ColGridAliasName = REPLACE(ColGridAliasName, 'I D', 'ID'), ColDescription = REPLACE(ColDescription, 'I D', 'ID') Where ColColumnName Like 'esh%'
UPDATE dbo.SYSTM000ColumnsAlias SET ColAliasName = REPLACE(ColAliasName, 'U D F', 'UDF'), ColCaption = REPLACE(ColCaption, 'U D F', 'UDF'), ColGridAliasName = REPLACE(ColGridAliasName, 'U D F', 'UDF'), ColDescription = REPLACE(ColDescription, 'U D F', 'UDF') Where ColColumnName Like 'esh%'
UPDATE dbo.SYSTM000ColumnsAlias SET ColAliasName = REPLACE(ColAliasName, 'B O L', 'BOL'), ColCaption = REPLACE(ColCaption, 'B O L', 'BOL'), ColGridAliasName = REPLACE(ColGridAliasName, 'B O L', 'BOL'), ColDescription = REPLACE(ColDescription, 'B O L', 'BOL') Where ColColumnName Like 'esh%'
@nmfujimoto Testing completed on Staging environment and It is working as expected.
The Program EDI Assign Jobs section needs to have the following fields available in the drop down for the EDI 204.
Add the options for the Assign Jobs EDI fields available to search on: