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

idempiere9.adempiere contains 919 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_elementvalue accountsign bpchar 1 Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue accounttype bpchar 1 Indicates the type of account
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
c_country allowcitiesoutoflist bpchar 1  √  'Y'::bpchar A flag to allow cities, currently not in the list, to be entered
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
c_bankaccount bankaccounttype bpchar 1 Bank Account Type
c_bp_bankaccount bankaccounttype bpchar 1  √  null Bank Account Type
c_elementvalue bpartnertype bpchar 1  √  NULL::bpchar Business Partner Type
c_bp_bankaccount bpbankacctuse bpchar 1  √  null Business Partner Bank Account usage
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
c_project copyfrom bpchar 1  √  null Copy From Record
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
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_dunning createlevelssequentially bpchar 1 'N'::bpchar Create Dunning Letter by level sequentially
c_bp_bankaccount creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
c_element elementtype bpchar 1 Element Type (account or user defined)
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_project generateto bpchar 1  √  null Generate To
c_acctschema hasalias bpchar 1 'Y'::bpchar Ability to select (partial) account combinations by an Alias
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_acctschema hascombination bpchar 1 'Y'::bpchar Combination of account elements are checked
c_country haspostal_add bpchar 1 'N'::bpchar Has Additional Postal Code
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
c_country hasregion bpchar 1 'N'::bpchar Country contains Regions
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
c_acctschema isaccrual bpchar 1 'Y'::bpchar Indicates if Accrual or Cash Based accounting will be used
c_bp_bankaccount isach bpchar 1 'N'::bpchar Automatic Clearing House
c_acctschema isactive bpchar 1 'Y'::bpchar The record is active in the system
c_activity isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bank isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bankaccount isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_bankaccount isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_withholding isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_calendar isactive bpchar 1 'Y'::bpchar The record is active in the system
c_campaign isactive bpchar 1 'Y'::bpchar The record is active in the system
c_channel isactive bpchar 1 'Y'::bpchar The record is active in the system
c_city isactive bpchar 1 'Y'::bpchar The record is active in the system
c_conversion_rate isactive bpchar 1 'Y'::bpchar The record is active in the system
c_country isactive bpchar 1 'Y'::bpchar The record is active in the system
c_countrygroup isactive bpchar 1 'Y'::bpchar The record is active in the system
c_countrygroupcountry isactive bpchar 1 'Y'::bpchar The record is active in the system
c_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctypecounter isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunning isactive bpchar 1 'Y'::bpchar The record is active in the system
c_element isactive bpchar 1 'Y'::bpchar The record is active in the system
c_elementvalue isactive bpchar 1 'Y'::bpchar The record is active in the system
c_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_nonbusinessday isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentterm isactive bpchar 1 'Y'::bpchar The record is active in the system
c_period isactive bpchar 1 'Y'::bpchar The record is active in the system
c_periodcontrol isactive bpchar 1 'Y'::bpchar The record is active in the system
c_project isactive bpchar 1 'Y'::bpchar The record is active in the system
c_region isactive bpchar 1 'Y'::bpchar The record is active in the system
c_salesregion isactive bpchar 1 'Y'::bpchar The record is active in the system
c_tax isactive bpchar 1 'Y'::bpchar The record is active in the system
c_taxcategory isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom_conversion isactive bpchar 1 'Y'::bpchar The record is active in the system
c_validcombination isactive bpchar 1 'Y'::bpchar The record is active in the system
c_withholding isactive bpchar 1 'Y'::bpchar The record is active in the system
c_year isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_warehouse 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_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
c_element isbalancing bpchar 1 'N'::bpchar All transactions within an element value must balance (e.g. cost centers)
c_elementvalue isbankaccount bpchar 1  √  'N'::bpchar Indicates if this is the Bank Account
c_bpartner_location isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
c_project iscommitceiling bpchar 1 'N'::bpchar The commitment amount/quantity is the chargeable ceiling
c_project iscommitment bpchar 1 'Y'::bpchar Is this document a (legal) commitment?
c_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_doctypecounter iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_bankaccount isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_dunning isdefault bpchar 1 'N'::bpchar Default value
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
c_region isdefault bpchar 1  √  'N'::bpchar Default value
c_salesregion isdefault bpchar 1 'N'::bpchar Default value
c_tax isdefault bpchar 1 'N'::bpchar Default value
c_taxcategory isdefault bpchar 1 'N'::bpchar Default value
c_uom isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
c_elementvalue isdetailbpartner bpchar 1 'N'::bpchar Manage Business Partners
c_elementvalue isdetailproduct bpchar 1 'N'::bpchar Manage Products
m_warehouse isdisallownegativeinv bpchar 1 'N'::bpchar Negative Inventory is not allowed in this warehouse
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar Correct the tax for payment discount and charges
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_elementvalue isdoccontrolled bpchar 1  √  'N'::bpchar Control account - If an account is controlled by a document, you cannot post manually to it
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
c_tax isdocumentlevel bpchar 1 'Y'::bpchar Tax is calculated on document level (rather than line by line)
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm isduefixed bpchar 1 'N'::bpchar Payment is due on a fixed date
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
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
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar Post the cost adjustment explicitly
c_elementvalue isforeigncurrency bpchar 1  √  'N'::bpchar Balances in foreign currency accounts are held in the nominated currency
c_validcombination isfullyqualified bpchar 1 'Y'::bpchar This account is fully qualified
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
m_warehouse isintransit bpchar 1  √  'N'::bpchar Movement is in transit
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
c_bp_withholding ismandatorywithholding bpchar 1 'N'::bpchar Monies must be withheld
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_element isnaturalaccount bpchar 1 'Y'::bpchar The primary natural account
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar Payment due on the next business day
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Pricelist
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
c_bank isownbank bpchar 1 'N'::bpchar Bank for this Organization
m_product isownbox bpchar 1 'N'::bpchar Own Box
c_withholding ispaidto3party bpchar 1 'Y'::bpchar Amount paid to someone other than the Business Partner
c_bpartner_location ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
c_withholding ispercentwithholding bpchar 1 'Y'::bpchar Withholding amount is a percentage of the invoice amount
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_country ispostcodelookup bpchar 1 'N'::bpchar Does this country have a post code web service
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_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
c_bpartner_location ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
c_bpartner_location isremitto bpchar 1 'Y'::bpchar Business Partner payment address
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_tax issalestax bpchar 1 'N'::bpchar This is a sales tax (i.e. not a value added tax)
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
c_bpartner_location isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_activity issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_campaign issummary bpchar 1 'N'::bpchar This is a summary entity
c_elementvalue issummary bpchar 1 'N'::bpchar This is a summary entity
c_project issummary bpchar 1 'N'::bpchar This is a summary entity
c_salesregion issummary bpchar 1 'N'::bpchar This is a summary entity
c_tax issummary bpchar 1 'N'::bpchar This is a summary entity
m_product 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_tax istaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on sales
c_withholding istaxprorated bpchar 1 'N'::bpchar Tax is Prorated
c_withholding istaxwithholding bpchar 1 'Y'::bpchar This is a tax related withholding
c_bp_withholding istemporaryexempt bpchar 1 'N'::bpchar Temporarily do not withhold taxes
m_product istoformule bpchar 1  √  null
c_acctschema istradediscountposted bpchar 1 'N'::bpchar Generate postings for trade discounts
c_doctypecounter isvalid bpchar 1 'N'::bpchar Element is valid
c_location isvalid bpchar 1  √  'N'::bpchar Element is valid
c_paymentterm isvalid bpchar 1 'N'::bpchar Element is valid
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
c_paymentterm netday bpchar 1  √  null Day when payment is due net
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar Payment term usage indicates if this payment term is used for sales, purchases or both.
c_periodcontrol periodaction bpchar 1 Action taken for this period
c_periodcontrol periodstatus bpchar 1  √  null Current state of this period
c_period periodtype bpchar 1 Period Type
c_elementvalue postactual bpchar 1 'Y'::bpchar Actual Values can be posted
c_elementvalue postbudget bpchar 1 'Y'::bpchar Budget values can be posted
c_elementvalue postencumbrance bpchar 1 'Y'::bpchar Post commitments to this account
c_elementvalue poststatistical bpchar 1 'Y'::bpchar Post statistical quantities to this account?
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_acctschema processing bpchar 1  √  null Process Now
c_doctypecounter processing bpchar 1  √  null Process Now
c_paymentterm processing bpchar 1  √  null Process Now
c_period processing bpchar 1  √  null Process Now
c_periodcontrol processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
c_year processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
c_project projectcategory bpchar 1  √  'N'::bpchar Project Category
c_project projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
c_bp_bankaccount r_avsaddr bpchar 1  √  null This address has been verified
c_bp_bankaccount r_avszip bpchar 1  √  null The Zip Code has been verified
c_bpartner rating bpchar 1  √  null Classification or Importance
c_tax requirestaxcertificate bpchar 1 'N'::bpchar This tax rate requires the Business Partner to be tax exempt
c_dunning senddunningletter bpchar 1 'Y'::bpchar Indicates if dunning letters will be sent
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_acctschema separator bpchar 1 Element Separator
m_warehouse separator bpchar 1 Element Separator
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_tax sopotype bpchar 1 'B'::bpchar Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
c_location validateaddress bpchar 1  √  NULL::bpchar Validate Address
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_doctypecounter docaction bpchar 2  √  null The targeted status of the document
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
c_doctype docbasetype bpchar 3 Logical type of document
c_periodcontrol docbasetype bpchar 3 Logical type of document
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
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_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
c_campaign costs numeric 0 0 Costs in accounting currency
c_bankaccount creditlimit numeric 0 0 Amount of Credit allowed
c_bankaccount currentbalance numeric 0 0 Current Balance
c_paymentterm discount numeric 0 Discount in percent
c_paymentterm discount2 numeric 0 Discount in percent
c_conversion_rate dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
c_uom_conversion dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
c_currency emurate numeric 0  √  0 Official rate to the Euro
c_withholding fixamt numeric 0  √  0 Fix amounted amount to be levied or paid
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_project invoicedamt numeric 0 0 The amount invoiced
c_project invoicedqty numeric 0 0 The quantity invoiced
c_withholding maxamt numeric 0  √  0 Maximum Amount in invoice currency
c_withholding minamt numeric 0  √  0 Minimum Amount in invoice currency
c_conversion_rate multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
c_uom_conversion multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
c_withholding percent numeric 0  √  0 Percentage
c_project plannedamt numeric 0 0 Planned amount for this project
c_project plannedmarginamt numeric 0 0 Project's planned margin amount
c_project plannedqty numeric 0 0 Planned quantity for this project
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_project projectbalanceamt numeric 0 0 Total Project Balance
c_tax rate numeric 0 Rate or Tax or Exchange
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_withholding thresholdmax numeric 0  √  0 Maximum gross amount for withholding calculation (0=no limit)
c_withholding thresholdmin numeric 0  √  0 Minimum gross amount for withholding calculation
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
c_validcombination account_id numeric 10 Account used
c_acctschema ad_client_id numeric 10 Client/Tenant for this installation.
c_activity ad_client_id numeric 10 Client/Tenant for this installation.
c_bank ad_client_id numeric 10 Client/Tenant for this installation.
c_bankaccount ad_client_id numeric 10 Client/Tenant for this installation.
c_bp_bankaccount ad_client_id numeric 10 Client/Tenant for this installation.
c_bp_withholding ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_location ad_client_id numeric 10 Client/Tenant for this installation.
c_calendar ad_client_id numeric 10 Client/Tenant for this installation.
c_campaign ad_client_id numeric 10 Client/Tenant for this installation.
c_channel ad_client_id numeric 10 Client/Tenant for this installation.
c_city ad_client_id numeric 10 Client/Tenant for this installation.
c_conversion_rate ad_client_id numeric 10 Client/Tenant for this installation.
c_country ad_client_id numeric 10 Client/Tenant for this installation.
c_countrygroup ad_client_id numeric 10 Client/Tenant for this installation.
c_countrygroupcountry ad_client_id numeric 10 Client/Tenant for this installation.
c_currency ad_client_id numeric 10 Client/Tenant for this installation.
c_doctype ad_client_id numeric 10 Client/Tenant for this installation.
c_doctypecounter ad_client_id numeric 10 Client/Tenant for this installation.
c_dunning ad_client_id numeric 10 Client/Tenant for this installation.
c_element ad_client_id numeric 10 Client/Tenant for this installation.
c_elementvalue ad_client_id numeric 10 Client/Tenant for this installation.
c_location ad_client_id numeric 10 Client/Tenant for this installation.
c_nonbusinessday ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentterm ad_client_id numeric 10 Client/Tenant for this installation.
c_period ad_client_id numeric 10 Client/Tenant for this installation.
c_periodcontrol ad_client_id numeric 10 Client/Tenant for this installation.
c_project ad_client_id numeric 10 Client/Tenant for this installation.
c_region ad_client_id numeric 10 Client/Tenant for this installation.
c_salesregion ad_client_id numeric 10 Client/Tenant for this installation.
c_tax ad_client_id numeric 10 Client/Tenant for this installation.
c_taxcategory ad_client_id numeric 10 Client/Tenant for this installation.
c_uom ad_client_id numeric 10 Client/Tenant for this installation.
c_uom_conversion ad_client_id numeric 10 Client/Tenant for this installation.
c_validcombination ad_client_id numeric 10 Client/Tenant for this installation.
c_withholding ad_client_id numeric 10 Client/Tenant for this installation.
c_year ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
c_acctschema ad_org_id numeric 10 Organizational entity within client
c_activity ad_org_id numeric 10 Organizational entity within client
c_bank ad_org_id numeric 10 Organizational entity within client
c_bankaccount ad_org_id numeric 10 Organizational entity within client
c_bp_bankaccount ad_org_id numeric 10 Organizational entity within client
c_bp_withholding ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner_location ad_org_id numeric 10 Organizational entity within client
c_calendar ad_org_id numeric 10 Organizational entity within client
c_campaign ad_org_id numeric 10 Organizational entity within client
c_channel ad_org_id numeric 10 Organizational entity within client
c_city ad_org_id numeric 10 Organizational entity within client
c_conversion_rate ad_org_id numeric 10 Organizational entity within client
c_country ad_org_id numeric 10 Organizational entity within client
c_countrygroup ad_org_id numeric 10 Organizational entity within client
c_countrygroupcountry ad_org_id numeric 10 Organizational entity within client
c_currency ad_org_id numeric 10 Organizational entity within client
c_doctype ad_org_id numeric 10 Organizational entity within client
c_doctypecounter ad_org_id numeric 10 Organizational entity within client
c_dunning ad_org_id numeric 10 Organizational entity within client
c_element ad_org_id numeric 10 Organizational entity within client
c_elementvalue ad_org_id numeric 10 Organizational entity within client
c_location ad_org_id numeric 10 Organizational entity within client
c_nonbusinessday ad_org_id numeric 10 Organizational entity within client
c_paymentterm ad_org_id numeric 10 Organizational entity within client
c_period ad_org_id numeric 10 Organizational entity within client
c_periodcontrol ad_org_id numeric 10 Organizational entity within client
c_project ad_org_id numeric 10 Organizational entity within client
c_region ad_org_id numeric 10 Organizational entity within client
c_salesregion ad_org_id numeric 10 Organizational entity within client
c_tax ad_org_id numeric 10 Organizational entity within client
c_taxcategory ad_org_id numeric 10 Organizational entity within client
c_uom ad_org_id numeric 10 Organizational entity within client
c_uom_conversion ad_org_id numeric 10 Organizational entity within client
c_validcombination ad_org_id numeric 10 Organizational entity within client
c_withholding ad_org_id numeric 10 Organizational entity within client
c_year ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_warehouse 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_acctschema ad_orgonly_id numeric 10  √  null Create posting entries only for this organization
c_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
c_validcombination ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_channel ad_printcolor_id numeric 10  √  null Color used for printing and display
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
c_tax ad_rule_id numeric 10  √  null Rule
c_element ad_tree_id numeric 10  √  null Identifies a Tree
c_bp_bankaccount ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_withholding beneficiary numeric 10  √  null Business Partner to whom payment is made
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_acctschema c_acctschema_id numeric 10 Rules for accounting
c_validcombination c_acctschema_id numeric 10 Rules for accounting
c_activity c_activity_id numeric 10 Business Activity
c_project c_activity_id numeric 10  √  NULL::numeric Business Activity
c_validcombination c_activity_id numeric 10  √  null Business Activity
c_location c_addressvalidation_id numeric 10  √  NULL::numeric Address Validation
c_bank c_bank_id numeric 10 Bank
c_bankaccount c_bank_id numeric 10 Bank
c_bp_bankaccount c_bank_id numeric 10  √  null Bank
c_bankaccount c_bankaccount_id numeric 10 Account at the Bank
c_elementvalue c_bankaccount_id numeric 10  √  null Account at the Bank
c_bp_bankaccount c_bp_bankaccount_id numeric 10 Bank Account of the Business Partner
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bp_bankaccount c_bpartner_id numeric 10 Identifies a Business Partner
c_bp_withholding c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_id numeric 10 Identifies a Business Partner
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_validcombination c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_project c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_project c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
c_calendar c_calendar_id numeric 10 Accounting Calendar Name
c_nonbusinessday c_calendar_id numeric 10 Accounting Calendar Name
c_year c_calendar_id numeric 10 Accounting Calendar Name
c_campaign c_campaign_id numeric 10 Marketing Campaign
c_project c_campaign_id numeric 10  √  null Marketing Campaign
c_validcombination c_campaign_id numeric 10  √  null Marketing Campaign
c_campaign c_channel_id numeric 10  √  null Sales Channel
c_channel c_channel_id numeric 10 Sales Channel
c_city c_city_id numeric 10 City
c_location c_city_id numeric 10  √  null City
c_conversion_rate c_conversion_rate_id numeric 10 Rate used for converting currencies
c_conversion_rate c_conversiontype_id numeric 10 Currency Conversion Rate Type
c_city c_country_id numeric 10  √  null Country
c_country c_country_id numeric 10 Country
c_countrygroupcountry c_country_id numeric 10  √  NULL::numeric Country
c_location c_country_id numeric 10 Country
c_nonbusinessday c_country_id numeric 10  √  NULL::numeric Country
c_region c_country_id numeric 10 Country
c_tax c_country_id numeric 10  √  null Country
c_countrygroup c_countrygroup_id numeric 10 Country Group
c_countrygroupcountry c_countrygroup_id numeric 10  √  NULL::numeric Country Group
c_countrygroupcountry c_countrygroupcountry_id numeric 10 Country on Country Group
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_acctschema c_currency_id numeric 10 The Currency for this record
c_bankaccount c_currency_id numeric 10 The Currency for this record
c_conversion_rate c_currency_id numeric 10 The Currency for this record
c_country c_currency_id numeric 10  √  null The Currency for this record
c_currency c_currency_id numeric 10 The Currency for this record
c_elementvalue c_currency_id numeric 10  √  null The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
c_conversion_rate c_currency_id_to numeric 10 Target currency
c_doctype c_doctype_id numeric 10 Document type or rules
c_doctypecounter c_doctype_id numeric 10 Document type or rules
c_doctypecounter c_doctypecounter_id numeric 10 Counter Document Relationship
c_doctype c_doctypedifference_id numeric 10  √  null Document type for generating in dispute Shipments
c_doctype c_doctypeinvoice_id numeric 10  √  null Document type used for invoices generated from this sales document
c_doctype c_doctypeproforma_id numeric 10  √  null Document type used for pro forma invoices generated from this sales document
c_doctype c_doctypeshipment_id numeric 10  √  null Document type used for shipments generated from this sales document
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_dunning c_dunning_id numeric 10 Dunning Rules for overdue invoices
c_element c_element_id numeric 10 Accounting Element
c_elementvalue c_element_id numeric 10 Accounting Element
c_elementvalue c_elementvalue_id numeric 10 Account Element
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_bank c_location_id numeric 10  √  null Location or Address
c_bpartner_location c_location_id numeric 10  √  null Location or Address
c_location c_location_id numeric 10 Location or Address
m_warehouse c_location_id numeric 10 Location or Address
c_validcombination c_locfrom_id numeric 10  √  null Location that inventory was moved from
c_validcombination c_locto_id numeric 10  √  null Location that inventory was moved to
c_nonbusinessday c_nonbusinessday_id numeric 10 Day on which business is not transacted
c_bp_bankaccount c_paymentprocessor_id numeric 10  √  NULL::numeric Payment processor for electronic payments
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_withholding c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_acctschema c_period_id numeric 10  √  null Period of the Calendar
c_period c_period_id numeric 10 Period of the Calendar
c_periodcontrol c_period_id numeric 10 Period of the Calendar
c_periodcontrol c_periodcontrol_id numeric 10 Period Control
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_project c_project_id numeric 10 Financial Project
c_validcombination c_project_id numeric 10  √  null Financial Project
c_project c_projecttype_id numeric 10  √  null Type of the project
c_city c_region_id numeric 10  √  null Identifies a geographical Region
c_location c_region_id numeric 10  √  null Identifies a geographical Region
c_region c_region_id numeric 10 Identifies a geographical Region
c_tax c_region_id numeric 10  √  null Identifies a geographical Region
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_bpartner_location c_salesregion_id numeric 10  √  null Sales coverage region
c_salesregion c_salesregion_id numeric 10 Sales coverage region
c_validcombination c_salesregion_id numeric 10  √  null Sales coverage region
c_validcombination c_subacct_id numeric 10  √  null Sub account for Element Value
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_tax c_tax_id numeric 10 Tax identifier
c_tax c_taxcategory_id numeric 10 Tax Category
c_taxcategory c_taxcategory_id numeric 10 Tax Category
m_product c_taxcategory_id numeric 10 Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_tax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_uom_conversion c_uom_conversion_id numeric 10 Unit of Measure Conversion
c_uom c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_to_id numeric 10 Target or destination Unit of Measure
c_validcombination c_validcombination_id numeric 10 Valid Account Combination
c_bp_withholding c_withholding_id numeric 10 Withholding type defined
c_withholding c_withholding_id numeric 10 Withholding type defined
c_period c_year_id numeric 10 Calendar Year
c_year c_year_id numeric 10 Calendar Year
c_currency costingprecision numeric 10 Rounding used costing calculations
c_uom costingprecision numeric 10 Rounding used costing calculations
c_doctypecounter counter_c_doctype_id numeric 10  √  null Generated Counter Document Type (To)
c_acctschema createdby numeric 10 User who created this records
c_activity createdby numeric 10 User who created this records
c_bank createdby numeric 10 User who created this records
c_bankaccount createdby numeric 10 User who created this records
c_bp_bankaccount createdby numeric 10 User who created this records
c_bp_withholding createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_bpartner_location createdby numeric 10 User who created this records
c_calendar createdby numeric 10 User who created this records
c_campaign createdby numeric 10 User who created this records
c_channel createdby numeric 10 User who created this records
c_city createdby numeric 10 User who created this records
c_conversion_rate createdby numeric 10 User who created this records
c_country createdby numeric 10 User who created this records
c_countrygroup createdby numeric 10 User who created this records
c_countrygroupcountry createdby numeric 10 User who created this records
c_currency createdby numeric 10 User who created this records
c_doctype createdby numeric 10 User who created this records
c_doctypecounter createdby numeric 10 User who created this records
c_dunning createdby numeric 10 User who created this records
c_element createdby numeric 10 User who created this records
c_elementvalue createdby numeric 10 User who created this records
c_location createdby numeric 10 User who created this records
c_nonbusinessday createdby numeric 10 User who created this records
c_paymentterm createdby numeric 10 User who created this records
c_period createdby numeric 10 User who created this records
c_periodcontrol createdby numeric 10 User who created this records
c_project createdby numeric 10 User who created this records
c_region createdby numeric 10 User who created this records
c_salesregion createdby numeric 10 User who created this records
c_tax createdby numeric 10 User who created this records
c_taxcategory createdby numeric 10 User who created this records
c_uom createdby numeric 10 User who created this records
c_uom_conversion createdby numeric 10 User who created this records
c_validcombination createdby numeric 10 User who created this records
c_withholding createdby numeric 10 User who created this records
c_year createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_warehouse createdby numeric 10 User who created this records
c_bp_bankaccount creditcardexpmm numeric 10  √  null Expiry Month
c_bp_bankaccount creditcardexpyy numeric 10  √  null Expiry Year
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
c_paymentterm discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_paymentterm discountdays2 numeric 10 Number of days from invoice date to be eligible for discount
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_doctype documentcopies numeric 10 Number of copies to be printed
c_paymentterm fixmonthcutoff numeric 10  √  null Last day to include for next due date
c_paymentterm fixmonthday numeric 10  √  null Day of the month of the due date
c_paymentterm fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
c_doctype gl_category_id numeric 10 General Ledger Category
c_paymentterm gracedays numeric 10 Days after due date to send first dunning letter
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
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
c_acctschema m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
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
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_product m_product_category_id numeric 10 Category of a Product
c_uom_conversion m_product_id numeric 10  √  null Product, Service, Item
c_validcombination m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
c_paymentterm netdays numeric 10 Net Days in which payment is due
c_bpartner numberemployees numeric 10  √  null Number of employees
c_tax parent_tax_id numeric 10  √  null Parent Tax indicates a tax that is made up of multiple taxes
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_period periodno numeric 10 Unique Period Number
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
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
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_salesregion salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product 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 shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
c_tax to_country_id numeric 10  √  null Receiving Country
c_tax to_region_id numeric 10  √  null Receiving Region
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
c_acctschema updatedby numeric 10 User who updated this records
c_activity updatedby numeric 10 User who updated this records
c_bank updatedby numeric 10 User who updated this records
c_bankaccount updatedby numeric 10 User who updated this records
c_bp_bankaccount updatedby numeric 10 User who updated this records
c_bp_withholding updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner_location updatedby numeric 10 User who updated this records
c_calendar updatedby numeric 10 User who updated this records
c_campaign updatedby numeric 10 User who updated this records
c_channel updatedby numeric 10 User who updated this records
c_city updatedby numeric 10 User who updated this records
c_conversion_rate updatedby numeric 10 User who updated this records
c_country updatedby numeric 10 User who updated this records
c_countrygroup updatedby numeric 10 User who updated this records
c_countrygroupcountry updatedby numeric 10 User who updated this records
c_currency updatedby numeric 10 User who updated this records
c_doctype updatedby numeric 10 User who updated this records
c_doctypecounter updatedby numeric 10 User who updated this records
c_dunning updatedby numeric 10 User who updated this records
c_element updatedby numeric 10 User who updated this records
c_elementvalue updatedby numeric 10 User who updated this records
c_location updatedby numeric 10 User who updated this records
c_nonbusinessday updatedby numeric 10 User who updated this records
c_paymentterm updatedby numeric 10 User who updated this records
c_period updatedby numeric 10 User who updated this records
c_periodcontrol updatedby numeric 10 User who updated this records
c_project updatedby numeric 10 User who updated this records
c_region updatedby numeric 10 User who updated this records
c_salesregion updatedby numeric 10 User who updated this records
c_tax updatedby numeric 10 User who updated this records
c_taxcategory updatedby numeric 10 User who updated this records
c_uom updatedby numeric 10 User who updated this records
c_uom_conversion updatedby numeric 10 User who updated this records
c_validcombination updatedby numeric 10 User who updated this records
c_withholding updatedby numeric 10 User who updated this records
c_year updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_warehouse updatedby numeric 10 User who updated this records
c_validcombination user1_id numeric 10  √  null User defined list element #1
c_validcombination user2_id numeric 10  √  null User defined list element #2
c_validcombination userelement1_id numeric 10  √  null User defined accounting Element
c_validcombination userelement2_id numeric 10  √  null User defined accounting Element
c_acctschema created timestamp 29,6 now() Date this record was created
c_activity created timestamp 29,6 now() Date this record was created
c_bank created timestamp 29,6 now() Date this record was created
c_bankaccount created timestamp 29,6 now() Date this record was created
c_bp_bankaccount created timestamp 29,6 now() Date this record was created
c_bp_withholding created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner_location created timestamp 29,6 now() Date this record was created
c_calendar created timestamp 29,6 now() Date this record was created
c_campaign created timestamp 29,6 now() Date this record was created
c_channel created timestamp 29,6 now() Date this record was created
c_city created timestamp 29,6 now() Date this record was created
c_conversion_rate created timestamp 29,6 now() Date this record was created
c_country created timestamp 29,6 now() Date this record was created
c_countrygroup created timestamp 29,6 statement_timestamp() Date this record was created
c_countrygroupcountry created timestamp 29,6 statement_timestamp() Date this record was created
c_currency created timestamp 29,6 now() Date this record was created
c_doctype created timestamp 29,6 now() Date this record was created
c_doctypecounter created timestamp 29,6 now() Date this record was created
c_dunning created timestamp 29,6 now() Date this record was created
c_element created timestamp 29,6 now() Date this record was created
c_elementvalue created timestamp 29,6 now() Date this record was created
c_location created timestamp 29,6 now() Date this record was created
c_nonbusinessday created timestamp 29,6 now() Date this record was created
c_paymentterm created timestamp 29,6 now() Date this record was created
c_period created timestamp 29,6 now() Date this record was created
c_periodcontrol created timestamp 29,6 now() Date this record was created
c_project created timestamp 29,6 now() Date this record was created
c_region created timestamp 29,6 now() Date this record was created
c_salesregion created timestamp 29,6 now() Date this record was created
c_tax created timestamp 29,6 now() Date this record was created
c_taxcategory created timestamp 29,6 now() Date this record was created
c_uom created timestamp 29,6 now() Date this record was created
c_uom_conversion created timestamp 29,6 now() Date this record was created
c_validcombination created timestamp 29,6 now() Date this record was created
c_withholding created timestamp 29,6 now() Date this record was created
c_year created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_warehouse created timestamp 29,6 now() Date this record was created
c_nonbusinessday date1 timestamp 29,6 Date when business is not conducted
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_countrygroup datefrom timestamp 29,6  √  null Starting date for a range
c_countrygroupcountry datefrom timestamp 29,6  √  null Starting date for a range
c_countrygroup dateto timestamp 29,6  √  null End date of a date range
c_countrygroupcountry dateto timestamp 29,6  √  null End date of a date range
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
c_campaign enddate timestamp 29,6  √  null Last effective date (inclusive)
c_period enddate timestamp 29,6  √  null Last effective date (inclusive)
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_campaign startdate timestamp 29,6  √  null First effective day (inclusive)
c_period startdate timestamp 29,6 First effective day (inclusive)
c_acctschema updated timestamp 29,6 now() Date this record was updated
c_activity updated timestamp 29,6 now() Date this record was updated
c_bank updated timestamp 29,6 now() Date this record was updated
c_bankaccount updated timestamp 29,6 now() Date this record was updated
c_bp_bankaccount updated timestamp 29,6 now() Date this record was updated
c_bp_withholding updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner_location updated timestamp 29,6 now() Date this record was updated
c_calendar updated timestamp 29,6 now() Date this record was updated
c_campaign updated timestamp 29,6 now() Date this record was updated
c_channel updated timestamp 29,6 now() Date this record was updated
c_city updated timestamp 29,6 now() Date this record was updated
c_conversion_rate updated timestamp 29,6 now() Date this record was updated
c_country updated timestamp 29,6 now() Date this record was updated
c_countrygroup updated timestamp 29,6 statement_timestamp() Date this record was updated
c_countrygroupcountry updated timestamp 29,6 statement_timestamp() Date this record was updated
c_currency updated timestamp 29,6 now() Date this record was updated
c_doctype updated timestamp 29,6 now() Date this record was updated
c_doctypecounter updated timestamp 29,6 now() Date this record was updated
c_dunning updated timestamp 29,6 now() Date this record was updated
c_element updated timestamp 29,6 now() Date this record was updated
c_elementvalue updated timestamp 29,6 now() Date this record was updated
c_location updated timestamp 29,6 now() Date this record was updated
c_nonbusinessday updated timestamp 29,6 now() Date this record was updated
c_paymentterm updated timestamp 29,6 now() Date this record was updated
c_period updated timestamp 29,6 now() Date this record was updated
c_periodcontrol updated timestamp 29,6 now() Date this record was updated
c_project updated timestamp 29,6 now() Date this record was updated
c_region updated timestamp 29,6 now() Date this record was updated
c_salesregion updated timestamp 29,6 now() Date this record was updated
c_tax updated timestamp 29,6 now() Date this record was updated
c_taxcategory updated timestamp 29,6 now() Date this record was updated
c_uom updated timestamp 29,6 now() Date this record was updated
c_uom_conversion updated timestamp 29,6 now() Date this record was updated
c_validcombination updated timestamp 29,6 now() Date this record was updated
c_withholding updated timestamp 29,6 now() Date this record was updated
c_year updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_warehouse updated timestamp 29,6 now() Date this record was updated
c_conversion_rate validfrom timestamp 29,6 Valid from including this date (first day)
c_elementvalue validfrom timestamp 29,6  √  null Valid from including this date (first day)
c_tax validfrom timestamp 29,6 Valid from including this date (first day)
c_conversion_rate validto timestamp 29,6  √  null Valid to including this date (last day)
c_elementvalue validto timestamp 29,6  √  null Valid to including this date (last day)
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
c_bp_bankaccount creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_uom x12de355 varchar 4 UOM EDI X12 Code
c_bpartner ad_language varchar 6  √  null Language for this entity
c_country ad_language varchar 6  √  null Language for this entity
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_city areacode varchar 10  √  null Phone Area Code
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_year fiscalyear varchar 10 The Fiscal Year
c_city locode varchar 10  √  null Location code - UN/LOCODE
c_city postal varchar 10  √  null Postal code
c_location postal varchar 10  √  null Postal code
c_location postal_add varchar 10  √  null Additional ZIP or Postal code
c_tax taxindicator varchar 10  √  null Short form for Tax to be printed on documents
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
m_product classification varchar 12  √  null Classification for grouping
c_city coordinates varchar 15  √  null Location coordinate
c_bp_bankaccount a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_bp_bankaccount a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_bp_bankaccount a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_bankaccount accountno varchar 20 Account Number
c_bp_bankaccount accountno varchar 20  √  null Account Number
c_taxcategory commoditycode varchar 20  √  null Commodity code used for tax calculation
c_bp_bankaccount creditcardnumber varchar 20  √  null Credit Card Number
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
c_country displaysequence varchar 20 Format for printing this Address
c_country displaysequencelocal varchar 20  √  null Format for printing this Address locally
c_bp_withholding exemptreason varchar 20  √  null Reason for not withholding
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_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bank routingno varchar 20 Bank Routing Number
c_bp_bankaccount routingno varchar 20  √  null Bank Routing Number
c_bank swiftcode varchar 20  √  null Swift Code or BIC
c_bpartner taxid varchar 20  √  null Tax Identification
m_product versionno varchar 20  √  null Version Number
m_product sku varchar 30  √  null Stock Keeping Unit
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying C_AcctSchema_UU
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_bank c_bank_uu varchar 36  √  NULL::character varying C_Bank_UU
c_bankaccount c_bankaccount_uu varchar 36  √  NULL::character varying C_BankAccount_UU
c_bp_bankaccount c_bp_bankaccount_uu varchar 36  √  NULL::character varying C_BP_BankAccount_UU
c_bp_withholding c_bp_withholding_uu varchar 36  √  NULL::character varying C_BP_Withholding_UU
c_bpartner_location c_bpartner_location_uu varchar 36  √  NULL::character varying C_BPartner_Location_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_calendar c_calendar_uu varchar 36  √  NULL::character varying C_Calendar_UU
c_campaign c_campaign_uu varchar 36  √  NULL::character varying C_Campaign_UU
c_channel c_channel_uu varchar 36  √  NULL::character varying C_Channel_UU
c_city c_city_uu varchar 36  √  NULL::character varying C_City_UU
c_conversion_rate c_conversion_rate_uu varchar 36  √  NULL::character varying C_Conversion_Rate_UU
c_country c_country_uu varchar 36  √  NULL::character varying C_Country_UU
c_countrygroup c_countrygroup_uu varchar 36  √  NULL::character varying C_CountryGroup_UU
c_countrygroupcountry c_countrygroupcountry_uu varchar 36  √  NULL::character varying C_CountryGroupCountry_UU
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
c_doctypecounter c_doctypecounter_uu varchar 36  √  NULL::character varying C_DocTypeCounter_UU
c_dunning c_dunning_uu varchar 36  √  NULL::character varying C_Dunning_UU
c_element c_element_uu varchar 36  √  NULL::character varying C_Element_UU
c_elementvalue c_elementvalue_uu varchar 36  √  NULL::character varying C_ElementValue_UU
c_location c_location_uu varchar 36  √  NULL::character varying C_Location_UU
c_nonbusinessday c_nonbusinessday_uu varchar 36  √  NULL::character varying C_NonBusinessDay_UU
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying C_PaymentTerm_UU
c_period c_period_uu varchar 36  √  NULL::character varying C_Period_UU
c_periodcontrol c_periodcontrol_uu varchar 36  √  NULL::character varying C_PeriodControl_UU
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
c_region c_region_uu varchar 36  √  NULL::character varying C_Region_UU
c_salesregion c_salesregion_uu varchar 36  √  NULL::character varying C_SalesRegion_UU
c_tax c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_taxcategory c_taxcategory_uu varchar 36  √  NULL::character varying C_TaxCategory_UU
c_uom_conversion c_uom_conversion_uu varchar 36  √  NULL::character varying C_UOM_Conversion_UU
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
c_validcombination c_validcombination_uu varchar 36  √  NULL::character varying C_ValidCombination_UU
c_withholding c_withholding_uu varchar 36  √  NULL::character varying C_Withholding_UU
c_year c_year_uu varchar 36  √  NULL::character varying C_Year_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
c_bp_bankaccount a_country varchar 40  √  null Country
c_bp_bankaccount a_state varchar 40  √  null State of the Credit Card or Account holder
c_validcombination alias varchar 40  √  null Defines an alternate method of indicating an account combination.
c_bankaccount bban varchar 40  √  null Basic Bank Account Number
c_bpartner_location fax varchar 40  √  null Facsimile number
c_bankaccount iban varchar 40  √  null International Bank Account Number
c_bp_bankaccount iban varchar 40  √  NULL::character varying International Bank Account Number
c_bpartner_location isdn varchar 40  √  null ISDN or modem line
c_country mediasize varchar 40  √  null Java Media Size
c_bpartner_location phone varchar 40  √  null Identifies a telephone number
c_bpartner_location phone2 varchar 40  √  null Identifies an alternate telephone number.
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_location regionname varchar 40  √  null Name of the Region
c_activity value varchar 40 Search key for the record in the format required - must be unique
c_bankaccount value varchar 40 NULL::character varying Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_campaign value varchar 40 Search key for the record in the format required - must be unique
c_countrygroup value varchar 40 Search key for the record in the format required - must be unique
c_elementvalue value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm value varchar 40 Search key for the record in the format required - must be unique
c_project value varchar 40 Search key for the record in the format required - must be unique
c_salesregion value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 40 Search key for the record in the format required - must be unique
m_warehouse value varchar 40 Search key for the record in the format required - must be unique
c_element vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country lookupclientid varchar 50  √  null The ClientID or Login submitted to the Lookup URL
c_country lookuppassword varchar 50  √  null The password submitted to the Lookup URL
c_bp_bankaccount a_city varchar 60  √  null City or the Credit Card or Account Holder
c_bp_bankaccount a_email varchar 60  √  null Email Address
c_bp_bankaccount a_name varchar 60  √  null Name on Credit Card or Account holder
c_bp_bankaccount a_street varchar 60  √  null Street address of the Credit Card or Account holder
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_country capturesequence varchar 60  √  null Capture Sequence
c_location city varchar 60  √  null Identifies a City
c_validcombination combination varchar 60  √  null Unique combination of account elements
c_bpartner_location customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_bp_bankaccount customerpaymentprofileid varchar 60  √  NULL::character varying Customer Payment Profile ID
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_acctschema name varchar 60 Alphanumeric identifier of the entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_bank name varchar 60 Alphanumeric identifier of the entity
c_bankaccount name varchar 60 NULL::character varying Alphanumeric identifier of the entity
c_bpartner_location name varchar 60 Alphanumeric identifier of the entity
c_calendar name varchar 60 Alphanumeric identifier of the entity
c_campaign name varchar 60 Alphanumeric identifier of the entity
c_channel name varchar 60 Alphanumeric identifier of the entity
c_city name varchar 60 Alphanumeric identifier of the entity
c_country name varchar 60 Alphanumeric identifier of the entity
c_countrygroup name varchar 60 Alphanumeric identifier of the entity
c_doctype name varchar 60 Alphanumeric identifier of the entity
c_doctypecounter name varchar 60 Alphanumeric identifier of the entity
c_dunning name varchar 60 Alphanumeric identifier of the entity
c_element name varchar 60 Alphanumeric identifier of the entity
c_nonbusinessday name varchar 60  √  null Alphanumeric identifier of the entity
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
c_period name varchar 60 Alphanumeric identifier of the entity
c_project name varchar 60 Alphanumeric identifier of the entity
c_region name varchar 60 Alphanumeric identifier of the entity
c_salesregion name varchar 60 Alphanumeric identifier of the entity
c_tax name varchar 60 Alphanumeric identifier of the entity
c_taxcategory name varchar 60 Alphanumeric identifier of the entity
c_uom name varchar 60 Alphanumeric identifier of the entity
c_withholding name varchar 60 Alphanumeric identifier of the entity
m_warehouse name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_bankaccount paymentexportclass varchar 60  √  NULL::character varying Payment Export Class
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
c_country regionname varchar 60  √  null Name of the Region
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
c_country lookupurl varchar 100  √  null The URL of the web service that the plugin connects to in order to retrieve postcode data
m_product descriptionurl varchar 120  √  null URL for the description
m_product downloadurl varchar 120  √  null
m_product imageurl varchar 120  √  null URL of image
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_elementvalue name varchar 120 Alphanumeric identifier of the entity
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_acctschema description varchar 255  √  null Optional short description of the record
c_activity description varchar 255  √  null Optional short description of the record
c_bank description varchar 255  √  null Optional short description of the record
c_bankaccount description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_calendar description varchar 255  √  null Optional short description of the record
c_campaign description varchar 255  √  null Optional short description of the record
c_channel description varchar 255  √  null Optional short description of the record
c_country description varchar 255  √  null Optional short description of the record
c_countrygroup description varchar 255  √  NULL::character varying Optional short description of the record
c_currency description varchar 255 Optional short description of the record
c_doctype description varchar 255  √  null Optional short description of the record
c_doctypecounter description varchar 255  √  null Optional short description of the record
c_dunning description varchar 255  √  null Optional short description of the record
c_element description varchar 255  √  null Optional short description of the record
c_elementvalue description varchar 255  √  null Optional short description of the record
c_paymentterm description varchar 255  √  null Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
c_region description varchar 255  √  null Optional short description of the record
c_salesregion description varchar 255  √  null Optional short description of the record
c_tax description varchar 255  √  null Optional short description of the record
c_taxcategory description varchar 255  √  null Optional short description of the record
c_uom description varchar 255  √  null Optional short description of the record
c_validcombination description varchar 255  √  null Optional short description of the record
c_withholding description varchar 255  √  null Optional short description of the record
c_year description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_warehouse description varchar 255  √  null Optional short description of the record
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
c_country lookupclassname varchar 255  √  null The class name of the postcode lookup plugin
m_product name varchar 255 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_bpartner so_description varchar 255  √  null Description to be used on orders
c_location comments varchar 2000  √  NULL::character varying Comments or additional information
c_doctype documentnote varchar 2000  √  null Additional information for a Document
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
m_product documentnote varchar 2000  √  null Additional information for a Document
c_activity help varchar 2000  √  null Comment or Hint
c_countrygroup help varchar 2000  √  NULL::character varying Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
c_project note varchar 2000  √  null Optional additional user defined information
c_location result varchar 2000  √  NULL::character varying Result of the action taken