Data Dictionary - Visit Package |
|||||
|
|
|||||
|
Table Name VP_VPWUAP_VPWU_AP_TASK |
|
||||
|
|
|||||
|
Table Comment This Table maintains Access Panel Tasks for the Access 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 |
Scheduled 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 |
Access 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 Visti package is applicable |
No |
No |
|
VPAME_USER_STATUS |
varchar(25) |
NULL |
User defined status of the visit package |
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 |
Timestamp is the number which will indicate the no of times the record is modified |
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 Revision 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 Access Panel Task |
No |
No |
|
vpapt_close_ap_task |
varchar(30) |
NULL |
Closed Access Panel Task |
No |
No |
|
vpapt_ap_status |
varchar(5) |
NULL |
Access Panel task status 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 revision 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 revision 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 or Others" |
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 generated 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 |
Time Unit - Can be Minutes, Hours or Days |
No |
No |
|
vpwu_maintenance_type |
varchar(5) |
NULL |
Maintenance Type - Can be ’Overhaul’, ’Repair’, ’Inspection’ or ’Others’ |
No |
No |
|
vpwu_est_elasped_time |
numeric(28,8) |
NULL |
Estimated Elapsed 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 Elapsed 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, Discrepancy |
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 |
Incoming Serial Number for Replacement Type "Replacement" |
No |
No |
|
vpwu_incomepart_no |
varchar(40) |
NULL |
Incoming 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 |
Elapsed Time Uom - Can be Hours or minutes or days |
No |
No |
|
vstpkg_est_elasped_time |
numeric(28,8) |
NULL |
Estimated Elapsed Time |
No |
No |
|
vstpkg_elasped_time_in_min |
numeric(28,8) |
NULL |
Elapsed Time 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 |
Miscellaneous 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 |
Aircraft 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 |
Preparatory 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,Ex. Revenue, Capital |
No |
No |
|
VSTPKG_CAPEX_PROPNO |
varchar(40) |
NULL |
Capital Expense Proposal Number |
No |
No |
|
VSTPKG_SLOTNO |
varchar(20) |
NULL |
|
No |
No |
|
VSTPKG_SLOT_StDate |
datetime |
NULL |
|
No |
No |
|
VSTPKG_SLOT_EnDate |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
|
|