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

idempiere9.adempiere contains 253 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar Create Asset
c_invoiceline a_processed bpchar 1  √  'N'::bpchar Processed
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
c_orderline createproduction bpchar 1  √  'N'::bpchar Create Production
c_orderline createshipment bpchar 1  √  'N'::bpchar Create Shipment
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
c_invoiceline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_orderline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom_conversion isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar Auto create production to fulfill shipment
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
c_uom isdefault bpchar 1 'N'::bpchar Default value
c_invoiceline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
c_orderline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_inoutline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
m_inoutline isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_invoiceline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_product istoformule bpchar 1  √  null
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
c_invoiceline processed bpchar 1 'N'::bpchar The document has been processed
c_orderline processed bpchar 1 'N'::bpchar The document has been processed
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
c_orderline discount numeric 0  √  null Discount in percent
c_uom_conversion dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
c_orderline freightamt numeric 0 0 Freight Amount
c_invoiceline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline linetotalamt numeric 0  √  0 Total line amount incl. Tax
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
c_uom_conversion multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
c_invoiceline priceactual numeric 0 0 Actual Price
c_orderline priceactual numeric 0 0 Actual Price
c_orderline pricecost numeric 0  √  null Price per Unit of Measure including all indirect costs (Freight, etc.)
c_invoiceline priceentered numeric 0 Price Entered - the price based on the selected/base UoM
c_orderline priceentered numeric 0 Price Entered - the price based on the selected/base UoM
c_invoiceline pricelimit numeric 0 0 Lowest price for a product
c_orderline pricelimit numeric 0 0 Lowest price for a product
c_invoiceline pricelist numeric 0 0 List Price
c_orderline pricelist numeric 0 0 List Price
c_orderline qtydelivered numeric 0 0 Delivered Quantity
c_invoiceline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
c_orderline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
m_inoutline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
c_invoiceline qtyinvoiced numeric 0 0 Invoiced Quantity
c_orderline qtyinvoiced numeric 0 0 Invoiced Quantity
c_orderline qtylostsales numeric 0 0 Quantity of potential sales
c_orderline qtyordered numeric 0 0 Ordered Quantity
m_inoutline qtyoverreceipt numeric 0  √  0 Over Receipt Quantity
c_orderline qtyreserved numeric 0 0 Reserved Quantity
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
c_orderline rramt numeric 0  √  null Revenue Recognition Amount
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_product shelfheight numeric 0  √  null Shelf height required
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
c_invoiceline a_asset_group_id numeric 10  √  null Group of Assets
c_invoiceline a_asset_id numeric 10  √  null Asset used internally or by customers
c_invoiceline ad_client_id numeric 10 Client/Tenant for this installation.
c_orderline ad_client_id numeric 10 Client/Tenant for this installation.
c_uom ad_client_id numeric 10 Client/Tenant for this installation.
c_uom_conversion ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutline ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceline ad_org_id numeric 10 Organizational entity within client
c_orderline ad_org_id numeric 10 Organizational entity within client
c_uom ad_org_id numeric 10 Organizational entity within client
c_uom_conversion ad_org_id numeric 10 Organizational entity within client
m_inoutline ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
c_invoiceline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_orderline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric 1099 Box
c_invoiceline c_activity_id numeric 10  √  null Business Activity
c_orderline c_activity_id numeric 10  √  null Business Activity
m_inoutline c_activity_id numeric 10  √  null Business Activity
c_orderline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_orderline c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_invoiceline c_campaign_id numeric 10  √  null Marketing Campaign
c_orderline c_campaign_id numeric 10  √  null Marketing Campaign
m_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
c_invoiceline c_charge_id numeric 10  √  null Additional document charges
c_orderline c_charge_id numeric 10  √  null Additional document charges
m_inoutline c_charge_id numeric 10  √  null Additional document charges
c_orderline c_currency_id numeric 10 The Currency for this record
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
c_orderline c_order_id numeric 10 Order
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
c_orderline c_orderline_id numeric 10 Sales Order Line
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
c_invoiceline c_project_id numeric 10  √  null Financial Project
c_orderline c_project_id numeric 10  √  null Financial Project
m_inoutline c_project_id numeric 10  √  null Financial Project
c_invoiceline c_projectphase_id numeric 10  √  null Phase of a Project
c_orderline c_projectphase_id numeric 10  √  null Phase of a Project
m_inoutline c_projectphase_id numeric 10  √  null Phase of a Project
c_invoiceline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_orderline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
m_inoutline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_invoiceline c_tax_id numeric 10  √  null Tax identifier
c_orderline c_tax_id numeric 10 Tax identifier
m_product c_taxcategory_id numeric 10 Tax Category
c_uom_conversion c_uom_conversion_id numeric 10 Unit of Measure Conversion
c_invoiceline c_uom_id numeric 10  √  null Unit of Measure
c_orderline c_uom_id numeric 10 Unit of Measure
c_uom c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_id numeric 10 Unit of Measure
m_inoutline c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_to_id numeric 10 Target or destination Unit of Measure
c_uom costingprecision numeric 10 Rounding used costing calculations
c_invoiceline createdby numeric 10 User who created this records
c_orderline createdby numeric 10 User who created this records
c_uom createdby numeric 10 User who created this records
c_uom_conversion createdby numeric 10 User who created this records
m_inoutline createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
c_invoiceline line numeric 10 Unique line for this document
c_orderline line numeric 10 Unique line for this document
m_inoutline line numeric 10 Unique line for this document
c_orderline link_orderline_id numeric 10  √  null This field links a sales order line to the purchase order line that is generated from it.
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_orderline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_inoutline m_inout_id numeric 10 Material Shipment Document
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_inoutline m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_inoutline m_locator_id numeric 10  √  null Warehouse Locator
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_product m_product_category_id numeric 10 Category of a Product
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
c_orderline m_product_id numeric 10  √  null Product, Service, Item
c_uom_conversion m_product_id numeric 10  √  null Product, Service, Item
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
c_orderline m_promotion_id numeric 10  √  null Promotion
c_invoiceline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inoutline m_rmaline_id numeric 10  √  null Return Material Authorization Line
c_orderline m_shipper_id numeric 10  √  null Method or manner of product delivery
c_orderline m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_orderline pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_inoutline ref_inoutline_id numeric 10  √  null Referenced Shipment Line
c_invoiceline ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
c_orderline ref_orderline_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
c_invoiceline s_resourceassignment_id numeric 10  √  null Resource Assignment
c_orderline s_resourceassignment_id numeric 10  √  null Resource Assignment
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfwidth numeric 10  √  null Shelf width required
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
c_invoiceline updatedby numeric 10 User who updated this records
c_orderline updatedby numeric 10 User who updated this records
c_uom updatedby numeric 10 User who updated this records
c_uom_conversion updatedby numeric 10 User who updated this records
m_inoutline updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
c_invoiceline user1_id numeric 10  √  null User defined list element #1
c_orderline user1_id numeric 10  √  null User defined list element #1
m_inoutline user1_id numeric 10  √  null User defined list element #1
c_invoiceline user2_id numeric 10  √  null User defined list element #2
c_orderline user2_id numeric 10  √  null User defined list element #2
m_inoutline user2_id numeric 10  √  null User defined list element #2
c_invoiceline created timestamp 29,6 now() Date this record was created
c_orderline created timestamp 29,6 now() Date this record was created
c_uom created timestamp 29,6 now() Date this record was created
c_uom_conversion created timestamp 29,6 now() Date this record was created
m_inoutline created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
c_orderline datedelivered timestamp 29,6  √  null Date when the product was delivered
c_orderline dateinvoiced timestamp 29,6  √  null Date printed on Invoice
c_orderline dateordered timestamp 29,6 Date of Order
c_orderline datepromised timestamp 29,6  √  null Date Order was promised
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_invoiceline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_orderline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_invoiceline updated timestamp 29,6 now() Date this record was updated
c_orderline updated timestamp 29,6 now() Date this record was updated
c_uom updated timestamp 29,6 now() Date this record was updated
c_uom_conversion updated timestamp 29,6 now() Date this record was updated
m_inoutline updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
c_invoiceline a_capvsexp varchar 3  √  null Capital/Expense
c_uom x12de355 varchar 4 UOM EDI X12 Code
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_product versionno varchar 20  √  null Version Number
m_product sku varchar 30  √  null Stock Keeping Unit
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_UU
c_orderline c_orderline_uu varchar 36  √  NULL::character varying C_OrderLine_UU
c_uom_conversion c_uom_conversion_uu varchar 36  √  NULL::character varying C_UOM_Conversion_UU
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying M_InOutLine_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_product value varchar 40 Search key for the record in the format required - must be unique
c_uom name varchar 60 Alphanumeric identifier of the entity
m_product descriptionurl varchar 120  √  null URL for the description
m_product downloadurl varchar 120  √  null
m_product imageurl varchar 120  √  null URL of image
c_invoiceline description varchar 255  √  null Optional short description of the record
c_orderline description varchar 255  √  null Optional short description of the record
c_uom description varchar 255  √  null Optional short description of the record
m_inoutline description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
m_product name varchar 255 Alphanumeric identifier of the entity
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product help varchar 2000  √  null Comment or Hint