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

idempiere11.adempiere contains 474 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_printcolor ad_client_id numeric 10
ad_printcolor ad_org_id numeric 10
ad_printcolor ad_printcolor_id numeric 10
ad_printcolor ad_printcolor_uu varchar 36  √  NULL::character varying
ad_printcolor code varchar 2000
ad_printcolor created timestamp 29,6 now()
ad_printcolor createdby numeric 10
ad_printcolor isactive bpchar 1 'Y'::bpchar
ad_printcolor isdefault bpchar 1 'N'::bpchar
ad_printcolor name varchar 60
ad_printcolor updated timestamp 29,6 now()
ad_printcolor updatedby numeric 10
ad_user ad_client_id numeric 10
ad_user ad_image_id numeric 10  √  NULL::numeric
ad_user ad_org_id numeric 10
ad_user ad_orgtrx_id numeric 10  √  null
ad_user ad_user_id numeric 10
ad_user ad_user_uu varchar 36  √  NULL::character varying
ad_user answer varchar 1024  √  NULL::character varying
ad_user authenticationtype varchar 10  √  NULL::character varying
ad_user birthday timestamp 29,6  √  null
ad_user bp_location_id numeric 10  √  NULL::numeric
ad_user bpname varchar 60  √  NULL::character varying
ad_user c_bpartner_id numeric 10  √  null
ad_user c_bpartner_location_id numeric 10  √  null
ad_user c_campaign_id numeric 10  √  NULL::numeric
ad_user c_greeting_id numeric 10  √  null
ad_user c_job_id numeric 10  √  null
ad_user c_location_id numeric 10  √  NULL::numeric
ad_user comments varchar 2000  √  null
ad_user connectionprofile bpchar 1  √  null
ad_user created timestamp 29,6 now()
ad_user createdby numeric 10
ad_user dateaccountlocked timestamp 29,6  √  null
ad_user datelastlogin timestamp 29,6  √  null
ad_user datepasswordchanged timestamp 29,6  √  null
ad_user description varchar 255  √  null
ad_user email varchar 60  √  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
ad_user failedlogincount numeric 10 (0)::numeric
ad_user fax varchar 40  √  null
ad_user isactive bpchar 1 'Y'::bpchar
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar
ad_user isbillto bpchar 1 'N'::bpchar
ad_user isexpired bpchar 1 'N'::bpchar
ad_user isfullbpaccess bpchar 1 'Y'::bpchar
ad_user isinpayroll bpchar 1 'N'::bpchar
ad_user islocked bpchar 1 'N'::bpchar
ad_user ismenuautoexpand bpchar 1  √  null
ad_user isnoexpire bpchar 1 'N'::bpchar
ad_user isnopasswordreset bpchar 1 'N'::bpchar
ad_user issaleslead bpchar 1 'N'::bpchar
ad_user isshipto bpchar 1 'N'::bpchar
ad_user issupportuser bpchar 1 'N'::bpchar
ad_user isvendorlead bpchar 1 'N'::bpchar
ad_user lastcontact timestamp 29,6  √  null
ad_user lastresult 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
ad_user name varchar 60
ad_user notificationtype bpchar 1 'X'::bpchar
ad_user password varchar 1024  √  null
ad_user phone varchar 40  √  null
ad_user phone2 varchar 40  √  null
ad_user processing bpchar 1  √  null
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric
ad_user salesrep_id numeric 10  √  NULL::numeric
ad_user salt varchar 16  √  NULL::character varying
ad_user securityquestion varchar 1024  √  null
ad_user supervisor_id numeric 10  √  null
ad_user title varchar 40  √  null
ad_user updated timestamp 29,6 now()
ad_user updatedby numeric 10
ad_user userpin varchar 20  √  null
ad_user value varchar 40  √  null
c_bpartner acqusitioncost numeric 0  √  0
c_bpartner actuallifetimevalue numeric 0  √  0
c_bpartner ad_client_id numeric 10
c_bpartner ad_language varchar 6  √  null
c_bpartner ad_org_id numeric 10
c_bpartner ad_orgbp_id numeric 10  √  null
c_bpartner bpartner_parent_id numeric 10  √  null
c_bpartner c_bp_group_id numeric 10
c_bpartner c_bpartner_id numeric 10
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying
c_bpartner c_dunning_id numeric 10  √  null
c_bpartner c_greeting_id numeric 10  √  null
c_bpartner c_invoiceschedule_id numeric 10  √  null
c_bpartner c_paymentterm_id numeric 10  √  null
c_bpartner c_taxgroup_id numeric 10  √  null
c_bpartner created timestamp 29,6 now()
c_bpartner createdby numeric 10
c_bpartner customerprofileid varchar 60  √  NULL::character varying
c_bpartner default1099box_id numeric 10  √  NULL::numeric
c_bpartner deliveryrule bpchar 1  √  null
c_bpartner deliveryviarule bpchar 1  √  null
c_bpartner description varchar 255  √  null
c_bpartner documentcopies numeric 10  √  null
c_bpartner dunninggrace timestamp 29,6  √  null
c_bpartner duns varchar 11  √  null
c_bpartner firstsale timestamp 29,6  √  null
c_bpartner flatdiscount numeric 0  √  null
c_bpartner freightcostrule bpchar 1  √  null
c_bpartner invoice_printformat_id numeric 10  √  null
c_bpartner invoicerule bpchar 1  √  null
c_bpartner is1099vendor bpchar 1 'N'::bpchar
c_bpartner isactive bpchar 1 'Y'::bpchar
c_bpartner iscustomer bpchar 1 'Y'::bpchar
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar
c_bpartner isemployee bpchar 1 'N'::bpchar
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar
c_bpartner isonetime bpchar 1 'N'::bpchar
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar
c_bpartner isprospect bpchar 1 'N'::bpchar
c_bpartner issalesrep bpchar 1 'N'::bpchar
c_bpartner issummary bpchar 1 'N'::bpchar
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar
c_bpartner isvendor bpchar 1 'N'::bpchar
c_bpartner logo_id numeric 10  √  NULL::numeric
c_bpartner m_discountschema_id numeric 10  √  null
c_bpartner m_pricelist_id numeric 10  √  null
c_bpartner naics varchar 6  √  null
c_bpartner name varchar 120
c_bpartner name2 varchar 60  √  null
c_bpartner numberemployees numeric 10  √  null
c_bpartner paymentrule bpchar 1  √  null
c_bpartner paymentrulepo bpchar 1  √  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
c_bpartner rating bpchar 1  √  null
c_bpartner referenceno varchar 40  √  null
c_bpartner salesrep_id numeric 10  √  null
c_bpartner salesvolume numeric 10  √  null
c_bpartner sendemail bpchar 1 'N'::bpchar
c_bpartner shareofcustomer numeric 10  √  null
c_bpartner shelflifeminpct numeric 10  √  null
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
c_bpartner taxid varchar 20  √  null
c_bpartner totalopenbalance numeric 0  √  null
c_bpartner updated timestamp 29,6 now()
c_bpartner updatedby numeric 10
c_bpartner url varchar 120  √  null
c_bpartner value varchar 40
c_doctype ad_client_id numeric 10
c_doctype ad_org_id numeric 10
c_doctype ad_printformat_id numeric 10  √  null
c_doctype c_doctype_id numeric 10
c_doctype c_doctype_uu varchar 36  √  NULL::character varying
c_doctype c_doctypedifference_id numeric 10  √  null
c_doctype c_doctypeinvoice_id numeric 10  √  null
c_doctype c_doctypeproforma_id numeric 10  √  null
c_doctype c_doctypeshipment_id numeric 10  √  null
c_doctype created timestamp 29,6 now()
c_doctype createdby numeric 10
c_doctype definitesequence_id numeric 10  √  null
c_doctype description varchar 255  √  null
c_doctype docbasetype bpchar 3
c_doctype docnosequence_id numeric 10  √  null
c_doctype docsubtypeinv varchar 2  √  NULL::character varying
c_doctype docsubtypeso bpchar 2  √  null
c_doctype documentcopies numeric 10
c_doctype documentnote varchar 2000  √  null
c_doctype gl_category_id numeric 10
c_doctype hascharges bpchar 1 'N'::bpchar
c_doctype hasproforma bpchar 1  √  'N'::bpchar
c_doctype isactive bpchar 1 'Y'::bpchar
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar
c_doctype iscreatecounter bpchar 1 'Y'::bpchar
c_doctype isdefault bpchar 1 'N'::bpchar
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar
c_doctype isindexed bpchar 1 'Y'::bpchar
c_doctype isintransit bpchar 1 'N'::bpchar
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar
c_doctype isshipconfirm bpchar 1 'N'::bpchar
c_doctype issotrx bpchar 1 'Y'::bpchar
c_doctype issplitwhendifference bpchar 1 'N'::bpchar
c_doctype name varchar 60
c_doctype printname varchar 60
c_doctype updated timestamp 29,6 now()
c_doctype updatedby numeric 10
c_payment a_city varchar 60  √  null
c_payment a_country varchar 40  √  null
c_payment a_email varchar 60  √  null
c_payment a_ident_dl varchar 20  √  null
c_payment a_ident_ssn varchar 20  √  null
c_payment a_name varchar 60  √  null
c_payment a_state varchar 40  √  null
c_payment a_street varchar 60  √  null
c_payment a_zip varchar 20  √  null
c_payment accountno varchar 20  √  null
c_payment ad_client_id numeric 10
c_payment ad_org_id numeric 10
c_payment ad_orgtrx_id numeric 10  √  null
c_payment c_activity_id numeric 10  √  null
c_payment c_bankaccount_id numeric 10  √  null
c_payment c_banktransfer_id numeric 10  √  NULL::numeric
c_payment c_bp_bankaccount_id numeric 10  √  null
c_payment c_bpartner_id numeric 10  √  null
c_payment c_campaign_id numeric 10  √  null
c_payment c_cashbook_id numeric 10  √  null
c_payment c_charge_id numeric 10  √  null
c_payment c_conversiontype_id numeric 10  √  null
c_payment c_currency_id numeric 10
c_payment c_depositbatch_id numeric 10  √  NULL::numeric
c_payment c_doctype_id numeric 10
c_payment c_invoice_id numeric 10  √  null
c_payment c_order_id numeric 10  √  null
c_payment c_payment_id numeric 10
c_payment c_payment_uu varchar 36  √  NULL::character varying
c_payment c_paymentbatch_id numeric 10  √  null
c_payment c_paymentprocessor_id numeric 10  √  NULL::numeric
c_payment c_postendertype_id numeric 10  √  NULL::numeric
c_payment c_project_id numeric 10  √  null
c_payment chargeamt numeric 0  √  0
c_payment checkno varchar 20  √  null
c_payment convertedamt numeric 0  √  null
c_payment created timestamp 29,6 now()
c_payment createdby numeric 10
c_payment creditcardexpmm numeric 10  √  null
c_payment creditcardexpyy numeric 10  √  null
c_payment creditcardnumber varchar 20  √  null
c_payment creditcardtype bpchar 1  √  null
c_payment creditcardvv varchar 4  √  null
c_payment currencyrate numeric 0  √  null
c_payment customeraddressid varchar 60  √  NULL::character varying
c_payment customerpaymentprofileid varchar 60  √  NULL::character varying
c_payment customerprofileid varchar 60  √  NULL::character varying
c_payment dateacct timestamp 29,6
c_payment datetrx timestamp 29,6
c_payment description varchar 255  √  null
c_payment discountamt numeric 0  √  0
c_payment docaction bpchar 2
c_payment docstatus bpchar 2
c_payment documentno varchar 30
c_payment iban varchar 40  √  NULL::character varying
c_payment isactive bpchar 1 'Y'::bpchar
c_payment isallocated bpchar 1 'N'::bpchar
c_payment isapproved bpchar 1 'N'::bpchar
c_payment isdelayedcapture bpchar 1 'N'::bpchar
c_payment isonline bpchar 1 'N'::bpchar
c_payment isoverridecurrencyrate bpchar 1 'N'::bpchar
c_payment isoverunderpayment bpchar 1 'Y'::bpchar
c_payment isprepayment bpchar 1 'N'::bpchar
c_payment isreceipt bpchar 1 'Y'::bpchar
c_payment isreconciled bpchar 1 'N'::bpchar
c_payment isselfservice bpchar 1 'N'::bpchar
c_payment isvoided bpchar 1 'N'::bpchar
c_payment micr varchar 20  √  null
c_payment oprocessing bpchar 1  √  null
c_payment orig_trxid varchar 20  √  null
c_payment overunderamt numeric 0  √  0
c_payment payamt numeric 0 0
c_payment ponum varchar 60  √  null
c_payment posted bpchar 1 'N'::bpchar
c_payment processed bpchar 1 'N'::bpchar
c_payment processedon numeric 0  √  null
c_payment processing bpchar 1  √  null
c_payment r_authcode varchar 20  √  null
c_payment r_authcode_dc varchar 20  √  null
c_payment r_avsaddr bpchar 1  √  null
c_payment r_avszip bpchar 1  √  null
c_payment r_cvv2match bpchar 1  √  null
c_payment r_info varchar 2000  √  null
c_payment r_pnref varchar 20  √  null
c_payment r_pnref_dc varchar 20  √  null
c_payment r_respmsg varchar 60  √  null
c_payment r_result varchar 20  √  null
c_payment r_voidmsg varchar 255  √  NULL::character varying
c_payment ref_payment_id numeric 10  √  null
c_payment reversal_id numeric 10  √  null
c_payment routingno varchar 20  √  null
c_payment swiftcode varchar 20  √  NULL::character varying
c_payment swipe varchar 80  √  null
c_payment taxamt numeric 0  √  0
c_payment tendertype bpchar 1
c_payment trxtype bpchar 1
c_payment updated timestamp 29,6 now()
c_payment updatedby numeric 10
c_payment user1_id numeric 10  √  null
c_payment user2_id numeric 10  √  null
c_payment voiceauthcode varchar 20  √  null
c_payment writeoffamt numeric 0  √  0
c_pos ad_client_id numeric 10
c_pos ad_org_id numeric 10
c_pos autologoutdelay numeric 10  √  NULL::numeric
c_pos c_bankaccount_id numeric 10  √  null
c_pos c_bpartnercashtrx_id numeric 10  √  null
c_pos c_cashbook_id numeric 10  √  null
c_pos c_doctype_id numeric 10  √  null
c_pos c_pos_id numeric 10
c_pos c_pos_uu varchar 36  √  NULL::character varying
c_pos c_poskeylayout_id numeric 10  √  null
c_pos cashdrawer varchar 120  √  null
c_pos created timestamp 29,6 now()
c_pos createdby numeric 10
c_pos description varchar 255  √  null
c_pos help varchar 2000  √  null
c_pos isactive bpchar 1 'Y'::bpchar
c_pos ismodifyprice bpchar 1 'N'::bpchar
c_pos m_pricelist_id numeric 10
c_pos m_warehouse_id numeric 10
c_pos name varchar 60
c_pos osk_keylayout_id numeric 10  √  NULL::numeric
c_pos osnp_keylayout_id numeric 10  √  NULL::numeric
c_pos printername varchar 60  √  null
c_pos salesrep_id numeric 10
c_pos updated timestamp 29,6 now()
c_pos updatedby numeric 10
c_poskey ad_client_id numeric 10
c_poskey ad_image_id numeric 10  √  NULL::numeric
c_poskey ad_org_id numeric 10
c_poskey ad_printcolor_id numeric 10  √  null
c_poskey ad_printfont_id numeric 10  √  NULL::numeric
c_poskey c_poskey_id numeric 10
c_poskey c_poskey_uu varchar 36  √  NULL::character varying
c_poskey c_poskeylayout_id numeric 10
c_poskey created timestamp 29,6 now()
c_poskey createdby numeric 10
c_poskey description varchar 255  √  null
c_poskey isactive bpchar 1 'Y'::bpchar
c_poskey m_product_id numeric 10  √  null
c_poskey name varchar 60
c_poskey qty numeric 0  √  null
c_poskey seqno numeric 10 0
c_poskey spanx numeric 10  √  NULL::numeric
c_poskey spany numeric 10  √  NULL::numeric
c_poskey subkeylayout_id numeric 10  √  NULL::numeric
c_poskey text varchar 22  √  NULL::character varying
c_poskey updated timestamp 29,6 now()
c_poskey updatedby numeric 10
c_poskeylayout ad_client_id numeric 10
c_poskeylayout ad_org_id numeric 10
c_poskeylayout ad_printcolor_id numeric 10  √  NULL::numeric
c_poskeylayout ad_printfont_id numeric 10  √  NULL::numeric
c_poskeylayout c_poskeylayout_id numeric 10
c_poskeylayout c_poskeylayout_uu varchar 36  √  NULL::character varying
c_poskeylayout columns numeric 10  √  NULL::numeric
c_poskeylayout created timestamp 29,6 now()
c_poskeylayout createdby numeric 10
c_poskeylayout description varchar 255  √  null
c_poskeylayout help varchar 2000  √  null
c_poskeylayout isactive bpchar 1 'Y'::bpchar
c_poskeylayout name varchar 60
c_poskeylayout poskeylayouttype bpchar 1  √  NULL::bpchar
c_poskeylayout updated timestamp 29,6 now()
c_poskeylayout updatedby numeric 10
m_pricelist ad_client_id numeric 10
m_pricelist ad_org_id numeric 10
m_pricelist basepricelist_id numeric 10  √  null
m_pricelist c_currency_id numeric 10
m_pricelist created timestamp 29,6 now()
m_pricelist createdby numeric 10
m_pricelist description varchar 255  √  null
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar
m_pricelist isactive bpchar 1 'Y'::bpchar
m_pricelist isdefault bpchar 1 'N'::bpchar
m_pricelist ismandatory bpchar 1  √  'N'::bpchar
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar
m_pricelist issopricelist bpchar 1 'Y'::bpchar
m_pricelist istaxincluded bpchar 1 'N'::bpchar
m_pricelist m_pricelist_id numeric 10
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying
m_pricelist name varchar 60
m_pricelist priceprecision numeric 10 2
m_pricelist updated timestamp 29,6 now()
m_pricelist updatedby numeric 10
m_product ad_client_id numeric 10
m_product ad_org_id numeric 10
m_product c_revenuerecognition_id numeric 10  √  null
m_product c_subscriptiontype_id numeric 10  √  null
m_product c_taxcategory_id numeric 10
m_product c_uom_id numeric 10
m_product classification varchar 12  √  null
m_product copyfrom bpchar 1  √  NULL::bpchar
m_product created timestamp 29,6 now()
m_product createdby numeric 10
m_product customstariffnumber varchar 20  √  null
m_product 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
m_product documentnote varchar 2000  √  null
m_product downloadurl varchar 120  √  null
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
m_product imageurl varchar 120  √  null
m_product isactive bpchar 1 'Y'::bpchar
m_product isautoproduce bpchar 1 'N'::bpchar
m_product isbom bpchar 1 'N'::bpchar
m_product isdropship bpchar 1 'N'::bpchar
m_product isexcludeautodelivery bpchar 1 'N'::bpchar
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar
m_product iskanban bpchar 1 'N'::bpchar
m_product ismanufactured 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
m_product ispurchased bpchar 1 'Y'::bpchar
m_product isselfservice bpchar 1 'Y'::bpchar
m_product issold bpchar 1 'Y'::bpchar
m_product isstocked bpchar 1 'Y'::bpchar
m_product issummary bpchar 1 'N'::bpchar
m_product istoformule bpchar 1  √  null
m_product isverified bpchar 1 'N'::bpchar
m_product iswebstorefeatured bpchar 1 'N'::bpchar
m_product lowlevel numeric 10 (0)::numeric
m_product m_attributeset_id numeric 10  √  null
m_product m_attributesetinstance_id numeric 10  √  0
m_product m_freightcategory_id numeric 10  √  null
m_product m_locator_id numeric 10  √  null
m_product m_parttype_id numeric 10  √  NULL::numeric
m_product m_product_category_id numeric 10
m_product m_product_id numeric 10
m_product m_product_uu varchar 36  √  NULL::character varying
m_product name varchar 255
m_product processing bpchar 1  √  null
m_product producttype bpchar 1 'I'::bpchar
m_product r_mailtext_id numeric 10  √  null
m_product s_expensetype_id numeric 10  √  null
m_product s_resource_id numeric 10  √  null
m_product salesrep_id numeric 10  √  null
m_product shelfdepth numeric 10  √  null
m_product shelfheight numeric 0  √  null
m_product shelfwidth numeric 10  √  null
m_product sku varchar 30  √  null
m_product unitsperpack numeric 10 1
m_product unitsperpallet numeric 0  √  null
m_product upc varchar 30  √  null
m_product updated timestamp 29,6 now()
m_product updatedby numeric 10
m_product value varchar 510
m_product versionno varchar 20  √  null
m_product volume numeric 0  √  0
m_product weight numeric 0  √  0
m_warehouse ad_client_id numeric 10
m_warehouse ad_org_id numeric 10
m_warehouse c_location_id numeric 10
m_warehouse created timestamp 29,6 now()
m_warehouse createdby numeric 10
m_warehouse description varchar 255  √  null
m_warehouse isactive bpchar 1 'Y'::bpchar
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar
m_warehouse isintransit bpchar 1  √  'N'::bpchar
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric
m_warehouse m_warehouse_id numeric 10
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying
m_warehouse m_warehousesource_id numeric 10  √  null
m_warehouse name varchar 60
m_warehouse replenishmentclass varchar 60  √  null
m_warehouse separator bpchar 1
m_warehouse updated timestamp 29,6 now()
m_warehouse updatedby numeric 10
m_warehouse value varchar 40