Part Administration

Part Administration

Table Name PRT_ALT_MAD
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRALT_CREATED_OUINSTANCE	decimal(10)	NOT NULL	OU Instance	No	No
PRALT_PART_NO	varchar(40)		Part No
PRALT_ALT_PART_OUINSTANCE	decimal(10)		Alternate part ouInstance
PRALT_ALT_PART_NO	varchar(40)		The number identifying the part, which can be fitted in place of the reference part number, if the reference part number is not available.
PRALT_INTERCHANGE_RULE	varchar(5)	NULL	Interchanging rule
PRALT_ORDER_OF_PREF	decimal(10)		Order of Preference
PRALT_REMARKS	varchar(255)		Remarks
PRALT_CREATED_BY	varchar(30)	NOT NULL	User who created the details
PRALT_CREATED_DATE	datetime		Dates at which the user created the details
PRALT_MODIFIED_BY	varchar(30)		User who modified the details
PRALT_MODIFIED_DATE	datetime		Date at which the user modified the details

Table Name PRT_ALT_MAD
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
RplHis_Lead_time	decimal(28,8)	NULL		No	No
RplHis_Leadtime_uom	varchar(10)
RplHis_Carrying_Cost	decimal(28,8)
RplHis_Ordering_Cost
RplHis_Updated_Date	datetime
RplHis_Ser_Level_Factor	decimal(28,8)
RplHis_Update_Mode	varchar(10)
RplHis_Forecast_Factor	decimal(28,8)
RPLHIS_UPDATED_BY	varchar(30)
RplHis_PrtPlan_Ou	decimal(10)	NOT NULL		Yes
RplHis_Part_No	varchar(40)		Part/Stock/Item No. This could be equivalent to Airline Stock Number. These parts which are created in the system are also referred as ’Internal’ Part #		Yes
RplHis_Part_Crt_Ou	numeric(10)		This is the OUInstance Id where the Part is Created (for more details, see entity description)
RplHis_Ouinstance	decimal(10)				No
RplHis_Annual_Consumption	decimal(28,8)	NULL		No
RplHis_Safety_Stock
RplHis_SeqNo	numeric(28)	NOT NULL		Yes
RplHis_Reorder_Level	decimal(28,8)	NULL		No
RplHis_Reorder_Qty

Table Name PRT_CONDALT_ALTERNATE_PARTS

Table Comment Table to store the details of conditional and customer specific alternates
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRT_CONDALT_CREATED_OU	int	NOT NULL	Created OU	Yes	No
PRT_CONDALT_PART_NO	sql_variant		Part No
PRT_CONDALT_ALT_PART_NO			Alternate part no
PRT_CONDALT_ALT_PART_OU	int		Alternate part OU
PRT_CONDALT_ALT_TYPE	sql_variant		Alternate type, whether it is conditional or customer specific
PRT_CONDALT_CUST_ID			Customer ID , if customer specific
PRT_CONDALT_PART_OU	int		Part OU	No
PRT_CONDALT_INTERCHG_RULE	sql_variant	NULL	Interchanging rule
PRT_CONDALT_ORDER_OF_PREF	int	NOT NULL	Order of perference
PRT_CONDALT_REMARKS	sql_variant		Remarks
PRT_CONDALT_CUST_OU	int		Customer OU
PRT_CONDALT_ALT_CONDITION	sql_variant		Condition, if conditional alternate
PRT_CONDALT_TIMESTAMP	int		TimeStamp for concurrency check and the no of time the record gets modified
PRT_CONDALT_CREATED_BY	sql_variant		User who created the record.
PRT_CONDALT_CREATED_DATE			Date at which the user created the details
PRT_CONDALT_MODIFIED_BY			User who modified the record.
PRT_CONDALT_MODIFIED_DATE			Date at which the user modified the details

Table Name Prt_Grptmp_Type_Hier_Tmp

Table Comment This is for building the group code hieararchy.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Grptmp_Guid	varchar(40)	NOT NULL	When we delete the record ,All the deleted will be stored for deleting child.	No	No
Grptmp_Group_Type	varchar(20)	NULL	Group Type
Grptmp_Group_Code	varchar(40)		Group Code
Grptmp_Imd_Parent
Grptmp_Level_No	numeric(10)

Table Name Prt_HAZMAT_Dtl_Gen_Info
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrtHAZMAT_ouinstance	int	NOT NULL	This column is used to store ouinstance .	Yes	No
PrtHAZMAT_Part_No	sql_variant		This field is used to store ’Part No’ value
PrtHAZMAT_HAZMAT_Id		NULL	This column is used to store ’HAZMAT ID’ value	No
PrtHAZMAT_HAZMAT_Class			This column is used to save the ’HAZMAT Class’ value
PrtHAZMAT_Ship_Name			This column is used to store ’Shipping Name’ value
PrtHAZMAT_Limit_Qty	bigint		This column is used to store the ’Limited Qty’ value
PrtHAZMAT_PackType	sql_variant		This column is used to store the ’Packaging Type’ value
PrtHAZMAT_PackGrp			This column is used to store the ’Package Group’ value
PrtHAZMAT_Pack_Inst	char(18)		This column is used to store’packaging Instruction’ value
PrtHAZMAT_Handling_Inst			This &nbspcolumn is used to store the ’Handling Instruction’value
PrtHAZMAT_Filename	sql_variant		This column is used to store the ’Filename’value

Table Name PRT_INFO_MAD_1
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRCRL_CREATED_OUINSTANCE	decimal(10)	NOT NULL	Ou Instatance	No	No
PRCRL_PART_NO	varchar(40)		Part No
PRCRL_PART_DESC	varchar(150)		Part Description
PRCRL_PART_DESC_UP			Part Description in Uppercase
PRCRL_REFERENCE_STATUS	varchar(5)		Reference Status
PRCRL_KEYWORD	varchar(25)	NULL	A keyword to easily identify the part (Alphanumeric, 25).
PRCRL_KEYWORD_UP			Keyword in upper case.
PRCRL_PART_TYPE	varchar(5)	NOT NULL	It will have "Expendable",Component","Tool", "Miscellaneous",Consumable","Kit","Raw material’
PRCRL_PART_CATEGORY	varchar(25)	NULL	Part Category
PRCRL_MANUF_PART_NO	varchar(40)		manufacturar Part no
PRCRL_FILENAME	varchar(50)		The name of the file used for document reference that is associated with the part
PRCRL_BASE_PART_NO	varchar(40)		The number identifying the base part
PRCRL_MANUF_NO	varchar(45)		Manufacturar No
PRCRL_AC_MANUF_OU	decimal(10)		Manufacturar Ou
PRCRL_SUP_MANUF_OU
PRCRL_ISSUE_BASIS	varchar(5)
PRCRL_PART_CNTRL_TYPE	varchar(25)		Part Control type
PRCRL_PREV_PART_NO	varchar(40)		The number given to the part previously
PRCRL_DRAWING_REF			The number identifying the document containing the drawing reference
PRCRL_DRAWING_REVISION_NO			The revision number of the drawing document
PRCRL_MOD_STATUS_NO	varchar(15)
PRCRL_SOURCE_DOC_TYPE	varchar(5)
PRCRL_SOURCE_DOC_OUINSTANCE	decimal(10)
PRCRL_SOURCE_DOC_NO	varchar(40)
PRCRL_SUGGESTED_PART_NO
PRCRL_DOC_REVISION_NO
PRCRL_MATERIAL_SPEC	varchar(255)
PRCRL_SL_NO_CONTROL_FLAG	varchar(25)
PRCRL_SL_NO_LOGIC	varchar(5)
PRCRL_SL_NO_TYPE_NO
PRCRL_LOT_NO_CONTROL_FLAG	varchar(25)
PRCRL_LOT_NO_TYPE_NO	varchar(5)		Numbering type for Lot no
PRCRL_STD_COST	decimal(28,8)	NOT NULL	Standard cost
PRCRL_PLANNING_TYPE	varchar(5)		It will have "Min-max", Reorder Level","None" ]
PRCRL_EXPENCE_TYPE	varchar(25)	NULL	It will have "Capital", "Revenue"
PRCRL_SHELF_LIFE_UNIT	varchar(5)
PRCRL_DESIGNED_SHELF_LIFE	decimal(28,8)		Designed Shelf Life
PRCRL_MIN_SHELF_LIFE			Minimum Shelf Life
PRCRL_ALERT_VALUE			Alert Value for Shelf Life
PRCRL_UOM_OUINSTANCE	decimal(10)	NOT NULL
PRCRL_STOCK_UOM	varchar(10)		The unit of measurement in which the part is stocked
PRCRL_GROSS_VOLUME	decimal(28,8)	NULL	The gross volume of the part (Decimal). The gross volume must be greater than zero.
PRCRL_VOLUME_UOM	varchar(10)		The unit of measurement in which the volume of the part is measured
PRCRL_GROSS_WEIGHT	decimal(28,8)		The gross weight of the part (Decimal).
PRCRL_WEIGHT_UOM	varchar(10)
PRCRL_USER_DEFINED_DTL1	varchar(25)		User Defined Detail &nbsp1
PRCRL_USER_DEFINED_DTL2
PRCRL_REMARKS	varchar(255)		Remarks
PRCRL_CREATED_BY	varchar(30)	NOT NULL	User who created the details
PRCRL_CREATEDDATE	datetime		Date at which the user created the details
PRCRL_MODIFIED_BY	varchar(30)		User who modified the details
PRCRL_MODIFIEDDATE	datetime		Date at which the user modified the details
PRCRL_TIMESTAMP	decimal(10)		TimeStamp for concurrency check and the no of time the record gets modified
PRCRL_PART_ACC_GRP	varchar(20)	NULL	Account Group Details
PRCRL_PRIMEPART_NO	varchar(40)		Primary part no
PRCRL_WORK_CENTER	varchar(30)		Work center Name
PRCRL_MODEL	varchar(20)		The number identifying the primary aircraft model

Table Name Prt_levcde_level_code

Table Comment This table will have one column to store the level code.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
levcde_levelcode	numeric(10)	NOT NULL		Yes	No

Table Name PRT_NWPRTTMP_EONEWPARTS_TMP

Table Comment This Is for processing new part requirement from EO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
NWPRTTMP_OUINSTANCE	numeric(10)	NOT NULL	OuInstance	No	No
NWPRTTMP_GUID	varchar(40)		When we delete the record ,All the deleted will be stored for deleting child.
NWPRTTMP_SUGGESTED_PARTNO		NULL
NWPRTTMP_PART_DESC	varchar(150)		Part Description
NWPRTTMP_EXISTING_PARTNO	varchar(40)		Existing Part Number
NWPRTTMP_MCRPARTNO
NWPRTTMP_PARTTYPE	varchar(25)		Part type
NWPRTTMP_SRCDOCTYPE
NWPRTTMP_SRCDOCNO	varchar(40)
NWPRTTMP_REVISIONNO

Table Name prt_otherprt_cust_tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
otherprt_Guid	sql_variant	NOT NULL	When we delete the record ,All the deleted will be stored for deleting child.	No	No
otherprt_created_ouinstance	int		Created Ou
otherprt_part_no	sql_variant		Part no
otherprt_other_part_no			Other part no
otherprt_other_part_desc		NULL	Part Description
otherprt_cust_no		NOT NULL	Customer Id

Table Name Prt_Parameter_Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_ComponentName	varchar(80)	NOT NULL	Name of the component	Yes	No
Prt_ParamCategory	varchar(10)		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.
Prt_ParamType	varchar(25)		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.
Prt_ParamCode	varchar(10)		Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component
Prt_LangId	numeric(10)		Language id. This is the language id of the record.
Prt_ParamDesc	varchar(80)	NULL	Param Description	No
Prt_Sortby	numeric(10)		The order in which the values are populated.
Prt_CreationDate	datetime		Date at which details are created.

Table Name PRT_PGRTMP_PARTGROUP_TMP

Table Comment This is for PartGroup processing.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PGRTMP_GUID	varchar(40)	NOT NULL	When we delete the record ,All the deleted will be stored for deleting child.	No	No
PGRTMP_GROUPCODE		NULL	Group Code
PGRTMP_OUINSTANCE	numeric(10)		OuInstance

Table Name PRT_PLNPRTTMP_PLANG_PARTS_TMP
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PLNPRTTMP_OUINSTANCE	numeric(10)	NOT NULL		No	No
PLNPRTTMP_GUID	varchar(40)		When we delete the record ,All the deleted will be stored for deleting child.
PLNPRTTMP_PART_NO		NULL
PLNPRTTMP_PART_DESC	varchar(150)
PLNPRTTMP_PART_TYPE	varchar(25)
PLNPRTTMP_PLNG_STATUS	varchar(40)
PLNPRTTMP_PLNG_TYPE	varchar(25)

Table Name Prt_PrAlt_Alternate_Parts

Table Comment This is an extension to the Part CRL List. This contains the Alternate Or Substitute part details. Alternate part are one or more part numbers, which can substitute a particular part number (based on interchangeability rules) in the event of non-availability of stock of that specific part. The alternate part # will always be valid part existing in the Inventory. At the time of issue, the stores clerk will be able to issue an alternate Part number if the requested part number is not available in stock. In case part numbers are interchangeable with one another only for a specific model of aircraft or specific component family or specific position code, the details should be identified in the Configuration component and not in Part Administration component.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrAlt_created_by	varchar(30)	NOT NULL	User who created the details	No	No
PrAlt_remarks	varchar(255)	NULL	Remarks if any
PrAlt_order_of_pref	numeric(10)		Order of Preference. Data type of field is changed to UDD_SeqNo
PrAlt_created_date	datetime	NOT NULL	Date at which the user created the details
PrAlt_modified_by	varchar(30)		User who modified the details
PrAlt_modified_date	datetime		Date at which the user modified the details
PrAlt_part_no	varchar(40)		Internal Part No	Yes	Yes
PrAlt_created_ouinstance	numeric(10)		This is the OUInstance Id where the Part is Created (for more details, see entity description of PrCRL table)
PrAlt_interchange_rule	varchar(5)	NULL	If the interchangeable rule is set as ’Two-Way’, then system assumes that the main part also is a substitute to alternate parts (and an reverse entry is also inserted) Following lists &nbspthe interchangeable rule codes and their description OW One Way TW Two Ways	No	No
PrAlt_alt_part_ouinstance	numeric(10)	NOT NULL	Alternative Part Created OUInstance	Yes
PrAlt_alt_part_no	varchar(40)		Alternate or Substitute Part No

Table Name Prt_PrAtt_Part_Attrib_Map
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrAtt_Trackable_Flag	varchar(25)	NULL	It will have "Y" or "N"	No	No
PrAtt_Usage_Type			Usage Type
PrAtt_Std_Qlt_Value	varchar(80)		Standard Qualitative Value
PrAtt_Modified_By	varchar(30)		User who modified the details
PrAtt_Created_By			User who created the details
PrAtt_Created_Date	datetime		Date at which the user created the details
PrAtt_Modified_Date			Date at which the user modified the details
PrAtt_part_no	varchar(40)	NOT NULL	Part/Stock/Item No. This could be equivalent to Airline Stock Number. These parts which are created in the system are also referred as ’Internal’ Part #	Yes	Yes
PrAtt_Attribute_OU	numeric(10)		Attribute Ou		No
PrAtt_created_ouinstance			This is the OUInstance Id where the Part is Created (for more details, see entity description)		Yes
PrAtt_Max_Value	numeric(20,8)	NULL	Maximum Value	No	No
PrAtt_Std_Value			Standard Value
PrAtt_Attribute_Code	varchar(10)	NOT NULL	Attribute Code	Yes
PrAtt_Min_Value	numeric(20,8)	NULL	Minimum Value	No

Table Name Prt_PrCrl_CentralRefList_Info

Table Comment This table contains the Part main details for a OU Group. Eg. Let’s assume OU1, OU2, OU3 as self interacting. If Part is created in OU1, it means the same part is also available in OU2 and OU3. &nbspIf Part is created in OU2, it means the same part is also available in OU1 and OU3. Parts defined in any of these OUs will be like a central reference list to all other interacting OUs.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrCrl_created_ouinstance	numeric(10)	NOT NULL	This is the OUInstance Id where the Part is Created (for more details, see entity description)	Yes	No
PrCrl_part_no	varchar(40)		Part/Stock/Item No. This could be equivalent to Airline Stock Number. These parts which are created in the system are also referred as ’Internal’ Part #
PrCrl_part_desc	varchar(150)		Description of &nbspthe Part No	No
PRCRL_PART_DESC_UP			Part Description stored in Upper case.
PrCrl_reference_status	varchar(5)		Reference status can have the following codes A(Active) U(Under Creation) B( )
PrCrl_keyword	varchar(25)	NULL	This will have the short text which can be commonly used to quickly search/identify a Part
PRCRL_KEYWORD_UP			key word Stored in Upper case.
PrCrl_part_type	varchar(5)	NOT NULL	The broad classification of the part into raw material, components, spare parts, kits, consumables, tools and services. Following lists &nbspthe codes and their description CM Component CNSMB Consumable KIT Kit RWMTR Raw Material SP Spare Part TOOL Tool
prCrl_part_category	varchar(25)	NULL	Part Categories can be classified by the user in ’Create QuickCode’ activity under the Quick Type ’Part Category’. A part will belong to one of these categories.
PrCrl_manuf_part_no	varchar(40)		This will have the Manufacturer’s identity for the part. Applicable mainly for parts of the type ’component’
PrCrl_Filename	varchar(50)
PrCrl_base_part_no	varchar(40)		This is the original part from which the new part is derived (Original Part # could have got changed based on a service bulletin or even internal Engineering order. So after the change, the Part is recreated in the system again as ’new’ part. While creating the new partno, the original part no is given...)
PrCrl_manuf_no	varchar(45)		Manufacturer name
PrCrl_ac_manuf_ou	numeric(10)		If the manufacturer is available in Aircraft, Aircraft OU will be stored here.
PrCrl_sup_manuf_ou			If the manufacturer is available in Supplier, Supplier OU will be stored here.
PrCrl_Issue_Basis	varchar(5)		This will be "Returnable", "Core Returnable" Or "Non-Returnable". Rtn - Returnable CrRtn - Core Returnable NRtn - Non Returnable
PRCRL_PART_CNTRL_TYPE	varchar(25)
PrCrl_prev_part_no	varchar(40)		This will have the last part from which the new part is derived
PrCrl_drawing_ref			This will have the reference Drawing Number of the part
PrCrl_drawing_revision_no			This will have the reference Drawing Revision No
PrCrl_mod_status_no	varchar(15)		This will have the stamping No which is mainly applicable for parts of the type ’component’
PrCrl_source_doc_type	varchar(5)		The type of reference document on basis of which the part # is created. Will have values like Engineering Order, IPC etc Following lists &nbspthe codes and their description EO EO IPC IPC OTH Others
PrCrl_source_doc_ouinstance	numeric(10)		This will have the Org Unit where the Reference Source Document is created and is available
PrCrl_source_doc_no	varchar(40)		This will have the reference document No on the basis of which the part # is created
PrCrl_suggested_part_no			The part # suggested by the source document like Engineering order
PrCrl_doc_revision_no			This will have the Revision No of reference document No on the basis of which the part # is created
PrCrl_material_spec	varchar(255)		Material Specification
PrCrl_sl_no_control_flag	varchar(25)		This will have the value ’Y’ for serial number controlled parts. For parts which are not serial number controlled, it will have the value ’N’
PrCrl_sl_no_logic	varchar(5)		For parts which are serial number controlled, the logic for generating the internal serial # could be based on the manufacturer serial number or could be generated based on numbering pattern. AUT Automatic Generation MSI Manufacturer Sl No
PrCrl_sl_no_type_no			The numbering pattern to be used by the system for generating the serial # if the serial number generation logic is set as ’Automatic’
PrCrl_lot_no_control_flag	varchar(25)		This will have the value ’Y’ if the part is lot controlled else it will have the value ’N’
PrCrl_lot_no_type_no	varchar(5)		This will have the numbering pattern to be used by the system for lot number
PrCrl_std_cost	decimal(28,8)	NOT NULL	The cost or the Standard Rate of the Part for valuation purpose
PrCrl_planning_type	varchar(5)		The method by which the requirement of the part must be planned. It will have values like Reorder, Min max etc Following lists the Codes for planning types and their description DSP Disposition MM Min-Max NONE None RL Reorder Level
PRCRL_EXPENCE_TYPE	varchar(25)	NULL	This will the default expense type of the part. Following lists the Codes for Expense types and their description CAP Capital REV Revenue
PrCrl_shelf_life_unit	varchar(5)		This will have the time unit of the designed shelf life. Following lists the Codes for Shelf life and their description D Days M Month W Weeks Y Years
PrCrl_designed_shelf_life	decimal(28,8)		This will have the period for which a part can be maintained on the shelf without any deterioration of characteristics Note: Value will be stored as what the user enters and not in the lowest unit...
PrCrl_min_shelf_life			A Part should be having a minimum of this shelf life without which part can not be received (There will be validation for this in Unplanned Receipt or in GR)
PrCrl_alert_value			This will have the alert value for shelf life expiry
PrCrl_uom_ouinstance	numeric(10)	NOT NULL	OUInstance Id where the Stock Uom is created
PrCrl_stock_uom	varchar(10)		The unit of measurement in which the part is stocked across all locations
PrCrl_gross_volume	decimal(28,8)	NULL	This will have the volume of the Part
PrCrl_volume_uom	varchar(10)		Volume Uom Code
PrCrl_gross_weight	decimal(28,8)		Gross Weight
PrCrl_weight_uom	varchar(10)		UomCode of Gross Weight
PrCrl_NSN_No	varchar(25)		User can enter NSN no for the Specific Part #
PrCrl_Link_Flag	char(18)
PrCrl_user_defined_dtl1	varchar(25)		User can define some additional details for the part in Dtl1 , Dtl2
PrCrl_user_defined_dtl2
PrCrl_Remarks	varchar(255)		Remarks
PrCrl_created_by	varchar(30)	NOT NULL	User who created the details
PrCrl_createddate	datetime		Date at which the user created the details
PrCrl_modified_by	varchar(30)		User who modified the details
PrCrl_modifieddate	datetime		Date at which the user modified the details
PrCrl_timestamp	numeric(10)
PrCrl_part_acc_grp	varchar(20)	NULL	Part Account Group
PrCrl_PrimePart_No	varchar(40)		Prime Part Number for the Main Part Number
PrCrl_Work_Center	varchar(30)		Default Work Center for the Part No
PrCrl_Model	varchar(20)		Default Model No for the Part No.
PrCrl_Shelflife_Extendable	sql_variant		Stores Shelf Life Update Flag as Yes/No
PRCRL_ATA_UDC	decimal(2)
Prcrl_Strip_Part_no	varchar(30)	NOT NULL	strip part no will be stored here.
PRCRL_Non_Stockable	sql_variant	NULL	This column is used to store the ’Non Stockable’ combo value
PRCRL_RefDocumentNo	varchar(40)	NULL	This column is used to store the Reference Document number.
PRCRL_RefDocumentType	varchar(25)	NULL	This column is used to store the Reference document type.
PRCRL_RefNotes	varchar(2000)	NULL	This column is used to store the reference notes.

Table Name Prt_PrDA_Doc_Attach_Dtl

Table Comment Document Attached Detail for the Partno
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrDA_Doc_Id	varchar(40)	NOT NULL	Document Id	Yes	No
PrDA_File_Name	varchar(50)	NULL	Reference File Name	No
PrDA_Remarks	varchar(255)		Remarks (if any)
PrDA_created_ouinstance	numeric(10)	NOT NULL	This is the OUInstance Id where the Part is Created (for more details, see entity description)	Yes	Yes
PrDA_Ref_Doc_Type	varchar(15)		Reference Document Type		No
PrDA_part_no	varchar(40)		Part/Stock/Item No. This could be equivalent to Airline Stock Number. These parts which are created in the system are also referred as ’Internal’ Part #		Yes

Table Name Prt_PrGpAt_PartGrp_Attribs

Table Comment Attributes associated to Partno
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrGpAt_Crt_OUInstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
PrGpAt_Group_Code	varchar(40)		Group code.
PrGpAt_Attrib_Code	varchar(10)		Attribute code which is refferred from Attribute component.		No
PrGpAt_Attrib_OU	numeric(10)	NULL	Attribute created Ou.	No
PrGpAt_Min_Value	numeric(20,8)		Minimum value
PrGpAt_Max_Value			Maximum value.
PrGpAt_Std_Qlt_Value	varchar(80)		standard Quality value.
PrGpAt_Std_Qnt_Value	numeric(20,8)		Standard Quantitive value

Table Name Prt_PrGpPr_PartGrp_Parts

Table Comment Part and Group code Association table.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrGpPr_Part_Crt_Ou	numeric(10)	NOT NULL	Part created Ouinstance.	Yes	No
PrGpPr_Part_No	varchar(40)		Part No
PrGpPr_Prim_PrtGp_Flg	sql_variant	NULL	Primary Part Group for the Part will be "Y" and the other Part Groups will be "N"	No
PrGpPr_Group_Code	varchar(40)	NOT NULL	Group code.	Yes	Yes
PrGpPr_Crt_OUInstance	numeric(10)		Ouinstance.

Table Name Prt_PrGpTy_Group_Types

Table Comment Group Type Information.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrtGpTy_OUInstance	numeric(10)	NOT NULL	Part Group Type OuInstance (where the Group type is defined)	Yes	No
PrtGpTy_Group_Type	varchar(20)		Group Type
PrtGpTy_Description	varchar(80)	NULL	Group Type Description	No
PrtGpTy_Description_Up			Group Type Description in upper case.
PrtGpTy_Usage	varchar(25)		Usage could be the following "Maintenance", "Inventory", "Purchase", "Sales", "Operation" , "Accounting & "Others". add blank.
PrtGpTy_Status	varchar(15)		Status could be ’Active’ or ’InActive’
PrtGpTy_Created_Datetime	datetime		Date at which the user created the details
PrtGpTy_Created_By	varchar(30)		User who created the details
PrtGpTy_Modified_Datetime	datetime		Date at which the user modified the details
PrtGpTy_Modified_By	varchar(30)		User who modified the details
PrtGpTy_Timestamp	numeric(10)		Timestamp for Concurrency checking.

Table Name Prt_PrGpTyMp_PrGrp_Type_Map

Table Comment This is hieararchy table for the grouptype and groupcode.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrGpTyMp_Group_Code_Ou	numeric(10)	NULL	Group Code created Ou.	No	No
PrGpTyMp_Group_Type_Ou			Group type Ou.
PrGpTyMp_Imd_Parent	varchar(40)		Immediate Parent.
PrGpTyMp_Level_No			Level No
PrGpTyMp_OUInstance	numeric(10)	NOT NULL	Part Group Type OuInstance (where the Group type is defined)	Yes	Yes
PrGpTyMp_Group_Code	varchar(40)		Group code		No
PrGpTyMp_Group_Type	varchar(20)		Associated Group type.		Yes

Table Name Prt_PrGrp_Part_Group_Info

Table Comment Group code Information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrGrp_Crt_OUInstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
PrGrp_Group_Code	varchar(40)		Group code.
PrGrp_Description	varchar(150)	NULL	Group code descruiption	No
Prgrp_Description_Up			Description stored in Upper case.
PrGrp_Status	varchar(25)		Group code Status.
PrGrp_Map_Attrib_Flag			Map attribute flag (Y or N).
PrGrp_Map_Parts_Flag			Map parts flag (Yor N).
PrGrp_Created_By	varchar(30)		User who created the details
PrGrp_Created_Date	datetime		Date at which the user created the details.
PrGrp_Modified_By	varchar(30)		User who modified the details
PrGrp_Modified_Date	datetime		Date at which the user modified the details
PrGrp_Timestamp	numeric(10)		Timestamp for Concurrency checking.
PRGRP_CTRL_GROUP	sql_variant		It will have "Y" or "N"
PRGRP_PURPOSE			It will have "Pricing" or "Taxes and charges" or "Product Line" or " Capability Definition" or "Vat"

Table Name Prt_PrkitInf_Kit_Info

Table Comment This is an extension to the Part CRL List. This contains the Part Kit Composition details which is maintained at a OU Group level. For the part created in one OU, Kit composition details are stored here The kit is a collection of multiple spare parts supplied as a whole by the Vendor or the manufacturer. Kits are generally used as a whole in the execution of any maintenance activity. Kit constitution involves identification of the individual parts (along with the quantities) that make up the Kit. The individual part # will always be valid part existing in the Inventory.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrkitInf_created_by	varchar(30)	NOT NULL	User who created the details	No	No
PrkitInf_remarks	varchar(255)	NULL	Kit composition details if any can be given here
PrkitInf_createddate	datetime	NOT NULL	Date at which the details are created
PrkitInf_modified_by	varchar(30)		User who modified the details
PrkitInf_modifieddate	datetime		Date at which the details are modified
PrKitInf_part_no	varchar(40)		Internal Part No which is of Part Type ’Kit’	Yes	Yes
PrKitInf_created_ouinstance	numeric(10)		This is the OUInstance Id where the Part is Created (for more details, see entity description of PrCRL table)
PrkitInf_est_qty	decimal(28,8)	NULL	It describes the Item Quantity	No	No
PrKitInf_kit_ouinstance	numeric(10)	NOT NULL	Created OUInstance of the Kit Part # (that is the constituent Part No’s Created OUInstance)	Yes	Yes
PrKitInf_kit_part_no	varchar(40)		Kit Part # (that is the constituent Part No)

Table Name Prt_PrOpSet_Option_Settings

Table Comment Option setting Information for new part and standard cost validation.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrOpSet_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
PrOpSet_std_cost_mand_flag	varchar(25)	NULL	Standard cost Mandatory Flag.	No
PrOpSet_new_part_chk_flag			New Part Check Flag.
PrOpSet_Created_By	varchar(30)	NOT NULL	User who created the record.
PrOpSet_CreatedDate	datetime		Date at which the record is created
PrOpSet_Modified_By	varchar(30)		User who modified the record.
PrOpSet_ModifiedDate	datetime		Date at which the record is modified.
PrOpSet_Timestamp	numeric(10)		Timestamp for the Concurrency check.
PROPSET_DEFVALMET	sql_variant	NULL	Default Valuation method
PROPSET_PRIPRTGRPMAND			Primary part group mandatory
PROPSET_DEFPRTACTGRP			Default part account group
PROPSET_CAPDEF			Cap def
PROPSET_PRODLINE			Product line
PROPSET_PRICING			Pricing
PROPSET_TAXCHARGE			Tax Charge
PROPSET_VAT			VAT
PROPSET_APPL_VALMET

Table Name Prt_PrOthprt_other_part_info

Table Comment This is an extension to the Part CRL List. A part may have different identifications used by the organization using the part and individual vendors and manufacturers. The same part may be identified differently by the industry, customer or even Competitor. Many a times there may be a requirement for finding out the reference number used by a vendor (from whom the part could be purchased) for a part. During placement of purchase order, either the vendor part number can be mentioned or it may be sufficient to specify the manufacturer part numbers along with manufacturer code. Other part numbers are the equivalent (used by vendors/competitors/other available sources) of the internal part numbers.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrOthPrt_remarks	varchar(255)	NULL	Remarks if any	No	No
PrOthPrt_nscm_no	varchar(5)		NATO SCM Code assigned to the manufacturer
PrOthPrt_cage_no			Cage code assigned to the manufacturer
PrOthPrt_modified_by	varchar(30)	NOT NULL	User who modified the details
PrOthPrt_created_by			User who created the details
PrOthPrt_createddate	datetime		Date at which the user created the details
PrOthPrt_modifieddate			Date at which the user modified the details
PrOthPrt_part_no	varchar(40)		Part No	Yes	Yes
PrOthPrt_Line_No	numeric(10)		Since Other Part No can duplicate and a combination of Source Desc, Other Part No, Other Part Desc, SourceType, Cage No, Nscm No all together forms the key and all of them except other part no + one of them being mandatory, it will be difficult to process without a key. So, LineNo is reqd to serve as a key [hidden to the user] to this entity		No
PrOthPrt_created_ouinstance			Part Created OUInstance		Yes
PrOthPrt_source_type	varchar(80)	NULL	This could be ’Manufacturer’ or ’Vendor’ or ’Competitor’ as defined in the Source Type activity	No	No
PrOthPrt_other_part_desc	varchar(150)		Description of the ParCode of the manufacturer/competitor for our system Internal Part #
PrOthPrt_source_desc			This could be the manufacturer/competitor name
PrOthPrt_other_part_no	varchar(40)	NOT NULL	Equivalent ParCode of the manufacturer/competitor for system Internal Part #

Table Name Prt_PrPlInf_Planning_Info

Table Comment This table contains OU Specific Planning Information for Parts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrPlInf_created_by	varchar(30)	NOT NULL	User who created the details	No	No
PrPlInf_Avg_Trnfr_Leadtime	decimal(28,8)	NULL
PrPlInf_created_date	datetime	NOT NULL	Date at which the details are created
PrPlInf_modified_by	varchar(30)		User who modified the details
PrPlInf_modified_date	datetime		Date at which the details are modified
PrPlInf_ved_class	varchar(5)	NULL	One of the methods of Stock Analysis Following are the list of VED codes and their description V (V) E (E) D (D) None (None)
PrPlInf_Trnfr_Leadtime_Uom			Will indicate the average transfer lead time UOM - Days, Weeks or months
PrPlInf_Allocable_Horizon	decimal(28,8)		The number of days beyond which hard allocation for a part cannot be made.
PrPlInf_Allocable	varchar(5)		This will indicate whether the part is hard allocable or not. It will be ’Y’ if the part can be hard allocated and it will be ’N’ if the part cannnot be hard allocated
PrPlInf_fsn_class			One of the methods of Stock Analysis Following are the list of FSNcodes and their description F (F) S (S) N (N) None (None)
PrPlInf_Repln_Leadtime_Uom	varchar(10)		The lead time unit, which could be Days, Weeks”, Months or Years.
PrPlInf_Repln_Leadtime	decimal(28,8)		The total lead time required for the replenishment activity to be completed (Decimal).
PrPlInf_Action_Phaseout	varchar(25)		Action on phase out
PrPlInf_Cert_Reqd	sql_variant		It will have "Yes" or "No"
PrPlInf_timestamp	numeric(10)	NOT NULL	TimeStamp for concurrency check
PrPlInf_Annual_Consumption	decimal(28,8)	NULL	The annual consumption of the part stocked in the inventory
PrPlInf_Carrying_Cost			The miscellaneous cost such as the cost incurred for handling hazardous types of parts or breakable parts (Decimal).
PrPlInf_Ser_Level_Factor			The level (in percentage) to which the service has been provided to the MRO for the request of material. This is calculated as: Number of times service provided + Quantity of parts provided to the MRO based on the request
PrPlInf_Ordering_Cost			The miscellaneous cost such as transportation charges and electricity charges incurred on the part (Decimal).
PrPlInf_expensing_policy	sql_variant	NOT NULL	It will have "Core value on Phase out" or "First Issue" or "On Phased out"
PrPlInf_valuation_method	varchar(5)		The inventory costing method to be used for the part in the location. It will have values Like Std. Cost, LIFO etc Following lists &nbspthe Cost Valuation Codes and their description AC Actual Cost FIFO FIFO LIFO LIFO SC Standard Cost WAR Wt Avg Rate
PrPlInf_material_controller	varchar(20)	NULL	Employee Code of the person who is in charge of maintaining the stock of a location
PrPlInf_reservation_horizon	decimal(28,8)		The number of days beyond which reservation for a part cannot be made.
PrPlInf_reorder_activated_by	varchar(5)		Re-order activated by indicates the method of reordering at a location Following lists the RAB Codes and their description BPO BPO NONE None PO PO PR PR ST Stock Transfer
PrPlInf_reorder_activated_at			Following lists the ’reorder activated at’ codes stored and their description LOC Location NONE None WHS Warehouse The value will indicate whether reorder level calculations are done at location level or at warehouse level
PrPlInf_ouinstance	numeric(10)	NOT NULL	Part Planning OU	Yes
PrPlInf_planning_status	varchar(40)		Following lists &nbspthe planning status codes and their description A Active F Fresh I InActive	No
PrPlInf_part_no			Internal Part #	Yes	Yes
PrPlInf_created_ouinstance	numeric(10)		Part Created OU
PrPlInf_picking_strategy	varchar(5)	NULL	Picking Strategy for the part indicates the strategy to be adopted for automatically finding the default storage address details from where the part can be issued.	No	No
PrPlInf_abc_class			One of the methods of Stock Analysis Following are the list of ABC codes and their description A (A) B (B) C (C) None (None)
PrPlInf_warehouse_ouinstance	numeric(10)		OUInstance of the standard warehouse
PrPlInf_xyz_class	varchar(5)		One of the methods of Stock Analysis Following are the list of XYZ codes and their description X (X) Y(Y) Z(Z) None(None)
PrPlInf_placement_strategy			Placement Strategy for the part indicates the strategy to be adopted for automatically finding the default storage address details where the part can be received
PrPlInf_min_qty	decimal(28,8)		It describes the Item Quanity
PrPlInf_reorder_level
PrPlInf_max_qty
PrPlInf_safety_stock
PrPlInf_reorder_qty
PrPlInf_min_issue_qty

Table Name Prt_PrPlLoc_Part_Def_Wh_Loc
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrPlLoc_Issue_Location	decimal(10)	NULL	Issue OU Instance (Transfer From Location)	No	No
PrPlLoc_Def_Wh_Id	varchar(10)		Warehouse Id in the location where the part has to be put by default
PrPlLoc_StkTrn_Src_Wh_Ou	numeric(10)		Stock Transfer Warehouse location
PrPlLoc_StkTrn_Src_Wh_Id	varchar(10)		Sourcing warehouse for stock transfer
PrPlLoc_Transfer_Location	decimal(10)		Stock Transfer Location [Transfer Processing Location]
PrPlLoc_ouinstance	numeric(10)	NOT NULL	Part Planning OU	Yes	Yes
PrPlLoc_Def_Wh_Ou			This is the storage admin OUInstance Id for which default warehouse and stock transfer details are specified		No
PrPlLoc_created_ouinstance			Part Created OU		Yes
PrPlLoc_part_no	varchar(40)		Internal Part #

Table Name Prt_PrPuDtl_Purchase_Dtl

Table Comment This table contains the Purchase Details for parts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRPUDTL_ORDERING_LOCN_OUINSTAN	numeric(10)	NOT NULL	It will be either the PurchaseOrder [PO] OUInstance or ReleaseSlip [RS] OUInstance	Yes	No
PrPuDtl_created_ouinstance			Ouinstance	No	Yes
PrPuDtl_default_flag	varchar(5)	NULL	Y(Yes) N(No)		No
PrPuDtl_OuInstance	decimal(10)	NOT NULL		Yes	Yes
PrPuDtl_componentname	varchar(20)		Component Name		No
PrPuDtl_part_no	varchar(40)		Part Number		Yes

Table Name Prt_PrPuInf_Purchase_Info

Table Comment This table contains OU Specific Purchase Information for Parts Note: Purchase information can be defined only if reference status of the part is ’Active’
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrPuInf_created_by	varchar(30)	NOT NULL	User who created the record.	No	No
PrPuInf_createddate	datetime		Date at which the record is created.
PrPuInf_modified_by	varchar(30)		User who modified the record.
PrPuInf_min_ord_qty	bigint	NULL	It describes the Item Quantity
PrPuInf_post_order_lead_time			Post Order Lead Time
PrPuInf_prc_order_lead_time			Prc Order Lead Time
PrPuInf_Work_Unit_type	char(18)
PrPuInf_Task_Auth_OU
PrPuInf_modifieddate	datetime	NOT NULL	Date at which the record is modified.
PrPuInf_timestamp	numeric(10)		Timestamp for the Concurrency check.
PrPuInf_Work_Unit_No	char(18)	NULL
PrPuInf_Insp_WO
PrPuInf_COM
PrPuInf_pref_supplier	varchar(45)	NOT NULL	The default vendor or supplier to whom the order for the part must be placed from this location
PrPuInf_supplier_ouinstance	numeric(10)		Supplier Ouinstance
PrPuInf_std_pur_price	bigint		The rate of the part as per the stock UOM , which will be defaulted when Purchase Requests/ Purchase Orders are generated
PrPuInf_OuInstance	char(18)			Yes
PrPuInf_part_no	varchar(40)		Part No		Yes
PrPuInf_created_ouinstance	numeric(10)		OUinstance
PrPuInf_pre_order_lead_time	bigint	NULL	Pre Order Lead Time	No	No
PrPuInf_purchase_uom	varchar(10)	NOT NULL	Purchase UOM
PrPuInf_lead_time_uom		NULL	Lead Time Unit of Measurement
PrPuInf_pstv_tolerance	bigint		Positive Tolerance
PrPuInf_ngtv_tolerance			Negative Tolerance
PrPuInf_uom_ouinstance	numeric(10)	NOT NULL	UOM OUinstance
PrPuInf_receipt_horizon	bigint	NULL	Receipt Horizon

Table Name Prt_PrPuInf_Purchase_Info

Table Comment This table contains OU Specific Purchase Information for Parts Note: Purchase information can be defined only if reference status of the part is ’Active’
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRPUINF_OUINSTANCE	decimal(10)	NOT NULL	Ou Instance	Yes	No
PRPUINF_PART_NO	varchar(40)		Part No
PRPUINF_CREATED_OUINSTANCE	decimal(10)		Created Ou
SerPuH_Pln_OUInstance	numeric(28)		Ouinstance		Yes
SerPuH_Crt_OUInstance	decimal(10)		Location Id where the service is created
SerPuH_Service_No	varchar(40)		Service Number entered by the user or generated by the system
PRPUINF_PREF_SUPPLIER	varchar(45)		The default supplier with whom the order must be placed (Alphanumeric, 45). The preferred supplier must have been defined in the “Create Supplier” activity of the “Supplier” business component and must be in “Active” status.	No	No
PRPUINF_SUPPLIER_OUINSTANCE	decimal(10)		Supplier Ouinstance
PRPUINF_STD_PUR_PRICE	decimal(28,8)		Purchase Price
PRPUINF_PSTV_TOLERANCE		NULL	The maximum excess quantity in percentage, which can be received in comparison to the quantity ordered (Integer). The value in this field must be greater than zero.
PRPUINF_NGTV_TOLERANCE			The minimum deficit quantity in percentage, which can be received in comparison to the quantity ordered (Integer). The value in this field must be greater than zero.
PRPUINF_RECEIPT_HORIZON			The interim time interval between two purchase requests for the part (Numeric). The value in this field must be greater than zero.
PRPUINF_UOM_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance
PRPUINF_PURCHASE_UOM	varchar(10)		The unit of measurement in which the part is purchased (Alphanumeric, 10). Mandatory. The UOM must be defined in the “Create UOM” activity of the “Unit of Measurement Administration” business component and must be in “Active” status.
PRPUINF_LEAD_TIME_UOM		NULL	Use the drop-down list box to select the unit of measurement of the lead-time. The lead time could be measured in “Days”, “Weeks”, “Months” or “Years”.
PRPUINF_PRE_ORDER_LEAD_TIME	decimal(28,8)		The time required for pre-order processing (Integer). The value in this field must be greater than zero.
PRPUINF_PRC_ORDER_LEAD_TIME			The time taken to process an order (Integer). The value in this field must be greater than zero.
PRPUINF_POST_ORDER_LEAD_TIME			The time between the date of ordering and the date of supplying (Integer).
PRPUINF_MIN_ORD_QTY			The minimum quantity that is ordered, whenever a purchase request or a purchase order is generated (Integer). The value in this field must be greater than zero.
PRPUINF_CREATED_BY	varchar(30)	NOT NULL	User who created the record.
PRPUINF_CREATEDDATE	datetime		Date at which the record is created.
PRPUINF_MODIFIED_BY	varchar(30)		User who modified the record.
PRPUINF_MODIFIEDDATE	datetime		Date at which the record is modified.
PRPUINF_TIMESTAMP	decimal(10)		Timestamp for the Concurrency check.
PrPuInf_Insp_WO	varchar(25)	NULL
PrPuInf_Work_Unit_No	varchar(30)		The number identifying the work unit (Alphanumeric, 30). This field is mandatory if you have selected “Required” in the “Insp. WO?” field.
PrPuInf_Work_Unit_type	varchar(25)		Use the drop-down list box to specify the type of the work unit that must be included in the work order. The system lists the options “Standard Procedure” and “Task”, and displays “Task” by default.
PrPuInf_Task_Auth_OU	int		Authorize Ou
PrPuInf_COM	varchar(25)		Component
SerPuH_pref_supplier	varchar(45)	NOT NULL	The default vendor or supplier to whom the order for the part must be placed from this location
%AttName	numeric(10)		decimal(10)
SerPuH_std_pur_price	bigint		The rate of the part as per the stock UOM , which will be defaulted when Purchase Requests/ Purchase Orders are generated
SerPuH_pstv_tolerance		NULL	Positive Tolerance
SerPuH_ngtv_tolerance			Negative Tolerance
SerPuH_receipt_horizon			Receipt Horizon
%AttName	numeric(10)	NOT NULL	˜I able Value
SerPuH_purchase_uom	varchar(10)		Purchase UOM
SerPuH_lead_time_uom		NULL	Lead Time Unit of Measurement
SerPuH_pre_order_lead_time	bigint		Pre Order Lead Time
SerPuH_prc_order_lead_time			Prc Order Lead Time
SerPuH_post_order_lead_time			Post Order Lead Time
SerPuH_min_ord_qty			It describes the Item Quantity
SerPuH_created_by	varchar(30)	NOT NULL	User who created the record.
SerPuH_createddate	datetime		Date at which the record is created.
SerPuH_modified_by	varchar(30)		User who modified the record.
SerPuH_modifieddate	datetime		Date at which the record is modified.
SerPuH_timestamp	numeric(10)		Timestamp for the Concurrency check.

Table Name Prt_PrSlInf_Sale_Info

Table Comment This table contains OU Specific Sales Information for Parts Note: Sales information can be defined only if reference status of the part is ’Active’
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrSlInf_modifieddate	datetime	NOT NULL	Date at which the user modified the details	No	No
PrSlInf_timestamp	numeric(10)		TimeStamp for the concurrency check
PrSlInf_modified_by	varchar(30)		User who modified the details
PrSlInf_createddate	datetime		Date at which the user created the details
PrSlInf_created_by	varchar(30)		User who created the details
PrslInf_Appl_At	sql_variant	NULL	Load whether the Info is applicable at Location/Warehouse Level.
PrslInf_Var_Price			Load Variable Pricing with "Allowed"/"Not Allowed"
PrslInf_Est_Pricing_Bas			Est. Pricing based on Pricing basis should be if Pricing Basis "Actual Iss Cost" then load with "Max Purchase" "Std Sales Price".
PrslInf_Pricing_Bas			Load Pricing basis based on Variable Pricing with "Lifo"/"Fifo".,
PrslInf_Min_Stk_limit	bigint		It describes the Item Quantity
PrSlInf_created_ouinstance	numeric(10)	NOT NULL	Part Created OUInstance		Yes
PrSlInf_std_sales_package	decimal(28,8)	NULL	It describes the Item Quantity		No
PrSlInf_part_no	varchar(40)	NOT NULL	Internal Part No	Yes	Yes
PrSlInf_ouinstance	numeric(10)		Sales OUInstance		No
PrSlInf_ngtv_tolerance	decimal(28,8)	NULL	Negative Tolerance:	No
PrSlInf_pstv_tolerance			Positive Tolerance:
PrSlInf_uom_ouinstance	numeric(10)	NOT NULL	OUInstance of Sales Uom
PrSlInf_std_sales_price	decimal(28,8)	NULL	The rate of the part as per the stock UOM , which will be defaulted when Purchase Requests/ Purchase Orders are generated
PrSlInf_sales_uom	varchar(10)	NOT NULL	Sales Uom : Unit of measurement in which the part can be sold

Table Name Prt_PrSrcTyp_Source_Types

Table Comment This table contains Source Type which will be used in the ’Other Parts’ UI There could be zero or more other parts defined with the same source type. Source types could be like ’Manufacturer’ or ’Competitor’...
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrSrcTyp_created_ouinstance	numeric(10)	NOT NULL	OUinstance	Yes	No
PrSrcTyp_source_type	varchar(80)		Three values are predefined Manufacturer Others Supplier and the other values are defined by the user
PrSrcTyp_source_flag	varchar(25)		Source Flag should be either UserDef or PreDef	No
PrSrcTyp_created_by	varchar(30)		User who created the details
PrSrcTyp_createddate	datetime		Date at which the details are created
PrSrcTyp_modified_by	varchar(30)		User who modified the details
PrSrcTyp_modifieddate	datetime		Date at which the details are modified

Table Name PRT_PRTADDL_VALINFO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRTADDL_PART_NO	sql_variant	NOT NULL	A unique code identifying the part.The part number must be unique across all the organizational units.	Yes	No
PRTADDL_CREATED_OUINSTANCE	int		Part Created OUInstance
PRTADDL_INSPECTION	sql_variant		It will have "Expense Off" or "Add to Stock"	No
PRTADDL_OVERHAUL
PRTADDL_OTHERS
PRTADDL_REPAIR
PRTADDL_RESIDUAL_VALUE		NULL	Residual Value
PRTADDL_VARIABLE_VALUE			Variable Value Basis
PRTADDL_STD_COREVALUE	numeric		Standard Core Value
PRTADDL_CREATED_BY	sql_variant	NOT NULL	User who created the details
PRTADDL_CREATED_DATE			Date at which the details are created
PRTADDL_MODIFIED_BY			User who modified the details
PRTADDL_MODIFIED_DATE			Date at which the user modified the details
PRTADDL_TIMESTAMP	decimal(10)	NULL	Timestamp for the concurrency check

Table Name PRT_PRTATR_CHGREQ_DTL

Table Comment This table is used to store the &nbspmultiline details in Record New part Rewuest/Part Attribute Chage
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrtAtrdtl_ChgReq_Ouinstance	int	NOT NULL	This column the ouinstance value	Yes	No
PrtAtrdtl_Request_No	varchar(40)		This column used to hold Request No value
PrtAtrdtl_Lineno	int	NULL	This column holds value indicating Line No	No
PrtAtrdtl_Refdoctyp	varchar(25)		This column holds value -reference document type
PrtAtrdtl_Refdocno	varchar(40)		This column holds the Ref.Doc No value
PrtAtrdtl_filename	varchar(50)		This column holds filename value
PrtAtrdtl_remarks	varchar(255)		This column holds Remarks value

Table Name PRT_PRTATR_CHGREQ_HDR

Table Comment Added to hold the Nre part Request /part Attribute Change values
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrtAtr_ChgReq_Ouinstance	int	NOT NULL	This column holds ouinstance value	Yes	No
PrtAtr_Request_No	varchar(40)		This column holds the Request No
PrtAtr_Request_Date	datetime		This column holds the Request Date
PrtAtr_Request_Type	varchar(25)		This column holds the Request Type
PrtAtr_Empid	varchar(77)		This column holds the Request By value
PrtAtr_Newpart_No	varchar(40)	NULL	This column holds the New Part No	No
PrtAtr_part_Desc	varchar(150)		This column holds the Part desciption
PrtAtr_Altrforpart_No	varchar(40)		This column holds the part description
PrtAtr_Numbering_Type	varchar(5)		This column holds the Numbering Type of the Request
PrtAtr_Request_Status			This column holds the Request Status
PrtAtr_User_Status	varchar(25)		This column holds the Request User status
PrtAtr_Priority	varchar(20)		This column holds the Request Priority
PrtAtr_ReqCat	varchar(25)		This column holds the Request Category value
PrtAtr_Prtyp_to			This column holds the Part Type To value
PrtAtr_Prtattpart_No	varchar(40)		This column holds the Part No value that is available in the Part Attribute &nbspChange Cluster
PrtAtr_Refdtlpart_No			This column holds the Part No avaiable in the Reference Details cluster
PrtAtr_Prtyp_from	varchar(25)		This column holds the Part type From value
PrtAtr_CtrlTyp_from			This column holds the Control type from value
PrtAtr_CtrlTyp_To	sql_variant		This column holds the Control type To value
PrtAtr_Altrpartno	varchar(40)		This column holds the Alternate part No value
PrtAtr_Aircraftno	varchar(30)		This column holds the AircraftNo value
PrtAtr_WrkCtr	sql_variant		This column holds the Workcenter value
PrtAtr_Station	varchar(40)		This column holds the Station value
PrtAtr_refDoctyp	varchar(25)		This column holds the Reference Document type value
PrtAtr_Refdocno	varchar(40)		This column holds the Reference Document No value
PrtAtr_OthRef	varchar(80)		This column holds the Other references value
PrtAtr_SourceDocType	varchar(40)		This column holds the Source Document Type value
PrtAtr_SourceDocNo			This column holds the Source Document No value
PrtAtr_DocReviNo			This column holds the Document revision No value
PrtAtr_MatSpecific	varchar(255)		This column holds the material Specification value
PrtAtr_DrawReference	varchar(40)		This column holds the Drawing Reference value
PrtAtr_DrawRevisionNo			This column holds the Drawing Revision No value
PrtAtr_OtherDetails	varchar(255)		This column holds the other Details value
PrtAtr_RequestorRemarks			This column holds the Requestor Remarks value
PrtAtr_ConfirmComments			This column holds the Confirmation Comments value
PrtAtr_crtdby	varchar(30)	NOT NULL	This column holds the Created By value
PrtAtr_crtdate	datetime	NULL	This column holds the Created date value
PrtAtr_lastmodby	varchar(30)	NOT NULL	This column holds the last Modified By value
PrtAtr_lastmoddate	datetime	NULL	This column holds the Last modified date value
PrtAtr_confirmedby	varchar(30)		This column holds the confirmed By value
PrtAtr_confirmdate	datetime		This column holds the Confirmed date value
PrtAtr_Timestamp	int		This column holds the Timestamp value
PrtAtr_AltPartFlag	varchar(25)		This column holds value indicating existence of Alternate part No
PrtAtr_CtrlTypFlag			This column holds value indicating existence of control type
PrtAtr_PrtTypFlag			This column holds value indicating existence of Part type
PrtAtr_CreatedPartno	varchar(40)		This column holds value indicating the Created part No
PrtAtr_AutoFlag	varchar(5)
PrtAtr_Rejectedby	sql_variant	NOT NULL	This column is used to store the Rejected By details
PrtAtr_Rejecteddate		NULL	This column is used to store the Rejected date
PrtAtr_Rejectioncomments	nchar(256)		This column is used to save the Rejection comments
PrtAtr_CtrlTyp_DocNo	varchar(40)		To store the control type
PrtAtr_PrtTyp_DocNo			To store the part type

Table Name PRT_PRTHLPTMP_OTHPARTHELP_TMP

Table Comment This is for Other partno.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRTHLPTMP_GUID	varchar(40)	NOT NULL	When we delete the record ,All the deleted will be stored for deleting child.	No	No
PRTHLPTMP_PART_OUINSTANCE	numeric(10)
PRTHLPTMP_PART_NO	varchar(40)
PRTHLPTMP_PART_DESC	varchar(150)
PRTHLPTMP_PART_TYPE	varchar(80)

Table Name Prt_PRTNT_PartNoteDtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRTNT_OUinstance	int	NOT NULL	Ouinstance	Yes	No
PRTNT_PartNo	sql_variant		This column holds the Part No	Yes	No
PRTNT_LineNo	int		This column holds the Line No	Yes	No
PRTNT_NoteType	sql_variant	NULL	This column holds the Note type that will be defaulted in Purchase request	No	No
PRTNT_NoteDesc			This column holds the description of the Note Type	No	No
PRTNT_standard			This column states if the the note type specified has to be defaulted or not.	No	No
PRTNT_RefDate	datetime		This column holds the reference date	No	No
PRTNT_Clasfcn	char(25)		This column holds the class function details	No	No
PRTNT_CreatedBy	sql_variant	NOT NULL	This column holds the user who created the note	No	No
PRTNT_CreatedDate	datetime	NULL	This column holds the date when the user created the note	No	No
PRTNT_ModifiedBy	sql_variant	NOT NULL	This column holds the user who modified the note	No	No
PRTNT_ModifedDate	datetime	NULL	This column holds the date when the user modified the note	No	No
PRTNT_Remarks	varchar(4000)	NULL	This column holds the remarks for the note types.	No	No
PRTNT_FileName	varchar(50)	NULL	This column holds the reference file name for the note types.	No	No

Table Name Prt_Prtqc_quick_code
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prtqc_ouinstance	numeric(10)	NOT NULL	OUinstance	Yes	No
Prtqc_type	varchar(5)		PrCat(Part Category)
Prtqc_quick_code	varchar(25)		Quick code
Prtqc_description	varchar(80)		Quick Code Description	No
Prtqc_status	varchar(15)		Quick Code Status
Prtqc_created_by	varchar(30)		User who created the Quick Code
Prtqc_created_date	datetime		Date at which the Quick Code can be create
Prtqc_modified_by	varchar(30)		User who modified the record.
Prtqc_modified_date	datetime		Date at which the record is modified.
Prtqc_timestamp	numeric(10)		Timestamp for the Concurrency check.

Table Name PRT_PRTTMP_SEARCHID_GEN_TMP

Table Comment This is for Advance Search Id creation.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRTTMP_GUID	varchar(40)	NOT NULL		No	No
PRTTMP_OUINSTANCE	numeric(10)	NULL
PRTTMP_PART_NO	varchar(40)
PRTTMP_PART_DESC	varchar(150)		Part Description
PRTTMP_PART_DESC_UP			Part Description in upper case.
PRTTMP_MANUF_PART_NO	varchar(40)		Manufacturar Part No
PRTTMP_PART_CATEGORY	varchar(25)		Part Category
PRTTMP_BASE_PART_NO	varchar(40)
PRTTMP_KEYWORD	varchar(25)		Keyword
PRTTMP_KEYWORD_UP			Keyword &nbspin upper case.
PRTTMP_REFERENCE_STATUS	varchar(5)
PRTTMP_PART_TYPE
PRTTMP_STOCK_UOM	varchar(10)
PRTTMP_PRIMEPART_NO	varchar(40)
PRTTMP_PRTWCCODE	varchar(30)
PRTTMP_PLANNINGTYPE	varchar(5)

Table Name Prt_PrUCON_Uom_Conv_Info

Table Comment This is an extension to the Part CRL List. This contains the Part dependant uom conversion details which is maintained at a OU Group level. For the part created in one OU, Part dependant uom conversion details are stored here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrUcon_created_by	varchar(30)	NOT NULL	User who created the details	No	No
PrUcon_conv_factor	decimal(28,8)		The factor for converting FromUOM of the part to ToUom
PrUcon_created_date	datetime		Date at which the details are created
PrUcon_modified_by	varchar(30)		User who modified the details
PrUcon_modified_date	datetime		Date at which the details are modified
PrUcon_part_no	varchar(40)		Internal Part No	Yes	Yes
PrUcon_created_ouinstance	numeric(10)		This is the OUInstance Id where the Part is Created (for more details, see entity description of PrCRL table)
PrUcon_to_uom	varchar(10)		To UomCode		No
PrUcon_uom_ouinstance	numeric(10)		OUInstance Id where From/To UomCode is defined
PrUcon_from_uom	varchar(10)		From UomCode

Table Name Prt_PrUsg_Usage_Src_Gen_Info

Table Comment This is a OU Specific part additional planning information. Usage info indicates the purpose for which the part must be used in the location like Maintainable, Saleable, Poolable, Exchangeable. There can be multiple usage for a part. For example, a part can be maintainable and can be exchangeable Source info indicates the source from which the item can be obtained in the location like Purchased, On loan, Pooled, On Exchange, subcontracted. A part can have multiple sources. E.g. a part can be ’purchased’ at times and could occasionally be ’on loan’. General info contains whether the following identification/tags is reqd for the part: &nbspQC Clearance &nbspBack Flushing &nbspStorage Allocation &nbspHazardous
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrUsg_pooled_source	varchar(5)	NULL	Contains ’Y’ if part source is poolable else ’N’	No	No
PrUsg_onexchange_source			Contains ’Y’ if part source is exchange else ’N’
PrUsg_onloan_source			Contains ’Y’ if part source is loanable else ’N’
PrUsg_subcontracted_source			Contains ’Y’ if part source is subcontracted else ’N’
PrUsg_hazardous_general			’Y’ if the part is hazardous else ’N’
PrUsg_qc_clearance_reqd			’Y’ if QC Clearance is reqd for the part else ’N’
PrUsg_storage_alloc_mandatory			’Y’ if Storage Allocation is reqd for the part else ’N’
PrUsg_back_flushing_reqd			’Y’ if Back Flushing is reqd for the part else ’N’
PrUsg_on_warranty			’Y’ if the Part is ’On Warranty’ else ’N’
PrUsg_created_ouinstance	numeric(10)	NOT NULL	Part Created OUInstance		Yes
PrUsg_maint_usage	varchar(5)	NULL	Contains ’Y’ if part usage is maintainable else ’N’		No
PrUsg_part_no	varchar(40)	NOT NULL	Internal Part #	Yes	Yes
PrUsg_ouinstance	numeric(10)		Planning OUInstance
PrUsg_purchased_source	varchar(5)	NULL	Contains ’Y’ if part is purchaseable else ’N’	No	No
PrUsg_exchangeable_usage			Contains ’Y’ if part usage is exchangeable else ’N’
PrUsg_sales_usage			Contains ’Y’ if part usage is saleable else ’N’
PrUsg_poolable_usage			Contains ’Y’ if part usage is poolable else ’N’
PrUsg_lonable_usage			Contains ’Y’ if usage is loanable else ’N’

Table Name Prt_PurTmp_Purchase_Dtl_Tmp

Table Comment This is for Processing purchase detail.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PurTmp_guid	varchar(40)	NOT NULL	Guid	Yes	No
PurTmp_part_no			Part number
PurTmp_componentname	varchar(20)		Component Name
PurTmp_des_ouinstance	numeric(10)		Destination OUInstance
PurTmp_Applicable_Flag	varchar(5)	NULL	Applicable flag	No
PurTmp_Default_Flag			Default flag

Table Name Prt_SerAtt_Ser_Attrib_Map
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SerAtt_Crt_OUInstance	decimal(10)	NOT NULL	Location Id where the service is created	Yes	Yes
SerAtt_Service_No	varchar(40)		Service Number entered by the user or generated by the system
SerAtt_Attribute_OU	numeric(10)		OuInstance		No
SerAtt_Attribute_Code	varchar(10)		The code identifying the attribute that you wish to associate to the part (Alphanumeric, 10). Mandatory. The attribute code must be already defined in the “Create Attributes” activity of the “Attribute Definition” business component. Ensure that the attribute code is in “Active” status and is unique in the multiline.
SerAtt_Min_Value	numeric(20,8)	NULL	The minimum quantitative value that can be assigned to the attribute of the part (Integer). Mandatory. You can enter fractional values in this field if the standard UOM allows fractions.	No
SerAtt_Std_Value			The standard quantitative value that can be assigned to the attribute of the part (Integer). Mandatory. Ensure that the value entered here is greater than the minimum value and lesser than or equal to the maximum value. You can enter fractional values in this field if the standard UOM allows fractions.
SerAtt_Max_Value			The maximum quantitative value that can be assigned to the attribute of the part (Integer). Mandatory. Ensure that the value entered here is greater than the minimum value. You can enter fractional values in this field if the standard UOM allows fractions.
SerAtt_Std_Qlt_Value	varchar(80)		Standard Qualitative Value
SerAtt_Usage_Type	varchar(25)		Usage Type
SerAtt_Trackable_Flag			It will have "Y" or "N"
SerAtt_Created_By	varchar(30)	NOT NULL	User who created the details
SerAtt_Created_Date	datetime		Date at which the user created the details
SerAtt_Modified_By	varchar(30)		User who modified the details
SerAtt_Modified_Date	datetime		Date at which the user modified the details

Table Name Prt_SerBOM_Ser_BOM_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SerBOM_OUInstance	decimal(10)	NOT NULL	OuInstance	Yes	No
SerBOM_Service_Crt_Ou			Location Id where the service is created		Yes
SerBOM_Service_No	varchar(40)		Service Number entered by the user or generated by the system
SerBOM_Part_Crt_Ou	numeric(28)		Ou instance		No
SerBOM_Part_No	varchar(40)		The part number associated with the specified service.
SerBOM_Const_Type	varchar(5)	NULL	The constituent type of the service, for which the bill of material details are displayed. The system lists one of the following, based on the “Service Type”:	No
SerBOMD_Qty	decimal(28,8)		The number of bills of material associated with the specified service.
SerBOMD_UOM	varchar(25)		The default unit of measurement of the bill of material associated with specified service.
SerBOMD_pstv_tolerance	decimal(28,8)		The upper limit beyond which it is not possible to perform the service for the part.
SerBOMD_ngtv_tolerance			The lower limit below which it is not possible to perform the service for the part.
SerBOM_Propor_Qty_Flag	varchar(5)		It will have "Y" or "N"
SerBOM_Qty_InStkUom	decimal(28,8)		The unit of measurement of the part.

Table Name Prt_SerMn_Service_Part_Main

Table Comment All Service Parts Created are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SerMn_Crt_OUInstance	decimal(10)	NOT NULL	Location Id where the service is created	Yes	No
SerMn_Service_No	varchar(40)		Service Number entered by the user or generated by the system
SerMn_Reference_Status	varchar(5)		Reference Status	No
SerMn_Service_Desc	varchar(150)		Service Description
SerMn_Keyword	varchar(25)	NULL	Keyword
SerMn_Service_Type	varchar(5)	NOT NULL	Service Type
SerMn_Service_Category	varchar(25)	NULL	Service Category
SerMn_Std_Cost	decimal(28,8)	NOT NULL	Standard Cost
SerMn_Default_Uom	varchar(10)		Default Uom
SerMn_User_Def_1	varchar(25)	NULL	User Defind
SerMn_User_Def_2
SerMn_Remarks	varchar(255)		Remarks
SerMn_FileName	varchar(50)		File Name
SerMn_Created_By	varchar(30)	NOT NULL	User who Created the record.
SerMn_Created_Datetime	datetime		Date at which the record is Created
SerMn_Modified_By	varchar(30)		User who modified the record.
SerMn_Modified_Datetime	datetime		Date at which the record is modified.
SerMn_Timestamp	decimal(10)		Timestamp for the Concurrency check.
SerMn_Version_No		NULL	Version Number
SerMn_Mod_AtOrder	varchar(5)

Table Name Prt_SerOthpr_Ser_other_part

Table Comment This is an extension to the Part CRL List. A part may have different identifications used by the organization using the part and individual vendors and manufacturers. The same part may be identified differently by the industry, customer or even Competitor. Many a times there may be a requirement for finding out the reference number used by a vendor (from whom the part could be purchased) for a part. During placement of purchase order, either the vendor part number can be mentioned or it may be sufficient to specify the manufacturer part numbers along with manufacturer code. Other part numbers are the equivalent (used by vendors/competitors/other available sources) of the internal part numbers.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SerOthPr_Crt_OUInstance	decimal(10)	NOT NULL	Location Id where the service is created	Yes	Yes
SerOthPr_Service_No	varchar(40)		Service Number entered by the user or generated by the system
SerOthPr_Line_No	numeric(10)		Since Other Part No can duplicate and a combination of Source Desc, Other Part No, Other Part Desc, SourceType, Cage No, Nscm No all together forms the key and all of them except other part no + one of them being mandatory, it will be difficult to process without a key. So, LineNo is reqd to serve as a key [hidden to the user] to this entity		No
SerOthPr_source_desc	varchar(150)	NULL	This could be the manufacturer/competitor name	No
SerOthPr_other_part_no	varchar(40)	NOT NULL	Equivalent ParCode of the manufurer/competitor for &nbspsystem Internal Part #
SerOthPr_other_part_desc	varchar(150)	NULL	Description of the ParCode of the manufurer/competitor for &nbspour system Internal Part #
SerOthPr_source_type	varchar(80)		This could be ’Manufacturer’ or ’Vendor’ or ’Competitor’ as defined in the Source Type activity
SerOthPr_cage_no	varchar(5)		Cage code assigned to the manufacturer
SerOthPr_nscm_no			NATO SCM Code assigned to the manufacturer
SerOthPr_remarks	varchar(255)		Remarks if any
SerOthPr_created_by	varchar(30)	NOT NULL	User who created the details
SerOthPr_createddate	datetime		Date at which the user created the details
SerOthPr_modified_by	varchar(30)		User who modified the details
SerOthPr_modifieddate	datetime		Date at which the user modified the details

Table Name Prt_SerPln_Ser_Planning
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SerPln_Created_By	varchar(30)	NOT NULL	User who Created the record.	No	No
SerPln_Abc_Class	varchar(5)		The ABC Class, analysis classification for the service. This analysis is based on the earlier consumption records of the service. The system displays the values “A”, “B” and “C” which represent the different levels of classification under which the service can be classified.
SerPln_Est_Elapse_TUom	varchar(10)	NULL	The default UOM of the service
SerPln_Modified_Datetime	datetime	NOT NULL	Date at which the record is modified.
SerPln_Created_Datetime			Date at which the record is Created
SerPln_Modified_By	varchar(30)		User who modified the record.
SerPln_Timestamp	decimal(10)		Timestamp for the Concurrency check.
SerPln_Crt_OUInstance			Location Id where the service is created	Yes	Yes
SerPln_Service_No	varchar(40)		Service Number entered by the user or generated by the system
SerPln_Pln_OUInstance	numeric(28)		OuInstance		No
SerPln_Est_Elapse_Time	bigint	NULL	It describes the Item Quanity	No
SERPLN_PROPORTIONATE_ORDER	varchar(5)	NOT NULL	Indicates whether the planning details must be proportionate to sub-contract order details
SerPln_Planning_Status			The inventory status of the service which could be one of the following: Fresh indicates that the planning details have not been incorporated completely. Active &nbspindicates that the planning details have been incorporated completely. Inactive &nbspindicates that the service is no longer referred in transactions.
SerPln_Valuation_Method	char(18)	NULL

Table Name Prt_SerPuD_Ser_Purchase_Dtl

Table Comment This table contains the Purchase Details for parts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRPUINF_OUINSTANCE	decimal(10)	NOT NULL	OuInstance	Yes	Yes
SerPuD_Pln_OUInstance	numeric(28)
SerPuD_Crt_OUInstance	decimal(10)		Location Id where the service is created
PRPUINF_PART_NO	varchar(40)		Part Number
PRPUINF_CREATED_OUINSTANCE	decimal(10)		Created OuInstance
SerPuD_Service_No	varchar(40)		Service Number entered by the user or generated by the system
SerPuD_ComponentName	varchar(20)		Component Name		No
SerPuD_OrdLoc_Ou	numeric(10)		It will be either the PurchaseOrder [PO] OUInstance or ReleaseSlip [RS] OUInstance
SerPuD_default_flag	varchar(5)		Y(Yes) N(No)	No
SERPUD_APPLICABLE	sql_variant

Table Name PRT_SERPUH_SER_PURCHASE_HDR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SERPUH_SERVICE_NO	varchar(40)	NOT NULL	Service No	Yes	Yes
SERPUH_CRT_OUINSTANCE	decimal(10)		Ouinstance
SERPUH_PLN_OUINSTANCE	numeric(28)
SERPUH_PREF_SUPPLIER	varchar(45)		The default supplier with whom the order must be placed (Alphanumeric, 45). The preferred supplier must have been defined in the “Create Supplier” activity of the “Supplier” business component and must be in “Active” status.	No	No
SERPUH_SUPPLIER_OUINSTANCE	decimal(10)	NULL	Supplier OU
SERPUH_STD_PUR_PRICE	bigint	NOT NULL	It describes the Item Quanity
SERPUH_PSTV_TOLERANCE		NULL
SERPUH_NGTV_TOLERANCE
SERPUH_RECEIPT_HORIZON
SERPUH_UOM_OUINSTANCE	decimal(10)		Ouinstance
SERPUH_PURCHASE_UOM	varchar(10)		The unit of measurement in which the part is purchased (Alphanumeric, 10). Mandatory. The UOM must be defined in the “Create UOM” activity of the “Unit of Measurement Administration” business component and must be in “Active” status.
SERPUH_LEAD_TIME_UOM			The unit of measurement in which the part is stocked in the warehouse.
SERPUH_PRE_ORDER_LEAD_TIME	bigint		It describes the Item Quantity
SERPUH_PRC_ORDER_LEAD_TIME
SERPUH_POST_ORDER_LEAD_TIME
SERPUH_MIN_ORD_QTY
SERPUH_CREATED_BY	varchar(20)	NOT NULL	User who Created the record.
SERPUH_CREATEDDATE	datetime		Date at which the record is modified.
SERPUH_MODIFIED_BY	varchar(20)		User who modified the record.
SERPUH_MODIFIEDDATE	datetime		Date at which the record is modified.
SERPUH_TIMESTAMP	decimal(10)		Timestamp for the Concurrency check.

Table Name PRT_SRCCRL_ADVSEARCH_CRLREF

Table Comment This is a part information advance Filter criteria..
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SRCCRL_OUINSTANCE	numeric(10)	NOT NULL	Search Id OUInstance	Yes	No
SRCCRL_SEARCHID	varchar(30)		This Search Id (code)
SRCCRL_GROUP_TYPE	varchar(20)	NULL	Group type.	No
SRCCRL_PLAN_TYPE	varchar(5)		Planning type
SRCCRL_PARTGROUP	varchar(40)		Part Group
SRCCRL_ISSUE_BASIS	varchar(5)		Issue Basis will have (Returnable,Non returnable,Core returnable).
SRCCRL_EXPENCE_TYPE			Expense Type ( Capital ,revenue)
SRCCRL_GROUP_USAGE			Group Usage
SRCCRL_SL_NO_CONTROL_FLAG			serial control flag (Y or N).
SRCCRL_LOT_NO_CONTROL_FLAG			Lot control Flag (Y or N).
SRCCRL_USER_DEFINED_DTL1	varchar(25)		User defined
SRCCRL_USER_DEFINED_DTL2			User Defined 2
SRCCRL_CREATED_BY			created user.
SRCCRL_CREATED_DATE	datetime		Created date.
SRCCRL_MODIFIED_BY	varchar(25)		Last modified user.
SRCCRL_MODIFIED_DATE	datetime		Last Modified date.
SRCCRL_TIMESTAMP	numeric(28,8)		Timestamp.
SrcCrl_All_Flag	varchar(5)
Srccrl_Primepart_No	varchar(40)		Prime part No for the referred Part No
Srccrl_Prtwccode	varchar(30)		Default Work Center for the referred part no

Table Name PRT_SRCPLG_ADVSEARCH_PLNG
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SRCPLG_OUINSTANCE	numeric(10)	NOT NULL	Planning OUInstance	Yes	No
SRCPLG_SEARCHID	varchar(30)		This Search Id (code)
SRCPLG_GROUP_TYPE	varchar(20)	NULL	Group type.	No
SRCPLG_PLAN_TYPE	varchar(5)		Planning type
SRCPLG_PARTGROUP	varchar(40)		Part group
SRCPLG_VALUATION_METHOD	varchar(5)		Valuation Method
SRCPLG_GROUP_USAGE			Contains ’Y’ if part usage is maintainable else ’N’
SRCPLG_MAINT_USAGE			Contains ’Y’ if part usage is saleable else ’N’
SRCPLG_SALES_USAGE
SRCPLG_LONABLE_USAGE			Contains ’Y’ if usage is &nbsploanable else ’N’
SRCPLG_POOLABLE_USAGE			Contains ’Y’ if part usage is poolable else ’N’
SRCPLG_EXCHANGEABLE_USAGE			Contains ’Y’ if part usage is exchangeable else ’N’
SRCPLG_PURCHASED_SOURCE			Contains ’Y’ if part is purchaseable &nbspelse ’N’
SRCPLG_SUBCONTRACTED_SOURCE			Contains ’Y’ if part source is subcontracted else ’N’
SRCPLG_ONLOAN_SOURCE			Contains ’Y’ if part source is loanable else ’N’
SRCPLG_POOLED_SOURCE			Contains ’Y’ if part source is poolable else ’N’
SRCPLG_ONEXCHANGE_SOURCE			Contains ’Y’ if part source is exchange else ’N’
SRCPLG_ABC_CLASS			Par Planning class A,B,C
SRCPLG_XYZ_CLASS			Par Planning class X,Y,Z
SRCPLG_FSN_CLASS			Par Planning class F,S,N
SRCPLG_VED_CLASS			Par Planning Class ’V’,E,D
SRCPLG_EXPENCE_TYPE			Expense Type (Revenue and Capital)
SRCPLG_ISSUE_BASIS			Issue Basis will have (Returnable,Non returnable,Core returnable).
SRCPLG_PRTCONTROL_TYPE	varchar(10)		Part control type (Serial Controlled,lot controlled.Both).
SRCPLG_USER_DEFINED_DTL1	varchar(25)		User defined
SRCPLG_USER_DEFINED_DTL2			User defined
SRCPLG_CREATED_BY	varchar(30)		First created user
SRCPLG_CREATED_DATE	datetime		First creation date
SRCPLG_MODIFIED_BY	varchar(30)		Last modified user.
SRCPLG_MODIFIED_DATE	datetime		Last Modified Date.
SRCPLG_TIMESTAMP	numeric(28)		concurrency.
Srcplg_PrimePart_No	varchar(40)		Prime Part No of the referred PartNo
Srcplg_WorkCenter_Code	varchar(30)		Default Work Center for the referred part no

Table Name Prt_typdtl_type_change_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_typdtl_OuInstance	int	NOT NULL	Ou Instatnce	No	No
Prt_typdtl_ConverNo	sql_variant		Conversion No
Prt_typdtl_Location		NULL	warehouse &nbspLocation
Prt_typdtl_Warehouse			WareHouse Name
Prt_typdtl_StockStatus			Staock Status
Prt_typdtl_Zone			Zone Id
Prt_typdtl_Bin			Bin Id
Prt_typdtl_Serial_No			Serial Number
Prt_typdtl_MfgSrl_No			ManuFacturar Serial Number
Prt_typdtl_Lot_No			Lot No
Prt_typdtl_MfgLot_No			ManuFacturar Lot No
Prt_typdtl_Quantity	bigint		Quantity
Prt_typdtl_NewSerial_No	sql_variant		New Serial no
Prt_typdtl_NewMfgSrl_No			New Manufacturar SI No
Prt_typdtl_NewLot_No			New Lot no
Prt_typdtl_NewMfgLot_No			New Manufacturar Lot no
Prt_typdtl_Prt_Condn			Part Condition
Prt_typdtl_Cert_Type			Certificate Type
Prt_typdtl_Cert_Date	datetime		Certificate Date
Prt_typdtl_Cert_No	sql_variant		Certificate No
Prt_typdtl_Expiry_Date	datetime		Expiry Date
PRT_TYPEDTL_LINENO	int		Line no

Table Name Prt_TypeChg_Confg_OpTrn_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_TypeChg_Cfg_OuInstance	int	NOT NULL		No	No
Prt_TypeChg_Cfg_ConvNumber	sql_variant		Conversion Number
Prt_TypeChg_Cfg_Component		NULL
Prt_TypeChg_Cfg_AirCraftNo			Aircraft Number
Prt_TypeChg_Cfg_ACRevNo			Aircraft Revision Number
Prt_TypeChg_Cfg_ACModel			Aircraft model
Prt_TypeChg_Cfg_ConfigClass
Prt_TypeChg_Cfg_NHAPart
Prt_TypeChg_Cfg_NHACompID
Prt_TypeChg_Cfg_LevelCode
Prt_TypeChg_Cfg_PosCode
Prt_TypeChg_Cfg_PosCodeStat
Prt_TypeChg_Cfg_ConfgRules
Prt_TypeChg_Cfg_Remarks			Remarks
Prt_TypeChg_Cfg_CompRevno

Table Name Prt_TypeChg_PrtChg_OpTrn_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_TypeChg_OpTrn_OuInstance	int	NOT NULL	Ou Instatance	No	No
Prt_TypeChg_OpTrn_ConvNumber	sql_variant		Conversion Number
Prt_TypeChg_OpTrn_Component		NULL	Component Name
Prt_TypeChg_OpTrn_DocNo			Document Number
Prt_TypeChg_OpTrn_DocRevNo			Document Revision Number
Prt_TypeChg_OpTrn_DocType			Documnet Type
Prt_TypeChg_OpTrn_DocCreated	datetime
Prt_TypeChg_OpTrn_Status	sql_variant
Prt_TypeChg_OpTrn_RefDocNo			Reference Document Number
Prt_TypeChg_OpTrn_RefDocType			Refrence Document Type
Prt_TypeChg_OpTrn_RefDocRevNo			Reference Document Revision Number
Prt_TypeChg_OpTrn_RefDocStatus			Reference Document Status
Prt_TypeChg_OpTrn_WareHouse			WareHouse
Prt_TypeChg_OpTrn_Quantity	bigint		Qty
Prt_TypeChg_OpTrn_TxnUom	sql_variant		Uom
Prt_TypeChg_OpTrn_EmpCode			Employee Id
Prt_TypeChg_OpTrn_EmpName			Employee name
Prt_TypeChg_OpTrn_MntInvFlag			It will have "Y" or "N"
Prt_TypeChg_OpTrn_Remarks			Remarks

Table Name Prt_typhdr_type_change_Hdr
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_typhdr_OuInstance	int	NOT NULL	Ou Instance	No	No
Prt_typhdr_ConverNo	sql_variant		Conversion no
Prt_typhdr_NumberType		NULL	Nimbering Type for creating the conversion no
Prt_typhdr_ConvStatus			Conversion Status
Prt_typhdr_UserStatus			User Status
Prt_typhdr_ConvCategory			Conversion Category
Prt_typhdr_PartNo			Part no
Prt_typhdr_FrmPrt_Type			From Part Type
Prt_typhdr_FrmPrt_CtrlType			From part control type
Prt_typhdr_ToPrt_Type			To part type
Prt_typhdr_ToPrt_CtrlType			To part control type
Prt_typhdr_TotPrt_Qty	bigint		Total part Qty
Prt_typhdr_Stock_Uom	sql_variant		The main stock keeping uom for the item
Prt_typhdr_SlNo_Logic			It will have "Automatic Generation","Manufacturer SI No","Not Applicable"
Prt_typhdr_SlNo_Type			Numbering type for SI No
Prt_typhdr_LotNo_Type			Numbering type for Lot No
Prt_typhdr_Remarks			Remarks
Prt_typhdr_User_Def1			User defined
Prt_typhdr_User_Def2
Prt_typhdr_Crtd_By			User who created the details
Prt_typhdr_Crtd_date			Date at which the user created the details
Prt_typhdr_Conf_By			User who configured the details
Prt_typhdr_Conf_Date	datetime		Date at which the user configure the details
Prt_typhdr_Modfd_By	sql_variant		User who modified the record.
Prt_typhdr_Modfd_Date	datetime		Date at which the user modified the details
Prt_typhdr_TimeStamp	int		TimeStamp for concurrency check and the no of time the record gets modified
Prt_typhdr_WF_Stage	sql_variant		Work flow Stage
Prt_typhdr_WF_DocKey			To process work flow unique Doc key is generated
Prt_typhdr_PlanGroup_Flag			Plan Group will have "Y" or "N"
Prt_typhdr_ComPTray_Flag			It will have "Y" or "N"
Prt_typhdr_PrmPartMap_Flag
Prt_typhdr_MELItem_Flag
Prt_typhdr_Cancel_Reason			Reason For cancel the record

Table Name Prt_Attribute_Change_Hdr
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_AttChgHdr_OuInstance	int	NOT NULL	Ou instance	No	No
Prt_AttChgHdr_ConvNo	sql_variant		Document number
Prt_AttChgHdr_BaseCurrency			Currency
Prt_AttChgHdr_Status			Document status
Prt_AttChgHdr_ConvStatus			Conversion status
Prt_AttChgHdr_ConvCategory			Change category
Prt_AttChgHdr_UserStatus			User status
Prt_AttChgHdr_RequestBy			Request user
Prt_AttChgHdr_RequestDate			Requested date
Prt_AttChgHdr_FileName			File name
Prt_AttChgHdr_Remarks			Remarks
Prt_AttChgHdr_OtherRef			Other reference details
Prt_AttChgHdr_timestamp	int		TimeStamp for concurrency check and the no of time the record gets modified
Prt_AttChgHdr_CreatedBy	sql_variant		User who created the details
Prt_AttChgHdr_CreatedDate	datetime		Date at which the user created the details
Prt_AttChgHdr_LastModifiedBy	sql_variant		User who modified the record.
Prt_AttChgHdr_LastModifiedDate	datetime		Date at which the user modified the details

Table Name Prt_Attribute_Change_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Prt_AttChgDtl_OuInstance	int	not null	Ou instance	No	No
Prt_AttChgDtl_ConvNo	sql_variant		Document number
Prt_AttChgDtl_PartNo			Part number
Prt_AttChgDtl_LineNo	int		Part line number
Prt_AttChgDtl_FrmPartType	sql_variant		From part type
Prt_AttChgDtl_ToPartType			To part type
Prt_AttChgDtl_FrmCntrlType			From part control type
Prt_AttChgDtl_ToCntrlType			To control type
Prt_AttChgDtl_FrmExpType			From expense type
Prt_AttChgDtl_ToExpType			To expense type
Prt_AttChgDtl_FrmIssBasis			From issue basis
Prt_AttChgDtl_ToIssBasis			To issue basis
Prt_AttChgDtl_FrmValMethod			From valuation method
Prt_AttChgDtl_ToValMethod			To valuation method
Prt_AttChgDtl_FrmStockable			From stockable
Prt_AttChgDtl_ToStockable			To stockable
Prt_AttChgDtl_FrmExpPolicy			From expensing policy
Prt_AttChgDtl_ToExpPolicy			To Expensing policy
Prt_AttChgDtl_SrlLogic			Serial logic for serial number
Prt_AttChgDtl_SrlNumType			Serial numbering type
Prt_AttChgDtl_LotNumType			Lot numbering type
Prt_AttChgDtl_CompIdPrefix			component id prefix
Prt_AttChgDtl_StdCost	decimal(28,8)		standard cost
Prt_AttChgDtl_HoldPart	sql_variant		Hold part information
Prt_AttChgDtl_FileName			Filename
Prt_AttChgDtl_Reason			Reason for change
Prt_AttChgDtl_Remarks			Remarks for change
Prt_AttChgDtl_OtherRef			Other references
Prt_AttChgDtl_TgtAttribute			Target attributes
Prt_AttChgDtl_LineStatus			Line level status
Prt_AttChgDtl_CreatedBy			User who created the details
Prt_AttChgDtl_CreatedDate	datetime		Date at which the user created the details
Prt_AttChgDtl_LastModifiedBy	sql_variant		User who modified the record.
Prt_AttChgDtl_LastModifiedDate	datetime		Date at which the user modified the details

Table Name PRT_ATTRIBUTE_STOCKINFO_DTL
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
STKDTL_OUINSTANCE	int		Ou instance	No	No
STKDTL_CONVNO	sql_variant		Document number
STKDTL_PARTNO			Part number
STKDTL_PARTLINENO			Part line number
STKDTL_SRLLINENO			Part Serial line number
STKDTL_ACTION			Suggested action
STKDTL_WAREHOUSEID			Warehouse id
STKDTL_ZONEID			Zone id
STKDTL_BINID			bin id
STKDTL_STOCKSTATUS			Stock status
STKDTL_SERIALNO			Serial number
STKDTL_MFRSRLNO			manufacture serial number
STKDTL_LOTNO			lot number
STKDTL_MFRLOTNO			manufacture lot number
STKDTL_QUANTITY	int		Serial/ Lot quantity
STKDTL_NEW_MFRSRLNO	sql_variant		New Manufacture serial number
STKDTL_NEW_MFRLOTNO			New Manufacture Lot number
STKDTL_CONDITION			Part condition
STKDTL_UNITCOST			Unit cost
STKDTL_STKUOM			Stock UOM
STKDTL_NEWSERIALNO			New serial number
STKDTL_NEWLOTNO			New lot number
STKDTL_CERTYPE			certificate type
STKDTL_CERNO			Certificate number
STKDTL_CERDATE	datetime		Certificate date
STKDTL_EXPDATE			Expiry date
STKDTL_OWNINGOU	int		Owning OU
STKDTL_OWNERSHIP	sql_variant		Ownership
STKDTL_OWNINGAGENCY			Owning agency


Table Name PRT_OPNTRN_VIEW_DTL
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PRTTRN_OUINSTANCE	int		Ou instance	No	No
PRTTRN_DOCUMENTNO	sql_variant		Document number
PRTTRN_DOCSTATUS			Document Status
PRTTRN_PARTNO			Part number
PRTTRN_MSGTYPE			Part Message Type
PRTTRN_TRNTYPE			Transition Type
PRTTRN_MNTOBJ			Maintenance Object
PRTTRN_TRNNO			Transaction Number
PRTTRN_TRNSTATUS			Transaction Status
PRTTRN_CREATEDBY			Created User information
PRTTRN_WAREHOUSE			Warehouse information
PRTTRN_REMARKS			To get store the remarks
PRTTRN_RESOLUTION			Resolution for transaction
PRTTRN_FRMTARGET			From target attributes
PRTTRN_TOTARGET	sql_variant		To target attributes