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

idempiere9.adempiere contains 699 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
r_request a_asset_id numeric 10  √  null Asset used internally or by customers
w_click acceptlanguage varchar 60  √  null Language accepted based on browser information
w_counter acceptlanguage varchar 60  √  null Language accepted based on browser information
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_client ad_client_id numeric 10 Client/Tenant for this installation.
ad_clientinfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_language 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_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentterm ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse 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.
w_advertisement ad_client_id numeric 10 Client/Tenant for this installation.
w_basket ad_client_id numeric 10 Client/Tenant for this installation.
w_basketline ad_client_id numeric 10 Client/Tenant for this installation.
w_click ad_client_id numeric 10 Client/Tenant for this installation.
w_clickcount ad_client_id numeric 10 Client/Tenant for this installation.
w_counter ad_client_id numeric 10 Client/Tenant for this installation.
w_countercount ad_client_id numeric 10 Client/Tenant for this installation.
w_mailmsg ad_client_id numeric 10 Client/Tenant for this installation.
w_mailmsg_trl ad_client_id numeric 10 Client/Tenant for this installation.
w_store ad_client_id numeric 10 Client/Tenant for this installation.
w_store_trl ad_client_id numeric 10 Client/Tenant for this installation.
ad_client ad_client_uu varchar 36  √  NULL::character varying AD_Client_UU
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying AD_ClientInfo_UU
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_client ad_language varchar 6  √  null Language for this entity
ad_language ad_language varchar 6 Language for this entity
c_bpartner ad_language varchar 6  √  null Language for this entity
w_mailmsg_trl ad_language varchar 6 Language for this entity
w_store_trl ad_language varchar 6 Language for this entity
ad_language ad_language_id numeric 10 Language ID
ad_language ad_language_uu varchar 36  √  NULL::character varying AD_Language_UU
ad_client ad_org_id numeric 10 Organizational entity within client
ad_clientinfo ad_org_id numeric 10 Organizational entity within client
ad_language 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_bpartner ad_org_id numeric 10 Organizational entity within client
c_paymentterm ad_org_id numeric 10 Organizational entity within client
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_warehouse 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
w_advertisement ad_org_id numeric 10 Organizational entity within client
w_basket ad_org_id numeric 10 Organizational entity within client
w_basketline ad_org_id numeric 10 Organizational entity within client
w_click ad_org_id numeric 10 Organizational entity within client
w_clickcount ad_org_id numeric 10 Organizational entity within client
w_counter ad_org_id numeric 10 Organizational entity within client
w_countercount ad_org_id numeric 10 Organizational entity within client
w_mailmsg ad_org_id numeric 10 Organizational entity within client
w_mailmsg_trl ad_org_id numeric 10 Organizational entity within client
w_store ad_org_id numeric 10 Organizational entity within client
w_store_trl ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_client ad_passwordrule_id numeric 10  √  NULL::numeric Password Policies
ad_language ad_printpaper_id numeric 10  √  NULL::numeric Printer paper definition
ad_client ad_replicationstrategy_id numeric 10  √  null Data Replication Strategy
r_request ad_role_id numeric 10  √  null Responsibility Role
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
r_request ad_table_id numeric 10  √  null Database Table information
ad_clientinfo ad_tree_activity_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_campaign_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_clientinfo ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_clientinfo ad_tree_product_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_project_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null Trees are used for (financial) reporting
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
r_request ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
w_advertisement ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
w_basket ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
w_click ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
w_counter 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_usermail ad_usermail_id numeric 10 Mail sent to the user
ad_usermail ad_usermail_uu varchar 36  √  NULL::character varying AD_UserMail_UU
w_advertisement adtext varchar 2000  √  null Text of the Advertisement
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_client autoarchive bpchar 1 'N'::bpchar Enable and level of automatic Archive of documents
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
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
ad_clientinfo c_acctschema1_id numeric 10  √  null Primary rules for accounting
r_request c_activity_id numeric 10  √  null Business Activity
c_bpartner c_bp_group_id numeric 10 Business Partner Group
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
r_request c_bpartner_id numeric 10  √  null Identifies a Business Partner
w_advertisement c_bpartner_id numeric 10 Identifies a Business Partner
w_basket c_bpartner_id numeric 10  √  null Identifies a Business Partner
w_clickcount c_bpartner_id numeric 10  √  null Identifies a Business Partner
w_countercount c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null Business Partner used for creating new Business Partners on the fly
ad_clientinfo c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
r_request c_campaign_id numeric 10  √  null Marketing Campaign
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric Charge for Freight
m_pricelist c_currency_id numeric 10 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
r_request 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
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
m_warehouse c_location_id numeric 10 Location or Address
r_request c_order_id numeric 10  √  null Order
r_request c_payment_id numeric 10  √  null Payment identifier
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
w_store c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying C_PaymentTerm_UU
r_request 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_clientinfo c_uom_length_id numeric 10  √  null Standard Unit of Measure for Length
ad_clientinfo c_uom_time_id numeric 10  √  null Standard Unit of Measure for Time
ad_clientinfo c_uom_volume_id numeric 10  √  null Standard Unit of Measure for Volume
ad_clientinfo c_uom_weight_id numeric 10  √  null Standard Unit of Measure for Weight
m_product classification varchar 12  √  null Classification for grouping
r_request closedate timestamp 29,6  √  null Close Date
ad_user comments varchar 2000  √  null Comments or additional information
r_request confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_request confidentialtypeentry bpchar 1 Confidentiality of the individual entry
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
ad_language countrycode bpchar 2  √  null Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_client created timestamp 29,6 now() Date this record was created
ad_clientinfo created timestamp 29,6 now() Date this record was created
ad_language 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_bpartner created timestamp 29,6 now() Date this record was created
c_paymentterm created timestamp 29,6 now() Date this record was created
m_pricelist created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_warehouse 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
w_advertisement created timestamp 29,6 now() Date this record was created
w_basket created timestamp 29,6 now() Date this record was created
w_basketline created timestamp 29,6 now() Date this record was created
w_click created timestamp 29,6 now() Date this record was created
w_clickcount created timestamp 29,6 now() Date this record was created
w_counter created timestamp 29,6 now() Date this record was created
w_countercount created timestamp 29,6 now() Date this record was created
w_mailmsg created timestamp 29,6 now() Date this record was created
w_mailmsg_trl created timestamp 29,6 now() Date this record was created
w_store created timestamp 29,6 now() Date this record was created
w_store_trl created timestamp 29,6 now() Date this record was created
ad_client createdby numeric 10 User who created this records
ad_clientinfo createdby numeric 10 User who created this records
ad_language 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_bpartner createdby numeric 10 User who created this records
c_paymentterm createdby numeric 10 User who created this records
m_pricelist createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_warehouse 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
w_advertisement createdby numeric 10 User who created this records
w_basket createdby numeric 10 User who created this records
w_basketline createdby numeric 10 User who created this records
w_click createdby numeric 10 User who created this records
w_clickcount createdby numeric 10 User who created this records
w_counter createdby numeric 10 User who created this records
w_countercount createdby numeric 10 User who created this records
w_mailmsg createdby numeric 10 User who created this records
w_mailmsg_trl createdby numeric 10 User who created this records
w_store createdby numeric 10 User who created this records
w_store_trl createdby numeric 10 User who created this records
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
r_request 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_request datenextaction timestamp 29,6  √  null Date that this request should be acted on
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
ad_language datepattern varchar 20  √  null Java Date Pattern
r_request datestartplan timestamp 29,6  √  null Planned Start Date
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
ad_usermail deliveryconfirmation varchar 120  √  null EMail Delivery confirmation
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
ad_client 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
c_paymentterm description varchar 255  √  null Optional short description of the record
m_pricelist description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_warehouse description varchar 255  √  null Optional short description of the record
w_advertisement description varchar 255  √  null Optional short description of the record
w_basketline description varchar 255 Optional short description of the record
w_clickcount description varchar 255  √  null Optional short description of the record
w_countercount description varchar 255  √  null Optional short description of the record
w_mailmsg description varchar 255  √  null Optional short description of the record
w_store 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
c_paymentterm discount numeric 0 Discount in percent
c_paymentterm discount2 numeric 0 Discount in percent
c_paymentterm discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_paymentterm discountdays2 numeric 10 Number of days from invoice date to be eligible for discount
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
ad_client documentdir varchar 60  √  null Directory for documents from the application server
r_request documentno varchar 30 Document sequence number of the document
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
r_request duetype bpchar 1 Status of the next action for this Request
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
ad_user email varchar 60  √  null Electronic Mail Address
w_basket email varchar 60  √  null Electronic Mail Address
w_click email varchar 60  √  null Electronic Mail Address
w_counter email varchar 60  √  null Electronic Mail Address
w_store emailfooter varchar 2000  √  null Footer added to EMails
w_store_trl emailfooter varchar 2000  √  null Footer added to EMails
ad_usermail emailfrom varchar 255  √  NULL::character varying EMail sent from
w_store emailheader varchar 2000  √  null Header added to EMails
w_store_trl emailheader varchar 2000  √  null Header added to EMails
ad_client emailtest bpchar 1  √  null Test EMail
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
r_request endtime timestamp 29,6  √  null End of the time span
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_user fax varchar 40  √  null Facsimile number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_paymentterm fixmonthcutoff numeric 10  √  null Last day to include for next due date
c_paymentterm fixmonthday numeric 10  √  null Day of the month of the due date
c_paymentterm fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
ad_clientinfo fy_startdate timestamp 29,6  √  null Financial Year Start Date
c_paymentterm gracedays numeric 10 Days after due date to send first dunning letter
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
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
m_product help varchar 2000  √  null Comment or Hint
w_advertisement help varchar 2000  √  null Comment or Hint
w_store help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
w_advertisement imageurl varchar 120  √  null URL of image
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_client isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_clientinfo 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_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_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentterm isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist 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_warehouse 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
w_advertisement isactive bpchar 1 'Y'::bpchar The record is active in the system
w_basket isactive bpchar 1 'Y'::bpchar The record is active in the system
w_basketline isactive bpchar 1 'Y'::bpchar The record is active in the system
w_click isactive bpchar 1 'Y'::bpchar The record is active in the system
w_clickcount isactive bpchar 1 'Y'::bpchar The record is active in the system
w_counter isactive bpchar 1 'Y'::bpchar The record is active in the system
w_countercount isactive bpchar 1 'Y'::bpchar The record is active in the system
w_mailmsg isactive bpchar 1 'Y'::bpchar The record is active in the system
w_mailmsg_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
w_store isactive bpchar 1 'Y'::bpchar The record is active in the system
w_store_trl 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_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_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar Show Confirmation On Document Action Close
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar Show Confirmation On Document Action Void
ad_client iscostimmediate bpchar 1 'N'::bpchar Update Costs immediately for testing
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_language isdecimalpoint bpchar 1  √  null The number notation has a decimal point (no decimal comma)
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
w_store isdefault bpchar 1 'N'::bpchar Default value
ad_usermail isdelivered bpchar 1  √  null Delivered
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar Payment Discount calculation does not include Taxes and Charges
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm isduefixed bpchar 1 'N'::bpchar Payment is due on a fixed date
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
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
r_mailtext ishtml bpchar 1 'N'::bpchar Text has HTML tags
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
r_request isinvoiced bpchar 1 'N'::bpchar 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_language isloginlocale bpchar 1  √  'N'::bpchar Login Locale
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
w_store ismenuassets bpchar 1 'Y'::bpchar Show Menu Assets
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
w_store ismenucontact bpchar 1 'Y'::bpchar Show Menu Contact
w_store ismenuinterests bpchar 1 'Y'::bpchar Show Menu Interests
w_store ismenuinvoices bpchar 1 'Y'::bpchar Show Menu Invoices
w_store ismenuorders bpchar 1 'Y'::bpchar Show Menu Orders
w_store ismenupayments bpchar 1 'Y'::bpchar Show Menu Payments
w_store ismenuregistrations bpchar 1 'Y'::bpchar Show Menu Registrations
w_store ismenurequests bpchar 1 'Y'::bpchar Show Menu Requests
w_store ismenurfqs bpchar 1 'Y'::bpchar Show Menu RfQs
w_store ismenushipments bpchar 1 'Y'::bpchar Show Menu Shipments
ad_client ismultilingualdocument bpchar 1 'N'::bpchar Documents are Multi Lingual
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar Payment due on the next business day
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
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
ad_client ispostimmediate bpchar 1 'N'::bpchar Post the accounting immediately for testing (Deprecated)
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
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_client issecuresmtp bpchar 1 'N'::bpchar Use SSL/TLS for SMTP
m_product isselfservice bpchar 1 'Y'::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
w_advertisement isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_client isserveremail bpchar 1  √  null Send EMail from Server
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
ad_client issmtpauthorization bpchar 1 'N'::bpchar Your mail server requires Authentication
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_language issystemlanguage bpchar 1 'N'::bpchar The screens, etc. are maintained in this Language
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_product istoformule bpchar 1  √  null
w_mailmsg_trl istranslated bpchar 1 'N'::bpchar This column is translated
w_store_trl istranslated bpchar 1 'N'::bpchar This column is translated
ad_client isuseasp bpchar 1 'N'::bpchar IsUseASP
ad_client isusebetafunctions bpchar 1 'N'::bpchar Enable the use of Beta Functionality
c_paymentterm isvalid bpchar 1 'N'::bpchar Element is valid
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
ad_clientinfo keeplogdays numeric 10  √  null Number of days to keep the log entries
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_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
ad_user lastresult varchar 255  √  null Result of last contact
r_request lastresult varchar 2000  √  null Result of last contact
ad_client ldapquery varchar 255  √  null
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
w_basketline line numeric 10 Unique line for this document
ad_clientinfo logo_id numeric 10  √  NULL::numeric Logo
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric Logo Report
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric Logo Web
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
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
r_request m_changerequest_id numeric 10  √  null BOM (Engineering) Change Request
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
r_request m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
r_request m_inout_id numeric 10  √  null Material Shipment Document
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
w_basket m_pricelist_id numeric 10  √  null Unique identifier of a Price List
w_store m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_product m_product_category_id numeric 10 Category of a Product
m_product m_product_id numeric 10 Product, Service, Item
r_request m_product_id numeric 10  √  null Product, Service, Item
w_basketline m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
ad_clientinfo m_productfreight_id numeric 10  √  null Product for Freight
r_request m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
r_request m_rma_id numeric 10  √  null Return Material Authorization
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
w_store m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
r_mailtext mailheader varchar 2000  √  null Mail Header (Subject)
w_mailmsg mailmsgtype bpchar 2 Mail Message Type
ad_usermail mailtext varchar 2000  √  null Text used for Mail message
r_mailtext mailtext text 2147483647 Text used for Mail message
r_mailtext mailtext2 varchar 2000  √  null Optional second text part used for Mail message
r_mailtext mailtext3 varchar 2000  √  null Optional third text part used for Mail message
w_mailmsg message varchar 2000 EMail Message
w_mailmsg_trl message varchar 2000 EMail Message
w_mailmsg message2 varchar 2000  √  null Optional second part of the EMail Message
w_mailmsg_trl message2 varchar 2000  √  null Optional second part of the EMail Message
w_mailmsg message3 varchar 2000  √  null Optional third part of the EMail Message
w_mailmsg_trl message3 varchar 2000  √  null Optional third part of the EMail Message
ad_usermail messageid varchar 120  √  null EMail Message ID
ad_client mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
ad_client modelvalidationclasses varchar 255  √  null List of data model validation classes separated by ;
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_client name varchar 60 Alphanumeric identifier of the entity
ad_language 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
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_product name varchar 255 Alphanumeric identifier of the entity
m_warehouse name varchar 60 Alphanumeric identifier of the entity
r_mailtext name varchar 60 Alphanumeric identifier of the entity
w_advertisement name varchar 60 Alphanumeric identifier of the entity
w_clickcount name varchar 60 Alphanumeric identifier of the entity
w_countercount name varchar 60 Alphanumeric identifier of the entity
w_mailmsg name varchar 60 Alphanumeric identifier of the entity
w_store name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_paymentterm netday bpchar 1  √  null Day when payment is due net
c_paymentterm netdays numeric 10 Net Days in which payment is due
r_request nextaction bpchar 1  √  null Next Action to be taken
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
c_bpartner numberemployees numeric 10  √  null Number of employees
w_counter pageurl varchar 120 Page URL
w_countercount pageurl varchar 120 Page URL
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
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar Payment term usage indicates if this payment term is used for sales, purchases or both.
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
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
w_basketline price numeric 0 0 Price
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
ad_language printname varchar 60 NULL::character varying The label text to be printed on a document or correspondence.
r_request priority bpchar 1 Indicates if this request is of a high, medium or low priority.
r_request priorityuser bpchar 1  √  null Priority of the issue for the User
r_request processed bpchar 1 'N'::bpchar The document has been processed
w_click processed bpchar 1 'N'::bpchar The document has been processed
w_counter processed bpchar 1 'N'::bpchar The document has been processed
ad_language processing bpchar 1  √  null Process Now
ad_user processing bpchar 1  √  null Process Now
c_paymentterm processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
w_advertisement processing bpchar 1  √  null Process Now
w_basketline product varchar 40 Product
m_product producttype bpchar 1 'I'::bpchar Type of product
w_advertisement publishstatus bpchar 1 Status of Publication
w_basketline qty numeric 0 0 Quantity
r_request qtyinvoiced numeric 0  √  0 Invoiced Quantity
r_request qtyplan numeric 0  √  null Planned Quantity
r_request qtyspent numeric 0  √  0 Quantity used for this event
r_request r_category_id numeric 10  √  null Request Category
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
r_request r_group_id numeric 10  √  null Request Group
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_mailtext r_mailtext_uu varchar 36  √  NULL::character varying R_MailText_UU
r_request r_request_id numeric 10 Request from a Business Partner or Prospect
r_request r_request_uu varchar 36  √  NULL::character varying R_Request_UU
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_request r_resolution_id numeric 10  √  null Request Resolution
r_request r_standardresponse_id numeric 10  √  null Request Standard Response
r_request r_status_id numeric 10  √  null Request Status
c_bpartner rating bpchar 1  √  null Classification or Importance
ad_usermail recipientbcc varchar 2000  √  null Bcc
ad_usermail recipientcc varchar 2000  √  null Cc
ad_usermail recipientto varchar 2000  √  NULL::character varying To
r_request 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
w_click referrer varchar 120  √  null Referring web address
w_counter referrer varchar 120  √  null Referring web address
w_click remote_addr varchar 60  √  null Remote Address
w_counter remote_addr varchar 60  √  null Remote Address
w_click remote_host varchar 120  √  null Remote host Info
w_counter remote_host varchar 120  √  null Remote host Info
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
r_request requestamt numeric 0 0 Amount associated with this request
ad_client requestemail varchar 60  √  null EMail address to send automated mails from or receive mails for automated processing (fully qualified)
ad_client requestfolder varchar 20  √  null EMail folder to process incoming emails; if empty INBOX is used
ad_client requestuser varchar 60  √  null User Name (ID) of the email owner
ad_client requestuserpw varchar 255  √  null Password of the user name (ID) for mail processing
r_request result varchar 2000  √  null Result of the action taken
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
r_request salesrep_id numeric 10 Sales Representative or Company Agent
w_store salesrep_id numeric 10 Sales Representative or Company Agent
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
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_warehouse separator bpchar 1 Element Separator
w_basket session_id varchar 60 Session ID
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
ad_client smtphost varchar 60  √  null Hostname of Mail Server for SMTP and IMAP
ad_client smtpport numeric 10  √  NULL::numeric SMTP Port Number
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
r_request startdate timestamp 29,6  √  null First effective day (inclusive)
r_request starttime timestamp 29,6  √  null Time started
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric Archive Store
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric Storage provider for Image
ad_client storearchiveonfilesystem bpchar 1 'N'::bpchar Store Archive On File System
ad_client storeattachmentsonfilesystem bpchar 1 'N'::bpchar Store Attachments On File System
w_store stylesheet varchar 60  √  null CSS (Stylesheet) used
ad_usermail subject varchar 255  √  null Email Message Subject
w_mailmsg subject varchar 255 Email Message Subject
w_mailmsg_trl subject varchar 255 Email Message Subject
r_request summary varchar 2000 Textual summary of this request
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
w_click targeturl varchar 120  √  null URL for the Target
w_clickcount targeturl varchar 120 URL for the Target
r_request taskstatus bpchar 1  √  null Status of the Task
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 unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_product unitsperpallet numeric 0  √  null Units Per Pallet
ad_client unixarchivepath varchar 255  √  null Unix Archive Path
ad_client unixattachmentpath varchar 255  √  null Unix Attachment Path
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
ad_client updated timestamp 29,6 now() Date this record was updated
ad_clientinfo updated timestamp 29,6 now() Date this record was updated
ad_language 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_bpartner updated timestamp 29,6 now() Date this record was updated
c_paymentterm updated timestamp 29,6 now() Date this record was updated
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_warehouse 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
w_advertisement updated timestamp 29,6 now() Date this record was updated
w_basket updated timestamp 29,6 now() Date this record was updated
w_basketline updated timestamp 29,6 now() Date this record was updated
w_click updated timestamp 29,6 now() Date this record was updated
w_clickcount updated timestamp 29,6 now() Date this record was updated
w_counter updated timestamp 29,6 now() Date this record was updated
w_countercount updated timestamp 29,6 now() Date this record was updated
w_mailmsg updated timestamp 29,6 now() Date this record was updated
w_mailmsg_trl updated timestamp 29,6 now() Date this record was updated
w_store updated timestamp 29,6 now() Date this record was updated
w_store_trl updated timestamp 29,6 now() Date this record was updated
ad_client updatedby numeric 10 User who updated this records
ad_clientinfo updatedby numeric 10 User who updated this records
ad_language 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_bpartner updatedby numeric 10 User who updated this records
c_paymentterm updatedby numeric 10 User who updated this records
m_pricelist updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_warehouse 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
w_advertisement updatedby numeric 10 User who updated this records
w_basket updatedby numeric 10 User who updated this records
w_basketline updatedby numeric 10 User who updated this records
w_click updatedby numeric 10 User who updated this records
w_clickcount updatedby numeric 10 User who updated this records
w_counter updatedby numeric 10 User who updated this records
w_countercount updatedby numeric 10 User who updated this records
w_mailmsg updatedby numeric 10 User who updated this records
w_mailmsg_trl updatedby numeric 10 User who updated this records
w_store updatedby numeric 10 User who updated this records
w_store_trl updatedby numeric 10 User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
w_store url varchar 120 'http://localhost'::character varying Full URL address - e.g. http://www.idempiere.org
w_click useragent varchar 255  √  null Browser Used
w_counter useragent varchar 255  √  null Browser Used
ad_user userpin varchar 20  √  null User PIN
w_advertisement validfrom timestamp 29,6  √  null Valid from including this date (first day)
w_advertisement validto timestamp 29,6  √  null Valid to including this date (last day)
ad_client value varchar 40 Search key for the record in the format required - must be unique
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm 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
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
w_advertisement version numeric 10  √  null Version of the table definition
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
w_advertisement w_advertisement_id numeric 10 Web Advertisement
w_advertisement w_advertisement_uu varchar 36  √  NULL::character varying W_Advertisement_UU
w_basket w_basket_id numeric 10 Web Basket
w_basketline w_basket_id numeric 10 Web Basket
w_basket w_basket_uu varchar 36  √  NULL::character varying W_Basket_UU
w_basketline w_basketline_id numeric 10 Web Basket Line
w_basketline w_basketline_uu varchar 36  √  NULL::character varying W_BasketLine_UU
w_click w_click_id numeric 10 Individual Web Click
w_click w_click_uu varchar 36  √  NULL::character varying W_Click_UU
w_advertisement w_clickcount_id numeric 10  √  null Web Click Management
w_click w_clickcount_id numeric 10  √  null Web Click Management
w_clickcount w_clickcount_id numeric 10 Web Click Management
w_clickcount w_clickcount_uu varchar 36  √  NULL::character varying W_ClickCount_UU
w_counter w_counter_id numeric 10 Individual Count hit
w_counter w_counter_uu varchar 36  √  NULL::character varying W_Counter_UU
w_advertisement w_countercount_id numeric 10  √  null Web Counter Count Management
w_counter w_countercount_id numeric 10  √  null Web Counter Count Management
w_countercount w_countercount_id numeric 10 Web Counter Count Management
w_countercount w_countercount_uu varchar 36  √  NULL::character varying W_CounterCount_UU
ad_usermail w_mailmsg_id numeric 10  √  null Web Store Mail Message Template
w_mailmsg w_mailmsg_id numeric 10 Web Store Mail Message Template
w_mailmsg_trl w_mailmsg_id numeric 10 Web Store Mail Message Template
w_mailmsg_trl w_mailmsg_trl_uu varchar 36  √  NULL::character varying W_MailMsg_Trl_UU
w_mailmsg w_mailmsg_uu varchar 36  √  NULL::character varying W_MailMsg_UU
w_mailmsg w_store_id numeric 10 A Web Store of the Client
w_store w_store_id numeric 10 A Web Store of the Client
w_store_trl w_store_id numeric 10 A Web Store of the Client
w_store_trl w_store_trl_uu varchar 36  √  NULL::character varying W_Store_Trl_UU
w_store w_store_uu varchar 36  √  NULL::character varying W_Store_UU
w_store webcontext varchar 20 Web Server Context - e.g. /wstore
w_store webinfo varchar 2000  √  null Web Store Header Information
w_store_trl webinfo varchar 2000  √  null Web Store Header Information
w_store weborderemail varchar 60  √  null EMail address to receive notifications when web orders were processed
w_advertisement webparam1 varchar 2000  √  null Web Site Parameter 1 (default: header image)
w_store webparam1 varchar 2000  √  null Web Site Parameter 1 (default: header image)
w_store_trl webparam1 varchar 2000  √  null Web Site Parameter 1 (default: header image)
w_advertisement webparam2 varchar 2000  √  null Web Site Parameter 2 (default index page)
w_store webparam2 varchar 2000  √  null Web Site Parameter 2 (default index page)
w_store_trl webparam2 varchar 2000  √  null Web Site Parameter 2 (default index page)
w_advertisement webparam3 varchar 2000  √  null Web Site Parameter 3 (default left - menu)
w_store webparam3 varchar 2000  √  null Web Site Parameter 3 (default left - menu)
w_store_trl webparam3 varchar 2000  √  null Web Site Parameter 3 (default left - menu)
w_advertisement webparam4 varchar 2000  √  null Web Site Parameter 4 (default footer left)
w_store webparam4 varchar 2000  √  null Web Site Parameter 4 (default footer left)
w_store_trl webparam4 varchar 2000  √  null Web Site Parameter 4 (default footer left)
w_store webparam5 varchar 2000  √  null Web Site Parameter 5 (default footer center)
w_store_trl webparam5 varchar 2000  √  null Web Site Parameter 5 (default footer center)
w_store webparam6 varchar 2000  √  null Web Site Parameter 6 (default footer right)
w_store_trl webparam6 varchar 2000  √  null Web Site Parameter 6 (default footer right)
m_product weight numeric 0  √  0 Weight of a product
ad_client windowsarchivepath varchar 255  √  null Windows Archive Path
ad_client windowsattachmentpath varchar 255  √  null Windows Attachment Path
w_store wstoreemail varchar 60  √  null EMail address used as the sender (From)
w_store wstoreuser varchar 60  √  null User ID of the Web Store EMail address
w_store wstoreuserpw varchar 20  √  null Password of the Web Store EMail address