View idempiere9.adempiere.c_rfqresponseline_v
C_RfQResponseLine_v

 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
c_rfqresponse_id numeric 10  √  null Request for Quotation Response from a potential Vendor
c_rfqresponseline_id numeric 10  √  null Request for Quotation Response Line
c_rfqline_id numeric 10  √  null Request for Quotation Line
c_rfqresponselineqty_id numeric 10  √  null Request for Quotation Response Line Quantity
c_rfqlineqty_id numeric 10  √  null Request for Quotation Line Quantity
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ad_language varchar 6  √  null Language for this entity
line numeric 10  √  null Unique line for this document
m_product_id numeric 10  √  null Product, Service, Item
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
name text 2147483647  √  null Alphanumeric identifier of the entity
description varchar 2147483647  √  null Optional short description of the record
documentnote varchar 2000  √  null Additional information for a Document
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
productvalue varchar 40  √  null Key of the Product
help varchar 2000  √  null Comment or Hint
dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
deliverydays numeric 10  √  null Number of Days (planned) until Delivery
c_uom_id numeric 10  √  null Unit of Measure
uomsymbol varchar 10  √  null Symbol for a Unit of Measure
benchmarkprice numeric 0  √  null Price to compare responses to
qty numeric 0  √  null Quantity
price numeric 0  √  null Price
discount numeric 0  √  null Discount in percent

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