| BasPurReq | ||||||
| Table Name pr_parameter_details | ||||||
| Table Comment This table used to Store the Parameter Details of the Purchase request Document | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| componentname | varchar(20) | NOT NULL | This field holds the Name of the component. | Yes | No | |
| paramcategory | varchar(10) | NOT NULL | This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc. | Yes | No | |
| paramtype | varchar(25) | NOT NULL | Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows. | Yes | No | |
| paramcode | varchar(5) | NOT NULL | This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained. | Yes | No | |
| paramdesc | varchar(80) | NOT NULL | Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component | Yes | No | |
| Langid | numeric(10) | NOT NULL | Language id. This is the language id of the record. | Yes | No | |
| sortby | numeric(10) | NULL | This field holds the default sort by code | No | No | |
| creationdate | datetime | NULL | This field holds the record created date for auditing purpose. | No | No | |
| Table Name pr_praad_auth_audit_dtl | ||||||
| Table Comment This table used to Store All the Status Changes that have been made to the Purchase request Document | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| praad_pr_ouinstance | numeric(28) | NOT NULL | The Login Ouinstance | Yes | No | |
| praad_pr_no | varchar(40) | NOT NULL | purchase request no | Yes | No | |
| praad_audit_trail_id | numeric(28) | NOT NULL | Audit trail record id | Yes | No | |
| praad_auth_level_pc | varchar(25) | NOT NULL | The  Level or PC code of the user who is responsible for changing the status. | No | No | |
| praad_date_and_time | datetime | NULL | date and time on which the audit record gets posted | No | No | |
| praad_status_from | varchar(15) | NULL | THe status of the PR Document currently in ( before changing)( to be changed from) | No | No | |
| praad_status_to | varchar(15) | NULL | THe status of the PR Document currently in ( after changing)(  changed to) | No | No | |
| praad_user_name | varchar(30) | NULL | The user who has been mapped to the Level or PC. It is the same user who has logged in. | No | No | |
| Table Name pr_prapd_auth_profile_dtl | ||||||
| Table Comment This table holds the authorisation profile  Purchase Commitee details of purchase request | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prapd_ouinstance | numeric(10) | NOT NULL | This field captures the Purchase request  created ouinstance | Yes | No | |
| prapd_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | No | |
| prapd_pc_code | varchar(25) | NOT NULL | This field holds the  Purchase commitee  who authorised the  purchase request document | Yes | No | |
| prapd_emp_code | varchar(20) | NOT NULL | This field captures the Employee code | Yes | No | |
| prapd_member_auth_status | varchar(5) | NULL | This field captures the Authorised status 1. YES 2. NO | No | No | |
| prapd_auth_by | varchar(30) | NULL | The user who authorized the PO | No | No | |
| prapd_auth_date | datetime | NULL | The date when the PO is authorised. | No | No | |
| Table Name pr_praph_auth_profile_hdr | ||||||
| Table Comment This table holds the authorisation profile details of purchase request | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| praph_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request is created | Yes | No | |
| praph_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | No | |
| praph_lvl_pc_code | varchar(25) | NOT NULL | This field holds the  Authorise Level code or Purchase commitee  who authorised the  purchase request document | Yes | No | |
| praph_seqno | numeric(10) | NOT NULL | The sequence in which the PC or the LEVEL has to be authorised | Yes | No | |
| praph_type | varchar(5) | NULL | This field holds the Authorise type may be 1.LVL 2.PC | No | No | |
| praph_no_members | numeric(10) | NULL | This fields captures the  Number of person in the PC.(if the authorised type is PC) | No | No | |
| praph_pc_type | varchar(5) | NULL | This field catures the PC type may be 1. ANY (Atlease one person should be authorise the document) 2. ALL(all person should be  authorise the document) 3. Quroum | No | No | |
| praph_pc_quroum | numeric(10) | NULL | This field captures atleast How many person should be authorised the Document If the PC type is Quroum. | No | No | |
| praph_members_authorized | numeric(10) | NULL | This field capture that Till how many members are authorised the document. | No | No | |
| praph_lvl_pc_auth_Status | varchar(5) | NULL | this field captures the Authorise status  may be 1. YES 2. NO | No | No | |
| praph_last_authorized_by | varchar(30) | NULL | This field holds the user who authorised the document | No | No | |
| praph_last_auth_date | datetime | NULL | This field holds the authorised date of the purchase request document | No | No | |
| Table Name pr_prhdr_pur_request_hdr | ||||||
| Table Comment This table holds the purchase request document details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prhdr_created_by | varchar(30) | NULL | This field holds the user who created the record | No | No | |
| prhdr_creationdate | datetime | NULL | This field holds the created date of the record | No | No | |
| prhdr_modifieddate | datetime | NULL | This field holds the modified date of the record | No | No | |
| prhdr_modified_by | varchar(30) | NULL | This field holds the user who modified the record | No | No | |
| prhdr_auth_maxval | decimal(28,8) | NULL | This field holds the maximum document value for authorisation  of purchase request document can be made for the given user | No | No | |
| prhdr_stage | varchar(25) | NULL | This field holds the stage of the authorisation process | No | No | |
| prhdr_auth_nxtlvlpc | varchar(25) | NULL | This field holds the next level in the authorisation profile of purchase request document | No | No | |
| prhdr_auth_type | varchar(5) | NULL | This field holds the authorisation type whether it Purchase Committee or not | No | No | |
| prhdr_auth_minval | decimal(28,8) | NULL | This field holds the minimum document value for authorisation  of purchase request document can be made for the given user | No | No | |
| PRHDR_REQUNIT | varchar(20) | NULL | This column is used to hold the requesting unit value | No | No | |
| prhdr_expense_type | varchar(5) | NULL | This field holds the expense type of purchase request doc . Allowed values C- Capital R-Revenue | No | No | |
| PRHDR_BUYER_GROUP | varchar(25) | NULL | Save the Created Buyer Group Code in this column, If ’Buyer Group Needed for PR’ Set Option in LogCM is set as ’Required’. | No | No | |
| prhdr_timestamp | numeric(10) | NULL | This field holds the timestamp of the purchase request document | No | No | |
| PRHDR_REASON_FOR_CANC | varchar(2000) | NULL | Stores the reason for cancellation of purchase request | No | No | |
| PRHDR_PRIORITY | varchar(5) | NULL | This field holds the priority of PR to be created.  Allowed values are N-Normal, A-AOG, C-Critical and E-Expedite. | No | No | |
| prhdr_wf_doc_key | varchar(128) | NULL | stores the document key which is stored for work flow purpose | No | No | |
| PRHDR__REPLENISHMENT_FLAG | varchar(1) | NULL | This field holds whether this PR is created through Replenishment. | No | No | |
| PRHDR_BUYGRP_OU | int | NULL | Save the Created Buyer Group OU in this column, If ’Buyer Group Needed for PR’ Set Option in LogCM is set as ’Required’. | No | No | |
| prhdr_pr_category | varchar(25) | NULL | This field holds the category of purchase request document | No | No | |
| prhdr_need_date | datetime | NULL | This field holds the need date for the purchase request document | No | No | |
| prhdr_ordering_ou | numeric(10) | NULL | This field contains the ouinstance where the purchase order is going to be raised | No | No | |
| prhdr_receiving_ou | numeric(10) | NULL | This field contains the ouinstance where the goods receipt  is going to be raised | No | No | |
| prhdr_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request is created | Yes | No | |
| prhdr_num_type_no | varchar(5) | NULL | This field holds the numbering type number of purchase request document | No | No | |
| prhdr_pr_status | varchar(5) | NULL | This field holds the purchase request status . Allowed values A- Active I-Inactive | No | No | |
| prhdr_pr_date | datetime | NULL | This field holds the purchase request date | No | No | |
| prhdr_auth_terlevel | varchar(25) | NULL | This field holds the terminating level in the authorisation profile of purchase request document | No | No | |
| prhdr_pr_value | decimal(28,8) | NULL | This field holds the value  of the purchase request document | No | No | |
| prhdr_part_type | varchar(25) | NULL | This field holds the part type of the purchase request document | No | No | |
| prhdr_basecurrency | varchar(20) | NULL | This field holds the base currency of the purchase request document | No | No | |
| prhdr_pr_type | varchar(5) | NULL | This field holds the type of the purchase request document | No | No | |
| prhdr_remarks | varchar(255) | NULL | This field holds the remarks of the purchase request document | No | No | |
| prhdr_approved_by | varchar(30) | NULL | This field holds the user who approved the document | No | No | |
| prhdr_user_status | varchar(25) | NULL | This field holds the user status of the purchase request document | No | No | |
| prhdr_approveddate | datetime | NULL | This field holds the approved date of the purchase request document | No | No | |
| prhdr_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | No | |
| Table Name pr_pritm_pr_item_details | ||||||
| Table Comment This table holds the purchase request item details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| pritm_shortcls_qty | decimal(28,8) | NULL | This field captures short close quantity | No | No | |
| pritm_ref_doc_ou | decimal(10) | NULL | This is the ouinstance in which reference document for this purchase request is created. | No | No | |
| pritm_capex_no | varchar(18) | NULL | This field  captures the capex no of the part. | No | No | |
| pritm_alternate_type | varchar(5) | NOT NULL | This field captures alternate type | No | No | |
| pritm_alternate_part_no | varchar(40) | NULL | This field captures alternate part no | No | No | |
| pritm_modifieddate | datetime | NULL | This field  captures the date when the PR item details are modified  in the system | No | No | |
| pritm_created_by | varchar(30) | NULL | This field  captures the user who created the PR item details | No | No | |
| pritm_ref_doc_line_no | numeric(10) | NULL | This field  captures the reference document line no . | No | No | |
| pritm_modified_by | varchar(30) | NULL | This field  captures the user who modified the PR item details | No | No | |
| pritm_work_center | varchar(30) | NULL | This field captures the work center. | No | No | |
| pritm_createddate | datetime | NULL | This field  captures the date when the PR item details are created in the system | No | No | |
| PRITM_SUBANLY_CODE | varchar(30) | NULL | Thsi column holds the subanalysis code value | No | No | |
| PRITM_ANLY_CODE | varchar(30) | NULL | This column holds the analysis code value | No | No | |
| PRITM_MR_LINENO | int | NULL | This column holds the MR line No | No | No | |
| PRITM_MRPRCOV_QTY | varchar(30) | NULL | This column holds the MR PR covered quantity maintained only at the backend level | No | No | |
| pritm_scl_comments | varchar(255) | NULL | This field captures short close comments | No | No | |
| PRITM_REF_DOC_TYPE | varchar(5) | NULL | reference document type | No | No | |
| pritm_line_status | NULL | This field captures line status | No | No | ||
| PRITM_COST_BASIS | varchar(30) | NULL | This column holds the cost basis value | No | No | |
| PRITM_ACC_USAGE | varchar(20) | NULL | This column holds the accounting usage value | No | No | |
| PRITM_CST_USAGE | varchar(30) | NULL | This column holds the costing usage value | No | No | |
| PRITM_KNOCKOFF_PRQTY_INSTKUOM | bigint | NULL | This column holds the  MR knock off quantity from PR-PO maintained only at the backend level.(To update the pending Demand table) | No | No | |
| pritm_order_qty | decimal(28,8) | NULL | This field  captures the PO Covered quantity (updated from PO component) | No | No | |
| pritm_required_qty | decimal(28,8) | NULL | This field  captures the request  qty of each line item of the PR | No | No | |
| pritm_pending_qty | decimal(28,8) | NULL | when create the PR, pending qty is same as required qty when update the ordered quantity from PO Pending quantity = required quantity - order quantity | No | No | |
| pritm_cost | decimal(28,8) | NULL | This field  captures the Cost of the part, depending on cost per, it can be either cost of 1 part or more. | No | No | |
| PRITM_COSTPER | numeric(28,8) | NULL | This field  captures the Unit cost of the part | No | No | |
| pritm_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| pritm_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request  is created | Yes | Yes | |
| pritm_part_ou | numeric(10) | NULL | This field  captures the Part created ouinstance | No | No | |
| pritm_pr_serial_no | numeric(10) | NOT NULL | This field capures the Unique identifier number for the part of the PR | Yes | No | |
| pritm_part_no | varchar(40) | NULL | This field  captures the Part number requested in the PR | No | ||
| pritm_quality_attribute | varchar(5) | NULL | This fields captures the Quality Attribute  with the following values 1. (S)tandard 2. (C)ustom 3. (N)one | No | No | |
| pritm_part_uom | varchar(10) | NULL | This field  captures  Any valid UOM from the UOM component in which the goods can be purchased . | No | No | |
| pritm_ref_doc_no | varchar(40) | NULL | This field  captures the reference document no this used to find from  where the request is raised. | No | No | |
| pritm_condition | varchar(25) | NULL | This field  captures  the part condition List of values are New New Surplus Overhaul Servicable Unservicable | No | No | |
| pritm_ref_doc_revno | varchar(40) | NULL | stores the revision no of reference document for this PR | No | No | |
| pritm_delivery_type | varchar(25) | NULL | This field  captures the  purchase request’s delivery  type List of values are (S)ingle -- all the requested qty will be delivered in a single  schedule. (M)ultiple -- the requested qty will be delivered in a staggered schedule dates. | No | No | |
| pritm_wh_code | varchar(10) | NULL | This field  captures the warehoouse code | No | No | |
| pritm_need_date | datetime | NULL | This field  captures the date in which the ordered  qty has to be delivered. | No | No | |
| pritm_comments | varchar(255) | NULL | This field captures the comments, | No | No | |
| pritm_wh_ou | numeric(10) | NULL | stores the warehouse OU instance | No | No | |
| pritm_supp_code | varchar(45) | NULL | This field  captures the Supplier code from the supplier component who has raise the purchase request. | No | No | |
| Table Name PR_PRQC_QUICK_CODE | ||||||
| Table Comment This table maintains the Quick Code information. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| PRQC_OUINSTANCE | decimal(10) | NOT NULL | Ou instance | Yes | No | |
| PRQC_QUICK_CODE | varchar(25) | NOT NULL | Quick Code number stored here. | Yes | No | |
| PRQC_TYPE | varchar(25) | NOT NULL | Quick Code Type | Yes | No | |
| PRQC_DESCRIPTION | varchar(150) | NOT NULL | Quick Code Description | No | No | |
| PRQC_STATUS | varchar(25) | NULL | Quick Code Status is stored here. ’A’ - Active ’I’ - Inactive | No | No | |
| PRQC_CREATED_BY | varchar(30) | NULL | User who has created the quick code | No | No | |
| PRQC_CREATEDDATE | datetime | NULL | Date on which quick code got created | No | No | |
| PRQC_MODIFIED_BY | varchar(30) | NULL | User who has modified the quick code. | No | No | |
| PRQC_MODIFIEDDATE | datetime | NULL | Date on which quick code got modified. | No | No | |
| PRQC_TIMESTAMP | decimal(10) | NULL | Quick code Time stamp details. | No | No | |
| Table Name pr_prqua_pr_quality_dtl | ||||||
| Table Comment This table is Used To store the Parameter Information which was captured from the Aircraft Component and the Present Value for the related Part No associated with the PR Document. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prqua_std_qual_value | varchar(80) | NULL | This field holds the standard qualitative value | No | No | |
| prqua_trackable | varchar(5) | NULL | This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO | No | No | |
| prqua_std_max_value | decimal(28,8) | NULL | This field holds the standard maximum value of PR document | No | No | |
| prqua_std_min_value | decimal(28,8) | NULL | This field holds the standard minimum value of PR document | No | No | |
| prqua_std_value | decimal(28,8) | NULL | This field holds the standard  value of PR document | No | No | |
| prqua_modifieddate | datetime | NULL | This field holds the modified date of the record | No | No | |
| prqua_remarks | varchar(255) | NULL | This field holds the inspect remarks of PR component | No | No | |
| prqua_created_by | varchar(30) | NULL | This field holds the user who created the record | No | No | |
| prqua_createddate | datetime | NULL | This field holds the created date of the record | No | No | |
| prqua_modified_by | varchar(30) | NULL | This field holds the user who modified the record | No | No | |
| prqua_pr_serial_no | numeric(10) | NOT NULL | This field holds the uniquely generated id of PR document | Yes | Yes | |
| prqua_pr_attribute_id | varchar(40) | NOT NULL | This field holds the attribute id of PR document | Yes | No | |
| prqua_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| prqua_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request  is created | Yes | Yes | |
| prqua_minimum_value | decimal(28,8) | NULL | This field holds the minimum value of PR  document | No | No | |
| prqua_attribute_type | varchar(5) | NULL | This field is to capture the attribute type of PR document | No | No | |
| prqua_maximum_value | decimal(28,8) | NULL | This field holds the maximum value of PR  document | No | No | |
| pritm_part_no | varchar(40) | NOT NULL | This field  captures the Part number requested in the PR | Yes | Yes | |
| prqua_attribute_code | varchar(10) | NULL | This field is to capture the attribute code of the PR document | No | No | |
| prqua_attribute_ou | numeric(10) | NULL | This field holds the ouinstance of attribute component with which PR is created. | No | No | |
| Table Name pr_prsch_pr_sch_details | ||||||
| Table Comment This table holds the purchase request  schedule details | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prsch_created_by | varchar(30) | NULL | This field  captures the user who created the PR schedule details | No | No | |
| prsch_createddate | datetime | NULL | This field  captures the date when the PR Schedule details are created in the system | No | No | |
| prsch_sch_date | datetime | NULL | This field captures the  date in which the schedule qty has to be delivered. | No | No | |
| prsch_pending_sch_qty | decimal(28,8) | NULL | stores the pending schedule quantity | No | No | |
| prsch_modifieddate | datetime | NULL | This field  captures the date when the PR Schedule details are modified in the system | No | No | |
| prsch_modified_by | varchar(30) | NULL | This field  captures the user who modified the PR schedule details | No | No | |
| PRITM_REF_DOC_TYPE | varchar(5) | NULL | column to store reference document type | No | No | |
| prsch_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| prsch_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request schedule details  is created | Yes | Yes | |
| prsch_sch_qty | decimal(28,8) | NULL | This field captures the schedule quantity of the part | No | No | |
| pritm_part_no | varchar(40) | NOT NULL | This field  captures the Part number requested in the PR | Yes | Yes | |
| prsch_pr_serial_no | numeric(10) | NOT NULL | This field capures the Unique identifier number for the part of the PR | Yes | Yes | |
| prsch_sch_no | numeric(10) | NOT NULL | This field captures the schedule  number | Yes | No | |
| Table Name PR_PRSOPT_SETOPTION_INFO | ||||||
| Table Comment This table is used to store numbering type options for Automatic PR creation. | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| PRSOPT_PR_OUINSTANCE | decimal(10) | NOT NULL | This is the ouinstance in which Automatic purchase request is created | Yes | No | |
| PRSOPT_NUMTYP_FOR_AUTOPR | varchar(5) | NOT NULL | This the default numbering type defined for Automatic PR creation. | Yes | No | |
| PRSOPT_CREATED_DATE | datetime | NULL | This field captures the date when the default numbering type details are created for Automatic PR  created in the system | No | No | |
| PRSOPT_CREATED_BY | varchar(30) | NULL | This field captures the user who created the default numbering type for Automatic PR created. | No | No | |
| PRSOPT_MODIFIED_DATE | datetime | NULL | This field captures the date when the Set Options for Default numbering type for Automatic PR is  modified in the system | No | No | |
| PRSOPT_MODIFIED_BY | varchar(30) | NULL | This field captures the user who modified the default numbering type for Automatic PR Creation. | No | No | |
| PRSOPT_DefStdNote | sql_variant | NULL | This field captures the default standard note setting | No | No | |
| Table Name pr_prudi_user_def_info | ||||||
| Table Comment This table holds the user defined info of  purchase request document | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prudi_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request document is created | Yes | Yes | |
| prudi_pr_no | varchar(40) | NOT NULL | This field holds the document number of purchase request component | No | No | |
| prudi_user_def_desc1 | varchar(30) | NULL | This field holds the first user defined description | No | No | |
| prudi_user_def_opt1 | varchar(30) | NULL | This field holds the first user defined option | No | No | |
| prudi_user_def_desc2 | varchar(30) | NULL | This field holds the second user defined description | No | No | |
| prudi_user_def_opt2 | varchar(30) | NULL | This field holds the second user defined option | No | No | |
| prudi_user_def_desc3 | varchar(30) | NULL | This field holds the third user defined description | No | No | |
| prudi_user_def_opt3 | varchar(30) | NULL | This field holds the third user defined option | No | No | |
| prudi_user_def_desc4 | varchar(30) | NULL | This field holds the fourth user defined description | No | No | |
| prudi_user_def_opt4 | varchar(30) | NULL | This field holds the fourth user defined option | No | No | |
| prudi_user_def_remarks | varchar(255) | NULL | This field holds the user defined remarks | No | No | |
| prudi_created_date | datetime | NULL | This field holds the created date of the record | No | No | |
| prudi_created_by | varchar(30) | NULL | This field holds the user who created the record | No | No | |
| prudi_modified_date | datetime | NULL | This field holds the modified  date of the record | No | No | |
| prudi_modified_by | varchar(30) | NULL | This field holds the user who modified  the record | No | No | |
| Table Name PRA_PRHDR_PUR_REQUEST_HDR | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| PRAHDR_OUINSTANCE | int | NOT NULL | This is the ouinstance in which purchase request is created | Yes | No | |
| PRAHDR_PR_NO | VARCHAR(40) | NOT NULL | This field holds the purchase request number | Yes | No | |
| PRAHDR_AMEND_NO | varchar(40) | NOT NULL | PR Amendment No | Yes | No | |
| prhdr_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| prhdr_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request is created | Yes | Yes | |
| PRAHDR_PR_STATUS | varchar(5) | NULL | This field holds the purchase request status . Allowed values A- Active I-Inactive | No | No | |
| PRAHDR_PR_DATE | datetime | This field holds the purchase request date | No | No | ||
| PRAHDR_NUM_TYPE_NO | varbinary(5) | NULL | This field holds the numbering type number of purchase request document | No | No | |
| PRAHDR_NEED_DATE | datetime | NULL | This field holds the need date for the purchase request document | No | No | |
| PRAHDR_PR_CATEGORY | varchar(25) | NULL | This field holds the category of purchase request document | No | No | |
| PRAHDR_ORDERING_OU | int | NULL | This field contains the ouinstance where the purchase order is going to be raised | No | No | |
| PRAHDR_RECEIVING_OU | int | NULL | This field contains the ouinstance where the goods receipt  is going to be raised | No | No | |
| PRAHDR_PR_TYPE | varchar(5) | NULL | This field holds the type of the purchase request document | No | No | |
| PRAHDR_REMARKS | varchar(255) | NULL | This field holds the remarks of the purchase request document | No | No | |
| PRAHDR_USER_STATUS | varchar(25) | NULL | This field holds the user status of the purchase request document | No | No | |
| PRAHDR_APPROVEDDATE | datetime | NULL | This field holds the approved date of the purchase request document | No | No | |
| PRAHDR_APPROVED_BY | varchar(30) | NULL | This field holds the user who approved the document | No | No | |
| PRAHDR_PART_TYPE | varchar(25) | NULL | This field holds the part type of the purchase request document | No | No | |
| PRAHDR_PR_VALUE | decimal(28,8) | NULL | This field holds the value  of the purchase request document | No | No | |
| PRAHDR_BASECURRENCY | varchar(20) | NULL | This field holds the base currency of the purchase request document | No | No | |
| PRAHDR_AUTH_TYPE | varchar(5) | NULL | This field holds the authorisation type whether it Purchase Committee or not | No | No | |
| PRAHDR_STAGE | varchar(25) | NULL | This field holds the stage of the authorisation process | No | No | |
| PRAHDR_CREATIONDATE | datetime | NULL | This field holds the created date of the record | No | No | |
| PRAHDR_CREATED_BY | varchar(30) | NULL | This field holds the user who created the record | No | No | |
| PRAHDR_MODIFIEDDATE | datetime | NULL | This field holds the modified date of the record | No | No | |
| PRAHDR_MODIFIED_BY | varchar(30) | NULL | This field holds the user who modified the record | No | No | |
| PRAHDR_TIMESTAMP | int | NULL | This field holds the timestamp of the purchase request document | No | No | |
| PRAHDR_REASON_FOR_CANC | varchar(2000) | NULL | Stores the reason for cancellation of purchase request | No | No | |
| PRAHDR_WF_DOC_KEY | varchar(128) | NULL | stores the document key which is stored for work flow purpose | No | No | |
| PRAHDR__REPLENISHMENT_FLAG | varchar(1) | NULL | This field holds whether this PR is created through Replenishment. | No | No | |
| PRAHDR_PRIORITY | varchar(5) | NULL | This field holds the priority of PR to be created.  Allowed values are N-Normal, A-AOG, C-Critical and E-Expedite. | No | No | |
| PRAHDR_EXPENSE_TYPE | NULL | This field holds the expense type of purchase request doc . Allowed values C- Capital R-Revenue | No | No | ||
| PRAHDR_REQUNIT | varchar(20) | NULL | This column is used to hold the requesting unit value | No | No | |
| PRAHDR_BUYER_GROUP | varchar(25) | NULL | Save the Created Buyer Group Code in this column, If ’Buyer Group Needed for PR’ Set Option in LogCM is set as ’Required’. | No | No | |
| PRAHDR_BUYGRP_OU | int | NULL | Save the Created Buyer Group OU in this column, If ’Buyer Group Needed for PR’ Set Option in LogCM is set as ’Required’. | No | No | |
| PRAHDR_AMENDED_BY | varchar(30) | NULL | PR Amended By | No | No | |
| PRAHDR_AMENDED_DATE | datetime | NULL | PR Amended Date | No | No | |
| Table Name PRA_PRITM_PR_ITEM_DETAILS | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| PRAITM_OUINSTANCE | int | NOT NULL | This is the ouinstance in which purchase request  is created | No | No | |
| PRAITM_PR_NO | varchar(40) | NOT NULL | This field holds the purchase request number | No | No | |
| PRAITM_AMEND_NO | int | NOT NULL | PR Amendment No | No | No | |
| PRAITM_PR_SERIAL_NO | int | NOT NULL | This field capures the Unique identifier number for the part of the PR | No | No | |
| PRAITM_PART_NO | varchar(40) | NOT NULL | This field  captures the Part number requested in the PR | No | No | |
| PRAITM_PART_OU | int | NULL | This field  captures the Part created ouinstance | No | No | |
| PRAITM_REQUIRED_QTY | decimal(28,8) | NULL | This field  captures the request  qty of each line item of the PR | No | No | |
| PRAITM_ORDER_QTY | decimal(28,8) | NULL | This field  captures the PO Covered quantity (updated from PO component) | No | No | |
| PRAITM_PENDING_QTY | decimal(28,8) | NULL | when create the PR, pending qty is same as required qty when update the ordered quantity from PO Pending quantity = required quantity - order quantity | No | No | |
| PRAITM_COST | decimal(28,8) | NULL | This field  captures the Cost of the part, depending on cost per, it can be either cost of 1 part or more. | No | No | |
| PRAITM_COSTPER | decimal(28,8) | NULL | This field  captures the Unit cost of the part | No | No | |
| PRAITM_DELIVERY_TYPE | varchar(25) | NULL | This field  captures the  purchase request’s delivery  type List of values are (S)ingle -- all the requested qty will be delivered in a single  schedule. (M)ultiple -- the requested qty will be delivered in a staggered schedule dates. | No | No | |
| PRAITM_NEED_DATE | datetime | NULL | This field  captures the date in which the ordered  qty has to be delivered. | No | No | |
| PRAITM_WH_CODE | varchar(10) | NULL | This field  captures the warehoouse code | No | No | |
| PRAITM_WH_OU | int | NULL | stores the warehouse OU instance | No | No | |
| PRAITM_SUPP_CODE | varchar(45) | NULL | This field  captures the Supplier code from the supplier component who has raise the purchase request. | No | No | |
| PRAITM_COMMENTS | varchar(255) | NULL | This field captures the comments, | No | No | |
| PRAITM_REF_DOC_NO | varchar(40) | NULL | This field  captures the reference document no this used to find from  where the request is raised. | No | No | |
| PRAITM_PART_UOM | varchar(15) | NULL | This field  captures  Any valid UOM from the UOM component in which the goods can be purchased . | No | No | |
| PRAITM_CONDITION | NULL | This field  captures  the part condition List of values are New New Surplus Overhaul Servicable Unservicable | No | No | ||
| PRAITM_REF_DOC_REVNO | int | NULL | stores the revision no of reference document for this PR | No | No | |
| PRAITM_QUALITY_ATTRIBUTE | varchar(5) | NULL | This fields captures the Quality Attribute  with the following values 1. (S)tandard 2. (C)ustom 3. (N)one | No | No | |
| PRAITM_CREATEDDATE | datetime | NULL | This field  captures the date when the PR item details are created in the system | No | No | |
| PRAITM_CREATED_BY | varchar(30) | NULL | This field  captures the user who created the PR item details | No | No | |
| PRAITM_MODIFIEDDATE | datetime | NULL | This field  captures the date when the PR item details are modified  in the system | No | No | |
| PRAITM_MODIFIED_BY | varchar(30) | NULL | This field  captures the user who modified the PR item details | No | No | |
| PRAITM_WORK_CENTER | varchar(30) | NULL | This field captures the work center. | No | No | |
| PRAITM_REF_DOC_LINE_NO | varchar(30) | NULL | This field  captures the reference document line no . | No | No | |
| PRAITM_REF_DOC_OU | int | NULL | This is the ouinstance in which reference document for this purchase request is created. | No | No | |
| PRAITM_SHORTCLS_QTY | decimal(28,8) | NULL | This field captures short close quantity | No | No | |
| PRAITM_CAPEX_NO | varchar(20) | NULL | This field  captures the capex no of the part. | No | No | |
| PRAITM_ALTERNATE_TYPE | varchar(5) | NULL | This field captures alternate type | No | No | |
| PRAITM_ALTERNATE_PART_NO | varchar(40) | NULL | This field captures alternate part no | No | No | |
| PRAITM_SCL_COMMENTS | varchar(255) | NULL | This field captures short close comments | No | No | |
| PRAITM_LINE_STATUS | varchar(5) | NULL | This field captures line status | No | No | |
| PRAITM_REF_DOC_TYPE | varchar(5) | NULL | reference document type | No | No | |
| PRAITM_TASK_NO | varchar(30) | NULL | No | No | ||
| PRAITM_INTSEQ_NO | int | NULL | No | No | ||
| PRAITM_COST_BASIS | varchar(20) | NULL | This column holds the cost basis value | No | No | |
| PRAITM_ACC_USAGE | varchar(20) | NULL | This column holds the accounting usage value | No | No | |
| PRAITM_CST_USAGE | varchar(20) | NULL | This column holds the costing usage value | No | No | |
| PRAITM_ANLY_CODE | varchar(20) | NULL | This column holds the analysis code value | No | No | |
| PRAITM_SUBANLY_CODE | varchar(20) | NULL | Thsi column holds the subanalysis code value | No | No | |
| PRAITM_MR_LINENO | int | NULL | This column holds the MR line No | No | No | |
| PRAITM_MRPRCOV_QTY | decimal(28,8) | NULL | This column holds the MR PR covered quantity maintained only at the backend level | No | No | |
| PRAITM_KNOCKOFF_PRQTY_INSTKUOM | decimal(28,8) | NULL | This column holds the  MR knock off quantity from PR-PO maintained only at the backend level.(To update the pending Demand table) | No | No | |
| PRAITM_REP_FLAG | varchar(25) | NULL | Replenishment Flag | No | No | |
| PRAITM_REP_WH | varchar(10) | NULL | Replenishment Warehouse | No | No | |
| PRAITM_REP_WHQTY | decimal(28,8) | NULL | Replenishment Quantity | No | No | |
| Table Name PRA_PRSCH_PR_SCH_DETAILS | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prsch_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request schedule details  is created | Yes | Yes | |
| prsch_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| prsch_pr_serial_no | numeric(10) | NOT NULL | This field capures the Unique identifier number for the part of the PR | Yes | Yes | |
| prsch_sch_no | numeric(10) | NOT NULL | This field captures the schedule  number | Yes | Yes | |
| pritm_part_no | varchar(40) | NOT NULL | This field  captures the Part number requested in the PR | Yes | Yes | |
| PRSCH_OUINSTANCE | int | NOT NULL | This is the ouinstance in which purchase request is created | No | No | |
| PRSCH_PR_NO | varchar(40) | NOT NULL | This field holds the purchase request number | No | No | |
| PRSCH_PR_SERIAL_NO | int | NOT NULL | This field capures the Unique identifier number for the part of the PR | No | No | |
| PRSCH_SCH_NO | int | NOT NULL | This field captures the schedule  number | No | No | |
| PRSCH_SCH_QTY | decimal(28,8) | NULL | This field captures the schedule quantity of the part | No | No | |
| PRSCH_SCH_DATE | datetime | NULL | This field captures the  date in which the schedule qty has to be delivered. | No | No | |
| PRSCH_PENDING_SCH_QTY | decimal(28,8) | NULL | stores the pending schedule quantity | No | No | |
| PRSCH_CREATEDDATE | datetime | NULL | This field  captures the date when the PR Schedule details are created in the system | No | No | |
| PRSCH_CREATED_BY | varchar(30) | NULL | This field  captures the user who created the PR schedule details | No | No | |
| PRSCH_MODIFIEDDATE | datetime | NULL | This field  captures the date when the PR Schedule details are modified in the system | No | No | |
| PRSCH_MODIFIED_BY | varchar(30) | NULL | This field  captures the user who modified the PR schedule details | No | No | |
| Table Name PRA_PRUDI_USER_DEF_INFO | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prudi_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request document is created | Yes | Yes | |
| prudi_pr_no | varchar(40) | NOT NULL | This field holds the document number of purchase request component | Yes | Yes | |
| PRAUDI_OUINSTANCE | int | NOT NULL | This is the ouinstance in which purchase request  is created | Yes | Yes | |
| PRAUDI_PR_NO | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| PRAUDI_AMEND_NO | int | NOT NULL | PR AmendmentNo | Yes | Yes | |
| PRAUDI_USER_DEF_DESC1 | varchar(40) | NOT NULL | This field holds the first user defined description | Yes | Yes | |
| PRAUDI_USER_DEF_OPT1 | varchar(40) | NOT NULL | This field holds the first user defined option | Yes | Yes | |
| PRAUDI_USER_DEF_DESC2 | varchar(40) | NOT NULL | This field holds the second user defined description | Yes | Yes | |
| PRAUDI_USER_DEF_OPT2 | varchar(40) | NOT NULL | This field holds the second user defined option | Yes | Yes | |
| PRAUDI_USER_DEF_DESC3 | varchar(40) | NOT NULL | This field holds the third user defined description | Yes | Yes | |
| PRAUDI_USER_DEF_OPT3 | varchar(40) | NOT NULL | This field holds the third user defined option | Yes | Yes | |
| PRAUDI_USER_DEF_DESC4 | varchar(40) | NOT NULL | This field holds the fourth user defined description | Yes | Yes | |
| PRAUDI_USER_DEF_OPT4 | varchar(40) | NOT NULL | This field holds the fourth user defined option | Yes | Yes | |
| PRAUDI_USER_DEF_REMARKS | varchar(255) | NOT NULL | This field holds the user defined remarks | Yes | Yes | |
| PRAUDI_CREATED_DATE | datetime | NOT NULL | This field holds the created date of the record | Yes | Yes | |
| PRAUDI_CREATED_BY | varchar(40) | NOT NULL | This field holds the user who created the record | Yes | Yes | |
| PRAUDI_MODIFIED_DATE | datetime | NOT NULL | This field holds the modified  date of the record | Yes | Yes | |
| PRAUDI_MODIFIED_BY | varchar(40) | NOT NULL | This field holds the user who modified  the record | Yes | Yes | |
| Table Name PRA_PRUQA_PR_QUALITY_DTL | ||||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK | |
| prqua_ouinstance | numeric(10) | NOT NULL | This is the ouinstance in which purchase request  is created | Yes | Yes | |
| prqua_pr_no | varchar(40) | NOT NULL | This field holds the purchase request number | Yes | Yes | |
| prqua_pr_serial_no | numeric(10) | NOT NULL | This field holds the uniquely generated id of PR document | Yes | Yes | |
| prqua_pr_attribute_id | varchar(40) | NOT NULL | This field holds the attribute id of PR document | Yes | Yes | |
| pritm_part_no | varchar(40) | NOT NULL | This field  captures the Part number requested in the PR | Yes | Yes | |
| PRAQUA_OUINSTANCE | int | NOT NULL | This is the ouinstance in which purchase request  is created | No | No | |
| PRAQUA_PR_NO | varchar(40) | NOT NULL | This field holds the purchase request number | No | No | |
| PRAQUA_AMEND_NO | int | NOT NULL | PR Amendment No | No | No | |
| PRAQUA_PR_SERIAL_NO | int | NOT NULL | This field holds the uniquely generated id of PR document | No | No | |
| PRAQUA_PR_ATTRIBUTE_ID | varchar(40) | NOT NULL | This field holds the attribute id of PR document | No | No | |
| PRAQUA_ATTRIBUTE_OU | int | NULL | This field holds the ouinstance of attribute component with which PR is created. | No | No | |
| PRAQUA_ATTRIBUTE_CODE | varchar(25) | NULL | This field is to capture the attribute code of the PR document | No | No | |
| PRAQUA_ATTRIBUTE_TYPE | varchar(5) | NULL | This field is to capture the attribute type of PR document | No | No | |
| PRAQUA_MAXIMUM_VALUE | decimal(28,8) | NULL | This field holds the maximum value of PR  document | No | No | |
| PRAQUA_MINIMUM_VALUE | decimal(28,8) | NULL | This field holds the minimum value of PR  document | No | No | |
| PRAQUA_STD_VALUE | decimal(28,8) | NULL | This field holds the standard  value of PR document | No | No | |
| PRAQUA_STD_MIN_VALUE | decimal(28,8) | NULL | This field holds the standard minimum value of PR document | No | No | |
| PRAQUA_STD_MAX_VALUE | decimal(28,8) | NULL | This field holds the standard maximum value of PR document | No | No | |
| PRAQUA_STD_QUAL_VALUE | varchar(80) | NULL | This field holds the standard qualitative value | No | No | |
| PRAQUA_TRACKABLE | varchar(5) | NULL | This field is set when the trackable option is allowed. Allowed values are 1.YES 2.NO | No | No | |
| PRAQUA_REMARKS | varchar(255) | NULL | This field holds the inspect remarks of PR component | No | No | |
| PRAQUA_CREATEDDATE | datetime | NULL | This field holds the created date of the record | No | No | |
| PRAQUA_CREATED_BY | varchar(30) | NULL | This field holds the user who created the record | No | No | |
| PRAQUA_MODIFIEDDATE | datetime | NULL | This field holds the modified date of the record | No | No | |
| PRAQUA_MODIFIED_BY | varchar(30) | NULL | This field holds the user who modified the record | No | No | |