On my Order Entry > Releases > Detail screen there are 2 fields labeled:
- Orig Need By (Mapped to OrderRel.Date05)
- Orig Ship By (Mapped to OrderRel.Date04)
Those fields seem to reflect exactly what they say, the original dates.
The issue I am having is that for the life of me I cannot find where those fields are being set at. I have looked through all of the usual places, and am coming up dry.
I looked through the code on the Customization for the Order Entry screen, and there is nothing in there that references those fields. I have looked through all of the BPMs for OrderRel, OrderDtl , and OrderHed and am not finding anything that references Date04 or Date05 in the OrderRel table. I also went and looked at the relevant tables for Customizations and BPMs in the database and found nothing.
I even went as far as to looking at the SP’s in SQL, with no luck either.
Used this to search Customization’s:
SELECT
Key1 AS [Name]
,Key2 AS [Program]
,Description AS [Description]
,Content AS [Content]
,CASE
WHEN OnMenu = 1 THEN 'Active'
ELSE 'Not Active'
END AS [Status]
FROM Ice.XXXDef
WHERE TypeCode = 'Customization'
AND Content LIKE '%OrderRel%Date04%'
ORDER BY Key2 ASC
The only item that was returned was the Customization where those fields were put onto the form.
To search the BPM’s, I ran this:
SELECT
bd.Source
,bd.BpMethodCode
,bd.Name
,bdt.Name
FROM Ice.BpDirective bd
LEFT OUTER JOIN Ice.BpDirectiveType bdt
ON bd.Source = bdt.Source
AND bd.DirectiveType = bdt.DirectiveType
WHERE IsEnabled = 1
AND CAST(bd.Body AS NVARCHAR(MAX)) LIKE '%OrderRel%Date04%'
ORDER BY bd.Source, bd.BpMethodCode
The results from that were just the BPM’s that enable the Change Log’s.
SELECT DISTINCT
A.Name AS OBJECT_NAME
,A.TYPE_DESC
FROM sys.SQL_MODULES M
INNER JOIN sys.OBJECTS A
ON M.object_id = A.object_id
WHERE type_desc = 'SQL_STORED_PROCEDURE'
AND M.DEFINITION LIKE '%OrderRel%Date04%'
ORDER BY TYPE_DESC
That returned nothing outside of the standard ZFW*_GetByID/GetRows/GetBySysRowID Stored Procedures.
There are no Database Triggers defined either.
Here are the properties for one of the controls. The other is setup the exact same but for OrderRel.Date04 instead of OrderRel.Date05.
I looked in the User Defined Column Mapping as well, but that was not any help.
The UD Column Maintenance proves to be just as unhelpful.
The only thing that I can think of is that perhaps it is being set during the EDI process (Demand Workbench/Mass Review), but I didn’t find anything there either.
Any thoughts on where else I should be looking? Is there some other place that could be updating those fields that I haven’t thought of yet? (I think I covered it all)
