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

idempiere9.adempiere contains 304 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_salesdashboard ad_client_id numeric 10  √  null Client/Tenant for this installation.
c_salesdashboard ad_org_id numeric 10  √  null Organizational entity within client
c_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
c_contactactivity ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
c_opportunity ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
c_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_salesdashboard ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_project c_activity_id numeric 10  √  NULL::numeric Business Activity
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_project c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bpartner_location c_bpartner_location_uu varchar 36  √  NULL::character varying C_BPartner_Location_UU
c_project c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
c_opportunity c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
c_project c_campaign_id numeric 10  √  null Marketing Campaign
c_campaign c_campaign_uu varchar 36  √  NULL::character varying C_Campaign_UU
c_campaign c_channel_id numeric 10  √  null Sales Channel
c_contactactivity c_contactactivity_uu varchar 36  √  NULL::character varying C_ContactActivity_UU
c_cycle c_cycle_uu varchar 36  √  NULL::character varying C_Cycle_UU
c_cyclestep c_cyclestep_uu varchar 36  √  NULL::character varying C_CycleStep_UU
c_bpartner_location c_location_id numeric 10  √  null Location or Address
c_contactactivity c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_opportunity c_opportunity_uu varchar 36  √  NULL::character varying C_Opportunity_UU
c_opportunity c_order_id numeric 10  √  NULL::numeric Order
c_projectline c_order_id numeric 10  √  null Order
c_projectline c_orderpo_id numeric 10  √  null Purchase Order
c_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying C_PaymentTerm_UU
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_phase c_phase_uu varchar 36  √  NULL::character varying C_Phase_UU
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
c_projectline c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
c_projectline c_projectline_uu varchar 36  √  NULL::character varying C_ProjectLine_UU
c_projectline c_projectphase_id numeric 10  √  null Phase of a Project
c_projectline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_project c_projecttype_id numeric 10  √  null Type of the project
c_bpartner_location c_salesregion_id numeric 10  √  null Sales coverage region
c_salesstage c_salesstage_uu varchar 36  √  NULL::character varying C_SalesStage_UU
c_opportunity closedate timestamp 29,6  √  null Close Date
c_contactactivity comments text 2147483647  √  null Comments or additional information
c_opportunity comments text 2147483647  √  null Comments or additional information
m_bp_price comments varchar 2000  √  NULL::character varying Comments or additional information
c_projectline committedamt numeric 0  √  0 The (legal) commitment amount
c_projectline committedqty numeric 0  √  0 The (legal) commitment Quantity
c_project copyfrom bpchar 1  √  null Copy From Record
c_opportunity cost numeric 0  √  null Cost information
c_salesdashboard created timestamp 29,6  √  null Date this record was created
c_salesdashboard createdby numeric 10  √  null User who created this records
c_bpartner_location customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_campaign description varchar 255  √  null Optional short description of the record
c_cycle description varchar 255  √  null Optional short description of the record
c_opportunity description varchar 255  √  NULL::character varying Optional short description of the record
c_paymentterm description varchar 255  √  null Optional short description of the record
c_phase description varchar 255  √  null Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
c_projectline description varchar 255  √  null Optional short description of the record
c_salesstage description varchar 255  √  NULL::character varying Optional short description of the record
r_interestarea description varchar 255  √  null Optional short description of the record
m_bp_price discount numeric 0  √  null Discount in percent
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
c_projectline dopricing bpchar 1  √  'Y'::bpchar Pricing
c_campaign enddate timestamp 29,6  √  null Last effective date (inclusive)
c_contactactivity enddate timestamp 29,6  √  null Last effective date (inclusive)
c_bpartner_location fax varchar 40  √  null Facsimile number
c_paymentterm fixmonthcutoff numeric 10  √  null Last day to include for next due date
c_paymentterm fixmonthday numeric 10  √  null Day of the month of the due date
c_paymentterm fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
c_project generateto bpchar 1  √  null Generate To
c_phase help varchar 2000  √  null Comment or Hint
c_salesdashboard isactive bpchar 1  √  null The record is active in the system
c_contactactivity iscomplete bpchar 1  √  NULL::bpchar It is complete
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
c_bpartner_location isdn varchar 40  √  null ISDN or modem line
m_bp_price isnetprice bpchar 1  √  NULL::bpchar Net Price including all discounts
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar Payment due on the next business day
c_salesstage iswon bpchar 1  √  NULL::bpchar The opportunity was won
m_bp_price m_bp_price_uu varchar 36  √  NULL::character varying M_BP_Price_UU
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
c_projectline m_product_category_id numeric 10  √  null Category of a Product
c_phase m_product_id numeric 10  √  null Product, Service, Item
c_projectline m_product_id numeric 10  √  null Product, Service, Item
c_projectline m_production_id numeric 10  √  NULL::numeric Plan for producing a product
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
c_salesdashboard name varchar 60  √  null Alphanumeric identifier of the entity
c_paymentterm netday bpchar 1  √  null Day when payment is due net
c_project note varchar 2000  √  null Optional additional user defined information
r_contactinterest optoutdate timestamp 29,6  √  null Date the contact opted out
c_bpartner_location phone varchar 40  √  null Identifies a telephone number
c_bpartner_location phone2 varchar 40  √  null Identifies an alternate telephone number.
c_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_bp_price priceoverridetype bpchar 1  √  NULL::bpchar Type of price override, fixed price or discount off list
c_paymentterm processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
c_project projectcategory bpchar 1  √  'N'::bpchar Project Category
r_contactinterest r_contactinterest_uu varchar 36  √  NULL::character varying R_ContactInterest_UU
r_interestarea r_interestarea_uu varchar 36  √  NULL::character varying R_InterestArea_UU
c_salesdashboard salespipeline int4 10  √  null Sales Pipeline
c_contactactivity salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_opportunity salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_campaign startdate timestamp 29,6  √  null First effective day (inclusive)
r_contactinterest subscribedate timestamp 29,6  √  null Date the contact actively subscribed
c_salesdashboard updated timestamp 29,6  √  null Date this record was updated
c_salesdashboard updatedby numeric 10  √  null User who updated this records
m_bp_price validfrom timestamp 29,6  √  null Valid from including this date (first day)
m_bp_price validto timestamp 29,6  √  null Valid to including this date (last day)
c_bpartner_location ad_client_id numeric 10 Client/Tenant for this installation.
c_campaign ad_client_id numeric 10 Client/Tenant for this installation.
c_contactactivity ad_client_id numeric 10 Client/Tenant for this installation.
c_cycle ad_client_id numeric 10 Client/Tenant for this installation.
c_cyclestep ad_client_id numeric 10 Client/Tenant for this installation.
c_opportunity ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentterm ad_client_id numeric 10 Client/Tenant for this installation.
c_phase ad_client_id numeric 10 Client/Tenant for this installation.
c_project ad_client_id numeric 10 Client/Tenant for this installation.
c_projectline ad_client_id numeric 10 Client/Tenant for this installation.
c_salesstage ad_client_id numeric 10 Client/Tenant for this installation.
m_bp_price ad_client_id numeric 10 Client/Tenant for this installation.
r_contactinterest ad_client_id numeric 10 Client/Tenant for this installation.
r_interestarea ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_location ad_org_id numeric 10 Organizational entity within client
c_campaign ad_org_id numeric 10 Organizational entity within client
c_contactactivity ad_org_id numeric 10 Organizational entity within client
c_cycle ad_org_id numeric 10 Organizational entity within client
c_cyclestep ad_org_id numeric 10 Organizational entity within client
c_opportunity ad_org_id numeric 10 Organizational entity within client
c_paymentterm ad_org_id numeric 10 Organizational entity within client
c_phase ad_org_id numeric 10 Organizational entity within client
c_project ad_org_id numeric 10 Organizational entity within client
c_projectline ad_org_id numeric 10 Organizational entity within client
c_salesstage ad_org_id numeric 10 Organizational entity within client
m_bp_price ad_org_id numeric 10 Organizational entity within client
r_contactinterest ad_org_id numeric 10 Organizational entity within client
r_interestarea ad_org_id numeric 10 Organizational entity within client
r_contactinterest ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
m_bp_price breakvalue numeric 0 Low Value of trade discount break level
c_bpartner_location c_bpartner_id numeric 10 Identifies a Business Partner
c_opportunity c_bpartner_id numeric 10 Identifies a Business Partner
m_bp_price c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_campaign c_campaign_id numeric 10 Marketing Campaign
c_contactactivity c_contactactivity_id numeric 10 Events, tasks, communications related to a contact
c_cycle c_currency_id numeric 10 The Currency for this record
c_opportunity c_currency_id numeric 10 The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
m_bp_price c_currency_id numeric 10 The Currency for this record
c_cycle c_cycle_id numeric 10 Identifier for this Project Reporting Cycle
c_cyclestep c_cycle_id numeric 10 Identifier for this Project Reporting Cycle
c_cyclestep c_cyclestep_id numeric 10 The step for this Cycle
c_opportunity c_opportunity_id numeric 10 Sales Opportunity
c_paymentterm c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_phase c_phase_id numeric 10 Standard Phase of the Project Type
c_project c_project_id numeric 10 Financial Project
c_projectline c_project_id numeric 10 Financial Project
c_projectline c_projectline_id numeric 10 Task or step in a project
c_phase c_projecttype_id numeric 10 Type of the project
c_opportunity c_salesstage_id numeric 10 Stages of the sales process
c_salesstage c_salesstage_id numeric 10 Stages of the sales process
c_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
c_contactactivity contactactivitytype varchar 10 Type of activity, e.g. task, email, phone call
c_campaign costs numeric 0 0 Costs in accounting currency
c_bpartner_location created timestamp 29,6 now() Date this record was created
c_campaign created timestamp 29,6 now() Date this record was created
c_contactactivity created timestamp 29,6 statement_timestamp() Date this record was created
c_cycle created timestamp 29,6 now() Date this record was created
c_cyclestep created timestamp 29,6 now() Date this record was created
c_opportunity created timestamp 29,6 statement_timestamp() Date this record was created
c_paymentterm created timestamp 29,6 now() Date this record was created
c_phase created timestamp 29,6 now() Date this record was created
c_project created timestamp 29,6 now() Date this record was created
c_projectline created timestamp 29,6 now() Date this record was created
c_salesstage created timestamp 29,6 statement_timestamp() Date this record was created
m_bp_price created timestamp 29,6 statement_timestamp() Date this record was created
r_contactinterest created timestamp 29,6 now() Date this record was created
r_interestarea created timestamp 29,6 now() Date this record was created
c_bpartner_location createdby numeric 10 User who created this records
c_campaign createdby numeric 10 User who created this records
c_contactactivity createdby numeric 10 User who created this records
c_cycle createdby numeric 10 User who created this records
c_cyclestep createdby numeric 10 User who created this records
c_opportunity createdby numeric 10 User who created this records
c_paymentterm createdby numeric 10 User who created this records
c_phase createdby numeric 10 User who created this records
c_project createdby numeric 10 User who created this records
c_projectline createdby numeric 10 User who created this records
c_salesstage createdby numeric 10 User who created this records
m_bp_price createdby numeric 10 User who created this records
r_contactinterest createdby numeric 10 User who created this records
r_interestarea createdby numeric 10 User who created this records
c_contactactivity description varchar 255 Optional short description of the record
c_paymentterm discount numeric 0 Discount in percent
c_paymentterm discount2 numeric 0 Discount in percent
c_paymentterm discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_paymentterm discountdays2 numeric 10 Number of days from invoice date to be eligible for discount
c_opportunity documentno varchar 60 Document sequence number of the document
c_opportunity expectedclosedate timestamp 29,6 Expected Close Date
c_paymentterm gracedays numeric 10 Days after due date to send first dunning letter
c_project invoicedamt numeric 0 0 The amount invoiced
c_projectline invoicedamt numeric 0 0 The amount invoiced
c_project invoicedqty numeric 0 0 The quantity invoiced
c_projectline invoicedqty numeric 0 0 The quantity invoiced
c_bpartner_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_campaign isactive bpchar 1 'Y'::bpchar The record is active in the system
c_contactactivity isactive bpchar 1 'Y'::bpchar The record is active in the system
c_cycle isactive bpchar 1 'Y'::bpchar The record is active in the system
c_cyclestep isactive bpchar 1 'Y'::bpchar The record is active in the system
c_opportunity isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentterm isactive bpchar 1 'Y'::bpchar The record is active in the system
c_phase isactive bpchar 1 'Y'::bpchar The record is active in the system
c_project isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_salesstage isactive bpchar 1 'Y'::bpchar The record is active in the system
m_bp_price isactive bpchar 1 'Y'::bpchar The record is active in the system
r_contactinterest isactive bpchar 1 'Y'::bpchar The record is active in the system
r_interestarea isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_location isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
c_salesstage isclosed bpchar 1 'N'::bpchar The status is closed
c_project iscommitceiling bpchar 1 'N'::bpchar The commitment amount/quantity is the chargeable ceiling
c_project iscommitment bpchar 1 'Y'::bpchar Is this document a (legal) commitment?
c_paymentterm isduefixed bpchar 1 'N'::bpchar Payment is due on a fixed date
c_bpartner_location ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
c_bpartner_location ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name
c_projectline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
c_bpartner_location isremitto bpchar 1 'Y'::bpchar Business Partner payment address
r_interestarea isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_bpartner_location isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
c_campaign issummary bpchar 1 'N'::bpchar This is a summary entity
c_project issummary bpchar 1 'N'::bpchar This is a summary entity
c_paymentterm isvalid bpchar 1 'N'::bpchar Element is valid
c_projectline line numeric 10 Unique line for this document
m_bp_price m_bp_price_id numeric 10 Business Partner Price
m_bp_price m_product_id numeric 10 Product, Service, Item
c_bpartner_location name varchar 60 Alphanumeric identifier of the entity
c_campaign name varchar 60 Alphanumeric identifier of the entity
c_cycle name varchar 60 Alphanumeric identifier of the entity
c_cyclestep name varchar 60 Alphanumeric identifier of the entity
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
c_phase name varchar 60 Alphanumeric identifier of the entity
c_project name varchar 60 Alphanumeric identifier of the entity
c_salesstage name varchar 60 Alphanumeric identifier of the entity
r_interestarea name varchar 60 Alphanumeric identifier of the entity
c_paymentterm netdays numeric 10 Net Days in which payment is due
c_opportunity opportunityamt numeric 0 The estimated value of this opportunity.
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar Payment term usage indicates if this payment term is used for sales, purchases or both.
c_project plannedamt numeric 0 0 Planned amount for this project
c_projectline plannedamt numeric 0 0 Planned amount for this project
c_project plannedmarginamt numeric 0 0 Project's planned margin amount
c_projectline plannedmarginamt numeric 0 0 Project's planned margin amount
c_projectline plannedprice numeric 0 0 Planned price for this project line
c_project plannedqty numeric 0 0 Planned quantity for this project
c_projectline plannedqty numeric 0 0 Planned quantity for this project
m_bp_price pricelimit numeric 0 Lowest price for a product
m_bp_price pricelist numeric 0 List Price
m_bp_price pricestd numeric 0 Standard Price
c_opportunity probability numeric 0 Probability
c_salesstage probability numeric 0 Probability
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_projectline processed bpchar 1 'N'::bpchar The document has been processed
c_project projectbalanceamt numeric 0 0 Total Project Balance
c_project projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
r_contactinterest r_interestarea_id numeric 10 Interest Area or Topic
r_interestarea r_interestarea_id numeric 10 Interest Area or Topic
c_cyclestep relativeweight numeric 0 Relative weight of this step (0 = ignored)
c_cyclestep seqno numeric 10 Method of ordering records; lowest number comes first
c_phase seqno numeric 10 Method of ordering records; lowest number comes first
c_phase standardqty numeric 0 0 Standard Quantity
c_contactactivity startdate timestamp 29,6 First effective day (inclusive)
c_bpartner_location updated timestamp 29,6 now() Date this record was updated
c_campaign updated timestamp 29,6 now() Date this record was updated
c_contactactivity updated timestamp 29,6 statement_timestamp() Date this record was updated
c_cycle updated timestamp 29,6 now() Date this record was updated
c_cyclestep updated timestamp 29,6 now() Date this record was updated
c_opportunity updated timestamp 29,6 statement_timestamp() Date this record was updated
c_paymentterm updated timestamp 29,6 now() Date this record was updated
c_phase updated timestamp 29,6 now() Date this record was updated
c_project updated timestamp 29,6 now() Date this record was updated
c_projectline updated timestamp 29,6 now() Date this record was updated
c_salesstage updated timestamp 29,6 statement_timestamp() Date this record was updated
m_bp_price updated timestamp 29,6 statement_timestamp() Date this record was updated
r_contactinterest updated timestamp 29,6 now() Date this record was updated
r_interestarea updated timestamp 29,6 now() Date this record was updated
c_bpartner_location updatedby numeric 10 User who updated this records
c_campaign updatedby numeric 10 User who updated this records
c_contactactivity updatedby numeric 10 User who updated this records
c_cycle updatedby numeric 10 User who updated this records
c_cyclestep updatedby numeric 10 User who updated this records
c_opportunity updatedby numeric 10 User who updated this records
c_paymentterm updatedby numeric 10 User who updated this records
c_phase updatedby numeric 10 User who updated this records
c_project updatedby numeric 10 User who updated this records
c_projectline updatedby numeric 10 User who updated this records
c_salesstage updatedby numeric 10 User who updated this records
m_bp_price updatedby numeric 10 User who updated this records
r_contactinterest updatedby numeric 10 User who updated this records
r_interestarea updatedby numeric 10 User who updated this records
c_campaign value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm value varchar 40 Search key for the record in the format required - must be unique
c_project value varchar 40 Search key for the record in the format required - must be unique
c_salesstage value varchar 60 Search key for the record in the format required - must be unique
r_interestarea value varchar 40 Search key for the record in the format required - must be unique