Data Dictionary -- Repair Order

Srl. No.	Table Name	Comment
1	REP_RAACDT_REC_ACK_DTL	This field is to hold the acknowledgement Details for the Repair Order / Amendment Number
2	REP_RACDT_REC_ACK_DTL	This table is to hold Acknowledgement Details for the Repair Order.
3	REP_RACPMD_COMP_PARAM_DTL	This tableis to hold life Parameter Details for the Repair Order -Amendment Numbers .
4	REP_RADD_DISCREPANCY_DTL	This field is to hold the discrepancy Details for the Repair Order -Amendment Numbers
5	REP_RADOT_DOC_TCD_DTL	This field is tohold the Document Tcd Details for the Repair Order /Amendment Number
6	REP_RALTD_LABOUR_TCD_DTL	This field is to hold the Labour Tcd Details for the Repair Order-Amendment Numbers
7	REP_RAMCDT_MATL_COST_DTL	Material cost Detail for the Repair Order /Amendment no
8	REP_RAMTCD_MAT_TCD_DTL	This field is to hold the Material Tcd Details for Each Material of the Repair Order - Amendment Numbers
9	Rep_RAPrt_PiecePart_Dtl	This table is to hold Piece part information for the Repair Order -Amendment Numbers .
10	REP_RAQUD_QUOTE_DTL	This field is to hold the Quotation Details for the Repair Order -Amendment Numbers
11	REP_RASSD_SPARE_SHIP_DTL	This field is to hold the spare Ship Details for the Repair Order-Amendment Numbers
12	REP_RATMCN_TERM_COND_INFO	This table is to capture the terms and condition details of Repair Order Amendments
13	REP_RCPMDT_COMP_PARAM_DTL	This table is to hold the life Parameter Details of the Repair Order .
14	REP_RDD_DISCREPANCY_DTL	This field is to hold the Discrepancy Details for the Repair Order .
15	REP_RDOT_DOC_TCD_DTL	This table is to capture Document Tcd Details for the Repair Order.
16	REP_REPAUI_USER_DEF_INFO	This table is to capture the User Defined Details for the Repair Order /Amendment Numbers
17	REP_REPPRM_PARAMETER_DTL	This table is to hold Parameter Details for the Repair Order.
18	REP_REPSC_SUP_CORR_DETAILS	This table holds supplier correspondence details for a RO document subsequent to the authorization of the RO and the document is received by the repair agency
19	REP_REPUI_USER_DEF_INFO	User Defined Details for the Repair Order .
20	REP_RLBTD_LABOUR_TCD_DTL	This table is to hold Labout Tcd Details of the Repair Order .
21	REP_RMCDT_MATL_COST_DTL	This table is to hold Material Cost Details for the QUotation of the Repair Order.
22	REP_RMTCD_MAT_TCD_DTL	This field holds the Material Tcd Details for the Materials of the Quotation of the Repair Order.
23	REP_ROAH_REPAIR_ORDER_HDR	This field is to hold Repair Order-Amendment history Header Info
24	Rep_ROGen_Inp_Dtl	This table is to capture the AUTO Repair order generation
25	REP_ROHD_REPAIR_ORDER_HDR	THis table is to capture Repair Order Info
26	Rep_ROPrt_PiecePart_Dtl	This table is to hold Piece part information for the Repair Order -Amendment Numbers
27	REP_ROSOPT_SETOPTION_INFO	This table is to capture the repair order set option info.
28	REP_RQUD_QUOTE_DTL	This field holds the Quotation Details for the Repair Order.
29	REP_RSPID_SPARE_ISSUE_DTL	This table is to hold Spares Lot/Serial no Issue Details of the Repair Order Number
30	REP_RSPSD_SPARE_SHIP_DTL	This table is to hold the Spare Ship Details of the Repair Orders
31	REP_RTMCN_TERM_COND_INFO	This table is to hold terms and condition details of the Repair order Number
32	REP_RWSCAD_WORK_SCOPE_DTL	Work Unit Details of the Repair Orderno / Amendment no
33	REP_RWSCDT_WORK_SCOPE_DTL	This table is to hold Work Unit Details of the Repair Orderno

Table Name :	REP_RAACDT_REC_ACK_DTL
Comment :	This field is to hold the acknowledgement Details for the Repair Order / Amendment Number

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAACDT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair orders	Yes
RAACDT_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number for amended repair orders	Yes
RAACDT_ACK_ID	_decimal_10_0	decimal(10)	No	This table is to hold the AcknowledgeMent Number of The Repair Order. for amended repair orders	Yes
RAACDT_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This table is to capture the Amendment Number of Repair Order. for amended repair orders	Yes
RAACDT_ACK_REF_NO	_varchar_40	varchar(40)	No	This field is to hold the Acknowledgement Reference Number of the Repair Order. for amended repair orders	No
RAACDT_ACK_RECD_PART_NO	_varchar_40	varchar(40)	No	This table is to hold the Received Part Number of repair order for amended repair orders	No
RAACDT_ACK_RECD_SERIAL_NO	_varchar_40	varchar(40)	No	This table is to hold the received serial number of repair order for amended repair orders	No
RAACDT_ACK_DATE	_datetime_8	datetime(8)	No	This field is to hold the AcknowledgeMent Date of repair order for amended repair orders	No
RAACDT_ACK_SHIP_NOTE_NO	_varchar_40	varchar(40)	Yes	This field is to hold the Shipping Note of repair order for amended repair orders	No
RAACDT_ACK_RECEIPT_STATUS	_varchar_5	varchar(5)	Yes	This field is to hold the Receipt Status of the Acknowledged Repair Order Allowed values are Y Yes N No for amended repair orders	No
RAACDT_ACK_COMMENTS	_varchar_255	varchar(255)	Yes	Thsif ield is to hold the comments for the Acknowledegment for amended repair orders	No
RAACDT_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold the user who created the record for amended repair orders	No
RAACDT_CREATED_DATE	_datetime_8	datetime(8)	No	This field is tohold the Date on which the Repair Order Number was Created for amended repair orders	No
RAACDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is to hold the User Who modified the Repair Order for amended repair orders	No
RAACDT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is to hold the Last Date on which the Repair Order got Modified. for amended repair orders	No

Table Name :	REP_RACDT_REC_ACK_DTL
Comment :	This table is to hold Acknowledgement Details for the Repair Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RACDT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RACDT_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair Order Number	Yes
RACDT_ACK_ID	_decimal_10_0	decimal(10)	No	This field is to hold The Acknowledgement id	Yes
RACDT_ACK_REF_NO	_varchar_40	varchar(40)	No	This field is to hold the Acknowledgement Reference Number	No
RACDT_ACK_DATE	_datetime_8	datetime(8)	No	This field holds the AcknowledgeMent Date	No
RACDT_ACK_SHIP_NOTE_NO	_varchar_40	varchar(40)	Yes	This field holds the Shipping Note of the Repair Order Number for acknowledgement	No
RACDT_ACK_RECEIPT_STATUS	_varchar_5	varchar(5)	Yes	This field hold the Receipt Status for the Repair Order for acknowledgement. Allowed values are Y Yes N No	No
RACDT_ACK_COMMENTS	_varchar_255	varchar(255)	Yes	This field holds the Comments for the Repair Order Acknowledgement	No
RACDT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the USer Who has created the Repair Order Number.	No
RACDT_CREATED_DATE	_datetime_8	datetime(8)	No	This field hodls the Date on which the Repair Order Number was Created.	No
RACDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
RACDT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Last Date on which the Repair Order Number got Modified.	No

Table Name :	REP_RACPMD_COMP_PARAM_DTL
Comment :	This tableis to hold life Parameter Details for the Repair Order -Amendment Numbers .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RACPMD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RACPMD_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair ORder number for amended repair order documents	Yes
RACPMD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the Repair Order Amendment no for amended repair order documents	Yes
RACPMD_PARAM_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the uniquely generated param line id for amended repair order documents	Yes
RACPMD_AC_PARAM_CODE	_varchar_40	varchar(40)	No	This field holds the Aircraft Parameter Code for amended repair order documents	No
RACPMD_UOM	_varchar_10	varchar(10)	Yes	This field holds the Parameter UOM Unit of measurement for amended repair order documents	No
RACPMD_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	This field holds the Since New Parameter value for amended repair order documents	No
RACPMD_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	This field holds the Since Overhaul Parameter value for amended repair order documents	No
RACPMD_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	This field holds the Since Repair Parameter value for amended repair order documents	No
RACPMD_SINCE_SHOP_VISIT	_decimal_28_8	decimal(28)	Yes	This field hodls the Since Shop Visit Parameter value for amended repair order documents	No
RACPMD_SINCE_INSPECT	_decimal_28_8	decimal(28)	Yes	This field holds the Since Inspect parameter value for amended repair order documents	No
RACPMD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record for amended repair order documents	No
RACPMD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Created Date of the record for amended repair order documents	No
RACPMD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record. for amended repair order documents	No
RACPMD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the date onwhich the record is modified for amended repair order documents	No

Table Name :	REP_RADD_DISCREPANCY_DTL
Comment :	This field is to hold the discrepancy Details for the Repair Order -Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RADD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RADD_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair Order number for amended repair order documents	Yes
RADD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field is to hold the Amendment Number of Repair Order for amended repair order documents	Yes
RADD_RO_DISCY_NO	_varchar_40	varchar(40)	No	This field is to hold the Discrepancy Number of repair order for amended repair order documents	Yes
RADD_RO_DISCY	_varchar_5	varchar(5)	No	This fieldis tohold the Discrepancies Reported Allowed values are FC Fully Confirmed PC Partially Confirmed NF No Fault Found for amended repair order documents	No
RADD_RO_DISCY_COMMENTS	_varchar_255	varchar(255)	Yes	This field is to hold the Discrepancy Comments for amended repair order documents	No
RADD_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold the User who created the Discrepancy info for amended repair order documents	No
RADD_CREATED_DATE	_datetime_8	datetime(8)	No	This field is to hold the Date on which the Discrepancy was created for amended repair order documents	No
RADD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is to hold the User who Modified the Discrepancy info. for amended repair order documents	No
RADD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the date on which the record gets modified for amended repair order documents	No
RADD_RO_DISC_DESC	_varchar_255	varchar(255)	Yes	This field holds the Discrepancy Description	No
RADD_RO_DEF_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Mode of Attach Flag which Identifies if the discrepancy is added manually or defaulted from the Component Replacement component D Defaulted M Manual	No
RADD_RO_ATANO	_varchar_30	varchar(30)	Yes	Air Tansport association Number	No
RADD_RO_MAINTREP	_varchar_255	varchar(255)	Yes	This field holds the number identifying the maintenance report corresponding to the discrepancy	No
RADD_RO_PARTNO	udd_partno	varchar(40)	Yes	This Field stores the part no details.	No
RADD_RO_SERIALNO	udd_partserialnumber	varchar(40)	Yes	This Field stores the serial no details of the part.	No

Table Name :	REP_RADOT_DOC_TCD_DTL
Comment :	This field is tohold the Document Tcd Details for the Repair Order /Amendment Number

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RADOT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RADOT_RO_NO	_varchar_40	varchar(40)	No	This field holds the Repair Order Document number for amended repair order documents	Yes
RADOT_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the Amendment Number For The Repair Order	Yes
RADOT_TCD_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the TCD line id for amended repair order documents	Yes
RADOT_TCD_OU	_decimal_10_0	decimal(10)	No	This field holds the Tcd Ouinstance in which the Tcd got Created. for amended repair order documents	No
RADOT_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Tcd Code from TCD component for amended repair order documents	No
RADOT_TCD_VARIANT_CODE	_varchar_25	Varchar(25)	No	This field holds the Tcd variant Code from TCD component for amended repair order documents	No
RADOT_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd rate from TCD component for amended repair order documents	No
RADOT_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds the Calculated Tcd Amount from Tcd Master. for amended repair order documents	No
RADOT_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field holds the pay to supplier number for amended repair order documents	No
RADOT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record for amended repair order documents	No
RADOT_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the created date of the record for amended repair order documents	No
RADOT_MODIFIED_BY	_varchar_30	varchar(30)	No	The user who has last modified the Tcd details. for amended repair order documents	No
RADOT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holdsThe Last Date on which the Repair Order Got Modified. for amended repair order documents	No
RADOT_TCD_PAYMT_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Payment Currency	No
RADOT_USER_SEQ	_decimal_10_0	decimal(10)	Yes	User sequnce number	No
RADOT_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RADOT_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RADOT_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RADOT_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RADOT_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RADOT_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RADOT_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RADOT_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RADOT_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No

Table Name :	REP_RALTD_LABOUR_TCD_DTL
Comment :	This field is to hold the Labour Tcd Details for the Repair Order-Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RALTD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RALTD_RO_NO	_varchar_40	varchar(40)	No	This field is tohold the Repair Order numbers for amended repair order documents	Yes
RALTD_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to hold the Quotation Id of Repair Order. for amended repair order documents	Yes
RALTD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field is tohold the Amendment Number of the Repair Order. for amended repair order documents	Yes
RALTD_TCD_OU	_decimal_10_0	decimal(10)	No	This field is to capture the Tcd Ouinstance for amended repair order documents	No
RALTD_TCD_CODE	_varchar_25	Varchar(25)	No	This field is tocapture the Tcd Code from TCD component for amended repair order documents	No
RALTD_TCD_VARIANT_CODE	_varchar_25	Varchar(25)	No	this field is tocapture the TCD variant code from the repair order for amended repair order documents	No
RALTD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field is to capture the Tcd Rate of TCD component for amended repair order documents	No
RALTD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field is to capture the TCD amount of repair order for amended repair order documents	No
RALTD_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field isto capture the pay to supplier of repair order for amended repair order documents	No
RALTD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record for amended repair order documents	No
RALTD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the date on which the record gets created for amended repair order documents	No
RALTD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record for amended repair order documents	No
RALTD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Last Date on which the record got Modified. for amended repair order documents	No
RALTD_TCD_PAYMT_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Payment Currency	No
RALTD_USER_SEQ	_decimal_10_0	decimal(10)	Yes	Sequnce number for internal usage	No
RALTD_EXCHG_RATE	_decimal_28_8	decimal(28)	No	Holds the exchage rate between the document currency and the payment currency	No
RALTD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RALTD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RALTD_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RALTD_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RALTD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RALTD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RALTD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RALTD_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No

Table Name :	REP_RAMCDT_MATL_COST_DTL
Comment :	Material cost Detail for the Repair Order /Amendment no

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAMCDT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RAMCDT_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number for amended repair order documents	Yes
RAMCDT_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This fieldisto capture the repir order Amendment Number for amended repair order documents	Yes
RAMCDT_MATL_LINE_ID	_decimal_10_0	decimal(10)	No	This field is to capture Material Line Id for the Parts. for amended repair order documents	Yes
RAMCDT_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the Quotation Id for the Repair Order Number for amended repair order documents	Yes
RAMCDT_MANUF_PART_NO	_varchar_40	varchar(40)	No	This field is to capture the manufacturer Part Number for amended repair order documents	No
RAMCDT_MATL_LINE_NO	_varchar_30	varchar(30)	No	This field isto capture the Material Line Id for the Parts. for amended repair order documents	No
RAMCDT_PART_DESC	_varchar_80	varchar(80)	Yes	Thisfield is to capture the Part Description for the Parts for amended repair order documents	No
RAMCDT_PART_QTY	_decimal_28_8	decimal(28)	No	This field is to capture the Part Quantity for amended repair order documents	No
RAMCDT_PART_UOM	_varchar_10	varchar(10)	Yes	This field is to capture the Part UOM for amended repair order documents	No
RAMCDT_PART_UNIT_RATE	_decimal_28_8	decimal(28)	Yes	Thsi field isto capture the Unit Rate for the Parts for amended repair order documents	No
RAMCDT_TOTAL_TCD_COST	_decimal_28_8	decimal(28)	Yes	Thisfield is to capture The Total Tcd Cost Calculated for The Tcds. for amended repair order documents	No
RAMCDT_CREATED_BY	_varchar_30	varchar(30)	No	This field is to capture the User who has Created the Material cost info for amended repair order documents	No
RAMCDT_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Material cost info got Created for amended repair order documents	No
RAMCDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the Last User who has Modified the Repair Order. for amended repair order documents	No
RAMCDT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the modified date on which the Repair Order Number got Modified. for amended repair order documents	No

Table Name :	REP_RAMTCD_MAT_TCD_DTL
Comment :	This field is to hold the Material Tcd Details for Each Material of the Repair Order - Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAMTCD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RAMTCD_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number for amended repair order documents	Yes
RAMTCD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field is to capture the Amendment Number of the Repair Order for amended repair order documents	Yes
RAMTCD_MATL_LINE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the Material Line Id for the repair Parts for amended repair order documents	Yes
RAMTCD_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the Quotation Id of the Repair Order Number. for amended repair order documents	Yes
RAMTCD_TCD_LINE_ID	_decimal_10_0	decimal(10)	No	This field is to hold the TCD line id for amended repair order documents	Yes
RAMTCD_TCD_OU	_decimal_10_0	decimal(10)	No	This field is to hold the Tcd OuInstance in which the Tcd code was Created for amended repair order documents	No
RAMTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Tcd Code from tcd Component. for amended repair order documents	No
RAMTCD_TCD_VARIANT_CODE	_varchar_25	Varchar(25)	No	This field holds the Tcd Variant Code from Tcd Component for amended repair order documents	No
RAMTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd Rate from TCD component for amended repair order documents	No
RAMTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd Amount calculated from Tcd Component. for amended repair order documents	No
RAMTCD_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field holds the pay to supplier no of repair order for amended repair order documents	No
RAMTCD_CREATED_BY	_varchar_30	varchar(30)	No	THis field holds the user who created the record for amended repair order documents	No
RAMTCD_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date on which the Repair Order Number was Created. for amended repair order documents	No
RAMTCD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the User who Modified the Repair Order for amended repair order documents	No
RAMTCD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the date onwhich the record got modified for amended repair order documents	No
RAMTCD_TCD_PAYMT_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Payment Currency	No
RAMTCD_USER_SEQ	_decimal_10_0	decimal(10)	Yes	Sequnce number	No
RAMTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RAMTCD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RAMTCD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RAMTCD_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RAMTCD_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RAMTCD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RAMTCD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RAMTCD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RAMTCD_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No

Table Name :	Rep_RAPrt_PiecePart_Dtl
Comment :	This table is to hold Piece part information for the Repair Order -Amendment Numbers .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAPrt_RO_Amend_No	_decimal_10_0	decimal(10)	No	Thisfield is to capture the Amendment Number for the Repair order document	Yes
RAPrt_Line_no	udd_linenum	varchar(30)	No	THis field is to capture the part line no	Yes
ROPrt_Part_Cr_OU	udd_ctxt_ouinstance	int(4)	Yes	This field holds the Part Created OU with which the repair order component is interacting	No
RAPrt_Part_No	udd_partno	varchar(40)	Yes	This field holds the repair order piece part number	No
RAPrt_Quantity	udd_quantity	numeric(13)	No	This field holds the piece part quantity	No
RAPrt_Serial_No	udd_partserialnumber	varchar(40)	Yes	This field holds the repair order piece part serial number	No
RAPrt_Lot_No	udd_lotno	varchar(18)	Yes	This field holds the repair order piece part lot number	No
RAPrt_Stock_Status	udd_status	varchar(25)	No	This field holds the piece part stock status	No
RAPrt_Cost	udd_purcost	numeric(13)	Yes	This field holds the cost of the piece part	No
RAPrt_Work_Request	udd_txt255	varchar(255)	Yes	This field holds the work requested for the piece part	No
RAPrt_Remarks	udd_txt255	varchar(255)	Yes	This field holds the remarks	No
RAPrt_BER_Qty	udd_quantity	numeric(13)	Yes	This column holds the value BER Quantity, which is defined in record quation	No
RAPrt_Rec_Qty	udd_quantity	numeric(13)	Yes	This column holds the value of received quantity of this line, which defined in Repair reciept	No
RAPrt_Line_status	udd_designparamcode	varchar(5)	Yes	This column holds the line level status of the each part no no values CL closed OP open BC BER closed	No
RAPrt_GR_Rec_Partno	udd_partno	varchar(40)	Yes	This field holds the received repair part no of amended repair order documents	No
RAPrt_GR_Rec_Serialno	udd_partserialnumber	varchar(40)	Yes	This field holds the Received Serial number of amended repairorder documents	No
RAPrt_COMPONENT_ID	udd_componentid	varchar(90)	Yes	If part number and serial number is of type component then the component id is stored here	No
RAPrt_ACCOMPONENT_OU	udd_ctxt_ouinstance	int(4)	Yes	If part number and serial number is of type component then the Ou for that component is stored here	No
RAPrt_BER_Cost	udd_quantity	numeric(13)	Yes	This field holds the beyond repair cost of the part.	No
RAPrt_Salvage_Action	udd_designparamcode	varchar(5)	Yes	This field holds the salvage action of the part.	No
RAPrt_Salvage_Value	udd_amount	numeric(13)	Yes	This field holds the salvage value of the part.	No
RAPrt_Pending_Qty	udd_quantity	numeric(13)	Yes	It holds the value of pending quantity	No
RAPrt_RO_Ouinstance	_decimal_10_0	decimal(10)	No	This field holds the part Organisation unit of the part	Yes
RAPrt_RO_No	udd_documentno	varchar(40)	No	This field is to capture the Repair order Number	Yes
RAPRT_COST_DIFF	_numeric_28_8	numeric(28)	Yes	This field hold the cost difference of the part after amendment	No
RAPrt_NRTN_Cost	fin_amount	numeric(13)	Yes	This fields hold the non return cost value	No
RAPrt_BER_INVOICED	udd_designparamcode	varchar(5)	Yes	Persist the column which store BER invoice flag	No
RAPrt_BER_InvQty	udd_quantity	numeric(13)	Yes	Persist the column which store BER invoice qty	No
RAPrt_EXCHANGE_COST	udd_cost	numeric(13)	Yes	This field holds the Exchange cost of the piece part line level during amendment	No
RAPrt_EXCHANGE_DIFF	udd_cost	numeric(13)	Yes	This field holds the Exchange Cost difference of part after amendment	No
RAPrt_EXCHANGE_INVOICED	udd_designparamcode	varchar(5)	Yes	indicate whether invoice has been done for the Exchage part - quantity	No
RAprt_Exchange_InvQty	udd_designparamcode	varchar(5)	Yes	Invoice Quantity for the exchage Part	No
RAPrt_release_ship	udd_flag	varchar(25)	Yes	Indicates whether the parts released for shipping	No
RAPrt_REPAIR_INVOICED	udd_designparamcode	varchar(5)	Yes	indicate whether invoice has been done for the part - quantity	No
RAPrt_Repair_InvQty	udd_quantity	numeric(13)	Yes	Invoice Quantity for the Part	No
RAPrt_SALVAGE_INVOICED	udd_designparamcode	varchar(5)	Yes	Persist the salvage action invoiced status after amendment	No
RAPrt_Salvage_InvQty	udd_quantity	numeric(13)	Yes	Stores the Salvage Invoiced Quantity for the Piece part after amendment	No
RoAprt_Core_id	udd_seqno	int(4)	Yes	This colmn holds the core ID for the RO referenec Document number	No
RoAprt_CR_key_Seqno	udd_seqno	int(4)	Yes	Sequence number for the Core ID	No

Table Name :	REP_RAQUD_QUOTE_DTL
Comment :	This field is to hold the Quotation Details for the Repair Order -Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAQUD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RAQUD_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number	Yes
RAQUD_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the Quote ID Running Serial no for the RO no for amended repair order documents	Yes
RAQUD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	The Amendement Number for the Repair order Running Serial Number for amended repair order documents	Yes
RAQUD_RO_USER_STATUS	_varchar_25	Varchar(25)	Yes	Holds the user entered status for a repair order	No
RAQUD_SUP_CON_DISCREPANCY	_varchar_5	varchar(5)	Yes	This field is to capture the COnfirm Discrepanies confirmed by the Supplier allowed values are FC Fully Confirmed PC Partially Confirmed NF No Fault Found for amended repair order documents	No
RAQUD_SUP_ADD_DISCREPANCY	_varchar_5	varchar(5)	Yes	This field is to capture the Additional Discrepancies Detected Allowed values are Y Yes N No for amended repair order documents	No
RAQUD_SUP_ADD_PROBLEMS	_varchar_255	varchar(255)	Yes	This field is to capture the Additionals Problems Descriptions. for amended repair order documents	No
RAQUD_SUP_COMMENTS	_varchar_255	varchar(255)	Yes	This field is to capture any Comment from the Supplier for amended repair order documents	No
RAQUD_QUOTE_REF_NO	udd_documentno	varchar(40)	Yes	This field is to capture the Quotation Reference number for amended repair order documents	No
RAQUD_QUOTE_TYPE	_varchar_5	varchar(5)	No	This field holds the Quotation Type Allowed values F Firm E Estimate for amended repair order documents	No
RAQUD_QUOTE_DATE	udd_time	datetime(8)	Yes	This field holds the Quotation Date of the Supplier for amended repair order documents	No
RAQUD_QUOTE_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds Quotation Currency of the supplier for amended repair order documents	No
RAQUD_QUOTE_EST_MAN_HRS	_decimal_28_8	decimal(28)	Yes	This field holds the Quoted &Estimated Man Hours for amended repair order documents	No
RAQUD_QUOTE_COST_MAN_HR	_decimal_28_8	decimal(28)	Yes	This field holds the quoted Cost Per Man Hour for amended repair order documents	No
RAQUD_QUOTE_LABOUR_COST	_decimal_28_8	decimal(28)	Yes	Thisfield holds the quotedLabour Cost for amended repair order documents	No
RAQUD_TOTAL_LAB_TCD	_decimal_28_8	decimal(28)	Yes	This field is to hold the Total Labour TCD Cost for amended repair order documents	No
RAQUD_TOTAL_LABOUR_COST	_decimal_28_8	decimal(28)	Yes	This field is to hold the total labour cost Total Labour cost Labour Cost + Total Labour TCD Cost for amended repair order documents	No
RAQUD_QUOTE_MATL_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Material cost sum Material cost for all of the materials used for the Quotation. for amended repair order documents	No
RAQUD_TOTAL_MATL_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Total Material cost Total Material Cost + Total Material TCD Cost for amended repair order documents	No
RAQUD_TOTAL_DOC_TCD	_decimal_28_8	decimal(28)	Yes	This field is to capture the Total Document TCD Cost for amended repair order documents	No
RAQUD_QUOTE_MISC_COST	_decimal_28_8	decimal(28)	Yes	This field is to capture the Quotation Miscellaneous cost for amended repair order documents	No
RAQUD_EXCHANGE_RATE_OU	_decimal_10_0	decimal(10)	Yes	This field is to capture the Exchange Rate OU ESetup Component OU . for amended repair order documents	No
RAQUD_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	This field is to capture Exchange Rate Between the Base currency and the Quotation Suppler Currency for amended repair order documents	No
RAQUD_QUOTE_AMT_HLD_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the Price Held Firm time THe Price valid time from the Quotation date into consideraion for amended repair order documents	No
RAQUD_QUOTE_LD_TIME_UNIT	_varchar_5	varchar(5)	Yes	This field holds the Quotation Lead time unit Allowed values are D Days W Weeks M Months for amended repair order documents	No
RAQUD_BER_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Beyond Repair Analysis Cost for amended repair order documents	No
RAQUD_QUOTE_REMARKS	_varchar_255	varchar(255)	Yes	This field holds Any Remarks entered by the Supplier regarding the Quotation for amended repair order documents	No
RAQUD_SALVAGE_AT	_varchar_5	varchar(5)	Yes	This field holds the Salvage Action IF BER Flag is Yes THen the Salvage Action is Mandatory. Allowed values are BRS By Repair Shop BOP By Operator B Blank for amended repair order documents	No
RAQUD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who entered the QUotation into the system for amended repair order documents	No
RAQUD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the QUotation is entered into the system for amended repair order documents	No
RAQUD_MODIFIED_BY	_varchar_30	varchar(30)	No	Thisfield holds the User who modified the QUotation in the system for amended repair order documents	No
RAQUD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is to hold the Date on which the QUotation is last modified for amended repair order documents	No
RAQUD_QUOT_EXCHANGE_FEE	_decimal_28_8	decimal(28)	Yes	This field holds the Exchange Fee	No
RAQUD_SAL_SALVAGE_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Estimated Scrap value	No
RAQUD_QUOT_TOTALREP_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Total Repair Cost	No
RAQUD_COMP_LIST_PRICE	_decimal_28_8	decimal(28)	Yes	This field holds the Component List Price	No
RAQUD_TOTAL_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Total Cost for the RO no Quote	No
RAQuD_Filename	udd_filename	varchar(50)	Yes	This field holds the File name for RO quotation	No
RAQuD_CUST_QUOTE_NO	udd_documentno	varchar(40)	Yes	This fields hold the history of customer quotation Number	No
RAQuD_CUST_AUTH_STAUS	udd_quickcodes	varchar(25)	Yes	This fields hold the history of customer quotation Authorization status	No
RAQuD_QUOTE_COMMETNS	udd_txt2000	varchar(2000)	Yes	This fields hold the history of customer quotation comments	No
RAQuD_CUST_COMMETNS	udd_txt2000	varchar(2000)	Yes	This fields hold the history of customer comments	No
RAQUD_BER_INVOICED	udd_designparamcode	varchar(5)	Yes	Indicates the BER Quantity got invoiced or not	No
RAQUD_BER_InvQty	udd_quantity	numeric(13)	Yes	this holds the Invoiced - BER Quantity for the Piece part line level	No
RAQUD_EXCHANGE_INVOICED	udd_designparamcode	varchar(5)	Yes	This column used to store the Exchange part invoiced status at quotation stage	No
RAQUD_Exchange_InvQty	udd_quantity	numeric(13)	Yes	This column used to store the Exchange part invoiced Quantity at During record Quote	No
RAQUD_REPAIR_INVOICED	udd_designparamcode	varchar(5)	Yes	Invoice status for the part while record quote	No
RAQUD_Repair_InvQty	udd_quantity	numeric(13)	Yes	Invoice Quantity for the part while record quote	No
RAQUD_SALVAGE_INVOICED	udd_designparamcode	varchar(5)	Yes	this holds the status of invoice for the scrapped part after quotation	No
RAQUD_Salvage_InvQty	udd_quantity	numeric(13)	Yes	This holds the Invoiced quantity for the scrapped part after Quotation	No

Table Name :	REP_RASSD_SPARE_SHIP_DTL
Comment :	This field is to hold the spare Ship Details for the Repair Order-Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RASSD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RASSD_RO_NO	_varchar_40	varchar(40)	No	Thsi fieldis to hold the Repair order number for amended repair order documents	Yes
RASSD_RO_SPARES_ID	_decimal_10_0	decimal(10)	No	This field is tohold the Spares Running Serial Number for amended repair order documents	Yes
RASSD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field is tohold the Amendment Number of the Repair Order Running Serial Number for amended repair order documents	Yes
RASSD_SPARE_PART_CR_OU	_decimal_10_0	decimal(10)	No	This field is to hold Spare Part Created OU of repair order for amended repair order documents	No
RASSD_SPARE_PART_NO	_varchar_40	varchar(40)	No	This field is to hold the Spare Requested Part Number of repair order for amended repair order documents	No
RASSD_SPARE_PART_QTY	_decimal_28_8	decimal(28)	No	This field is to hold the Spare Part Quantity requested in Repair Order UOM for amended repair order documents	No
RASSD_SPARE_PART_UOM	_varchar_10	varchar(10)	No	This field is tohold the Spare part UOM for amended repair order documents	No
RASSD_SPARE_PART_QTY_SUOM	_decimal_28_8	decimal(28)	Yes	This field is to hold the Spare Part Quantity Requested In Stock UOM for amended repair order documents	No
RASSD_SPARE_PART_COND	_varchar_5	varchar(5)	Yes	This field is to hold the Spare Part Condition As of now this field will be empty always for amended repair order documents	No
RASSD_SPARE_STKMNT_OU	_decimal_10_0	decimal(10)	No	This field is to hold the Stock Maintenance OU for amended repair order documents	No
RASSD_SPARE_SDSTKADMIN_OU	_decimal_10_0	decimal(10)	No	This field is to hold the Stock Admin OU interacting with the Stock Maintenance OU for amended repair order documents	No
RASSD_SPARE_SEND_WH_NO	_varchar_10	varchar(10)	No	This field is toholdthe send Warehouse No from where the Spare part has to be issued for amended repair order documents	No
RASSD_SPARE_STKISSUE_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold the stock issue quantity for amended repair order documents	No
RASSD_SPARE_PEND_RET_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold the Pending Quantity which has yet to be returned for amended repair order documents	No
RASSD_SPARE_RET_TYPE	_varchar_5	varchar(5)	No	This field is to holdthe Spares Return Type Allowed values are RT Returnable NR Non Returnable B Blank for amended repair order documents	No
RASSD_SPARE_GR_OU	_decimal_10_0	decimal(10)	Yes	This field is to hold the GR OUInstance which is interacting with repair order for amended repair order documents	No
RSPSD_SPARE_RCSTKADMIN_OU	_decimal_10_0	decimal(10)	Yes	Thsi field is to capture the Stock Admin OU interacting with the GR OU	No
RASSD_SPARE_RET_WH_NO	_varchar_10	varchar(10)	Yes	This field holds the Warehouse Number to which the spares has to be returned for amended repair order documents	No
RASSD_SPARE_RECD_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the Spares Recieved Part no for amended repair order documents	No
RASSD_SPR_STKISS_QTY_SUOM	_decimal_28_8	decimal(28)	Yes	This field holds the Spares Stock Issue Quantity in Stock UOM for amended repair order documents	No
RASSD_SPARE_GR_RECD_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold goods received quantity of spare parts for amended repair order documents	No
RASSD_SPARE_GR_ACCPT_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold goods accepted quantity of spare parts for amended repair order documents	No
RASSD_SPARE_GR_MOVED_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold goods moved quantity of spare parts for amended repair order documents	No
RASSD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record for amended repair order documents	No
RASSD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Spares details is entered into the system for amended repair order documents	No
RASSD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the User who last modified the Spares details of the Repair order document into the sysstem for amended repair order documents	No
RASSD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Spares details got modified for amended repair order documents	No
RASSD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RASSD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RASSD_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RASSD_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RASSD_DEF_FIN_BOOK	_varchar_20	varchar(20)	Yes	stores the default finance book	No
RASSD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RASSD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RASSD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RASSD_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No
RASSD_STOCKSTATUS	udd_partstatus	varchar(40)	Yes	This field corresponds to the stock status of the part.	No
RASSD_RO_release_ship	udd_flag	varchar(25)	Yes	holds whether release for shipping done for the spare parts	No

Table Name :	REP_RATMCN_TERM_COND_INFO
Comment :	This table is to capture the terms and condition details of Repair Order Amendments

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RATMCN_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RATMCN_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair order Number for amended repair order documents	Yes
RATMCN_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field is to hold amendment number of the Repair Order for amended repair order documents	Yes
RTMCN_SUPP_CONTACT_OU	_decimal_10_0	decimal(10)	No	This field is to hold the local interacting OU of the SUpplier with the Repair order for amended repair order documents	No
RATMCN_FWSH_CONTACT	udd_contactperson	varchar(80)	Yes	This field is to hold the Shipping Contact Person of the Supplier for amended repair order documents	No
RATMCN_FWSH_CORE_BY	_varchar_25	Varchar(25)	No	This field is to hold the Shippping Core By list of Shipping Method codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_FWSH_PACKAGE_CODE	_varchar_25	Varchar(25)	No	This field is to hold the Core Packaging Codes list of Core Pack codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_FWSH_SPARES_BY	_varchar_25	Varchar(25)	Yes	This field is to hold the Shippping Spares By list of Shipping Method codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_PAY_TERM	_varchar_25	Varchar(25)	No	This field is to hold the Pay term code defined in the Payterm component for amended repair order documents	No
RATMCN_PAY_MODE	_varchar_5	varchar(5)	Yes	This field is to hold the Pay Mode of the repair order Allowed values are DD Demand Draft CS Cash CQ Cheque P Pay Order O Others for amended repair order documents	No
RATMCN_PAY_PRIORITY	_varchar_5	varchar(5)	Yes	This field is to hold the Pay Priority of repair order Allowed values are H High N Normal L Low for amended repair order documents	No
RATMCN_MATCHING_TYPE	_varchar_5	varchar(5)	Yes	This field is to hold the matching Type of repair order document. 2W Two Way 3WG Three Way at GR 3WR Three Way at RO 4WG Four Way at GR 4WR Four Way at RO for amended repair order documents	No
RATMCN_PAY_TO_SUP_NO	_varchar_45	varchar(45)	No	This field is to hold Pay to Supplier No Supplier No to which payment has to be made for amended repair order documents	No
RATMCN_INSUR_LIABTY	_varchar_5	varchar(5)	Yes	This field is to hold the Insurance Liability of repair order. Allowed values are SL Self SP Supplier NO None for amended repair order documents	No
RATMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field is to hold the remarks of repair order for amended repair order documents	No
RATMCN_CRRT_CORE_BY	_varchar_25	Varchar(25)	No	This field is to hold the Core Return Method list of Shipping Method Codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_CRRT_SHIP_PAYMENT	_varchar_25	Varchar(25)	No	This field is to hold the Core Return Shipping Payment list of Shipping Payment method defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_CRRT_PACKAGE_CODE	_varchar_25	Varchar(25)	No	Thisf ield is to hold the Core return Pack code list of Packaging Codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_CRRT_SPARES_RET	_varchar_5	varchar(5)	Yes	This field is to hold the Spares Return Allowed values WC With Core SP Separate B Blank for amended repair order documents	No
RATMCN_CRRT_CERT_TYPE	_varchar_25	Varchar(25)	Yes	This field is to hold the Certificate type the Certificate types that have been created for Parts in the Logistics Common Master component for amended repair order documents	No
RATMCN_CRRT_INSPECT_TYPE	_varchar_5	varchar(5)	Yes	This field is to hold the Inspection type of repair order. Allowed values are S Self BI By Inspector for amended repair order documents	No
RATMCN_SPRT_SPARES_BY	_varchar_25	Varchar(25)	Yes	This field is to hold the Return Spares By list of Shipping Method codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_SPRT_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This fiield is to hold the Spares Return Shippping Payment list of Shipping Payment Method codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_SPRT_PACKAGE_CODE	_varchar_25	Varchar(25)	Yes	THis field is to hold the Spares Return Pack code list of Packaging Codes defined in the Logistics Common Master component for amended repair order documents	No
RATMCN_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who enters creates the Terms and conditins details of the Repair order document into the sysstem for amended repair order documents	No
RATMCN_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Terms and conditions is entered into the system for amended repair order documents	No
RATMCN_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is to hold the user who modified the record for amended repair order documents	No
RATMCN_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is to hold the date on which the record is modified. for amended repair order documents	No
RATMCN_GTA_REFDOC_NO	_varchar_40	varchar(40)	Yes	This field holds the General Terms Agreement Referece Document no	No
RATMCN_GTA_REFDOC_DATE	_datetime_8	datetime(8)	Yes	This field holds the General Terms Agreement Referece Document Date	No
RATMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks on General Terms Agreement	No
RATMCN_ADVANCE_PAYABLE	_varchar_5	varchar(5)	Yes	This field holds the Advance Payable Y Yes N No	No
RATMCN_ADVANCE_TOL_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the Advance Tolerance Percent	No
RATMCN_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the Advance Pay Date	No
RATMCN_ADVANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the Advance Percentage value	No
RATMCN_ADVANCE_PERC_ON	_varchar_5	varchar(5)	Yes	This field holds the Advance Percent on BV Basic Value TV Total Value B Blank	No
RATMCN_DDCHARGES_BORNEBY	_varchar_5	varchar(5)	Yes	This field holds the DD Charges Borne By value : SF Self RS Repair Shop	No
RATMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the Inco Term	No
RATMCN_CARRIER_AGENCY	_varchar_20	varchar(20)	Yes	Carrier Agency Number in amend Terms and condition	No
RATMCN_PORT_OF_DESTN	_varchar_32	varchar(32)	Yes	This field holds the Port of Destination	No
RATMCN_PORT_OF_DEP	_varchar_32	varchar(32)	Yes	This field holds the Port of Departure	No
RATMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the Packaging notes	No
RATMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the Shipping Notes	No
RATMCN_ADV_PAY_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the Advance Payable amount	No
RATMCN_PAYTOSUP_ADDR_ID	UDD_TXT60	varchar(60)	Yes	This field holds the Pay to Supplier Address Id	No
RATMCN_Unwar	udd_flag1	varchar(25)	Yes	This field store the under warranty value for the parts.	No
RATMCN_Warbasis	udd_flag1	varchar(25)	Yes	This field store the warranty basis value for the parts.	No
RATMCN_WarBegin	udd_designparamcode	varchar(5)	Yes	This field store the warranty begins on value.	No
RATMCN_WarDur	udd_duration	numeric(13)	Yes	This field store the warranty duration value.	No
RATMCN_WarDurUnit	udd_designparamcode	varchar(5)	Yes	This field store the warranty duration units value.	No
RATMCN_War_FH	udd_duration	numeric(13)	Yes	This field will store the Flight Hours values.	No
RATMCN_War_FC	udd_duration	numeric(13)	Yes	This field will store the Flight Cycles values.	No
RATMCN_WarRefAgr	udd_documentno	varchar(40)	Yes	This field will store the warranty reference agreement value.	No
RATMCN_War_TermRef	udd_notes	varchar(2000)	Yes	This field will store the Terms and References value.	No
RATMCN_DELIVERTOCODE	udd_documentno	varchar(40)	Yes	This fields hold the history of delivary code	No
RATMCN_RMA_NO	udd_txt20	varchar(20)	Yes	RMA document no	No
RATMCN_RMA_DATE	udd_time	datetime(8)	Yes	RMA date	No

Table Name :	REP_RCPMDT_COMP_PARAM_DTL
Comment :	This table is to hold the life Parameter Details of the Repair Order .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RCPMDT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RCPMDT_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair ORder number	Yes
RCPMDT_PARAM_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the uniquely generated param line id	Yes
RCPMDT_AC_PARAM_CODE	_varchar_40	varchar(40)	No	This field holds the Aircraft Parameter Code	No
RCPMDT_UOM	_varchar_10	varchar(10)	Yes	This field holds the Parameter UOM Unit of measurement	No
RCPMDT_SINCE_NEW	_decimal_28_8	decimal(28)	Yes	This field holds the Since New Parameter value	No
RCPMDT_SINCE_OVERHAUL	_decimal_28_8	decimal(28)	Yes	This field holds the Since Overhaul Parameter value	No
RCPMDT_SINCE_REPAIR	_decimal_28_8	decimal(28)	Yes	This field holds the Since Repair Parameter value	No
RCPMDT_SINCE_SHOP_VISIT	_decimal_28_8	decimal(28)	Yes	This field hodls the Since Shop Visit Parameter value	No
RCPMDT_SINCE_INSPECT	_decimal_28_8	decimal(28)	Yes	This field holds the Since Inspect parameter value	No
RCPMDT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record	No
RCPMDT_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Created Date of the record	No
RCPMDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record.	No
RCPMDT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the date onwhich the record is modified	No

Table Name :	REP_RDD_DISCREPANCY_DTL
Comment :	This field is to hold the Discrepancy Details for the Repair Order .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RDD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RDD_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair Order Number	Yes
RDD_RO_DISCY_NO	_varchar_50	varchar(50)	No	This field is to hold the Discrepancy Number From BASCR Component Replacement	Yes
RDD_RO_DISCY	_varchar_5	varchar(5)	No	This field is to capture the Discrepancies Reported Values are FC Fully Confirmed PC Partially Confirmed NF No Fault Found	No
RDD_RO_DISCY_COMMENTS	_varchar_255	varchar(255)	Yes	Thisfieldis to hold the Discrepancy Comments	No
RDD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who has created the Discrepancy info.	No
RDD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Discrepancy detail was created.	No
RDD_MODIFIED_BY	_varchar_30	varchar(30)	No	THis field holds the User who modified the Discrepancy info	No
RDD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the last modification has taken place.	No
RDD_RO_DISC_DESC	udd_txt2000	varchar(2000)	Yes	This field holds the Discrepancy Description	No
RDD_RO_DEF_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Mode of Attach Flag which Identifies if the discrepancy is added manually or defaulted from the Component Replacement component D Defaulted M Manual	No
RDD_RO_ATANO	_varchar_30	varchar(30)	Yes	Air Transport association Number in descripency table	No
RDD_RO_MAINTREP	_varchar_255	varchar(255)	Yes	This field holds the number identifying the maintenance report corresponding to the discrepancy.	No
RDD_RO_PARTNO	udd_partno	varchar(40)	Yes	This Field stores the part no details.	No
RDD_RO_SERIALNO	udd_partserialnumber	varchar(40)	Yes	This Field stores the serial no details of the part.	No

Table Name :	REP_RDOT_DOC_TCD_DTL
Comment :	This table is to capture Document Tcd Details for the Repair Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RDOT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RDOT_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order number	Yes
RDOT_TCD_LINE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the uniquely generated TCD line id	Yes
RDOT_TCD_OU	_decimal_10_0	decimal(10)	No	This field is to capture the TCD OUInstance of TCD component which interacts with repair order component	No
RDOT_TCD_CODE	_varchar_25	Varchar(25)	No	This field is to capture the Tcd Code of Tcd Component which interacts with repair order component	No
RDOT_TCD_VARIANT_CODE	_varchar_25	Varchar(25)	No	This field is to capture the Tcd varian Code of Tcd Component which interacts with repair order component	No
RDOT_TCD_RATE	_decimal_28_8	decimal(28)	Yes	Ths field is to capture the Tcd Rate of TCD component.	No
RDOT_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	Ths field is to capture the Tcd calculated amount of TCD component.	No
RDOT_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field is to capture the Pay To Supplier Number	No
RDOT_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created this record	No
RDOT_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the creation date of the record	No
RDOT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
RDOT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the modified date of the record	No
RDOT_TCD_PAYMT_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Payment Currency	No
RDOT_USER_SEQ	_decimal_10_0	decimal(10)	Yes	Sequnce number in Document level TCD	No
RDOT_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RDOT_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RDOT_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RDOT_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RDOT_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RDOT_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RDOT_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RDOT_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RDOT_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No
RDOT_TCD_DIFF	udd_amount	numeric(13)	Yes	This field holds the Tcd Amount Diffrence	No
RDOT_ENTITY	udd_flag	varchar(25)	Yes	this holds the unique identification for the TCD part	No

Table Name :	REP_REPAUI_USER_DEF_INFO
Comment :	This table is to capture the User Defined Details for the Repair Order /Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
REPAUI_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
REPAUI_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number for amended repair order documents	Yes
REPAUI_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	THis field is to capture the Amendment Number of the Repair Order. for amended repair order documents	Yes
REPAUI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field is to capture the User Defined Description for Option 1. for amended repair order documents	No
REPAUI_USER_DEF_OPT1	_varchar_18	varchar(18)	Yes	This field is to capture the User Defined Option1 defined in logistics common master for amended repair order documents	No
REPAUI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field is to hold User Defined Description for Option 2 for amended repair order documents	No
REPAUI_USER_DEF_OPT2	_varchar_18	varchar(18)	Yes	This field is to hold User Defined Option 2. for amended repair order documents	No
REPAUI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field is to hold User Defined Description for Option 3 for amended repair order documents	No
REPAUI_USER_DEF_OPT3	_varchar_18	varchar(18)	Yes	This field is to hold User Defined option 3 for amended repair order documents	No
REPAUI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field is to hold User Defined Description for Option 4 for amended repair order documents	No
REPAUI_USER_DEF_OPT4	_varchar_18	varchar(18)	Yes	This field is to hold User Defined Option 4 for amended repair order documents	No
REPAUI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field is to hold User Defined Remarks for amended repair order documents	No
REPAUI_CREATED_DATE	_datetime_8	datetime(8)	No	This field is to hold the Date on which the User Detail was created for the Repair Order no for amended repair order documents	No
REPAUI_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold the User who has created the User Defined Details. for amended repair order documents	No
REPAUI_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field is to hold the Last Date on which the user Defined Detail was Modified. for amended repair order documents	No
REPAUI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to hold the User who has modified the User Defined Details for amended repair order documents	No

Table Name :	REP_REPPRM_PARAMETER_DTL
Comment :	This table is to hold Parameter Details for the Repair Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
REPPRM_COMPONENTNAME	_varchar_20	varchar(20)	No	This field holds the Name of the component.	Yes
REPPRM_PARAMCATEGORY	_varchar_10	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
REPPRM_PARAMTYPE	_varchar_25	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
REPPRM_PARAMCODE	_varchar_5	varchar(5)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes
REPPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
REPPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
REPPRM_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No
REPPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No

Table Name :	REP_REPSC_SUP_CORR_DETAILS
Comment :	This table holds supplier correspondence details for a RO document subsequent to the authorization of the RO and the document is received by the repair agency

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
REPSC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
REPSC_RO_NO	_varchar_40	varchar(40)	No	This field holds the repair order document number.	Yes
REPSC_LINE_NO	_decimal_10_0	decimal(10)	No	Holds the line no for all correspondence detail	Yes
REPSC_AMEND_NO	_decimal_10_0	decimal(10)	No	stores the amendment number of the repair order	Yes
REPSC_DATE	_datetime_8	datetime(8)	Yes	stores the date on which the repair agency comment or buyer comment is recorded	No
REPSC_SUPP_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks sent by the repair agency	No
REPSC_BUYER_REMARKS	_varchar_255	varchar(255)	Yes	stores the remarks entered by buyer	No
REPSC_CREATEDDATE	_datetime_8	datetime(8)	Yes	stores the created date	No
REPSC_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user name who created the record	No
REPSC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	stores the modified date	No
REPSC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user name who modified the record	No

Table Name :	REP_REPUI_USER_DEF_INFO
Comment :	User Defined Details for the Repair Order .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
REPUI_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
REPUI_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order number	Yes
REPUI_USER_DEF_DESC1	_varchar_30	varchar(30)	Yes	This field is to capture the User Defined Description for Option1	No
REPUI_USER_DEF_OPT1	_varchar_18	varchar(18)	Yes	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 1 and also blank	No
REPUI_USER_DEF_DESC2	_varchar_30	varchar(30)	Yes	This field is to capture the User Defined Description for Option2	No
REPUI_USER_DEF_OPT2	_varchar_18	varchar(18)	Yes	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 2 and also blank	No
REPUI_USER_DEF_DESC3	_varchar_30	varchar(30)	Yes	This field is to capture the User Defined Description for Option3	No
REPUI_USER_DEF_OPT3	_varchar_18	varchar(18)	Yes	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 3 and also blank	No
REPUI_USER_DEF_DESC4	_varchar_30	varchar(30)	Yes	This field is to capture the User Defined Description for Option4	No
REPUI_USER_DEF_OPT4	_varchar_18	varchar(18)	Yes	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 4 and also blank	No
REPUI_USER_DEF_REMARKS	_varchar_255	varchar(255)	Yes	This field is to capture the User Defined Remarks	No
REPUI_CREATED_DATE	_datetime_8	datetime(8)	No	Ths field is to hold The Date on which the User Defined Info was Created.	No
REPUI_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record	No
REPUI_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Ths field is to hold The Date on which the User Defined Info was modified.	No
REPUI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field to hold the user who modified the record	No

Table Name :	REP_RLBTD_LABOUR_TCD_DTL
Comment :	This table is to hold Labout Tcd Details of the Repair Order .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RLBTD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RLBTD_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number	Yes
RLBTD_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the Quotation Id of the Repair Order Number	Yes
RLBTD_TCD_OU	_decimal_10_0	decimal(10)	No	This field is to capture the TCd OUInstance	No
RLBTD_TCD_CODE	_varchar_25	Varchar(25)	No	This field is to capture The TCd Code From the Tcd Component	No
RLBTD_TCD_VARIANT_CODE	_varchar_25	Varchar(25)	No	This field is to capture The Tcd Variant Code from the Tcd Component	No
RLBTD_TCD_LINE_ID	_decimal_28_8	decimal(28)	No	This field is to capture Tcd lineid which has been created for the Repair Order no.	Yes
RLBTD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd Rate For the Tcd component.	No
RLBTD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds theTcd Amount which has been calculated	No
RLBTD_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field holds The pay to Supplier Number	No
RLBTD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who has created the Labour Tcd Details.	No
RLBTD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Labour Tcd was Created	No
RLBTD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field hold the Last User Who Modified the Labour Tcd Details.	No
RLBTD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Last Date on which the Labour Tcd got Modified.	No
RLBTD_TCD_PAYMT_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Payment Currency	No
RLBTD_USER_SEQ	_decimal_10_0	decimal(10)	Yes	Sequnce number in Labour TCD	No
RLBTD_EXCHG_RATE	_decimal_28_8	decimal(28)	No	Holds the exchage rate between the document currency and the payment currency	No
RLBTD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RLBTD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RLBTD_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RLBTD_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RLBTD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RLBTD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RLBTD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RLBTD_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No

Table Name :	REP_RMCDT_MATL_COST_DTL
Comment :	This table is to hold Material Cost Details for the QUotation of the Repair Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RMCDT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RMCDT_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair Order Number	Yes
RMCDT_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to hold the Quotation Id of the REpair Order Number	Yes
RMCDT_MATL_LINE_ID	_decimal_10_0	decimal(10)	No	This field is to hold the Material Line Id for the Parts which are created for repair orders.	Yes
RMCDT_MATL_LINE_NO	_varchar_30	varchar(30)	No	This column is to hold the Material Line Id for the Parts which are created for the repair order	No
RMCDT_MANUF_PART_NO	_varchar_40	varchar(40)	No	This column is to hold the Manufacturer PartNumber of repair order	No
RMCDT_PART_DESC	_varchar_80	varchar(80)	Yes	This column is to hold Part Description of repair parts for the repair order document	No
RMCDT_PART_QTY	_decimal_28_8	decimal(28)	No	This column is to hold Part quantity of repair parts for the repair order document	No
RMCDT_PART_UOM	_varchar_10	varchar(10)	Yes	This column is to hold Part UOM of repair parts for the repair order document	No
RMCDT_PART_UNIT_RATE	_decimal_28_8	decimal(28)	Yes	This column is to hold unit rate of repair parts for the repair order document	No
RMCDT_TOTAL_TCD_COST	_decimal_28_8	decimal(28)	Yes	This column is to hold Total Tcd Value applicable for the material line id of repair orders	No
RMCDT_CREATED_BY	_varchar_30	varchar(30)	No	This table holds the user who created the record	No
RMCDT_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the date on which the Material info was Created.	No
RMCDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who has last modified the Material cost info.	No
RMCDT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Material cost got Modified.	No

Table Name :	REP_RMTCD_MAT_TCD_DTL
Comment :	This field holds the Material Tcd Details for the Materials of the Quotation of the Repair Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RMTCD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RMTCD_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number	Yes
RMTCD_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to capture the Quotation Id for the Repair Order Number.	Yes
RMTCD_MATL_LINE_ID	_decimal_10_0	decimal(10)	No	This field is to hold the Material Line Id of the QUotation Number	Yes
RMTCD_TCD_LINE_ID	_decimal_10_0	decimal(10)	No	This field holds the uniquely generated TCD line id	Yes
RMTCD_TCD_OU	_decimal_10_0	decimal(10)	No	This field holds the Tcd Ouinstance in which the Tcd was created FROM TCD Component	No
RMTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the Tcd Code from Tcd Component	No
RMTCD_TCD_VARIANT_CODE	_varchar_25	Varchar(25)	No	This field holds the Tcd Variant Code from Tcd Component	No
RMTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd Rate from Tcd Component	No
RMTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds the Tcd Calculated Amount from Tcd Component.	No
RMTCD_PAY_TO_SUPPLIER_NO	_varchar_45	varchar(45)	Yes	This field holds the Supplier No to whom payment has to be made	No
RMTCD_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold The User Who has created the Material Tcd Info.	No
RMTCD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds The Date on which the Material Tcd info was created.	No
RMTCD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
RMTCD_MODIFIED_DATE	_datetime_8	datetime(8)	No	Thisfield holds the date on which itis modified	No
RMTCD_TCD_PAYMT_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Payment Currency	No
RMTCD_USER_SEQ	_decimal_10_0	decimal(10)	Yes	Sequnce number in MAT TCD	No
RMTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	Holds the exchage rate between the document currency and the payment currency	No
RMTCD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RMTCD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RMTCD_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RMTCD_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RMTCD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RMTCD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RMTCD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RMTCD_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No

Table Name :	REP_ROAH_REPAIR_ORDER_HDR
Comment :	This field is to hold Repair Order-Amendment history Header Info

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ROAH_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the amended repair orders OUInstance	Yes
ROAH_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the amended Repair order Documents	Yes
ROAH_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	Thisfield is to capture the Amendment Number for the Repair order document	Yes
ROAH_RO_TYPE	_varchar_5	varchar(5)	No	This field is to hold The Repair order type for amended repair orders Values are NM Normal EX Exchange	No
ROAH_RO_REMARKS	_varchar_255	varchar(255)	Yes	This field is to hold any Remarks entered for the amended Repair order documents	No
ROAH_SUPPLIER_OU	_decimal_10_0	decimal(10)	No	This field is to capture the Repair shop Supplier Created OU For Amendment.	No
ROAH_REPAIR_SHOP_NO	_varchar_45	varchar(45)	No	This field is to capture the supplier no marked as repair agency for amended repair orders	No
ROAH_REPAIR_SHOP_CONPER	_varchar_80	varchar(80)	Yes	This field is to capture the contact person of supplier marked as repair agency for amended repair orders	No
ROAH_RO_PRIORITY	_varchar_20	varchar(20)	Yes	This field holds the priority populated From Logistics Common Master for amended repair order	No
ROAH_RO_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Aircraft Registration Number Created OU Only if "For Aircraft Reg no" exists for amended repair order documents	No
ROAH_RO_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	This field is to hold the Aircraft Registration Number Mandatory Only if Priority = AOG for amended repair order documents	No
ROAH_RO_REQ_REPAIR_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the Requested Repair time THe time that should be taken for repair NOt mandatory . for amended repair order documents	No
ROAH_RO_LEAD_TIME_UNITS	_varchar_5	varchar(5)	Yes	This field holds the Requested Repair time units. Allowed values are D Days W Weeks M Months B Blank for amended repair order documents	No
ROAH_RO_MATL_RET_AUTH_NO	_varchar_40	varchar(40)	Yes	This field holds the Material Return Authority Number which is mandatory if BER Flag is YES AND Salvage Action is By Operator for amended repair order documents	No
ROAH_RO_SPEC_SHIP_DATE	_datetime_8	datetime(8)	No	This field holds the Specified Shipping Date If Requested Repair Time is entered Then it should be greater than the Requested repair time for amended repair order documents	No
ROAH_RO_SHIP_DATE_CTRL	_varchar_5	varchar(5)	Yes	This field holds the Shipping Date Control. Allowed values are Y Yes N No B Blank for amended repair order documents	No
ROAH_RO_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the Quickcodes of type category defined in the Logistics Common Master for the RO Document for amended repair order documents	No
ROAH_RO_USER_STATUS	_varchar_25	Varchar(25)	Yes	Thisfield holds the Quickcodes of type User status defined in the Logistics Common Master for the RO Document for amended repair order documents	No
ROAH_RO_RETURN_TO_OU	_decimal_10_0	decimal(10)	Yes	This field holds the GR OU IN which the core part will be recieved for amended repair order documents	No
ROAH_RO_STKADMN_OU	_decimal_10_0	decimal(10)	Yes	This field holdsTHe Warehouse OU Stock Admin OU of the Warehouse in which the goods will be stored after Return. for amended repair order documents	No
ROAH_RO_WH_NO	_varchar_10	varchar(10)	Yes	This field holds the Warehouse Number in which the good s will be stored after Return. for amended repair order documents	No
ROAH_RO_CORE_RETURN_OPT	_varchar_5	varchar(5)	No	This field is to hold the Core Return Option Allowed values are P P/N Change Allowed PS P/N and S/N change allowed S S/N change allowed N No change allowed for amended repair order documents	No
ROAH_RO_SPARES	_varchar_5	varchar(5)	No	This field holds the Spares Shipped Allowed values are 1.SH Shipped 2.NSH Not Shipped for amended repair order documents	No
ROAH_RO_BUYER_GROUP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Buyer Group OUInstance of the Buyer Group to which the Login User Belongs to for amended repair order documents	No
ROAH_RO_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field holds the Buyer Group to which the Login User Belongs to for amended repair order documents	No
ROAH_RO_CMPLAN_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Component Maintenance Planning OU with which repair order component is interacting for amended repair order documents	No
ROAH_RO_PART_CR_OU	_decimal_10_0	decimal(10)	Yes	This field is to capture the RO Part Created OUInstance. for amended repair order documents	No
ROAH_RO_PART_NO	_varchar_40	varchar(40)	No	This field is to capture the repair order Partno for amended repair order documents	No
ROAH_RO_SERIAL_NO	_varchar_40	varchar(40)	No	This field is to capture the Serial No for amended repair order documents	No
ROAH_RO_ACCOMPONENT_OU	_decimal_10_0	decimal(10)	No	This field is to capture the Component Id Created Aircraft OU with which repair order component isinteracting for amended repair order documents	No
ROAH_RO_COMPONENT_ID	_varchar_90	varchar(90)	No	This field is to capture the Component Id for which the Repair order Document is created for amended repair order documents	No
ROAH_RO_COMP_REPLACE_OU	_decimal_10_0	decimal(10)	Yes	This field is to capture the Component Replacement OU with which repair order component is interacting for amended repair order documents	No
ROAH_RO_COMP_REPLACE_NO	_varchar_40	varchar(40)	Yes	This field is to capture the Component Replacement Number of repair order document for amended repair order documents	No
ROAH_RO_PART_OWNED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the Owner Code airline operator codes defined in the Common Master component for amended repair order documents	No
ROAH_RO_UNDER_WARRANTY	_varchar_5	varchar(5)	Yes	This field is to capture the Under Warranty Status Allowed values are Y Yes N No B Blank for amended repair order documents	No
ROAH_RO_WARR_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Warranty OUInstance with which repair order component is interacting for amended repair order documents	No
ROAH_RO_WARR_OEM_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty Number of OEM Type if exists for amended repair order documents	No
ROAH_RO_WARR_NEW_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty Number of New Type if exists for amended repair order documents	No
ROAH_RO_WARR_OVERHAUL_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty Number of Overhaul Type if exists for amended repair order documents	No
ROAH_RO_WARR_REPAIR_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty Number of Repair Type if exists for amended repair order documents	No
ROAH_RO_WARR_OEM_FLG	_varchar_5	varchar(5)	Yes	This field holds the Warranty type OE OEM Type for amended repair order documents	No
ROAH_RO_WARR_NEW_FLG	_varchar_5	varchar(5)	Yes	This field holds the Warranty type NE NEW Type for amended repair order documents	No
ROAH_RO_WARR_OVERHAUL_FLG	_varchar_5	varchar(5)	Yes	This field holds the Warranty type OV Overhaul Type for amended repair order documents	No
ROAH_RO_WARR_REPAIR_FLG	_varchar_5	varchar(5)	Yes	Thsi field holds the Warranty type RE Repair Type for amended repair order documents	No
ROAH_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	This field holds the final authorizer to authorize the document for amended repair order documents	No
ROAH_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field holds the Minimum document Value of this Route for amended repair order documents	No
ROAH_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field holds tHe Maximum document value of the ROute for amended repair order documents	No
ROAH_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field holds The Next Level code or PC to authorize the document for amended repair order documents	No
ROAH_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Authorizer type LEVEL code or PC for amended repair order documents	No
ROAH_AUTH_STAGE	_varchar_25	Varchar(25)	Yes	This field holds THe Authorizer stages if the Document is in "Under AUthorization U status for amended repair order documents	No
ROAH_RO_STATUS	_varchar_15	varchar(15)	No	This field holds the Status of the Document. Allowed values are D Draft F Fresh RL Released ACK Acknowledged Q Quoted CF Confirmed U Under Authorization AU Authorized AM Amended CN Cancel	No
ROAH_RO_CORE_RET_FLG	_varchar_5	varchar(5)	Yes	This field holds THe Core Returned Flag If the Issue Component has returned the Core Component Allowed values Y Yes N No for amended repair order documents	No
ROAH_CORE_ISSUED_FLAG	_varchar_5	varchar(5)	Yes	This field holds thee Core Issued Flag If the Issue Compoennt has issued the Core Component Allowed values Y Yes N No for amended repair order documents	No
ROAH_GR_RECD_PART_NO	_varchar_40	varchar(40)	Yes	Thsi field holds the received repair part no of amended repair order documents for amended repair order documents	No
ROAH_GR_RECD_SL_NO	_varchar_30	varchar(30)	Yes	This field holds the Received Serial number of amended repairorder documents for amended repair order documents	No
ROAH_GR_RECD_FLAG	_varchar_5	varchar(5)	Yes	This field holds the GR Recieved Flag A Accepted If the Core has been returned from the supplier. for amended repair order documents	No
ROAH_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record for amended repair order documents	No
ROAH_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the created date of the record for amended repair order documents	No
ROAH_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record for amended repair order documents	No
ROAH_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Modified date of the record for amended repair order documents	No
ROAH_RELEASED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Released date of the record for amended repair order documents	No
ROAH_RELEASED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who Released the document for amended repair order documents	No
ROAH_AUTHORISED_DATE	_datetime_8	datetime(8)	Yes	Thisfield holds the Authorized date of the document for amended repair order documents	No
ROAH_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who authorised the document for amended repair order documents	No
ROAH_CONFIRMED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Confirmed Date of the record for amended repair order documents	No
ROAH_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	The field holds the User who Confirmed the document for amended repair order documents	No
ROAH_AMENDED_DATE	_datetime_8	datetime(8)	Yes	This field holds the AMended Date of the record for amended repair order documents	No
ROAH_AMENDED_BY	_varchar_30	varchar(30)	Yes	This field holds theuser whoamended the record for amended repair order documents	No
ROAH_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the Timestamp value for amended repair order documents	No
ROAH_RO_EXCHG_TYPE	_varchar_5	varchar(5)	Yes	Holds the Exchange type : F Flat R Repair B Blank	No
ROAH_RO_CR_REASON	_varchar_20	varchar(20)	Yes	Component Removal reason	No
ROAH_RO_REASON_FOR_REM	_varchar_255	varchar(255)	Yes	Reason for removal	No
ROAH_RO_DISP_WARR_TYPE	_varchar_5	varchar(5)	Yes	This field holds the warranty type of the warranty no with highest priority that has to be displayed .	No
ROAH_RO_WARR_CLAIM	_varchar_40	varchar(40)	Yes	Warranty Claim Number	No
ROAH_RO_WARR_CLAIM_DATE	_datetime_8	datetime(8)	Yes	warranty claim date	No
ROAH_RO_WARR_CLAIM_ON	_varchar_5	varchar(5)	Yes	warranty claim on : F Full P Partial M Material L Labour O Others B Blank	No
ROAH_RO_SUP_AGMNT_REF	_varchar_40	varchar(40)	Yes	Supplier Agreement Reference number	No
ROAH_RO_SUPP_WARR_REF	_varchar_40	varchar(40)	Yes	Supplier Warranty Reference Number	No
ROAH_RO_WARR_NOTES	_varchar_2000	varchar(2000)	Yes	Warranty notes	No
ROAH_RO_WARR_REASON	_varchar_2000	varchar(2000)	Yes	Warranty Reason	No
ROAH_CLAIM_ACCPT_ON	_varchar_5	varchar(5)	Yes	Claim Accepted on F Full P Partial M Material L Labour O Others B Blank	No
ROAH_CLAIM_ACCPT_STATUS	_varchar_5	varchar(5)	Yes	Claim Acceptance Status FA Fully Accepted PA Partially Accepted RJ Rejected	No
ROAH_RO_STKFROM_OU	_decimal_10_0	decimal(10)	Yes	Stock Admin OU Warehouse OU Where the Core component is stored	No
ROAH_RO_STKFROM_WH	_varchar_10	varchar(10)	Yes	Warehouse no Where the Core component is stored .	No
ROAH_RO_REASON	_varchar_2000	varchar(2000)	Yes	Holds the reason for actions taken cancellation/authorization against RO.	No
ROAH_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
ROAH_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
ROAH_DEF_FIN_BOOK	_varchar_20	varchar(20)	Yes	stores the default finance book	No
ROAH_COMPANY_CODE	_varchar_32	varchar(32)	Yes	stores the company code	No
ROAH_BUSINESS_UNIT	_varchar_32	varchar(32)	Yes	stores the business unit	No
ROAH_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
ROAH_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
ROAH_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
ROAH_RO_CMPID_OWNSHP	_varchar_5	varchar(5)	Yes	stores the component id ownership status whenever the repair order is BER closed.	No
ROAH_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the document key for work flow purpose	No
ROAH_RO_NUM_TYP_NO	_varchar_5	varchar(5)	Yes	stores the numbering type no of repair order	No
ROAH_RO_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	OU Instance of Reference Document Number	No
ROAH_RO_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number like CWO number	No
ROAH_RO_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Reference Document Type like CWO etc.	No
ROAH_RO_WORK_CENTER_OU	_decimal_10_0	decimal(10)	Yes	Work Center OU	No
ROAH_RO_WORK_CENTER	_varchar_30	varchar(30)	Yes	Work Center	No
ROAH_RO_LOT_NO	_varchar_18	varchar(18)	Yes	Lot Number	No
ROAH_SCRAAC_TYPE	_varchar_5	varchar(5)	Yes	Scrap account Type	No
ROAH_SCRACC_CODE	_varchar_32	varchar(32)	Yes	Scrap account code	No
ROAH_Currency	udd_currency	varchar(20)	Yes	This field is to capture the transaction currency of the repairorder	No
ROAH_Expense_type	udd_designparamcode	varchar(5)	Yes	This field holds the Expense type Allowed values are Revenue Revenue Capital Capital	No
ROAH_ShopJob_Type	udd_designparamcode	varchar(5)	Yes	This field holds the Shop Job Type Allowed values are C Component PP Peice part F faciltity	No
ROAH_CapexProposal_No	udd_documentno	varchar(40)	Yes	This field is to capture the Capex Proposal No of the repairorder	No
ROAH_Customer_No	udd_customer_id	varchar(18)	Yes	This field is to capture the Customer No of the repairorder	No
ROAH_Custorder_No	udd_documentno	varchar(40)	Yes	This field is to capture the Customer order No of the repairorder	No
ROAH_RO_Source	udd_flag	varchar(25)	Yes	This field hold the repair order source, The valid values are Manual AUTO CO AUTO CWO AUTO HWO AUTO TLOG Others	No
ROAH_RO_From_Wh_No	udd_warehouse	varchar(10)	Yes	This field holds the Warehouse Number from which the good s will be Fetched before repair.	No
ROAH_Stock_Status	udd_status	varchar(25)	No	This field holds the stock status of the repairorder	No
ROAH_Cost	udd_purcost	numeric(13)	Yes	This field holds the total cost of the RO line level	No
ROAH_Work_Request	udd_txt2000	varchar(2000)	Yes	This field holds the work requested for the part	No
ROAH_Remarks	udd_txt255	varchar(255)	Yes	This field holds the remarks which is given in the maitain multiline..	No
ROAD_BER_Qty	udd_quantity	numeric(13)	Yes	This field holds the BER quantity	No
ROAH_COST_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the cost difference of RO after the amendment	No
ROAH_RO_InsuranceCost	udd_amount	numeric(13)	Yes	This column holds the amended Insurance cost value	No
ROAH_NRTN_Cost	fin_amount	numeric(13)	Yes	This fields hold the history of non return cost value	No
ROAH_RO_CR_ACREG_NO	udd_aircraftnumber	varchar(30)	Yes	Column to store Aircraft Reg no for the respective CR No.	No
ROAH_RO_ADDRESSID	udd_seqno	int(4)	Yes	This fields hold the history of repair shop address ID.	No
ROAH_RO_CLASSIFICATION	udd_quickcodes	varchar(25)	Yes	This fields hold the history of repair shop clasification	No
ROAH_RO_CUST_APP_FLAG	udd_flag	varchar(25)	Yes	This fields hold the history of customer approval required flag value	No
ROAH_Repair_For	udd_designparamcode	varchar(5)	Yes	repair for	No
ROAH_Rep_TradingPartner	udd_vendorcode	varchar(45)	Yes	trading partner	No
ROAH_RoInvOrg	udd_companycode	varchar(10)	Yes	inter company code	No
ROAH_Rep_Oucode	udd_ctxt_ouinstance	int(4)	Yes	inter company ou	No
ROAH_BaseCurrency	udd_currency	varchar(20)	Yes	base currency	No
RoAh_Expenseto	udd_currency	varchar(20)	Yes	expense to	No
ROAH_release_ship	udd_flag	varchar(25)	Yes	This stores the release for shipping done for the component part	No
ROAHD_CR_key_Seqno	udd_seqno	int(4)	Yes	This column holds the unique id for the Swo based RO part after amendment	No
ROAHD_RO_Core_ID	udd_seqno	int(4)	Yes	This field holds the Key ID for the SWO reference RO component part after amendment	No
Roah_OverideBER_Limit	udd_seqno	int(4)	Yes	This field holds the Overide BER Limit	No
ROAH_RO_Amd_Aftr_CL_Flag	udd_designparamcode	varchar(5)	Yes	This field holds the amended RO after CL flag	No
ROAH_RO_RTN_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the return RO by	No
ROAH_RO_RTN_Date	udd_datetime	varchar(30)	Yes	This field holds the return date	No
ROAH_RO_RTN_Reason	udd_txt2000	varchar(2000)	Yes	This field holds the return reason	No

Table Name :	Rep_ROGen_Inp_Dtl
Comment :	This table is to capture the AUTO Repair order generation

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	REP_ROHD_REPAIR_ORDER_HDR
Comment :	THis table is to capture Repair Order Info

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ROHD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
ROHD_RO_NO	_varchar_40	varchar(40)	No	This field holds the repair order document number.	Yes
ROHD_RO_TYPE	_varchar_5	varchar(5)	No	This field holds the repair order type Values allowed are 1. NM Normal 2. EX Exchange	No
ROHD_RO_LAT_AMEND_NO	_decimal_10_0	decimal(10)	No	This field holds the latest amendment no. for the Repair order document	No
ROHD_RO_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks entered for the RO document	No
ROHD_SUPPLIER_OU	_decimal_10_0	decimal(10)	No	This field captures the repair shop supplier created OUInstance.	No
ROHD_REPAIR_SHOP_NO	_varchar_45	varchar(45)	No	This field holds the Repair shop number supplier of type repair agency	No
ROHD_REPAIR_SHOP_CONPER	_varchar_80	varchar(80)	Yes	This field holds the repair shop s contact person. contact person of repair shop	No
ROHD_RO_PRIORITY	_varchar_20	varchar(20)	Yes	This field holds the priority whose values are populated from Logistics Common Master	No
ROHD_RO_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Aircraft Created OUInstance Only if "For Aircraft Reg no" exists	No
ROHD_RO_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Thsi field holds the for aircraft registration no.It is mandatory only if Priority = AOG	No
ROHD_RO_REQ_REPAIR_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the requested repair time THe time that should be taken for repair It is not mandatory .	No
ROHD_RO_LEAD_TIME_UNITS	_varchar_5	varchar(5)	Yes	This field holds the repair order lead time units. Allowed values are D Days W Weeks M Months B Blank	No
ROHD_RO_MATL_RET_AUTH_NO	_varchar_40	varchar(40)	Yes	This field holds the Material Return Authority Number.It is mandatory only if BER Flag is YES and Salvage Action is By Operator	No
ROHD_RO_SPEC_SHIP_DATE	_datetime_8	datetime(8)	Yes	This field holds the Specified Shipping Date If Requested Repair Time is entered the specific shipping date should be greater than the Requested repair time	No
ROHD_RO_SHIP_DATE_CTRL	_varchar_5	varchar(5)	Yes	THis field holds the Shipping Date Control. Allowed values are Y Yes N No B Blank	No
ROHD_RO_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the Quickcodes of type category defined in the Logistics Common Master for the RO Document	No
ROHD_RO_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the user status defined in the Logistics Common Master for the RO Document	No
ROHD_RO_RETURN_TO_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Goods receipt ouinstance in which the core part will be recieved	No
ROHD_RO_STKADMN_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Warehouse OU Stock Admin OU of the Warehouse in which the goods will be stored after Return.	No
ROHD_RO_WH_NO	_varchar_10	varchar(10)	Yes	THis field holds the Warehouse number in which the goods will be stored after Return.	No
ROHD_RO_CORE_RETURN_OPT	_varchar_5	varchar(5)	No	This field holds the Core Return Option. Allowed values are P P/N Change Allowed PS P/N and S/N change allowed S S/N change allowed N No change allowed	No
ROHD_RO_SPARES	_varchar_5	varchar(5)	No	This field holds the values which indicates that spares to be shipped or not. Allowed values are 1.SH Shipped 2.NSH Not Shipped	No
ROHD_RO_BUYER_GROUP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Buyer Group OUInstance of the Buyer Group to which the Login User Belongs to	No
ROHD_RO_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field holds the Buyer Group to which the Login User Belongs to	No
ROHD_RO_CMPLAN_OU	_decimal_10_0	decimal(10)	Yes	This field holds the "The Component Maintenance Planning OU " interacting with repair order component	No
ROHD_RO_PART_CR_OU	_decimal_10_0	decimal(10)	No	This field holds the Part Created OU with which the repair order component is interacting	No
ROHD_RO_PART_NO	_varchar_40	varchar(40)	No	This field holds the repair order part number	No
ROHD_RO_SERIAL_NO	_varchar_40	varchar(40)	No	This field holds the repair order serial number	No
ROHD_RO_ACCOMPONENT_OU	_decimal_10_0	decimal(10)	No	This field holds the Component Id Created Aircraft OUInstance	No
ROHD_RO_COMPONENT_ID	_varchar_90	varchar(90)	No	This field holds the Component Id for which the Repair order Document is created	No
ROHD_RO_COMP_REPLACE_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Component Replacement OU of repair order document	No
ROHD_RO_COMP_REPLACE_NO	_varchar_40	varchar(40)	Yes	This field holds the Component Replacement number of the repair order document	No
ROHD_RO_PART_OWNED_BY	_varchar_30	varchar(30)	Yes	THis field holds the Owner Code airline operator codes defined in the Common Master component	No
ROHD_RO_UNDER_WARRANTY	_varchar_5	varchar(5)	Yes	This field holds the Under Warranty Status. Allowed values Y Yes N No B Blank	No
ROHD_RO_WARR_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Warranty OUinstance of warranty component with which repair order component is interacting	No
ROHD_RO_WARR_OEM_NO	_varchar_40	varchar(40)	Yes	This field holds theWarranty Number of OEM Type if exists	No
ROHD_RO_WARR_NEW_NO	_varchar_40	varchar(40)	Yes	THis field holds the Warranty Number of New Type if exists	No
ROHD_RO_WARR_OVERHAUL_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty Number of Overhaul Type if exists	No
ROHD_RO_WARR_REPAIR_NO	_varchar_40	varchar(40)	Yes	This field holds the Warranty Number of Repair Type if exists	No
ROHD_RO_WARR_OEM_FLG	_varchar_5	varchar(5)	Yes	This field holds the indicator of OEM Type of warranty Allowed value OE	No
ROHD_RO_WARR_NEW_FLG	_varchar_5	varchar(5)	Yes	This field holds the indicator of NEW Type of warranty Allowed value is NE	No
ROHD_RO_WARR_OVERHAUL_FLG	_varchar_5	varchar(5)	Yes	This field holds the Overhaul Type of warranty. Allowed value is OV Overhaul	No
ROHD_RO_WARR_REPAIR_FLG	_varchar_5	varchar(5)	Yes	Thisfield holds the Repair Type of warrranty. Allowed value is RE Repair	No
ROHD_AUTH_TERLEVEL	_varchar_25	Varchar(25)	Yes	THe final authorizer to authorize the doucmetn Level Code or Purchase Committee	No
ROHD_AUTH_MINVAL	_decimal_28_8	decimal(28)	Yes	This field is to capture the Minimum document Value of authorisation Route	No
ROHD_AUTH_MAXVAL	_decimal_28_8	decimal(28)	Yes	This field is to capture the Maximum document Value of authorisation Route	No
ROHD_AUTH_NXTLVLPC	_varchar_25	Varchar(25)	Yes	This field is to capture "The Next Level code" or "PC" to authorize the document	No
ROHD_AUTH_TYPE	_varchar_5	varchar(5)	Yes	This field is to hold the Authorizer type Allowed value LEVEL code or PC	No
ROHD_AUTH_STAGE	_varchar_25	Varchar(25)	Yes	This field holds the Authorizer stages if the Document is in "Under AUthorization U status	No
ROHD_RO_STATUS	_varchar_15	varchar(15)	No	This field holds the repair order Status of the Document. Allowed values are D Draft F Fresh RL Released ACK Acknowledged Q Quoted CF Confirmed U Under Authorization AU Authorized AM Amended CN	No
ROHD_RO_CORE_RET_FLG	_varchar_5	varchar(5)	Yes	This field is to capture the RO core return flag	No
ROHD_CORE_ISSUED_FLAG	_char_1	char(1)	Yes	This field is to capture the Core Issued Flag If the Issue Compoennt has issued the Core Component Allowed values are Y Yes N No	No
ROHD_GR_RECD_PART_NO	_varchar_40	varchar(40)	Yes	THis field holds the Received Repair part number of the goods receipt component	No
ROHD_GR_RECD_SL_NO	_varchar_40	varchar(40)	Yes	This field is to capture the Received Serial number of goods receipt component	No
ROHD_GR_RECD_FLAG	_varchar_5	varchar(5)	Yes	This field is to capture the GR Recieved Flag Allowed value is A Accepted If the Core has been returned from the supplier.	No
ROHD_TASK_OU	_decimal_10_0	decimal(10)	Yes	Stores the task OUinstance form task component	No
ROHD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the RO document	No
ROHD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Created Date of the record	No
ROHD_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	This field holds the User who modified the document	No
ROHD_MODIFIED_DATE	udd_time	datetime(8)	No	This field holds the Modified date of the record	No
ROHD_RELEASED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Released date of the record	No
ROHD_RELEASED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who Released the document	No
ROHD_AUTHORISED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Authorized date of the record	No
ROHD_AUTHORISED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who authorised the record	No
ROHD_CONFIRMED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Confirmed Date of the record	No
ROHD_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	This field holds the User who Confirmed the document the latest	No
ROHD_AMENDED_DATE	_datetime_8	datetime(8)	Yes	This field holds the AMended Date of the record	No
ROHD_AMENDED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who amended the record.	No
ROHD_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp value	No
ROHD_RO_EXCHG_TYPE	_varchar_5	varchar(5)	Yes	Holds the Exchange type : F Flat R Repair B Blank	No
ROHD_RO_CR_REASON	_varchar_20	varchar(20)	Yes	Component Removal reason in RO main table	No
ROHD_RO_REASON_FOR_REM	_varchar_255	varchar(255)	Yes	Reason for removal	No
ROHD_RO_DISP_WARR_TYPE	_varchar_5	varchar(5)	Yes	This field holds the warranty type of the warranty no with highest priority that has to be displayed .	No
ROHD_RO_WARR_CLAIM	_varchar_40	varchar(40)	Yes	Warranty Claim Number in RO main table	No
ROHD_RO_WARR_CLAIM_DATE	_datetime_8	datetime(8)	Yes	warranty claim date	No
ROHD_RO_WARR_CLAIM_ON	_varchar_5	varchar(5)	Yes	warranty claim on : F Full P Partial M Material L Labour O Others B Blank	No
ROHD_RO_SUP_AGMNT_REF	_varchar_40	varchar(40)	Yes	Supplier Agreement Reference number in RO main table	No
ROHD_RO_SUPP_WARR_REF	_varchar_40	varchar(40)	Yes	Supplier Warranty Reference Number in RO main table	No
ROHD_RO_WARR_NOTES	_varchar_2000	varchar(2000)	Yes	Warranty notes	No
ROHD_RO_WARR_REASON	_varchar_2000	varchar(2000)	Yes	Warranty Reason	No
ROHD_CLAIM_ACCPT_ON	_varchar_5	varchar(5)	Yes	Claim Accepted on F Full P Partial M Material L Labour O Others B Blank	No
ROHD_CLAIM_ACCPT_STATUS	_varchar_5	varchar(5)	Yes	Claim Acceptance Status FA Fully Accepted PA Partially Accepted RJ Rejected	No
ROHD_RO_STKFROM_OU	_decimal_10_0	decimal(10)	Yes	Stock Admin OU Warehouse OU Where the Core component is stored	No
ROHD_RO_STKFROM_WH	_varchar_10	varchar(10)	Yes	Warehouse no Where the Core component is stored .	No
ROHD_RO_REASON	_varchar_2000	varchar(2000)	Yes	Holds the reason for actions taken cancellation/authorization against RO.	No
ROHD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
ROHD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
ROHD_DEF_FIN_BOOK	_varchar_20	varchar(20)	Yes	stores the default finance book	No
ROHD_COMPANY_CODE	_varchar_32	varchar(32)	Yes	stores the company code	No
ROHD_BUSINESS_UNIT	_varchar_32	varchar(32)	Yes	stores the business unit	No
ROHD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
ROHD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
ROHD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
ROHD_RO_CMPID_OWNSHP	_varchar_5	varchar(5)	Yes	stores the component id ownership status whenever the repair order is BER closed.	No
ROHD_DOC_KEY	_varchar_128	varchar(128)	Yes	stores the document key for work flow purpose	No
ROHD_RO_NUM_TYP_NO	_varchar_5	varchar(5)	Yes	stores the numbering type no of repair order	No
ROHD_RO_REF_DOC_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Reference Document No	No
ROHD_RO_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number like CWO Number, etc.	No
ROHD_RO_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Reference Document Type Possible values CWO Component Work Order HWO Hangar Work Order OTH Others TL Tech Log	No
ROHD_RO_WORK_CENTER_OU	_decimal_10_0	decimal(10)	Yes	This field holds the OUInstance of the work center	No
ROHD_RO_WORK_CENTER	_varchar_30	varchar(30)	Yes	This field holds the Work Center	No
ROHD_RO_LOT_NO	_varchar_18	varchar(18)	Yes	This field holds the Lot Number	No
ROHD_SCRAAC_TYPE	_varchar_5	varchar(5)	Yes	This field holds the scrap account type	No
ROHD_SCRACC_CODE	_varchar_32	varchar(32)	Yes	This field holds the scrap account code	No
ROHD_RO_PART_COND	_varchar_5	varchar(5)	Yes	This field holds the part condition of the part	No
ROHD_RO_Insp_WO	_varchar_75	varchar(75)	Yes	This field holds the Insecption work order ID	No
ROHD_RO_Com_No	_varchar_40	varchar(40)	Yes	This field holds the component ID	No
ROHD_RO_Gen_Insp_WO	_varchar_25	Varchar(25)	Yes	This field holds the Generated Component work order ID	No
ROHD_RO_Comp_WO_No	_varchar_40	varchar(40)	Yes	This fields hold the component work order number	No
ROHD_RO_Insp_WO_Desc	_varchar_75	varchar(75)	Yes	This field holds the Insecption work order Description	No
ROHD_RO_Insp_WO_Status	_varchar_15	varchar(15)	Yes	This field holds the Insecption work order status	No
ROHD_RO_Exe_omments	_varchar_75	varchar(75)	Yes	This field holds the Repair order comments	No
ROHd_Currency	udd_currency	varchar(20)	Yes	This field is to capture the transaction currency of the repairorder	No
ROHd_Expense_type	udd_designparamcode	varchar(5)	Yes	This field holds the Expense type Allowed values are Revenue R Capital C	No
ROHd_ShopJob_Type	udd_designparamcode	varchar(5)	Yes	This fields hold the repair order shop job type	No
ROHd_CapexProposal_No	udd_documentno	varchar(40)	Yes	This field is to capture the Capex Proposal No of the repairorder	No
ROHd_Customer_No	udd_customer_id	varchar(18)	Yes	This field is to capture the Customer No of the repairorder	No
ROHd_Custorder_No	udd_documentno	varchar(40)	Yes	This field is to capture the Customer order No of the repairorder	No
ROHd_RO_Source	udd_flag	varchar(25)	Yes	This field hold the repair order source, The valid values are Manual AUTO CO AUTO CWO AUTO HWO AUTO TLOG Others	No
ROHd_RO_From_Wh_No	udd_warehouse	varchar(10)	Yes	This field holds the Warehouse Number from which the good s will be Fetched before repair.	No
ROHD_Stock_Status	udd_partstatus	varchar(40)	No	This field holds the stock status of the repairorder	No
ROHD_Cost	udd_purcost	numeric(13)	Yes	This field holds the total cost of the RO line level	No
ROHD_Work_Request	udd_txt2000	varchar(2000)	Yes	This field holds the work requested for the part	No
ROHD_Remarks	udd_txt255	varchar(255)	Yes	This field holds the remarks which is given in the maitain multiline..	No
ROHD_BER_Qty	udd_quantity	numeric(13)	Yes	It holds the value of ber quantity	No
ROHD_COST_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the cost difference of RO after amendment	No
ROHD_RO_SUPP_REPAIRCOST	udd_amount	numeric(13)	Yes	This field will store the Supplier Cost	No
ROHD_RO_WARR_Ultimate_NO	udd_documentno	varchar(40)	Yes	This field holds the Warranty Number of Ultimate Life Type if exists	No
ROHD_RO_WARR_Ultimate_FLG	udd_designparamcode	varchar(5)	Yes	This field holds the indicator of Ultimate LifeType of warranty	No
ROHD_RO_WARR_Mod_NO	udd_documentno	varchar(40)	Yes	This field holds the Warranty Number of Mod Type if exists	No
ROHD_RO_WARR_Mod_FLG	udd_designparamcode	varchar(5)	Yes	This field holds the indicator of Mod of warranty	No
RoHD_Ro_Warr_Refdoc_type	udd_documentno	varchar(40)	Yes	This field will store the Reference document Type	No
RoHD_RO_Warr_Refdoc_no	udd_documentno	varchar(40)	Yes	This field will store the Reference document Number	No
RoHD_Ro_Warr_Quotegen	udd_designparamcode	varchar(5)	Yes	This field will store the Quote generation basis.	No
RoHD_RO_Quote_Status	udd_flag	varchar(25)	Yes	This field will store the Quote generation Mode.	No
RoHD_RO_Warflag	udd_flag	varchar(25)	Yes	This field will store the Warranty flag value.	No
ROHd_RO_InsuranceCost	udd_amount	numeric(13)	Yes	This column is used to hold the Insurance cost value	No
ROHD_NRTN_Cost	fin_amount	numeric(13)	Yes	This fields hold the repair order non return cost value	No
rohd_maincore_cost	udd_amount	numeric(13)	Yes	This fields hold the repair order main core part cost value	No
rohd_rtn_cost	udd_amount	numeric(13)	Yes	This fields hold the repair order return cost value	No
ROHD_RO_CR_ACREG_NO	udd_aircraftnumber	varchar(30)	Yes	This column to store aircraft reg no against the respective CR No.	No
ROHD_Remarks_UniqueID	udd_documentno	varchar(40)	Yes	This field corresponds the unique id generated against each remark value.	No
ROHD_PART_TYPE	udd_type	varchar(25)	No	This field corresponds to the part type defined in part master.	No
ROHD_PART_CONTROLTYPE	udd_type	varchar(25)	No	This field corresponds to the control type of the part.	No
ROHD_PART_EXPOLICY	udd_designparamcode	varchar(5)	No	This field corresponds to the part expence policy as defined in part master.	No
ROHD_PART_EXPTYPE	udd_type	varchar(25)	No	This field corresponds to the expence type of the part as defined in part master.	No
ROHD_PART_NONSTKFLG	udd_model	varchar(20)	No	This field corresponds to the Non stockable part as defined in part master.	No
ROHD_PART_LOTNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Lot numbering type.	No
ROHD_PART_SLNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Serial numbering type.	No
ROHD_PART_SLNOLOGIC	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Serial no logic generation.	No
ROHD_RO_ADDRESSID	udd_seqno	int(4)	Yes	This fields hold the repair shop address ID.	No
ROHD_RO_CLASSIFICATION	udd_quickcodes	varchar(25)	Yes	This fields hold the repair shop clasification	No
ROHD_RO_CUST_APP_FLAG	udd_flag	varchar(25)	Yes	This fields hold the customer approval required flag value	No
ROHD_EXCGAPPFLG	udd_flag	varchar(25)	Yes	flag holding the value for exchange applicable or not	No
ROHD_RO_CSO_LINE_NO	udd_seqno	int(4)	Yes	the CSO line no	No
ROHD_ROOTCHILD_FLG	udd_flag	varchar(25)	Yes	Root chlid flag	No
ROHD_RO_DELINK_FLAG	udd_designparamcode	varchar(5)	Yes	RO delink flag	No
ROHD_RO_CLASS	udd_designparamcode	varchar(5)	Yes	RO class	No
ROHD_RO_Mode	udd_designparamcode	varchar(5)	Yes	RO Mode	No
ROHD_RO_Adl_Ref_Doc_No	udd_documentno	varchar(40)	Yes	RO ref doc number	No
ROHD_RO_Adl_Ref_Doc_Type	udd_designparamcode	varchar(5)	Yes	Ref doc type	No
created_area_code	_varchar_40	varchar(40)	Yes	OFMS area code	No
ROHD_RR_EXIST	udd_designparamcode	varchar(5)	Yes	repair receipt exist	No
Rohd_Repair_For	udd_designparamcode	varchar(5)	Yes	repair for	No
Rohd_Rep_TradingPartner	udd_vendorcode	varchar(45)	Yes	trading partner	No
Rohd_Expenseto	udd_vendorcode	varchar(45)	Yes	expense to	No
Rohd_RoInvOrg	udd_companycode	varchar(10)	Yes	inter company code	No
Rohd_Rep_Oucode	udd_ctxt_ouinstance	int(4)	Yes	inter company ouinstance	No
Rohd_BaseCurrency	udd_currency	varchar(20)	Yes	base currency	No
ROHD_CR_key_Seqno	udd_seqno	int(4)	Yes	This column holds the unique id for the Swo based RO part after amendment	No
ROHD_release_ship	udd_flag	varchar(25)	Yes	This Shows the release for shipping status for the component part	No
ROHD_RO_Core_ID	udd_seqno	int(4)	Yes	this field holds the Unique key ID for the Swo based RO part	No
Rohd_OverideBER_Limit	udd_seqno	int(4)	Yes	This field holds the Overide BER Limit	No
ROHD_RO_Amd_Aftr_CL_Flag	udd_designparamcode	varchar(5)	Yes	This field holds the amended RO after CL flag	No
ROHD_RO_RTN_BY	udd_ctxt_user	varchar(30)	Yes	This field holds the return RO by	No
ROHD_RO_RTN_Date	udd_datetime	varchar(30)	Yes	This field holds the return date	No
ROHD_RO_RTN_Reason	udd_txt2000	varchar(2000)	Yes	This field holds the return reason	No

Table Name :	Rep_ROPrt_PiecePart_Dtl
Comment :	This table is to hold Piece part information for the Repair Order -Amendment Numbers

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ROPrt_RO_Ouinstance	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
ROPrt_RO_No	udd_documentno	varchar(40)	No	This field holds the repair order document number.	Yes
ROPrt_Line_no	udd_linenum	varchar(30)	No	THis field is to capture the part line no	Yes
ROPrt_Part_Cr_OU	udd_ctxt_ouinstance	int(4)	Yes	This field holds the Part Created OU with which the repair order component is interacting	No
ROPrt_Part_No	udd_partno	varchar(40)	Yes	This field holds the repair order piece part number	No
ROPrt_Quantity	udd_quantity	numeric(13)	No	This field holds the piece part quantity	No
ROPrt_Serial_No	udd_partserialnumber	varchar(40)	Yes	This field holds the repair order piece part serial number	No
ROPrt_Lot_No	udd_lotno	varchar(18)	Yes	This field holds the repair order piece part lot number	No
ROPrt_Stock_Status	udd_partstatus	varchar(40)	No	This field holds the piece part stock status	No
ROPrt_Cost	udd_purcost	numeric(13)	Yes	This field holds the Total cost of the piece part line level	No
ROPrt_Work_Request	udd_txt2000	varchar(2000)	Yes	This field holds the work requested for the piece part	No
ROPrt_Remarks	udd_txt255	varchar(255)	Yes	This field holds the remarks	No
ROPrt_BER_Qty	udd_quantity	numeric(13)	Yes	This column holds the value BER Quantity, which is defined in record quation line level	No
ROPrt_Rec_Qty	udd_quantity	numeric(13)	Yes	This column holds the value of received quantity of this line, which defined in Repair reciept	No
ROPrt_Line_status	udd_designparamcode	varchar(5)	Yes	This column holds the line level status of the each part no no values CL closed OP open BC BER closed	No
ROPrt_GR_Rec_Partno	udd_partno	varchar(40)	Yes	This field holds the received repair part no of repair order documents	No
ROPrt_GR_Rec_Serialno	udd_partserialnumber	varchar(40)	Yes	This field holds the Received Serial number of repairorder documents	No
ROPrt_COMPONENT_ID	udd_componentid	varchar(90)	Yes	If part number and serial number is of type component then the component id is stored here	No
ROPrt_ACCOMPONENT_OU	udd_ctxt_ouinstance	int(4)	Yes	If part number and serial number is of type component then the Ou for that component is stored here	No
ROPrt_BER_Cost	udd_quantity	numeric(13)	Yes	This field holds the beyond repair cost of the part.	No
ROPrt_Salvage_Action	udd_designparamcode	varchar(5)	Yes	This field holds the salvage action of the part.	No
ROPrt_Salvage_Value	udd_amount	numeric(13)	Yes	This field holds the salvage value of the part.	No
ROPrt_Pending_Qty	udd_quantity	numeric(13)	Yes	It holds the value of pending quantity	No
ROPRT_COST_DIFF	_numeric_28_8	numeric(28)	Yes	This field holds the cost difference of part after amendment	No
ROPRT_SUPP_REPAIRCOST	udd_amount	numeric(13)	Yes	This field will store the Supplier cost.	No
ROPrt_NRTN_Cost	fin_amount	numeric(13)	Yes	This fields hold the repair order non return cost value in piece part level.	No
roprt_maincore_cost	udd_amount	numeric(13)	Yes	This fields hold the repair order main core value in piece part level.	No
ROPrt_Remarks_UniqueID	udd_documentno	varchar(40)	Yes	This field corresponds the unique id generated against each remark value.	No
ROPRT_PART_TYPE	udd_type	varchar(25)	No	This field corresponds to the part type defined in part master.	No
ROPRT_PART_EXPTYPE	udd_type	varchar(25)	No	This field corresponds to the expence type of the part as defined in part master.	No
ROPRT_PART_NONSTKFLG	udd_model	varchar(20)	No	This field corresponds to the Non stockable part as defined in part master.	No
ROPRT_PART_EXPOLICY	udd_designparamcode	varchar(5)	No	This field corresponds to the part expence policy as defined in part master.	No
ROPRT_PART_CONTROLTYPE	udd_type	varchar(25)	No	This field corresponds to the control type of the part.	No
ROPRT_PART_LOTNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Lot numbering type.	No
ROPRT_PART_SLNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Serial numbering type.	No
ROPRT_PART_SLNOLOGIC	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Serial no logic generation.	No
ROPrt_RO_CSO_LINE_NO	udd_seqno	int(4)	Yes	This field corresponds to the CSO line NO	No
ROPrt_Accepted_Qty	udd_quantity	numeric(13)	Yes	part accepted quantity	No
ROPrt_Rejection_Qty	udd_quantity	numeric(13)	Yes	part rejection quantity	No
ROPRT_BER_INVOICED	udd_designparamcode	varchar(5)	Yes	This indicates the BER declared part invoiced status	No
ROPrt_BER_InvQty	udd_quantity	numeric(13)	Yes	this field holds the Invoiced Quantity of the BER Declared Part	No
Roprt_Core_id	udd_seqno	int(4)	Yes	This field holds the SWO based RO-Unique ID for piece part	No
Roprt_CR_key_Seqno	udd_seqno	int(4)	Yes	This field refers the Sequence number of the SWO Reference Piece part	No
ROPRT_EXCHANGE_COST	udd_cost	numeric(13)	Yes	Exchange cost of the Piece part	No
ROPRT_EXCHANGE_DIFF	udd_cost	numeric(13)	Yes	This Column holds the different between the exchange cost at piece part level	No
ROPRT_EXCHANGE_INVOICED	udd_designparamcode	varchar(5)	Yes	This column is used to mark whether invoice done for the Exchange Part at piece part level	No
ROprt_Exchange_InvQty	udd_quantity	numeric(13)	Yes	this field holds the Incoiced Quantity of the Exchage part at piece part level	No
ROPrt_release_ship	udd_flag	varchar(25)	Yes	This marks whether the release for shipping done for the piece part	No
ROPRT_REPAIR_INVOICED	udd_designparamcode	varchar(5)	Yes	This indicates the repaired Quantity part invoiced status	No
ROPrt_Repair_InvQty	udd_quantity	numeric(13)	Yes	This indicates the invoiced Quantity for the Repaired Quantity	No
ROPRT_SALVAGE_INVOICED	udd_designparamcode	varchar(5)	Yes	This columns flag used to specify the invoiced flag at piece part level	No
ROPrt_Salvage_InvQty	udd_quantity	numeric(13)	Yes	this field stores the Salvage Invoiced Quantity	No

Table Name :	REP_ROSOPT_SETOPTION_INFO
Comment :	This table is to capture the repair order set option info.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ROSOPT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
ROSOPT_DEF_AUTO_NUM_TYPE	_varchar_5	varchar(5)	Yes	This field is to capture the Member Authorization Status Allowed values are 1.Y 2.N	No
ROSOPT_WUNIT_ADD	_varchar_5	varchar(5)	Yes	If the user is given option to add a work unit manually,then this field needs to set	No
ROSOPT_WUNIT_DELETE	_varchar_5	varchar(5)	Yes	If the user is given option to delete a defaulted work unit manually,then this field needs to set	No
ROSOPT_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold the user who created teh record	No
ROSOPT_CREATED_DATE	_datetime_8	datetime(8)	No	This field is to capture the created date of the record.	No
ROSOPT_MODIFIED_BY	_varchar_30	varchar(30)	No	This field is to hold the user who modified the record.	No
ROSOPT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is to capture the modified date of the record.	No
ROSOPT_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record.	No
ROSOPT_DEFTYP_AUTOWARRRO	_varchar_5	varchar(5)	Yes	ROSOPT_DEF_NO_TYP_AUTOWARRRO	No
ROSOPT_ADDN_DISCPS_TO_RO	_varchar_5	varchar(5)	Yes	This field holds the Addition of Discrepancies to RO no AL Allowed NA Not Allowed	No
ROSOPT_ADDN_OF_NRTNE_TASK	_varchar_5	varchar(5)	Yes	This field holds the Addition of Non Routine Task AL Allowed NA Not Allowed	No
ROSOPT_ACK_OF_ORDER	_varchar_5	varchar(5)	Yes	This field holds the Acknowledgement of Order MD Mandatory NM Non Mandatory	No
ROSOPT_RO_ON_UNSVBLE_PRTS	_varchar_5	varchar(5)	Yes	This field holds the Repair Order only on Unserviceable parts Y Yes N No	No
ROSOPT_COMP_IN_WHCHK	_varchar_5	varchar(5)	Yes	This field holds the Component in Warehouse Check EF Enforce DE Do not Enforce	No
ROSOPT_SPARES_SUPPLD_BY	_varchar_5	varchar(5)	Yes	This field holds the Spares Supplied By RS Repair Shop OP Operator BO Both	No
ROSOPT_SPARES_SHIPPING	_varchar_5	varchar(5)	Yes	This field holds the Spares Shipping WC With Core Sp Separate	No
ROSOPT_RETLOC_ISSLOC_DIFF	_varchar_5	varchar(5)	Yes	This field holds the Return to Location different from Issue Location AL Allowed NA Not Allowed	No
ROSOPT_COMP_LIST_PRICE	_varchar_5	varchar(5)	Yes	This field holds the Component List Price SC Standard cost EN Enterable	No
ROSOPT_AUTOAUTHLIMIT	_decimal_28_8	decimal(28)	Yes	This field holds the Auto Authorization Limit %	No
ROSOPT_MAX_ALLOW_REP_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Maximum Allowable Repair cost %	No
ROSOPT_PTPRC_MAP_TO_SUP	_varchar_5	varchar(5)	Yes	This field holds the flag whether the part and process mapping to supplier is mandatory or non mandatory	No
ROSOPT_RO_COST_AMD_ALLOWED	_varchar_5	varchar(5)	Yes	This field holds value Y or N	No
ROSOPT_QUOT_TYPE_ALLOWED_INV	udd_designparamcode	varchar(5)	Yes	This column store the values like FIRM, FIRM AND ESTIMATE	No
ROSOPT_Def_RepAgency	udd_designparamcode	varchar(5)	Yes	Stores whether Repair Agency has to be default in Repair Order.	No
ROSOPT_QUO_GEN_BASIS	udd_designparamcode	varchar(5)	Yes	This field will store the Quote Generation Basis	No
ROSOPT_ROSTATUS_NONCNT_PRT	udd_designparamcode	varchar(5)	Yes	This field will store the RO Status for non contracted parts	No
ROSOPT_RO_TRANSIT_TIME	udd_seqno	int(4)	Yes	Used to store the Transit Time	No
ROSOPT_UNDERWARNTY_REPAIR	udd_designparamcode	varchar(5)	Yes	This column holds the Underwarranty value	No
ROSOPT_DEFINSURANCE_COST	udd_designparamcode	varchar(5)	Yes	This column hols the default Insurance cost	No
ROSOPT_Retrieval_RelatedTsk	udd_designparamcode	varchar(5)	Yes	This column holds the informational value of Related Task retreival.	No
ROSOPT_DefRProc_PerpetualTsk	udd_flag	varchar(25)	Yes	This column holds informational value related to perpetual task fetch	No

Table Name :	REP_RQUD_QUOTE_DTL
Comment :	This field holds the Quotation Details for the Repair Order.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RQUD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RQUD_RO_NO	_varchar_40	varchar(40)	No	This field is to hold the Repair Order Number	Yes
RQUD_QUOTE_ID	_decimal_10_0	decimal(10)	No	This field is to hold the uniquely generated quote id	Yes
RQUD_RO_USER_STATUS	_varchar_25	Varchar(25)	Yes	Holds the user entered status for a repair order	No
RQUD_SUP_CON_DISCREPANCY	_varchar_5	varchar(5)	Yes	This field holds the COnfirm Discrepanies confirmed byt he Supplier allowed values are FC Fully Confirmed PC Partially Confirmed NF No Fault Found	No
RQUD_SUP_ADD_DISCREPANCY	_varchar_5	varchar(5)	Yes	This field is to hold the Additional Discrepancies that are Detected Allowed values are Y Yes N No	No
RQUD_SUP_ADD_PROBLEMS	_varchar_255	varchar(255)	Yes	This field is to hold The Additionals Problem Descriptions of supplier	No
RQUD_SUP_COMMENTS	_varchar_255	varchar(255)	Yes	This field is to hold any Comment from the Supplier	No
RQUD_EXCHANGE_RATE_OU	_decimal_10_0	decimal(10)	Yes	This field is to hold the Exchange Rate OUInstance from ESetup Component OU .	No
RQUD_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	This field is tohold the Exchange Rate Between the Base currency and the Quotation Suppler Currency	No
RQUD_QUOTE_REF_NO	udd_documentno	varchar(40)	Yes	This field is to hold the Quotation Reference Number	No
RQUD_QUOTE_TYPE	_varchar_5	varchar(5)	Yes	This field is to hold Quotation Type Allowed Values are F Firm E Estimate	No
RQUD_QUOTE_DATE	_datetime_8	datetime(8)	Yes	This field holds the Quotation Date of the Supplier	No
RQUD_QUOTE_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Quotation Currency	No
RQUD_QUOTE_EST_MAN_HRS	_decimal_28_8	decimal(28)	Yes	This field holds the Quoted &Estimated Man Hours	No
RQUD_QUOTE_COST_MAN_HR	_decimal_28_8	decimal(28)	Yes	This field holds the Cost Per Man Hour	No
RQUD_QUOTE_LABOUR_COST	_decimal_28_8	decimal(28)	Yes	This field holds the quote Labour Cost	No
RQUD_TOTAL_LABOUR_COST	_decimal_28_8	decimal(28)	Yes	This field holds the total labour cost Total Labour cost Labour Cost + Total Labour TCD Cost	No
RQUD_TOTAL_LAB_TCD	_decimal_28_8	decimal(28)	Yes	This field holds the Total Labour TCD Cost	No
RQUD_QUOTE_MATL_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Material cost sum Material cost for all of the materials used for the Quotation.	No
RQUD_TOTAL_MATL_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Total Material cost Total Material Cost + Total Material TCD Cost	No
RQUD_TOTAL_DOC_TCD	_decimal_28_8	decimal(28)	Yes	This field holds the Total Document TCD Cost	No
RQUD_QUOTE_MISC_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Quotation Miscellaneous cost	No
RQUD_QUOTE_AMT_HLD_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the Price Held Firm time THe Price valid time from the Quotation date into consideration	No
RQUD_QUOTE_LD_TIME_UNIT	_varchar_5	varchar(5)	Yes	Ths field holds the Quotation Lead time unit Allowed values D Days W Weeks M Months	No
RQUD_BER_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Beyond Repair Analysis Cost	No
RQUD_QUOTE_REMARKS	_varchar_255	varchar(255)	Yes	This field is to hold any Remarks entered by the Supplier regarding the Quotation	No
RQUD_SALVAGE_AT	_varchar_5	varchar(5)	Yes	This field holds the Salvage Action IF BER Flag is Yes THen the Salvage Action is Mandatory. Allowed values are BRS By Repair Shop BOP By Operator B Blank	No
RQUD_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who entered the QUotation	No
RQUD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the created date of the record	No
RQUD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
RQUD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the QUotation is last modified	No
RQUD_QUOT_EXCHANGE_FEE	_decimal_28_8	decimal(28)	Yes	This field holds the Exchange Fee	No
RQUD_SAL_SALVAGE_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Estimated Scrap value	No
RQUD_QUOT_TOTALREP_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Total Repair Cost	No
RQUD_COMP_LIST_PRICE	_decimal_28_8	decimal(28)	Yes	This field holds the Component List Price	No
RQUD_TOTAL_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Total Cost for the RO no Quote	No
RQuD_Filename	udd_filename	varchar(50)	Yes	This field holds the filename of RO quotation	No
rqud_quote_ber	_varchar_5	varchar(5)	Yes	This fields hold the repair order quotation BER Flag	No
RQUD_CUST_QUOTE_NO	udd_documentno	varchar(40)	Yes	This fields hold the customer quotation Number	No
RQUD_CUST_AUTH_STAUS	udd_quickcodes	varchar(25)	Yes	This fields hold the customer quotation Authorization status	No
RQUD_QUOTE_COMMETNS	udd_txt2000	varchar(2000)	Yes	This fields hold the customer quotation comments	No
RQUD_CUST_COMMETNS	udd_txt2000	varchar(2000)	Yes	This fields hold the customer comments	No
RQUD_NOTES_UNIQUEID	udd_guid	varchar(40)	Yes	Unique ID added for Notes functionality in quotation level	No
RQUD_CUST_COMMENTS_ID	udd_guid	varchar(40)	Yes	customer comments	No
RQUD_BER_INVOICED	udd_designparamcode	varchar(5)	Yes	This column stores the flag for Invoiced BER declared part at record quotes	No
RQUD_BER_InvQty	udd_quantity	numeric(13)	Yes	This Column stores the Invoiced BER quantity during record quotes	No
RQUD_EXCHANGE_INVOICED	udd_designparamcode	varchar(5)	Yes	this field having the flag for Invoiced Exchage Part at record quotes	No
RQUD_Exchange_InvQty	udd_quantity	numeric(13)	Yes	This column stores the Incoiced Exchage part at record quotes	No
RQUD_REPAIR_INVOICED	udd_designparamcode	varchar(5)	Yes	This column stores the Flag to specify the Repaired part invoiced status	No
RQUD_Repair_InvQty	udd_quantity	numeric(13)	Yes	this Column Stores the Invoiced Quantoty of repairable part	No
RQUD_SALVAGE_INVOICED	udd_designparamcode	varchar(5)	Yes	Specify the status of invoiced scrapped part	No
RQUD_Salvage_InvQty	udd_quantity	numeric(13)	Yes	This Field Stores the Invoiced Quantity of scrapped part	No

Table Name :	REP_RSPID_SPARE_ISSUE_DTL
Comment :	This table is to hold Spares Lot/Serial no Issue Details of the Repair Order Number

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSPID_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RSPID_RO_NO	_varchar_40	varchar(40)	No	This field holds the Repair order Number	Yes
RSPID_RO_SPARES_ID	_decimal_10_0	decimal(10)	No	This field holds the Repair Order SPares ID Foreign Key from the Spares Detail Information	Yes
RSPID_RO_LOT_SL_ID	_decimal_10_0	decimal(10)	No	This field holds the Running Serial no for each Lot/SI/NO details for the Spares ID.	Yes
RSPID_RO_ISSUE_LOT_NO	_varchar_18	varchar(18)	Yes	This field holds the Issued Repair lot no in stock issue component	No
RSPID_RO_ISSUE_SERIAL_NO	_varchar_40	varchar(40)	Yes	This field holds the Issued Repair serial no in stock issue component	No
RSPID_RO_ISSUE_QTY	_decimal_28_8	decimal(28)	No	This field holds the Issued Qty in Repair Order UOM	No
RSPID_RO_ISSUE_UOM	_varchar_10	varchar(10)	No	This field holds the Repair Order UOm	No
RSPID_RO_ISSUE_QTY_SUOM	_decimal_28_8	decimal(28)	No	This field holds the Issued Qty in Stock UOM	No
RSPID_GR_RECD_LOT_NO	_varchar_18	varchar(18)	Yes	This field holds the Returned/Recieved Lotno through GR NULL in case of Only Serial Controlled and None Part types	No
RSPID_GR_RECD_SERIAL_NO	_varchar_40	varchar(40)	Yes	This field holds the Returned/Recieved Serial Number through GR NULL in case of Only Lot Controlled and None Part types	No
RSPID_GR_RECD_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Returned/Recieved Quantity in Repair order UOM	No
RSPID_GR_ACCPT_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Accepted Quantity among the Recieved Quantity in Repair order UOM	No
RSPID_GR_MOVED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Moved Quantity into the warehouse among the Accepted Quantity in Repair order UOM	No
RSPID_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user who created the record	No
RSPID_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Created Date of the record	No
RSPID_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
RSPID_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the Modified Date of the record	No
RSPID_GR_REJ_QTY	udd_seqno	int(4)	Yes	gr rejected qty	No
RSPID_RO_PEND_RET_QTY	udd_quantity	numeric(13)	Yes	pending return qty	No

Table Name :	REP_RSPSD_SPARE_SHIP_DTL
Comment :	This table is to hold the Spare Ship Details of the Repair Orders

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RSPSD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RSPSD_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair order number	Yes
RSPSD_RO_SPARES_ID	_decimal_10_0	decimal(10)	No	This field is to capture the uniquely generated spares id	Yes
RSPSD_SPARE_PART_CR_OU	_decimal_10_0	decimal(10)	No	This field is to hold the Spare Part Created OUInstance	No
RSPSD_SPARE_PART_NO	_varchar_40	varchar(40)	No	This field is to hold the Spare Requested Part Number	No
RSPSD_SPARE_PART_QTY	_decimal_28_8	decimal(28)	No	This field is to hold the Spare Part Quantity requested in Repair Order UOM	No
RSPSD_SPARE_PART_UOM	_varchar_10	varchar(10)	No	This field is to hold the Spare part UOM.	No
RSPSD_SPARE_PART_QTY_SUOM	_decimal_28_8	decimal(28)	Yes	This field is to hold the Spare Part Quantity Requested In Stock UOM	No
RSPSD_SPARE_PART_COND	_varchar_5	varchar(5)	Yes	This field is to hold the Spare Part Condition As of now this field will be empty always	No
RSPSD_SPARE_STKMNT_OU	_decimal_10_0	decimal(10)	No	This field is to hold Stock Maintenance OU with which repair order component is interacting	No
RSPSD_SPARE_SDSTKADMIN_OU	_decimal_10_0	decimal(10)	No	This field is to hold the sending Stock Admin OU interacting with the Stock Maintenance OU	No
RSPSD_SPARE_SEND_WH_NO	_varchar_10	varchar(10)	No	This field is to capture the sending Warehouse Number from where the Spare part has to be issued	No
RSPSD_SPARE_STKISSUE_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold the Quantity which has been Issued already through stockissue component	No
RSPSD_SPARE_PEND_RET_QTY	_decimal_28_8	decimal(28)	Yes	This field is to hold the spare Pending Quantity which has yet to be returned	No
RSPSD_SPARE_RET_TYPE	_varchar_5	varchar(5)	No	This field is to hold the Spares Return Type Allowed values are RT Returnable NR Non Returnable B Blank	No
RSPSD_SPARE_GR_OU	_decimal_10_0	decimal(10)	Yes	This field is to hold spare part GR OU with which repair order component is interacting	No
RSPSD_SPARE_RCSTKADMIN_OU	_decimal_10_0	decimal(10)	Yes	Thsi field is to capture the Stock Admin OU interacting with the GR OU	No
RSPSD_SPARE_RET_WH_NO	_varchar_10	varchar(10)	Yes	This field captures the Warehouse Number to which the spares has to be returned	No
RSPSD_SPR_STKISS_QTY_SUOM	_decimal_28_8	decimal(28)	Yes	This field is to hold the Spares Stock Issue Quantity in Stock UOM	No
RSPSD_SPARE_RECD_PART_NO	_varchar_40	varchar(40)	Yes	This field is to hold the Spares Recieved Part no	No
RSPSD_SPARE_GR_RECD_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Spares Quantity Received from the Supplier	No
RSPSD_SPARE_GR_ACCPT_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Spare Quantity Accepted from the Recieved Quantity	No
RSPSD_SPARE_GR_MOVED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Spare Quantity Moved into the Warehouse from the Accepted Quantity.	No
RSPSD_CREATED_BY	_varchar_30	varchar(30)	No	Ths field holds the User who enters creates the Spares details of the Repair order document into the sysstem	No
RSPSD_CREATED_DATE	_datetime_8	datetime(8)	No	This field holds the Date on which the Spares details is entered into the system	No
RSPSD_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the User who last modified the Spares details of the Repair order document into the sysstem	No
RSPSD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field holds the last modified date of the record	No
RSPSD_ACCOUNT_TYPE	_varchar_5	varchar(5)	Yes	stores the account type	No
RSPSD_ACCOUNT_CODE	_varchar_32	varchar(32)	Yes	stores the account code	No
RSPSD_ANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the analysis code for the account code	No
RSPSD_SUBANALYSIS_CODE	_varchar_32	varchar(32)	Yes	stores the sub analysis code for the account code	No
RSPSD_DEF_FIN_BOOK	_varchar_20	varchar(20)	Yes	stores the default finance book	No
RSPSD_CONTROL_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the control account type	No
RSPSD_AUTO_POST_ACC_TYPE	_varchar_32	varchar(32)	Yes	stores the auto posting account type	No
RSPSD_ACCT_CURR_CODE	_varchar_32	varchar(32)	Yes	stores the account currency code	No
RSPSD_CST_CENTER	_varchar_10	varchar(10)	Yes	stores the cost center for the given account code	No
RSPSD_STOCKSTATUS	udd_partstatus	varchar(40)	Yes	Repair order spare stock status	No
RSPSD_PART_TYPE	udd_type	varchar(25)	No	This field corresponds to the part type defined in part master.	No
RSPSD_PART_EXPTYPE	udd_type	varchar(25)	No	This field corresponds to the control type of the part.	No
RSPSD_PART_NONSTKFLG	udd_model	varchar(20)	No	This field corresponds to the part expence policy as defined in part master.	No
RSPSD_PART_EXPOLICY	udd_designparamcode	varchar(5)	No	This field corresponds to the expence type of the part as defined in part master.	No
RSPSD_PART_CONTROLTYPE	udd_type	varchar(25)	No	This field corresponds to the Non stockable part as defined in part master.	No
RSPSD_PART_LOTNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Lot numbering type.	No
RSPSD_PART_SLNOTYPE	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Serial numbering type.	No
RSPSD_PART_SLNOLOGIC	udd_designparamcode	varchar(5)	Yes	This field corresponds to the Serial no logic generation.	No
RSPSD_SPARE_GR_REJ_QTY	udd_seqno	int(4)	Yes	gr rejected quantity	No
RSPSD_RO_release_ship	udd_flag	varchar(25)	Yes	this Column indicates whether release for shipping done for the Spare Part	No

Table Name :	REP_RTMCN_TERM_COND_INFO
Comment :	This table is to hold terms and condition details of the Repair order Number

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTMCN_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RTMCN_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair order Number	Yes
RTMCN_SUPP_CONTACT_OU	_decimal_10_0	decimal(10)	No	This field is to hold the local interacting OU of the SUpplier with the Repair order for amended repair order documents	No
RTMCN_FWSH_CONTACT	udd_contactperson	varchar(80)	Yes	THis field is to hold the forward Shipping Contact Person of the Supplier	No
RTMCN_FWSH_CORE_BY	_varchar_25	Varchar(25)	No	THis field is to hold the forward Shipping Core By list of Shipping Method codes defined in the Logistics Common Master component	No
RTMCN_FWSH_PACKAGE_CODE	_varchar_25	Varchar(25)	No	Ths field is to hold the forward shipping Core Packaging Codes list of Core Pack codes defined in the Logistics Common Master component	No
RTMCN_FWSH_SPARES_BY	_varchar_25	Varchar(25)	Yes	This field is to hold the forward Shipping Spares By list of Shipping Method codes defined in the Logistics Common Master component	No
RTMCN_PAY_TERM	_varchar_25	Varchar(25)	No	This field is to hold the Pay term code defined int he Payterm component for repair order component	No
RTMCN_PAY_MODE	_varchar_5	varchar(5)	Yes	This field is to hold the Pay Modes Allowed values are DD Demand Draft CS Cash CQ Cheque P Pay Order O Others	No
RTMCN_PAY_PRIORITY	_varchar_5	varchar(5)	Yes	This field is to hold the Pay Priority Allowed values are H High N Normal L Low	No
RTMCN_MATCHING_TYPE	_varchar_5	varchar(5)	Yes	This field is to hold the Matching Type. Allowed values are 2W Two Way 3WG Three Way at GR 3WR Three Way at RO 4WG Four Way at GR 4WR Four Way at RO	No
RTMCN_PAY_TO_SUP_NO	_varchar_45	varchar(45)	No	This field is to hold the Pay to Supplier no Supllier no to which payment has to be made	No
RTMCN_INSUR_LIABTY	_varchar_5	varchar(5)	Yes	THis field is to hold the Insurance Liability of repair order document. Allowed vaues are SL Self SP Supplier NO None	No
RTMCN_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of repair order document	No
RTMCN_CRRT_CORE_BY	_varchar_25	Varchar(25)	No	This field is tohold the Core Return Method list of Shipping Method Codes defined in the Logistics Common Master component	No
RTMCN_CRRT_SHIP_PAYMENT	_varchar_25	Varchar(25)	No	This field is to hold Core Return Shipping Payment list of Shipping Payment method defined in the Logistics Common Master component	No
RTMCN_CRRT_PACKAGE_CODE	_varchar_25	Varchar(25)	No	This field is to hold Core return Pack code list of Packaging Codes defined in the Logistics Common Master component	No
RTMCN_CRRT_SPARES_RET	_varchar_5	varchar(5)	Yes	This field is to hold the Spares Return . Allowed values WC With Core SP Separate B Blank	No
RTMCN_CRRT_CERT_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Certificate type the Certificate types that have been created for Parts in the Logistics Common Master component	No
RTMCN_CRRT_INSPECT_TYPE	_varchar_5	varchar(5)	Yes	Thi sfield holds the Inspection type . Allowed values are S Self BI By Inspector	No
RTMCN_SPRT_SPARES_BY	_varchar_25	Varchar(25)	Yes	Thsi field holds the Return Spares By list of Shipping Method codes defined in the Logistics Common Master component	No
RTMCN_SPRT_SHIP_PAYMENT	_varchar_25	Varchar(25)	Yes	This field is to hold the Spares Return Shippping Payment list of Shipping Payment Method codes defined in the Logistics Common Master component	No
RTMCN_SPRT_PACKAGE_CODE	_varchar_25	Varchar(25)	Yes	This field is to hold Spares Return Pack code list of Packaging Codes defined in the Logistics Common Master component	No
RTMCN_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the User who enters creates the Terms and conditions details of the Repair order document into the sysstem	No
RTMCN_CREATED_DATE	_datetime_8	datetime(8)	No	This field is to hold the date on which the Terms and conditions is entered into the system	No
RTMCN_MODIFIED_BY	_varchar_30	varchar(30)	No	User who modifies the Terms and conditins details of the Repair order document in the sysstem	No
RTMCN_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is Date on which the Terms and condition is modified the latest in the system.	No
RTMCN_GTA_REFDOC_NO	_varchar_40	varchar(40)	Yes	This field holds the General Terms Agreement Referece Document no	No
RTMCN_GTA_REFDOC_DATE	_datetime_8	datetime(8)	Yes	This field holds the General Terms Agreement Referece Document Date	No
RTMCN_GTA_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks on General Terms Agreement	No
RTMCN_ADVANCE_PAYABLE	_varchar_5	varchar(5)	Yes	This field holds the Advance Payable Y Yes N No	No
RTMCN_ADVANCE_TOL_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the Advance Tolerance Percent	No
RTMCN_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the Advance Pay Date	No
RTMCN_ADVANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the Advance Percentage value	No
RTMCN_ADVANCE_PERC_ON	_varchar_5	varchar(5)	Yes	This field holds the Advance Percent on BV Basic Value TV Total Value B Blank	No
RTMCN_DDCHARGES_BORNEBY	_varchar_5	varchar(5)	Yes	This field holds the DD Charges Borne By value : SF Self RS Repair Shop	No
RTMCN_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the Inco Term	No
RTMCN_CARRIER_AGENCY	_varchar_20	varchar(20)	Yes	Carrier Agency Number in Terms and condition	No
RTMCN_PORT_OF_DESTN	_varchar_32	varchar(32)	Yes	This field holds the Port of Destination	No
RTMCN_PORT_OF_DEP	_varchar_32	varchar(32)	Yes	This field holds the Port of Departure	No
RTMCN_PACKAGING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the Packaging notes	No
RTMCN_SHIPPING_NOTES	_varchar_2000	varchar(2000)	Yes	This field holds the Shipping Notes	No
RTMCN_ADV_PAY_AMT	_decimal_28_8	decimal(28)	Yes	This field holds the Advance Payable amount	No
RTMCN_PAYTOSUP_ADDR_ID	UDD_TXT60	varchar(60)	Yes	This field holds the Pay to Supplier Address Id	No
RTMCN_Unwar	udd_flag1	varchar(25)	Yes	This field store the under warranty value for the parts.	No
RTMCN_Warbasis	udd_flag1	varchar(25)	Yes	This field store the warranty basis value for the parts.	No
RTMCN_WarBegin	udd_designparamcode	varchar(5)	Yes	This field store the warranty begins on value.	No
RTMCN_WarDur	udd_duration	numeric(13)	Yes	This field store the warranty duration value.	No
RTMCN_WarDurUnit	udd_designparamcode	varchar(5)	Yes	This field store the warranty duration units value.	No
RTMCN_War_FH	udd_duration	numeric(13)	Yes	This field will store the Flight Hours values.	No
RTMCN_War_FC	udd_duration	numeric(13)	Yes	This field will store the Flight Cycles values.	No
RTMCN_WarRefAgr	udd_documentno	varchar(40)	Yes	This field will store the warranty reference agreement value.	No
RTMCN_War_TermRef	udd_notes	varchar(2000)	Yes	This field will store the Terms and References value.	No
RTMCN_RMA_NO	udd_txt20	varchar(20)	Yes	This column holds the RMA no	No
RTMCN_RMA_DATE	udd_time	datetime(8)	Yes	This column holds the RMA Date value	No
RTMCN_SHIPTO_AddID	UDD_TXT60	varchar(60)	Yes	This column holds the Ship to address ID value	No
RTMCN_DELIVERTOCODE	udd_documentno	varchar(40)	Yes	This fields hold the delivary code	No

Table Name :	REP_RWSCAD_WORK_SCOPE_DTL
Comment :	Work Unit Details of the Repair Orderno / Amendment no

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RWSCAD_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance for amended repair order documents	Yes
RWSCAD_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number for amended repair order documents	Yes
RWSCAD_RO_AMEND_NO	_decimal_10_0	decimal(10)	No	This field is to capture the Repair Order Amendment Number for amended repair order documents	Yes
RWSCDT_WORK_SCOPE_ID	_decimal_10_0	decimal(10)	No	THis field is to capture the work scope id	Yes
RWSCAD_REPAIR_PROCESS_NO	_varchar_25	Varchar(25)	No	This field is to capture the Repair Process Number From Logistics Common Master for amended repair order documents	No
RWSCAD_MAINTENANCE_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Maintenance TYpe of the WOrk Units for amended repair order documents	No
RWSCAD_WORK_UNIT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the WorkUnit OUInstance with which repairorder is interacting Can be a Task OU or BASCMP ComponentMaintenancePlanning OU for amended repair order documents	No
RWSCAD_WORK_UNIT_NO	_varchar_30	varchar(30)	No	Thsi field is to capture the Work Unit Number Can be a Task , Stored Procedure or Work Package for amended repair order documents	No
RWSCAD_WKUT_REVNO	_varchar_40	varchar(40)	Yes	Workunit Revision No.	No
RWSCAD_REF_DOCUMENT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Reference Document OU FROM CMPLAN OU as it is stored for that workunits of the Component id for amended repair order documents	No
RWSCAD_REF_DOCUMENT_NO	_varchar_40	varchar(40)	Yes	This field is to hold the Reference Document no FROM CMPLAN OU as it is stored for that workunits of the Component id for amended repair order documents	No
RWSCAD_REF_DOCUMENT_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Reference Document Type FROM CMPLAN OU as it is stored for that workunits of the Component id for amended repair order documents	No
RWSCAD_WORK_UNIT_TYPE	_varchar_5	varchar(5)	No	THis field holds the Work Unit Type FROM CMPLAN OU as it is stored for that workunits of the Component id Can be T Task W Work Package P Standard Procedure for amended repair order documents	No
RWSCAD_COMMENTS	_varchar_255	varchar(255)	Yes	This field is to hold any Comments about the Workunit details for amended repair order documents	No
RWSCAD_MODEOF_ATTACH_FLAG	_char_1	char(1)	Yes	Mode of Attachment Flag	No
RWSCAD_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold the user who created the record for amended repair order documents	No
RWSCAD_CREATED_DATE	_datetime_8	datetime(8)	No	This field is to capture the Created date of the record for amended repair order documents	No
RWSCAD_MODIFIED_BY	_varchar_30	varchar(30)	No	This fieldis to hold the user who modified the record. for amended repair order documents	No
RWSCAD_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is to hold the modified date of the record for amended repair order documents	No
RWSCAD_REF_REVISION_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
RWSCAD_REF_MOD_PARTNO	_varchar_40	varchar(40)	Yes	Part Number	No
RWSCAD_REF_MOD_STATUS	_varchar_20	varchar(20)	Yes	Status	No
RWSCAD_SCHEDULE_DATE	udd_time	datetime(8)	Yes	This column holds the schedule date value	No
RWSCAD_PartNo	udd_partno	varchar(40)	Yes	This Field stores the part no details.	No
RWSCAD_SerialNo	udd_partserialnumber	varchar(40)	Yes	This Field stores the serial no details of the part.	No
RWSCAD_EngDocNo	udd_document	varchar(20)	Yes	This Field stores the Engineering document no details.	No
RWSCAD_EngDoc_RevNo	udd_document	varchar(20)	Yes	This Field stores the Engineering document Revision no details.	No
RWSCAD_RelationType	udd_designparamcode	varchar(5)	Yes	This Field stores the relationship of between the task and the related task.	No
RWSCAD_ParentTaskNo	udd_documentno	varchar(40)	Yes	The fields refers to parent task no details of the given child task.	No
RWSCAD_RootTask	udd_documentno	varchar(40)	Yes	The fields refers to root task no details of the given child task.	No
RWSCAD_COMPONENT_ID	udd_componentid	varchar(90)	Yes	This field corresponds to the Componenet id details for the given part	No
RWSCAD_COMPONENT_OU	udd_ctxt_ouinstance	int(4)	Yes	This field corresponds to the Componenet Ou for the respective Componenet id details.	No
RWSCAD_RO_COMPL_FLAG	udd_designparamcode	varchar(5)	Yes	this Indicates whether compliance has been updated at repair receipt after amendment	No
RWSCAD_RO_INST_ID	udd_seqno	int(4)	Yes	This Column holds the Instance ID for the Particular Task for complinace after amendment	No

Table Name :	REP_RWSCDT_WORK_SCOPE_DTL
Comment :	This table is to hold Work Unit Details of the Repair Orderno

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RWSCDT_RO_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field is to capture the repair order OUInstance	Yes
RWSCDT_RO_NO	_varchar_40	varchar(40)	No	This field is to capture the Repair Order Number	Yes
RWSCDT_WORK_SCOPE_ID	_decimal_10_0	decimal(10)	No	THis field is to capture the work scope id	Yes
RWSCDT_REPAIR_PROCESS_NO	_varchar_25	Varchar(25)	No	This field is to capture the Repair Process Number From Logistics Common Master	No
RWSCDT_MAINTENANCE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Maintenance TYpe of the WOrk Units	No
RWSCDT_WORK_UNIT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the WorkUnit OUInstance with which repairorder is interacting Can be a Task OU or BASCMP ComponentMaintenancePlanning OU	No
RWSCDT_WORK_UNIT_NO	_varchar_30	varchar(30)	No	Thsi field is to capture the Work Unit Number Can be a Task , Stored Procedure or Work Package	No
RWSCDT_WKUT_REVNO	_varchar_40	varchar(40)	Yes	This field holds the WorkUnit Revision Number	No
RWSCDT_REF_DOCUMENT_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Reference Document OU FROM CMPLAN OU as it is stored for that workunits of the Component id	No
RWSCDT_REF_DOCUMENT_NO	_varchar_40	varchar(40)	Yes	This field is to hold the Reference Document no FROM CMPLAN OU as it is stored for that workunits of the Component id	No
RWSCDT_REF_DOCUMENT_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Reference Document Type FROM CMPLAN OU as it is stored for that workunits of the Component id	No
RWSCDT_WORK_UNIT_TYPE	_varchar_5	varchar(5)	No	THis field holds the Work Unit Type FROM CMPLAN OU as it is stored for that workunits of the Component id Can be T Task W Work Package P Standard Procedure	No
RWSCDT_COMMENTS	_varchar_255	varchar(255)	Yes	This field is to hold any Comments about the Workunit details	No
RWSCDT_MODEOF_ATTACH_FLAG	_char_1	char(1)	Yes	This flag is used to recognize if the Workunits were added manually or defaulted from component maintenance planning.	No
RWSCDT_CREATED_BY	_varchar_30	varchar(30)	No	This field is to hold the user who created the record	No
RWSCDT_CREATED_DATE	_datetime_8	datetime(8)	No	This field is to capture the Created date of the record	No
RWSCDT_MODIFIED_BY	_varchar_30	varchar(30)	No	This fieldis to hold the user who modified the record.	No
RWSCDT_MODIFIED_DATE	_datetime_8	datetime(8)	No	This field is to hold the modified date of the record	No
RWSCDT_REF_REVISION_NO	_varchar_40	varchar(40)	Yes	This field holds the Revision Number	No
RWSCDT_REF_MOD_PARTNO	_varchar_40	varchar(40)	Yes	This field holds the Part Number	No
RWSCDT_REF_MOD_STATUS	_varchar_20	varchar(20)	Yes	This field holds the Status	No
RWSCDT_INSPWO	_varchar_5	varchar(5)	Yes	This field holds the Inspection workorder	No
RWSCDT_SCHEDULE_DATE	udd_time	datetime(8)	Yes	This column holds the schedule date value	No
RWSCDT_PERPETUAL_FLG	udd_designparamcode	varchar(5)	Yes	This column holds the perpetual status	No
RWSCDT_SOURCE_WORKUNIT	udd_taskcode	varchar(30)	Yes	This column holds the source tast code	No
RWScDt_PartNo	udd_partno	varchar(40)	Yes	This Field stores the part no details.	No
RWScDt_SerialNo	udd_partserialnumber	varchar(40)	Yes	This Field stores the serial no details of the part.	No
RWScDt_EngDocNo	udd_document	varchar(20)	Yes	This Field stores the Engineering document no details.	No
RWScDt_EngDoc_RevNo	udd_document	varchar(20)	Yes	This Field stores the Engineering document Revision no details.	No
RWScDt_RelationType	udd_designparamcode	varchar(5)	Yes	This Field stores the relationship of between the task and the related task.	No
RWScDt_ParentTaskNo	udd_documentno	varchar(40)	Yes	The fields refers to parent task no details of the given child task.	No
RWScDt_RootTask	udd_documentno	varchar(40)	Yes	The fields refers to root task no details of the given child task.	No
RWSCDT_COMPONENT_ID	udd_componentid	varchar(90)	Yes	This field corresponds to the Componenet id details for the given part	No
RWSCDT_COMPONENT_OU	udd_ctxt_ouinstance	int(4)	Yes	This field corresponds to the Componenet Ou for the respective Componenet id details.	No
RWSCDT_Core_ID	udd_seqno	int(4)	Yes	This column holds the Work scope unique ID specific to the Task level	No
RWSCDT_CR_key_Seqno	udd_seqno	int(4)	Yes	This colums holds the Instant ID for the task	No
RWSCDT_RO_COMPL_FLAG	udd_designparamcode	varchar(5)	Yes	this Indicates whether compliance has been updated at repair receipt	No
RWSCDT_RO_INST_ID	udd_seqno	int(4)	Yes	This Column holds the Instance ID for the Particular Task for complinace	No