SchemaSpy Analysis of idempiere11.adempiere - ColumnsWebStore Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:57 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 704 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
r_request a_asset_id numeric 10  √  null
w_click acceptlanguage varchar 60  √  null
w_counter acceptlanguage varchar 60  √  null
c_bpartner acqusitioncost numeric 0  √  0
c_bpartner actuallifetimevalue numeric 0  √  0
ad_client ad_client_id numeric 10
ad_clientinfo ad_client_id numeric 10
ad_language ad_client_id numeric 10
ad_user ad_client_id numeric 10
ad_usermail ad_client_id numeric 10
c_bpartner ad_client_id numeric 10
c_paymentterm ad_client_id numeric 10
m_pricelist ad_client_id numeric 10
m_product ad_client_id numeric 10
m_warehouse ad_client_id numeric 10
r_mailtext ad_client_id numeric 10
r_request ad_client_id numeric 10
w_advertisement ad_client_id numeric 10
w_basket ad_client_id numeric 10
w_basketline ad_client_id numeric 10
w_click ad_client_id numeric 10
w_clickcount ad_client_id numeric 10
w_counter ad_client_id numeric 10
w_countercount ad_client_id numeric 10
w_mailmsg ad_client_id numeric 10
w_mailmsg_trl ad_client_id numeric 10
w_store ad_client_id numeric 10
w_store_trl ad_client_id numeric 10
ad_client ad_client_uu varchar 36  √  NULL::character varying
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying
ad_user ad_image_id numeric 10  √  NULL::numeric
ad_client ad_language varchar 6  √  null
ad_language ad_language varchar 6
c_bpartner ad_language varchar 6  √  null
w_mailmsg_trl ad_language varchar 6
w_store_trl ad_language varchar 6
ad_language ad_language_id numeric 10
ad_language ad_language_uu varchar 36  √  NULL::character varying
ad_client ad_org_id numeric 10
ad_clientinfo ad_org_id numeric 10
ad_language ad_org_id numeric 10
ad_user ad_org_id numeric 10
ad_usermail ad_org_id numeric 10
c_bpartner ad_org_id numeric 10
c_paymentterm ad_org_id numeric 10
m_pricelist ad_org_id numeric 10
m_product ad_org_id numeric 10
m_warehouse ad_org_id numeric 10
r_mailtext ad_org_id numeric 10
r_request ad_org_id numeric 10
w_advertisement ad_org_id numeric 10
w_basket ad_org_id numeric 10
w_basketline ad_org_id numeric 10
w_click ad_org_id numeric 10
w_clickcount ad_org_id numeric 10
w_counter ad_org_id numeric 10
w_countercount ad_org_id numeric 10
w_mailmsg ad_org_id numeric 10
w_mailmsg_trl ad_org_id numeric 10
w_store ad_org_id numeric 10
w_store_trl ad_org_id numeric 10
c_bpartner ad_orgbp_id numeric 10  √  null
ad_user ad_orgtrx_id numeric 10  √  null
ad_client ad_passwordrule_id numeric 10  √  NULL::numeric
ad_language ad_printpaper_id numeric 10  √  NULL::numeric
ad_client ad_replicationstrategy_id numeric 10  √  null
r_request ad_role_id numeric 10  √  null
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric
r_request ad_table_id numeric 10  √  null
ad_clientinfo ad_tree_activity_id numeric 10  √  null
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null
ad_clientinfo ad_tree_campaign_id numeric 10  √  null
ad_clientinfo ad_tree_menu_id numeric 10  √  null
ad_clientinfo ad_tree_org_id numeric 10  √  null
ad_clientinfo ad_tree_product_id numeric 10  √  null
ad_clientinfo ad_tree_project_id numeric 10  √  null
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null
ad_user ad_user_id numeric 10
ad_usermail ad_user_id numeric 10
r_request ad_user_id numeric 10  √  null
w_advertisement ad_user_id numeric 10  √  null
w_basket ad_user_id numeric 10
w_click ad_user_id numeric 10  √  null
w_counter ad_user_id numeric 10  √  null
ad_user ad_user_uu varchar 36  √  NULL::character varying
ad_usermail ad_usermail_id numeric 10
ad_usermail ad_usermail_uu varchar 36  √  NULL::character varying
w_advertisement adtext varchar 2000  √  null
c_paymentterm afterdelivery bpchar 1 'N'::bpchar
ad_user answer varchar 1024  √  NULL::character varying
ad_client authenticationtype varchar 10 'AAS'::character varying
ad_user authenticationtype varchar 10  √  NULL::character varying
ad_client autoarchive bpchar 1 'N'::bpchar
m_pricelist basepricelist_id numeric 10  √  null
ad_user birthday timestamp 29,6  √  null
ad_user bp_location_id numeric 10  √  NULL::numeric
c_bpartner bpartner_parent_id numeric 10  √  null
ad_user bpname varchar 60  √  NULL::character varying
ad_clientinfo c_acctschema1_id numeric 10  √  null
r_request c_activity_id numeric 10  √  null
c_bpartner c_bp_group_id numeric 10
ad_user c_bpartner_id numeric 10  √  null
c_bpartner c_bpartner_id numeric 10
r_request c_bpartner_id numeric 10  √  null
w_advertisement c_bpartner_id numeric 10
w_basket c_bpartner_id numeric 10  √  null
w_clickcount c_bpartner_id numeric 10  √  null
w_countercount c_bpartner_id numeric 10  √  null
ad_user c_bpartner_location_id numeric 10  √  null
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null
ad_clientinfo c_calendar_id numeric 10  √  null
ad_user c_campaign_id numeric 10  √  NULL::numeric
r_request c_campaign_id numeric 10  √  null
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric
m_pricelist c_currency_id numeric 10
c_bpartner c_dunning_id numeric 10  √  null
ad_user c_greeting_id numeric 10  √  null
c_bpartner c_greeting_id numeric 10  √  null
r_request c_invoice_id numeric 10  √  null
r_request c_invoicerequest_id numeric 10  √  null
c_bpartner c_invoiceschedule_id numeric 10  √  null
ad_user c_job_id numeric 10  √  null
ad_user c_location_id numeric 10  √  NULL::numeric
m_warehouse c_location_id numeric 10
r_request c_order_id numeric 10  √  null
r_request c_payment_id numeric 10  √  null
c_bpartner c_paymentterm_id numeric 10  √  null
c_paymentterm c_paymentterm_id numeric 10
w_store c_paymentterm_id numeric 10  √  null
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying
r_request c_project_id numeric 10  √  null
m_product c_revenuerecognition_id numeric 10  √  null
m_product c_subscriptiontype_id numeric 10  √  null
m_product c_taxcategory_id numeric 10
c_bpartner c_taxgroup_id numeric 10  √  null
m_product c_uom_id numeric 10
ad_clientinfo c_uom_length_id numeric 10  √  null
ad_clientinfo c_uom_time_id numeric 10  √  null
ad_clientinfo c_uom_volume_id numeric 10  √  null
ad_clientinfo c_uom_weight_id numeric 10  √  null
m_product classification varchar 12  √  null
r_request closedate timestamp 29,6  √  null
ad_user comments varchar 2000  √  null
r_request confidentialtype bpchar 1 'C'::bpchar
r_request confidentialtypeentry bpchar 1
ad_user connectionprofile bpchar 1  √  null
m_product copyfrom bpchar 1  √  NULL::bpchar
ad_language countrycode bpchar 2  √  null
ad_client created timestamp 29,6 now()
ad_clientinfo created timestamp 29,6 now()
ad_language created timestamp 29,6 now()
ad_user created timestamp 29,6 now()
ad_usermail created timestamp 29,6 now()
c_bpartner created timestamp 29,6 now()
c_paymentterm created timestamp 29,6 now()
m_pricelist created timestamp 29,6 now()
m_product created timestamp 29,6 now()
m_warehouse created timestamp 29,6 now()
r_mailtext created timestamp 29,6 now()
r_request created timestamp 29,6 now()
w_advertisement created timestamp 29,6 now()
w_basket created timestamp 29,6 now()
w_basketline created timestamp 29,6 now()
w_click created timestamp 29,6 now()
w_clickcount created timestamp 29,6 now()
w_counter created timestamp 29,6 now()
w_countercount created timestamp 29,6 now()
w_mailmsg created timestamp 29,6 now()
w_mailmsg_trl created timestamp 29,6 now()
w_store created timestamp 29,6 now()
w_store_trl created timestamp 29,6 now()
ad_client createdby numeric 10
ad_clientinfo createdby numeric 10
ad_language createdby numeric 10
ad_user createdby numeric 10
ad_usermail createdby numeric 10
c_bpartner createdby numeric 10
c_paymentterm createdby numeric 10
m_pricelist createdby numeric 10
m_product createdby numeric 10
m_warehouse createdby numeric 10
r_mailtext createdby numeric 10
r_request createdby numeric 10
w_advertisement createdby numeric 10
w_basket createdby numeric 10
w_basketline createdby numeric 10
w_click createdby numeric 10
w_clickcount createdby numeric 10
w_counter createdby numeric 10
w_countercount createdby numeric 10
w_mailmsg createdby numeric 10
w_mailmsg_trl createdby numeric 10
w_store createdby numeric 10
w_store_trl createdby numeric 10
c_bpartner customerprofileid varchar 60  √  NULL::character varying
m_product customstariffnumber varchar 20  √  null
ad_user dateaccountlocked timestamp 29,6  √  null
r_request datecompleteplan timestamp 29,6  √  null
r_request datelastaction timestamp 29,6  √  null
r_request datelastalert timestamp 29,6  √  null
ad_user datelastlogin timestamp 29,6  √  null
r_request datenextaction timestamp 29,6  √  null
ad_user datepasswordchanged timestamp 29,6  √  null
ad_language datepattern varchar 20  √  null
r_request datestartplan timestamp 29,6  √  null
c_bpartner default1099box_id numeric 10  √  NULL::numeric
ad_usermail deliveryconfirmation varchar 120  √  null
c_bpartner deliveryrule bpchar 1  √  null
c_bpartner deliveryviarule bpchar 1  √  null
ad_client description varchar 255  √  null
ad_user description varchar 255  √  null
c_bpartner description varchar 255  √  null
c_paymentterm description varchar 255  √  null
m_pricelist description varchar 255  √  null
m_product description varchar 255  √  null
m_warehouse description varchar 255  √  null
w_advertisement description varchar 255  √  null
w_basketline description varchar 255
w_clickcount description varchar 255  √  null
w_countercount description varchar 255  √  null
w_mailmsg description varchar 255  √  null
w_store description varchar 255  √  null
m_product descriptionurl varchar 120  √  null
m_product discontinued bpchar 1  √  'N'::bpchar
m_product discontinuedat timestamp 29,6  √  null
m_product discontinuedby timestamp 29,6  √  null
c_paymentterm discount numeric 0
c_paymentterm discount2 numeric 0
c_paymentterm discountdays numeric 10
c_paymentterm discountdays2 numeric 10
c_bpartner documentcopies numeric 10  √  null
ad_client documentdir varchar 60  √  null
r_request documentno varchar 30
c_paymentterm documentnote varchar 2000  √  null
m_product documentnote varchar 2000  √  null
m_product downloadurl varchar 120  √  null
r_request duetype bpchar 1
c_bpartner dunninggrace timestamp 29,6  √  null
c_bpartner duns varchar 11  √  null
ad_user email varchar 60  √  null
w_basket email varchar 60  √  null
w_click email varchar 60  √  null
w_counter email varchar 60  √  null
w_store emailfooter varchar 2000  √  null
w_store_trl emailfooter varchar 2000  √  null
ad_usermail emailfrom varchar 255  √  NULL::character varying
w_store emailheader varchar 2000  √  null
w_store_trl emailheader varchar 2000  √  null
ad_client emailtest bpchar 1  √  null
ad_user emailuser varchar 60  √  null
ad_user emailuserpw varchar 255  √  null
ad_user emailverify varchar 40  √  null
ad_user emailverifydate timestamp 29,6  √  null
r_request endtime timestamp 29,6  √  null
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar
ad_user failedlogincount numeric 10 (0)::numeric
ad_user fax varchar 40  √  null
c_bpartner firstsale timestamp 29,6  √  null
c_paymentterm fixmonthcutoff numeric 10  √  null
c_paymentterm fixmonthday numeric 10  √  null
c_paymentterm fixmonthoffset numeric 10  √  null
c_bpartner flatdiscount numeric 0  √  null
c_bpartner freightcostrule bpchar 1  √  null
ad_clientinfo fy_startdate timestamp 29,6  √  null
c_paymentterm gracedays numeric 10
m_product group1 varchar 255  √  null
m_product group2 varchar 255  √  null
m_product guaranteedays numeric 10  √  null
m_product guaranteedaysmin numeric 10  √  null
m_product help varchar 2000  √  null
w_advertisement help varchar 2000  √  null
w_store help varchar 2000  √  null
m_product imageurl varchar 120  √  null
w_advertisement imageurl varchar 120  √  null
c_bpartner invoice_printformat_id numeric 10  √  null
c_bpartner invoicerule bpchar 1  √  null
c_bpartner is1099vendor bpchar 1 'N'::bpchar
ad_client isactive bpchar 1 'Y'::bpchar
ad_clientinfo isactive bpchar 1 'Y'::bpchar
ad_language isactive bpchar 1 'N'::bpchar
ad_user isactive bpchar 1 'Y'::bpchar
ad_usermail isactive bpchar 1 'Y'::bpchar
c_bpartner isactive bpchar 1 'Y'::bpchar
c_paymentterm isactive bpchar 1 'Y'::bpchar
m_pricelist isactive bpchar 1 'Y'::bpchar
m_product isactive bpchar 1 'Y'::bpchar
m_warehouse isactive bpchar 1 'Y'::bpchar
r_mailtext isactive bpchar 1 'Y'::bpchar
r_request isactive bpchar 1 'Y'::bpchar
w_advertisement isactive bpchar 1 'Y'::bpchar
w_basket isactive bpchar 1 'Y'::bpchar
w_basketline isactive bpchar 1 'Y'::bpchar
w_click isactive bpchar 1 'Y'::bpchar
w_clickcount isactive bpchar 1 'Y'::bpchar
w_counter isactive bpchar 1 'Y'::bpchar
w_countercount isactive bpchar 1 'Y'::bpchar
w_mailmsg isactive bpchar 1 'Y'::bpchar
w_mailmsg_trl isactive bpchar 1 'Y'::bpchar
w_store isactive bpchar 1 'Y'::bpchar
w_store_trl isactive bpchar 1 'Y'::bpchar
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar
m_product isautoproduce bpchar 1 'N'::bpchar
ad_language isbaselanguage bpchar 1 'N'::bpchar
ad_user isbillto bpchar 1 'N'::bpchar
m_product isbom bpchar 1 'N'::bpchar
ad_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar
ad_client iscostimmediate bpchar 1 'N'::bpchar
c_bpartner iscustomer bpchar 1 'Y'::bpchar
ad_language isdecimalpoint bpchar 1  √  null
c_paymentterm isdefault bpchar 1  √  'N'::bpchar
m_pricelist isdefault bpchar 1 'N'::bpchar
w_store isdefault bpchar 1 'N'::bpchar
ad_usermail isdelivered bpchar 1  √  null
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar
m_product isdropship bpchar 1 'N'::bpchar
c_paymentterm isduefixed bpchar 1 'N'::bpchar
c_bpartner isemployee bpchar 1 'N'::bpchar
r_request isescalated bpchar 1 'N'::bpchar
m_product isexcludeautodelivery bpchar 1 'N'::bpchar
ad_user isexpired bpchar 1 'N'::bpchar
ad_user isfullbpaccess bpchar 1 'Y'::bpchar
r_mailtext ishtml bpchar 1 'N'::bpchar
ad_user isinpayroll bpchar 1 'N'::bpchar
m_warehouse isintransit bpchar 1  √  'N'::bpchar
r_request isinvoiced bpchar 1 'N'::bpchar
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar
m_product iskanban bpchar 1 'N'::bpchar
ad_user islocked bpchar 1 'N'::bpchar
ad_language isloginlocale bpchar 1  √  'N'::bpchar
m_pricelist ismandatory bpchar 1  √  'N'::bpchar
m_product ismanufactured bpchar 1 'N'::bpchar
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar
w_store ismenuassets bpchar 1 'Y'::bpchar
ad_user ismenuautoexpand bpchar 1  √  null
w_store ismenucontact bpchar 1 'Y'::bpchar
w_store ismenuinterests bpchar 1 'Y'::bpchar
w_store ismenuinvoices bpchar 1 'Y'::bpchar
w_store ismenuorders bpchar 1 'Y'::bpchar
w_store ismenupayments bpchar 1 'Y'::bpchar
w_store ismenuregistrations bpchar 1 'Y'::bpchar
w_store ismenurequests bpchar 1 'Y'::bpchar
w_store ismenurfqs bpchar 1 'Y'::bpchar
w_store ismenushipments bpchar 1 'Y'::bpchar
ad_client ismultilingualdocument bpchar 1 'N'::bpchar
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar
ad_user isnoexpire bpchar 1 'N'::bpchar
ad_user isnopasswordreset bpchar 1 'N'::bpchar
c_bpartner isonetime bpchar 1 'N'::bpchar
m_product isownbox bpchar 1 'N'::bpchar
m_product isphantom bpchar 1  √  'N'::bpchar
m_product ispicklistprintdetails bpchar 1 'N'::bpchar
ad_client ispostimmediate bpchar 1 'N'::bpchar
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar
c_bpartner isprospect bpchar 1 'N'::bpchar
m_product ispurchased bpchar 1 'Y'::bpchar
ad_user issaleslead bpchar 1 'N'::bpchar
c_bpartner issalesrep bpchar 1 'N'::bpchar
ad_client issecuresmtp bpchar 1 'N'::bpchar
m_product isselfservice bpchar 1 'Y'::bpchar
r_request isselfservice bpchar 1 'N'::bpchar
w_advertisement isselfservice bpchar 1 'N'::bpchar
ad_client isserveremail bpchar 1  √  null
ad_user isshipto bpchar 1 'N'::bpchar
ad_client issmtpauthorization bpchar 1 'N'::bpchar
m_product issold bpchar 1 'Y'::bpchar
m_pricelist issopricelist bpchar 1 'Y'::bpchar
m_product isstocked bpchar 1 'Y'::bpchar
c_bpartner issummary bpchar 1 'N'::bpchar
m_product issummary bpchar 1 'N'::bpchar
ad_user issupportuser bpchar 1 'N'::bpchar
ad_language issystemlanguage bpchar 1 'N'::bpchar
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar
m_pricelist istaxincluded bpchar 1 'N'::bpchar
m_product istoformule bpchar 1  √  null
w_mailmsg_trl istranslated bpchar 1 'N'::bpchar
w_store_trl istranslated bpchar 1 'N'::bpchar
ad_client isuseasp bpchar 1 'N'::bpchar
ad_client isusebetafunctions bpchar 1 'N'::bpchar
c_paymentterm isvalid bpchar 1 'N'::bpchar
c_bpartner isvendor bpchar 1 'N'::bpchar
ad_user isvendorlead bpchar 1 'N'::bpchar
m_product isverified bpchar 1 'N'::bpchar
m_product iswebstorefeatured bpchar 1 'N'::bpchar
ad_clientinfo keeplogdays numeric 10  √  null
ad_language languageiso bpchar 2  √  null
ad_user lastcontact timestamp 29,6  √  null
ad_user lastresult varchar 255  √  null
r_request lastresult varchar 2000  √  null
ad_client ldapquery varchar 255  √  null
ad_user ldapuser varchar 60  √  null
ad_user leadsource varchar 10  √  NULL::character varying
ad_user leadsourcedescription varchar 255  √  NULL::character varying
ad_user leadstatus varchar 10  √  NULL::character varying
ad_user leadstatusdescription varchar 255  √  NULL::character varying
w_basketline line numeric 10
ad_client loginprefix varchar 40  √  NULL::character varying
ad_clientinfo logo_id numeric 10  √  NULL::numeric
c_bpartner logo_id numeric 10  √  NULL::numeric
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric
m_product lowlevel numeric 10 (0)::numeric
m_product m_attributeset_id numeric 10  √  null
m_product m_attributesetinstance_id numeric 10  √  0
r_request m_changerequest_id numeric 10  √  null
c_bpartner m_discountschema_id numeric 10  √  null
r_request m_fixchangenotice_id numeric 10  √  null
m_product m_freightcategory_id numeric 10  √  null
r_request m_inout_id numeric 10  √  null
m_product m_locator_id numeric 10  √  null
m_product m_parttype_id numeric 10  √  NULL::numeric
c_bpartner m_pricelist_id numeric 10  √  null
m_pricelist m_pricelist_id numeric 10
w_basket m_pricelist_id numeric 10  √  null
w_store m_pricelist_id numeric 10
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying
m_product m_product_category_id numeric 10
m_product m_product_id numeric 10
r_request m_product_id numeric 10  √  null
w_basketline m_product_id numeric 10  √  null
m_product m_product_uu varchar 36  √  NULL::character varying
ad_clientinfo m_productfreight_id numeric 10  √  null
r_request m_productspent_id numeric 10  √  null
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric
r_request m_rma_id numeric 10  √  null
m_warehouse m_warehouse_id numeric 10
w_store m_warehouse_id numeric 10
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying
m_warehouse m_warehousesource_id numeric 10  √  null
r_mailtext mailheader varchar 2000  √  null
w_mailmsg mailmsgtype bpchar 2
ad_usermail mailtext varchar 2000  √  null
r_mailtext mailtext text 2147483647
r_mailtext mailtext2 varchar 2000  √  null
r_mailtext mailtext3 varchar 2000  √  null
w_mailmsg message varchar 2000
w_mailmsg_trl message varchar 2000
w_mailmsg message2 varchar 2000  √  null
w_mailmsg_trl message2 varchar 2000  √  null
w_mailmsg message3 varchar 2000  √  null
w_mailmsg_trl message3 varchar 2000  √  null
ad_usermail messageid varchar 120  √  null
ad_client mmpolicy bpchar 1 'F'::bpchar
ad_client modelvalidationclasses varchar 255  √  null
c_bpartner naics varchar 6  √  null
ad_client name varchar 60
ad_language name varchar 60
ad_user name varchar 60
c_bpartner name varchar 120
c_paymentterm name varchar 60
m_pricelist name varchar 60
m_product name varchar 255
m_warehouse name varchar 60
r_mailtext name varchar 60
w_advertisement name varchar 60
w_clickcount name varchar 60
w_countercount name varchar 60
w_mailmsg name varchar 60
w_store name varchar 60
c_bpartner name2 varchar 60  √  null
c_paymentterm netday bpchar 1  √  null
c_paymentterm netdays numeric 10
r_request nextaction bpchar 1  √  null
ad_user notificationtype bpchar 1 'X'::bpchar
c_bpartner numberemployees numeric 10  √  null
w_counter pageurl varchar 120
w_countercount pageurl varchar 120
ad_user password varchar 1024  √  null
c_bpartner paymentrule bpchar 1  √  null
c_bpartner paymentrulepo bpchar 1  √  null
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar
ad_user phone varchar 40  √  null
ad_user phone2 varchar 40  √  null
c_bpartner po_discountschema_id numeric 10  √  null
c_bpartner po_paymentterm_id numeric 10  √  null
c_bpartner po_pricelist_id numeric 10  √  null
c_bpartner poreference varchar 20  √  null
c_bpartner potentiallifetimevalue numeric 0  √  0
w_basketline price numeric 0 0
m_pricelist priceprecision numeric 10 2
ad_language printname varchar 60 NULL::character varying
r_request priority bpchar 1
r_request priorityuser bpchar 1  √  null
r_request processed bpchar 1 'N'::bpchar
w_click processed bpchar 1 'N'::bpchar
w_counter processed bpchar 1 'N'::bpchar
ad_language processing bpchar 1  √  null
ad_user processing bpchar 1  √  null
c_paymentterm processing bpchar 1  √  null
m_product processing bpchar 1  √  null
w_advertisement processing bpchar 1  √  null
w_basketline product varchar 40
m_product producttype bpchar 1 'I'::bpchar
w_advertisement publishstatus bpchar 1
w_basketline qty numeric 0 0
r_request qtyinvoiced numeric 0  √  0
r_request qtyplan numeric 0  √  null
r_request qtyspent numeric 0  √  0
r_request r_category_id numeric 10  √  null
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric
r_request r_group_id numeric 10  √  null
ad_usermail r_mailtext_id numeric 10  √  null
m_product r_mailtext_id numeric 10  √  null
r_mailtext r_mailtext_id numeric 10
r_request r_mailtext_id numeric 10  √  null
r_mailtext r_mailtext_uu varchar 36  √  NULL::character varying
r_request r_request_id numeric 10
r_request r_request_uu varchar 36  √  NULL::character varying
r_request r_requestrelated_id numeric 10  √  null
r_request r_requesttype_id numeric 10
r_request r_resolution_id numeric 10  √  null
r_request r_standardresponse_id numeric 10  √  null
r_request r_status_id numeric 10  √  null
c_bpartner rating bpchar 1  √  null
ad_usermail recipientbcc varchar 2000  √  null
ad_usermail recipientcc varchar 2000  √  null
ad_usermail recipientto varchar 2000  √  NULL::character varying
r_request record_id numeric 10  √  null
r_request record_uu varchar 36  √  NULL::character varying
c_bpartner referenceno varchar 40  √  null
w_click referrer varchar 120  √  null
w_counter referrer varchar 120  √  null
w_click remote_addr varchar 60  √  null
w_counter remote_addr varchar 60  √  null
w_click remote_host varchar 120  √  null
w_counter remote_host varchar 120  √  null
m_warehouse replenishmentclass varchar 60  √  null
r_request requestamt numeric 0 0
ad_client requestemail varchar 60  √  null
ad_client requestfolder varchar 20  √  null
ad_client requestuser varchar 60  √  null
ad_client requestuserpw varchar 255  √  null
r_request result varchar 2000  √  null
m_product s_expensetype_id numeric 10  √  null
m_product s_resource_id numeric 10  √  null
ad_user salesrep_id numeric 10  √  NULL::numeric
c_bpartner salesrep_id numeric 10  √  null
m_product salesrep_id numeric 10  √  null
r_request salesrep_id numeric 10
w_store salesrep_id numeric 10
c_bpartner salesvolume numeric 10  √  null
ad_user salt varchar 16  √  NULL::character varying
ad_user securityquestion varchar 1024  √  null
c_bpartner sendemail bpchar 1 'N'::bpchar
m_warehouse separator bpchar 1
w_basket session_id varchar 60
c_bpartner shareofcustomer numeric 10  √  null
m_product shelfdepth numeric 10  √  null
m_product shelfheight numeric 0  √  null
c_bpartner shelflifeminpct numeric 10  √  null
m_product shelfwidth numeric 10  √  null
m_product sku varchar 30  √  null
ad_client smtphost varchar 60  √  null
ad_client smtpport numeric 10  √  NULL::numeric
c_bpartner so_creditlimit numeric 0  √  0
c_bpartner so_creditused numeric 0  √  0
c_bpartner so_description varchar 255  √  null
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar
r_request startdate timestamp 29,6  √  null
r_request starttime timestamp 29,6  √  null
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric
ad_client storearchiveonfilesystem bpchar 1 'N'::bpchar
ad_client storeattachmentsonfilesystem bpchar 1 'N'::bpchar
w_store stylesheet varchar 60  √  null
ad_usermail subject varchar 255  √  null
w_mailmsg subject varchar 255
w_mailmsg_trl subject varchar 255
r_request summary varchar 2000
ad_user supervisor_id numeric 10  √  null
w_click targeturl varchar 120  √  null
w_clickcount targeturl varchar 120
r_request taskstatus bpchar 1  √  null
c_bpartner taxid varchar 20  √  null
ad_language timepattern varchar 20  √  null
ad_clientinfo timezone varchar 60  √  NULL::character varying
ad_user title varchar 40  √  null
c_bpartner totalopenbalance numeric 0  √  null
m_product unitsperpack numeric 10 1
m_product unitsperpallet numeric 0  √  null
ad_client unixarchivepath varchar 255  √  null
ad_client unixattachmentpath varchar 255  √  null
m_product upc varchar 30  √  null
ad_client updated timestamp 29,6 now()
ad_clientinfo updated timestamp 29,6 now()
ad_language updated timestamp 29,6 now()
ad_user updated timestamp 29,6 now()
ad_usermail updated timestamp 29,6 now()
c_bpartner updated timestamp 29,6 now()
c_paymentterm updated timestamp 29,6 now()
m_pricelist updated timestamp 29,6 now()
m_product updated timestamp 29,6 now()
m_warehouse updated timestamp 29,6 now()
r_mailtext updated timestamp 29,6 now()
r_request updated timestamp 29,6 now()
w_advertisement updated timestamp 29,6 now()
w_basket updated timestamp 29,6 now()
w_basketline updated timestamp 29,6 now()
w_click updated timestamp 29,6 now()
w_clickcount updated timestamp 29,6 now()
w_counter updated timestamp 29,6 now()
w_countercount updated timestamp 29,6 now()
w_mailmsg updated timestamp 29,6 now()
w_mailmsg_trl updated timestamp 29,6 now()
w_store updated timestamp 29,6 now()
w_store_trl updated timestamp 29,6 now()
ad_client updatedby numeric 10
ad_clientinfo updatedby numeric 10
ad_language updatedby numeric 10
ad_user updatedby numeric 10
ad_usermail updatedby numeric 10
c_bpartner updatedby numeric 10
c_paymentterm updatedby numeric 10
m_pricelist updatedby numeric 10
m_product updatedby numeric 10
m_warehouse updatedby numeric 10
r_mailtext updatedby numeric 10
r_request updatedby numeric 10
w_advertisement updatedby numeric 10
w_basket updatedby numeric 10
w_basketline updatedby numeric 10
w_click updatedby numeric 10
w_clickcount updatedby numeric 10
w_counter updatedby numeric 10
w_countercount updatedby numeric 10
w_mailmsg updatedby numeric 10
w_mailmsg_trl updatedby numeric 10
w_store updatedby numeric 10
w_store_trl updatedby numeric 10
c_bpartner url varchar 120  √  null
w_store url varchar 120 'http://localhost'::character varying
w_click useragent varchar 255  √  null
w_counter useragent varchar 255  √  null
ad_user userpin varchar 20  √  null
w_advertisement validfrom timestamp 29,6  √  null
w_advertisement validto timestamp 29,6  √  null
ad_client value varchar 40
ad_user value varchar 40  √  null
c_bpartner value varchar 40
c_paymentterm value varchar 40
m_product value varchar 510
m_warehouse value varchar 40
w_advertisement version numeric 10  √  null
m_product versionno varchar 20  √  null
m_product volume numeric 0  √  0
w_advertisement w_advertisement_id numeric 10
w_advertisement w_advertisement_uu varchar 36  √  NULL::character varying
w_basket w_basket_id numeric 10
w_basketline w_basket_id numeric 10
w_basket w_basket_uu varchar 36  √  NULL::character varying
w_basketline w_basketline_id numeric 10
w_basketline w_basketline_uu varchar 36  √  NULL::character varying
w_click w_click_id numeric 10
w_click w_click_uu varchar 36  √  NULL::character varying
w_advertisement w_clickcount_id numeric 10  √  null
w_click w_clickcount_id numeric 10  √  null
w_clickcount w_clickcount_id numeric 10
w_clickcount w_clickcount_uu varchar 36  √  NULL::character varying
w_counter w_counter_id numeric 10
w_counter w_counter_uu varchar 36  √  NULL::character varying
w_advertisement w_countercount_id numeric 10  √  null
w_counter w_countercount_id numeric 10  √  null
w_countercount w_countercount_id numeric 10
w_countercount w_countercount_uu varchar 36  √  NULL::character varying
ad_usermail w_mailmsg_id numeric 10  √  null
w_mailmsg w_mailmsg_id numeric 10
w_mailmsg_trl w_mailmsg_id numeric 10
w_mailmsg_trl w_mailmsg_trl_uu varchar 36  √  NULL::character varying
w_mailmsg w_mailmsg_uu varchar 36  √  NULL::character varying
w_mailmsg w_store_id numeric 10
w_store w_store_id numeric 10
w_store_trl w_store_id numeric 10
w_store_trl w_store_trl_uu varchar 36  √  NULL::character varying
w_store w_store_uu varchar 36  √  NULL::character varying
w_store webcontext varchar 20
w_store webinfo varchar 2000  √  null
w_store_trl webinfo varchar 2000  √  null
w_store weborderemail varchar 60  √  null
w_advertisement webparam1 varchar 2000  √  null
w_store webparam1 varchar 2000  √  null
w_store_trl webparam1 varchar 2000  √  null
w_advertisement webparam2 varchar 2000  √  null
w_store webparam2 varchar 2000  √  null
w_store_trl webparam2 varchar 2000  √  null
w_advertisement webparam3 varchar 2000  √  null
w_store webparam3 varchar 2000  √  null
w_store_trl webparam3 varchar 2000  √  null
w_advertisement webparam4 varchar 2000  √  null
w_store webparam4 varchar 2000  √  null
w_store_trl webparam4 varchar 2000  √  null
w_store webparam5 varchar 2000  √  null
w_store_trl webparam5 varchar 2000  √  null
w_store webparam6 varchar 2000  √  null
w_store_trl webparam6 varchar 2000  √  null
m_product weight numeric 0  √  0
ad_client windowsarchivepath varchar 255  √  null
ad_client windowsattachmentpath varchar 255  √  null
w_store wstoreemail varchar 60  √  null
w_store wstoreuser varchar 60  √  null
w_store wstoreuserpw varchar 20  √  null