SchemaSpy Analysis of idempiere9.adempiere - ColumnsCustomize Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:47 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 91 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
m_locator isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
m_locator isdefault bpchar 1 'N'::bpchar Default value
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
m_locator ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_org_id numeric 10 Organizational entity within client
m_locator ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_bpartner createdby numeric 10 User who created this records
m_locator createdby numeric 10 User who created this records
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_locator m_locator_id numeric 10 Warehouse Locator
m_locator m_locatortype_id numeric 10  √  NULL::numeric Locator Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_locator m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_bpartner numberemployees numeric 10  √  null Number of employees
c_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
m_locator priorityno numeric 10 Where inventory should be picked from first
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner updatedby numeric 10 User who updated this records
m_locator updatedby numeric 10 User who updated this records
c_bpartner created timestamp 29,6 now() Date this record was created
m_locator created timestamp 29,6 now() Date this record was created
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner updated timestamp 29,6 now() Date this record was updated
m_locator updated timestamp 29,6 now() Date this record was updated
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner taxid varchar 20  √  null Tax Identification
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
m_locator m_locator_uu varchar 36  √  NULL::character varying M_Locator_UU
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
m_locator value varchar 40 Search key for the record in the format required - must be unique
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_bpartner name2 varchar 60  √  null Additional Name
m_locator x varchar 60  √  null X dimension, e.g., Aisle
m_locator y varchar 60  √  null Y dimension, e.g., Bin
m_locator z varchar 60  √  null Z dimension, e.g., Level
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_bpartner description varchar 255  √  null Optional short description of the record
c_bpartner so_description varchar 255  √  null Description to be used on orders