Data Dictionary -- Quick Codes
Srl. No. Table Name Comment
1QCD_QUICK_CODES_DTLStores the Details of Quick Codes
2QCD_QUICK_CODES_MSTStores the Information of Quick Codes
Table Name : QCD_QUICK_CODES_DTL
Comment :Stores the Details of Quick Codes
Column Name UDD Data Type Is NULL? Comment Is PK?
LANGUAGE_IDfin_decimaldecimal(17)NoLanguage idYes
ENTITYfin_varcharvarchar(800)NoEntityYes
QUICK_CODEfin_varcharvarchar(800)NoQuick codeYes
TIMESTAMPfin_decimaldecimal(17)NoTimestampNo
QUICK_CODE_VALUEfin_varcharvarchar(800)YesQuict code valueNo
DEFAULT_VALUEfin_varcharvarchar(800)YesDefault valueNo
STATUSfin_varcharvarchar(800)YesStatusNo
FROM_DATEudd_date2varchar(11)YesFrom dateNo
QUICK_CODE_TYPEfin_varcharvarchar(800)YesQuick code typeNo
CREATEDBYfin_varcharvarchar(800)YesCreated byNo
CREATEDDATEudd_date2varchar(11)YesCreated daeNo
MODIFIEDBYfin_varcharvarchar(800)YesModified byNo
MODIFIEDDATEudd_date2varchar(11)YesModified dateNo
Table Name : QCD_QUICK_CODES_MST
Comment :Stores the Information of Quick Codes
Column Name UDD Data Type Is NULL? Comment Is PK?
ENTITYfin_varcharvarchar(800)NoEntityYes
QUICK_CODEfin_varcharvarchar(800)NoQuick codeYes
TIMESTAMPfin_decimaldecimal(17)YesTimestampNo
CREATEDBYfin_varcharvarchar(800)YesCreated byNo
CREATEDDATEfin_datetimedatetime(8)YesCreated dateNo
MODIFIEDBYfin_varcharvarchar(800)YesModified byNo
MODIFIEDDATEfin_datetimedatetime(8)YesModified dateNo