pears.companyinfo [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.companyinfo ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

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

===== Original SQL =====
<code 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
}
</code>