| BasChkPack | |||||
| Table Name VP_VPWUAP_VPWU_AP_TASK | |||||
| Table Comment This Table Maintains Access Panel Tasks for the Acess Panel | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| VPWUAP_OUINSTANCE | numeric(28) | NOT NULL | OUinstance | No | No |
| VPWUAP_VISIT_PKG_NO | varchar(40) | NOT NULL | Visit Package No | No | No |
| VPWUAP_REV_NO | varchar(40) | NOT NULL | Revision No. | No | No |
| VPWUAP_SEQ_NO | numeric(28) | NOT NULL | Sequence no of the task | No | No |
| VPWUAP_SCH_DATE | datetime | NULL | Schduled Date if the task | No | No |
| VPWUAP_AP_TASK | varchar(40) | NOT NULL | Access Panel Task | No | No |
| VPWUAP_AP_TASK_TYPE | varchar(20) | NULL | Acess Panel task Type | No | No |
| VPWUAP_TASK_NO | varchar(40) | NULL | Task No | No | No |
| VPWUAP_ACCESS_PANEL | varchar(20) | NULL | Access panel code | No | No |
| Table Name vpkg_parameter_details | |||||
| Table Comment Meta Data Table for Central Planning | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpkg_componentname | varchar(80) | NOT NULL | component Name | Yes | No |
| vpkg_ParamCategory | varchar(10) | NOT NULL | Parameter Category | Yes | No |
| vpkg_ParamType | varchar(25) | NOT NULL | Parameter Type | Yes | No |
| vpkg_ParamCode | varchar(5) | NOT NULL | Parameter Code | Yes | No |
| vpkg_ParamDesc | varchar(80) | NULL | Parameter Description | No | No |
| vpkg_Langid | numeric(10) | NULL | Language Id | No | No |
| vpkg_Creationdate | datetime | NULL | Creation Date | No | No |
| vpkg_sortby | numeric(10) | NULL | Sort By | No | No |
| Table Name vpkg_quick_code | |||||
| Table Comment User defined Quick Codes Master | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpkg_ouinstance | numeric(10) | NOT NULL | OUInstance | Yes | No |
| vpkg_quick_code | varchar(25) | NOT NULL | Quick Code | Yes | No |
| vpkg_type | varchar(80) | NOT NULL | Quick Code Type - ’Aircraft Group Category’, "Aircraft Type", "Model Type", "Usage Type", "Aircraft Details - 1", "Aircraft Details - 2", "Aircraft Details - 3", "Component Details - 1", "Component Details - 2", "Component Details - 3" | Yes | No |
| vpkg_description | varchar(80) | NULL | Description | No | No |
| vpkg_status | varchar(5) | NULL | Status - Can be A - Active or I - Inactive | No | No |
| vpkg_created_by | varchar(30) | NOT NULL | Created By | No | No |
| vpkg_modified_by | varchar(30) | NULL | Modified By | No | No |
| vpkg_creationdate | datetime | NOT NULL | Creation Date | No | No |
| vpkg_modifieddate | datetime | NULL | Last Modified date | No | No |
| vpkg_timestamp | numeric(10) | NOT NULL | Timestamp | No | No |
| Table Name VPKG_VPAME_ADNL_MANHRS_EXT | |||||
| Table Comment Stores Additional Manhours | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| VPAME_OUINSTANCE | decimal(10) | NOT NULL | Ouinstance | No | No |
| VPAME_VISIT_PKG_NO | varchar(40) | NOT NULL | Visit Package Number | No | No |
| VPAME_REV_NO | varchar(40) | NOT NULL | Revision Number of the Visit Package | No | No |
| VPAME_WCCODE | varchar(40) | NOT NULL | Work Center Code | No | No |
| VPAME_AC_OU | decimal(10) | NULL | Aircraft Ouinstance | No | No |
| VPAME_AIRCRAFT_REG_NO | varchar(30) | NULL | Aircraft Registration Number for which the Vistipackagae is applicable | No | No |
| VPAME_USER_STATUS | varchar(25) | NULL | User defined status of the visitpackage | No | No |
| VPAME_CUMULATIVE_MANHRS | decimal(28,8) | NULL | Cumulative Man Hours | No | No |
| VPAME_EXTEND_BY | decimal(28,8) | NULL | No | No | |
| VPAME_ORGINAL_TARGET_DATE | datetime | NULL | Original Target Date | No | No |
| VPAME_REVISED_TARGET_DATE | datetime | NULL | Revised Target Date | No | No |
| VPAME_REVISED_PLEND_DATE | datetime | NULL | Revised Planned End date | No | No |
| VPAME_COMMENTS | varchar(255) | NULL | Any comments to be added | No | No |
| VPAME_TIMESTAMP | decimal(10) | NULL | Timstamp is the number which will indicate the no of times the record is modifed | No | No |
| VPAME_MODIFIEDDATE | datetime | NULL | Record Modified Date | No | No |
| VPAME_MODIFIED_BY | varchar(30) | NULL | No | No | |
| VPAME_PRIORITY | decimal(10) | NULL | Priority Number | No | No |
| VPAME_EXEC_MODE | decimal(10) | NOT NULL | No | No | |
| Table Name vpkg_vpapt_task_ap_map | |||||
| Table Comment This table is maintained for Design purpose - Access Panel Tasks for a Task is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpapt_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| vpapt_visit_pkg_no | varchar(40) | NOT NULL | Visit Package No. | Yes | No |
| vpapt_rev_no | varchar(40) | NOT NULL | Latest Revison No of the visit package | Yes | No |
| vpapt_task_code | varchar(30) | NOT NULL | Task(work unit) code | Yes | No |
| vpapt_access_panel | varchar(30) | NOT NULL | Access Panel code | Yes | No |
| vpapt_access_panel_ou | numeric(10) | NULL | Access Panel Ou | No | No |
| vpapt_open_ap_task | varchar(30) | NULL | Open Acess Panel Task | No | No |
| vpapt_close_ap_task | varchar(30) | NULL | Closed Acess Panel Task | No | No |
| vpapt_ap_status | varchar(5) | NULL | Acess Panel task staus like fresh, Active | No | No |
| Table Name vpkg_vpdflt_deferral_limit | |||||
| Table Comment Deferral Limits for the work units in the Deferral request is maintained here. Deferral limit is a mandatory information in case of finite deferrals. | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpdflt_deferred_by | numeric(28) | NULL | Deferred By Value for the Parameter | No | No |
| vpdflt_param_code | varchar(40) | NOT NULL | Parameter Code | Yes | No |
| vpdflt_Seqno | numeric(10) | NOT NULL | Sequence Number | Yes | No |
| vpdflt_alert_value | numeric(28) | NULL | Alert Value for the Parameter | No | No |
| vpdflt_deftilldt | datetime | NULL | Deferred Till Date | No | No |
| VPDFLT_ALERT_DATE | datetime | NULL | Alert Date | No | No |
| vpdflt_def_req_no | varchar(40) | NOT NULL | Deferral Request Number | Yes | Yes |
| vpdflt_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| VPDFWU_SEQNO | int | NOT NULL | Yes | Yes | |
| vpdflt_work_unit | varchar(30) | NOT NULL | Work Unit - | Yes | Yes |
| vpdflt_wu_type | varchar(5) | NOT NULL | Work Unit Type - Can be Task or Standard Work Package or Standard Procedure | Yes | Yes |
| Table Name vpkg_vpdfrq_deferral_req | |||||
| Table Comment Deferral requests are maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpdfrq_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | No |
| vpdfrq_def_req_no | varchar(40) | NOT NULL | Deferral Request Number | Yes | No |
| vpdfrq_visit_pkg_no | varchar(40) | NULL | Visit Package Number | No | No |
| vpdfrq_rev_no | varchar(40) | NULL | No | No | |
| vpdfrq_num_type_no | varchar(5) | NULL | Numbering Type Number | No | No |
| vpdfrq_work_centre | varchar(30) | NULL | Work Centre | No | No |
| vpdfrq_status | varchar(5) | NULL | Status of the Deferral.Can be in Draft or Approved or Rejected | No | No |
| vpdfrq_emp_code | varchar(15) | NULL | Employee who has requested the deferral | No | No |
| vpdfrq_email | varchar(70) | NULL | E-mail id of the employee | No | No |
| vpdfrq_phone_no | varchar(70) | NULL | Phone No of the Employee | No | No |
| vpdfrq_created_by | varchar(30) | NULL | Created By | No | No |
| vpdfrq_createddate | datetime | NULL | Created Date | No | No |
| vpdfrq_modified_by | varchar(30) | NULL | Last Modified By | No | No |
| vpdfrq_modifieddate | datetime | NULL | Last Modified Date | No | No |
| vpdfrq_timestamp | numeric(10) | NULL | Timestamp | No | No |
| vpdfrq_job_type | varchar(5) | NULL | Job Type | No | No |
| vpdfrq_aircraft_reg_no | varchar(30) | NULL | Aircraft Registration Number | No | No |
| vpdfrq_component_id | varchar(90) | NULL | Component Id | No | No |
| vpdfrq_dockey | varchar(128) | NULL | Document key for workflow (combination of Deferment Request No + OUInstance) | No | No |
| vpdfrq_stage | varchar(25) | NULL | Current state of the document | No | No |
| Table Name vpkg_vpdfwu_def_work_unit | |||||
| Table Comment The list of work units in the deferral request | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpdfwu_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpdfwu_def_req_no | varchar(40) | NOT NULL | Deferral Request Number | Yes | Yes |
| vpdfwu_work_unit | varchar(30) | NOT NULL | Work Unit | Yes | No |
| vpdfwu_seqno | numeric(10) | NOT NULL | Yes | No | |
| vpdfwu_wu_type | varchar(5) | NOT NULL | Work Unit Type - Can be Task or a Standard procedure or a Standard Work Package | Yes | No |
| vpdfwu_wu_ou | numeric(10) | NULL | Ouinstance | No | No |
| vpdfwu_wu_rev_no | varchar(40) | NULL | wu revison number | No | No |
| vpdfwu_keyseqno | numeric(10) | NULL | Key Sequence Number | No | No |
| vpdfwu_PosCode | varchar(25) | NULL | Position Code | No | No |
| vpdfwu_serialno | varchar(40) | NULL | Serial Number | No | No |
| vpdfwu_partNo | varchar(40) | NULL | Part Number | No | No |
| vpdfwu_appcomments | varchar(255) | NULL | Approval Comments | No | No |
| vpdfwu_maintenence_type | varchar(5) | NULL | Maintenance Type | No | No |
| vpdfwu_deferral_reason | varchar(25) | NULL | Reason for the Deferral | No | No |
| vpdfwu_deferral_type | varchar(5) | NULL | Deferral Type - Can be Indefinite , Usage based , date based or usage and date based | No | No |
| vpdfwu_schdate | datetime | NULL | Schedule Date | No | No |
| vpdfwu_remarks | varchar(255) | NULL | Remarks if any | No | No |
| vpdfwu_action | varchar(5) | NULL | Action | No | No |
| vpdfwu_approval_no | varchar(30) | NULL | Approval Number | No | No |
| vpdfwu_reg_authority | varchar(25) | NULL | Regulatory Authority | No | No |
| vpdfwu_approveddate | datetime | NULL | Approval Date | No | No |
| vpdfwu_defered_till_date | int | NULL | Deferred Till Date | No | No |
| vpdfwu_deferred_by_in_days | numeric(28) | NULL | Number of days by which the work unit is deferred | No | No |
| vpdfwu_alert_value | numeric(28) | NULL | Alert Value | No | No |
| vpdfwu_source | varchar(25) | NULL | Source | No | No |
| vpdfwu_src_doc_ou | numeric(10) | NULL | source ou | No | No |
| vpdfwu_src_doc_no | varchar(40) | NULL | Source document no | No | No |
| vpdfwu_src_doc_rev_no | varchar(40) | NULL | source doc revion no | No | No |
| vpdfwu_wu_seq_no | numeric(10) | NULL | Source SeqNo | No | No |
| vpdfwu_deferred_till_date | datetime | NULL | Deferred till date | No | No |
| vpdfwu_job_type | varchar(20) | NULL | Job Type | No | No |
| vpdfwu_deferred_alert_date | datetime | NULL | Deferred alert date | No | No |
| Table Name vpkg_vpfin_finance_info | |||||
| Table Comment This table holds the information required for financial postings | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| Vpfin_maint_Loss_Acc_Code | varchar(32) | NULL | Maintenance Loss Account Code | No | No |
| Vpfin_adj_Sub_anal_code | varchar(5) | NULL | Adjustment account sub analysis code | No | No |
| Vpfin_maint_loss_CntAc_Type | varchar(40) | NULL | Maintenance Loss Control Account Type | No | No |
| Vpfin_maint_loss_aptacc_Type | varchar(40) | NULL | Maintenance Loss  auto posting Account type | No | No |
| Vpfin_adj_CntAc_Type | varchar(40) | NULL | Control Account type of the Adjustment account code | No | No |
| Vpfin_adj_anal_Code | varchar(5) | NULL | Adjustment account analysis code | No | No |
| Vpfin_adj_apacc_Type | varchar(40) | NULL | Auto posting account type of the Adjustment account code | No | No |
| Vpfin_adj_acc_curr | varchar(5) | NULL | Adjustment account code currency | No | No |
| vpfin_adj_Acc_Code | varchar(32) | NULL | Adjustment account code | No | No |
| Vpfin_WIPSusp_anal_Code | varchar(5) | NULL | No | No | |
| Vpfin_WIPSusp_aptacc_Type | varchar(40) | NULL | No | No | |
| Vpfin_WIPSusp_Sub_anal_code | varchar(5) | NULL | No | No | |
| Vpfin_maint_loss_acc_curr | varchar(5) | NULL | No | No | |
| VPfin_maint_loss_anal_Code | varchar(5) | NULL | No | No | |
| Vpfin_WIPSusp_CntAc_Type | varchar(40) | NULL | No | No | |
| VPfin_maint_loss_Sub_anal_code | varchar(5) | NULL | No | No | |
| Vpfin_WIPSusp_acc_Code | varchar(32) | NULL | No | No | |
| Vpfin_WIPSusp_acc_curr | varchar(5) | NULL | No | No | |
| vpfin_bu_code | varchar(20) | NULL | Business Unit | No | No |
| vpfin_tran_type | varchar(25) | NULL | Transaction Type | No | No |
| vpfin_company_code | varchar(40) | NULL | Company code | No | No |
| Vpfin_erate_type | varchar(80) | NULL | exchange rate | No | No |
| vpfin_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpfin_fin_book_id | varchar(20) | NULL | Finance Book Id | No | No |
| vpfin_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vpfin_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| vpfin_con_cosr_acc_curr | varchar(5) | NULL | account currency  of the Consumption or the COSR account | No | No |
| vpfin_con_cosr_analy_Code | varchar(5) | NULL | Analysis code  of the Consumption or the COSR account | No | No |
| vpfin_con_cosr_aptacc_type | varchar(40) | NULL | Auto Posting account type of the Consumption or the COSR account | No | No |
| vpfin_con_cosr_sub_anal_code | varchar(5) | NULL | Sub analysis code  of the Consumption or the COSR account | No | No |
| vpfin_parallel_base_Erate | numeric(10) | NULL | parallel base currency exchange rate | No | No |
| vpfin_Base_currency | varchar(5) | NULL | base currency | No | No |
| vpfin_con_Cosr_CntAcc_Type | varchar(40) | NULL | Control Account Type of the Consumption or the COSR account | No | No |
| vpfin_parallel_Base_currency | varchar(5) | NULL | Parallel base currency | No | No |
| vpfin_Con_cosr_Acc_Code | varchar(32) | NULL | This account code can be a consumption account or COSR account ( Cost of the services rendered) | No | No |
| Table Name vpkg_vplog_vp_status_log | |||||
| Table Comment Status Log of the Visit Package | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vplog_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| vplog_visit_pkg_no | varchar(40) | NOT NULL | Visit Package Number | Yes | No |
| vplog_rev_no | varchar(40) | NOT NULL | Revision Number | Yes | No |
| vplog_changeddate | datetime | NOT NULL | Date on which the status was modified | Yes | No |
| vplog_doc_status | varchar(5) | NOT NULL | Status | No | No |
| vplog_approval_status | varchar(5) | NULL | No | No | |
| vplog_changed_by | varchar(30) | NULL | Changed By | No | No |
| vplog_remarks | varchar(255) | NULL | Remarks | No | No |
| Table Name vpkg_vpopt_options_set | |||||
| Table Comment Option Setting  for Visit Package Component is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpopt_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| vpopt_vp_app_req_flag | varchar(25) | NULL | Approval Required Flag - This flag indicates if approval is required for the Visit Package | No | No |
| vpopt_def_auth_by_flag | sql_variant | NULL | Deferral Authorization Flag - | No | No |
| vpopt_no_type_sch_vp_flag | varchar(25) | NULL | flag | No | No |
| vpopt_wc_hierarchy_flag | varchar(25) | NULL | Work Centre Hierarchy Flag - Yes and No are valid values | No | No |
| vpopt_auto_mr_gen_flag | varchar(25) | NULL | Automatic Material Request Generation Flag - Valid values are ’Yes’ and ’No’ | No | No |
| vpopt_wo_status_on_rel_flag | varchar(25) | NULL | Status of the Work Order when it is released from Visit Package - Can be Fresh or Scheduled | No | No |
| vpopt_createddate | datetime | NOT NULL | Created Date | No | No |
| vpopt_created_by | varchar(30) | NOT NULL | Created By | No | No |
| vpopt_modifieddate | datetime | NULL | Last Modified date | No | No |
| vpopt_modified_by | varchar(30) | NULL | Last Modified By | No | No |
| vpopt_timestamp | numeric(10) | NOT NULL | Timestamp | No | No |
| Table Name vpkg_vpprt_visit_level_part | |||||
| Table Comment Visit Level Material Requirements | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpprt_wh_code | varchar(10) | NULL | Warehouse Code | No | No |
| vpprt_wh_ou | numeric(10) | NULL | Warehouse Ouinstance | No | No |
| vpprt_process_flag | varchar(5) | NULL | Process flag | No | No |
| vpprt_qty_in_stkuom | numeric(28) | NULL | Quantity in Stock UOM | No | No |
| vpprt_substitute_partou | int | NULL | Substitute Part OUInstance | No | No |
| vpprt_consum_mode | varchar(25) | NULL | Consumption Mode ’REG’ - Regular ’BFL’ - Backflashable | No | No |
| vpprt_substitute_partno | varchar(40) | NULL | Substitute PartNo if entered | No | No |
| vpprt_substitute_type | varchar(6) | NULL | Substitute Type values ’Not Allowed’ "NA", ’NHA’ "NHA" ’Specific Alternates’ "SA" | No | No |
| vpprt_stock_status | varchar(40) | NULL | Part Stock Status | No | No |
| vpprt_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vpprt_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| vpprt_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpprt_uom | varchar(25) | NULL | Unit of measure | No | No |
| vpprt_part_ou | numeric(10) | NULL | Part Ouinstance | No | No |
| vpprt_part_no | varchar(40) | NOT NULL | Part Number | Yes | No |
| vpprt_ear_required_date | datetime | NULL | Earliest Required Date | No | No |
| vpprt_required_qty | numeric(28) | NULL | Required Quantity | No | No |
| Table Name vpkg_vpres_visit_level_res | |||||
| Table Comment Visit package resource usage details | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpres_time_uom | varchar(30) | NULL | Time UOM | No | No |
| vpres_resource_type | varchar(25) | NOT NULL | Resource Type - Skills,Tools,Equipment or Others" | Yes | No |
| vpres_estimated_nos | numeric(28) | NULL | Estimated Numbers of the resource | No | No |
| vpres_estimated_time | numeric(28,8) | NULL | Estimated time of the resource | No | No |
| vpres_res_ou | numeric(10) | NULL | resource ou | No | No |
| vpres_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpres_resource | varchar(40) | NOT NULL | Resource | Yes | No |
| vpres_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vpres_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| Table Name vpkg_vpsrch_search_id_master | |||||
| Table Comment User can create customized search option. | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpsrch_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| vpsrch_search_id | varchar(30) | NOT NULL | Search Id. | Yes | No |
| vpsrch_user_id | varchar(30) | NOT NULL | User Id who has created the search id | Yes | No |
| vpsrch_ata_no | varchar(16) | NULL | ATA Number | No | No |
| vpsrch_zone_code | varchar(15) | NULL | Zone Code | No | No |
| vpsrch_component_family | varchar(25) | NULL | Component Family Code | No | No |
| vpsrch_componentid | varchar(90) | NULL | component Id | No | No |
| vpsrch_fcd_no | varchar(40) | NULL | FCD Number | No | No |
| vpsrch_eo_no | varchar(40) | NULL | EO Number | No | No |
| vpsrch_task_group | varchar(25) | NULL | Task Group - Quick Codes defined in Visit Package component | No | No |
| vpsrch_plan_item_group | varchar(25) | NULL | Plan Item Group - User defined quick code | No | No |
| vpsrch_status | varchar(5) | NOT NULL | Status | No | No |
| vpsrch_createddate | datetime | NOT NULL | Created Date | No | No |
| vpsrch_timestamp | numeric(10) | NOT NULL | Timestamp | No | No |
| vpsrch_cust_code | varchar(45) | NULL | Customer Code | No | No |
| vpsrch_cust_name | varchar(80) | NULL | Customer Name | No | No |
| Table Name vpkg_vptrs_visit_wu_res | |||||
| Table Comment Resource list of the work units in the Visit Package | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vptrs_estimated_nos | numeric(28) | NULL | Number of the resources required | No | No |
| vptrs_time_unit | varchar(25) | NULL | Time Unit - Minutes , Hours or Days | No | No |
| vptrs_wu_type | varchar(25) | NOT NULL | Work Unit Type - Standard Procedure or Standard Task and Standard work package | Yes | No |
| vptrs_sign_off_req_flag | varchar(25) | NULL | Sign off required flag - ’Yes ’ or ’No’ | No | No |
| vptrs_estimated_time | numeric(28,8) | NULL | Estimated Time of the Resource | No | No |
| vptrs_app_req_flag | varchar(25) | NULL | Approval Required Flag | No | No |
| vptrs_res_ou | numeric(10) | NULL | Resource Ouinstance | No | No |
| vptrs_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vptrs_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| vptrs_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vptrs_work_unit | varchar(30) | NOT NULL | Work units | Yes | Yes |
| vptrs_resource_type | varchar(25) | NOT NULL | Resource Type - "Skills,Tools,Equipment  orOthers" | Yes | No |
| vptrs_seq_no | numeric(10) | NOT NULL | Sequence number | Yes | Yes |
| vptrs_resource | varchar(40) | NOT NULL | Resource | Yes | No |
| Table Name vpkg_vpwoop_wo_gen_option | |||||
| Table Comment Rules to generate workorder for a Visit Package | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpwoop_ouinstance | numeric(10) | NOT NULL | Ouinstance | Yes | No |
| vpwoop_wo_gen_flag | varchar(25) | NULL | Work order Generation Flag - Indicates that if WO needs to be generated for each task or for a group of tasks | No | No |
| vpwoop_ata_flag | varchar(25) | NULL | ATA Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated ATA wise | No | No |
| vpwoop_skill_flag | varchar(25) | NULL | Skill Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated Skill wise | No | No |
| vpwoop_dsc_flag | varchar(25) | NULL | DSC Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated DSC wise | No | No |
| vpwoop_zone_flag | varchar(25) | NULL | ZONE Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated ZONE  wise | No | No |
| vpwoop_tsk_grp_flag | varchar(25) | NULL | Task Group Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated Task Group  wise | No | No |
| vpwoop_plan_item_grp_flag | varchar(25) | NULL | Plan Item Group  Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generatedPlan Item Group  wise | No | No |
| vpwoop_work_area_flag | varchar(25) | NULL | Work Area Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated Work Area  wise | No | No |
| vpwoop_task_type_flag | varchar(25) | NULL | Task Type  Wise - Valid values are ’Yes’ and ’No’. Yes indicates that WOs need to be generated Task Type wise | No | No |
| vpwoop_modifieddate | datetime | NULL | Last Modified Date | No | No |
| vpwoop_modifiedby | varchar(30) | NULL | Last Modified By | No | No |
| Table Name vpkg_vpwu_vp_work_units | |||||
| Table Comment List of work units in the Visit Package | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpwu_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpwu_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vpwu_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| vpwu_seq_no | numeric(10) | NOT NULL | sequence number | Yes | No |
| vpwu_pos_no | numeric(10) | NULL | position number | No | No |
| vpwu_wu_seq_no | numeric(10) | NULL | Work unit sequence number | No | No |
| vpwu_work_unit | varchar(30) | NULL | Work unit - Task or SP or SWP or Access Panel | No | No |
| vpwu_wu_rev_no | varchar(40) | NULL | Revision number of the task | No | No |
| vpwu_wu_type | varchar(5) | NULL | Task or SP or SWP or Access Panel | No | No |
| vpwu_wu_ou | numeric(10) | NULL | Work unit OU | No | No |
| vpwu_wc_code | varchar(30) | NULL | work centre code | No | No |
| vpwu_wu_desc | varchar(150) | NULL | work unit desc - will be available if the work unit is a non routine task | No | No |
| vpwu_part_no | varchar(40) | NULL | part number | No | No |
| vpwu_serial_no | NULL | serial number of the part | No | No | |
| vpwu_position_code | varchar(25) | NULL | Position Code - Position where the component is placed | No | No |
| vpwu_component_id | varchar(90) | NULL | Component Id - Mandatory if the job is removal or a on wing job | No | No |
| vpwu_time_unit | varchar(5) | NULL | Tiem Unit - Can be Minutes, Hours or Days | No | No |
| vpwu_maintenance_type | varchar(5) | NULL | Maintenancen Type - Can be ’Overhaul’, ’Repair’, ’Inspection’ or ’Others’ | No | No |
| vpwu_est_elasped_time | numeric(28,8) | NULL | Estimated Elasped Time | No | No |
| vpwu_est_man_hrs | numeric(28,8) | NULL | Estimated Man hours | No | No |
| vpwu_est_elasped_time_in_min | numeric(28,8) | NULL | Estimated Elasped time in minutes | No | No |
| vpwu_plnd_start_date | datetime | NULL | Planned start date of the work unit | No | No |
| vpwu_plnd_end_date | datetime | NULL | Planned end date | No | No |
| vpwu_mandatory_flag | varchar(5) | NULL | Mandatory Flag - Valid values are Yes and No | No | No |
| vpwu_priority | numeric(10) | NULL | priority | No | No |
| vpwu_source | varchar(25) | NULL | Source - Can be Forecast or EO or FCD or Component Forecast, Descrepancy | No | No |
| vpwu_src_doc_ou | numeric(10) | NULL | Source doc ouinstance | No | No |
| vpwu_src_doc_no | varchar(40) | NULL | Document number of the source. Can be a forecast number or an EO number or a FCD number | No | No |
| vpwu_src_doc_rev_no | varchar(40) | NULL | No | No | |
| vpwu_wu_status | varchar(5) | NULL | Can be Precluded or None | No | No |
| vpwu_precluded_wu | varchar(30) | NULL | Precluded Work Unit | No | No |
| vpwu_precluded_wu_seq_no | numeric(10) | NULL | Precluded Work unit Seq No. | No | No |
| vpwu_sp_seq_no | numeric(10) | NULL | SP sequence number | No | No |
| vpwu_std_proc_no | varchar(30) | NULL | Standard Procedure | No | No |
| vpwu_task_seq_no | numeric(10) | NULL | Task sequence number | No | No |
| vpwu_task_code | varchar(30) | NULL | Task Code | No | No |
| vpwu_swp_seq_no | numeric(10) | NULL | SWP sequence number | No | No |
| vpwu_swp_code | varchar(30) | NULL | Standard Work Package | No | No |
| vpwu_priority_ou | numeric(10) | NULL | Priority OU | No | No |
| vpwu_job_type | varchar(5) | NULL | Job Type - "Aircraft","On-Wing"  or ’Component Removal" | No | No |
| vpwu_ata_no | varchar(16) | NULL | ATA Number | No | No |
| vpwu_zone_code | varchar(15) | NULL | Zone code | No | No |
| vpwu_access_panel | varchar(30) | NULL | Access Panel | No | No |
| vpwu_task_group | varchar(25) | NULL | Task Group - Quick Codes defined as Task Group in Visit Package Quick Code Master | No | No |
| vpwu_plan_item_group | varchar(25) | NULL | Plan Item Group - Quick Codes defined as Plan Item  Group in Visit Package Quick Code Master | No | No |
| vpwu_work_order_no | varchar(40) | NULL | No | No | |
| vpwu_src_seqno | numeric(10) | NULL | source sequence number | No | No |
| vpwu_superceded_wu_seq_no | NULL | Work Unit code of the precluded work unit | No | No | |
| vpwu_LevelCode | varchar(150) | NULL | level code | No | No |
| vpwu_component_ou | numeric(10) | NULL | component ouinstance | No | No |
| vpwu_approval_status | varchar(5) | NULL | Approval Status - When the visit package is created based on a customer order, unplanned work units will require approval from customer. This flag will have teh approval status of those work units. | No | No |
| vpwu_model_no | varchar(20) | NULL | Model # for the Aircraft Reg No | No | No |
| vpwu_model_ou | numeric(10) | NULL | Model OUInstance for the Model # | No | No |
| vpwu_refdoc_no | varchar(40) | NULL | Reference Document number if Visit package is created from Customer | No | No |
| vpwu_refdoc_type | varchar(5) | NULL | Reference Document type if Visit package is created from Customer | No | No |
| vpwu_reptype | varchar(5) | NULL | Replacement Type REP - ’Replacement’ RES - ’Restoration’ | No | No |
| vpwu_incomeser_no | varchar(40) | NULL | Incomming Serial Number for Replacement Type "Replacement" | No | No |
| vpwu_incomepart_no | varchar(40) | NULL | Incomming Part Number for Replacement Type "Replacement" | No | No |
| VPWU_EXPENSE_TYPE | varchar(5) | NOT NULL | Expense Type | No | No |
| VPWU_CAPEX_PROPNO | varchar(40) | NULL | Capital Expense Proposal Number | No | No |
| VPWU_PLAN_STATUS | varchar(5) | NULL | Plan Status | No | No |
| VPWU_CUSTORDER_SEQNO | int | NULL | Customer Order Sequence No. | No | No |
| VPWU_COWU_LINE_NO | int | NULL | Customer Order Workunit Line No. | No | No |
| VPWU_WU_JOBID | int | NULL | No | No | |
| Table Name vpkg_vpwupt_visit_wu_part | |||||
| Table Comment Part requirement list defined for the work units in the visit package | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpwupt_wh_code | varchar(10) | NULL | Warehouse code | No | No |
| vpwupt_wh_ou | numeric(10) | NULL | Ouinstance | No | No |
| vpwupt_process_flag | varchar(5) | NULL | process flag | No | No |
| vpwupt_reqqty_in_stkuom | numeric(28) | NULL | Required Quantity in Stock Uom | No | No |
| vpwupt_estimated_qty | numeric(28) | NULL | Estimated quantity for the work unit | No | No |
| vpwupt_substitute_partou | int | NULL | Substitute Part OUInstance | No | No |
| vpwupt_consum_mode | varchar(25) | NULL | Consumption Mode ’REG’ - Regular ’BFL’ - Backflashable | No | No |
| vpwupt_substitute_partno | varchar(40) | NULL | Substitute Part No | No | No |
| vpwupt_substitute_type | varchar(6) | NULL | Substitute Type values ’Not Allowed’ "NA", ’NHA’ "NHA" ’Specific Alternates’ "SA" | No | No |
| vpwupt_stock_status | varchar(20) | NULL | Part Stock Status | No | No |
| vpwupt_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| vpwupt_seq_no | numeric(10) | NOT NULL | Sequence Number | Yes | Yes |
| vpwupt_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vpwupt_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpwupt_required_qty | numeric(28) | NULL | Required Quantity | No | No |
| vpwupt_part_ou | numeric(10) | NULL | Part OUInstance | No | No |
| vpwupt_uom | varchar(25) | NULL | Uom of the Part | No | No |
| vpwupt_part_no | varchar(40) | NOT NULL | Part Number | Yes | No |
| vpwupt_wu_type | varchar(25) | NOT NULL | Work Unit Type - Can be Task or Access Panel Task or Standard Procedure or Standard Work Package | Yes | No |
| vpwupt_work_unit | varchar(30) | NOT NULL | Work Unit | Yes | No |
| Table Name vpkg_vpwurl_wu_relationship | |||||
| Table Comment Relationship between the work units is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vpwurl_dep_wu | varchar(30) | NULL | dependent work unit | No | No |
| vpwurl_wu_type | varchar(5) | NULL | Work Unit type - can be task or standard procedure or standard work package | No | No |
| vpwurl_work_unit | varchar(30) | NULL | Work Unit | No | No |
| vpwurl_lag_time | numeric(28,8) | NULL | Lag time between the primary work unit and the dependent work unit | No | No |
| vpwurl_time_uom | varchar(5) | NULL | UOM of the lag time | No | No |
| vpwurl_relationship_type | varchar(5) | NULL | Relationship type-Start - Start, Start - Finish , Finish - start and Finish - Finish | No | No |
| vpwurl_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | Yes |
| vpwurl_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | Yes |
| vpwurl_dep_seqno | numeric(10) | NOT NULL | dependent workunit sequence no | Yes | No |
| vpwurl_primary_seq_no | numeric(10) | NOT NULL | Primary seq no | Yes | No |
| vpwurl_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | Yes |
| vpwurl_key_seq_no | numeric(10) | NOT NULL | Sequence number of the work unit | Yes | Yes |
| Table Name vpkg_vstpkg_visit_package | |||||
| Table Comment Visit Package Header | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| vstpkg_ouinstance | numeric(10) | NOT NULL | OUinstance | Yes | No |
| vstpkg_visit_pkg_no | varchar(40) | NOT NULL | Visit Package number | Yes | No |
| vstpkg_rev_no | varchar(40) | NOT NULL | Revision Number of the Visit Package | Yes | No |
| vstpkg_title | varchar(150) | NULL | visit package title | No | No |
| vstpkg_num_type_no | varchar(5) | NULL | Numbering type used | No | No |
| vstpkg_emp_ou | numeric(10) | NULL | employee Ouinstance | No | No |
| vstpkg_ac_ou | numeric(10) | NULL | Aircraft ouinstance | No | No |
| vstpkg_aircraft_reg_no | varchar(30) | NULL | Aircraft Registration Number | No | No |
| vstpkg_vp_type | varchar(5) | NULL | Planned if created from CP , UNplanned if created by the Visit Planner | No | No |
| vstpkg_user_status | varchar(25) | NULL | User status | No | No |
| vstpkg_project_code | varchar(30) | NULL | Project code | No | No |
| vstpkg_project_file | varchar(50) | NULL | Project file number | No | No |
| vstpkg_visit_group | varchar(25) | NULL | visit package group | No | No |
| vstpkg_visit_category | varchar(25) | NULL | visit package category | No | No |
| vstpkg_groundingdate | datetime | NULL | Grounding Date of the Aircraft | No | No |
| vstpkg_priority_ou | numeric(10) | NULL | priority ouinstance | No | No |
| vstpkg_primary_wc_code | varchar(30) | NULL | Primary Work Center | No | No |
| vstpkg_emp_code | varchar(15) | NULL | Employee Code | No | No |
| vstpkg_priority | numeric(10) | NULL | Priority | No | No |
| vstpkg_elasped_time_uom | varchar(5) | NULL | Elasped Time Uom - Can be Hours or minutes or days | No | No |
| vstpkg_est_elasped_time | numeric(28,8) | NULL | Estimated Elasped Time | No | No |
| vstpkg_elasped_time_in_min | numeric(28,8) | NULL | Elasped Tiem in minutes | No | No |
| vstpkg_est_man_hrs | numeric(28,8) | NULL | Estimated Man Hours | No | No |
| vstpkg_plnd_start_date | datetime | NULL | Planned Start Date | No | No |
| vstpkg_plnd_end_date | datetime | NULL | Planned End | No | No |
| vstpkg_projecteddate | datetime | NULL | Projected  End  Date | No | No |
| vstpkg_status | varchar(5) | NULL | Status | No | No |
| vstpkg_misc_cost | numeric(28,8) | NULL | Miscelleneous Cost for the Visit Package | No | No |
| vstpkg_labor_cost | numeric(28,8) | NULL | Labor Cost | No | No |
| vstpkg_material_cost | numeric(28,8) | NULL | Material Cost - This cost is the sum of the work unit level material cost and visit level material  cost | No | No |
| vstpkg_facilities_cost | numeric(28,8) | NULL | Facilities Cost - Resource cost at the work unit and visit level | No | No |
| vstpkg_total_cost | numeric(28,8) | NULL | Total cost | No | No |
| vstpkg_capital_cost | numeric(28,8) | NULL | Capital cost | No | No |
| vstpkg_comments | varchar(255) | NULL | Comments | No | No |
| vstpkg_com_flag | varchar(5) | NULL | certificate of maintenance flag | No | No |
| vstpkg_project_time_uom | varchar(5) | NULL | Project time uom. unit in which the entire visit package time will be estimated | No | No |
| vstpkg_created_by | varchar(30) | NULL | Created by | No | No |
| vstpkg_createddate | datetime | NULL | Created Date | No | No |
| vstpkg_modified_by | varchar(30) | NULL | Modified By | No | No |
| vstpkg_modifieddate | datetime | NULL | Modified Date | No | No |
| vstpkg_approved_by | varchar(30) | NULL | Approved By | No | No |
| vstpkg_approveddate | datetime | NULL | Approved Date | No | No |
| vstpkg_timestamp | numeric(10) | NULL | Timestamp | No | No |
| vstpkg_execution_unit | numeric(10) | NULL | OU where the Visit package will be executed | No | No |
| vstpkg_approval_status | varchar(5) | NULL | Approval Status | No | No |
| vstpkg_approval_comments | varchar(255) | NULL | Approval Comments | No | No |
| vstpkg_releaseddate | datetime | NULL | Released Date of the Visit Package | No | No |
| vstpkg_released_by | varchar(30) | NULL | Released By | No | No |
| vstpkg_title_up | varchar(150) | NULL | Title in upper case | No | No |
| vstpkg_station_code | varchar(32) | NULL | Station Code | No | No |
| vstpkg_cust_ou | numeric(10) | NULL | customer ouinstance | No | No |
| vstpkg_cust_code | varchar(18) | NULL | customer code | No | No |
| vstpkg_cust_order_no | varchar(40) | NULL | customer order number | No | No |
| vstpkg_cust_order_ou | numeric(10) | NULL | Customer Order OU | No | No |
| vstpkg_ac_release_date | datetime | NULL | Aicraft release date | No | No |
| vstpkg_closed_by | varchar(30) | NULL | Visit Package Closed by userid | No | No |
| vstpkg_closed_date | datetime | NULL | Visit Package Closed date | No | No |
| vstpkg_preperatory_time | numeric(28,8) | NULL | Preperatory time fetched from Maintenance Program | No | No |
| vstpkg_maintevent | varchar(30) | NULL | Maintenance Event | No | No |
| vstpkg_doc_key | varchar(128) | NULL | Document key for workflow (combination of Visit Package No + OUInstance) | No | No |
| vstpkg_stage | varchar(25) | NULL | Current state of the document | No | No |
| vstpkg_closing_comments | varchar(255) | NULL | Visit Package Closing comments | No | No |
| vstpkg_closing_filename | varchar(50) | NULL | At the time of closing the Visit Package User can enter additional filename | No | No |
| VSTPKG_EXPENSE_TYPE | varchar(5) | NOT NULL | Expense type,E.g Revenue, Capital | No | No |
| VSTPKG_CAPEX_PROPNO | varchar(40) | NULL | Capital Expense Poposal Number | No | No |
| VSTPKG_SLOTNO | varchar(20) | NULL | No | No | |
| VSTPKG_SLOT_StDate | datetime | NULL | No | No | |
| VSTPKG_SLOT_EnDate | datetime | NULL | No | No | |