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 across the organization DA Levels are created by the system as per the parent Delivery 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 |
|
guide |
varchar(128) |
NULL |
Guide |
No | No |
|
|
|
|
|
|
|