SchemaSpy Analysis of idempiere9.adempiere - ColumnsClient & Organization | Generated by Quality Systems & Solutions |
Generated on 2021-12-25 14:46 +0100 |
| |||||
|
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 | varchar | 60 | √ | NULL::character varying | ||
ad_user | 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 |