Table of Contents



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
}