|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRCRL_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This is the OUInstance Id where the Part is Created (for more details, see entity description) | Yes |
| PRCRL_PART_NO | _varchar_40 | varchar(40) | No | 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 |
| PRCRL_PART_DESC | _varchar_150 | varchar(150) | No | Description of the Part No | No |
| PRCRL_PART_DESC_UP | _varchar_150 | varchar(150) | No | Part Description in Uppercase | No |
| PRCRL_REFERENCE_STATUS | _varchar_5 | varchar(5) | No | Reference status can have the following codes A(Active) U(Under Creation) B( ) | No |
| PRCRL_KEYWORD | _varchar_25 | Varchar(25) | Yes | A keyword to easily identify the part (Alphanumeric, 25). | No |
| PRCRL_KEYWORD_UP | _varchar_25 | Varchar(25) | Yes | Keyword in upper case. | No |
| PRCRL_PART_TYPE | _varchar_5 | varchar(5) | No | The broad classification of the part into raw material, components, spare parts, kits, consumables, tools and services. Following lists the codes and their description CM Component CNSMBConsumable KIT Kit RWMTRRaw Material SP Spare Part | No |
| PRCRL_PART_CATEGORY | _varchar_25 | Varchar(25) | Yes | Part Category | No |
| PRCRL_MANUF_PART_NO | _varchar_40 | varchar(40) | Yes | manufacturar Part no | No |
| PRCRL_FILENAME | _varchar_50 | varchar(50) | Yes | File Name | No |
| PRCRL_BASE_PART_NO | _varchar_40 | varchar(40) | Yes | 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 | No |
| PRCRL_MANUF_NO | _varchar_45 | varchar(45) | Yes | Manufacturar No | No |
| PRCRL_AC_MANUF_OU | _decimal_10_0 | decimal(10) | Yes | If the manufacturer is available in Aircraft, Aircraft OU will be stored here. | No |
| PRCRL_SUP_MANUF_OU | _decimal_10_0 | decimal(10) | Yes | If the manufacturer is available in Supplier, Supplier OU will be stored here. | No |
| PRCRL_ISSUE_BASIS | _varchar_5 | varchar(5) | Yes | Issue Basis | No |
| PRCRL_PART_CNTRL_TYPE | _varchar_25 | Varchar(25) | Yes | Part Control Type | No |
| PRCRL_PREV_PART_NO | _varchar_40 | varchar(40) | Yes | The number given to the part previously | No |
| PRCRL_DRAWING_REF | _varchar_40 | varchar(40) | Yes | The number identifying the document containing the drawing reference | No |
| PRCRL_DRAWING_REVISION_NO | _varchar_40 | varchar(40) | Yes | The revision number of the drawing document | No |
| PRCRL_MOD_STATUS_NO | _varchar_15 | varchar(15) | Yes | Status Number | No |
| PRCRL_SOURCE_DOC_TYPE | _varchar_5 | varchar(5) | Yes | The type of reference document on basis of which the part # is created. Will have values like Engineering Order, IPC etc Following lists the codes and their description EO EO IPC IPC OTH Others | No |
| PRCRL_SOURCE_DOC_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | This will have the Org Unit where the Reference Source Document is created and is available | No |
| PRCRL_SOURCE_DOC_NO | _varchar_40 | varchar(40) | Yes | This will have the reference document No on the basis of which the part # is created | No |
| PRCRL_SUGGESTED_PART_NO | _varchar_40 | varchar(40) | Yes | The part # suggested by the source document like Engineering order | No |
| PRCRL_DOC_REVISION_NO | _varchar_40 | varchar(40) | Yes | This will have the Revision No of reference document No on the basis of which the part # is created | No |
| PRCRL_MATERIAL_SPEC | _varchar_255 | varchar(255) | Yes | Material Specific | No |
| PRCRL_SL_NO_CONTROL_FLAG | _varchar_25 | Varchar(25) | Yes | 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 | No |
| PRCRL_SL_NO_LOGIC | _varchar_5 | varchar(5) | Yes | Serial No Logic | No |
| PRCRL_SL_NO_TYPE_NO | _varchar_5 | varchar(5) | Yes | The numbering pattern to be used by the system for generating the serial # if the serial number generation logic is set as Automatic | No |
| PRCRL_LOT_NO_CONTROL_FLAG | _varchar_25 | Varchar(25) | Yes | Lot Number Control flag | No |
| PRCRL_LOT_NO_TYPE_NO | _varchar_5 | varchar(5) | Yes | Numbering type for Lot no | No |
| PRCRL_STD_COST | _decimal_28_8 | decimal(28) | No | The cost or the Standard Rate of the Part for valuation purpose | No |
| PRCRL_PLANNING_TYPE | _varchar_5 | varchar(5) | No | It will have "Min-max", Reorder Level","None" ] | No |
| PRCRL_EXPENCE_TYPE | _varchar_25 | Varchar(25) | Yes | This will the default expense type of the part. Following lists the Codes for Expense types and their description CAP Capital REV Revenue | No |
| PRCRL_SHELF_LIFE_UNIT | _varchar_5 | varchar(5) | Yes | 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 | No |
| PRCRL_DESIGNED_SHELF_LIFE | _decimal_28_8 | decimal(28) | Yes | Designed Shelf Life | No |
| PRCRL_MIN_SHELF_LIFE | _decimal_28_8 | decimal(28) | Yes | 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) | No |
| PRCRL_ALERT_VALUE | _decimal_28_8 | decimal(28) | Yes | Alert Value for Shelf Life | No |
| PRCRL_UOM_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance Id where the Stock Uom is created | No |
| PRCRL_STOCK_UOM | _varchar_10 | varchar(10) | No | The unit of measurement in which the part is stocked | No |
| PRCRL_GROSS_VOLUME | _decimal_28_8 | decimal(28) | Yes | This will have the volume of the Part | No |
| PRCRL_VOLUME_UOM | _varchar_10 | varchar(10) | Yes | Volume Uom Code | No |
| PRCRL_GROSS_WEIGHT | _decimal_28_8 | decimal(28) | Yes | The gross weight of the part (Decimal). | No |
| PRCRL_WEIGHT_UOM | _varchar_10 | varchar(10) | Yes | UomCode of Gross Weight | No |
| PRCRL_NSN_NO | udd_documentno | varchar(40) | Yes | User can enter NSN no for the Specific Part # | No |
| PRCRL_USER_DEFINED_DTL1 | _varchar_25 | Varchar(25) | Yes | User can define some additional details for the part in Dtl1 , Dtl2 | No |
| PRCRL_USER_DEFINED_DTL2 | _varchar_25 | Varchar(25) | Yes | User can define some additional details for the part in Dtl2 | No |
| PRCRL_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| PRCRL_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PRCRL_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the user created the details | No |
| PRCRL_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PRCRL_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the user modified the details | No |
| PRCRL_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp | No |
| PRCRL_PART_ACC_GRP | _varchar_20 | varchar(20) | Yes | Account Group Details | No |
| PRCRL_PRIMEPART_NO | _varchar_40 | varchar(40) | Yes | Prime Part Number for the Main Part Number | No |
| PRCRL_WORK_CENTER | _varchar_30 | varchar(30) | Yes | Default Work Center for the Part No | No |
| PRCRL_MODEL | _varchar_20 | varchar(20) | Yes | Default Model No for the Part No. | No |
| PRCRL_SHELFLIFE_EXTENDABLE | udd_designparamcode | varchar(5) | Yes | Stores Shelf Life Update Flag as Yes/No | No |
| Prcrl_Strip_Part_no | _varchar_40 | varchar(40) | No | strip part no will be stored here. | No |
| PRCRL_Non_Stockable | udd_model | varchar(20) | Yes | This column is used to identify the Non stockable items. | No |
| PRCRL_RefDocumentNo | udd_documentno | varchar(40) | Yes | This column used to store the Reference document details. | No |
| PRCRL_RefDocumentType | udd_type | varchar(25) | Yes | This column is used to store the Reference document Type. | No |
| PRCRL_RefNotes | udd_notes | varchar(2000) | Yes | This column is store the Reference Notes. | No |
| PRCRL_PartId | _int_0 | int(0) | No | Part Id | No |
| PRCRL_SOURCE_DOC_DATE | udd_date | varchar(15) | Yes | Source Document Date | No |
| PRCRL_PRM_PRT_GROUP | udd_documentno | varchar(40) | Yes | Primary Part Group | No |
| PRCRL_Spec2kPrt_NO | _varchar_30 | varchar(30) | Yes | Spec 2000 Part number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRDA_CREATED_OUINSTANCE | _numeric_28_0 | numeric(28) | No | This is the OUInstance Id where the Part is Created (for more details, see entity description) | Yes |
| PRDA_PART_NO | _varchar_40 | varchar(40) | No | 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 |
| PRDA_REF_DOC_TYPE | _varchar_15 | varchar(15) | No | Reference Document Type | Yes |
| PRDA_DOC_ID | _varchar_40 | varchar(40) | No | Document Id | Yes |
| PRDA_FILE_NAME | _varchar_50 | varchar(50) | Yes | Reference File Name | No |
| PRDA_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks (if any) | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRGPAT_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ouinstance | Yes |
| PRGPAT_GROUP_CODE | _varchar_40 | varchar(40) | No | Group code. | Yes |
| PRGPAT_ATTRIB_OU | _decimal_10_0 | decimal(10) | Yes | Attribute created Ou. | No |
| PRGPAT_ATTRIB_CODE | _varchar_10 | varchar(10) | No | Attribute code which is refferred from Attribute component. | Yes |
| PRGPAT_MIN_VALUE | _decimal_20_8 | decimal(20) | Yes | Minimum value | No |
| PRGPAT_MAX_VALUE | _decimal_20_8 | decimal(20) | Yes | Maximum value. | No |
| PRGPAT_STD_QLT_VALUE | _varchar_80 | varchar(80) | Yes | standard Quality value. | No |
| PRGPAT_STD_QNT_VALUE | _decimal_20_8 | decimal(20) | Yes | Standard Quantitive value | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRGPPR_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ouinstance. | Yes |
| PRGPPR_GROUP_CODE | _varchar_40 | varchar(40) | No | Group code. | Yes |
| PRGPPR_PART_CRT_OU | _decimal_10_0 | decimal(10) | No | Part created Ouinstance. | Yes |
| PRGPPR_PART_NO | _varchar_40 | varchar(40) | No | Part No | Yes |
| PrGpPr_Prim_PrtGp_Flg | udd_designparamcode | varchar(5) | Yes | Primary Part Group for the Part will be "Y" and the other Part Groups will be "N" | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRGPTYMP_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Group Type OuInstance (where the Group type is defined) | Yes |
| PRGPTYMP_GROUP_TYPE | _varchar_20 | varchar(20) | No | Associated Group type. | Yes |
| PRGPTYMP_GROUP_TYPE_OU | _decimal_10_0 | decimal(10) | Yes | Group type Ou. | No |
| PRGPTYMP_GROUP_CODE | _varchar_40 | varchar(40) | No | Group code | Yes |
| PRGPTYMP_GROUP_CODE_OU | _decimal_10_0 | decimal(10) | Yes | Group Code created Ou. | No |
| PRGPTYMP_IMD_PARENT | _varchar_40 | varchar(40) | Yes | Immediate Parent. | No |
| PRGPTYMP_LEVEL_NO | _varchar_40 | varchar(40) | Yes | Level No | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRTGPTY_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Group Type OuInstance (where the Group type is defined) | Yes |
| PRTGPTY_GROUP_TYPE | _varchar_20 | varchar(20) | No | Group Type | Yes |
| PRTGPTY_DESCRIPTION | _varchar_80 | varchar(80) | Yes | Group Type Description | No |
| PRTGPTY_DESCRIPTION_UP | _varchar_80 | varchar(80) | Yes | Group Type Description in upper case. | No |
| PRTGPTY_USAGE | _varchar_25 | Varchar(25) | Yes | Usage could be the following "Maintenance", "Inventory", "Purchase", "Sales", "Operation" , "Accounting & "Others". add blank. | No |
| PRTGPTY_STATUS | _varchar_15 | varchar(15) | Yes | Status could be Active or InActive | No |
| PRTGPTY_CREATED_DATETIME | _datetime_8 | datetime(8) | Yes | Date at which the user created the details | No |
| PRTGPTY_CREATED_BY | _varchar_30 | varchar(30) | Yes | User who created the details | No |
| PRTGPTY_MODIFIED_DATETIME | _datetime_8 | datetime(8) | Yes | Date at which the user modified the details | No |
| PRTGPTY_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User who modified the details | No |
| PRTGPTY_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp for Concurrency checking. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRGRP_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ouinstance | Yes |
| PRGRP_GROUP_CODE | _varchar_40 | varchar(40) | No | Group code. | Yes |
| PRGRP_DESCRIPTION | _varchar_150 | varchar(150) | Yes | Group code descruiption | No |
| PRGRP_DESCRIPTION_UP | _varchar_150 | varchar(150) | Yes | Description stored in Upper case. | No |
| PRGRP_STATUS | _varchar_25 | Varchar(25) | Yes | Group code Status. | No |
| PRGRP_MAP_ATTRIB_FLAG | _varchar_25 | Varchar(25) | Yes | Map attribute flag (Y or N). | No |
| PRGRP_MAP_PARTS_FLAG | _varchar_25 | Varchar(25) | Yes | Map parts flag (Yor N). | No |
| PRGRP_CREATED_BY | _varchar_30 | varchar(30) | Yes | User who created the details | No |
| PRGRP_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Date at which the user created the details. | No |
| PRGRP_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | User who modified the details | No |
| PRGRP_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Date at which the user modified the details | No |
| PRGRP_CTRL_GROUP | udd_checkyesno | varchar(3) | Yes | It will have "Y" or "N" | No |
| PRGRP_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp for Concurrency checking. | No |
| PRGRP_PURPOSE | udd_designparamcode | varchar(5) | Yes | It will have "Pricing" or "Taxes and charges" or "Product Line" or " Capability Definition" or "Vat" | No | |
| Table Name : | PRT_PRKITINF_KIT_INFO |
| 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 su |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRKITINF_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This is the OUInstance Id where the Part is Created (for more details, see entity description of PrCRL table) | Yes |
| PRKITINF_PART_NO | _varchar_40 | varchar(40) | No | Internal Part No which is of Part Type Kit | Yes |
| PRKITINF_KIT_PART_NO | _varchar_40 | varchar(40) | No | Kit Part # (that is the constituent Part No) | Yes |
| PRKITINF_KIT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Created OUInstance of the Kit Part # (that is the constituent Part No s Created OUInstance) | Yes |
| PRKITINF_EST_QTY | _decimal_28_8 | decimal(28) | Yes | It describes the Item Quanity | No |
| PRKITINF_REMARKS | _varchar_255 | varchar(255) | Yes | Kit composiiton details if any can be given here | No |
| PRKITINF_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PRKITINF_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the details are created | No |
| PRKITINF_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PRKITINF_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the details are modified | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PROPSET_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ouinstance | Yes |
| PROPSET_STD_COST_MAND_FLAG | _varchar_25 | Varchar(25) | Yes | Standard cost Mandatory Flag. | No |
| PROPSET_NEW_PART_CHK_FLAG | _varchar_25 | Varchar(25) | Yes | New Part Check Flag. | No |
| PROPSET_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the record. | No |
| PROPSET_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the record is created | No |
| PROPSET_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the record. | No |
| PROPSET_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the record is modified. | No |
| PROPSET_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the Concurrency check. | No |
| PROPSET_DEFVALMET | udd_flag2 | varchar(25) | Yes | Default Valuation method | No |
| PROPSET_PRIPRTGRPMAND | udd_flag2 | varchar(25) | Yes | Primary part group mandatory | No |
| PROPSET_DEFPRTACTGRP | udd_iag | varchar(20) | Yes | Default part account group | No |
| PROPSET_CAPDEF | udd_flag1 | varchar(25) | Yes | Cap def | No |
| PROPSET_PRODLINE | udd_partno | varchar(40) | Yes | Product line | No |
| PROPSET_PRICING | udd_flag1 | varchar(25) | Yes | Pricing | No |
| PROPSET_TAXCHARGE | udd_flag1 | varchar(25) | Yes | Tax Charge | No |
| PROPSET_VAT | udd_flag1 | varchar(25) | Yes | VAT | No |
| PROPSET_APPL_VALMET | udd_designparamcode | varchar(5) | Yes | valuation method | No |
| PROPSET_PRTSUPMAP | udd_designparamcode | varchar(5) | Yes | part supplier mapping | No | |
| Table Name : | PRT_PROTHPRT_OTHER_PART_INFO |
| 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 Competit |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PROTHPRT_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Created OUInstance | Yes |
| PROTHPRT_PART_NO | _varchar_40 | varchar(40) | No | Part No | Yes |
| PROTHPRT_SOURCE_DESC | _varchar_150 | varchar(150) | Yes | This could be the manufacturer/competitor name | No |
| PROTHPRT_LINE_NO | _decimal_10_0 | decimal(10) | No | 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 pr | Yes |
| PROTHPRT_OTHER_PART_NO | _varchar_40 | varchar(40) | No | Equivalent ParCode of the manufurer/competitor for system Internal Part # | No |
| PROTHPRT_OTHER_PART_DESC | _varchar_150 | varchar(150) | Yes | Description of the ParCode of the manufurer/competitor for our system Internal Part # | No |
| PROTHPRT_SOURCE_TYPE | _varchar_80 | varchar(80) | Yes | This could be Manufacturer or Vendor or Competitor as defined in the Source Type activity | No |
| PROTHPRT_CAGE_NO | _varchar_5 | varchar(5) | Yes | Cage code assigned to the manufacturer | No |
| PROTHPRT_NSCM_NO | _varchar_5 | varchar(5) | Yes | NATO SCM Code assigned to the manufacturer | No |
| PROTHPRT_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks if any | No |
| PROTHPRT_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PROTHPRT_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the user created the details | No |
| PROTHPRT_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PROTHPRT_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the user modified the details | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PrPlAd_PartOU | udd_ctxt_ouinstance | int(4) | No | Part OU | Yes |
| PrPlAd_PartNo | udd_partno | varchar(40) | No | Part number | Yes |
| PrPlAd_TRAN_Code | udd_designparamcode | varchar(5) | No | Transaction code | Yes |
| PrPlAd_RestrictYN | udd_designparamcode | varchar(5) | Yes | Restrict flag (y/n) | No |
| PrPlAd_Reason | udd_txt2000 | varchar(2000) | Yes | Reason | No |
| PrPlAd_Created_By | udd_ctxt_user | varchar(30) | Yes | created by | No |
| PrPlAd_CREATED_DATE | udd_datetime | varchar(30) | Yes | created date | No |
| PrPlAd_MODIFIED_BY | udd_ctxt_user | varchar(30) | Yes | modified by | No |
| PrPlAd_Modified_Date | udd_datetime | varchar(30) | Yes | modified date | No |
| PrPlAd_Timestamp | udd_timestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PrPlAd_Func_Type | udd_component | varchar(16) | Yes | Function type | No |
| PrPlAd_Func_Desc | udd_txt255 | varchar(255) | Yes | Function description | No |
| PrPlAd_Tran_Code | udd_designparamcode | varchar(5) | Yes | Transaction code | No |
| PrPlAd_Tran_Desc | udd_txt255 | varchar(255) | Yes | Transaction description | No |
| PrPlAd_LanuageID | udd_ctxt_language | int(4) | Yes | Language id. This is the language id of the record. | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRPLINF_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Planning OU | Yes |
| PRPLINF_PART_NO | _varchar_40 | varchar(40) | No | Internal Part # | Yes |
| PRPLINF_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Created OU | Yes |
| PRPLINF_PLANNING_STATUS | _varchar_40 | varchar(40) | No | Following lists the planning status codes and their description A Active F Fresh I InActive | No |
| PRPLINF_MATERIAL_CONTROLLER | _varchar_20 | varchar(20) | Yes | Employee Code of the person who is in charge of maintaining the stock of a location | No |
| PRPLINF_VALUATION_METHOD | _varchar_5 | varchar(5) | No | The inventory costing method to be used for the part in the location. It will have values Like Std. Cost, LIFO etc Following lists the Cost Valuation Codes and their description AC Actual Cost FIFO FIFO LIFO LIFO SC Standard Cost WAR Wt A | No |
| PRPLINF_RESERVATION_HORIZON | _decimal_28_8 | decimal(28) | Yes | The number of days beyond which reservation for a part cannot be made. | No |
| PRPLINF_REORDER_ACTIVATED_BY | _varchar_5 | varchar(5) | Yes | 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 | No |
| PRPLINF_REORDER_ACTIVATED_AT | _varchar_5 | varchar(5) | Yes | 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 | No |
| PRPLINF_MIN_QTY | _decimal_28_8 | decimal(28) | Yes | It describes the Item minimum Quanity | No |
| PRPLINF_MAX_QTY | _decimal_28_8 | decimal(28) | Yes | It describes the Item Quanity | No |
| PRPLINF_REORDER_LEVEL | _decimal_28_8 | decimal(28) | Yes | It describes the Item Quanity. | No |
| PRPLINF_REORDER_QTY | _decimal_28_8 | decimal(28) | Yes | ReOrder Quantity | No |
| PRPLINF_MIN_ISSUE_QTY | _decimal_28_8 | decimal(28) | Yes | Minimum Issue Quantity | No |
| PRPLINF_SAFETY_STOCK | _decimal_28_8 | decimal(28) | Yes | It describes the Item Quanity.. | No |
| PRPLINF_ABC_CLASS | _varchar_5 | varchar(5) | Yes | 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) | No |
| PRPLINF_XYZ_CLASS | _varchar_5 | varchar(5) | Yes | 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) | No |
| PRPLINF_PLACEMENT_STRATEGY | _varchar_5 | varchar(5) | Yes | 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 | No |
| PRPLINF_PICKING_STRATEGY | _varchar_5 | varchar(5) | Yes | 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 |
| PRPLINF_FSN_CLASS | _varchar_5 | varchar(5) | Yes | One of the methods of Stock Analysis Following are the list of FSNcodes and their description F (F) S (S) N (N) None (None) | No |
| PRPLINF_VED_CLASS | _varchar_5 | varchar(5) | Yes | 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) | No |
| PRPLINF_ALLOCABLE_HORIZON | _decimal_28_8 | decimal(28) | Yes | The number of days beyond which hard allocation for a part cannot be made. | No |
| PRPLINF_ALLOCABLE | _varchar_5 | varchar(5) | Yes | 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 | No |
| PRPLINF_TRNFR_LEADTIME_UOM | _varchar_5 | varchar(5) | Yes | Will indiate the average transfer lead time UOM - Days, Weeks or months | No |
| PRPLINF_AVG_TRNFR_LEADTIME | _decimal_28_8 | decimal(28) | Yes | Will indiate the average transfer lead time | No |
| PRPLINF_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PRPLINF_CREATED_DATE | _datetime_8 | datetime(8) | No | Date at which the details are created | No |
| PRPLINF_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PRPLINF_MODIFIED_DATE | _datetime_8 | datetime(8) | No | Date at which the details are modified | No |
| PRPLINF_TIMESTAMP | _decimal_10_0 | decimal(10) | No | TimeStamp for concurrency check | No |
| PRPLINF_ANNUAL_CONSUMPTION | _decimal_28_8 | decimal(28) | Yes | The annual consumption of the part stocked in the inventory | No |
| PRPLINF_SER_LEVEL_FACTOR | _decimal_28_8 | decimal(28) | Yes | 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 | No |
| PRPLINF_ORDERING_COST | _decimal_28_8 | decimal(28) | Yes | The miscellaneous cost such as transportation charges and electricity charges incurred on the part (Decimal). | No |
| PRPLINF_CARRYING_COST | _decimal_28_8 | decimal(28) | Yes | The miscellaneous cost such as the cost incurred for handling hazardous types of parts or breakable parts (Decimal). | No |
| PRPLINF_REPLN_LEADTIME | _decimal_28_8 | decimal(28) | Yes | The total lead time required for the replenishment activity to be completed (Decimal). | No |
| PRPLINF_REPLN_LEADTIME_UOM | _varchar_10 | varchar(10) | Yes | The lead time unit, which could be Days, Weeks", Months or Years. | No |
| PrPlInf_Action_Phaseout | _varchar_25 | Varchar(25) | Yes | Action on phase out | No |
| PRPLINF_Cert_Reqd | udd_designparamcode | varchar(5) | Yes | It will have "Yes" or "No" | No |
| PrPlInf_expensing_policy | udd_designparamcode | varchar(5) | No | It will have "Core value on Phase out" or "Fitst Issue" or "On Phased out" | No |
| PRPLINF_ADJACTCOST | udd_flag | varchar(25) | Yes | It describes the Item Value. | No |
| PRSLINF_SCRAP_NOTE_PROC | udd_designparamcode | varchar(5) | Yes | Scrap Note Process | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRPLLOC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Planning OU | Yes |
| PRPLLOC_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Created OU | Yes |
| PRPLLOC_PART_NO | _varchar_40 | varchar(40) | No | Internal Part # | Yes |
| PRPLLOC_DEF_WH_OU | _decimal_10_0 | decimal(10) | No | This is the storage admin OUInstance Id for which default warehouse and stock transfer details are specified | Yes |
| PRPLLOC_DEF_WH_ID | _varchar_10 | varchar(10) | Yes | Warehouse Id in the location where the part has to be put by default | No |
| PRPLLOC_ISSUE_LOCATION | _decimal_10_0 | decimal(10) | Yes | Issue OU Instance (Transfer From Location) | No |
| PRPLLOC_STKTRN_SRC_WH_OU | _decimal_10_0 | decimal(10) | Yes | Stock Transfer Warehouse location | No |
| PRPLLOC_STKTRN_SRC_WH_ID | _varchar_10 | varchar(10) | Yes | Sourcing warehouse for stock transfer | No |
| PRPLLOC_TRANSFER_LOCATION | _decimal_10_0 | decimal(10) | Yes | Stock Transfer Location [Transfer Processing Location] | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRPUDTL_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Created ouinstance | Yes |
| PRPUDTL_PART_NO | _varchar_40 | varchar(40) | No | Part Number | Yes |
| PRPUDTL_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ouinstance | No |
| PRPUDTL_COMPONENTNAME | _varchar_20 | varchar(20) | No | Component Name | Yes |
| PRPUDTL_ORDERING_LOCN_OUINSTAN | _decimal_10_0 | decimal(10) | No | It will be either the PurchaseOrder [PO] OUInstance or ReleaseSlip [RS] OUInstance | Yes |
| PRPUDTL_DEFAULT_FLAG | _varchar_5 | varchar(5) | Yes | Y(Yes) N(No) | No |
| PRPUDTL_Applicable_Flag | _varchar_5 | varchar(5) | Yes | Applicable flag | No | |
| Table Name : | PRT_PRPUINF_PURCHASE_INFO |
| 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 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRPUINF_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Ou Instance | Yes |
| PRPUINF_PART_NO | _varchar_40 | varchar(40) | No | Part No | Yes |
| PRPUINF_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| PRPUINF_PREF_SUPPLIER | _varchar_45 | varchar(45) | No | The default vendor or supplier to whom the order for the part must be placed from this location | No |
| PRPUINF_SUPPLIER_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Supplier Ouinstance | No |
| PRPUINF_STD_PUR_PRICE | _decimal_28_8 | decimal(28) | No | The rate of the part as per the stock UOM , which will be defaulted when Purchase Requests/ Purchase Orders are generated | No |
| PRPUINF_PSTV_TOLERANCE | _decimal_28_8 | decimal(28) | Yes | 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. | No |
| PRPUINF_NGTV_TOLERANCE | _decimal_28_8 | decimal(28) | Yes | Negative Tolerance | No |
| PRPUINF_RECEIPT_HORIZON | _decimal_28_8 | decimal(28) | Yes | Receipt Horizon | No |
| PRPUINF_UOM_OUINSTANCE | _decimal_10_0 | decimal(10) | No | UOM OUinstance | No |
| PRPUINF_PURCHASE_UOM | _varchar_10 | varchar(10) | No | 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. | No |
| PRPUINF_LEAD_TIME_UOM | _varchar_10 | varchar(10) | Yes | Lead Time Unit of Measurement | No |
| PRPUINF_PRE_ORDER_LEAD_TIME | _decimal_28_8 | decimal(28) | Yes | The time required for pre-order processing (Integer). The value in this field must be greater than zero. | No |
| PRPUINF_PRC_ORDER_LEAD_TIME | _decimal_28_8 | decimal(28) | Yes | Prc Order Lead Time | No |
| PRPUINF_POST_ORDER_LEAD_TIME | _decimal_28_8 | decimal(28) | Yes | The time between the date of ordering and the date of supplying (Integer). | No |
| PRPUINF_MIN_ORD_QTY | _decimal_28_8 | decimal(28) | Yes | It describes the Item Quanity | No |
| PRPUINF_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the record. | No |
| PRPUINF_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the record is created. | No |
| PRPUINF_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the record. | No |
| PRPUINF_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the record is modified. | No |
| PRPUINF_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the Concurrency check. | No |
| PrPuInf_Insp_WO | _varchar_25 | Varchar(25) | Yes | Inspection Work Order | No |
| PrPuInf_Work_Unit_No | _varchar_30 | varchar(30) | Yes | The number identifying the work unit (Alphanumeric, 30). This field is mandatory if you have selected "Required" in the "Insp. WO?" field. | No |
| PrPuInf_Work_Unit_type | _varchar_25 | Varchar(25) | Yes | Work Unit Type | No |
| PrPuInf_Task_Auth_OU | _int_0 | int(0) | Yes | Task Authorized OU | No |
| PrPuInf_COM | _varchar_25 | Varchar(25) | Yes | COM | No | |
| Table Name : | PRT_PRSLINF_SALE_INFO |
| 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 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRSLINF_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Sales OUInstance | Yes |
| PRSLINF_PART_NO | _varchar_40 | varchar(40) | No | Internal Part No | Yes |
| PRSLINF_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Created OUInstance | No |
| PRSLINF_STD_SALES_PACKAGE | _decimal_28_8 | decimal(28) | Yes | It describes the Item Quanity | No |
| PRSLINF_UOM_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance of Sales Uom | No |
| PRSLINF_SALES_UOM | _varchar_10 | varchar(10) | No | Sales Uom : Unit of measurement in which the part can be sold | No |
| PRSLINF_STD_SALES_PRICE | _decimal_28_8 | decimal(28) | Yes | The rate of the part as per the stock UOM , which will be defaulted when Purchase Requests/ Purchase Orders are generated | No |
| PRSLINF_PSTV_TOLERANCE | _decimal_28_8 | decimal(28) | Yes | Positive Tolerance: | No |
| PRSLINF_NGTV_TOLERANCE | _decimal_28_8 | decimal(28) | Yes | Negative Tolerance: | No |
| PRSLINF_VAR_PRICE | udd_designparamcode | varchar(5) | Yes | Load Variable Pricing with "Allowed"/"Not Allowed" | No |
| PRSLINF_PRICING_BAS | udd_designparamcode | varchar(5) | Yes | Load Pricing basis based on Variable Pricing with "Lifo"/"Fifo"., | No |
| PRSLINF_EST_PRICING_BAS | udd_designparamcode | varchar(5) | Yes | Est. Pricing based on Pricing basis shoud be if Pricing Basis "Actual Iss Cost" then load with "Max Purchase" "Std Sales Price". | No |
| PRSLINF_APPL_AT | udd_designparamcode | varchar(5) | Yes | Load whether the Info is applicable at Location/Warehouse Level. | No |
| PRSLINF_MIN_STK_LIMIT | udd_quantity | numeric(13) | Yes | It describes the Item Quanity . | No |
| PRSLINF_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PRSLINF_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the user created the details | No |
| PRSLINF_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PRSLINF_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the user modified the details | No |
| PRSLINF_TIMESTAMP | _decimal_10_0 | decimal(10) | No | TimeStamp for the concurrency check | No |
| PRSLINF_REG_EXCH | udd_designparamcode | varchar(5) | Yes | regular excahnge | No |
| PRSLINF_STD_EXCH | udd_designparamcode | varchar(5) | Yes | standard exchange | No |
| PRSLINF_STD_EXCH_TYPE | udd_flag | varchar(25) | Yes | standard exchange type "regular or advance exchange" | No | |
| Table Name : | PRT_PRSRCTYP_SOURCE_TYPES |
| 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 ... |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRSRCTYP_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| PRSRCTYP_SOURCE_TYPE | _varchar_80 | varchar(80) | No | Three values are predefined Manufacturer Others Supplier and the other values are defined by the user | Yes |
| PRSRCTYP_SOURCE_FLAG | _varchar_25 | Varchar(25) | No | Source Flag should be either UserDef or PreDef | No |
| PRSRCTYP_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PRSRCTYP_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the details are created | No |
| PRSRCTYP_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PRSRCTYP_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the details are modified | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRTADDL_CREATED_OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | Part Created OUInstance | Yes |
| PRTADDL_PART_NO | udd_partno | varchar(40) | No | A unique code identifying the part.The part number must be unique across all the organizational units. | Yes |
| PRTADDL_INSPECTION | udd_designparamcode | varchar(5) | No | It will have "Expense Off" or "Add to Stock" | No |
| PRTADDL_OVERHAUL | udd_designparamcode | varchar(5) | No | overhaul | No |
| PRTADDL_OTHERS | udd_designparamcode | varchar(5) | No | It will have "Expense Off" or "Add to Stock" . | No |
| PRTADDL_REPAIR | udd_designparamcode | varchar(5) | No | It will have "Expense Off" or "Add to Stock". | No |
| PRTADDL_RESIDUAL_VALUE | udd_designparamcode | varchar(5) | Yes | Residual Value | No |
| PRTADDL_VARIABLE_VALUE | udd_designparamcode | varchar(5) | Yes | Variable Value Basis | No |
| PRTADDL_STD_COREVALUE | _numeric_18_0 | Numeric(18) | Yes | Standard Core Value | No |
| PRTADDL_CREATED_BY | udd_ctxt_user | varchar(30) | No | User who created the details | No |
| PRTADDL_CREATED_DATE | udd_datetime | varchar(30) | No | Date at which the details are created | No |
| PRTADDL_MODIFIED_BY | udd_ctxt_user | varchar(30) | No | User who modified the details | No |
| PRTADDL_MODIFIED_DATE | udd_datetime | varchar(30) | No | Date at which the user modified the details | No |
| PRTADDL_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp for the concurrency check | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PrtAtrdtl_ChgReq_Ouinstance | udd_ctxt_ouinstance | int(4) | Yes | This column used to store the OU (organization unit). | No |
| PrtAtrdtl_Request_No | udd_documentno | varchar(40) | Yes | This Column is used to store the Request number. | No |
| PrtAtrdtl_Lineno | udd_lineno | int(4) | Yes | This column is used to store the Line number. | No |
| PrtAtrdtl_Refdoctyp | udd_type | varchar(25) | Yes | This column is use to store the document type. | No |
| PrtAtrdtl_Refdocno | udd_documentno | varchar(40) | Yes | This column is used to store the Reference Document number. | No |
| PrtAtrdtl_filename | udd_filename | varchar(50) | Yes | This column is used to store the Filename. | No |
| PrtAtrdtl_remarks | udd_remarks | varchar(255) | Yes | This column is used to store the remarks. | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PrtAtr_ChgReq_Ouinstance | udd_ctxt_ouinstance | int(4) | Yes | This column is used to store the OU (organization Unit) | No |
| PrtAtr_Request_No | udd_documentno | varchar(40) | Yes | This column is used to store the Request number. | No |
| PrtAtr_Newpart_No | udd_partno | varchar(40) | Yes | This column is used to store the New part number. | No |
| PrtAtr_part_Desc | udd_txt150 | varchar(150) | Yes | This column is used to store the Part Describtion | No |
| PrtAtr_Altrforpart_No | udd_partno | varchar(40) | Yes | This column is used to store the Alternative part number. | No |
| PrtAtr_Numbering_Type | udd_notypeno | varchar(5) | Yes | This column is used to store the Numbering type | No |
| PrtAtr_Request_Date | udd_time | datetime(8) | Yes | This column is used to store the Requested Date. | No |
| PrtAtr_Request_Status | udd_designparamcode | varchar(5) | Yes | This column is used for Request Status. | No |
| PrtAtr_Request_Type | udd_type | varchar(25) | Yes | This column is used to store the request type. | No |
| PrtAtr_User_Status | udd_status | varchar(25) | Yes | This column is used to store the User Status. | No |
| PrtAtr_Priority | udd_status | varchar(25) | Yes | This column is used to store the Priority Details. | No |
| PrtAtr_ReqCat | udd_quickcodes | varchar(25) | Yes | This column is used to store the Request Category. | No |
| PrtAtr_Empid | udd_hrempname | varchar(77) | Yes | This column is used to store the Employee name. | No |
| PrtAtr_Prtyp_to | udd_type | varchar(25) | Yes | This column is used to store the Part type converted to details. | No |
| PrtAtr_Prtattpart_No | udd_partno | varchar(40) | Yes | This column is used to store the Alternative part number.. | No |
| PrtAtr_Refdtlpart_No | udd_partno | varchar(40) | Yes | This column is used to store the reference part number. | No |
| PrtAtr_Prtyp_from | udd_type | varchar(25) | Yes | This column is used to store the part type from details. | No |
| PrtAtr_CtrlTyp_from | udd_type | varchar(25) | Yes | This column is used to store the Part control type from. | No |
| PrtAtr_CtrlTyp_To | udd_type | varchar(25) | Yes | This column is used to store the part control type To. | No |
| PrtAtr_Altrpartno | udd_partno | varchar(40) | Yes | Alternate part number | No |
| PrtAtr_Aircraftno | udd_partno | varchar(40) | Yes | This column is used to store the Aircraft Number information. | No |
| PrtAtr_WrkCtr | udd_ctxt_user | varchar(30) | Yes | This column is used to store the Work center details. | No |
| PrtAtr_Station | udd_documentno | varchar(40) | Yes | This column is used to store the Station. | No |
| PrtAtr_ExecDocTyp | udd_type | varchar(25) | Yes | This column is used to store the Execution document type. | No |
| PrtAtr_ExecDocNo | udd_documentno | varchar(40) | Yes | This column is used to store the Execution Document Number. | No |
| PrtAtr_OthRef | udd_notes | varchar(2000) | Yes | This column is used to store the Other references. | No |
| PrtAtr_SourceDocType | udd_documenttype | varchar(40) | Yes | This column is used to store the Source document type. | No |
| PrtAtr_SourceDocNo | udd_documentno | varchar(40) | Yes | This column is used to store the source document number. | No |
| PrtAtr_DocReviNo | udd_documentno | varchar(40) | Yes | This column is used to store the Document Revesion number. | No |
| PrtAtr_MatSpecific | udd_txt255 | varchar(255) | Yes | This column is used to store the Material specification. | No |
| PrtAtr_DrawReference | udd_documentno | varchar(40) | Yes | This column is used to store the draw reference. | No |
| PrtAtr_DrawRevisionNo | udd_documentno | varchar(40) | Yes | This column is used to store the Draw Revision number. | No |
| PrtAtr_OtherDetails | udd_txt255 | varchar(255) | Yes | This column is used to store other details | No |
| PrtAtr_RequestorRemarks | udd_txt255 | varchar(255) | Yes | This column is used to store the Requestor remarks. | No |
| PrtAtr_ConfirmComments | udd_txt255 | varchar(255) | Yes | This column is used to store the confirmation comments. | No |
| PrtAtr_crtdby | udd_ctxt_user | varchar(30) | Yes | This column is used to store the created by. | No |
| PrtAtr_crtdate | udd_time | datetime(8) | Yes | This column is used to store the Created date. | No |
| PrtAtr_lastmodby | udd_ctxt_user | varchar(30) | Yes | This column is used to store the last modified by. | No |
| PrtAtr_lastmoddate | udd_time | datetime(8) | Yes | This column is used to store the Last modified date. | No |
| PrtAtr_confirmedby | udd_ctxt_user | varchar(30) | Yes | This column is used to store the Confirmated user details. | No |
| PrtAtr_confirmdate | udd_time | datetime(8) | Yes | This column is used to store the confirmation date. | No |
| PrtAtr_Timestamp | udd_timestamp | int(4) | Yes | This column is used to store the Timestamp details. | No |
| PrtAtr_AltPartFlag | udd_flag | varchar(25) | Yes | This column is used to store the Alternative Flag | No |
| PrtAtr_CtrlTypFlag | udd_flag | varchar(25) | Yes | This column is used to store the control type flag | No |
| PrtAtr_PrtTypFlag | udd_flag | varchar(25) | Yes | This column is used to store the Part type flag. | No |
| PrtAtr_CreatedPartno | udd_partno | varchar(40) | Yes | This column is used to store the Created part number. | No |
| PrtAtr_AutoFlag | udd_designparamcode | varchar(5) | Yes | This column is used to store the Auto flag | No |
| PrtAtr_Rejectedby | udd_ctxt_user | varchar(30) | Yes | This column is used to store the Rejected by. | No |
| PrtAtr_Rejecteddate | udd_date | varchar(15) | Yes | This column is used to store the rejected date. | No |
| PrtAtr_Rejectioncomments | UDD_Comments | char(256) | Yes | This column is used to store the rejection comments. | No |
| PrtAtr_CtrlTyp_DocNo | udd_documentno | varchar(40) | Yes | This column is used to store the Control document number. | No |
| PrtAtr_PrtTyp_DocNo | udd_documentno | varchar(40) | Yes | This column is used to store the Part type document number. | No |
| PrtAtr_RefDocumentType | udd_type | varchar(25) | Yes | This column is used to store the reference document type. | No |
| PrtAtr_RefDocumentNo | udd_documentno | varchar(40) | Yes | This column is used to store the reference document number. | No |
| PRTATR_SOURCEDOCDATE | udd_date | varchar(15) | Yes | source document date | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes |
| PrtAtr_PrtTyp | udd_type | varchar(25) | Yes | part type | No |
| PrtAtr_PrtCtrTyp | udd_type | varchar(25) | Yes | part control type | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRTNT_OUinstance | udd_ctxt_ouinstance | int(4) | No | New Column added for capturing remarks about Note Types | Yes |
| PRTNT_PartNo | udd_partno | varchar(40) | No | This column holds the Part No | Yes |
| PRTNT_LineNo | udd_count | int(4) | No | This column holds the Line No | Yes |
| PRTNT_NoteType | udd_designparamcode | varchar(5) | Yes | This column holds the Note type that will be defaulted in Purchase request | No |
| PRTNT_NoteDesc | udd_remarks | varchar(255) | Yes | This column holds the description of the Note Type | No |
| PRTNT_standard | udd_designparamcode | varchar(5) | Yes | This column states if the the note type specified has to be defaulted or not. | No |
| PRTNT_RefDate | udd_time | datetime(8) | Yes | This column holds the reference date | No |
| PRTNT_Clasfcn | udd_flag | varchar(25) | Yes | This column holds the class function details | No |
| PRTNT_CreatedBy | udd_ctxt_user | varchar(30) | Yes | This column holds the user who created the note | No |
| PRTNT_CreatedDate | udd_time | datetime(8) | Yes | This column holds the date when the user created the note | No |
| PRTNT_ModifiedBy | udd_ctxt_user | varchar(30) | Yes | This column holds the user who modified the note | No |
| PRTNT_ModifedDate | udd_time | datetime(8) | Yes | This column holds the date when the user modified the note | No |
| PRTNT_Remarks | udd_txt6000 | varchar(4000) | Yes | New column added for capturing remarks for note types | No |
| PRTNT_FileName | udd_filename | varchar(50) | Yes | New column added for capturing reference file name details | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRTQC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| PRTQC_QUICK_CODE | _varchar_25 | Varchar(25) | No | Quick code | Yes |
| PRTQC_DESCRIPTION | _varchar_80 | varchar(80) | No | Quick Code Description | No |
| PRTQC_TYPE | _varchar_5 | varchar(5) | No | PrCat(Part Category) | Yes |
| PRTQC_STATUS | _varchar_15 | varchar(15) | No | Quick Code Status | No |
| PRTQC_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the Quick Code | No |
| PRTQC_CREATED_DATE | _datetime_8 | datetime(8) | No | Date at which the Quick Code can be creat | No |
| PRTQC_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the record. | No |
| PRTQC_MODIFIED_DATE | _datetime_8 | datetime(8) | No | Date at which the record is modified. | No |
| PRTQC_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the Concurrency check. | No | |
| Table Name : | PRT_PRUCON_UOM_CONV_INFO |
| 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 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRUCON_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | This is the OUInstance Id where the Part is Created (for more details, see entity description of PrCRL table) | Yes |
| PRUCON_PART_NO | _varchar_40 | varchar(40) | No | Internal Part No | Yes |
| PRUCON_UOM_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance Id where From/To UomCode is defined | Yes |
| PRUCON_FROM_UOM | _varchar_10 | varchar(10) | No | From UomCode | Yes |
| PRUCON_TO_UOM | _varchar_10 | varchar(10) | No | To UomCode | Yes |
| PRUCON_CONV_FACTOR | _decimal_28_8 | decimal(28) | No | The factor for converting FromUOM of the part to ToUom | No |
| PRUCON_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| PRUCON_CREATED_DATE | _datetime_8 | datetime(8) | No | Date at which the details are created | No |
| PRUCON_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| PRUCON_MODIFIED_DATE | _datetime_8 | datetime(8) | No | Date at which the details are modified | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Table Name : | PRT_PRUSG_USAGE_SRC_GEN_INFO |
| 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 |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PRUSG_PART_NO | _varchar_40 | varchar(40) | No | Internal Part # | Yes |
| PRUSG_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Planning OUInstance | Yes |
| PRUSG_CREATED_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Part Created OUInstance | No |
| PRUSG_MAINT_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is maintainable else N | No |
| PRUSG_SALES_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is saleable else N | No |
| PRUSG_LONABLE_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if usage is loanable else N | No |
| PRUSG_POOLABLE_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is poolable else N | No |
| PRUSG_EXCHANGEABLE_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is exchangeable else N | No |
| PRUSG_PURCHASED_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part is purchaseable else N | No |
| PRUSG_SUBCONTRACTED_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is subcontracted else N | No |
| PRUSG_ONLOAN_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is loanable else N | No |
| PRUSG_POOLED_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is poolable else N | No |
| PRUSG_ONEXCHANGE_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is exchange else N | No |
| PRUSG_QC_CLEARANCE_REQD | _varchar_5 | varchar(5) | Yes | Y if QC Clearance is reqd for the part else N | No |
| PRUSG_BACK_FLUSHING_REQD | _varchar_5 | varchar(5) | Yes | Y if Back Flushing is reqd for the part else N | No |
| PRUSG_STORAGE_ALLOC_MANDATORY | _varchar_5 | varchar(5) | Yes | Y if Storage Allocation is reqd for the part else N | No |
| PRUSG_HAZARDOUS_GENERAL | _varchar_5 | varchar(5) | Yes | Y if the part is hazardous else N | No |
| PRUSG_ON_WARRANTY | _varchar_5 | varchar(5) | Yes | Y if the Part is On Warranty else N | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SERATT_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SERATT_SERVICE_NO | _varchar_40 | varchar(40) | No | Service Number entered by the user or generated by the system | Yes |
| SERATT_ATTRIBUTE_OU | _decimal_10_0 | decimal(10) | No | OuInstance | Yes |
| SERATT_ATTRIBUTE_CODE | _varchar_10 | varchar(10) | No | 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 | Yes |
| SERATT_MIN_VALUE | _decimal_20_8 | decimal(20) | Yes | 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 | _decimal_20_8 | decimal(20) | Yes | 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 value | No |
| SERATT_MAX_VALUE | _decimal_20_8 | decimal(20) | Yes | 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 frac | No |
| SERATT_STD_QLT_VALUE | _varchar_80 | varchar(80) | Yes | Standard Qualitative Value | No |
| SERATT_USAGE_TYPE | _varchar_25 | Varchar(25) | Yes | Usage Type | No |
| SERATT_TRACKABLE_FLAG | _varchar_25 | Varchar(25) | Yes | It will have "Y" or "N" | No |
| SERATT_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| SERATT_CREATED_DATE | _datetime_8 | datetime(8) | No | Date at which the user created the details | No |
| SERATT_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| SERATT_MODIFIED_DATE | _datetime_8 | datetime(8) | No | Date at which the user modified the details | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SERBOM_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OuInstance | Yes |
| SERBOM_SERVICE_CRT_OU | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SERBOM_PART_NO | _varchar_40 | varchar(40) | No | The part number associated with the specified service. | Yes |
| SERBOM_SERVICE_NO | _varchar_40 | varchar(40) | No | Service Number entered by the user or generated by the system | Yes |
| SERBOM_CONST_TYPE | _varchar_5 | varchar(5) | Yes | 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 |
| SERBOM_PART_CRT_OU | _numeric_28_8 | numeric(28) | No | Ou instance | Yes |
| SERBOMD_QTY | _numeric_28_8 | numeric(28) | Yes | The number of bills of material associated with the specified service. | No |
| SERBOMD_UOM | _varchar_25 | Varchar(25) | Yes | The default unit of measurement of the bill of material associated with specified service. | No |
| SERBOMD_PSTV_TOLERANCE | _decimal_28_8 | decimal(28) | Yes | The upper limit beyond which it is not possible to perform the service for the part. | No |
| SERBOMD_NGTV_TOLERANCE | _decimal_28_8 | decimal(28) | Yes | The lower limit below which it is not possible to perform the service for the part. | No |
| SERBOM_PROPOR_QTY_FLAG | _varchar_5 | varchar(5) | Yes | It will have "Y" or "N" | No |
| SERBOM_QTY_INSTKUOM | _decimal_28_0 | decimal(28) | Yes | The unit of measurement of the part. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SERMN_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SERMN_SERVICE_NO | _varchar_40 | varchar(40) | No | Service Number entered by the user or generated by the system | Yes |
| SERMN_REFERENCE_STATUS | _varchar_5 | varchar(5) | No | Reference Status | No |
| SERMN_SERVICE_DESC | _varchar_150 | varchar(150) | No | Service Description | No |
| SERMN_KEYWORD | _varchar_25 | Varchar(25) | Yes | Keyword | No |
| SERMN_SERVICE_TYPE | _varchar_5 | varchar(5) | No | Service Type | No |
| SERMN_SERVICE_CATEGORY | _varchar_25 | Varchar(25) | Yes | Service Category | No |
| SERMN_STD_COST | _decimal_28_8 | decimal(28) | No | Standard Cost | No |
| SERMN_DEFAULT_UOM | _varchar_10 | varchar(10) | No | Default Uom | No |
| SERMN_USER_DEF_1 | _varchar_25 | Varchar(25) | Yes | User Defind | No |
| SERMN_USER_DEF_2 | _varchar_25 | Varchar(25) | Yes | User Defind 2 | No |
| SERMN_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| SERMN_FILENAME | _varchar_50 | varchar(50) | Yes | File Name | No |
| SERMN_CREATED_BY | _varchar_30 | varchar(30) | No | User who Created the record. | No |
| SERMN_CREATED_DATETIME | _datetime_8 | datetime(8) | No | Date at which the record is Created | No |
| SERMN_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the record. | No |
| SERMN_MODIFIED_DATETIME | _datetime_8 | datetime(8) | No | Date at which the record is modified. | No |
| SERMN_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the Concurrency check. | No |
| SERMN_VERSION_NO | _decimal_10_0 | decimal(10) | Yes | Version Number | No |
| SERMN_MOD_ATORDER | _varchar_5 | varchar(5) | Yes | at order | No | |
| Table Name : | PRT_SEROTHPR_SER_OTHER_PART |
| 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 Competi |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SEROTHPR_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SEROTHPR_SERVICE_NO | _varchar_40 | varchar(40) | No | Service Number entered by the user or generated by the system | Yes |
| SEROTHPR_SOURCE_DESC | _varchar_150 | varchar(150) | Yes | This could be the manufacturer/competitor name | No |
| SEROTHPR_LINE_NO | _decimal_10_0 | decimal(10) | No | 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 pr | Yes |
| SEROTHPR_OTHER_PART_NO | _varchar_40 | varchar(40) | No | Equivalent ParCode of the manufurer/competitor for system Internal Part # | No |
| SEROTHPR_OTHER_PART_DESC | _varchar_150 | varchar(150) | Yes | Description of the ParCode of the manufurer/competitor for our system Internal Part # | No |
| SEROTHPR_SOURCE_TYPE | _varchar_80 | varchar(80) | Yes | This could be Manufacturer or Vendor or Competitor as defined in the Source Type activity | No |
| SEROTHPR_CAGE_NO | _varchar_5 | varchar(5) | Yes | Cage code assigned to the manufacturer | No |
| SEROTHPR_NSCM_NO | _varchar_5 | varchar(5) | Yes | NATO SCM Code assigned to the manufacturer | No |
| SEROTHPR_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks if any | No |
| SEROTHPR_CREATED_BY | _varchar_30 | varchar(30) | No | User who created the details | No |
| SEROTHPR_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the user created the details | No |
| SEROTHPR_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the details | No |
| SEROTHPR_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the user modified the details | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SERPLN_PLN_OUINSTANCE | _numeric_28_0 | numeric(28) | No | OuInstance | Yes |
| SERPLN_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SERPLN_SERVICE_NO | _varchar_40 | varchar(40) | No | Service Number entered by the user or generated by the system | Yes |
| SERPLN_PLANNING_STATUS | _varchar_5 | varchar(5) | No | 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 indicates that the planning details have been incorporated completely. Inactive | No |
| SERPLN_PROPORTIONATE_ORDER | _varchar_5 | varchar(5) | No | Indicates whether the planning details must be proportionate to sub-contract order details | No |
| SERPLN_EST_ELAPSE_TIME | udd_quantity | numeric(13) | Yes | It describes the Item Quanity | No |
| SERPLN_EST_ELAPSE_TUOM | _varchar_10 | varchar(10) | Yes | The default UOM of the service | No |
| SERPLN_ABC_CLASS | _varchar_5 | varchar(5) | No | 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 s | No |
| SERPLN_CREATED_BY | _varchar_30 | varchar(30) | No | User who Created the record. | No |
| SERPLN_CREATED_DATETIME | _datetime_8 | datetime(8) | No | Date at which the record is Created | No |
| SERPLN_MODIFIED_BY | _varchar_30 | varchar(30) | No | User who modified the record. | No |
| SERPLN_MODIFIED_DATETIME | _datetime_8 | datetime(8) | No | Date at which the record is modified. | No |
| SERPLN_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the Concurrency check. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SERPUD_PLN_OUINSTANCE | _numeric_28_0 | numeric(28) | No | OuInstance | Yes |
| SERPUD_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SERPUD_SERVICE_NO | _varchar_40 | varchar(40) | No | Service Number entered by the user or generated by the system | Yes |
| SERPUD_COMPONENTNAME | _varchar_20 | varchar(20) | No | Component Name | Yes |
| SERPUD_ORDLOC_OU | _decimal_10_0 | decimal(10) | No | It will be either the PurchaseOrder [PO] OUInstance or ReleaseSlip [RS] OUInstance | Yes |
| SERPUD_DEFAULT_FLAG | _varchar_5 | varchar(5) | No | Y(Yes) N(No) | No |
| SERPUD_APPLICABLE | UDD_AISFLAG | varchar(1) | Yes | Applicable flag | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SERPUH_PLN_OUINSTANCE | _numeric_28_0 | numeric(28) | No | NULL | Yes |
| SERPUH_CRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Location Id where the service is created | Yes |
| SERPUH_SERVICE_NO | _varchar_40 | varchar(40) | No | Service No | Yes |
| SERPUH_PREF_SUPPLIER | _varchar_45 | varchar(45) | No | The default vendor or supplier to whom the order for the part must be placed from this location | No |
| SERPUH_SUPPLIER_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | Supplier OU | No |
| SERPUH_STD_PUR_PRICE | udd_quantity | numeric(13) | No | It describes the Item Quanity | No |
| SERPUH_PSTV_TOLERANCE | udd_quantity | numeric(13) | Yes | It describes the Item Quanity. | No |
| SERPUH_NGTV_TOLERANCE | udd_quantity | numeric(13) | Yes | It describes the Item Quanity .. | No |
| SERPUH_RECEIPT_HORIZON | udd_quantity | numeric(13) | Yes | It describes the Item Quanity . | No |
| SERPUH_UOM_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | Ouinstance | No |
| SERPUH_PURCHASE_UOM | _varchar_10 | varchar(10) | Yes | 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. | No |
| SERPUH_LEAD_TIME_UOM | _varchar_10 | varchar(10) | Yes | Lead Time Unit of Measurement | No |
| SERPUH_PRE_ORDER_LEAD_TIME | udd_quantity | numeric(13) | Yes | It describes the Item Quanity.. | No |
| SERPUH_PRC_ORDER_LEAD_TIME | udd_quantity | numeric(13) | Yes | Lead Time | No |
| SERPUH_POST_ORDER_LEAD_TIME | udd_quantity | numeric(13) | Yes | Post Order Lead Time | No |
| SERPUH_MIN_ORD_QTY | udd_quantity | numeric(13) | Yes | It describes the Item Quanity . | No |
| SERPUH_CREATED_BY | udd_ctxt_user | varchar(30) | No | User who Created the record. | No |
| SERPUH_CREATEDDATE | _datetime_8 | datetime(8) | No | Date at which the record is modified. | No |
| SERPUH_MODIFIED_BY | udd_ctxt_user | varchar(30) | No | User who modified the record. | No |
| SERPUH_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Date at which the record is modified .. | No |
| SERPUH_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the Concurrency check. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SRCCRL_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Search Id OUInstance | Yes |
| SRCCRL_SEARCHID | _varchar_30 | varchar(30) | No | This Search Id (code) | Yes |
| SRCCRL_GROUP_TYPE | _varchar_20 | varchar(20) | Yes | Group type. | No |
| SRCCRL_PLAN_TYPE | _varchar_5 | varchar(5) | Yes | Planning type | No |
| SRCCRL_PARTGROUP | _varchar_40 | varchar(40) | Yes | Part Group | No |
| SRCCRL_ISSUE_BASIS | _varchar_5 | varchar(5) | Yes | Issue Basis will have (Returnable,Non returnable,Core returnable). | No |
| SRCCRL_EXPENCE_TYPE | _varchar_5 | varchar(5) | Yes | Expence Type ( Capital ,revenue) | No |
| SRCCRL_GROUP_USAGE | _varchar_5 | varchar(5) | Yes | Group Usage | No |
| SRCCRL_SL_NO_CONTROL_FLAG | _varchar_5 | varchar(5) | Yes | serial control flag (Y or N). | No |
| SRCCRL_LOT_NO_CONTROL_FLAG | _varchar_5 | varchar(5) | Yes | Lot control Flag (Y or N). | No |
| SRCCRL_USER_DEFINED_DTL1 | _varchar_25 | Varchar(25) | Yes | User defined | No |
| SRCCRL_USER_DEFINED_DTL2 | _varchar_25 | Varchar(25) | Yes | User Defined 2 | No |
| SRCCRL_CREATED_BY | udd_ctxt_user | varchar(30) | Yes | created user. | No |
| SRCCRL_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created date. | No |
| SRCCRL_MODIFIED_BY | udd_ctxt_user | varchar(30) | Yes | Last modified user. | No |
| SRCCRL_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Last Modified date. | No |
| SRCCRL_TIMESTAMP | _decimal_28_8 | decimal(28) | Yes | Timestamp. | No |
| SRCCRL_ALL_FLAG | _varchar_5 | varchar(5) | Yes | FLAG | No |
| SRCCRL_PRIMEPART_NO | _varchar_40 | varchar(40) | Yes | Prime part No for the referred Part No | No |
| SRCCRL_PRTWCCODE | _varchar_30 | varchar(30) | Yes | Default Work Center for the referred part no | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SRCPLG_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Planning OUInstance | Yes |
| SRCPLG_SEARCHID | _varchar_30 | varchar(30) | No | This Search Id (code) | Yes |
| SRCPLG_GROUP_TYPE | _varchar_20 | varchar(20) | Yes | Group type. | No |
| SRCPLG_PLAN_TYPE | _varchar_5 | varchar(5) | Yes | Planning type | No |
| SRCPLG_PARTGROUP | _varchar_40 | varchar(40) | Yes | Part group | No |
| SRCPLG_VALUATION_METHOD | _varchar_5 | varchar(5) | Yes | Valuation Method | No |
| SRCPLG_GROUP_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is maintainable else N | No |
| SRCPLG_MAINT_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is saleable else N | No |
| SRCPLG_SALES_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is saleable else N . | No |
| SRCPLG_LONABLE_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if usage is loanable else N | No |
| SRCPLG_POOLABLE_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is poolable else N | No |
| SRCPLG_EXCHANGEABLE_USAGE | _varchar_5 | varchar(5) | Yes | Contains Y if part usage is exchangeable else N | No |
| SRCPLG_PURCHASED_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part is purchaseable else N | No |
| SRCPLG_SUBCONTRACTED_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is subcontracted else N | No |
| SRCPLG_ONLOAN_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is loanable else N | No |
| SRCPLG_POOLED_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is poolable else N | No |
| SRCPLG_ONEXCHANGE_SOURCE | _varchar_5 | varchar(5) | Yes | Contains Y if part source is exchange else N | No |
| SRCPLG_ABC_CLASS | _varchar_5 | varchar(5) | Yes | Par Planning class A,B,C | No |
| SRCPLG_XYZ_CLASS | _varchar_5 | varchar(5) | Yes | Par Planning class X,Y,Z | No |
| SRCPLG_FSN_CLASS | _varchar_5 | varchar(5) | Yes | Par Planning class F,S,N | No |
| SRCPLG_VED_CLASS | _varchar_5 | varchar(5) | Yes | Par Planning Class V ,E,D | No |
| SRCPLG_EXPENCE_TYPE | _varchar_5 | varchar(5) | Yes | Expence Type (Revenue and Capital) | No |
| SRCPLG_ISSUE_BASIS | _varchar_5 | varchar(5) | Yes | Issue Basis will have (Returnable,Non returnable,Core returnable). | No |
| SRCPLG_PRTCONTROL_TYPE | _varchar_10 | varchar(10) | Yes | Part control type (Serial Controlled,lot controlled.Both). | No |
| SRCPLG_USER_DEFINED_DTL1 | _varchar_25 | Varchar(25) | Yes | User defined | No |
| SRCPLG_USER_DEFINED_DTL2 | _varchar_25 | Varchar(25) | Yes | User defuned | No |
| SRCPLG_CREATED_BY | _varchar_30 | varchar(30) | Yes | First created user | No |
| SRCPLG_CREATED_DATE | _datetime_8 | datetime(8) | Yes | First creation date | No |
| SRCPLG_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Last modified user. | No |
| SRCPLG_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | Last Modified Date. | No |
| SRCPLG_TIMESTAMP | _numeric_28_0 | numeric(28) | Yes | concurrency. | No |
| SRCPLG_PRIMEPART_NO | _varchar_40 | varchar(40) | Yes | Prime Part No of the referred PartNo | No |
| SRCPLG_WORKCENTER_CODE | _varchar_30 | varchar(30) | Yes | Default Work Center for the referred part no | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Prt_typdtl_OuInstance | udd_ctxt_ouinstance | int(4) | No | Ou Instatnce | No |
| Prt_typdtl_ConverNo | udd_documentno | varchar(40) | No | Conversion No | No |
| Prt_typdtl_Location | udd_txt255 | varchar(255) | Yes | warehouse Location | No |
| Prt_typdtl_Warehouse | udd_warehouse | varchar(10) | Yes | WareHouse Name | No |
| Prt_typdtl_StockStatus | udd_documentno | varchar(40) | Yes | Staock Status | No |
| Prt_typdtl_Zone | udd_zone | varchar(10) | Yes | Zone Id | No |
| Prt_typdtl_Bin | udd_bin | varchar(10) | Yes | Bin Id | No |
| Prt_typdtl_Serial_No | udd_documentno | varchar(40) | Yes | Serial Number | No |
| Prt_typdtl_MfgSrl_No | udd_documentno | varchar(40) | Yes | ManuFacturar Serial Number | No |
| Prt_typdtl_Lot_No | udd_documentnumber | varchar(18) | Yes | Lot No | No |
| Prt_typdtl_MfgLot_No | udd_documentnumber | varchar(18) | Yes | ManuFacturar Lot No | No |
| Prt_typdtl_Quantity | udd_amount | numeric(13) | Yes | Quantity | No |
| Prt_typdtl_NewSerial_No | udd_documentno | varchar(40) | Yes | New Serial no | No |
| Prt_typdtl_NewMfgSrl_No | udd_documentno | varchar(40) | Yes | New Manufacturar SI No | No |
| Prt_typdtl_NewLot_No | udd_documentnumber | varchar(18) | Yes | New Lot no | No |
| Prt_typdtl_NewMfgLot_No | udd_documentnumber | varchar(18) | Yes | New Manufacturar Lot no | No |
| Prt_typdtl_Prt_Condn | udd_designparamcode | varchar(5) | Yes | Part Condition | No |
| Prt_typdtl_Cert_Type | udd_flag | varchar(25) | Yes | Certificate Type | No |
| Prt_typdtl_Cert_Date | _datetime_8 | datetime(8) | Yes | Certificate Date | No |
| Prt_typdtl_Cert_No | udd_documentno | varchar(40) | Yes | Certificate No | No |
| Prt_typdtl_Expiry_Date | _datetime_8 | datetime(8) | Yes | Expiry Date | No |
| PRT_TYPEDTL_LINENO | udd_lineno | int(4) | Yes | Line no | No |
| Prt_typdtl_PRTCOST | _decimal_28_8 | decimal(28) | Yes | part cost | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Prt_TypeChg_Cfg_OuInstance | udd_ctxt_ouinstance | int(4) | No | part cost | No |
| Prt_TypeChg_Cfg_ConvNumber | udd_documentno | varchar(40) | No | Conversion Number | No |
| Prt_TypeChg_Cfg_Component | udd_desc20 | varchar(20) | Yes | Component Name | No |
| Prt_TypeChg_Cfg_AirCraftNo | udd_aircraftnumber | varchar(30) | Yes | Aircraft Number | No |
| Prt_TypeChg_Cfg_ACRevNo | udd_documentno | varchar(40) | Yes | Aircraft Revesion Number | No |
| Prt_TypeChg_Cfg_ACModel | udd_desc20 | varchar(20) | Yes | Aircraft model | No |
| Prt_TypeChg_Cfg_ConfigClass | udd_configid | varchar(30) | Yes | config class | No |
| Prt_TypeChg_Cfg_NHAPart | udd_documentno | varchar(40) | Yes | NHA part | No |
| Prt_TypeChg_Cfg_NHACompID | udd_componentid | varchar(90) | Yes | NHA Component ID | No |
| Prt_TypeChg_Cfg_LevelCode | udd_txt150 | varchar(150) | Yes | Level code | No |
| Prt_TypeChg_Cfg_PosCode | udd_flag | varchar(25) | Yes | Pos code | No |
| Prt_TypeChg_Cfg_PosCodeStat | udd_flag | varchar(25) | Yes | Pos code Status | No |
| Prt_TypeChg_Cfg_ConfgRules | udd_componentid | varchar(90) | Yes | config rules | No |
| Prt_TypeChg_Cfg_Remarks | udd_txt255 | varchar(255) | Yes | Remarks | No |
| Prt_TypeChg_Cfg_CompRevno | udd_documentno | varchar(40) | Yes | comp revision number | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Prt_TypeChg_OpTrn_OuInstance | udd_ctxt_ouinstance | int(4) | No | Ou Instatance | No |
| Prt_TypeChg_OpTrn_ConvNumber | udd_documentno | varchar(40) | No | Conversion Number | No |
| Prt_TypeChg_OpTrn_Component | udd_desc20 | varchar(20) | Yes | Component Name | No |
| Prt_TypeChg_OpTrn_DocNo | udd_documentno | varchar(40) | Yes | Document Number | No |
| Prt_TypeChg_OpTrn_DocRevNo | udd_documentno | varchar(40) | Yes | Document Revision Number | No |
| Prt_TypeChg_OpTrn_DocType | udd_documentno | varchar(40) | Yes | Documnet Type | No |
| Prt_TypeChg_OpTrn_DocCreated | _datetime_8 | datetime(8) | Yes | Doc Created | No |
| Prt_TypeChg_OpTrn_Status | udd_flag | varchar(25) | Yes | transaction status description | No |
| Prt_TypeChg_OpTrn_RefDocNo | udd_documentno | varchar(40) | Yes | Reference Document Number | No |
| Prt_TypeChg_OpTrn_RefDocType | udd_documentno | varchar(40) | Yes | Refrence Document Type | No |
| Prt_TypeChg_OpTrn_RefDocRevNo | udd_documentno | varchar(40) | Yes | Reference Document Revision Number | No |
| Prt_TypeChg_OpTrn_RefDocStatus | udd_flag | varchar(25) | Yes | Reference Document Status | No |
| Prt_TypeChg_OpTrn_WareHouse | udd_warehouse | varchar(10) | Yes | WareHouse | No |
| Prt_TypeChg_OpTrn_Quantity | udd_amount | numeric(13) | Yes | Qty | No |
| Prt_TypeChg_OpTrn_TxnUom | udd_uom | varchar(15) | Yes | Uom | No |
| Prt_TypeChg_OpTrn_EmpCode | udd_empcode | varchar(15) | Yes | Employee Id | No |
| Prt_TypeChg_OpTrn_EmpName | udd_empcode | varchar(15) | Yes | Employee name | No |
| Prt_TypeChg_OpTrn_MntInvFlag | udd_designparamcode | varchar(5) | Yes | It will have "Y" or "N" | No |
| Prt_TypeChg_OpTrn_Remarks | udd_txt255 | varchar(255) | Yes | Remarks | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Prt_typhdr_OuInstance | udd_ctxt_ouinstance | int(4) | No | Ou Instance | No |
| Prt_typhdr_ConverNo | udd_documentno | varchar(40) | No | Conversion no | No |
| Prt_typhdr_NumberType | udd_designparamcode | varchar(5) | Yes | Nimbering Type for creating the conversion no | No |
| Prt_typhdr_ConvStatus | udd_designparamcode | varchar(5) | Yes | Conversion Status | No |
| Prt_typhdr_UserStatus | udd_flag | varchar(25) | Yes | User Status | No |
| Prt_typhdr_ConvCategory | udd_flag | varchar(25) | Yes | Conversion Category | No |
| Prt_typhdr_PartNo | udd_documentno | varchar(40) | Yes | Part no | No |
| Prt_typhdr_FrmPrt_Type | udd_designparamcode | varchar(5) | Yes | From Part Type | No |
| Prt_typhdr_FrmPrt_CtrlType | udd_flag | varchar(25) | Yes | From part control type | No |
| Prt_typhdr_ToPrt_Type | udd_designparamcode | varchar(5) | Yes | To part type | No |
| Prt_typhdr_ToPrt_CtrlType | udd_flag | varchar(25) | Yes | To part control type | No |
| Prt_typhdr_TotPrt_Qty | udd_amount | numeric(13) | Yes | Total part Qty | No |
| Prt_typhdr_Stock_Uom | udd_uomcode | varchar(10) | Yes | The main stock keeping uom for the item | No |
| Prt_typhdr_SlNo_Logic | udd_designparamcode | varchar(5) | Yes | It will have "Automatic Genration","Manufacturar SI No","Not Applicable" | No |
| Prt_typhdr_SlNo_Type | udd_designparamcode | varchar(5) | Yes | Numbering type for SI No | No |
| Prt_typhdr_LotNo_Type | udd_designparamcode | varchar(5) | Yes | Numbering type for Lot No | No |
| Prt_typhdr_Remarks | udd_txt255 | varchar(255) | Yes | Remarks | No |
| Prt_typhdr_User_Def1 | udd_flag | varchar(25) | Yes | User defined | No |
| Prt_typhdr_User_Def2 | udd_flag | varchar(25) | Yes | User Def2 | No |
| Prt_typhdr_Crtd_By | udd_ctxt_user | varchar(30) | Yes | User who created the details | No |
| Prt_typhdr_Crtd_date | udd_datetime | varchar(30) | Yes | Date at which the user created the details | No |
| Prt_typhdr_Conf_By | udd_ctxt_user | varchar(30) | Yes | User who configured the details | No |
| Prt_typhdr_Conf_Date | _datetime_8 | datetime(8) | Yes | Date at which the user configure the details | No |
| Prt_typhdr_Modfd_By | udd_ctxt_user | varchar(30) | Yes | User who modified the record. | No |
| Prt_typhdr_Modfd_Date | _datetime_8 | datetime(8) | Yes | Date at which the user modified the details | No |
| Prt_typhdr_TimeStamp | udd_timestamp | int(4) | Yes | TimeStamp for concurrency check and the no of time the record gets modified | No |
| Prt_typhdr_WF_Stage | udd_wfstatename | varchar(10) | Yes | Work flow Stage | No |
| Prt_typhdr_WF_DocKey | udd_txt150 | varchar(150) | Yes | To process work flow unique Doc key is genrated | No |
| Prt_typhdr_PlanGroup_Flag | udd_designparamcode | varchar(5) | Yes | Plan Group will have "Y" or "N" | No |
| Prt_typhdr_ComPTray_Flag | udd_designparamcode | varchar(5) | Yes | It will have "Y" or "N" | No |
| Prt_typhdr_PrmPartMap_Flag | udd_designparamcode | varchar(5) | Yes | It will have "Y" or "N" . | No |
| Prt_typhdr_MELItem_Flag | udd_designparamcode | varchar(5) | Yes | It will have "Y" or "N" . | No |
| Prt_typhdr_Cancel_Reason | udd_txt255 | varchar(255) | Yes | Reason For cancel the record | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique ID | Yes |