Match Orgname Table

From edegan.com
Jump to navigation Jump to search

Table Structure

           Table "public.matchorgname"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
stdorgname | character varying(255) | 
orgname    | character varying(255) | 

Example of table entries:

           stdorgname            |             orgname               
---------------------------------+----------------------------------
000 “Midera-K”                   | 000 “Midera-K”
000 “MP ELSYS”                   | 000 “MP ELSYS”
002134761 Ontario Ltd.           | 002134761 Ontario Ltd.
002152706 Ontario Ltd.           | 002152706 Ontario Ltd.
002152706 Ontario Ltd.           | 002152706 ONTARIO LTD.
0055 Management Services Pty Ltd | 0055 Management Services Pty Ltd
01Click, L.L.C.                  | 01Click, L.L.C.
01 Communique Laboratory Inc.    | 01 Communique Laboratory Inc.
01 dB Metravib                   | 01 dB Metravib
01 Inc.                          | 01 Inc.

Table Variables

The stdorgname is the standardized name of a firm or organization. The orgname is any name used to refer to a firm. The table has a composite key consisting of a unique pair of stdorgname and orgname.

Table Purpose

Current Problems