SchemaSpy Analysis of idempiere11.adempiere - ColumnsRelations Management | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:54 +0100 |
| |||||
|
idempiere11.adempiere contains 323 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 | |
r_request_v | ad_client_id | numeric | 10 | √ | null | ||
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
r_request_v | ad_org_id | numeric | 10 | √ | null | ||
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_request | ad_table_id | numeric | 10 | √ | null | Database Table information | |
r_request_v | ad_table_id | numeric | 10 | √ | null | ||
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 | |
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
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_v | confidentialtype | bpchar | 1 | √ | null | ||
r_requestaction | confidentialtype | bpchar | 1 | √ | null | Type of Confidentiality | |
r_request_v | confidentialtypeentry | bpchar | 1 | √ | null | ||
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
r_requesttype | contentcolor | varchar | 7 | √ | NULL::character varying | Content color of calendar dashlet | |
r_request_v | created | timestamp | 29,6 | √ | null | ||
r_request_v | createdby | numeric | 10 | √ | null | ||
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_v | documentno | varchar | 30 | √ | null | ||
r_request_v | duetype | bpchar | 1 | √ | null | ||
ad_user | 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 | 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_request_v | isactive | bpchar | 1 | √ | null | ||
r_request_v | isescalated | bpchar | 1 | √ | null | ||
r_requestaction | isescalated | bpchar | 1 | √ | null | This request has been escalated | |
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 | ismenuautoexpand | bpchar | 1 | √ | null | If ticked, the menu is automatically expanded | |
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_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 | 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 | |
r_request | nextaction | bpchar | 1 | √ | null | Next Action to be taken | |
r_request_v | nextaction | bpchar | 1 | √ | null | ||
r_requestaction | nullcolumns | varchar | 255 | √ | null | Columns with NULL value | |
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_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_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_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_v | r_request_id | numeric | 10 | √ | null | ||
r_request | r_request_uu | varchar | 36 | √ | NULL::character varying | R_Request_UU | |
r_requestaction | r_requestaction_uu | varchar | 36 | √ | NULL::character varying | R_RequestAction_UU | |
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_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_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_request | record_id | numeric | 10 | √ | null | Direct internal record ID | |
r_request_v | record_id | numeric | 10 | √ | null | ||
r_request | record_uu | varchar | 36 | √ | NULL::character varying | Record UUID | |
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_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_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_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_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 | |
r_request_v | updated | timestamp | 29,6 | √ | null | ||
r_request_v | updatedby | numeric | 10 | √ | null | ||
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 | |
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_mailtext | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_request | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_requestaction | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_requestprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_requestprocessor_route | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_requesttype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_mailtext | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_request | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requestaction | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requestprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requestprocessor_route | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requesttype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requestprocessor | ad_schedule_id | numeric | 10 | NULL::numeric | Schedule | ||
ad_user | ad_user_id | numeric | 10 | 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 | |||
r_request | confidentialtype | bpchar | 1 | 'C'::bpchar | Type of Confidentiality | ||
r_requesttype | confidentialtype | bpchar | 1 | 'C'::bpchar | Type of Confidentiality | ||
r_request | confidentialtypeentry | bpchar | 1 | Confidentiality of the individual entry | |||
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_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_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 | |||
r_request | documentno | varchar | 30 | Document sequence number of the document | |||
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 | |||
ad_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
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_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 | ||
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? | ||
ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
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_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_mailtext | mailtext | text | 2147483647 | Text 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 | |||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
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) | |||
r_request | priority | bpchar | 1 | Indicates if this request is of a high, medium or low priority. | |||
r_request | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
r_mailtext | r_mailtext_id | numeric | 10 | Text templates for mailings | |||
r_request | r_request_id | numeric | 10 | Request from a Business Partner or Prospect | |||
r_requestaction | r_request_id | numeric | 10 | Request from a Business Partner or Prospect | |||
r_requestaction | r_requestaction_id | numeric | 10 | Request has been changed | |||
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_request | r_requesttype_id | numeric | 10 | Type of request (e.g. Inquiry, Complaint, ..) | |||
r_requesttype | r_requesttype_id | numeric | 10 | Type of request (e.g. Inquiry, Complaint, ..) | |||
r_requesttype | r_statuscategory_id | numeric | 10 | Request Status Category | |||
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 | salesrep_id | numeric | 10 | Sales Representative or Company Agent | |||
r_requestprocessor_route | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
r_request | summary | varchar | 2000 | Textual summary of this request | |||
r_requestprocessor | supervisor_id | numeric | 10 | Supervisor for this user/organization - used for escalation and approval | |||
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_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_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 |