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