|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ClaHrd_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Claim Deatils. | Yes |
| ClaHrd_Claim_No | UDD_DocumentNo2 | Varchar(80) | No | The unique identifying reference allotted to the Claim.This is mandatory information. Can t be modified or deleted | Yes |
| ClaHrd_Desc | udd_txt2000 | varchar(2000) | Yes | This field holds the Claims Description | No |
| ClaHrd_Category | udd_quickcodes | varchar(25) | Yes | The category to which the Claim is associated. The combo gets loaded with values defined in quick codes. Category value can be changed | No |
| ClaHrd_Status | udd_designparamcode | varchar(5) | Yes | Sets status of Claims as Active A or Inactive I Status value can be reset. | No |
| ClaHrd_Numbering_Type | udd_notypeno | varchar(5) | Yes | This field holds the numbering type selected for Claim Number | No |
| ClaHrd_Claim_DateTime | _datetime_8 | datetime(8) | Yes | This field holds the Claim Date and time | No |
| ClaHrd_Initiated_by | udd_hrempname | varchar(77) | Yes | This field holds the User name who Iniatated the claim | No |
| ClaHrd_Initiated_DateTime | _datetime_8 | datetime(8) | Yes | This field holds the Initiated Date time | No |
| ClaHrd_User_Status | udd_quickcodes | varchar(25) | Yes | This field holds the User status | No |
| ClaHrd_Implications | udd_quickcodes | varchar(25) | Yes | This field holds the claims implications. Combo values loaded from claim quick code table | No |
| ClaHrd_Ref_DocNo | udd_refdocno | varchar(40) | Yes | This field holds the Reference document number for the claim | No |
| ClaHrd_Ref_Doc_Date | _datetime_8 | datetime(8) | Yes | This field holds the Reference document date | No |
| ClaHrd_Ref_Details | udd_txt2000 | varchar(2000) | Yes | This field holds the Reference Details of the claim | No |
| ClaHrd_Contract_RefNO | udd_documentno | varchar(40) | Yes | This fields holds teh Contract Reference number of the claims | No |
| ClaHrd_Contract_Date | _datetime_8 | datetime(8) | Yes | This fields holds teh Contract Reference date of the claims | No |
| ClaHrd_Addl_Ref | udd_txt2000 | varchar(2000) | Yes | This fields holds teh Addl. References of the claims | No |
| ClaHrd_Audit_Reqd | udd_designparamcode | varchar(5) | Yes | This fields holds the Audit required flag Yes or NO | No |
| ClaHrd_Supplier | udd_vendorcode | varchar(45) | Yes | This field holds the supplier of the claim | No |
| ClaHrd_Cont_Person_dtl | udd_txt2000 | varchar(2000) | Yes | This field holds the Contact person name | No |
| ClaHrd_Claim_Curr | udd_currency | varchar(20) | Yes | This field holds the Claim currency | No |
| ClaHrd_Expense_Curr | udd_currency | varchar(20) | Yes | This field holds the Expense currency | No |
| ClaHrd_Comments | udd_hrnotes | varchar(2000) | Yes | This field holds the comments of the claims | No |
| ClaHrd_File_Name | udd_filename | varchar(50) | Yes | This field holds the file names of the claims | No |
| ClaHrd_Regist_Comments | udd_txt255 | varchar(255) | Yes | This field holds the registration comments | No |
| ClaHrd_Ack_Ref | udd_document | varchar(20) | Yes | This field holds the Acknowledgement reference | No |
| ClaHrd_Ack_Ref_DateTime | _datetime_8 | datetime(8) | Yes | This field holds the Acknowledgment Reference datetime | No |
| ClaHrd_Processed_by | UDD_EmployeeCode | char(20) | Yes | This field holds the Processed by of a claim | No |
| ClaHrd_Payment_Ref | UDD_PaymentReference | char(30) | Yes | This field holds the Payment reference of the claim | No |
| ClaHrd_Payment_Date | _datetime_8 | datetime(8) | Yes | This field holds the Payment date of the claim | No |
| ClaHrd_Payment_Comments | udd_txt255 | varchar(255) | Yes | This field holds the Payment comments of the claim | No |
| ClaHrd_Release_Comments | udd_txt255 | varchar(255) | Yes | This field holds the Release comments of the claim | No |
| ClaHrd_Acc_Rej_Comments | udd_txt255 | varchar(255) | Yes | This field holds the Accepted or Rejected comments | No |
| ClaHrd_Created_By | udd_ctxt_user | varchar(30) | Yes | Name of the login user who created the Claims information. | No |
| ClaHrd_Created_date | _datetime_8 | datetime(8) | Yes | This field holds the Date on which the Claims information is created. | No |
| ClaHrd_Modified_By | udd_ctxt_user | varchar(30) | Yes | Name of the login user who is the last to modify respective claims information. | No |
| ClaHrd_Modified_Date | _datetime_8 | datetime(8) | Yes | The last date on which the particular claims information was modified. | No |
| ClaHrd_Registered_by | udd_ctxt_user | varchar(30) | Yes | This field holds the registered by of the claims | No |
| ClaHrd_Registered_Date | _datetime_8 | datetime(8) | Yes | This field holds the registered date of the claims | No |
| ClaHrd_Released_By | udd_ctxt_user | varchar(30) | Yes | This field holds the Released by of the claim | No |
| ClaHrd_Released_Date | _datetime_8 | datetime(8) | Yes | This field holds the Released date of the claim | No |
| ClaHrd_Closed_by | udd_ctxt_user | varchar(30) | Yes | This field holds the closed by of the claim | No |
| ClaHrd_Closed_Date | _datetime_8 | datetime(8) | Yes | This field holds the closed date information of the claim | No |
| ClaHrd_Timestamp | udd_timestamp | int(4) | Yes | This field holds the timestamp so that more than one user cant modified same record in the same time | No |
| ClaHrd_ClmRemedy | udd_designparamcode | varchar(5) | Yes | Claim Remedy | No |
| ClaHrd_ClmType | udd_designparamcode | varchar(5) | Yes | Claim type | No |
| ClaHrd_ClmClassification | udd_designparamcode | varchar(5) | Yes | claim classification | No |
| ClaHrd_clmclass | udd_designparamcode | varchar(5) | Yes | claim class | No |
| ClaHrd_fldprtdis | udd_designparamcode | varchar(5) | Yes | claim part | No |
| ClaHrd_agreementyp | udd_designparamcode | varchar(5) | Yes | Agreement type | No |
| ClaHrd_ClmDisOpt | udd_designparamcode | varchar(5) | Yes | Cliam display option | No |
| ClaHrd_invno | udd_documentno | varchar(40) | Yes | invoice number | No |
| ClaHrd_invdate | _datetime_8 | datetime(8) | Yes | in voice date | No |
| ClaHrd_recloc | udd_oudescription | varchar(256) | Yes | Claim location | No |
| ClaHrd_Ordloc | udd_oudescription | varchar(256) | Yes | order loacation | No |
| ClaHrd_flag | udd_flag | varchar(25) | Yes | claim flag | No |
| ClaHrd_Buyer_Group | udd_quickcodes | varchar(25) | Yes | buyer group added in claim table | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLA_CLAPARAM_CLAIM_OUINSTANCE | udd_ctxt_ouinstance | int(4) | Yes | Claim Ouinstance | No |
| CLA_CLAPARAM_CLAIM_NO | UDD_DocumentNo2 | Varchar(80) | Yes | Claim No | No |
| CLA_CLAPARAM_LINENO | udd_seqno | int(4) | Yes | Line No | No |
| CLA_CLAPARAM_COMPREPNO | udd_documentno | varchar(40) | Yes | Component Replacement No | No |
| CLA_CLAPARAM_REFLINENO | udd_seqno | int(4) | Yes | Reference Line # | No |
| CLA_CLAPARAM_PARAMETER | udd_parameter | varchar(40) | Yes | Parameter | No |
| CLA_CLAPARAM_UOM | udd_unitofmeasurement | varchar(10) | Yes | UOM | No |
| CLA_CLAPARAM_TSO | udd_numericparamval | numeric(13) | Yes | TSO Value | No |
| CLA_CLAPARAM_TSN | udd_numericparamval | numeric(13) | Yes | TSN Value | No |
| CLA_CLAPARAM_REMARKS | udd_remarks | varchar(255) | Yes | Remarks | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ClaPrm_ComponentName | udd_ctxt_component | varchar(20) | No | This field holds the Component Code which table belongs to | Yes |
| ClaPrm_ParamCategory | udd_paramcategory | varchar(10) | No | This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc. | Yes |
| ClaPrm_ParamType | udd_paramtype | varchar(25) | No | Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows. | Yes |
| ClaPrm_ParamCode | udd_paramcode | varchar(30) | No | Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component | Yes |
| ClaPrm_Langid | udd_ctxt_language | int(4) | No | Language id. This is the language id of the record. | Yes |
| ClaPrm_ParamDesc | udd_txt255 | varchar(255) | Yes | This field holds the description of the Param Code | No |
| ClaPrm_sort_by | udd_seqno | int(4) | Yes | The order in which the values are populated. | No |
| ClaPrm_CreationDate | _datetime_8 | datetime(8) | Yes | This field holds the record creation date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLA_CLAPROCEXP_CLAIM_OUINSTANCE | udd_ctxt_ouinstance | int(4) | Yes | Claim Ouinstance | No |
| CLA_CLAPROCEXP_CLAIM_NO | UDD_DocumentNo2 | Varchar(80) | Yes | Claim NO | No |
| CLA_CLAPROCEXP_CLAIM_LINENO | udd_seqno | int(4) | Yes | Line No | No |
| CLA_CLAPROCEXP_COMPREPNO | udd_documentno | varchar(40) | Yes | Component Replacement No | No |
| CLA_CLAPROCEXP_REFLINENO | udd_seqno | int(4) | Yes | Reference Line # | No |
| CLA_CLAPROCEXP_CLAIMHEAD | udd_flag2 | varchar(25) | Yes | Claim Head | No |
| CLA_CLAPROCEXP_EXPENSES | udd_amount | numeric(13) | Yes | Expenses | No |
| CLA_CLAPROCEXP_CLMAMT | udd_amount | numeric(13) | Yes | Claim Amount | No |
| CLA_CLAPROCEXP_ACPTAMT | udd_amount | numeric(13) | Yes | Accepted Amount | No |
| CLA_CLAPROCEXP_REMARKS | udd_remarks | varchar(255) | Yes | Remarks | No |
| CLA_CLAPROCEXP_PARTNO | udd_partno | varchar(40) | Yes | Part No | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Table Name : | Cla_ClaQcd_Quick_Code_Dtl |
| Comment : | Quick Code details table. Will stores the quickcodes detined for all the quick code types |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ClaQcd_OUInstance | _numeric_10_0 | numeric(10) | No | The Organization unit at which user has logged in the system, and created the Claim details. | Yes |
| ClaQcd_Quick_Code | udd_quickcodes | varchar(25) | No | Any user enterable value that is to be associated with the above mentioned quick code type. | Yes |
| ClaQcd_Type | _varchar_25 | Varchar(25) | No | The applicable values for this filter are Load the Quick Code Type combo with the values Claim Category CLCAT Claim User Status CLURS Claim Implication CLIMP Expense Category EXCAT Correspondence Category CORCA Correspondence S | Yes |
| ClaQcd_Desc | udd_txt80 | varchar(80) | Yes | A brief description on that quick code | No |
| ClaQcd_Status | udd_designparamcode | varchar(5) | Yes | Enables to set the selected quick code value as Active A or Inactive I . Only active quick code values would be made available for quick code types during transactions Can be reset again. | No |
| ClaQcd_Default_flag | udd_designparamcode | varchar(5) | Yes | Provision to set the quick code as default for the quick code type selected above. This default value will be loaded automatically in the quick code type combo, in all the User Interfaces where it is used. This default value can later be reset, and s | No |
| ClaQcd_CreatedDate | _datetime_8 | datetime(8) | Yes | Date on which Quick Code was created | No |
| ClaQcd_Created_By | udd_ctxt_user | varchar(30) | Yes | User who has created the Quick Code | No |
| ClaQcd_ModifiedDate | _datetime_8 | datetime(8) | Yes | Date on which Quick code was modified | No |
| ClaQcd_Modified_By | udd_ctxt_user | varchar(30) | Yes | User who has modified the quick code | No |
| ClaQcd_Timestamp | udd_timestamp | int(4) | Yes | This field holds the timestamp so that more than one user cant modified same record in the same time | No | |
| Table Name : | Cla_ClaQch_Quick_Code_Hdr |
| Comment : | Quick Code Header table. This table stores mandatory falg for all the Quick code types |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ClaQch_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Claim details. | Yes |
| ClaQch_Type | udd_designparamcode | varchar(5) | No | The applicable values for this filter are Load the Quick Code Type combo with the values Claim Category , Claim User Status , Claim Implication , Expense Category , Correspondence Category , Correspondence Status and Ref.Doc Type These v | Yes |
| LibQch_Mandatory_Flag | udd_designparamcode | varchar(5) | Yes | This field holds the mandatory Yes or No flag.Provision to set whether the Quick Code Type selected in header combo should be Mandatory or Non mandatory, for the different User Interfaces, in insurence Claim. The system would ensure that the Quic | No |
| ClaQch_Updated_Date | _datetime_8 | datetime(8) | Yes | This field holds the date on which Quick code was modified | No |
| ClaQch_Updated_By | udd_ctxt_user | varchar(30) | Yes | This field holds the user who has modified the quick code | No |
| ClaQch_Timestamp | udd_timestamp | int(4) | Yes | This field holds the timestamp so that more than one user cant modified same record in the same time | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ClaRef_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Claim Deatils. | Yes |
| ClaRef_Claim_No | UDD_DocumentNo2 | Varchar(80) | No | The unique identifying reference allotted to the Claim.This is mandatory information. | Yes |
| ClaRef_Seq_No | udd_seqno | int(4) | No | This field holds the Sequence number of the reference details multilne | Yes |
| ClaRef_Ref_Doc_Type | udd_cmnrefdocs | varchar(10) | Yes | This field holds the Reference document type | No |
| ClaRef_Document_ID | udd_documentno | varchar(40) | Yes | This field holds the Document ID | No |
| ClaRef_File_Name | udd_filename | varchar(50) | Yes | This field holds the File Name of reference details multiline | No |
| ClaRef_Remarks | udd_desc40 | varchar(40) | Yes | This field holds the Remarks of the reference details multiline | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLA_CLAWAREFDOC_CLAIM_OUINSTANCE | udd_ctxt_ouinstance | int(4) | Yes | Claim Ouinstance | No |
| CLA_CLAWAREFDOC_CLAIM_NO | UDD_DocumentNo2 | Varchar(80) | Yes | Claim No | No |
| CLA_CLAWAREFDOC_LINENO | udd_seqno | int(4) | Yes | Claim Line No | No |
| CLA_CLAWAREFDOC_COMPREPNO | udd_documentno | varchar(40) | Yes | Component Replacement No | No |
| CLA_CLAWAREFDOC_REFLINENO | udd_seqno | int(4) | Yes | Reference Line # | No |
| CLA_CLAWAREFDOC_AGRNO | udd_documentno | varchar(40) | Yes | Agreement No | No |
| CLA_CLAWAREFDOC_AGRTYP | udd_subtitle | varchar(40) | Yes | Agreement type | No |
| CLA_CLAWAREFDOC_AGRDATE | _datetime_8 | datetime(8) | Yes | Agreement Date | No |
| CLA_CLAWAREFDOC_SUPNO | udd_vendorcode | varchar(45) | Yes | Supplier NO | No |
| CLA_CLAWAREFDOC_NTFYFAILBF | _datetime_8 | datetime(8) | Yes | Notify Failure Before | No |
| CLA_CLAWAREFDOC_WARSTRTDATE | _datetime_8 | datetime(8) | Yes | Warranty Start Date | No |
| CLA_CLAWAREFDOC_WAREXPDATE | _datetime_8 | datetime(8) | Yes | Warranty Expiry Date | No |
| CLA_CLAWAREFDOC_FAILDATE | _datetime_8 | datetime(8) | Yes | Failed Date | No |
| CLA_CLAWAREFDOC_WARPARAMETER | udd_parameter | varchar(40) | Yes | Warrant Parameter | No |
| CLA_CLAWAREFDOC_WARPARAMVALUE | udd_paramvalue | varchar(30) | Yes | Warrant Param Value | No |
| CLA_CLAWAREFDOC_FAILPARAMVALUE | udd_paramvalue | varchar(30) | Yes | Failed Parameter Value | No |
| CLA_CLAWAREFDOC_CLMAGST | udd_designparamcode | varchar(5) | Yes | Claim Against | No |
| CLA_CLAWAREFDOC_REMARKS | udd_remarks | varchar(255) | Yes | Remarks | No |
| CLA_CLAWAREFDOC_FILENAME | UDD_text | varchar(256) | Yes | File Name | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_cqe_cr_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Created Ou | No |
| Cla_cqe_cr_no | udd_documentno | varchar(40) | Yes | CR No | No |
| Cla_cqe_exe_doc_ou | udd_ctxt_ouinstance | int(4) | Yes | Execution Document OU | No |
| Cla_cqe_exe_doc_type | udd_documenttype | varchar(40) | Yes | Execution Document Type | No |
| Cla_cqe_exe_doc_no | udd_documentno | varchar(40) | Yes | Execution Document No | No |
| Cla_cqe_exec_doc_date | _datetime_8 | datetime(8) | Yes | Execution Document Date | No |
| Cla_cqe_exec_doc_status | udd_docstatus | varchar(15) | Yes | Execution Document Status | No |
| Cla_cqe_cost_basis | udd_flag1 | varchar(25) | Yes | Cost Basis | No |
| Cla_cqe_material_cost | udd_amount | numeric(13) | Yes | Material Cost | No |
| Cla_cqe_labor_cost | udd_amount | numeric(13) | Yes | Labor Cost | No |
| Cla_cqe_misc_cost | udd_amount | numeric(13) | Yes | Miscellanous Cost | No |
| Cla_cqe_labour_hours | udd_duration | numeric(13) | Yes | Labour Hours | No |
| Cla_cqe_total_cost | udd_amount | numeric(13) | Yes | Total Cost | No |
| Cla_cqe_exec_comments | udd_txt2000 | varchar(2000) | Yes | Execution Comments | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_cqh_cr_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Created Ou | No |
| Cla_cqh_cr_no | udd_documentno | varchar(40) | Yes | CR NO | No |
| Cla_cqh_cr_date | _datetime_8 | datetime(8) | Yes | CR Date | No |
| Cla_cqh_cr_status | udd_docstatus | varchar(15) | Yes | CR Status | No |
| Cla_cqh_source_doc_ou | udd_ctxt_ouinstance | int(4) | Yes | Source Document OU | No |
| Cla_cqh_source_doc_no | udd_documentno | varchar(40) | Yes | Source Document No | No |
| Cla_cqh_source_doc_type | udd_documenttype | varchar(40) | Yes | Source Document Type | No |
| Cla_cqh_object_type | udd_flag1 | varchar(25) | Yes | Object Type | No |
| Cla_cqh_removed_component | udd_componentid | varchar(90) | Yes | Removed Component | No |
| Cla_cqh_removed_part_ou | udd_ctxt_ouinstance | int(4) | Yes | Remoed Part OU | No |
| Cla_cqh_removed_part_no | udd_partno | varchar(40) | Yes | Remoed Part No | No |
| Cla_cqh_removed_part_serial_no | udd_partserialnumber | varchar(40) | Yes | Remoed Part Serial No | No |
| Cla_cqh_removed_part_lot_no | udd_lotnumber | varchar(28) | Yes | Remoed Part Lot No | No |
| Cla_cqh_removed_part_condition | udd_partstatus | varchar(40) | Yes | Removed Part Condition | No |
| Cla_cqh_removed_part_type_class | udd_desc40 | varchar(40) | Yes | Removed Part Type Classification | No |
| Cla_cqh_ata_no | udd_atanumber | varchar(16) | Yes | ATA NO | No |
| Cla_cqh_reason_no | udd_reasonforremoval | varchar(20) | Yes | Reason No | No |
| Cla_cqh_part_ownership | udd_partstatus | varchar(40) | Yes | Part Ownership | No |
| Cla_cqh_aircraft_reg_no | udd_aircraftnumber | varchar(30) | Yes | Aircraft Reg NO | No |
| Cla_cqh_position_code | udd_positioncode | varchar(25) | Yes | Position code | No |
| Cla_cqh_level_code | udd_cnfglvlcd | varchar(150) | Yes | Level Code | No |
| Cla_cqh_removed_by | udd_hrempcode | varchar(20) | Yes | Removed by | No |
| Cla_cqh_removed_date | _datetime_8 | datetime(8) | Yes | Removed Date | No |
| Cla_cqh_removed_time | _datetime_8 | datetime(8) | Yes | Removed Time | No |
| Cla_cqh_supplier_ou | udd_ctxt_ouinstance | int(4) | Yes | Supplier Ou | No |
| Cla_cqh_supplier_no | udd_vendorcode | varchar(45) | Yes | Supplier No | No |
| Cla_cqh_notify_failure_before | _datetime_8 | datetime(8) | Yes | Notify Failure Before | No |
| Cla_cqh_is_eligibile | udd_txt5 | varchar(5) | Yes | Is claim eligible | No |
| Cla_cqh_is_claimed | udd_txt5 | varchar(5) | Yes | Is the claim processed | No |
| Cla_cqh_removal_fh | udd_numericparamval | numeric(13) | Yes | FH During removal | No |
| Cla_cqh_removal_fc | udd_numericparamval | numeric(13) | Yes | FC During removal | No |
| Cla_cqh_processing_status | udd_status | varchar(25) | Yes | Processing status | No |
| Cla_cqh_processing_comments | udd_txt255 | varchar(255) | Yes | Processing Comments | No |
| Cla_cqh_agreement_details | udd_remarks | varchar(255) | Yes | Aggreement to be considered for processing | No |
| Cla_cqh_remarks | udd_remarks | varchar(255) | Yes | Remarks | No |
| Cla_cqh_Seq_No | udd_count | int(4) | No | Seq NO | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_cqp_cr_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Create | No |
| Cla_cqp_cr_no | udd_documentno | varchar(40) | Yes | CR NO | No |
| Cla_cqp_object_id | udd_componentid | varchar(90) | Yes | Object Id | No |
| Cla_cqp_object_type | udd_flag1 | varchar(25) | Yes | Object Type | No |
| Cla_cqp_agr_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Agreement Created Ou | No |
| Cla_cqp_agr_no | udd_documentno | varchar(40) | Yes | Agreemeno No | No |
| Cla_cqp_wrnty_type | udd_flag1 | varchar(25) | Yes | Warranty Type | No |
| Cla_cqp_wrnty_parameter | udd_parameter | varchar(40) | Yes | Warranty Parameter | No |
| Cla_cqp_wrnty_param_value | udd_numericparamval | numeric(13) | Yes | Warranty Parameter Value | No |
| Cla_cqp_wrnty_param_expry_value | udd_numericparamval | numeric(13) | Yes | Warranty Parameter Expiry Value | No |
| Cla_cqp_failed_param_value | udd_numericparamval | numeric(13) | Yes | Failed Parameter Value | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_cqr_cr_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Created Ou | No |
| Cla_cqr_cr_no | udd_documentno | varchar(40) | Yes | CR No | No |
| Cla_cqr_agr_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Agreement Created Ou | No |
| Cla_cqr_agr_type | udd_subtitle | varchar(40) | Yes | Agreeement Type | No |
| Cla_cqr_agr_no | udd_documentno | varchar(40) | Yes | Agreement Number | No |
| Cla_cqr_agr_date | _datetime_8 | datetime(8) | Yes | Agreement Date | No |
| Cla_cqr_supplier_ou | udd_ctxt_ouinstance | int(4) | Yes | Supplier OU | No |
| Cla_cqr_supplier_no | udd_vendorcode | varchar(45) | Yes | Supplier No | No |
| Cla_cqr_wrnty_start_date | _datetime_8 | datetime(8) | Yes | Warranty Start Date | No |
| Cla_cqr_wrnty_end_date | _datetime_8 | datetime(8) | Yes | Warranty End Date | No |
| Cla_cqr_failed_date | _datetime_8 | datetime(8) | Yes | Failed Date | No |
| Cla_cqr_notify_failure_before | _datetime_8 | datetime(8) | Yes | Notify Failure Before | No |
| Cla_cqr_is_prim_source_doc | udd_txt5 | varchar(5) | Yes | Primary Source Document | No |
| Cla_cqr_wrnty_type | udd_flag1 | varchar(25) | Yes | Warranty Type | No |
| Cla_cqr_terms_and_ref | udd_txt2000 | varchar(2000) | Yes | Terms and references | No |
| Cla_cqr_sort_order | udd_count | int(4) | Yes | Sort Order | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_eoe_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Created Ou | No |
| Cla_eoe_eo_no | udd_documentno | varchar(40) | Yes | Eo No | No |
| Cla_eoe_eo_Rev_No | udd_revisionno | varchar(40) | Yes | Eo Revision No | No |
| Cla_eoe_exe_doc_ou | udd_ctxt_ouinstance | int(4) | Yes | Execution Document Ou | No |
| Cla_eoe_exe_doc_type | udd_documenttype | varchar(40) | Yes | Execution Document Type | No |
| Cla_eoe_exe_doc_no | udd_documentno | varchar(40) | Yes | Execution Document No | No |
| Cla_eoe_exec_doc_date | _datetime_8 | datetime(8) | Yes | Execution Document Date | No |
| Cla_eoe_exec_doc_status | udd_docstatus | varchar(15) | Yes | Execution Document Status | No |
| Cla_eoe_cost_basis | udd_flag1 | varchar(25) | Yes | Cost Basis | No |
| Cla_eoe_material_cost | udd_amount | numeric(13) | Yes | Material Cost | No |
| Cla_eoe_labor_cost | udd_amount | numeric(13) | Yes | Labor Cost | No |
| Cla_eoe_misc_cost | udd_amount | numeric(13) | Yes | Miscellanous Cost | No |
| Cla_eoe_labour_hours | udd_duration | numeric(13) | Yes | Labour Hours | No |
| Cla_eoe_total_cost | udd_amount | numeric(13) | Yes | Total Cost | No |
| Cla_eoe_exec_comments | udd_txt2000 | varchar(2000) | Yes | Execution Comments | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_eoq_created_ou | udd_ctxt_ouinstance | int(4) | Yes | Created Ou | No |
| Cla_eoq_eo_no | udd_documentno | varchar(40) | Yes | Eo No | No |
| Cla_eoq_eo_rev_no | udd_revisionno | varchar(40) | Yes | Eo Revision No | No |
| Cla_eoq_eo_created_date | _datetime_8 | datetime(8) | Yes | EO Created Date | No |
| Cla_eoq_ata_no | udd_atanumber | varchar(16) | Yes | ATA NO | No |
| Cla_eoq_mcr_ou | udd_ctxt_ouinstance | int(4) | Yes | MCR OU | No |
| Cla_eoq_mcr_no | udd_documentno | varchar(40) | Yes | MCR NO | No |
| Cla_eoq_mcr_rev_no | udd_revisionno | varchar(40) | Yes | MCR Revision NO | No |
| Cla_eoq_mcr_issue_date | _datetime_8 | datetime(8) | Yes | MCR Issue Date | No |
| Cla_eoq_source_doc_type | udd_documenttype | varchar(40) | Yes | Source Document Type | No |
| Cla_eoq_applicability | udd_flag | varchar(25) | Yes | Eoq applicability | No |
| Cla_eoq_ac_effect | udd_aircraftnumber | varchar(30) | Yes | Eoq ac effectivity | No |
| Cla_eoq_comp_effect | udd_componentid | varchar(90) | Yes | Eoq comp effectivity | No |
| Cla_eoq_wrnty_appl_mat | udd_txt5 | varchar(5) | Yes | Applicable Material | No |
| Cla_eoq_wrnty_appl_fac | udd_txt5 | varchar(5) | Yes | Applicable Facility | No |
| Cla_eoq_wrnty_appl_labo | udd_txt5 | varchar(5) | Yes | Applicable Labor | No |
| Cla_eoq_wrnty_appl_oth | udd_txt5 | varchar(5) | Yes | Applicable other details | No |
| Cla_eoq_terms_and_references | udd_txt2000 | varchar(2000) | Yes | Terms and references | No |
| Cla_eoq_is_claimed | udd_txt5 | varchar(5) | Yes | Is Claimed | No |
| Cla_eoq_supplierno | udd_vendorcode | varchar(45) | Yes | Supplier NO | No |
| Cla_eoq_partno | udd_partno | varchar(40) | Yes | Part NO | No |
| Cla_eoq_serialno | udd_partserialnumber | varchar(40) | Yes | Serial NO | No |
| Cla_eoq_processing_status | udd_status | varchar(25) | Yes | Processing status | No |
| Cla_eoq_part_type | udd_parttype | varchar(25) | Yes | Part Type | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_SetOptdtl_OUInstance | udd_ctxt_ouinstance | int(4) | Yes | OUInstance | No |
| Cla_SetOptdtl_Keycode | udd_txt150 | varchar(150) | Yes | Keycode | No |
| Cla_SetOptdtl_Status | udd_docstatus | varchar(15) | Yes | Status | No |
| Cla_SetOptdtl_Value | udd_groupno | int(4) | Yes | Value | No |
| Cla_SetOptdtl_CreatedBy | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| Cla_SetOptdtl_CreatedDate | _datetime_8 | datetime(8) | Yes | Created Date | No |
| Cla_SetOptdtl_ModifiedBy | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| Cla_SetOptdtl_ModifiedDate | _datetime_8 | datetime(8) | Yes | Modified DAte | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_SetOptHdr_OUInstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| Cla_SetOptHdr_NumAutoPo | udd_flag | varchar(25) | Yes | Auto PO Numbering Type | No |
| Cla_SetOptHdr_NumClaim | udd_flag1 | varchar(25) | Yes | Numbeing type for claim generation | No |
| Cla_SetOptHdr_TimeStamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| Cla_SetOptHdr_CreatedBy | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| Cla_SetOptHdr_CreatedDate | _datetime_8 | datetime(8) | Yes | Created Date | No |
| Cla_SetOptHdr_ModifiedBy | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| Cla_SetOptHdr_ModifiedDate | _datetime_8 | datetime(8) | Yes | Modified DAte | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_SetOpt_Langid | udd_ctxt_language | int(4) | Yes | Language id. This is the language id of the record. | No |
| Cla_SetOpt_Keycode | udd_txt150 | varchar(150) | Yes | Keycode | No |
| Cla_SetOpt_Metadata_Type | udd_paramcode | varchar(30) | Yes | Metadata Type | No |
| Cla_SetOpt_Paramcode | udd_paramcode | varchar(30) | Yes | Paramcode | No |
| Cla_SetOpt_ParamDesc | udd_txt150 | varchar(150) | Yes | ParamDesc | No |
| Cla_SetOpt_Mandatory_Chk | udd_flag1 | varchar(25) | Yes | Mandatory Chk | No |
| Cla_SetOpt_SortBy | udd_seqno | int(4) | Yes | SortBy | No |
| Cla_SetOpt_CreatedDate | _datetime_8 | datetime(8) | Yes | CreatedDate | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Cla_SetOpt_OptLangid | udd_ctxt_language | int(4) | Yes | Language id. This is the language id of the record. | No |
| Cla_SetOpt_OptKeycode | udd_paramcode | varchar(30) | Yes | OptKeycode | No |
| Cla_SetOpt_OptPermittedValue | udd_count | int(4) | Yes | OptPermittedValue | No |
| Cla_SetOpt_OptPmtedValue_Desc | udd_txt150 | varchar(150) | Yes | OptPermittedValue Description | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLA_UPDFALEXPINFO_CLM_OUINSTANCE | udd_ctxt_ouinstance | int(4) | Yes | Claim Ouinstance | No |
| CLA_UPDFALEXPINFO_CLAIM_NO | UDD_DocumentNo2 | Varchar(80) | Yes | Claim No | No |
| CLA_UPDFALEXPINFO_LINENO | udd_seqno | int(4) | Yes | Line No | No |
| CLA_UPDFALEXPINFO_PRTFLDATE | _datetime_8 | datetime(8) | Yes | Part Failed Date | No |
| CLA_UPDFALEXPINFO_REASREMVL | udd_txt255 | varchar(255) | Yes | Reason for Removal | No |
| CLA_UPDFALEXPINFO_RMVDBY | udd_hrempcode | varchar(20) | Yes | Removed by | No |
| CLA_UPDFALEXPINFO_EMPNAME | udd_employeename | varchar(77) | Yes | Emp Name | No |
| CLA_UPDFALEXPINFO_RMVDACFT | udd_identifierno | varchar(90) | Yes | Removed from Aircraft | No |
| CLA_UPDFALEXPINFO_RMVDCMPT | udd_componentid | varchar(90) | Yes | Removed Component | No |
| CLA_UPDFALEXPINFO_AFH | udd_duration | numeric(13) | Yes | FH of Aircraft | No |
| CLA_UPDFALEXPINFO_AFC | udd_count | int(4) | Yes | FC of Aircraft | No |
| CLA_UPDFALEXPINFO_LABOURHRS | udd_duration | numeric(13) | Yes | Labor Hours | No |
| CLA_UPDFALEXPINFO_LabRatePerHrs | udd_amount | numeric(13) | Yes | Labor Rate per Hour | No |
| CLA_UPDFALEXPINFO_MechRem | udd_txt255 | varchar(255) | Yes | Mechanic Remarks | No |
| CLA_UPDFALEXPINFO_Claimntremarks | udd_txt255 | varchar(255) | Yes | Claimant Remakrs | No |
| CLA_UPDFALEXPINFO_AckReference | udd_document | varchar(20) | Yes | Acknowledgement Reference | No |
| CLA_UPDFALEXPINFO_AckDtTime | udd_eam_time | varchar(20) | Yes | Acknowledgement Date and Time | No |
| CLA_UPDFALEXPINFO_AckDate | _datetime_8 | datetime(8) | Yes | Acknowledgement Date | No |
| CLA_UPDFALEXPINFO_procsby | udd_ctxt_user | varchar(30) | Yes | Processed By | No |
| CLA_UPDFALEXPINFO_RelComments | udd_txt255 | varchar(255) | Yes | Release Comments | No |
| CLA_UPDFALEXPINFO_AccRejComm | udd_ShortDesc | varchar(75) | Yes | Acceptance or rejection comments | No |
| CLA_UPDFALEXPINFO_invno | udd_documentno | varchar(40) | Yes | invoice number | No |
| CLA_UPDFALEXPINFO_invdate | _datetime_8 | datetime(8) | Yes | Invoice Date | No |
| CLA_UPDFALEXPINFO_PymntRef | UDD_PaymentReference | char(30) | Yes | Payment Reference | No |
| CLA_UPDFALEXPINFO_PayDate | _datetime_8 | datetime(8) | Yes | Payment Date | No |
| CLA_UPDFALEXPINFO_pymtcomments | udd_txt255 | varchar(255) | Yes | Payment Comments | No |
| CLA_UPDFALEXPINFO_CRTBY | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| CLA_UPDFALEXPINFO_CRTDATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| CLA_UPDFALEXPINFO_MODBY | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| CLA_UPDFALEXPINFO_MODDATE | _datetime_8 | datetime(8) | Yes | Modified DAte | No |
| CLA_UPDFALEXPINFO_AckTime | udd_eam_time | varchar(20) | Yes | Acknowledgement Time | No |
| CLA_UPDFALEXPINFO_PRTFLTIME | udd_eam_time | varchar(20) | Yes | Part failed Time | No |
| CLA_UPDFALEXPINFO_PARTNO | udd_partno | varchar(40) | Yes | Part No | No |
| CLA_UPDFALEXPINFO_SERIALNO | udd_partserialnumber | varchar(40) | Yes | Serial NO | No |
| CLA_UPDFALEXPINFO_LOTNO | udd_lotno | varchar(18) | Yes | Lot No | No |
| CLA_UPDFALEXPINFO_CMPTREPNO | udd_documentno | varchar(40) | Yes | Component Replacement No | No |
| CLA_UPDFALEXPINFO_CMPTREPDATE | _datetime_8 | datetime(8) | Yes | Component Replacement Date | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes |