database:functions:pears_iqxnetcompanystartdate



pears.IQXNetCompanyStartDate

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."IQXNetCompanyStartDate"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pCompanyID" CHAR(20) ) 
RETURNS DATE
BEGIN
  DECLARE "nrv" DOUBLE;
  SET "nrv" = NULL;
  SELECT FIRST "value" INTO "nrv" FROM "tagvalue" WHERE "taglocation" = 'C' AND "tagid" = '9X0' AND "id" = "pCompanyID";
  RETURN "dateadd"("day","isnull"("nrv",0),'1899-12-30')
END
  • database/functions/pears_iqxnetcompanystartdate.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1