Material Request

Table Name EApp_E1_RsMr_ResIdMRLn_Map

Table Comment This table is required for IN3 and IN4 touch points. AIS passes Reservation Id-Part to E.App and MR(s) are generated for the same in E.App and is maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

RsMr_Part_No

varchar(40)

NULL

Part reserved against the Reservation Id.

RsMr_Base

varchar(30)

NULL

Base for which the reservation is raised for.

RsMr_AIS_Component

varchar(30)

NULL

Lin or Pln module which reserved the MR. Note that this information is maintained at MR header level also.

RsMr_AIS_LoginOu

decimal(10,1)

NULL

OUInstance ID of the Lin or Pln module which reserved the MR. Note that this information is maintained at MR header level also.

RsMr_OUInstance

decimal(10)

NOT NULL

MR OUInstance ID.

RsMr_Reservation_Id

decimal(10,1)

NOT NULL

Reservation Id generated by AIS for a Event-Package-JobCard-Position.

RsMr_MReq_No

varchar(40)

NOT NULL

Material Request Document No.

RsMr_Line_No

decimal(10)

NOT NULL

MR Line Number.

Table Name MR_MRDA_Doc_Attach_Dtl

Table Comment It holds the Reference Document information for a Material Request.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MRDA_OUInstance

decimal(10)

NOT NULL

OU ID

MRDA_Return_No

char(18)

NOT NULL

System generated number for the Return transaction based on the ’Numbering Type’ chosen.

MRDA_MREQ_NO

varchar(40)

NOT NULL

The type of the reference document based on which the material request is raised. The reference document could be of types “Component Work Order”, &nbsp“Technical Log”, "Visit Package" "Hangar Work Order" or “Others”.

MRDA_Ref_Doc_Type

varchar(15)

NOT NULL

The type of the reference document based on which the material request is raised. The reference document could be of types Component Work Order, &nbspTechnical Log. "Visit Package" "Hangar Work Order" or Others.

MRDA_Doc_Id

varchar(40)

NOT NULL

The name of the reference document.

MRDA_File_Name

varchar(50)

NULL

The file name of the reference document.

MRDA_Remarks

varchar(225)

NULL

Any additional comment pertaining to the association of the reference document to the material request.

Table Name MR_MRDtl_Matrl_Req_Prt_Dtl

Table Comment This entity contains the Part list for the MR document.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MRDtl_OUInstance

decimal(10)

NOT NULL

MR OUInstance ID.

MRDtl_MReq_No

varchar(40)

NOT NULL

The number identifying the material request.

MRDtl_Line_No

decimal(10)

NOT NULL

The number identifying the row in the multiline in which the part is entered.

MRDtl_Req_Part_Crt_OU

decimal(10)

NULL

Requested Part Created OUInstance.

MRDtl_Req_Part_No

varchar(40)

NULL

The number identifying the part for which the material request is raised.

MRDtl_Req_Qty

decimal(28,8)

NULL

The total quantity of the part required

MRDtl_Req_Uom

varchar(10)

NULL

The unit of measurement of the required parts

MRDtl_Req_Qty_InStkUom

decimal(28,8)

NULL

Requested Part Qty in Stock Uom.

MRDtl_Alt_Part_Crt_OU

decimal(10)

NULL

Alternate Part Created OUInstance.

MRDtl_Alt_Part_No

varchar(40)

NULL

The number identifying the alternate part that can be used if the part entered in the “Requested Part #” is not available.

MRDtl_Part_Status

varchar(40)

NULL

Part/Stock Status.

MRDtl_Prefrd_Cond

varchar(5)

NULL

The preferred condition of the requested part 1. New - Indicates that the part must be new or purchased recently 2.Overhauled - Indicates that some maintenance action or servicing must be done on the part, and the part has not been used after servicing 3.Serviceable - Indicates that the part must be in a usable condition 4.Unserviceable -Indicates that the part can be in the unusable state

MRDtl_Exp_Return_Date

datetime

NULL

The expected date on which the part must be returned

MRDtl_Remarks

varchar(255)

NULL

General comments regarding part details

MRDtl_Issued_Qty

decimal(28,8)

NULL

The quantity of the issued part

MRDtl_Issued_Qty_InStkUom

decimal(28,8)

NULL

Quantity that has been totally issued for the MR line item (in stock uom).

MRDtl_Auth_Qty

decimal(28,8)

NULL

The total quantity authorized for the part

MRDtl_Auth_Qty_InStkUom

decimal(28,8)

NULL

Authorised Quantity in Stock UOM

MRDtl_TLog_TotAlc_QtyInStkUom

decimal(28,8)

NULL

Tech Log Allocated Quantiry in Stock UOM- Sum of Part Requested Quantity in Stock UOM which are Allocated to many Tech Log numbers.

MRDtl_Shortclose_Flag

varchar(5)

NULL

This will indicate whether the line item is shortclosed or not. It will ’Y’ if it is short closed else it will be ’N’.

MRDtl_Created_User

varchar(30)

NULL

The name of the user who created the material request

MRDtl_Created_Date

datetime

NULL

The date on which the material request was created

MRDtl_Modified_User

varchar(30)

NULL

The name of the user who last modified the material request

MRDtl_Modified_Date

datetime

NULL

The date on which the material request was last modified

MRDtl_Task_Ou

decimal(10)

NULL

Task OU Id of the Task in the WorkOrder.

MRDtl_Task_No

varchar(40)

NULL

Task Id for which part is estimated in the WorkOrder.

MRDtl_Task_KeySeqNo

decimal(10)

NULL

The task serial number associated with the work order for every part requested, if the reference document type is CWO.

MRDtl_LineLvl_Status

varchar(40)

NULL

This will indicate the line level status. It will be one of the following :- PIsu  - Partially Issued ShCl  - Short Closed Isu             - Completely Issued NULL        - Authorized and no issue or                               &nbspshortclose has happened.

MRDtl_ShCls_Qty

decimal(28,8)

NULL

The quantity of the short closed part

MRDtl_ShCls_Qty_InStkUom

decimal(28,8)

NULL

Short Closed Quantity in Stock UOM.

MRDtl_ShortClose_Comments

varchar(255)

NULL

Additional comments or remarks pertaining to the material request which typically are reasons for short closing the material request.

MRDtl_Acc_Usage

varchar(20)

NULL

The accounting usage to be used.

MRDtl_Cc_Usage

varchar(20)

NULL

The costing usage to be used

MRDtl_Fin_Book

varchar(20)

NULL

Finance book.

MRDtl_Acc_Code

varchar(32)

NULL

Account Code.

MRDtl_Anly_Code

varchar(5)

NULL

Analysis Code.

MRDtl_SubAnly_Code

varchar(5)

NULL

Sub Analysis Code.

MRDtl_Costcenter_Code

varchar(20)

NULL

Cost Center Code.

MRDtl_Rtn_Qty_InStkUom

decimal(28,8)

NULL

For Maint MR alone, pending return quantity needs to be tracked. This will have the total returned qty for the MR-Part..

MRDtl_Req_Type

varchar(5)

NULL

The requirement type of the part, which could be Normal or Specific.

MRDtl_Mat_Type

varchar(5)

NULL

The material type, which could be Main Core or Regular.

MRDtl_Alt_Allowed

varchar(5)

NULL

Displays Specific Alternates if alternate part numbers can be considered in place of the requested part number, when the Requested Part #”is not available. Displays Not Allowed if alternate part numbers cannot be considered.

MRDTL_RECEIVED_QTY

decimal(28,8)

NULL

The quantity of part received..

MRDTL_RECEIVED_QTY_INSTKUOM

decimal(28,8)

NULL

The unit of measurement of the received part .

MRDTL_NEWPART

varchar(40)

NULL

Column to check whether its a New Part or Not. Value stored with Y and N

MRDTL_DISCREPANCY_NO

varchar(40)

NULL

To store the DISCREPANCY_NO

MRDTL_DISCREPANCY_OU

int

NULL

To store DISCREPANCY_OU

MRDTL_NEWPART_DESC

varchar(150)

NULL

To store New part desc

MRDTL_REQ_MODE

Varchar(5)

NOT NULL

To store the Request mode

MRDTL_EFFECTIVITY_NOTES

Varchar92000)

NULL

To store the effectivity notes

Table Name MR_MRMn_Matrl_Req_Main_Hdr

Table Comment This table &nbspallows you to &nbspstore the create a material request transaction details.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MRMn_OUInstance

decimal(10)

NOT NULL

MR OUInstance.

MRMn_MReq_No

varchar(40)

NOT NULL

A unique number identifying the material request

MRMn_Class

varchar(5)

NULL

system provides the following options: 1.Maintenance - this option indicate that the MR is created for a maintenance requirement. 2.General  - this option indicate that the MR is created for a general requirement

MRMn_Type

varchar(5)

NULL

type of the material request.   If the MR Class is Maintenance or General, the system provides the following options: 1. Planned- Indicates that the material request is raised due to planned maintenance activities or execution documents, which contain the list of materials required. 2. Unplanned - Indicates that the material request is raised from the unplanned maintenance activities such as the line station.

MRMn_Priority

varchar(5)

NULL

the priority of the material request 1. Normal - MR raised for parts that pertain to the usual requirement of an aircraft 2. AOG - MR raised for the aircraft on ground

MRMn_Category

varchar(25)

NULL

The category to which the material request belongs This will have the list of active quick codes defined for MR category in the Quick Code activity.

MRMn_Need_Date

datetime

NULL

The date on which the parts will be consumed or needed

MRMn_Warehouse_OU

decimal(10)

NULL

Warehouse OUInstance ID.

MRMn_Warehouse_No

varchar(10)

NULL

The number identifying the warehouse where you are located.

MRMn_User_Status

varchar(25)

NULL

The user-defined status of the material request

MRMn_MR_Status

varchar(5)

NULL

MR Document Status. . List of codes and values for MR Status Draft                             - Drft Fresh                            - Frsh Authorized                    - Auth Cancelled                     - Can Partially issued              - PIss Issued                           - Iss Short closed                  - ShCls Closed                           - Cls

MRMn_Aircraft_OU

decimal(10)

NULL

Aircraft OUInstance ID.

MRMn_Aircraft_Reg_No

varchar(30)

NULL

The registration number of the aircraft for which the parts are required

MRMn_Component_Ou

char(18)

NULL

Component Ouinstance ID.

MRMn_Component_Id

varchar(90)

NULL

The number identifying the component for which the materials are required

MRMn_Work_Center_OU

decimal(10)

NULL

WorkCenter OUInstance ID.

MRMn_Work_Center

varchar(30)

NULL

The number identifying the work center where the parts are required

MRMn_Station_Code

varchar(32)

NULL

The number identifying the station where the parts are required

MRMn_Requesting_Locn

decimal(10)

NULL

The organization unit from where the material request is prepared.

MRMn_Source_Flag

varchar(5)

NULL

Will be LIN or PLN

MRMn_Ref_Doc_Type

varchar(5)

NULL

This indicates the type of the reference document. The reference document type based on which the material request is prepared List of codes and values for Ref Doc Type Component work order       - &nbspCWo Line work order                  - &nbspLWo Tech Log                           - &nbspTLog Others                                - &nbspOth Hanger WorkOrder            - &nbspHwo Lin                                      - LIN Planning                             - PLN

MRMn_Ref_Doc_No

varchar(40)

NULL

The number identifying the reference document based on which the material request is prepared.

MRMn_Requestor_OU

decimal(10)

NULL

OUInstance ID to which the Requester belongs to..

MRMn_Requestor

varchar(20)

NULL

The number identifying the employee who made the request for the part. The employee name will be displayed alongside

MRMn_Requestor_Name

varchar(150)

NULL

The name identifying the employee who made the request for the part. The employee name will be displayed alongside.

MRMn_Hard_Alloc_Reqd

varchar(5)

NULL

Indicates whether the part need to be hard allocated.

MRMn_Iss_In_Single_Lot

varchar(5)

NULL

This indicates whether the parts can be issued in a staggered manner as and when available.

MRMn_User_Def_1

varchar(25)

NULL

Additional details pertaining to the material request.

MRMn_User_Def_2

NULL

MRMn_Delivery_Instruction

varchar(255)

NULL

Delivery Instructions for the MR.

MRMn_Remarks

varchar(255)

NULL

Additional remarks pertaining to the material request, which typically are reasons for modifying the material request.

MRMn_ShortClose_Comments

varchar(255)

NULL

Additional comments or remarks pertaining to the material request which typically are reasons for short closing the material request.

MRMN_PART_TYPE

varchar(5)

NULL

The type of the part.

MRMn_Auth_By

varchar(30)

NULL

The name of the user who approved the material request

MRMn_Auth_Date

datetime

NULL

The date on which the material request was approved

MRMn_AutoMR_Flag

varchar(5)

NULL

If the MR is automatically generated by the system thru LineWo, CWo, etc AutoMR_Flag will be ’Yes’. This needs to be maintained because system should ensure that MR created thru the respective workorder component cannot be modified in ’Edit MR’..

MRMn_Created_Datetime

datetime

NULL

The date on which the material request was created

MRMn_Created_User

varchar(30)

NULL

The name of the user who created the material request

MRMn_Modified_Datetime

datetime

NULL

The date on which the material request was last modified

MRMn_Modified_User

varchar(30)

NULL

The name of the user who last modified the material request

MRMn_Timestamp

decimal(10)

NULL

Timestamp of a Record.

MRMN_REF_DOC_OU

decimal(10)

NULL

ou of the reference doc

MRMn_FileName

varchar(50)

NULL

The name of the file used for document reference that is associated to the material request

MRMn_Wf_New_State

varchar(10)

NULL

Currect state of Material Request in Work Flow.

MRMn_Wf_Doc_Key

varchar(128)

NULL

Work flow Document Key It will have the Material Request number concatenated with MR Created Ouinstance ID.

MRMn_Acc_Usage

varchar(20)

NULL

The accounting usage to be used.

MRMn_Cc_Usage

varchar(20)

NULL

The costing usage to be used

MRMN_REQUEST_FOR

sql_variant

NOT NULL

specify whether the material request is created for internal parts, customer parts or both the internal and customer parts

MRMN_CUSTOMER_ID

sql_variant

NULL

The code identifying the customer.

MRMN_CUSTOMER_OU

int

NULL

OU Instance of the Customer.

MRMN_ISU_OPTION

varchar(5)

NULL

To store the Issue option either Document level or Line Level

MRMN_MMD_PRINT_FLAG

sql_variant

NULL

To enable selective ’MMD Printing’.

Table Name MR_MrPrm_parameter_details

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MrPrm_ComponentName

varchar(80)

NOT NULL

Component Name.

MrPrm_ParamCategory

varchar(10)

NOT NULL

Parameter Category.

MrPrm_ParamType

varchar(15)

NOT NULL

Paramter Type.

MrPrm_ParamCode

varchar(5)

NOT NULL

Parameter Code.

MrPrm_Langid

decimal(10)

NOT NULL

Language ID.

MrPrm_ParamDesc

varchar(80)

NULL

Parameter Description.

MrPrm_CreationDate

datetime

NULL

Creation Date.

MRPRM_SORTBY

decimal(10)

NULL

Sort By. -It is sequential numbers used to load combo values in some predefined order

Table Name MR_MRQc_Quick_Code

Table Comment This table allows you to store &nbspcreate material request quick code

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MRQc_OUInstance

decimal(10)

NOT NULL

Quickcode Created Ouinstance ID.

MRQc_Quick_Code

varchar(25)

NOT NULL

A unique identifier for the quick code

MRQc_Type

varchar(80)

NOT NULL

the quick code type for which quick codes have to be defined. The system provides the options: MR Category and User Status. .

MRQc_Desc

varchar(80)

NULL

The textual description of the quick code

MRQc_Status

varchar(15)

NULL

The system provides the options:Active and Inactive.

MRQc_CreatedDate

datetime

NULL

The date on which the quick code was created

MRQc_Created_By

varchar(30)

NULL

The login ID of the user who has created the quick code.

MRQc_ModifiedDate

datetime

NULL

The date on which the quick code was last modified

MRQc_Modified_By

varchar(30)

NULL

The login ID of the user that last modified the quick code.

MRQc_Timestamp

decimal(10)

NULL

Timestamp of a Record.

Table Name MR_MRSL_MatReq_SrlLot

Table Comment It holds the Part Serial Lot information. If Part Requirement type is Specific for a MR, Serial - Lot information will be stored.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MRSL_Bin_Id

varchar(10)

NULL

Bin Id.

MRSL_Zone_Id

NULL

Zone ID.

MRSL_Lot_No

varchar(18)

NULL

The preferred lot number of the part.

MRSL_Req_QtyInStkUom

decimal(28,8)

NULL

Requested Quantity in Stock UOM.

MRSL_Req_Uom

varchar(10)

NULL

Requested UOM.

MRSL_Req_Qty

decimal(28,8)

NULL

Requested Quantity in Requested UOM.

MRSL_Part_Status

varchar(40)

NULL

Part Status.

MRSL_MReq_No

varchar(40)

NOT NULL

The number identifying the material request.

MRSL_Line_No

decimal(10)

NOT NULL

The number identifying the row in the multiline in which the part is entered.

MRSL_OUInstance

decimal(10)

NOT NULL

MR OUInstance ID.

MRSL_Srl_No

varchar(40)

NULL

The preferred serial number of the part.

MRSL_Req_Part_No

varchar(40)

NULL

The number identifying the part for which the material request is raised.

MRSL_Seq_No

decimal(10)

NOT NULL

Sequence Number.

MRSL_Req_Part_OU

decimal(10)

NULL

Request part created Ouinstance ID.

Table Name MR_MRTLog_MatReq_Prt_Info

Table Comment This entity contains the List of parts of a &nbspMR document allocated to Tech logs.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

MRTLog_Req_Part_Ou

decimal(10)

NULL

Requested Part Created Ouinstance.

MRTLog_TLog_Line_No

decimal(10)

NULL

Tech Log Line No.

MRTLog_Req_Part_No

varchar(40)

NULL

Request Part Number.

MRTLog_Alloc_QtyInStkUom

decimal(28,8)

NULL

Part Requested Qunatity in Stock UOM.

MRTLog_Part_Status

varchar(40)

NULL

Requested Part Status.

MRTLog_MReq_No

varchar(40)

NOT NULL

Material Request Document No.

MRTLog_OUInstance

decimal(10)

NOT NULL

MR OUInstance ID.

MRTLog_TechLog_No

varchar(40)

NOT NULL

Tech Log Number.

MRTLog_Line_No

decimal(10)

NOT NULL

Line Number.

MRTLog_TechLog_OU

decimal(10)

NOT NULL

Tech log Ouinstance.