Request for Quotation |
|||||
|
|
|||||
|
Table Name quo_quodet_quot_detail |
|
||||
|
|
|||||
|
Table Comment This table holds the Quotation Item Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUODET_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUODET_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUODET_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
quodet_line_no |
numeric(10) |
NOT NULL |
This field holds the line number of the multiline |
No |
No |
|
quodet_rfq_line_no |
|
NULL |
This field holds the RFQ line number |
No |
No |
|
quodet_part_no |
varchar(40) |
NULL |
This field holds the part number |
No |
No |
|
quodet_part_desc |
varchar(150) |
NULL |
This field holds the part description of the part |
No |
No |
|
quodet_part_type |
varchar(5) |
NULL |
This field holds the Part Type - as defined in Part Admin |
No |
No |
|
quodet_part_condition |
varchar(5) |
NULL |
This field holds the Part Condition - "New", "New Surplus", "Overhauled" ,"Serviceable" |
No |
No |
|
quodet_quoted_part |
varchar(40) |
NULL |
This field holds the Quoted Part Number |
No |
No |
|
quodet_quoted_qty |
numeric(28,8) |
NULL |
This field holds the Quoted Quantity |
No |
No |
|
quodet_quoted_uom |
varchar(10) |
NULL |
This field holds the Quoted UOM |
No |
No |
|
quodet_cost |
numeric(28,8) |
NULL |
This field holds the Cost for the quantity cost_per |
No |
No |
|
quodet_cost_per |
numeric(10) |
NULL |
This field holds the Quantity for which cost is specified |
No |
No |
|
quodet_qty_price_break |
varchar(5) |
NULL |
This field holds the Quantity price break. Valid values are ’Yes’ and ’No’ . .This is set as ’Yes’ if quantity price break is defined for the Item |
No |
No |
|
quodet_sch_type |
|
NULL |
This field holds the Schedule Type - Can be Single or Multiple |
No |
No |
|
quodet_need_date |
datetime |
NULL |
This field holds the Need Date |
No |
No |
|
quodet_ship_to |
numeric(10) |
NULL |
This field holds the Ship To |
No |
No |
|
quodet_quality_attribute |
varchar(5) |
NULL |
This field holds the Quality Attribute - Valid values are ’Yes’ and ’No’ .This is set as ’Yes’ if quality attributes are defined for the Item |
No |
No |
|
quodet_certificate_type |
varchar(25) |
NULL |
This field holds the Certificate Type - Values as defined for Parts in the Logistics Common Master which are in Active status |
No |
No |
|
quodet_remarks |
varchar(255) |
NULL |
This field holds the Remarks for the part |
No |
No |
|
quodet_part_ou |
numeric(10) |
NULL |
This field holds the Part OU in which part created |
No |
No |
|
quodet_lead_time |
numeric(28,8) |
NULL |
This field holds the lead time |
No |
No |
|
quodet_lead_time_uom |
varchar(5) |
NULL |
This field holds the lead time UOM |
No |
No |
|
quodet_auth_status |
|
NULL |
This field holds the item level authorization status |
No |
No |
|
quodet_base_curr_cost |
numeric(28,8) |
NULL |
This field holds the value of the part cost in base currency |
No |
No |
|
|
|||||
|
Table Name quo_quodtcd_quot_doc_tcd |
|
||||
|
|
|||||
|
Table Comment This table holds the data of Document Level TCDs of the Quoation |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUODTCD_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUODTCD_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUODTCD_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
quodtcd_tcd_seq_no |
numeric(10) |
NOT NULL |
This field holds the TCD Sequence number |
No |
No |
|
quodtcd_tcd_ou |
numeric(10) |
NULL |
This field holds the TCD OU instance |
No |
No |
|
quodtcd_tcd_code |
varchar(25) |
NOT NULL |
This field holds the TCD Code |
No |
No |
|
quodtcd_tcd_variant |
|
NULL |
This field holds the TCD Variant |
No |
No |
|
quodtcd_tcd_rate |
numeric(28,8) |
NULL |
This field holds the TCD Rate |
No |
No |
|
quodtcd_supp_ou |
numeric(10) |
NULL |
This field holds the Supplier OU |
No |
No |
|
quodtcd_pay_to_supp |
varchar(45) |
NULL |
This field holds the Pay to Supplier Code |
No |
No |
|
quodtcd_tcd_amount |
numeric(28,8) |
NULL |
This field holds the TCD Amount |
No |
No |
|
quodtcd_currency |
varchar(5) |
NULL |
This field holds the stores the payment currency |
No |
No |
|
quodtcd_user_seqno |
numeric(10) |
NULL |
stores the user entered sequence number |
No |
No |
|
quodtcd_exchg_rate |
numeric(28,8) |
NULL |
stores the exchanges rate between document currency and the multiline currency |
No |
No |
|
|
|||||
|
Table Name quo_quohdr_quot_header |
|
||||
|
|
|||||
|
Table Comment Quotation Header |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
quohdr_ouinstance |
numeric(10) |
NOT NULL |
This field holds the OU instance where the document created |
No |
No |
|
quohdr_quot_no |
varchar(40) |
NOT NULL |
This field holds the quotation number |
No |
No |
|
quohdr_amend_no |
varchar(40) |
NOT NULL |
This field holds the quotation amendment no |
No |
No |
|
quohdr_rfq_no |
varchar(40) |
NULL |
This field holds the RFQ Number |
No |
No |
|
quohdr_supp_ou |
numeric(10) |
NULL |
This field holds the Supplier OU |
No |
No |
|
quohdr_supp_code |
varchar(45) |
NULL |
This field holds the Supplier Code |
No |
No |
|
quohdr_num_type_no |
varchar(5) |
NULL |
This field holds the numbering type number used for quotation generation |
No |
No |
|
quohdr_user_status |
varchar(25) |
NULL |
This field holds the User Status -List of Active user defined status in common master |
No |
No |
|
quohdr_status |
varchar(5) |
NULL |
This field holds the Status of the quotation - "Draft", "Fresh", "Confirm", "Cancel", "Authorized", "Rejected", Partially Amended","Amended" (D)Draft (F)Fresh (C)Cancelled (CN)Confirmed (A)Authorized (R)Rejected (UA)Under Amendment (AM)Amended (RE)Revised |
No |
No |
|
quohdr_buyer_group_ou |
numeric(10) |
NULL |
This field holds the buyer group OU |
No |
No |
|
quohdr_buyer_group |
varchar(25) |
NULL |
This field holds the Buyer Group |
No |
No |
|
quohdr_quot_date |
datetime |
NULL |
This field holds the Quotation Date |
No |
No |
|
quohdr_quot_type |
varchar(5) |
NULL |
This field holds the Quotation Type - "Price List" and "Normal" (N)Normal (PL)Price List |
No |
No |
|
quohdr_supp_offer_no |
varchar(40) |
NULL |
This field holds the Supplier offer number |
No |
No |
|
quohdr_quot_category |
varchar(25) |
NULL |
This field holds the Quotation Category - list of categories in Active status, defined for the document Quotation, in the Logistics Common Master component |
No |
No |
|
quohdr_supp_offer_date |
datetime |
NULL |
This field holds the Supplier Offer Date |
No |
No |
|
quohdr_received_date |
datetime |
NULL |
This field holds the Received Date |
No |
No |
|
quohdr_price_held_firm_time |
numeric(28,8) |
NULL |
This field holds the Price held firm time |
No |
No |
|
quohdr_time_uom |
varchar(5) |
NULL |
This field holds the Time UOM (M)Months (D)Days (W)Weeks |
No |
No |
|
quohdr_currency |
varchar(20) |
NULL |
This field holds the Currency of the document |
No |
No |
|
quohdr_effective_to |
datetime |
NULL |
This field holds the Effective To |
No |
No |
|
quohdr_exchange_rate |
numeric(28,8) |
NULL |
This field holds the Exchange Rate |
No |
No |
|
quohdr_rfq_date |
datetime |
NULL |
This field holds the request for quotation date |
No |
No |
|
quohdr_active_flag |
varchar(5) |
NULL |
This field holds the ’Y’ indicates that this is the latest amendment (Y)Yes |
No |
No |
|
quohdr_createddate |
datetime |
NULL |
This field holds the Created Date |
No |
No |
|
quohdr_created_by |
varchar(30) |
NULL |
This field holds the Created By |
No |
No |
|
quohdr_modifieddate |
datetime |
NULL |
This field holds the Last Modified Date |
No |
No |
|
quohdr_modified_by |
varchar(30) |
NULL |
This field holds the Last Modified By |
No |
No |
|
quohdr_approveddate |
datetime |
NULL |
This field holds the date when the quotation was approved |
No |
No |
|
quohdr_approved_by |
varchar(30) |
NULL |
This field holds the user name of the approver |
No |
No |
|
quohdr_timestamp |
numeric(10) |
NULL |
This field holds the timestamp so that more than one user cant modified same record in the same time |
No |
No |
|
quohdr_remarks |
varchar(2000) |
NULL |
This field holds the remarks entered for the quotation |
No |
No |
|
QUOHDR_ADDRESSID |
numeric(10) |
NULL |
This field holds the address id |
No |
No |
|
QUOHDR_CONTACT_PERSON |
varchar(80) |
NULL |
This field holds the contact person |
No |
No |
|
quohdr_latest_amd_flag |
varchar(5) |
NULL |
This field holds the Stores the latest amend flag. Values allowed : (Y) Yes (N) No |
No |
No |
|
|
|||||
|
Table Name quo_quoins_quot_terms_conds |
|
||||
|
|
|||||
|
Table Comment Terms And Conditions |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUOINS_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUOINS_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUOINS_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
quoins_payterm |
varchar(25) |
NULL |
This field holds the pay term selected for the document |
No |
No |
|
quoins_payment_mode |
varchar(25) |
NULL |
This field holds the pay term mode |
No |
No |
|
quoins_payto_supplier |
varchar(45) |
NULL |
This field holds the Pay to supplier |
No |
No |
|
quoins_insurance_terms |
varchar(150) |
NULL |
This field holds the Insurance terms |
No |
No |
|
quoins_insurance_liability |
varchar(25) |
NULL |
This field holds the Insurance Liability (SLF)Self (SUP)Supplier (N)None |
No |
No |
|
quoins_insurance_amount |
numeric(28,8) |
NULL |
This field holds the Insurance Amount |
No |
No |
|
quoins_inco_term |
varchar(150) |
NULL |
This field holds the INCO Term |
No |
No |
|
quoins_ship_by |
varchar(25) |
NULL |
This field holds the Ship By |
No |
No |
|
quoins_delivery_point |
varchar(255) |
NULL |
This field holds the Delivery Point |
No |
No |
|
quoins_trans_shipment |
varchar(25) |
NULL |
This field holds the Trans Shipment Flag - Can take values ’Yes’ or ’No’ |
No |
No |
|
quoins_packaging_code |
varchar(25) |
NULL |
This field holds the Packaging Code |
No |
No |
|
quoins_ship_partial_flag |
varchar(5) |
NULL |
This field holds the Ship Partial Flag - Valid values are ’Yes’ and ’No’ |
No |
No |
|
quoins_shipping_payment |
varchar(25) |
NULL |
This field holds the Shipping Payment |
No |
No |
|
quoins_remarks |
varchar(255) |
NULL |
This field holds the Remarks |
No |
No |
|
QUOINS_PORT_OF_DESTN |
varchar(32) |
NULL |
This field holds the port of destination |
No |
No |
|
QUOINS_ADVANCE_TOL_PERC |
numeric(28,8) |
NULL |
This field holds the advance tolerance percent |
No |
No |
|
QUOINS_ADVANCE_PAYABLE |
numeric(28,8) |
NULL |
This field holds the advance payable amount |
No |
No |
|
QUOINS_ADVANCE_PERC_ON |
varchar(5) |
NULL |
This field holds the advance percent on BV - basic value TV - total value B - blank |
No |
No |
|
QUOINS_ADVANCE_PERC |
numeric(28,8) |
NULL |
This field holds the percentage to be applied on basic value or total value |
No |
No |
|
QUOINS_ADVANCE_PAYDATE |
datetime |
NULL |
This field holds the advance pay date |
No |
No |
|
QUOINS_ADVANCE_PAY_FLAG |
varchar(5) |
NULL |
This field holds the advance pay flag Y - Yes N - No |
No |
No |
|
QUOINS_WARR_BASIS |
varchar(5) |
NULL |
This field holds the warranty basis C - Calendar U - Usage BO - Both B - Blank |
No |
No |
|
QUOINS_WARRANTY |
varchar(5) |
NULL |
This field holds the warranty flag Y - yes N - No |
No |
No |
|
QUOINS_WARR_AGREEMENT |
varchar(5) |
NULL |
This field holds the warranty agreement |
No |
No |
|
|
|||||
|
Table Name quo_quoprm_parameter_details |
|
||||
|
|
|||||
|
Table Comment Meta data information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
quoprm_componentname |
varchar(80) |
NOT NULL |
This field holds the component name |
No |
No |
|
quoprm_paramcode |
varchar(5) |
NOT NULL |
This field holds the parameter code |
No |
No |
|
quoprm_paramtype |
varchar(25) |
NOT NULL |
This field holds the parameter type |
No |
No |
|
quoprm_paramcat |
varchar(10) |
NOT NULL |
This field holds the parameter category |
No |
No |
|
quoprm_langid |
numeric(10) |
NOT NULL |
This field holds the language id |
No |
No |
|
quoprm_param_desc |
varchar(80) |
NULL |
This field holds the parameter description |
No |
No |
|
quoprm_sortby |
numeric(10) |
NULL |
This field holds the sort by code |
No |
No |
|
quoprm_createddate |
datetime |
NULL |
This field holds the created date who created the record |
No |
No |
|
|
|||||
|
Table Name quo_quoptcd_quot_part_tcd |
|
||||
|
|
|||||
|
Table Comment This field holds the data of Item Level TCD Details of the quotation |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUOPTCD_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUOPTCD_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUOPTCD_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
QUOPTCD_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the TCD Line number of the quotation |
No |
No |
|
quoptcd_tcd_seq_no |
numeric(10) |
NOT NULL |
This field holds the TCD Sequence number for a part |
No |
No |
|
quoptcd_tcd_ou |
numeric(10) |
NOT NULL |
This field holds the TCD OU where TCD created |
No |
No |
|
quoptcd_tcd_code |
varchar(25) |
NOT NULL |
This field holds the TCD Code for the part |
No |
No |
|
quoptcd_tcd_variant |
|
NULL |
This field holds the TCD Variant for a part |
No |
No |
|
quoptcd_tcd_rate |
numeric(28,8) |
NULL |
This field holds the TCD Rate for a part |
No |
No |
|
quoptcd_tcd_amount |
numeric(28,8) |
NULL |
This field holds the TCD Amount |
No |
No |
|
quoptcd_currency |
varchar(5) |
NULL |
This field holds the stores the payment currency |
No |
No |
|
quoptcd_user_seqno |
numeric(10) |
NULL |
This field holds the user entered sequence number |
No |
No |
|
quoptcd_exchg_rate |
numeric(28,8) |
NULL |
This field holds the exchange rate between document currency and multiline currency |
No |
No |
|
|
|||||
|
Table Name quo_quoqat_quot_quality_att |
|
||||
|
|
|||||
|
Table Comment This table holds the data of Quality Attributes for each part of the quotation |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUOQAT_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUOQAT_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUOQAT_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
QUOQAT_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the Quality Attribute line number of the quotation |
No |
No |
|
quoqat_attribute_code |
varchar(18) |
NOT NULL |
This field holds the Attribute Code |
No |
No |
|
quoqat_attribute_ou |
numeric(10) |
NULL |
This field holds where the attribute was created |
No |
No |
|
quoqat_attribute_type |
varchar(5) |
NULL |
This field holds the Attribute Type |
No |
No |
|
quoqat_std_value |
numeric(28,8) |
NULL |
This field holds the Standard Value |
No |
No |
|
quoqat_minimum_value |
numeric(28,8) |
NULL |
This field holds the Minimum Value |
No |
No |
|
quoqat_maximum_value |
numeric(28,8) |
NULL |
This field holds the Maximum Value |
No |
No |
|
quoqat_trackable_flag |
varchar(5) |
NULL |
This field holds the Trackable Flag |
No |
No |
|
quoqat_remarks |
varchar(255) |
NULL |
This field holds the Remarks |
No |
No |
|
|
|||||
|
Table Name quo_quoqpb_quot_price_break |
|
||||
|
|
|||||
|
Table Comment This table holds the data of Quantity Price Break Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUOQPB_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUOQPB_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUOQPB_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
QUOQPB_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the price breakup line number of the quotation |
No |
No |
|
QUOQPB_SEQ_NO |
numeric(10) |
NOT NULL |
This field holds the sequence no for the price breaks for a quotation |
No |
No |
|
quoqpb_from_qty |
numeric(28,8) |
NOT NULL |
This field holds the From Quantity |
No |
No |
|
quoqpb_to_qty |
numeric(28,8) |
NULL |
This field holds the To Quantity |
No |
No |
|
quoqpb_cost |
numeric(28,8) |
NULL |
This field holds the cost |
No |
No |
|
|
|||||
|
Table Name quo_quosch_quot_schedule |
|
||||
|
|
|||||
|
Table Comment This table holds the data of Quotation Schedule Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUOSCH_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUOSCH_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUOSCH_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
QUOSCH_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the schedule detail line number of the quotation |
No |
No |
|
quosch_sch_no |
numeric(10) |
NOT NULL |
This field holds the schedule number |
No |
No |
|
quosch_sch_date |
datetime |
NULL |
This field holds the schedule date |
No |
No |
|
quosch_sch_qty |
numeric(28,8) |
NULL |
This field holds the schedule quantity |
No |
No |
|
|
|||||
|
Table Name quo_quousr_quot_user_det |
|
||||
|
|
|||||
|
Table Comment This table holds the data of RFQ -User Specific Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
QUOUSR_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Quotation is created |
No |
No |
|
QUOUSR_QUOT_NO |
varchar(40) |
NOT NULL |
This field holds the Quotation number |
No |
No |
|
QUOUSR_AMEND_NO |
varchar(40) |
NOT NULL |
This field holds the Amendment number of the quotation |
No |
No |
|
quousr_remarks |
varchar(255) |
NULL |
This field holds the remarks |
No |
No |
|
quousr_user_detail1 |
varchar(30) |
NULL |
This field holds the user defined detail 1 |
No |
No |
|
quousr_user_detail2 |
varchar(30) |
NULL |
This field holds the user defined detail 2 |
No |
No |
|
quousr_user_detail3 |
varchar(30) |
NULL |
This field holds the user defined detail 3 |
No |
No |
|
quousr_user_detail4 |
varchar(30) |
NULL |
This field holds the user defined detail 4 |
No |
No |
|
quousr_user_option1 |
varchar(30) |
NULL |
This field holds the user defined option 1 |
No |
No |
|
quousr_user_option2 |
varchar(30) |
NULL |
This field holds the user defined option 2 |
No |
No |
|
quousr_user_option3 |
varchar(30) |
NULL |
This field holds the user defined option 3 |
No |
No |
|
quousr_user_option4 |
varchar(30) |
NULL |
This field holds the user defined option 4 |
No |
No |
|
|
|||||
|
Table Name quo_rfqdet_rfq_item_details |
|
||||
|
|
|||||
|
Table Comment This table holds the data of RFQ Item Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
RFQDET_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Request for Quotation is created |
No |
No |
|
RFQDET_RFQ_NO |
varchar(40) |
NOT NULL |
This field holds the Request for Quotation number |
No |
No |
|
rfqdet_line_no |
numeric(10) |
NOT NULL |
This field holds the RFQ line number |
No |
No |
|
rfqdet_part_no |
varchar(40) |
NOT NULL |
This field holds the part number |
No |
No |
|
rfqdet_part_desc |
varchar(150) |
NULL |
This field holds the part description- Will be given if the part does not exist in Inventory |
No |
No |
|
rfqdet_part_type |
varchar(5) |
NULL |
This field holds the part type - types as defined in part admin |
No |
No |
|
rfqdet_part_condition |
varchar(5) |
NULL |
This field holds the part condition - "New", "New Surplus", "Overhauled" ,"Serviceable" |
No |
No |
|
rfqdet_required_qty |
numeric(20) |
NULL |
This field holds the required quantity |
No |
No |
|
rfqdet_uom |
varchar(10) |
NULL |
This field holds the UOM of the part |
No |
No |
|
rfqdet_sch_type |
varchar(5) |
NULL |
This field holds the schedule type - Can be Single or Multiple |
No |
No |
|
rfqdet_need_date |
datetime |
NULL |
This field holds the need date of the part |
No |
No |
|
rfqdet_ship_to |
numeric(10) |
NULL |
This field holds the ship to |
No |
No |
|
rfqdet_alternate_part_no |
varchar(40) |
NULL |
This field holds the Alternate Part Number - Allowed or Not Allowed |
No |
No |
|
rfqdet_quality_attribute |
varchar(5) |
NULL |
This field holds the Quality Attribute - ’None’, ’Standard’ or ’Customized’ |
No |
No |
|
rfqdet_certificate_type |
varchar(25) |
NULL |
This field holds the certificate type |
No |
No |
|
rfqdet_remarks |
varchar(255) |
NULL |
This field holds the remarks |
No |
No |
|
|
|||||
|
Table Name quo_rfqhdr_rfq_header |
|
||||
|
|
|||||
|
Table Comment Request For Quotation Header |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
rfqhdr_ouinstance |
numeric(10) |
NOT NULL |
This field holds the OU instance where RFQ created |
No |
No |
|
rfqhdr_rfq_no |
varchar(40) |
NOT NULL |
This field holds the RFQ Number |
No |
No |
|
rfqhdr_num_type_no |
varchar(5) |
NULL |
This field holds the Numbering type number used to generate the RFQ number |
No |
No |
|
rfqhdr_rfq_date |
datetime |
NULL |
This field holds the RFQ Date |
No |
No |
|
rfqhdr_status |
varchar(5) |
NULL |
This field holds the Status of the RFQ. - Can be in Draft,Fresh. confirmed, authorized and cancelled (D)Draft (F)Fresh (C)Cancelled (CN)Confirmed (A)Authorized (R)Rejected (UA)Under Amendment (AM)Amended (RE)Revised |
No |
No |
|
rfqhdr_reply_by_date |
datetime |
NULL |
This field holds the Reply By Date |
No |
No |
|
rfqhdr_buyer_group |
varchar(25) |
NULL |
This field holds the Buyer Group |
No |
No |
|
RFQHDR_BUYER_OU |
numeric(10) |
NULL |
This field holds the OU instance where the Buyer is created |
No |
No |
|
rfqhdr_rfq_category |
varchar(25) |
NULL |
This field holds the RFQ Category - Active codes as defined in the logistics common master |
No |
No |
|
rfqhdr_rfq_type |
varchar(5) |
NULL |
This field holds the RFQ Type -’ Competitive Bidding’ and ’Selective’ (C )Competitive Bidding (S) Selective’ |
No |
No |
|
rfqhdr_user_status |
varchar(25) |
NULL |
This field holds the User Status - codes in Active status, defined for the document RFQ, in the Logistics Common Master component |
No |
No |
|
rfqhdr_createddate |
datetime |
NULL |
This field holds the Created Date |
No |
No |
|
rfqhdr_created_by |
varchar(30) |
NULL |
This field holds the Created By |
No |
No |
|
rfqhdr_modifieddate |
datetime |
NULL |
This field holds the Last Modified Date |
No |
No |
|
rfqhdr_modified_by |
varchar(30) |
NULL |
This field holds the Last modified by |
No |
No |
|
rfqhdr_timestamp |
numeric(10) |
NULL |
This field holds the Timestamp |
No |
No |
|
rfqhdr_insurance_terms |
varchar(150) |
NULL |
This field holds the Insurance Terms |
No |
No |
|
rfqhdr_insurance_liability |
varchar(5) |
NULL |
This field holds the Insurance Liability |
No |
No |
|
rfqhdr_insurance_amount |
numeric(20,8) |
NULL |
This field holds the Insurance Amount |
No |
No |
|
rfqhdr_inco_term |
varchar(150) |
NULL |
This field holds the International Commercial Terms |
No |
No |
|
rfqhdr_ship_by |
varchar(25) |
NULL |
This field holds the Ship By |
No |
No |
|
rfqhdr_shipping_payment |
varchar(25) |
NULL |
This field holds the Shipping Payment |
No |
No |
|
rfqhdr_trans_shipment |
varchar(5) |
NULL |
This field holds the Trans Shipment - Valid values are ’Yes’ and ’No’ |
No |
No |
|
rfqhdr_packing_code |
varchar(25) |
NULL |
This field holds the Packaging code - Packaging Codes defined in the Logistics Common Master component |
No |
No |
|
rfqhdr_ship_partial_flag |
varchar(5) |
NULL |
This field holds the Ship Partial Flag - Valid values are ’Yes’ and ’No’ |
No |
No |
|
rfqhdr_remarks |
varchar(2000) |
NULL |
This field holds the Remarks |
No |
No |
|
rfqhdr_supp_code |
varchar(45) |
NULL |
This field holds the Supplier Code |
No |
No |
|
RFQHDR_ADDRESSID |
numeric(10) |
NULL |
This field holds the address id |
No |
No |
|
RFQHDR_CONTACT_PERSON |
varchar(80) |
NULL |
This field holds the contact person |
No |
No |
|
rfqhdr_base_rfq_no |
varchar(40) |
NULL |
This field holds the Base RFQ Number |
No |
No |
|
rfqhdr_supp_ou |
numeric(10) |
NULL |
This field holds the Supplier OU |
No |
No |
|
rfqhdr_running_no |
numeric(10) |
NULL |
This field holds the running number which was appended to the base RFQ to form the supplier RFQ |
No |
No |
|
RFQHDR_CANCEL_REMARKS |
varchar(2000) |
NULL |
This field holds the remarks for cancellation of the request for quotation |
No |
No |
|
|
|||||
|
Table Name quo_rfqpr_rfq_pr_coverage |
|
||||
|
|
|||||
|
Table Comment PR coverage Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
RFQPR_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Request for Quotation is created |
No |
No |
|
RFQPR_RFQ_NO |
varchar(40) |
NOT NULL |
This field holds the Request for Quotation number |
No |
No |
|
RFQPR_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the line number |
No |
No |
|
rfqpr_pr_no |
varchar(40) |
NOT NULL |
This field holds the PR Number |
No |
No |
|
rfqpr_pr_line_no |
numeric(10) |
NOT NULL |
This field holds the PR Line Number |
No |
No |
|
rfqpr_pr_qty |
numeric(20) |
NULL |
This field holds the PR Quantity |
No |
No |
|
rfqpr_pr_ou |
numeric(10) |
NULL |
This field holds the PR OU instance |
No |
No |
|
RFQPR_PR_SCH_NO |
numeric(10) |
NOT NULL |
This field holds the purchase request’s schedule no |
No |
No |
|
RFQPR_PR_SCH_DATE |
datetime |
NULL |
This field holds the schedule date of the purchase request |
No |
No |
|
|
|||||
|
Table Name quo_rfqqat_rfq_quality_att |
|
||||
|
|
|||||
|
Table Comment Quality Attributes for the Items in RFQ |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
RFQQAT_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Request for Quotation is created |
No |
No |
|
RFQQAT_RFQ_NO |
varchar(40) |
NOT NULL |
This field holds the Request for Quotation number |
No |
No |
|
RFQQAT_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the line number of the Request for quotation |
No |
No |
|
rfqqat_attribute_code |
varchar(10) |
NOT NULL |
This field holds the Attribute Code - Defined in Part Admin |
No |
No |
|
rfqqat_attribute_type |
varchar(5) |
NULL |
This field holds the Attribute Type - Quantitative or Qualitative |
No |
No |
|
rfqqat_std_value |
numeric(20) |
NULL |
This field holds the Standard Value |
No |
No |
|
rfqqat_minimum_value |
numeric(20) |
NULL |
This field holds the Minimum Value |
No |
No |
|
rfqqat_maximum_value |
numeric(20) |
NULL |
This field holds the Maximum Value |
No |
No |
|
rfqqat_std_qual_value |
varchar(88) |
NULL |
This field holds the Standard Qualitative Value if the attribute code is of type Qualitative |
No |
No |
|
rfqqat_trackable_flag |
varchar(5) |
NULL |
This field holds the Trackable Flag - Can be ’Yes’ or ’No’ (Y) Yes (N) No |
No |
No |
|
rfqqat_remarks |
varchar(255) |
NULL |
This field holds the Remarks |
No |
No |
|
RFQQAT_UOM |
varchar(40) |
NULL |
This field holds the unit of measurement |
No |
No |
|
|
|||||
|
Table Name quo_rfqsch_rfq_schedule |
|
||||
|
|
|||||
|
Table Comment This table holds the data of RFQ Schedule Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
RFQSCH_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Request for Quotation is created |
No |
No |
|
RFQSCH_RFQ_NO |
varchar(40) |
NOT NULL |
This field holds the Request for Quotation number |
No |
No |
|
RFQSCH_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the Schedule line number of the Request for quotation |
No |
No |
|
rfqsch_sch_no |
numeric(10) |
NOT NULL |
This field holds the Schedule number |
No |
No |
|
rfqsch_sch_date |
datetime |
NULL |
This field holds the Schedule Date |
No |
No |
|
rfqsch_sch_qty |
numeric(20) |
NULL |
This field holds the Schedule Quantity |
No |
No |
|
|
|||||
|
Table Name quo_rfqsup_rfq_supplier |
|
||||
|
|
|||||
|
Table Comment This table holds the data of Supplier Details for the RFQ |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
RFQSUP_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Request for Quotation is created |
No |
No |
|
RFQSUP_RFQ_NO |
varchar(40) |
NOT NULL |
This field holds the Request for Quotation number |
No |
No |
|
RFQSUP_LINE_NO |
decimal(10) |
NOT NULL |
This field holds the line number of the Request for quotation |
No |
No |
|
rfqsup_supp_code |
varchar(45) |
NOT NULL |
Supplier Code |
No |
No |
|
rfqsup_supp_ou |
numeric(10) |
NULL |
Supplier OU |
No |
No |
|
rfqsup_mode_flag |
varchar(5) |
NULL |
Design purpose - I indicates RFQ has to be generated for the supplier code given. U generates existing RFQ has to be appended |
No |
No |
|
RFQSUP_ADDRESSID |
numeric(10) |
NULL |
This field holds the address id |
No |
No |
|
RFQSUP_CONTACT_PERSON |
varchar(80) |
NULL |
This field holds the contact person |
No |
No |
|
|
|||||
|
Table Name quo_rfqusr_rfq_user_details |
|
||||
|
|
|||||
|
Table Comment This table holds the data of RFQ -User Specific Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
RFQUSR_OUINSTANCE |
decimal(10) |
NOT NULL |
This field holds the Organization Unit where the Request for Quotation is created |
No |
No |
|
RFQUSR_RFQ_NO |
varchar(40) |
NOT NULL |
This field holds the Request for Quotation number |
No |
No |
|
rfqusr_user_detail1 |
varchar(30) |
NULL |
This field holds the User Defined detail 1 |
No |
No |
|
rfqusr_user_detail2 |
varchar(30) |
NULL |
This field holds the User Defined detail 2 |
No |
No |
|
rfqusr_user_detail3 |
varchar(30) |
NULL |
This field holds the User Defined detail 3 |
No |
No |
|
rfqusr_user_detail4 |
varchar(30) |
NULL |
This field holds the User Defined detail 4 |
No |
No |
|
rfqusr_user_detail5 |
varchar(30) |
NULL |
This field holds the User Defined detail 5 |
No |
No |
|
rfqusr_user_option1 |
varchar(30) |
NULL |
This field holds the User Defined option 1 |
No |
No |
|
rfqusr_user_option2 |
varchar(30) |
NULL |
This field holds the User Defined option 2 |
No |
No |
|
rfqusr_user_option3 |
varchar(30) |
NULL |
This field holds the User Defined option 3 |
No |
No |
|
rfqusr_user_option4 |
varchar(30) |
NULL |
This field holds the User Defined option 4 |
No |
No |
|
rfqusr_user_option5 |
varchar(30) |
NULL |
This field holds the User Defined option 5 |
No |
No |
|
rfqusr_remarks |
varchar(255) |
NULL |
This field holds the Remarks |
No |
No |
|
|
|
|
|
|
|