SchemaSpy Analysis of idempiere11.adempiere - ColumnsWebStore | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:57 +0100 |
| |||||
|
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 | varchar | 60 | √ | null | ||
w_basket | varchar | 60 | √ | null | ||
w_click | varchar | 60 | √ | null | ||
w_counter | 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 |