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

idempiere11.adempiere contains 1206 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_invoiceline a_asset_group_id numeric 10  √  null
m_product_category a_asset_group_id numeric 10  √  null
c_invoiceline a_asset_id numeric 10  √  null
c_invoiceline a_capvsexp varchar 3  √  null
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar
c_invoiceline a_processed bpchar 1  √  'N'::bpchar
c_acctschema ad_client_id numeric 10
c_allocationline ad_client_id numeric 10
c_invoice ad_client_id numeric 10
c_invoiceline ad_client_id numeric 10
c_landedcost ad_client_id numeric 10
c_landedcostallocation ad_client_id numeric 10
c_order ad_client_id numeric 10
c_orderlandedcost ad_client_id numeric 10
c_orderlandedcostallocation ad_client_id numeric 10
c_orderline ad_client_id numeric 10
c_projectissue ad_client_id numeric 10
c_projectissuema ad_client_id numeric 10
m_attributesetinstance ad_client_id numeric 10
m_cost ad_client_id numeric 10
m_costdetail ad_client_id numeric 10
m_costelement ad_client_id numeric 10
m_costhistory ad_client_id numeric 10
m_costmovement_v ad_client_id numeric 10  √  null
m_costqueue ad_client_id numeric 10
m_costtype ad_client_id numeric 10
m_inout ad_client_id numeric 10
m_inoutline ad_client_id numeric 10
m_inoutlinema ad_client_id numeric 10
m_inventoryline ad_client_id numeric 10
m_inventorylinema ad_client_id numeric 10
m_locator ad_client_id numeric 10
m_matchinv ad_client_id numeric 10
m_matchpo ad_client_id numeric 10
m_movementline ad_client_id numeric 10
m_movementlinema ad_client_id numeric 10
m_product ad_client_id numeric 10
m_product_acct ad_client_id numeric 10
m_product_category ad_client_id numeric 10
m_product_category_acct ad_client_id numeric 10
m_product_po ad_client_id numeric 10
m_productionline ad_client_id numeric 10
m_productionlinema ad_client_id numeric 10
m_transaction ad_client_id numeric 10
m_warehouse ad_client_id numeric 10
m_warehouse_acct ad_client_id numeric 10
s_resource ad_client_id numeric 10
t_inventoryvalue ad_client_id numeric 10  √  null
c_acctschema ad_org_id numeric 10
c_allocationline ad_org_id numeric 10
c_invoice ad_org_id numeric 10
c_invoiceline ad_org_id numeric 10
c_landedcost ad_org_id numeric 10
c_landedcostallocation ad_org_id numeric 10
c_order ad_org_id numeric 10
c_orderlandedcost ad_org_id numeric 10
c_orderlandedcostallocation ad_org_id numeric 10
c_orderline ad_org_id numeric 10
c_projectissue ad_org_id numeric 10
c_projectissuema ad_org_id numeric 10
m_attributesetinstance ad_org_id numeric 10
m_cost ad_org_id numeric 10
m_costdetail ad_org_id numeric 10
m_costelement ad_org_id numeric 10
m_costhistory ad_org_id numeric 10
m_costmovement_v ad_org_id numeric 10  √  null
m_costqueue ad_org_id numeric 10
m_costtype ad_org_id numeric 10
m_inout ad_org_id numeric 10
m_inoutline ad_org_id numeric 10
m_inoutlinema ad_org_id numeric 10
m_inventoryline ad_org_id numeric 10
m_inventorylinema ad_org_id numeric 10
m_locator ad_org_id numeric 10
m_matchinv ad_org_id numeric 10
m_matchpo ad_org_id numeric 10
m_movementline ad_org_id numeric 10
m_movementlinema ad_org_id numeric 10
m_product ad_org_id numeric 10
m_product_acct ad_org_id numeric 10
m_product_category ad_org_id numeric 10
m_product_category_acct ad_org_id numeric 10
m_product_po ad_org_id numeric 10
m_productionline ad_org_id numeric 10
m_productionlinema ad_org_id numeric 10
m_transaction ad_org_id numeric 10
m_warehouse ad_org_id numeric 10
m_warehouse_acct ad_org_id numeric 10
s_resource ad_org_id numeric 10
t_inventoryvalue ad_org_id numeric 10  √  null
c_acctschema ad_orgonly_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
t_inventoryvalue ad_pinstance_id numeric 10
m_product_category ad_printcolor_id numeric 10  √  null
c_invoice ad_user_id numeric 10  √  null
c_order ad_user_id numeric 10  √  null
m_inout ad_user_id numeric 10  √  null
s_resource ad_user_id numeric 10  √  null
c_allocationline allocationno numeric 10  √  null
c_allocationline amount numeric 0 0
c_order amountrefunded numeric 22,2  √  null
c_order amounttendered numeric 22,2  √  null
c_landedcostallocation amt numeric 0 0
c_orderlandedcost amt numeric 0 (0)::numeric
c_orderlandedcostallocation amt numeric 0
m_costdetail amt numeric 0 0
m_costmovement_v amt numeric 0  √  null
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar
c_landedcostallocation base numeric 0 0
c_orderlandedcostallocation base numeric 0
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_invoiceline c_1099box_id numeric 10  √  NULL::numeric
c_acctschema c_acctschema_id numeric 10
m_cost c_acctschema_id numeric 10
m_costdetail c_acctschema_id numeric 10
m_costmovement_v c_acctschema_id numeric 10  √  null
m_costqueue c_acctschema_id numeric 10
m_product_acct c_acctschema_id numeric 10
m_product_category_acct c_acctschema_id numeric 10
m_warehouse_acct c_acctschema_id numeric 10
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying
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
c_allocationline c_allocationhdr_id numeric 10
c_allocationline c_allocationline_id numeric 10
c_allocationline c_allocationline_uu varchar 36  √  NULL::character varying
c_allocationline c_banktransfer_id numeric 10  √  NULL::numeric
c_allocationline c_bpartner_id numeric 10  √  null
c_invoice c_bpartner_id numeric 10
c_order c_bpartner_id numeric 10
c_orderline c_bpartner_id numeric 10  √  null
m_inout c_bpartner_id numeric 10
m_product_po c_bpartner_id numeric 10
c_invoice c_bpartner_location_id numeric 10
c_order c_bpartner_location_id numeric 10
c_orderline c_bpartner_location_id numeric 10  √  null
m_inout c_bpartner_location_id numeric 10
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
m_inout c_campaign_id numeric 10  √  null
m_inoutline c_campaign_id numeric 10  √  null
c_allocationline c_cashline_id numeric 10  √  null
c_invoice c_cashline_id numeric 10  √  null
c_order c_cashline_id numeric 10  √  null
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric
c_order c_cashplanline_id numeric 10  √  NULL::numeric
c_allocationline c_charge_id numeric 10  √  NULL::numeric
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
m_inventoryline c_charge_id numeric 10  √  null
c_invoice c_conversiontype_id numeric 10  √  null
c_order c_conversiontype_id numeric 10  √  null
c_acctschema 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
m_product_po c_currency_id numeric 10  √  null
t_inventoryvalue c_currency_id numeric 10  √  null
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_dunninglevel_id numeric 10  √  null
c_allocationline c_invoice_id numeric 10  √  null
c_invoice c_invoice_id numeric 10
c_invoiceline c_invoice_id numeric 10
m_inout c_invoice_id numeric 10  √  null
c_invoice c_invoice_uu varchar 36  √  NULL::character varying
c_invoiceline c_invoiceline_id numeric 10
c_landedcost c_invoiceline_id numeric 10
c_landedcostallocation c_invoiceline_id numeric 10
m_costdetail c_invoiceline_id numeric 10  √  null
m_costmovement_v c_invoiceline_id numeric 10  √  null
m_matchinv c_invoiceline_id numeric 10
m_matchpo c_invoiceline_id numeric 10  √  null
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying
c_landedcost c_landedcost_id numeric 10
c_landedcost c_landedcost_uu varchar 36  √  NULL::character varying
c_landedcostallocation c_landedcostallocation_id numeric 10
c_landedcostallocation c_landedcostallocation_uu varchar 36  √  NULL::character varying
m_warehouse c_location_id numeric 10
c_order c_opportunity_id numeric 10  √  NULL::numeric
c_allocationline c_order_id numeric 10  √  null
c_invoice c_order_id numeric 10  √  null
c_order c_order_id numeric 10
c_orderlandedcost c_order_id numeric 10
c_orderline c_order_id numeric 10
m_inout c_order_id numeric 10  √  null
c_order c_order_uu varchar 36  √  NULL::character varying
c_orderlandedcost c_orderlandedcost_id numeric 10
c_orderlandedcostallocation c_orderlandedcost_id numeric 10
c_orderlandedcost c_orderlandedcost_uu varchar 36  √  NULL::character varying
c_orderlandedcostallocation c_orderlandedcostallocation_id numeric 10
c_orderlandedcostallocation c_orderlandedcostallocation_uu varchar 36  √  NULL::character varying
c_invoiceline c_orderline_id numeric 10  √  null
c_orderlandedcostallocation c_orderline_id numeric 10
c_orderline c_orderline_id numeric 10
m_costdetail c_orderline_id numeric 10  √  null
m_costmovement_v c_orderline_id numeric 10  √  null
m_inoutline c_orderline_id numeric 10  √  null
m_matchpo c_orderline_id numeric 10
c_orderline c_orderline_uu varchar 36  √  NULL::character varying
c_order c_ordersource_id numeric 10  √  null
c_allocationline c_payment_id numeric 10  √  null
c_invoice c_payment_id numeric 10  √  null
c_order c_payment_id numeric 10  √  null
c_invoice c_paymentterm_id numeric 10
c_order c_paymentterm_id numeric 10
c_acctschema c_period_id numeric 10  √  null
c_order c_pos_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
c_projectissue c_project_id numeric 10
m_inout c_project_id numeric 10  √  null
m_inoutline c_project_id numeric 10  √  null
c_projectissue c_projectissue_id numeric 10
c_projectissuema c_projectissue_id numeric 10
m_costdetail c_projectissue_id numeric 10  √  null
m_costmovement_v c_projectissue_id numeric 10  √  null
m_transaction c_projectissue_id numeric 10  √  null
c_projectissue c_projectissue_uu varchar 36  √  NULL::character varying
c_projectissuema c_projectissuema_uu varchar 36  √  NULL::character varying
c_invoiceline c_projectphase_id numeric 10  √  null
c_orderline c_projectphase_id numeric 10  √  null
m_inoutline c_projectphase_id numeric 10  √  null
c_invoiceline c_projecttask_id numeric 10  √  null
c_orderline c_projecttask_id numeric 10  √  null
m_inoutline c_projecttask_id numeric 10  √  null
m_product c_revenuerecognition_id numeric 10  √  null
m_product c_subscriptiontype_id numeric 10  √  null
c_invoiceline c_tax_id numeric 10  √  null
c_orderline c_tax_id numeric 10
m_product c_taxcategory_id numeric 10
c_invoiceline c_uom_id numeric 10  √  null
c_orderline c_uom_id numeric 10
m_inoutline c_uom_id numeric 10
m_product c_uom_id numeric 10
m_product_po c_uom_id numeric 10  √  null
s_resource chargeableqty numeric 0  √  0
c_invoice chargeamt numeric 0  √  0
c_order chargeamt numeric 0  √  0
m_inout chargeamt numeric 0  √  0
m_product classification varchar 12  √  null
c_acctschema commitmenttype bpchar 1 'N'::bpchar
m_inoutline confirmedqty numeric 0  √  0
m_movementline confirmedqty numeric 0  √  0
c_invoice copyfrom bpchar 1  √  null
c_order copyfrom bpchar 1  √  null
m_product copyfrom bpchar 1  √  NULL::bpchar
t_inventoryvalue cost numeric 0  √  0
t_inventoryvalue costamt numeric 0  √  0
m_costelement costelementtype bpchar 1
c_acctschema costinglevel bpchar 1 'C'::bpchar
m_product_category_acct costinglevel bpchar 1  √  null
c_acctschema costingmethod bpchar 1
m_costelement costingmethod bpchar 1  √  null
m_product_category_acct costingmethod bpchar 1  √  null
m_product_po costperorder numeric 0  √  0
t_inventoryvalue coststandard numeric 0  √  0
t_inventoryvalue coststandardamt numeric 0  √  0
m_inout createconfirm bpchar 1  √  null
c_acctschema created timestamp 29,6 now()
c_allocationline created timestamp 29,6 now()
c_invoice created timestamp 29,6 now()
c_invoiceline created timestamp 29,6 now()
c_landedcost created timestamp 29,6 now()
c_landedcostallocation created timestamp 29,6 now()
c_order created timestamp 29,6 now()
c_orderlandedcost created timestamp 29,6 statement_timestamp()
c_orderlandedcostallocation created timestamp 29,6 statement_timestamp()
c_orderline created timestamp 29,6 now()
c_projectissue created timestamp 29,6 now()
c_projectissuema created timestamp 29,6 now()
m_attributesetinstance created timestamp 29,6 now()
m_cost created timestamp 29,6 now()
m_costdetail created timestamp 29,6 now()
m_costelement created timestamp 29,6 now()
m_costhistory created timestamp 29,6 statement_timestamp()
m_costmovement_v created timestamp 29,6  √  null
m_costqueue created timestamp 29,6 now()
m_costtype created timestamp 29,6 now()
m_inout created timestamp 29,6 now()
m_inoutline created timestamp 29,6 now()
m_inoutlinema created timestamp 29,6 now()
m_inventoryline created timestamp 29,6 now()
m_inventorylinema created timestamp 29,6 now()
m_locator created timestamp 29,6 now()
m_matchinv created timestamp 29,6 now()
m_matchpo created timestamp 29,6 now()
m_movementline created timestamp 29,6 now()
m_movementlinema created timestamp 29,6 now()
m_product created timestamp 29,6 now()
m_product_acct created timestamp 29,6 now()
m_product_category created timestamp 29,6 now()
m_product_category_acct created timestamp 29,6 now()
m_product_po created timestamp 29,6 now()
m_productionline created timestamp 29,6 now()
m_productionlinema created timestamp 29,6 now()
m_transaction created timestamp 29,6 now()
m_warehouse created timestamp 29,6 now()
m_warehouse_acct created timestamp 29,6 now()
s_resource created timestamp 29,6 now()
c_acctschema createdby numeric 10
c_allocationline createdby numeric 10
c_invoice createdby numeric 10
c_invoiceline createdby numeric 10
c_landedcost createdby numeric 10
c_landedcostallocation createdby numeric 10
c_order createdby numeric 10
c_orderlandedcost createdby numeric 10
c_orderlandedcostallocation createdby numeric 10
c_orderline createdby numeric 10
c_projectissue createdby numeric 10
c_projectissuema createdby numeric 10
m_attributesetinstance createdby numeric 10
m_cost createdby numeric 10
m_costdetail createdby numeric 10
m_costelement createdby numeric 10
m_costhistory createdby numeric 10
m_costmovement_v createdby numeric 10  √  null
m_costqueue createdby numeric 10
m_costtype createdby numeric 10
m_inout createdby numeric 10
m_inoutline createdby numeric 10
m_inoutlinema createdby numeric 10
m_inventoryline createdby numeric 10
m_inventorylinema createdby numeric 10
m_locator createdby numeric 10
m_matchinv createdby numeric 10
m_matchpo createdby numeric 10
m_movementline createdby numeric 10
m_movementlinema createdby numeric 10
m_product createdby numeric 10
m_product_acct createdby numeric 10
m_product_category createdby numeric 10
m_product_category_acct createdby numeric 10
m_product_po createdby numeric 10
m_productionline createdby numeric 10
m_productionlinema createdby numeric 10
m_transaction createdby numeric 10
m_warehouse createdby numeric 10
m_warehouse_acct createdby numeric 10
s_resource createdby numeric 10
c_invoice createfrom bpchar 1  √  null
m_inout createfrom bpchar 1  √  null
c_invoice createlinesfrom bpchar 1  √  NULL::bpchar
m_inout createlinesfrom bpchar 1  √  NULL::bpchar
m_inout createpackage bpchar 1  √  null
c_orderline createproduction bpchar 1  √  'N'::bpchar
c_orderline createshipment bpchar 1  √  'N'::bpchar
m_cost cumulatedamt numeric 0  √  0
m_costdetail cumulatedamt numeric 0  √  null
m_cost cumulatedqty numeric 0  √  0
m_costdetail cumulatedqty numeric 0  √  null
c_invoice currencyrate numeric 0  √  null
m_cost currentcostprice numeric 0
m_costdetail currentcostprice numeric 0  √  null
m_costqueue currentcostprice numeric 0 0
m_inventoryline currentcostprice numeric 0  √  (0)::numeric
m_cost currentcostpricell numeric 0  √  0
m_cost currentqty numeric 0 0
m_costdetail currentqty numeric 0  √  null
m_costqueue currentqty numeric 0 0
m_product customstariffnumber varchar 20  √  null
s_resource dailycapacity numeric 0  √  null
c_invoice dateacct timestamp 29,6
c_order dateacct timestamp 29,6
m_inout dateacct timestamp 29,6
m_matchinv dateacct timestamp 29,6  √  null
m_matchpo dateacct timestamp 29,6  √  null
c_orderline datedelivered timestamp 29,6  √  null
c_invoice dateinvoiced timestamp 29,6
c_orderline dateinvoiced timestamp 29,6  √  null
m_inoutlinema datematerialpolicy timestamp 29,6
m_inventorylinema datematerialpolicy timestamp 29,6
m_movementlinema datematerialpolicy timestamp 29,6
m_productionlinema datematerialpolicy timestamp 29,6
c_invoice dateordered timestamp 29,6  √  null
c_order dateordered timestamp 29,6
c_orderline dateordered timestamp 29,6
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_allocationline datetrx timestamp 29,6  √  null
m_matchinv datetrx timestamp 29,6
m_matchpo datetrx timestamp 29,6
t_inventoryvalue datevalue timestamp 29,6  √  null
m_movementline dd_orderline_id numeric 10  √  null
c_order deliveryrule bpchar 1
m_inout deliveryrule bpchar 1
m_product_po deliverytime_actual numeric 10  √  null
m_product_po deliverytime_promised numeric 10  √  null
c_order deliveryviarule bpchar 1
m_inout deliveryviarule bpchar 1
m_costdetail deltaamt numeric 0  √  0
m_costmovement_v deltaamt numeric 0  √  null
m_costdetail deltaqty numeric 0  √  0
m_costmovement_v deltaqty numeric 0  √  null
c_acctschema description varchar 255  √  null
c_invoice description varchar 255  √  null
c_invoiceline description varchar 255  √  null
c_landedcost description varchar 255  √  null
c_order description varchar 255  √  null
c_orderlandedcost description varchar 255  √  NULL::character varying
c_orderline description varchar 255  √  null
c_projectissue description varchar 255  √  null
m_attributesetinstance description varchar 255  √  null
m_cost description varchar 255  √  null
m_costdetail description varchar 255  √  null
m_costelement description varchar 255  √  null
m_costmovement_v description varchar 255  √  null
m_costtype description varchar 255  √  null
m_inout description varchar 255  √  null
m_inoutline description varchar 255  √  null
m_inventoryline description varchar 255  √  null
m_matchinv description varchar 255  √  null
m_matchpo description varchar 255  √  null
m_movementline description varchar 255  √  null
m_product description varchar 255  √  null
m_product_category description varchar 255  √  null
m_productionline description varchar 255  √  null
m_warehouse description varchar 255  √  null
s_resource description varchar 255  √  null
m_product descriptionurl varchar 120  √  null
m_product discontinued bpchar 1  √  'N'::bpchar
m_product_po discontinued bpchar 1  √  'N'::bpchar
m_product discontinuedat timestamp 29,6  √  null
m_product_po discontinuedat timestamp 29,6  √  null
m_product discontinuedby timestamp 29,6  √  null
m_product_po discontinuedby timestamp 29,6  √  null
c_orderline discount numeric 0  √  null
c_allocationline discountamt numeric 0 0
c_invoice docaction bpchar 2
c_order docaction bpchar 2
c_projectissue docaction bpchar 2 'CO'::bpchar
m_inout docaction bpchar 2
c_invoice docstatus bpchar 2
c_order docstatus bpchar 2
c_projectissue docstatus varchar 2 'DR'::character varying
m_inout docstatus bpchar 2
c_invoice documentno varchar 30
c_order documentno varchar 30
m_inout documentno varchar 30
m_matchinv documentno varchar 30  √  null
m_matchpo documentno varchar 30  √  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_invoice dunninggrace timestamp 29,6  √  null
m_inout fob varchar 10  √  NULL::character varying
c_order freightamt numeric 0  √  0
c_orderline freightamt numeric 0 0
m_inout freightamt numeric 0  √  0
m_inout freightcharges varchar 10  √  NULL::character varying
c_order freightcostrule bpchar 1
m_inout freightcostrule bpchar 1
m_cost futurecostprice numeric 0  √  null
m_cost futurecostpricell numeric 0  √  null
c_acctschema gaap bpchar 2
c_invoice generateto bpchar 1  √  null
m_inout generateto bpchar 1  √  null
c_invoice grandtotal numeric 0 0
c_order grandtotal numeric 0 0
m_product group1 varchar 255  √  null
m_product group2 varchar 255  √  null
m_attributesetinstance guaranteedate timestamp 29,6  √  null
m_product guaranteedays numeric 10  √  null
m_product guaranteedaysmin numeric 10  √  null
c_acctschema hasalias bpchar 1 'Y'::bpchar
c_acctschema hascombination bpchar 1 'Y'::bpchar
m_costtype help varchar 2000  √  null
m_product help varchar 2000  √  null
m_product imageurl varchar 120  √  null
m_inout insurance bpchar 1  √  NULL::bpchar
m_inventoryline inventorytype bpchar 1 'D'::bpchar
c_invoice invoicecollectiontype bpchar 1  √  null
c_order invoicerule bpchar 1
c_acctschema isaccrual bpchar 1 'Y'::bpchar
c_acctschema isactive bpchar 1 'Y'::bpchar
c_allocationline 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_orderlandedcost isactive bpchar 1 'Y'::bpchar
c_orderlandedcostallocation isactive bpchar 1 'Y'::bpchar
c_orderline isactive bpchar 1 'Y'::bpchar
c_projectissue isactive bpchar 1 'Y'::bpchar
c_projectissuema isactive bpchar 1 'Y'::bpchar
m_attributesetinstance isactive bpchar 1 'Y'::bpchar
m_cost isactive bpchar 1 'Y'::bpchar
m_costdetail isactive bpchar 1 'Y'::bpchar
m_costelement isactive bpchar 1 'Y'::bpchar
m_costhistory isactive bpchar 1 'Y'::bpchar
m_costmovement_v isactive bpchar 1  √  null
m_costqueue isactive bpchar 1 'Y'::bpchar
m_costtype isactive bpchar 1 'Y'::bpchar
m_inout isactive bpchar 1 'Y'::bpchar
m_inoutline isactive bpchar 1 'Y'::bpchar
m_inoutlinema isactive bpchar 1 'Y'::bpchar
m_inventoryline isactive bpchar 1 'Y'::bpchar
m_inventorylinema isactive bpchar 1 'Y'::bpchar
m_locator isactive bpchar 1 'Y'::bpchar
m_matchinv isactive bpchar 1 'Y'::bpchar
m_matchpo isactive bpchar 1 'Y'::bpchar
m_movementline isactive bpchar 1 'Y'::bpchar
m_movementlinema isactive bpchar 1 'Y'::bpchar
m_product isactive bpchar 1 'Y'::bpchar
m_product_acct isactive bpchar 1 'Y'::bpchar
m_product_category isactive bpchar 1 'Y'::bpchar
m_product_category_acct isactive bpchar 1 'Y'::bpchar
m_product_po isactive bpchar 1 'Y'::bpchar
m_productionline isactive bpchar 1 'Y'::bpchar
m_productionlinema isactive bpchar 1 'Y'::bpchar
m_transaction isactive bpchar 1 'Y'::bpchar
m_warehouse isactive bpchar 1 'Y'::bpchar
m_warehouse_acct isactive bpchar 1 'Y'::bpchar
s_resource isactive bpchar 1 'Y'::bpchar
c_acctschema isadjustcogs bpchar 1 'N'::bpchar
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar
c_invoice isapproved bpchar 1 'N'::bpchar
c_order isapproved bpchar 1 'N'::bpchar
c_projectissue isapproved bpchar 1 'N'::bpchar
m_inout isapproved bpchar 1 'N'::bpchar
m_matchpo isapproved bpchar 1  √  'Y'::bpchar
m_inoutlinema isautogenerated bpchar 1  √  'N'::bpchar
m_inventorylinema isautogenerated bpchar 1  √  'N'::bpchar
m_movementlinema isautogenerated bpchar 1  √  'N'::bpchar
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar
m_product isautoproduce bpchar 1 'N'::bpchar
s_resource isavailable bpchar 1 'Y'::bpchar
m_product isbom bpchar 1 'N'::bpchar
m_costelement iscalculated bpchar 1 'N'::bpchar
m_cost iscostfrozen bpchar 1  √  'N'::bpchar
c_order iscreditapproved bpchar 1 'N'::bpchar
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar
m_locator isdefault bpchar 1 'N'::bpchar
m_product_category isdefault 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
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar
c_order isdiscountprinted bpchar 1 'Y'::bpchar
c_order isdropship bpchar 1 'N'::bpchar
m_inout isdropship bpchar 1  √  'N'::bpchar
m_product isdropship bpchar 1 'N'::bpchar
m_productionline isendproduct bpchar 1  √  NULL::bpchar
m_product isexcludeautodelivery bpchar 1 'N'::bpchar
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar
c_invoice isfixedassetinvoice bpchar 1  √  null
c_invoiceline isfixedassetinvoice bpchar 1  √  null
c_invoice isindispute bpchar 1 'N'::bpchar
m_inout isindispute bpchar 1 'N'::bpchar
m_inout isintransit bpchar 1 'N'::bpchar
m_warehouse isintransit bpchar 1  √  'N'::bpchar
c_order isinvoiced bpchar 1 'N'::bpchar
m_inoutline isinvoiced bpchar 1 'N'::bpchar
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar
m_product iskanban bpchar 1 'N'::bpchar
c_allocationline ismanual bpchar 1  √  'N'::bpchar
m_product ismanufactured bpchar 1 'N'::bpchar
s_resource ismanufacturingresource 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 isphantom bpchar 1  √  'N'::bpchar
m_product ispicklistprintdetails bpchar 1 'N'::bpchar
c_acctschema ispostifclearingequal bpchar 1  √  'Y'::bpchar
c_acctschema ispostservices bpchar 1 'N'::bpchar
c_invoice isprinted bpchar 1 'N'::bpchar
c_invoiceline isprinted bpchar 1 'Y'::bpchar
c_order isprinted bpchar 1 'N'::bpchar
m_inout isprinted bpchar 1 'N'::bpchar
c_order ispriviledgedrate bpchar 1 'N'::bpchar
m_product ispurchased bpchar 1 'Y'::bpchar
c_order isselected bpchar 1 'N'::bpchar
c_invoice isselfservice bpchar 1 'N'::bpchar
c_order isselfservice bpchar 1 'N'::bpchar
m_product isselfservice bpchar 1 'Y'::bpchar
m_product_category 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_costdetail issotrx bpchar 1 'Y'::bpchar
m_inout issotrx bpchar 1 'Y'::bpchar
m_product isstocked bpchar 1 'Y'::bpchar
m_product issummary bpchar 1 'N'::bpchar
c_invoice istaxincluded bpchar 1 'N'::bpchar
c_order istaxincluded bpchar 1 'N'::bpchar
m_product istoformule bpchar 1  √  null
c_acctschema istradediscountposted bpchar 1 'N'::bpchar
c_invoice istransferred bpchar 1 'N'::bpchar
c_order istransferred bpchar 1 'N'::bpchar
m_product isverified bpchar 1 'N'::bpchar
m_product iswebstorefeatured bpchar 1 'N'::bpchar
c_landedcost landedcostdistribution bpchar 1
c_orderlandedcost landedcostdistribution bpchar 1 'Q'::bpchar
c_invoiceline line numeric 10
c_orderline line numeric 10
c_projectissue line numeric 10
m_inoutline line numeric 10
m_inventoryline line numeric 10  √  null
m_movementline line numeric 10  √  null
m_productionline line numeric 10
c_invoiceline linenetamt numeric 0 0
c_orderline linenetamt numeric 0 0
c_invoiceline linetotalamt numeric 0  √  0
c_order link_order_id numeric 10  √  null
c_orderline link_orderline_id numeric 10  √  null
m_attributesetinstance lot varchar 40  √  null
m_product lowlevel numeric 10 (0)::numeric
m_attributesetinstance m_attributeset_id numeric 10  √  null
m_product m_attributeset_id numeric 10  √  null
c_invoiceline m_attributesetinstance_id numeric 10  √  0
c_landedcostallocation m_attributesetinstance_id numeric 10  √  null
c_orderline m_attributesetinstance_id numeric 10  √  0
c_projectissue m_attributesetinstance_id numeric 10  √  0
c_projectissuema m_attributesetinstance_id numeric 10
m_attributesetinstance m_attributesetinstance_id numeric 10
m_cost m_attributesetinstance_id numeric 10
m_costdetail m_attributesetinstance_id numeric 10
m_costhistory m_attributesetinstance_id numeric 10
m_costmovement_v m_attributesetinstance_id numeric 10  √  null
m_costqueue m_attributesetinstance_id numeric 10
m_inoutline m_attributesetinstance_id numeric 10  √  0
m_inoutlinema m_attributesetinstance_id numeric 10
m_inventoryline m_attributesetinstance_id numeric 10  √  0
m_inventorylinema m_attributesetinstance_id numeric 10
m_matchinv m_attributesetinstance_id numeric 10  √  null
m_matchpo m_attributesetinstance_id numeric 10  √  null
m_movementline m_attributesetinstance_id numeric 10  √  null
m_movementlinema m_attributesetinstance_id numeric 10
m_product m_attributesetinstance_id numeric 10  √  0
m_productionline m_attributesetinstance_id numeric 10  √  0
m_productionlinema m_attributesetinstance_id numeric 10
m_transaction m_attributesetinstance_id numeric 10 0
t_inventoryvalue m_attributesetinstance_id numeric 10
m_attributesetinstance m_attributesetinstance_uu varchar 36  √  NULL::character varying
m_movementline m_attributesetinstanceto_id numeric 10  √  null
m_cost m_cost_uu varchar 36  √  NULL::character varying
m_costdetail m_costdetail_id numeric 10
m_costhistory m_costdetail_id numeric 10
m_costmovement_v m_costdetail_id numeric 10  √  null
m_costdetail m_costdetail_uu varchar 36  √  NULL::character varying
c_landedcost m_costelement_id numeric 10
c_landedcostallocation m_costelement_id numeric 10
c_orderlandedcost m_costelement_id numeric 10
m_cost m_costelement_id numeric 10
m_costdetail m_costelement_id numeric 10  √  null
m_costelement m_costelement_id numeric 10
m_costhistory m_costelement_id numeric 10
m_costmovement_v m_costelement_id numeric 10  √  null
m_costqueue m_costelement_id numeric 10
t_inventoryvalue m_costelement_id numeric 10  √  null
m_costelement m_costelement_uu varchar 36  √  NULL::character varying
m_costhistory m_costhistory_id numeric 10
m_costmovement_v m_costhistory_id numeric 10  √  null
m_costhistory m_costhistory_uu varchar 36
m_costqueue m_costqueue_id numeric 10
m_costqueue m_costqueue_uu varchar 36  √  NULL::character varying
c_acctschema m_costtype_id numeric 10  √  null
m_cost m_costtype_id numeric 10
m_costhistory m_costtype_id numeric 10
m_costmovement_v m_costtype_id numeric 10  √  null
m_costqueue m_costtype_id numeric 10
m_costtype m_costtype_id numeric 10
m_costtype m_costtype_uu varchar 36  √  NULL::character varying
c_order m_freightcategory_id numeric 10  √  NULL::numeric
m_product m_freightcategory_id numeric 10  √  null
c_landedcost m_inout_id numeric 10  √  null
m_inout m_inout_id numeric 10
m_inoutline m_inout_id numeric 10
m_inout m_inout_uu varchar 36  √  NULL::character varying
c_invoiceline m_inoutline_id numeric 10  √  null
c_landedcost m_inoutline_id numeric 10  √  null
c_landedcostallocation m_inoutline_id numeric 10  √  NULL::numeric
c_projectissue m_inoutline_id numeric 10  √  null
m_costdetail m_inoutline_id numeric 10  √  null
m_costmovement_v m_inoutline_id numeric 10  √  null
m_inoutline m_inoutline_id numeric 10
m_inoutlinema m_inoutline_id numeric 10
m_matchinv m_inoutline_id numeric 10  √  null
m_matchpo m_inoutline_id numeric 10  √  null
m_transaction m_inoutline_id numeric 10  √  null
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying
m_inoutlinema m_inoutlinema_uu varchar 36  √  NULL::character varying
m_inventoryline m_inventory_id numeric 10
m_costdetail m_inventoryline_id numeric 10  √  null
m_costmovement_v m_inventoryline_id numeric 10  √  null
m_inventoryline m_inventoryline_id numeric 10
m_inventorylinema m_inventoryline_id numeric 10
m_transaction m_inventoryline_id numeric 10  √  null
m_inventoryline m_inventoryline_uu varchar 36  √  NULL::character varying
m_inventorylinema m_inventorylinema_uu varchar 36  √  NULL::character varying
c_projectissue m_locator_id numeric 10
m_inoutline m_locator_id numeric 10  √  null
m_inventoryline m_locator_id numeric 10  √  null
m_locator m_locator_id numeric 10
m_movementline m_locator_id numeric 10
m_product m_locator_id numeric 10  √  null
m_productionline m_locator_id numeric 10
m_transaction m_locator_id numeric 10
m_locator m_locator_uu varchar 36  √  NULL::character varying
m_movementline m_locatorto_id numeric 10
m_locator m_locatortype_id numeric 10  √  NULL::numeric
m_attributesetinstance m_lot_id numeric 10  √  null
m_costdetail m_matchinv_id numeric 10  √  NULL::numeric
m_costmovement_v m_matchinv_id numeric 10  √  null
m_matchinv m_matchinv_id numeric 10
m_matchinv m_matchinv_uu varchar 36  √  NULL::character varying
m_matchpo m_matchpo_id numeric 10
m_matchpo m_matchpo_uu varchar 36  √  NULL::character varying
m_movementline m_movement_id numeric 10
m_costdetail m_movementline_id numeric 10  √  null
m_costmovement_v m_movementline_id numeric 10  √  null
m_movementline m_movementline_id numeric 10
m_movementlinema m_movementline_id numeric 10
m_transaction m_movementline_id numeric 10  √  null
m_movementline m_movementline_uu varchar 36  √  NULL::character varying
m_movementlinema m_movementlinema_uu varchar 36  √  NULL::character varying
m_product m_parttype_id numeric 10  √  NULL::numeric
c_invoice m_pricelist_id numeric 10
c_order m_pricelist_id numeric 10
t_inventoryvalue m_pricelist_version_id numeric 10  √  null
m_product_acct m_product_acct_uu varchar 36  √  NULL::character varying
m_product_category_acct m_product_category_acct_uu varchar 36  √  NULL::character varying
m_product m_product_category_id numeric 10
m_product_category m_product_category_id numeric 10
m_product_category_acct m_product_category_id numeric 10
m_product_category m_product_category_parent_id numeric 10  √  null
m_product_category m_product_category_uu varchar 36  √  NULL::character varying
c_invoiceline m_product_id numeric 10  √  null
c_landedcost m_product_id numeric 10  √  null
c_landedcostallocation m_product_id numeric 10
c_orderline m_product_id numeric 10  √  null
c_projectissue m_product_id numeric 10
m_cost m_product_id numeric 10
m_costdetail m_product_id numeric 10
m_costhistory m_product_id numeric 10  √  NULL::numeric
m_costmovement_v m_product_id numeric 10  √  null
m_costqueue m_product_id numeric 10
m_inoutline m_product_id numeric 10  √  null
m_inventoryline m_product_id numeric 10
m_matchinv m_product_id numeric 10  √  null
m_matchpo m_product_id numeric 10  √  null
m_movementline m_product_id numeric 10
m_product m_product_id numeric 10
m_product_acct m_product_id numeric 10
m_product_po m_product_id numeric 10
m_productionline m_product_id numeric 10
m_transaction m_product_id numeric 10
t_inventoryvalue m_product_id numeric 10
m_product_po m_product_po_uu varchar 36  √  NULL::character varying
m_product m_product_uu varchar 36  √  NULL::character varying
m_productionline m_production_id numeric 10  √  null
m_costdetail m_productionline_id numeric 10  √  null
m_costmovement_v m_productionline_id numeric 10  √  null
m_productionline m_productionline_id numeric 10
m_productionlinema m_productionline_id numeric 10
m_transaction m_productionline_id numeric 10  √  null
m_productionline m_productionline_uu varchar 36  √  NULL::character varying
m_productionlinema m_productionlinema_uu varchar 36  √  NULL::character varying
m_productionline m_productionplan_id numeric 10  √  null
c_orderline m_promotion_id numeric 10  √  null
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric
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
m_transaction m_transaction_id numeric 10
m_transaction m_transaction_uu varchar 36  √  NULL::character varying
m_warehouse_acct m_warehouse_acct_uu varchar 36  √  NULL::character varying
c_order m_warehouse_id numeric 10
c_orderline m_warehouse_id numeric 10
m_inout m_warehouse_id numeric 10
m_locator m_warehouse_id numeric 10
m_warehouse m_warehouse_id numeric 10
m_warehouse_acct m_warehouse_id numeric 10
s_resource m_warehouse_id numeric 10
t_inventoryvalue m_warehouse_id numeric 10
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying
m_warehouse m_warehousesource_id numeric 10  √  null
m_product_po manufacturer varchar 30  √  null
s_resource manufacturingresourcetype bpchar 2  √  null
m_product_category mmpolicy bpchar 1 'F'::bpchar
c_projectissue movementdate timestamp 29,6
m_inout movementdate timestamp 29,6
m_transaction movementdate timestamp 29,6
c_projectissue movementqty numeric 0 0
c_projectissuema movementqty numeric 0 0
m_inoutline movementqty numeric 0 0
m_inoutlinema movementqty numeric 0 (1)::numeric
m_inventorylinema movementqty numeric 0 (1)::numeric
m_movementline movementqty numeric 0 0
m_movementlinema movementqty numeric 0  √  (1)::numeric
m_productionline movementqty numeric 0 0
m_productionlinema movementqty numeric 0 0
m_transaction movementqty numeric 0 0
m_inout movementtype bpchar 2
m_transaction movementtype bpchar 2
c_acctschema name varchar 60
m_costelement name varchar 60
m_costtype name varchar 60
m_product name varchar 255
m_product_category name varchar 60
m_warehouse name varchar 60
s_resource name varchar 60
m_costhistory newcamt numeric 0  √  null
m_costmovement_v newcamt numeric 0  √  null
m_costhistory newcostprice numeric 0
m_costmovement_v newcostprice numeric 0  √  null
m_inventoryline newcostprice numeric 0  √  (0)::numeric
m_costhistory newcqty numeric 0  √  null
m_costmovement_v newcqty numeric 0  √  null
m_costhistory newqty numeric 0
m_costmovement_v newqty numeric 0  √  null
m_inout nopackages numeric 10  √  (1)::numeric
m_costhistory oldcamt numeric 0  √  null
m_costmovement_v oldcamt numeric 0  √  null
m_costhistory oldcostprice numeric 0
m_costmovement_v oldcostprice numeric 0  √  null
m_costhistory oldcqty numeric 0  √  null
m_costmovement_v oldcqty numeric 0  √  null
m_costhistory oldqty numeric 0
m_costmovement_v oldqty numeric 0  √  null
m_product_po order_min numeric 0  √  0
m_product_po order_pack numeric 0  √  0
c_order ordertype varchar 510  √  null
c_allocationline overunderamt numeric 0  √  0
m_product_acct p_asset_acct numeric 10
m_product_category_acct p_asset_acct numeric 10
m_product_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric
m_product_category_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric
m_product_acct p_burden_acct numeric 10  √  null
m_product_category_acct p_burden_acct numeric 10  √  null
m_product_acct p_cogs_acct numeric 10
m_product_category_acct p_cogs_acct numeric 10
m_product_acct p_costadjustment_acct numeric 10  √  null
m_product_category_acct p_costadjustment_acct numeric 10  √  null
m_product_acct p_costofproduction_acct numeric 10  √  null
m_product_category_acct p_costofproduction_acct numeric 10  √  null
m_product_acct p_expense_acct numeric 10
m_product_category_acct p_expense_acct numeric 10
m_product_acct p_floorstock_acct numeric 10  √  null
m_product_category_acct p_floorstock_acct numeric 10  √  null
m_product_acct p_inventoryclearing_acct numeric 10  √  null
m_product_category_acct p_inventoryclearing_acct numeric 10  √  null
m_product_acct p_invoicepricevariance_acct numeric 10
m_product_category_acct p_invoicepricevariance_acct numeric 10
m_product_acct p_labor_acct numeric 10  √  null
m_product_category_acct p_labor_acct numeric 10  √  null
m_product_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric
m_product_category_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric
m_product_acct p_methodchangevariance_acct numeric 10  √  null
m_product_category_acct p_methodchangevariance_acct numeric 10  √  null
m_product_acct p_mixvariance_acct numeric 10  √  null
m_product_category_acct p_mixvariance_acct numeric 10  √  null
m_product_acct p_outsideprocessing_acct numeric 10  √  null
m_product_category_acct p_outsideprocessing_acct numeric 10  √  null
m_product_acct p_overhead_acct numeric 10  √  null
m_product_category_acct p_overhead_acct numeric 10  √  null
m_product_acct p_purchasepricevariance_acct numeric 10
m_product_category_acct p_purchasepricevariance_acct numeric 10
m_product_acct p_ratevariance_acct numeric 10  √  null
m_product_category_acct p_ratevariance_acct numeric 10  √  null
m_product_acct p_revenue_acct numeric 10
m_product_category_acct p_revenue_acct numeric 10
m_product_acct p_scrap_acct numeric 10  √  null
m_product_category_acct p_scrap_acct numeric 10  √  null
m_product_acct p_tradediscountgrant_acct numeric 10
m_product_category_acct p_tradediscountgrant_acct numeric 10
m_product_acct p_tradediscountrec_acct numeric 10
m_product_category_acct p_tradediscountrec_acct numeric 10
m_product_acct p_usagevariance_acct numeric 10  √  null
m_product_category_acct p_usagevariance_acct numeric 10  √  null
m_product_acct p_wip_acct numeric 10  √  null
m_product_category_acct p_wip_acct numeric 10  √  null
c_order pay_bpartner_id numeric 10  √  null
c_order pay_location_id numeric 10  √  null
c_invoice paymentrule bpchar 1
c_order paymentrule bpchar 1
m_cost percent numeric 10  √  0
s_resource percentutilization numeric 0 (100)::numeric
c_acctschema period_openfuture numeric 10  √  null
c_acctschema period_openhistory numeric 10  √  null
m_inout pickdate timestamp 29,6  √  null
m_inoutline pickedqty numeric 0  √  0
m_product_category plannedmargin numeric 0
m_productionline plannedqty numeric 0  √  null
s_resource planninghorizon numeric 10  √  (0)::numeric
c_invoice poreference varchar 20  √  null
c_order poreference varchar 20  √  null
m_inout poreference varchar 20  √  null
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
m_matchinv posted bpchar 1 'N'::bpchar
m_matchpo posted bpchar 1 'N'::bpchar
c_orderline pp_cost_collector_id numeric 10  √  null
m_costdetail pp_cost_collector_id numeric 10  √  null
m_transaction pp_cost_collector_id numeric 10  √  null
c_invoiceline priceactual numeric 0 0
c_orderline priceactual numeric 0 0
c_orderline pricecost numeric 0  √  null
m_product_po priceeffective timestamp 29,6  √  null
c_invoiceline priceentered numeric 0
c_orderline priceentered numeric 0
m_product_po pricelastinv numeric 0  √  0
m_product_po pricelastpo numeric 0  √  0
c_invoiceline pricelimit numeric 0 0
c_orderline pricelimit numeric 0 0
t_inventoryvalue pricelimit numeric 0  √  0
t_inventoryvalue pricelimitamt numeric 0  √  0
c_invoiceline pricelist numeric 0 0
c_orderline pricelist numeric 0 0
m_product_po pricelist numeric 0  √  0
t_inventoryvalue pricelist numeric 0  √  0
t_inventoryvalue pricelistamt numeric 0  √  0
m_matchpo pricematchdifference numeric 0  √  null
m_product_po pricepo numeric 0  √  0
t_inventoryvalue pricepo numeric 0  √  0
t_inventoryvalue pricepoamt numeric 0  √  0
t_inventoryvalue pricestd numeric 0  √  0
t_inventoryvalue pricestdamt numeric 0  √  0
m_locator priorityno numeric 10
c_order priorityrule bpchar 1
m_inout priorityrule bpchar 1
c_invoice processed bpchar 1 'N'::bpchar
c_invoiceline processed bpchar 1 'N'::bpchar
c_order processed bpchar 1 'N'::bpchar
c_orderlandedcost processed bpchar 1 'N'::bpchar
c_orderlandedcostallocation processed bpchar 1 'N'::bpchar
c_orderline processed bpchar 1 'N'::bpchar
c_projectissue processed bpchar 1 'N'::bpchar
m_costdetail processed bpchar 1 'N'::bpchar
m_inout processed bpchar 1 'N'::bpchar
m_inoutline processed bpchar 1 'N'::bpchar
m_inventoryline processed bpchar 1 'N'::bpchar
m_matchinv processed bpchar 1 'N'::bpchar
m_matchpo processed bpchar 1 'N'::bpchar
m_movementline processed bpchar 1 'N'::bpchar
m_productionline processed bpchar 1 'N'::bpchar
c_invoice processedon numeric 0  √  null
c_order processedon numeric 0  √  null
c_projectissue processedon numeric 0  √  null
m_inout processedon numeric 0  √  null
m_matchinv processedon numeric 0  √  null
m_matchpo processedon numeric 0  √  null
c_acctschema processing bpchar 1  √  null
c_invoice processing bpchar 1  √  null
c_landedcost processing bpchar 1  √  null
c_order processing bpchar 1  √  null
c_projectissue processing bpchar 1  √  null
m_inout processing bpchar 1  √  null
m_matchinv processing bpchar 1
m_matchpo processing bpchar 1
m_product processing bpchar 1  √  null
m_product_category_acct processing bpchar 1  √  null
m_product producttype bpchar 1 'I'::bpchar
c_order promotioncode varchar 30  √  null
c_landedcostallocation qty numeric 0 0
c_orderlandedcostallocation qty numeric 0
m_costdetail qty numeric 0 0
m_costmovement_v qty numeric 0  √  null
m_matchinv qty numeric 0 0
m_matchpo qty numeric 0 0
m_inventoryline qtybook numeric 0 0
m_inventoryline qtycount numeric 0 0
m_inventoryline qtycsv numeric 0 0
c_orderline qtydelivered numeric 0 0
c_invoiceline qtyentered numeric 0
c_orderline qtyentered numeric 0
m_inoutline qtyentered numeric 0
m_inventoryline qtyinternaluse numeric 0  √  null
c_invoiceline qtyinvoiced numeric 0 0
c_orderline qtyinvoiced numeric 0 0
c_orderline qtylostsales numeric 0 0
t_inventoryvalue qtyonhand numeric 0  √  0
c_orderline qtyordered numeric 0 0
m_inoutline qtyoverreceipt numeric 0  √  0
c_orderline qtyreserved numeric 0 0
m_productionline qtyused numeric 0  √  null
m_product_po qualityrating numeric 0  √  null
s_resource queuingtime numeric 0  √  null
c_order quotationorder_id numeric 10  √  NULL::numeric
m_product r_mailtext_id numeric 10  √  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
m_matchinv ref_matchinv_id numeric 10  √  NULL::numeric
m_matchpo ref_matchpo_id numeric 10  √  NULL::numeric
c_order ref_order_id numeric 10  √  null
c_orderline ref_orderline_id numeric 10  √  null
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric
m_warehouse replenishmentclass varchar 60  √  null
m_inout returnbpartner_id numeric 10  √  NULL::numeric
m_inout returnlocation_id numeric 10  √  NULL::numeric
m_inout returnuser_id numeric 10  √  NULL::numeric
c_invoice reversal_id numeric 10  √  null
c_projectissue reversal_id numeric 10  √  null
m_inout reversal_id numeric 10  √  null
m_matchinv reversal_id numeric 10  √  NULL::numeric
m_matchpo reversal_id numeric 10  √  NULL::numeric
m_inoutline reversalline_id numeric 10  √  null
m_inventoryline reversalline_id numeric 10  √  null
m_movementline reversalline_id numeric 10  √  null
m_product_po royaltyamt numeric 0  √  0
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
s_resource s_resource_id numeric 10
s_resource s_resource_uu varchar 36  √  NULL::character varying
c_invoiceline s_resourceassignment_id numeric 10  √  null
c_orderline s_resourceassignment_id numeric 10  √  null
s_resource s_resourcetype_id numeric 10
c_projectissue s_timeexpenseline_id numeric 10  √  null
c_invoice salesrep_id numeric 10  √  null
c_order salesrep_id numeric 10  √  null
m_inout salesrep_id numeric 10  √  null
m_product salesrep_id numeric 10  √  null
m_inoutline scrappedqty numeric 0  √  0
m_movementline scrappedqty numeric 0  √  0
c_invoice sendemail bpchar 1 'N'::bpchar
c_order sendemail bpchar 1 'N'::bpchar
m_inout sendemail bpchar 1 'N'::bpchar
c_acctschema separator bpchar 1
m_warehouse separator bpchar 1
m_attributesetinstance serno varchar 40  √  null
m_product shelfdepth numeric 10  √  null
m_product shelfheight numeric 0  √  null
m_product shelfwidth numeric 10  √  null
m_inout shipdate timestamp 29,6  √  null
m_inout shipperaccount varchar 40  √  NULL::character varying
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar
m_product sku varchar 30  √  null
t_inventoryvalue t_inventoryvalue_uu varchar 36  √  NULL::character varying
m_inoutline targetqty numeric 0  √  0
m_movementline targetqty numeric 0  √  0
c_invoiceline taxamt numeric 0  √  0
c_acctschema taxcorrectiontype bpchar 1  √  null
c_invoice totallines numeric 0 0
c_order totallines numeric 0 0
m_inout trackingno varchar 60  √  null
m_product unitsperpack numeric 10 1
m_product unitsperpallet numeric 0  √  null
m_product upc varchar 30  √  null
m_product_po upc varchar 20  √  null
c_acctschema updated timestamp 29,6 now()
c_allocationline updated timestamp 29,6 now()
c_invoice updated timestamp 29,6 now()
c_invoiceline updated timestamp 29,6 now()
c_landedcost updated timestamp 29,6 now()
c_landedcostallocation updated timestamp 29,6 now()
c_order updated timestamp 29,6 now()
c_orderlandedcost updated timestamp 29,6 statement_timestamp()
c_orderlandedcostallocation updated timestamp 29,6 statement_timestamp()
c_orderline updated timestamp 29,6 now()
c_projectissue updated timestamp 29,6 now()
c_projectissuema updated timestamp 29,6 now()
m_attributesetinstance updated timestamp 29,6 now()
m_cost updated timestamp 29,6 now()
m_costdetail updated timestamp 29,6 now()
m_costelement updated timestamp 29,6 now()
m_costhistory updated timestamp 29,6 statement_timestamp()
m_costmovement_v updated timestamp 29,6  √  null
m_costqueue updated timestamp 29,6 now()
m_costtype updated timestamp 29,6 now()
m_inout updated timestamp 29,6 now()
m_inoutline updated timestamp 29,6 now()
m_inoutlinema updated timestamp 29,6 now()
m_inventoryline updated timestamp 29,6 now()
m_inventorylinema updated timestamp 29,6 now()
m_locator updated timestamp 29,6 now()
m_matchinv updated timestamp 29,6 now()
m_matchpo updated timestamp 29,6 now()
m_movementline updated timestamp 29,6 now()
m_movementlinema updated timestamp 29,6 now()
m_product updated timestamp 29,6 now()
m_product_acct updated timestamp 29,6 now()
m_product_category updated timestamp 29,6 now()
m_product_category_acct updated timestamp 29,6 now()
m_product_po updated timestamp 29,6 now()
m_productionline updated timestamp 29,6 now()
m_productionlinema updated timestamp 29,6 now()
m_transaction updated timestamp 29,6 now()
m_warehouse updated timestamp 29,6 now()
m_warehouse_acct updated timestamp 29,6 now()
s_resource updated timestamp 29,6 now()
c_acctschema updatedby numeric 10
c_allocationline updatedby numeric 10
c_invoice updatedby numeric 10
c_invoiceline updatedby numeric 10
c_landedcost updatedby numeric 10
c_landedcostallocation updatedby numeric 10
c_order updatedby numeric 10
c_orderlandedcost updatedby numeric 10
c_orderlandedcostallocation updatedby numeric 10
c_orderline updatedby numeric 10
c_projectissue updatedby numeric 10
c_projectissuema updatedby numeric 10
m_attributesetinstance updatedby numeric 10
m_cost updatedby numeric 10
m_costdetail updatedby numeric 10
m_costelement updatedby numeric 10
m_costhistory updatedby numeric 10
m_costmovement_v updatedby numeric 10  √  null
m_costqueue updatedby numeric 10
m_costtype updatedby numeric 10
m_inout updatedby numeric 10
m_inoutline updatedby numeric 10
m_inoutlinema updatedby numeric 10
m_inventoryline updatedby numeric 10
m_inventorylinema updatedby numeric 10
m_locator updatedby numeric 10
m_matchinv updatedby numeric 10
m_matchpo updatedby numeric 10
m_movementline updatedby numeric 10
m_movementlinema updatedby numeric 10
m_product updatedby numeric 10
m_product_acct updatedby numeric 10
m_product_category updatedby numeric 10
m_product_category_acct updatedby numeric 10
m_product_po updatedby numeric 10
m_productionline updatedby numeric 10
m_productionlinema updatedby numeric 10
m_transaction updatedby numeric 10
m_warehouse updatedby numeric 10
m_warehouse_acct updatedby numeric 10
s_resource updatedby numeric 10
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
m_locator value varchar 40
m_product value varchar 510
m_product_category value varchar 40
m_warehouse value varchar 40
s_resource value varchar 40
m_product_po vendorcategory varchar 30  √  null
m_product_po vendorproductno varchar 40
m_product versionno varchar 20  √  null
c_order volume numeric 0  √  null
m_inout volume numeric 0  √  null
m_product volume numeric 0  √  0
m_warehouse_acct w_differences_acct numeric 10
m_warehouse_acct w_invactualadjust_acct numeric 10  √  null
m_warehouse_acct w_inventory_acct numeric 10  √  null
m_warehouse_acct w_revaluation_acct numeric 10  √  null
s_resource waitingtime numeric 0  √  null
c_order weight numeric 0  √  null
m_inout weight numeric 0  √  null
m_product weight numeric 0  √  0
c_allocationline writeoffamt numeric 0 0
m_locator x varchar 60  √  null
m_locator y varchar 60  √  null
m_locator z varchar 60  √  null