Data Dictionary - Delivery Area
Table Name da_del_area_master
Table Comment Delivery Area Information This is the master information. This DA is associated with Customer code. Area code is unique acorss the organization DA Levels are created by the system as per the parent Devlivery area code, which is associated it’s always parent delarea code +1 = child’s level Parent delarea level will be always 1 Every Delarea code will have parent ref except the parent one.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DA_OU	INT	NOT NULL	OUINSTANCE CODE, DELIVERY AREA CREATED OU	Yes	No
da_Delarea_Code	varchar(18)	NOT NULL	Unique code of a delivery area.	Yes	No
DA_LO	varchar(20)	NOT NULL	DELAREA IS CREATED AT LO LEVEL LO information will be fetched based on the OU, the user logins in EMOD will give this information	No	No
DA_PAREANT_DELAREA_Code	varchar(18)	NULL	Unique code representing delivery area.	No	Yes
da_DelAreaDesc	varchar(25)	NOT NULL	Description of the Delivery Area for the unique Delivery Area code	No	No
da_DelAreaDesc_Shd	varchar(25)	NOT NULL	Description of the Delivery Area for the unique Delivery Area code shadow Description	No	No
da_Level	INT	NOT NULL	The level of delivery area hierarchy to which the particular delivery area belongs. The highest level being ’1’.	No	No
da_Reasoncode	varchar(10)	NULL	An unique code for identifying various reasons. Reason codes are pre-defined	No	No
da_Remarks	varchar(255)	NULL	Remarks captured here it’s a text column no validation on it-	No	No
da_Status	varchar(8)	NOT NULL	Active/Inactive/Canceled	No	No
da_Created_by	varchar(30)	NOT NULL	created User name	No	No
da_Created_date	datetime	NOT NULL	Delivery Area created date	No	No
da_Modified_by	varchar(30)	NOT NULL	Login user who modified	No	No
da_Modified_date	datetime	NOT NULL	Delivery area modified date	No	No
da_Timestamp_value	INT	NOT NULL	Timestamp value	No	No
da_addl1	INT	NULL	Address1	No	No
da_addl2	varchar(255)	NULL	Address2	No	No
da_addl3	varchar(255)	NULL	Address3	No	No
Table Name da_row_count_tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
selcted_rows	INT	NULL	Selected rows	No	No
guid	varchar(128)	NULL	Guid	No	No