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

idempiere9.adempiere contains 684 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_user ad_client_id numeric 10
c_bpartner ad_client_id numeric 10
c_calendar ad_client_id numeric 10
c_cashplan ad_client_id numeric 10
c_cashplanline ad_client_id numeric 10
c_charge ad_client_id numeric 10
c_doctype ad_client_id numeric 10
c_order ad_client_id numeric 10
c_orderline ad_client_id numeric 10
c_period ad_client_id numeric 10
c_year ad_client_id numeric 10
m_demand ad_client_id numeric 10
m_demanddetail ad_client_id numeric 10
m_demandline ad_client_id numeric 10
m_forecast ad_client_id numeric 10
m_forecastline ad_client_id numeric 10
m_pricelist ad_client_id numeric 10
m_product ad_client_id numeric 10
m_requisition ad_client_id numeric 10
m_requisitionline ad_client_id numeric 10
m_warehouse ad_client_id numeric 10
ad_user ad_image_id numeric 10  √  NULL::numeric
c_bpartner ad_language varchar 6  √  null
ad_user ad_org_id numeric 10
c_bpartner ad_org_id numeric 10
c_calendar ad_org_id numeric 10
c_cashplan ad_org_id numeric 10
c_cashplanline ad_org_id numeric 10
c_charge ad_org_id numeric 10
c_doctype ad_org_id numeric 10
c_order ad_org_id numeric 10
c_orderline ad_org_id numeric 10
c_period ad_org_id numeric 10
c_year ad_org_id numeric 10
m_demand ad_org_id numeric 10
m_demanddetail ad_org_id numeric 10
m_demandline ad_org_id numeric 10
m_forecast ad_org_id numeric 10
m_forecastline ad_org_id numeric 10
m_pricelist ad_org_id numeric 10
m_product ad_org_id numeric 10
m_requisition ad_org_id numeric 10
m_requisitionline 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
c_cashplan ad_orgtrx_id numeric 10  √  NULL::numeric
c_cashplanline ad_orgtrx_id numeric 10  √  NULL::numeric
c_order ad_orgtrx_id numeric 10  √  null
c_orderline ad_orgtrx_id numeric 10  √  null
c_doctype ad_printformat_id numeric 10  √  null
ad_user ad_user_id numeric 10
c_order ad_user_id numeric 10  √  null
m_requisition ad_user_id numeric 10
ad_user ad_user_uu varchar 36  √  NULL::character varying
c_order amountrefunded numeric 22,2  √  null
c_order amounttendered numeric 22,2  √  null
ad_user answer varchar 1024  √  NULL::character varying
m_pricelist basepricelist_id numeric 10  √  null
c_order bill_bpartner_id numeric 10  √  null
c_order bill_location_id numeric 10  √  null
c_order bill_user_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
c_cashplan c_activity_id numeric 10  √  null
c_cashplanline c_activity_id numeric 10  √  NULL::numeric
c_order c_activity_id numeric 10  √  null
c_orderline 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
c_cashplan c_bpartner_id numeric 10  √  NULL::numeric
c_cashplanline c_bpartner_id numeric 10  √  NULL::numeric
c_charge c_bpartner_id numeric 10  √  null
c_order c_bpartner_id numeric 10
c_orderline c_bpartner_id numeric 10  √  null
m_requisitionline c_bpartner_id numeric 10  √  NULL::numeric
ad_user c_bpartner_location_id numeric 10  √  null
c_order c_bpartner_location_id numeric 10
c_orderline c_bpartner_location_id numeric 10  √  null
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying
c_calendar c_calendar_id numeric 10
c_year c_calendar_id numeric 10
m_demand c_calendar_id numeric 10
m_forecast c_calendar_id numeric 10
c_calendar c_calendar_uu varchar 36  √  NULL::character varying
ad_user c_campaign_id numeric 10  √  NULL::numeric
c_cashplan c_campaign_id numeric 10  √  NULL::numeric
c_cashplanline c_campaign_id numeric 10  √  NULL::numeric
c_order c_campaign_id numeric 10  √  null
c_orderline c_campaign_id numeric 10  √  null
c_order c_cashline_id numeric 10  √  null
c_cashplan c_cashplan_id numeric 10
c_cashplanline c_cashplan_id numeric 10
c_cashplan c_cashplan_uu varchar 36  √  NULL::character varying
c_cashplanline c_cashplanline_id numeric 10
c_order c_cashplanline_id numeric 10  √  NULL::numeric
c_cashplanline c_cashplanline_uu varchar 36  √  NULL::character varying
c_cashplanline c_charge_id numeric 10  √  NULL::numeric
c_charge c_charge_id numeric 10
c_order c_charge_id numeric 10  √  null
c_orderline c_charge_id numeric 10  √  null
m_requisitionline c_charge_id numeric 10  √  null
c_charge c_charge_uu varchar 36  √  NULL::character varying
c_charge c_chargetype_id numeric 10  √  null
c_order c_conversiontype_id numeric 10  √  null
c_order c_currency_id numeric 10
c_orderline c_currency_id numeric 10
m_pricelist c_currency_id numeric 10
c_doctype c_doctype_id numeric 10
c_order c_doctype_id numeric 10
m_requisition 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_order c_doctypetarget_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_user c_location_id numeric 10  √  NULL::numeric
m_warehouse c_location_id numeric 10
c_order c_opportunity_id numeric 10  √  NULL::numeric
c_order c_order_id numeric 10
c_orderline c_order_id numeric 10
c_order c_order_uu varchar 36  √  NULL::character varying
c_orderline c_orderline_id numeric 10
m_demanddetail c_orderline_id numeric 10  √  null
m_requisitionline c_orderline_id numeric 10  √  null
c_orderline c_orderline_uu varchar 36  √  NULL::character varying
c_order c_ordersource_id numeric 10  √  null
c_order c_payment_id numeric 10  √  null
c_bpartner c_paymentterm_id numeric 10  √  null
c_order c_paymentterm_id numeric 10
c_period c_period_id numeric 10
m_demandline c_period_id numeric 10
m_forecastline c_period_id numeric 10
c_period c_period_uu varchar 36  √  NULL::character varying
c_order c_pos_id numeric 10  √  null
c_cashplan c_project_id numeric 10  √  null
c_cashplanline c_project_id numeric 10  √  NULL::numeric
c_order c_project_id numeric 10  √  null
c_orderline c_project_id numeric 10  √  null
c_cashplanline c_projectphase_id numeric 10  √  NULL::numeric
c_orderline c_projectphase_id numeric 10  √  null
c_cashplanline c_projecttask_id numeric 10  √  NULL::numeric
c_orderline c_projecttask_id numeric 10  √  null
m_product c_revenuerecognition_id numeric 10  √  null
m_product c_subscriptiontype_id numeric 10  √  null
c_orderline c_tax_id numeric 10
c_charge c_taxcategory_id numeric 10  √  null
m_product c_taxcategory_id numeric 10
c_bpartner c_taxgroup_id numeric 10  √  null
c_orderline c_uom_id numeric 10
m_product c_uom_id numeric 10
m_requisitionline c_uom_id numeric 10  √  NULL::numeric
c_period c_year_id numeric 10
c_year c_year_id numeric 10
m_demand c_year_id numeric 10
m_forecast c_year_id numeric 10
c_year c_year_uu varchar 36  √  NULL::character varying
c_cashplan cashflowtype bpchar 1  √  NULL::bpchar
c_charge chargeamt numeric 0 0
c_order chargeamt numeric 0  √  0
m_product classification varchar 12  √  null
ad_user comments varchar 2000  √  null
ad_user connectionprofile bpchar 1  √  null
c_cashplan copyfrom bpchar 1  √  NULL::bpchar
c_order copyfrom bpchar 1  √  null
m_product copyfrom bpchar 1  √  NULL::bpchar
ad_user created timestamp 29,6 now()
c_bpartner created timestamp 29,6 now()
c_calendar created timestamp 29,6 now()
c_cashplan created timestamp 29,6 statement_timestamp()
c_cashplanline created timestamp 29,6 statement_timestamp()
c_charge created timestamp 29,6 now()
c_doctype created timestamp 29,6 now()
c_order created timestamp 29,6 now()
c_orderline created timestamp 29,6 now()
c_period created timestamp 29,6 now()
c_year created timestamp 29,6 now()
m_demand created timestamp 29,6 now()
m_demanddetail created timestamp 29,6 now()
m_demandline created timestamp 29,6 now()
m_forecast created timestamp 29,6 now()
m_forecastline created timestamp 29,6 now()
m_pricelist created timestamp 29,6 now()
m_product created timestamp 29,6 now()
m_requisition created timestamp 29,6 now()
m_requisitionline created timestamp 29,6 now()
m_warehouse created timestamp 29,6 now()
ad_user createdby numeric 10
c_bpartner createdby numeric 10
c_calendar createdby numeric 10
c_cashplan createdby numeric 10
c_cashplanline createdby numeric 10
c_charge createdby numeric 10
c_doctype createdby numeric 10
c_order createdby numeric 10
c_orderline createdby numeric 10
c_period createdby numeric 10
c_year createdby numeric 10
m_demand createdby numeric 10
m_demanddetail createdby numeric 10
m_demandline createdby numeric 10
m_forecast createdby numeric 10
m_forecastline createdby numeric 10
m_pricelist createdby numeric 10
m_product createdby numeric 10
m_requisition createdby numeric 10
m_requisitionline createdby numeric 10
m_warehouse createdby numeric 10
c_orderline createproduction bpchar 1  √  'N'::bpchar
c_orderline createshipment bpchar 1  √  'N'::bpchar
c_bpartner customerprofileid varchar 60  √  NULL::character varying
m_product customstariffnumber varchar 20  √  null
ad_user dateaccountlocked timestamp 29,6  √  null
c_order dateacct timestamp 29,6
c_orderline datedelivered timestamp 29,6  √  null
c_cashplan datedoc timestamp 29,6
m_requisition datedoc timestamp 29,6 now()
c_orderline dateinvoiced timestamp 29,6  √  null
ad_user datelastlogin timestamp 29,6  √  null
c_order dateordered timestamp 29,6
c_orderline dateordered timestamp 29,6
ad_user datepasswordchanged timestamp 29,6  √  null
c_order dateprinted timestamp 29,6  √  null
c_order datepromised timestamp 29,6  √  null
c_orderline datepromised timestamp 29,6  √  null
m_forecastline datepromised timestamp 29,6
m_requisition daterequired timestamp 29,6
c_cashplanline datetrx timestamp 29,6
c_bpartner default1099box_id numeric 10  √  NULL::numeric
c_doctype definitesequence_id numeric 10  √  null
c_bpartner deliveryrule bpchar 1  √  null
c_order deliveryrule bpchar 1
c_bpartner deliveryviarule bpchar 1  √  null
c_order deliveryviarule bpchar 1
ad_user description varchar 255  √  null
c_bpartner description varchar 255  √  null
c_calendar description varchar 255  √  null
c_cashplan description varchar 255  √  NULL::character varying
c_cashplanline description varchar 255  √  NULL::character varying
c_charge description varchar 255  √  null
c_doctype description varchar 255  √  null
c_order description varchar 255  √  null
c_orderline description varchar 255  √  null
c_year description varchar 255  √  null
m_demand description varchar 255  √  null
m_forecast description varchar 255  √  null
m_pricelist description varchar 255  √  null
m_product description varchar 255  √  null
m_requisition description varchar 255  √  null
m_requisitionline description varchar 255  √  null
m_warehouse 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_orderline discount numeric 0  √  null
c_order docaction bpchar 2
m_requisition docaction bpchar 2
c_doctype docbasetype bpchar 3
c_doctype docnosequence_id numeric 10  √  null
c_order docstatus bpchar 2
m_requisition docstatus bpchar 2
c_doctype docsubtypeinv varchar 2  √  NULL::character varying
c_doctype docsubtypeso bpchar 2  √  null
c_bpartner documentcopies numeric 10  √  null
c_doctype documentcopies numeric 10
c_cashplan documentno varchar 30
c_order documentno varchar 30
m_requisition documentno varchar 30
c_doctype documentnote varchar 2000  √  null
m_product documentnote varchar 2000  √  null
m_product downloadurl varchar 120  √  null
c_order dropship_bpartner_id numeric 10  √  null
c_order dropship_location_id numeric 10  √  null
c_order dropship_user_id numeric 10  √  null
c_bpartner dunninggrace timestamp 29,6  √  null
c_bpartner duns varchar 11  √  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
c_period enddate 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_year fiscalyear varchar 10
c_bpartner flatdiscount numeric 0  √  null
c_order freightamt numeric 0  √  0
c_orderline freightamt numeric 0 0
c_bpartner freightcostrule bpchar 1  √  null
c_order freightcostrule bpchar 1
c_cashplan generateperiodic bpchar 1  √  NULL::bpchar
c_doctype gl_category_id numeric 10
c_cashplan grandtotal numeric 0
c_order grandtotal numeric 0 0
m_product group1 varchar 255  √  null
m_product group2 varchar 255  √  null
m_product guaranteedays numeric 10  √  null
m_product guaranteedaysmin numeric 10  √  null
c_doctype hascharges bpchar 1 'N'::bpchar
c_doctype hasproforma bpchar 1  √  'N'::bpchar
m_demand help varchar 2000  √  null
m_forecast help varchar 2000  √  null
m_product help varchar 2000  √  null
m_requisition help varchar 2000  √  null
m_product imageurl varchar 120  √  null
c_bpartner invoice_printformat_id numeric 10  √  null
c_bpartner invoicerule bpchar 1  √  null
c_order invoicerule bpchar 1
c_bpartner is1099vendor bpchar 1 'N'::bpchar
ad_user isactive bpchar 1 'Y'::bpchar
c_bpartner isactive bpchar 1 'Y'::bpchar
c_calendar isactive bpchar 1 'Y'::bpchar
c_cashplan isactive bpchar 1 'Y'::bpchar
c_cashplanline isactive bpchar 1 'Y'::bpchar
c_charge isactive bpchar 1 'Y'::bpchar
c_doctype isactive bpchar 1 'Y'::bpchar
c_order isactive bpchar 1 'Y'::bpchar
c_orderline isactive bpchar 1 'Y'::bpchar
c_period isactive bpchar 1 'Y'::bpchar
c_year isactive bpchar 1 'Y'::bpchar
m_demand isactive bpchar 1 'Y'::bpchar
m_demanddetail isactive bpchar 1 'Y'::bpchar
m_demandline isactive bpchar 1 'Y'::bpchar
m_forecast isactive bpchar 1 'Y'::bpchar
m_forecastline isactive bpchar 1 'Y'::bpchar
m_pricelist isactive bpchar 1 'Y'::bpchar
m_product isactive bpchar 1 'Y'::bpchar
m_requisition isactive bpchar 1 'Y'::bpchar
m_requisitionline isactive bpchar 1 'Y'::bpchar
m_warehouse isactive bpchar 1 'Y'::bpchar
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar
c_cashplan isapproved bpchar 1
c_order isapproved bpchar 1 'Y'::bpchar
m_requisition isapproved bpchar 1 'Y'::bpchar
m_product isautoproduce bpchar 1 'N'::bpchar
ad_user isbillto bpchar 1 'N'::bpchar
m_product isbom bpchar 1 'N'::bpchar
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar
c_doctype iscreatecounter bpchar 1 'Y'::bpchar
c_order iscreditapproved bpchar 1 'N'::bpchar
c_bpartner iscustomer bpchar 1 'Y'::bpchar
c_doctype isdefault bpchar 1 'N'::bpchar
m_demand isdefault bpchar 1 'N'::bpchar
m_forecast isdefault bpchar 1 'N'::bpchar
m_pricelist isdefault bpchar 1 'N'::bpchar
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar
c_order isdelivered bpchar 1 'N'::bpchar
c_orderline isdescription bpchar 1 'N'::bpchar
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar
c_order isdiscountprinted bpchar 1 'Y'::bpchar
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar
c_order isdropship bpchar 1 'N'::bpchar
m_product isdropship bpchar 1 'N'::bpchar
c_bpartner isemployee 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
c_doctype isindexed bpchar 1 'Y'::bpchar
ad_user isinpayroll bpchar 1 'N'::bpchar
c_doctype isintransit bpchar 1 'N'::bpchar
m_warehouse isintransit bpchar 1  √  'N'::bpchar
c_order 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
m_pricelist ismandatory bpchar 1  √  'N'::bpchar
m_product ismanufactured bpchar 1 'N'::bpchar
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar
ad_user ismenuautoexpand bpchar 1  √  null
ad_user isnoexpire bpchar 1 'N'::bpchar
ad_user isnopasswordreset bpchar 1 'N'::bpchar
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar
c_bpartner isonetime bpchar 1 'N'::bpchar
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar
m_product isownbox bpchar 1 'N'::bpchar
c_order ispayschedulevalid bpchar 1 'N'::bpchar
m_product isphantom bpchar 1  √  'N'::bpchar
m_product ispicklistprintdetails bpchar 1 'N'::bpchar
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar
c_order isprinted bpchar 1 'N'::bpchar
c_order ispriviledgedrate 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
c_charge issamecurrency bpchar 1 'N'::bpchar
c_charge issametax bpchar 1 'N'::bpchar
c_order isselected bpchar 1 'N'::bpchar
c_order isselfservice bpchar 1 'N'::bpchar
m_product isselfservice bpchar 1 'Y'::bpchar
c_doctype isshipconfirm bpchar 1 'N'::bpchar
ad_user isshipto bpchar 1 'N'::bpchar
m_product issold bpchar 1 'Y'::bpchar
m_pricelist issopricelist bpchar 1 'Y'::bpchar
c_cashplan issotrx bpchar 1
c_doctype issotrx bpchar 1 'Y'::bpchar
c_order issotrx bpchar 1 'Y'::bpchar
c_doctype issplitwhendifference bpchar 1 'N'::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
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar
c_charge istaxincluded bpchar 1 'N'::bpchar
c_order istaxincluded bpchar 1 'N'::bpchar
m_pricelist istaxincluded bpchar 1 'N'::bpchar
m_product istoformule bpchar 1  √  null
c_order istransferred 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_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
c_cashplanline line numeric 10
c_orderline line numeric 10
m_requisitionline line numeric 10
c_orderline linenetamt numeric 0 0
m_requisitionline linenetamt numeric 0 0
c_cashplanline linetotalamt numeric 0  √  null
c_order link_order_id numeric 10  √  null
c_orderline link_orderline_id numeric 10  √  null
c_bpartner logo_id numeric 10  √  NULL::numeric
m_product lowlevel numeric 10 (0)::numeric
m_product m_attributeset_id numeric 10  √  null
c_orderline m_attributesetinstance_id numeric 10  √  0
m_product m_attributesetinstance_id numeric 10  √  0
m_requisitionline m_attributesetinstance_id numeric 0  √  null
m_demand m_demand_id numeric 10
m_demandline m_demand_id numeric 10
m_demand m_demand_uu varchar 36  √  NULL::character varying
m_demanddetail m_demanddetail_id numeric 10
m_demanddetail m_demanddetail_uu varchar 36  √  NULL::character varying
m_demanddetail m_demandline_id numeric 10
m_demandline m_demandline_id numeric 10
m_demandline m_demandline_uu varchar 36  √  NULL::character varying
c_bpartner m_discountschema_id numeric 10  √  null
m_forecast m_forecast_id numeric 10
m_forecastline m_forecast_id numeric 10
m_forecast m_forecast_uu varchar 36  √  NULL::character varying
m_demanddetail m_forecastline_id numeric 10  √  null
m_forecastline m_forecastline_id numeric 10
m_forecastline m_forecastline_uu varchar 36  √  NULL::character varying
c_order m_freightcategory_id numeric 10  √  NULL::numeric
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
c_bpartner m_pricelist_id numeric 10  √  null
c_order m_pricelist_id numeric 10
m_forecast m_pricelist_id numeric 10  √  null
m_pricelist m_pricelist_id numeric 10
m_requisition m_pricelist_id numeric 10
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying
m_product m_product_category_id numeric 10
c_cashplanline m_product_id numeric 10  √  NULL::numeric
c_orderline m_product_id numeric 10  √  null
m_demandline m_product_id numeric 10
m_forecastline m_product_id numeric 10
m_product m_product_id numeric 10
m_requisitionline m_product_id numeric 10  √  null
m_product m_product_uu varchar 36  √  NULL::character varying
c_orderline m_promotion_id numeric 10  √  null
m_requisition m_requisition_id numeric 10
m_requisitionline m_requisition_id numeric 10
m_requisition m_requisition_uu varchar 36  √  NULL::character varying
m_demanddetail m_requisitionline_id numeric 10  √  null
m_requisitionline m_requisitionline_id numeric 10
m_requisitionline m_requisitionline_uu varchar 36  √  NULL::character varying
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric
c_order m_shipper_id numeric 10  √  null
c_orderline m_shipper_id numeric 10  √  null
c_order m_warehouse_id numeric 10
c_orderline m_warehouse_id numeric 10
m_forecastline m_warehouse_id numeric 10
m_requisition m_warehouse_id numeric 10
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
c_bpartner naics varchar 6  √  null
ad_user name varchar 60
c_bpartner name varchar 120
c_calendar name varchar 60
c_cashplanline name varchar 60  √  NULL::character varying
c_charge name varchar 60
c_doctype name varchar 60
c_period name varchar 60
m_demand name varchar 60
m_forecast name varchar 60
m_pricelist name varchar 60
m_product name varchar 255
m_warehouse name varchar 60
c_bpartner name2 varchar 60  √  null
ad_user notificationtype bpchar 1 'X'::bpchar
c_bpartner numberemployees numeric 10  √  null
c_order ordertype varchar 510  √  null
ad_user password varchar 1024  √  null
c_order pay_bpartner_id numeric 10  √  null
c_order pay_location_id numeric 10  √  null
c_bpartner paymentrule bpchar 1  √  null
c_order paymentrule bpchar 1
c_bpartner paymentrulepo bpchar 1  √  null
c_period periodno numeric 10
c_period periodtype bpchar 1
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_order poreference varchar 20  √  null
c_order posted bpchar 1 'N'::bpchar
m_requisition posted bpchar 1 'N'::bpchar
c_bpartner potentiallifetimevalue numeric 0  √  0
c_orderline pp_cost_collector_id numeric 10  √  null
c_orderline priceactual numeric 0 0
m_requisitionline priceactual numeric 0 0
c_orderline pricecost numeric 0  √  null
c_orderline priceentered numeric 0
c_orderline pricelimit numeric 0 0
c_orderline pricelist numeric 0 0
m_pricelist priceprecision numeric 10 2
c_doctype printname varchar 60
c_order priorityrule bpchar 1
m_requisition priorityrule bpchar 1
c_cashplanline probability numeric 0  √  null
c_cashplan processed bpchar 1
c_cashplanline processed bpchar 1
c_order processed bpchar 1 'N'::bpchar
c_orderline processed bpchar 1 'N'::bpchar
m_requisition processed bpchar 1 'N'::bpchar
c_order processedon numeric 0  √  null
m_requisition processedon numeric 0  √  null
ad_user processing bpchar 1  √  null
c_order processing bpchar 1  √  null
c_period processing bpchar 1  √  null
c_year processing bpchar 1  √  null
m_demand processing bpchar 1  √  null
m_forecast processing bpchar 1  √  null
m_product processing bpchar 1  √  null
m_requisition processing bpchar 1  √  null
m_product producttype bpchar 1 'I'::bpchar
c_order promotioncode varchar 30  √  null
m_demandline qty numeric 0 0
m_forecastline qty numeric 0 0
m_requisitionline qty numeric 0 0
m_demandline qtycalculated numeric 0 0
m_forecastline qtycalculated numeric 0 0
c_orderline qtydelivered numeric 0 0
c_cashplanline qtyentered numeric 0 1
c_orderline qtyentered numeric 0
c_orderline qtyinvoiced numeric 0 0
c_orderline qtylostsales numeric 0 0
c_orderline qtyordered numeric 0 0
c_orderline qtyreserved numeric 0 0
c_order quotationorder_id numeric 10  √  NULL::numeric
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric
m_product r_mailtext_id numeric 10  √  null
c_bpartner rating bpchar 1  √  null
c_order ref_order_id numeric 10  √  null
c_orderline ref_orderline_id numeric 10  √  null
c_bpartner referenceno varchar 40  √  null
m_warehouse replenishmentclass varchar 60  √  null
c_orderline rramt numeric 0  √  null
c_orderline rrstartdate timestamp 29,6  √  null
m_product s_expensetype_id numeric 10  √  null
m_product s_resource_id numeric 10  √  null
c_orderline s_resourceassignment_id numeric 10  √  null
ad_user salesrep_id numeric 10  √  NULL::numeric
c_bpartner salesrep_id numeric 10  √  null
c_order salesrep_id numeric 10  √  null
m_forecastline salesrep_id numeric 10  √  null
m_product salesrep_id numeric 10  √  null
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
c_order sendemail bpchar 1 'N'::bpchar
m_warehouse separator bpchar 1
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
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar
m_product sku varchar 30  √  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_period startdate timestamp 29,6
ad_user supervisor_id numeric 10  √  null
c_bpartner taxid varchar 20  √  null
ad_user title varchar 40  √  null
c_order totallines numeric 0 0
m_requisition totallines numeric 0 0
c_bpartner totalopenbalance numeric 0  √  null
m_product unitsperpack numeric 10 1
m_product unitsperpallet numeric 0  √  null
m_product upc varchar 30  √  null
ad_user updated timestamp 29,6 now()
c_bpartner updated timestamp 29,6 now()
c_calendar updated timestamp 29,6 now()
c_cashplan updated timestamp 29,6 statement_timestamp()
c_cashplanline updated timestamp 29,6 statement_timestamp()
c_charge updated timestamp 29,6 now()
c_doctype updated timestamp 29,6 now()
c_order updated timestamp 29,6 now()
c_orderline updated timestamp 29,6 now()
c_period updated timestamp 29,6 now()
c_year updated timestamp 29,6 now()
m_demand updated timestamp 29,6 now()
m_demanddetail updated timestamp 29,6 now()
m_demandline updated timestamp 29,6 now()
m_forecast updated timestamp 29,6 now()
m_forecastline updated timestamp 29,6 now()
m_pricelist updated timestamp 29,6 now()
m_product updated timestamp 29,6 now()
m_requisition updated timestamp 29,6 now()
m_requisitionline updated timestamp 29,6 now()
m_warehouse updated timestamp 29,6 now()
ad_user updatedby numeric 10
c_bpartner updatedby numeric 10
c_calendar updatedby numeric 10
c_cashplan updatedby numeric 10
c_cashplanline updatedby numeric 10
c_charge updatedby numeric 10
c_doctype updatedby numeric 10
c_order updatedby numeric 10
c_orderline updatedby numeric 10
c_period updatedby numeric 10
c_year updatedby numeric 10
m_demand updatedby numeric 10
m_demanddetail updatedby numeric 10
m_demandline updatedby numeric 10
m_forecast updatedby numeric 10
m_forecastline updatedby numeric 10
m_pricelist updatedby numeric 10
m_product updatedby numeric 10
m_requisition updatedby numeric 10
m_requisitionline updatedby numeric 10
m_warehouse updatedby numeric 10
c_bpartner url varchar 120  √  null
c_cashplan user1_id numeric 10  √  NULL::numeric
c_cashplanline user1_id numeric 10  √  NULL::numeric
c_order user1_id numeric 10  √  null
c_orderline user1_id numeric 10  √  null
c_cashplan user2_id numeric 10  √  NULL::numeric
c_cashplanline user2_id numeric 10  √  NULL::numeric
c_order user2_id numeric 10  √  null
c_orderline user2_id numeric 10  √  null
ad_user userpin varchar 20  √  null
ad_user value varchar 40  √  null
c_bpartner value varchar 40
m_product value varchar 40
m_warehouse value varchar 40
m_product versionno varchar 20  √  null
c_order volume numeric 0  √  null
m_product volume numeric 0  √  0
c_order weight numeric 0  √  null
m_product weight numeric 0  √  0