Table idempiere9.adempiere.c_rfq
Request for Quotation

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_rfq_id numeric 10
c_rfqline.c_rfq_id crfq_crfqline C
c_rfqresponse.c_rfq_id crfq_crfqresponse C
Request for Quotation
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
c_rfq_topic_id numeric 10
c_rfq_topic.c_rfq_topic_id crfqtopic_crfq R
Topic for Request for Quotations
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_crfq R
The Currency for this record
dateresponse timestamp 29,6 Date of the Response
isrfqresponseaccepted bpchar 1 'Y'::bpchar Are Responses to the Request for Quotation accepted
dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
deliverydays numeric 10  √  0 Number of Days (planned) until Delivery
dateworkcomplete timestamp 29,6  √  null Date when work is (planned to be) complete
quotetype bpchar 1 Request for Quotation Type
isquotetotalamt bpchar 1 'N'::bpchar The response can have just the total amount for the RfQ
isquoteallqty bpchar 1 'Y'::bpchar Suppliers are requested to provide responses for all quantities
isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
isinvitedvendorsonly bpchar 1 'N'::bpchar Only invited vendors can respond to an RfQ
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_crfq R
Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbplocation_crfq R
Identifies the (ship to) address for this Business Partner
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_crfq R
User within the system - Internal or Business Partner Contact
salesrep_id numeric 10
ad_user.ad_user_id adusersalesrep_crfq R
Sales Representative or Company Agent
margin numeric 0  √  null Margin for a product as a percentage
createso bpchar 1  √  null Create SO
createpo bpchar 1  √  null Create Purchase Order
publishrfq bpchar 1  √  null Publish RfQ
c_order_id numeric 10  √  null
c_order.c_order_id corder_crfq R
Order
copylines bpchar 1  √  null Copy Lines
rankrfq bpchar 1  √  null Rank RfQ
processing bpchar 1  √  null Process Now
processed bpchar 1 'N'::bpchar The document has been processed
documentno varchar 30 '.'::character varying Document sequence number of the document
c_rfq_uu varchar 36  √  NULL::character varying C_RfQ_UU

Table contained 1 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_rfq_id Primary key Asc c_rfq_pkey
c_rfq_uu Must be unique Asc c_rfq_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.