INDIAN MARKETER DCA TABLES

Title: DCA Tables - Dept. of Company Affairs CD (Mar 2000)

Table : cmp	Search Parameter	Display in Results
Fields
ST CODE	$-$	$-$
REG NO	$-$	$-$
CO NAME	$\checkmark$	$\checkmark$
NMCD	?	?
ADDRESS	X	$\checkmark$
CITY	$\checkmark$	$\checkmark$
STATE	$\checkmark$	$\checkmark$
PIN CODE	X	$\checkmark$
TELEPHONE	X	$\checkmark$
FAX	X	$\checkmark$
EMAIL	X	$\checkmark$
REG DATE	X	X
IACD	?	?
TYPE	?	?
CATG	?	?
CO STATUS	?	?
A CAP	?	?
IACDDESC	?	?
PSTAT	?	?
3P_Ind_code	$\checkmark$	$\checkmark$

 

Note: The handwritten signature "Abhi" and date "18/4/03" are at the bottom.

TABLE : cmp0, cmp1, cmp20, cmp22, cmp25, cmp30, cmp31, cmp33, cmp35, cmp37, cmp5, cmp60, cmp62, cmp64, cmp7, cmp800, cmp801, cmp81

Fields
ST_CODE
REG NO
CO_NAME
NMCD
ADDRESS
CITY
STATE
PIN_CODE
TELEPHONE
FAX
REG DATE
IACD
TYPE
CATG
CO_STATUS

 

Table : Company_Desc	Search Parameter	Display
Fields
CO DESC	X	$\checkmark$
INDUSTRY ID	X	X
DCA's own?

 

Foreign Companies

Table : forcos	Search Parameter	Display
Fields
REG NO	X	X
CO NAME	$\checkmark$	$\checkmark$
NMCD		$\checkmark$
ADDRESS	X	$\checkmark$
COUNTRY	$\checkmark$	$\checkmark$
REG DATE	X	X
EST DATE	X	X
IAC	?	?
INDACT	?	?
GLOBAL	?	?
STATUS	?	?

 

Question: Does this mean DCA have developed their own Industry code? How many? can we 'MAP' with 3P ind_code?

Table : ind_code	Search Parameter	Display
Fields
CODE	X	X
DESC	X	X
GRAPH	X	X

 

NOTE

Neither in "Search-parameters", nor in any display, we should ever use following fields/values:

$\rightarrow$ DCA "REG NO"

$\rightarrow$ DCA "REG DATE"

$\rightarrow$ DCA "INDUSTRY ID"

$\rightarrow$ DCA "EST DATE"

$\rightarrow$ DCA "IND. CODE"

$\rightarrow$ DCA "DESC"

$\rightarrow$ DCA "GRAPH"

TABLE: mainscr2

Fields
MAINSCR

 

Table : name

Fields
ST CODE
REG NO
CO NAME
NMCD

 

Table : pcode	Search Parameter	Display
Fields
ITC CODE	$\checkmark$	$\checkmark$
PRODUCT	$\checkmark$	$\checkmark$
IND CODES	X	X

 

Table : prod	Search Parameter	Display
Fields
ST CODE
REG NO	X	X
ITC CODE1		$\checkmark$
PRODUCT1	$\checkmark$	$\checkmark$
ITC CODE2	$\checkmark$	$\checkmark$
PRODUCT2	$\checkmark$	$\checkmark$
ITC CODE3	$\checkmark$	$\checkmark$
PRODUCT3	$\checkmark$	$\checkmark$

 

Table : submas	Search Parameter	Display
Fields
ST CODE
STATE		X
REG NO	X	$\checkmark$
CO NAME		$\checkmark$
NMCD	$\checkmark$	$\checkmark$
PARENT CO	$\checkmark$	$\checkmark$
COUNTRY	$\checkmark$	$\checkmark$
ADDRESS	X	$\checkmark$
CSUDATE	X	X
UDDATE
IACD
BUSINESS
STATUS
HCO PERC
QDSTAT	X	X

 

Table: suggest
Fields
Suggest