Warranty |
|
|
| |||||
|
|
||||||||
|
Table Name WC_ACTDT_ACTCLM_DTL |
|
|||||||
|
|
||||||||
|
Table Comment Actual Claim Details - Detail Table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
ACTDT_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
ACTDT_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Warranty Claim NO |
Yes |
Yes |
|
||
|
ACTDT_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
Warranty Claim OU Instance |
Yes |
Yes |
|
||
|
ACTDT_SER_NO |
NUMBER(10) |
NOT NULL |
Serial NO |
Yes |
No |
|
||
|
ACTDT_REMEDY |
VARCHAR2(25) |
NULL |
Remedy |
No |
No |
|
||
|
ACTDT_EXPENSE |
NUMBER(28,8) |
NULL |
expense amt |
No |
No |
|
||
|
ACTDT_CLAIM_AMT |
NUMBER(28,8) |
NULL |
claim amt |
No |
No |
|
||
|
ACTDT_REMARKS |
VARCHAR2(255) |
NULL |
remarks |
No |
No |
|
||
|
ACTDT_CREATED_BY |
VARCHAR2(30) |
NULL |
created by |
No |
No |
|
||
|
ACTDT_CREATED_DATE |
DATE |
NULL |
created date |
No |
No |
|
||
|
ACTDT_MODIFIED_BY |
VARCHAR2(30) |
NULL |
modified by |
No |
No |
|
||
|
ACTDT_MODIFIED_DATE |
DATE |
NULL |
modified date |
No |
No |
|
||
|
ACTDT_RMB_REMEDY |
NUMBER(28,8) |
NULL |
Reimbursed |
No |
No |
|
||
|
ACTDT_CLSE_CLM_REMRK |
VARCHAR2(255) |
NULL |
Close Claim Remarks |
No |
No |
|
||
|
ACTDT_REIMB_AMT |
NUMBER(28,8) |
NULL |
Reimbursed Amount |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_ACTMS_ACTCLM_HDR |
|
|||||||
|
|
||||||||
|
Table Comment Actual Claim Details - header Table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
ACTMS_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
ACTMS_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Warranty Claim NO |
Yes |
Yes |
|
||
|
ACTMS_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
Warranty Claim OU Instance |
Yes |
Yes |
|
||
|
ACTMS_CLAIM_FOR |
VARCHAR2(25) |
NULL |
Warranty Claim For |
No |
No |
|
||
|
ACTMS_CLM_MATRL_COST |
NUMBER(28,8) |
NULL |
Material cost |
No |
No |
|
||
|
ACTMS_CLM_LABR_COST |
NUMBER(28,8) |
NULL |
Labor cost |
No |
No |
|
||
|
ACTMS_CLM_FAC_COST |
NUMBER(28,8) |
NULL |
Facilities cost |
No |
No |
|
||
|
ACTMS_CLM_MISC_COST |
NUMBER(28,8) |
NULL |
Misc cost |
No |
No |
|
||
|
ACTMS_CLM_TOTAL_COST |
NUMBER(28,8) |
NULL |
Total sum claimed to the supplier |
No |
No |
|
||
|
ACTMS_COMMENTS |
VARCHAR2(255) |
NULL |
Comments |
No |
No |
|
||
|
ACTMS_EXP_REIMB |
NUMBER(28,8) |
NULL |
Total sum reimbursed by the supplier. |
No |
No |
|
||
|
ACTMS_CREATED_BY |
VARCHAR2(30) |
NULL |
created by |
No |
No |
|
||
|
ACTMS_CREATED_DATE |
DATE |
NULL |
created date |
No |
No |
|
||
|
ACTMS_MODIFIED_BY |
VARCHAR2(30) |
NULL |
modified by |
No |
No |
|
||
|
ACTMS_MODIFIED_DATE |
DATE |
NULL |
modified date |
No |
No |
|
||
|
ACTMS_RMB_MATRL_COST |
NUMBER(28,8) |
NULL |
Reimbursed Material Cost |
No |
No |
|
||
|
ACTMS_RMB_LABR_COST |
NUMBER(28,8) |
NULL |
Reimbursed Labour Cost |
No |
No |
|
||
|
ACTMS_RMB_FAC_COST |
NUMBER(28,8) |
NULL |
Reimbursed Facilities Cost |
No |
No |
|
||
|
ACTMS_RMB_MISC_COST |
NUMBER(28,8) |
NULL |
Reimbursed Misc Cost |
No |
No |
|
||
|
ACTMS_RMB_TOTAL_COST |
NUMBER(28,8) |
NULL |
Reimbursed Total Cost |
No |
No |
|
||
|
ACTMS_TOT_LBR_HRS |
NUMBER(28,8) |
NULL |
Total Labor Hours |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_AGRDT_PART_DTL |
|
|||||||
|
|
||||||||
|
Table Comment To capture an agreement for Warranty with the supplier for its components. Detail Table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
AGRDT_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
Yes |
|
||
|
AGRDT_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
AGRDT_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty Amendment No. |
Yes |
Yes |
|
||
|
AGRDT_PART_NO |
VARCHAR2(40) |
NOT NULL |
Part number of the component for which agreement is done. |
Yes |
No |
|
||
|
AGRDT_PART_OUINST |
NUMBER(10) |
NOT NULL |
Part OU Instance |
Yes |
No |
|
||
|
AGRDT_INHOUSE_RPIR |
VARCHAR2(25) |
NULL |
A flag to indicate if the component can be repaired in the shop with values "Yes","No" |
No |
No |
|
||
|
AGRDT_INSURANCE_BY |
VARCHAR2(25) |
NULL |
To capture who bears the insurance details, with possible values ’Supplier’ and ’Operator’ . |
No |
No |
|
||
|
AGRDT_INSPECT_REIMB |
VARCHAR2(25) |
NULL |
To capture Inspection Reimbursement with values "Yes","No" |
No |
No |
|
||
|
AGRDT_REIMB_LIMIT |
NUMBER(10) |
NULL |
To capture Reimbursement limit in terms of percentage of part cost. |
No |
No |
|
||
|
AGRDT_MAX_REIMB |
NUMBER(20) |
NULL |
To capture Maximum Reimbursement |
No |
No |
|
||
|
AGRDT_MTBUR |
NUMBER(28,8) |
NULL |
Facility to capture supplier guaranteed MTBUR, for a part number in the Supplier Agreement. |
No |
No |
|
||
|
AGRDT_MTBF |
NUMBER(28,8) |
NULL |
Facility to capture supplier guaranteed MTBF for a part number in the Supplier Agreement. |
No |
No |
|
||
|
AGRDT_REMARKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
AGRDT_CREATED_BY |
VARCHAR2(30) |
NULL |
Create By |
No |
No |
|
||
|
AGRDT_CREATED_DATE |
DATE |
NULL |
Create Date |
No |
No |
|
||
|
AGRDT_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
AGRDT_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
AGRDT_WARR_BEGINS_ON |
VARCHAR2(5) |
NULL |
To capture warranty begins on. It should be either Installation Date or Receipt date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_AGRMS_PART_HDR |
|
|||||||
|
|
||||||||
|
Table Comment To capture an agreement for Warranty with the supplier for its components. Master Table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
AGRMS_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
No |
|
||
|
AGRMS_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU instance |
Yes |
No |
|
||
|
AGRMS_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty Amendment No. |
Yes |
No |
|
||
|
AGRMS_SUPP_OUINSTANCE |
NUMBER(10) |
NOT NULL |
Supplier OU instance |
No |
No |
|
||
|
AGRMS_AGREMT_SUPP_ID |
VARCHAR2(45) |
NOT NULL |
Unique code to identify a supplier |
No |
No |
|
||
|
AGRMS_AGREMT_DESC |
VARCHAR2(255) |
NULL |
Description of the Warranty Agreement |
No |
No |
|
||
|
AGRMS_AGREMT_CATEGRY |
VARCHAR2(25) |
NULL |
A quick code facilitating the user to categorize the warranty agreement |
No |
No |
|
||
|
AGRMS_AGREMT_STATUS |
VARCHAR2(25) |
NULL |
Agreement status -possible values Fresh,Confirmed, pending confirmation,Cancelled and amended |
No |
No |
|
||
|
AGRMS_USER_STATUS |
VARCHAR2(25) |
NULL |
A quick code facilitating the user to define statuses apart from the standard ones |
No |
No |
|
||
|
AGRMS_AGREMT_STR_DATE |
DATE |
NULL |
Agreement Start Date |
No |
No |
|
||
|
AGRMS_AGREMT_END_DATE |
DATE |
NULL |
Agreement End Date |
No |
No |
|
||
|
AGRMS_SHIPPING_COST |
VARCHAR2(25) |
NULL |
A flag to indicate if the component has to be sent to the supplier, is the Supplier going to bear the shipping cost. Possible values "Yes","No" and "Not Applicable". |
No |
No |
|
||
|
AGRMS_NTY_FAILURE_BFR |
NUMBER(20) |
NULL |
To capture duration before which claim has to be raised after correction of a component. |
No |
No |
|
||
|
AGRMS_NTY_BFR_UOM |
VARCHAR2(10) |
NULL |
UOM to represent time-duration before which claim has to be raised after correction of a component with values "Days" and "Months". |
No |
No |
|
||
|
AGRMS_LBR_RATE_PERHR |
NUMBER(20) |
NULL |
Facility to capture Supplier agreed ’labor rate’ for warranty claim |
No |
No |
|
||
|
AGRMS_COMMENTS |
VARCHAR2(150) |
NULL |
Comments |
No |
No |
|
||
|
AGRMS_REMARKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
AGRMS_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
AGRMS_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
AGRMS_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
AGRMS_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
AGRMS_TIMESTAMP |
NUMBER(10) |
NULL |
Time Stamp |
No |
No |
|
||
|
AGRMS_CNFRMED_BY |
VARCHAR2(30) |
NULL |
Confirmed By |
No |
No |
|
||
|
AGRMS_CNFRMED_DATE |
DATE |
NULL |
Confirmed Date |
No |
No |
|
||
|
AGRMS_AGREMT_DESC_UP |
VARCHAR2(255) |
NULL |
Agreement Desc in Upper case for search |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_ASSCP_DTL |
|
|||||||
|
|
||||||||
|
Table Comment To Maintain details of Associated Sub component of the Main Component for which Warranty reference is created |
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
ASSCP_WAR_REFNO |
VARCHAR2(40) |
NOT NULL |
Warranty Reference No |
Yes |
Yes |
|
||
|
ASSCP_OUINSTANCE |
NUMBER(10) |
NOT NULL |
Warranty Reference OU Instance |
Yes |
Yes |
|
||
|
ASSCP_SER_NO |
NUMBER(10) |
NOT NULL |
Serial no |
Yes |
No |
|
||
|
ASSCP_COMP_OUINSTANCE |
NUMBER(10) |
NULL |
Component OU Instance |
No |
No |
|
||
|
ASSCP_COMP_ID |
VARCHAR2(90) |
NULL |
Component ID |
No |
No |
|
||
|
ASSCP_CREATED_BY |
VARCHAR2(30) |
NULL |
created by |
No |
No |
|
||
|
ASSCP_CREATED_DATE |
DATE |
NULL |
created date |
No |
No |
|
||
|
ASSCP_MODIFIED_BY |
VARCHAR2(30) |
NULL |
modified by |
No |
No |
|
||
|
ASSCP_MODIFIED_DATE |
DATE |
NULL |
modified date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_CLMDT_CLAIM_DTL |
|
|||||||
|
|
||||||||
|
Table Comment An Airline operator makes a Warranty Claim to a supplier when an Aircraft/Component under warranty failed due to a snag. Detail Table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
CLMDT_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
CLMDT_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
CLMDT_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Unique transaction number for the warranty claim |
Yes |
Yes |
|
||
|
CLMDT_SER_NO |
NUMBER(10) |
NOT NULL |
Serial No |
Yes |
No |
|
||
|
CLMDT_CMP_WK_ODR_NO |
VARCHAR2(40) |
NULL |
The Work Order Number that is raised on the Component for Shop visit/Repair |
No |
No |
|
||
|
CLMDT_REMARKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
CLMDT_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
CLMDT_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
CLMDT_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
CLMDT_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
CLMDT_MATRL_COST |
NUMBER(28,8) |
NULL |
Material Cost |
No |
No |
|
||
|
CLMDT_LABOR_COST |
NUMBER(28,8) |
NULL |
Labor cost |
No |
No |
|
||
|
CLMDT_LABOR_HOURS |
NUMBER(28,8) |
NULL |
LABOR HOURS |
No |
No |
|
||
|
CLMDT_FACT_COST |
NUMBER(28,8) |
NULL |
Facilities cost |
No |
No |
|
||
|
CLMDT_MISC_COST |
NUMBER(28,8) |
NULL |
Misc cost |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_CLMMS_CLAIM_HDR |
|
|||||||
|
|
||||||||
|
Table Comment An Airline operator makes a Warranty Claim to a supplier when an Aircraft/Component under warranty failed due to a snag. Master Table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
CLMMS_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Unique transaction number for the warranty claim |
Yes |
No |
|
||
|
CLMMS_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
No |
|
||
|
CLMMS_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
No |
|
||
|
CLMMS_WAR_REF_NO |
|
NULL |
Unique number to identify a warranty. |
No |
No |
|
||
|
CLMMS_COMP_ID |
VARCHAR2(90) |
NULL |
Component id |
No |
No |
|
||
|
CLMMS_CLAIM_STATUS |
VARCHAR2(5) |
NULL |
Facility to have the Warranty claim statuses like ’Open’, ’’Cancelled’, ’Released’, ’ Revised’, ’Freezed ’,’ ’Closed’. |
No |
No |
|
||
|
CLMMS_CLAIM_DESC |
VARCHAR2(150) |
NULL |
Textual description of the warranty claim |
No |
No |
|
||
|
CLMMS_CLAIM_CATEG |
VARCHAR2(25) |
NULL |
A quick code facilitating the user to categorize the warranty claim |
No |
No |
|
||
|
CLMMS_CLAIM_TYPE |
VARCHAR2(5) |
NULL |
Predefined categorization based on the type of claim like ’Reliability’, ’Failure’ |
No |
No |
|
||
|
CLMMS_REIMB_TYPE |
VARCHAR2(5) |
NULL |
Predefined categorization based on the type of reimbursement like ’Cash’, ’Credit’ |
No |
No |
|
||
|
CLMMS_USER_STATUS |
VARCHAR2(25) |
NULL |
A quick code facilitating the user to define statuses apart from the standard ones |
No |
No |
|
||
|
CLMMS_SUGG_ACTION |
VARCHAR2(25) |
NULL |
Predefined categorization of suggested Supplier action like ’Repair’, ’Exchange’ |
No |
No |
|
||
|
CLMMS_CLAIM_PRIRTY |
NUMBER(10) |
NULL |
User defined Priority codes of the Warranty Claim like Urgent, Normal, AOG, etc., |
No |
No |
|
||
|
CLMMS_AGGR_NO |
VARCHAR2(40) |
NULL |
Unique number to identify agreement between supplier and operator for warranty. |
No |
No |
|
||
|
CLMMS_AMEND_NO |
NUMBER(5) |
NULL |
Agreement Amendment No |
No |
No |
|
||
|
CLMMS_REPAIR_AT |
VARCHAR2(5) |
NULL |
In some cases the supplier and the operator can decide to repair the component in operator premises. Flag to specify inhouse or not |
No |
No |
|
||
|
CLMMS_COMP_REP_NO |
VARCHAR2(40) |
NULL |
Reference Number through which component Removal has taken place. |
No |
No |
|
||
|
CLMMS_PRT_FLD_DATE |
DATE |
NULL |
The date on which the failure has occurred. |
No |
No |
|
||
|
CLMMS_REASON_NO |
VARCHAR2(20) |
NULL |
User Defined Reason for a claim being rejected by the Supplier. |
No |
No |
|
||
|
CLMMS_BER |
VARCHAR2(5) |
NULL |
A flag to indicate if a component is declared as Beyond Economic Repair (BER) |
No |
No |
|
||
|
CLMMS_HOLD_PERIOD |
NUMBER(28,8) |
NULL |
The holding period for components declared as Beyond Economic Repair (BER) |
No |
No |
|
||
|
CLMMS_HLD_PRD_UOM |
VARCHAR2(5) |
NULL |
The holding period for components declared as Beyond Economic Repair (BER) - Unit of Measure |
No |
No |
|
||
|
CLMMS_ACCEPT_STATUS |
VARCHAR2(5) |
NULL |
Various acceptance statuses like ’Accepted’, ’Rejected’, and ’Under Dispute’. |
No |
No |
|
||
|
CLMMS_COMMENTS |
VARCHAR2(255) |
NULL |
Comments |
No |
No |
|
||
|
CLMMS_REMARKS |
|
NULL |
Remarks |
No |
No |
|
||
|
CLMMS_CLM_GR_NO |
VARCHAR2(40) |
NULL |
Claim GR No. |
No |
No |
|
||
|
CLMMS_CLM_INV_NO |
|
NULL |
Claim Invoice No |
No |
No |
|
||
|
CLMMS_NFF |
VARCHAR2(5) |
NULL |
No Fault Found Details |
No |
No |
|
||
|
CLMMS_SUPP_BER |
|
NULL |
Supplier Response BER |
No |
No |
|
||
|
CLMMS_SUPP_REFDOC_NO |
VARCHAR2(40) |
NULL |
SUPPLIER REFERENCE DOC NO |
No |
No |
|
||
|
CLMMS_SUPP_RESP_DATE |
DATE |
NULL |
SUPPLIER RESPONSE DATE |
No |
No |
|
||
|
CLMMS_SUPP_REASON_NO |
VARCHAR2(20) |
NULL |
SUPPLIER REJECTION REASON NO |
No |
No |
|
||
|
CLMMS_SUPP_RSPNSE |
VARCHAR2(2000) |
NULL |
SUPPLIER RESPONSE |
No |
No |
|
||
|
CLMMS_SUPP_ACTION |
VARCHAR2(255) |
NULL |
SUPPLIER ACTION |
No |
No |
|
||
|
CLMMS_MTBF |
NUMBER(28,8) |
NULL |
MTBF - added for Integration Service |
No |
No |
|
||
|
CLMMS_MTBUR |
|
NULL |
MTBUR - added for Integration Service |
No |
No |
|
||
|
CLMMS_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
CLMMS_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
CLMMS_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
CLMMS_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
CLMMS_RLSED_BY |
VARCHAR2(30) |
NULL |
Released By |
No |
No |
|
||
|
CLMMS_RLSED_DATE |
DATE |
NULL |
Released Date |
No |
No |
|
||
|
CLMMS_FRZED_BY |
VARCHAR2(30) |
NULL |
Freeze by |
No |
No |
|
||
|
CLMMS_FRZED_DATE |
DATE |
NULL |
Freeze date |
No |
No |
|
||
|
CLMMS_CLOSED_BY |
VARCHAR2(30) |
NULL |
Closed by |
No |
No |
|
||
|
CLMMS_CLOSED_DATE |
DATE |
NULL |
Closed Date |
No |
No |
|
||
|
CLMMS_TIMESTAMP |
NUMBER(10) |
NULL |
Time stamp |
No |
No |
|
||
|
CLMMS_PRTFLD_TIME |
DATE |
NULL |
Part Failed Time |
No |
No |
|
||
|
CLMMS_SUP_WARR_REFNO |
VARCHAR2(40) |
NULL |
This field holds supplier warranty reference no. |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_CLMPM_PARAM_VALUE |
|
|||||||
|
|
||||||||
|
Table Comment Maintain Claim parameters and its values |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
CLMPM_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
CLMPM_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Warranty Claim no |
Yes |
Yes |
|
||
|
CLMPM_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
Claim Ou instance |
Yes |
Yes |
|
||
|
CLMPM_SER_NO |
NUMBER(10) |
NOT NULL |
Serial NO |
Yes |
No |
|
||
|
CLMPM_PARAMETER |
VARCHAR2(40) |
NULL |
The Consumption type parameters based on which Warranty is tracked. |
No |
No |
|
||
|
CLMPM_PARAM_VALUE |
NUMBER |
NULL |
Parameter value |
No |
No |
|
||
|
CLMPM_CREATED_BY |
VARCHAR2(30) |
NULL |
Created BY |
No |
No |
|
||
|
CLMPM_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
CLMPM_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified by |
No |
No |
|
||
|
CLMPM_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_CLMRF_DOCDTL |
|
|||||||
|
|
||||||||
|
Table Comment Hold Reference details for the Warranty Claim |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
CLMRF_SEQ_NO |
NUMBER(10) |
NOT NULL |
This field holds the Unique identifier for each claim no |
Yes |
No |
|
||
|
CLMRF_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Unique transaction number for the warranty claim |
Yes |
Yes |
|
||
|
CLMRF_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
CLMRF_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
CLMRF_DOC_TYPE |
VARCHAR2(25) |
NULL |
Type of Document. Defined in Logistic Common Master |
No |
No |
|
||
|
CLMRF_DOC_ID |
VARCHAR2(40) |
NULL |
Document ID |
No |
No |
|
||
|
CLMRF_FILENAME |
VARCHAR2(50) |
NULL |
File Name corresponding to the Document |
No |
No |
|
||
|
CLMRF_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
CLMRF_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
CLMRF_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
CLMRF_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_CLMUD_USR_DFND |
|
|||||||
|
|
||||||||
|
Table Comment Hold User Defined details for the Warranty claim |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
CLMUD_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Unique transaction number for the warranty claim |
Yes |
Yes |
|
||
|
CLMUD_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
CLMUD_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
CLMUD_DETAIL1 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
CLMUD_OPTION1 |
VARCHAR2(25) |
NULL |
User Defined Option Selected from Common Logistic Master |
No |
No |
|
||
|
CLMUD_DETAIL2 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
CLMUD_OPTION2 |
VARCHAR2(25) |
NULL |
User Defined Option |
No |
No |
|
||
|
CLMUD_DETAIL3 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
CLMUD_OPTION3 |
VARCHAR2(25) |
NULL |
User Defined Option |
No |
No |
|
||
|
CLMUD_DETAIL4 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
CLMUD_OPTION4 |
VARCHAR2(25) |
NULL |
User Defined Option |
No |
No |
|
||
|
CLMUD_REMARKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
CLMUD_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
CLMUD_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
CLMUD_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
CLMUD_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_DFDTL_DEFECT_RPT |
|
|||||||
|
|
||||||||
|
Table Comment Maintain Defect reports associated with discrepancies |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
DFDTL_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
DFDTL_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Unique transaction number for the warranty claim |
Yes |
Yes |
|
||
|
DFDTL_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
DFDTL_SER_NO |
NUMBER(10) |
NOT NULL |
Serial NO |
Yes |
No |
|
||
|
DFDTL_DISCREP_NO |
VARCHAR2(40) |
NULL |
Discrepancy no |
No |
No |
|
||
|
DFDTL_COMMENTS |
VARCHAR2(255) |
NULL |
comments |
No |
No |
|
||
|
DFDTL_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
DFDTL_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
DFDTL_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
DFDTL_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_DFHDR_DEFECT_RPT |
|
|||||||
|
|
||||||||
|
Table Comment Maintain Defect Reports |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
DFHDR_CLAIM_REVNO |
VARCHAR2(40) |
NOT NULL |
Claim Revision No |
Yes |
Yes |
|
||
|
DFHDR_WAR_CLAIM_NO |
VARCHAR2(40) |
NOT NULL |
Unique transaction number for the warranty claim |
Yes |
Yes |
|
||
|
DFHDR_CLAIM_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
DFHDR_REMARK1 |
VARCHAR2(255) |
NULL |
Remarks 1 |
No |
No |
|
||
|
DFHDR_REMARK2 |
VARCHAR2(255) |
NULL |
Remarks 2 |
No |
No |
|
||
|
DFHDR_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
DFHDR_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
DFHDR_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
DFHDR_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_DFWRD_DETAIL |
|
|||||||
|
|
||||||||
|
Table 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’. |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
DFWRD_PART_OUINST |
NUMBER(10) |
NOT NULL |
Part OU Instance |
Yes |
Yes |
|
||
|
DFWRD_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
Yes |
|
||
|
DFWRD_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
Agreement OU Instance |
Yes |
Yes |
|
||
|
DFWRD_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty amendment |
Yes |
Yes |
|
||
|
DFWRD_PART_NO |
VARCHAR2(40) |
NOT NULL |
Part number of the component for which agreement is done. |
Yes |
Yes |
|
||
|
DFWRD_SER_NO |
NUMBER(5) |
NOT NULL |
Serial No. |
Yes |
No |
|
||
|
DFWRD_WAR_TYPE |
VARCHAR2(25) |
NOT NULL |
Different warranty types are ’New’, ’Overhaul’, Repair, OEM |
Yes |
Yes |
|
||
|
DFWRD_PARAM_NAME |
VARCHAR2(40) |
NULL |
Parameter Name of the Parameters that have Warranty Tracking as "Yes" and in "Active" status for the Part # |
No |
No |
|
||
|
DFWRD_WAR_VALUE |
NUMBER(20) |
NULL |
Value for the Parameter |
No |
No |
|
||
|
DFWRD_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
DFWRD_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
DFWRD_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
DFWRD_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_DFWRH_HDR |
|
|||||||
|
|
||||||||
|
Table Comment Default Warranty Period Details for parts under Warranty |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
DFWRH_PART_OUINST |
NUMBER(10) |
NOT NULL |
Part OU Instance |
Yes |
Yes |
|
||
|
DFWRH_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty Amendment No. |
Yes |
Yes |
|
||
|
DFWRH_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
Yes |
|
||
|
DFWRH_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
DFWRH_PART_NO |
VARCHAR2(40) |
NOT NULL |
Part number of the component for which agreement is done. |
Yes |
Yes |
|
||
|
DFWRH_WAR_TYPE |
VARCHAR2(25) |
NOT NULL |
Different warranty types are ’New’, ’Overhaul’, Repair, OEM |
Yes |
No |
|
||
|
DFWRH_DFWAR_PRD |
NUMBER(20) |
NULL |
Default Warranty Period |
No |
No |
|
||
|
DFWRH_DFWAR_UOM |
VARCHAR2(10) |
NULL |
Default Warranty Period UOM with values "Years" and "Months". |
No |
No |
|
||
|
DFWRH_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
DFWRH_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
DFWRH_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
DFWRH_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_REFER_DOCDTL |
|
|||||||
|
|
||||||||
|
Table Comment Hold Reference details for the Warranty Part Agreement |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
REFER_SEQ_NO |
NUMBER(5) |
NOT NULL |
This field holds the Unique identifier for each agreement no |
Yes |
No |
|
||
|
REFER_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
Yes |
|
||
|
REFER_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU instance |
Yes |
Yes |
|
||
|
REFER_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty Amendment No. |
Yes |
Yes |
|
||
|
REFER_DOC_TYPE |
VARCHAR2(25) |
NULL |
Type of Document. Defined in Logistic Common Master |
No |
No |
|
||
|
REFER_DOC_ID |
VARCHAR2(40) |
NULL |
Document ID |
No |
No |
|
||
|
REFER_FILENAME |
VARCHAR2(50) |
NULL |
File Name corresponding to the Document |
No |
No |
|
||
|
REFER_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
REFER_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
REFER_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
REFER_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_RPRSP_ASSOCIATE |
|
|||||||
|
|
||||||||
|
Table Comment To capture authorized vendor / agent details for the Supplier. |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
AGRDT_PART_OUINST |
NUMBER(10) |
NOT NULL |
Part OU Instance |
Yes |
Yes |
|
||
|
RPRSP_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
Yes |
|
||
|
RPRSP_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
Yes |
|
||
|
RPRSP_PART_NO |
VARCHAR2(40) |
NOT NULL |
Part number of the component for which agreement is done. |
Yes |
Yes |
|
||
|
RPRSP_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty Amendment No. |
Yes |
Yes |
|
||
|
RPRSP_SER_NO |
NUMBER(5) |
NOT NULL |
Serial NO |
Yes |
No |
|
||
|
RPRSP_WAR_TYPE |
VARCHAR2(25) |
NULL |
Different warranty types are ’New’, ’Overhaul’, Repair, OEM |
No |
No |
|
||
|
RPRSP_RPRSHP_NO |
VARCHAR2(45) |
NULL |
Repair Shop No. |
No |
No |
|
||
|
RPRSP_RMKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
RPRSP_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
RPRSP_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
RPRSP_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
RPRSP_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
RPRSP_ADDRESS_ID |
NUMBER(5) |
NULL |
Address ID of the Supplier |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_USRDT_USR_DFND |
|
|||||||
|
|
||||||||
|
Table Comment Hold User Defined details for the Warranty Part Agreement |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
USRDT_AGREMT_NO |
VARCHAR2(40) |
NOT NULL |
Unique number to identify agreement between supplier and operator for warranty. |
Yes |
Yes |
|
||
|
USRDT_AGREMT_OUINSTNCE |
NUMBER(10) |
NOT NULL |
OU instance |
Yes |
Yes |
|
||
|
USRDT_AMEND_NO |
NUMBER(5) |
NOT NULL |
Warranty Amendment No. |
Yes |
Yes |
|
||
|
USRDT_DETAIL1 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
USRDT_OPTION1 |
VARCHAR2(25) |
NULL |
User Defined Option Selected from Common Logistic Master |
No |
No |
|
||
|
USRDT_DETAIL2 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
USRDT_OPTION2 |
VARCHAR2(25) |
NULL |
User Defined Option |
No |
No |
|
||
|
USRDT_DETAIL3 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
USRDT_OPTION3 |
VARCHAR2(25) |
NULL |
User Defined Option |
No |
No |
|
||
|
USRDT_DETAIL4 |
VARCHAR2(30) |
NULL |
User Defined Detail |
No |
No |
|
||
|
USRDT_OPTION4 |
VARCHAR2(25) |
NULL |
User Defined Option |
No |
No |
|
||
|
USRDT_REMARKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
USRDT_CREATED_BY |
VARCHAR2(30) |
NULL |
Created By |
No |
No |
|
||
|
USRDT_CREATED_DATE |
DATE |
NULL |
Created Date |
No |
No |
|
||
|
USRDT_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
USRDT_MODIFIED_DATE |
DATE |
NULL |
Modified Date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_WAOPT_OPTIONS |
|
|||||||
|
|
||||||||
|
Table Comment Option Setting for the BASWA Component |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
WAOPT_OU_INSTANCE |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
No |
|
||
|
WAOPT_CONFRM_GR |
VARCHAR2(20) |
NULL |
Confirmation of Warranty Reference from GR |
No |
No |
|
||
|
WAOPT_DESC_GR |
VARCHAR2(20) |
NULL |
Default Description of Warranty Reference from GR |
No |
No |
|
||
|
WAOPT_PART_SUPP_MAP |
VARCHAR2(20) |
NULL |
Part Warranty Agg Without Supplier-Part Mapping |
No |
No |
|
||
|
WAOPT_PRT_AGR_CLAIM |
VARCHAR2(20) |
NULL |
Warranty Claim without Part Warranty Agreement |
No |
No |
|
||
|
WAOPT_PRT_CHK |
VARCHAR2(5) |
NULL |
On Warranty definition in Part Administration |
No |
No |
|
||
|
WAOPT_MODIFIED_BY |
VARCHAR2(30) |
NULL |
Modified By |
No |
No |
|
||
|
WAOPT_MODIFIED_DATE |
DATE |
NULL |
Modified date |
No |
No |
|
||
|
WAOPT_TIMESTAMP |
NUMBER(10) |
NULL |
Time Stamp |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_WAQc_Quick_Code |
|
|||||||
|
|
||||||||
|
Table Comment Quick Codes |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
WAQc_OUInstance |
NUMBER(10) |
NOT NULL |
OU Instance |
Yes |
No |
|
||
|
WAQc_Quick_Code |
VARCHAR2(25) |
NOT NULL |
Quick Code |
Yes |
No |
|
||
|
WAQc_Type |
VARCHAR2(5) |
NOT NULL |
Quick Code Type |
Yes |
No |
|
||
|
WAQc_Desc |
VARCHAR2(80) |
NULL |
Quick Code Desc |
No |
No |
|
||
|
WAQc_Status |
VARCHAR2(15) |
NULL |
Quick Code Status |
No |
No |
|
||
|
WAQc_CreatedDate |
DATE |
NULL |
Quick Code Created Date |
No |
No |
|
||
|
WAQc_Created_By |
VARCHAR2(30) |
NULL |
Created BY |
No |
No |
|
||
|
WAQc_ModifiedDate |
DATE |
NULL |
Modified date |
No |
No |
|
||
|
WAQc_Modified_By |
VARCHAR2(30) |
NULL |
Modified by |
No |
No |
|
||
|
WAQc_Timestamp |
NUMBER(10) |
NULL |
Time stamp |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_WARDT_INFO_DTL |
|
|||||||
|
|
||||||||
|
Table Comment Warranty Reference Information - Detail table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
WARDT_WAR_REFNO |
VARCHAR2(40) |
NOT NULL |
Warranty Reference No |
Yes |
Yes |
|
||
|
WARDT_SER_NO |
NUMBER(10) |
NOT NULL |
Serial no |
Yes |
No |
|
||
|
WARDT_OUINSTANCE |
NUMBER(10) |
NOT NULL |
Warranty Reference OU Instance |
Yes |
Yes |
|
||
|
WARDT_PARAM_NAME |
VARCHAR2(40) |
NULL |
parameter name |
No |
No |
|
||
|
WARDT_PRM_WAR_VAL |
NUMBER(28,8) |
NULL |
parameter warranty value |
No |
No |
|
||
|
WARDT_PRM_EXP_VAL |
NUMBER(28,8) |
NULL |
parameter expiry value |
No |
No |
|
||
|
WARDT_CREATED_BY |
VARCHAR2(30) |
NULL |
created by |
No |
No |
|
||
|
WARDT_CREATED_DATE |
DATE |
NULL |
created date |
No |
No |
|
||
|
WARDT_MODIFIED_BY |
VARCHAR2(30) |
NULL |
modified by |
No |
No |
|
||
|
WARDT_MODIFIED_DATE |
DATE |
NULL |
modified date |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_WARMS_INFO_HDR |
|
|||||||
|
|
||||||||
|
Table Comment Warranty Reference Information - Master table |
|
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
WARMS_WAR_REFNO |
VARCHAR2(40) |
NOT NULL |
Warranty Reference No |
Yes |
No |
|
||
|
WARMS_OUINSTANCE |
NUMBER(10) |
NOT NULL |
Warranty Reference OUInstance |
Yes |
No |
|
||
|
WARMS_WAR_DESC |
VARCHAR2(150) |
NULL |
Warranty Reference desc |
No |
No |
|
||
|
WARMS_STATUS |
VARCHAR2(5) |
NULL |
Warranty Reference status |
No |
No |
|
||
|
WARMS_SOURCE |
VARCHAR2(5) |
NULL |
Warranty Reference source |
No |
No |
|
||
|
WARMS_NHA_PRT_NO |
VARCHAR2(40) |
NULL |
NHA part no |
No |
No |
|
||
|
WARMS_AIRCRFT_REG |
VARCHAR2(30) |
NULL |
Aircraft reg no |
No |
No |
|
||
|
WARMS_AIRCFT_OUINST |
NUMBER(10) |
NULL |
Aircraft OUInstance |
No |
No |
|
||
|
WARMS_NHA_SER_NO |
VARCHAR2(40) |
NULL |
NHA serial No |
No |
No |
|
||
|
WARMS_SUPP_NO |
VARCHAR2(45) |
NULL |
Supplier code |
No |
No |
|
||
|
WARMS_SUPP_OUINST |
NUMBER(10) |
NULL |
Supplier OUInstance |
No |
No |
|
||
|
WARMS_COMP_ID |
VARCHAR2(90) |
NULL |
Component Id |
No |
No |
|
||
|
WARMS_COMP_OUINST |
NUMBER(10) |
NULL |
Component OU |
No |
No |
|
||
|
WARMS_REF_DOC_TYP |
VARCHAR2(5) |
NULL |
Reference Doc Type |
No |
No |
|
||
|
WARMS_REF_DOCNO |
VARCHAR2(40) |
NULL |
Reference Doc NO |
No |
No |
|
||
|
WARMS_WAR_DUR |
NUMBER(28,8) |
NULL |
Warranty Duration |
No |
No |
|
||
|
WARMS_DUR_UOM |
VARCHAR2(10) |
NULL |
Warranty Duration UOM |
No |
No |
|
||
|
WARMS_WAR_TYPE |
VARCHAR2(5) |
NULL |
Warranty Type |
No |
No |
|
||
|
WARMS_START_DATE |
DATE |
NULL |
Start date |
No |
No |
|
||
|
WARMS_SERVI_DESC |
VARCHAR2(255) |
NULL |
Service Desc |
No |
No |
|
||
|
WARMS_CATEGORY |
VARCHAR2(25) |
NULL |
Warranty Category |
No |
No |
|
||
|
WARMS_REMRKS |
VARCHAR2(255) |
NULL |
Remarks |
No |
No |
|
||
|
WARMS_COMMENTS |
VARCHAR2(255) |
NULL |
Comments |
No |
No |
|
||
|
WARMS_CREATED_BY |
VARCHAR2(30) |
NULL |
created by |
No |
No |
|
||
|
WARMS_CREATED_DATE |
DATE |
NULL |
created date |
No |
No |
|
||
|
WARMS_MODIFIED_BY |
VARCHAR2(30) |
NULL |
modified by |
No |
No |
|
||
|
WARMS_MODIFIED_DATE |
DATE |
NULL |
modified date |
No |
No |
|
||
|
WARMS_CONFIRMED_BY |
VARCHAR2(30) |
NULL |
This field holds the user who modified the warranty |
No |
No |
|
||
|
WARMS_CONFIRMED_DATE |
DATE |
NULL |
This field holds the date when the warranty is confirmed. |
No |
No |
|
||
|
WARMS_EXPIRED_BY |
VARCHAR2(30) |
NULL |
expired by |
No |
No |
|
||
|
WARMS_EXPIRED_DATE |
DATE |
NULL |
expired date |
No |
No |
|
||
|
WARMS_TIMESTAMP |
NUMBER(10) |
NULL |
time stamp |
No |
No |
|
||
|
WARMS_GR_NO |
VARCHAR2(40) |
NULL |
GR # |
No |
No |
|
||
|
WARMS_GR_DATE |
DATE |
NULL |
Gr date |
No |
No |
|
||
|
WARMS_AGREEMENT_NO |
VARCHAR2(40) |
NULL |
Agreement no |
No |
No |
|
||
|
WARMS_AMENDMENT_NO |
NUMBER(10) |
NULL |
Agreement Amendment no |
No |
No |
|
||
|
WARMS_WARR_BEGINS_ON |
VARCHAR2(5) |
NULL |
To capture warranty begins on. It should be either Installation Date or Receipt date |
No |
No |
|
||
|
WARMS_STARTS_REF_TYPE |
VARCHAR2(5) |
NULL |
To capture warranty starts reference type List of Reference type 1. Goods Receipt 2. Component Replacement 3. Others |
No |
No |
|
||
|
WARMS_STARTS_REF_NO |
VARCHAR2(40) |
NULL |
To capture warranty starts reference no |
No |
No |
|
||
|
|
||||||||
|
Table Name WC_WCPRM_details |
|
|||||||
|
|
||||||||
|
Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message |
| |||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
||
|
WCPRM_ComponentName |
VARCHAR2(80) |
NOT NULL |
Component Name |
Yes |
No |
|
||
|
WCPRM_ParamCategory |
VARCHAR(10) |
NOT NULL |
Param Category |
Yes |
No |
|
||
|
WCPRM_ParamType |
VARCHAR2(25) |
NOT NULL |
Param Type |
Yes |
No |
|
||
|
WCPRM_ParamCode |
VARCHAR2(5) |
NOT NULL |
Param Code |
Yes |
No |
|
||
|
WCPRM_Langid |
NUMBER(10) |
NOT NULL |
Language id |
Yes |
No |
|
||
|
WCPRM_ParamDesc |
VARCHAR2(80) |
NULL |
Param Desc |
No |
No |
|
||
|
WCPRM_CreationDate |
DATE |
NULL |
Creation Date |
No |
No |
|
||
|
WCPRM_SortBy |
NUMBER(10) |
NULL |
Sort order |
No |
No |
|
||
|
|
|
|
|
|
|
|
|
|