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

idempiere9.adempiere contains 547 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_bpartner acqusitioncost numeric 0  √  0
c_bpartner actuallifetimevalue numeric 0  √  0
ad_org ad_replicationstrategy_id numeric 0  √  null
c_bpartner flatdiscount numeric 0  √  null
ad_system idrangeend numeric 0  √  null
ad_system idrangestart numeric 0  √  null
c_bpartner potentiallifetimevalue numeric 0  √  0
c_bpartner so_creditlimit numeric 0  √  0
c_bpartner so_creditused numeric 0  √  0
c_bpartner totalopenbalance numeric 0  √  null
ad_orginfo transferbank_id numeric 0  √  null
ad_orginfo transfercashbook_id numeric 0  √  null
ad_table accesslevel bpchar 1
c_country allowcitiesoutoflist bpchar 1  √  'Y'::bpchar
ad_client autoarchive bpchar 1 'N'::bpchar
ad_user connectionprofile bpchar 1  √  null
ad_table copycolumnsfromtable varchar 1  √  null
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar
c_bpartner deliveryrule bpchar 1  √  null
c_bpartner deliveryviarule bpchar 1  √  null
ad_client emailtest bpchar 1  √  null
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar
c_bpartner freightcostrule bpchar 1  √  null
c_country haspostal_add bpchar 1 'N'::bpchar
c_country hasregion bpchar 1 'N'::bpchar
ad_table importtable bpchar 1  √  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_clientshare isactive bpchar 1 'Y'::bpchar
ad_language isactive bpchar 1 'N'::bpchar
ad_org isactive bpchar 1 'Y'::bpchar
ad_org_v isactive bpchar 1  √  null
ad_orginfo isactive bpchar 1 'Y'::bpchar
ad_orgtype isactive bpchar 1 'Y'::bpchar
ad_preference isactive bpchar 1 'Y'::bpchar
ad_printform isactive bpchar 1 'Y'::bpchar
ad_registration isactive bpchar 1 'Y'::bpchar
ad_system isactive bpchar 1 'Y'::bpchar
ad_table isactive bpchar 1 'Y'::bpchar
ad_user isactive bpchar 1 'Y'::bpchar
c_bpartner isactive bpchar 1 'Y'::bpchar
c_country isactive bpchar 1 'Y'::bpchar
m_pricelist isactive bpchar 1 'Y'::bpchar
m_warehouse isactive bpchar 1 'Y'::bpchar
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar
c_country isaddresslineslocalreverse bpchar 1 'N'::bpchar
c_country isaddresslinesreverse bpchar 1 'N'::bpchar
ad_registration isallowpublish bpchar 1 'Y'::bpchar
ad_registration isallowstatistics bpchar 1 'Y'::bpchar
ad_system isallowstatistics bpchar 1 'Y'::bpchar
ad_system isautoerrorreport bpchar 1 'Y'::bpchar
ad_language isbaselanguage bpchar 1 'N'::bpchar
ad_user isbillto bpchar 1 'N'::bpchar
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar
ad_table ischangelog 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
m_pricelist isdefault bpchar 1 'N'::bpchar
ad_table isdeleteable bpchar 1 'Y'::bpchar
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar
c_bpartner isemployee bpchar 1 'N'::bpchar
ad_user isexpired bpchar 1 'N'::bpchar
ad_system isfailonbuilddiffer bpchar 1 'N'::bpchar
ad_system isfailonmissingmodelvalidator bpchar 1 'Y'::bpchar
ad_user isfullbpaccess bpchar 1 'Y'::bpchar
ad_table ishighvolume bpchar 1 'N'::bpchar
ad_user isinpayroll bpchar 1 'N'::bpchar
ad_registration isinproduction bpchar 1 'N'::bpchar
m_warehouse isintransit bpchar 1  √  'N'::bpchar
ad_system isjustmigrated 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
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar
ad_user ismenuautoexpand bpchar 1  √  null
ad_client ismultilingualdocument bpchar 1 'N'::bpchar
ad_user isnoexpire bpchar 1 'N'::bpchar
ad_user isnopasswordreset bpchar 1 'N'::bpchar
c_bpartner isonetime bpchar 1 'N'::bpchar
c_country ispostcodelookup 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
ad_registration isregistered bpchar 1 'N'::bpchar
ad_user issaleslead bpchar 1 'N'::bpchar
c_bpartner issalesrep bpchar 1 'N'::bpchar
ad_client issecuresmtp bpchar 1 'N'::bpchar
ad_table issecurityenabled 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_pricelist issopricelist bpchar 1 'Y'::bpchar
ad_org issummary bpchar 1 'N'::bpchar
ad_org_v issummary bpchar 1  √  null
c_bpartner 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
ad_client isuseasp bpchar 1 'N'::bpchar
ad_client isusebetafunctions bpchar 1 'N'::bpchar
c_bpartner isvendor bpchar 1 'N'::bpchar
ad_user isvendorlead bpchar 1 'N'::bpchar
ad_table isview bpchar 1 'N'::bpchar
ad_client mmpolicy bpchar 1 'F'::bpchar
ad_user notificationtype bpchar 1 'X'::bpchar
c_bpartner paymentrule bpchar 1  √  null
c_bpartner paymentrulepo bpchar 1  √  null
ad_preference preferencefor bpchar 1 'W'::bpchar
ad_language processing bpchar 1  √  null
ad_registration processing bpchar 1  √  null
ad_system processing bpchar 1  √  null
ad_table processing bpchar 1  √  NULL::bpchar
ad_user processing bpchar 1  √  null
c_bpartner rating bpchar 1  √  null
ad_system replicationtype bpchar 1 'L'::bpchar
ad_table replicationtype bpchar 1 'L'::bpchar
c_bpartner sendemail bpchar 1 'N'::bpchar
m_warehouse separator bpchar 1
ad_clientshare sharetype bpchar 1
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar
ad_client storearchiveonfilesystem bpchar 1 'N'::bpchar
ad_client storeattachmentsonfilesystem bpchar 1 'N'::bpchar
ad_system systemstatus bpchar 1 'E'::bpchar
ad_language countrycode bpchar 2  √  null
c_country countrycode bpchar 2
ad_language languageiso bpchar 2  √  null
ad_client ad_language varchar 6  √  null
ad_language ad_language varchar 6
c_bpartner ad_language varchar 6  √  null
c_country ad_language varchar 6  √  null
c_bpartner naics varchar 6  √  null
ad_client ad_client_id numeric 10
ad_clientinfo ad_client_id numeric 10
ad_clientshare ad_client_id numeric 10
ad_language ad_client_id numeric 10
ad_org ad_client_id numeric 10
ad_org_v ad_client_id numeric 10  √  null
ad_orginfo ad_client_id numeric 10
ad_orgtype ad_client_id numeric 10
ad_preference ad_client_id numeric 10
ad_printform ad_client_id numeric 10  √  null
ad_registration ad_client_id numeric 10
ad_system ad_client_id numeric 10
ad_table ad_client_id numeric 10
ad_user ad_client_id numeric 10
c_bpartner ad_client_id numeric 10
c_country ad_client_id numeric 10
m_pricelist ad_client_id numeric 10
m_warehouse ad_client_id numeric 10
ad_clientshare ad_clientshare_id numeric 10
ad_user ad_image_id numeric 10  √  NULL::numeric
ad_preference ad_infowindow_id numeric 10  √  NULL::numeric
ad_language ad_language_id numeric 10
ad_client ad_org_id numeric 10
ad_clientinfo ad_org_id numeric 10
ad_clientshare ad_org_id numeric 10
ad_language ad_org_id numeric 10
ad_org ad_org_id numeric 10
ad_org_v ad_org_id numeric 10  √  null
ad_orginfo ad_org_id numeric 10
ad_orgtype ad_org_id numeric 10
ad_preference ad_org_id numeric 10
ad_printform ad_org_id numeric 10
ad_registration ad_org_id numeric 10
ad_system ad_org_id numeric 10
ad_table ad_org_id numeric 10
ad_user ad_org_id numeric 10
c_bpartner ad_org_id numeric 10
c_country ad_org_id numeric 10
m_pricelist ad_org_id numeric 10
m_warehouse ad_org_id numeric 10
c_bpartner ad_orgbp_id numeric 10  √  null
ad_user ad_orgtrx_id numeric 10  √  null
ad_org_v ad_orgtype_id numeric 10  √  null
ad_orginfo ad_orgtype_id numeric 10  √  null
ad_orgtype ad_orgtype_id numeric 10
ad_client ad_passwordrule_id numeric 10  √  NULL::numeric
ad_preference ad_preference_id numeric 10
ad_orgtype ad_printcolor_id numeric 10  √  null
ad_printform ad_printform_id numeric 10
ad_language ad_printpaper_id numeric 10  √  NULL::numeric
ad_preference ad_process_id numeric 10  √  NULL::numeric
ad_registration ad_registration_id numeric 10
ad_client ad_replicationstrategy_id numeric 10  √  null
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric
ad_registration ad_system_id numeric 10
ad_system ad_system_id numeric 10
ad_clientshare ad_table_id numeric 10
ad_table ad_table_id numeric 10
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_preference ad_user_id numeric 10  √  null
ad_user ad_user_id numeric 10
ad_table ad_val_rule_id numeric 10  √  null
ad_preference ad_window_id numeric 10  √  null
ad_table ad_window_id numeric 10  √  null
m_pricelist basepricelist_id numeric 10  √  null
ad_user bp_location_id numeric 10  √  NULL::numeric
c_bpartner bpartner_parent_id numeric 10  √  null
ad_clientinfo c_acctschema1_id numeric 10  √  null
c_bpartner c_bp_group_id numeric 10
ad_org_v c_bpartner_id numeric 10  √  null
ad_user c_bpartner_id numeric 10  √  null
c_bpartner c_bpartner_id numeric 10
ad_user c_bpartner_location_id numeric 10  √  null
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null
ad_clientinfo c_calendar_id numeric 10  √  null
ad_orginfo c_calendar_id numeric 10  √  null
ad_user c_campaign_id numeric 10  √  NULL::numeric
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric
c_country c_country_id numeric 10
ad_registration c_currency_id numeric 10  √  null
c_country c_currency_id numeric 10  √  null
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
c_bpartner c_invoiceschedule_id numeric 10  √  null
ad_user c_job_id numeric 10  √  null
ad_org_v c_location_id numeric 10  √  null
ad_orginfo c_location_id numeric 10  √  null
ad_registration c_location_id numeric 10  √  null
ad_user c_location_id numeric 10  √  NULL::numeric
m_warehouse c_location_id numeric 10
c_bpartner c_paymentterm_id numeric 10  √  null
c_bpartner c_taxgroup_id numeric 10  √  null
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
ad_client createdby numeric 10
ad_clientinfo createdby numeric 10
ad_clientshare createdby numeric 10
ad_language createdby numeric 10
ad_org createdby numeric 10
ad_org_v createdby numeric 10  √  null
ad_orginfo createdby numeric 10
ad_orgtype createdby numeric 10
ad_preference createdby numeric 10
ad_printform createdby numeric 10
ad_registration createdby numeric 10
ad_system createdby numeric 10
ad_table createdby numeric 10
ad_user createdby numeric 10
c_bpartner createdby numeric 10
c_country createdby numeric 10
m_pricelist createdby numeric 10
m_warehouse createdby numeric 10
c_bpartner default1099box_id numeric 10  √  NULL::numeric
ad_printform distrib_order_mailtext_id numeric 10  √  null
ad_printform distrib_order_printformat_id numeric 10  √  null
c_bpartner documentcopies numeric 10  √  null
ad_orginfo dropship_warehouse_id numeric 10  √  null
ad_user failedlogincount numeric 10 (0)::numeric
ad_printform invoice_mailtext_id numeric 10  √  null
ad_printform invoice_printformat_id numeric 10  √  null
c_bpartner invoice_printformat_id numeric 10  √  null
ad_clientinfo keeplogdays numeric 10  √  null
ad_user leadsource varchar 10  √  NULL::character varying
ad_user leadstatus varchar 10  √  NULL::character varying
ad_table loadseq numeric 10  √  null
ad_clientinfo logo_id numeric 10  √  NULL::numeric
ad_orginfo 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
c_bpartner m_discountschema_id numeric 10  √  null
c_bpartner m_pricelist_id numeric 10  √  null
m_pricelist m_pricelist_id numeric 10
ad_clientinfo m_productfreight_id numeric 10  √  null
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric
ad_org_v m_warehouse_id numeric 10  √  null
ad_orginfo m_warehouse_id numeric 10  √  null
m_warehouse m_warehouse_id numeric 10
m_warehouse m_warehousesource_id numeric 10  √  null
ad_printform manuf_order_mailtext_id numeric 10  √  null
ad_printform manuf_order_printformat_id numeric 10  √  null
ad_system noprocessors numeric 10  √  null
ad_registration numberemployees numeric 10  √  0
c_bpartner numberemployees numeric 10  √  null
ad_printform order_mailtext_id numeric 10  √  null
ad_printform order_printformat_id numeric 10  √  null
ad_orginfo pa_goal_id numeric 10  √  null
ad_org_v parent_org_id numeric 10  √  null
ad_orginfo parent_org_id numeric 10  √  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
ad_table po_window_id numeric 10  √  null
m_pricelist priceprecision numeric 10 2
ad_printform project_mailtext_id numeric 10  √  null
ad_printform project_printformat_id numeric 10  √  null
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric
ad_registration record_id numeric 10  √  null
ad_system record_id numeric 10  √  null
ad_system releaseno varchar 10  √  null
ad_printform remittance_mailtext_id numeric 10  √  null
ad_printform remittance_printformat_id numeric 10  √  null
ad_user salesrep_id numeric 10  √  NULL::numeric
c_bpartner salesrep_id numeric 10  √  null
ad_registration salesvolume numeric 10  √  0
c_bpartner salesvolume numeric 10  √  null
c_bpartner shareofcustomer numeric 10  √  null
c_bpartner shelflifeminpct numeric 10  √  null
ad_printform shipment_mailtext_id numeric 10  √  null
ad_printform shipment_printformat_id numeric 10  √  null
ad_client smtpport numeric 10  √  NULL::numeric
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric
ad_org_v supervisor_id numeric 10  √  null
ad_orginfo supervisor_id numeric 10  √  null
ad_user supervisor_id numeric 10  √  null
ad_system supportunits numeric 10  √  null
ad_client updatedby numeric 10
ad_clientinfo updatedby numeric 10
ad_clientshare updatedby numeric 10
ad_language updatedby numeric 10
ad_org updatedby numeric 10
ad_org_v updatedby numeric 10  √  null
ad_orginfo updatedby numeric 10
ad_orgtype updatedby numeric 10
ad_preference updatedby numeric 10
ad_printform updatedby numeric 10
ad_registration updatedby numeric 10
ad_system updatedby numeric 10
ad_table updatedby numeric 10
ad_user updatedby numeric 10
c_bpartner updatedby numeric 10
c_country updatedby numeric 10
m_pricelist updatedby numeric 10
m_warehouse updatedby numeric 10
ad_org_v duns varchar 11  √  null
ad_orginfo duns varchar 11
c_bpartner duns varchar 11  √  null
ad_user salt varchar 16  √  NULL::character varying
ad_language datepattern varchar 20  √  null
c_country displaysequence varchar 20
c_country displaysequencelocal varchar 20  √  null
c_country expressionbankaccountno varchar 20  √  null
c_country expressionbankroutingno varchar 20  √  null
c_country expressionphone varchar 20  √  null
c_country expressionpostal varchar 20  √  null
c_country expressionpostal_add varchar 20  √  null
ad_system password varchar 20  √  null
c_bpartner poreference varchar 20  √  null
ad_client requestfolder varchar 20  √  null
ad_org_v taxid varchar 20  √  null
ad_orginfo taxid varchar 20
c_bpartner taxid varchar 20  √  null
ad_language timepattern varchar 20  √  null
ad_user userpin varchar 20  √  null
ad_system version varchar 20  √  null
ad_user birthday timestamp 29,6  √  null
ad_client created timestamp 29,6 now()
ad_clientinfo created timestamp 29,6 now()
ad_clientshare created timestamp 29,6 now()
ad_language created timestamp 29,6 now()
ad_org created timestamp 29,6 now()
ad_org_v created timestamp 29,6  √  null
ad_orginfo created timestamp 29,6 now()
ad_orgtype created timestamp 29,6 now()
ad_preference created timestamp 29,6 now()
ad_printform created timestamp 29,6 now()
ad_registration created timestamp 29,6 now()
ad_system created timestamp 29,6 now()
ad_table created timestamp 29,6 now()
ad_user created timestamp 29,6 now()
c_bpartner created timestamp 29,6 now()
c_country created timestamp 29,6 now()
m_pricelist created timestamp 29,6 now()
m_warehouse created timestamp 29,6 now()
ad_user dateaccountlocked timestamp 29,6  √  null
ad_user datelastlogin timestamp 29,6  √  null
ad_user datepasswordchanged timestamp 29,6  √  null
c_bpartner dunninggrace timestamp 29,6  √  null
ad_user emailverifydate timestamp 29,6  √  null
c_bpartner firstsale timestamp 29,6  √  null
ad_clientinfo fy_startdate timestamp 29,6  √  null
ad_user lastcontact timestamp 29,6  √  null
ad_registration startproductiondate timestamp 29,6  √  null
ad_system supportexpdate timestamp 29,6  √  null
ad_client updated timestamp 29,6 now()
ad_clientinfo updated timestamp 29,6 now()
ad_clientshare updated timestamp 29,6 now()
ad_language updated timestamp 29,6 now()
ad_org updated timestamp 29,6 now()
ad_org_v updated timestamp 29,6  √  null
ad_orginfo updated timestamp 29,6 now()
ad_orgtype updated timestamp 29,6 now()
ad_preference updated timestamp 29,6 now()
ad_printform updated timestamp 29,6 now()
ad_registration updated timestamp 29,6 now()
ad_system updated timestamp 29,6 now()
ad_table updated timestamp 29,6 now()
ad_user updated timestamp 29,6 now()
c_bpartner updated timestamp 29,6 now()
c_country updated timestamp 29,6 now()
m_pricelist updated timestamp 29,6 now()
m_warehouse updated timestamp 29,6 now()
ad_client ad_client_uu varchar 36  √  NULL::character varying
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying
ad_clientshare ad_clientshare_uu varchar 36  √  NULL::character varying
ad_language ad_language_uu varchar 36  √  NULL::character varying
ad_org ad_org_uu varchar 36  √  NULL::character varying
ad_orginfo ad_orginfo_uu varchar 36  √  NULL::character varying
ad_orgtype ad_orgtype_uu varchar 36  √  NULL::character varying
ad_preference ad_preference_uu varchar 36  √  NULL::character varying
ad_printform ad_printform_uu varchar 36  √  NULL::character varying
ad_registration ad_registration_uu varchar 36  √  NULL::character varying
ad_system ad_system_uu varchar 36  √  NULL::character varying
ad_table ad_table_uu varchar 36  √  NULL::character varying
ad_user ad_user_uu varchar 36  √  NULL::character varying
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying
c_country c_country_uu varchar 36  √  NULL::character varying
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying
ad_user emailverify varchar 40  √  null
ad_table entitytype varchar 40 'D'::character varying
ad_orginfo fax varchar 40  √  NULL::character varying
ad_user fax varchar 40  √  null
c_country mediasize varchar 40  √  null
ad_orginfo phone varchar 40  √  NULL::character varying
ad_user phone varchar 40  √  null
ad_orginfo phone2 varchar 40  √  NULL::character varying
ad_user phone2 varchar 40  √  null
c_bpartner referenceno varchar 40  √  null
ad_table tablename varchar 40
ad_user title varchar 40  √  null
ad_client value varchar 40
ad_org value varchar 40
ad_org_v value varchar 40  √  null
ad_user value varchar 40  √  null
c_bpartner value varchar 40
m_warehouse value varchar 40
c_country lookupclientid varchar 50  √  null
c_country lookuppassword varchar 50  √  null
ad_preference attribute varchar 60
ad_user bpname varchar 60  √  NULL::character varying
c_country capturesequence varchar 60  √  null
c_bpartner customerprofileid varchar 60  √  NULL::character varying
ad_system customprefix varchar 60  √  null
ad_system dbinstance varchar 60  √  null
ad_client documentdir varchar 60  √  null
ad_orginfo email varchar 60  √  NULL::character varying
ad_user email varchar 60  √  null
ad_user emailuser varchar 60  √  null
ad_system ldaphost varchar 60  √  null
ad_user ldapuser varchar 60  √  null
ad_client name varchar 60
ad_clientshare name varchar 60
ad_language name varchar 60
ad_org name varchar 60
ad_org_v name varchar 60  √  null
ad_orgtype name varchar 60
ad_printform name varchar 60
ad_system name varchar 60
ad_table name varchar 60
ad_user name varchar 60
c_country name varchar 60
m_pricelist name varchar 60
m_warehouse name varchar 60
c_bpartner name2 varchar 60  √  null
ad_system oldname varchar 60  √  null
ad_language printname varchar 60 NULL::character varying
c_country regionname varchar 60  √  null
ad_registration remote_addr varchar 60  √  null
m_warehouse replenishmentclass varchar 60  √  null
ad_client requestemail varchar 60  √  null
ad_client requestuser varchar 60  √  null
ad_client smtphost varchar 60  √  null
ad_system statisticsinfo varchar 60  √  null
ad_system supportemail varchar 60  √  null
ad_system username varchar 60
ad_preference value varchar 60
c_country lookupurl varchar 100  √  null
c_bpartner name varchar 120
ad_registration remote_host varchar 120  √  null
c_bpartner url varchar 120  √  null
ad_system dbaddress varchar 255  √  null
ad_client description varchar 255  √  null
ad_clientshare description varchar 255  √  null
ad_org description varchar 255  √  null
ad_org_v description varchar 255  √  null
ad_orgtype description varchar 255  √  null
ad_printform description varchar 255  √  null
ad_registration description varchar 255  √  null
ad_system description varchar 255  √  null
ad_table description varchar 255  √  null
ad_user description varchar 255  √  null
c_bpartner description varchar 255  √  null
c_country description varchar 255  √  null
m_pricelist description varchar 255  √  null
m_warehouse description varchar 255  √  null
ad_user emailuserpw varchar 255  √  null
ad_system encryptionkey varchar 255  √  null
ad_registration industryinfo varchar 255  √  null
ad_system info varchar 255  √  null
ad_system lastbuildinfo varchar 255  √  null
ad_system lastmigrationscriptapplied varchar 255  √  NULL::character varying
ad_user lastresult varchar 255  √  null
ad_system ldapdomain varchar 255  √  null
ad_client ldapquery varchar 255  √  null
ad_user leadsourcedescription varchar 255  √  NULL::character varying
ad_user leadstatusdescription varchar 255  √  NULL::character varying
c_country lookupclassname varchar 255  √  null
ad_client modelvalidationclasses varchar 255  √  null
c_country placeholderaddress1 varchar 255  √  NULL::character varying
c_country placeholderaddress2 varchar 255  √  NULL::character varying
c_country placeholderaddress3 varchar 255  √  NULL::character varying
c_country placeholderaddress4 varchar 255  √  NULL::character varying
c_country placeholderaddress5 varchar 255  √  NULL::character varying
c_country placeholdercity varchar 255  √  NULL::character varying
c_country placeholdercomments varchar 255  √  NULL::character varying
c_country placeholderpostal varchar 255  √  NULL::character varying
c_country placeholderpostal_add varchar 255  √  NULL::character varying
ad_registration platforminfo varchar 255  √  null
ad_system profileinfo varchar 255  √  null
ad_client requestuserpw varchar 255  √  null
c_bpartner so_description varchar 255  √  null
ad_system summary varchar 255  √  null
ad_client unixarchivepath varchar 255  √  null
ad_client unixattachmentpath varchar 255  √  null
ad_client windowsarchivepath varchar 255  √  null
ad_client windowsattachmentpath varchar 255  √  null
ad_orginfo receiptfootermsg varchar 1023  √  null
ad_user answer varchar 1024  √  NULL::character varying
ad_user password varchar 1024  √  null
ad_user securityquestion varchar 1024  √  null
ad_user comments varchar 2000  √  null
ad_table help varchar 2000  √  null