View idempiere9.adempiere.rv_bpartner
BPartner

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
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
c_bpartner_id numeric 10  √  null Identifies a Business Partner
value varchar 40  √  null Search key for the record in the format required - must be unique
name varchar 120  √  null Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
description varchar 255  √  null Optional short description of the record
issummary bpchar 1  √  null This is a summary entity
c_bp_group_id numeric 10  √  null Business Partner Group
isonetime bpchar 1  √  null One time transaction
isprospect bpchar 1  √  null Indicates this is a Prospect
isvendor bpchar 1  √  null Indicates if this Business Partner is a Vendor
iscustomer bpchar 1  √  null Indicates if this Business Partner is a Customer
isemployee bpchar 1  √  null Indicates if this Business Partner is an employee
issalesrep bpchar 1  √  null Indicates if the business partner is a sales representative or company agent
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
duns varchar 11  √  null Dun & Bradstreet Number
url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_language varchar 6  √  null Language for this entity
taxid varchar 20  √  null Tax Identification
istaxexempt bpchar 1  √  null Business partner is exempt from tax on sales
c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
rating bpchar 1  √  null Classification or Importance
salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
numberemployees numeric 10  √  null Number of employees
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
firstsale timestamp 29,6  √  null Date of First Sale
acqusitioncost numeric 0  √  null The cost of gaining the prospect as a customer
potentiallifetimevalue numeric 0  √  null Total Revenue expected
actuallifetimevalue numeric 0  √  null Actual Life Time Revenue
shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
paymentrule bpchar 1  √  null How you pay the invoice
so_creditlimit numeric 0  √  null Total outstanding invoice amounts allowed
so_creditused numeric 0  √  null Current open balance
so_creditavailable numeric 0  √  null Available Credit based on Credit Limit (not Total Open Balance) and Credit Used
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
so_description varchar 255  √  null Description to be used on orders
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
paymentrulepo bpchar 1  √  null Purchase payment option
po_pricelist_id numeric 10  √  null Price List used by this Business Partner
po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
documentcopies numeric 10  √  null Number of copies to be printed
c_greeting_id numeric 10  √  null Greeting to print on correspondence
invoicerule bpchar 1  √  null Frequency and method of invoicing
deliveryrule bpchar 1  √  null Defines the timing of Delivery
freightcostrule bpchar 1  √  null Method for charging Freight
deliveryviarule bpchar 1  √  null How the order will be delivered
salesrep_id numeric 10  √  null Sales Representative or Company Agent
sendemail bpchar 1  √  null Enable sending Document EMail
bpartner_parent_id numeric 10  √  null Business Partner Parent
invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
socreditstatus bpchar 1  √  null Business Partner Credit Status
shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
flatdiscount numeric 0  √  null Flat discount percentage
totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
contactname varchar 60  √  null Business Partner Contact Name
contactdescription varchar 255  √  null Description of Contact
email varchar 60  √  null Electronic Mail Address
supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
emailuser varchar 60  √  null User Name (ID) in the Mail System
bpcontactgreeting numeric 10  √  null Greeting for Business Partner Contact
title varchar 40  √  null Name this entity is referred to as
comments varchar 2000  √  null Comments or additional information
phone varchar 40  √  null Identifies a telephone number
phone2 varchar 40  √  null Identifies an alternate telephone number.
fax varchar 40  √  null Facsimile number
lastcontact timestamp 29,6  √  null Date this individual was last contacted
lastresult varchar 255  √  null Result of last contact
birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
emailverify varchar 40  √  null Verification information of EMail Address
ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
emailverifydate timestamp 29,6  √  null Date Email was verified
notificationtype bpchar 1  √  null Type of Notifications
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
postal varchar 10  √  null Postal code
city varchar 60  √  null Identifies a City
address1 varchar 60  √  null Address line 1 for this location
address2 varchar 60  √  null Address line 2 for this location
address3 varchar 60  √  null Address Line 3 for the location
c_region_id numeric 10  √  null Identifies a geographical Region
regionname varchar 2147483647  √  null Name of the Region
c_country_id numeric 10  √  null Country
countryname varchar 60  √  null Country Name
c_bp_c_taxgroup_id numeric 10  √  null c_bp_c_taxgroup_id
c_bp_dunninggrace timestamp 29,6  √  null c_bp_dunninggrace
c_bp_ismanufacturer bpchar 1  √  null c_bp_ismanufacturer
c_bp_ispotaxexempt bpchar 1  √  null c_bp_ispotaxexempt
c_bp_logo_id numeric 10  √  null c_bp_logo_id
c_bp_location_ad_org_id numeric 10  √  null c_bp_location_ad_org_id
c_bp_location_c_bpartner_id numeric 10  √  null c_bpartner_location_c_bpartner_id
c_bp_location_c_location_id numeric 10  √  null c_bp_location_c_location_id
c_bp_location_created timestamp 29,6  √  null c_bp_location_created
c_bp_location_createdby numeric 10  √  null c_bp_location_createdby
c_bp_location_salesregion_id numeric 10  √  null c_bp_location_salesregion_id
c_bp_location_fax varchar 40  √  null c_bp_location_fax
c_bp_location_isactive bpchar 1  √  null c_bp_location_isactive
c_bp_location_isbillto bpchar 1  √  null c_bp_location_isbillto
c_bp_location_isdn varchar 40  √  null c_bp_location_isdn
c_bp_location_ispayfrom bpchar 1  √  null c_bp_location_ispayfrom
c_bp_location_isremitto bpchar 1  √  null c_bp_location_isremitto
c_bp_location_isshipto bpchar 1  √  null c_bp_location_isshipto
c_bp_location_name varchar 60  √  null c_bp_location_name
c_bp_location_phone varchar 40  √  null c_bp_location_phone
c_bp_location_phone2 varchar 40  √  null c_bp_location_phone2
c_bp_location_updated timestamp 29,6  √  null c_bp_location_updated
c_bp_location_updatedby numeric 10  √  null c_bp_location_updatedby
ad_user_ad_org_id numeric 10  √  null AD_User_AD_Org_ID
ad_user_c_bpartner_id numeric 10  √  null AD_User_C_BPartner_ID
ad_user_c_bpartner_location_id numeric 10  √  null AD_User_C_BPartner_Location_ID
ad_user_created timestamp 29,6  √  null ad_user_created
ad_user_createdby numeric 10  √  null ad_user_createdby
ad_user_isactive bpchar 1  √  null ad_user_isactive
ad_user_updated timestamp 29,6  √  null ad_user_updated
ad_user_updatedby numeric 10  √  null ad_user_updatedby
ad_user_value varchar 40  √  null ad_user_value
address4 varchar 60  √  null Address Line 4 for the location
c_location_ad_org_id numeric 10  √  null c_location_ad_org_id
c_city_id numeric 10  √  null City
c_location_id numeric 10  √  null Location or Address
c_location_created timestamp 29,6  √  null c_location_created
c_location_createdby numeric 10  √  null c_location_createdby
c_location_isactive bpchar 1  √  null c_location_isactive
postal_add varchar 10  √  null Additional ZIP or Postal code
c_location_updated timestamp 29,6  √  null c_location_updated
c_location_updatedby numeric 10  √  null c_location_updatedby
c_region_ad_org_id numeric 10  √  null c_region_ad_org_id
c_region_c_country_id numeric 10  √  null c_region_c_country_id
c_region_description varchar 255  √  null c_region_description
c_region_isactive bpchar 1  √  null c_region_isactive
isdefault bpchar 1  √  null Default value
c_country_ad_language varchar 6  √  null c_country_ad_language
c_country_c_currency_id numeric 10  √  null c_country_c_currency_id
countrycode bpchar 2  √  null Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
c_country_description varchar 255  √  null c_country_description
c_country_isactive bpchar 1  √  null c_country_isactive

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