|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
rcd_codes_mst |
Stores the information about all the Reason codes that are created in the system. |
component_id |
sql_variant |
Component Id |
Yes |
No |
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
event_name |
|
Event Name |
|
|
|
|
|
|
reason_code |
|
Reason Code |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
reason_descr |
sql_variant |
Reason Description |
|
|
|
|
|
|
status |
|
Status |
|
|
|
|
|
|
default_flag |
|
Default Flag |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
rcd_codes_tmp |
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
component_id |
|
Component Id |
|
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
event_name |
|
Event Name |
|
|
|
|
|
|
reason_code |
|
Reason Code |
|
|
|
|
|
|
reason_descr |
|
Reason Description |
|
|
|
|
|
|
status |
|
Status |
|
|
|
|
|
|
default_flag |
|
Default Flag |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
|
|
|
|
rcd_meta_code |
Stores the information about all the Reason codes that are created in the system. |
component_id |
sql_variant |
Component Id |
Yes |
|
|
|
|
|
tran_type |
|
Transaction Type |
|
|
|
|
|
|
event_name |
|
Event Name |
|
|
|
|
|
|
language_id |
int |
Language Id |
No |
|
|
|
|
|
component_name |
sql_variant |
Component Name |
|
|
|
|
|
|
trantype_desc |
|
Transaction Type Description |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|