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

idempiere9.adempiere contains 524 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
a_asset a_qty_current numeric 0  √  null Current Qty
a_asset a_qty_original numeric 0  √  null A_QTY_Original
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
ad_system idrangeend numeric 0  √  null End if the ID Range used
ad_system idrangestart numeric 0  √  null Start of the ID Range used
a_asset lifeuseunits numeric 0  √  null Units of use until the asset is not usable anymore
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
a_asset qty numeric 0  √  null Quantity
m_product shelfheight numeric 0  √  null Shelf height required
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
m_product unitsperpallet numeric 0  √  null Units Per Pallet
a_asset useunits numeric 0  √  null Currently used units of the assets
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
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
a_asset isactive bpchar 1 'Y'::bpchar The record is active in the system
a_registration isactive bpchar 1 'Y'::bpchar The record is active in the system
a_registrationattribute isactive bpchar 1 'Y'::bpchar The record is active in the system
a_registrationproduct isactive bpchar 1 'Y'::bpchar The record is active in the system
a_registrationvalue isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_entitytype isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_language isactive bpchar 1 'N'::bpchar The record is active in the system
ad_modification isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_reference isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_registration isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_system isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
a_registration isallowpublish bpchar 1 'Y'::bpchar You allow to publish the information, not just statistical summary info
ad_registration isallowpublish bpchar 1 'Y'::bpchar You allow to publish the information, not just statistical summary info
ad_registration isallowstatistics bpchar 1 'Y'::bpchar Maintain general statistics
ad_system isallowstatistics bpchar 1 'Y'::bpchar Maintain general statistics
ad_process_para isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_system isautoerrorreport bpchar 1 'Y'::bpchar Automatically report Errors
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
ad_language isbaselanguage bpchar 1 'N'::bpchar The system information is maintained in this language
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_language isdecimalpoint bpchar 1  √  null The number notation has a decimal point (no decimal comma)
a_asset isdepreciated bpchar 1 'Y'::bpchar The asset will be depreciated
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
a_asset isdisposed bpchar 1 'N'::bpchar The asset is disposed
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
ad_process_para isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_system isfailonbuilddiffer bpchar 1 'N'::bpchar Fail if Build Differ
ad_system isfailonmissingmodelvalidator bpchar 1 'Y'::bpchar Fail on Missing Model Validator
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
a_asset isfullydepreciated bpchar 1 'N'::bpchar The asset is fully depreciated
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
a_asset isinposession bpchar 1 'Y'::bpchar The asset is in the possession of the organization
a_registration isinproduction bpchar 1 'N'::bpchar The system is in production
ad_registration isinproduction bpchar 1 'N'::bpchar The system is in production
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
ad_system isjustmigrated bpchar 1  √  'N'::bpchar Value set by Migration for post-Migration tasks.
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
ad_user islocked bpchar 1 'N'::bpchar Locked
ad_language isloginlocale bpchar 1  √  'N'::bpchar Login Locale
ad_process_para ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
ad_reference isorderbyvalue bpchar 1  √  'N'::bpchar Order list using the value column instead of the name column
m_product isownbox bpchar 1 'N'::bpchar Own Box
a_asset isowned bpchar 1 'Y'::bpchar The asset is owned by the organization
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
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
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
ad_process_para isrange bpchar 1 'N'::bpchar The parameter is a range of values
a_registration isregistered bpchar 1 'N'::bpchar The application is registered.
ad_registration isregistered bpchar 1 'N'::bpchar The application is registered.
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
a_registrationattribute isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_language issystemlanguage bpchar 1 'N'::bpchar The screens, etc. are maintained in this Language
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
m_product istoformule bpchar 1  √  null
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
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
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
a_asset processed bpchar 1 'N'::bpchar The document has been processed
a_asset processing bpchar 1  √  'N'::bpchar Process Now
a_registration processing bpchar 1  √  null Process Now
ad_entitytype processing bpchar 1  √  null Process Now
ad_language processing bpchar 1  √  null Process Now
ad_registration processing bpchar 1  √  null Process Now
ad_system processing bpchar 1  √  null Process Now
ad_user processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
c_bpartner rating bpchar 1  √  null Classification or Importance
ad_system replicationtype bpchar 1 'L'::bpchar Type of Data Replication
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
ad_system systemstatus bpchar 1 'E'::bpchar Status of the system - Support priority depends on system status
ad_reference validationtype bpchar 1 Different method of validating data
a_asset a_asset_action varchar 2 'MD'::character varying Asset Action
a_asset a_asset_status varchar 2 'NW'::character varying Asset Status
ad_language 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
ad_language languageiso bpchar 2  √  null Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
a_asset a_assettype varchar 3 'MFX'::character varying Asset Type
ad_language ad_language varchar 6 Language for this entity
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
a_asset a_asset_class_id numeric 10  √  NULL::numeric Asset class
a_asset a_asset_group_id numeric 10 Group of Assets
a_asset a_asset_id numeric 10 Asset used internally or by customers
a_registration a_asset_id numeric 10  √  null Asset used internally or by customers
a_asset a_asset_type_id numeric 10  √  null Asset Type
a_asset a_parent_asset_id numeric 10  √  null Parent Asset
a_registration a_registration_id numeric 10 User Asset Registration
a_registrationvalue a_registration_id numeric 10 User Asset Registration
a_registrationattribute a_registrationattribute_id numeric 10 Asset Registration Attribute
a_registrationproduct a_registrationattribute_id numeric 10 Asset Registration Attribute
a_registrationvalue a_registrationattribute_id numeric 10 Asset Registration Attribute
a_asset ad_client_id numeric 10 Client/Tenant for this installation.
a_registration ad_client_id numeric 10 Client/Tenant for this installation.
a_registrationattribute ad_client_id numeric 10 Client/Tenant for this installation.
a_registrationproduct ad_client_id numeric 10 Client/Tenant for this installation.
a_registrationvalue ad_client_id numeric 10 Client/Tenant for this installation.
ad_entitytype ad_client_id numeric 10 Client/Tenant for this installation.
ad_language ad_client_id numeric 10 Client/Tenant for this installation.
ad_modification ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_reference ad_client_id numeric 10 Client/Tenant for this installation.
ad_registration ad_client_id numeric 10 Client/Tenant for this installation.
ad_system ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_para ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_reference ad_element_id numeric 10  √  NULL::numeric System Element enables the central maintenance of column description and help.
ad_entitytype ad_entitytype_id numeric 10 System Entity Type
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_language ad_language_id numeric 10 Language ID
ad_modification ad_modification_id numeric 10 System Modification or Extension
a_asset ad_org_id numeric 10 Organizational entity within client
a_registration ad_org_id numeric 10 Organizational entity within client
a_registrationattribute ad_org_id numeric 10 Organizational entity within client
a_registrationproduct ad_org_id numeric 10 Organizational entity within client
a_registrationvalue ad_org_id numeric 10 Organizational entity within client
ad_entitytype ad_org_id numeric 10 Organizational entity within client
ad_language ad_org_id numeric 10 Organizational entity within client
ad_modification ad_org_id numeric 10 Organizational entity within client
ad_process_para ad_org_id numeric 10 Organizational entity within client
ad_reference ad_org_id numeric 10 Organizational entity within client
ad_registration ad_org_id numeric 10 Organizational entity within client
ad_system ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
m_product 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
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_language ad_printpaper_id numeric 10  √  NULL::numeric Printer paper definition
ad_process_para ad_process_id numeric 10 Process or Report
ad_process_para ad_process_para_id numeric 10 Process Parameter
a_registrationattribute ad_reference_id numeric 10 System Reference and Validation
ad_process_para ad_reference_id numeric 10 System Reference and Validation
ad_reference ad_reference_id numeric 10 System Reference and Validation
a_registrationattribute ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_process_para ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_registration ad_registration_id numeric 10 System Registration
ad_registration ad_system_id numeric 10 System Definition
ad_system ad_system_id numeric 10 System Definition
a_asset ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
a_registration ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_process_para ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
a_asset c_activity_id numeric 10  √  NULL::numeric Business Activity
c_bpartner c_bp_group_id numeric 10 Business Partner Group
a_asset c_bpartner_id numeric 10  √  null Identifies a Business Partner
a_registration c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
a_asset c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
a_asset c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
ad_registration c_currency_id numeric 10  √  null The Currency for this record
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
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
ad_user c_job_id numeric 10  √  null Job Position
a_asset c_location_id numeric 10  √  null Location or Address
ad_registration c_location_id numeric 10  √  null Location or Address
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
a_asset c_project_id numeric 10  √  null Financial Project
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
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
m_product c_uom_id numeric 10 Unit of Measure
a_asset createdby numeric 10 User who created this records
a_registration createdby numeric 10 User who created this records
a_registrationattribute createdby numeric 10 User who created this records
a_registrationproduct createdby numeric 10 User who created this records
a_registrationvalue createdby numeric 10 User who created this records
ad_entitytype createdby numeric 10 User who created this records
ad_language createdby numeric 10 User who created this records
ad_modification createdby numeric 10 User who created this records
ad_process_para createdby numeric 10 User who created this records
ad_reference createdby numeric 10 User who created this records
ad_registration createdby numeric 10 User who created this records
ad_system createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
m_product 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
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_process_para fieldlength numeric 10 Length of the column in the database
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
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
a_asset lastmaintenanceunit numeric 10  √  null Last Maintenance Unit
a_asset lastmaintenanceuseunit numeric 10  √  null
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
a_asset lease_bpartner_id numeric 10  √  null The Business Partner who rents or leases
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
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
a_asset m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
a_asset m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
a_asset m_locator_id numeric 10  √  null Warehouse Locator
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_product m_product_category_id numeric 10 Category of a Product
a_asset m_product_id numeric 10 Product, Service, Item
a_registration m_product_id numeric 10  √  null Product, Service, Item
a_registrationproduct m_product_id numeric 10 Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
a_asset manufacturedyear numeric 10  √  NULL::numeric Manufactured Year
a_asset nextmaintenanceuseunit numeric 10  √  null
a_asset nextmaintenenceunit numeric 10  √  null Next Maintenence Unit
ad_system noprocessors numeric 10  √  null Number of Database Processors
ad_registration numberemployees numeric 10  √  0 Number of employees
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
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
ad_registration record_id numeric 10  √  null Direct internal record ID
ad_system record_id numeric 10  √  null Direct internal record ID
ad_system releaseno varchar 10  √  null Internal Release Number
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
ad_registration salesvolume numeric 10  √  0 Total Volume of Sales in Thousands of Currency
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
a_registrationattribute seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_modification seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_process_para seqno numeric 10 Method of ordering records; lowest number comes first
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_system supportunits numeric 10  √  null Number of Internal Users for iDempiere Support
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
a_asset updatedby numeric 10 User who updated this records
a_registration updatedby numeric 10 User who updated this records
a_registrationattribute updatedby numeric 10 User who updated this records
a_registrationproduct updatedby numeric 10 User who updated this records
a_registrationvalue updatedby numeric 10 User who updated this records
ad_entitytype updatedby numeric 10 User who updated this records
ad_language updatedby numeric 10 User who updated this records
ad_modification updatedby numeric 10 User who updated this records
ad_process_para updatedby numeric 10 User who updated this records
ad_reference updatedby numeric 10 User who updated this records
ad_registration updatedby numeric 10 User who updated this records
ad_system updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
a_asset uselifemonths numeric 10  √  null Months of the usable life of the asset
a_asset uselifeyears numeric 10  √  null Years of the usable life of the asset
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
m_product classification varchar 12  √  null Classification for grouping
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
ad_language datepattern varchar 20  √  null Java Date Pattern
ad_system password varchar 20  √  null Password of any length (case sensitive)
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
ad_language timepattern varchar 20  √  null Java Time Pattern
ad_user userpin varchar 20  √  null User PIN
ad_process_para valuemax varchar 20  √  null Maximum Value for a field
ad_process_para valuemin varchar 20  √  null Minimum Value for a field
ad_entitytype version varchar 20  √  null Version of the table definition
ad_modification version varchar 20  √  null Version of the table definition
ad_system version varchar 20  √  null Version of the table definition
a_asset versionno varchar 20  √  null Version Number
m_product versionno varchar 20  √  null Version Number
a_asset a_asset_createdate timestamp 29,6  √  null Create Date
a_asset a_asset_revaldate timestamp 29,6  √  null Revaluation Date
a_asset assetactivationdate timestamp 29,6  √  null Activation Date
a_asset assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
a_asset assetdisposaldate timestamp 29,6  √  null Date when the asset is/was disposed
a_asset assetservicedate timestamp 29,6  √  null Date when Asset was put into service
a_registration assetservicedate timestamp 29,6  √  null Date when Asset was put into service
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
a_asset created timestamp 29,6 now() Date this record was created
a_registration created timestamp 29,6 now() Date this record was created
a_registrationattribute created timestamp 29,6 now() Date this record was created
a_registrationproduct created timestamp 29,6 now() Date this record was created
a_registrationvalue created timestamp 29,6 now() Date this record was created
ad_entitytype created timestamp 29,6 now() Date this record was created
ad_language created timestamp 29,6 now() Date this record was created
ad_modification created timestamp 29,6 now() Date this record was created
ad_process_para created timestamp 29,6 now() Date this record was created
ad_reference created timestamp 29,6 now() Date this record was created
ad_registration created timestamp 29,6 now() Date this record was created
ad_system created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
a_asset guaranteedate timestamp 29,6  √  null Date when guarantee expires
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
a_asset lastmaintenancedate timestamp 29,6  √  null Last Maintenance Date
a_asset lastmaintenencedate timestamp 29,6  √  null
a_asset leaseterminationdate timestamp 29,6  √  null Lease Termination Date
a_asset nextmaintenencedate timestamp 29,6  √  null Next Maintenence Date
ad_registration startproductiondate timestamp 29,6  √  null The day you started the implementation (if implementing) - or production (went life) with iDempiere
ad_system supportexpdate timestamp 29,6  √  null Date when the iDempiere support expires
a_asset updated timestamp 29,6 now() Date this record was updated
a_registration updated timestamp 29,6 now() Date this record was updated
a_registrationattribute updated timestamp 29,6 now() Date this record was updated
a_registrationproduct updated timestamp 29,6 now() Date this record was updated
a_registrationvalue updated timestamp 29,6 now() Date this record was updated
ad_entitytype updated timestamp 29,6 now() Date this record was updated
ad_language updated timestamp 29,6 now() Date this record was updated
ad_modification updated timestamp 29,6 now() Date this record was updated
ad_process_para updated timestamp 29,6 now() Date this record was updated
ad_reference updated timestamp 29,6 now() Date this record was updated
ad_registration updated timestamp 29,6 now() Date this record was updated
ad_system updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
a_registrationattribute columnname varchar 30  √  null Name of the column in the database
ad_process_para columnname varchar 30 Name of the column in the database
a_asset inventoryno varchar 30  √  NULL::character varying Inventory No
a_asset manufacturer varchar 30  √  NULL::character varying Manufacturer of the Product
m_product sku varchar 30  √  null Stock Keeping Unit
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
a_asset a_asset_uu varchar 36  √  NULL::character varying A_Asset_UU
a_registration a_registration_uu varchar 36  √  NULL::character varying A_Registration_UU
a_registrationattribute a_registrationattribute_uu varchar 36  √  NULL::character varying A_RegistrationAttribute_UU
a_registrationproduct a_registrationproduct_uu varchar 36  √  NULL::character varying A_RegistrationProduct_UU
a_registrationvalue a_registrationvalue_uu varchar 36  √  NULL::character varying A_RegistrationValue_UU
ad_entitytype ad_entitytype_uu varchar 36  √  NULL::character varying AD_EntityType_UU
ad_language ad_language_uu varchar 36  √  NULL::character varying AD_Language_UU
ad_modification ad_modification_uu varchar 36  √  NULL::character varying AD_Modification_UU
ad_process_para ad_process_para_uu varchar 36  √  NULL::character varying AD_Process_Para_UU
ad_reference ad_reference_uu varchar 36  √  NULL::character varying AD_Reference_UU
ad_registration ad_registration_uu varchar 36  √  NULL::character varying AD_Registration_UU
ad_system ad_system_uu varchar 36  √  NULL::character varying AD_System_UU
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_entitytype entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_modification entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process_para entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_reference entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_user fax varchar 40  √  null Facsimile number
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
ad_user title varchar 40  √  null Name this entity is referred to as
a_asset value varchar 40 Search key for the record in the format required - must be unique
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 40 Search key for the record in the format required - must be unique
ad_reference vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_user bpname varchar 60  √  NULL::character varying BP Name
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
ad_system customprefix varchar 60  √  null Prefix for Custom entities
ad_system dbinstance varchar 60  √  null Database Name
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
a_asset lastmaintenancenote varchar 60  √  null Last Maintenance Note
ad_system ldaphost varchar 60  √  null Connection String to LDAP server starting with ldap://
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
a_asset name varchar 60 Alphanumeric identifier of the entity
a_registration name varchar 60 Alphanumeric identifier of the entity
a_registrationattribute name varchar 60 Alphanumeric identifier of the entity
a_registrationvalue name varchar 60 Alphanumeric identifier of the entity
ad_entitytype name varchar 60 Alphanumeric identifier of the entity
ad_language name varchar 60 Alphanumeric identifier of the entity
ad_modification name varchar 60 Alphanumeric identifier of the entity
ad_process_para name varchar 60 Alphanumeric identifier of the entity
ad_reference name varchar 60 Alphanumeric identifier of the entity
ad_system name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
ad_system oldname varchar 60  √  null Old Name
ad_language printname varchar 60 NULL::character varying The label text to be printed on a document or correspondence.
a_registration remote_addr varchar 60  √  null Remote Address
ad_registration remote_addr varchar 60  √  null Remote Address
ad_system statisticsinfo varchar 60  √  null Information to help profiling the system for solving support issues
ad_system supportemail varchar 60  √  null EMail address to send support information and updates to
ad_system username varchar 60 User Name
m_product descriptionurl varchar 120  √  null URL for the description
m_product downloadurl varchar 120  √  null
m_product imageurl varchar 120  √  null URL of image
c_bpartner name varchar 120 Alphanumeric identifier of the entity
a_registration remote_host varchar 120  √  null Remote host Info
ad_registration remote_host varchar 120  √  null Remote host Info
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_entitytype classpath varchar 255  √  null Extension Classpath
ad_system dbaddress varchar 255  √  null JDBC URL of the database server
a_asset description varchar 255  √  null Optional short description of the record
a_registration description varchar 255  √  null Optional short description of the record
a_registrationattribute description varchar 255  √  null Optional short description of the record
a_registrationproduct description varchar 255  √  null Optional short description of the record
a_registrationvalue description varchar 255  √  null Optional short description of the record
ad_entitytype description varchar 255  √  null Optional short description of the record
ad_modification description varchar 255  √  null Optional short description of the record
ad_process_para description varchar 255  √  null Optional short description of the record
ad_reference description varchar 255  √  null Optional short description of the record
ad_registration description varchar 255  √  null Optional short description of the record
ad_system description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_system encryptionkey varchar 255  √  null Encryption Class used for securing data content
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
ad_registration industryinfo varchar 255  √  null Information of the industry (e.g. professional service, distribution of furnitures, ..)
ad_system info varchar 255  √  null Information
ad_system lastbuildinfo varchar 255  √  null Last Build Info
ad_system lastmigrationscriptapplied varchar 255  √  NULL::character varying Register of the filename for the last migration script applied on this database
ad_user lastresult varchar 255  √  null Result of last contact
ad_system ldapdomain varchar 255  √  null Directory service domain name - e.g. idempiere.org
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
a_asset locationcomment varchar 255  √  null Additional comments or remarks concerning the location
a_asset lot varchar 255  √  null Lot number (alphanumeric)
ad_entitytype modelpackage varchar 255  √  null Java Package of the model classes
m_product name varchar 255 Alphanumeric identifier of the entity
ad_process_para placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_registration platforminfo varchar 255  √  null Information about Server and Client Platform
ad_system profileinfo varchar 255  √  null Information to help profiling the system for solving support issues
a_asset serno varchar 255  √  null Product Serial Number
c_bpartner so_description varchar 255  √  null Description to be used on orders
ad_system summary varchar 255  √  null Textual summary of this request
ad_process_para vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user securityquestion varchar 1024  √  null Security Question
ad_user comments varchar 2000  √  null Comments or additional information
ad_process_para defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para defaultvalue2 varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
m_product documentnote varchar 2000  √  null Additional information for a Document
a_asset help varchar 2000  √  null Comment or Hint
a_registration help varchar 2000  √  null Comment or Hint
ad_entitytype help varchar 2000  √  null Comment or Hint
ad_modification help varchar 2000  √  null Comment or Hint
ad_process_para help varchar 2000  √  null Comment or Hint
ad_reference help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
a_registration note varchar 2000  √  null Optional additional user defined information
ad_process_para query varchar 2000  √  NULL::character varying SQL
ad_process_para readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)