Data Dictionary -- Object Attachments

Srl. No.	Table Name	Comment
1	DA_DAPRM_PARAMETER_DETAILS	Parameter details for Object Attachments
2	DA_DEL_AREA_MASTER	Area Master
3	DA_DFFLD_DEF_FOLDER	Default Folder for each components
4	DA_DFSET_DEF_SETTING	Set options for Object Attachment
5	DA_UPLF_UPLOADFILE_DTL	Upload file details

Table Name :	DA_DAPRM_PARAMETER_DETAILS
Comment :	Parameter details for Object Attachments

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DAPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	Component name	No
DAPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	Parameter category	No
DAPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Parameter type	No
DAPRM_PARAMCODE	_varchar_5	varchar(5)	No	Parameter code	No
DAPRM_LANGID	_decimal_10_0	decimal(10)	No	Language ID	No
DAPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Parameter Description	No
DAPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	Parameter Creation Date	No
DAPRM_SORTBY	_decimal_10_0	decimal(10)	Yes	Ordering Sequence number	No

Table Name :	DA_DEL_AREA_MASTER
Comment :	Area Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DA_LO	_varchar_20	varchar(20)	No	LO #	No
DA_OU	_decimal_10_0	decimal(10)	No	ouinstance	Yes
DA_DELAREA_CODE	_varchar_18	varchar(18)	No	Area Code	Yes
DA_PAREANT_DELAREA_CODE	_varchar_18	varchar(18)	Yes	Parent Area code	No
DA_DELAREADESC	_varchar_25	Varchar(25)	No	Area Description	No
DA_DELAREADESC_SHD	_varchar_25	Varchar(25)	No	Area Description - Upper case	No
DA_LEVEL	_decimal_6_0	decimal(6)	No	Level	No
DA_REASONCODE	_varchar_10	varchar(10)	Yes	Reason	No
DA_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
DA_STATUS	_varchar_8	varchar(8)	No	status	No
DA_ADDL1	_decimal_10_0	decimal(10)	Yes	Additional details 1	No
DA_ADDL2	_varchar_255	varchar(255)	Yes	Additional details 2	No
DA_ADDL3	_varchar_255	varchar(255)	Yes	Additional details 3	No
DA_CREATED_BY	_varchar_30	varchar(30)	No	created by	No
DA_CREATED_DATE	_datetime_8	datetime(8)	No	created date	No
DA_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
DA_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	modified date	No
DA_TIMESTAMP_VALUE	_decimal_10_0	decimal(10)	No	Time stamp	No

Table Name :	DA_DFFLD_DEF_FOLDER
Comment :	Default Folder for each components

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DFFLD_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
DFFLD_COMP_NAME	_varchar_40	varchar(40)	No	component name	Yes
DFFLD_COMP_OUINSTANCE	_varchar_32	varchar(32)	No	component ouinstance	Yes
DFFLD_DEST_PATH	_varchar_255	varchar(255)	Yes	Destination Path	No
DFFLD_ACTION_FILE_EXISTS	_char_6	char(6)	Yes	Action, if the file exists	No
DFFLD_MAX_FILE_SIZE	_decimal_10_0	decimal(10)	Yes	Maximun size of the file	No
DFFLD_STATUS	_varchar_5	varchar(5)	Yes	Status	No
DFFLD_CREATEDDATE	_datetime_8	datetime(8)	Yes	File created date	No
DFFLD_CREATED_BY	_varchar_30	varchar(30)	Yes	File created by the user	No
DFFLD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	File modified date	No
DFFLD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	File modified by the user	No

Table Name :	DA_DFSET_DEF_SETTING
Comment :	Set options for Object Attachment

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DFSET_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouistance	No
DFSET_DEST_PATH	_varchar_255	varchar(255)	Yes	Destination Path	No
DFSET_ACTION_FILE_EXISTS	_varchar_5	varchar(5)	Yes	Action if the file exists	No
DFSET_DISP_DEST_PATH	_varchar_255	varchar(255)	Yes	Default destination path	No
DFSET_MAX_FILE_SIZE	_decimal_10_0	decimal(10)	Yes	Max size of the file	No
DFSET_CREATEDDATE	_datetime_8	datetime(8)	Yes	File created date	No
DFSET_CREATED_BY	_varchar_30	varchar(30)	Yes	File created by	No
DFSET_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	File Modified date	No
DFSET_MODIFIED_BY	_varchar_30	varchar(30)	Yes	File Modified by	No
DFSET_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time Stamp	No
DFSET_FTP_SERVERNAME	_varchar_255	varchar(255)	Yes	Servername	No
DFSET_READUSR_NAME	_varchar_15	varchar(15)	Yes	Login username	No
DFSET_READUSR_PWD	_varchar_15	varchar(15)	Yes	Login user password	No
DFSET_UPLOADUSR_NAME	_varchar_15	varchar(15)	Yes	File Uploading User name	No
DFSET_UPLOADUSR_PWD	_varchar_15	varchar(15)	Yes	File Uploading User password	No

Table Name :	DA_UPLF_UPLOADFILE_DTL
Comment :	Upload file details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DA_UPLF_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouistance	No
DA_UPLF_UPLOADEDBY	udd_ctxt_user	varchar(30)	No	File Uploaded by the user	No
DA_UPLF_UPLOADEDDATE	_datetime_8	datetime(8)	No	File Uploaded Date	No
DA_UPLF_COMPONENTNAME	udd_ctxt_component	varchar(20)	No	Component Name	No
DA_UPLF_REFDOC_TYPE	udd_doctype	varchar(40)	Yes	Reference Document Type	No
DA_UPLF_REFDOC_NO	udd_refdocno	varchar(40)	Yes	Reference Document number	No
DA_UPLF_ACTIONIFEXISTS	udd_designparamcode	varchar(5)	Yes	Action if file exists	No
DA_UPLF_SOURECPATH	UDD_RFDI_FilePath	varchar(255)	No	Source Path of the File	No
DA_UPLF_FILENAME	udd_filename	varchar(50)	No	File Name	No
DA_UPLF_FILESIZE	udd_filesize	numeric(13)	No	File Size	No
DA_UPLF_AIRCRAFT_REG_NO	udd_aircraftnumber	varchar(30)	Yes	Aircraft Register no	No
DA_UPLF_PARTNO	udd_partno	varchar(40)	Yes	Part no	No
DA_UPLF_SERIALNO	udd_partserialnumber	varchar(40)	Yes	Serial no	No
DA_UPLF_COMPONENTID	udd_componentid	varchar(90)	Yes	component id	No
DA_UPLF_SUPPLIER	udd_suppliercode	varchar(16)	Yes	Supplier #	No
DA_UPLF_REPAIRAGENCY	udd_suppliercode	varchar(16)	Yes	Repair agency number	No
DA_UPLF_MESSAGE	udd_txt255	varchar(255)	Yes	Success/Error Message	No
DA_UPLF_DESTPATH	udd_txt255	varchar(255)	Yes	File Destination Path	No
DA_UPLF_KEYCODE	udd_txt2000	varchar(2000)	Yes	Key code for uploaded file	No
DA_UPLF_UNIQUEID	udd_guid	varchar(40)	Yes	unique Id of the uploaded file	No
da_uplf_processed_flag	udd_chkflag	varchar(1)	Yes	Processed flag	No
da_uplf_sys_updated_flag	udd_chkflag	varchar(1)	Yes	Updated flag	No
DA_UPLF_Libry_NO	_UDD_DocumentNo2_80	UDD_DocumentNo2(80)	Yes	Upload file library number	No