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

idempiere9.adempiere contains 532 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_clientinfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying AD_ClientInfo_UU
ad_clientinfo ad_org_id numeric 10 Organizational entity within client
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_clientinfo ad_tree_activity_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_campaign_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_clientinfo ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_clientinfo ad_tree_product_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_project_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo c_acctschema1_id numeric 10  √  null Primary rules for accounting
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null Business Partner used for creating new Business Partners on the fly
ad_clientinfo c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric Charge for Freight
ad_clientinfo c_uom_length_id numeric 10  √  null Standard Unit of Measure for Length
ad_clientinfo c_uom_time_id numeric 10  √  null Standard Unit of Measure for Time
ad_clientinfo c_uom_volume_id numeric 10  √  null Standard Unit of Measure for Volume
ad_clientinfo c_uom_weight_id numeric 10  √  null Standard Unit of Measure for Weight
ad_clientinfo created timestamp 29,6 now() Date this record was created
ad_clientinfo createdby numeric 10 User who created this records
ad_clientinfo fy_startdate timestamp 29,6  √  null Financial Year Start Date
ad_clientinfo isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar Show Confirmation On Document Action Close
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar Show Confirmation On Document Action Void
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar Payment Discount calculation does not include Taxes and Charges
ad_clientinfo keeplogdays numeric 10  √  null Number of days to keep the log entries
ad_clientinfo logo_id numeric 10  √  NULL::numeric Logo
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric Logo Report
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric Logo Web
ad_clientinfo m_productfreight_id numeric 10  √  null Product for Freight
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric Archive Store
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric Storage provider for Image
ad_clientinfo updated timestamp 29,6 now() Date this record was updated
ad_clientinfo updatedby numeric 10 User who updated this records
ad_menu action bpchar 1  √  null Indicates the Action to be performed
ad_menu ad_client_id numeric 10 Client/Tenant for this installation.
ad_menu ad_form_id numeric 10  √  null Special Form
ad_menu ad_infowindow_id numeric 10  √  NULL::numeric Info and search/select Window
ad_menu ad_menu_id numeric 10 Identifies a Menu
ad_menu ad_menu_uu varchar 36  √  NULL::character varying AD_Menu_UU
ad_menu ad_org_id numeric 10 Organizational entity within client
ad_menu ad_process_id numeric 10  √  null Process or Report
ad_menu ad_task_id numeric 10  √  null Operation System Task
ad_menu ad_window_id numeric 10  √  null Data entry or display window
ad_menu ad_workbench_id numeric 10  √  null Collection of windows, reports
ad_menu ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_menu created timestamp 29,6 now() Date this record was created
ad_menu createdby numeric 10 User who created this records
ad_menu description varchar 255  √  null Optional short description of the record
ad_menu entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_menu isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_menu iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_menu isreadonly bpchar 1 'N'::bpchar Field is read only
ad_menu issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_menu issummary bpchar 1 'N'::bpchar This is a summary entity
ad_menu name varchar 60 Alphanumeric identifier of the entity
ad_menu predefinedcontextvariables varchar 4000  √  NULL::character varying Predefined context variables to inject when opening a menu entry or a window
ad_menu updated timestamp 29,6 now() Date this record was updated
ad_menu updatedby numeric 10 User who updated this records
ad_orginfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_orginfo ad_org_id numeric 10 Organizational entity within client
ad_orginfo ad_orginfo_uu varchar 36  √  NULL::character varying AD_OrgInfo_UU
ad_orginfo ad_orgtype_id numeric 10  √  null Organization Type
ad_orginfo c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_orginfo c_location_id numeric 10  √  null Location or Address
ad_orginfo created timestamp 29,6 now() Date this record was created
ad_orginfo createdby numeric 10 User who created this records
ad_orginfo dropship_warehouse_id numeric 10  √  null The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_orginfo duns varchar 11 Dun & Bradstreet Number
ad_orginfo email varchar 60  √  NULL::character varying Electronic Mail Address
ad_orginfo fax varchar 40  √  NULL::character varying Facsimile number
ad_orginfo isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_orginfo logo_id numeric 10  √  NULL::numeric Logo
ad_orginfo m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
ad_orginfo pa_goal_id numeric 10  √  null
ad_orginfo parent_org_id numeric 10  √  null Parent (superior) Organization
ad_orginfo phone varchar 40  √  NULL::character varying Identifies a telephone number
ad_orginfo phone2 varchar 40  √  NULL::character varying Identifies an alternate telephone number.
ad_orginfo receiptfootermsg varchar 1023  √  null This message will be displayed at the bottom of a receipt when doing a sales or purchase
ad_orginfo supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_orginfo taxid varchar 20 Tax Identification
ad_orginfo transferbank_id numeric 0  √  null Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo transfercashbook_id numeric 0  √  null CashBook for transfers
ad_orginfo updated timestamp 29,6 now() Date this record was updated
ad_orginfo updatedby numeric 10 User who updated this records
ad_tree ad_client_id numeric 10 Client/Tenant for this installation.
ad_tree ad_org_id numeric 10 Organizational entity within client
ad_tree ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_tree ad_tree_id numeric 10 Identifies a Tree
ad_tree ad_tree_uu varchar 36  √  NULL::character varying AD_Tree_UU
ad_tree created timestamp 29,6 now() Date this record was created
ad_tree createdby numeric 10 User who created this records
ad_tree description varchar 255  √  null Optional short description of the record
ad_tree isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tree isallnodes bpchar 1 'Y'::bpchar All Nodes are included (Complete Tree)
ad_tree isdefault bpchar 1 'N'::bpchar Default value
ad_tree isloadallnodesimmediately bpchar 1 'Y'::bpchar If checked, all nodes are loaded before tree is displayed
ad_tree istreedrivenbyvalue bpchar 1 'N'::bpchar Driven by Search Key
ad_tree isvaluedisplayed bpchar 1 'N'::bpchar Displays Value column with the Display column
ad_tree name varchar 60 Alphanumeric identifier of the entity
ad_tree parent_column_id numeric 10  √  NULL::numeric The link column on the parent tab.
ad_tree processing bpchar 1  √  null Process Now
ad_tree treetype bpchar 2 Element this tree is built on (i.e Product, Business Partner)
ad_tree updated timestamp 29,6 now() Date this record was updated
ad_tree updatedby numeric 10 User who updated this records
ad_tree_favorite ad_client_id numeric 10 Client/Tenant for this installation.
ad_tree_favorite ad_org_id numeric 10 Organizational entity within client
ad_tree_favorite ad_tree_favorite_id numeric 10 Favorite Tree
ad_tree_favorite ad_tree_favorite_uu varchar 36  √  NULL::character varying Favorite Tree
ad_tree_favorite ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_tree_favorite created timestamp 29,6  √  statement_timestamp() Date this record was created
ad_tree_favorite createdby numeric 10  √  NULL::numeric User who created this records
ad_tree_favorite isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tree_favorite updated timestamp 29,6  √  statement_timestamp() Date this record was updated
ad_tree_favorite updatedby numeric 10 User who updated this records
ad_tree_favorite_node ad_client_id numeric 10 Client/Tenant for this installation.
ad_tree_favorite_node ad_menu_id numeric 10  √  NULL::numeric Identifies a Menu
ad_tree_favorite_node ad_org_id numeric 10 Organizational entity within client
ad_tree_favorite_node ad_tree_favorite_id numeric 10 Favorite Tree
ad_tree_favorite_node ad_tree_favorite_node_id numeric 10 Favorite Node Tree
ad_tree_favorite_node ad_tree_favorite_node_uu varchar 36  √  NULL::character varying Favorite Node Tree
ad_tree_favorite_node created timestamp 29,6 statement_timestamp() Date this record was created
ad_tree_favorite_node createdby numeric 10 User who created this records
ad_tree_favorite_node isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tree_favorite_node iscollapsible bpchar 1 'Y'::bpchar Flag to indicate the state of the dashboard panel
ad_tree_favorite_node isfavourite bpchar 1 'N'::bpchar This record is a favourite
ad_tree_favorite_node issummary bpchar 1 'N'::bpchar This is a summary entity
ad_tree_favorite_node loginopenseqno numeric 10  √  NULL::numeric Determine the order items will be automatically opened when user logs in
ad_tree_favorite_node name varchar 120  √  NULL::character varying Alphanumeric identifier of the entity
ad_tree_favorite_node parent_id numeric 10  √  NULL::numeric Parent of Entity
ad_tree_favorite_node seqno numeric 10 Method of ordering records; lowest number comes first
ad_tree_favorite_node updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_tree_favorite_node updatedby numeric 10 User who updated this records
ad_treebar ad_client_id numeric 10 Client/Tenant for this installation.
ad_treebar ad_org_id numeric 10 Organizational entity within client
ad_treebar ad_tree_id numeric 10 Identifies a Tree
ad_treebar ad_treebar_uu varchar 36  √  NULL::character varying AD_TreeBar_UU
ad_treebar ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_treebar created timestamp 29,6 now() Date this record was created
ad_treebar createdby numeric 10 User who created this records
ad_treebar isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treebar isfavourite bpchar 1 'Y'::bpchar This record is a favourite
ad_treebar loginopenseqno numeric 10  √  NULL::numeric Determine the order items will be automatically opened when user logs in
ad_treebar node_id numeric 10 Node
ad_treebar updated timestamp 29,6 now() Date this record was updated
ad_treebar updatedby numeric 10 User who updated this records
ad_treenode ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenode ad_org_id numeric 10 Organizational entity within client
ad_treenode ad_tree_id numeric 10 Identifies a Tree
ad_treenode ad_treenode_uu varchar 36  √  NULL::character varying AD_TreeNode_UU
ad_treenode created timestamp 29,6 now() Date this record was created
ad_treenode createdby numeric 10 User who created this records
ad_treenode isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenode node_id numeric 10 Node
ad_treenode parent_id numeric 10  √  null Parent of Entity
ad_treenode seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_treenode updated timestamp 29,6 now() Date this record was updated
ad_treenode updatedby numeric 10 User who updated this records
ad_treenodebp ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodebp ad_org_id numeric 10 Organizational entity within client
ad_treenodebp ad_tree_id numeric 10 Identifies a Tree
ad_treenodebp ad_treenodebp_uu varchar 36  √  NULL::character varying AD_TreeNodeBP_UU
ad_treenodebp created timestamp 29,6 now() Date this record was created
ad_treenodebp createdby numeric 10 User who created this records
ad_treenodebp isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodebp node_id numeric 10 Node
ad_treenodebp parent_id numeric 10  √  null Parent of Entity
ad_treenodebp seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_treenodebp updated timestamp 29,6 now() Date this record was updated
ad_treenodebp updatedby numeric 10 User who updated this records
ad_treenodemm ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodemm ad_org_id numeric 10 Organizational entity within client
ad_treenodemm ad_tree_id numeric 10 Identifies a Tree
ad_treenodemm ad_treenodemm_uu varchar 36  √  NULL::character varying AD_TreeNodeMM_UU
ad_treenodemm created timestamp 29,6 now() Date this record was created
ad_treenodemm createdby numeric 10 User who created this records
ad_treenodemm isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodemm node_id numeric 10 Node
ad_treenodemm parent_id numeric 10  √  null Parent of Entity
ad_treenodemm seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_treenodemm updated timestamp 29,6 now() Date this record was updated
ad_treenodemm updatedby numeric 10 User who updated this records
ad_treenodepr ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodepr ad_org_id numeric 10 Organizational entity within client
ad_treenodepr ad_tree_id numeric 10 Identifies a Tree
ad_treenodepr ad_treenodepr_uu varchar 36  √  NULL::character varying AD_TreeNodePR_UU
ad_treenodepr created timestamp 29,6 now() Date this record was created
ad_treenodepr createdby numeric 10 User who created this records
ad_treenodepr isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodepr node_id numeric 10 Node
ad_treenodepr parent_id numeric 10  √  null Parent of Entity
ad_treenodepr seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_treenodepr updated timestamp 29,6 now() Date this record was updated
ad_treenodepr updatedby numeric 10 User who updated this records
ad_treenodeu1 ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodeu1 ad_org_id numeric 10 Organizational entity within client
ad_treenodeu1 ad_tree_id numeric 10 Identifies a Tree
ad_treenodeu1 ad_treenodeu1_uu varchar 36  √  NULL::character varying AD_TreeNodeU1_UU
ad_treenodeu1 created timestamp 29,6 now() Date this record was created
ad_treenodeu1 createdby numeric 10 User who created this records
ad_treenodeu1 isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodeu1 node_id numeric 10 Node
ad_treenodeu1 parent_id numeric 10 Parent of Entity
ad_treenodeu1 seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_treenodeu1 updated timestamp 29,6 now() Date this record was updated
ad_treenodeu1 updatedby numeric 10 User who updated this records
ad_treenodeu2 ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodeu2 ad_org_id numeric 10 Organizational entity within client
ad_treenodeu2 ad_tree_id numeric 10 Identifies a Tree
ad_treenodeu2 ad_treenodeu2_uu varchar 36  √  NULL::character varying AD_TreeNodeU2_UU
ad_treenodeu2 created timestamp 29,6 now() Date this record was created
ad_treenodeu2 createdby numeric 10 User who created this records
ad_treenodeu2 isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodeu2 node_id numeric 10 Node
ad_treenodeu2 parent_id numeric 10 Parent of Entity
ad_treenodeu2 seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_treenodeu2 updated timestamp 29,6 now() Date this record was updated
ad_treenodeu2 updatedby numeric 10 User who updated this records
ad_treenodeu3 ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodeu3 ad_org_id numeric 10 Organizational entity within client
ad_treenodeu3 ad_tree_id numeric 10 Identifies a Tree
ad_treenodeu3 ad_treenodeu3_uu varchar 36  √  NULL::character varying AD_TreeNodeU3_UU
ad_treenodeu3 created timestamp 29,6 now() Date this record was created
ad_treenodeu3 createdby numeric 10 User who created this records
ad_treenodeu3 isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodeu3 node_id numeric 10 Node
ad_treenodeu3 parent_id numeric 10 Parent of Entity
ad_treenodeu3 seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_treenodeu3 updated timestamp 29,6 now() Date this record was updated
ad_treenodeu3 updatedby numeric 10 User who updated this records
ad_treenodeu4 ad_client_id numeric 10 Client/Tenant for this installation.
ad_treenodeu4 ad_org_id numeric 10 Organizational entity within client
ad_treenodeu4 ad_tree_id numeric 10 Identifies a Tree
ad_treenodeu4 ad_treenodeu4_uu varchar 36  √  NULL::character varying AD_TreeNodeU4_UU
ad_treenodeu4 created timestamp 29,6 now() Date this record was created
ad_treenodeu4 createdby numeric 10 User who created this records
ad_treenodeu4 isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_treenodeu4 node_id numeric 10 Node
ad_treenodeu4 parent_id numeric 10 Parent of Entity
ad_treenodeu4 seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_treenodeu4 updated timestamp 29,6 now() Date this record was updated
ad_treenodeu4 updatedby numeric 10 User who updated this records
c_activity ad_client_id numeric 10 Client/Tenant for this installation.
c_activity ad_org_id numeric 10 Organizational entity within client
c_activity c_activity_id numeric 10 Business Activity
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_activity created timestamp 29,6 now() Date this record was created
c_activity createdby numeric 10 User who created this records
c_activity description varchar 255  √  null Optional short description of the record
c_activity help varchar 2000  √  null Comment or Hint
c_activity isactive bpchar 1 'Y'::bpchar The record is active in the system
c_activity issummary bpchar 1 'N'::bpchar This is a summary entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_activity updated timestamp 29,6 now() Date this record was updated
c_activity updatedby numeric 10 User who updated this records
c_activity value varchar 40 Search key for the record in the format required - must be unique
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 ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner 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_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
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 created timestamp 29,6 now() Date this record was created
c_bpartner createdby numeric 10 User who created this records
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
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 description varchar 255  √  null Optional short description of the record
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
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
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
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 logo_id numeric 10  √  NULL::numeric Logo
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_bpartner numberemployees numeric 10  √  null Number of employees
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
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
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
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 sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
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 so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_bpartner taxid varchar 20  √  null Tax Identification
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_element ad_client_id numeric 10 Client/Tenant for this installation.
c_element ad_org_id numeric 10 Organizational entity within client
c_element ad_tree_id numeric 10  √  null Identifies a Tree
c_element c_element_id numeric 10 Accounting Element
c_element c_element_uu varchar 36  √  NULL::character varying C_Element_UU
c_element created timestamp 29,6 now() Date this record was created
c_element createdby numeric 10 User who created this records
c_element description varchar 255  √  null Optional short description of the record
c_element elementtype bpchar 1 Element Type (account or user defined)
c_element isactive bpchar 1 'Y'::bpchar The record is active in the system
c_element isbalancing bpchar 1 'N'::bpchar All transactions within an element value must balance (e.g. cost centers)
c_element isnaturalaccount bpchar 1 'Y'::bpchar The primary natural account
c_element name varchar 60 Alphanumeric identifier of the entity
c_element updated timestamp 29,6 now() Date this record was updated
c_element updatedby numeric 10 User who updated this records
c_element vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_elementvalue accountsign bpchar 1 Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue accounttype bpchar 1 Indicates the type of account
c_elementvalue ad_client_id numeric 10 Client/Tenant for this installation.
c_elementvalue ad_org_id numeric 10 Organizational entity within client
c_elementvalue bpartnertype bpchar 1  √  NULL::bpchar Business Partner Type
c_elementvalue c_bankaccount_id numeric 10  √  null Account at the Bank
c_elementvalue c_currency_id numeric 10  √  null The Currency for this record
c_elementvalue c_element_id numeric 10 Accounting Element
c_elementvalue c_elementvalue_id numeric 10 Account Element
c_elementvalue c_elementvalue_uu varchar 36  √  NULL::character varying C_ElementValue_UU
c_elementvalue created timestamp 29,6 now() Date this record was created
c_elementvalue createdby numeric 10 User who created this records
c_elementvalue description varchar 255  √  null Optional short description of the record
c_elementvalue isactive bpchar 1 'Y'::bpchar The record is active in the system
c_elementvalue isbankaccount bpchar 1  √  'N'::bpchar Indicates if this is the Bank Account
c_elementvalue isdetailbpartner bpchar 1 'N'::bpchar Manage Business Partners
c_elementvalue isdetailproduct bpchar 1 'N'::bpchar Manage Products
c_elementvalue isdoccontrolled bpchar 1  √  'N'::bpchar Control account - If an account is controlled by a document, you cannot post manually to it
c_elementvalue isforeigncurrency bpchar 1  √  'N'::bpchar Balances in foreign currency accounts are held in the nominated currency
c_elementvalue issummary bpchar 1 'N'::bpchar This is a summary entity
c_elementvalue name varchar 120 Alphanumeric identifier of the entity
c_elementvalue postactual bpchar 1 'Y'::bpchar Actual Values can be posted
c_elementvalue postbudget bpchar 1 'Y'::bpchar Budget values can be posted
c_elementvalue postencumbrance bpchar 1 'Y'::bpchar Post commitments to this account
c_elementvalue poststatistical bpchar 1 'Y'::bpchar Post statistical quantities to this account?
c_elementvalue updated timestamp 29,6 now() Date this record was updated
c_elementvalue updatedby numeric 10 User who updated this records
c_elementvalue validfrom timestamp 29,6  √  null Valid from including this date (first day)
c_elementvalue validto timestamp 29,6  √  null Valid to including this date (last day)
c_elementvalue value varchar 40 Search key for the record in the format required - must be unique
c_project ad_client_id numeric 10 Client/Tenant for this installation.
c_project ad_org_id numeric 10 Organizational entity within client
c_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
c_project 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_project c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
c_project c_campaign_id numeric 10  √  null Marketing Campaign
c_project c_currency_id numeric 10 The Currency for this record
c_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_project c_project_id numeric 10 Financial Project
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
c_project c_projecttype_id numeric 10  √  null Type of the project
c_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
c_project copyfrom bpchar 1  √  null Copy From Record
c_project created timestamp 29,6 now() Date this record was created
c_project createdby numeric 10 User who created this records
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_project description varchar 255  √  null Optional short description of the record
c_project generateto bpchar 1  √  null Generate To
c_project invoicedamt numeric 0 0 The amount invoiced
c_project invoicedqty numeric 0 0 The quantity invoiced
c_project isactive bpchar 1 'Y'::bpchar The record is active in the system
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_project issummary bpchar 1 'N'::bpchar This is a summary entity
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
c_project name varchar 60 Alphanumeric identifier of the entity
c_project note varchar 2000  √  null Optional additional user defined information
c_project plannedamt numeric 0 0 Planned amount for this project
c_project plannedmarginamt numeric 0 0 Project's planned margin amount
c_project plannedqty numeric 0 0 Planned quantity for this project
c_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_project processing bpchar 1  √  null Process Now
c_project projectbalanceamt numeric 0 0 Total Project Balance
c_project projectcategory bpchar 1  √  'N'::bpchar Project Category
c_project projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_project updated timestamp 29,6 now() Date this record was updated
c_project updatedby numeric 10 User who updated this records
c_project value varchar 40 Search key for the record in the format required - must be unique
c_salesregion ad_client_id numeric 10 Client/Tenant for this installation.
c_salesregion ad_org_id numeric 10 Organizational entity within client
c_salesregion c_salesregion_id numeric 10 Sales coverage region
c_salesregion c_salesregion_uu varchar 36  √  NULL::character varying C_SalesRegion_UU
c_salesregion created timestamp 29,6 now() Date this record was created
c_salesregion createdby numeric 10 User who created this records
c_salesregion description varchar 255  √  null Optional short description of the record
c_salesregion isactive bpchar 1 'Y'::bpchar The record is active in the system
c_salesregion isdefault bpchar 1 'N'::bpchar Default value
c_salesregion issummary bpchar 1 'N'::bpchar This is a summary entity
c_salesregion name varchar 60 Alphanumeric identifier of the entity
c_salesregion salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_salesregion updated timestamp 29,6 now() Date this record was updated
c_salesregion updatedby numeric 10 User who updated this records
c_salesregion value varchar 40 Search key for the record in the format required - must be unique
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within client
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_product created timestamp 29,6 now() Date this record was created
m_product createdby numeric 10 User who created this records
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_product description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_product istoformule bpchar 1  √  null
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_product m_product_category_id numeric 10 Category of a Product
m_product m_product_id numeric 10 Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_product name varchar 255 Alphanumeric identifier of the entity
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product updated timestamp 29,6 now() Date this record was updated
m_product updatedby numeric 10 User who updated this records
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
m_product_category ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category ad_org_id numeric 10 Organizational entity within client
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
m_product_category created timestamp 29,6 now() Date this record was created
m_product_category createdby numeric 10 User who created this records
m_product_category description varchar 255  √  null Optional short description of the record
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isdefault bpchar 1 'N'::bpchar Default value
m_product_category isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
m_product_category m_product_category_uu varchar 36  √  NULL::character varying M_Product_Category_UU
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
m_product_category name varchar 60 Alphanumeric identifier of the entity
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
m_product_category updated timestamp 29,6 now() Date this record was updated
m_product_category updatedby numeric 10 User who updated this records
m_product_category value varchar 40 Search key for the record in the format required - must be unique