|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLMMS_WAR_CLAIM_NO | _varchar_40 | varchar(40) | No | Unique transaction number for the warranty claim | Yes |
| CLMMS_CLAIM_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| CLMMS_CLAIM_REVNO | _varchar_40 | varchar(40) | No | Claim Revision No | Yes |
| CLMMS_WAR_REF_NO | _varchar_40 | varchar(40) | Yes | Unique number to identify a warranty. | No |
| CLMMS_COMP_ID | _varchar_90 | varchar(90) | Yes | Component id | No |
| CLMMS_CLAIM_STATUS | _varchar_5 | varchar(5) | Yes | Facility to have the Warranty claim statuses like Open , Cancelled , Released , Revised , Freezed , Closed . | No |
| CLMMS_CLAIM_DESC | _varchar_150 | varchar(150) | Yes | Textual description of the warranty claim | No |
| CLMMS_CLAIM_CATEG | _varchar_25 | Varchar(25) | Yes | A quick code facilitating the user to categorize the warranty claim | No |
| CLMMS_CLAIM_TYPE | _varchar_5 | varchar(5) | Yes | Predefined categorization based on the type of claim like Reliability , Failure | No |
| CLMMS_REIMB_TYPE | _varchar_5 | varchar(5) | Yes | Predefined categorization based on the type of reimbursement like Cash , Credit | No |
| CLMMS_USER_STATUS | _varchar_25 | Varchar(25) | Yes | A quick code facilitating the user to define statuses apart from the standard ones | No |
| CLMMS_SUGG_ACTION | _varchar_25 | Varchar(25) | Yes | Predefined categorization of suggested Supplier action like Repair , Exchange | No |
| CLMMS_CLAIM_PRIRTY | _decimal_10_0 | decimal(10) | Yes | User defined Priority codes of the Warranty Claim like Urgent, Normal, AOG, etc., | No |
| CLMMS_AGGR_NO | _varchar_40 | varchar(40) | Yes | Unique number to identify agreement between supplier and operator for warranty. | No |
| CLMMS_AMEND_NO | _decimal_5_0 | decimal(5) | Yes | Aggrement Amendment No | No |
| CLMMS_REPAIR_AT | _varchar_5 | varchar(5) | Yes | In some cases the supplier and the operator can decide to repair the component in operator premises. Flag to specify inhouse or not | No |
| CLMMS_COMP_REP_NO | _varchar_40 | varchar(40) | Yes | Reference Number through which component Removal has taken place. | No |
| CLMMS_PRT_FLD_DATE | _datetime_8 | datetime(8) | Yes | The date on which the failure has occurred. | No |
| CLMMS_REASON_NO | _varchar_20 | varchar(20) | Yes | User Defined Reason for a claim being rejected by the Supplier. | No |
| CLMMS_BER | _varchar_5 | varchar(5) | Yes | A flag to indicate if a component is declared as Beyond Economic Repair BER | No |
| CLMMS_HOLD_PERIOD | _decimal_28_8 | decimal(28) | Yes | The holding period for components declared as Beyond Economic Repair BER | No |
| CLMMS_HLD_PRD_UOM | _varchar_5 | varchar(5) | Yes | The holding period for components declared as Beyond Economic Repair BER Unit of Measure | No |
| CLMMS_ACCEPT_STATUS | _varchar_5 | varchar(5) | Yes | Various acceptance statuses like Accepted , Rejected , and Under Dispute . | No |
| CLMMS_COMMENTS | _varchar_255 | varchar(255) | Yes | Comments | No |
| CLMMS_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| CLMMS_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| CLMMS_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| CLMMS_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| CLMMS_RLSED_BY | _varchar_30 | varchar(30) | Yes | Released By | No |
| CLMMS_RLSED_DATE | _datetime_8 | datetime(8) | Yes | Released Date | No |
| CLMMS_FRZED_BY | _varchar_30 | varchar(30) | Yes | Freeze by | No |
| CLMMS_FRZED_DATE | _datetime_8 | datetime(8) | Yes | Freeze date | No |
| CLMMS_CLOSED_BY | _varchar_30 | varchar(30) | Yes | Closed by | No |
| CLMMS_CLOSED_DATE | _datetime_8 | datetime(8) | Yes | Closed Date | No |
| CLMMS_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Time stamp | No |
| CLMMS_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| CLMMS_CLM_GR_NO | _varchar_40 | varchar(40) | Yes | Claim GR No. | No |
| CLMMS_CLM_INV_NO | _varchar_40 | varchar(40) | Yes | Claim Invoice No | No |
| CLMMS_NFF | _varchar_5 | varchar(5) | Yes | No Fault Found Details | No |
| CLMMS_SUPP_BER | _varchar_5 | varchar(5) | Yes | Supplier Response BER | No |
| CLMMS_SUPP_REFDOC_NO | _varchar_40 | varchar(40) | Yes | SUPPLIER REFERENCE DOC NO | No |
| CLMMS_SUPP_RESP_DATE | _datetime_8 | datetime(8) | Yes | SUPPLIER RESPONSE DATE | No |
| CLMMS_SUPP_REASON_NO | _varchar_20 | varchar(20) | Yes | SUPPLIER REJECTION REASON NO | No |
| CLMMS_SUPP_RSPNSE | _varchar_2000 | varchar(2000) | Yes | SUPPLIER RESPONSE | No |
| CLMMS_SUPP_ACTION | _varchar_2000 | varchar(2000) | Yes | SUPPLIER ACTION | No |
| CLMMS_MTBF | _decimal_28_8 | decimal(28) | Yes | MTBF added for Integration Service | No |
| CLMMS_MTBUR | _decimal_28_8 | decimal(28) | Yes | MTBUR added for Integration Service | No |
| CLMMS_PRTFLD_TIME | _datetime_8 | datetime(8) | Yes | Part Failed Time | No |
| CLMMS_SUP_WARR_REFNO | _varchar_40 | varchar(40) | Yes | This field holds supplier warranty reference no. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLMPM_CLAIM_REVNO | _varchar_40 | varchar(40) | No | Claim Revision No | Yes |
| CLMPM_WAR_CLAIM_NO | _varchar_40 | varchar(40) | No | Warranty Claim no | Yes |
| CLMPM_CLAIM_OUINSTNCE | _decimal_10_0 | decimal(10) | No | Claim Ou instance | Yes |
| CLMPM_SER_NO | _decimal_10_0 | decimal(10) | No | Serial NO | Yes |
| CLMPM_PARAMETER | _varchar_40 | varchar(40) | Yes | The Consumption type parameters based on which Warranty is tracked. | No |
| CLMPM_PARAM_VALUE | _decimal_38_0 | decimal(38) | Yes | Parameter value | No |
| CLMPM_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created BY | No |
| CLMPM_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| CLMPM_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by | No |
| CLMPM_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Table Name : | WC_CLMRF_DOCDTL |
| Comment : | Hold Reference details for the Warranty Claim |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLMRF_SEQ_NO | _decimal_10_0 | decimal(10) | No | This field holds the Unique identifier for each claim no | Yes |
| CLMRF_WAR_CLAIM_NO | _varchar_40 | varchar(40) | No | Unique transaction number for the warranty claim | Yes |
| CLMRF_CLAIM_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| CLMRF_CLAIM_REVNO | _varchar_40 | varchar(40) | No | Claim Revision No | Yes |
| CLMRF_DOC_TYPE | _varchar_25 | Varchar(25) | Yes | Type of Document. Defined in Logistic Common Master | No |
| CLMRF_DOC_ID | _varchar_40 | varchar(40) | Yes | Document ID | No |
| CLMRF_FILENAME | _varchar_50 | varchar(50) | Yes | File Name corresponding to the Document | No |
| CLMRF_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| CLMRF_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| CLMRF_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| CLMRF_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Table Name : | WC_CLMUD_USR_DFND |
| Comment : | Hold User Defined details for the Warranty claim |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| CLMUD_WAR_CLAIM_NO | _varchar_40 | varchar(40) | No | Unique transaction number for the warranty claim | Yes |
| CLMUD_CLAIM_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| CLMUD_CLAIM_REVNO | _varchar_40 | varchar(40) | No | Claim Revision No | Yes |
| CLMUD_DETAIL1 | _varchar_30 | varchar(30) | Yes | User Defined Detail | No |
| CLMUD_OPTION1 | _varchar_25 | Varchar(25) | Yes | User Defined Option Selected from Common Logistic Master | No |
| CLMUD_DETAIL2 | _varchar_30 | varchar(30) | Yes | User Defined Detai | No |
| CLMUD_OPTION2 | _varchar_25 | Varchar(25) | Yes | User Defined Option | No |
| CLMUD_DETAIL3 | _varchar_30 | varchar(30) | Yes | User defind details 3 | No |
| CLMUD_OPTION3 | _varchar_25 | Varchar(25) | Yes | User defind option 3 | No |
| CLMUD_DETAIL4 | _varchar_30 | varchar(30) | Yes | User defind details 4 | No |
| CLMUD_OPTION4 | _varchar_25 | Varchar(25) | Yes | User defind option 4 | No |
| CLMUD_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| CLMUD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| CLMUD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| CLMUD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| CLMUD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Table Name : | WC_DFDTL_DEFECT_RPT |
| Comment : | Maintain Defect reports associated with discrepancies |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| DFDTL_CLAIM_REVNO | _varchar_40 | varchar(40) | No | Claim Revision No | Yes |
| DFDTL_WAR_CLAIM_NO | _varchar_40 | varchar(40) | No | Unique transaction number for the warranty claim | Yes |
| DFDTL_CLAIM_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| DFDTL_SER_NO | _decimal_10_0 | decimal(10) | No | Serial NO | Yes |
| DFDTL_DISCREP_NO | _varchar_40 | varchar(40) | Yes | Discrepancy no | No |
| DFDTL_COMMENTS | _varchar_255 | varchar(255) | Yes | comments | No |
| DFDTL_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| DFDTL_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| DFDTL_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| DFDTL_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| DFHDR_CLAIM_REVNO | _varchar_40 | varchar(40) | No | Claim Revision No | Yes |
| DFHDR_WAR_CLAIM_NO | _varchar_40 | varchar(40) | No | Unique transaction number for the warranty claim | Yes |
| DFHDR_CLAIM_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| DFHDR_REMARK1 | _varchar_255 | varchar(255) | Yes | Remarks 1 | No |
| DFHDR_REMARK2 | _varchar_255 | varchar(255) | Yes | Remarks 2 | No |
| DFHDR_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| DFHDR_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| DFHDR_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| DFHDR_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Table Name : | WC_DFWRD_DETAIL |
| Comment : | To associate default warranty validity in terms of usage parameter value for set of part numbers for various warranty types like New , Overhaul , Repair . |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| DFWRD_PART_OUINST | _decimal_10_0 | decimal(10) | No | Part OU Instance | Yes |
| DFWRD_AGREMT_NO | _varchar_40 | varchar(40) | No | Unique number to identify agreement between supplier and operator for warranty. | Yes |
| DFWRD_AGREMT_OUINSTNCE | _decimal_10_0 | decimal(10) | No | Agreement OU Instance | Yes |
| DFWRD_AMEND_NO | _decimal_5_0 | decimal(5) | No | Warranty amendment | Yes |
| DFWRD_PART_NO | _varchar_40 | varchar(40) | No | Part number of the component for which agreement is done. | Yes |
| DFWRD_SER_NO | _decimal_5_0 | decimal(5) | No | Serial No. | Yes |
| DFWRD_WAR_TYPE | _varchar_25 | Varchar(25) | No | Different warranty types are New , Overhaul , Repair, OEM | Yes |
| DFWRD_PARAM_NAME | _varchar_40 | varchar(40) | Yes | Parameter Name of the Parameters that have Warranty Tracking as Yes and in Active status for the Part no | No |
| DFWRD_WAR_VALUE | udd_numericparamval | numeric(13) | Yes | Value for the Parameter | No |
| DFWRD_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| DFWRD_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| DFWRD_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| DFWRD_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Table Name : | WC_DFWRH_HDR |
| Comment : | Default Warranty Period Details for parts under Warranty |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| DFWRH_PART_OUINST | _decimal_10_0 | decimal(10) | No | Part OU Instance | Yes |
| DFWRH_AMEND_NO | _decimal_5_0 | decimal(5) | No | Warranty Amendement No. | Yes |
| DFWRH_AGREMT_NO | _varchar_40 | varchar(40) | No | Unique number to identify agreement between supplier and operator for warranty. | Yes |
| DFWRH_AGREMT_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| DFWRH_PART_NO | _varchar_40 | varchar(40) | No | Part number of the component for which agreement is done. | Yes |
| DFWRH_WAR_TYPE | _varchar_25 | Varchar(25) | No | Different warranty types are New , Overhaul , Repair, OEM | Yes |
| DFWRH_DFWAR_PRD | udd_duration | numeric(13) | Yes | Default Warranty Period | No |
| DFWRH_DFWAR_UOM | _varchar_10 | varchar(10) | Yes | Default Warranty Period UOM with values Years and Months . | No |
| DFWRH_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| DFWRH_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| DFWRH_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| DFWRH_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| COMPONENTNAME | _varchar_80 | varchar(80) | No | Compent Name | No |
| PARAMCATEGORY | _varchar_10 | varchar(10) | No | parameter category | No |
| PARAMTYPE | _varchar_25 | Varchar(25) | No | Parameter type | No |
| PARAMCODE | _varchar_5 | varchar(5) | No | Parameter code | No |
| PARAMDESC | _varchar_80 | varchar(80) | Yes | Parameter description | No |
| LANGID | _decimal_10_0 | decimal(10) | No | Language ID | No |
| CREATIONDATE | _datetime_8 | datetime(8) | No | CREATION DATE | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Wc_PrtCvg_OUInstance | udd_ctxt_ouinstance | int(4) | Yes | Warranty Part coverage OU Instance | No |
| Wc_PrtCvg_Agreementno | udd_documentno | varchar(40) | Yes | Warranty Part coverageAgreementno | No |
| Wc_PrtCvg_PartsCovered | udd_desc40 | varchar(40) | Yes | Warranty Part coverage Parts Covered flag | No |
| Wc_PrtCvg_Applicable | udd_designparamcode | varchar(5) | Yes | Warranty Part coverage Applicable | No |
| Wc_PrtCvg_Lowervaluelimit | udd_amount1 | numeric(13) | Yes | Warranty Part coverageLower value limit | No |
| Wc_PrtCvg_Uppervaluelimit | udd_amount1 | numeric(13) | Yes | Warranty Part coverage Upper valuel imit | No |
| Wc_PrtCvg_Annuallimit | udd_amount1 | numeric(13) | Yes | Warranty Part coverage Annual limit | No |
| Wc_PrtCvg_ClaimAgainst | udd_designparamcode | varchar(5) | Yes | Warranty Part coverage Claim Against | No |
| Wc_PrtCvg_Coverageterms | udd_txt2000 | varchar(2000) | Yes | Warranty Part coverage Coverageterms | No |
| Wc_PrtCvg_Remarks | udd_txt2000 | varchar(2000) | Yes | Warranty Part coverage_Remarks | No |
| Wc_PrtCvg_CreatedBy | udd_ctxt_user | varchar(30) | Yes | Warranty Part coverage_CreatedBy | No |
| Wc_PrtCvg_CreatedDate | _datetime_8 | datetime(8) | Yes | Warranty Part coverage_CreatedDate | No |
| Wc_PrtCvg_LastmodifiedBy | udd_ctxt_user | varchar(30) | Yes | Warranty Part coverage_LastmodifiedBy | No |
| Wc_PrtCvg_LastmodifiedDate | _datetime_8 | datetime(8) | Yes | Warranty Part coverage LastmodifiedDate | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Wc_PrtWar_OUInstance | udd_ctxt_ouinstance | int(4) | No | Part warranty claim OUInstance | Yes |
| Wc_PrtWar_Agreementno | udd_documentno | varchar(40) | No | Part warranty claim Agreementno | Yes |
| Wc_PrtWar_PartWarrantyno | udd_documentno | varchar(40) | No | Part warranty claim PartWarrantyno | Yes |
| Wc_PrtWar_PartOUInstance | udd_ctxt_ouinstance | int(4) | Yes | Part warranty claim PartOUInstance | No |
| Wc_PrtWar_Supplier | udd_vendorcode | varchar(45) | Yes | Part warranty claim Supplier | No |
| Wc_PrtWar_SuOUInstance | udd_ctxt_ouinstance | int(4) | Yes | Part warranty claim SuOUInstance | No |
| Wc_PrtWar_Backstop | udd_designparamcode | varchar(5) | Yes | Part warranty claim Backstop | No |
| Wc_PrtWar_Remarks | udd_txt2000 | varchar(2000) | Yes | Part warranty claim Remarks | No |
| Wc_PrtWar_CreatedBy | udd_ctxt_user | varchar(30) | Yes | Part warranty claim CreatedBy | No |
| Wc_PrtWar_CreatedDate | _datetime_8 | datetime(8) | Yes | Part warranty claim CreatedDate | No |
| Wc_PrtWar_LastmodifiedBy | udd_ctxt_user | varchar(30) | Yes | Part warranty claim LastmodifiedBy | No |
| Wc_PrtWar_LastmodifiedDate | _datetime_8 | datetime(8) | Yes | Part warranty claim LastmodifiedDate | No | |
| Table Name : | WC_REFER_DOCDTL |
| Comment : | Hold Reference details for the Warranty Part Aggreement |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| REFER_SEQ_NO | _decimal_5_0 | decimal(5) | No | This field holds the Unique identifier for each agreement no | Yes |
| REFER_AGREMT_NO | _varchar_40 | varchar(40) | No | Unique number to identify agreement between supplier and operator for warranty. | Yes |
| REFER_AGREMT_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU instance | Yes |
| REFER_AMEND_NO | _decimal_5_0 | decimal(5) | No | Warranty Amendement No. | Yes |
| REFER_DOC_TYPE | _varchar_25 | Varchar(25) | Yes | Type of Document. Defined in Logistic Common Master | No |
| REFER_DOC_ID | _varchar_40 | varchar(40) | Yes | Document ID | No |
| REFER_FILENAME | _varchar_50 | varchar(50) | Yes | File Name corresponding to the Document | No |
| REFER_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| REFER_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| REFER_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| REFER_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Table Name : | WC_RPRSP_ASSOCIATE |
| Comment : | To capture authorized vendor / agent details for the Supplier. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| AGRDT_PART_OUINST | _decimal_10_0 | decimal(10) | No | Part OU Instance | Yes |
| RPRSP_AGREMT_NO | _varchar_40 | varchar(40) | No | Unique number to identify agreement between supplier and operator for warranty. | Yes |
| RPRSP_AGREMT_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| RPRSP_PART_NO | _varchar_40 | varchar(40) | No | Part number of the component for which agreement is done. | Yes |
| RPRSP_AMEND_NO | _decimal_5_0 | decimal(5) | No | Warranty Amendement No. | Yes |
| RPRSP_SER_NO | _decimal_5_0 | decimal(5) | No | Serial NO | Yes |
| RPRSP_WAR_TYPE | udd_type | varchar(25) | No | Different warranty types are New , Overhaul , Repair, OEM | Yes |
| RPRSP_RPRSHP_NO | _varchar_45 | varchar(45) | Yes | Repair Shop No. | No |
| RPRSP_RMKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| RPRSP_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| RPRSP_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| RPRSP_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| RPRSP_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No |
| RPRSP_ADDRESS_ID | _decimal_5_0 | decimal(5) | Yes | Address ID of the Supplier | No | |
| Table Name : | WC_USRDT_USR_DFND |
| Comment : | Hold User Defined details for the Warranty Part Aggreement |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| USRDT_AGREMT_NO | _varchar_40 | varchar(40) | No | Unique number to identify agreement between supplier and operator for warranty. | Yes |
| USRDT_AGREMT_OUINSTNCE | _decimal_10_0 | decimal(10) | No | OU instance | Yes |
| USRDT_AMEND_NO | _decimal_5_0 | decimal(5) | No | Warranty Amendement No. | Yes |
| USRDT_DETAIL1 | _varchar_30 | varchar(30) | Yes | User Defined Detail | No |
| USRDT_OPTION1 | _varchar_25 | Varchar(25) | Yes | User Defined Option Selected from Common Logistic Master | No |
| USRDT_DETAIL2 | _varchar_30 | varchar(30) | Yes | User Defined Detai | No |
| USRDT_OPTION2 | _varchar_25 | Varchar(25) | Yes | User Defined Option | No |
| USRDT_DETAIL3 | _varchar_30 | varchar(30) | Yes | user defind detail 3 | No |
| USRDT_OPTION3 | _varchar_25 | Varchar(25) | Yes | user defind option 3 | No |
| USRDT_DETAIL4 | _varchar_30 | varchar(30) | Yes | user defind detail 4 | No |
| USRDT_OPTION4 | _varchar_25 | Varchar(25) | Yes | user defind option 4 | No |
| USRDT_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| USRDT_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created By | No |
| USRDT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| USRDT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| USRDT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified Date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WAOPT_OU_INSTANCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| WAOPT_CONFRM_GR | _varchar_20 | varchar(20) | Yes | Confirmation of Warranty Reference from GR | No |
| WAOPT_DESC_GR | _varchar_20 | varchar(20) | Yes | Default Description of Warranty Reference from GR | No |
| WAOPT_PART_SUPP_MAP | _varchar_20 | varchar(20) | Yes | Part Warranty Agg Without Supplier Part Mapping | No |
| WAOPT_PRT_AGR_CLAIM | _varchar_20 | varchar(20) | Yes | Warranty Claim without Part Warranty Agreement | No |
| WAOPT_PRT_CHK | _varchar_5 | varchar(5) | Yes | On Warranty definition in Part Administration | No |
| WAOPT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified By | No |
| WAOPT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Modified date | No |
| WAOPT_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Time Stamp | No |
| WAOPT_NUMTYPP_ACWAAGR | udd_flag2 | varchar(25) | Yes | Numbering Type | No |
| WAOPT_NUMTYPAUTO_COMPWARREF | udd_flag2 | varchar(25) | Yes | component Warranty reference | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WAQC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OU Instance | Yes |
| WAQC_QUICK_CODE | _varchar_25 | Varchar(25) | No | Quick Code | Yes |
| WAQC_TYPE | _varchar_5 | varchar(5) | No | Quick Code Type | Yes |
| WAQC_DESC | _varchar_80 | varchar(80) | Yes | Quick Code Desc | No |
| WAQC_STATUS | _varchar_15 | varchar(15) | Yes | Quick Code Status | No |
| WAQC_CREATEDDATE | _datetime_8 | datetime(8) | Yes | Quick Code Created Date | No |
| WAQC_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created BY | No |
| WAQC_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Modified date | No |
| WAQC_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Modified by | No |
| WAQC_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Time stamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WARDT_WAR_REFNO | _varchar_40 | varchar(40) | No | Warranty Reference No | Yes |
| WARDT_SER_NO | _decimal_10_0 | decimal(10) | No | Serial no | Yes |
| WARDT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Warranty Reference OU Instance | Yes |
| WARDT_PARAM_NAME | _varchar_40 | varchar(40) | Yes | parameter name | No |
| WARDT_PRM_WAR_VAL | _decimal_28_8 | decimal(28) | Yes | parameter warranty value | No |
| WARDT_PRM_EXP_VAL | _decimal_28_8 | decimal(28) | Yes | parameter expiry value | No |
| WARDT_CREATED_BY | _varchar_30 | varchar(30) | Yes | created by | No |
| WARDT_CREATED_DATE | _datetime_8 | datetime(8) | Yes | created date | No |
| WARDT_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | modified by | No |
| WARDT_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | modified date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WARMS_WAR_REFNO | _varchar_40 | varchar(40) | No | Warranty Reference No | Yes |
| WARMS_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Warranty Reference OUInstance | Yes |
| WARMS_WAR_DESC | _varchar_150 | varchar(150) | Yes | Warranty Reference desc | No |
| WARMS_STATUS | _varchar_5 | varchar(5) | Yes | Warranty Reference status | No |
| WARMS_SOURCE | _varchar_5 | varchar(5) | Yes | Warranty Reference source | No |
| WARMS_NHA_PRT_NO | _varchar_40 | varchar(40) | Yes | NHA part no | No |
| WARMS_AIRCRFT_REG | _varchar_30 | varchar(30) | Yes | Aircraft reg no | No |
| WARMS_AIRCFT_OUINST | _decimal_10_0 | decimal(10) | Yes | Aircraft OUInstance | No |
| WARMS_NHA_SER_NO | _varchar_40 | varchar(40) | Yes | NHA serial No | No |
| WARMS_SUPP_NO | _varchar_45 | varchar(45) | Yes | Supplier code | No |
| WARMS_SUPP_OUINST | _decimal_10_0 | decimal(10) | Yes | Supplier OUInstance | No |
| WARMS_COMP_ID | _varchar_90 | varchar(90) | Yes | Component Id | No |
| WARMS_COMP_OUINST | _decimal_10_0 | decimal(10) | Yes | Component OU | No |
| WARMS_REF_DOC_TYP | _varchar_5 | varchar(5) | Yes | Reference Doc Type | No |
| WARMS_REF_DOCNO | _varchar_40 | varchar(40) | Yes | Reference Doc NO | No |
| WARMS_WAR_DUR | _decimal_28_8 | decimal(28) | Yes | Warranty Duration | No |
| WARMS_DUR_UOM | _varchar_10 | varchar(10) | Yes | Warranty Duration UOM | No |
| WARMS_WAR_TYPE | _varchar_5 | varchar(5) | Yes | Warranty Type | No |
| WARMS_START_DATE | _datetime_8 | datetime(8) | Yes | Start date | No |
| WARMS_SERVI_DESC | _varchar_255 | varchar(255) | Yes | Service Desc | No |
| WARMS_CATEGORY | _varchar_25 | Varchar(25) | Yes | Warranty Category | No |
| WARMS_REMRKS | _varchar_255 | varchar(255) | Yes | REmarks | No |
| WARMS_COMMENTS | _varchar_255 | varchar(255) | Yes | Comments | No |
| WARMS_CREATED_BY | _varchar_30 | varchar(30) | Yes | created by | No |
| WARMS_CREATED_DATE | _datetime_8 | datetime(8) | Yes | created date | No |
| WARMS_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | modified by | No |
| WARMS_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | modified date | No |
| WARMS_CONFIRMED_BY | _varchar_30 | varchar(30) | Yes | This field holds the user who modified the warranty | No |
| WARMS_CONFIRMED_DATE | _datetime_8 | datetime(8) | Yes | This field holds the date when the warranty is confirmed. | No |
| WARMS_EXPIRED_BY | _varchar_30 | varchar(30) | Yes | expired by | No |
| WARMS_EXPIRED_DATE | _datetime_8 | datetime(8) | Yes | expired date | No |
| WARMS_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | time stamp | No |
| WARMS_GR_NO | _varchar_40 | varchar(40) | Yes | GR no | No |
| WARMS_GR_DATE | _datetime_8 | datetime(8) | Yes | Gr date | No |
| WARMS_AGREEMENT_NO | _varchar_40 | varchar(40) | Yes | Agreement no | No |
| WARMS_AMENDMENT_NO | _decimal_10_0 | decimal(10) | Yes | Agreemnet Amendment no | No |
| WARMS_WARR_BEGINS_ON | _varchar_5 | varchar(5) | Yes | To capture warranty begins on. It should be either Installation Date or Receipt date | No |
| WARMS_STARTS_REF_TYPE | _varchar_5 | varchar(5) | Yes | To capture warranty starts reference type List of Reference type 1. Goods Receipt 2. Component Replacement 3. Others | No |
| WARMS_STARTS_REF_NO | _varchar_40 | varchar(40) | Yes | To capture warranty starts reference no | No | |
| Table Name : | WC_WCPRM_DETAILS |
| Comment : | Stores Parameter detail information. In this component, this table needs to store only search criteria message |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCPRM_COMPONENTNAME | _varchar_80 | varchar(80) | No | Component Name | Yes |
| WCPRM_PARAMCATEGORY | _varchar_10 | varchar(10) | No | Param Category | Yes |
| WCPRM_PARAMTYPE | _varchar_25 | Varchar(25) | No | Param Type | Yes |
| WCPRM_PARAMCODE | _varchar_5 | varchar(5) | No | Param Code | Yes |
| WCPRM_LANGID | _decimal_10_0 | decimal(10) | No | Language id | Yes |
| WCPRM_PARAMDESC | _varchar_80 | varchar(80) | Yes | Param Desc | No |
| WCPRM_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date | No |
| WCPRM_SORTBY | _decimal_10_0 | decimal(10) | Yes | Sort order | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Wc_WrTrm_OUInstance | udd_ctxt_ouinstance | int(4) | No | Warranty terms OUInstance | Yes |
| Wc_WrTrm_Agreementno | udd_documentno | varchar(40) | No | Warranty termsAgreementno | Yes |
| Wc_WrTrm_WarrApplicability | udd_designparamcode | varchar(5) | Yes | Warranty terms WarrApplicability | No |
| Wc_WrTrm_Failedpartdisposition | udd_designparamcode | varchar(5) | Yes | Warranty terms Failedpartdisposition | No |
| Wc_WrTrm_DefaultClaimRemedy | udd_designparamcode | varchar(5) | Yes | Warranty termsDefaultClaimRemedy | No |
| Wc_WrTrm_ClaimCurrency | udd_designparamcode | varchar(5) | Yes | Warranty termsClaimCurrency | No |
| Wc_WrTrm_Claimwithsupp | udd_vendorcode | varchar(45) | Yes | Warranty termsClaimwithsupp | No |
| Wc_WrTrm_PartCstBasis | udd_designparamcode | varchar(5) | Yes | Warranty termsPartCstBasis | No |
| Wc_WrTrm_Shipmentcost | udd_designparamcode | varchar(5) | Yes | Warranty termsShipmentcost | No |
| Wc_WrTrm_MaxnoAnnualClaim | udd_number | int(4) | Yes | Warranty termsMaxnoAnnualClaim | No |
| Wc_WrTrm_MaxvalueAnnualClaim | udd_amount1 | numeric(13) | Yes | Warranty termsMaxvalueAnnualClaim | No |
| Wc_WrTrm_WarrantyLabourrate | udd_amount1 | numeric(13) | Yes | Warranty termsWarrantyLabourrate | No |
| Wc_WrTrm_Valuelimitprocessing | udd_amount1 | numeric(13) | Yes | Warranty termsValuelimitprocessing | No |
| Wc_WrTrm_Notifyfailuerbfrdays | udd_duration | numeric(13) | Yes | Warranty termsNotifyfailuerbfrdays | No |
| Wc_WrTrm_FailedpartHldingDays | udd_number | int(4) | Yes | Warranty termsFailedpartHldingDays | No |
| Wc_WrTrm_GenAgreementdtls | udd_txt2000 | varchar(2000) | Yes | Warranty termsGenAgreementdtls | No |
| Wc_WrTrm_Additionalterms | udd_txt2000 | varchar(2000) | Yes | Warranty termsAdditionalterms | No |
| Wc_WrTrm_Exceptions | udd_txt2000 | varchar(2000) | Yes | Warranty terms Exceptions | No |
| Wc_WrTrm_Remarks | udd_txt2000 | varchar(2000) | Yes | Warranty terms Remarks | No |
| Wc_WrTrm_Fielname | udd_txt255 | varchar(255) | Yes | Warranty terms Fielname | No |
| Wc_WrTrm_CreatedBy | udd_ctxt_user | varchar(30) | Yes | Warranty terms CreatedBy | No |
| Wc_WrTrm_CreatedDate | _datetime_8 | datetime(8) | Yes | Warranty terms CreatedDate | No |
| Wc_WrTrm_LastmodifiedBy | udd_ctxt_user | varchar(30) | Yes | Warranty terms LastmodifiedBy | No |
| Wc_WrTrm_LastmodifiedDate | _datetime_8 | datetime(8) | Yes | Warranty terms LastmodifiedDate | No |
| Wc_WrTrm_Timestamp | udd_timestamp | int(4) | Yes | Warranty terms Timestamp | No |