database:views:pears_companyinfo



pears.companyinfo

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

Description

Consolidated address and phone(etc) fields for a Company record

Original SQL

CREATE VIEW "pears"."companyinfo"( "companyid",
  "addressonline","phones" ) 
  AS SELECT "company"."companyid","pears"."GetCompanyAddressOnLine"("company"."companyid"),
    "pears"."getcompanyphoneinblock"("company"."companyid") FROM "pears"."company"
GO
 
COMMENT ON VIEW "pears"."companyinfo" IS 
	'Consolidated address and phone(etc) fields for a Company record'
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."companyinfo" IS 
{CREATE VIEW companyinfo 
(companyid,addressonline,phones)
AS SELECT company.companyid,pears.GetCompanyAddressOnLine(company.companyid),
pears.getcompanyphoneinblock(company.companyid) FROM pears.company
}
  • database/views/pears_companyinfo.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1