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

idempiere9.adempiere contains 321 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
r_request a_asset_id numeric 10  √  null Asset used internally or by customers
r_request_v a_asset_id numeric 10  √  null
r_requestaction a_asset_id numeric 10  √  null Asset used internally or by customers
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
r_mailtext ad_client_id numeric 10 Client/Tenant for this installation.
r_request ad_client_id numeric 10 Client/Tenant for this installation.
r_request_v ad_client_id numeric 10  √  null
r_requestaction ad_client_id numeric 10 Client/Tenant for this installation.
r_requestprocessor ad_client_id numeric 10 Client/Tenant for this installation.
r_requestprocessor_route ad_client_id numeric 10 Client/Tenant for this installation.
r_requesttype ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_user ad_org_id numeric 10 Organizational entity within client
r_mailtext ad_org_id numeric 10 Organizational entity within client
r_request ad_org_id numeric 10 Organizational entity within client
r_request_v ad_org_id numeric 10  √  null
r_requestaction ad_org_id numeric 10 Organizational entity within client
r_requestprocessor ad_org_id numeric 10 Organizational entity within client
r_requestprocessor_route ad_org_id numeric 10 Organizational entity within client
r_requesttype ad_org_id numeric 10 Organizational entity within client
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
r_request ad_role_id numeric 10  √  null Responsibility Role
r_request_v ad_role_id numeric 10  √  null
r_requestaction ad_role_id numeric 10  √  null Responsibility Role
r_requestprocessor ad_schedule_id numeric 10 NULL::numeric Schedule
r_request ad_table_id numeric 10  √  null Database Table information
r_request_v ad_table_id numeric 10  √  null
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
r_request ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
r_request_v ad_user_id numeric 10  √  null
r_requestaction ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
r_requestprocessor_route ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ad_user answer varchar 1024  √  NULL::character varying Answer
r_requesttype autoduedatedays numeric 10  √  null Automatic Due Date Days
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
ad_user bpname varchar 60  √  NULL::character varying BP Name
r_request c_activity_id numeric 10  √  null Business Activity
r_request_v c_activity_id numeric 10  √  null
r_requestaction c_activity_id numeric 10  √  null Business Activity
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
r_request c_bpartner_id numeric 10  √  null Identifies a Business Partner
r_request_v c_bpartner_id numeric 10  √  null
r_requestaction c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
r_request c_campaign_id numeric 10  √  null Marketing Campaign
r_request_v c_campaign_id numeric 10  √  null
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
r_request c_invoice_id numeric 10  √  null Invoice Identifier
r_request_v c_invoice_id numeric 10  √  null
r_requestaction c_invoice_id numeric 10  √  null Invoice Identifier
r_request c_invoicerequest_id numeric 10  √  null The generated invoice for this request
r_request_v c_invoicerequest_id numeric 10  √  null
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
r_request c_order_id numeric 10  √  null Order
r_request_v c_order_id numeric 10  √  null
r_requestaction c_order_id numeric 10  √  null Order
r_request c_payment_id numeric 10  √  null Payment identifier
r_request_v c_payment_id numeric 10  √  null
r_requestaction c_payment_id numeric 10  √  null Payment identifier
r_request c_project_id numeric 10  √  null Financial Project
r_request_v c_project_id numeric 10  √  null
r_requestaction c_project_id numeric 10  √  null Financial Project
r_request closedate timestamp 29,6  √  null Close Date
r_request_v closedate timestamp 29,6  √  null
ad_user comments varchar 2000  √  null Comments or additional information
r_request confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_request_v confidentialtype bpchar 1  √  null
r_requestaction confidentialtype bpchar 1  √  null Type of Confidentiality
r_requesttype confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_request confidentialtypeentry bpchar 1 Confidentiality of the individual entry
r_request_v confidentialtypeentry bpchar 1  √  null
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
r_requesttype contentcolor varchar 7  √  NULL::character varying Content color of calendar dashlet
ad_user created timestamp 29,6 now() Date this record was created
r_mailtext created timestamp 29,6 now() Date this record was created
r_request created timestamp 29,6 now() Date this record was created
r_request_v created timestamp 29,6  √  null
r_requestaction created timestamp 29,6 now() Date this record was created
r_requestprocessor created timestamp 29,6 now() Date this record was created
r_requestprocessor_route created timestamp 29,6 now() Date this record was created
r_requesttype created timestamp 29,6 now() Date this record was created
ad_user createdby numeric 10 User who created this records
r_mailtext createdby numeric 10 User who created this records
r_request createdby numeric 10 User who created this records
r_request_v createdby numeric 10  √  null
r_requestaction createdby numeric 10 User who created this records
r_requestprocessor createdby numeric 10 User who created this records
r_requestprocessor_route createdby numeric 10 User who created this records
r_requesttype createdby numeric 10 User who created this records
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
r_request datecompleteplan timestamp 29,6  √  null Planned Completion Date
r_request_v datecompleteplan timestamp 29,6  √  null
r_requestaction datecompleteplan timestamp 29,6  √  null Planned Completion Date
r_request datelastaction timestamp 29,6  √  null Date this request was last acted on
r_request_v datelastaction timestamp 29,6  √  null
r_request datelastalert timestamp 29,6  √  null Date when last alert were sent
r_request_v datelastalert timestamp 29,6  √  null
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
r_requestprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
r_request datenextaction timestamp 29,6  √  null Date that this request should be acted on
r_request_v datenextaction timestamp 29,6  √  null
r_requestaction datenextaction timestamp 29,6  √  null Date that this request should be acted on
r_requestprocessor datenextrun timestamp 29,6  √  null Date the process will run next
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
r_request datestartplan timestamp 29,6  √  null Planned Start Date
r_request_v datestartplan timestamp 29,6  √  null
r_requestaction datestartplan timestamp 29,6  √  null Planned Start Date
ad_user description varchar 255  √  null Optional short description of the record
r_requestprocessor description varchar 255  √  null Optional short description of the record
r_requesttype description varchar 255  √  null Optional short description of the record
r_request documentno varchar 30 Document sequence number of the document
r_request_v documentno varchar 30  √  null
r_requesttype duedatetolerance numeric 10 7 Tolerance in days between the Date Next Action and the date the request is regarded as overdue
r_request duetype bpchar 1 Status of the next action for this Request
r_request_v duetype bpchar 1  √  null
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
r_requestaction enddate timestamp 29,6  √  null Last effective date (inclusive)
r_request endtime timestamp 29,6  √  null End of the time span
r_request_v endtime timestamp 29,6  √  null
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_user fax varchar 40  √  null Facsimile number
r_requestprocessor frequency numeric 10  √  (1)::numeric Frequency of events
r_requestprocessor frequencytype bpchar 1  √  null Frequency of event
r_requesttype headercolor varchar 7  √  NULL::character varying Header color of calendar dashlet
r_requestprocessor inactivityalertdays numeric 10 0 Send Alert when there is no activity after days (0= no alert)
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
r_mailtext isactive bpchar 1 'Y'::bpchar The record is active in the system
r_request isactive bpchar 1 'Y'::bpchar The record is active in the system
r_request_v isactive bpchar 1  √  null
r_requestaction isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestprocessor_route isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requesttype 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
r_requesttype isautochangerequest bpchar 1 'N'::bpchar Automatically create BOM (Engineering) Change Request
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
r_requesttype isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
r_requesttype isdefault bpchar 1 'N'::bpchar Default value
r_requesttype isemailwhendue bpchar 1 'N'::bpchar Send EMail when Request becomes due
r_requesttype isemailwhenoverdue bpchar 1 'N'::bpchar Send EMail when Request becomes overdue
r_request isescalated bpchar 1 'N'::bpchar This request has been escalated
r_request_v isescalated bpchar 1  √  null
r_requestaction isescalated bpchar 1  √  null This request has been escalated
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
r_mailtext ishtml bpchar 1 'N'::bpchar Text has HTML tags
r_requesttype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
r_request isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
r_request_v isinvoiced bpchar 1  √  null
r_requestaction isinvoiced bpchar 1  √  null Is this invoiced?
r_requesttype isinvoiced bpchar 1  √  null Is this invoiced?
ad_user islocked bpchar 1 'N'::bpchar Locked
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
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
r_request isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_request_v isselfservice bpchar 1  √  null
r_requestaction isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttype 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
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
r_requestprocessor keeplogdays numeric 10 Number of days to keep the log entries
r_requestprocessor_route keyword varchar 60  √  null Case insensitive keyword
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
ad_user lastresult varchar 255  √  null Result of last contact
r_request lastresult varchar 2000  √  null Result of last contact
r_request_v lastresult varchar 2000  √  null
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
r_request m_changerequest_id numeric 10  √  null BOM (Engineering) Change Request
r_request_v m_changerequest_id numeric 10  √  null
r_request m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
r_request_v m_fixchangenotice_id numeric 10  √  null
r_request m_inout_id numeric 10  √  null Material Shipment Document
r_request_v m_inout_id numeric 10  √  null
r_requestaction m_inout_id numeric 10  √  null Material Shipment Document
r_request m_product_id numeric 10  √  null Product, Service, Item
r_request_v m_product_id numeric 10  √  null
r_requestaction m_product_id numeric 10  √  null Product, Service, Item
r_request m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
r_request_v m_productspent_id numeric 10  √  null
r_requestaction m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
r_request m_rma_id numeric 10  √  null Return Material Authorization
r_request_v m_rma_id numeric 10  √  null
r_requestaction m_rma_id numeric 10  √  null Return Material Authorization
r_mailtext mailheader varchar 2000  √  null Mail Header (Subject)
r_mailtext mailtext text 2147483647 Text used for Mail message
r_mailtext mailtext2 varchar 2000  √  null Optional second text part used for Mail message
r_mailtext mailtext3 varchar 2000  √  null Optional third text part used for Mail message
ad_user name varchar 60 Alphanumeric identifier of the entity
r_mailtext name varchar 60 Alphanumeric identifier of the entity
r_requestprocessor name varchar 60 Alphanumeric identifier of the entity
r_requesttype name varchar 60 Alphanumeric identifier of the entity
r_request nextaction bpchar 1  √  null Next Action to be taken
r_request_v nextaction bpchar 1  √  null
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
r_requestaction nullcolumns varchar 255  √  null Columns with NULL value
r_requestprocessor overduealertdays numeric 10 Send email alert after number of days due (0=no alerts)
r_requestprocessor overdueassigndays numeric 10 Escalation to superior after number of due days (0 = no)
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
r_request priority bpchar 1 Indicates if this request is of a high, medium or low priority.
r_request_v priority bpchar 1  √  null
r_requestaction priority bpchar 1  √  null Indicates if this request is of a high, medium or low priority.
r_request priorityuser bpchar 1  √  null Priority of the issue for the User
r_request_v priorityuser bpchar 1  √  null
r_requestaction priorityuser bpchar 1  √  null Priority of the issue for the User
r_request processed bpchar 1 'N'::bpchar The document has been processed
r_request_v processed bpchar 1  √  null
ad_user processing bpchar 1  √  null Process Now
r_requestprocessor processing bpchar 1  √  null Process Now
r_request qtyinvoiced numeric 0  √  0 Invoiced Quantity
r_request_v qtyinvoiced numeric 0  √  null
r_requestaction qtyinvoiced numeric 0  √  null Invoiced Quantity
r_request qtyplan numeric 0  √  null Planned Quantity
r_request_v qtyplan numeric 0  √  null
r_requestaction qtyplan numeric 0  √  null Planned Quantity
r_request qtyspent numeric 0  √  0 Quantity used for this event
r_request_v qtyspent numeric 0  √  null
r_requestaction qtyspent numeric 0  √  null Quantity used for this event
r_request r_category_id numeric 10  √  null Request Category
r_request_v r_category_id numeric 10  √  null
r_requestaction r_category_id numeric 10  √  null Request Category
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
r_request r_group_id numeric 10  √  null Request Group
r_request_v r_group_id numeric 10  √  null
r_requestaction r_group_id numeric 10  √  null Request Group
r_mailtext r_mailtext_id numeric 10 Text templates for mailings
r_request r_mailtext_id numeric 10  √  null Text templates for mailings
r_request_v r_mailtext_id numeric 10  √  null
r_mailtext r_mailtext_uu varchar 36  √  NULL::character varying R_MailText_UU
r_request r_request_id numeric 10 Request from a Business Partner or Prospect
r_request_v r_request_id numeric 10  √  null
r_requestaction r_request_id numeric 10 Request from a Business Partner or Prospect
r_request r_request_uu varchar 36  √  NULL::character varying R_Request_UU
r_requestaction r_requestaction_id numeric 10 Request has been changed
r_requestaction r_requestaction_uu varchar 36  √  NULL::character varying R_RequestAction_UU
r_requestprocessor r_requestprocessor_id numeric 10 Processor for Requests
r_requestprocessor_route r_requestprocessor_id numeric 10 Processor for Requests
r_requestprocessor_route r_requestprocessor_route_id numeric 10 Automatic routing of requests
r_requestprocessor_route r_requestprocessor_route_uu varchar 36  √  NULL::character varying R_RequestProcessor_Route_UU
r_requestprocessor r_requestprocessor_uu varchar 36  √  NULL::character varying R_RequestProcessor_UU
r_request r_requestrelated_id numeric 10  √  null Related Request (Master Issue, ..)
r_request_v r_requestrelated_id numeric 10  √  null
r_request r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_request_v r_requesttype_id numeric 10  √  null
r_requestaction r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor_route r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_uu varchar 36  √  NULL::character varying R_RequestType_UU
r_request r_resolution_id numeric 10  √  null Request Resolution
r_request_v r_resolution_id numeric 10  √  null
r_requestaction r_resolution_id numeric 10  √  null Request Resolution
r_request r_standardresponse_id numeric 10  √  null Request Standard Response
r_request_v r_standardresponse_id numeric 10  √  null
r_request r_status_id numeric 10  √  null Request Status
r_request_v r_status_id numeric 10  √  null
r_requestaction r_status_id numeric 10  √  null Request Status
r_requesttype r_statuscategory_id numeric 10 Request Status Category
r_request record_id numeric 10  √  null Direct internal record ID
r_request_v record_id numeric 10  √  null
r_requestprocessor reminddays numeric 10 7 Days between sending Reminder Emails for a due or inactive Document
r_request requestamt numeric 0 0 Amount associated with this request
r_request_v requestamt numeric 0  √  null
r_request result varchar 2000  √  null Result of the action taken
r_request_v result varchar 2000  √  null
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
r_request salesrep_id numeric 10 Sales Representative or Company Agent
r_request_v salesrep_id numeric 10  √  null
r_requestaction salesrep_id numeric 10  √  null Sales Representative or Company Agent
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user securityquestion varchar 1024  √  null Security Question
r_requestprocessor_route seqno numeric 10 Method of ordering records; lowest number comes first
r_request startdate timestamp 29,6  √  null First effective day (inclusive)
r_request_v startdate timestamp 29,6  √  null
r_requestaction startdate timestamp 29,6  √  null First effective day (inclusive)
r_request starttime timestamp 29,6  √  null Time started
r_request_v starttime timestamp 29,6  √  null
r_request summary varchar 2000 Textual summary of this request
r_request_v summary varchar 2000  √  null
r_requestaction summary varchar 2000  √  null Textual summary of this request
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
r_requestprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
r_request taskstatus bpchar 1  √  null Status of the Task
r_request_v taskstatus bpchar 1  √  null
r_requestaction taskstatus bpchar 1  √  null Status of the Task
ad_user title varchar 40  √  null Name this entity is referred to as
ad_user updated timestamp 29,6 now() Date this record was updated
r_mailtext updated timestamp 29,6 now() Date this record was updated
r_request updated timestamp 29,6 now() Date this record was updated
r_request_v updated timestamp 29,6  √  null
r_requestaction updated timestamp 29,6 now() Date this record was updated
r_requestprocessor updated timestamp 29,6 now() Date this record was updated
r_requestprocessor_route updated timestamp 29,6 now() Date this record was updated
r_requesttype updated timestamp 29,6 now() Date this record was updated
ad_user updatedby numeric 10 User who updated this records
r_mailtext updatedby numeric 10 User who updated this records
r_request updatedby numeric 10 User who updated this records
r_request_v updatedby numeric 10  √  null
r_requestaction updatedby numeric 10 User who updated this records
r_requestprocessor updatedby numeric 10 User who updated this records
r_requestprocessor_route updatedby numeric 10 User who updated this records
r_requesttype updatedby numeric 10 User who updated this records
ad_user userpin varchar 20  √  null User PIN
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique