View idempiere9.adempiere.c_rfqresponse_v
C_RfQResponse_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_rfq_id numeric 10  √  null Request for Quotation
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
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
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
c_currency_id numeric 10  √  null The Currency for this record
iso_code bpchar 3  √  null Three letter ISO 4217 Code of the Currency
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
c_bpartner_id numeric 10  √  null Identifies a Business Partner
bpname varchar 120  √  null BP Name
bpname2 varchar 60  √  null BP Name2
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_location_id numeric 10  √  null Location or Address
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
title varchar 40  √  null Name this entity is referred to as
phone varchar 40  √  null Identifies a telephone number
contactname text 2147483647  √  null Business Partner Contact Name

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