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

idempiere9.adempiere contains 1202 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_invoiceline a_asset_group_id numeric 10  √  null Group of Assets
m_product_category 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 a_capvsexp varchar 3  √  null Capital/Expense
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar Create Asset
c_invoiceline a_processed bpchar 1  √  'N'::bpchar Processed
c_acctschema ad_client_id numeric 10 Client/Tenant for this installation.
c_allocationline ad_client_id numeric 10 Client/Tenant for this installation.
c_invoice ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceline ad_client_id numeric 10 Client/Tenant for this installation.
c_landedcost ad_client_id numeric 10 Client/Tenant for this installation.
c_landedcostallocation ad_client_id numeric 10 Client/Tenant for this installation.
c_order ad_client_id numeric 10 Client/Tenant for this installation.
c_orderlandedcost ad_client_id numeric 10 Client/Tenant for this installation.
c_orderlandedcostallocation ad_client_id numeric 10 Client/Tenant for this installation.
c_orderline ad_client_id numeric 10 Client/Tenant for this installation.
c_projectissue ad_client_id numeric 10 Client/Tenant for this installation.
c_projectissuema ad_client_id numeric 10 Client/Tenant for this installation.
m_attributesetinstance ad_client_id numeric 10 Client/Tenant for this installation.
m_cost ad_client_id numeric 10 Client/Tenant for this installation.
m_costdetail ad_client_id numeric 10 Client/Tenant for this installation.
m_costelement ad_client_id numeric 10 Client/Tenant for this installation.
m_costhistory ad_client_id numeric 10 Client/Tenant for this installation.
m_costmovement_v ad_client_id numeric 10  √  null Client/Tenant for this installation.
m_costqueue ad_client_id numeric 10 Client/Tenant for this installation.
m_costtype ad_client_id numeric 10 Client/Tenant for this installation.
m_inout ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutline ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutlinema ad_client_id numeric 10 Client/Tenant for this installation.
m_inventoryline ad_client_id numeric 10 Client/Tenant for this installation.
m_inventorylinema ad_client_id numeric 10 Client/Tenant for this installation.
m_locator ad_client_id numeric 10 Client/Tenant for this installation.
m_matchinv ad_client_id numeric 10 Client/Tenant for this installation.
m_matchpo ad_client_id numeric 10 Client/Tenant for this installation.
m_movementline ad_client_id numeric 10 Client/Tenant for this installation.
m_movementlinema ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product_acct ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category_acct ad_client_id numeric 10 Client/Tenant for this installation.
m_product_po ad_client_id numeric 10 Client/Tenant for this installation.
m_productionline ad_client_id numeric 10 Client/Tenant for this installation.
m_productionlinema ad_client_id numeric 10 Client/Tenant for this installation.
m_transaction ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse_acct ad_client_id numeric 10 Client/Tenant for this installation.
s_resource ad_client_id numeric 10 Client/Tenant for this installation.
t_inventoryvalue ad_client_id numeric 10  √  null Client/Tenant for this installation.
c_acctschema ad_org_id numeric 10 Organizational entity within client
c_allocationline ad_org_id numeric 10 Organizational entity within client
c_invoice ad_org_id numeric 10 Organizational entity within client
c_invoiceline ad_org_id numeric 10 Organizational entity within client
c_landedcost ad_org_id numeric 10 Organizational entity within client
c_landedcostallocation ad_org_id numeric 10 Organizational entity within client
c_order ad_org_id numeric 10 Organizational entity within client
c_orderlandedcost ad_org_id numeric 10 Organizational entity within client
c_orderlandedcostallocation ad_org_id numeric 10 Organizational entity within client
c_orderline ad_org_id numeric 10 Organizational entity within client
c_projectissue ad_org_id numeric 10 Organizational entity within client
c_projectissuema ad_org_id numeric 10 Organizational entity within client
m_attributesetinstance ad_org_id numeric 10 Organizational entity within client
m_cost ad_org_id numeric 10 Organizational entity within client
m_costdetail ad_org_id numeric 10 Organizational entity within client
m_costelement ad_org_id numeric 10 Organizational entity within client
m_costhistory ad_org_id numeric 10 Organizational entity within client
m_costmovement_v ad_org_id numeric 10  √  null Organizational entity within client
m_costqueue ad_org_id numeric 10 Organizational entity within client
m_costtype ad_org_id numeric 10 Organizational entity within client
m_inout ad_org_id numeric 10 Organizational entity within client
m_inoutline ad_org_id numeric 10 Organizational entity within client
m_inoutlinema ad_org_id numeric 10 Organizational entity within client
m_inventoryline ad_org_id numeric 10 Organizational entity within client
m_inventorylinema ad_org_id numeric 10 Organizational entity within client
m_locator ad_org_id numeric 10 Organizational entity within client
m_matchinv ad_org_id numeric 10 Organizational entity within client
m_matchpo ad_org_id numeric 10 Organizational entity within client
m_movementline ad_org_id numeric 10 Organizational entity within client
m_movementlinema ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_product_acct ad_org_id numeric 10 Organizational entity within client
m_product_category ad_org_id numeric 10 Organizational entity within client
m_product_category_acct ad_org_id numeric 10 Organizational entity within client
m_product_po ad_org_id numeric 10 Organizational entity within client
m_productionline ad_org_id numeric 10 Organizational entity within client
m_productionlinema ad_org_id numeric 10 Organizational entity within client
m_transaction ad_org_id numeric 10 Organizational entity within client
m_warehouse ad_org_id numeric 10 Organizational entity within client
m_warehouse_acct ad_org_id numeric 10 Organizational entity within client
s_resource ad_org_id numeric 10 Organizational entity within client
t_inventoryvalue ad_org_id numeric 10  √  null Organizational entity within client
c_acctschema ad_orgonly_id numeric 10  √  null Create posting entries only for this organization
c_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoiceline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_order ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_orderline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inout ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
t_inventoryvalue ad_pinstance_id numeric 10 Instance of the process
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_order ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_inout ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
s_resource ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_allocationline allocationno numeric 10  √  null
c_allocationline amount numeric 0 0 Amount in a defined currency
c_order amountrefunded numeric 22,2  √  null AmountRefunded
c_order amounttendered numeric 22,2  √  null AmountTendered
c_landedcostallocation amt numeric 0 0 Amount
c_orderlandedcost amt numeric 0 (0)::numeric Amount
c_orderlandedcostallocation amt numeric 0 Amount
m_costdetail amt numeric 0 0 Amount
m_costmovement_v amt numeric 0  √  null Amount
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
c_landedcostallocation base numeric 0 0 Calculation Base
c_orderlandedcostallocation base numeric 0 Calculation Base
c_order bill_bpartner_id numeric 10  √  null Business Partner to be invoiced
c_order bill_location_id numeric 10  √  null Business Partner Location for invoicing
c_order bill_user_id numeric 10  √  null Business Partner Contact for invoicing
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric 1099 Box
c_acctschema c_acctschema_id numeric 10 Rules for accounting
m_cost c_acctschema_id numeric 10 Rules for accounting
m_costdetail c_acctschema_id numeric 10 Rules for accounting
m_costmovement_v c_acctschema_id numeric 10  √  null Rules for accounting
m_costqueue c_acctschema_id numeric 10 Rules for accounting
m_product_acct c_acctschema_id numeric 10 Rules for accounting
m_product_category_acct c_acctschema_id numeric 10 Rules for accounting
m_warehouse_acct c_acctschema_id numeric 10 Rules for accounting
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying C_AcctSchema_UU
c_invoice c_activity_id numeric 10  √  null Business Activity
c_invoiceline c_activity_id numeric 10  √  null Business Activity
c_order c_activity_id numeric 10  √  null Business Activity
c_orderline c_activity_id numeric 10  √  null Business Activity
m_inout c_activity_id numeric 10  √  null Business Activity
m_inoutline c_activity_id numeric 10  √  null Business Activity
c_allocationline c_allocationhdr_id numeric 10 Payment allocation
c_allocationline c_allocationline_id numeric 10 Allocation Line
c_allocationline c_allocationline_uu varchar 36  √  NULL::character varying C_AllocationLine_UU
c_allocationline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_invoice c_bpartner_id numeric 10 Identifies a Business Partner
c_order c_bpartner_id numeric 10 Identifies a Business Partner
c_orderline c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_inout c_bpartner_id numeric 10 Identifies a Business Partner
m_product_po c_bpartner_id numeric 10 Identifies a Business Partner
c_invoice c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_order c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_orderline c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
m_inout c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_invoiceline c_campaign_id numeric 10  √  null Marketing Campaign
c_order c_campaign_id numeric 10  √  null Marketing Campaign
c_orderline c_campaign_id numeric 10  √  null Marketing Campaign
m_inout c_campaign_id numeric 10  √  null Marketing Campaign
m_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
c_allocationline c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_order c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_order c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_allocationline c_charge_id numeric 10  √  NULL::numeric Additional document charges
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_invoiceline c_charge_id numeric 10  √  null Additional document charges
c_order c_charge_id numeric 10  √  null Additional document charges
c_orderline c_charge_id numeric 10  √  null Additional document charges
m_inout c_charge_id numeric 10  √  null Additional document charges
m_inoutline c_charge_id numeric 10  √  null Additional document charges
m_inventoryline c_charge_id numeric 10  √  null Additional document charges
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_order c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_acctschema c_currency_id numeric 10 The Currency for this record
c_invoice c_currency_id numeric 10 The Currency for this record
c_order c_currency_id numeric 10 The Currency for this record
c_orderline c_currency_id numeric 10 The Currency for this record
m_product_po c_currency_id numeric 10  √  null The Currency for this record
t_inventoryvalue c_currency_id numeric 10  √  null The Currency for this record
c_invoice c_doctype_id numeric 10 Document type or rules
c_order c_doctype_id numeric 10 Document type or rules
m_inout c_doctype_id numeric 10 Document type or rules
c_invoice c_doctypetarget_id numeric 10 Target document type for conversing documents
c_order c_doctypetarget_id numeric 10 Target document type for conversing documents
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_allocationline c_invoice_id numeric 10  √  null Invoice Identifier
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
m_inout c_invoice_id numeric 10  √  null Invoice Identifier
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
c_landedcost c_invoiceline_id numeric 10 Invoice Detail Line
c_landedcostallocation c_invoiceline_id numeric 10 Invoice Detail Line
m_costdetail c_invoiceline_id numeric 10  √  null Invoice Detail Line
m_costmovement_v c_invoiceline_id numeric 10  √  null Invoice Detail Line
m_matchinv c_invoiceline_id numeric 10 Invoice Detail Line
m_matchpo c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_UU
c_landedcost c_landedcost_id numeric 10 Landed cost to be allocated to material receipts
c_landedcost c_landedcost_uu varchar 36  √  NULL::character varying C_LandedCost_UU
c_landedcostallocation c_landedcostallocation_id numeric 10 Allocation for Land Costs
c_landedcostallocation c_landedcostallocation_uu varchar 36  √  NULL::character varying C_LandedCostAllocation_UU
m_warehouse c_location_id numeric 10 Location or Address
c_order c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_allocationline c_order_id numeric 10  √  null Order
c_invoice c_order_id numeric 10  √  null Order
c_order c_order_id numeric 10 Order
c_orderlandedcost c_order_id numeric 10 Order
c_orderline c_order_id numeric 10 Order
m_inout c_order_id numeric 10  √  null Order
c_order c_order_uu varchar 36  √  NULL::character varying C_Order_UU
c_orderlandedcost c_orderlandedcost_id numeric 10 Estimated Landed Cost
c_orderlandedcostallocation c_orderlandedcost_id numeric 10 Estimated Landed Cost
c_orderlandedcost c_orderlandedcost_uu varchar 36  √  NULL::character varying C_OrderLandedCost_UU
c_orderlandedcostallocation c_orderlandedcostallocation_id numeric 10 Estimated Landed Cost Allocation
c_orderlandedcostallocation c_orderlandedcostallocation_uu varchar 36  √  NULL::character varying C_OrderLandedCostAllocation_UU
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
c_orderlandedcostallocation c_orderline_id numeric 10 Sales Order Line
c_orderline c_orderline_id numeric 10 Sales Order Line
m_costdetail c_orderline_id numeric 10  √  null Sales Order Line
m_costmovement_v c_orderline_id numeric 10  √  null Sales Order Line
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
m_matchpo c_orderline_id numeric 10 Sales Order Line
c_orderline c_orderline_uu varchar 36  √  NULL::character varying C_OrderLine_UU
c_order c_ordersource_id numeric 10  √  null Order Source
c_allocationline c_payment_id numeric 10  √  null Payment identifier
c_invoice c_payment_id numeric 10  √  null Payment identifier
c_order c_payment_id numeric 10  √  null Payment identifier
c_invoice c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_order c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_acctschema c_period_id numeric 10  √  null Period of the Calendar
c_order c_pos_id numeric 10  √  null Point of Sales Terminal
c_invoice c_project_id numeric 10  √  null Financial Project
c_invoiceline c_project_id numeric 10  √  null Financial Project
c_order c_project_id numeric 10  √  null Financial Project
c_orderline c_project_id numeric 10  √  null Financial Project
c_projectissue c_project_id numeric 10 Financial Project
m_inout c_project_id numeric 10  √  null Financial Project
m_inoutline c_project_id numeric 10  √  null Financial Project
c_projectissue c_projectissue_id numeric 10 Project Issues (Material, Labor)
c_projectissuema c_projectissue_id numeric 10 Project Issues (Material, Labor)
m_costdetail c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
m_costmovement_v c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
m_transaction c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
c_projectissue c_projectissue_uu varchar 36  √  NULL::character varying C_ProjectIssue_UU
c_projectissuema c_projectissuema_uu varchar 36  √  NULL::character varying C_ProjectIssueMA_UU
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_invoiceline c_uom_id numeric 10  √  null Unit of Measure
c_orderline 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
m_product_po c_uom_id numeric 10  √  null Unit of Measure
s_resource chargeableqty numeric 0  √  0 Chargeable Quantity
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_order chargeamt numeric 0  √  0 Charge Amount
m_inout chargeamt numeric 0  √  0 Charge Amount
m_product classification varchar 12  √  null Classification for grouping
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
m_movementline confirmedqty numeric 0  √  0 Confirmation of a received quantity
c_invoice copyfrom bpchar 1  √  null Copy From Record
c_order copyfrom bpchar 1  √  null Copy From Record
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
t_inventoryvalue cost numeric 0  √  0 Cost information
t_inventoryvalue costamt numeric 0  √  0 Value with Cost
m_costelement costelementtype bpchar 1 Type of Cost Element
c_acctschema costinglevel bpchar 1 'C'::bpchar The lowest level to accumulate Costing Information
m_product_category_acct costinglevel bpchar 1  √  null The lowest level to accumulate Costing Information
c_acctschema costingmethod bpchar 1 Indicates how Costs will be calculated
m_costelement costingmethod bpchar 1  √  null Indicates how Costs will be calculated
m_product_category_acct costingmethod bpchar 1  √  null Indicates how Costs will be calculated
m_product_po costperorder numeric 0  √  0 Fixed Cost Per Order
t_inventoryvalue coststandard numeric 0  √  0 Standard Costs
t_inventoryvalue coststandardamt numeric 0  √  0 Value in Standard Costs
m_inout createconfirm bpchar 1  √  null Create Confirm
c_acctschema created timestamp 29,6 now() Date this record was created
c_allocationline created timestamp 29,6 now() Date this record was created
c_invoice created timestamp 29,6 now() Date this record was created
c_invoiceline created timestamp 29,6 now() Date this record was created
c_landedcost created timestamp 29,6 now() Date this record was created
c_landedcostallocation created timestamp 29,6 now() Date this record was created
c_order created timestamp 29,6 now() Date this record was created
c_orderlandedcost created timestamp 29,6 statement_timestamp() Date this record was created
c_orderlandedcostallocation created timestamp 29,6 statement_timestamp() Date this record was created
c_orderline created timestamp 29,6 now() Date this record was created
c_projectissue created timestamp 29,6 now() Date this record was created
c_projectissuema created timestamp 29,6 now() Date this record was created
m_attributesetinstance created timestamp 29,6 now() Date this record was created
m_cost created timestamp 29,6 now() Date this record was created
m_costdetail created timestamp 29,6 now() Date this record was created
m_costelement created timestamp 29,6 now() Date this record was created
m_costhistory created timestamp 29,6 statement_timestamp() Date this record was created
m_costmovement_v created timestamp 29,6  √  null Date this record was created
m_costqueue created timestamp 29,6 now() Date this record was created
m_costtype created timestamp 29,6 now() Date this record was created
m_inout created timestamp 29,6 now() Date this record was created
m_inoutline created timestamp 29,6 now() Date this record was created
m_inoutlinema created timestamp 29,6 now() Date this record was created
m_inventoryline created timestamp 29,6 now() Date this record was created
m_inventorylinema created timestamp 29,6 now() Date this record was created
m_locator created timestamp 29,6 now() Date this record was created
m_matchinv created timestamp 29,6 now() Date this record was created
m_matchpo created timestamp 29,6 now() Date this record was created
m_movementline created timestamp 29,6 now() Date this record was created
m_movementlinema created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_product_acct created timestamp 29,6 now() Date this record was created
m_product_category created timestamp 29,6 now() Date this record was created
m_product_category_acct created timestamp 29,6 now() Date this record was created
m_product_po created timestamp 29,6 now() Date this record was created
m_productionline created timestamp 29,6 now() Date this record was created
m_productionlinema created timestamp 29,6 now() Date this record was created
m_transaction created timestamp 29,6 now() Date this record was created
m_warehouse created timestamp 29,6 now() Date this record was created
m_warehouse_acct created timestamp 29,6 now() Date this record was created
s_resource created timestamp 29,6 now() Date this record was created
c_acctschema createdby numeric 10 User who created this records
c_allocationline createdby numeric 10 User who created this records
c_invoice createdby numeric 10 User who created this records
c_invoiceline createdby numeric 10 User who created this records
c_landedcost createdby numeric 10 User who created this records
c_landedcostallocation createdby numeric 10 User who created this records
c_order createdby numeric 10 User who created this records
c_orderlandedcost createdby numeric 10 User who created this records
c_orderlandedcostallocation createdby numeric 10 User who created this records
c_orderline createdby numeric 10 User who created this records
c_projectissue createdby numeric 10 User who created this records
c_projectissuema createdby numeric 10 User who created this records
m_attributesetinstance createdby numeric 10 User who created this records
m_cost createdby numeric 10 User who created this records
m_costdetail createdby numeric 10 User who created this records
m_costelement createdby numeric 10 User who created this records
m_costhistory createdby numeric 10 User who created this records
m_costmovement_v createdby numeric 10  √  null User who created this records
m_costqueue createdby numeric 10 User who created this records
m_costtype createdby numeric 10 User who created this records
m_inout createdby numeric 10 User who created this records
m_inoutline createdby numeric 10 User who created this records
m_inoutlinema createdby numeric 10 User who created this records
m_inventoryline createdby numeric 10 User who created this records
m_inventorylinema createdby numeric 10 User who created this records
m_locator createdby numeric 10 User who created this records
m_matchinv createdby numeric 10 User who created this records
m_matchpo createdby numeric 10 User who created this records
m_movementline createdby numeric 10 User who created this records
m_movementlinema createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product_acct createdby numeric 10 User who created this records
m_product_category createdby numeric 10 User who created this records
m_product_category_acct createdby numeric 10 User who created this records
m_product_po createdby numeric 10 User who created this records
m_productionline createdby numeric 10 User who created this records
m_productionlinema createdby numeric 10 User who created this records
m_transaction createdby numeric 10 User who created this records
m_warehouse createdby numeric 10 User who created this records
m_warehouse_acct createdby numeric 10 User who created this records
s_resource createdby numeric 10 User who created this records
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createpackage bpchar 1  √  null Create Package
c_orderline createproduction bpchar 1  √  'N'::bpchar Create Production
c_orderline createshipment bpchar 1  √  'N'::bpchar Create Shipment
m_cost cumulatedamt numeric 0  √  0 Total Amount
m_costdetail cumulatedamt numeric 0  √  null Total Amount
m_cost cumulatedqty numeric 0  √  0 Total Quantity
m_costdetail cumulatedqty numeric 0  √  null Total Quantity
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
m_cost currentcostprice numeric 0 The currently used cost price
m_costdetail currentcostprice numeric 0  √  null The currently used cost price
m_costqueue currentcostprice numeric 0 0 The currently used cost price
m_inventoryline currentcostprice numeric 0  √  (0)::numeric The currently used cost price
m_cost currentcostpricell numeric 0  √  0 Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
m_cost currentqty numeric 0 0 Current Quantity
m_costdetail currentqty numeric 0  √  null Current Quantity
m_costqueue currentqty numeric 0 0 Current Quantity
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
s_resource dailycapacity numeric 0  √  null Daily Capacity
c_invoice dateacct timestamp 29,6 Accounting Date
c_order dateacct timestamp 29,6 Accounting Date
m_inout dateacct timestamp 29,6 Accounting Date
m_matchinv dateacct timestamp 29,6  √  null Accounting Date
m_matchpo dateacct timestamp 29,6  √  null Accounting Date
c_orderline datedelivered timestamp 29,6  √  null Date when the product was delivered
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_orderline dateinvoiced timestamp 29,6  √  null Date printed on Invoice
m_inoutlinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_inventorylinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_movementlinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
m_productionlinema datematerialpolicy timestamp 29,6 Time used for LIFO and FIFO Material Policy
c_invoice dateordered timestamp 29,6  √  null Date of Order
c_order dateordered timestamp 29,6 Date of Order
c_orderline dateordered timestamp 29,6 Date of Order
m_inout dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
c_order dateprinted timestamp 29,6  √  null Date the document was printed.
m_inout dateprinted timestamp 29,6  √  null Date the document was printed.
c_order datepromised timestamp 29,6  √  null Date Order was promised
c_orderline datepromised timestamp 29,6  √  null Date Order was promised
m_inout datereceived timestamp 29,6  √  null Date a product was received
c_allocationline datetrx timestamp 29,6  √  null Transaction Date
m_matchinv datetrx timestamp 29,6 Transaction Date
m_matchpo datetrx timestamp 29,6 Transaction Date
t_inventoryvalue datevalue timestamp 29,6  √  null Date of valuation
m_movementline dd_orderline_id numeric 10  √  null Distribution Order Line
c_order deliveryrule bpchar 1 Defines the timing of Delivery
m_inout deliveryrule bpchar 1 Defines the timing of Delivery
m_product_po deliverytime_actual numeric 10  √  null Actual days between order and delivery
m_product_po deliverytime_promised numeric 10  √  null Promised days between order and delivery
c_order deliveryviarule bpchar 1 How the order will be delivered
m_inout deliveryviarule bpchar 1 How the order will be delivered
m_costdetail deltaamt numeric 0  √  0 Difference Amount
m_costmovement_v deltaamt numeric 0  √  null Difference Amount
m_costdetail deltaqty numeric 0  √  0 Quantity Difference
m_costmovement_v deltaqty numeric 0  √  null Quantity Difference
c_acctschema description varchar 255  √  null Optional short description of the record
c_invoice description varchar 255  √  null Optional short description of the record
c_invoiceline description varchar 255  √  null Optional short description of the record
c_landedcost description varchar 255  √  null Optional short description of the record
c_order description varchar 255  √  null Optional short description of the record
c_orderlandedcost description varchar 255  √  NULL::character varying Optional short description of the record
c_orderline description varchar 255  √  null Optional short description of the record
c_projectissue description varchar 255  √  null Optional short description of the record
m_attributesetinstance description varchar 255  √  null Optional short description of the record
m_cost description varchar 255  √  null Optional short description of the record
m_costdetail description varchar 255  √  null Optional short description of the record
m_costelement description varchar 255  √  null Optional short description of the record
m_costmovement_v description varchar 255  √  null Optional short description of the record
m_costtype description varchar 255  √  null Optional short description of the record
m_inout description varchar 255  √  null Optional short description of the record
m_inoutline description varchar 255  √  null Optional short description of the record
m_inventoryline description varchar 255  √  null Optional short description of the record
m_matchinv description varchar 255  √  null Optional short description of the record
m_matchpo description varchar 255  √  null Optional short description of the record
m_movementline description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_product_category description varchar 255  √  null Optional short description of the record
m_productionline description varchar 255  √  null Optional short description of the record
m_warehouse description varchar 255  √  null Optional short description of the record
s_resource description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product_po discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product_po discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product_po discontinuedby timestamp 29,6  √  null
c_orderline discount numeric 0  √  null Discount in percent
c_allocationline discountamt numeric 0 0 Calculated amount of discount
c_invoice docaction bpchar 2 The targeted status of the document
c_order docaction bpchar 2 The targeted status of the document
c_projectissue docaction bpchar 2 'CO'::bpchar The targeted status of the document
m_inout docaction bpchar 2 The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
c_order docstatus bpchar 2 The current status of the document
c_projectissue docstatus varchar 2 'DR'::character varying The current status of the document
m_inout docstatus bpchar 2 The current status of the document
c_invoice documentno varchar 30 Document sequence number of the document
c_order documentno varchar 30 Document sequence number of the document
m_inout documentno varchar 30 Document sequence number of the document
m_matchinv documentno varchar 30  √  null Document sequence number of the document
m_matchpo documentno varchar 30  √  null Document sequence number of the document
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
c_order dropship_bpartner_id numeric 10  √  null Business Partner to ship to
m_inout dropship_bpartner_id numeric 10  √  null Business Partner to ship to
c_order dropship_location_id numeric 10  √  null Business Partner Location for shipping to
m_inout dropship_location_id numeric 10  √  null Business Partner Location for shipping to
c_order dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
m_inout dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
m_inout fob varchar 10  √  NULL::character varying Freight Terms
c_order freightamt numeric 0  √  0 Freight Amount
c_orderline freightamt numeric 0 0 Freight Amount
m_inout freightamt numeric 0  √  0 Freight Amount
m_inout freightcharges varchar 10  √  NULL::character varying Freight Charges
c_order freightcostrule bpchar 1 Method for charging Freight
m_inout freightcostrule bpchar 1 Method for charging Freight
m_cost futurecostprice numeric 0  √  null Future Cost Price
m_cost futurecostpricell numeric 0  √  null Future Cost Price Lower Level
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
c_invoice generateto bpchar 1  √  null Generate To
m_inout generateto bpchar 1  √  null Generate To
c_invoice grandtotal numeric 0 0 Total amount of document
c_order grandtotal numeric 0 0 Total amount of document
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
m_attributesetinstance guaranteedate timestamp 29,6  √  null Date when guarantee expires
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_acctschema hasalias bpchar 1 'Y'::bpchar Ability to select (partial) account combinations by an Alias
c_acctschema hascombination bpchar 1 'Y'::bpchar Combination of account elements are checked
m_costtype help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
m_inout insurance bpchar 1  √  NULL::bpchar Insurance
m_inventoryline inventorytype bpchar 1 'D'::bpchar Type of inventory difference
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_order invoicerule bpchar 1 Frequency and method of invoicing
c_acctschema isaccrual bpchar 1 'Y'::bpchar Indicates if Accrual or Cash Based accounting will be used
c_acctschema isactive bpchar 1 'Y'::bpchar The record is active in the system
c_allocationline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoice isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoiceline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_order isactive bpchar 1 'Y'::bpchar The record is active in the system
c_orderlandedcost isactive bpchar 1 'Y'::bpchar The record is active in the system
c_orderlandedcostallocation 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_projectissue isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectissuema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_attributesetinstance isactive bpchar 1 'Y'::bpchar The record is active in the system
m_cost isactive bpchar 1 'Y'::bpchar The record is active in the system
m_costdetail isactive bpchar 1 'Y'::bpchar The record is active in the system
m_costelement isactive bpchar 1 'Y'::bpchar The record is active in the system
m_costhistory isactive bpchar 1 'Y'::bpchar The record is active in the system
m_costmovement_v isactive bpchar 1  √  null The record is active in the system
m_costqueue isactive bpchar 1 'Y'::bpchar The record is active in the system
m_costtype isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout 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_inoutlinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventoryline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inventorylinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_locator isactive bpchar 1 'Y'::bpchar The record is active in the system
m_matchinv isactive bpchar 1 'Y'::bpchar The record is active in the system
m_matchpo isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_movementlinema 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_product_acct isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category_acct isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_po isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productionline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productionlinema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_transaction isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse_acct isactive bpchar 1 'Y'::bpchar The record is active in the system
s_resource isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
c_invoice isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_order isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_projectissue isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inout isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_matchpo isapproved bpchar 1  √  'Y'::bpchar Indicates if this document requires approval
m_inoutlinema isautogenerated bpchar 1  √  'N'::bpchar Auto Generated
m_inventorylinema isautogenerated bpchar 1  √  'N'::bpchar Auto Generated
m_movementlinema isautogenerated bpchar 1  √  'N'::bpchar Auto Generated
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
s_resource isavailable bpchar 1 'Y'::bpchar Resource is available
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_costelement iscalculated bpchar 1 'N'::bpchar The value is calculated by the system
m_cost iscostfrozen bpchar 1  √  'N'::bpchar Indicated that the Standard Cost is frozen
c_order iscreditapproved bpchar 1 'N'::bpchar Credit has been approved
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar Use this Vendor for pricing and stock replenishment
m_locator isdefault bpchar 1 'N'::bpchar Default value
m_product_category isdefault bpchar 1 'N'::bpchar Default value
c_order isdelivered bpchar 1 'N'::bpchar Delivered
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_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar Correct the tax for payment discount and charges
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_order isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_order isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_inout isdropship bpchar 1  √  'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_productionline isendproduct bpchar 1  √  NULL::bpchar End Product of production
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar Post the cost adjustment explicitly
c_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isintransit bpchar 1 'N'::bpchar Movement is in transit
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
c_order isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
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
c_allocationline ismanual bpchar 1  √  'N'::bpchar This is a manual process
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
s_resource ismanufacturingresource bpchar 1  √  'N'::bpchar Manufacturing Resource
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
m_product isownbox bpchar 1 'N'::bpchar Own Box
c_invoice ispaid bpchar 1 'N'::bpchar The document is paid
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
c_order ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
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_acctschema ispostifclearingequal bpchar 1  √  'Y'::bpchar This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema ispostservices bpchar 1 'N'::bpchar Differentiate between Services and Product Receivable/Payables
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_invoiceline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
c_order isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
m_inout isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_order ispriviledgedrate bpchar 1 'N'::bpchar Priviledged Rate
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
c_order isselected bpchar 1 'N'::bpchar Selected
c_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_order isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category 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
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_order issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_costdetail issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_inout issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_order istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_product istoformule bpchar 1  √  null
c_acctschema istradediscountposted bpchar 1 'N'::bpchar Generate postings for trade discounts
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_order istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
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_landedcost landedcostdistribution bpchar 1 Landed Cost Distribution
c_orderlandedcost landedcostdistribution bpchar 1 'Q'::bpchar Landed Cost Distribution
c_invoiceline line numeric 10 Unique line for this document
c_orderline line numeric 10 Unique line for this document
c_projectissue line numeric 10 Unique line for this document
m_inoutline line numeric 10 Unique line for this document
m_inventoryline line numeric 10  √  null Unique line for this document
m_movementline line numeric 10  √  null Unique line for this document
m_productionline line numeric 10 Unique line for this document
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
c_order link_order_id numeric 10  √  null This field links a sales order to the purchase order that is generated from it.
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_attributesetinstance lot varchar 40  √  null Lot number (alphanumeric)
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_attributesetinstance m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_landedcostallocation m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
c_orderline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_projectissue m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_projectissuema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_attributesetinstance m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_cost m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_costdetail m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_costhistory m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_costmovement_v m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_costqueue m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inoutlinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_inventoryline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inventorylinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_matchinv m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_matchpo m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_movementline m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_movementlinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_productionline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_productionlinema m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_transaction m_attributesetinstance_id numeric 10 0 Product Attribute Set Instance
t_inventoryvalue m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_attributesetinstance m_attributesetinstance_uu varchar 36  √  NULL::character varying M_AttributeSetInstance_UU
m_movementline m_attributesetinstanceto_id numeric 10  √  null Target Product Attribute Set Instance
m_cost m_cost_uu varchar 36  √  NULL::character varying M_Cost_UU
m_costdetail m_costdetail_id numeric 10 Cost Detail Information
m_costhistory m_costdetail_id numeric 10 Cost Detail Information
m_costmovement_v m_costdetail_id numeric 10  √  null Cost Detail Information
m_costdetail m_costdetail_uu varchar 36  √  NULL::character varying M_CostDetail_UU
c_landedcost m_costelement_id numeric 10 Product Cost Element
c_landedcostallocation m_costelement_id numeric 10 Product Cost Element
c_orderlandedcost m_costelement_id numeric 10 Product Cost Element
m_cost m_costelement_id numeric 10 Product Cost Element
m_costdetail m_costelement_id numeric 10  √  null Product Cost Element
m_costelement m_costelement_id numeric 10 Product Cost Element
m_costhistory m_costelement_id numeric 10 Product Cost Element
m_costmovement_v m_costelement_id numeric 10  √  null Product Cost Element
m_costqueue m_costelement_id numeric 10 Product Cost Element
t_inventoryvalue m_costelement_id numeric 10  √  null Product Cost Element
m_costelement m_costelement_uu varchar 36  √  NULL::character varying M_CostElement_UU
m_costhistory m_costhistory_id numeric 10 Movement history for M_Cost
m_costmovement_v m_costhistory_id numeric 10  √  null Movement history for M_Cost
m_costhistory m_costhistory_uu varchar 36 Cost History UUID
m_costqueue m_costqueue_id numeric 10 FiFo/LiFo Cost Queue
m_costqueue m_costqueue_uu varchar 36  √  NULL::character varying M_CostQueue_UU
c_acctschema m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
m_cost m_costtype_id numeric 10 Type of Cost (e.g. Current, Plan, Future)
m_costhistory m_costtype_id numeric 10 Type of Cost (e.g. Current, Plan, Future)
m_costmovement_v m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
m_costqueue m_costtype_id numeric 10 Type of Cost (e.g. Current, Plan, Future)
m_costtype m_costtype_id numeric 10 Type of Cost (e.g. Current, Plan, Future)
m_costtype m_costtype_uu varchar 36  √  NULL::character varying M_CostType_UU
c_order m_freightcategory_id numeric 10  √  NULL::numeric Category of the Freight
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
c_landedcost m_inout_id numeric 10  √  null Material Shipment Document
m_inout m_inout_id numeric 10 Material Shipment Document
m_inoutline m_inout_id numeric 10 Material Shipment Document
m_inout m_inout_uu varchar 36  √  NULL::character varying M_InOut_UU
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_landedcost m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_landedcostallocation m_inoutline_id numeric 10  √  NULL::numeric Line on Shipment or Receipt document
c_projectissue m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_costdetail m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_costmovement_v 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_inoutlinema m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_matchinv m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_matchpo m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_transaction m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying M_InOutLine_UU
m_inoutlinema m_inoutlinema_uu varchar 36  √  NULL::character varying M_InOutLineMA_UU
m_inventoryline m_inventory_id numeric 10 Parameters for a Physical Inventory
m_costdetail m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_costmovement_v m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_inventoryline m_inventoryline_id numeric 10 Unique line in an Inventory document
m_inventorylinema m_inventoryline_id numeric 10 Unique line in an Inventory document
m_transaction m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_inventoryline m_inventoryline_uu varchar 36  √  NULL::character varying M_InventoryLine_UU
m_inventorylinema m_inventorylinema_uu varchar 36  √  NULL::character varying M_InventoryLineMA_UU
c_projectissue m_locator_id numeric 10 Warehouse Locator
m_inoutline m_locator_id numeric 10  √  null Warehouse Locator
m_inventoryline m_locator_id numeric 10  √  null Warehouse Locator
m_locator m_locator_id numeric 10 Warehouse Locator
m_movementline m_locator_id numeric 10 Warehouse Locator
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_productionline m_locator_id numeric 10 Warehouse Locator
m_transaction m_locator_id numeric 10 Warehouse Locator
m_locator m_locator_uu varchar 36  √  NULL::character varying M_Locator_UU
m_movementline m_locatorto_id numeric 10 Location inventory is moved to
m_locator m_locatortype_id numeric 10  √  NULL::numeric Locator Type
m_attributesetinstance m_lot_id numeric 10  √  null Product Lot Definition
m_costdetail m_matchinv_id numeric 10  √  NULL::numeric Match Shipment/Receipt to Invoice
m_costmovement_v m_matchinv_id numeric 10  √  null Match Shipment/Receipt to Invoice
m_matchinv m_matchinv_id numeric 10 Match Shipment/Receipt to Invoice
m_matchinv m_matchinv_uu varchar 36  √  NULL::character varying M_MatchInv_UU
m_matchpo m_matchpo_id numeric 10 Match Purchase Order to Shipment/Receipt and Invoice
m_matchpo m_matchpo_uu varchar 36  √  NULL::character varying M_MatchPO_UU
m_movementline m_movement_id numeric 10 Movement of Inventory
m_costdetail m_movementline_id numeric 10  √  null Inventory Move document Line
m_costmovement_v m_movementline_id numeric 10  √  null Inventory Move document Line
m_movementline m_movementline_id numeric 10 Inventory Move document Line
m_movementlinema m_movementline_id numeric 10 Inventory Move document Line
m_transaction m_movementline_id numeric 10  √  null Inventory Move document Line
m_movementline m_movementline_uu varchar 36  √  NULL::character varying M_MovementLine_UU
m_movementlinema m_movementlinema_uu varchar 36  √  NULL::character varying M_MovementLineMA_UU
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
c_order m_pricelist_id numeric 10 Unique identifier of a Price List
t_inventoryvalue m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_product_acct m_product_acct_uu varchar 36  √  NULL::character varying M_Product_Acct_UU
m_product_category_acct m_product_category_acct_uu varchar 36  √  NULL::character varying M_Product_Category_Acct_UU
m_product m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_id numeric 10 Category of a Product
m_product_category_acct m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
m_product_category m_product_category_uu varchar 36  √  NULL::character varying M_Product_Category_UU
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
c_landedcost m_product_id numeric 10  √  null Product, Service, Item
c_landedcostallocation m_product_id numeric 10 Product, Service, Item
c_orderline m_product_id numeric 10  √  null Product, Service, Item
c_projectissue m_product_id numeric 10 Product, Service, Item
m_cost m_product_id numeric 10 Product, Service, Item
m_costdetail m_product_id numeric 10 Product, Service, Item
m_costmovement_v m_product_id numeric 10  √  null Product, Service, Item
m_costqueue m_product_id numeric 10 Product, Service, Item
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_inventoryline m_product_id numeric 10 Product, Service, Item
m_matchinv m_product_id numeric 10  √  null Product, Service, Item
m_matchpo m_product_id numeric 10  √  null Product, Service, Item
m_movementline m_product_id numeric 10 Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_product_acct m_product_id numeric 10 Product, Service, Item
m_product_po m_product_id numeric 10 Product, Service, Item
m_productionline m_product_id numeric 10 Product, Service, Item
m_transaction m_product_id numeric 10 Product, Service, Item
t_inventoryvalue m_product_id numeric 10 Product, Service, Item
m_product_po m_product_po_uu varchar 36  √  NULL::character varying M_Product_PO_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_productionline m_production_id numeric 10  √  null Plan for producing a product
m_costdetail m_productionline_id numeric 10  √  null Document Line representing a production
m_costmovement_v m_productionline_id numeric 10  √  null Document Line representing a production
m_productionline m_productionline_id numeric 10 Document Line representing a production
m_productionlinema m_productionline_id numeric 10 Document Line representing a production
m_transaction m_productionline_id numeric 10  √  null Document Line representing a production
m_productionline m_productionline_uu varchar 36  √  NULL::character varying M_ProductionLine_UU
m_productionlinema m_productionlinema_uu varchar 36  √  NULL::character varying M_ProductionLineMA_UU
m_productionline m_productionplan_id numeric 10  √  null Plan for how a product is produced
c_orderline m_promotion_id numeric 10  √  null Promotion
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
m_inout m_rma_id numeric 10  √  null Return Material Authorization
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_order m_shipper_id numeric 10  √  null Method or manner of product delivery
c_orderline m_shipper_id numeric 10  √  null Method or manner of product delivery
m_inout m_shipper_id numeric 10  √  null Method or manner of product delivery
m_transaction m_transaction_id numeric 10 Inventory Transaction
m_transaction m_transaction_uu varchar 36  √  NULL::character varying M_Transaction_UU
m_warehouse_acct m_warehouse_acct_uu varchar 36  √  NULL::character varying M_Warehouse_Acct_UU
c_order m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_orderline m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_inout m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_locator m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse_acct m_warehouse_id numeric 10 Storage Warehouse and Service Point
s_resource m_warehouse_id numeric 10 Storage Warehouse and Service Point
t_inventoryvalue m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
m_product_po manufacturer varchar 30  √  null Manufacturer of the Product
s_resource manufacturingresourcetype bpchar 2  √  null Manufacturing Resource Type
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
c_projectissue movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inout movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_transaction movementdate timestamp 29,6 Date a product was moved in or out of inventory
c_projectissue movementqty numeric 0 0 Quantity of a product moved.
c_projectissuema movementqty numeric 0 0 Quantity of a product moved.
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
m_inoutlinema movementqty numeric 0 (1)::numeric Quantity of a product moved.
m_inventorylinema movementqty numeric 0 (1)::numeric Quantity of a product moved.
m_movementline movementqty numeric 0 0 Quantity of a product moved.
m_movementlinema movementqty numeric 0  √  (1)::numeric Quantity of a product moved.
m_productionline movementqty numeric 0 0 Quantity of a product moved.
m_productionlinema movementqty numeric 0 0 Quantity of a product moved.
m_transaction movementqty numeric 0 0 Quantity of a product moved.
m_inout movementtype bpchar 2 Method of moving the inventory
m_transaction movementtype bpchar 2 Method of moving the inventory
c_acctschema name varchar 60 Alphanumeric identifier of the entity
m_costelement name varchar 60 Alphanumeric identifier of the entity
m_costtype name varchar 60 Alphanumeric identifier of the entity
m_product name varchar 255 Alphanumeric identifier of the entity
m_product_category name varchar 60 Alphanumeric identifier of the entity
m_warehouse name varchar 60 Alphanumeric identifier of the entity
s_resource name varchar 60 Alphanumeric identifier of the entity
m_costhistory newcamt numeric 0  √  null Accumulated Amt after processing of M_CostDetail
m_costmovement_v newcamt numeric 0  √  null Accumulated Amt after processing of M_CostDetail
m_costhistory newcostprice numeric 0 New current cost price after processing of M_CostDetail
m_costmovement_v newcostprice numeric 0  √  null New current cost price after processing of M_CostDetail
m_inventoryline newcostprice numeric 0  √  (0)::numeric New current cost price after processing of M_CostDetail
m_costhistory newcqty numeric 0  √  null New Accumulated Qty after processing of M_CostDetail
m_costmovement_v newcqty numeric 0  √  null New Accumulated Qty after processing of M_CostDetail
m_costhistory newqty numeric 0 New current quantity after processing of M_CostDetail
m_costmovement_v newqty numeric 0  √  null New current quantity after processing of M_CostDetail
m_inout nopackages numeric 10  √  (1)::numeric Number of packages shipped
m_costhistory oldcamt numeric 0  √  null Old accumulated amt before the processing of M_CostDetail
m_costmovement_v oldcamt numeric 0  √  null Old accumulated amt before the processing of M_CostDetail
m_costhistory oldcostprice numeric 0 Old current cost price before the processing of M_CostDetail
m_costmovement_v oldcostprice numeric 0  √  null Old current cost price before the processing of M_CostDetail
m_costhistory oldcqty numeric 0  √  null Old accumulated qty before the processing of M_CostDetail
m_costmovement_v oldcqty numeric 0  √  null Old accumulated qty before the processing of M_CostDetail
m_costhistory oldqty numeric 0 Old current quantity before the processing of M_CostDetail
m_costmovement_v oldqty numeric 0  √  null Old current quantity before the processing of M_CostDetail
m_product_po order_min numeric 0  √  0 Minimum order quantity in UOM
m_product_po order_pack numeric 0  √  0 Package order size in UOM (e.g. order set of 5 units)
c_order ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_allocationline overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
m_product_acct p_asset_acct numeric 10 Account for Product Asset (Inventory)
m_product_category_acct p_asset_acct numeric 10 Account for Product Asset (Inventory)
m_product_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric Average Cost Variance
m_product_category_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric Average Cost Variance
m_product_acct p_burden_acct numeric 10  √  null The Burden account is the account used Manufacturing Order
m_product_category_acct p_burden_acct numeric 10  √  null The Burden account is the account used Manufacturing Order
m_product_acct p_cogs_acct numeric 10 Account for Cost of Goods Sold
m_product_category_acct p_cogs_acct numeric 10 Account for Cost of Goods Sold
m_product_acct p_costadjustment_acct numeric 10  √  null Product Cost Adjustment Account
m_product_category_acct p_costadjustment_acct numeric 10  √  null Product Cost Adjustment Account
m_product_acct p_costofproduction_acct numeric 10  √  null The Cost Of Production account is the account used Manufacturing Order
m_product_category_acct p_costofproduction_acct numeric 10  √  null The Cost Of Production account is the account used Manufacturing Order
m_product_acct p_expense_acct numeric 10 Account for Product Expense
m_product_category_acct p_expense_acct numeric 10 Account for Product Expense
m_product_acct p_floorstock_acct numeric 10  √  null The Floor Stock account is the account used Manufacturing Order
m_product_category_acct p_floorstock_acct numeric 10  √  null The Floor Stock account is the account used Manufacturing Order
m_product_acct p_inventoryclearing_acct numeric 10  √  null Product Inventory Clearing Account
m_product_category_acct p_inventoryclearing_acct numeric 10  √  null Product Inventory Clearing Account
m_product_acct p_invoicepricevariance_acct numeric 10 Difference between Costs and Invoice Price (IPV)
m_product_category_acct p_invoicepricevariance_acct numeric 10 Difference between Costs and Invoice Price (IPV)
m_product_acct p_labor_acct numeric 10  √  null The Labor account is the account used Manufacturing Order
m_product_category_acct p_labor_acct numeric 10  √  null The Labor account is the account used Manufacturing Order
m_product_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric Product Landed Cost Clearing Account
m_product_category_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric Product Landed Cost Clearing Account
m_product_acct p_methodchangevariance_acct numeric 10  √  null The Method Change Variance account is the account used Manufacturing Order
m_product_category_acct p_methodchangevariance_acct numeric 10  √  null The Method Change Variance account is the account used Manufacturing Order
m_product_acct p_mixvariance_acct numeric 10  √  null The Mix Variance account is the account used Manufacturing Order
m_product_category_acct p_mixvariance_acct numeric 10  √  null The Mix Variance account is the account used Manufacturing Order
m_product_acct p_outsideprocessing_acct numeric 10  √  null The Outside Processing Account is the account used in Manufacturing Order
m_product_category_acct p_outsideprocessing_acct numeric 10  √  null The Outside Processing Account is the account used in Manufacturing Order
m_product_acct p_overhead_acct numeric 10  √  null The Overhead account is the account used in Manufacturing Order
m_product_category_acct p_overhead_acct numeric 10  √  null The Overhead account is the account used in Manufacturing Order
m_product_acct p_purchasepricevariance_acct numeric 10 Difference between Standard Cost and Purchase Price (PPV)
m_product_category_acct p_purchasepricevariance_acct numeric 10 Difference between Standard Cost and Purchase Price (PPV)
m_product_acct p_ratevariance_acct numeric 10  √  null The Rate Variance account is the account used Manufacturing Order
m_product_category_acct p_ratevariance_acct numeric 10  √  null The Rate Variance account is the account used Manufacturing Order
m_product_acct p_revenue_acct numeric 10 Account for Product Revenue (Sales Account)
m_product_category_acct p_revenue_acct numeric 10 Account for Product Revenue (Sales Account)
m_product_acct p_scrap_acct numeric 10  √  null The Scrap account is the account used in Manufacturing Order
m_product_category_acct p_scrap_acct numeric 10  √  null The Scrap account is the account used in Manufacturing Order
m_product_acct p_tradediscountgrant_acct numeric 10 Trade Discount Granted Account
m_product_category_acct p_tradediscountgrant_acct numeric 10 Trade Discount Granted Account
m_product_acct p_tradediscountrec_acct numeric 10 Trade Discount Receivable Account
m_product_category_acct p_tradediscountrec_acct numeric 10 Trade Discount Receivable Account
m_product_acct p_usagevariance_acct numeric 10  √  null The Usage Variance account is the account used Manufacturing Order
m_product_category_acct p_usagevariance_acct numeric 10  √  null The Usage Variance account is the account used Manufacturing Order
m_product_acct p_wip_acct numeric 10  √  null The Work in Process account is the account used Manufacturing Order
m_product_category_acct p_wip_acct numeric 10  √  null The Work in Process account is the account used Manufacturing Order
c_order pay_bpartner_id numeric 10  √  null Business Partner responsible for the payment
c_order pay_location_id numeric 10  √  null Location of the Business Partner responsible for the payment
c_invoice paymentrule bpchar 1 How you pay the invoice
c_order paymentrule bpchar 1 How you pay the invoice
m_cost percent numeric 10  √  0 Percentage
s_resource percentutilization numeric 0 (100)::numeric % Utilization
c_acctschema period_openfuture numeric 10  √  null Number of days to be able to post to a future date (based on system date)
c_acctschema period_openhistory numeric 10  √  null Number of days to be able to post in the past (based on system date)
m_inout pickdate timestamp 29,6  √  null Date/Time when picked for Shipment
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
m_productionline plannedqty numeric 0  √  null Planned quantity for this project
s_resource planninghorizon numeric 10  √  (0)::numeric The planning horizon is the amount of time (Days) an organisation will look into the future when preparing a strategic plan.
c_invoice poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_order posted bpchar 1 'N'::bpchar Posting status
c_projectissue posted bpchar 1 'N'::bpchar Posting status
m_inout posted bpchar 1 'N'::bpchar Posting status
m_matchinv posted bpchar 1 'N'::bpchar Posting status
m_matchpo posted bpchar 1 'N'::bpchar Posting status
c_orderline pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_costdetail pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
m_transaction pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
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.)
m_product_po priceeffective timestamp 29,6  √  null Effective Date of Price
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
m_product_po pricelastinv numeric 0  √  0 Price of the last invoice for the product
m_product_po pricelastpo numeric 0  √  0 Price of the last purchase order for the product
c_invoiceline pricelimit numeric 0 0 Lowest price for a product
c_orderline pricelimit numeric 0 0 Lowest price for a product
t_inventoryvalue pricelimit numeric 0  √  0 Lowest price for a product
t_inventoryvalue pricelimitamt numeric 0  √  0 Value with limit price
c_invoiceline pricelist numeric 0 0 List Price
c_orderline pricelist numeric 0 0 List Price
m_product_po pricelist numeric 0  √  0 List Price
t_inventoryvalue pricelist numeric 0  √  0 List Price
t_inventoryvalue pricelistamt numeric 0  √  0 Valuation with List Price
m_matchpo pricematchdifference numeric 0  √  null Difference between Purchase and Invoice Price per matched line
m_product_po pricepo numeric 0  √  0 Price based on a purchase order
t_inventoryvalue pricepo numeric 0  √  0 Price based on a purchase order
t_inventoryvalue pricepoamt numeric 0  √  0 Valuation with PO Price
t_inventoryvalue pricestd numeric 0  √  0 Standard Price
t_inventoryvalue pricestdamt numeric 0  √  0 Valuation with standard price
m_locator priorityno numeric 10 Where inventory should be picked from first
c_order priorityrule bpchar 1 Priority of a document
m_inout priorityrule bpchar 1 Priority of a document
c_invoice processed bpchar 1 'N'::bpchar The document has been processed
c_invoiceline processed bpchar 1 'N'::bpchar The document has been processed
c_order processed bpchar 1 'N'::bpchar The document has been processed
c_orderlandedcost processed bpchar 1 'N'::bpchar The document has been processed
c_orderlandedcostallocation processed bpchar 1 'N'::bpchar The document has been processed
c_orderline processed bpchar 1 'N'::bpchar The document has been processed
c_projectissue processed bpchar 1 'N'::bpchar The document has been processed
m_costdetail processed bpchar 1 'N'::bpchar The document has been processed
m_inout processed bpchar 1 'N'::bpchar The document has been processed
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
m_inventoryline processed bpchar 1 'N'::bpchar The document has been processed
m_matchinv processed bpchar 1 'N'::bpchar The document has been processed
m_matchpo processed bpchar 1 'N'::bpchar The document has been processed
m_movementline processed bpchar 1 'N'::bpchar The document has been processed
m_productionline processed bpchar 1 'N'::bpchar The document has been processed
c_invoice processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_order processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_projectissue processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_inout processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_matchinv processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_matchpo processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_acctschema processing bpchar 1  √  null Process Now
c_invoice processing bpchar 1  √  null Process Now
c_landedcost processing bpchar 1  √  null Process Now
c_order processing bpchar 1  √  null Process Now
c_projectissue processing bpchar 1  √  null Process Now
m_inout processing bpchar 1  √  null Process Now
m_matchinv processing bpchar 1 Process Now
m_matchpo processing bpchar 1 Process Now
m_product processing bpchar 1  √  null Process Now
m_product_category_acct processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
c_order promotioncode varchar 30  √  null User entered promotion code at sales time
c_landedcostallocation qty numeric 0 0 Quantity
c_orderlandedcostallocation qty numeric 0 Quantity
m_costdetail qty numeric 0 0 Quantity
m_costmovement_v qty numeric 0  √  null Quantity
m_matchinv qty numeric 0 0 Quantity
m_matchpo qty numeric 0 0 Quantity
m_inventoryline qtybook numeric 0 0 Book Quantity
m_inventoryline qtycount numeric 0 0 Counted Quantity
m_inventoryline qtycsv numeric 0 0 QtyCsv
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
m_inventoryline qtyinternaluse numeric 0  √  null Internal Use Quantity removed from Inventory
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
t_inventoryvalue qtyonhand numeric 0  √  0 On Hand Quantity
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
m_productionline qtyused numeric 0  √  null Quantity Used
m_product_po qualityrating numeric 0  √  null Method for rating vendors
s_resource queuingtime numeric 0  √  null Queue time is the time a job waits at a work center before begin handled.
c_order quotationorder_id numeric 10  √  NULL::numeric Quotation used for generating this order
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_inout ref_inout_id numeric 10  √  null Referenced Shipment
m_inoutline ref_inoutline_id numeric 10  √  null Referenced Shipment Line
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoiceline ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
m_matchinv ref_matchinv_id numeric 10  √  NULL::numeric Referenced Match Invoice
m_matchpo ref_matchpo_id numeric 10  √  NULL::numeric Referenced Match PO
c_order ref_order_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
c_orderline ref_orderline_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
m_inout returnbpartner_id numeric 10  √  NULL::numeric Return Partner
m_inout returnlocation_id numeric 10  √  NULL::numeric Return Location
m_inout returnuser_id numeric 10  √  NULL::numeric Return User/Contact
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_projectissue reversal_id numeric 10  √  null ID of document reversal
m_inout reversal_id numeric 10  √  null ID of document reversal
m_matchinv reversal_id numeric 10  √  NULL::numeric ID of document reversal
m_matchpo reversal_id numeric 10  √  NULL::numeric ID of document reversal
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_inventoryline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_movementline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_product_po royaltyamt numeric 0  √  0 (Included) Amount for copyright, etc.
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
c_orderline rramt numeric 0  √  null Revenue Recognition Amount
c_invoiceline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_orderline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
s_resource s_resource_id numeric 10 Resource
s_resource s_resource_uu varchar 36  √  NULL::character varying S_Resource_UU
c_invoiceline s_resourceassignment_id numeric 10  √  null Resource Assignment
c_orderline s_resourceassignment_id numeric 10  √  null Resource Assignment
s_resource s_resourcetype_id numeric 10 Resource Type
c_projectissue s_timeexpenseline_id numeric 10  √  null Time and Expense Report Line
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_order salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inout salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_movementline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inout sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_acctschema separator bpchar 1 Element Separator
m_warehouse separator bpchar 1 Element Separator
m_attributesetinstance serno varchar 40  √  null Product Serial Number
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
m_inout shipdate timestamp 29,6  √  null Shipment Date/Time
m_inout shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
m_product sku varchar 30  √  null Stock Keeping Unit
t_inventoryvalue t_inventoryvalue_uu varchar 36  √  NULL::character varying T_InventoryValue_UU
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
m_movementline targetqty numeric 0  √  0 Target Movement Quantity
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
c_invoice totallines numeric 0 0 Total of all document lines
c_order totallines numeric 0 0 Total of all document lines
m_inout trackingno varchar 60  √  null Number to track the shipment
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product_po upc varchar 20  √  null Bar Code (Universal Product Code or its superset European Article Number)
c_acctschema updated timestamp 29,6 now() Date this record was updated
c_allocationline updated timestamp 29,6 now() Date this record was updated
c_invoice updated timestamp 29,6 now() Date this record was updated
c_invoiceline updated timestamp 29,6 now() Date this record was updated
c_landedcost updated timestamp 29,6 now() Date this record was updated
c_landedcostallocation updated timestamp 29,6 now() Date this record was updated
c_order updated timestamp 29,6 now() Date this record was updated
c_orderlandedcost updated timestamp 29,6 statement_timestamp() Date this record was updated
c_orderlandedcostallocation updated timestamp 29,6 statement_timestamp() Date this record was updated
c_orderline updated timestamp 29,6 now() Date this record was updated
c_projectissue updated timestamp 29,6 now() Date this record was updated
c_projectissuema updated timestamp 29,6 now() Date this record was updated
m_attributesetinstance updated timestamp 29,6 now() Date this record was updated
m_cost updated timestamp 29,6 now() Date this record was updated
m_costdetail updated timestamp 29,6 now() Date this record was updated
m_costelement updated timestamp 29,6 now() Date this record was updated
m_costhistory updated timestamp 29,6 statement_timestamp() Date this record was updated
m_costmovement_v updated timestamp 29,6  √  null Date this record was updated
m_costqueue updated timestamp 29,6 now() Date this record was updated
m_costtype updated timestamp 29,6 now() Date this record was updated
m_inout updated timestamp 29,6 now() Date this record was updated
m_inoutline updated timestamp 29,6 now() Date this record was updated
m_inoutlinema updated timestamp 29,6 now() Date this record was updated
m_inventoryline updated timestamp 29,6 now() Date this record was updated
m_inventorylinema updated timestamp 29,6 now() Date this record was updated
m_locator updated timestamp 29,6 now() Date this record was updated
m_matchinv updated timestamp 29,6 now() Date this record was updated
m_matchpo updated timestamp 29,6 now() Date this record was updated
m_movementline updated timestamp 29,6 now() Date this record was updated
m_movementlinema updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_product_acct updated timestamp 29,6 now() Date this record was updated
m_product_category updated timestamp 29,6 now() Date this record was updated
m_product_category_acct updated timestamp 29,6 now() Date this record was updated
m_product_po updated timestamp 29,6 now() Date this record was updated
m_productionline updated timestamp 29,6 now() Date this record was updated
m_productionlinema updated timestamp 29,6 now() Date this record was updated
m_transaction updated timestamp 29,6 now() Date this record was updated
m_warehouse updated timestamp 29,6 now() Date this record was updated
m_warehouse_acct updated timestamp 29,6 now() Date this record was updated
s_resource updated timestamp 29,6 now() Date this record was updated
c_acctschema updatedby numeric 10 User who updated this records
c_allocationline updatedby numeric 10 User who updated this records
c_invoice updatedby numeric 10 User who updated this records
c_invoiceline updatedby numeric 10 User who updated this records
c_landedcost updatedby numeric 10 User who updated this records
c_landedcostallocation updatedby numeric 10 User who updated this records
c_order updatedby numeric 10 User who updated this records
c_orderlandedcost updatedby numeric 10 User who updated this records
c_orderlandedcostallocation updatedby numeric 10 User who updated this records
c_orderline updatedby numeric 10 User who updated this records
c_projectissue updatedby numeric 10 User who updated this records
c_projectissuema updatedby numeric 10 User who updated this records
m_attributesetinstance updatedby numeric 10 User who updated this records
m_cost updatedby numeric 10 User who updated this records
m_costdetail updatedby numeric 10 User who updated this records
m_costelement updatedby numeric 10 User who updated this records
m_costhistory updatedby numeric 10 User who updated this records
m_costmovement_v updatedby numeric 10  √  null User who updated this records
m_costqueue updatedby numeric 10 User who updated this records
m_costtype updatedby numeric 10 User who updated this records
m_inout updatedby numeric 10 User who updated this records
m_inoutline updatedby numeric 10 User who updated this records
m_inoutlinema updatedby numeric 10 User who updated this records
m_inventoryline updatedby numeric 10 User who updated this records
m_inventorylinema updatedby numeric 10 User who updated this records
m_locator updatedby numeric 10 User who updated this records
m_matchinv updatedby numeric 10 User who updated this records
m_matchpo updatedby numeric 10 User who updated this records
m_movementline updatedby numeric 10 User who updated this records
m_movementlinema updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_product_acct updatedby numeric 10 User who updated this records
m_product_category updatedby numeric 10 User who updated this records
m_product_category_acct updatedby numeric 10 User who updated this records
m_product_po updatedby numeric 10 User who updated this records
m_productionline updatedby numeric 10 User who updated this records
m_productionlinema updatedby numeric 10 User who updated this records
m_transaction updatedby numeric 10 User who updated this records
m_warehouse updatedby numeric 10 User who updated this records
m_warehouse_acct updatedby numeric 10 User who updated this records
s_resource updatedby numeric 10 User who updated this records
c_invoice user1_id numeric 10  √  null User defined list element #1
c_invoiceline user1_id numeric 10  √  null User defined list element #1
c_order user1_id numeric 10  √  null User defined list element #1
c_orderline user1_id numeric 10  √  null User defined list element #1
m_inout user1_id numeric 10  √  null User defined list element #1
m_inoutline user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
c_invoiceline user2_id numeric 10  √  null User defined list element #2
c_order user2_id numeric 10  √  null User defined list element #2
c_orderline user2_id numeric 10  √  null User defined list element #2
m_inout user2_id numeric 10  √  null User defined list element #2
m_inoutline user2_id numeric 10  √  null User defined list element #2
m_locator value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product_category value varchar 40 Search key for the record in the format required - must be unique
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
s_resource value varchar 40 Search key for the record in the format required - must be unique
m_product_po vendorcategory varchar 30  √  null Product Category of the Business Partner
m_product_po vendorproductno varchar 40 Product Key of the Business Partner
m_product versionno varchar 20  √  null Version Number
c_order volume numeric 0  √  null Volume of a product
m_inout volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
m_warehouse_acct w_differences_acct numeric 10 Warehouse Differences Account
m_warehouse_acct w_invactualadjust_acct numeric 10  √  null Account for Inventory value adjustments for Actual Costing
m_warehouse_acct w_inventory_acct numeric 10  √  null Warehouse Inventory Asset Account - Currently not used
m_warehouse_acct w_revaluation_acct numeric 10  √  null Account for Inventory Revaluation
s_resource waitingtime numeric 0  √  null Workflow Simulation Waiting time
c_order weight numeric 0  √  null Weight of a product
m_inout weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
c_allocationline writeoffamt numeric 0 0 Amount to write-off
m_locator x varchar 60  √  null X dimension, e.g., Aisle
m_locator y varchar 60  √  null Y dimension, e.g., Bin
m_locator z varchar 60  √  null Z dimension, e.g., Level