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

idempiere11.adempiere contains 702 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_acctschema ad_client_id numeric 10 Tenant for this installation.
c_acctschema ad_org_id numeric 10 Organizational entity within tenant
c_acctschema ad_orgonly_id numeric 10  √  null Create posting entries only for this organization
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
c_acctschema c_acctschema_id numeric 10 Rules for accounting
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying C_AcctSchema_UU
c_acctschema c_currency_id numeric 10 The Currency for this record
c_acctschema c_period_id numeric 10  √  null Period of the Calendar
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
c_acctschema costinglevel bpchar 1 'C'::bpchar The lowest level to accumulate Costing Information
c_acctschema costingmethod bpchar 1 Indicates how Costs will be calculated
c_acctschema created timestamp 29,6 now() Date this record was created
c_acctschema createdby numeric 10 User who created this records
c_acctschema description varchar 255  √  null Optional short description of the record
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
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
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_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar Correct the tax for payment discount and charges
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar Post the cost adjustment explicitly
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_acctschema istradediscountposted bpchar 1 'N'::bpchar Generate postings for trade discounts
c_acctschema m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
c_acctschema name varchar 60 Alphanumeric identifier of the entity
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)
c_acctschema processing bpchar 1  √  null Process Now
c_acctschema separator bpchar 1 Element Separator
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
c_acctschema updated timestamp 29,6 now() Date this record was updated
c_acctschema updatedby numeric 10 User who updated this records
c_allocationhdr ad_client_id numeric 10 Tenant for this installation.
c_allocationhdr ad_org_id numeric 10 Organizational entity within tenant
c_allocationhdr approvalamt numeric 0 0 Document Approval Amount
c_allocationhdr c_allocationhdr_id numeric 10 Payment allocation
c_allocationhdr c_allocationhdr_uu varchar 36  √  NULL::character varying C_AllocationHdr_UU
c_allocationhdr c_currency_id numeric 10 The Currency for this record
c_allocationhdr c_doctype_id numeric 10  √  NULL::numeric Document type or rules
c_allocationhdr created timestamp 29,6 now() Date this record was created
c_allocationhdr createdby numeric 10 User who created this records
c_allocationhdr dateacct timestamp 29,6 Accounting Date
c_allocationhdr datetrx timestamp 29,6 Transaction Date
c_allocationhdr description varchar 255  √  null Optional short description of the record
c_allocationhdr docaction bpchar 2 The targeted status of the document
c_allocationhdr docstatus bpchar 2 The current status of the document
c_allocationhdr documentno varchar 30 Document sequence number of the document
c_allocationhdr isactive bpchar 1 'Y'::bpchar The record is active in the system
c_allocationhdr isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_allocationhdr ismanual bpchar 1 'N'::bpchar This is a manual process
c_allocationhdr posted bpchar 1 'N'::bpchar Posting status
c_allocationhdr processed bpchar 1 'N'::bpchar The document has been processed
c_allocationhdr processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_allocationhdr processing bpchar 1  √  null Process Now
c_allocationhdr reversal_id numeric 10  √  NULL::numeric ID of document reversal
c_allocationhdr updated timestamp 29,6 now() Date this record was updated
c_allocationhdr updatedby numeric 10 User who updated this records
c_allocationline ad_client_id numeric 10 Tenant for this installation.
c_allocationline ad_org_id numeric 10 Organizational entity within tenant
c_allocationline allocationno numeric 10  √  null
c_allocationline amount numeric 0 0 Amount in a defined currency
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_banktransfer_id numeric 10  √  NULL::numeric Bank Transfer
c_allocationline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_allocationline c_cashline_id numeric 10  √  null Cash Journal Line
c_allocationline c_charge_id numeric 10  √  NULL::numeric Additional document charges
c_allocationline c_invoice_id numeric 10  √  null Invoice Identifier
c_allocationline c_order_id numeric 10  √  null Order
c_allocationline c_payment_id numeric 10  √  null Payment identifier
c_allocationline created timestamp 29,6 now() Date this record was created
c_allocationline createdby numeric 10 User who created this records
c_allocationline datetrx timestamp 29,6  √  null Transaction Date
c_allocationline discountamt numeric 0 0 Calculated amount of discount
c_allocationline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_allocationline ismanual bpchar 1  √  'N'::bpchar This is a manual process
c_allocationline overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_allocationline updated timestamp 29,6 now() Date this record was updated
c_allocationline updatedby numeric 10 User who updated this records
c_allocationline writeoffamt numeric 0 0 Amount to write-off
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 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 tenant
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_charge ad_client_id numeric 10 Tenant for this installation.
c_charge ad_org_id numeric 10 Organizational entity within tenant
c_charge c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_charge c_charge_id numeric 10 Additional document charges
c_charge c_charge_uu varchar 36  √  NULL::character varying C_Charge_UU
c_charge c_chargetype_id numeric 10  √  null Charge Type
c_charge c_taxcategory_id numeric 10  √  null Tax Category
c_charge chargeamt numeric 0 0 Charge Amount
c_charge created timestamp 29,6 now() Date this record was created
c_charge createdby numeric 10 User who created this records
c_charge description varchar 255  √  null Optional short description of the record
c_charge isactive bpchar 1 'Y'::bpchar The record is active in the system
c_charge issamecurrency bpchar 1 'N'::bpchar Same Currency
c_charge issametax bpchar 1 'N'::bpchar Use the same tax as the main transaction
c_charge istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_charge name varchar 60 Alphanumeric identifier of the entity
c_charge updated timestamp 29,6 now() Date this record was updated
c_charge updatedby numeric 10 User who updated this records
c_country ad_client_id numeric 10 Tenant for this installation.
c_country ad_language varchar 6  √  null Language for this entity
c_country ad_org_id numeric 10 Organizational entity within tenant
c_country allowcitiesoutoflist bpchar 1  √  'Y'::bpchar A flag to allow cities, currently not in the list, to be entered
c_country c_country_id numeric 10 Country
c_country c_country_uu varchar 36  √  NULL::character varying C_Country_UU
c_country c_currency_id numeric 10  √  null The Currency for this record
c_country capturesequence varchar 60  √  null Capture Sequence
c_country countrycode bpchar 2 Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
c_country created timestamp 29,6 now() Date this record was created
c_country createdby numeric 10 User who created this records
c_country description varchar 255  √  null Optional short description of the record
c_country displaysequence varchar 20 Format for printing this Address
c_country displaysequencelocal varchar 20  √  null Format for printing this Address locally
c_country expressionbankaccountno varchar 20  √  null Format of the Bank Account
c_country expressionbankroutingno varchar 20  √  null Format of the Bank Routing Number
c_country expressionphone varchar 20  √  null Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country expressionpostal varchar 20  √  null Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country expressionpostal_add varchar 20  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country haspostal_add bpchar 1 'N'::bpchar Has Additional Postal Code
c_country hasregion bpchar 1 'N'::bpchar Country contains Regions
c_country isactive bpchar 1 'Y'::bpchar The record is active in the system
c_country isaddresslineslocalreverse bpchar 1 'N'::bpchar Print Local Address in reverse Order
c_country isaddresslinesreverse bpchar 1 'N'::bpchar Print Address in reverse Order
c_country ispostcodelookup bpchar 1 'N'::bpchar Does this country have a post code web service
c_country lookupclassname varchar 255  √  null The class name of the postcode lookup plugin
c_country lookupclientid varchar 50  √  null The Client ID or Login submitted to the Lookup URL
c_country lookuppassword varchar 50  √  null The password submitted to the Lookup URL
c_country lookupurl varchar 100  √  null The URL of the web service that the plugin connects to in order to retrieve postcode data
c_country mediasize varchar 40  √  null Java Media Size
c_country name varchar 60 Alphanumeric identifier of the entity
c_country placeholderaddress1 varchar 255  √  NULL::character varying Placeholder for Address 1
c_country placeholderaddress2 varchar 255  √  NULL::character varying Placeholder for Address 2
c_country placeholderaddress3 varchar 255  √  NULL::character varying Placeholder for Address 3
c_country placeholderaddress4 varchar 255  √  NULL::character varying Placeholder for Address 4
c_country placeholderaddress5 varchar 255  √  NULL::character varying Placeholder for Address 5
c_country placeholdercity varchar 255  √  NULL::character varying Placeholder for city
c_country placeholdercomments varchar 255  √  NULL::character varying Placeholder for comments
c_country placeholderpostal varchar 255  √  NULL::character varying Placeholder for postal
c_country placeholderpostal_add varchar 255  √  NULL::character varying Placeholder for additional zip
c_country regionname varchar 60  √  null Name of the Region
c_country updated timestamp 29,6 now() Date this record was updated
c_country updatedby numeric 10 User who updated this records
c_countrygroup ad_client_id numeric 10 Tenant for this installation.
c_countrygroup ad_org_id numeric 10 Organizational entity within tenant
c_countrygroup c_countrygroup_id numeric 10 Country Group
c_countrygroup c_countrygroup_uu varchar 36  √  NULL::character varying C_CountryGroup_UU
c_countrygroup created timestamp 29,6 statement_timestamp() Date this record was created
c_countrygroup createdby numeric 10 User who created this records
c_countrygroup datefrom timestamp 29,6  √  null Starting date for a range
c_countrygroup dateto timestamp 29,6  √  null End date of a date range
c_countrygroup description varchar 255  √  NULL::character varying Optional short description of the record
c_countrygroup help varchar 2000  √  NULL::character varying Comment or Hint
c_countrygroup isactive bpchar 1 'Y'::bpchar The record is active in the system
c_countrygroup name varchar 60 Alphanumeric identifier of the entity
c_countrygroup updated timestamp 29,6 statement_timestamp() Date this record was updated
c_countrygroup updatedby numeric 10 User who updated this records
c_countrygroup value varchar 40 Search key for the record in the format required - must be unique
c_currency ad_client_id numeric 10 Tenant for this installation.
c_currency ad_org_id numeric 10 Organizational entity within tenant
c_currency c_currency_id numeric 10 The Currency for this record
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_currency costingprecision numeric 10 Rounding used costing calculations
c_currency created timestamp 29,6 now() Date this record was created
c_currency createdby numeric 10 User who created this records
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_currency description varchar 255 Optional short description of the record
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
c_currency emurate numeric 0  √  0 Official rate to the Euro
c_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_currency isemumember bpchar 1 'N'::bpchar This currency is member if the European Monetary Union
c_currency iseuro bpchar 1 'N'::bpchar This currency is the Euro
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
c_currency updated timestamp 29,6 now() Date this record was updated
c_currency updatedby numeric 10 User who updated this records
c_invoice ad_client_id numeric 10 Tenant for this installation.
c_invoice ad_org_id numeric 10 Organizational entity within tenant
c_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoice c_activity_id numeric 10  √  null Business Activity
c_invoice 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_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_invoice c_currency_id numeric 10 The Currency for this record
c_invoice c_doctype_id numeric 10 Document type or rules
c_invoice c_doctypetarget_id numeric 10 Target document type for conversing documents
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_invoice c_order_id numeric 10  √  null Order
c_invoice c_payment_id numeric 10  √  null Payment identifier
c_invoice c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_invoice c_project_id numeric 10  √  null Financial Project
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_invoice copyfrom bpchar 1  √  null Copy From Record
c_invoice created timestamp 29,6 now() Date this record was created
c_invoice 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
c_invoice createlinesfrom bpchar 1  √  NULL::bpchar Process which will generate a new document lines based on an existing document
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
c_invoice dateacct timestamp 29,6 Accounting Date
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_invoice dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
c_invoice description varchar 255  √  null Optional short description of the record
c_invoice docaction bpchar 2 The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
c_invoice documentno varchar 30 Document sequence number of the document
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_invoice generateto bpchar 1  √  null Generate To
c_invoice grandtotal numeric 0 0 Total amount of document
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_invoice isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoice isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_invoice isfixedassetinvoice bpchar 1  √  null Is Fixed Asset Invoice
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
c_invoice ispaid bpchar 1 'N'::bpchar The document is fully paid
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
c_invoice paymentrule bpchar 1 How you pay the invoice
c_invoice 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_invoice 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_invoice processing bpchar 1  √  null Process Now
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice totallines numeric 0 0 Total of all document lines
c_invoice updated timestamp 29,6 now() Date this record was updated
c_invoice updatedby numeric 10 User who updated this records
c_invoice user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
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 Tenant for this installation.
c_invoiceline ad_org_id numeric 10 Organizational entity within tenant
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 Is Fixed Asset Invoice
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_invoicetax ad_client_id numeric 10 Tenant for this installation.
c_invoicetax ad_org_id numeric 10 Organizational entity within tenant
c_invoicetax c_invoice_id numeric 10 Invoice Identifier
c_invoicetax c_invoicetax_uu varchar 36  √  NULL::character varying C_InvoiceTax_UU
c_invoicetax c_tax_id numeric 10 Tax identifier
c_invoicetax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_invoicetax created timestamp 29,6 now() Date this record was created
c_invoicetax createdby numeric 10 User who created this records
c_invoicetax isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoicetax istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoicetax processed bpchar 1 'N'::bpchar The document has been processed
c_invoicetax taxamt numeric 0 0 Tax Amount for a document
c_invoicetax taxbaseamt numeric 0 0 Base for calculating the tax amount
c_invoicetax updated timestamp 29,6 now() Date this record was updated
c_invoicetax updatedby numeric 10 User who updated this records
c_location ad_client_id numeric 10 Tenant for this installation.
c_location ad_org_id numeric 10 Organizational entity within tenant
c_location address1 varchar 60  √  null Address line 1 for this location
c_location address2 varchar 60  √  null Address line 2 for this location
c_location address3 varchar 60  √  null Address Line 3 for the location
c_location address4 varchar 60  √  null Address Line 4 for the location
c_location address5 varchar 60  √  NULL::character varying Address Line 5 for the location
c_location c_addressvalidation_id numeric 10  √  NULL::numeric Address Validation
c_location c_city_id numeric 10  √  null City
c_location c_country_id numeric 10 Country
c_location c_location_id numeric 10 Location or Address
c_location c_location_uu varchar 36  √  NULL::character varying C_Location_UU
c_location c_region_id numeric 10  √  null Identifies a geographical Region
c_location city varchar 60  √  null Identifies a City
c_location comments varchar 2000  √  NULL::character varying Comments or additional information
c_location created timestamp 29,6 now() Date this record was created
c_location createdby numeric 10 User who created this records
c_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_location isvalid bpchar 1  √  'N'::bpchar Element is valid
c_location postal varchar 10  √  null Postal code
c_location postal_add varchar 10  √  null Additional ZIP or Postal code
c_location regionname varchar 40  √  null Name of the Region
c_location result varchar 2000  √  NULL::character varying Result of the action taken
c_location updated timestamp 29,6 now() Date this record was updated
c_location updatedby numeric 10 User who updated this records
c_location validateaddress bpchar 1  √  NULL::bpchar Validate Address
c_region ad_client_id numeric 10 Tenant for this installation.
c_region ad_org_id numeric 10 Organizational entity within tenant
c_region c_country_id numeric 10 Country
c_region c_region_id numeric 10 Identifies a geographical Region
c_region c_region_uu varchar 36  √  NULL::character varying C_Region_UU
c_region created timestamp 29,6 now() Date this record was created
c_region createdby numeric 10 User who created this records
c_region description varchar 255  √  null Optional short description of the record
c_region isactive bpchar 1 'Y'::bpchar The record is active in the system
c_region isdefault bpchar 1  √  'N'::bpchar Default value
c_region name varchar 60 Alphanumeric identifier of the entity
c_region updated timestamp 29,6 now() Date this record was updated
c_region updatedby numeric 10 User who updated this records
c_tax ad_client_id numeric 10 Tenant for this installation.
c_tax ad_org_id numeric 10 Organizational entity within tenant
c_tax ad_rule_id numeric 10  √  null Rule
c_tax c_country_id numeric 10  √  null Country
c_tax c_countrygroupfrom_id numeric 10  √  NULL::numeric Country Group From
c_tax c_countrygroupto_id numeric 10  √  NULL::numeric Country Group To
c_tax c_region_id numeric 10  √  null Identifies a geographical Region
c_tax c_tax_id numeric 10 Tax identifier
c_tax c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_tax c_taxcategory_id numeric 10 Tax Category
c_tax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_tax created timestamp 29,6 now() Date this record was created
c_tax createdby numeric 10 User who created this records
c_tax description varchar 255  √  null Optional short description of the record
c_tax isactive bpchar 1 'Y'::bpchar The record is active in the system
c_tax isdefault bpchar 1 'N'::bpchar Default value
c_tax isdocumentlevel bpchar 1 'Y'::bpchar Tax is calculated on document level (rather than line by line)
c_tax issalestax bpchar 1 'N'::bpchar This is a sales tax (i.e. not a value added tax)
c_tax issummary bpchar 1 'N'::bpchar This is a summary entity
c_tax istaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on sales
c_tax name varchar 60 Alphanumeric identifier of the entity
c_tax parent_tax_id numeric 10  √  null Parent Tax indicates a tax that is made up of multiple taxes
c_tax rate numeric 0 Rate or Tax or Exchange
c_tax requirestaxcertificate bpchar 1 'N'::bpchar This tax rate requires the Business Partner to be tax exempt
c_tax sopotype bpchar 1 'B'::bpchar Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_tax taxindicator varchar 10  √  null Short form for Tax to be printed on documents
c_tax taxpostingindicator bpchar 1  √  '0'::bpchar Type of input tax (deductible and non deductible)
c_tax to_country_id numeric 10  √  null Receiving Country
c_tax to_region_id numeric 10  √  null Receiving Region
c_tax updated timestamp 29,6 now() Date this record was updated
c_tax updatedby numeric 10 User who updated this records
c_tax validfrom timestamp 29,6 Valid from including this date (first day)
c_tax_acct ad_client_id numeric 10 Tenant for this installation.
c_tax_acct ad_org_id numeric 10 Organizational entity within tenant
c_tax_acct c_acctschema_id numeric 10 Rules for accounting
c_tax_acct c_tax_acct_uu varchar 36  √  NULL::character varying C_Tax_Acct_UU
c_tax_acct c_tax_id numeric 10 Tax identifier
c_tax_acct created timestamp 29,6 now() Date this record was created
c_tax_acct createdby numeric 10 User who created this records
c_tax_acct isactive bpchar 1 'Y'::bpchar The record is active in the system
c_tax_acct t_credit_acct numeric 10 Account for Tax you can reclaim
c_tax_acct t_due_acct numeric 10 Account for Tax you have to pay
c_tax_acct t_expense_acct numeric 10 Account for paid tax you cannot reclaim
c_tax_acct t_liability_acct numeric 10  √  null Account for Tax declaration liability
c_tax_acct t_receivables_acct numeric 10  √  null Account for Tax credit after tax declaration
c_tax_acct updated timestamp 29,6 now() Date this record was updated
c_tax_acct updatedby numeric 10 User who updated this records
c_taxcategory ad_client_id numeric 10 Tenant for this installation.
c_taxcategory ad_org_id numeric 10 Organizational entity within tenant
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_taxdeclaration ad_client_id numeric 10 Tenant for this installation.
c_taxdeclaration ad_org_id numeric 10 Organizational entity within tenant
c_taxdeclaration c_taxdeclaration_id numeric 10 Define the declaration to the tax authorities
c_taxdeclaration c_taxdeclaration_uu varchar 36  √  NULL::character varying C_TaxDeclaration_UU
c_taxdeclaration created timestamp 29,6 now() Date this record was created
c_taxdeclaration createdby numeric 10 User who created this records
c_taxdeclaration datefrom timestamp 29,6 Starting date for a range
c_taxdeclaration dateto timestamp 29,6 End date of a date range
c_taxdeclaration datetrx timestamp 29,6 Transaction Date
c_taxdeclaration description varchar 255  √  null Optional short description of the record
c_taxdeclaration isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxdeclaration name varchar 60 Alphanumeric identifier of the entity
c_taxdeclaration processed bpchar 1 'N'::bpchar The document has been processed
c_taxdeclaration processing bpchar 1  √  null Process Now
c_taxdeclaration updated timestamp 29,6 now() Date this record was updated
c_taxdeclaration updatedby numeric 10 User who updated this records
c_taxdeclarationacct ad_client_id numeric 10 Tenant for this installation.
c_taxdeclarationacct ad_org_id numeric 10 Organizational entity within tenant
c_taxdeclarationacct c_acctschema_id numeric 10 Rules for accounting
c_taxdeclarationacct c_taxdeclaration_id numeric 10 Define the declaration to the tax authorities
c_taxdeclarationacct c_taxdeclarationacct_id numeric 10 Tax Accounting Reconciliation
c_taxdeclarationacct c_taxdeclarationacct_uu varchar 36  √  NULL::character varying C_TaxDeclarationAcct_UU
c_taxdeclarationacct created timestamp 29,6 now() Date this record was created
c_taxdeclarationacct createdby numeric 10 User who created this records
c_taxdeclarationacct description varchar 255  √  null Optional short description of the record
c_taxdeclarationacct fact_acct_id numeric 10 Accounting Fact
c_taxdeclarationacct isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxdeclarationacct line numeric 10  √  null Unique line for this document
c_taxdeclarationacct updated timestamp 29,6 now() Date this record was updated
c_taxdeclarationacct updatedby numeric 10 User who updated this records
c_taxdeclarationline ad_client_id numeric 10 Tenant for this installation.
c_taxdeclarationline ad_org_id numeric 10 Organizational entity within tenant
c_taxdeclarationline c_allocationline_id numeric 10  √  null Allocation Line
c_taxdeclarationline c_bpartner_id numeric 10 Identifies a Business Partner
c_taxdeclarationline c_currency_id numeric 10 The Currency for this record
c_taxdeclarationline c_invoice_id numeric 10  √  null Invoice Identifier
c_taxdeclarationline c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_taxdeclarationline c_tax_id numeric 10 Tax identifier
c_taxdeclarationline c_taxdeclaration_id numeric 10 Define the declaration to the tax authorities
c_taxdeclarationline c_taxdeclarationline_id numeric 10 Tax Declaration Document Information
c_taxdeclarationline c_taxdeclarationline_uu varchar 36  √  NULL::character varying C_TaxDeclarationLine_UU
c_taxdeclarationline created timestamp 29,6 now() Date this record was created
c_taxdeclarationline createdby numeric 10 User who created this records
c_taxdeclarationline dateacct timestamp 29,6 Accounting Date
c_taxdeclarationline description varchar 255  √  null Optional short description of the record
c_taxdeclarationline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxdeclarationline ismanual bpchar 1 'N'::bpchar This is a manual process
c_taxdeclarationline line numeric 10 0 Unique line for this document
c_taxdeclarationline taxamt numeric 0 0 Tax Amount for a document
c_taxdeclarationline taxbaseamt numeric 0 0 Base for calculating the tax amount
c_taxdeclarationline updated timestamp 29,6 now() Date this record was updated
c_taxdeclarationline updatedby numeric 10 User who updated this records
c_taxpostal ad_client_id numeric 10 Tenant for this installation.
c_taxpostal ad_org_id numeric 10 Organizational entity within tenant
c_taxpostal c_tax_id numeric 10 Tax identifier
c_taxpostal c_taxpostal_id numeric 10 Tax Postal/ZIP
c_taxpostal c_taxpostal_uu varchar 36  √  NULL::character varying C_TaxPostal_UU
c_taxpostal created timestamp 29,6 now() Date this record was created
c_taxpostal createdby numeric 10 User who created this records
c_taxpostal isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxpostal postal varchar 10 Postal code
c_taxpostal postal_to varchar 10  √  null Postal code to
c_taxpostal updated timestamp 29,6 now() Date this record was updated
c_taxpostal updatedby numeric 10 User who updated this records
c_taxprovider account varchar 60  √  NULL::character varying Account
c_taxprovider ad_client_id numeric 10 Tenant for this installation.
c_taxprovider ad_org_id numeric 10 Organizational entity within tenant
c_taxprovider c_taxprovider_id numeric 10 Tax Provider
c_taxprovider c_taxprovider_uu varchar 36  √  NULL::character varying C_TaxProvider_UU
c_taxprovider c_taxprovidercfg_id numeric 10 Tax Provider Configuration
c_taxprovider companycode varchar 60  √  NULL::character varying Company Code
c_taxprovider created timestamp 29,6 statement_timestamp() Date this record was created
c_taxprovider createdby numeric 10 User who created this records
c_taxprovider isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxprovider license varchar 60  √  NULL::character varying License
c_taxprovider name varchar 120 Alphanumeric identifier of the entity
c_taxprovider seqno numeric 10 (0)::numeric Method of ordering records; lowest number comes first
c_taxprovider updated timestamp 29,6 statement_timestamp() Date this record was updated
c_taxprovider updatedby numeric 10 User who updated this records
c_taxprovider validateconnection bpchar 1  √  NULL::bpchar Validate Connection
c_taxprovidercfg ad_client_id numeric 10 Tenant for this installation.
c_taxprovidercfg ad_org_id numeric 10 Organizational entity within tenant
c_taxprovidercfg c_taxprovidercfg_id numeric 10 Tax Provider Configuration
c_taxprovidercfg c_taxprovidercfg_uu varchar 36  √  NULL::character varying C_TaxProviderCfg_UU
c_taxprovidercfg created timestamp 29,6 statement_timestamp() Date this record was created
c_taxprovidercfg createdby numeric 10 User who created this records
c_taxprovidercfg description varchar 255  √  NULL::character varying Optional short description of the record
c_taxprovidercfg isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxprovidercfg name varchar 120 Alphanumeric identifier of the entity
c_taxprovidercfg taxproviderclass varchar 60  √  NULL::character varying Tax Provider Class
c_taxprovidercfg updated timestamp 29,6 statement_timestamp() Date this record was updated
c_taxprovidercfg updatedby numeric 10 User who updated this records
c_taxprovidercfg url varchar 120  √  NULL::character varying Full URL address - e.g. http://www.idempiere.org
fact_acct a_asset_id numeric 10  √  null Asset used internally or by customers
fact_acct account_id numeric 10 Account used
fact_acct ad_client_id numeric 10 Tenant for this installation.
fact_acct ad_org_id numeric 10 Organizational entity within tenant
fact_acct ad_orgtrx_id numeric 10  √  null Performing or initiating organization
fact_acct ad_table_id numeric 10 Database Table information
fact_acct amtacctcr numeric 0 0 Accounted Credit Amount
fact_acct amtacctdr numeric 0 0 Accounted Debit Amount
fact_acct amtsourcecr numeric 0 0 Source Credit Amount
fact_acct amtsourcedr numeric 0 0 Source Debit Amount
fact_acct c_acctschema_id numeric 10 Rules for accounting
fact_acct c_activity_id numeric 10  √  null Business Activity
fact_acct c_bpartner_id numeric 10  √  null Identifies a Business Partner
fact_acct c_campaign_id numeric 10  √  null Marketing Campaign
fact_acct c_currency_id numeric 10 The Currency for this record
fact_acct c_locfrom_id numeric 10  √  null Location that inventory was moved from
fact_acct c_locto_id numeric 10  √  null Location that inventory was moved to
fact_acct c_period_id numeric 10  √  null Period of the Calendar
fact_acct c_project_id numeric 10  √  null Financial Project
fact_acct c_projectphase_id numeric 10  √  null Phase of a Project
fact_acct c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
fact_acct c_salesregion_id numeric 10  √  null Sales coverage region
fact_acct c_subacct_id numeric 10  √  null Sub account for Element Value
fact_acct c_tax_id numeric 10  √  null Tax identifier
fact_acct c_uom_id numeric 10  √  null Unit of Measure
fact_acct created timestamp 29,6 now() Date this record was created
fact_acct createdby numeric 10 User who created this records
fact_acct dateacct timestamp 29,6 Accounting Date
fact_acct datetrx timestamp 29,6 Transaction Date
fact_acct description varchar 255  √  null Optional short description of the record
fact_acct fact_acct_id numeric 10 Accounting Fact
fact_acct fact_acct_uu varchar 36  √  NULL::character varying Fact_Acct_UU
fact_acct gl_budget_id numeric 10  √  null General Ledger Budget
fact_acct gl_category_id numeric 10  √  null General Ledger Category
fact_acct isactive bpchar 1 'Y'::bpchar The record is active in the system
fact_acct line_id numeric 10  √  null Transaction line ID (internal)
fact_acct m_locator_id numeric 10  √  null Warehouse Locator
fact_acct m_product_id numeric 10  √  null Product, Service, Item
fact_acct postingtype bpchar 1 The type of posted amount for the transaction
fact_acct qty numeric 0  √  0 Quantity
fact_acct record_id numeric 10 Direct internal record ID
fact_acct updated timestamp 29,6 now() Date this record was updated
fact_acct updatedby numeric 10 User who updated this records
fact_acct user1_id numeric 10  √  null User defined list element #1
fact_acct user2_id numeric 10  √  null User defined list element #2
fact_acct userelement1_id numeric 10  √  null User defined accounting Element
fact_acct userelement2_id numeric 10  √  null User defined accounting Element
m_product ad_client_id numeric 10 Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within tenant
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 510 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