View idempiere9.adempiere.rv_c_rfqresponse
RfQ Response

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
c_rfq_id numeric 10  √  null Request for Quotation
c_rfq_topic_id numeric 10  √  null Topic for Request for Quotations
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_rfqresponse_id numeric 10  √  null Request for Quotation Response from a potential Vendor
c_currency_id numeric 10  √  null The Currency for this record
dateresponse timestamp 29,6  √  null Date of the Response
dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
deliverydays numeric 10  √  null Number of Days (planned) until Delivery
dateworkcomplete timestamp 29,6  √  null Date when work is (planned to be) complete
price numeric 0  √  null Price
ranking numeric 10  √  null Relative Rank Number
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
m_product_id numeric 10  √  null Product, Service, Item
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
line numeric 10  √  null Unique line for this document
linedateworkstart timestamp 29,6  √  null Date when line work is (planned to be) started
linedeliverydays numeric 10  √  null Line Delivery Days
linedateworkcomplete timestamp 29,6  √  null Date when line work is (planned to be) complete
linedescription varchar 255  √  null Description of the Line
linehelp varchar 2000  √  null Line Help/Comment
c_uom_id numeric 10  √  null Unit of Measure
qty numeric 0  √  null Quantity
benchmarkprice numeric 0  √  null Price to compare responses to
benchmarkdifference numeric 0  √  null Difference between Response Price and Benchmark Price
qtyprice numeric 0  √  null Quantity Price
discount numeric 0  √  null Discount in percent
qtyranking numeric 10  √  null Quantity Ranking

Analyzed at 2021-12-25 14:43 +0100