| SchemaSpy Analysis of idempiere11.adempiere - ColumnsAccounting Defaults | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:45 +0100 |
| |||||
|
| ||||||
idempiere11.adempiere contains 658 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | |
|---|---|---|---|---|---|---|---|
| a_asset_acct | a_depreciation_manual_amount | numeric | 0 | √ | null | A_Depreciation_Manual_Amount | |
| a_asset_group_acct | a_depreciation_manual_amount | numeric | 0 | √ | null | A_Depreciation_Manual_Amount | |
| a_asset_acct | a_depreciation_variable_perc | numeric | 0 | √ | null | Variable Percent | |
| a_asset_group_acct | a_depreciation_variable_perc | numeric | 0 | √ | null | Variable Percent | |
| a_asset_acct | a_depreciation_variable_perc_f | numeric | 0 | √ | null | Variable Percent (fiscal) | |
| a_asset_group_acct | a_depreciation_variable_perc_f | numeric | 0 | √ | null | Variable Percent (fiscal) | |
| a_asset_acct | a_salvage_value | numeric | 0 | √ | (0)::numeric | Asset Salvage Value | |
| a_asset_acct | a_split_percent | numeric | 0 | (1)::numeric | Split Percent | ||
| a_asset_group_acct | a_split_percent | numeric | 0 | (1)::numeric | Split Percent | ||
| 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 | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
| c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
| 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_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
| m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
| a_asset_group_acct | uselifeyears | numeric | 0 | √ | null | Years of the usable life of the asset | |
| a_asset_group_acct | uselifeyears_f | numeric | 0 | '0'::numeric | Use Life - Years (fiscal) | ||
| m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
| m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
| c_acctschema | autoperiodcontrol | bpchar | 1 | 'N'::bpchar | If selected, the periods are automatically opened and closed | ||
| c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | Create Commitment and/or Reservations for Budget Control | ||
| m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| c_acctschema | costinglevel | bpchar | 1 | 'C'::bpchar | The lowest level to accumulate Costing Information | ||
| m_product_category_acct | costinglevel | bpchar | 1 | √ | null | The lowest level to accumulate Costing Information | |
| c_acctschema | costingmethod | bpchar | 1 | Indicates how Costs will be calculated | |||
| m_product_category_acct | costingmethod | bpchar | 1 | √ | null | Indicates how Costs will be calculated | |
| 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_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
| 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_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 | ||
| a_asset_acct | isactive | bpchar | 1 | The record is active in the system | |||
| a_asset_group_acct | isactive | bpchar | 1 | √ | null | The record is active in the system | |
| ad_clientinfo | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_acctschema | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_acctschema_default | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_acctschema_gl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bankaccount_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_customer_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_employee_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_group_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_vendor_acct | 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_charge_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_interorg_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_project_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_tax_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_withholding_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_product_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_product_category_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_warehouse_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| 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 | ||
| m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
| ad_clientinfo | isconfirmondocclose | bpchar | 1 | 'N'::bpchar | Show Confirmation On Document Action Close | ||
| ad_clientinfo | isconfirmondocvoid | bpchar | 1 | 'N'::bpchar | Show Confirmation On Document Action Void | ||
| c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
| c_acctschema | isdiscountcorrectstax | bpchar | 1 | 'N'::bpchar | Correct the tax for payment discount and charges | ||
| ad_clientinfo | isdiscountlineamt | bpchar | 1 | 'Y'::bpchar | Payment Discount calculation does not include Taxes and Charges | ||
| c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
| m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
| c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
| m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
| c_acctschema | isexplicitcostadjustment | bpchar | 1 | 'N'::bpchar | Post the cost adjustment explicitly | ||
| 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 | ||
| 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 | ||
| m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
| m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
| m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the pick list | ||
| c_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_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
| m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
| c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
| 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 | ||
| c_bpartner | 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 | |
| m_product | istoformule | bpchar | 1 | √ | null | ||
| c_acctschema | istradediscountposted | bpchar | 1 | 'N'::bpchar | Generate postings for trade discounts | ||
| 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_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
| c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
| a_asset_acct | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
| a_asset_group_acct | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
| a_asset_acct | processing | bpchar | 1 | √ | 'Y'::bpchar | Process Now | |
| a_asset_group_acct | processing | bpchar | 1 | √ | null | Process Now | |
| c_acctschema | processing | bpchar | 1 | √ | null | Process Now | |
| c_acctschema_default | processing | bpchar | 1 | √ | null | Process Now | |
| c_bp_group_acct | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | processing | bpchar | 1 | √ | null | Process Now | |
| m_product_category_acct | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
| c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
| c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| c_acctschema | separator | bpchar | 1 | Element Separator | |||
| c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
| c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | Type of Tax Correction | |
| c_acctschema_gl | usecurrencybalancing | bpchar | 1 | 'Y'::bpchar | Use Currency Balancing | ||
| c_acctschema_gl | usesuspensebalancing | bpchar | 1 | 'Y'::bpchar | Use Suspense Balancing | ||
| c_acctschema_gl | usesuspenseerror | bpchar | 1 | 'Y'::bpchar | Use Suspense Error | ||
| a_asset_acct | a_depreciation_manual_period | varchar | 2 | √ | null | A_Depreciation_Manual_Period | |
| a_asset_group_acct | a_depreciation_manual_period | varchar | 2 | √ | null | A_Depreciation_Manual_Period | |
| c_acctschema | gaap | bpchar | 2 | Generally Accepted Accounting Principles | |||
| a_asset_acct | a_reval_cal_method | varchar | 3 | √ | null | A_Reval_Cal_Method | |
| c_bpartner | 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 | |
| a_asset_acct | a_accumdepreciation_acct | numeric | 10 | Accumulated Depreciation Account | |||
| a_asset_group_acct | a_accumdepreciation_acct | numeric | 10 | Accumulated Depreciation Account | |||
| a_asset_acct | a_asset_acct | numeric | 10 | Asset Acct | |||
| a_asset_group_acct | a_asset_acct | numeric | 10 | Asset Acct | |||
| a_asset_acct | a_asset_acct_id | numeric | 10 | A_Asset_Acct_ID | |||
| a_asset_group_acct | a_asset_group_acct_id | numeric | 10 | Asset Group Accounting | |||
| a_asset_group_acct | a_asset_group_id | numeric | 10 | Group of Assets | |||
| a_asset_acct | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
| a_asset_acct | a_asset_spread_id | numeric | 10 | √ | null | A_Asset_Spread_ID | |
| a_asset_group_acct | a_asset_spread_type | varchar | 10 | √ | null | Spread Type | |
| a_asset_acct | a_depreciation_acct | numeric | 10 | Depreciation Account | |||
| a_asset_group_acct | a_depreciation_acct | numeric | 10 | Depreciation Account | |||
| a_asset_group_acct | a_depreciation_calc_type | varchar | 10 | √ | null | Calculation Type | |
| a_asset_acct | a_depreciation_conv_f_id | numeric | 10 | √ | null | Depreciation Convention (fiscal) | |
| a_asset_group_acct | a_depreciation_conv_f_id | numeric | 10 | √ | null | Depreciation Convention (fiscal) | |
| a_asset_acct | a_depreciation_conv_id | numeric | 10 | √ | null | Convention Type | |
| a_asset_group_acct | a_depreciation_conv_id | numeric | 10 | √ | null | Convention Type | |
| a_asset_acct | a_depreciation_f_id | numeric | 10 | Depreciation (fiscal) | |||
| a_asset_group_acct | a_depreciation_f_id | numeric | 10 | Depreciation (fiscal) | |||
| a_asset_acct | a_depreciation_id | numeric | 10 | Depreciation | |||
| a_asset_group_acct | a_depreciation_id | numeric | 10 | Depreciation | |||
| a_asset_acct | a_depreciation_method_f_id | numeric | 10 | √ | null | Depreciation Method (fiscal) | |
| a_asset_group_acct | a_depreciation_method_f_id | numeric | 10 | √ | null | Depreciation Method (fiscal) | |
| a_asset_acct | a_depreciation_method_id | numeric | 10 | √ | null | Depreciation Method | |
| a_asset_group_acct | a_depreciation_method_id | numeric | 10 | √ | null | Depreciation Method | |
| a_asset_acct | a_depreciation_table_header_id | numeric | 10 | √ | null | A_Depreciation_Table_Header_ID | |
| a_asset_group_acct | a_depreciation_table_header_id | numeric | 10 | √ | null | A_Depreciation_Table_Header_ID | |
| a_asset_acct | a_disposal_gain | varchar | 10 | √ | null | Disposal Gain | |
| a_asset_group_acct | a_disposal_gain | varchar | 10 | √ | null | Disposal Gain | |
| a_asset_acct | a_disposal_gain_acct | numeric | 10 | √ | NULL::numeric | Disposal Gain Acct | |
| a_asset_group_acct | a_disposal_gain_acct | numeric | 10 | √ | NULL::numeric | Disposal Gain Acct | |
| a_asset_acct | a_disposal_loss_acct | numeric | 10 | Disposal Loss Acct | |||
| a_asset_group_acct | a_disposal_loss_acct | numeric | 10 | √ | NULL::numeric | Disposal Loss Acct | |
| a_asset_acct | a_disposal_revenue_acct | numeric | 10 | Disposal Revenue Acct | |||
| a_asset_group_acct | a_disposal_revenue_acct | numeric | 10 | √ | NULL::numeric | Disposal Revenue Acct | |
| a_asset_acct | a_period_end | numeric | 10 | A_Period_End | |||
| a_asset_acct | a_period_start | numeric | 10 | A_Period_Start | |||
| a_asset_acct | a_reval_adep_offset_cur_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Cur | |
| a_asset_group_acct | a_reval_adep_offset_cur_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Cur | |
| a_asset_acct | a_reval_adep_offset_prior_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Prior | |
| a_asset_group_acct | a_reval_adep_offset_prior_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Prior | |
| a_asset_acct | a_reval_cost_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Acct | |
| a_asset_group_acct | a_reval_cost_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Acct | |
| a_asset_acct | a_reval_cost_offset_prior_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Prior Acct | |
| a_asset_group_acct | a_reval_cost_offset_prior_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Prior Acct | |
| a_asset_acct | a_reval_depexp_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Depexp Offset Acct | |
| a_asset_group_acct | a_reval_depexp_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Depexp Offset Acct | |
| a_asset_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| a_asset_group_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| ad_clientinfo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_acctschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_acctschema_default | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_acctschema_gl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bankaccount_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bp_customer_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bp_employee_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bp_group_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bp_vendor_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_charge_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_interorg_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_project_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_tax_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_withholding_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_product_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_product_category_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_warehouse_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| a_asset_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| a_asset_group_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| ad_clientinfo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_acctschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_acctschema_default | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_acctschema_gl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bankaccount_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bp_customer_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bp_employee_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bp_group_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bp_vendor_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_charge_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_interorg_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_project_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_tax_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_withholding_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_product_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_product_category_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_warehouse_acct | 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_acctschema | ad_orgonly_id | numeric | 10 | √ | null | Create posting entries only for this organization | |
| c_interorg_acct | ad_orgto_id | numeric | 10 | Organization valid for intercompany documents | |||
| ad_clientinfo | ad_storageprovider_id | numeric | 10 | √ | NULL::numeric | Storage Provider | |
| ad_clientinfo | ad_tree_activity_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
| ad_clientinfo | ad_tree_bpartner_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
| ad_clientinfo | ad_tree_campaign_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
| ad_clientinfo | ad_tree_menu_id | numeric | 10 | √ | null | Tree of the menu | |
| ad_clientinfo | ad_tree_org_id | numeric | 10 | √ | null | Trees are used for (financial) reporting and security access (via role) | |
| ad_clientinfo | ad_tree_product_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
| ad_clientinfo | ad_tree_project_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
| ad_clientinfo | ad_tree_salesregion_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
| c_acctschema_default | b_asset_acct | numeric | 10 | Bank Asset Account | |||
| c_bankaccount_acct | b_asset_acct | numeric | 10 | Bank Asset Account | |||
| c_acctschema_default | b_expense_acct | numeric | 10 | √ | null | Bank Expense Account | |
| c_bankaccount_acct | b_expense_acct | numeric | 10 | √ | null | Bank Expense Account | |
| c_acctschema_default | b_interestexp_acct | numeric | 10 | Bank Interest Expense Account | |||
| c_bankaccount_acct | b_interestexp_acct | numeric | 10 | Bank Interest Expense Account | |||
| c_acctschema_default | b_interestrev_acct | numeric | 10 | Bank Interest Revenue Account | |||
| c_bankaccount_acct | b_interestrev_acct | numeric | 10 | Bank Interest Revenue Account | |||
| c_acctschema_default | b_intransit_acct | numeric | 10 | Bank In Transit Account | |||
| c_bankaccount_acct | b_intransit_acct | numeric | 10 | Bank In Transit Account | |||
| c_acctschema_default | b_paymentselect_acct | numeric | 10 | AP Payment Selection Clearing Account | |||
| c_bankaccount_acct | b_paymentselect_acct | numeric | 10 | AP Payment Selection Clearing Account | |||
| c_acctschema_default | b_revaluationgain_acct | numeric | 10 | √ | null | Bank Revaluation Gain Account | |
| c_bankaccount_acct | b_revaluationgain_acct | numeric | 10 | √ | null | Bank Revaluation Gain Account | |
| c_acctschema_default | b_revaluationloss_acct | numeric | 10 | √ | null | Bank Revaluation Loss Account | |
| c_bankaccount_acct | b_revaluationloss_acct | numeric | 10 | √ | null | Bank Revaluation Loss Account | |
| c_acctschema_default | b_settlementgain_acct | numeric | 10 | √ | null | Bank Settlement Gain Account | |
| c_bankaccount_acct | b_settlementgain_acct | numeric | 10 | √ | null | Bank Settlement Gain Account | |
| c_acctschema_default | b_settlementloss_acct | numeric | 10 | √ | null | Bank Settlement Loss Account | |
| c_bankaccount_acct | b_settlementloss_acct | numeric | 10 | √ | null | Bank Settlement Loss Account | |
| c_acctschema_default | b_unallocatedcash_acct | numeric | 10 | Unallocated Cash Clearing Account | |||
| c_bankaccount_acct | b_unallocatedcash_acct | numeric | 10 | Unallocated Cash Clearing Account | |||
| c_acctschema_default | b_unidentified_acct | numeric | 10 | √ | null | Bank Unidentified Receipts Account | |
| c_bankaccount_acct | b_unidentified_acct | numeric | 10 | √ | null | Bank Unidentified Receipts Account | |
| c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
| ad_clientinfo | c_acctschema1_id | numeric | 10 | √ | null | Primary rules for accounting | |
| a_asset_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| a_asset_group_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_acctschema | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_acctschema_default | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_acctschema_gl | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_bankaccount_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_bp_customer_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_bp_employee_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_bp_group_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_bp_vendor_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_charge_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_interorg_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_project_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_tax_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_withholding_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| m_product_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| m_product_category_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| m_warehouse_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_bankaccount_acct | c_bankaccount_id | numeric | 10 | Account at the Bank | |||
| c_bp_group_acct | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| c_bp_customer_acct | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bp_employee_acct | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bp_vendor_acct | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| ad_clientinfo | c_bpartnercashtrx_id | numeric | 10 | √ | null | Business Partner used for creating new Business Partners on the fly | |
| ad_clientinfo | c_calendar_id | numeric | 10 | √ | null | Accounting Calendar Name | |
| c_charge_acct | c_charge_id | numeric | 10 | Additional document charges | |||
| ad_clientinfo | c_chargefreight_id | numeric | 10 | √ | NULL::numeric | Charge for Freight | |
| c_acctschema | c_currency_id | numeric | 10 | The Currency for this record | |||
| 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_acctschema | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
| c_acctschema_default | c_prepayment_acct | numeric | 10 | Account for customer prepayments | |||
| c_bp_customer_acct | c_prepayment_acct | numeric | 10 | √ | null | Account for customer prepayments | |
| c_bp_group_acct | c_prepayment_acct | numeric | 10 | Account for customer prepayments | |||
| c_project_acct | c_project_id | numeric | 10 | Financial Project | |||
| c_acctschema_default | c_receivable_acct | numeric | 10 | Account for Customer Receivables | |||
| c_bp_customer_acct | c_receivable_acct | numeric | 10 | √ | null | Account for Customer Receivables | |
| c_bp_group_acct | c_receivable_acct | numeric | 10 | Account for Customer Receivables | |||
| c_acctschema_default | c_receivable_services_acct | numeric | 10 | √ | null | Customer Accounts Receivables Services Account | |
| c_bp_customer_acct | c_receivable_services_acct | numeric | 10 | √ | null | Customer Accounts Receivables Services Account | |
| c_bp_group_acct | c_receivable_services_acct | numeric | 10 | √ | null | Customer Accounts Receivables Services Account | |
| m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
| m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
| c_tax_acct | c_tax_id | numeric | 10 | Tax identifier | |||
| m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
| c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
| m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
| ad_clientinfo | c_uom_length_id | numeric | 10 | √ | null | Standard Unit of Measure for Length | |
| ad_clientinfo | c_uom_time_id | numeric | 10 | √ | null | Standard Unit of Measure for Time | |
| ad_clientinfo | c_uom_volume_id | numeric | 10 | √ | null | Standard Unit of Measure for Volume | |
| ad_clientinfo | c_uom_weight_id | numeric | 10 | √ | null | Standard Unit of Measure for Weight | |
| c_withholding_acct | c_withholding_id | numeric | 10 | Withholding type defined | |||
| c_acctschema_default | cb_asset_acct | numeric | 10 | √ | null | Cash Book Asset Account | |
| c_acctschema_default | cb_cashtransfer_acct | numeric | 10 | √ | null | Cash Transfer Clearing Account | |
| c_acctschema_default | cb_differences_acct | numeric | 10 | √ | null | Cash Book Differences Account | |
| c_acctschema_default | cb_expense_acct | numeric | 10 | √ | null | Cash Book Expense Account | |
| c_acctschema_default | cb_receipt_acct | numeric | 10 | √ | null | Cash Book Receipts Account | |
| c_acctschema_default | ch_expense_acct | numeric | 10 | Charge Account | |||
| c_charge_acct | ch_expense_acct | numeric | 10 | Charge Account | |||
| c_acctschema_default | ch_revenue_acct | numeric | 10 | √ | null | Charge Revenue Account | |
| c_charge_acct | ch_revenue_acct | numeric | 10 | √ | null | Charge Revenue Account | |
| c_acctschema_gl | commitmentoffset_acct | numeric | 10 | Budgetary Commitment Offset Account | |||
| c_acctschema_gl | commitmentoffsetsales_acct | numeric | 10 | Budgetary Commitment Offset Account for Sales | |||
| a_asset_group_acct | conventiontype | varchar | 10 | √ | null | Convention Type | |
| a_asset_acct | createdby | numeric | 10 | User who created this records | |||
| a_asset_group_acct | createdby | numeric | 10 | √ | null | User who created this records | |
| ad_clientinfo | createdby | numeric | 10 | User who created this records | |||
| c_acctschema | createdby | numeric | 10 | User who created this records | |||
| c_acctschema_default | createdby | numeric | 10 | User who created this records | |||
| c_acctschema_gl | createdby | numeric | 10 | User who created this records | |||
| c_bankaccount_acct | createdby | numeric | 10 | User who created this records | |||
| c_bp_customer_acct | createdby | numeric | 10 | User who created this records | |||
| c_bp_employee_acct | createdby | numeric | 10 | User who created this records | |||
| c_bp_group_acct | createdby | numeric | 10 | User who created this records | |||
| c_bp_vendor_acct | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | createdby | numeric | 10 | User who created this records | |||
| c_charge_acct | createdby | numeric | 10 | User who created this records | |||
| c_interorg_acct | createdby | numeric | 10 | User who created this records | |||
| c_project_acct | createdby | numeric | 10 | User who created this records | |||
| c_tax_acct | createdby | numeric | 10 | User who created this records | |||
| c_withholding_acct | createdby | numeric | 10 | User who created this records | |||
| m_product | createdby | numeric | 10 | User who created this records | |||
| m_product_acct | createdby | numeric | 10 | User who created this records | |||
| m_product_category_acct | createdby | numeric | 10 | User who created this records | |||
| m_warehouse_acct | createdby | numeric | 10 | User who created this records | |||
| c_acctschema_gl | currencybalancing_acct | numeric | 10 | √ | null | Account used when a currency is out of balance | |
| c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
| a_asset_group_acct | depreciationtype | varchar | 10 | √ | null | Depreciation Type | |
| c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
| c_acctschema_default | e_expense_acct | numeric | 10 | √ | null | Account for Employee Expenses | |
| c_bp_employee_acct | e_expense_acct | numeric | 10 | √ | null | Account for Employee Expenses | |
| c_acctschema_default | e_prepayment_acct | numeric | 10 | √ | null | Account for Employee Expense Prepayments | |
| c_bp_employee_acct | e_prepayment_acct | numeric | 10 | √ | null | Account for Employee Expense Prepayments | |
| m_product | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
| m_product | guaranteedaysmin | numeric | 10 | √ | null | Minimum number of guarantee days | |
| c_acctschema_gl | incomesummary_acct | numeric | 10 | √ | null | Income Summary Account | |
| c_acctschema_gl | intercompanyduefrom_acct | numeric | 10 | Intercompany Due From / Receivables Account | |||
| c_interorg_acct | intercompanyduefrom_acct | numeric | 10 | Intercompany Due From / Receivables Account | |||
| c_acctschema_gl | intercompanydueto_acct | numeric | 10 | Intercompany Due To / Payable Account | |||
| c_interorg_acct | intercompanydueto_acct | numeric | 10 | Intercompany Due To / Payable Account | |||
| c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
| ad_clientinfo | keeplogdays | numeric | 10 | √ | null | Number of days to keep the log entries | |
| ad_clientinfo | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
| c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
| ad_clientinfo | logoreport_id | numeric | 10 | √ | NULL::numeric | Logo Report | |
| ad_clientinfo | logoweb_id | numeric | 10 | √ | NULL::numeric | Logo Web | |
| 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 | |
| m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
| m_product_category_acct | m_product_category_id | numeric | 10 | Category of a Product | |||
| m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_product_acct | m_product_id | numeric | 10 | Product, Service, Item | |||
| ad_clientinfo | m_productfreight_id | numeric | 10 | √ | null | Product for Freight | |
| m_warehouse_acct | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| c_acctschema_default | notinvoicedreceipts_acct | numeric | 10 | Account for not-invoiced Material Receipts | |||
| c_bp_group_acct | notinvoicedreceipts_acct | numeric | 10 | Account for not-invoiced Material Receipts | |||
| c_acctschema_default | notinvoicedreceivables_acct | numeric | 10 | √ | null | Account for not invoiced Receivables | |
| c_bp_group_acct | notinvoicedreceivables_acct | numeric | 10 | √ | null | Account for not invoiced Receivables | |
| c_acctschema_default | notinvoicedrevenue_acct | numeric | 10 | √ | null | Account for not invoiced Revenue | |
| c_bp_group_acct | notinvoicedrevenue_acct | numeric | 10 | √ | null | Account for not invoiced Revenue | |
| c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
| c_acctschema_default | p_asset_acct | numeric | 10 | Account for Product Asset (Inventory) | |||
| m_product_acct | p_asset_acct | numeric | 10 | Account for Product Asset (Inventory) | |||
| m_product_category_acct | p_asset_acct | numeric | 10 | Account for Product Asset (Inventory) | |||
| c_acctschema_default | p_averagecostvariance_acct | numeric | 10 | √ | NULL::numeric | Average Cost Variance | |
| m_product_acct | p_averagecostvariance_acct | numeric | 10 | √ | NULL::numeric | Average Cost Variance | |
| m_product_category_acct | p_averagecostvariance_acct | numeric | 10 | √ | NULL::numeric | Average Cost Variance | |
| c_acctschema_default | p_burden_acct | numeric | 10 | √ | null | The Burden account is the account used Manufacturing Order | |
| m_product_acct | p_burden_acct | numeric | 10 | √ | null | The Burden account is the account used Manufacturing Order | |
| m_product_category_acct | p_burden_acct | numeric | 10 | √ | null | The Burden account is the account used Manufacturing Order | |
| c_acctschema_default | p_cogs_acct | numeric | 10 | Account for Cost of Goods Sold | |||
| m_product_acct | p_cogs_acct | numeric | 10 | Account for Cost of Goods Sold | |||
| m_product_category_acct | p_cogs_acct | numeric | 10 | Account for Cost of Goods Sold | |||
| c_acctschema_default | p_costadjustment_acct | numeric | 10 | Product Cost Adjustment Account | |||
| m_product_acct | p_costadjustment_acct | numeric | 10 | √ | null | Product Cost Adjustment Account | |
| m_product_category_acct | p_costadjustment_acct | numeric | 10 | √ | null | Product Cost Adjustment Account | |
| c_acctschema_default | p_costofproduction_acct | numeric | 10 | √ | null | The Cost Of Production account is the account used Manufacturing Order | |
| m_product_acct | p_costofproduction_acct | numeric | 10 | √ | null | The Cost Of Production account is the account used Manufacturing Order | |
| m_product_category_acct | p_costofproduction_acct | numeric | 10 | √ | null | The Cost Of Production account is the account used Manufacturing Order | |
| c_acctschema_default | p_expense_acct | numeric | 10 | Account for Product Expense | |||
| m_product_acct | p_expense_acct | numeric | 10 | Account for Product Expense | |||
| m_product_category_acct | p_expense_acct | numeric | 10 | Account for Product Expense | |||
| c_acctschema_default | p_floorstock_acct | numeric | 10 | √ | null | The Floor Stock account is the account used Manufacturing Order | |
| m_product_acct | p_floorstock_acct | numeric | 10 | √ | null | The Floor Stock account is the account used Manufacturing Order | |
| m_product_category_acct | p_floorstock_acct | numeric | 10 | √ | null | The Floor Stock account is the account used Manufacturing Order | |
| c_acctschema_default | p_inventoryclearing_acct | numeric | 10 | Product Inventory Clearing Account | |||
| m_product_acct | p_inventoryclearing_acct | numeric | 10 | √ | null | Product Inventory Clearing Account | |
| m_product_category_acct | p_inventoryclearing_acct | numeric | 10 | √ | null | Product Inventory Clearing Account | |
| c_acctschema_default | p_invoicepricevariance_acct | numeric | 10 | Difference between Costs and Invoice Price (IPV) | |||
| m_product_acct | p_invoicepricevariance_acct | numeric | 10 | Difference between Costs and Invoice Price (IPV) | |||
| m_product_category_acct | p_invoicepricevariance_acct | numeric | 10 | Difference between Costs and Invoice Price (IPV) | |||
| c_acctschema_default | p_labor_acct | numeric | 10 | √ | null | The Labor account is the account used Manufacturing Order | |
| m_product_acct | p_labor_acct | numeric | 10 | √ | null | The Labor account is the account used Manufacturing Order | |
| m_product_category_acct | p_labor_acct | numeric | 10 | √ | null | The Labor account is the account used Manufacturing Order | |
| c_acctschema_default | p_landedcostclearing_acct | numeric | 10 | √ | NULL::numeric | Product Landed Cost Clearing Account | |
| m_product_acct | p_landedcostclearing_acct | numeric | 10 | √ | NULL::numeric | Product Landed Cost Clearing Account | |
| m_product_category_acct | p_landedcostclearing_acct | numeric | 10 | √ | NULL::numeric | Product Landed Cost Clearing Account | |
| c_acctschema_default | p_methodchangevariance_acct | numeric | 10 | √ | null | The Method Change Variance account is the account used Manufacturing Order | |
| m_product_acct | p_methodchangevariance_acct | numeric | 10 | √ | null | The Method Change Variance account is the account used Manufacturing Order | |
| m_product_category_acct | p_methodchangevariance_acct | numeric | 10 | √ | null | The Method Change Variance account is the account used Manufacturing Order | |
| c_acctschema_default | p_mixvariance_acct | numeric | 10 | √ | null | The Mix Variance account is the account used Manufacturing Order | |
| m_product_acct | p_mixvariance_acct | numeric | 10 | √ | null | The Mix Variance account is the account used Manufacturing Order | |
| m_product_category_acct | p_mixvariance_acct | numeric | 10 | √ | null | The Mix Variance account is the account used Manufacturing Order | |
| c_acctschema_default | p_outsideprocessing_acct | numeric | 10 | √ | null | The Outside Processing Account is the account used in Manufacturing Order | |
| m_product_acct | p_outsideprocessing_acct | numeric | 10 | √ | null | The Outside Processing Account is the account used in Manufacturing Order | |
| m_product_category_acct | p_outsideprocessing_acct | numeric | 10 | √ | null | The Outside Processing Account is the account used in Manufacturing Order | |
| c_acctschema_default | p_overhead_acct | numeric | 10 | √ | null | The Overhead account is the account used in Manufacturing Order | |
| m_product_acct | p_overhead_acct | numeric | 10 | √ | null | The Overhead account is the account used in Manufacturing Order | |
| m_product_category_acct | p_overhead_acct | numeric | 10 | √ | null | The Overhead account is the account used in Manufacturing Order | |
| c_acctschema_default | p_purchasepricevariance_acct | numeric | 10 | Difference between Standard Cost and Purchase Price (PPV) | |||
| m_product_acct | p_purchasepricevariance_acct | numeric | 10 | Difference between Standard Cost and Purchase Price (PPV) | |||
| m_product_category_acct | p_purchasepricevariance_acct | numeric | 10 | Difference between Standard Cost and Purchase Price (PPV) | |||
| c_acctschema_default | p_ratevariance_acct | numeric | 10 | √ | null | The Rate Variance account is the account used Manufacturing Order | |
| m_product_acct | p_ratevariance_acct | numeric | 10 | √ | null | The Rate Variance account is the account used Manufacturing Order | |
| m_product_category_acct | p_ratevariance_acct | numeric | 10 | √ | null | The Rate Variance account is the account used Manufacturing Order | |
| c_acctschema_default | p_revenue_acct | numeric | 10 | Account for Product Revenue (Sales Account) | |||
| m_product_acct | p_revenue_acct | numeric | 10 | Account for Product Revenue (Sales Account) | |||
| m_product_category_acct | p_revenue_acct | numeric | 10 | Account for Product Revenue (Sales Account) | |||
| c_acctschema_default | p_scrap_acct | numeric | 10 | √ | null | The Scrap account is the account used in Manufacturing Order | |
| m_product_acct | p_scrap_acct | numeric | 10 | √ | null | The Scrap account is the account used in Manufacturing Order | |
| m_product_category_acct | p_scrap_acct | numeric | 10 | √ | null | The Scrap account is the account used in Manufacturing Order | |
| c_acctschema_default | p_tradediscountgrant_acct | numeric | 10 | Trade Discount Granted Account | |||
| m_product_acct | p_tradediscountgrant_acct | numeric | 10 | Trade Discount Granted Account | |||
| m_product_category_acct | p_tradediscountgrant_acct | numeric | 10 | Trade Discount Granted Account | |||
| c_acctschema_default | p_tradediscountrec_acct | numeric | 10 | Trade Discount Receivable Account | |||
| m_product_acct | p_tradediscountrec_acct | numeric | 10 | Trade Discount Receivable Account | |||
| m_product_category_acct | p_tradediscountrec_acct | numeric | 10 | Trade Discount Receivable Account | |||
| c_acctschema_default | p_usagevariance_acct | numeric | 10 | √ | null | The Usage Variance account is the account used Manufacturing Order | |
| m_product_acct | p_usagevariance_acct | numeric | 10 | √ | null | The Usage Variance account is the account used Manufacturing Order | |
| m_product_category_acct | p_usagevariance_acct | numeric | 10 | √ | null | The Usage Variance account is the account used Manufacturing Order | |
| c_acctschema_default | p_wip_acct | numeric | 10 | √ | null | The Work in Process account is the account used Manufacturing Order | |
| m_product_acct | p_wip_acct | numeric | 10 | √ | null | The Work in Process account is the account used Manufacturing Order | |
| m_product_category_acct | p_wip_acct | numeric | 10 | √ | null | The Work in Process account is the account used Manufacturing Order | |
| c_acctschema_default | paydiscount_exp_acct | numeric | 10 | Payment Discount Expense Account | |||
| c_bp_group_acct | paydiscount_exp_acct | numeric | 10 | Payment Discount Expense Account | |||
| c_acctschema_default | paydiscount_rev_acct | numeric | 10 | Payment Discount Revenue Account | |||
| c_bp_group_acct | paydiscount_rev_acct | numeric | 10 | Payment Discount Revenue Account | |||
| 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_default | pj_asset_acct | numeric | 10 | Project Asset Account | |||
| c_project_acct | pj_asset_acct | numeric | 10 | Project Asset Account | |||
| c_acctschema_default | pj_wip_acct | numeric | 10 | Account for Work in Progress | |||
| c_project_acct | pj_wip_acct | numeric | 10 | Account for Work in Progress | |||
| 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_acctschema_gl | ppvoffset_acct | numeric | 10 | Purchase Price Variance Offset Account | |||
| m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| c_acctschema_default | realizedgain_acct | numeric | 10 | Realized Gain Account | |||
| c_acctschema_default | realizedloss_acct | numeric | 10 | Realized Loss Account | |||
| c_acctschema_gl | retainedearning_acct | numeric | 10 | √ | null | Retained Earning Acct | |
| 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 | |
| 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 | |
| ad_clientinfo | storagearchive_id | numeric | 10 | √ | NULL::numeric | Archive Store | |
| ad_clientinfo | storageimage_id | numeric | 10 | √ | NULL::numeric | Storage provider for Image | |
| c_acctschema_gl | suspensebalancing_acct | numeric | 10 | √ | null | Suspense Balancing Acct | |
| c_acctschema_gl | suspenseerror_acct | numeric | 10 | √ | null | Suspense Error Acct | |
| c_acctschema_default | t_credit_acct | numeric | 10 | Account for Tax you can reclaim | |||
| c_tax_acct | t_credit_acct | numeric | 10 | Account for Tax you can reclaim | |||
| c_acctschema_default | t_due_acct | numeric | 10 | Account for Tax you have to pay | |||
| c_tax_acct | t_due_acct | numeric | 10 | Account for Tax you have to pay | |||
| c_acctschema_default | t_expense_acct | numeric | 10 | Account for paid tax you cannot reclaim | |||
| c_tax_acct | t_expense_acct | numeric | 10 | Account for paid tax you cannot reclaim | |||
| c_acctschema_default | t_liability_acct | numeric | 10 | √ | null | Account for Tax declaration liability | |
| c_tax_acct | t_liability_acct | numeric | 10 | √ | null | Account for Tax declaration liability | |
| c_acctschema_default | t_receivables_acct | numeric | 10 | √ | null | Account for Tax credit after tax declaration | |
| c_tax_acct | t_receivables_acct | numeric | 10 | √ | null | Account for Tax credit after tax declaration | |
| c_acctschema_default | unearnedrevenue_acct | numeric | 10 | √ | null | Account for unearned revenue | |
| c_bp_group_acct | unearnedrevenue_acct | numeric | 10 | √ | null | Account for unearned revenue | |
| m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
| c_acctschema_default | unrealizedgain_acct | numeric | 10 | Unrealized Gain Account for currency revaluation | |||
| c_acctschema_default | unrealizedloss_acct | numeric | 10 | Unrealized Loss Account for currency revaluation | |||
| a_asset_acct | updatedby | numeric | 10 | User who updated this records | |||
| a_asset_group_acct | updatedby | numeric | 10 | √ | null | User who updated this records | |
| ad_clientinfo | updatedby | numeric | 10 | User who updated this records | |||
| c_acctschema | updatedby | numeric | 10 | User who updated this records | |||
| c_acctschema_default | updatedby | numeric | 10 | User who updated this records | |||
| c_acctschema_gl | updatedby | numeric | 10 | User who updated this records | |||
| c_bankaccount_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_customer_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_employee_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_group_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_vendor_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
| c_charge_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_interorg_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_project_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_tax_acct | updatedby | numeric | 10 | User who updated this records | |||
| c_withholding_acct | updatedby | numeric | 10 | User who updated this records | |||
| m_product | updatedby | numeric | 10 | User who updated this records | |||
| m_product_acct | updatedby | numeric | 10 | User who updated this records | |||
| m_product_category_acct | updatedby | numeric | 10 | User who updated this records | |||
| m_warehouse_acct | updatedby | numeric | 10 | User who updated this records | |||
| a_asset_group_acct | uselifemonths | numeric | 10 | √ | (0)::numeric | Months of the usable life of the asset | |
| a_asset_group_acct | uselifemonths_f | numeric | 10 | (0)::numeric | Use Life - Months (fiscal) | ||
| c_acctschema_default | v_liability_acct | numeric | 10 | Account for Vendor Liability | |||
| c_bp_group_acct | v_liability_acct | numeric | 10 | Account for Vendor Liability | |||
| c_bp_vendor_acct | v_liability_acct | numeric | 10 | √ | null | Account for Vendor Liability | |
| c_acctschema_default | v_liability_services_acct | numeric | 10 | √ | null | Account for Vendor Service Liability | |
| c_bp_group_acct | v_liability_services_acct | numeric | 10 | √ | null | Account for Vendor Service Liability | |
| c_bp_vendor_acct | v_liability_services_acct | numeric | 10 | √ | null | Account for Vendor Service Liability | |
| c_acctschema_default | v_prepayment_acct | numeric | 10 | Account for Vendor Prepayments | |||
| c_bp_group_acct | v_prepayment_acct | numeric | 10 | Account for Vendor Prepayments | |||
| c_bp_vendor_acct | v_prepayment_acct | numeric | 10 | √ | null | Account for Vendor Prepayments | |
| c_acctschema_default | w_differences_acct | numeric | 10 | Warehouse Differences Account | |||
| m_warehouse_acct | w_differences_acct | numeric | 10 | Warehouse Differences Account | |||
| c_acctschema_default | w_invactualadjust_acct | numeric | 10 | √ | null | Account for Inventory value adjustments for Actual Costing | |
| m_warehouse_acct | w_invactualadjust_acct | numeric | 10 | √ | null | Account for Inventory value adjustments for Actual Costing | |
| c_acctschema_default | w_inventory_acct | numeric | 10 | √ | null | Warehouse Inventory Asset Account - Currently not used | |
| m_warehouse_acct | w_inventory_acct | numeric | 10 | √ | null | Warehouse Inventory Asset Account - Currently not used | |
| c_acctschema_default | w_revaluation_acct | numeric | 10 | √ | null | Account for Inventory Revaluation | |
| m_warehouse_acct | w_revaluation_acct | numeric | 10 | √ | null | Account for Inventory Revaluation | |
| c_acctschema_default | withholding_acct | numeric | 10 | √ | null | Account for Withholdings | |
| c_withholding_acct | withholding_acct | numeric | 10 | Account for Withholdings | |||
| c_acctschema_default | writeoff_acct | numeric | 10 | Account for Receivables write-off | |||
| c_bp_group_acct | writeoff_acct | numeric | 10 | Account for Receivables write-off | |||
| c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
| m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
| m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
| c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
| m_product | versionno | varchar | 20 | √ | null | Version Number | |
| a_asset_group_acct | a_disposal_loss | varchar | 22 | √ | null | Loss on Disposal | |
| a_asset_group_acct | a_disposal_revenue | varchar | 22 | √ | null | Disposal Revenue | |
| a_asset_acct | a_reval_accumdep_offset_cur | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Current Year | |
| a_asset_group_acct | a_reval_accumdep_offset_cur | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Current Year | |
| a_asset_acct | a_reval_accumdep_offset_prior | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Prior Year | |
| a_asset_group_acct | a_reval_accumdep_offset_prior | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Prior Year | |
| a_asset_group_acct | a_reval_cal_method | varchar | 22 | √ | null | A_Reval_Cal_Method | |
| a_asset_acct | a_reval_cost_offset | varchar | 22 | √ | null | Revaluation Cost Offset for Current Year | |
| a_asset_group_acct | a_reval_cost_offset | varchar | 22 | √ | null | Revaluation Cost Offset for Current Year | |
| a_asset_acct | a_reval_cost_offset_prior | varchar | 22 | √ | null | Revaluation Cost Offset for Prior Year | |
| a_asset_group_acct | a_reval_cost_offset_prior | varchar | 22 | √ | null | Revaluation Cost Offset for Prior Year | |
| a_asset_acct | a_reval_depexp_offset | varchar | 22 | √ | null | Revaluation Expense Offs | |
| a_asset_group_acct | a_reval_depexp_offset | varchar | 22 | √ | null | Revaluation Expense Offs | |
| a_asset_acct | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| a_asset_group_acct | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| ad_clientinfo | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_acctschema | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_acctschema_default | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_acctschema_gl | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bankaccount_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_customer_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_employee_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_group_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_vendor_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_charge_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_interorg_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_project_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_tax_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_withholding_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product_category_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_warehouse_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
| 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_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
| ad_clientinfo | fy_startdate | timestamp | 29,6 | √ | null | Financial Year Start Date | |
| a_asset_acct | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| a_asset_group_acct | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| ad_clientinfo | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_acctschema | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_acctschema_default | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_acctschema_gl | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bankaccount_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_customer_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_employee_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_group_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_vendor_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_charge_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_interorg_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_project_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_tax_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_withholding_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product_category_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_warehouse_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| a_asset_acct | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
| 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) | |
| a_asset_acct | a_asset_acct_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Acct_UU | |
| a_asset_group_acct | a_asset_group_acct_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Group_Acct_UU | |
| ad_clientinfo | ad_clientinfo_uu | varchar | 36 | √ | NULL::character varying | AD_ClientInfo_UU | |
| c_acctschema_default | c_acctschema_default_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_Default_UU | |
| c_acctschema_gl | c_acctschema_gl_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_GL_UU | |
| c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_UU | |
| c_bankaccount_acct | c_bankaccount_acct_uu | varchar | 36 | √ | NULL::character varying | C_BankAccount_Acct_UU | |
| c_bp_customer_acct | c_bp_customer_acct_uu | varchar | 36 | √ | NULL::character varying | C_BP_Customer_Acct_UU | |
| c_bp_employee_acct | c_bp_employee_acct_uu | varchar | 36 | √ | NULL::character varying | C_BP_Employee_Acct_UU | |
| c_bp_group_acct | c_bp_group_acct_uu | varchar | 36 | √ | NULL::character varying | C_BP_Group_Acct_UU | |
| c_bp_vendor_acct | c_bp_vendor_acct_uu | varchar | 36 | √ | NULL::character varying | C_BP_Vendor_Acct_UU | |
| c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
| c_charge_acct | c_charge_acct_uu | varchar | 36 | √ | NULL::character varying | C_Charge_Acct_UU | |
| c_interorg_acct | c_interorg_acct_uu | varchar | 36 | √ | NULL::character varying | C_InterOrg_Acct_UU | |
| c_project_acct | c_project_acct_uu | varchar | 36 | √ | NULL::character varying | C_Project_Acct_UU | |
| c_tax_acct | c_tax_acct_uu | varchar | 36 | √ | NULL::character varying | C_Tax_Acct_UU | |
| c_withholding_acct | c_withholding_acct_uu | varchar | 36 | √ | NULL::character varying | C_Withholding_Acct_UU | |
| m_product_acct | m_product_acct_uu | varchar | 36 | √ | NULL::character varying | M_Product_Acct_UU | |
| m_product_category_acct | m_product_category_acct_uu | varchar | 36 | √ | NULL::character varying | M_Product_Category_Acct_UU | |
| m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
| m_warehouse_acct | m_warehouse_acct_uu | varchar | 36 | √ | NULL::character varying | M_Warehouse_Acct_UU | |
| a_asset_acct | a_disposal_loss | varchar | 40 | √ | null | Loss on Disposal | |
| a_asset_acct | a_disposal_revenue | varchar | 40 | √ | null | Disposal Revenue | |
| c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
| c_bpartner | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
| c_acctschema | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
| ad_clientinfo | timezone | varchar | 60 | √ | NULL::character varying | Time zone name | |
| 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_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_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | group1 | varchar | 255 | √ | null | Group1 | |
| m_product | group2 | varchar | 255 | √ | null | Group2 | |
| m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
| c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
| m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
| m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| m_product | help | varchar | 2000 | √ | null | Comment or Hint |