|
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
CapPlan_CPOpt_SetOption |
|
CPOpt_OUInstance |
varchar(20) |
NULL |
|
No |
No |
|
|
|
CPOpt_ShortTerm_Days |
numeric |
|
|
|
|
|
|
|
CPOpt_MediumTerm_Days |
|
|
|
|
|
|
|
|
CPOpt_LongTerm_Days |
|
|
|
|
|
|
|
|
CPOpt_OvertimeHrsAlwd |
|
|
|
|
|
|
|
|
CPOpt_AlternateInfo |
varchar(3) |
|
|
|
|
|
|
|
CPOpt_AltStkStatus |
|
|
|
|
|
|
|
|
CPOpt_AltWhouse |
|
|
|
|
|
|
|
|
CPOpt_Purchase |
|
|
|
|
|
|
|
|
CPOpt_Created_By |
varchar(30) |
|
|
|
|
|
|
|
CPOpt_Created_Date |
datetime |
|
|
|
|
|
|
|
CPOpt_Modified_By |
varchar(30) |
|
|
|
|
|
|
|
CPOpt_Modified_Date |
datetime |
|
|
|
|
|
|
|
CPOpt_TimeStamp |
numeric |
|
|
|
|
|
Cp_cpd_cap_plan_det |
|
cpd_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
|
|
|
|
cpd_line_no |
int |
|
|
|
|
|
|
|
cpd_cust_order_no |
varchar(18) |
|
|
|
|
|
|
|
cpd_workunit_code |
varchar(30) |
|
|
|
|
|
|
|
cpd_task_code |
|
|
|
|
|
|
|
|
cpd_acreg_no |
|
NULL |
|
No |
|
|
|
|
cpd_component_id |
varchar(90) |
|
|
|
|
|
|
|
cpd_workunit_lineno |
int |
|
|
|
|
|
|
|
cpd_maint_type |
varchar(40) |
|
|
|
|
|
|
|
cpd_workunit_type |
|
|
|
|
|
|
|
|
cpd_work_center |
varchar(60) |
|
|
|
|
|
|
|
cpd_plan_start_dt |
datetime |
|
|
|
|
|
|
|
cpd_plan_end_dt |
|
|
|
|
|
|
|
|
cpd_task_revno |
varchar(40) |
|
|
|
|
|
|
|
cpd_std_procno |
varchar(18) |
|
|
|
|
|
|
|
cpd_workunit_status |
varchar(25) |
|
Work unit status: P - Pending A - Allocated |
|
|
|
|
|
cpd_execution_docno |
varchar(18) |
|
|
|
|
|
|
|
cpd_exec_doctype |
varchar(40) |
|
VP - Visit Package # WS - WorkScope # |
|
|
|
Cp_cph_cap_plan_hdr |
Capacity Planning Header - This table stores Planned Start/End dates at Order/Object level. |
cph_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
|
|
|
|
cph_line_no |
int |
|
|
|
|
|
|
|
cph_document_no |
varchar(18) |
NULL |
|
No |
|
|
|
|
cph_document_type |
varchar(40) |
|
|
|
|
|
|
|
cph_plan_start_dt |
datetime |
|
|
|
|
|
|
|
cph_plan_end_dt |
|
|
|
|
|
|
|
|
cph_work_center |
varchar(60) |
|
|
|
|
|
|
|
cph_cap_flag |
varchar(25) |
|
B - Bid type customer order P - Prospect type customer order CP - Capacity Planning performed AC - Aircraft Jobs allocated C - Component Jobs allocated |
|
|
|
|
|
cph_part_flag |
|
|
|
|
|
|
|
|
cph_resource_flag |
|
|
|
|
|
|
|
|
cph_fh_flag |
|
|
|
|
|
|
|
|
cph_mel_flag |
|
|
|
|
|
|
|
|
cph_eo_flag |
|
|
|
|
|
|
|
|
cph_comments |
varchar(255) |
|
|
|
|
|
Cp_crp_cap_resource_plan |
Resource Planning details. |
crp_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
|
|
|
|
crp_work_center |
varchar(60) |
|
|
|
|
|
|
|
crp_resource_id |
varchar(16) |
|
|
|
|
|
|
|
crp_resource_type |
varchar(5) |
|
|
|
|
|
|
|
crp_plan_date |
datetime |
|
|
|
|
|
|
|
crp_available_hrs |
numeric |
NULL |
|
No |
|
|
|
|
crp_planned_hrs |
|
|
|
|
|
|
|
|
crp_unplanned_hrs |
|
|
|
|
|
|
Cp_sopt_search_option |
|
sopt_ouinstance |
char(18) |
NOT NULL |
|
Yes |
|
|
|
|
sopt_planner_id |
|
|
|
|
|
|
|
|
sopt_planning_basis |
|
NULL |
|
No |
|
|
|
|
sopt_planning_horizon |
|
|
|
|
|
|
|
|
sopt_work_center |
|
|
|
|
|
|
|
|
sopt_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
|
|
|
|
sopt_planner_id |
|
|
|
|
|
|
|
|
sopt_planning_basis |
varchar(5) |
NULL |
|
No |
|
|
|
|
sopt_planning_horizon |
|
|
|
|
|
|
|
|
sopt_work_center |
varchar(60) |
|
|
|
|
|
|
|
sopt_ouinstance |
varchar(18) |
NOT NULL |
|
Yes |
|
|
|
|
sopt_planner_id |
|
|
|
|
|
|
|
|
sopt_planning_basis |
|
NULL |
|
No |
|
|
|
|
sopt_planning_horizon |
|
|
|
|
|
|
|
|
sopt_work_center |
|
|
|
|
|
|
E_6 |
|
|
|
|
|
|
|