Database Schema for

Data Dictionary -- RFQ

Srl. No.	Table Name	Comment
1	QUO_QUODET_QUOT_DETAIL	This table holds information regarding the parts that are processed in the quotation
2	QUO_QUODTCD_QUOT_DOC_TCD	This table holds the data of Document Level TCDs of the Quoation
3	QUO_QUOHDR_QUOT_HEADER	This table holds information about the quotations that are submitted to the supplier for processing
4	QUO_QUOINS_QUOT_TERMS_CONDS	Terms and Conditions specified by the supplier is stored here
5	QUO_QUOPRM_PARAMETER_DETAILS	Information of the codes and descriptions of various elements like quotation status, quotation type, price break etc. are stored here
6	QUO_QUOPTCD_QUOT_PART_TCD	This field holds the data of Item Level TCD Details of the quotation
7	QUO_QUOQAT_QUOT_QUALITY_ATT	This table holds the data of Quality Attributes for each part of the quotation
8	QUO_QUOQPB_QUOT_PRICE_BREAK	This table holds the data of Quantity Price Break Details
9	QUO_QUOSCH_QUOT_SCHEDULE	This table holds the data of Schedule Details of the quotation if only the schedule is selected as Multiple
10	QUO_QUOUSR_QUOT_USER_DET	This table holds the data of User Specific Details of the quotations
11	QUO_RFQDET_RFQ_ITEM_DETAILS	Parts that are processed as part of a request are stored in this table
12	QUO_RFQHDR_RFQ_HEADER	This table holds the requests received from the suppliers
13	QUO_RFQPR_RFQ_PR_COVERAGE	This table holds the details of the Purchase requests that are processed as part of a particular request
14	QUO_RFQQAT_RFQ_QUALITY_ATT	Quality Attributes for the Items in the request are stored in this table
15	QUO_RFQSCH_RFQ_SCHEDULE	This table holds the data of RFQ Schedule Details
16	QUO_RFQSUP_RFQ_SUPPLIER	Information about the supplier to whom the requests will be submitted will be stored here
17	QUO_RFQUSR_RFQ_USER_DETAILS	This table holds the data of User Specific Details of the request


Table Name :	QUO_QUODET_QUOT_DETAIL
Comment :	This table holds information regarding the parts that are processed in the quotation


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUODET_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUODET_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUODET_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUODET_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line number of the multiline	No
QUODET_RFQ_LINE_NO	_decimal_10_0	decimal(10)	Yes	This field holds the RFQ line number	No
QUODET_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the part number	No
QUODET_PART_DESC	_varchar_150	varchar(150)	Yes	This field holds the part description of the part	No
QUODET_PART_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Part Type as defined in Part Admin	No
QUODET_PART_CONDITION	_varchar_5	varchar(5)	Yes	This field holds the Part Condition New , New Surplus , Overhauled , Servicable	No
QUODET_QUOTED_PART	_varchar_40	varchar(40)	Yes	This field holds the Quoted Part Number	No
QUODET_QUOTED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Quoted Quanity	No
QUODET_QUOTED_UOM	_varchar_10	varchar(10)	Yes	This field holds the Quoted UOM	No
QUODET_COST	_decimal_28_8	decimal(28)	Yes	This field holds the Cost for the quanity cost_per	No
QUODET_COST_PER	_decimal_28_8	decimal(28)	Yes	This field holds the Quantity for which cost is specified	No
QUODET_QTY_PRICE_BREAK	_varchar_5	varchar(5)	Yes	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
QUODET_SCH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Schedule Type Can be Single or Multiple	No
QUODET_NEED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Need Date	No
QUODET_SHIP_TO	_decimal_10_0	decimal(10)	Yes	This field holds the Ship To	No
QUODET_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This field holds the Qualtity Attribute Valid values are Yes and No .This is set as Yes if qualtity attributes are defined for the Item	No
QUODET_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Certificate Type Values as defined for Parts in the Logistics Common Master which are in Active status	No
QUODET_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks for the part	No
QUODET_PART_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Part OU in which part created	No
QUODET_LEAD_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the lead time	No
QUODET_LEAD_TIME_UOM	_varchar_5	varchar(5)	Yes	This field holds the lead time UOM	No
QUODET_AUTH_STATUS	_varchar_5	varchar(5)	Yes	This field holds the ttem level authorization status	No
QUODET_BASE_CURR_COST	_decimal_28_8	decimal(28)	Yes	This field holds the value of the part cost in base currency	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUODTCD_QUOT_DOC_TCD
Comment :	This table holds the data of Document Level TCDs of the Quoation


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUODTCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUODTCD_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUODTCD_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUODTCD_TCD_SEQ_NO	_decimal_10_0	decimal(10)	No	This field holds the TCD Sequence number	No
QUODTCD_TCD_OU	_decimal_10_0	decimal(10)	Yes	This field holds the TCD Ouinstance	No
QUODTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the TCD Code	No
QUODTCD_TCD_VARIANT	_varchar_25	Varchar(25)	Yes	This field holds the TCD Variant	No
QUODTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Rate	No
QUODTCD_SUPP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Supplier OU	No
QUODTCD_PAY_TO_SUPP	udd_vendorcode	varchar(45)	Yes	This field holds the Pay to Supplier Code	No
QUODTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Amount	No
QUODTCD_CURRENCY	_varchar_5	varchar(5)	Yes	This field holds the stores the payment currency	No
QUODTCD_USER_SEQNO	_decimal_10_0	decimal(10)	Yes	stores the user entered sequence number	No
QUODTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	stores the exchanges rate between document currency and the multiline currency	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOHDR_QUOT_HEADER
Comment :	This table holds information about the quotations that are submitted to the supplier for processing


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance where the document created	No
QUOHDR_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the quotation number	No
QUOHDR_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the quotation amendment no	No
QUOHDR_RFQ_NO	_varchar_40	varchar(40)	Yes	This field holds the RFQ Number	No
QUOHDR_SUPP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Supplier OU	No
QUOHDR_SUPP_CODE	_varchar_45	varchar(45)	Yes	This field holds the Supplier Code	No
QUOHDR_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	This field holds the numbering type number used for quotation generation	No
QUOHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the User Status List of Active user defined status in common master	No
QUOHDR_STATUS	_varchar_5	varchar(5)	Yes	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	No
QUOHDR_BUYER_GROUP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the buyer group OU	No
QUOHDR_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field holds the Buyer Group	No
QUOHDR_QUOT_DATE	_datetime_8	datetime(8)	Yes	This field holds the Quotation Date	No
QUOHDR_QUOT_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Quotation Type Price List and Normal N Normal PL Price List	No
QUOHDR_SUPP_OFFER_NO	_varchar_40	varchar(40)	Yes	This field holds the Supplier offer number	No
QUOHDR_QUOT_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the Quotation Category list of categories in Active status, defined for the document Quotation, in the Logistics Common Master component	No
QUOHDR_SUPP_OFFER_DATE	_datetime_8	datetime(8)	Yes	This field holds the Supplier Offer Date	No
QUOHDR_RECEIVED_DATE	_datetime_8	datetime(8)	Yes	This field holds the Received Date	No
QUOHDR_PRICE_HELD_FIRM_TIME	_decimal_28_8	decimal(28)	Yes	This field holds the Price held firm time	No
QUOHDR_TIME_UOM	_varchar_5	varchar(5)	Yes	This field holds the Time UOM M Months D Days W Weeks	No
QUOHDR_CURRENCY	_varchar_20	varchar(20)	Yes	This field holds the Currency of the document	No
QUOHDR_EFFECTIVE_TO	_datetime_8	datetime(8)	Yes	This field holds the Effective To	No
QUOHDR_EXCHANGE_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the Exchange Rate	No
QUOHDR_RFQ_DATE	_datetime_8	datetime(8)	Yes	This field holds the request for quotation date	No
QUOHDR_ACTIVE_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Y indicates that this is the latest amendment Y Yes	No
QUOHDR_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Created Date	No
QUOHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the Created By	No
QUOHDR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Last Modified Date	No
QUOHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the Last Modified By	No
QUOHDR_APPROVEDDATE	_datetime_8	datetime(8)	Yes	This field holds the date when the quotation ws approved	No
QUOHDR_APPROVED_BY	_varchar_30	varchar(30)	Yes	This field holds the user name of the approver	No
QUOHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp so that more than one user cant modified same record in the same time	No
QUOHDR_REMARKS	_varchar_2000	varchar(2000)	Yes	This field holds the remarks entered for the quotation	No
QUOHDR_ADDRESSID	_decimal_10_0	decimal(10)	Yes	This field holds the address id	No
QUOHDR_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	This field holds the contact person	No
QUOHDR_LATEST_AMD_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Stores the latest amend flag. Values allowed : Y Yes N No	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOINS_QUOT_TERMS_CONDS
Comment :	Terms and Conditions specified by the supplier is stored here


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOINS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Quotation terms and condition OU	No
QUOINS_QUOT_NO	_varchar_40	varchar(40)	No	Quotation terms and condition Number	No
QUOINS_AMEND_NO	_varchar_40	varchar(40)	No	Quotation terms and condition amendment Number	No
QUOINS_PAYTERM	_varchar_25	Varchar(25)	Yes	This field holds the payterm selected for the document	No
QUOINS_PAYMENT_MODE	_varchar_25	Varchar(25)	Yes	This field holds the payterm mode	No
QUOINS_PAYTO_SUPPLIER	_varchar_45	varchar(45)	Yes	This field holds the Pay to supplier	No
QUOINS_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	This field holds the Insurance terms	No
QUOINS_INSURANCE_LIABILITY	_varchar_25	Varchar(25)	Yes	This field holds the Insurance Liability SLF Self SUP Supplier N None	No
QUOINS_INSURANCE_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds the Insurance Amount	No
QUOINS_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the INCO Term	No
QUOINS_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the Ship By	No
QUOINS_DELIVERY_POINT	_varchar_255	varchar(255)	Yes	This field holds the Delivery Point	No
QUOINS_TRANS_SHIPMENT	_varchar_25	Varchar(25)	Yes	This field holds the Trans Shipment Flag Can take values Yes or No	No
QUOINS_PACKAGING_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Packaging Code	No
QUOINS_SHIP_PARTIAL_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Ship Partial Flag Valid values are Yes and No	No
QUOINS_SHIPPING_PAYMENT	_varchar_25	Varchar(25)	Yes	This field holds the Shipping Payment	No
QUOINS_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
QUOINS_PORT_OF_DESTN	_varchar_32	varchar(32)	Yes	This field holds the port of destination	No
QUOINS_ADVANCE_TOL_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the advance tolerance percent	No
QUOINS_ADVANCE_PAYABLE	_decimal_28_8	decimal(28)	Yes	This field holds the advance payable amount	No
QUOINS_ADVANCE_PERC_ON	_varchar_5	varchar(5)	Yes	This field holds the advance percent on BV basic value TV total value B blank	No
QUOINS_ADVANCE_PERC	_decimal_28_8	decimal(28)	Yes	This field holds the percentage to be applied on basic value or total value	No
QUOINS_ADVANCE_PAYDATE	_datetime_8	datetime(8)	Yes	This field holds the advance pay date	No
QUOINS_ADVANCE_PAY_FLAG	_varchar_5	varchar(5)	Yes	This field holds the advance pay flag Y Yes N No	No
QUOINS_WARR_BASIS	_varchar_5	varchar(5)	Yes	This field holds the warranty basis C Calendar U Usage BO Both B Blank	No
QUOINS_WARRANTY	_varchar_5	varchar(5)	Yes	This field holds the warranty flag Y yes N No	No
QUOINS_WARR_AGREEMENT	_varchar_5	varchar(5)	Yes	This field holds the warranty agreement	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOPRM_PARAMETER_DETAILS
Comment :	Information of the codes and descriptions of various elements like quotation status, quotation type, price break etc. are stored here


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	This field holds the component name	No
QUOPRM_PARAMCODE	_varchar_5	varchar(5)	No	This field holds the parameter code	No
QUOPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	This field holds the parameter type	No
QUOPRM_PARAMCAT	_varchar_10	varchar(10)	No	This field holds the parameter category	No
QUOPRM_LANGID	_decimal_10_0	decimal(10)	No	This field holds the language id	No
QUOPRM_PARAM_DESC	_varchar_80	varchar(80)	Yes	This field holds the parameter description	No
QUOPRM_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the sort by code	No
QUOPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date who created the record	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOPTCD_QUOT_PART_TCD
Comment :	This field holds the data of Item Level TCD Details of the quotation


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOPTCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUOPTCD_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUOPTCD_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUOPTCD_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the TCD Line number of the quotation	No
QUOPTCD_TCD_SEQ_NO	_decimal_10_0	decimal(10)	No	This field holds the TCD Sequence number for a part	No
QUOPTCD_TCD_OU	_decimal_10_0	decimal(10)	No	This field holds the TCD OU where TCD created	No
QUOPTCD_TCD_CODE	_varchar_25	Varchar(25)	No	This field holds the TCD Code for the part	No
QUOPTCD_TCD_VARIANT	_varchar_25	Varchar(25)	Yes	This field holds the TCD Variant for a part	No
QUOPTCD_TCD_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Rate for a part	No
QUOPTCD_TCD_AMOUNT	_decimal_28_8	decimal(28)	Yes	This field holds the TCD Amount	No
QUOPTCD_CURRENCY	_varchar_5	varchar(5)	Yes	This field holds the stores the payment currency	No
QUOPTCD_USER_SEQNO	_decimal_10_0	decimal(10)	Yes	This field holds the user entered sequence number	No
QUOPTCD_EXCHG_RATE	_decimal_28_8	decimal(28)	Yes	This field holds the exchange rate between dcoument currency and multiline currency	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOQAT_QUOT_QUALITY_ATT
Comment :	This table holds the data of Quality Attributes for each part of the quotation


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOQAT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUOQAT_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUOQAT_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUOQAT_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Quality Attribute line number of the quotation	No
QUOQAT_ATTRIBUTE_CODE	_varchar_18	varchar(18)	No	This field holds the Attribute Code	No
QUOQAT_ATTRIBUTE_OU	_decimal_10_0	decimal(10)	Yes	This field holds where the attribute was created	No
QUOQAT_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Attribute Type	No
QUOQAT_STD_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Standard Value	No
QUOQAT_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Minimum Value	No
QUOQAT_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Maximum Value	No
QUOQAT_TRACKABLE_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Trackable Flag	No
QUOQAT_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOQPB_QUOT_PRICE_BREAK
Comment :	This table holds the data of Quantity Price Break Details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOQPB_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUOQPB_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUOQPB_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUOQPB_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the price breakup line number of the quotation	No
QUOQPB_SEQ_NO	_decimal_10_0	decimal(10)	No	This field holds the sequence no for the price breaks for a quotation	No
QUOQPB_FROM_QTY	_decimal_28_8	decimal(28)	No	This field holds the From Quantity	No
QUOQPB_TO_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the To Quantity	No
QUOQPB_COST	_decimal_28_8	decimal(28)	Yes	This field holds the cost	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOSCH_QUOT_SCHEDULE
Comment :	This table holds the data of Schedule Details of the quotation if only the schedule is selected as Multiple


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOSCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUOSCH_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUOSCH_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUOSCH_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the schedule detail line number of the quotation	No
QUOSCH_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the schedule number	No
QUOSCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field holds the schedule date	No
QUOSCH_SCH_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the schedule quantity	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_QUOUSR_QUOT_USER_DET
Comment :	This table holds the data of User Specific Details of the quotations


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
QUOUSR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Quotation is created	No
QUOUSR_QUOT_NO	_varchar_40	varchar(40)	No	This field holds the Quotation number	No
QUOUSR_AMEND_NO	_varchar_40	varchar(40)	No	This field holds the Amendment number of the quotation	No
QUOUSR_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks	No
QUOUSR_USER_DETAIL1	_varchar_30	varchar(30)	Yes	This field holds the user defined detail 1	No
QUOUSR_USER_DETAIL2	_varchar_30	varchar(30)	Yes	This field holds the user defined detail 2	No
QUOUSR_USER_DETAIL3	_varchar_30	varchar(30)	Yes	This field holds the user defined detail 3	No
QUOUSR_USER_DETAIL4	_varchar_30	varchar(30)	Yes	This field holds the user defined detail 4	No
QUOUSR_USER_OPTION1	_varchar_30	varchar(30)	Yes	This field holds the user defined option 1	No
QUOUSR_USER_OPTION2	_varchar_30	varchar(30)	Yes	This field holds the user defined option 2	No
QUOUSR_USER_OPTION3	_varchar_30	varchar(30)	Yes	This field holds the user defined option 3	No
QUOUSR_USER_OPTION4	_varchar_30	varchar(30)	Yes	This field holds the user defined option 4	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQDET_RFQ_ITEM_DETAILS
Comment :	Parts that are processed as part of a request are stored in this table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQDET_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Request for Quotation is created	No
RFQDET_RFQ_NO	_varchar_40	varchar(40)	No	This field holds the Request for Quotation number	No
RFQDET_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the RFQ line number	No
RFQDET_PART_NO	_varchar_40	varchar(40)	No	This field holds the part number	No
RFQDET_PART_DESC	_varchar_150	varchar(150)	Yes	This field holds the part description Will be given if the part does not exist in Inventory	No
RFQDET_PART_TYPE	_varchar_5	varchar(5)	Yes	This field holds the part type types as defined in part admin	No
RFQDET_PART_CONDITION	_varchar_5	varchar(5)	Yes	This field holds the part condition New , New Surplus , Overhauled , Servicable	No
RFQDET_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the required quantity	No
RFQDET_UOM	_varchar_10	varchar(10)	Yes	This field holds the UOM of the part	No
RFQDET_SCH_TYPE	_varchar_5	varchar(5)	Yes	This field holds the schedule type Can be Single or Mutiple	No
RFQDET_NEED_DATE	_datetime_8	datetime(8)	Yes	This field holds the need date of the part	No
RFQDET_SHIP_TO	_decimal_10_0	decimal(10)	Yes	This field holds the ship to	No
RFQDET_ALTERNATE_PART_NO	_varchar_40	varchar(40)	Yes	This field holds the Alternate Part Number Allowed or Not Allowed	No
RFQDET_QUALITY_ATTRIBUTE	_varchar_5	varchar(5)	Yes	This field holds the Quality Attribute None , Standard or Customized	No
RFQDET_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the certificate type	No
RFQDET_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQHDR_RFQ_HEADER
Comment :	This table holds the requests received from the suppliers


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Ouinstance where RFQ created	No
RFQHDR_RFQ_NO	_varchar_40	varchar(40)	No	This field holds the RFQ Number	No
RFQHDR_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	This field holds the Numbering type number used to generate the RFQ number	No
RFQHDR_RFQ_DATE	_datetime_8	datetime(8)	Yes	This field holds the RFQ Date	No
RFQHDR_STATUS	_varchar_5	varchar(5)	Yes	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
RFQHDR_REPLY_BY_DATE	_datetime_8	datetime(8)	Yes	This field holds the Reply By Date	No
RFQHDR_BUYER_GROUP	_varchar_25	Varchar(25)	Yes	This field holds the Buyer Group	No
RFQHDR_BUYER_OU	_decimal_10_0	decimal(10)	Yes	This field holds the OU instance where the Buyer is created	No
RFQHDR_RFQ_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the RFQ Category Active codes as defined in the logistics common master	No
RFQHDR_RFQ_TYPE	_varchar_5	varchar(5)	Yes	This field holds the RFQ Type Competitive Bidding and Selective C Competitive Bidding S Selective	No
RFQHDR_USER_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the User Status codes in Active status, defined for the document RFQ, in the Logistics Common Master component	No
RFQHDR_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Created Date	No
RFQHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the Created By	No
RFQHDR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the Last Modified Date	No
RFQHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the Last modified by	No
RFQHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the Timestamp	No
RFQHDR_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	This field holds the Insurance Terms	No
RFQHDR_INSURANCE_LIABILITY	_varchar_5	varchar(5)	Yes	This field holds the Insurance Liability	No
RFQHDR_INSURANCE_AMOUNT	_decimal_20_8	decimal(20)	Yes	This field holds the Insurance Amount	No
RFQHDR_INCO_TERM	_varchar_150	varchar(150)	Yes	This field holds the International Commercial Terms	No
RFQHDR_SHIP_BY	_varchar_25	Varchar(25)	Yes	This field holds the Ship By	No
RFQHDR_SHIPPING_PAYMENT	_varchar_25	Varchar(25)	Yes	This field holds the Shipping Payment	No
RFQHDR_TRANS_SHIPMENT	_varchar_5	varchar(5)	Yes	This field holds the Trans Shipment Valid values are Yes and No	No
RFQHDR_PACKING_CODE	_varchar_25	Varchar(25)	Yes	This field holds the Packaging code Packaging Codes defined in the Logistics Common Master component	No
RFQHDR_SHIP_PARTIAL_FLAG	_varchar_5	varchar(5)	Yes	This field holds the Ship Partial Flag Valid values are Yes and No	No
RFQHDR_REMARKS	_varchar_2000	varchar(2000)	Yes	This field holds the Remarks	No
RFQHDR_SUPP_CODE	_varchar_45	varchar(45)	Yes	This field holds the Supplier Code	No
RFQHDR_ADDRESSID	_decimal_10_0	decimal(10)	Yes	This field holds the address id	No
RFQHDR_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	This field holds the contact person	No
RFQHDR_BASE_RFQ_NO	_varchar_40	varchar(40)	Yes	This field holds the Base RFQ Number	No
RFQHDR_SUPP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the OU instance in which the supplier was created	No
RFQHDR_RUNNING_NO	_decimal_10_0	decimal(10)	Yes	This field holds the running number which was appended to the base RFQ to form the supplier RFQ	No
RFQHDR_CANCEL_REMARKS	_varchar_2000	varchar(2000)	Yes	This field holds the remarks for cancellation of the request for quotation	No
RFQHDR_RFQPRIORITY	udd_txt20	varchar(20)	Yes	This field holds the RFQ Priority number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQPR_RFQ_PR_COVERAGE
Comment :	This table holds the details of the Purchase requests that are processed as part of a particular request


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQPR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Request for Quotation is created	No
RFQPR_RFQ_NO	_varchar_40	varchar(40)	No	This field holds the Request for Quotation number	No
RFQPR_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line number	No
RFQPR_PR_NO	_varchar_40	varchar(40)	No	This field holds the PR Number	No
RFQPR_PR_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the PR Line Number	No
RFQPR_PR_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the PR Quantity	No
RFQPR_PR_OU	_decimal_10_0	decimal(10)	Yes	This field holds the PR OUinstance	No
RFQPR_PR_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the purchase request s schedule no	No
RFQPR_PR_SCH_DATE	_datetime_8	datetime(8)	Yes	This field holds the schedule date of the purchase request	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQQAT_RFQ_QUALITY_ATT
Comment :	Quality Attributes for the Items in the request are stored in this table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQQAT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Requst for Quotation quality attributes OU	No
RFQQAT_RFQ_NO	_varchar_40	varchar(40)	No	Requst for Quotation quality attributes RFQ No	No
RFQQAT_LINE_NO	_decimal_10_0	decimal(10)	No	Requst for Quotation quality attributes RFQ Line No	No
RFQQAT_ATTRIBUTE_CODE	_varchar_10	varchar(10)	No	This field holds the Attribute Code Defined in Part Admin	No
RFQQAT_ATTRIBUTE_TYPE	_varchar_5	varchar(5)	Yes	This field holds the Attribute Type Quantitative or Qualitative	No
RFQQAT_STD_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Standard Value	No
RFQQAT_MINIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Minimum Value	No
RFQQAT_MAXIMUM_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the Maximum Value	No
RFQQAT_STD_QUAL_VALUE	_varchar_88	varchar(88)	Yes	This field holds the Standard Qualitative Value if the attribute code is of type Qualitative	No
RFQQAT_TRACKABLE_FLAG	_varchar_5	varchar(5)	Yes	This field holds theTrackable Flag Can be Yes or No Y Yes N No	No
RFQQAT_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
RFQQAT_UOM	_varchar_40	varchar(40)	Yes	This field holds the unit of measurement	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQSCH_RFQ_SCHEDULE
Comment :	This table holds the data of RFQ Schedule Details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQSCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Request for Quotation is created	No
RFQSCH_RFQ_NO	_varchar_40	varchar(40)	No	This field holds the Request for Quotation number	No
RFQSCH_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Schedule line number of the Request for quotation	No
RFQSCH_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the Schedule number	No
RFQSCH_SCH_DATE	_datetime_8	datetime(8)	Yes	This field holds the Schedule Date	No
RFQSCH_SCH_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Schedule Quantity	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQSUP_RFQ_SUPPLIER
Comment :	Information about the supplier to whom the requests will be submitted will be stored here


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQSUP_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Request for Quotation is created	No
RFQSUP_RFQ_NO	_varchar_40	varchar(40)	No	This field holds the Request for Quotation number	No
RFQSUP_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the line number of the Request for quotation	No
RFQSUP_SUPP_CODE	_varchar_45	varchar(45)	No	This field holds the supplier code of the request for quotation	No
RFQSUP_SUPP_OU	_decimal_10_0	decimal(10)	Yes	This field holds the OU instance in which the supplier was created	No
RFQSUP_MODE_FLAG	_varchar_5	varchar(5)	Yes	Design purpose I indicates RFQ has to be generated for the supplier code given.U generates existing RFQ has to be appended	No
RFQSUP_ADDRESSID	_decimal_10_0	decimal(10)	Yes	This field holds the address id	No
RFQSUP_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	This field holds the contact person	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes


Table Name :	QUO_RFQUSR_RFQ_USER_DETAILS
Comment :	This table holds the data of User Specific Details of the request


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RFQUSR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation Unit where the Request for Quotation is created	No
RFQUSR_RFQ_NO	_varchar_40	varchar(40)	No	This field holds the Request for Quotation number	No
RFQUSR_USER_DETAIL1	_varchar_30	varchar(30)	Yes	This field holds the User Defined detail 1	No
RFQUSR_USER_DETAIL2	_varchar_30	varchar(30)	Yes	This field holds the User Defined detail 2	No
RFQUSR_USER_DETAIL3	_varchar_30	varchar(30)	Yes	This field holds the User Defined detail 3	No
RFQUSR_USER_DETAIL4	_varchar_30	varchar(30)	Yes	This field holds the User Defined detail 4	No
RFQUSR_USER_DETAIL5	_varchar_30	varchar(30)	Yes	This field holds the User Defined detail 5	No
RFQUSR_USER_OPTION1	_varchar_30	varchar(30)	Yes	This field holds the User Defined option 1	No
RFQUSR_USER_OPTION2	_varchar_30	varchar(30)	Yes	This field holds the User Defined option 2	No
RFQUSR_USER_OPTION3	_varchar_30	varchar(30)	Yes	This field holds the User Defined option 3	No
RFQUSR_USER_OPTION4	_varchar_30	varchar(30)	Yes	This field holds the User Defined option 4	No
RFQUSR_USER_OPTION5	_varchar_30	varchar(30)	Yes	This field holds the User Defined option 5	No
RFQUSR_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes