|
comgt_cucrsp_dtl |
This table is used to store Customer Correspondence details for a customer order |
cucrsp_order_ou |
int |
NOT NULL |
order ou instance |
Yes |
No |
|
|
|
cucrsp_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
cucrsp_amend_no |
int |
|
amendment number |
|
|
|
|
|
cucrsp_refno |
|
|
Line number |
|
|
|
|
|
cucrsp_dateml |
date |
NULL |
Date |
No |
|
|
|
|
cucrsp_cusremrks |
varchar(255) |
|
customer remarks |
|
|
|
|
|
cucrsp_oprremrks |
|
|
Operator Remarks |
|
|
|
|
|
cucrsp_splinst |
|
|
Special Instructions |
|
|
|
|
|
cucrsp_contprson |
varchar(80) |
|
Contact person |
|
|
|
|
|
cucrsp_phone |
char(15) |
|
Contact Phone |
|
|
|
|
|
cucrsp_crscat |
varchar(5) |
|
Correspondence category |
|
|
|
|
|
cucrsp_crssts |
|
|
Correspondence Status |
|
|
|
|
|
cucrsp_reference |
char(255) |
|
Referrence |
|
|
|
|
|
cucrsp_attendby |
varchar(80) |
|
Attended By |
|
|
|
|
|
cucrsp_timestamp |
int |
|
Timestamp count |
|
|
|
|
|
cucrsp_created_by |
varchar(30) |
|
record created by |
|
|
|
|
|
cucrsp_created_date |
datetime |
|
record created Date |
|
|
|
|
|
cucrsp_modified_by |
varchar(30) |
|
record Modified by |
|
|
|
|
|
cucrsp_modified_date |
datetime |
|
record Modified Date |
|
|
| dbo |
comgt_parameter_details |
To store the parameter details of the customer order |
componentname |
varchar(20) |
NOT NULL |
component name |
Yes |
|
| |
|
|
paramcategory |
varchar(10) |
|
category |
|
|
| |
|
|
paramtype |
varchar(25) |
|
type |
|
|
| |
|
|
paramcode |
varchar(5) |
|
code |
|
|
| |
|
|
langid |
int |
|
languge id |
|
|
| |
|
|
paramdesc |
varchar(254) |
|
param description |
No |
|
| |
|
|
sortby |
int |
|
sort by |
|
|
| |
|
|
creationdate |
datetime |
|
creation date |
|
|
|
corm_ad_addlncharge_dtl |
This table is used to stored additional charge details for a customer order against the Release #. |
ad_billable_yn |
varchar(5) |
NULL |
billable y - yes
n - no |
|
|
|
|
|
ad_paytosupplier |
char(16) |
|
pay to supplier |
|
|
|
|
|
ad_currency |
varchar(20) |
|
currency |
|
|
|
|
|
ad_accounting_usage |
char(20) |
|
accounting usage |
|
|
|
|
|
ad_cost_center |
char(10) |
|
cost center |
|
|
|
|
|
ad_created_date |
datetime |
|
created date |
|
|
|
|
|
ad_modified_by |
varchar(30) |
|
modified by |
|
|
|
|
|
ad_remarks |
varchar(255) |
|
remarks |
|
|
|
|
|
ad_created_by |
varchar(30) |
|
created by |
|
|
|
|
|
ad_amount |
numeric(28,8) |
|
amount |
|
|
|
|
|
ad_modified_date |
datetime |
|
modified date |
|
|
|
|
|
ad_release_no |
int |
NOT NULL |
release number |
Yes |
Yes |
|
|
|
ad_lineno |
|
|
line number |
|
No |
|
|
|
ad_order_no |
varchar(40) |
|
order number |
|
Yes |
|
|
|
ad_order_ou |
int |
|
order ou instance |
|
|
|
|
|
ad_markup_factor |
bigint |
NULL |
mark up factor |
No |
No |
|
|
|
ad_amend_no |
int |
NOT NULL |
amendment number |
|
|
|
|
|
ad_tcd_Rate |
numeric(28,8) |
NULL |
tcd rate |
|
|
|
|
|
ad_tcd_ou |
int |
NOT NULL |
tcd ou instance |
Yes |
|
|
|
|
ad_tcd_variant_no |
varchar(25) |
|
tcd variant number |
|
|
|
|
|
ad_tcd_no |
|
|
tcd number |
|
|
|
corm_ibd_invbilling_dtl |
This table is used to Stored Billing Head Details for the Customer order. |
ibd_quoted_price |
numeric(28,8) |
NULL |
quoted price |
No |
|
|
|
|
ibd_actualcost |
|
|
actual cost |
|
|
|
|
|
ibd_actual_price |
numeric(19) |
|
actual price |
|
|
|
|
|
idb_invoiced_amount |
numeric(28,8) |
|
invoiced amount |
|
|
|
|
|
ibd_Amount |
numeric(19) |
|
amount |
|
|
|
|
|
ibd_order_no |
varchar(40) |
NOT NULL |
order number |
Yes |
Yes |
|
|
|
ibd_order_ou |
int |
|
order ou instance |
|
|
|
|
|
ibd_amend_no |
|
|
amendment number |
No |
No |
|
|
|
ibd_release_no |
|
|
release number |
Yes |
Yes |
|
|
|
ibd_billing_head |
char(15) |
|
billing head |
|
No |
|
corm_imd_invmat_dtl |
This table is used to store Part Invoice details against the Release ID for a Customer Order |
imd_actual_issuecost |
numeric(19) |
NULL |
actual issue code |
No |
|
|
|
|
imd_actual_unitprice |
|
|
actual unit price |
|
|
|
|
|
imd_billableqty |
numeric(28) |
|
billable quantity |
|
|
|
|
|
imd_consumedqty |
|
|
consumed quantity |
|
|
|
|
|
imd_partpricelist |
varchar(40) |
|
part price list number |
|
|
|
|
|
imd_bill_mat_price |
numeric(19) |
|
billable material price |
|
|
|
|
|
imd_amount_tobe |
|
|
amount to be |
|
|
|
|
|
imd_revisionno |
varchar(40) |
|
part price list revision number |
|
|
|
|
|
imd_order_no |
|
NOT NULL |
order number |
Yes |
Yes |
|
|
|
imd_release_no |
int |
|
release number |
|
|
|
|
|
imd_order_ou |
|
|
order ou instance |
|
|
|
|
|
imd_amend_no |
|
|
amendment number |
No |
No |
|
|
|
imd_part_no |
char(40) |
|
part number |
Yes |
|
|
|
|
imd_ref_line_no |
int |
|
reference line number |
|
Yes |
|
|
|
imd_part_ou |
|
|
part ou instance |
|
No |
|
|
|
imd_line_no |
|
|
Running line number for customer order and amendment number combination |
|
Yes |
|
corm_Invh_invoice_hdr |
This table is used to Store Header Level Information Like Release ID, Invoicing Comments,etc., for the Customer order. |
invh_order_ou |
|
|
order ou instance |
|
No |
|
|
|
invh_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
invh_release_no |
int |
|
release number |
|
|
|
|
|
invh_amend_no |
|
|
amendment number |
No |
|
|
|
|
invh_release_status |
varchar(5) |
|
release status |
|
|
|
|
|
invh_Invoice_stage |
|
NULL |
invoice stage |
|
|
|
|
|
invh_actnormal_hr |
numeric(28,8,) |
|
actual normal hour |
|
|
|
|
|
invh_actovertime_hr |
|
|
actual overtime hour |
|
|
|
|
|
invh_billnormal_hr |
|
|
billable normal hour |
|
|
|
|
|
invh_billovertime_hr |
|
|
billable overtime hour |
|
|
|
|
|
invh_invnormal_hr |
|
|
invoice normal hour |
|
|
|
|
|
invh_invovertime_hr |
|
|
invoice over time hour |
|
|
|
|
|
invh_invoicednormal_hr |
|
|
invoiced normal hour |
|
|
|
|
|
invh_invoicedot_hr |
|
|
invoiced overtime hour |
|
|
|
|
|
invh_comments |
varchar(255) |
|
comments |
|
|
|
|
|
invh_prt_invcomments |
|
|
part invoice comments |
|
|
|
|
|
invh_Invoicedby |
varchar(30) |
NOT NULL |
invoiced by |
|
|
|
|
|
invh_Invoiceddate |
datetime |
|
invoiced date |
|
|
|
|
|
invh_modifiedby |
varchar(30) |
NULL |
modified by |
|
|
|
|
|
invh_modifieddate |
datetime |
|
modified date |
|
|
|
|
|
invh_timestamp |
int |
|
time stamp |
|
|
|
|
|
invh_Exchange_Rate |
numeric(28,8) |
|
exchange rate |
|
|
|
|
|
invh_confirmed_date |
datetime |
|
confirmed date |
|
|
|
|
|
invh_confirmed_by |
varchar(30) |
|
confirmed by |
|
|
|
|
|
invh_rep_comments |
varchar(255) |
|
reprocessing comments |
|
|
|
corm_ird_inv_repord_dtl |
This table is used to stored Repair order details for a customer order against the Release #. |
ird_order_ou |
int |
NOT NULL |
order ou instance |
Yes |
Yes |
|
|
|
ird_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
ird_release_no |
int |
|
release number |
|
|
|
|
|
ird_line_no |
|
|
line number |
|
No |
|
|
|
ird_repairorder_no |
varchar(40) |
|
repair order number |
No |
|
|
|
|
ird_repairorder_ou |
int |
|
repair order ou instance |
|
|
|
|
|
ird_amend_no |
|
|
amendment number |
|
|
|
|
|
ird_part_no |
varchar(40) |
NULL |
part number |
|
|
|
|
|
ird_serial_no |
|
|
serial number |
|
|
|
|
|
ird_resource_price |
numeric(28,8) |
|
resource price |
|
|
|
|
|
ird_material_price |
|
|
material price |
|
|
|
|
|
ird_misc_price |
|
|
misc price |
|
|
|
|
|
ird_total_value |
|
|
total value |
|
|
|
|
|
ird_ser_pricelist |
varchar(10) |
|
service price list number |
|
|
|
|
|
ird_pricing_basis |
varchar(25) |
|
pricing basis |
|
|
|
|
|
ird_remarks |
varchar(150) |
|
remarks |
|
|
|
|
|
ird_billable |
varchar(5) |
|
billable |
|
|
|
|
|
ird_inv_status |
|
|
invoice status |
|
|
|
corm_ird_inv_resource_dtl |
This table is used to store the Resource Reported against the workunits for a Customer order Release # wise. |
ird_order_ou |
int |
NOT NULL |
order ou instance |
Yes |
Yes |
|
|
|
ird_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
ird_release_no |
int |
|
release number |
|
|
|
|
|
ird_ref_line_no |
|
|
reference number |
|
|
|
|
|
ird_line_no |
|
|
Running line number for customer order and amendment number combination |
|
|
|
|
|
ird_resource_code |
char(40) |
|
resource code |
|
No |
|
|
|
ird_amend_no |
int |
|
amendment number |
No |
|
|
|
|
ird_wrkunit_lineno |
|
NULL |
workunit line number |
|
|
|
|
|
ird_resouce_type |
char(25) |
|
resource type |
|
|
|
|
|
ird_est_man_hrs |
numeric(28,8,) |
|
estimated man hours |
|
|
|
|
|
ird_quot_ratehr_nor |
numeric(19) |
|
quotation normal rate per hour |
|
|
|
|
|
ird_quot_ratehr_ot |
|
|
quotation overtime rate per hour |
|
|
|
|
|
ird_actual_hr_nor |
numeric(5) |
|
actual hour normal |
|
|
|
|
|
ird_actual_hr_ot |
|
|
actual hour overtime |
|
|
|
|
|
ird_billable_hr_no |
|
|
billable hour normal |
|
|
|
|
|
ird_billable_hr_ot |
|
|
billable hour overtime |
|
|
|
|
|
ird_normalrate_perhr |
numeric(19) |
|
normal rate per hour |
|
|
|
|
|
ird_otrate_perhr |
|
|
over time rate per hour |
|
|
|
|
|
ird_facilityrate_perhr |
|
|
facility rate per hour |
|
|
|
|
|
ird_resource_price |
numeric(28,8) |
|
resource price |
|
|
|
|
|
ird_service_pricelist |
varchar(40) |
|
service price list |
|
|
|
|
|
ird_revision_no |
int(6) |
|
revision number |
|
|
|
|
|
ird_effective_tilldate |
datetime |
|
effective till date |
|
|
|
corm_iwd_inv_wrkunit_dtl |
To store the workunit and object details of the customer order .
All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . |
iwd_order_ou |
int |
NOT NULL |
order ou instance |
Yes |
Yes |
|
|
|
iwd_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
iwd_release_no |
int |
|
release number |
|
|
|
|
|
iwd_line_no |
|
|
Running line number for customer order and amendment number combination |
|
No |
|
|
|
iwd_amend_no |
|
|
amendment number |
No |
|
|
|
|
iwd_invproc_status |
varchar(5) |
NULL |
Quotation Status
1 ) Pending Labour Estimate
2 ) Pending Labour & material Estimate
3 ) Pending Material Estimate
4 ) Pending Confirmation
5 ) Quoted ( on confimration ) |
|
|
|
|
|
iwd_wrkunit_lineno |
int |
|
Line number of each distinct workunit . |
|
|
|
|
|
iwd_workunit_ou |
|
|
Workunit ouinstance |
|
|
|
|
|
iwd_workunit_no |
char(40) |
|
Workunit code |
|
|
|
|
|
iwd_workunit_type |
varchar(25) |
|
WorkunitType values
1 ) Task
2 ) Standard Procedure
3 ) Aircraft Work Package
4 ) Component Work Package
5 ) Maint. Change Request
6 ) Engineering Order |
|
|
|
|
|
iwd_actual_hr |
numeric(5) |
|
actual hour |
|
|
|
|
|
iwd_billable_hr |
numeric(28,8,) |
|
billable hour |
|
|
|
|
|
iwd_billable |
varchar(5) |
|
Billable values
1 ) Yes
2 ) No |
|
|
|
|
|
iwd_invoiced_hr |
numeric(28,8,) |
|
invoiced hour |
|
|
|
|
|
iwd_invoicablehr |
|
|
invoicable hour |
|
|
|
|
|
iwd_billable_labprice |
|
|
billable labour price |
|
|
|
|
|
iwd_billable_facprice |
|
|
billable facility price |
|
|
|
|
|
iwd_billable_matprice |
numeric(28,8) |
|
billable material price |
|
|
|
|
|
iwd_billable_misccost |
|
|
billable miscellenous cost |
|
|
|
|
|
iwd_comments |
varchar(150) |
|
comments |
|
|
|
|
|
iwd_created_by |
varchar(30) |
|
Created by ( user id ) |
|
|
|
|
|
iwd_created_date |
datetime |
|
Created date of the information |
|
|
|
|
|
iwd_modified_by |
varchar(30) |
|
modified by ( user id ) |
|
|
|
|
|
iwd_modified_date |
datetime |
|
Modified date of the information |
|
|
|
|
|
iwd_ref_document |
varchar(40) |
|
reference document number |
|
|
|
|
|
iwd_ref_doc_type |
char(15) |
|
reference document type |
|
|
|
corm_iwd_inv_wutask_dtl |
|
iwd_billable_facprice |
numeric(28,8,) |
|
billable facility price |
|
|
|
|
|
iwd_billable_labprice |
|
|
billable labour price |
|
|
|
|
|
iwd_billable_matprice |
numeric(28,8) |
|
billable material price |
|
|
|
|
|
iwd_billable_miscost |
|
|
billable miscellneous cost |
|
|
|
|
|
iwd_billable_hr |
numeric(28,8,) |
|
billable hour |
|
|
|
|
|
iwd_invoicablehr |
|
|
invoicable hour |
|
|
|
|
|
iwd_billable |
varchar(5) |
|
Billable values
1 ) Yes
2 ) No |
|
|
|
|
|
iwd_actual_hr |
numeric(5) |
|
actual hour |
|
|
|
|
|
iwd_ref_document |
varchar(40) |
|
reference document number |
|
|
|
|
|
iwd_modified_date |
datetime |
|
Modified date of the information |
|
|
|
|
|
iwd_ref_doc_type |
char(15) |
|
reference document type |
|
|
|
|
|
iwd_comments |
varchar(150) |
|
comments |
|
|
|
|
|
iwd_created_by |
varchar(30) |
|
Created by ( user id ) |
|
|
|
|
|
iwd_modified_by |
|
|
modified by ( user id ) |
|
|
|
|
|
iwd_created_date |
datetime |
|
Created date of the information |
|
|
|
|
|
iwd_WorkOrder_No |
char(40) |
|
work order number |
|
|
|
|
|
iwd_line_no |
int |
NOT NULL |
Running line number for customer order and amendment number combination |
Yes |
Yes |
|
|
|
iwd_ref_line_no |
|
|
rerence line number |
|
No |
|
|
|
iwd_amend_no |
|
|
amendment number |
No |
|
|
|
|
iwd_invproc_status |
varchar(5) |
NULL |
Quotation Status
1 ) Pending Labour Estimate
2 ) Pending Labour & material Estimate
3 ) Pending Material Estimate
4 ) Pending Confirmation
5 ) Quoted ( on confimration ) |
|
|
|
|
|
iwd_order_ou |
int |
NOT NULL |
order ou instance |
Yes |
Yes |
|
|
|
iwd_release_no |
|
|
release number |
|
|
|
|
|
iwd_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
iwd_taskrevno |
|
NULL |
task revision number |
No |
No |
|
|
|
iwd_stdproc |
|
|
standard procedure |
|
|
|
|
|
iwd_wrkpckage |
|
|
work package |
|
|
|
|
|
iwd_taskcode |
char(30) |
|
task code |
|
|
|
|
|
iwd_wrkunit_lineno |
int |
|
work unit line number |
|
|
|
|
|
iwd_parent_wu_ou |
|
|
Workunit ouinstance |
|
|
|
|
|
iwd_parent_wu_type |
varchar(25) |
|
WorkunitType values
1 ) Task
2 ) Standard Procedure
3 ) Aircraft Work Package
4 ) Component Work Package
5 ) Maint. Change Request
6 ) Engineering Order |
|
|
|
|
|
iwd_parent_wu_no |
char(40) |
|
Workunit code |
|
|
|
corm_oad_ord_addl_chr_dtl |
This table is used to store additional charges occurs during workorder execution. |
oad_order_ou |
int |
NOT NULL |
order ou instance |
Yes |
|
|
|
|
oad_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
oad_amend_no |
int |
|
amend number |
|
|
|
|
|
oad_lineno |
|
|
line number |
|
|
|
|
|
oad_tcd_ou |
|
|
tcd ou instance |
|
|
|
|
|
oad_tcd_no |
varchar(25) |
|
tcd number |
|
|
|
|
|
oad_tcd_variant_no |
|
|
tcd varient number |
|
|
|
|
|
oad_tcd_Rate |
numeric(28,8) |
NULL |
tcd rate |
No |
|
|
|
|
oad_markup_factor |
bigint |
|
mark up factor |
|
|
|
|
|
oad_cost_center |
char(10) |
|
cost center |
|
|
|
|
|
oad_accounting_usage |
char(20) |
|
accounting usage |
|
|
|
|
|
oad_currency |
varchar(20) |
|
currency |
|
|
|
|
|
oad_billable_yn |
varchar(5) |
|
billable yes / no |
|
|
|
|
|
oad_paytosupplier |
char(16) |
|
pay to supplier |
|
|
|
|
|
oad_remarks |
varchar(255) |
|
remarks |
|
|
|
|
|
oad_amount |
numeric(28,8) |
|
amount |
|
|
|
|
|
oad_invoiced |
varchar(5) |
|
invoiced |
|
|
|
|
|
oad_created_by |
varchar(30) |
|
created by |
|
|
|
|
|
oad_created_date |
datetime |
|
created date |
|
|
|
|
|
oad_modified_by |
varchar(30) |
|
modified by |
|
|
|
|
|
oad_modified_date |
datetime |
|
modified date |
|
|
| dbo |
corm_qh_quotation_hdr |
To Store the header details of the customer order Number . |
qh_order_ou |
int |
NOT NULL |
Customer order ouinstance. |
Yes |
|
| |
|
|
qh_order_no |
varchar(40) |
|
Customer order number |
|
|
| |
|
|
qh_amend_no |
int |
|
Amendment number for the Customer order |
|
|
| |
|
|
qh_quot_no |
varchar(40) |
|
Quotation will be generated when the quotation is done for the first time for customer order .
For a customer order we will have only one quotation number . |
No |
|
| |
|
|
qh_quot_revisionno |
int |
NULL |
When Re-Quotation happen we will generate a revision number for the quotation that is created for the customer order . |
|
|
| |
|
|
qh_Quot_status |
varchar(5) |
|
Quotation Status
1 ) Not Required
2 ) Pending Quote
3 ) Quoted |
|
|
| |
|
|
qh_labrate_perhr |
numeric(28,8) |
|
Labour Rate/HR |
|
|
| |
|
|
qh_facrate_perhr |
|
|
Facility Rate Per Hour |
|
|
| |
|
|
qh_total_value |
|
|
Total value |
|
|
| |
|
|
qh_basic_value |
|
|
Basic value |
|
|
| |
|
|
qh_remarks |
varchar(255) |
|
Remarks |
|
|
| |
|
|
qh_misc_cost |
numeric(28,8) |
|
Miscellenous cost |
|
|
| |
|
|
qh_quot_routinehrs |
numeric(28,8,) |
|
Quoted Routine hours . |
|
|
| |
|
|
qh_quot_nonroutinehrs |
|
|
Quoted Non - Routine hours . |
|
|
| |
|
|
qh_quot_TMat_Price |
numeric(28,8) |
|
Total Quoted Material price |
|
|
| |
|
|
qh_quot_TRes_Price |
|
|
Total Quoted Resource price |
|
|
| |
|
|
qh_quot_TFac_Hrs |
numeric(28,8,) |
|
Total Quoted facility hours |
|
|
| |
|
|
qh_part_comments |
char(256) |
|
Part Comments |
|
|
| |
|
|
qh_timestamp |
int |
|
TimeStamp |
|
|
| |
|
|
qh_quot_created_by |
varchar(30) |
|
customer order quotation createdby by user |
|
|
| |
|
|
qh_quot_created_date |
datetime |
|
Created date and time of the customer order quotation |
|
|
| |
|
|
qh_quot_modified_by |
varchar(30) |
|
customer order quotation modifedby by user |
|
|
| |
|
|
qh_quot_modified_date |
datetime |
|
Modified date and time of the customer order quotation |
|
|
| |
|
|
qh_mquot_created_by |
varchar(30) |
|
Material Quote Created By |
|
|
| |
|
|
qh_mquot_created_date |
datetime |
|
Material Quote Created Date |
|
|
| |
|
|
qh_mquot_modified_by |
varchar(30) |
|
customer order Material quotation modifedby by user |
|
|
| |
|
|
qh_mquot_modified_date |
datetime |
|
Modified date and time of the customer order material quotation |
|
|
| |
|
|
qh_resquot_basis |
varchar(5) |
|
This column will store the previous quote basis of resource for a customer order . |
|
|
| |
|
|
qh_matquot_basis |
|
|
This column will store the previous quote basis of material for a customer order . |
|
|
| |
|
|
qh_quot_comments |
char(256) |
|
This column will store the quotation comments for resource . |
|
|
| |
corm_qhh_quotation_hdr |
|
qhh_order_ou |
int |
NOT NULL |
OU Instance |
Yes |
|
| |
|
|
qhh_order_no |
varchar(40) |
|
Customer order number |
|
|
| |
|
|
qhh_amend_no |
int |
|
Amendment number for the Customer order |
|
|
| |
|
|
qhh_quot_no |
varchar(40) |
|
Quotation will be generated when the quotation is done for the first time for customer order .
For a customer order we will have only one quotation number . |
No |
|
| |
|
|
qhh_quot_revisionno |
int |
NULL |
When Re-Quotation happen we will generate a revision number for the quotation that is created for the customer order . |
|
|
| |
|
|
qhh_Quot_status |
varchar(5) |
|
Quotation Status
1 ) Not Required
2 ) Pending Quote
3 ) Quoted |
|
|
| |
|
|
qhh_labrate_perhr |
numeric(28,8) |
|
Labour Rate/HR |
|
|
| |
|
|
qhh_facrate_perhr |
|
|
Facility Rate Per Hour |
|
|
| |
|
|
qhh_total_value |
|
|
Total value |
|
|
| |
|
|
qhh_basic_value |
|
|
Basic value |
|
|
| |
|
|
qhh_remarks |
varchar(255) |
|
Remarks |
|
|
| |
|
|
qhh_misc_cost |
numeric(28,8) |
|
Miscellenous cost |
|
|
| |
|
|
qhh_quot_routinehrs |
numeric(28,8,) |
|
Quoted Routine hours . |
|
|
| |
|
|
qhh_quot_nonroutinehrs |
|
|
Quoted Non - Routine hours . |
|
|
| |
|
|
qhh_quot_TMat_Price |
numeric(28,8) |
|
Total Quoted Material price |
|
|
| |
|
|
qhh_quot_TRes_Price |
|
|
Total Quoted Resource price |
|
|
| |
|
|
qhh_quot_TFac_Hrs |
numeric(28,8,) |
|
Total Quoted facility hours |
|
|
| |
|
|
qhh_part_comments |
char(256) |
|
Part Comments |
|
|
| |
|
|
qhh_timestamp |
int |
|
Timestamp count |
|
|
| |
|
|
qhh_quot_created_by |
varchar(30) |
|
customer order quotation createdby by user |
|
|
| |
|
|
qhh_quot_created_date |
datetime |
|
Created date and time of the customer order quotation |
|
|
| |
|
|
qhh_quot_modified_by |
varchar(30) |
|
customer order quotation modifedby by user |
|
|
| |
|
|
qhh_quot_modified_date |
datetime |
|
Modified date and time of the customer order quotation |
|
|
| |
|
|
qhh_mquot_created_by |
varchar(30) |
|
Material Quote Created By |
|
|
| |
|
|
qhh_mquot_created_date |
datetime |
|
Material Quote Created Date |
|
|
| |
|
|
qhh_mquot_modified_by |
varchar(30) |
|
customer order Material quotation modifedby by user |
|
|
| |
|
|
qhh_mquot_modified_date |
datetime |
|
Modified date and time of the customer order material quotation |
|
|
| |
|
|
qhh_resquot_basis |
varchar(5) |
|
This column shows the Resource Quote Basis |
|
|
| |
|
|
qhh_matquot_basis |
|
|
|
|
|
| |
|
|
qhh_quot_comments |
char(256) |
|
This column shows the Resource Quote Comments |
|
|
|
corm_qmd_quotemat_dtl |
To Store Part details of the Customer order |
qmd_remarks |
varchar(255) |
|
remarks |
|
|
|
|
|
qmd_partpricelist |
varchar(40) |
|
part price list number |
|
|
|
|
|
qmd_standardcost |
numeric(28,8) |
|
standard cost |
|
|
|
|
|
qmd_embodiment_fee |
bigint |
|
embodiment fee |
|
|
|
|
|
qmd_unit_price |
numeric(28,8) |
|
unit price |
|
|
|
|
|
qmd_comp_unit_price |
|
|
This column will store the value that is computed by the pricing engine . |
|
|
|
|
|
qmd_pplrevisionno |
varchar(40) |
|
part price list revision number |
|
|
|
|
|
qmd_act_qty |
numeric(28) |
|
This column will store the actual part quantity used . |
|
|
|
|
|
qmd_quoteind |
varchar(40) |
|
This column will store value that will indicate the increase in existing part quantity or addition of new part .
Values
1 ) Additional part
1 ) Additional quantity |
|
|
|
|
|
qmd_comp_embodimentfee |
bigint |
|
This column will store the value that is computed by the pricing engine . |
|
|
|
|
|
qmd_amend_no |
int |
NOT NULL |
amendment number |
Yes |
Yes |
|
|
|
qmd_ref_line_no |
|
|
Running line number for customer order and amendment number combination |
|
|
|
|
|
qmd_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
qmd_order_ou |
int |
|
order ou instance |
|
|
|
|
|
qmd_quantity |
numeric(28) |
NULL |
quantity |
No |
No |
|
|
|
qmd_stk_status |
char(40) |
NOT NULL |
This column shows the stock status of the part |
Yes |
|
|
|
|
qmd_revisionno |
int |
NULL |
revision number |
No |
|
|
|
|
qmd_Line_no |
|
NOT NULL |
line number |
Yes |
Yes |
|
|
|
qmd_part_no |
char(40) |
|
part number |
|
No |
|
|
|
qmd_part_ou |
int |
|
part ou instance |
|
|
|
corm_qmhd_quotemat_dtl |
This table is used to store Material quote details for a customer order |
qmhd_remarks |
varchar(255) |
NULL |
Remarks |
No |
|
|
|
|
qmhd_partpricelist |
varchar(40) |
|
Part Price List |
|
|
|
|
|
qmhd_standardcost |
numeric(28,8) |
|
Standard Cost |
|
|
|
|
|
qmhd_embodiment_fee |
bigint |
|
Embodiment Fee |
|
|
|
|
|
qmhd_unit_price |
numeric(28,8) |
|
Unit Price |
|
|
|
|
|
qmhd_quoteind |
varchar(40) |
|
This shows Part Indicator |
|
|
|
|
|
qmhd_pplrevisionno |
|
|
Part Price List revision Number |
|
|
|
|
|
qmhd_comp_embodimentfee |
bigint |
|
This shows Part Embodiment Fee |
|
|
|
|
|
qmhd_comp_unit_price |
numeric(28,8) |
|
This shows Part Unit Price |
|
|
|
|
|
qmhd_act_qty |
numeric(28) |
|
This shows Actual Part Qty |
|
|
|
|
|
qmhd_amend_no |
int |
NOT NULL |
Customer Order Amendment Number |
Yes |
Yes |
|
|
|
qmhd_ref_line_no |
|
|
Running line number for customer order and amendment number combination |
|
|
|
|
|
qmhd_order_no |
varchar(40) |
|
Customer Order Number |
|
|
|
|
|
qmhd_order_ou |
int |
|
Customer Order OU Instance |
|
|
|
|
|
qmhd_quantity |
numeric(28) |
NULL |
Quantity |
No |
No |
|
|
|
qmhd_stk_status |
char(40) |
NOT NULL |
This shows Part Stock Status |
Yes |
|
|
|
|
qmhd_revisionno |
int |
NULL |
Revision Number |
No |
|
|
|
|
qmhd_Line_no |
|
NOT NULL |
Line Number |
Yes |
Yes |
|
|
|
qmhd_part_no |
char(40) |
|
Part Number |
|
No |
|
|
|
qmhd_part_ou |
int |
|
Part OU Instance |
|
|
|
corm_qrd_qout_repord_dtl |
This table will have information on Quoted Repair Order |
qrd_pricing_basis |
varchar(25) |
NULL |
pricing basis |
No |
|
|
|
|
qrd_billable |
varchar(5) |
|
billable
y - yes
n - no |
|
|
|
|
|
qrd_ser_pricelist |
varchar(10) |
|
service price list number |
|
|
|
|
|
qrd_total_value |
numeric(28,8) |
|
total value |
|
|
|
|
|
qrd_misc_price |
|
|
miscellenous price |
|
|
|
|
|
qrd_resquot_basis |
varchar(5) |
|
This column will store the resource quote basis of each repair order . |
|
|
|
|
|
qrd_quot_status |
|
|
quotation status |
|
|
|
|
|
qrd_remarks |
varchar(150) |
|
remarks |
|
|
|
|
|
qrd_revision_no |
int |
|
revision number -
number of times the repair order value revisied |
|
|
|
|
|
qrd_matquot_basis |
varchar(5) |
|
This column will store the material quote basis of each repair order . |
|
|
|
|
|
qrd_amend_no |
int |
NOT NULL |
Amendment number for the Customer order |
Yes |
Yes |
|
|
|
qrd_line_no |
|
|
line number |
|
No |
|
|
|
qrd_order_no |
varchar(40) |
|
Customer order number |
|
Yes |
|
|
|
qrd_order_ou |
int |
|
Customer order ouinstance |
|
|
|
|
|
qrd_material_price |
numeric(28,8) |
NULL |
material price |
No |
No |
|
|
|
qrd_serial_no |
varchar(40) |
|
serial number |
|
|
|
|
|
qrd_resource_price |
numeric(28,8) |
|
resource price |
|
|
|
|
|
qrd_repairorder_no |
varchar(40) |
NOT NULL |
repair oder number |
|
|
|
|
|
qrd_part_no |
|
NULL |
part number |
|
|
|
|
|
qrd_repairorder_ou |
int |
NOT NULL |
repair order ou instance |
|
|
|
corm_qrhd_qout_repord_dtl |
This table is used to store Quotation Repair Order details for a customer order |
qrhd_pricing_basis |
varchar(25) |
NULL |
Pricing Basis |
|
|
|
|
|
qrhd_billable |
varchar(5) |
|
Billable |
|
|
|
|
|
qrhd_ser_pricelist |
varchar(10) |
|
Service Price List |
|
|
|
|
|
qrhd_total_value |
numeric(28,8) |
|
Total value |
|
|
|
|
|
qrhd_misc_price |
|
|
Miscelaneous Price |
|
|
|
|
|
qrhd_resquot_basis |
varchar(5) |
|
This Shows Resource Quote Basis |
|
|
|
|
|
qrhd_quot_status |
|
|
Quotation Status |
|
|
|
|
|
qrhd_remarks |
varchar(150) |
|
Remarks |
|
|
|
|
|
qrhd_revision_no |
int |
|
revision number -
number of times the repair order value revisied |
|
|
|
|
|
qrhd_matquot_basis |
varchar(5) |
|
This Shows Material Quote Basis |
|
|
|
|
|
qrhd_amend_no |
int |
NOT NULL |
Amendment number for the Customer order |
Yes |
Yes |
|
|
|
qrhd_line_no |
|
|
Line Number |
|
No |
|
|
|
qrhd_order_no |
varchar(40) |
|
Customer order number |
|
Yes |
|
|
|
qrhd_order_ou |
int |
|
Customer Order OU Instance |
|
|
|
|
|
qrhd_material_price |
numeric(28,8) |
NULL |
Material Price |
No |
No |
|
|
|
qrhd_serial_no |
varchar(40) |
|
Serial number |
|
|
|
|
|
qrhd_resource_price |
numeric(28,8) |
|
Resource Price |
|
|
|
|
|
qrhd_repairorder_no |
varchar(40) |
NOT NULL |
Repair Order Number |
|
|
|
|
|
qrhd_part_no |
|
NULL |
Part Number |
|
|
|
|
|
qrhd_repairorder_ou |
int |
NOT NULL |
Repair Order OU Instance |
|
|
|
CORM_QRS_QUOTE_RES_DTL |
This table will store the resource details at task level . |
qrs_nonbillable_hrs |
numeric(28,8,) |
NULL |
Non billable Hours |
|
|
|
|
|
qrs_billable_hrs |
|
|
Billable Hours |
|
|
|
|
|
qrs_est_no |
numeric(28) |
|
Estimation Number |
|
|
|
|
|
qrs_spl_revno |
varchar(40) |
|
Service Price List Revision Number |
|
|
|
|
|
qrs_resourcerate_perhr |
numeric(28,8) |
|
Resource Rate Per Hour |
|
|
|
|
|
qrs_pricelist |
varchar(40) |
|
Service Price List |
|
|
|
|
|
qrs_spl_eff_date |
datetime |
|
Service Price List Effectivity date |
|
|
|
|
|
qrs_order_no |
varchar(40) |
NOT NULL |
order number |
Yes |
Yes |
|
|
|
qrs_amend_no |
int |
|
amendment number |
|
|
|
|
|
qrs_order_ou |
|
|
order ou instance |
|
|
|
|
|
qrs_resource_type |
varchar(25) |
NULL |
Resource Type |
No |
No |
|
|
|
qrs_resource_code |
char(40) |
NOT NULL |
Resource Code |
Yes |
|
|
|
|
qrs_ref_line_no |
int |
|
Running line number for customer order and amendment number combination |
|
Yes |
|
|
|
qrs_task_line_no |
|
|
task like numer |
|
|
|
corm_qwd_quote_wrkunit_dtl |
To store the workunit and object details of the customer order .
All the workunits defined in the workunit tab will be executed , For each part captured in object details tab page . |
qwd_remarks |
varchar(150) |
NULL |
remarks |
No |
No |
|
|
|
qwd_estmisc_price |
numeric(28,8) |
|
estimated miscellenous price |
|
|
|
|
|
qwd_pricingbasis |
varchar(25) |
|
pricing basis |
|
|
|
|
|
qwd_created_by |
varchar(30) |
|
Created by ( user id ) |
|
|
|
|
|
qwd_estmat_price_flat |
numeric(28,8) |
|
estimated material price flat |
|
|
|
|
|
qwd_embodiment_fee |
|
|
Embodiment Fee |
|
|
|
|
|
qwd_estmat_price |
|
|
Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) |
|
|
|
|
|
qwd_estresource_price |
|
|
estimated resource price |
|
|
|
|
|
qwd_matquot_basis |
varchar(5) |
|
This column will store the quote basis of material for each workunit . |
|
|
|
|
|
qwd_resquot_basis |
|
|
This column will store the quote basis of resource for each workunit . |
|
|
|
|
|
qwd_act_labhrs |
numeric(28,8,) |
|
This column will store actual labour hours for each workunit . |
|
|
|
|
|
qwd_created_date |
datetime |
|
Created date of the information |
|
|
|
|
|
qwd_modified_by |
varchar(30) |
|
modified by ( user id ) |
|
|
|
|
|
qwd_ref_doc_type |
char(15) |
|
reference document type |
|
|
|
|
|
qwd_modified_date |
datetime |
|
Modified date of the information |
|
|
|
|
|
qwd_ref_document |
varchar(40) |
|
reference document number |
|
|
|
|
|
qwd_act_fachrs |
numeric(28,8,) |
|
This column will store actual facility hours for each workunit . |
|
|
|
|
|
qwd_revisionno |
int |
|
revision number |
|
|
|
|
|
qwd_quot_no |
varchar(40) |
NOT NULL |
quotation number |
|
|
|
|
|
qwd_quot_status |
varchar(5) |
NULL |
Quotation Status
1 ) Pending Labour Estimate
2 ) Pending Labour & material Estimate
3 ) Pending Material Estimate
4 ) Pending Confirmation
5 ) Quoted ( on confimration ) |
|
|
|
|
|
qwd_wrkunit_lineno |
int |
|
Line number of each distinct workunit . |
|
|
|
|
|
qwd_order_ou |
|
NOT NULL |
Customer order ouinstance |
Yes |
Yes |
|
|
|
qwd_line_no |
|
|
Running line number for customer order and amendment number combination |
|
No |
|
|
|
qwd_order_no |
varchar(40) |
|
Customer order number |
|
Yes |
|
|
|
qwd_amend_no |
int |
|
Amendment number for the Customer order |
|
|
|
|
|
qwd_facilityrate_perhr |
numeric(28,8) |
NULL |
facility rate per hour |
No |
No |
|
|
|
qwd_qfacility_hrs |
numeric(28,8,) |
|
quoted facility hours |
|
|
|
|
|
qwd_qlabour_hrs |
|
|
quoted labour hours |
|
|
|
|
|
qwd_labourrate_perhr |
numeric(28,8) |
|
labour rate per hour |
|
|
|
|
|
qwd_workunit_ou |
int |
|
Workunit ouinstance |
|
|
|
|
|
qwd_workunit_no |
char(40) |
|
Workunit code |
|
|
|
|
|
qwd_estman_hrs |
numeric(28,8,) |
|
Estimated ManHours |
|
|
|
|
|
qwd_wrkunit_type |
varchar(25) |
|
WorkunitType values
1 ) Task
2 ) Standard Procedure
3 ) Aircraft Work Package
4 ) Component Work Package
5 ) Maint. Change Request
6 ) Engineering Order |
|
|
|
|
|
qwd_billable |
varchar(5) |
|
Billable values
1 ) Yes
2 ) No |
|
|
|
corm_qwd_quote_wutask_dtl |
|
qwd_embodiment_fee |
numeric(28,8) |
|
Embodiment Fee |
|
|
|
|
|
qwd_estmat_price |
|
|
Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) |
|
|
|
|
|
qwd_estmisc_price |
|
|
Estimated Misclaneous price |
|
|
|
|
|
qwd_pricingbasis |
varchar(25) |
|
Pricing Basis |
|
|
|
|
|
qwd_remarks |
varchar(150) |
|
Remarks |
|
|
|
|
|
qwd_labourrate_perhr |
numeric(28,8) |
|
Quated Labour rate Per Hour |
|
|
|
|
|
qwd_estmaterial_price_flt |
|
|
Estimated Material price Flat |
|
|
|
|
|
qwd_facilityrate_perhr |
|
|
Quated Facility rate per Hours |
|
|
|
|
|
qwd_estresource_price |
|
|
Estimated Resource Price |
|
|
|
|
|
qwd_qfacility_hrs |
numeric(28,8,) |
|
Quated Facility Hours |
|
|
|
|
|
qwd_resquot_basis |
varchar(5) |
|
This column will store the quote basis of resource for each task . |
|
|
|
|
|
qwd_ref_doc_type |
char(15) |
|
reference document type |
|
|
|
|
|
qwd_matquot_basis |
varchar(5) |
|
This column will store the quote basis of material for each task . |
|
|
|
|
|
qwd_act_labhrs |
numeric(28,8,) |
|
This column will store actual labour hours for each task. |
|
|
|
|
|
qwd_created_by |
varchar(30) |
|
Created by ( user id ) |
|
|
|
|
|
qwd_created_date |
datetime |
|
Created date of the information |
|
|
|
|
|
qwd_ref_document |
varchar(40) |
|
Reference Document Number |
|
|
|
|
|
qwd_modified_by |
varchar(30) |
|
modified by ( user id ) |
|
|
|
|
|
qwd_modified_date |
datetime |
|
Modified date of the information |
|
|
|
|
|
qwd_act_fachrs |
numeric(28,8,) |
|
This column will store actual facility hours for each task . |
|
|
|
|
|
qwd_quot_no |
varchar(40) |
NOT NULL |
quotation number |
|
|
|
|
|
qwd_task_line_no |
int |
|
task like numer |
Yes |
|
|
|
|
qwd_quot_status |
varchar(5) |
NULL |
Quotation Status
1 ) Pending Labour Estimate
2 ) Pending Labour & material Estimate
3 ) Pending Material Estimate
4 ) Pending Confirmation
5 ) Quoted ( on confimration ) |
No |
|
|
|
|
qwd_revisionno |
int |
|
revision number |
|
|
|
|
|
qwd_wrkunit_lineno |
|
|
Line number of each distinct workunit . |
|
|
|
|
|
qwd_order_ou |
|
NOT NULL |
order ou instance |
Yes |
Yes |
|
|
|
qwd_ref_line_no |
|
|
Running line number for customer order and amendment number combination |
|
|
|
|
|
qwd_order_no |
varchar(40) |
|
order number |
|
|
|
|
|
qwd_amend_no |
int |
|
amendment number |
|
|
|
|
|
qwd_qlabour_Hrs |
numeric(28,8,) |
NULL |
Quated Labour Hours |
No |
No |
|
|
|
qwd_taskrevno |
varchar(40) |
|
Task Revision Number |
|
|
|
|
|
qwd_taskcode |
varchar(30) |
|
Task Code |
|
|
|
|
|
qwd_billable |
varchar(5) |
|
Billable values
1 ) Yes
2 ) No |
|
|
|
|
|
qwd_estman_Hrs |
numeric(28,8,) |
|
Estimated ManHours |
|
|
|
|
|
qwd_parent_wu_ou |
int |
|
Workunit ouinstance |
|
|
|
|
|
qwd_parent_wu_no |
char(40) |
|
Workunit code |
|
|
|
|
|
qwd_stdproc |
varchar(40) |
|
Standard procedure |
|
|
|
|
|
qwd_parent_wu_type |
varchar(25) |
|
WorkunitType values
1 ) Task
2 ) Standard Procedure
3 ) Aircraft Work Package
4 ) Component Work Package
5 ) Maint. Change Request
6 ) Engineering Order |
|
|
|
|
|
qwd_wrkpckage |
varchar(40) |
|
Work Pakage |
|
|
|
corm_qwhd_quote_wrkunit_dtl |
|
qwhd_remarks |
varchar(150) |
|
Remarks |
|
|
|
|
|
qwhd_estmisc_price |
numeric(28,8) |
|
Estimated Miscelaneous Price |
|
|
|
|
|
qwhd_pricingbasis |
varchar(25) |
|
Pricing basis |
|
|
|
|
|
qwhd_created_by |
varchar(30) |
|
Created by ( user id ) |
|
|
|
|
|
qwhd_estmat_price_flat |
numeric(28,8) |
|
Flat Estimated Material Price |
|
|
|
|
|
qwhd_embodiment_fee |
|
|
Embodiment Fee |
|
|
|
|
|
qwhd_estmat_price |
|
|
Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) |
|
|
|
|
|
qwhd_estresource_price |
|
|
Estimated Resource Price |
|
|
|
|
|
qwhd_act_fachrs |
numeric(28,8,) |
|
This Column shows Actual Facility Hour |
|
|
|
|
|
qwhd_act_labhrs |
|
|
This Column shows Actual Labour Hour |
|
|
|
|
|
qwhd_resquot_basis |
varchar(5) |
|
This Column shows Resource Quote Basis |
|
|
|
|
|
qwhd_created_date |
datetime |
|
Created date of the information |
|
|
|
|
|
qwhd_modified_by |
varchar(30) |
|
modified by ( user id ) |
|
|
|
|
|
qwhd_ref_doc_type |
char(15) |
|
Reference Document Type |
|
|
|
|
|
qwhd_modified_date |
datetime |
|
Modified date of the information |
|
|
|
|
|
qwhd_ref_document |
varchar(40) |
|
Reference Document |
|
|
|
|
|
qwhd_matquot_basis |
varchar(5) |
|
This Column shows Material Quote Basis |
|
|
|
|
|
qwhd_revisionno |
int |
|
Revision Number |
|
|
|
|
|
qwhd_quot_no |
varchar(40) |
|
Quotation Number |
|
|
|
|
|
qwhd_quot_status |
varchar(5) |
|
Quotation Status
1 ) Pending Labour Estimate
2 ) Pending Labour & material Estimate
3 ) Pending Material Estimate
4 ) Pending Confirmation
5 ) Quoted ( on confimration ) |
|
|
|
|
|
qwhd_wrkunit_lineno |
int |
|
Line number of each distinct workunit . |
|
|
|
|
|
qwhd_order_ou |
|
NOT NULL |
Customer order OU Instance |
Yes |
Yes |
|
|
|
qwhd_line_no |
|
|
Running line number for customer order and amendment number combination |
|
No |
|
|
|
qwhd_order_no |
varchar(40) |
|
Customer order number |
|
Yes |
|
|
|
qwhd_amend_no |
int |
|
Amendment number for the Customer order |
|
|
|
|
|
qwhd_facilityrate_perhr |
numeric(28,8) |
NULL |
Facility Rate PerHour |
No |
No |
|
|
|
qwhd_qfacility_hrs |
numeric(28,8,) |
|
Quotated Facility Hours |
|
|
|
|
|
qwhd_qlabour_hrs |
|
|
Quotated Labour Hours |
|
|
|
|
|
qwhd_labourrate_perhr |
numeric(28,8) |
|
Labour Rate PerHour |
|
|
|
|
|
qwhd_wrkunit_ou |
int |
|
Workunit ouinstance |
|
|
|
|
|
qwhd_workunit_no |
char(40) |
|
Workunit code |
|
|
|
|
|
qwhd_estman_hrs |
numeric(28,8,) |
|
Estimated ManHours |
|
|
|
|
|
qwhd_wrkunit_type |
varchar(25) |
|
WorkunitType values
1 ) Task
2 ) Standard Procedure
3 ) Aircraft Work Package
4 ) Component Work Package
5 ) Maint. Change Request
6 ) Engineering Order |
|
|
|
|
|
qwhd_billable |
varchar(5) |
|
Billable values
1 ) Yes
2 ) No |
|
|
|
corm_qwhd_quote_wutask_dtl |
|
qwhd_embodiment_fee |
numeric(28,8) |
|
Embodiment Fee |
|
|
|
|
|
qwhd_estmat_price |
|
|
Estimated Material Price = SUM ( Unit Material Price ) + SUM ( Embodiment Fee ) |
|
|
|
|
|
qwhd_estmisc_price |
|
|
Estimated Miscelaneous price |
|
|
|
|
|
qwhd_pricingbasis |
varchar(25) |
|
Pricing Basis |
|
|
|
|
|
qwhd_remarks |
varchar(150) |
|
Remarks |
|
|
|
|
|
qwhd_labourrate_perhr |
numeric(28,8) |
|
Labour rate per Hour |
|
|
|
|
|
qwhd_estmaterial_price_flt |
|
|
Flat Estimated Material Price |
|
|
|
|
|
qwhd_facilityrate_perhr |
|
|
Facility rate per Hour |
|
|
|
|
|
qwhd_estresource_price |
|
|
Estimated resource Price |
|
|
|
|
|
qwhd_qfacility_hrs |
numeric(28,8,) |
|
Quotated Facility Hours |
|
|
|
|
|
qwhd_act_labhrs |
|
|
This Column shows Actual Labour Hours |
|
|
|
|
|
qwhd_ref_doc_type |
char(15) |
|
Reference Document Type |
|
|
|
|
|
qwhd_act_fachrs |
numeric(28,8,) |
|
This Column shows Actual Facility Hours |
|
|
|
|
|
qwhd_resquot_basis |
varchar(5) |
|
This Column shows Resource Quote Basis |
|
|
|
|
|
qwhd_created_by |
varchar(30) |
|
Created by ( user id ) |
|
|
|
|
|
qwhd_created_date |
datetime |
|
Created date of the information |
|
|
|
|
|
qwhd_ref_document |
varchar(40) |
|
Reference Document Number |
|
|
|
|
|
qwhd_modified_by |
varchar(30) |
|
modified by ( user id ) |
|
|
|
|
|
qwhd_modified_date |
datetime |
|
Modified date of the information |
|
|
|
|
|
qwhd_matquot_basis |
varchar(5) |
|
This Column shows Material Quote Bas |
|
|
|
|
|
qwhd_quot_no |
varchar(40) |
|
Quotation Number |
|
|
|
|
|
qwhd_task_line_no |
int |
NOT NULL |
Task Line Number |
Yes |
|
|
|
|
qwhd_revisionno |
|
NULL |
Revision Number |
No |
|
|
|
|
qwhd_quot_status |
varchar(5) |
|
Quotation Status
1 ) Pending Labour Estimate
2 ) Pending Labour & material Estimate
3 ) Pending Material Estimate
4 ) Pending Confirmation
5 ) Quoted ( on confimration ) |
|
|
|
|
|
qwhd_wrkunit_lineno |
int |
|
Line number of each distinct workunit . |
|
|
|
|
|
qwhd_order_ou |
|
NOT NULL |
Customer Order OU Instance |
Yes |
Yes |
|
|
|
qwhd_ref_line_no |
|
|
Running line number for customer order and amendment number combination |
|
|
|
|
|
qwhd_order_no |
varchar(40) |
|
Customer Order Number |
|
|
|
|
|
qwhd_amend_no |
int |
|
Customer Order Amendment Number |
|
|
|
|
|
qwhd_qlabour_Hrs |
numeric(28,8,) |
NULL |
Quotated Labour Hours |
No |
No |
|
|
|
qwhd_taskrevno |
varchar(40) |
|
Task Revision Number |
|
|
|
|
|
qwhd_taskcode |
varchar(30) |
|
Task Code |
|
|
|
|
|
qwhd_billable |
varchar(5) |
|
Billable values
1 ) Yes
2 ) No |
|
|
|
|
|
qwhd_estman_Hrs |
numeric(28,8,) |
|
Estimated ManHours |
|
|
|
|
|
qwhd_parent_wu_ou |
int |
|
Workunit ouinstance |
|
|
|
|
|
qwhd_parent_wu_no |
char(40) |
|
Workunit code |
|
|
|
|
|
qwhd_stdproc |
varchar(40) |
|
Standard Procedure |
|
|
|
|
|
qwhd_parent_wu_type |
varchar(25) |
|
WorkunitType values
1 ) Task
2 ) Standard Procedure
3 ) Aircraft Work Package
4 ) Component Work Package
5 ) Maint. Change Request
6 ) Engineering Order |
|
|
|
|
|
qwhd_wrkpckage |
varchar(40) |
|
Work Package |
|
|
|
corm_td_tcd_dtl |
This table is used to stored Tax, Charge and Discount details for a customer order against the Release #. |
td_billable_yn |
varchar(5) |
|
billable y-yes
n - no |
|
|
|
|
|
td_Amount |
numeric(28,8) |
|
amount |
|
|
|
|
|
td_rate |
|
|
rate |
|
|
|
|
|
td_currency |
varchar(20) |
|
currency |
|
|
|
|
|
td_modified_by |
varchar(30) |
|
modified by |
|
|
|
|
|
td_PaytoSupplier |
char(16) |
|
pay to supplier |
|
|
|
|
|
td_created_date |
datetime |
|
created date |
|
|
|
|
|
td_created_by |
varchar(30) |
|
created by |
|
|
|
|
|
td_modified_date |
datetime |
|
modified date |
|
|
|
|
|
td_release_no |
int |
NOT NULL |
release number |
Yes |
Yes |
|
|
|
td_Lineno |
|
|
line number |
|
No |
|
|
|
td_order_no |
varchar(40) |
|
order number |
|
Yes |
|
|
|
td_order_ou |
int |
|
order ou instance |
|
|
|
|
|
td_amend_no |
|
|
amendment number |
No |
No |
|
|
|
td_tcd_Variant_no |
varchar(25) |
|
tcd variant number |
Yes |
|
|
|
|
td_ApplnOn |
varchar(5) |
|
applicable on |
|
|
|
|
|
td_tcd_no |
varchar(25) |
|
tcd number |
|
|
|
|
|
td_tcd_ou |
int |
|
tcd ou instance |
|
|