|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
QCD_QUICK_CODES_DTL |
Stores the information about all the Quick codes that are created in the system. |
LANGUAGE_ID |
decimal(10) |
Language Id |
Yes |
No |
|
|
|
|
ENTITY |
varchar(40) |
Entity |
|
|
|
|
|
|
QUICK_CODE |
varchar(20) |
Quick Code |
|
|
|
|
|
|
TIMESTAMP |
decimal(10) |
Time Stamp |
No |
|
|
|
|
|
QUICK_CODE_VALUE |
varchar(40) |
Quick Code Value |
|
|
|
|
|
|
DEFAULT_VALUE |
varchar(3) |
Default Value |
|
|
|
|
|
|
STATUS |
|
Status. Values ACT -active ,IAC-inactive |
|
|
|
|
|
|
FROM_DATE |
sql_variant |
From Date |
|
|
|
|
|
|
QUICK_CODE_TYPE |
varchar(3) |
Quick Code Type |
|
|
|
|
|
|
CREATEDBY |
varchar(15) |
Created By |
|
|
|
|
|
|
CREATEDDATE |
sql_variant |
Created Date |
|
|
|
|
|
|
MODIFIEDBY |
varchar(15) |
Modified By |
|
|
|
|
|
|
MODIFIEDDATE |
sql_variant |
Modified Date |
|
|
|
|
QCD_QUICK_CODES_MST |
Stores the information about all the Quick codes that are created in the system. |
ENTITY |
varchar(40) |
Entity |
Yes |
|
|
|
|
|
QUICK_CODE |
varchar(30) |
Quick Code |
|
|
|
|
|
|
TIMESTAMP |
decimal(10) |
Time Stamp |
No |
|
|
|
|
|
CREATEDBY |
varchar(15) |
Created By |
|
|
|
|
|
|
CREATEDDATE |
datetime |
Created Date |
|
|
|
|
|
|
MODIFIEDBY |
varchar(15) |
Modified By |
|
|
|
|
|
|
MODIFIEDDATE |
datetime |
Modified Date |
|
|
|
|
qcd_quick_codes_tmp |
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
entitiy |
|
Entity |
|
|
|
|
|
|
quick_code |
|
Quick Code |
|
|
|
|
|
|
quick_code_value |
|
Quick Code Value |
|
|
|
|
|
|
default_value |
|
Default Value |
|
|
|
|
|
|
status |
|
Status. Values ACT -active,IAC-inactive |
|
|