| SchemaSpy Analysis of idempiere9.adempiere - ColumnsRequest Management | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:55 +0100 |
| |||||
|
| ||||||
idempiere9.adempiere contains 974 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 | |
| m_rma | amt | numeric | 0 | √ | null | Amount | |
| ad_role | amtapproval | numeric | 0 | √ | 0 | The approval amount limit for this role | |
| ad_role | amtapprovalaccum | numeric | 0 | √ | null | The approval amount limit for this role accumulated on a period | |
| m_inout | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
| c_bp_group | creditwatchpercent | numeric | 0 | √ | null | Credit Watch - Percent of Credit Limit when OK switches to Watch | |
| c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
| m_inout | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
| 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 | |
| c_bp_group | pricematchtolerance | numeric | 0 | √ | null | PO-Invoice Match Price Tolerance in percent of the purchase price | |
| m_inout | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
| a_asset | qty | numeric | 0 | √ | null | Quantity | |
| r_request | qtyinvoiced | numeric | 0 | √ | 0 | Invoiced Quantity | |
| r_requestaction | qtyinvoiced | numeric | 0 | √ | null | Invoiced Quantity | |
| r_requestupdate | qtyinvoiced | numeric | 0 | √ | 0 | Invoiced Quantity | |
| r_request | qtyplan | numeric | 0 | √ | null | Planned Quantity | |
| r_requestaction | qtyplan | numeric | 0 | √ | null | Planned Quantity | |
| r_request | qtyspent | numeric | 0 | √ | 0 | Quantity used for this event | |
| r_requestaction | qtyspent | numeric | 0 | √ | null | Quantity used for this event | |
| r_requestupdate | qtyspent | numeric | 0 | √ | 0 | Quantity used for this event | |
| r_request | requestamt | numeric | 0 | 0 | Amount associated with this request | ||
| 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_inout | volume | numeric | 0 | √ | null | Volume of a product | |
| m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
| m_inout | weight | numeric | 0 | √ | null | Weight of a product | |
| m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
| ad_table | accesslevel | bpchar | 1 | Access Level required | |||
| ad_role | allow_info_account | bpchar | 1 | 'Y'::bpchar | Allow Info Account | ||
| ad_role | allow_info_asset | bpchar | 1 | 'Y'::bpchar | Allow Info Asset | ||
| ad_role | allow_info_bpartner | bpchar | 1 | 'Y'::bpchar | Allow Info BPartner | ||
| ad_role | allow_info_cashjournal | bpchar | 1 | 'N'::bpchar | Allow Info CashJournal | ||
| ad_role | allow_info_crp | bpchar | 1 | 'N'::bpchar | Allow Info CRP | ||
| ad_role | allow_info_inout | bpchar | 1 | 'Y'::bpchar | Allow Info InOut | ||
| ad_role | allow_info_invoice | bpchar | 1 | 'Y'::bpchar | Allow Info Invoice | ||
| ad_role | allow_info_mrp | bpchar | 1 | 'N'::bpchar | Allow Info MRP | ||
| ad_role | allow_info_order | bpchar | 1 | 'Y'::bpchar | Allow Info Order | ||
| ad_role | allow_info_payment | bpchar | 1 | 'Y'::bpchar | Allow Info Payment | ||
| ad_role | allow_info_product | bpchar | 1 | 'Y'::bpchar | Allow Info Product | ||
| ad_role | allow_info_resource | bpchar | 1 | 'Y'::bpchar | Allow Info Resource | ||
| ad_role | allow_info_schedule | bpchar | 1 | 'Y'::bpchar | Allow Info Schedule | ||
| r_request | confidentialtype | bpchar | 1 | 'C'::bpchar | Type of Confidentiality | ||
| 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_requestupdate | confidentialtypeentry | bpchar | 1 | Confidentiality of the individual entry | |||
| ad_role | connectionprofile | bpchar | 1 | √ | null | How a Java Client connects to the server(s) | |
| ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Client connects to the server(s) | |
| ad_table | copycolumnsfromtable | varchar | 1 | √ | null | Copy Columns From Table | |
| ad_table | copycomponentsfromview | bpchar | 1 | √ | NULL::bpchar | Copy Components From View | |
| m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| m_inout | createconfirm | bpchar | 1 | √ | null | Create Confirm | |
| m_inout | createfrom | bpchar | 1 | √ | null | Process which will generate a new document lines based on an existing document | |
| m_rma | createfrom | bpchar | 1 | √ | NULL::bpchar | Process which will generate a new document lines based on an existing document | |
| m_inout | createpackage | bpchar | 1 | √ | null | Create Package | |
| ad_table | createwindowfromtable | bpchar | 1 | √ | NULL::bpchar | Create Window From Table | |
| ad_table | databaseviewdrop | bpchar | 1 | √ | NULL::bpchar | Drop view | |
| c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
| m_inout | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
| c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
| m_inout | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
| m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
| r_request | duetype | bpchar | 1 | Status of the next action for this Request | |||
| ad_smtp | emailtest | bpchar | 1 | √ | NULL::bpchar | Test EMail | |
| c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
| m_inout | freightcostrule | bpchar | 1 | Method for charging Freight | |||
| r_requestprocessor | frequencytype | bpchar | 1 | √ | null | Frequency of event | |
| m_inout | generateto | bpchar | 1 | √ | null | Generate To | |
| m_rma | generateto | bpchar | 1 | √ | null | Generate To | |
| ad_table | importtable | bpchar | 1 | √ | null | Import Table Columns from Database | |
| m_inout | insurance | bpchar | 1 | √ | NULL::bpchar | Insurance | |
| c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
| c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
| ad_role | isaccessadvanced | bpchar | 1 | √ | 'N'::bpchar | Access Advanced | |
| ad_role | isaccessallorgs | bpchar | 1 | 'N'::bpchar | Access all Organizations (no org access control) of the client | ||
| a_asset | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| a_asset_delivery | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| ad_role | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| ad_smtp | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| ad_table | 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 | ||
| ad_usermail | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_activity | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_group | 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_changenotice | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_changerequest | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_inout | 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 | ||
| m_rma | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_category | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_categoryupdates | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_contactinterest | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_group | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_groupupdates | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_interestarea | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| 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 | ||
| r_requesttypeupdates | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_requestupdate | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_requestupdates | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_resolution | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_standardresponse | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_status | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_statuscategory | 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 | ||
| m_inout | isalternatereturnaddress | bpchar | 1 | 'N'::bpchar | Alternate Return Address | ||
| m_changenotice | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| m_changerequest | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| m_inout | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| m_rma | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| r_requesttype | isautochangerequest | bpchar | 1 | 'N'::bpchar | Automatically create BOM (Engineering) Change Request | ||
| m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
| ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
| m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
| ad_role | iscanapproveowndoc | bpchar | 1 | 'Y'::bpchar | Users with this role can approve their own documents | ||
| ad_role | iscanexport | bpchar | 1 | 'Y'::bpchar | Users with this role can export data | ||
| ad_role | iscanreport | bpchar | 1 | 'Y'::bpchar | Users with this role can create reports | ||
| ad_table | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | Information maintained in System Element table | |
| ad_role | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
| ad_table | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
| r_status | isclosed | bpchar | 1 | 'N'::bpchar | The status is closed | ||
| c_bp_group | isconfidentialinfo | bpchar | 1 | 'N'::bpchar | Can enter confidential information | ||
| r_requesttype | isconfidentialinfo | bpchar | 1 | 'N'::bpchar | Can enter confidential information | ||
| c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
| c_bp_group | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| r_requesttype | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| r_status | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| r_statuscategory | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| ad_table | isdeleteable | bpchar | 1 | 'Y'::bpchar | Indicates if records can be deleted from the database | ||
| ad_usermail | isdelivered | bpchar | 1 | √ | null | Delivered | |
| a_asset | isdepreciated | bpchar | 1 | 'Y'::bpchar | The asset will be depreciated | ||
| ad_role | isdiscountallowedontotal | bpchar | 1 | 'N'::bpchar | IsDiscountAllowedOnTotal | ||
| c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
| ad_role | isdiscountuptolimitprice | bpchar | 1 | 'N'::bpchar | IsDiscountUptoLimitPrice | ||
| a_asset | isdisposed | bpchar | 1 | 'N'::bpchar | The asset is disposed | ||
| m_inout | isdropship | bpchar | 1 | √ | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | |
| m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
| 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 | ||
| c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
| r_request | isescalated | bpchar | 1 | 'N'::bpchar | This request has been escalated | ||
| r_requestaction | isescalated | bpchar | 1 | √ | null | This request has been escalated | |
| m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
| ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
| r_status | isfinalclose | bpchar | 1 | 'N'::bpchar | Entries with Final Close cannot be re-opened | ||
| 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_table | ishighvolume | bpchar | 1 | 'N'::bpchar | Use Search instead of Pick list | ||
| 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 | ||
| m_inout | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
| 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 | ||
| m_inout | isintransit | bpchar | 1 | 'N'::bpchar | Movement is in transit | ||
| r_request | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
| r_requestaction | isinvoiced | bpchar | 1 | √ | null | Is this invoiced? | |
| r_requesttype | isinvoiced | bpchar | 1 | √ | null | Is this invoiced? | |
| 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 | ||
| ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
| ad_role | ismanual | bpchar | 1 | 'Y'::bpchar | This is a manual process | ||
| 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_role | ismasterrole | bpchar | 1 | 'N'::bpchar | A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles | ||
| ad_role | ismenuautoexpand | bpchar | 1 | 'N'::bpchar | If ticked, the menu is automatically expanded | ||
| 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 | ||
| r_status | isopen | bpchar | 1 | 'N'::bpchar | The status is closed | ||
| m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
| a_asset | isowned | bpchar | 1 | 'Y'::bpchar | The asset is owned by the organization | ||
| ad_role | ispersonalaccess | bpchar | 1 | 'N'::bpchar | Allow access to all personal records | ||
| ad_role | ispersonallock | bpchar | 1 | 'N'::bpchar | Allow users with role to lock access to personal records | ||
| 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 | ||
| m_inout | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
| c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
| m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
| 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 | ||
| ad_smtp | issecuresmtp | bpchar | 1 | 'N'::bpchar | Use SSL/TLS for SMTP | ||
| ad_table | issecurityenabled | bpchar | 1 | 'N'::bpchar | If security is enabled, user access to data can be restricted via Roles | ||
| m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| r_categoryupdates | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| r_groupupdates | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| r_interestarea | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| r_request | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| 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 | ||
| r_requesttypeupdates | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| r_requestupdates | isselfservice | bpchar | 1 | 'N'::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_role | isshowacct | bpchar | 1 | 'Y'::bpchar | Users with this role can see accounting information | ||
| ad_smtp | issmtpauthorization | bpchar | 1 | 'N'::bpchar | Your mail server requires Authentication | ||
| m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
| m_inout | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| m_rma | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| m_product | isstocked | bpchar | 1 | 'Y'::bpchar | Organization stocks this product | ||
| c_activity | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| 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 | ||
| c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
| m_product | istoformule | bpchar | 1 | √ | null | ||
| ad_role | isuseuserorgaccess | bpchar | 1 | 'N'::bpchar | Use Org Access defined by user instead of Role Org Access | ||
| 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 | ||
| ad_table | isview | bpchar | 1 | 'N'::bpchar | This is a view | ||
| r_status | iswebcanupdate | bpchar | 1 | 'Y'::bpchar | Entry can be updated from the Web | ||
| m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
| r_request | nextaction | bpchar | 1 | √ | null | Next Action to be taken | |
| ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
| ad_role | overwritepricelimit | bpchar | 1 | 'N'::bpchar | Overwrite Price Limit if the Price List enforces the Price Limit | ||
| c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
| c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
| m_inout | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
| ad_role | preferencetype | bpchar | 1 | 'C'::bpchar | Determines what preferences the user can set | ||
| r_request | priority | bpchar | 1 | Indicates if this request is of a high, medium or low priority. | |||
| r_requestaction | priority | bpchar | 1 | √ | null | Indicates if this request is of a high, medium or low priority. | |
| c_bp_group | prioritybase | bpchar | 1 | √ | null | Base of Priority | |
| m_inout | priorityrule | bpchar | 1 | Priority of a document | |||
| r_request | priorityuser | bpchar | 1 | √ | null | Priority of the issue for the User | |
| r_requestaction | priorityuser | bpchar | 1 | √ | null | Priority of the issue for the User | |
| a_asset | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_changenotice | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_changerequest | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_inout | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_rma | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| r_request | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| a_asset | processing | bpchar | 1 | √ | 'N'::bpchar | Process Now | |
| ad_table | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
| ad_user | processing | bpchar | 1 | √ | null | Process Now | |
| m_changenotice | processing | bpchar | 1 | √ | null | Process Now | |
| m_inout | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | processing | bpchar | 1 | √ | null | Process Now | |
| m_rma | processing | bpchar | 1 | √ | null | Process Now | |
| r_requestprocessor | 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_table | replicationtype | bpchar | 1 | 'L'::bpchar | Type of Data Replication | ||
| c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| m_inout | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
| r_request | taskstatus | bpchar | 1 | √ | null | Status of the Task | |
| r_requestaction | taskstatus | bpchar | 1 | √ | null | Status of the Task | |
| a_asset | a_asset_action | varchar | 2 | 'MD'::character varying | Asset Action | ||
| a_asset | a_asset_status | varchar | 2 | 'NW'::character varying | Asset Status | ||
| m_inout | docaction | bpchar | 2 | The targeted status of the document | |||
| m_rma | docaction | bpchar | 2 | The targeted status of the document | |||
| m_inout | docstatus | bpchar | 2 | The current status of the document | |||
| m_rma | docstatus | bpchar | 2 | The current status of the document | |||
| m_inout | movementtype | bpchar | 2 | Method of moving the inventory | |||
| ad_role | roletype | varchar | 2 | √ | NULL::character varying | Role Type | |
| a_asset | a_assettype | varchar | 3 | 'MFX'::character varying | Asset Type | ||
| ad_role | userlevel | bpchar | 3 | ' O'::bpchar | System Client Organization | ||
| 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 | |
| r_requesttype | contentcolor | varchar | 7 | √ | NULL::character varying | Content color of calendar dashlet | |
| r_requesttype | headercolor | varchar | 7 | √ | NULL::character varying | Header color of calendar dashlet | |
| a_asset | a_asset_class_id | numeric | 10 | √ | NULL::numeric | Asset class | |
| a_asset_delivery | a_asset_delivery_id | numeric | 10 | Delivery of Asset | |||
| 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_asset_delivery | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
| r_request | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
| r_requestaction | 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_asset | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| a_asset_delivery | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_role | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_smtp | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_table | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_user | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_usermail | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_activity | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_bp_group | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_bpartner | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_changenotice | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_changerequest | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_inout | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_product | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_rma | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_category | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_categoryupdates | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_contactinterest | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_group | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_groupupdates | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_interestarea | 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_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. | |||
| r_requesttypeupdates | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_requestupdate | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_requestupdates | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_resolution | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_standardresponse | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_status | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_statuscategory | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
| a_asset | ad_org_id | numeric | 10 | Organizational entity within client | |||
| a_asset_delivery | ad_org_id | numeric | 10 | Organizational entity within client | |||
| ad_role | ad_org_id | numeric | 10 | Organizational entity within client | |||
| ad_smtp | ad_org_id | numeric | 10 | 0 | Organizational entity within client | ||
| ad_table | ad_org_id | numeric | 10 | Organizational entity within client | |||
| ad_user | ad_org_id | numeric | 10 | Organizational entity within client | |||
| ad_usermail | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_activity | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_bp_group | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_bpartner | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_changenotice | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_changerequest | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_inout | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_product | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_rma | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_category | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_categoryupdates | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_contactinterest | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_group | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_groupupdates | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_interestarea | 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_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 | |||
| r_requesttypeupdates | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_requestupdate | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_requestupdates | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_resolution | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_standardresponse | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_status | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_statuscategory | 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 | |
| m_inout | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| c_bp_group | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
| ad_role | ad_role_id | numeric | 10 | Responsibility Role | |||
| r_request | ad_role_id | numeric | 10 | √ | null | Responsibility Role | |
| r_requestaction | ad_role_id | numeric | 10 | √ | null | Responsibility Role | |
| r_requestprocessor | ad_schedule_id | numeric | 10 | NULL::numeric | Schedule | ||
| ad_smtp | ad_smtp_id | numeric | 10 | SMTP Server | |||
| ad_table | ad_table_id | numeric | 10 | Database Table information | |||
| r_request | ad_table_id | numeric | 10 | √ | null | Database Table information | |
| ad_role | ad_tree_menu_id | numeric | 10 | √ | null | Tree of the menu | |
| ad_role | ad_tree_org_id | numeric | 10 | √ | null | Trees are used for (financial) reporting and security access (via role) | |
| a_asset | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| a_asset_delivery | 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_usermail | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| m_inout | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| r_categoryupdates | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| r_contactinterest | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| r_groupupdates | 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_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 | |||
| r_requesttypeupdates | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| r_requestupdates | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| ad_usermail | ad_usermail_id | numeric | 10 | Mail sent to the user | |||
| ad_table | ad_val_rule_id | numeric | 10 | √ | null | Dynamic Validation Rule | |
| ad_table | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
| r_requesttype | autoduedatedays | numeric | 10 | √ | null | Automatic Due Date Days | |
| 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_activity | c_activity_id | numeric | 10 | Business Activity | |||
| m_inout | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| r_request | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| r_requestaction | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_bp_group | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| a_asset | 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 | |||
| m_inout | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| m_rma | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| r_request | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| r_requestaction | c_bpartner_id | numeric | 10 | √ | null | 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 | |
| m_inout | c_bpartner_location_id | numeric | 10 | 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 | |
| m_inout | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| r_request | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| m_inout | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| ad_role | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
| m_rma | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
| m_inout | c_doctype_id | numeric | 10 | Document type or rules | |||
| m_rma | c_doctype_id | numeric | 10 | Document type or rules | |||
| c_bp_group | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
| 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 | |
| m_inout | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
| r_request | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
| r_requestaction | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
| r_request | c_invoicerequest_id | numeric | 10 | √ | null | The generated invoice for this request | |
| 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_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
| m_inout | c_order_id | numeric | 10 | √ | null | Order | |
| m_rma | c_order_id | numeric | 10 | √ | null | Order | |
| r_request | c_order_id | numeric | 10 | √ | null | Order | |
| r_requestaction | c_order_id | numeric | 10 | √ | null | Order | |
| r_request | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
| r_requestaction | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
| 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_inout | c_project_id | numeric | 10 | √ | null | Financial Project | |
| r_request | c_project_id | numeric | 10 | √ | null | Financial Project | |
| r_requestaction | 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 | |||
| ad_role | confirmqueryrecords | numeric | 10 | 0 | Require Confirmation if more records will be returned by the query (If not defined 500) | ||
| a_asset | createdby | numeric | 10 | User who created this records | |||
| a_asset_delivery | createdby | numeric | 10 | User who created this records | |||
| ad_role | createdby | numeric | 10 | User who created this records | |||
| ad_smtp | createdby | numeric | 10 | User who created this records | |||
| ad_table | createdby | numeric | 10 | User who created this records | |||
| ad_user | createdby | numeric | 10 | User who created this records | |||
| ad_usermail | createdby | numeric | 10 | User who created this records | |||
| c_activity | createdby | numeric | 10 | User who created this records | |||
| c_bp_group | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | createdby | numeric | 10 | User who created this records | |||
| m_changenotice | createdby | numeric | 10 | User who created this records | |||
| m_changerequest | createdby | numeric | 10 | User who created this records | |||
| m_inout | createdby | numeric | 10 | User who created this records | |||
| m_product | createdby | numeric | 10 | User who created this records | |||
| m_rma | createdby | numeric | 10 | User who created this records | |||
| r_category | createdby | numeric | 10 | User who created this records | |||
| r_categoryupdates | createdby | numeric | 10 | User who created this records | |||
| r_contactinterest | createdby | numeric | 10 | User who created this records | |||
| r_group | createdby | numeric | 10 | User who created this records | |||
| r_groupupdates | createdby | numeric | 10 | User who created this records | |||
| r_interestarea | 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_requesttypeupdates | createdby | numeric | 10 | User who created this records | |||
| r_requestupdate | createdby | numeric | 10 | User who created this records | |||
| r_requestupdates | createdby | numeric | 10 | User who created this records | |||
| r_resolution | createdby | numeric | 10 | User who created this records | |||
| r_standardresponse | createdby | numeric | 10 | User who created this records | |||
| r_status | createdby | numeric | 10 | User who created this records | |||
| r_statuscategory | createdby | numeric | 10 | User who created this records | |||
| ad_role | daysapprovalaccum | numeric | 10 | √ | null | The days approval indicates the days to take into account to verify the accumulated approval amount. | |
| c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
| c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
| m_inout | dropship_bpartner_id | numeric | 10 | √ | null | Business Partner to ship to | |
| m_inout | dropship_location_id | numeric | 10 | √ | null | Business Partner Location for shipping to | |
| m_inout | dropship_user_id | numeric | 10 | √ | null | Business Partner Contact for drop shipment | |
| r_requesttype | duedatetolerance | numeric | 10 | 7 | Tolerance in days between the Date Next Action and the date the request is regarded as overdue | ||
| ad_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
| m_inout | fob | varchar | 10 | √ | NULL::character varying | Freight Terms | |
| m_inout | freightcharges | varchar | 10 | √ | NULL::character varying | Freight Charges | |
| r_requestprocessor | frequency | numeric | 10 | √ | (1)::numeric | Frequency of events | |
| 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 | |
| r_requestprocessor | inactivityalertdays | numeric | 10 | 0 | Send Alert when there is no activity after days (0= no alert) | ||
| m_rma | inout_id | numeric | 10 | MaterialShipment Document | |||
| c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
| r_requestprocessor | keeplogdays | numeric | 10 | Number of days to keep the log entries | |||
| 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 | |
| ad_table | loadseq | numeric | 10 | √ | null | Sequence | |
| 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 | |
| r_group | m_bom_id | numeric | 10 | √ | null | ||
| m_changenotice | m_changenotice_id | numeric | 10 | Bill of Materials (Engineering) Change Notice (Version) | |||
| m_changerequest | m_changenotice_id | numeric | 10 | √ | null | Bill of Materials (Engineering) Change Notice (Version) | |
| r_group | m_changenotice_id | numeric | 10 | √ | null | Bill of Materials (Engineering) Change Notice (Version) | |
| m_changerequest | m_changerequest_id | numeric | 10 | BOM (Engineering) Change Request | |||
| r_request | m_changerequest_id | numeric | 10 | √ | null | BOM (Engineering) Change Request | |
| c_bp_group | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
| c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
| m_changerequest | m_fixchangenotice_id | numeric | 10 | √ | null | Fixed in Change Notice | |
| r_request | m_fixchangenotice_id | numeric | 10 | √ | null | Fixed in Change Notice | |
| m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
| m_inout | m_inout_id | numeric | 10 | Material Shipment Document | |||
| r_request | m_inout_id | numeric | 10 | √ | null | Material Shipment Document | |
| r_requestaction | m_inout_id | numeric | 10 | √ | null | Material Shipment Document | |
| a_asset | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
| a_asset_delivery | 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_bp_group | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
| 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 | |||
| m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| r_category | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| r_request | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| r_requestaction | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| a_asset_delivery | m_productdownload_id | numeric | 10 | √ | null | Product downloads | |
| r_request | m_productspent_id | numeric | 10 | √ | null | Product/Resource/Service used in Request | |
| r_requestaction | m_productspent_id | numeric | 10 | √ | null | Product/Resource/Service used in Request | |
| r_requestupdate | m_productspent_id | numeric | 10 | √ | null | Product/Resource/Service used in Request | |
| m_inout | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
| m_rma | m_rma_id | numeric | 10 | Return Material Authorization | |||
| r_request | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
| r_requestaction | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
| m_rma | m_rmatype_id | numeric | 10 | √ | null | Return Material Authorization Type | |
| m_inout | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
| m_inout | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| a_asset | manufacturedyear | numeric | 10 | √ | NULL::numeric | Manufactured Year | |
| ad_role | maxqueryrecords | numeric | 10 | 0 | If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records | ||
| r_status | next_status_id | numeric | 10 | √ | null | Move to next status automatically after timeout | |
| a_asset | nextmaintenanceuseunit | numeric | 10 | √ | null | ||
| a_asset | nextmaintenenceunit | numeric | 10 | √ | null | Next Maintenence Unit | |
| m_inout | nopackages | numeric | 10 | √ | (1)::numeric | Number of packages shipped | |
| c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
| 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) | |||
| c_bp_group | po_discountschema_id | numeric | 10 | √ | null | Schema to calculate the purchase trade discount percentage | |
| 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_bp_group | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
| c_bpartner | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
| ad_table | po_window_id | numeric | 10 | √ | null | Purchase Order Window | |
| m_changerequest | pp_product_bom_id | numeric | 10 | √ | null | BOM & Formula | |
| r_group | pp_product_bom_id | numeric | 10 | √ | null | BOM & Formula | |
| r_category | r_category_id | numeric | 10 | Request Category | |||
| r_categoryupdates | r_category_id | numeric | 10 | Request Category | |||
| r_request | r_category_id | numeric | 10 | √ | null | Request Category | |
| r_requestaction | r_category_id | numeric | 10 | √ | null | Request Category | |
| ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
| r_group | r_group_id | numeric | 10 | Request Group | |||
| r_groupupdates | r_group_id | numeric | 10 | Request Group | |||
| r_request | r_group_id | numeric | 10 | √ | null | Request Group | |
| r_requestaction | r_group_id | numeric | 10 | √ | null | Request Group | |
| r_contactinterest | r_interestarea_id | numeric | 10 | Interest Area or Topic | |||
| r_interestarea | r_interestarea_id | numeric | 10 | Interest Area or Topic | |||
| ad_usermail | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| 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 | 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_requestupdate | r_request_id | numeric | 10 | Request from a Business Partner or Prospect | |||
| r_requestupdates | 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_requestrelated_id | numeric | 10 | √ | null | Related Request (Master Issue, ..) | |
| r_request | r_requesttype_id | numeric | 10 | Type of request (e.g. Inquiry, Complaint, ..) | |||
| 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_requesttypeupdates | r_requesttype_id | numeric | 10 | Type of request (e.g. Inquiry, Complaint, ..) | |||
| r_requestupdate | r_requestupdate_id | numeric | 10 | Request Updates | |||
| r_request | r_resolution_id | numeric | 10 | √ | null | Request Resolution | |
| r_requestaction | r_resolution_id | numeric | 10 | √ | null | Request Resolution | |
| r_resolution | r_resolution_id | numeric | 10 | Request Resolution | |||
| r_request | r_standardresponse_id | numeric | 10 | √ | null | Request Standard Response | |
| r_standardresponse | r_standardresponse_id | numeric | 10 | Request Standard Response | |||
| r_request | r_status_id | numeric | 10 | √ | null | Request Status | |
| r_requestaction | r_status_id | numeric | 10 | √ | null | Request Status | |
| r_status | r_status_id | numeric | 10 | Request Status | |||
| r_requesttype | r_statuscategory_id | numeric | 10 | Request Status Category | |||
| r_status | r_statuscategory_id | numeric | 10 | Request Status Category | |||
| r_statuscategory | r_statuscategory_id | numeric | 10 | Request Status Category | |||
| r_request | record_id | numeric | 10 | √ | null | Direct internal record ID | |
| m_inout | ref_inout_id | numeric | 10 | √ | null | Referenced Shipment | |
| m_rma | ref_rma_id | numeric | 10 | √ | NULL::numeric | Referenced RMA | |
| r_requestprocessor | reminddays | numeric | 10 | 7 | Days between sending Reminder Emails for a due or inactive Document | ||
| m_inout | returnbpartner_id | numeric | 10 | √ | NULL::numeric | Return Partner | |
| m_inout | returnlocation_id | numeric | 10 | √ | NULL::numeric | Return Location | |
| m_inout | returnuser_id | numeric | 10 | √ | NULL::numeric | Return User/Contact | |
| m_inout | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
| 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_inout | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| m_product | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| m_rma | salesrep_id | numeric | 10 | Sales Representative or Company Agent | |||
| r_request | salesrep_id | numeric | 10 | Sales Representative or Company Agent | |||
| r_requestaction | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| c_bpartner | salesvolume | numeric | 10 | √ | null | Total Volume of Sales in Thousands of Currency | |
| r_requestprocessor_route | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
| r_status | seqno | numeric | 10 | 0 | 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_smtp | smtpport | numeric | 10 | √ | NULL::numeric | SMTP Port Number | |
| ad_role | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
| 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_status | timeoutdays | numeric | 10 | √ | null | Timeout in Days to change Status automatically | |
| m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
| r_status | update_status_id | numeric | 10 | √ | null | Automatically change the status after entry from web | |
| a_asset | updatedby | numeric | 10 | User who updated this records | |||
| a_asset_delivery | updatedby | numeric | 10 | User who updated this records | |||
| ad_role | updatedby | numeric | 10 | User who updated this records | |||
| ad_smtp | updatedby | numeric | 10 | User who updated this records | |||
| ad_table | updatedby | numeric | 10 | User who updated this records | |||
| ad_user | updatedby | numeric | 10 | User who updated this records | |||
| ad_usermail | updatedby | numeric | 10 | User who updated this records | |||
| c_activity | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_group | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
| m_changenotice | updatedby | numeric | 10 | User who updated this records | |||
| m_changerequest | updatedby | numeric | 10 | User who updated this records | |||
| m_inout | updatedby | numeric | 10 | User who updated this records | |||
| m_product | updatedby | numeric | 10 | User who updated this records | |||
| m_rma | updatedby | numeric | 10 | User who updated this records | |||
| r_category | updatedby | numeric | 10 | User who updated this records | |||
| r_categoryupdates | updatedby | numeric | 10 | User who updated this records | |||
| r_contactinterest | updatedby | numeric | 10 | User who updated this records | |||
| r_group | updatedby | numeric | 10 | User who updated this records | |||
| r_groupupdates | updatedby | numeric | 10 | User who updated this records | |||
| r_interestarea | 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 | |||
| r_requesttypeupdates | updatedby | numeric | 10 | User who updated this records | |||
| r_requestupdate | updatedby | numeric | 10 | User who updated this records | |||
| r_requestupdates | updatedby | numeric | 10 | User who updated this records | |||
| r_resolution | updatedby | numeric | 10 | User who updated this records | |||
| r_standardresponse | updatedby | numeric | 10 | User who updated this records | |||
| r_status | updatedby | numeric | 10 | User who updated this records | |||
| r_statuscategory | 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 | |
| m_inout | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| m_inout | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| ad_usermail | w_mailmsg_id | numeric | 10 | √ | null | Web Store Mail Message Template | |
| 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 | |
| c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| m_inout | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
| ad_user | userpin | varchar | 20 | √ | null | User PIN | |
| a_asset | versionno | varchar | 20 | √ | null | Version Number | |
| a_asset_delivery | versionno | varchar | 20 | √ | null | Version Number | |
| m_product | versionno | varchar | 20 | √ | null | Version Number | |
| ad_role | userdiscount | numeric | 22,2 | √ | null | UserDiscount | |
| 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 | |
| ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
| r_request | closedate | timestamp | 29,6 | √ | null | Close Date | |
| a_asset | created | timestamp | 29,6 | now() | Date this record was created | ||
| a_asset_delivery | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_role | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_smtp | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| ad_table | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_usermail | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_activity | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_group | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_changenotice | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_changerequest | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_inout | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_rma | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_category | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_categoryupdates | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_contactinterest | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_group | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_groupupdates | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_interestarea | 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 | ||
| r_requesttypeupdates | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_requestupdate | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_requestupdates | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_resolution | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_standardresponse | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_status | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_statuscategory | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | Date Account Locked | |
| m_inout | dateacct | timestamp | 29,6 | Accounting Date | |||
| r_request | datecompleteplan | timestamp | 29,6 | √ | null | Planned Completion Date | |
| 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 | datelastalert | timestamp | 29,6 | √ | null | Date when last alert were sent | |
| 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_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 | |
| m_inout | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
| ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | Date Password Changed | |
| m_inout | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
| m_inout | datereceived | timestamp | 29,6 | √ | null | Date a product was received | |
| r_request | datestartplan | timestamp | 29,6 | √ | null | Planned Start Date | |
| r_requestaction | datestartplan | timestamp | 29,6 | √ | null | Planned Start Date | |
| 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 | |
| r_requestaction | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
| r_request | endtime | timestamp | 29,6 | √ | null | End of the time span | |
| r_requestupdate | endtime | timestamp | 29,6 | √ | null | End of the time span | |
| 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_delivery | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
| m_inout | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
| a_asset | nextmaintenencedate | timestamp | 29,6 | √ | null | Next Maintenence Date | |
| r_contactinterest | optoutdate | timestamp | 29,6 | √ | null | Date the contact opted out | |
| m_inout | pickdate | timestamp | 29,6 | √ | null | Date/Time when picked for Shipment | |
| m_inout | shipdate | timestamp | 29,6 | √ | null | Shipment Date/Time | |
| r_request | startdate | timestamp | 29,6 | √ | null | First effective day (inclusive) | |
| r_requestaction | startdate | timestamp | 29,6 | √ | null | First effective day (inclusive) | |
| r_request | starttime | timestamp | 29,6 | √ | null | Time started | |
| r_requestupdate | starttime | timestamp | 29,6 | √ | null | Time started | |
| r_contactinterest | subscribedate | timestamp | 29,6 | √ | null | Date the contact actively subscribed | |
| a_asset | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| a_asset_delivery | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| ad_role | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| ad_smtp | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| ad_table | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| ad_usermail | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_activity | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_group | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_changenotice | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_changerequest | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_inout | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_rma | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_category | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_categoryupdates | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_contactinterest | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_group | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_groupupdates | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_interestarea | 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 | ||
| r_requesttypeupdates | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_requestupdate | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_requestupdates | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_resolution | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_standardresponse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_status | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_statuscategory | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_changerequest | documentno | varchar | 30 | Document sequence number of the document | |||
| m_inout | documentno | varchar | 30 | Document sequence number of the document | |||
| m_rma | documentno | varchar | 30 | Document sequence number of the document | |||
| r_request | documentno | varchar | 30 | Document sequence number of the document | |||
| 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_delivery | a_asset_delivery_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Delivery_UU | |
| a_asset | a_asset_uu | varchar | 36 | √ | NULL::character varying | A_Asset_UU | |
| ad_role | ad_role_uu | varchar | 36 | √ | NULL::character varying | AD_Role_UU | |
| ad_smtp | ad_smtp_uu | varchar | 36 | √ | NULL::character varying | AD_SMTP_UU | |
| ad_table | ad_table_uu | varchar | 36 | √ | NULL::character varying | AD_Table_UU | |
| ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
| ad_usermail | ad_usermail_uu | varchar | 36 | √ | NULL::character varying | AD_UserMail_UU | |
| c_activity | c_activity_uu | varchar | 36 | √ | NULL::character varying | C_Activity_UU | |
| c_bp_group | c_bp_group_uu | varchar | 36 | √ | NULL::character varying | C_BP_Group_UU | |
| c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
| m_changenotice | m_changenotice_uu | varchar | 36 | √ | NULL::character varying | M_ChangeNotice_UU | |
| m_changerequest | m_changerequest_uu | varchar | 36 | √ | NULL::character varying | M_ChangeRequest_UU | |
| m_inout | m_inout_uu | varchar | 36 | √ | NULL::character varying | M_InOut_UU | |
| m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
| m_rma | m_rma_uu | varchar | 36 | √ | NULL::character varying | M_RMA_UU | |
| r_category | r_category_uu | varchar | 36 | √ | NULL::character varying | R_Category_UU | |
| r_categoryupdates | r_categoryupdates_uu | varchar | 36 | √ | NULL::character varying | R_CategoryUpdates_UU | |
| r_contactinterest | r_contactinterest_uu | varchar | 36 | √ | NULL::character varying | R_ContactInterest_UU | |
| r_group | r_group_uu | varchar | 36 | √ | NULL::character varying | R_Group_UU | |
| r_groupupdates | r_groupupdates_uu | varchar | 36 | √ | NULL::character varying | R_GroupUpdates_UU | |
| r_interestarea | r_interestarea_uu | varchar | 36 | √ | NULL::character varying | R_InterestArea_UU | |
| r_mailtext | r_mailtext_uu | varchar | 36 | √ | NULL::character varying | R_MailText_UU | |
| 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_requesttype | r_requesttype_uu | varchar | 36 | √ | NULL::character varying | R_RequestType_UU | |
| r_requesttypeupdates | r_requesttypeupdates_uu | varchar | 36 | √ | NULL::character varying | R_RequestTypeUpdates_UU | |
| r_requestupdate | r_requestupdate_uu | varchar | 36 | √ | NULL::character varying | R_RequestUpdate_UU | |
| r_requestupdates | r_requestupdates_uu | varchar | 36 | √ | NULL::character varying | R_RequestUpdates_UU | |
| r_resolution | r_resolution_uu | varchar | 36 | √ | NULL::character varying | R_Resolution_UU | |
| r_standardresponse | r_standardresponse_uu | varchar | 36 | √ | NULL::character varying | R_StandardResponse_UU | |
| r_status | r_status_uu | varchar | 36 | √ | NULL::character varying | R_Status_UU | |
| r_statuscategory | r_statuscategory_uu | varchar | 36 | √ | NULL::character varying | R_StatusCategory_UU | |
| ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
| ad_table | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
| ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
| a_asset_delivery | lot | varchar | 40 | √ | null | Lot number (alphanumeric) | |
| 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 | |
| a_asset_delivery | serno | varchar | 40 | √ | null | Product Serial Number | |
| m_inout | shipperaccount | varchar | 40 | √ | NULL::character varying | Shipper Account Number | |
| ad_table | tablename | varchar | 40 | Name of the table in the database | |||
| 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_activity | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_bp_group | value | varchar | 40 | 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 | |||
| r_interestarea | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| r_status | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
| c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
| a_asset_delivery | varchar | 60 | √ | null | Electronic Mail Address | ||
| ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
| ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
| r_requestprocessor_route | keyword | varchar | 60 | √ | null | Case insensitive keyword | |
| a_asset | lastmaintenancenote | varchar | 60 | √ | null | Last Maintenance Note | |
| 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 | |||
| ad_role | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| ad_smtp | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| ad_table | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_activity | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bp_group | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_changenotice | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_changerequest | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_rma | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| r_category | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| r_group | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| r_interestarea | 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_resolution | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| r_standardresponse | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| r_status | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| r_statuscategory | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
| a_asset_delivery | remote_addr | varchar | 60 | √ | null | Remote Address | |
| a_asset_delivery | remote_host | varchar | 60 | √ | null | Remote host Info | |
| ad_smtp | requestuser | varchar | 60 | √ | NULL::character varying | User Name (ID) of the email owner | |
| ad_smtp | smtphost | varchar | 60 | √ | NULL::character varying | Hostname of Mail Server for SMTP and IMAP | |
| m_inout | trackingno | varchar | 60 | √ | null | Number to track the shipment | |
| a_asset_delivery | deliveryconfirmation | varchar | 120 | √ | null | EMail Delivery confirmation | |
| ad_usermail | deliveryconfirmation | varchar | 120 | √ | null | EMail Delivery confirmation | |
| 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 | |
| a_asset_delivery | messageid | varchar | 120 | √ | null | EMail Message ID | |
| ad_usermail | messageid | varchar | 120 | √ | null | EMail Message ID | |
| c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
| a_asset_delivery | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
| c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
| a_asset | description | varchar | 255 | √ | null | Optional short description of the record | |
| a_asset_delivery | description | varchar | 255 | √ | null | Optional short description of the record | |
| ad_role | description | varchar | 255 | √ | null | Optional short description of the record | |
| ad_table | description | varchar | 255 | √ | null | Optional short description of the record | |
| ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_activity | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bp_group | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_changenotice | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_changerequest | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_inout | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_rma | description | varchar | 255 | √ | null | Optional short description of the record | |
| r_category | description | varchar | 255 | √ | null | Optional short description of the record | |
| r_group | description | varchar | 255 | √ | null | Optional short description of the record | |
| r_interestarea | 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_resolution | description | varchar | 255 | √ | null | Optional short description of the record | |
| r_status | description | varchar | 255 | √ | null | Optional short description of the record | |
| r_statuscategory | description | varchar | 255 | √ | null | Optional short description of the record | |
| ad_usermail | emailfrom | varchar | 255 | √ | NULL::character varying | EMail sent from | |
| ad_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
| m_product | group1 | varchar | 255 | √ | null | Group1 | |
| m_product | group2 | varchar | 255 | √ | null | Group2 | |
| ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
| 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) | |
| m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
| r_requestaction | nullcolumns | varchar | 255 | √ | null | Columns with NULL value | |
| a_asset_delivery | referrer | varchar | 255 | √ | null | Referring web address | |
| ad_smtp | requestuserpw | varchar | 255 | √ | NULL::character varying | Password of the user name (ID) for mail processing | |
| a_asset | serno | varchar | 255 | √ | null | Product Serial Number | |
| c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
| ad_usermail | subject | varchar | 255 | √ | null | Email Message Subject | |
| ad_smtp | usedbyemailordomain | varchar | 255 | √ | NULL::character varying | Used by email or domain | |
| 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 | |
| m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| a_asset | help | varchar | 2000 | √ | null | Comment or Hint | |
| ad_table | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_activity | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_changenotice | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_changerequest | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_rma | help | varchar | 2000 | √ | null | Comment or Hint | |
| r_category | help | varchar | 2000 | √ | null | Comment or Hint | |
| r_group | help | varchar | 2000 | √ | null | Comment or Hint | |
| r_resolution | help | varchar | 2000 | √ | null | Comment or Hint | |
| r_status | help | varchar | 2000 | √ | null | Comment or Hint | |
| r_statuscategory | help | varchar | 2000 | √ | null | Comment or Hint | |
| r_request | lastresult | varchar | 2000 | √ | null | Result of last contact | |
| r_mailtext | mailheader | varchar | 2000 | √ | null | Mail Header (Subject) | |
| ad_usermail | mailtext | varchar | 2000 | √ | null | 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_usermail | recipientbcc | varchar | 2000 | √ | null | Bcc | |
| ad_usermail | recipientcc | varchar | 2000 | √ | null | Cc | |
| ad_usermail | recipientto | varchar | 2000 | √ | NULL::character varying | To | |
| r_standardresponse | responsetext | varchar | 2000 | Request Response Text | |||
| r_request | result | varchar | 2000 | √ | null | Result of the action taken | |
| r_requestupdate | result | varchar | 2000 | √ | null | Result of the action taken | |
| r_request | summary | varchar | 2000 | Textual summary of this request | |||
| r_requestaction | summary | varchar | 2000 | √ | null | Textual summary of this request | |
| m_changenotice | detailinfo | text | 2147483647 | √ | null | Additional Detail Information | |
| m_changerequest | detailinfo | text | 2147483647 | √ | null | Additional Detail Information | |
| r_mailtext | mailtext | text | 2147483647 | Text used for Mail message |