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

idempiere9.adempiere contains 544 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner createdby numeric 10 User who created this records
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_bpartner description varchar 255  √  null Optional short description of the record
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_bpartner numberemployees numeric 10  √  null Number of employees
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_bpartner taxid varchar 20  √  null Tax Identification
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
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 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_invoiceline ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceline ad_org_id numeric 10 Organizational entity within client
c_invoiceline 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_invoiceline c_campaign_id numeric 10  √  null Marketing Campaign
c_invoiceline c_charge_id numeric 10  √  null Additional document charges
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_UU
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
c_invoiceline c_project_id numeric 10  √  null Financial Project
c_invoiceline 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_invoiceline c_tax_id numeric 10  √  null Tax identifier
c_invoiceline c_uom_id numeric 10  √  null Unit of Measure
c_invoiceline created timestamp 29,6 now() Date this record was created
c_invoiceline createdby numeric 10 User who created this records
c_invoiceline description varchar 255  √  null Optional short description of the record
c_invoiceline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoiceline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoiceline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
c_invoiceline 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_invoiceline linetotalamt numeric 0  √  0 Total line amount incl. Tax
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
c_invoiceline m_rmaline_id numeric 10  √  null Return Material Authorization Line
c_invoiceline priceactual numeric 0 0 Actual Price
c_invoiceline 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_invoiceline pricelist numeric 0 0 List Price
c_invoiceline processed bpchar 1 'N'::bpchar The document has been processed
c_invoiceline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
c_invoiceline qtyinvoiced numeric 0 0 Invoiced Quantity
c_invoiceline ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
c_invoiceline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_invoiceline s_resourceassignment_id numeric 10  √  null Resource Assignment
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
c_invoiceline updated timestamp 29,6 now() Date this record was updated
c_invoiceline updatedby numeric 10 User who updated this records
c_invoiceline user1_id numeric 10  √  null User defined list element #1
c_invoiceline user2_id numeric 10  √  null User defined list element #2
c_nonbusinessday ad_client_id numeric 10 Client/Tenant for this installation.
c_nonbusinessday ad_org_id numeric 10 Organizational entity within client
c_nonbusinessday c_calendar_id numeric 10 Accounting Calendar Name
c_nonbusinessday c_country_id numeric 10  √  NULL::numeric Country
c_nonbusinessday c_nonbusinessday_id numeric 10 Day on which business is not transacted
c_nonbusinessday c_nonbusinessday_uu varchar 36  √  NULL::character varying C_NonBusinessDay_UU
c_nonbusinessday created timestamp 29,6 now() Date this record was created
c_nonbusinessday createdby numeric 10 User who created this records
c_nonbusinessday date1 timestamp 29,6 Date when business is not conducted
c_nonbusinessday isactive bpchar 1 'Y'::bpchar The record is active in the system
c_nonbusinessday name varchar 60  √  null Alphanumeric identifier of the entity
c_nonbusinessday updated timestamp 29,6 now() Date this record was updated
c_nonbusinessday updatedby numeric 10 User who updated this records
c_orderline ad_client_id numeric 10 Client/Tenant for this installation.
c_orderline ad_org_id numeric 10 Organizational entity within client
c_orderline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_orderline 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_orderline c_campaign_id numeric 10  √  null Marketing Campaign
c_orderline c_charge_id numeric 10  √  null Additional document charges
c_orderline c_currency_id numeric 10 The Currency for this record
c_orderline c_order_id numeric 10 Order
c_orderline c_orderline_id numeric 10 Sales Order Line
c_orderline c_orderline_uu varchar 36  √  NULL::character varying C_OrderLine_UU
c_orderline c_project_id numeric 10  √  null Financial Project
c_orderline c_projectphase_id numeric 10  √  null Phase of a Project
c_orderline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_orderline c_tax_id numeric 10 Tax identifier
c_orderline c_uom_id numeric 10 Unit of Measure
c_orderline created timestamp 29,6 now() Date this record was created
c_orderline createdby numeric 10 User who created this records
c_orderline createproduction bpchar 1  √  'N'::bpchar Create Production
c_orderline createshipment bpchar 1  √  'N'::bpchar Create Shipment
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
c_orderline description varchar 255  √  null Optional short description of the record
c_orderline discount numeric 0  √  null Discount in percent
c_orderline freightamt numeric 0 0 Freight Amount
c_orderline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_orderline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
c_orderline line numeric 10 Unique line for this document
c_orderline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
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.
c_orderline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_orderline m_product_id numeric 10  √  null Product, Service, Item
c_orderline m_promotion_id numeric 10  √  null Promotion
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
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_orderline priceentered numeric 0 Price Entered - the price based on the selected/base UoM
c_orderline pricelimit numeric 0 0 Lowest price for a product
c_orderline pricelist numeric 0 0 List Price
c_orderline processed bpchar 1 'N'::bpchar The document has been processed
c_orderline qtydelivered numeric 0 0 Delivered Quantity
c_orderline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
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
c_orderline qtyreserved numeric 0 0 Reserved Quantity
c_orderline ref_orderline_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
c_orderline rramt numeric 0  √  null Revenue Recognition Amount
c_orderline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_orderline s_resourceassignment_id numeric 10  √  null Resource Assignment
c_orderline updated timestamp 29,6 now() Date this record was updated
c_orderline updatedby numeric 10 User who updated this records
c_orderline user1_id numeric 10  √  null User defined list element #1
c_orderline user2_id numeric 10  √  null User defined list element #2
c_servicelevel ad_client_id numeric 10 Client/Tenant for this installation.
c_servicelevel ad_org_id numeric 10 Organizational entity within client
c_servicelevel c_revenuerecognition_plan_id numeric 10 Plan for recognizing or recording revenue
c_servicelevel c_servicelevel_id numeric 10 Product Revenue Recognition Service Level
c_servicelevel c_servicelevel_uu varchar 36  √  NULL::character varying C_ServiceLevel_UU
c_servicelevel created timestamp 29,6 now() Date this record was created
c_servicelevel createdby numeric 10 User who created this records
c_servicelevel description varchar 255  √  null Optional short description of the record
c_servicelevel isactive bpchar 1 'Y'::bpchar The record is active in the system
c_servicelevel m_product_id numeric 10 Product, Service, Item
c_servicelevel processed bpchar 1  √  'N'::bpchar The document has been processed
c_servicelevel processing bpchar 1  √  null Process Now
c_servicelevel servicelevelinvoiced numeric 0 Quantity of product or service invoiced
c_servicelevel servicelevelprovided numeric 0 Quantity of service or product provided
c_servicelevel updated timestamp 29,6 now() Date this record was updated
c_servicelevel updatedby numeric 10 User who updated this records
c_servicelevelline ad_client_id numeric 10 Client/Tenant for this installation.
c_servicelevelline ad_org_id numeric 10 Organizational entity within client
c_servicelevelline c_servicelevel_id numeric 10 Product Revenue Recognition Service Level
c_servicelevelline c_servicelevelline_id numeric 10 Product Revenue Recognition Service Level Line
c_servicelevelline c_servicelevelline_uu varchar 36  √  NULL::character varying C_ServiceLevelLine_UU
c_servicelevelline created timestamp 29,6 now() Date this record was created
c_servicelevelline createdby numeric 10 User who created this records
c_servicelevelline description varchar 255  √  null Optional short description of the record
c_servicelevelline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_servicelevelline processed bpchar 1  √  'N'::bpchar The document has been processed
c_servicelevelline servicedate timestamp 29,6 Date service was provided
c_servicelevelline servicelevelprovided numeric 0 Quantity of service or product provided
c_servicelevelline updated timestamp 29,6 now() Date this record was updated
c_servicelevelline updatedby numeric 10 User who updated this records
c_taxcategory ad_client_id numeric 10 Client/Tenant for this installation.
c_taxcategory ad_org_id numeric 10 Organizational entity within client
c_taxcategory c_taxcategory_id numeric 10 Tax Category
c_taxcategory c_taxcategory_uu varchar 36  √  NULL::character varying C_TaxCategory_UU
c_taxcategory commoditycode varchar 20  √  null Commodity code used for tax calculation
c_taxcategory created timestamp 29,6 now() Date this record was created
c_taxcategory createdby numeric 10 User who created this records
c_taxcategory description varchar 255  √  null Optional short description of the record
c_taxcategory isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxcategory isdefault bpchar 1 'N'::bpchar Default value
c_taxcategory name varchar 60 Alphanumeric identifier of the entity
c_taxcategory updated timestamp 29,6 now() Date this record was updated
c_taxcategory updatedby numeric 10 User who updated this records
c_uom ad_client_id numeric 10 Client/Tenant for this installation.
c_uom ad_org_id numeric 10 Organizational entity within client
c_uom c_uom_id numeric 10 Unit of Measure
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
c_uom costingprecision numeric 10 Rounding used costing calculations
c_uom created timestamp 29,6 now() Date this record was created
c_uom createdby numeric 10 User who created this records
c_uom description varchar 255  √  null Optional short description of the record
c_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom isdefault bpchar 1 'N'::bpchar Default value
c_uom name varchar 60 Alphanumeric identifier of the entity
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
c_uom updated timestamp 29,6 now() Date this record was updated
c_uom updatedby numeric 10 User who updated this records
c_uom x12de355 varchar 4 UOM EDI X12 Code
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
m_pricelist c_currency_id numeric 10 The Currency for this record
m_pricelist created timestamp 29,6 now() Date this record was created
m_pricelist createdby numeric 10 User who created this records
m_pricelist description varchar 255  √  null Optional short description of the record
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
m_pricelist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_pricelist updatedby numeric 10 User who updated this records
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within client
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_product created timestamp 29,6 now() Date this record was created
m_product createdby numeric 10 User who created this records
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_product 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 discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
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
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
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
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
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
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
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_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
m_product m_product_id numeric 10 Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_product name varchar 255 Alphanumeric identifier of the entity
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
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_product sku varchar 30  √  null Stock Keeping Unit
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 updated timestamp 29,6 now() Date this record was updated
m_product updatedby numeric 10 User who updated this records
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
m_product_category ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category ad_org_id numeric 10 Organizational entity within client
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
m_product_category created timestamp 29,6 now() Date this record was created
m_product_category createdby numeric 10 User who created this records
m_product_category description varchar 255  √  null Optional short description of the record
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isdefault bpchar 1 'N'::bpchar Default value
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_category 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
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
m_product_category name varchar 60 Alphanumeric identifier of the entity
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
m_product_category updated timestamp 29,6 now() Date this record was updated
m_product_category updatedby numeric 10 User who updated this records
m_product_category value varchar 40 Search key for the record in the format required - must be unique
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_org_id numeric 10 Organizational entity within client
m_warehouse c_location_id numeric 10 Location or Address
m_warehouse created timestamp 29,6 now() Date this record was created
m_warehouse createdby numeric 10 User who created this records
m_warehouse description varchar 255  √  null Optional short description of the record
m_warehouse isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
m_warehouse 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_warehouse name varchar 60 Alphanumeric identifier of the entity
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
m_warehouse separator bpchar 1 Element Separator
m_warehouse updated timestamp 29,6 now() Date this record was updated
m_warehouse updatedby numeric 10 User who updated this records
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
s_expensetype ad_client_id numeric 10 Client/Tenant for this installation.
s_expensetype ad_org_id numeric 10 Organizational entity within client
s_expensetype c_taxcategory_id numeric 10 Tax Category
s_expensetype c_uom_id numeric 10 Unit of Measure
s_expensetype created timestamp 29,6 now() Date this record was created
s_expensetype createdby numeric 10 User who created this records
s_expensetype description varchar 255  √  null Optional short description of the record
s_expensetype isactive bpchar 1 'Y'::bpchar The record is active in the system
s_expensetype isinvoiced bpchar 1 'Y'::bpchar Is this invoiced?
s_expensetype m_product_category_id numeric 10 Category of a Product
s_expensetype name varchar 60 Alphanumeric identifier of the entity
s_expensetype s_expensetype_id numeric 10 Expense report type
s_expensetype s_expensetype_uu varchar 36  √  NULL::character varying S_ExpenseType_UU
s_expensetype updated timestamp 29,6 now() Date this record was updated
s_expensetype updatedby numeric 10 User who updated this records
s_expensetype value varchar 40 Search key for the record in the format required - must be unique
s_resource ad_client_id numeric 10 Client/Tenant for this installation.
s_resource ad_org_id numeric 10 Organizational entity within client
s_resource ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
s_resource chargeableqty numeric 0  √  0 Chargeable Quantity
s_resource created timestamp 29,6 now() Date this record was created
s_resource createdby numeric 10 User who created this records
s_resource dailycapacity numeric 0  √  null Daily Capacity
s_resource description varchar 255  √  null Optional short description of the record
s_resource isactive bpchar 1 'Y'::bpchar The record is active in the system
s_resource isavailable bpchar 1 'Y'::bpchar Resource is available
s_resource ismanufacturingresource bpchar 1  √  'N'::bpchar Manufacturing Resource
s_resource m_warehouse_id numeric 10 Storage Warehouse and Service Point
s_resource manufacturingresourcetype bpchar 2  √  null Manufacturing Resource Type
s_resource name varchar 60 Alphanumeric identifier of the entity
s_resource percentutilization numeric 0 (100)::numeric % Utilization
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.
s_resource queuingtime numeric 0  √  null Queue time is the time a job waits at a work center before begin handled.
s_resource s_resource_id numeric 10 Resource
s_resource s_resource_uu varchar 36  √  NULL::character varying S_Resource_UU
s_resource s_resourcetype_id numeric 10 Resource Type
s_resource updated timestamp 29,6 now() Date this record was updated
s_resource updatedby numeric 10 User who updated this records
s_resource value varchar 40 Search key for the record in the format required - must be unique
s_resource waitingtime numeric 0  √  null Workflow Simulation Waiting time
s_resourceassignment ad_client_id numeric 10 Client/Tenant for this installation.
s_resourceassignment ad_org_id numeric 10 Organizational entity within client
s_resourceassignment assigndatefrom timestamp 29,6 Assign resource from
s_resourceassignment assigndateto timestamp 29,6  √  null Assign resource until
s_resourceassignment created timestamp 29,6 now() Date this record was created
s_resourceassignment createdby numeric 10 User who created this records
s_resourceassignment description varchar 255  √  null Optional short description of the record
s_resourceassignment isactive bpchar 1 'Y'::bpchar The record is active in the system
s_resourceassignment isconfirmed bpchar 1 'N'::bpchar Assignment is confirmed
s_resourceassignment name varchar 60 Alphanumeric identifier of the entity
s_resourceassignment qty numeric 0  √  0 Quantity
s_resourceassignment s_resource_id numeric 10 Resource
s_resourceassignment s_resourceassignment_id numeric 10 Resource Assignment
s_resourceassignment s_resourceassignment_uu varchar 36  √  NULL::character varying S_ResourceAssignment_UU
s_resourceassignment updated timestamp 29,6 now() Date this record was updated
s_resourceassignment updatedby numeric 10 User who updated this records
s_resourcetype ad_client_id numeric 10 Client/Tenant for this installation.
s_resourcetype ad_org_id numeric 10 Organizational entity within client
s_resourcetype allowuomfractions bpchar 1 'N'::bpchar Allow Unit of Measure Fractions
s_resourcetype c_taxcategory_id numeric 10 Tax Category
s_resourcetype c_uom_id numeric 10 Unit of Measure
s_resourcetype chargeableqty numeric 0  √  0 Chargeable Quantity
s_resourcetype created timestamp 29,6 now() Date this record was created
s_resourcetype createdby numeric 10 User who created this records
s_resourcetype description varchar 255  √  null Optional short description of the record
s_resourcetype isactive bpchar 1 'Y'::bpchar The record is active in the system
s_resourcetype isdateslot bpchar 1 'N'::bpchar Resource has day slot availability
s_resourcetype issingleassignment bpchar 1 'N'::bpchar Only one assignment at a time (no double-booking or overlapping)
s_resourcetype istimeslot bpchar 1 'N'::bpchar Resource has time slot availability
s_resourcetype m_product_category_id numeric 10 Category of a Product
s_resourcetype name varchar 60 Alphanumeric identifier of the entity
s_resourcetype onfriday bpchar 1 'Y'::bpchar Available on Fridays
s_resourcetype onmonday bpchar 1 'Y'::bpchar Available on Mondays
s_resourcetype onsaturday bpchar 1 'N'::bpchar Available on Saturday
s_resourcetype onsunday bpchar 1 'N'::bpchar Available on Sundays
s_resourcetype onthursday bpchar 1 'Y'::bpchar Available on Thursdays
s_resourcetype ontuesday bpchar 1 'Y'::bpchar Available on Tuesdays
s_resourcetype onwednesday bpchar 1 'Y'::bpchar Available on Wednesdays
s_resourcetype s_resourcetype_id numeric 10 Resource Type
s_resourcetype s_resourcetype_uu varchar 36  √  NULL::character varying S_ResourceType_UU
s_resourcetype timeslotend timestamp 29,6  √  null Time when timeslot ends
s_resourcetype timeslotstart timestamp 29,6  √  null Time when timeslot starts
s_resourcetype updated timestamp 29,6 now() Date this record was updated
s_resourcetype updatedby numeric 10 User who updated this records
s_resourcetype value varchar 40 Search key for the record in the format required - must be unique
s_resourceunavailable ad_client_id numeric 10 Client/Tenant for this installation.
s_resourceunavailable ad_org_id numeric 10 Organizational entity within client
s_resourceunavailable created timestamp 29,6 now() Date this record was created
s_resourceunavailable createdby numeric 10 User who created this records
s_resourceunavailable datefrom timestamp 29,6 Starting date for a range
s_resourceunavailable dateto timestamp 29,6  √  null End date of a date range
s_resourceunavailable description varchar 255  √  null Optional short description of the record
s_resourceunavailable isactive bpchar 1 'Y'::bpchar The record is active in the system
s_resourceunavailable s_resource_id numeric 10 Resource
s_resourceunavailable s_resourceunavailable_id numeric 10 Resource Unavailability
s_resourceunavailable s_resourceunavailable_uu varchar 36  √  NULL::character varying S_ResourceUnAvailable_UU
s_resourceunavailable updated timestamp 29,6 now() Date this record was updated
s_resourceunavailable updatedby numeric 10 User who updated this records
s_timeexpense ad_client_id numeric 10 Client/Tenant for this installation.
s_timeexpense ad_org_id numeric 10 Organizational entity within client
s_timeexpense approvalamt numeric 0  √  null Document Approval Amount
s_timeexpense c_bpartner_id numeric 10 Identifies a Business Partner
s_timeexpense created timestamp 29,6 now() Date this record was created
s_timeexpense createdby numeric 10 User who created this records
s_timeexpense datereport timestamp 29,6 Expense/Time Report Date
s_timeexpense description varchar 255  √  null Optional short description of the record
s_timeexpense docaction bpchar 2 The targeted status of the document
s_timeexpense docstatus bpchar 2 The current status of the document
s_timeexpense documentno varchar 30 Document sequence number of the document
s_timeexpense isactive bpchar 1 'Y'::bpchar The record is active in the system
s_timeexpense isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
s_timeexpense m_pricelist_id numeric 10 Unique identifier of a Price List
s_timeexpense m_warehouse_id numeric 10 Storage Warehouse and Service Point
s_timeexpense processed bpchar 1 'N'::bpchar The document has been processed
s_timeexpense processing bpchar 1  √  null Process Now
s_timeexpense s_timeexpense_id numeric 10 Time and Expense Report
s_timeexpense s_timeexpense_uu varchar 36  √  NULL::character varying S_TimeExpense_UU
s_timeexpense updated timestamp 29,6 now() Date this record was updated
s_timeexpense updatedby numeric 10 User who updated this records
s_timeexpenseline ad_client_id numeric 10 Client/Tenant for this installation.
s_timeexpenseline ad_org_id numeric 10 Organizational entity within client
s_timeexpenseline c_activity_id numeric 10  √  null Business Activity
s_timeexpenseline c_bpartner_id numeric 10  √  null Identifies a Business Partner
s_timeexpenseline c_campaign_id numeric 10  √  null Marketing Campaign
s_timeexpenseline c_currency_id numeric 10  √  null The Currency for this record
s_timeexpenseline c_invoiceline_id numeric 10  √  null Invoice Detail Line
s_timeexpenseline c_orderline_id numeric 10  √  null Sales Order Line
s_timeexpenseline c_project_id numeric 10  √  null Financial Project
s_timeexpenseline c_projectphase_id numeric 10  √  null Phase of a Project
s_timeexpenseline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
s_timeexpenseline c_uom_id numeric 10  √  null Unit of Measure
s_timeexpenseline convertedamt numeric 0  √  0 Converted Amount
s_timeexpenseline created timestamp 29,6 now() Date this record was created
s_timeexpenseline createdby numeric 10 User who created this records
s_timeexpenseline dateexpense timestamp 29,6  √  null Date of expense
s_timeexpenseline description varchar 255  √  null Optional short description of the record
s_timeexpenseline expenseamt numeric 0  √  0 Amount for this expense
s_timeexpenseline invoiceprice numeric 0  √  0 Unit price to be invoiced or 0 for default price
s_timeexpenseline isactive bpchar 1 'Y'::bpchar The record is active in the system
s_timeexpenseline isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
s_timeexpenseline istimereport bpchar 1 'N'::bpchar Line is a time report only (no expense)
s_timeexpenseline line numeric 10 Unique line for this document
s_timeexpenseline m_product_id numeric 10  √  null Product, Service, Item
s_timeexpenseline note varchar 255  √  null Optional additional user defined information
s_timeexpenseline priceinvoiced numeric 0  √  null The priced invoiced to the customer (in the currency of the customer's AR price list) - 0 for default price
s_timeexpenseline pricereimbursed numeric 0  √  null The reimbursed price (in currency of the employee's AP price list)
s_timeexpenseline processed bpchar 1 'N'::bpchar The document has been processed
s_timeexpenseline qty numeric 0  √  0 Quantity
s_timeexpenseline qtyinvoiced numeric 0  √  null Invoiced Quantity
s_timeexpenseline qtyreimbursed numeric 0  √  null The reimbursed quantity
s_timeexpenseline s_resourceassignment_id numeric 10  √  null Resource Assignment
s_timeexpenseline s_timeexpense_id numeric 10 Time and Expense Report
s_timeexpenseline s_timeexpenseline_id numeric 10 Time and Expense Report Line
s_timeexpenseline s_timeexpenseline_uu varchar 36  √  NULL::character varying S_TimeExpenseLine_UU
s_timeexpenseline s_timetype_id numeric 10  √  null Type of time recorded
s_timeexpenseline updated timestamp 29,6 now() Date this record was updated
s_timeexpenseline updatedby numeric 10 User who updated this records