Repair Order

Repair Order
Table Name Rep_RAAcDt_Rec_Ack_Dtl
Table Comment This field is to hold the acknowledgement Details for the Repair Order / Amendment Number
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAAcDt_Ack_Receipt_Status	varchar(5)	NULL	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	No
RAAcDt_Ack_Comments	varchar(255)	NULL	This field is to hold the comments for the Acknowledgement (for amended repair orders)	No	No
RAAcDt_Ack_Ship_Note_No	varchar(40)	NULL	This field is to hold the Shipping Note of repair order (for amended repair orders)	No	No
RAAcDt_Ack_Date	datetime	NOT NULL	This field is to hold the Acknowledgment Date of repair order (for amended repair orders)	No	No
RAAcDt_Modified_By	varchar(30)	NOT NULL	This field is to hold the User Who modified the Repair Order (for amended repair orders)	No	No
RAAcDt_Created_By	varchar(30)	NOT NULL	This field is to hold the user who created the record (for amended repair orders)	No	No
RAAcDt_Created_Date	datetime	NOT NULL	This field is to hold the Date on which the Repair Order Number was Created (for amended repair orders)	No	No
RAAcDt_Modified_Date	datetime	NOT NULL	This field is to hold the Last Date on which the Repair Order got Modified. (for amended repair orders)	No	No
RAAcDt_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number (for amended repair orders)	Yes	Yes
RAAcDt_RO_Amend_No	numeric(10)	NOT NULL	This table is to capture the Amendment Number of Repair Order. (for amended repair orders)	Yes	Yes
RAAcDt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair orders)	Yes	Yes
RAAcDt_Ack_Recd_Serial_No	varchar(40)	NOT NULL	This table is to hold the received serial number of repair order (for amended repair orders)	No	No
RAAcDt_Ack_Recd_Part_No	varchar(40)	NOT NULL	This table is to hold the Received Part Number of repair order (for amended repair orders)	No	No
RAAcDt_Ack_Id	numeric(10)	NOT NULL	This table is to hold the Acknowledgement Number of The Repair Order. (for amended repair orders)	Yes	No
RAAcDt_Ack_Ref_No	varchar(40)	NOT NULL	This field is to hold the Acknowledgement Reference Number of the Repair Order. (for amended repair orders)	No	No

Table Name Rep_RAcDt_Rec_Ack_Dtl

Table Comment This table is to hold Acknowledgement Details for the Repair Order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAcDt_Ack_Comments	varchar(255)	NULL	This field holds the Comments for the Repair Order Acknowledgement	No	No
RAcDt_Ack_Receipt_Status	varchar(5)	NULL	This field hold the Receipt Status for the Repair Order for acknowledgement. Allowed values are Y-Yes N-No	No	No
RAcDt_Ack_Ship_Note_No	varchar(40)	NULL	This field holds the Shipping Note of the Repair Order Number for acknowledgement	No	No
RAcDt_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record	No	No
RAcDt_Created_By	varchar(30)	NOT NULL	This field holds the User Who has created the Repair Order Number.	No	No
RAcDt_Created_Date	datetime	NOT NULL	This field holds the Date on which the Repair Order Number was Created.	No	No
RAcDt_Modified_Date	datetime	NOT NULL	This field holds the Last Date on which the Repair Order Number got Modified.	No	No
RAcDt_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order Number	Yes	Yes
RAcDt_Ack_Id	numeric(10)	NOT NULL	This field is to hold The Acknowledgement id	Yes	No
RAcDt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RAcDt_Ack_Date	datetime	NOT NULL	This field holds the Acknowledgement Date	No	No
RAcDt_Ack_Recd_Serial_No	varchar(40)	NOT NULL	This field holds the Received Serial Number for acknowledgement	No	No
RAcDt_Ack_Ref_No	varchar(40)	NOT NULL	This field is to hold the Acknowledgement Reference Number	No	No
RAcDt_Ack_Recd_Part_No	varchar(40)	NOT NULL	This field holds the Received Part Number for acknowledgement	No	No

Table Name Rep_RACPmD_Comp_Param_Dtl

Table Comment This table is to hold life Parameter Details for the Repair Order -Amendment Numbers .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RACPmD_Since_Shop_Visit	numeric(28,8)	NULL	This field holds the Since Shop Visit Parameter value (for amended repair order documents)	No	No
RACPmD_Since_Inspect	numeric(28,8)	NULL	This field holds the Since Inspect parameter value (for amended repair order documents)	No	No
RACPmD_Since_Repair	numeric(28,8)	NULL	This field holds the Since Repair Parameter value (for amended repair order documents)	No	No
RACPmD_Since_Overhaul	numeric(28,8)	NULL	This field holds the Since Overhaul Parameter value (for amended repair order documents)	No	No
RACPmD_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record. (for amended repair order documents)	No	No
RACPmD_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record (for amended repair order documents)	No	No
RACPmD_Created_Date	datetime	NOT NULL	This field holds the Created Date of the record (for amended repair order documents)	No	No
RACPmD_Modified_Date	datetime	NOT NULL	This field holds the date on which the record is modified (for amended repair order documents)	No	No
RACPmD_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order number (for amended repair order documents)	Yes	Yes
RACPmD_RO_Amend_No	numeric(10)	NOT NULL	This field holds the Repair Order Amendment # (for amended repair order documents)	Yes	Yes
RACPmD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RACPmD_Since_New	numeric(28,8)	NULL	This field holds the Since New Parameter value (for amended repair order documents)	No	No
RACPmD_UOM	varchar(10)	NULL	This field holds the Parameter UOM (Unit of measurement) (for amended repair order documents)	No	No
RACPmD_Param_Line_Id	numeric(10)	NOT NULL	This field holds the uniquely generated param line id (for amended repair order documents)	Yes	No
RACPmD_Ac_Param_Code	varchar(40)	NOT NULL	This field holds the Aircraft Parameter Code (for amended repair order documents)	No	No

Table Name Rep_RADD_Discrepancy_Dtl

Table Comment This field is to hold the discrepancy Details for the Repair Order -Amendment Numbers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RADD_Modified_Date	datetime	NOT NULL	This field holds the date on which the record gets modified (for amended repair order documents)	No	No
RADD_Modified_By	varchar(30)	NOT NULL	This field is to hold the User who Modified the Discrepancy info. (for amended repair order documents)	No	No
RADD_Created_Date	datetime	NOT NULL	This field is to hold the Date on which the Discrepancy was created (for amended repair order documents)	No	No
RADD_RO_ATANO	varchar(30)	NULL	ATA Number	No	No
RADD_RO_DISC_DESC	varchar(255)	NULL	This field holds the Discrepancy Description	No	No
RADD_RO_DEF_FLAG	varchar(5)	NULL	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	No
RADD_RO_MAINTREP	varchar(255)	NULL	This field holds the number identifying the maintenance report corresponding to the discrepancy
RADD_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order number (for amended repair order documents)	Yes	Yes
RADD_RO_Amend_No	numeric(10)	NOT NULL	This field is to hold the Amendment Number of Repair Order (for amended repair order documents)	Yes	Yes
RADD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RADD_Created_By	varchar(30)	NOT NULL	This field is to hold the User who created the Discrepancy info (for amended repair order documents)	No	No
RADD_RO_Discy_Comments	varchar(255)	NULL	This field is to hold the Discrepancy Comments (for amended repair order documents)	No	No
RADD_RO_Discy_No	varchar(40)	NOT NULL	This field is to hold the Discrepancy Number of repair order (for amended repair order documents)	Yes	No
RADD_RO_Discy	varchar(5)	NOT NULL	This field is to hold the Discrepancies Reported - Allowed values are ’FC’ - ’Fully Confirmed’ ’PC’ - ’Partially Confirmed’ ’NF’ - ’No Fault Found’ (for amended repair order documents)	No	No
RADD_RO_PARTNO	varchar(40)	NULL	This Field stores the part no details.	No	No
RADD_RO_SERIALNO	varchar(40)	NULL	This Field stores the serial no details of the part.	No	No

Table Name Rep_RADoT_Doc_TCD_dtl

Table Comment This field is to hold the Document Tcd Details for the Repair Order /Amendment Number
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RADOT_USER_SEQ#	numeric(10)	NULL	This field holds the User Seq # which is manually entered by the user	No	No
RADoT_exchg_rate	numeric(28,8)	NULL	Holds the exchange rate between the document currency and the payment currency	No	No
RADoT_Account_Type	varchar(5)	NULL	stores the account type	No	No
RADOT_TCD_PAYMT_CURRENCY	varchar(20)	NULL	This field holds the Payment Currency	No	No
RADoT_Modified_Date	datetime	NOT NULL	This field holds The Last Date on which the Repair Order Got Modified. (for amended repair order documents)	No	No
RADoT_Modified_By	varchar(30)	NOT NULL	The user who has last modified the Tcd details. (for amended repair order documents)	No	No
RADoT_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RADoT_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RADoT_Account_Code	varchar(32)	NULL	stores the account code	No	No
RADoT_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RADoT_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RADoT_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RADOT_CST_CENTER	varchar(10)	NULL	stores the cost center for the given account code	No	No
RADoT_RO_Amend_No	numeric(10)	NOT NULL	This field holds the Amendment Number For The Repair Order	Yes	Yes
RADoT_TCD_Line_Id	numeric(10)	NOT NULL	This field holds the TCD line id (for amended repair order documents)	Yes	No
RADoT_TCD_OU	numeric(10)	NOT NULL	This field holds the Tcd Ouinstance in which the Tcd got Created. (for amended repair order documents)	No	No
RADoT_RO_No	varchar(40)	NOT NULL	This field holds the Repair Order Document number (for amended repair order documents)	Yes	Yes
RADoT_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RADoT_Created_Date	datetime	NOT NULL	This field holds the created date of the record (for amended repair order documents)	No	No
RADoT_Pay_to_Supplier_No	varchar(45)	NULL	This field holds the pay to supplier number (for amended repair order documents)	No	No
RADoT_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record (for amended repair order documents)	No	No
RADoT_TCD_Code	varchar(25)	NOT NULL	This field holds the Tcd Code from TCD component (for amended repair order documents)	No	No
RADoT_TCD_Variant_Code	varchar(25)	NOT NULL	This field holds the Tcd variant Code from TCD component (for amended repair order documents)	No	No
RADoT_TCD_Amount	numeric(28,8)	NULL	This field holds the Calculated Tcd Amount from Tcd Master. (for amended repair order documents)	No	No
RADoT_TCD_Rate	numeric(28,8)	NULL	This field holds the Tcd rate from TCD component (for amended repair order documents)	No	No

Table Name Rep_RALTD_Labour_TCD_Dtl

Table Comment This field is to hold the Labour Tcd Details for the Repair Order-Amendment Numbers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RALTD_USER_SEQ#	numeric(10)	NULL	This field holds the User Seq#	No	No
RALTD_exchg_rate	numeric(28,8)	NOT NULL	Holds the exchange rate between the document currency and the payment currency	No	No
RALTD_Account_Type	varchar(5)	NULL	stores the account type	No	No
RALTD_TCD_PAYMT_CURRENCY	varchar(20)	NULL	This field holds the Payment Currency	No	No
RALTD_Modified_Date	datetime	NOT NULL	This field holds the Last Date on which the record got Modified. (for amended repair order documents)	No	No
RALTD_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record (for amended repair order documents)	No	No
RALTD_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RALTD_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RALTD_Account_Code	varchar(32)	NULL	stores the account code	No	No
RALTD_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RALTD_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RALTD_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RALTD_CST_CENTER	varchar(10)	NULL	stores the cost center for the given account code	No	No
RALTD_Quote_Id	numeric(10)	NOT NULL	This field is to hold the Quotation Id of Repair Order. (for amended repair order documents)	Yes	Yes
RALTD_RO_Amend_No	numeric(10)	NOT NULL	This field is to hold the Amendment Number of the Repair Order. (for amended repair order documents)	Yes	Yes
RALTD_TCD_OU	numeric(10)	NOT NULL	This field is to capture the Tcd Ouinstance (for amended repair order documents)	No	No
RALTD_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order numbers (for amended repair order documents)	Yes	Yes
RALTD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RALTD_Created_Date	datetime	NOT NULL	This field holds the date on which the record gets created (for amended repair order documents)	No	No
RALTD_Pay_to_Supplier_No	varchar(45)	NULL	This field is to capture the pay to supplier of repair order (for amended repair order documents)	No	No
RALTD_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record (for amended repair order documents)	No	No
RALTD_TCD_Code	varchar(25)	NOT NULL	This field is to capture the Tcd Code from TCD component (for amended repair order documents)	No	No
RALTD_TCD_Variant_Code	varchar(25)	NOT NULL	this field is to capture the TCD variant code from the repair order (for amended repair order documents)	No	No
RALTD_TCD_Amount	numeric(28,8)	NULL	This field is to capture the TCD amount of repair order (for amended repair order documents)	No	No
RALTD_TCD_Rate	numeric(28,8)	NULL	This field is to capture the Tcd Rate of TCD component (for amended repair order documents)	No	No

Table Name Rep_RAMCDt_Matl_Cost_Dtl

Table Comment Material cost Detail for the Repair Order /Amendment #
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAMCDt_Part_Unit_Rate	numeric(28,8)	NULL	This field is to capture the Unit Rate for the Parts (for amended repair order documents)	No	No
RAMCDt_Total_TCD_Cost	numeric(28,8)	NULL	This field is to capture The Total Tcd Cost Calculated for The Tcds. (for amended repair order documents)	No	No
RAMCDt_Part_Uom	varchar(10)	NULL	This field is to capture the Part UOM (for amended repair order documents)	No	No
RAMCDt_Part_Qty	numeric(28,8)	NOT NULL	This field is to capture the Part Quantity (for amended repair order documents)	No	No
RAMCDt_Modified_By	varchar(30)	NOT NULL	This field holds the Last User who has Modified the Repair Order. (for amended repair order documents)	No	No
RAMCDt_Created_By	varchar(30)	NOT NULL	This field is to capture the User who has Created the Material cost info (for amended repair order documents)	No	No
RAMCDt_Created_Date	datetime	NOT NULL	This field holds the Date on which the Material cost info got Created (for amended repair order documents)	No	No
RAMCDt_Modified_Date	datetime	NOT NULL	This field holds the modified date on which the Repair Order Number got Modified. (for amended repair order documents)	No	No
RAMCDt_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number (for amended repair order documents)	Yes	Yes
RAMCDt_RO_Amend_No	numeric(10)	NOT NULL	This field is to capture the repair order Amendment Number (for amended repair order documents)	Yes	Yes
RAMCDt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RAMCDt_Part_Desc	varchar(80)	NULL	This field is to capture the Part Description for the Parts (for amended repair order documents)	No	No
RAMCDt_Matl_Line_No	varchar(30)	NOT NULL	This field is to capture the Material Line Id for the Parts. (for amended repair order documents)	No	No
RAMCDt_Matl_Line_Id	numeric(10)	NOT NULL	This field is to capture Material Line Id for the Parts. (for amended repair order documents)	Yes	No
RAMCDt_Manuf_Part_No	varchar(40)	NOT NULL	This field is to capture the manufacturer Part Number (for amended repair order documents)	No	No
RAMCDt_Quote_Id	numeric(10)	NOT NULL	This field is to capture the Quotation Id for the Repair Order Number (for amended repair order documents)	Yes	Yes

Table Name Rep_RAMTcd_Mat_TCD_dtl

Table Comment This field is to hold the Material Tcd Details for Each Material of the Repair Order - Amendment Numbers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAMTCD_USER_SEQ#	numeric(10)	NULL	This field holds the User Seq#	No	No
RAMTcd_exchg_rate	numeric(28,8)	NULL	Holds the exchange rate between the document currency and the payment currency	No	No
RAMTcd_Account_Type	varchar(5)	NULL	stores the account type	No	No
RAMTcd_Modified_By	varchar(30)	NOT NULL	This field holds the User who Modified the Repair Order (for amended repair order documents)	No	No
RAMTCD_TCD_PAYMT_CURRENCY	varchar(20)	NULL	This field holds the Payment Currency	No	No
RAMTcd_Modified_Date	datetime	NULL	This field holds the date on which the record got modified (for amended repair order documents)	No	No
RAMTcd_Created_Date	datetime	NULL	This field holds the date on which the Repair Order Number was Created. (for amended repair order documents)	No	No
RAMTcd_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RAMTcd_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RAMTcd_Account_Code	varchar(32)	NULL	stores the account code	No	No
RAMTcd_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RAMTcd_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RAMTcd_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RAMTCD_CST_CENTER	varchar(10)	NULL	stores the cost center for the given account code	No	No
RAMTcd_Matl_Line_Id	numeric(10)	NOT NULL	This field is to capture the Material Line Id for the repair Parts (for amended repair order documents)	Yes	Yes
RAMTcd_Quote_Id	numeric(10)	NOT NULL	This field is to capture the Quotation Id of the Repair Order Number. (for amended repair order documents)	Yes	Yes
RAMTcd_TCD_Line_Id	numeric(10)	NOT NULL	This field is to hold the TCD line id (for amended repair order documents)	Yes	No
RAMTcd_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RAMTcd_RO_Amend_No	numeric(10)	NOT NULL	This field is to capture the Amendment Number of the Repair Order (for amended repair order documents)	Yes	Yes
RAMTcd_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number (for amended repair order documents)	Yes	Yes
RAMTcd_Created_By	varchar(30)	NOT NULL	THis field holds the user who created the record (for amended repair order documents)	No	No
RAMTcd_TCD_Amount	numeric(28,8)	NULL	This field holds the Tcd Amount calculated from Tcd Component. (for amended repair order documents)	No	No
RAMTcd_Pay_to_Supplier_No	varchar(45)	NULL	This field holds the pay to supplier no of repair order (for amended repair order documents)	No	No
RAMTcd_TCD_OU	numeric(10)	NOT NULL	This field is to hold the Tcd OuInstance in which the Tcd code was Created (for amended repair order documents)	No	No
RAMTcd_TCD_Code	varchar(25)	NOT NULL	This field holds the Tcd Code from tcd Component. (for amended repair order documents)	No	No
RAMTcd_TCD_Rate	numeric(28,8)	NULL	This field holds the Tcd Rate from TCD component (for amended repair order documents)	No	No
RAMTcd_TCD_Variant_Code	varchar(25)	NOT NULL	This field holds the Tcd Variant Code from Tcd Component (for amended repair order documents)	No	No

Table Name Rep_RAPrt_PiecePart_Dtl

Table Comment This table is to hold Piece part information for the Repair Order -Amendment Numbers .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAPrt_Line_status	char(18)	NULL	This column holds the line level status of the each part no # values CL - closed OP - open BC - BER closed	No	No
RAPrt_GR_Rec_Partno	char(18)	NULL	This field holds the received repair part no of amended repair order documents	No	No
RAPrt_GR_Rec_Serialno	char(18)	NULL	This field holds the Received Serial number of amended repair order documents	No	No
RAPrt_Rec_Qty	char(18)	NULL	This column holds the value of received quantity of this line, which defined in Repair receipt	No	No
RAPrt_BER_Qty	char(18)	NULL	This column holds the value BER Quantity, which is defined in record quotation	No	No
RAPrt_Remarks	char(255)	NULL	This field holds the remarks	No	No
RAPrt_Salvage_Value	numeric(28,8)	NULL	This field holds the salvage value of the part.	No	No
RAPrt_Pending_Qty	char(18)	NULL	It holds the value of pending quantity	No	No
RAPrt_COMPONENT_ID	char(18)	NULL	If part number and serial number is of type component then the component id is stored here	No	No
RAPrt_ACCOMPONENT_OU	char(18)	NULL	If part number and serial number is of type component then the Ou for that component is stored here	No	No
RAPrt_Salvage_Action	char(5)	NULL	This field holds the salvage action of the part.	No	No
RAPrt_BER_Cost	numeric	NULL	This field holds the beyond repair cost of the part.	No	No
RAPRT_COST_DIFF	numeric(28,8)	NULL	This field hold the cost difference of the part after amendment	No	No
RAPrt_RO_Amend_No	numeric(10)	NOT NULL	This field is to capture the Amendment Number for the Repair order document	Yes	Yes
RAPrt_Line_no	char(30)	NOT NULL	THis field is to capture the part line no	Yes	No
ROPrt_Part_Cr_OU	int	NULL	This field holds the part Organization unit of the part	No	No
RAPrt_RO_Ouinstance	decimal(10)	NOT NULL		Yes	No
RAPrt_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair order Number	Yes	Yes
ROAH_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the amended repair orders’ OUInstance	Yes	Yes
RAPrt_Work_Request	char(255)	NULL	This field holds the work requested for the piece part	No	No
RAPrt_Stock_Status	char(5)	NULL	This field holds the piece part stock status	No	No
RAPrt_Cost	int	NULL	This field holds the cost of the piece part	No	No
RAPrt_Part_No	char(40)	NULL	This field holds the repair order piece part number	No	No
RAPrt_Quantity	numeric	NULL	This field holds the piece part quantity	No	No
RAPrt_Lot_No	char(18)	NULL	This field holds the repair order piece part lot number	No	No
RAPrt_Serial_No	char(40)	NULL	This field holds the repair order piece part serial number	No	No
RAPrt_NRTN_Cost	numeric(13,28)	NULL	This field holds the non returnable cost values	No	No

Table Name Rep_RAQuD_Quote_Dtl

Table Comment This field is to hold the Quotation Details for the Repair Order -Amendment Numbers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RAQuD_Quote_Ld_Time_Unit	varchar(5)	NULL	This field holds the Quotation Lead time unit Allowed values are D - Days W - Weeks M - Months (for amended repair order documents)	No	No
RAQuD_Quote_Amt_Hld_Time	decimal(28,8)	NULL	This field holds the Price Held Firm time -- THe Price valid time --from the Quotation date into consideration (for amended repair order documents)	No	No
RAQuD_BER_Cost	numeric(28,8)	NULL	This field holds the Beyond Repair -- Analysis Cost (for amended repair order documents)	No	No
RAQuD_Quote_Remarks	varchar(255)	NULL	This field holds Any Remarks -- entered by the Supplier regarding the Quotation (for amended repair order documents)	No	No
RAQuD_Salvage_At	varchar(5)	NULL	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	No
RAQuD_Total_Doc_TCD	numeric(28,8)	NULL	This field is to capture the Total Document TCD Cost (for amended repair order documents)	No	No
RAQuD_Exchange_Rate	numeric(28,8)	NULL	This field is to capture Exchange Rate -- Between the Base currency and the Quotation Suppler Currency (for amended repair order documents)	No	No
RAQuD_Quote_Misc_Cost	numeric(28,8)	NULL	This field is to capture the Quotation Miscellaneous cost (for amended repair order documents)	No	No
RAQuD_Exchange_Rate_OU	numeric(10)	NULL	This field is to capture the Exchange Rate OU -- ESetup Component OU . (for amended repair order documents)	No	No
RAQuD_Total_Matl_Cost	numeric(28,8)	NULL	This field holds the Total Material cost -- Total Material Cost + Total Material TCD Cost (for amended repair order documents)	No	No
RAQUD_QUOT_TOTALREP_COST	numeric(28,8)	NULL	This field holds the Total Repair Cost	No	No
RAQUD_SAL_SALVAGE_VALUE	numeric(28,8)	NULL	This field holds the Estimated Scrap value	No	No
RAQUD_COMP_LIST_PRICE	numeric(28,8)	NULL	This field holds the Component List Price	No	No
RAQUD_TOTAL_COST	numeric(28,8)	NULL	This field holds the Total Cost for the RO# Quote	No	No
RAQuD_Created_By	varchar(30)	NOT NULL	This field holds the User who entered the Quotation into the system (for amended repair order documents)	No	No
RAQuD_Created_Date	datetime	NOT NULL	This field holds the Date on which the QUotation is entered into the system (for amended repair order documents)	No	No
RAQUD_QUOT_EXCHANGE_FEE	numeric(28,8)	NULL	This field holds the Exchange Fee	No	No
RAQuD_Modified_By	varchar(30)	NOT NULL	This field holds the User who modified the QUotation in the system (for amended repair order documents)	No	No
RAQuD_Modified_Date	datetime	NOT NULL	This field is to hold the Date on which the QUotation is last modified (for amended repair order documents)	No	No
RAQuD_Filename	sql_variant	NULL	This field holds the File name for RO quotation	No	No
RAQuD_Sup_Con_Discrepancy	varchar(5)	NULL	This field is to capture the Confirm Discrepancies -- confirmed by the Supplier allowed values are ’FC’ -- ’Fully Confirmed’ ’PC’ -- ’Partially Confirmed’ ’NF’ -- ’No Fault Found’ (for amended repair order documents)	No	No
RAQUD_RO_USER_STATUS	varchar(25)	NULL	Holds the user entered status for a repair order	No	No
RAQuD_Sup_Add_Discrepancy	varchar(5)	NULL	This field is to capture the Additional Discrepancies Detected Allowed values are Y -- Yes N -- No (for amended repair order documents)	No	No
RAQuD_Sup_Add_Problems	varchar(255)	NULL	This field is to capture the Additional Problems Descriptions. (for amended repair order documents)	No	No
RAQuD_Sup_Comments	varchar(255)	NULL	This field is to capture any Comment from the Supplier (for amended repair order documents)	No	No
RAQuD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RAQuD_RO_Amend_No	numeric(10)	NOT NULL	The Amendment Number for the Repair order (Running Serial Number) (for amended repair order documents)	Yes	Yes
RAQuD_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number	Yes	Yes
RAQuD_Quote_Id	numeric(10)	NOT NULL	This field is to capture the Quote ID -- Running Serial # --for the RO# (for amended repair order documents)	Yes	No
RAQuD_Quote_Matl_Cost	numeric(28,8)	NULL	This field holds the Material cost -- sum(Material cost) for all of the materials used for the Quotation. (for amended repair order documents)	No	No
RAQuD_Quote_Labour_Cost	numeric(28,8)	NULL	This field holds the quoted Labour Cost (for amended repair order documents)	No	No
RAQuD_Quote_Cost_Man_Hr	numeric(28,8)	NULL	This field holds the quoted Cost Per Man Hour (for amended repair order documents)	No	No
RAQuD_Total_Lab_TCD	numeric(28,8)	NULL	This field is to hold the Total Labour TCD Cost (for amended repair order documents)	No	No
RAQuD_Total_Labour_Cost	numeric(28,8)	NULL	This field is to hold the total labour cost Total Labour cost -- Labour Cost + Total Labour TCD Cost (for amended repair order documents)	No	No
RAQuD_Quote_Ref_No	varchar(40)	NULL	This field is to capture the Quotation Reference number (for amended repair order documents)	No	No
RAQuD_Quote_Type	varchar(5)	NOT NULL	This field holds the Quotation Type -- Allowed values F -- Firm E -- Estimate (for amended repair order documents)	No	No
RAQuD_Quote_Est_Man_Hrs	numeric(28,8)	NULL	This field holds the Quoted &Estimated Man Hours (for amended repair order documents)	No	No
RAQuD_Quote_Date	datetime	NULL	This field holds the Quotation Date of the Supplier (for amended repair order documents)	No	No
RAQuD_Quote_Currency	varchar(20)	NULL	This field holds Quotation Currency of the supplier (for amended repair order documents)	No	No

Table Name Rep_RASSD_Spare_Ship_Dtl

Table Comment This field is to hold the spare Ship Details for the Repair Order-Amendment Numbers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RASSD_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record (for amended repair order documents)	No	No
RASSD_SPARE_GR_MOVED_QTY	numeric(28,8)	NULL	This field is to hold goods moved quantity of spare parts (for amended repair order documents)	No	No
RASSD_Created_Date	datetime	NOT NULL	This field holds the Date on which the Spares details is entered into the system (for amended repair order documents)	No	No
RASSD_Modified_By	varchar(30)	NOT NULL	This field holds the User who last modified the Spares details of the Repair order document into the system (for amended repair order documents)	No	No
RASSD_SPARE_RECD_PART_NO	varchar(40)	NULL	This field holds the Spares Received Part no (for amended repair order documents)	No	No
RASSD_SPARE_GR_ACCPT_QTY	numeric(28,8)	NULL	This field is to hold goods accepted quantity of spare parts (for amended repair order documents)	No	No
RASSD_SPR_STKISS_QTY_SUOM	numeric(28,8)	NULL	This field holds the Spares Stock Issue Quantity in Stock UOM (for amended repair order documents)	No	No
RASSD_SPARE_GR_RECD_QTY	numeric(28,8)	NULL	This field is to hold goods received quantity of spare parts (for amended repair order documents)	No	No
RASSD_Spare_Ret_Wh_No	varchar(10)	NULL	This field holds the Warehouse Number -- to which the spares has to be returned (for amended repair order documents)	No	No
RASSD_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RASSD_Def_Fin_Book	varchar(20)	NULL	stores the default finance book	No	No
RASSD_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RASSD_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RASSD_Modified_Date	datetime	NOT NULL	This field holds the Date on which the Spares details got modified (for amended repair order documents)	No	No
RASSD_Account_Type	varchar(5)	NULL	stores the account type	No	No
RASSD_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RASSD_Account_Code	varchar(32)	NULL	stores the account code	No	No
RASSD_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RASSD_CST_CENTER	varchar(10)	NULL	stores the cost center for the given account code	No	No
RASSD_Spare_Part_No	varchar(40)	NOT NULL	This field is to hold the Spare Requested Part Number of repair order (for amended repair order documents)	No	No
RASSD_Spare_Part_Cr_OU	numeric(10)	NOT NULL	This field is to hold Spare Part Created OU of repair order (for amended repair order documents)	No	No
RASSD_Spare_Part_Qty	numeric(28,8)	NOT NULL	This field is to hold the Spare Part Quantity requested in Repair Order UOM (for amended repair order documents)	No	No
RASSD_Spare_Part_UOM	varchar(10)	NOT NULL	This field is to hold the Spare part UOM (for amended repair order documents)	No	No
RASSD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RASSD_RO_Amend_No	numeric(10)	NOT NULL	This field is to hold the Amendment Number of the Repair Order(Running Serial Number) (for amended repair order documents)	Yes	Yes
RASSD_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair order number (for amended repair order documents)	Yes	Yes
RASSD_RO_Spares_Id	numeric(10)	NOT NULL	This field is to hold the Spares Running Serial Number (for amended repair order documents)	Yes	No
RSPSD_SPARE_RCSTKADMIN_OU	numeric(10)	NULL	This field is to hold the Stock Admin OU interacting with the GR OU (for amended repair order documents)	No	No
RASSD_Spare_Pend_Ret_Qty	numeric(28,8)	NULL	This field is to hold the Pending Quantity which has yet to be returned (for amended repair order documents)	No	No
RASSD_Spare_StkIssue_Qty	numeric(28,8)	NULL	This field is to hold the stock issue quantity (for amended repair order documents)	No	No
RASSD_Spare_Ret_Type	varchar(5)	NOT NULL	This field is to hold the Spares Return Type Allowed values are ’RT’ - ’Returnable’ ’NR’ - ’Non Returnable’ ’B’ - Blank (for amended repair order documents)	No	No
RASSD_Spare_GR_OU	numeric(10)	NULL	This field is to hold the GR OUInstance which is interacting with repair order (for amended repair order documents)	No	No
RASSD_SPARE_PART_QTY_SUOM	numeric(28,8)	NULL	This field is to hold the Spare Part Quantity Requested In Stock UOM (for amended repair order documents)	No	No
RASSD_SPARE_PART_COND	varchar(5)	NULL	This field is to hold the Spare Part Condition -- (As of now this field will be empty always) (for amended repair order documents)	No	No
RASSD_Spare_Send_Wh_No	varchar(10)	NOT NULL	This field is to hold the send Warehouse No from where the Spare part has to be issued (for amended repair order documents)	No	No
RASSD_Spare_StkMnt_OU	numeric(10)	NOT NULL	This field is to hold the Stock Maintenance OU (for amended repair order documents)	No	No
RASSD_Spare_SdStkAdmin_OU	numeric(10)	NOT NULL	This field is to hold the Stock Admin OU interacting with the Stock Maintenance OU (for amended repair order documents)	No	No
RASSD_STOCKSTATUS	varchar(25)	NULL	This field corresponds to the stock status of the part	No	No
Table Name Rep_RATmCn_Term_Cond_Info

Table Comment This table is to capture the terms and condition details of Repair Order Amendments
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RATmCn_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RATmCn_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair order Number (for amended repair order documents)	Yes	Yes
RATmCn_RO_Amend_No	numeric(10)	NOT NULL	This field is to hold amendment number of the Repair Order (for amended repair order documents)	Yes	Yes
RTMCN_SUPP_CONTACT_OU	numeric(10)	NOT NULL	This field is to hold the local interacting OU of the SUpplier with the Repair order (for amended repair order documents)	No	No
RATmCn_FwSh_Contact	varchar(80)	NOT NULL	This field is to hold the Shipping Contact Person of the Supplier (for amended repair order documents)	No	No
RATmCn_FwSh_Core_By	varchar(25)	NOT NULL	This field is to hold the Shipping Core By -- list of Shipping Method codes defined in the Logistics Common Master component (for amended repair order documents)	No	No
RATmCn_FwSh_Package_Code	varchar(25)	NOT NULL	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	No
RATmCn_FwSh_Spares_By	varchar(25)	NULL	This field is to hold the Shipping Spares By -- list of Shipping Method codes defined in the Logistics Common Master component (for amended repair order documents)	No	No
RATmCn_Pay_Term	varchar(25)	NOT NULL	This field is to hold the Pay term code defined in the Payterm component (for amended repair order documents)	No	No
RATmCn_Pay_Mode	varchar(5)	NULL	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	No
RATmCn_Pay_Priority	varchar(5)	NULL	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	No
RATmCn_Matching_Type	varchar(5)	NULL	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	No
RATmCn_Pay_to_Sup_No	varchar(45)	NOT NULL	This field is to hold Pay to Supplier No -- Supplier No to which payment has to be made (for amended repair order documents)	No	No
RATmCn_Insur_Liabty	varchar(5)	NULL	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	No
RATmCn_Remarks	varchar(255)		This field is to hold the remarks of repair order (for amended repair order documents)	No	No
RATmCn_CrRt_Core_By	varchar(25)	NOT NULL	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	No
RATmCn_CrRt_Ship_Payment	varchar(25)	NOT NULL	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	No
RATmCn_CrRt_Package_Code	varchar(25)	NOT NULL	This field 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	No
RATmCn_CrRt_Spares_Ret	varchar(5)	NULL	This field is to hold the Spares Return Allowed values ’WC’ - With Core ’SP’ - Separate ’B’ - Blank (for amended repair order documents)	No	No
RATmCn_CrRt_Cert_Type	varchar(25)	NULL	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	No
RATmCn_CrRt_Inspect_Type	varchar(5)	NULL	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	No
RATmCn_SpRt_Spares_By	varchar(25)	NULL	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	No
RATmCn_SpRt_Ship_Payment	varchar(25)	NULL	This field is to hold the Spares Return Shipping Payment -- list of Shipping Payment Method codes defined in the Logistics Common Master component (for amended repair order documents)	No	No
RATmCn_SpRt_Package_Code	varchar(25)	NULL	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	No
RATmCn_Created_By	varchar(30)	NOT NULL	This field holds the User who enters (creates)the Terms and conditions details of the Repair order document into the system (for amended repair order documents)	No	No
RATmCn_Created_Date	datetime	NOT NULL	This field holds the Date on which the Terms and conditions is entered into the system (for amended repair order documents)	No	No
RATmCn_Modified_By	varchar(30)	NOT NULL	This field is to hold the user who modified the record (for amended repair order documents)	No	No
RATmCn_Modified_Date	datetime	NOT NULL	This field is to hold the date on which the record is modified. (for amended repair order documents)	No	No
RATMCN_GTA_REFDOC_NO	varchar(40)	NULL	This field holds the General Terms Agreement Reference Document #	No	No
RATMCN_GTA_REFDOC_DATE	datetime	NULL	This field holds the General Terms Agreement Reference Document Date	No	No
RATMCN_GTA_REMARKS	varchar(255)	NULL	This field holds the Remarks on General Terms Agreement	No	No
RATMCN_ADVANCE_PAYABLE	varchar(5)	NULL	This field holds the Advance Payable Y - Yes N - No	No	No
RATMCN_ADVANCE_TOL_PERC	numeric(28,8)	NULL	This field holds the Advance Tolerance Percent	No	No
RATMCN_ADVANCE_PAYDATE	datetime	NULL	This field holds the Advance Pay Date	No	No
RATMCN_ADVANCE_PERC	numeric(28,8)	NULL	This field holds the Advance Percentage value	No	No
RATMCN_ADVANCE_PERC_ON	varchar(5)	NULL	This field holds the Advance Percent on BV -- Basic Value TV -- Total Value B -- Blank	No	No
RATMCN_DDCHARGES_BORNEBY	varchar(5)	NULL	This field holds the DD Charges Borne By value : SF -- Self RS -- Repair Shop	No	No
RATMCN_INCO_TERM	varchar(150)	NULL	This field holds the Inco Term	No	No
RATMCN_CARRIER_AGENCY#	varchar(20)	NULL	This field holds the Carrier Agency code	No	No
RATMCN_PORT_OF_DESTN	varchar(32)	NULL	This field holds the Port of Destination	No	No
RATMCN_PORT_OF_DEP		NULL	This field holds the Port of Departure	No	No
RATMCN_PACKAGING_NOTES	varchar(2000)	NULL	This field holds the Packaging notes	No	No
RATMCN_SHIPPING_NOTES		NULL	This field holds the Shipping Notes	No	No
RATMCN_ADV_PAY_AMT	numeric(28,8)	NULL	This field holds the Advance Payable amount	No	No
RATMCN_PAYTOSUP_ADDR_ID	char(80)	NULL	This field holds the Pay to Supplier Address Id	No	No
RATMCN_UNWAR	char(25)	NULL	This field store the under warranty value for the parts.	No	No
RATMCN_WARBASIS	char(25)	NULL	This field store the warranty basis value for the parts.	No	No
RATMCN_WARBEGIN	char(5)	NULL	This field store the warranty begins on value.	No	No
RATMCN_WARDUR	numeric(28,8)	NULL	This field store the warranty duration value.	No	No
RATMCN_WARDURUNIT	char(5)	NULL	This field store the warranty duration units value.	No	No
RATMCN_WAR_FH	numeric(28,8)	NULL	This field will store the Flight Hours values.	No	No
RATMCN_WAR_FC	numeric(28,8)	NULL	This field will store the Flight Cycles values.	No	No
RATMCN_WARREFAGR	char(18)	NULL	This field will store the warranty reference agreement value.	No	No
RATMCN_WAR_TERMREF	char(255)	NULL	This field will store the Terms and References value.	No	No

Table Name Rep_RCPmDt_Comp_Param_Dtl

Table Comment This table is to hold the life Parameter Details of the Repair Order .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RCPmDt_Since_Inspect	numeric(28,8)	NULL	This field holds the Since Inspect parameter value	No	No
RCPmDt_Since_Shop_Visit	numeric(28,8)	NULL	This field holds the Since Shop Visit Parameter value	No	No
RCPmDt_Since_Repair	numeric(28,8)	NULL	This field holds the Since Repair Parameter value	No	No
RCPmDt_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record.	No	No
RCPmDt_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record	No	No
RCPmDt_Created_Date	datetime	NOT NULL	This field holds the Created Date of the record	No	No
RCPmDt_Modified_Date	datetime	NOT NULL	This field holds the date on which the record is modified	No	No
RCPmDt_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order number	Yes	Yes
RCPmDt_Param_Line_Id	numeric(10)	NOT NULL	This field holds the uniquely generated param line id	Yes	No
RCPmDt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RCPmDt_Since_Overhaul	numeric(28,8)	NULL	This field holds the Since Overhaul Parameter value	No	No
RCPmDt_Since_New	numeric(28,8)	NULL	This field holds the Since New Parameter value	No	No
RCPmDt_Ac_Param_Code	varchar(40)	NOT NULL	This field holds the Aircraft Parameter Code	No	No
RCPmDt_UOM	varchar(10)	NULL	This field holds the Parameter UOM(Unit of measurement)	No	No

Table Name Rep_RDD_Discrepancy_Dtl

Table Comment This field is to hold the Discrepancy Details for the Repair Order .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RDD_Modified_Date	datetime	NOT NULL	This field holds the Date on which the last modification has taken place.	No	No
RDD_Modified_By	varchar(30)	NOT NULL	THis field holds the User who modified the Discrepancy info	No	No
RDD_Created_Date	datetime	NOT NULL	This field holds the Date on which the Discrepancy detail was created.	No	No
RDD_RO_ATANO	varchar(30)	NULL	ATA Number	No	No
RDD_RO_DISC_DESC	varchar(255)	NULL	This field holds the Discrepancy Description	No	No
RDD_RO_DEF_FLAG	varchar(5)	NULL	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	No
RDD_RO_MAINTREP	varchar(255)	NULL	This field holds the number identifying the maintenance report corresponding to the discrepancy.	No	No
RDD_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order Number	Yes	Yes
RDD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RDD_Created_By	varchar(30)	NOT NULL	This field holds the User who has created the Discrepancy info.	No	No
RDD_RO_Discy_Comments	varchar(255)	NULL	This field is to hold the Discrepancy Comments	No	No
RDD_RO_Discy_No	varchar(50)	NOT NULL	This field is to hold the Discrepancy Number -- From BASCR(Component Replacement)	Yes	No
RDD_RO_Discy	varchar(5)	NOT NULL	This field is to capture the Discrepancies Reported - Values are ’FC’ - ’Fully Confirmed’ ’PC’ - ’Partially Confirmed’ ’NF’ - ’No Fault Found’	No	No
RDD_RO_PARTNO	varchar(40)	NULL	This Field stores the part no details.	No	No
RDD_RO_SERIALNO	varchar(40)	NULL	This Field stores the serial no details of the part.	No	No
RDD_RO_PARTNO	varchar(40)	NULL	This Field stores the part no details.	No	No
RDD_RO_SERIALNO	varchar(40)	NULL	This Field stores the serial no details of the part.	No	No

Table Name Rep_RDoT_Doc_TCD_dtl

Table Comment This table is to capture Document Tcd Details for the Repair Order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RDoT_exchg_rate	numeric(28,8)	NULL	Holds the exchange rate between the document currency and the payment currency	No	No
RDoT_Account_Type	varchar(5)	NULL	stores the account type	No	No
RDoT_Account_Code	varchar(32)	NULL	stores the account code	No	No
RDOT_USER_SEQ#	numeric(10)	NULL	This field holds the User Seq # which is manually entered by the user	No	No
RDOT_TCD_PAYMT_CURRENCY	varchar(20)	NULL	This field holds the Payment Currency	No	No
RDoT_Modified_Date	datetime	NOT NULL	This field holds the modified date of the record	No	No
RDoT_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RDoT_Cst_Center	varchar(10)	NULL	stores the cost center for the given account code	No	No
RDoT_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RDoT_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RDoT_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RDoT_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RDOT_TCD_Diff	numeric(28,8)	NULL	This field holds the Tcd Amount Difference	No	No
RDoT_TCD_Line_Id	numeric(10)	NOT NULL	This field is to capture the uniquely generated TCD line id	Yes	No
RDoT_TCD_OU	numeric(10)	NOT NULL	This field is to capture the TCD OUInstance of TCD component which interacts with repair order component	No	No
RDoT_TCD_Code	varchar(25)	NOT NULL	This field is to capture the Tcd Code of Tcd Component which interacts with repair order component	No	No
RDoT_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order number	Yes	Yes
RDoT_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RDoT_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record	No	No
RDoT_Created_By	varchar(30)	NOT NULL	This field holds the user who created this record	No	No
RDoT_Created_Date	datetime	NOT NULL	This field holds the creation date of the record	No	No
RDoT_TCD_Variant_Code	varchar(25)	NOT NULL	This field is to capture the Tcd varian Code of Tcd Component which interacts with repair order component	No	No
RDoT_TCD_Rate	numeric(28,8)	NULL	This field is to capture the Tcd Rate of TCD component.	No	No
RDoT_Pay_to_Supplier_No	varchar(45)	NULL	This field is to capture the Pay-To-Supplier Number	No	No
RDoT_TCD_Amount	numeric(28,8)	NULL	This field is to capture the Tcd calculated amount of TCD component.	No	No

Table Name Rep_RepAUI_User_Def_Info

Table Comment This table is to capture the User Defined Details for the Repair Order /Amendment Numbers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RepAUI_User_Def_Opt4	varchar(18)	NULL	This field is to hold User Defined Option 4 (for amended repair order documents)	No	No
RepAUI_User_Def_Remarks	varchar(255)	NULL	This field is to hold User Defined Remarks (for amended repair order documents)	No	No
RepAUI_User_Def_Desc4	varchar(30)	NULL	This field is to hold User Defined Description for Option 4 (for amended repair order documents)	No	No
RepAUI_User_Def_Opt3	varchar(18)	NULL	This field is to hold User Defined option 3 (for amended repair order documents)	No	No
RepAUI_Modified_Date	datetime	NULL	This field is to hold the Last Date on which the user Defined Detail was Modified. (for amended repair order documents)	No	No
RepAUI_Created_Date	datetime	NOT NULL	This field is to hold the Date on which the User Detail was created for the Repair Order # (for amended repair order documents)	No	No
RepAUI_Created_By	varchar(30)	NOT NULL	This field is to hold the User who has created the User Defined Details. (for amended repair order documents)	No	No
RepAUI_Modified_By	varchar(30)	NULL	This field is to hold the User who has modified the User Defined Details (for amended repair order documents)	No	No
RepAUI_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number (for amended repair order documents)	Yes	Yes
RepAUI_RO_Amend_No	numeric(10)	NOT NULL	THis field is to capture the Amendment Number of the Repair Order. (for amended repair order documents)	Yes	Yes
RepAUI_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RepAUI_User_Def_Desc3	varchar(30)	NULL	This field is to hold User Defined Description for Option 3 (for amended repair order documents)	No	No
RepAUI_User_Def_Opt2	varchar(18)	NULL	This field is to hold User Defined Option 2. (for amended repair order documents)	No	No
RepAUI_User_Def_Desc1	varchar(30)	NULL	This field is to capture the User Defined Description for Option 1. (for amended repair order documents)	No	No
RepAUI_User_Def_Desc2	varchar(30)	NULL	This field is to hold User Defined Description for Option 2 (for amended repair order documents)	No	No
RepAUI_User_Def_Opt1	varchar(18)	NULL	This field is to capture the User Defined Option1 defined in logistics common master (for amended repair order documents)	No	No

Table Name Rep_RepPrm_Parameter_dtl

Table Comment This table is to hold Parameter Details for the Repair Order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RepPrm_Componentname	varchar(20)	NOT NULL	This field holds the Name of the component.	Yes	No
RepPrm_Paramcategory	varchar(10)	NOT NULL	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	No
RepPrm_Paramtype	varchar(25)	NOT NULL	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	No
RepPrm_Paramcode	varchar(5)	NOT NULL	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	No
RepPrm_Langid	numeric(10)	NOT NULL	Language id. This is the language id of the record.	Yes	No
RepPrm_Paramdesc	varchar(80)	NULL	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	No
RepPrm_Sortby	numeric(10)	NULL	This field holds the default sort by code	No	No
RepPrm_Createddate	datetime	NULL	This field holds the record created date for auditing purpose.	No	No

Table Name Rep_Repsc_sup_corr_details

Table 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
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RepSC_Createddate	datetime	NULL	stores the created date	No	No
RepSC_Buyer_Remarks	varchar(255)	NULL	stores the remarks entered by buyer	No	No
RepSC_Supp_Remarks	varchar(255)	NULL	stores the remarks sent by the repair agency	No	No
RepSC_Created_By	varchar(30)	NULL	stores the user name who created the record	No	No
RepSC_ModifiedDate	datetime	NULL	stores the modified date	No	No
RepSC_Modified_By	varchar(30)	NULL	stores the user name who modified the record	No	No
RepSC_RO_No	varchar(40)	NOT NULL	This field holds the repair order document number.	Yes	Yes
RepSC_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RepSC_Date	datetime	NULL	stores the date on which the repair agency comment or buyer comment is recorded	No	No
RepSc_Line_No	numeric(10)	NOT NULL	Holds the line no for all correspondence detail	Yes	No
RepSC_Amend_NO	numeric(10)	NOT NULL	stores the amendment number of the repair order	Yes	No

Table Name Rep_RepUI_User_Def_Info

Table Comment User Defined Details for the Repair Order .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RepUI_User_Def_Opt4	varchar(18)	NULL	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 4 and also blank	No	No
RepUI_User_Def_Remarks	varchar(255)	NULL	This field is to capture the User Defined Remarks	No	No
RepUI_User_Def_Desc4	varchar(30)	NULL	This field is to capture the User Defined Description for Option4	No	No
RepUI_User_Def_Opt3	varchar(18)	NULL	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 3 and also blank	No	No
RepUI_Modified_Date	datetime	NULL	This field is to hold The Date on which the User Defined Info was modified.	No	No
RepUI_Created_Date	datetime	NOT NULL	This field is to hold The Date on which the User Defined Info was Created.	No	No
RepUI_Created_By	varchar(30)		This field holds the user who created the record	No	No
RepUI_Modified_By	varchar(30)	NULL	This field to hold the user who modified the record	No	No
RepUI_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order number	Yes	Yes
RepUI_User_Def_Desc1	varchar(30)	NULL	This field is to capture the User Defined Description for Option1	No	No
RepUI_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RepUI_User_Def_Desc3	varchar(30)	NULL	This field is to capture the User Defined Description for Option3	No	No
RepUI_User_Def_Opt2	varchar(18)	NULL	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 2 and also blank	No	No
RepUI_User_Def_Opt1	varchar(18)	NULL	User Option Values defined in the Logistics Common master, in active status, for RO, for User Option 1 and also blank	No	No
RepUI_User_Def_Desc2	varchar(30)	NULL	This field is to capture the User Defined Description for Option2	No	No

Table Name Rep_RLbTD_Labour_TCD_Dtl

Table Comment This table is to hold Labour Tcd Details of the Repair Order .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RLBTD_USER_SEQ#	numeric(10)	NULL	This field holds the User Seq#	No	No
RLbTD_exchg_rate	numeric(28,8)	NOT NULL	Holds the exchange rate between the document currency and the payment currency	No	No
RLbTD_Account_Type	varchar(5)	NULL	stores the account type	No	No
RLBTD_TCD_PAYMT_CURRENCY	varchar(20)	NULL	This field holds the Payment Currency	No	No
RLbTD_Modified_Date	datetime	NOT NULL	This field holds the Last Date on which the Labour Tcd got Modified.	No	No
RLbTD_Modified_By	varchar(30)	NOT NULL	This field hold the Last User Who Modified the Labour Tcd Details.	No	No
RLbTD_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RLbTD_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RLbTD_Account_Code	varchar(32)	NULL	stores the account code	No	No
RLbTD_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RLbTD_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RLbTD_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RLbTD_Cst_Center	varchar(10)	NULL	stores the cost center for the given account code	No	No
RLbTD_Quote_Id	numeric(10)	NOT NULL	This field is to capture the Quotation Id of the Repair Order Number	Yes	Yes
RLBTD_TCD_LINE_ID	numeric(28,8)	NOT NULL	This field is to capture Tcd line id which has been created for the Repair Order #.	Yes	No
RLbTD_TCD_OU	numeric(10)	NOT NULL	This field is to capture the TCd OUInstance	No	No
RLbTD_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number	Yes	Yes
RLbTD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RLbTD_Created_Date	datetime	NOT NULL	This field holds the Date on which the Labour Tcd was Created	No	No
RLbTD_Pay_to_Supplier_No	varchar(45)	NULL	This field holds The pay to Supplier Number	No	No
RLbTD_Created_By	varchar(30)	NOT NULL	This field holds the User who has created the Labour Tcd Details.	No	No
RLbTD_TCD_Code	varchar(25)	NOT NULL	This field is to capture The TCd Code From the Tcd Component	No	No
RLbTD_TCD_Variant_Code	varchar(25)	NOT NULL	This field is to capture The Tcd Variant Code from the Tcd Component	No	No
RLbTD_TCD_Amount	numeric(28,8)	NULL	This field holds theTcd Amount which has been calculated	No	No
RLbTD_TCD_Rate	numeric(28,8)	NULL	This field holds the Tcd Rate For the Tcd component.	No	No

Table Name Rep_RMCDt_Matl_Cost_Dtl

Table Comment This table is to hold Material Cost Details for the Quotation of the Repair Order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RMCDt_Part_Unit_Rate	numeric(28,8)	NULL	This column is to hold unit rate of repair parts for the repair order document	No	No
RMCDt_Total_TCD_Cost	numeric(28,8)	NULL	This column is to hold Total Tcd Value applicable for the material line id of repair orders	No	No
RMCDt_Part_Uom	varchar(10)	NULL	This column is to hold Part UOM of repair parts for the repair order document	No	No
RMCDt_Part_Qty	numeric(28,8)	NOT NULL	This column is to hold Part quantity of repair parts for the repair order document	No	No
RMCDt_Modified_By	varchar(30)	NOT NULL	This field holds the user who has last modified the Material cost info.	No	No
RMCDt_Created_By	varchar(30)	NOT NULL	This table holds the user who created the record	No	No
RMCDt_Created_Date	datetime	NOT NULL	This field holds the date on which the Material info was Created.	No	No
RMCDt_Modified_Date	datetime	NOT NULL	This field holds the Date on which the Material cost got Modified.	No	No
RMCDt_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order Number	Yes	Yes
RMCDt_Quote_Id	numeric(10)	NOT NULL	This field is to hold the Quotation Id of the Repair Order Number	Yes	Yes
RMCDt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RMCDt_Part_Desc	varchar(80)	NULL	This column is to hold Part Description of repair parts for the repair order document	No	No
RMCDt_Manuf_Part_No	varchar(40)	NOT NULL	This column is to hold the Manufacturer Part Number of repair order	No	No
RMCDt_Matl_Line_Id	numeric(10)	NOT NULL	This field is to hold the Material Line Id for the Parts which are created for repair orders.	Yes	No
RMCDt_Matl_Line_No	varchar(30)	NOT NULL	This column is to hold the Material Line Id for the Parts which are created for the repair order	No	No

Table Name Rep_RMTcd_Mat_TCD_dtl

Table Comment This field holds the Material Tcd Details for the Materials of the Quotation of the Repair Order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RMTCD_USER_SEQ#	numeric(10)	NULL	This field holds the User Seq#	No	No
RMTcd_exchg_rate	numeric(28,8)	NULL	Holds the exchange rate between the document currency and the payment currency	No	No
RMTcd_Account_Type	varchar(5)	NULL	stores the account type	No	No
RMTCD_TCD_PAYMT_CURRENCY	varchar(20)	NULL	This field holds the Payment Currency	No	No
RMTcd_Modified_Date	datetime	NOT NULL	This field holds the date on which it is modified	No	No
RMTcd_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record	No	No
RMTcd_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RMTcd_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RMTcd_Account_Code	varchar(32)	NULL	stores the account code	No	No
RMTcd_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RMTcd_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RMTcd_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RMTcd_Cst_Center	varchar(10)	NULL	stores the cost center for the given account code	No	No
RMTcd_Matl_Line_Id	numeric(10)	NOT NULL	This field is to hold the Material Line Id of the Quotation Number	Yes	Yes
RMTcd_TCD_Line_Id	numeric(10)	NOT NULL	This field holds the uniquely generated TCD line id	Yes	No
RMTcd_TCD_OU	numeric(10)	NOT NULL	This field holds the Tcd Ouinstance in which the Tcd was created(FROM TCD Component)	No	No
RMTcd_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RMTcd_Quote_Id	numeric(10)	NOT NULL	This field is to capture the Quotation Id for the Repair Order Number.	Yes	Yes
RMTcd_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number	Yes	Yes
RMTcd_Created_Date	datetime	NOT NULL	This field holds The Date on which the Material Tcd info was created.	No	No
RMTcd_Pay_to_Supplier_No	varchar(45)	NULL	This field holds the Supplier No to whom payment has to be made	No	No
RMTcd_Created_By	varchar(30)	NOT NULL	This field is to hold The User Who has created the Material Tcd Info.	No	No
RMTcd_TCD_Code	varchar(25)	NOT NULL	This field holds the Tcd Code from Tcd Component	No	No
RMTcd_TCD_Variant_Code	varchar(25)	NOT NULL	This field holds the Tcd Variant Code from Tcd Component	No	No
RMTcd_TCD_Amount	numeric(28,8)	NULL	This field holds the Tcd Calculated Amount from Tcd Component.	No	No
RMTcd_TCD_Rate	numeric(28,8)	NULL	This field holds the Tcd Rate from Tcd Component	No	No

Table Name Rep_ROAH_Repair_Order_Hdr

Table Comment This field is to hold Repair Order-Amendment history Header Info
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ROAH_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the amended repair orders’ OUInstance	Yes	Yes
ROAH_RO_No	varchar(40)	NOT NULL	This field is to capture the amended Repair order Documents	Yes	Yes
ROAH_RO_Amend_No	numeric(10)	NOT NULL	This field is to capture the Amendment Number for the Repair order document	Yes	No
ROAH_RO_Type	varchar(5)	NOT NULL	This field is to hold The Repair order type for amended repair orders Values are ’NM’ -- Normal’ ’EX’ -- Exchange	No	No
ROAH_RO_Remarks	varchar(255)	NULL	This field is to hold any Remarks entered for the amended Repair order documents	No	No
ROAH_Supplier_OU	numeric(10)	NOT NULL	This field is to capture the Repair shop(Supplier) Created OU For Amendment.	No	No
ROAH_Repair_Shop_No	varchar(45)	NOT NULL	This field is to capture the supplier no marked as repair agency for amended repair orders	No	No
ROAH_Repair_Shop_ConPer	varchar(80)	NULL	This field is to capture the contact person of supplier marked as repair agency for amended repair orders	No	No
ROAH_RO_Priority	varchar(20)	NULL	This field holds the priority populated -- From Logistics Common Master for amended repair order	No	No
ROAH_RO_AirCraft_OU	numeric(10)	NULL	This field holds the Aircraft Registration Number Created OU -- Only if "For Aircraft Reg#" exists (for amended repair order documents)	No	No
ROAH_RO_Aircraft_Reg_No	varchar(30)	NULL	This field is to hold the Aircraft Registration Number -- Mandatory Only if Priority = ’AOG’ (for amended repair order documents)	No	No
ROAH_RO_Req_Repair_Time	numeric(28,8)	NULL	This field holds the Requested Repair time -- THe time that should be taken for repair -- NOt mandatory . (for amended repair order documents)	No	No
ROAH_RO_Lead_Time_Units	varchar(5)	NULL	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	No
ROAH_RO_Matl_Ret_Auth_No	varchar(40)	NULL	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	No
ROAH_RO_Spec_Ship_Date	datetime	NOT NULL	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	No
ROAH_RO_Ship_Date_Ctrl	varchar(5)	NULL	This field holds the Shipping Date Control. Allowed values are ’Y’ -- ’Yes ’N’--No B --Blank (for amended repair order documents)	No	No
ROAH_RO_Category	varchar(25)	NULL	This field holds the Quickcodes of type category defined in the Logistics Common Master for the RO Document (for amended repair order documents)	No	No
ROAH_RO_User_Status	varchar(25)	NULL	Thisfield holds the Quickcodes of type User status defined in the Logistics Common Master for the RO Document (for amended repair order documents)	No	No
ROAH_RO_Return_to_OU	numeric(10)	NULL	This field holds the GR OU -- IN which the core part will be received (for amended repair order documents)	No	No
ROAH_RO_StkAdmn_OU	numeric(10)	NULL	This field holds THe Warehouse OU -- Stock Admin OU -- of the Warehouse in which the goods will be stored after Return. (for amended repair order documents)	No	No
ROAH_RO_Wh_No	varchar(10)	NULL	This field holds the Warehouse Number- in which the good s will be stored after Return. (for amended repair order documents)	No	No
ROAH_RO_Core_Return_Opt	varchar(5)	NOT NULL	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	No
ROAH_RO_Spares	varchar(5)	NOT NULL	This field holds the Spares Shipped Allowed values are 1.SH -- Shipped 2.NSH -- Not Shipped (for amended repair order documents)	No	No
ROAH_RO_Buyer_Group_OU	numeric(10)	NULL	This field holds the Buyer Group OUInstance of the Buyer Group to which the Login User Belongs to (for amended repair order documents)	No	No
ROAH_RO_Buyer_Group	varchar(25)	NULL	This field holds the Buyer Group to which the Login User Belongs to (for amended repair order documents)	No	No
ROAH_RO_CMPlan_OU	numeric(10)	NULL	This field holds the Component Maintenance Planning OU with which repair order component is interacting (for amended repair order documents)	No	No
ROAH_RO_Part_Cr_OU	numeric(10)	NULL	This field is to capture the RO Part Created OUInstance. (for amended repair order documents)	No	No
ROAH_RO_Part_No	varchar(40)	NOT NULL	This field is to capture the repair order Partno (for amended repair order documents)	No	No
ROAH_RO_Serial_No	varchar(40)	NOT NULL	This field is to capture the Serial No (for amended repair order documents)	No	No
ROAH_RO_AcComponent_Ou	numeric(10)	NOT NULL	This field is to capture the Component Id Created Aircraft OU with which repair order component is interacting (for amended repair order documents)	No	No
ROAH_RO_Component_Id	varchar(90)	NOT NULL	This field is to capture the Component Id for which the Repair order Document is created (for amended repair order documents)	No	No
ROAH_RO_Comp_Replace_OU	numeric(10)	NULL	This field is to capture the Component Replacement OU with which repair order component is interacting (for amended repair order documents)	No	No
ROAH_RO_Comp_Replace_No	varchar(40)	NULL	This field is to capture the Component Replacement Number of repair order document (for amended repair order documents)	No	No
ROAH_RO_Part_Owned_By	varchar(30)	NULL	This field is to capture the Owner Code -- airline operator codes defined in the Common Master component (for amended repair order documents)	No	No
ROAH_RO_Under_Warranty	varchar(5)	NULL	This field is to capture the Under Warranty Status Allowed values are Y -- Yes N -- No ’B’--Blank (for amended repair order documents)	No	No
ROAH_RO_Warr_OU	numeric(10)	NULL	This field holds the Warranty OUInstance with which repair order component is interacting (for amended repair order documents)	No	No
ROAH_RO_Warr_OEM_No	varchar(40)	NULL	This field holds the Warranty Number of OEM Type -- if exists (for amended repair order documents)	No	No
ROAH_RO_Warr_New_No	varchar(40)	NULL	This field holds the Warranty Number of New Type -- if exists (for amended repair order documents)	No	No
ROAH_RO_Warr_Overhaul_No	varchar(40)	NULL	This field holds the Warranty Number of Overhaul Type -- if exists (for amended repair order documents)	No	No
ROAH_RO_Warr_Repair_No	varchar(40)	NULL	This field holds the Warranty Number of Repair Type -- if exists (for amended repair order documents)	No	No
ROAH_RO_Warr_OEM_Flg	varchar(5)	NULL	This field holds the Warranty type -- ’OE’ -- OEM Type (for amended repair order documents)	No	No
ROAH_RO_Warr_New_Flg	varchar(5)	NULL	This field holds the Warranty type -- ’NE’ -- NEW Type (for amended repair order documents)	No	No
ROAH_RO_Warr_Overhaul_Flg	varchar(5)	NULL	This field holds the Warranty type -- ’OV’ -- Overhaul Type (for amended repair order documents)	No	No
ROAH_RO_Warr_Repair_Flg	varchar(5)	NULL	This field holds the Warranty type -- ’RE’ --Repair Type (for amended repair order documents)	No	No
ROAH_Auth_TerLevel	varchar(25)	NULL	This field holds the final authorizer to authorize the document (for amended repair order documents)	No	No
ROAH_Auth_MinVal	numeric(28,8)	NULL	This field holds the Minimum document Value of this Route (for amended repair order documents)	No	No
ROAH_Auth_MaxVal	numeric(28,8)	NULL	This field holds tHe Maximum document value of the ROute (for amended repair order documents)	No	No
ROAH_Auth_NxtLvlPc	varchar(25)	NULL	This field holds The Next Level code or PC to authorize the document (for amended repair order documents)	No	No
ROAH_Auth_Type	varchar(5)	NULL	This field holds the Authorizer type -- LEVEL code or PC (for amended repair order documents)	No	No
ROAH_Auth_Stage	varchar(25)	NULL	This field holds THe Authorizer stages if the Document is in "Under AUthorization -’U’ status (for amended repair order documents)	No	No
ROAH_RO_Status	varchar(15)	NOT NULL	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 -- &nbspCancelled BC -- BER Closed CL -- Closed (for amended repair order documents)	No	No
ROAH_RO_Core_Ret_Flg	varchar(5)	NULL	This field holds THe Core Returned Flag -- If the Issue Component has returned the Core &nbspComponent Allowed values Y -- Yes N -- No (for amended repair order documents)	No	No
ROAH_CORE_ISSUED_FLAG	varchar(5)	NULL	This field holds the Core Issued Flag -- If the Issue Component has issued the Core Component Allowed values Y -- Yes N -- No (for amended repair order documents)	No	No
ROAH_GR_RECD_PART_NO	varchar(30)	NULL	This field holds the received repair part no of amended repair order documents (for amended repair order documents)	No	No
ROAH_GR_RECD_SL_NO	varchar(30)	NULL	This field holds the Received Serial number of amended repair order documents (for amended repair order documents)	No	No
ROAH_GR_RECD_FLAG	varchar(5)	NULL	This field holds the GR Received Flag ’A’ -- Accepted ---- If the Core has been returned from the supplier. (for amended repair order documents)	No	No
ROAH_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record (for amended repair order documents)	No	No
ROAH_Created_Date	datetime	NOT NULL	This field holds the created date of the record (for amended repair order documents)	No	No
ROAH_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record (for amended repair order documents)	No	No
ROAH_Modified_Date	datetime	NOT NULL	This field holds the Modified date of the record (for amended repair order documents)	No	No
ROAH_Released_Date	datetime	NULL	This field holds the Released date of the record (for amended repair order documents)	No	No
ROAH_Released_By	varchar(30)	NULL	This field holds the User who Released the document (for amended repair order documents)	No	No
ROAH_Authorised_Date	datetime	NULL	This field holds the Authorized date of the document (for amended repair order documents)	No	No
ROAH_Authorised_By	varchar(30)	NULL	This field holds the user who authorised the document (for amended repair order documents)	No	No
ROAH_Confirmed_Date	datetime	NULL	This field holds the Confirmed Date of the record (for amended repair order documents)	No	No
ROAH_Confirmed_By	varchar(30)	NULL	The field holds the User who Confirmed the document (for amended repair order documents)	No	No
ROAH_Amended_Date	datetime	NULL	This field holds the AMended Date of the record (for amended repair order documents)	No	No
ROAH_Amended_By	varchar(30)	NULL	This field holds the user who amended the record (for amended repair order documents)	No	No
ROAH_Timestamp	numeric(10)	NOT NULL	This field holds the Timestamp value (for amended repair order documents)	No	No
ROAH_RO_EXCHG_TYPE	varchar(5)	NULL	Holds the Exchange type : F - Flat R- Repair B - Blank	No	No
ROAH_RO_CR_REASON#	varchar(20)	NULL	Reason code -- From Component Replacement	No	No
ROAH_RO_REASON_FOR_REM	varchar(255)	NULL	Reason for removal	No	No
ROAH_RO_DISP_WARR_TYPE	varchar(5)	NULL	This field holds the warranty type of the warranty # with highest priority that has to be displayed .	No	No
ROAH_RO_WARR_CLAIM#	varchar(40)	NULL	warranty claim# for the component#	No	No
ROAH_RO_WARR_CLAIM_DATE	datetime	NULL	warranty claim date	No	No
ROAH_RO_WARR_CLAIM_ON	varchar(5)	NULL	warranty claim on : F -- Full P -- Partial M -- Material L -- Labour O -- Others B -- Blank	No	No
ROAH_RO_SUP_AGMNT_REF#	varchar(40)	NULL	Holds the Supplier Agreement Ref#	No	No
ROAH_RO_SUPP_WARR_REF#	varchar(40)	NULL	Supplier Warranty Ref#	No	No
ROAH_RO_WARR_NOTES	varchar(2000)	NULL	Warranty notes	No	No
ROAH_RO_WARR_REASON	varchar(2000)	NULL	Warranty Reason	No	No
ROAH_CLAIM_ACCPT_ON	varchar(5)	NULL	Claim Accepted on F -- Full P -- Partial M -- Material L -- Labour O -- Others B -- Blank	No	No
ROAH_CLAIM_ACCPT_STATUS	varchar(5)	NULL	Claim Acceptance Status FA -- Fully Accepted PA -- Partially Accepted RJ -- Rejected	No	No
ROAH_RO_STKFROM_OU	numeric(10)	NULL	Stock Admin OU -- Warehouse OU -- Where the Core component is stored	No	No
ROAH_RO_STKFROM_WH	varchar(10)	NULL	Warehouse# -- Where the Core component is stored .	No	No
ROAH_RO_REASON	varchar(2000)	NULL	Holds the reason for actions taken ( cancellation/authorization) &nbspagainst RO.	No	No
ROAH_Account_Type	varchar(5)	NULL	stores the account type	No	No
ROAH_Account_Code	varchar(32)	NULL	stores the account code	No	No
ROAH_Def_Fin_Book	varchar(20)	NULL	stores the default finance book	No	No
ROAH_Company_Code	varchar(32)	NULL	stores the company code	No	No
ROAH_Business_Unit	varchar(32)	NULL	stores the business unit	No	No
ROAH_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
ROAH_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
ROAH_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
ROAH_RO_CmpId_OwnShp	varchar(5)	NULL	stores the component id ownership status whenever the repair order is BER closed.	No	No
ROAH_DOC_KEY	varchar(128)	NULL	stores the document key for work flow purpose	No	No
ROAH_RO_NUM_Typ_No	varchar(5)	NULL	stores the numbering type no of repair order	No	No
ROAH_RO_Ref_Doc_OU	numeric(10)	NULL	OU Instance of Reference Document Number	No	No
ROAH_RO_Ref_Doc_No	varchar(40)	NULL	Reference Document Number (like CWO number)	No	No
ROAH_RO_Ref_Doc_Type	varchar(25)	NULL	Reference Document Type (like CWO etc.)	No	No
ROAH_RO_Work_Center_OU	numeric(10)	NULL	Work Center OU	No	No
ROAH_RO_Work_Center	varchar(30)	NULL	Work Center	No	No
ROAH_RO_Lot_No	varchar(18)	NULL	Lot Number	No	No
ROAH_Currency	char(20)	NULL	This field is to capture the transaction currency of the repairorder	No	No
ROAH_Expense_type	char(5)	NULL	This field holds the Expense type Allowed values are Revenue -- Revenue Capital -- Capital	No	No
ROAH_ShopJob_Type	char(5)	NULL	This field holds the Shop Job Type Allowed values are C - Component PP- Peice part F - faciltity	No	No
ROAH_CapexProposal_No	char(18)	NULL	This field is to capture the Capex Proposal No of the repairorder	No	No
ROAH_Customer_No	char(18)	NULL	This field is to capture the Customer No of the repairorder	No	No
ROAH_Custorder_No	char(18)	NULL	This field is to capture the Customer order No of the repairorder	No	No
ROAH_RO_Source	char(5)	NULL	This field hold the repair order source, The valid values are Manual AUTO-CO AUTO-CWO AUTO-HWO AUTO-TLOG Others	No	No
ROAH_RO_From_Wh_No	char(10)	NULL	This field holds the Warehouse Number- &nbspfrom which the good s will be &nbspFetched before repair.	No	No
ROAH_Stock_Status	char(5)	NULL	This field holds the stock status of the repairorder	No	No
ROAH_Cost	int	NULL	This field holds the total cost of the &nbspRO (line level)	No	No
ROAH_Work_Request	char(255)	NULL	This field holds the &nbspwork requested for the &nbsppart	No	No
ROAHD_BER_Qty	char(5)	NULL	it holds the ber quantity	No	No
ROAH_COST_DIFF	numeric(28,8)	NULL	This field holds the cost difference of RO after the amendment	No	No
ROAH_Remarks	char(255)	NULL	This field holds the &nbspremarks which is given in the maitain multiline..	No	No
ROAD_BER_Qty	numeric	NULL	This field holds the BER quantity	No	No
ROAH_RO_InsuranceCost	int	NULL	This column holds the amended Insurance cost value	No	No
ROAH_NRTN_Cost	numeric(13,28)	NULL	This column holds the non returnable cost	No	No
ROAH_RO_CR_ACREG_NO	char(30)	NULL	Column to store Aircraft Reg no for the respective CR No.	No	No

Table Name Rep_ROHd_Repair_Order_Hdr

Table Comment THis table is to capture Repair Order Info
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ROHd_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
ROHd_RO_No	varchar(40)	NOT NULL	This field holds the repair order document number.	Yes	No
ROHd_RO_Type	varchar(5)	NOT NULL	This field holds the repair order type Values allowed are 1.’NM’ -- Normal’ 2.’EX’ -- Exchange	No	No
ROHd_RO_Lat_Amend_No	numeric(10)	NOT NULL	This field holds the latest amendment no. for the Repair order document	No	No
ROHd_RO_Remarks	varchar(255)	NULL	This field holds the remarks entered for the RO document	No	No
ROHd_Supplier_OU	numeric(10)	NOT NULL	This field captures the &nbsprepair shop(supplier) created OUInstance.	No	No
ROHd_Repair_Shop_No	varchar(45)	NOT NULL	This field holds the Repair shop number(supplier of type repair agency)	No	No
ROHd_Repair_Shop_ConPer	varchar(80)	NULL	This field holds the repair shop’s contact person.(contact person of repair shop)	No	No
ROHd_RO_Priority	varchar(20)	NULL	This field holds the priority whose values are populated from Logistics Common Master	No	No
ROHd_RO_AirCraft_OU	numeric(10)	NULL	This field holds the &nbspAircraft Created OUInstance -- Only if "For Aircraft Reg#" exists	No	No
ROHd_RO_Aircraft_Reg_No	varchar(30)	NULL	Thsi field holds the for aircraft registration no.It is &nbspmandatory only if Priority = ’AOG’	No	No
ROHd_RO_Req_Repair_Time	numeric(28,8)	NULL	This field holds the requested repair time -- THe time that should be taken for repair -- It is not mandatory .	No	No
ROHd_RO_Lead_Time_Units	varchar(5)	NULL	This field holds the repair order lead time units. Allowed values are D -- Days W -- Weeks M -- Months B -- Blank	No	No
ROHd_RO_Matl_Ret_Auth_No	varchar(40)	NULL	This field holds the Material Return Authority Number.It &nbspis mandatory only if BER Flag is ’YES’ &nbspand &nbspSalvage Action is ’By Operator’	No	No
ROHd_RO_Spec_Ship_Date	datetime	NOT NULL	This field holds the Specified Shipping Date -- If Requested Repair Time is entered &nbspthe specific shipping date should be greater than the Requested repair time	No	No
ROHd_RO_Ship_Date_Ctrl	varchar(5)	NULL	THis field holds the Shipping Date Control. Allowed values are ’Y’ -- Yes ’N’-- &nbspNo B --Blank	No	No
ROHd_RO_Category	varchar(25)	NULL	This field holds the &nbspQuickcodes of type category defined in the Logistics Common Master for the RO Document	No	No
ROHd_RO_User_Status	varchar(25)	NULL	This field &nbspholds the user status defined in the Logistics Common Master for the RO Document	No	No
ROHd_RO_Return_to_OU	numeric(10)	NULL	This field holds the Goods receipt ouinstance -- in which the core part will be recieved	No	No
ROHd_RO_StkAdmn_OU	numeric(10)	NULL	This field holds the Warehouse OU -- Stock Admin OU -- of the Warehouse in which the goods will be stored after Return.	No	No
ROHd_RO_Wh_No	varchar(10)	NULL	THis field holds the Warehouse number &nbspin which the goods will be stored after Return.	No	No
ROHd_RO_Core_Return_Opt	varchar(5)	NOT NULL	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	No
ROHd_RO_Spares	varchar(5)	NOT NULL	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	No
ROHd_RO_Buyer_Group_OU	numeric(10)	NULL	This field holds the Buyer Group OUInstance of the Buyer Group to which the Login User Belongs to	No	No
ROHd_RO_Buyer_Group	varchar(25)	NULL	This field holds the Buyer Group to which the Login User Belongs to	No	No
ROHd_RO_CMPlan_OU	numeric(10)	NULL	This field holds the "The Component Maintenance Planning OU " interacting with repair order component	No	No
ROHd_RO_Part_Cr_OU	numeric(10)	NOT NULL	This field holds the Part Created OU with which the repair order component is interacting	No	No
ROHd_RO_Part_No	varchar(40)	NOT NULL	This field holds the repair order part number	No	No
ROHd_RO_Serial_No		NOT NULL	This field holds the repair order serial number	No	No
ROHd_RO_AcComponent_Ou	numeric(10)	NOT NULL	This field holds the Component Id Created Aircraft OUInstance	No	No
ROHd_RO_Component_Id	varchar(90)	NOT NULL	This field holds the Component Id for which the Repair order Document is created	No	No
ROHd_RO_Comp_Replace_OU	numeric(10)	NULL	This field holds the Component Replacement OU of repair order document	No	No
ROHd_RO_Comp_Replace_No	varchar(40)	NULL	This field holds the Component Replacement number of the repair order document	No	No
ROHd_RO_Part_Owned_By	varchar(30)	NULL	THis field holds the Owner Code -- airline operator codes defined &nbspin the Common Master component	No	No
ROHd_RO_Under_Warranty	varchar(5)	NULL	This field holds the Under Warranty Status. Allowed values Y -- Yes N -- No ’B’--Blank	No	No
ROHd_RO_Warr_OU	numeric(10)	NULL	This field holds the Warranty OUinstance of warranty component with which repair order component is interacting	No	No
ROHd_RO_Warr_OEM_No	varchar(40)	NULL	This field holds theWarranty Number of OEM Type -- if exists	No	No
ROHd_RO_Warr_New_No	varchar(40)	NULL	THis field holds the Warranty Number &nbspof New Type -- if exists	No	No
ROHd_RO_Warr_Overhaul_No	varchar(40)	NULL	This field holds the Warranty Number &nbspof Overhaul Type -- if exists	No	No
ROHd_RO_Warr_Repair_No	varchar(40)	NULL	This field holds the Warranty Number &nbspof Repair Type -- if exists	No	No
ROHd_RO_Warr_OEM_Flg	varchar(5)	NULL	This field holds the indicator of &nbspOEM Type of warranty Allowed value ’OE’	No	No
ROHd_RO_Warr_New_Flg	varchar(5)	NULL	This field holds the indicator of &nbspNEW Type of warranty Allowed value is ’NE’ --	No	No
ROHd_RO_Warr_Overhaul_Flg	varchar(5)	NULL	This field holds the Overhaul Type of warranty. Allowed value is ’OV’ -- &nbspOverhaul	No	No
ROHd_RO_Warr_Repair_Flg	varchar(5)	NULL	Thisfield holds the &nbspRepair &nbspType of warrranty. Allowed value is ’RE’ --Repair	No	No
ROHd_Auth_TerLevel	varchar(25)	NULL	THe final authorizer to authorize the doucmetn Level Code or Purchase Committee	No	No
ROHd_Auth_MinVal	numeric(28,8)	NULL	This field is to capture the Minimum document &nbspValue of authorisation &nbspRoute	No	No
ROHd_Auth_MaxVal	numeric(28,8)	NULL	This field is to capture the Maximum document &nbspValue of authorisation &nbspRoute	No	No
ROHd_Auth_NxtLvlPc	varchar(25)	NULL	This field is to capture "The Next Level code" or "PC" to authorize the document	No	No
ROHd_Auth_Type	varchar(5)	NULL	This field is to hold the &nbspAuthorizer type - Allowed value - LEVEL code (or) PC	No	No
ROHd_Auth_Stage	varchar(25)	NULL	This field holds the &nbspAuthorizer stages &nbspif the Document is in "Under AUthorization -’U’ status	No	No
ROHd_RO_Status	varchar(15)	NOT NULL	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 -- &nbspCancelled BC -- BER Closed CL -- Closed	No	No
ROHd_RO_Core_Ret_Flg	varchar(5)	NULL	This field is to capture the RO core return flag	No	No
ROHd_Core_Issued_Flag	char(1)	NULL	This field is to capture the Core Issued Flag - - If the Issue Compoennt has issued the Core &nbspComponent Allowed values are Y -- Yes N -- No	No	No
ROHd_GR_Recd_Part_No	varchar(30)	NULL	THis field holds the Received Repair part number of the goods receipt component	No	No
ROHd_GR_Recd_Sl_No	varchar(30)	NULL	This field is to capture the Received Serial number of goods receipt component	No	No
ROHd_GR_Recd_Flag	varchar(5)	NULL	This field is to capture the GR Recieved Flag Allowed value is ’A’ -- Accepted ----(If the Core has been returned from the supplier.)	No	No
ROHd_Task_OU	numeric(10)	NULL	Stores the task OUinstance form task component	No	No
ROHd_Created_By	varchar(30)	NOT NULL	This field holds the user who created the RO document	No	No
ROHd_Created_Date	datetime	NOT NULL	This field holds the Created Date of the record	No	No
ROHd_Modified_By	varchar(30)	NOT NULL	This field holds the User who modified the document	No	No
ROHd_Modified_Date	datetime	NOT NULL	This field holds the &nbspModified date of the record	No	No
ROHd_Released_Date	datetime	NULL	This field holds the Released date of the record	No	No
ROHd_Released_By	varchar(30)	NULL	This field holds the User who &nbspReleased &nbspthe document	No	No
ROHd_Authorised_Date	datetime	NULL	This field holds the Authorized date of the record	No	No
ROHd_Authorised_By	varchar(30)	NULL	This field holds the user who authorised the record	No	No
ROHd_Confirmed_Date	datetime	NULL	This field holds the Confirmed Date of the record	No	No
ROHd_Confirmed_By	varchar(30)	NULL	This field &nbspholds the User who Confirmed the document the latest	No	No
ROHd_Amended_Date	datetime	NULL	This field holds the AMended Date of the record	No	No
ROHd_Amended_By	varchar(30)	NULL	This field holds the user who amended the record.	No	No
ROHd_Timestamp	numeric(10)	NOT NULL	This field holds the timestamp value	No	No
ROHD_RO_EXCHG_TYPE	varchar(5)	NULL	Holds the Exchange type : F - Flat R- Repair B - Blank	No	No
ROHD_RO_CR_REASON#	varchar(20)	NULL	Reason code -- From Component Replacement	No	No
ROHD_RO_REASON_FOR_REM	varchar(255)	NULL	Reason for removal	No	No
ROHD_RO_DISP_WARR_TYPE	varchar(5)	NULL	This field holds the warranty type of the warranty # with highest priority that has to be displayed .	No	No
ROHD_RO_WARR_CLAIM#	varchar(40)	NULL	waranty claim# for the component#	No	No
ROHD_RO_WARR_CLAIM_DATE	datetime	NULL	warranty claim date	No	No
ROHD_RO_WARR_CLAIM_ON	varchar(5)	NULL	warranty claim on : F -- Full P -- Partial M -- Material L -- Labour O -- Others B -- Blank	No	No
ROHD_RO_SUP_AGMNT_REF#	varchar(40)	NULL	Holds the Supplier Agreement Ref#	No	No
ROHD_RO_SUPP_WARR_REF#	varchar(40)	NULL	Supplier Warranty Ref#	No	No
ROHD_RO_WARR_NOTES	varchar(2000)	NULL	Warranty notes	No	No
ROHD_RO_WARR_REASON	varchar(2000)	NULL	Warranty Reason	No	No
ROHD_CLAIM_ACCPT_ON	varchar(5)	NULL	Claim Accepted on F -- Full P -- Partial M -- Material L -- Labour O -- Others B -- Blank	No	No
ROHD_CLAIM_ACCPT_STATUS	varchar(5)	NULL	Claim Acceptance Status FA -- Fully Accepted PA -- Partially Accepted RJ -- Rejected	No	No
ROHD_RO_STKFROM_OU	numeric(10)	NULL	Stock Admin OU -- Warehouse OU -- Where the Core component is stored	No	No
ROHD_RO_STKFROM_WH	varchar(10)	NULL	Warehouse# -- Where the Core component is stored .	No	No
ROHD_RO_REASON	varchar(2000)	NULL	Holds the reason for actions taken ( cancellation/authorization) &nbspagainst RO.	No	No
ROHd_Account_Type	varchar(5)	NULL	stores the account type	No	No
ROHd_Account_Code	varchar(32)	NULL	stores the account code	No	No
ROHd_Def_Fin_Book	varchar(20)	NULL	stores the default finance book	No	No
ROHd_Company_Code	varchar(32)	NULL	stores the company code	No	No
ROHd_Business_Unit	varchar(32)	NULL	stores the business unit	No	No
ROHd_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
ROHd_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
ROHd_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
ROHd_RO_CmpId_OwnShp	varchar(5)	NULL	stores the component id ownership status whenever the repair order is BER closed.	No	No
ROHD_DOC_KEY	varchar(128)	NULL	stores the document key for work flow purpose	No	No
ROHd_RO_NUM_Typ_No	varchar(5)	NULL	stores the numbering type no of repair order	No	No
ROHd_RO_Ref_Doc_OU	numeric(10,0)	NULL	OUInstance of the Reference Document No	No	No
ROHd_RO_Ref_Doc_No	varchar(40)	NULL	Reference Document Number like CWO Number, etc.	No	No
ROHd_RO_Ref_Doc_Type	varchar(25)	NULL	This field holds the Reference Document Type Possible values CWO - Component Work Order HWO - Hangar Work Order OTH - Others TL - Tech Log	No	No
ROHd_RO_Work_Center_OU	numeric(10,0)	NULL	This field holds the OUInstance of the work center	No	No
ROHd_RO_Work_Center	varchar(30)	NULL	This field holds the Work Center	No	No
ROHd_RO_Lot_No	varchar(18)	NULL	This field holds the Lot Number	No	No
ROHD_SCRAAC_TYPE	varchar(5)	NULL	This field holds the scrap account type	No	No
ROHD_SCRACC_CODE	varchar(32)	NULL	This field holds the scrap account code	No	No
ROHd_ShopJobType	char(5)	NULL	This field holds the Shop Job Type Allowed values are C - Component PP- Peice part F - faciltity	No	No
ROHD_RO_PART_COND	varchar(5)	NULL	This field holds the part condition of the part	No	No
ROHD_RO_Insp_WO	varchar(75)	NULL	This field holds the Insecption work order ID	No	No
ROHD_RO_Com_No	varchar(40)	NULL	This field holds the component ID	No	No
ROHD_RO_Gen_Insp_WO	varchar(25)	NULL	This field holds the Generated Component work order ID	No	No
ROHD_RO_Comp_WO_No	varchar(40)	NULL	This field holds the Component work order ID	No	No
ROHD_RO_Insp_WO_Desc	varchar(75)	NULL	This field holds the Insecption work order Description	No	No
ROHD_RO_Insp_WO_Status	varchar(15)	NULL	This field holds the Insecption work order status	No	No
ROHD_RO_Exe_omments	varchar(75)	NULL	This field holds the Repair order comments	No	No
ROHd_Currency	char(20)	NULL	This field is to capture the transaction currency of the repairorder	No	No
ROHd_Expense_type	char(5)	NULL	This field holds the Expense type Allowed values are Revenue -- (R) Capital -- (C)	No	No
ROHD_Cost_Diff	numeric(28,8)	NULL	This field holds the cost difference of RO after amendment	No	No
ROHd_CapexProposal_No	char(18)	NULL	This field is to capture the Capex Proposal No of the repairorder	No	No
ROHd_Customer_No	char(18)	NULL	This field is to capture the Customer No of the repairorder	No	No
ROHd_Custorder_No	char(18)	NULL	This field is to capture the Customer order No of the repairorder	No	No
ROHd_RO_Source	char(25)	NULL	This field hold the repair order source, The valid values are Manual AUTO-CO AUTO-CWO AUTO-HWO AUTO-TLOG Others	No	No
ROHd_RO_From_Wh_No	char(10)	NULL	This field holds the Warehouse Number- &nbspfrom which the good s will be &nbspFetched before repair.	No	No
ROHD_Stock_Status	char(5)	NULL	This field holds the stock status of the repairorder	No	No
ROHD_Cost	int	NULL	This field holds the total cost of the &nbspRO (line level)	No	No
ROHD_Work_Request	char(255)	NULL	This field holds the &nbspwork requested for the &nbsppart	No	No
ROHD_Remarks	char(255)	NULL	This field holds the &nbspremarks which is given in the maitain multiline..	No	No
ROHD_BER_Qty	numeric	NULL	It holds the value of ber quantity	No	No
ROHD_RO_SUPP_REPAIRCOST	numeric(28,8)	NULL	This field will store the Supplier Cost	No	No
ROHD_RO_WARR_ULTIMATE_NO	char(18)	NULL	This field holds the Warranty Number &nbspof Ultimate Life Type -- if exists	No	No
ROHD_RO_WARR_ULTIMATE_FLG	char(5)	NULL	This field holds the indicator of &nbspUltimate LifeType of warranty	No	No
ROHD_RO_WARR_MOD_NO	char(18)	NULL	This field holds the Warranty Number &nbspof Mod Type -- if exists	No	No
ROHD_RO_WARR_MOD_FLG	char(5)	NULL	This field holds the indicator of &nbspMod of warranty	No	No
ROHD_RO_WARR_REFDOC_TYPE	char(18)	NULL	This field will store the Reference document Type	No	No
ROHD_RO_WARR_REFDOC_NO	char(18)	NULL	This field will store the Reference document Number	No	No
ROHD_RO_WARR_QUOTEGEN	char(5)	NULL	This field will store the Quote generation basis.	No	No
ROHD_RO_QUOTE_STATUS	char(25)	NULL	This field will store the Quote generation Mode.	No	No
ROHD_RO_WARFLAG	char(25)	NULL	This field will store the Warranty flag value.	No	No
ROHd_RO_InsuranceCost	int	NULL	This column is used to hold the Insurance cost value	No	No
rohd_maincore_cost	numeric(13,28)	NULL	This column is used to hold themain core cost
rohd_rtn_cost	numeric(13,28)	NULL	This column is used to hold the returnable cost	No	No
ROHD_NRTN_Cost	numeric(13,28)	NULL	This column is used to hold theNon returnable cost	No	No
ROHD_RO_CR_ACREG_NO	varchar(30)	NULL	This field is to capture the repair order OUInstance	No	No
ROHD_Remarks_UniqueID	varchar(40)	NULL	This field corresponds the unique id generated against each remark value.	No	No
ROHD_PART_TYPE	varchar(25)	NULL	This field corresponds to the part type defined in part master.	No	No
ROHD_PART_CONTROLTYPE	varchar(25)	NULL	This field corresponds to the control type of the part.	No	No
ROHD_PART_EXPOLICY	varchar(5)	NULL	This field corresponds to the part expence policy as defined in part master.	No	No
ROHD_PART_EXPTYPE	varchar(25)	NULL	This field corresponds to the expence type of the part as defined in part master.	No	No
ROHD_PART_NONSTKFLG	varchar(5)	NULL	This field corresponds to the Non stockable part as defined in part master.	No	No
ROHD_PART_LOTNOTYPE	varchar(5)	NULL	This field corresponds to the Lot numbering type.	No	No
ROHD_PART_SLNOTYPE	varchar(5)	NULL	This field corresponds to the Serial numbering type.	No	No
ROHD_PART_SLNOLOGIC	varchar(5)	NULL	This field corresponds to the Serial no logic generation.	No	No

Table Name Rep_ROPrt_PiecePart_Dtl

Table Comment This table is to hold &nbspPiece part information &nbspfor the Repair Order -Amendment Numbers .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ROPrt_GR_Rec_Partno	char(18)	NULL	This field holds the received repair part no of repair order documents	No	No
ROPrt_GR_Rec_Serialno	char(18)	NULL	This field holds the Received Serial number of repair order documents	No	No
ROPrt_BER_Cost	numeric	NULL	This field holds the beyond repair cost of the part.	No	No
ROPrt_Line_status	char(18)	NULL	This column holds the line level status of the each part no # values CL - closed OP - open BC - BER closed	No	No
ROPrt_Rec_Qty	char(18)	NULL	This column holds the value of received quantity of this line, which defined in Repair receipt	No	No
ROPrt_BER_Qty	char(18)	NULL	This column holds the value BER Quantity, which is defined in record quation (line level)	No	No
ROPrt_Pending_Qty	char(18)	NULL	It holds the value of pending quantity	No	No
Roprt_Cost_Diff	numeric(28,8)	NULL	This field holds the cost difference of part after amendment	No	No
ROPrt_Salvage_Action	char(5)	NULL	This field holds the &nbspsalvage action of the part.	No	No
ROPrt_Salvage_Value	numeric(28,8)	NULL	This field holds the &nbspsalvage value of the part.	No	No
ROPrt_ACCOMPONENT_OU	char(18)	NULL	If part number and serial number is of type component then the Ou for that component &nbspis stored here	No	No
ROPrt_COMPONENT_ID	char(18)	NULL	If part number and serial number is of type component then the component id is stored here	No	No
ROPRT_SUPP_REPAIRCOST	numeric(28,8)	NULL	This field will store the Supplier cost.	No	No
ROPrt_Line_no	char(30)	NOT NULL	THis field is to capture the part line no	Yes	No
ROPrt_Part_Cr_OU	int	NULL	This field holds the Part Created OU with which the repair order component is interacting	No	No
ROPrt_Part_No	char(40)	NULL	This field holds the repair order piece part number	No	No
ROPrt_RO_No	varchar(40)	NOT NULL	This field holds the repair order document number.	Yes	Yes
ROPrt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
ROPrt_Remarks	char(255)	NULL	This field holds the &nbspremarks	No	No
ROPrt_Cost	int	NULL	This field holds the Total cost of the &nbsppiece part (line level)	No	No
ROPrt_Work_Request	char(255)	NULL	This field holds the &nbspwork requested for the piece part	No	No
ROPrt_Quantity	numeric	NULL	This field holds the &nbsppiece part quantity	No	No
ROPrt_Serial_No	char(40)	NULL	This field holds the repair order piece part serial number	No	No
ROPrt_Stock_Status	char(5)	NULL	This field holds the &nbsppiece part stock status	No	No
ROPrt_Lot_No	char(18)	NULL	This field holds the repair order piece part lot number	No	No
roprt_maincore_cost	numeric(13,28)	NULL	This field holds the Amin core cost values	No	No
ROPrt_NRTN_Cost	numeric(13,28)	NULL	This field holds the non returnable cost values	No	No
ROPrt_Remarks_UniqueID	varchar(40)	NULL	This field corresponds the unique id generated against each remark value.	No	No
ROPRT_PART_TYPE	varchar(25)	NOT NULL	This field corresponds to the part type defined in part master.	No	No
ROPRT_PART_EXPTYPE	varchar(25)	NOT NULL	This field corresponds to the control type of the part.	No	No
ROPRT_PART_NONSTKFLG	varchar(25)	NOT NULL	This field corresponds to the part expence policy as defined in part master.	No	No
ROPRT_PART_EXPOLICY	varchar(5)	NOT NULL	This field corresponds to the expence type of the part as defined in part master.	No	No
ROPRT_PART_CONTROLTYPE	varchar(25)	NOT NULL	This field corresponds to the Non stockable part as defined in part master.	No	No
ROPRT_PART_LOTNOTYPE	varchar(5)	NULL	This field corresponds to the Lot numbering type.	No	No
ROPRT_PART_SLNOTYPE	varchar(5)	NULL	This field corresponds to the Serial numbering type.	No	No
ROPRT_PART_SLNOLOGIC	varchar(5)	NULL	This field corresponds to the Serial no logic generation.	No	No

Table Name Rep_ROSopt_SetOption_Info

Table Comment This table is to capture the repair order set option info
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ROSopt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	No
ROSopt_Def_Auto_Num_type	varchar(5)	NULL	This field is to capture the Member &nbspAuthorization &nbspStatus Allowed values are 1.Y 2.N	No	No
ROSopt_Wunit_Add	varchar(5)	NULL	If the user is given option to add a work unit manually,then this field needs to set	No	No
ROSopt_Wunit_Delete	varchar(5)	NULL	If the user is given option to delete a defaulted work unit manually,then this field needs to set	No	No
ROSopt_created_by	varchar(30)	NOT NULL	This field is to hold the user who created teh record	No	No
ROSopt_created_date	datetime	NOT NULL	This field is to capture the created date of the record.	No	No
ROSopt_modified_by	varchar(30)	NOT NULL	This field is to hold the user who modified the record.	No	No
ROSopt_modified_date	datetime	NOT NULL	This field is to capture the modified date of the record.	No	No
ROSopt_timestamp	numeric(10)	NOT NULL	This field holds the timestamp of the record.	No	No
ROSOPT_DEF#TYP_AUTOWARRRO	varchar(5)	NULL	This field holds the Default Numbering type for Auto Warranty RO	No	No
ROSOPT_ADDN_DISCPS_TO_RO	varchar(5)	NULL	This field holds the Addition of Discrepancies to RO# AL - Allowed NA - Not Allowed	No	No
ROSOPT_ADDN_OF_NRTNE_TASK	varchar(5)	NULL	This field holds the Addition of Non Routine Task AL - Allowed NA - Not Allowed	No	No
ROSOPT_ACK_OF_ORDER	varchar(5)	NULL	This field holds the Acknowledgement of Order MD -- Mandatory NM -- Non Mandatory	No	No
ROSOPT_RO_ON_UNSVBLE_PRTS	varchar(5)	NULL	This field holds the Repair Order only on Unserviceable parts Y -- Yes N -- No	No	No
ROSOPT_COMP_IN_WHCHK	varchar(5)	NULL	This field holds the Component in Warehouse Check EF -- Enforce DE -- Do not Enforce	No	No
ROSOPT_SPARES_SUPPLD_BY	varchar(5)	NULL	This field holds the Spares Supplied By RS -- Repair Shop OP -- Operator BO -- Both	No	No
ROSOPT_SPARES_SHIPPING	varchar(5)	NULL	This field holds the Spares Shipping WC -- With Core Sp -- Separate	No	No
ROSOPT_RETLOC_ISSLOC_DIFF	varchar(5)	NULL	This field holds the Return to Location different from Issue &nbspLocation AL - Allowed NA - Not Allowed	No	No
ROSOPT_COMP_LIST_PRICE	varchar(5)	NULL	This field holds the Component &nbspList Price SC - Standard cost EN - Enterable	No	No
ROSOPT_AUTOAUTHLIMIT	numeric(28,8)	NULL	This field holds the Auto Authorization Limit (%)	No	No
ROSOPT_MAX_ALLOW_REP_COST	numeric(28,8)	NULL	This field holds the Maximum Allowable Repair cost (%)	No	No
ROSOPT_PTPRC_MAP_TO_SUP	varchar(5)	NULL	This field holds the flag whether the part and process mapping to supplier is mandatory or non mandatory	No	No
ROSOPT_RO_COST_AMD_ALLOWED	char(5)	NULL	This field holds value ’Y’ or ’N’	No	No
ROSOPT_QUOT_TYPE_ALLOWED_INV	char(5)	NOT NULL	This column store the values like FIRM, FIRM AND ESTIMATE	No	No
ROSOPT_Def_RepAgency	char(5)	NOT NULL	Stores whether Repair Agency has to be default in Repair Order.	No	No
ROSOPT_QUO_GEN_BASIS	char(5)	NULL	This field will store the &nbspQuote Generation Basis	No	No
ROSOPT_ROSTATUS_NONCNT_PRT	char(5)	NULL	This field will store the RO Status for non-contracted parts	No	No
ROSOPT_RO_TRANSIT_TIME	int	NULL	Used to store the Transit Time	No	No
ROSOPT_UNDERWARNTY_REPAIR	char(5)	NULL	This column holds the Underwarranty value	No	No
ROSOPT_DEFINSURANCE_COST	char(5)	NULL	This column hols the default Insurance cost	No	No
ROSOPT_Retrieval_RelatedTsk	char(5)	NULL	This column holds the informational value of Related Task retreival.	No	No
ROSOPT_DefRProc_PerpetualTsk	char(25)	NULL	This column holds informational value related to perpetual task fetch	No	No

Table Name Rep_RQuD_Quote_Dtl

Table Comment This field holds the Quotation Details for the Repair Order.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RQuD_BER_Cost	numeric(28,8)	NULL	This field holds the Beyond Repair -- Analysis Cost	No	No
RQuD_Quote_Ld_Time_Unit	varchar(5)	NULL	Ths field holds the Quotation Lead time unit Allowed values D - Days W - Weeks M - Months	No	No
RQuD_Quote_Remarks	varchar(255)	NULL	This field is to hold any Remarks -- entered by the Supplier regarding the Quotation	No	No
RQuD_Salvage_At	varchar(5)	NULL	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	No
RQuD_Total_Matl_Cost	numeric(28,8)	NULL	This field holds the Total Material cost --Total &nbspMaterial Cost + Total Material &nbspTCD Cost	No	No
RQuD_Quote_Amt_Hld_Time	numeric(28,8)	NULL	This field holds the Price Held Firm time -- THe Price valid &nbsptime --from the Quotation date into consideration	No	No
RQuD_Total_Doc_TCD	numeric(28,8)	NULL	This field holds the Total Document TCD Cost	No	No
RQuD_Quote_Misc_Cost	numeric(28,8)	NULL	This field holds the Quotation Miscellaneous cost	No	No
RQuD_Quote_Matl_Cost	numeric(28,8)	NULL	This field holds the Material cost -- sum(Material cost) for all of the materials used for the Quotation.	No	No
RQUD_QUOT_TOTALREP_COST	numeric(28,8)	NULL	This field holds the Total Repair Cost	No	No
RQUD_SAL_SALVAGE_VALUE	numeric(28,8)	NULL	This field holds the Estimated Scrap value	No	No
RQUD_COMP_LIST_PRICE	numeric(28,8)	NULL	This field holds the Component List Price	No	No
RQUD_TOTAL_COST	numeric(28,8)	NULL	This field holds the Total Cost for the RO# Quote	No	No
RQuD_Created_By	varchar(30)	NOT NULL	This field holds the User who entered the QUotation	No	No
RQuD_Created_Date	datetime	NOT NULL	This field holds the created date of the record	No	No
RQUD_QUOT_EXCHANGE_FEE	numeric(28,8)	NULL	This field holds the &nbspExchange Fee	No	No
RQuD_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record	No	No
RQuD_Modified_Date	datetime	NOT NULL	This field holds the Date on which the QUotation is &nbsplast modified	No	No
RQuD_Filename	sql_variant	NULL	This field holds the filename of RO quotation	No	No
RQuD_Sup_Add_Discrepancy	varchar(5)	NULL	This field is to hold the Additional Discrepancies that are Detected Allowed values are Y -- Yes N -- No	No	No
RQuD_Sup_Con_Discrepancy	varchar(5)	NULL	This field holds the &nbspCOnfirm Discrepanies -- confirmed byt he Supplier allowed values are ’FC’ -- ’Fully Confirmed’ ’PC’ -- ’Partially Confirmed’ ’NF’ -- ’No Fault Found’	No	No
RQuD_Sup_Add_Problems	varchar(255)	NULL	This field is to hold The Additionals Problem Descriptions of supplier	No	No
RQuD_Sup_Comments	varchar(255)	NULL	This field is to hold any Comment &nbspfrom the Supplier	No	No
RQud_Exchange_Rate_OU	numeric(10)	NULL	This field is to hold the Exchange Rate OUInstance -- from ESetup Component OU .	No	No
RQuD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RQUD_RO_USER_STATUS	varchar(25)	NULL	Holds the user entered status for a repair order	No	No
RQuD_RO_No	varchar(40)	NOT NULL	This field is to hold the Repair Order Number	Yes	Yes
RQuD_Quote_Id	numeric(10)	NOT NULL	This field is to hold the uniquely generated quote id	Yes	No
RQuD_Total_Lab_TCD	numeric(28,8)	NULL	This field holds the Total Labour TCD Cost	No	No
RQuD_Quote_Cost_Man_Hr	numeric(28,8)	NULL	This field holds the Cost Per Man Hour	No	No
RQuD_Quote_Est_Man_Hrs	numeric(28,8)	NULL	This field holds the Quoted &Estimated Man Hours	No	No
RQuD_Quote_Labour_Cost	numeric(28,8)	NULL	This field holds the quote Labour Cost	No	No
RQuD_Total_Labour_Cost	numeric(28,8)	NULL	This field holds the total labour cost Total Labour cost -- Labour Cost + Total Labour TCD Cost	No	No
RQuD_Exchange_Rate	numeric(28,8)	NULL	This field is tohold the Exchange Rate -- &nbspBetween the Base currency and the Quotation Suppler Currency	No	No
RQuD_Quote_Ref_No	varchar(40)	NULL	This field is to hold the Quotation Reference Number	No	No
RQuD_Quote_Currency	varchar(20)	NULL	This field holds the Quotation Currency	No	No
RQuD_Quote_Type	varchar(5)	NULL	This field is to hold Quotation Type -- Allowed Values are F -- Firm E -- Estimate	No	No
RQuD_Quote_Date	datetime	NULL	This field holds the Quotation Date of the Supplier	No	No

Table Name REP_RSPID_SPARE_ISSUE_DTL

Table Comment This table is to hold Spares Lot/Serial no &nbspIssue &nbspDetails of the Repair Order Number
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RSPID_GR_Recd_Qty	numeric(28,8)	NULL	This field holds the Returned/Recieved Quantity in Repair order UOM	No	No
RSPID_GR_Accpt_Qty	numeric(28,8)	NULL	This field holds the Accepted Quantity &nbspamong the Recieved Quantity &nbspin Repair order UOM	No	No
RSPID_GR_Recd_Serial_No	varchar(40)	NULL	This field holds the Returned/Recieved Serial Number &nbspthrough &nbspGR NULL -- in case of Only Lot Controlled and None Part types	No	No
RSPID_GR_Recd_Lot_No	varchar(18)	NULL	This field holds the Returned/Recieved Lotno through GR NULL -- in case of Only Serial Controlled and None Part types	No	No
RSPID_Modified_By	varchar(30)	NOT NULL	This field holds the user who modified the record	No	No
RSPID_GR_Moved_Qty	numeric(28,8)	NULL	This field holds the Moved Quantity into the warehouse among the Accepted Quantity &nbspin Repair order UOM	No	No
RSPID_Created_Date	datetime	NOT NULL	This field holds the Created Date of the record	No	No
RSPID_Created_By	varchar(30)	NOT NULL	This field holds the user who created the record	No	No
RSPID_Modified_Date	datetime	NOT NULL	This field holds the Modified Date of the record	No	No
RSPID_RO_Spares_Id	numeric(10)	NOT NULL	This field holds the Repair Order SPares ID -- Foreign Key from the Spares Detail Information	Yes	Yes
RSPID_RO_Lot_Sl_Id	numeric(10)	NOT NULL	This field holds the Running Serial # for each Lot/SI/NO details for the Spares ID.	Yes	No
RSPID_RO_No	varchar(40)	NOT NULL	This field holds the Repair order Number	Yes	Yes
RSPID_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RSPID_RO_ISSUE_QTY_SUOM	numeric(28,8)	NOT NULL	This field holds the Issued Qty in Stock UOM	No	No
RSPID_RO_Issue_UOM	varchar(10)	NOT NULL	This field holds the Repair Order UOm	No	No
RSPID_RO_Issue_Lot_No	varchar(18)	NULL	This field holds the Issued Repair lot no in stock issue component	No	No
RSPID_RO_Issue_Qty	numeric(28,8)	NOT NULL	This field holds the Issued Qty in Repair Order UOM	No	No
RSPID_RO_Issue_Serial_No	varchar(40)	NULL	This field holds the Issued Repair serial no in stock issue component	No	No

Table Name Rep_RSpSD_Spare_Ship_Dtl

Table Comment This table is to hold the Spare Ship Details of the Repair Orders
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RSpSD_Created_Date	datetime	NOT NULL	This field holds the Date on which the Spares details is entered into the system	No	No
RSpSD_Created_By	varchar(30)	NOT NULL	This field holds the User who enters (creates)the Spares details of the Repair order document into the system	No	No
RSpSD_Modified_By	varchar(30)	NOT NULL	This field holds the User who last modified the Spares details of the Repair order document into the sysstem	No	No
RSpSD_Modified_Date	datetime	NOT NULL	This field holds the last modified date of the record	No	No
RSPSD_SPARE_RECD_PART_NO	varchar(40)	NULL	This field is to hold the Spares Received Part no	No	No
RSpSD_Spare_GR_Moved_Qty	numeric(28,8)	NULL	This field holds the Spare Quantity Moved into the Warehouse from the Accepted Quantity.	No	No
RSpSD_Spare_GR_Recd_Qty	numeric(28,8)	NULL	This field holds the Spares Quantity Received from the Supplier	No	No
RSpSD_Spare_GR_Accpt_Qty	numeric(28,8)	NULL	This field holds the Spare Quantity Accepted from the Received Quantity	No	No
RSPSD_SPR_STKISS_QTY_SUOM	numeric(28,8)	NULL	This field is to hold the Spares Stock Issue Quantity in Stock UOM	No	No
RSpSD_Auto_Post_Acc_Type	varchar(32)	NULL	stores the auto posting account type	No	No
RSpSD_Control_Acc_Type	varchar(32)	NULL	stores the control account type	No	No
RSpSD_Acct_Curr_Code	varchar(32)	NULL	stores the account currency code	No	No
RSpSD_Account_Type	varchar(5)	NULL	stores the account type	No	No
RSpSD_Account_Code	varchar(32)	NULL	stores the account code	No	No
RSpSD_Def_Fin_Book	varchar(20)	NULL	stores the default finance book	No	No
RSpSD_Analysis_Code	varchar(32)	NULL	stores the analysis code for the account code	No	No
RSpSD_SubAnalysis_Code	varchar(32)	NULL	stores the sub analysis code for the account code	No	No
RSpSD_Cst_Center	varchar(10)	NULL	stores the cost center for the given account code	No	No
RSpSD_Spare_Part_Qty	numeric(28,8)	NOT NULL	This field is to hold the Spare Part Quantity requested in Repair Order UOM	No	No
RSpSD_Spare_Part_No	varchar(40)	NOT NULL	This field is to hold the Spare Requested Part Number	No	No
RSpSD_Spare_Part_UOM	varchar(10)	NOT NULL	This field is to hold the Spare part UOM.	No	No
RSpSD_Spare_Part_Qty_SUOM	numeric(28,8)	NULL	This field is to hold the Spare Part Quantity Requested In Stock UOM	No	No
RSpSD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RSpSD_Spare_Part_Cr_OU	numeric(10)	NOT NULL	This field is to hold the Spare Part Created OUInstance	No	No
RSpSD_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair order number	Yes	Yes
RSpSD_RO_Spares_Id	numeric(10)	NOT NULL	This field is to capture the uniquely generated spares id	Yes	No
RSpSD_Spare_Ret_Wh_No	varchar(10)	NULL	This field captures the Warehouse Number -- to which the spares has to be returned	No	No
RSpSD_Spare_Ret_Type	varchar(5)	NOT NULL	This field is to hold the Spares Return Type Allowed values are ’RT’ - ’Returnable’ ’NR’ - ’Non Returnable’ ’B’ - &nbspBlank	No	No
RSpSD_Spare_Pend_Ret_Qty	numeric(28,8)	NULL	This field is to hold the spare Pending Quantity which has yet to be returned	No	No
RSpSD_Spare_GR_OU	numeric(10)	NULL	This field is to hold spare part GR OU with which repair order component is interacting	No	No
RSpSD_Spare_RcStkAdmin_OU	numeric(10)	NULL	This field is to capture the Stock Admin OU interacting with the GR OU	No	No
RSpSD_Spare_Part_Cond	varchar(5)	NULL	This field is to hold the Spare Part Condition -- (As of now this field will be empty always)	No	No
RSpSD_Spare_StkMnt_OU	numeric(10)	NOT NULL	This field is to hold Stock Maintenance OU with which repair order component is interacting	No	No
RSpSD_Spare_StkIssue_Qty	numeric(28,8)	NULL	This field is to hold the Quantity which has been Issued already through stock issue component	No	No
RSpSD_Spare_SdStkAdmin_OU	numeric(10)	NOT NULL	This field is to hold the sending Stock Admin OU interacting with the Stock Maintenance OU	No	No
RSpSD_Spare_Send_Wh_No	varchar(10)	NOT NULL	This field is to capture the sending Warehouse Number from where the Spare part has to be issued	No	No
RSPSD_STOCKSTATUS	varchar(25)	NULL	This field corresponds to the stock status of the part	No	No
RSPSD_PART_TYPE	varchar(25)	NOT NULL	This field corresponds to the part type defined in part master.	No	No
RSPSD_PART_EXPTYPE	varchar(25)	NOT NULL	This field corresponds to the control type of the part.	No	No
RSPSD_PART_NONSTKFLG	varchar(5)	NOT NULL	This field corresponds to the part expense policy as defined in part master.	No	No
RSPSD_PART_EXPOLICY	varchar(10)	NOT NULL	This field corresponds to the expense type of the part as defined in part master.	No	No
RSPSD_PART_CONTROLTYPE	varchar(25)	NOT NULL	This field corresponds to the Non stockable part as defined in part master.	No	No
RSPSD_PART_LOTNOTYPE	varchar(5)	NULL	This field corresponds to the Lot numbering type.	No	No
RSPSD_PART_SLNOTYPE	varchar(5)	NULL	This field corresponds to the Serial numbering type.	No	No
RSPSD_PART_SLNOLOGIC	varchar(5)	NULL	This field corresponds to the Serial no logic generation.	No	No

Table Name Rep_RTmCn_Term_Cond_Info

Table Comment This table is to hold terms and condition details of the Repair order Number
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RTmCn_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RTmCn_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair order Number	Yes	Yes
RTmCn_Supp_Contact_OU	numeric(10)	NOT NULL	This field is to hold the local interacting OU of the SUpplier with the Repair order	No	No
RTmCn_FwSh_Contact	varchar(80)	NOT NULL	THis field is to hold the forward Shipping Contact Person of the Supplier	No	No
RTmCn_FwSh_Core_By	varchar(25)	NOT NULL	THis field is to hold the forward Shipping Core By -- list of Shipping Method codes defined in the Logistics Common Master component	No	No
RTmCn_FwSh_Package_Code	varchar(25)	NOT NULL	This field is to hold the forward shipping Core Packaging Codes -- list of Core Pack codes defined in the Logistics Common Master component	No	No
RTmCn_FwSh_Spares_By	varchar(25)	NULL	This field is to hold the forward Shipping Spares By -- list of Shipping Method codes defined in the Logistics Common Master component	No	No
RTmCn_Pay_Term	varchar(25)	NOT NULL	This field is to hold the Pay term code defined in the Payterm component for repair order component	No	No
RTmCn_Pay_Mode	varchar(5)	NULL	This field is to hold the Pay Modes -- Allowed values are ’DD’ - ’Demand Draft ’CS’ - ’Cash’ ’CQ’ - ’Cheque’ ’P’ - ’Pay Order’ ’O’ - ’Others’	No	No
RTmCn_Pay_Priority	varchar(5)	NULL	This field is to hold the Pay Priority Allowed values are ’H’ - ’High’ ’N’ - ’Normal’ ’L’ - ’Low’	No	No
RTmCn_Matching_Type	varchar(5)	NULL	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	No
RTmCn_Pay_to_Sup_No	varchar(45)	NOT NULL	This field is to hold the Pay to Supplier # -- Supllier# to which payment has to be made	No	No
RTmCn_Insur_Liabty	varchar(5)	NULL	THis field is to hold the Insurance Liability of repair order document. Allowed values are ’SL’ - ’Self’ ’SP’ - ’Supplier’ ’NO’ - ’None’	No	No
RTmCn_Remarks	varchar(255)	NULL	This field holds the remarks of repair order document	No	No
RTmCn_CrRt_Core_By	varchar(25)	NOT NULL	This field is tohold the Core Return Method -- list of Shipping Method Codes defined in the Logistics Common Master component	No	No
RTmCn_CrRt_Ship_Payment	varchar(25)	NOT NULL	This field is to hold Core Return Shipping Payment -- list of Shipping Payment method defined in the Logistics Common Master component	No	No
RTmCn_CrRt_Package_Code	varchar(25)	NOT NULL	This field is to hold Core return Pack code -- list of Packaging Codes defined in the Logistics Common Master component	No	No
RTmCn_CrRt_Spares_Ret	varchar(5)	NULL	This field is to hold the Spares Return . Allowed values ’WC’ - With Core ’SP’ - Separate ’B’ - Blank	No	No
RTmCn_CrRt_Cert_Type	varchar(25)	NULL	This field holds the Certificate type -- the Certificate types that have been created for Parts in the Logistics Common Master component	No	No
RTmCn_CrRt_Inspect_Type	varchar(5)	NULL	This field holds the Inspection type . Allowed values are S - Self BI - By Inspector	No	No
RTmCn_SpRt_Spares_By	varchar(25)	NULL	This field holds the Return Spares By -- list of Shipping Method codes defined in the Logistics Common Master component	No	No
RTmCn_SpRt_Ship_Payment	varchar(25)	NULL	This field is to hold the Spares Return Shipping Payment -- list of Shipping Payment Method codes defined in the Logistics Common Master component	No	No
RTmCn_SpRt_Package_Code	varchar(25)	NULL	This field is to hold Spares Return Pack code -- list of Packaging Codes defined in the Logistics Common Master component	No	No
RTmCn_Created_By	varchar(30)	NOT NULL	This field holds the User who enters (creates)the Terms and conditions details of the Repair order document into the sysstem	No	No
RTmCn_Created_Date	datetime	NOT NULL	This field is to hold the date on which the Terms and conditions is entered into the system	No	No
RTmCn_Modified_By	varchar(30)	NOT NULL	User who modifies the Terms and conditions details of the Repair order document in the system	No	No
RTmCn_Modified_Date	datetime	NOT NULL	This field is Date on which the Terms and condition is modified the latest in the system.	No	No
RTMCN_GTA_REFDOC_NO	varchar(40)	NULL	This field holds the General Terms Agreement Reference Document #	No	No
RTMCN_GTA_REFDOC_DATE	datetime	NULL	This field holds the General Terms Agreement Reference Document Date	No	No
RTMCN_GTA_REMARKS	varchar(255)	NULL	This field holds the Remarks on General Terms Agreement	No	No
RTMCN_ADVANCE_PAYABLE	varchar(5)	NULL	This field holds the Advance Payable Y - Yes N - No	No	No
RTMCN_ADVANCE_TOL_PERC	numeric(28,8)	NULL	This field holds the Advance Tolerance Percent	No	No
RTMCN_ADVANCE_PAYDATE	datetime	NULL	This field holds the Advance Pay Date	No	No
RTMCN_ADVANCE_PERC	numeric(28,8)	NULL	This field holds the Advance Percentage value	No	No
RTMCN_ADVANCE_PERC_ON	varchar(5)	NULL	This field holds the Advance Percent on BV -- Basic Value TV -- Total Value B -- Blank	No	No
RTMCN_DDCHARGES_BORNEBY	varchar(5)	NULL	This field holds the DD Charges Borne By value : SF -- Self RS -- Repair Shop	No	No
RTMCN_INCO_TERM	varchar(150)	NULL	This field holds the Inco Term	No	No
RTMCN_CARRIER_AGENCY#	varchar(20)	NULL	This field holds the Carrier Agency code	No	No
RTMCN_PORT_OF_DESTN	varchar(32)	NULL	This field holds the Port of Destination	No	No
RTMCN_PORT_OF_DEP	varchar(32)	NULL	This field holds the Port of Departure	No	No
RTMCN_PACKAGING_NOTES	varchar(2000)	NULL	This field holds the Packaging notes	No	No
RTMCN_SHIPPING_NOTES	varchar(2000)	NULL	This field holds the Shipping Notes	No	No
RTMCN_ADV_PAY_AMT	numeric(28,8)	NULL	This field holds the Advance Payable amount	No	No
RTMCN_PAYTOSUP_ADDR_ID	char(80)	NULL	This field holds the Pay to Supplier Address Id	No	No
RTMCN_UNWAR	char(25)	NULL	This field store the under warranty value for the parts.	No	No
RTMCN_WARBASIS	char(25)	NULL	This field store the warranty basis value for the parts.	No	No
RTMCN_WARBEGIN	char(5)	NULL	This field store the warranty begins on value.	No	No
RTMCN_WARDUR	numeric(28,8)	NULL	This field store the warranty duration value.	No	No
RTMCN_WARDURUNIT	char(5)	NULL	This field store the warranty duration units value.	No	No
RTMCN_WAR_FH	numeric(28,8)	NULL	This field will store the Flight Hours values.	No	No
RTMCN_WAR_FC	numeric(28,8)	NULL	This field will store the Flight Cycles values.	No	No
RTMCN_WARREFAGR	char(18)	NULL	This field will store the warranty reference agreement value.	No	No
RTMCN_WAR_TERMREF	char(255)	NULL	This field will store the Terms and References value.	No	No
RTMCN_RMA_NO	char(20)	NULL	This column holds the RMA #	No	No
RTMCN_RMA_DATE	datetime	NULL	This column holds the RMA Date value	No	No
RTMCN_SHIPTO_AddID	char(80)	NULL	This column holds the Ship to address ID value	No	No

Table Name Rep_RWScAD_Work_Scope_Dtl

Table Comment Work Unit Details of the Repair Order # / Amendment #
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RWScAD_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance (for amended repair order documents)	Yes	Yes
RWScAD_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number (for amended repair order documents)	Yes	Yes
RWScAD_RO_Amend_No	numeric(10)	NOT NULL	This field is to capture the Repair Order Amendment Number (for amended repair order documents)	Yes	Yes
RWScdt_Work_Scope_Id	numeric(10)	NOT NULL	THis field is to capture the work scope id (for amended repair order documents) - column name changed as per existing oracle table script	Yes	No
RWScAD_Repair_Process_No	varchar(25)	NOT NULL	This field is to capture the Repair Process Number-- From Logistics Common Master (for amended repair order documents)	No	No
RWScAD_Maintenance_Type	varchar(25)	NULL	This field holds the Maintenance TYpe of the WOrk Units (for amended repair order documents)	No	No
RWScAD_Work_Unit_OU	numeric(10)	NULL	This field holds the Work Unit OUInstance with which repair order is interacting -- Can be a Task OU or BASCMP(ComponentMaintenancePlanning) OU (for amended repair order documents)	No	No
RWScAD_Work_Unit_No	varchar(30)	NOT NULL	This field is to capture the Work Unit Number -- Can be a Task , Stored Procedure or Work Package (for amended repair order documents)	No	No
RWScAD_WkUt_RevNo	varchar(40)	NULL	Workunit Revision No.	No	No
RWScAD_Ref_Document_OU	numeric(10)	NULL	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	No
RWScAD_Ref_Document_No	varchar(40)	NULL	This field is to hold the Reference Document # -- FROM CMPLAN OU -- as it is stored for that workunits of the Component id (for amended repair order documents)	No	No
RWScAD_Ref_Document_Type	varchar(5)	NULL	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	No
RWScAD_Work_Unit_Type	varchar(5)	NOT NULL	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	No
RWScAD_Comments	varchar(255)	NULL	This field is to hold any Comments about the Workunit details (for amended repair order documents)	No	No
RWSCAD_MODEOF_ATTACH_FLAG	char(1)		Mode of Attachment Flag	No	No
RWScAD_Created_By	varchar(30)	NOT NULL	This field is to hold the user who created the record (for amended repair order documents)	No	No
RWScAD_Created_Date	datetime	NOT NULL	This field is to capture the Created date of the record (for amended repair order documents)	No	No
RWScAD_Modified_By	varchar(30)	NOT NULL	This field is to hold the user who modified the record. (for amended repair order documents)	No	No
RWScAD_Modified_Date	datetime	NOT NULL	This field is to hold the modified date of the record (for amended repair order documents)	No	No
RWSCAD_REF_REVISION_NO	varchar(40)	NULL	Revision Number	No	No
RWSCAD_REF_MOD_PARTNO	varchar(40)	NULL	Part Number	No	No
RWSCAD_REF_MOD_STATUS	varchar(20)	NULL	Status	No	No
RWSCAD_SCHEDULE_DATE	datetime	NULL	This column holds the schedule date value	No	No
RWSCAD_PartNo	varchar(40)	NULL	This Field stores the part no details.	No	No
RWSCAD_SerialNo	varchar(40)	NULL	This Field stores the serial no details of the part.	No	No
RWSCAD_EngDocNo	varchar(20)	NULL	This Field stores the Engineering document no details.	No	No
RWSCAD_EngDoc_RevNo	varchar(20)	NULL	This Field stores the Engineering document Revision no details.	No	No
RWSCAD_RelationType	varchar(5)	NULL	This Field stores the relationship of between the task and the related task.	No	No
RWSCAD_ParentTaskNo	varchar(40)	NULL	The fields refers to parent task no details of the given child task.	No	No
RWSCAD_RootTask	varchar(40)	NULL	The fields refers to root task no details of the given child task.	No	No
RWSCAD_COMPONENT_ID	varchar(90)	NULL	This field corresponds to the Component id details for the given part	No	No
RWSCAD_COMPONENT_OU	int	NULL	This field corresponds to the Component Ou for the respective Component id details.	No	No

Table Name Rep_RWScDt_Work_Scope_Dtl

Table Comment This table is to hold Work Unit Details of the Repair Order#
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RWScDt_RO_Ouinstance	numeric(10)	NOT NULL	This field is to capture the repair order OUInstance	Yes	Yes
RWscDt_RO_No	varchar(40)	NOT NULL	This field is to capture the Repair Order Number	Yes	Yes
RWscDt_Work_Scope_Id	numeric(10)	NOT NULL	THis field is to capture the work scope id	Yes	No
RWScDt_Repair_Process_No	varchar(25)	NOT NULL	This field is to capture the Repair Process Number-- From Logistics Common Master	No	No
RWScDt_Maintenance_Type	varchar(5)	NULL	This field holds the Maintenance TYpe of the WOrk Units	No	No
RWScDt_Work_Unit_OU	numeric(10)	NULL	This field holds the WorkUnit OUInstance with which repairorder is interacting -- Can be a Task OU or BASCMP(ComponentMaintenancePlanning) OU	No	No
RWScDt_Work_Unit_No	varchar(30)	NOT NULL	This field is to capture the Work Unit Number -- Can be a Task , Stored Procedure or Work Package	No	No
RWScDt_WkUt_RevNo	varchar(40)	NULL	This field holds the WorkUnit Revision Number	No	No
RWScDt_Ref_Document_OU	numeric(10)	NULL	This field holds the Reference Document OU -- FROM CMPLAN OU -- as it is stored for that workunits of the Component id	No	No
RWScDt_Ref_Document_No	varchar(40)	NULL	This field is to hold the Reference Document # -- FROM CMPLAN OU -- as it is stored for that workunits of the Component id	No	No
RWScDt_Ref_Document_Type	varchar(5)	NULL	This field holds the Reference Document Type -- FROM CMPLAN OU -- as it is stored for that workunits of the Component id	No	No
RWScDt_Work_Unit_Type	varchar(5)	NOT NULL	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	No
RWScDt_Comments	varchar(255)	NULL	This field is to hold any Comments about the Workunit details	No	No
RWSCDT_MODEOF_ATTACH_FLAG	char(1)	NULL	This flag is used to recognize if the Workunits were added manually or defaulted from component maintenance planning.	No	No
RWScDt_Created_By	varchar(30)	NOT NULL	This field is to hold the user who created the record	No	No
RWScDt_Created_Date	datetime	NOT NULL	This field is to capture the Created date of the record	No	No
RWScDt_Modified_By	varchar(30)	NOT NULL	This field is to hold the user who modified the record.	No	No
RWScDt_Modified_Date	datetime	NOT NULL	This field is to hold the modified date of the record	No	No
RWSCDT_REF_REVISION_NO	varchar(40)	NULL	This field holds the Revision Number	No	No
RWSCDT_REF_MOD_PARTNO	varchar(40)	NULL	This field holds the Part Number	No	No
RWSCDT_REF_MOD_STATUS	varchar(20)	NULL	This field holds the Status	No	No
RWSCDT_INSPWO	varchar(5)	NULL	This field holds the Inspection work order	No	No
RWSCDT_SCHEDULE_DATE	datetime	NULL	This column holds the schedule date value	No	No
RWSCDT_PERPETUAL_FLG	varchar(5)	NULL	This column holds the perpetual status	No	No
RWSCDT_SOURCE_WORKUNIT	varchar(30)	NULL	This column holds the source test code	No	No
RWScDt_PartNo	varchar(40)	NULL	This Field stores the part no details.	No	No
RWScDt_SerialNo	varchar(40)	NULL	This Field stores the serial no details of the part.	No	No
RWScDt_EngDocNo	varchar(20)	NULL	This Field stores the Engineering document no details.	No	No
RWScDt_EngDoc_RevNo	varchar(20)	NULL	This Field stores the Engineering document Revision no details.	No	No
RWScDt_RelationType	varchar(5)	NULL	This Field stores the relationship of between the task and the related task.	No	No
RWScDt_ParentTaskNo	varchar(40)	NULL	The fields refers to parent task no details of the given child task.	No	No
RWScDt_RootTask	varchar(40)	NULL	The fields refers to root task no details of the given child task.	No	No
RWSCDT_COMPONENT_ID	varchar(90)	NULL	This field corresponds to the Component id details for the given part	No	No
RWSCDT_COMPONENT_OU	int(4)	NULL	This field corresponds to the Component OU for the respective Component id details.	No	No