View idempiere9.adempiere.rv_c_rfq_unanswered
RfQ UnAnswered

 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
name varchar 60  √  null Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_rfq_topic_id numeric 10  √  null Topic for Request for Quotations
quotetype bpchar 1  √  null Request for Quotation Type
isquotetotalamt bpchar 1  √  null The response can have just the total amount for the RfQ
isquoteallqty bpchar 1  √  null Suppliers are requested to provide responses for all quantities
c_currency_id numeric 10  √  null The Currency for this record
dateresponse timestamp 29,6  √  null Date of the Response
isrfqresponseaccepted bpchar 1  √  null Are Responses to the Request for Quotation accepted
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
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

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