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

idempiere9.adempiere contains 1000 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_project projinvoicerule bpchar 1 '-'::bpchar
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar
c_projectissue docaction bpchar 2 'CO'::bpchar
c_projectissue docstatus varchar 2 'DR'::character varying
m_product producttype bpchar 1 'I'::bpchar
a_asset a_asset_action varchar 2 'MD'::character varying
a_asset a_assettype varchar 3 'MFX'::character varying
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar
c_invoiceline a_processed bpchar 1  √  'N'::bpchar
c_orderline createproduction bpchar 1  √  'N'::bpchar
c_orderline createshipment bpchar 1  √  'N'::bpchar
m_product discontinued bpchar 1  √  'N'::bpchar
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar
c_paymentterm isdefault bpchar 1  √  'N'::bpchar
m_inout isdropship bpchar 1  √  'N'::bpchar
m_warehouse isintransit bpchar 1  √  'N'::bpchar
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar
s_resource ismanufacturingresource bpchar 1  √  'N'::bpchar
m_product isphantom bpchar 1  √  'N'::bpchar
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar
a_asset processing bpchar 1  √  'N'::bpchar
c_project projectcategory bpchar 1  √  'N'::bpchar
c_paymentterm afterdelivery bpchar 1 'N'::bpchar
c_bpartner is1099vendor bpchar 1 'N'::bpchar
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar
c_projectissue isapproved bpchar 1 'N'::bpchar
m_inout isapproved bpchar 1 'N'::bpchar
m_product isautoproduce bpchar 1 'N'::bpchar
m_product isbom bpchar 1 'N'::bpchar
c_project iscommitceiling bpchar 1 'N'::bpchar
c_projectphase iscommitceiling bpchar 1 'N'::bpchar
c_projectphase iscomplete bpchar 1 'N'::bpchar
c_order iscreditapproved bpchar 1 'N'::bpchar
c_order isdelivered bpchar 1 'N'::bpchar
c_invoiceline isdescription bpchar 1 'N'::bpchar
c_orderline isdescription bpchar 1 'N'::bpchar
m_inoutline isdescription bpchar 1 'N'::bpchar
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar
a_asset isdisposed bpchar 1 'N'::bpchar
c_order isdropship bpchar 1 'N'::bpchar
m_product isdropship bpchar 1 'N'::bpchar
c_paymentterm isduefixed bpchar 1 'N'::bpchar
c_bpartner isemployee bpchar 1 'N'::bpchar
m_product isexcludeautodelivery bpchar 1 'N'::bpchar
a_asset isfullydepreciated bpchar 1 'N'::bpchar
c_invoice isindispute bpchar 1 'N'::bpchar
m_inout isindispute bpchar 1 'N'::bpchar
m_inout isintransit bpchar 1 'N'::bpchar
c_order isinvoiced bpchar 1 'N'::bpchar
m_inoutline isinvoiced bpchar 1 'N'::bpchar
s_timeexpenseline isinvoiced 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
c_bpartner isonetime bpchar 1 'N'::bpchar
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar
m_product isownbox bpchar 1 'N'::bpchar
c_invoice ispaid bpchar 1 'N'::bpchar
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar
c_order ispayschedulevalid bpchar 1 'N'::bpchar
m_product ispicklistprintdetails bpchar 1 'N'::bpchar
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar
c_invoice isprinted bpchar 1 'N'::bpchar
c_order isprinted bpchar 1 'N'::bpchar
m_inout isprinted bpchar 1 'N'::bpchar
c_order ispriviledgedrate bpchar 1 'N'::bpchar
c_bpartner isprospect bpchar 1 'N'::bpchar
c_bpartner issalesrep bpchar 1 'N'::bpchar
c_order isselected bpchar 1 'N'::bpchar
c_invoice isselfservice bpchar 1 'N'::bpchar
c_order isselfservice bpchar 1 'N'::bpchar
c_activity issummary bpchar 1 'N'::bpchar
c_bpartner issummary bpchar 1 'N'::bpchar
c_project issummary bpchar 1 'N'::bpchar
m_product issummary bpchar 1 'N'::bpchar
c_invoice istaxincluded bpchar 1 'N'::bpchar
c_order istaxincluded bpchar 1 'N'::bpchar
s_timeexpenseline istimereport bpchar 1 'N'::bpchar
c_invoice istransferred bpchar 1 'N'::bpchar
c_order istransferred bpchar 1 'N'::bpchar
c_paymentterm isvalid bpchar 1 'N'::bpchar
c_bpartner isvendor bpchar 1 'N'::bpchar
m_product isverified bpchar 1 'N'::bpchar
m_product iswebstorefeatured bpchar 1 'N'::bpchar
c_invoice posted bpchar 1 'N'::bpchar
c_order posted bpchar 1 'N'::bpchar
c_projectissue posted bpchar 1 'N'::bpchar
m_inout posted bpchar 1 'N'::bpchar
a_asset processed bpchar 1 'N'::bpchar
c_invoice processed bpchar 1 'N'::bpchar
c_invoiceline processed bpchar 1 'N'::bpchar
c_order processed bpchar 1 'N'::bpchar
c_orderline processed bpchar 1 'N'::bpchar
c_project processed bpchar 1 'N'::bpchar
c_projectissue processed bpchar 1 'N'::bpchar
c_projectline processed bpchar 1 'N'::bpchar
m_inout processed bpchar 1 'N'::bpchar
m_inoutline processed bpchar 1 'N'::bpchar
s_timeexpenseline processed bpchar 1 'N'::bpchar
c_projecttype projectcategory bpchar 1 'N'::bpchar
c_bpartner sendemail bpchar 1 'N'::bpchar
c_invoice sendemail bpchar 1 'N'::bpchar
c_order sendemail bpchar 1 'N'::bpchar
m_inout sendemail bpchar 1 'N'::bpchar
a_asset a_asset_status varchar 2 'NW'::character varying
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar
c_project projectlinelevel bpchar 1 'P'::bpchar
c_projectline dopricing bpchar 1  √  'Y'::bpchar
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar
a_asset isactive bpchar 1 'Y'::bpchar
c_activity isactive bpchar 1 'Y'::bpchar
c_bpartner isactive bpchar 1 'Y'::bpchar
c_cycle isactive bpchar 1 'Y'::bpchar
c_cyclephase isactive bpchar 1 'Y'::bpchar
c_cyclestep isactive bpchar 1 'Y'::bpchar
c_invoice isactive bpchar 1 'Y'::bpchar
c_invoiceline isactive bpchar 1 'Y'::bpchar
c_order isactive bpchar 1 'Y'::bpchar
c_orderline isactive bpchar 1 'Y'::bpchar
c_paymentterm isactive bpchar 1 'Y'::bpchar
c_phase isactive bpchar 1 'Y'::bpchar
c_project isactive bpchar 1 'Y'::bpchar
c_projectissue isactive bpchar 1 'Y'::bpchar
c_projectline isactive bpchar 1 'Y'::bpchar
c_projectphase isactive bpchar 1 'Y'::bpchar
c_projecttask isactive bpchar 1 'Y'::bpchar
c_projecttype isactive bpchar 1 'Y'::bpchar
c_task isactive bpchar 1 'Y'::bpchar
m_inout isactive bpchar 1 'Y'::bpchar
m_inoutline isactive bpchar 1 'Y'::bpchar
m_pricelist_version isactive bpchar 1 'Y'::bpchar
m_product isactive bpchar 1 'Y'::bpchar
m_transaction isactive bpchar 1 'Y'::bpchar
m_warehouse isactive bpchar 1 'Y'::bpchar
s_resource isactive bpchar 1 'Y'::bpchar
s_timeexpenseline isactive bpchar 1 'Y'::bpchar
c_invoice isapproved bpchar 1 'Y'::bpchar
c_order isapproved bpchar 1 'Y'::bpchar
s_resource isavailable bpchar 1 'Y'::bpchar
c_project iscommitment bpchar 1 'Y'::bpchar
c_bpartner iscustomer bpchar 1 'Y'::bpchar
a_asset isdepreciated bpchar 1 'Y'::bpchar
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar
c_order isdiscountprinted bpchar 1 'Y'::bpchar
a_asset isinposession bpchar 1 'Y'::bpchar
a_asset isowned bpchar 1 'Y'::bpchar
c_invoiceline isprinted bpchar 1 'Y'::bpchar
c_projectline isprinted bpchar 1 'Y'::bpchar
m_product ispurchased bpchar 1 'Y'::bpchar
m_product isselfservice bpchar 1 'Y'::bpchar
m_product issold bpchar 1 'Y'::bpchar
c_invoice issotrx bpchar 1 'Y'::bpchar
c_order issotrx bpchar 1 'Y'::bpchar
m_inout issotrx bpchar 1 'Y'::bpchar
m_product isstocked bpchar 1 'Y'::bpchar
s_resource planninghorizon numeric 10  √  (0)::numeric
m_product lowlevel numeric 10 (0)::numeric
m_inout nopackages numeric 10  √  (1)::numeric
s_resource percentutilization numeric 0 (100)::numeric
c_bpartner acqusitioncost numeric 0  √  0
c_bpartner actuallifetimevalue numeric 0  √  0
s_resource chargeableqty numeric 0  √  0
c_invoice chargeamt numeric 0  √  0
c_order chargeamt numeric 0  √  0
m_inout chargeamt numeric 0  √  0
c_projectline committedamt numeric 0  √  0
c_projectline committedqty numeric 0  √  0
m_inoutline confirmedqty numeric 0  √  0
s_timeexpenseline convertedamt numeric 0  √  0
s_timeexpenseline expenseamt numeric 0  √  0
c_order freightamt numeric 0  √  0
m_inout freightamt numeric 0  √  0
s_timeexpenseline invoiceprice numeric 0  √  0
c_invoiceline linetotalamt numeric 0  √  0
a_asset m_attributesetinstance_id numeric 10  √  0
c_invoiceline m_attributesetinstance_id numeric 10  √  0
c_orderline m_attributesetinstance_id numeric 10  √  0
c_projectissue m_attributesetinstance_id numeric 10  √  0
m_inoutline m_attributesetinstance_id numeric 10  √  0
m_product m_attributesetinstance_id numeric 10  √  0
m_inoutline pickedqty numeric 0  √  0
c_bpartner potentiallifetimevalue numeric 0  √  0
c_projectphase priceactual numeric 0  √  0
c_projectphase qty numeric 0  √  0
c_projecttask qty numeric 0  √  0
s_timeexpenseline qty numeric 0  √  0
m_inoutline qtyoverreceipt numeric 0  √  0
m_inoutline scrappedqty numeric 0  √  0
c_bpartner so_creditlimit numeric 0  √  0
c_bpartner so_creditused numeric 0  √  0
m_inoutline targetqty numeric 0  √  0
c_invoiceline taxamt numeric 0  √  0
m_product volume numeric 0  √  0
m_product weight numeric 0  √  0
c_project committedamt numeric 0 0
c_projectphase committedamt numeric 0 0
c_projecttask committedamt numeric 0 0
c_project committedqty numeric 0 0
c_orderline freightamt numeric 0 0
c_invoice grandtotal numeric 0 0
c_order grandtotal numeric 0 0
c_project invoicedamt numeric 0 0
c_projectline invoicedamt numeric 0 0
c_project invoicedqty numeric 0 0
c_projectline invoicedqty numeric 0 0
c_invoiceline linenetamt numeric 0 0
c_orderline linenetamt numeric 0 0
m_transaction m_attributesetinstance_id numeric 10 0
c_projectissue movementqty numeric 0 0
m_inoutline movementqty numeric 0 0
m_transaction movementqty numeric 0 0
c_project plannedamt numeric 0 0
c_projectline plannedamt numeric 0 0
c_projectphase plannedamt numeric 0 0
c_projecttask plannedamt numeric 0 0
c_project plannedmarginamt numeric 0 0
c_projectline plannedmarginamt numeric 0 0
c_projectline plannedprice numeric 0 0
c_project plannedqty numeric 0 0
c_projectline plannedqty numeric 0 0
c_invoiceline priceactual numeric 0 0
c_orderline priceactual numeric 0 0
c_invoiceline pricelimit numeric 0 0
c_orderline pricelimit numeric 0 0
c_invoiceline pricelist numeric 0 0
c_orderline pricelist numeric 0 0
c_project projectbalanceamt numeric 0 0
c_orderline qtydelivered numeric 0 0
c_invoiceline qtyinvoiced numeric 0 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_phase standardqty numeric 0 0
c_task standardqty numeric 0 0
c_invoice totallines numeric 0 0
c_order totallines numeric 0 0
m_product unitsperpack numeric 10 1
a_asset created timestamp 29,6 now()
c_activity created timestamp 29,6 now()
c_bpartner created timestamp 29,6 now()
c_cycle created timestamp 29,6 now()
c_cyclephase created timestamp 29,6 now()
c_cyclestep created timestamp 29,6 now()
c_invoice created timestamp 29,6 now()
c_invoiceline created timestamp 29,6 now()
c_order created timestamp 29,6 now()
c_orderline created timestamp 29,6 now()
c_paymentterm created timestamp 29,6 now()
c_phase created timestamp 29,6 now()
c_project created timestamp 29,6 now()
c_projectissue created timestamp 29,6 now()
c_projectline created timestamp 29,6 now()
c_projectphase created timestamp 29,6 now()
c_projecttask created timestamp 29,6 now()
c_projecttype created timestamp 29,6 now()
c_task created timestamp 29,6 now()
m_inout created timestamp 29,6 now()
m_inoutline created timestamp 29,6 now()
m_pricelist_version created timestamp 29,6 now()
m_product created timestamp 29,6 now()
m_transaction created timestamp 29,6 now()
m_warehouse created timestamp 29,6 now()
s_resource created timestamp 29,6 now()
s_timeexpenseline created timestamp 29,6 now()
a_asset updated timestamp 29,6 now()
c_activity updated timestamp 29,6 now()
c_bpartner updated timestamp 29,6 now()
c_cycle updated timestamp 29,6 now()
c_cyclephase updated timestamp 29,6 now()
c_cyclestep updated timestamp 29,6 now()
c_invoice updated timestamp 29,6 now()
c_invoiceline updated timestamp 29,6 now()
c_order updated timestamp 29,6 now()
c_orderline updated timestamp 29,6 now()
c_paymentterm updated timestamp 29,6 now()
c_phase updated timestamp 29,6 now()
c_project updated timestamp 29,6 now()
c_projectissue updated timestamp 29,6 now()
c_projectline updated timestamp 29,6 now()
c_projectphase updated timestamp 29,6 now()
c_projecttask updated timestamp 29,6 now()
c_projecttype updated timestamp 29,6 now()
c_task updated timestamp 29,6 now()
m_inout updated timestamp 29,6 now()
m_inoutline updated timestamp 29,6 now()
m_pricelist_version updated timestamp 29,6 now()
m_product updated timestamp 29,6 now()
m_transaction updated timestamp 29,6 now()
m_warehouse updated timestamp 29,6 now()
s_resource updated timestamp 29,6 now()
s_timeexpenseline updated timestamp 29,6 now()
a_asset a_asset_createdate timestamp 29,6  √  null
c_invoiceline a_asset_group_id numeric 10  √  null
c_invoiceline a_asset_id numeric 10  √  null
a_asset a_asset_revaldate timestamp 29,6  √  null
a_asset a_asset_type_id numeric 10  √  null
c_invoiceline a_capvsexp varchar 3  √  null
a_asset a_parent_asset_id numeric 10  √  null
a_asset a_qty_current numeric 0  √  null
a_asset a_qty_original numeric 0  √  null
c_bpartner ad_language varchar 6  √  null
c_bpartner ad_orgbp_id numeric 10  √  null
c_invoice ad_orgtrx_id numeric 10  √  null
c_invoiceline ad_orgtrx_id numeric 10  √  null
c_order ad_orgtrx_id numeric 10  √  null
c_orderline ad_orgtrx_id numeric 10  √  null
m_inout ad_orgtrx_id numeric 10  √  null
m_inoutline ad_orgtrx_id numeric 10  √  null
a_asset ad_user_id numeric 10  √  null
c_invoice ad_user_id numeric 10  √  null
c_order ad_user_id numeric 10  √  null
c_project ad_user_id numeric 10  √  null
m_inout ad_user_id numeric 10  √  null
s_resource ad_user_id numeric 10  √  null
c_order amountrefunded numeric 22,2  √  null
c_order amounttendered numeric 22,2  √  null
a_asset assetactivationdate timestamp 29,6  √  null
a_asset assetdepreciationdate timestamp 29,6  √  null
a_asset assetdisposaldate timestamp 29,6  √  null
a_asset assetservicedate timestamp 29,6  √  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
c_bpartner bpartner_parent_id numeric 10  √  null
c_invoice c_activity_id numeric 10  √  null
c_invoiceline c_activity_id numeric 10  √  null
c_order c_activity_id numeric 10  √  null
c_orderline c_activity_id numeric 10  √  null
m_inout c_activity_id numeric 10  √  null
m_inoutline c_activity_id numeric 10  √  null
s_timeexpenseline c_activity_id numeric 10  √  null
a_asset c_bpartner_id numeric 10  √  null
c_orderline c_bpartner_id numeric 10  √  null
c_project c_bpartner_id numeric 10  √  null
s_timeexpenseline c_bpartner_id numeric 10  √  null
a_asset c_bpartner_location_id numeric 10  √  null
c_orderline c_bpartner_location_id numeric 10  √  null
c_project c_bpartner_location_id numeric 10  √  null
a_asset c_bpartnersr_id numeric 10  √  null
c_project c_bpartnersr_id numeric 10  √  null
c_invoice c_campaign_id numeric 10  √  null
c_invoiceline c_campaign_id numeric 10  √  null
c_order c_campaign_id numeric 10  √  null
c_orderline c_campaign_id numeric 10  √  null
c_project c_campaign_id numeric 10  √  null
m_inout c_campaign_id numeric 10  √  null
m_inoutline c_campaign_id numeric 10  √  null
s_timeexpenseline c_campaign_id numeric 10  √  null
c_invoice c_cashline_id numeric 10  √  null
c_order c_cashline_id numeric 10  √  null
c_invoice c_charge_id numeric 10  √  null
c_invoiceline c_charge_id numeric 10  √  null
c_order c_charge_id numeric 10  √  null
c_orderline c_charge_id numeric 10  √  null
m_inout c_charge_id numeric 10  √  null
m_inoutline c_charge_id numeric 10  √  null
c_invoice c_conversiontype_id numeric 10  √  null
c_order c_conversiontype_id numeric 10  √  null
s_timeexpenseline c_currency_id numeric 10  √  null
c_bpartner c_dunning_id numeric 10  √  null
c_invoice c_dunninglevel_id numeric 10  √  null
c_bpartner c_greeting_id numeric 10  √  null
m_inout c_invoice_id numeric 10  √  null
s_timeexpenseline c_invoiceline_id numeric 10  √  null
c_bpartner c_invoiceschedule_id numeric 10  √  null
a_asset c_location_id numeric 10  √  null
c_invoice c_order_id numeric 10  √  null
c_projectline c_order_id numeric 10  √  null
c_projectphase c_order_id numeric 10  √  null
m_inout c_order_id numeric 10  √  null
c_invoiceline c_orderline_id numeric 10  √  null
m_inoutline c_orderline_id numeric 10  √  null
s_timeexpenseline c_orderline_id numeric 10  √  null
c_projectline c_orderpo_id numeric 10  √  null
c_order c_ordersource_id numeric 10  √  null
c_invoice c_payment_id numeric 10  √  null
c_order c_payment_id numeric 10  √  null
c_bpartner c_paymentterm_id numeric 10  √  null
c_project c_paymentterm_id numeric 10  √  null
c_project c_phase_id numeric 10  √  null
c_projectphase c_phase_id numeric 10  √  null
c_order c_pos_id numeric 10  √  null
a_asset c_project_id numeric 10  √  null
c_invoice c_project_id numeric 10  √  null
c_invoiceline c_project_id numeric 10  √  null
c_order c_project_id numeric 10  √  null
c_orderline c_project_id numeric 10  √  null
m_inout c_project_id numeric 10  √  null
m_inoutline c_project_id numeric 10  √  null
s_timeexpenseline c_project_id numeric 10  √  null
c_projectline c_projectissue_id numeric 10  √  null
m_transaction c_projectissue_id numeric 10  √  null
c_invoiceline c_projectphase_id numeric 10  √  null
c_orderline c_projectphase_id numeric 10  √  null
c_projectline c_projectphase_id numeric 10  √  null
m_inoutline c_projectphase_id numeric 10  √  null
s_timeexpenseline c_projectphase_id numeric 10  √  null
c_invoiceline c_projecttask_id numeric 10  √  null
c_orderline c_projecttask_id numeric 10  √  null
c_projectline c_projecttask_id numeric 10  √  null
m_inoutline c_projecttask_id numeric 10  √  null
s_timeexpenseline c_projecttask_id numeric 10  √  null
c_project c_projecttype_id numeric 10  √  null
m_product c_revenuerecognition_id numeric 10  √  null
m_product c_subscriptiontype_id numeric 10  √  null
c_projecttask c_task_id numeric 10  √  null
c_invoiceline c_tax_id numeric 10  √  null
c_bpartner c_taxgroup_id numeric 10  √  null
c_invoiceline c_uom_id numeric 10  √  null
s_timeexpenseline c_uom_id numeric 10  √  null
m_product classification varchar 12  √  null
c_invoice copyfrom bpchar 1  √  null
c_order copyfrom bpchar 1  √  null
c_project copyfrom bpchar 1  √  null
m_inout createconfirm bpchar 1  √  null
c_invoice createfrom bpchar 1  √  null
m_inout createfrom bpchar 1  √  null
m_inout createpackage bpchar 1  √  null
c_invoice currencyrate numeric 0  √  null
m_product customstariffnumber varchar 20  √  null
s_resource dailycapacity numeric 0  √  null
c_project datecontract timestamp 29,6  √  null
c_orderline datedelivered timestamp 29,6  √  null
s_timeexpenseline dateexpense timestamp 29,6  √  null
c_project datefinish timestamp 29,6  √  null
c_orderline dateinvoiced timestamp 29,6  √  null
c_invoice dateordered timestamp 29,6  √  null
m_inout dateordered timestamp 29,6  √  null
c_invoice dateprinted timestamp 29,6  √  null
c_order dateprinted timestamp 29,6  √  null
m_inout dateprinted timestamp 29,6  √  null
c_order datepromised timestamp 29,6  √  null
c_orderline datepromised timestamp 29,6  √  null
m_inout datereceived timestamp 29,6  √  null
c_bpartner deliveryrule bpchar 1  √  null
c_bpartner deliveryviarule bpchar 1  √  null
a_asset description varchar 255  √  null
c_activity description varchar 255  √  null
c_bpartner description varchar 255  √  null
c_cycle description varchar 255  √  null
c_invoice description varchar 255  √  null
c_invoiceline description varchar 255  √  null
c_order description varchar 255  √  null
c_orderline description varchar 255  √  null
c_paymentterm description varchar 255  √  null
c_phase description varchar 255  √  null
c_project description varchar 255  √  null
c_projectissue description varchar 255  √  null
c_projectline description varchar 255  √  null
c_projectphase description varchar 255  √  null
c_projecttask description varchar 255  √  null
c_projecttype description varchar 255  √  null
c_task description varchar 255  √  null
m_inout description varchar 255  √  null
m_inoutline description varchar 255  √  null
m_pricelist_version description varchar 255  √  null
m_product description varchar 255  √  null
m_warehouse description varchar 255  √  null
s_resource description varchar 255  √  null
s_timeexpenseline description varchar 255  √  null
m_product descriptionurl varchar 120  √  null
m_product discontinuedat timestamp 29,6  √  null
m_product discontinuedby timestamp 29,6  √  null
c_orderline discount numeric 0  √  null
c_bpartner documentcopies numeric 10  √  null
c_paymentterm documentnote varchar 2000  √  null
m_product documentnote varchar 2000  √  null
m_product downloadurl varchar 120  √  null
c_order dropship_bpartner_id numeric 10  √  null
m_inout dropship_bpartner_id numeric 10  √  null
c_order dropship_location_id numeric 10  √  null
m_inout dropship_location_id numeric 10  √  null
c_order dropship_user_id numeric 10  √  null
m_inout dropship_user_id numeric 10  √  null
c_bpartner dunninggrace timestamp 29,6  √  null
c_invoice dunninggrace timestamp 29,6  √  null
c_bpartner duns varchar 11  √  null
c_projectphase enddate timestamp 29,6  √  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
c_projectphase generateorder bpchar 1  √  null
c_invoice generateto bpchar 1  √  null
c_project generateto bpchar 1  √  null
m_inout generateto bpchar 1  √  null
m_product group1 varchar 255  √  null
m_product group2 varchar 255  √  null
a_asset guaranteedate timestamp 29,6  √  null
m_product guaranteedays numeric 10  √  null
m_product guaranteedaysmin numeric 10  √  null
a_asset help varchar 2000  √  null
c_activity help varchar 2000  √  null
c_phase help varchar 2000  √  null
c_projectphase help varchar 2000  √  null
c_projecttask help varchar 2000  √  null
c_projecttype help varchar 2000  √  null
c_task help varchar 2000  √  null
m_product help varchar 2000  √  null
m_product imageurl varchar 120  √  null
c_bpartner invoice_printformat_id numeric 10  √  null
c_invoice invoicecollectiontype bpchar 1  √  null
c_bpartner invoicerule bpchar 1  √  null
c_invoice isfixedassetinvoice bpchar 1  √  null
c_invoiceline isfixedassetinvoice bpchar 1  √  null
m_product istoformule bpchar 1  √  null
a_asset lastmaintenancedate timestamp 29,6  √  null
a_asset lastmaintenancenote varchar 60  √  null
a_asset lastmaintenanceunit numeric 10  √  null
a_asset lastmaintenanceuseunit numeric 10  √  null
a_asset lastmaintenencedate timestamp 29,6  √  null
a_asset lease_bpartner_id numeric 10  √  null
a_asset leaseterminationdate timestamp 29,6  √  null
a_asset lifeuseunits numeric 0  √  null
c_order link_order_id numeric 10  √  null
c_orderline link_orderline_id numeric 10  √  null
a_asset locationcomment varchar 255  √  null
a_asset lot varchar 255  √  null
m_product m_attributeset_id numeric 10  √  null
c_bpartner m_discountschema_id numeric 10  √  null
m_product m_freightcategory_id numeric 10  √  null
a_asset m_inoutline_id numeric 10  √  null
c_invoiceline m_inoutline_id numeric 10  √  null
c_projectissue m_inoutline_id numeric 10  √  null
m_transaction m_inoutline_id numeric 10  √  null
m_transaction m_inventoryline_id numeric 10  √  null
a_asset m_locator_id numeric 10  √  null
m_inoutline m_locator_id numeric 10  √  null
m_product m_locator_id numeric 10  √  null
m_transaction m_movementline_id numeric 10  √  null
c_bpartner m_pricelist_id numeric 10  √  null
m_pricelist_version m_pricelist_version_base_id numeric 10  √  null
c_project m_pricelist_version_id numeric 10  √  null
c_projectline m_product_category_id numeric 10  √  null
c_invoiceline m_product_id numeric 10  √  null
c_orderline m_product_id numeric 10  √  null
c_phase m_product_id numeric 10  √  null
c_projectline m_product_id numeric 10  √  null
c_projectphase m_product_id numeric 10  √  null
c_projecttask m_product_id numeric 10  √  null
c_task m_product_id numeric 10  √  null
m_inoutline m_product_id numeric 10  √  null
s_timeexpenseline m_product_id numeric 10  √  null
m_transaction m_productionline_id numeric 10  √  null
c_orderline m_promotion_id numeric 10  √  null
c_invoice m_rma_id numeric 10  √  null
m_inout m_rma_id numeric 10  √  null
c_invoiceline m_rmaline_id numeric 10  √  null
m_inoutline m_rmaline_id numeric 10  √  null
c_order m_shipper_id numeric 10  √  null
c_orderline m_shipper_id numeric 10  √  null
m_inout m_shipper_id numeric 10  √  null
c_project m_warehouse_id numeric 10  √  null
m_warehouse m_warehousesource_id numeric 10  √  null
s_resource manufacturingresourcetype bpchar 2  √  null
c_bpartner naics varchar 6  √  null
c_bpartner name2 varchar 60  √  null
c_paymentterm netday bpchar 1  √  null
a_asset nextmaintenanceuseunit numeric 10  √  null
a_asset nextmaintenencedate timestamp 29,6  √  null
a_asset nextmaintenenceunit numeric 10  √  null
c_project note varchar 2000  √  null
s_timeexpenseline note varchar 255  √  null
c_bpartner numberemployees numeric 10  √  null
c_order ordertype varchar 510  √  null
c_order pay_bpartner_id numeric 10  √  null
c_order pay_location_id numeric 10  √  null
c_bpartner paymentrule bpchar 1  √  null
c_bpartner paymentrulepo bpchar 1  √  null
m_inout pickdate timestamp 29,6  √  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_invoice poreference varchar 20  √  null
c_order poreference varchar 20  √  null
c_project poreference varchar 20  √  null
m_inout poreference varchar 20  √  null
c_orderline pp_cost_collector_id numeric 10  √  null
m_transaction pp_cost_collector_id numeric 10  √  null
c_orderline pricecost numeric 0  √  null
s_timeexpenseline priceinvoiced numeric 0  √  null
s_timeexpenseline pricereimbursed numeric 0  √  null
m_pricelist_version proccreate bpchar 1  √  null
c_invoice processedon numeric 0  √  null
c_order processedon numeric 0  √  null
c_projectissue processedon numeric 0  √  null
m_inout processedon numeric 0  √  null
c_invoice processing bpchar 1  √  null
c_order processing bpchar 1  √  null
c_paymentterm processing bpchar 1  √  null
c_project processing bpchar 1  √  null
c_projectissue processing bpchar 1  √  null
m_inout processing bpchar 1  √  null
m_product processing bpchar 1  √  null
c_projectphase projinvoicerule bpchar 1  √  null
c_projecttask projinvoicerule bpchar 1  √  null
c_order promotioncode varchar 30  √  null
a_asset qty numeric 0  √  null
s_timeexpenseline qtyinvoiced numeric 0  √  null
s_timeexpenseline qtyreimbursed numeric 0  √  null
s_resource queuingtime numeric 0  √  null
m_product r_mailtext_id numeric 10  √  null
c_bpartner rating bpchar 1  √  null
m_inout ref_inout_id numeric 10  √  null
m_inoutline ref_inoutline_id numeric 10  √  null
c_invoice ref_invoice_id numeric 10  √  null
c_invoiceline ref_invoiceline_id numeric 10  √  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_invoice reversal_id numeric 10  √  null
c_projectissue reversal_id numeric 10  √  null
m_inout reversal_id numeric 10  √  null
m_inoutline reversalline_id numeric 10  √  null
c_invoiceline rramt numeric 0  √  null
c_orderline rramt numeric 0  √  null
c_invoiceline rrstartdate timestamp 29,6  √  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_invoiceline s_resourceassignment_id numeric 10  √  null
c_orderline s_resourceassignment_id numeric 10  √  null
s_timeexpenseline s_resourceassignment_id numeric 10  √  null
c_projectissue s_timeexpenseline_id numeric 10  √  null
s_timeexpenseline s_timetype_id numeric 10  √  null
c_bpartner salesrep_id numeric 10  √  null
c_invoice salesrep_id numeric 10  √  null
c_order salesrep_id numeric 10  √  null
c_project salesrep_id numeric 10  √  null
m_inout salesrep_id numeric 10  √  null
m_product salesrep_id numeric 10  √  null
c_bpartner salesvolume numeric 10  √  null
a_asset serno varchar 255  √  null
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_inout shipdate timestamp 29,6  √  null
m_product sku varchar 30  √  null
c_bpartner so_description varchar 255  √  null
c_projectphase startdate timestamp 29,6  √  null
c_bpartner taxid varchar 20  √  null
c_bpartner totalopenbalance numeric 0  √  null
m_inout trackingno varchar 60  √  null
m_product unitsperpallet numeric 0  √  null
m_product upc varchar 30  √  null
c_bpartner url varchar 120  √  null
a_asset uselifemonths numeric 10  √  null
a_asset uselifeyears numeric 10  √  null
c_invoice user1_id numeric 10  √  null
c_invoiceline user1_id numeric 10  √  null
c_order user1_id numeric 10  √  null
c_orderline user1_id numeric 10  √  null
m_inout user1_id numeric 10  √  null
m_inoutline user1_id numeric 10  √  null
c_invoice user2_id numeric 10  √  null
c_invoiceline user2_id numeric 10  √  null
c_order user2_id numeric 10  √  null
c_orderline user2_id numeric 10  √  null
m_inout user2_id numeric 10  √  null
m_inoutline user2_id numeric 10  √  null
a_asset useunits numeric 0  √  null
a_asset versionno varchar 20  √  null
m_product versionno varchar 20  √  null
c_order volume numeric 0  √  null
m_inout volume numeric 0  √  null
s_resource waitingtime numeric 0  √  null
c_order weight numeric 0  √  null
m_inout weight numeric 0  √  null
a_asset a_asset_group_id numeric 10
a_asset a_asset_id numeric 10
a_asset ad_client_id numeric 10
c_activity ad_client_id numeric 10
c_bpartner ad_client_id numeric 10
c_cycle ad_client_id numeric 10
c_cyclephase ad_client_id numeric 10
c_cyclestep ad_client_id numeric 10
c_invoice ad_client_id numeric 10
c_invoiceline ad_client_id numeric 10
c_order ad_client_id numeric 10
c_orderline ad_client_id numeric 10
c_paymentterm ad_client_id numeric 10
c_phase ad_client_id numeric 10
c_project ad_client_id numeric 10
c_projectissue ad_client_id numeric 10
c_projectline ad_client_id numeric 10
c_projectphase ad_client_id numeric 10
c_projecttask ad_client_id numeric 10
c_projecttype ad_client_id numeric 10
c_task ad_client_id numeric 10
m_inout ad_client_id numeric 10
m_inoutline ad_client_id numeric 10
m_pricelist_version ad_client_id numeric 10
m_product ad_client_id numeric 10
m_transaction ad_client_id numeric 10
m_warehouse ad_client_id numeric 10
s_resource ad_client_id numeric 10
s_timeexpenseline ad_client_id numeric 10
a_asset ad_org_id numeric 10
c_activity ad_org_id numeric 10
c_bpartner ad_org_id numeric 10
c_cycle ad_org_id numeric 10
c_cyclephase ad_org_id numeric 10
c_cyclestep ad_org_id numeric 10
c_invoice ad_org_id numeric 10
c_invoiceline ad_org_id numeric 10
c_order ad_org_id numeric 10
c_orderline ad_org_id numeric 10
c_paymentterm ad_org_id numeric 10
c_phase ad_org_id numeric 10
c_project ad_org_id numeric 10
c_projectissue ad_org_id numeric 10
c_projectline ad_org_id numeric 10
c_projectphase ad_org_id numeric 10
c_projecttask ad_org_id numeric 10
c_projecttype ad_org_id numeric 10
c_task ad_org_id numeric 10
m_inout ad_org_id numeric 10
m_inoutline ad_org_id numeric 10
m_pricelist_version ad_org_id numeric 10
m_product ad_org_id numeric 10
m_transaction ad_org_id numeric 10
m_warehouse ad_org_id numeric 10
s_resource ad_org_id numeric 10
s_timeexpenseline ad_org_id numeric 10
c_activity c_activity_id numeric 10
c_bpartner c_bp_group_id numeric 10
c_bpartner c_bpartner_id numeric 10
c_invoice c_bpartner_id numeric 10
c_order c_bpartner_id numeric 10
m_inout c_bpartner_id numeric 10
c_invoice c_bpartner_location_id numeric 10
c_order c_bpartner_location_id numeric 10
m_inout c_bpartner_location_id numeric 10
c_cycle c_currency_id numeric 10
c_invoice c_currency_id numeric 10
c_order c_currency_id numeric 10
c_orderline c_currency_id numeric 10
c_project c_currency_id numeric 10
c_cycle c_cycle_id numeric 10
c_cyclestep c_cycle_id numeric 10
c_cyclephase c_cyclestep_id numeric 10
c_cyclestep c_cyclestep_id numeric 10
c_invoice c_doctype_id numeric 10
c_order c_doctype_id numeric 10
m_inout c_doctype_id numeric 10
c_invoice c_doctypetarget_id numeric 10
c_order c_doctypetarget_id numeric 10
c_invoice c_invoice_id numeric 10
c_invoiceline c_invoice_id numeric 10
c_invoiceline c_invoiceline_id numeric 10
m_warehouse c_location_id numeric 10
c_order c_order_id numeric 10
c_orderline c_order_id numeric 10
c_orderline c_orderline_id numeric 10
c_invoice c_paymentterm_id numeric 10
c_order c_paymentterm_id numeric 10
c_paymentterm c_paymentterm_id numeric 10
c_cyclephase c_phase_id numeric 10
c_phase c_phase_id numeric 10
c_task c_phase_id numeric 10
c_project c_project_id numeric 10
c_projectissue c_project_id numeric 10
c_projectline c_project_id numeric 10
c_projectphase c_project_id numeric 10
c_projectissue c_projectissue_id numeric 10
c_projectline c_projectline_id numeric 10
c_projectphase c_projectphase_id numeric 10
c_projecttask c_projectphase_id numeric 10
c_projecttask c_projecttask_id numeric 10
c_phase c_projecttype_id numeric 10
c_projecttype c_projecttype_id numeric 10
c_task c_task_id numeric 10
c_orderline c_tax_id numeric 10
m_product c_taxcategory_id numeric 10
c_orderline c_uom_id numeric 10
m_inoutline c_uom_id numeric 10
m_product c_uom_id numeric 10
a_asset createdby numeric 10
c_activity createdby numeric 10
c_bpartner createdby numeric 10
c_cycle createdby numeric 10
c_cyclephase createdby numeric 10
c_cyclestep createdby numeric 10
c_invoice createdby numeric 10
c_invoiceline createdby numeric 10
c_order createdby numeric 10
c_orderline createdby numeric 10
c_paymentterm createdby numeric 10
c_phase createdby numeric 10
c_project createdby numeric 10
c_projectissue createdby numeric 10
c_projectline createdby numeric 10
c_projectphase createdby numeric 10
c_projecttask createdby numeric 10
c_projecttype createdby numeric 10
c_task createdby numeric 10
m_inout createdby numeric 10
m_inoutline createdby numeric 10
m_pricelist_version createdby numeric 10
m_product createdby numeric 10
m_transaction createdby numeric 10
m_warehouse createdby numeric 10
s_resource createdby numeric 10
s_timeexpenseline createdby numeric 10
c_invoice dateacct timestamp 29,6
c_order dateacct timestamp 29,6
m_inout dateacct timestamp 29,6
c_invoice dateinvoiced timestamp 29,6
c_order dateordered timestamp 29,6
c_orderline dateordered timestamp 29,6
c_order deliveryrule bpchar 1
m_inout deliveryrule bpchar 1
c_order deliveryviarule bpchar 1
m_inout deliveryviarule bpchar 1
c_paymentterm discount numeric 0
c_paymentterm discount2 numeric 0
c_paymentterm discountdays numeric 10
c_paymentterm discountdays2 numeric 10
c_invoice docaction bpchar 2
c_order docaction bpchar 2
m_inout docaction bpchar 2
c_invoice docstatus bpchar 2
c_order docstatus bpchar 2
m_inout docstatus bpchar 2
c_invoice documentno varchar 30
c_order documentno varchar 30
m_inout documentno varchar 30
c_order freightcostrule bpchar 1
m_inout freightcostrule bpchar 1
c_paymentterm gracedays numeric 10
c_order invoicerule bpchar 1
c_invoiceline line numeric 10
c_orderline line numeric 10
c_projectissue line numeric 10
c_projectline line numeric 10
m_inoutline line numeric 10
s_timeexpenseline line numeric 10
m_pricelist_version m_discountschema_id numeric 10
m_inout m_inout_id numeric 10
m_inoutline m_inout_id numeric 10
m_inoutline m_inoutline_id numeric 10
c_projectissue m_locator_id numeric 10
m_transaction m_locator_id numeric 10
c_invoice m_pricelist_id numeric 10
c_order m_pricelist_id numeric 10
m_pricelist_version m_pricelist_id numeric 10
m_pricelist_version m_pricelist_version_id numeric 10
m_product m_product_category_id numeric 10
a_asset m_product_id numeric 10
c_projectissue m_product_id numeric 10
m_product m_product_id numeric 10
m_transaction m_product_id numeric 10
m_transaction m_transaction_id numeric 10
c_order m_warehouse_id numeric 10
c_orderline m_warehouse_id numeric 10
m_inout m_warehouse_id numeric 10
m_warehouse m_warehouse_id numeric 10
s_resource m_warehouse_id numeric 10
c_projectissue movementdate timestamp 29,6
m_inout movementdate timestamp 29,6
m_transaction movementdate timestamp 29,6
m_inout movementtype bpchar 2
m_transaction movementtype bpchar 2
a_asset name varchar 60
c_activity name varchar 60
c_bpartner name varchar 120
c_cycle name varchar 60
c_cyclestep name varchar 60
c_paymentterm name varchar 60
c_phase name varchar 60
c_project name varchar 60
c_projectphase name varchar 60
c_projecttask name varchar 60
c_projecttype name varchar 60
c_task name varchar 60
m_pricelist_version name varchar 60
m_product name varchar 255
m_warehouse name varchar 60
s_resource name varchar 60
c_paymentterm netdays numeric 10
c_invoice paymentrule bpchar 1
c_order paymentrule bpchar 1
c_invoiceline priceentered numeric 0
c_orderline priceentered numeric 0
c_order priorityrule bpchar 1
m_inout priorityrule bpchar 1
c_invoiceline qtyentered numeric 0
c_orderline qtyentered numeric 0
m_inoutline qtyentered numeric 0
c_cyclestep relativeweight numeric 0
s_resource s_resource_id numeric 10
s_resource s_resourcetype_id numeric 10
s_timeexpenseline s_timeexpense_id numeric 10
s_timeexpenseline s_timeexpenseline_id numeric 10
m_warehouse separator bpchar 1
c_cyclestep seqno numeric 10
c_phase seqno numeric 10
c_projectphase seqno numeric 10
c_projecttask seqno numeric 10
c_task seqno numeric 10
a_asset updatedby numeric 10
c_activity updatedby numeric 10
c_bpartner updatedby numeric 10
c_cycle updatedby numeric 10
c_cyclephase updatedby numeric 10
c_cyclestep updatedby numeric 10
c_invoice updatedby numeric 10
c_invoiceline updatedby numeric 10
c_order updatedby numeric 10
c_orderline updatedby numeric 10
c_paymentterm updatedby numeric 10
c_phase updatedby numeric 10
c_project updatedby numeric 10
c_projectissue updatedby numeric 10
c_projectline updatedby numeric 10
c_projectphase updatedby numeric 10
c_projecttask updatedby numeric 10
c_projecttype updatedby numeric 10
c_task updatedby numeric 10
m_inout updatedby numeric 10
m_inoutline updatedby numeric 10
m_pricelist_version updatedby numeric 10
m_product updatedby numeric 10
m_transaction updatedby numeric 10
m_warehouse updatedby numeric 10
s_resource updatedby numeric 10
s_timeexpenseline updatedby numeric 10
m_pricelist_version validfrom timestamp 29,6
a_asset value varchar 40
c_activity value varchar 40
c_bpartner value varchar 40
c_paymentterm value varchar 40
c_project value varchar 40
m_product value varchar 40
m_warehouse value varchar 40
s_resource value varchar 40
m_product copyfrom bpchar 1  √  NULL::bpchar
m_inout insurance bpchar 1  √  NULL::bpchar
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar
a_asset a_asset_uu varchar 36  √  NULL::character varying
c_activity c_activity_uu varchar 36  √  NULL::character varying
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying
c_cycle c_cycle_uu varchar 36  √  NULL::character varying
c_cyclephase c_cyclephase_uu varchar 36  √  NULL::character varying
c_cyclestep c_cyclestep_uu varchar 36  √  NULL::character varying
c_invoice c_invoice_uu varchar 36  √  NULL::character varying
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying
c_order c_order_uu varchar 36  √  NULL::character varying
c_orderline c_orderline_uu varchar 36  √  NULL::character varying
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying
c_phase c_phase_uu varchar 36  √  NULL::character varying
c_project c_project_uu varchar 36  √  NULL::character varying
c_projectissue c_projectissue_uu varchar 36  √  NULL::character varying
c_projectline c_projectline_uu varchar 36  √  NULL::character varying
c_projectphase c_projectphase_uu varchar 36  √  NULL::character varying
c_projecttask c_projecttask_uu varchar 36  √  NULL::character varying
c_projecttype c_projecttype_uu varchar 36  √  NULL::character varying
c_task c_task_uu varchar 36  √  NULL::character varying
c_bpartner customerprofileid varchar 60  √  NULL::character varying
m_inout fob varchar 10  √  NULL::character varying
m_inout freightcharges varchar 10  √  NULL::character varying
a_asset inventoryno varchar 30  √  NULL::character varying
m_inout m_inout_uu varchar 36  √  NULL::character varying
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying
m_pricelist_version m_pricelist_version_uu varchar 36  √  NULL::character varying
m_product m_product_uu varchar 36  √  NULL::character varying
m_transaction m_transaction_uu varchar 36  √  NULL::character varying
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying
a_asset manufacturer varchar 30  √  NULL::character varying
s_resource s_resource_uu varchar 36  √  NULL::character varying
s_timeexpenseline s_timeexpenseline_uu varchar 36  √  NULL::character varying
m_inout shipperaccount varchar 40  √  NULL::character varying
a_asset a_asset_class_id numeric 10  √  NULL::numeric
c_project ad_orgtrx_id numeric 10  √  NULL::numeric
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric
a_asset c_activity_id numeric 10  √  NULL::numeric
c_project c_activity_id numeric 10  √  NULL::numeric
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric
c_order c_cashplanline_id numeric 10  √  NULL::numeric
c_order c_opportunity_id numeric 10  √  NULL::numeric
c_bpartner default1099box_id numeric 10  √  NULL::numeric
c_bpartner logo_id numeric 10  √  NULL::numeric
c_order m_freightcategory_id numeric 10  √  NULL::numeric
m_product m_parttype_id numeric 10  √  NULL::numeric
c_projectline m_production_id numeric 10  √  NULL::numeric
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric
a_asset manufacturedyear numeric 10  √  NULL::numeric
c_order quotationorder_id numeric 10  √  NULL::numeric
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric
m_inout returnbpartner_id numeric 10  √  NULL::numeric
m_inout returnlocation_id numeric 10  √  NULL::numeric
m_inout returnuser_id numeric 10  √  NULL::numeric