SchemaSpy Analysis of idempiere11.adempiere - ColumnsImport Export | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:48 +0100 |
| |||||
|
idempiere11.adempiere contains 2844 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
i_asset | a_accumdepreciation_acct | numeric | 10 | √ | null | Accumulated Depreciation Account | |
i_asset | a_accumulated_depr | numeric | 0 | √ | null | Accumulated Depreciation | |
i_fixedasset | a_accumulated_depr | numeric | 0 | √ | null | Accumulated Depreciation | |
i_fixedasset | a_accumulated_depr_f | numeric | 0 | √ | null | Accumulated Depreciation (fiscal) | |
i_asset | a_asset_acct | numeric | 10 | √ | null | Asset Acct | |
i_fixedasset | a_asset_class_id | numeric | 10 | √ | NULL::numeric | Asset class | |
i_fixedasset | a_asset_class_value | varchar | 40 | √ | NULL::character varying | Asset Class Key | |
i_asset | a_asset_cost | numeric | 0 | √ | null | Asset Cost | |
c_invoiceline | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
gl_journalline | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
i_asset | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
i_fixedasset | a_asset_group_id | numeric | 10 | √ | NULL::numeric | Group of Assets | |
m_product_category | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
i_fixedasset | a_asset_group_value | varchar | 40 | √ | NULL::character varying | Asset Group Key | |
c_invoiceline | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
gl_journalline | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
i_asset | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
i_fajournal | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
i_fixedasset | a_asset_id | numeric | 10 | √ | NULL::numeric | Asset used internally or by customers | |
i_asset | a_asset_life_current_year | numeric | 10 | √ | null | A_Asset_Life_Current_Year | |
i_asset | a_asset_life_years | numeric | 0 | √ | null | Life Years | |
i_asset | a_asset_spread_type | varchar | 10 | √ | null | Spread Type | |
i_fixedasset | a_asset_type_id | numeric | 10 | √ | null | Asset Type | |
i_fixedasset | a_asset_type_value | varchar | 40 | √ | NULL::character varying | Asset Type Value | |
i_asset | a_base_amount | numeric | 0 | √ | null | A_Base_Amount | |
i_asset | a_calc_accumulated_depr | numeric | 0 | √ | null | A_Calc_Accumulated_Depr | |
c_invoiceline | a_capvsexp | varchar | 3 | √ | null | Capital/Expense | |
c_payment | a_city | varchar | 60 | √ | null | City or the Credit Card or Account Holder | |
i_payment | a_city | varchar | 60 | √ | null | City or the Credit Card or Account Holder | |
c_payment | a_country | varchar | 40 | √ | null | Country | |
i_payment | a_country | varchar | 40 | √ | null | Country | |
c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
gl_journalline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
i_asset | a_curr_dep_exp | numeric | 0 | √ | null | A_Curr_Dep_Exp | |
i_asset | a_current_period | numeric | 10 | √ | null | Current Period | |
i_fixedasset | a_current_period | numeric | 10 | √ | NULL::numeric | Current Period | |
i_asset | a_depreciation_acct | numeric | 10 | √ | null | Depreciation Account | |
i_asset | a_depreciation_calc_type | varchar | 10 | √ | null | Calculation Type | |
i_asset | a_depreciation_manual_amount | numeric | 0 | √ | null | A_Depreciation_Manual_Amount | |
i_asset | a_depreciation_manual_period | varchar | 2 | √ | null | A_Depreciation_Manual_Period | |
i_asset | a_depreciation_table_header_id | numeric | 10 | √ | null | A_Depreciation_Table_Header_ID | |
i_asset | a_depreciation_variable_perc | numeric | 0 | √ | null | Variable Percent | |
i_asset | a_disposal_loss | varchar | 22 | √ | null | Loss on Disposal | |
i_asset | a_disposal_revenue | varchar | 22 | √ | null | Disposal Revenue | |
c_payment | a_email | varchar | 60 | √ | null | Email Address | |
i_payment | a_email | varchar | 60 | √ | null | Email Address | |
i_fajournal | a_entry_type | varchar | 3 | √ | null | Entry Type | |
c_payment | a_ident_dl | varchar | 20 | √ | null | Payment Identification - Driver License | |
i_payment | a_ident_dl | varchar | 20 | √ | null | Payment Identification - Driver License | |
c_payment | a_ident_ssn | varchar | 20 | √ | null | Payment Identification - Social Security No | |
i_payment | a_ident_ssn | varchar | 20 | √ | null | Payment Identification - Social Security No | |
i_asset | a_life_period | numeric | 10 | √ | null | Life Periods | |
c_payment | a_name | varchar | 60 | √ | null | Name on Credit Card or Account holder | |
i_payment | a_name | varchar | 60 | √ | null | Name on Credit Card or Account holder | |
i_asset | a_parent_asset_id | numeric | 10 | √ | (0)::numeric | Parent Asset | |
i_asset | a_period_end | numeric | 10 | √ | null | A_Period_End | |
i_asset | a_period_posted | numeric | 10 | √ | null | A_Period_Posted | |
i_asset | a_period_start | numeric | 10 | √ | null | A_Period_Start | |
i_asset | a_prior_year_accumulated_depr | numeric | 0 | √ | null | A_Prior_Year_Accumulated_Depr | |
c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
gl_journalline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
i_asset | a_qty_current | numeric | 10 | √ | null | Current Qty | |
i_asset | a_qty_original | numeric | 10 | √ | null | A_QTY_Original | |
i_asset | a_reval_accumdep_offset_cur | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Current Year | |
i_asset | a_reval_accumdep_offset_prior | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Prior Year | |
i_asset | a_reval_cal_method | varchar | 3 | √ | null | A_Reval_Cal_Method | |
i_asset | a_reval_cost_offset | varchar | 22 | √ | null | Revaluation Cost Offset for Current Year | |
i_asset | a_reval_cost_offset_prior | varchar | 22 | √ | null | Revaluation Cost Offset for Prior Year | |
i_asset | a_reval_depexp_offset | varchar | 22 | √ | null | Revaluation Expense Offs | |
i_asset | a_salvage_value | numeric | 0 | √ | null | Asset Salvage Value | |
i_fixedasset | a_salvage_value | numeric | 0 | √ | null | Asset Salvage Value | |
i_asset | a_split_percent | numeric | 0 | √ | null | Split Percent | |
c_payment | a_state | varchar | 40 | √ | null | State of the Credit Card or Account holder | |
i_payment | a_state | varchar | 40 | √ | null | State of the Credit Card or Account holder | |
c_payment | a_street | varchar | 60 | √ | null | Street address of the Credit Card or Account holder | |
i_payment | a_street | varchar | 60 | √ | null | Street address of the Credit Card or Account holder | |
c_payment | a_zip | varchar | 20 | √ | null | Zip Code of the Credit Card or Account Holder | |
i_payment | a_zip | varchar | 20 | √ | null | Zip Code of the Credit Card or Account Holder | |
gl_journalline | account_id | numeric | 10 | √ | NULL::numeric | Account used | |
i_fajournal | account_id | numeric | 10 | √ | null | Account used | |
i_gljournal | account_id | numeric | 10 | √ | null | Account used | |
c_payment | accountno | varchar | 20 | √ | null | Account Number | |
i_payment | accountno | varchar | 20 | √ | null | Account Number | |
i_elementvalue | accountsign | bpchar | 1 | √ | null | Indicates the Natural Sign of the Account as a Debit or Credit | |
i_elementvalue | accounttype | bpchar | 1 | √ | null | Indicates the type of account | |
i_fajournal | accountvalue | varchar | 80 | √ | null | Key of Account Element | |
i_gljournal | accountvalue | varchar | 40 | √ | null | Key of Account Element | |
i_fajournal | acctschemaname | varchar | 120 | √ | null | Name of the Accounting Schema | |
i_fixedasset | acctschemaname | varchar | 120 | √ | NULL::character varying | Name of the Accounting Schema | |
i_gljournal | acctschemaname | varchar | 60 | √ | null | Name of the Accounting Schema | |
c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | The cost of gaining the prospect as a customer | |
i_gljournal | activityvalue | varchar | 40 | √ | NULL::character varying | Text key for Activity | |
i_invoice | activityvalue | varchar | 40 | √ | null | Text key for Activity | |
c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | Actual Life Time Revenue | |
ad_column | ad_chart_id | numeric | 10 | √ | NULL::numeric | Chart | |
i_bankstatement | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_bpartner | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_conversion_rate | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_elementvalue | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_fajournal | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_gljournal | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_inventory | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_invoice | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_order | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_payment | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_pricelist | ad_client_id | numeric | 10 | √ | NULL::numeric | Tenant for this installation. | |
i_product | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
i_reportline | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
exp_formatline | ad_column_id | numeric | 10 | √ | null | Column in the table | |
i_elementvalue | ad_column_id | numeric | 10 | √ | null | Column in the table | |
ad_column | ad_column_uu | varchar | 36 | √ | NULL::character varying | AD_Column_UU | |
ad_column | ad_element_id | numeric | 10 | √ | null | System Element enables the central maintenance of column description and help. | |
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
ad_impformat_row | ad_impformat_row_uu | varchar | 36 | √ | NULL::character varying | AD_ImpFormat_Row_UU | |
ad_impformat | ad_impformat_uu | varchar | 36 | √ | NULL::character varying | AD_ImpFormat_UU | |
ad_importtemplate | ad_importtemplate_uu | varchar | 36 | √ | NULL::character varying | AD_ImportTemplate_UU | |
ad_column | ad_infowindow_id | numeric | 10 | √ | null | Info and search/select Window | |
c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
c_country | ad_language | varchar | 6 | √ | null | Language for this entity | |
i_bankstatement | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_bpartner | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_conversion_rate | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_elementvalue | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_fajournal | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_gljournal | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_inventory | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_invoice | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_order | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_payment | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_pricelist | ad_org_id | numeric | 10 | √ | NULL::numeric | Organizational entity within tenant | |
i_product | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_reportline | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
ad_org | ad_org_uu | varchar | 36 | √ | NULL::character varying | AD_Org_UU | |
c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | The Business Partner is another Organization for explicit Inter-Org transactions | |
i_fajournal | ad_orgdoc_id | numeric | 10 | √ | null | Document Organization (independent from account organization) | |
i_gljournal | ad_orgdoc_id | numeric | 10 | √ | null | Document Organization (independent from account organization) | |
c_acctschema | ad_orgonly_id | numeric | 10 | √ | null | Create posting entries only for this organization | |
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_invoice | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_invoiceline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_order | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_orderline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_payment | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating 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 | |
gl_journalline | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
i_fajournal | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
i_gljournal | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
i_invoice | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
i_movement | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
i_order | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_inventory | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
pa_reportsource | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_bp_group | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
m_product_category | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
c_doctype | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
ad_column | ad_process_id | numeric | 10 | √ | null | Process or Report | |
ad_column | ad_reference_value_id | numeric | 10 | √ | null | Required to specify, if data type is Table or List | |
ad_org | ad_replicationstrategy_id | numeric | 0 | √ | null | Data Replication Strategy | |
c_tax | ad_rule_id | numeric | 10 | √ | null | Rule | |
c_element | ad_tree_id | numeric | 10 | √ | null | Identifies a Tree | |
c_invoice | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_order | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_project | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
i_asset | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
i_bpartner | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
i_invoice | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
i_movement | ad_user_id | numeric | 10 | √ | NULL::numeric | User within the system - Internal or Business Partner Contact | |
i_order | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
ad_column | ad_val_rule_id | numeric | 10 | √ | null | Dynamic Validation Rule | |
ad_column | ad_val_rule_lookup_id | numeric | 10 | √ | NULL::numeric | Override Dynamic Validation Rule for Lookup Window | |
c_location | address1 | varchar | 60 | √ | null | Address line 1 for this location | |
i_bpartner | address1 | varchar | 60 | √ | null | Address line 1 for this location | |
i_invoice | address1 | varchar | 60 | √ | null | Address line 1 for this location | |
i_order | address1 | varchar | 60 | √ | null | Address line 1 for this location | |
c_location | address2 | varchar | 60 | √ | null | Address line 2 for this location | |
i_bpartner | address2 | varchar | 60 | √ | null | Address line 2 for this location | |
i_invoice | address2 | varchar | 60 | √ | null | Address line 2 for this location | |
i_order | 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_validcombination | alias | varchar | 40 | √ | null | Defines an alternate method of indicating an account combination. | |
gl_journalline | alias_validcombination_id | numeric | 10 | √ | NULL::numeric | Valid Account Alias List | |
c_country | allowcitiesoutoflist | bpchar | 1 | √ | 'Y'::bpchar | A flag to allow cities, currently not in the list, to be entered | |
ad_column | alwaysupdatablelogic | varchar | 2000 | √ | NULL::character varying | Logic to determine if field is Updatable irrespective if record's active status or processed status. This logic Applicable only if Always Updatable is N. | |
c_order | amountrefunded | numeric | 22,2 | √ | null | Amount Refunded | |
c_order | amounttendered | numeric | 22,2 | √ | null | Amount Tendered | |
i_reportline | amounttype | bpchar | 2 | √ | null | Type of amount to report | |
pa_reportline | amounttype | bpchar | 2 | √ | null | Type of amount to report | |
i_fajournal | amtacctcr | numeric | 0 | √ | null | Accounted Credit Amount | |
i_gljournal | amtacctcr | numeric | 0 | √ | 0 | Accounted Credit Amount | |
i_fajournal | amtacctdr | numeric | 0 | √ | null | Accounted Debit Amount | |
i_gljournal | amtacctdr | numeric | 0 | √ | 0 | Accounted Debit Amount | |
i_fajournal | amtsourcecr | numeric | 0 | √ | null | Source Credit Amount | |
i_gljournal | amtsourcecr | numeric | 0 | √ | 0 | Source Credit Amount | |
i_fajournal | amtsourcedr | numeric | 0 | √ | null | Source Debit Amount | |
i_gljournal | amtsourcedr | numeric | 0 | √ | 0 | Source Debit Amount | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
m_inventory | approvalamt | numeric | 0 | √ | null | Document Approval Amount | |
i_asset | assetdepreciationdate | timestamp | 29,6 | √ | null | Date of last depreciation | |
i_fixedasset | assetdepreciationdate | timestamp | 29,6 | √ | null | Date of last depreciation | |
i_asset | assetdisposaldate | timestamp | 29,6 | √ | null | Date when the asset is/was disposed | |
i_asset | assetmarketvalueamt | numeric | 0 | √ | null | Market value of the asset | |
i_asset | assetservicedate | timestamp | 29,6 | √ | null | Date when Asset was put into service | |
i_fixedasset | assetservicedate | timestamp | 29,6 | √ | null | Date when Asset was put into service | |
s_resourceassignment | assigndateto | timestamp | 29,6 | √ | null | Assign resource until | |
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
i_bankstatement | bankaccountno | varchar | 20 | √ | null | Bank Account Number | |
i_payment | bankaccountno | varchar | 20 | √ | null | Bank Account Number | |
m_pricelist | basepricelist_id | numeric | 10 | √ | null | Pricelist to be used, if product not found on this pricelist | |
i_fajournal | batchdescription | varchar | 510 | √ | null | Description of the Batch | |
i_gljournal | batchdescription | varchar | 255 | √ | null | Description of the Batch | |
i_fajournal | batchdocumentno | varchar | 60 | √ | null | Document Number of the Batch | |
i_gljournal | batchdocumentno | varchar | 30 | √ | null | Document Number of the Batch | |
c_bankaccount | bban | varchar | 40 | √ | null | Basic Bank Account Number | |
c_bankstatement | beginningbalance | numeric | 0 | √ | 0 | Balance prior to any transactions | |
c_order | bill_bpartner_id | numeric | 10 | √ | null | Business Partner to be invoiced | |
c_order | bill_location_id | numeric | 10 | √ | null | Business Partner Location for invoicing | |
c_order | bill_user_id | numeric | 10 | √ | null | Business Partner Contact for invoicing | |
i_order | billto_id | numeric | 10 | √ | null | Bill to Address | |
imp_processorlog | binarydata | bytea | 2147483647 | √ | null | Binary Data | |
ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
i_bpartner | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | Address of the Business Partner | |
c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
i_fixedasset | bpartner_value | varchar | 40 | √ | NULL::character varying | The Key of the Business Partner | |
i_pricelist | bpartner_value | varchar | 40 | √ | null | The Key of the Business Partner | |
i_product | bpartner_value | varchar | 40 | √ | null | The Key of the Business Partner | |
c_elementvalue | bpartnertype | bpchar | 1 | √ | NULL::bpchar | Business Partner Type | |
i_bankstatement | bpartnervalue | varchar | 40 | √ | null | Key of the Business Partner | |
i_fajournal | bpartnervalue | varchar | 80 | √ | null | Key of the Business Partner | |
i_gljournal | bpartnervalue | varchar | 40 | √ | null | Key of the Business Partner | |
i_invoice | bpartnervalue | varchar | 40 | √ | null | Key of the Business Partner | |
i_movement | bpartnervalue | varchar | 40 | √ | NULL::character varying | Key of the Business Partner | |
i_order | bpartnervalue | varchar | 40 | √ | null | Key of the Business Partner | |
i_payment | bpartnervalue | varchar | 40 | √ | null | Key of the Business Partner | |
i_bpartner | bpcontactgreeting | varchar | 60 | √ | null | Greeting for Business Partner Contact | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
i_pricelist | breakvalue | numeric | 0 | √ | null | Low Value of trade discount break level | |
gl_budget | budgetstatus | bpchar | 1 | √ | null | Indicates the current status of this budget | |
c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | 1099 Box | |
i_invoice | c_1099box_id | numeric | 10 | √ | NULL::numeric | 1099 Box | |
i_invoice | c_1099box_value | varchar | 40 | √ | NULL::character varying | 1099 Box Value | |
i_asset | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
i_fajournal | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
i_fixedasset | c_acctschema_id | numeric | 10 | √ | NULL::numeric | Rules for accounting | |
i_gljournal | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_UU | |
c_invoice | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_invoiceline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_order | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_orderline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_payment | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_project | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
c_validcombination | c_activity_id | numeric | 10 | √ | null | Business Activity | |
gl_journalline | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
i_fajournal | c_activity_id | numeric | 10 | √ | null | Business Activity | |
i_gljournal | c_activity_id | numeric | 10 | √ | null | Business Activity | |
i_invoice | c_activity_id | numeric | 10 | √ | null | Business Activity | |
i_order | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_inventory | c_activity_id | numeric | 10 | √ | null | Business Activity | |
pa_reportsource | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_activity | c_activity_uu | varchar | 36 | √ | NULL::character varying | C_Activity_UU | |
c_location | c_addressvalidation_id | numeric | 10 | √ | NULL::numeric | Address Validation | |
c_elementvalue | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
c_payment | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
i_bankstatement | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
i_payment | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
c_bankaccount | c_bankaccount_uu | varchar | 36 | √ | NULL::character varying | C_BankAccount_UU | |
i_bankstatement | c_bankstatement_id | numeric | 10 | √ | null | Bank Statement of account | |
c_bankstatement | c_bankstatement_uu | varchar | 36 | √ | NULL::character varying | C_BankStatement_UU | |
i_bankstatement | c_bankstatementline_id | numeric | 10 | √ | null | Line on a statement from this Bank | |
c_bankstatementline | c_bankstatementline_uu | varchar | 36 | √ | NULL::character varying | C_BankStatementLine_UU | |
c_payment | c_banktransfer_id | numeric | 10 | √ | NULL::numeric | Bank Transfer | |
c_payment | c_bp_bankaccount_id | numeric | 10 | √ | null | Bank Account of the Business Partner | |
i_bpartner | c_bp_group_id | numeric | 10 | √ | null | Business Partner Group | |
c_bp_group | c_bp_group_uu | varchar | 36 | √ | NULL::character varying | C_BP_Group_UU | |
ad_user | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_bankstatementline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_charge | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_orderline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_payment | c_bpartner_id | numeric | 10 | √ | null | 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 | |
gl_journalline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
i_asset | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_bankstatement | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_bpartner | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_fajournal | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_gljournal | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_invoice | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_movement | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
i_order | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_payment | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_pricelist | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_product | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
m_shipper | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
pa_reportsource | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_orderline | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_project | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
i_asset | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
i_bpartner | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
i_invoice | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
i_order | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
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_project | c_bpartnersr_id | numeric | 10 | √ | null | Business Partner (Agent or Sales Rep) | |
i_fixedasset | c_bpartnersr_id | numeric | 10 | √ | NULL::numeric | Business Partner (Agent or Sales Rep) | |
ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
c_invoice | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_invoiceline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_order | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_orderline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_payment | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_project | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_validcombination | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
gl_journalline | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
i_fajournal | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
i_gljournal | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
i_invoice | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
i_movement | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
i_order | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_inventory | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
pa_reportsource | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_campaign | c_campaign_uu | varchar | 36 | √ | NULL::character varying | C_Campaign_UU | |
c_payment | c_cashbook_id | numeric | 10 | √ | null | Cash Book for recording petty cash transactions | |
c_invoice | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
c_order | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
c_invoice | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
c_campaign | c_channel_id | numeric | 10 | √ | null | Sales Channel | |
c_bankstatementline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_invoice | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_invoiceline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_order | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_orderline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_payment | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
i_bankstatement | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
i_inventory | c_charge_id | numeric | 10 | √ | NULL::numeric | Additional document charges | |
i_invoice | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
i_order | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
i_payment | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_inventoryline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_charge | c_charge_uu | varchar | 36 | √ | NULL::character varying | C_Charge_UU | |
c_charge | c_chargetype_id | numeric | 10 | √ | null | Charge Type | |
c_location | c_city_id | numeric | 10 | √ | null | City | |
i_fixedasset | c_city_id | numeric | 10 | √ | NULL::numeric | City | |
i_fixedasset | c_city_value | varchar | 40 | √ | NULL::character varying | City Value | |
i_conversion_rate | c_conversion_rate_id | numeric | 10 | √ | null | Rate used for converting currencies | |
c_conversion_rate | c_conversion_rate_uu | varchar | 36 | √ | NULL::character varying | C_Conversion_Rate_UU | |
c_invoice | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
c_order | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
c_payment | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
i_conversion_rate | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
i_fajournal | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
i_gljournal | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
m_inventory | c_conversiontype_id | numeric | 10 | √ | NULL::numeric | Currency Conversion Rate Type | |
c_conversiontype | c_conversiontype_uu | varchar | 36 | √ | NULL::character varying | C_ConversionType_UU | |
c_tax | c_country_id | numeric | 10 | √ | null | Country | |
i_bpartner | c_country_id | numeric | 10 | √ | null | Country | |
i_invoice | c_country_id | numeric | 10 | √ | null | Country | |
i_order | c_country_id | numeric | 10 | √ | null | Country | |
c_country | c_country_uu | varchar | 36 | √ | NULL::character varying | C_Country_UU | |
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_country | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
c_elementvalue | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
gl_journal | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
gl_journalbatch | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_bankstatement | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_conversion_rate | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_fajournal | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_fixedasset | c_currency_id | numeric | 10 | √ | NULL::numeric | The Currency for this record | |
i_gljournal | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_invoice | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_order | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_payment | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_pricelist | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_product | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
m_inventory | c_currency_id | numeric | 10 | √ | NULL::numeric | The Currency for this record | |
m_product_po | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
i_conversion_rate | c_currency_id_to | numeric | 10 | √ | null | Target currency | |
c_currency | c_currency_uu | varchar | 36 | √ | NULL::character varying | C_Currency_UU | |
c_payment | c_depositbatch_id | numeric | 10 | √ | NULL::numeric | Deposit Batch | |
i_fajournal | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
i_gljournal | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
i_inventory | c_doctype_id | numeric | 10 | √ | NULL::numeric | Document type or rules | |
i_invoice | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
i_movement | c_doctype_id | numeric | 10 | √ | NULL::numeric | Document type or rules | |
i_order | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
i_payment | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
c_doctype | c_doctype_uu | varchar | 36 | √ | NULL::character varying | C_DocType_UU | |
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_bp_group | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
c_invoice | c_dunninglevel_id | numeric | 10 | √ | null | Dunning Level | |
i_elementvalue | c_element_id | numeric | 10 | √ | null | Accounting Element | |
c_element | c_element_uu | varchar | 36 | √ | NULL::character varying | C_Element_UU | |
i_elementvalue | c_elementvalue_id | numeric | 10 | √ | null | Account Element | |
i_reportline | c_elementvalue_id | numeric | 10 | √ | null | Account Element | |
pa_reportsource | c_elementvalue_id | numeric | 10 | √ | null | Account Element | |
c_elementvalue | c_elementvalue_uu | varchar | 36 | √ | NULL::character varying | C_ElementValue_UU | |
ad_user | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
c_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
i_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
c_greeting | c_greeting_uu | varchar | 36 | √ | NULL::character varying | C_Greeting_UU | |
c_bankstatementline | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
c_payment | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
i_bankstatement | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
i_invoice | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
i_payment | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
c_invoice | c_invoice_uu | varchar | 36 | √ | NULL::character varying | C_Invoice_UU | |
i_invoice | c_invoiceline_id | numeric | 10 | √ | null | Invoice Detail Line | |
m_inoutlineconfirm | c_invoiceline_id | numeric | 10 | √ | null | Invoice Detail Line | |
c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | C_InvoiceLine_UU | |
c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | Schedule for generating Invoices | |
c_invoicetax | c_invoicetax_uu | varchar | 36 | √ | NULL::character varying | C_InvoiceTax_UU | |
ad_user | c_job_id | numeric | 10 | √ | null | Job Position | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
c_bpartner_location | c_location_id | numeric | 10 | √ | null | Location or Address | |
i_asset | c_location_id | numeric | 10 | √ | null | Location or Address | |
i_invoice | c_location_id | numeric | 10 | √ | null | Location or Address | |
i_order | c_location_id | numeric | 10 | √ | null | Location or Address | |
pa_reportsource | c_location_id | numeric | 10 | √ | null | Location or Address | |
c_location | c_location_uu | varchar | 36 | √ | NULL::character varying | C_Location_UU | |
c_validcombination | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
gl_journalline | c_locfrom_id | numeric | 10 | √ | NULL::numeric | Location that inventory was moved from | |
i_fajournal | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
i_gljournal | 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 | |
gl_journalline | c_locto_id | numeric | 10 | √ | NULL::numeric | Location that inventory was moved to | |
i_fajournal | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
i_gljournal | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | Sales Opportunity | |
c_invoice | c_order_id | numeric | 10 | √ | null | Order | |
c_payment | c_order_id | numeric | 10 | √ | null | Order | |
i_order | c_order_id | numeric | 10 | √ | null | Order | |
c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | C_Order_UU | |
c_invoiceline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
i_order | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | C_OrderLine_UU | |
c_order | c_ordersource_id | numeric | 10 | √ | null | Order Source | |
i_order | c_ordersource_id | numeric | 10 | √ | NULL::numeric | Order Source | |
i_order | c_ordersourcevalue | varchar | 40 | √ | NULL::character varying | Order Source Key | |
c_ordertax | c_ordertax_uu | varchar | 36 | √ | NULL::character varying | C_OrderTax_UU | |
c_bankstatementline | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_invoice | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_order | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
i_bankstatement | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
i_payment | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_payment | c_payment_uu | varchar | 36 | √ | NULL::character varying | C_Payment_UU | |
c_payment | c_paymentbatch_id | numeric | 10 | √ | null | Payment batch for EFT | |
c_payment | 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_project | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
i_invoice | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
i_order | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
c_paymentterm | c_paymentterm_uu | varchar | 36 | √ | NULL::character varying | C_PaymentTerm_UU | |
c_acctschema | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
gl_journalbatch | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
i_fajournal | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
i_gljournal | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
c_period | c_period_uu | varchar | 36 | √ | NULL::character varying | C_Period_UU | |
c_project | c_phase_id | numeric | 10 | √ | null | Standard Phase of the Project Type | |
c_order | c_pos_id | numeric | 10 | √ | null | Point of Sales Terminal | |
c_payment | c_postendertype_id | numeric | 10 | √ | NULL::numeric | POS Tender Type | |
c_invoice | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_invoiceline | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_order | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_orderline | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_payment | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_validcombination | c_project_id | numeric | 10 | √ | null | Financial Project | |
gl_journalline | c_project_id | numeric | 10 | √ | NULL::numeric | Financial Project | |
i_fajournal | c_project_id | numeric | 10 | √ | null | Financial Project | |
i_gljournal | c_project_id | numeric | 10 | √ | null | Financial Project | |
i_invoice | c_project_id | numeric | 10 | √ | null | Financial Project | |
i_movement | c_project_id | numeric | 10 | √ | NULL::numeric | Financial Project | |
i_order | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_inventory | c_project_id | numeric | 10 | √ | null | Financial Project | |
pa_reportsource | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_project | c_project_uu | varchar | 36 | √ | NULL::character varying | C_Project_UU | |
c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
c_orderline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
c_orderline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
c_project | c_projecttype_id | numeric | 10 | √ | null | Type of the project | |
c_location | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
c_tax | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
i_bpartner | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
i_invoice | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
i_order | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
c_region | c_region_uu | varchar | 36 | √ | NULL::character varying | C_Region_UU | |
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_validcombination | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
gl_journalline | c_salesregion_id | numeric | 10 | √ | NULL::numeric | Sales coverage region | |
i_fajournal | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
i_gljournal | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
pa_reportsource | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
c_salesregion | c_salesregion_uu | varchar | 36 | √ | NULL::character varying | C_SalesRegion_UU | |
c_validcombination | c_subacct_id | numeric | 10 | √ | null | Sub account for Element Value | |
gl_journalline | c_subacct_id | numeric | 10 | √ | NULL::numeric | Sub account for Element Value | |
i_fajournal | c_subacct_id | numeric | 10 | √ | null | Sub account for Element Value | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
c_invoiceline | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
i_invoice | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
i_order | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
c_tax | c_tax_uu | varchar | 36 | √ | NULL::character varying | C_Tax_UU | |
c_charge | c_taxcategory_id | numeric | 10 | √ | null | Tax Category | |
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
c_invoicetax | c_taxprovider_id | numeric | 10 | √ | NULL::numeric | Tax Provider | |
c_ordertax | c_taxprovider_id | numeric | 10 | √ | NULL::numeric | Tax Provider | |
c_tax | c_taxprovider_id | numeric | 10 | √ | NULL::numeric | Tax Provider | |
c_invoiceline | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
gl_journalline | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
i_fajournal | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
i_fixedasset | c_uom_id | numeric | 10 | √ | NULL::numeric | Unit of Measure | |
i_gljournal | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
i_order | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
i_pricelist | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
i_product | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
m_product_po | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
c_uom | c_uom_uu | varchar | 36 | √ | NULL::character varying | C_UOM_UU | |
gl_journalline | c_validcombination_id | numeric | 10 | √ | null | Valid Account Combination | |
i_fajournal | c_validcombination_id | numeric | 10 | √ | null | Valid Account Combination | |
i_gljournal | c_validcombination_id | numeric | 10 | √ | null | Valid Account Combination | |
c_validcombination | c_validcombination_uu | varchar | 36 | √ | NULL::character varying | C_ValidCombination_UU | |
i_reportline | calculationtype | bpchar | 1 | √ | null | Calculation | |
pa_reportline | calculationtype | bpchar | 1 | √ | null | Calculation | |
ad_column | callout | varchar | 255 | √ | null | Fully qualified class names and method - separated by semicolons | |
ad_impformat_row | callout | varchar | 4000 | √ | null | Fully qualified class names and method - separated by semicolons | |
i_gljournal | campaignvalue | varchar | 40 | √ | NULL::character varying | Text key of the Campaign | |
i_movement | campaignvalue | varchar | 40 | √ | NULL::character varying | Text key of the Campaign | |
c_country | capturesequence | varchar | 60 | √ | null | Capture Sequence | |
i_fajournal | categoryname | varchar | 120 | √ | null | Name of the Category | |
i_gljournal | categoryname | varchar | 60 | √ | null | Name of the Category | |
c_invoice | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
c_order | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
c_payment | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
i_bankstatement | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
i_payment | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
i_bankstatement | chargename | varchar | 60 | √ | null | Name of the Charge | |
i_inventory | chargename | varchar | 60 | √ | NULL::character varying | Name of the Charge | |
i_invoice | chargename | varchar | 60 | √ | null | Name of the Charge | |
i_order | chargename | varchar | 60 | √ | null | Name of the Charge | |
i_payment | chargename | varchar | 60 | √ | null | Name of the Charge | |
c_payment | checkno | varchar | 20 | √ | null | Check Number | |
i_payment | checkno | varchar | 20 | √ | null | Check Number | |
c_location | city | varchar | 60 | √ | null | Identifies a City | |
i_bpartner | city | varchar | 60 | √ | null | Identifies a City | |
i_invoice | city | varchar | 60 | √ | null | Identifies a City | |
i_order | city | varchar | 60 | √ | null | Identifies a City | |
i_product | classification | bpchar | 1 | √ | null | Classification for grouping | |
m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
i_fajournal | clientvalue | varchar | 80 | √ | null | Key of the Tenant | |
i_gljournal | clientvalue | varchar | 40 | √ | null | Key of the Tenant | |
ad_column | columnsql | varchar | 4000 | √ | null | Virtual Column (r/o) | |
c_validcombination | combination | varchar | 60 | √ | null | Unique combination of account elements | |
ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
c_location | comments | varchar | 2000 | √ | NULL::character varying | Comments or additional information | |
i_bpartner | comments | varchar | 2000 | √ | null | Comments or additional information | |
i_inoutlineconfirm | confirmationno | varchar | 20 | √ | null | Confirmation Number | |
m_inoutlineconfirm | confirmationno | varchar | 20 | √ | null | Confirmation Number | |
i_inoutlineconfirm | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_impformat_row | constantvalue | varchar | 60 | √ | null | Constant value | |
i_bpartner | contactdescription | varchar | 255 | √ | null | Description of Contact | |
i_bpartner | contactname | varchar | 60 | √ | null | Business Partner Contact Name | |
i_invoice | contactname | varchar | 60 | √ | null | Business Partner Contact Name | |
i_order | contactname | varchar | 60 | √ | null | Business Partner Contact Name | |
gl_journal | controlamt | numeric | 0 | √ | 0 | If not zero, the Debit amount of the document must be equal this amount | |
gl_journalbatch | controlamt | numeric | 0 | √ | 0 | If not zero, the Debit amount of the document must be equal this amount | |
i_asset | conventiontype | varchar | 10 | √ | null | Convention Type | |
i_conversion_rate | conversiontypevalue | varchar | 40 | √ | null | Key value for the Currency Conversion Rate Type | |
i_fajournal | conversiontypevalue | varchar | 40 | √ | null | Key value for the Currency Conversion Rate Type | |
i_gljournal | conversiontypevalue | varchar | 40 | √ | null | Key value for the Currency Conversion Rate Type | |
c_payment | convertedamt | numeric | 0 | √ | null | Converted Amount | |
c_bankstatement | copyfrom | bpchar | 1 | √ | 'N'::bpchar | Copy From Record | |
c_invoice | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_order | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_project | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
gl_journal | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
gl_journalbatch | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
m_inventory | costingmethod | bpchar | 1 | √ | NULL::bpchar | Indicates how Costs will be calculated | |
i_product | costperorder | numeric | 0 | √ | 0 | Fixed Cost Per Order | |
m_product_po | costperorder | numeric | 0 | √ | 0 | Fixed Cost Per Order | |
i_bpartner | countrycode | bpchar | 2 | √ | null | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | |
i_invoice | countrycode | bpchar | 2 | √ | null | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | |
i_order | countrycode | bpchar | 2 | √ | null | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | |
i_asset | createdby | numeric | 10 | √ | null | User who created this records | |
i_bankstatement | createdby | numeric | 10 | √ | null | User who created this records | |
i_bpartner | createdby | numeric | 10 | √ | null | User who created this records | |
i_conversion_rate | createdby | numeric | 10 | √ | null | User who created this records | |
i_elementvalue | createdby | numeric | 10 | √ | null | User who created this records | |
i_fajournal | createdby | numeric | 10 | √ | null | User who created this records | |
i_gljournal | createdby | numeric | 10 | √ | null | User who created this records | |
i_inventory | createdby | numeric | 10 | √ | null | User who created this records | |
i_invoice | createdby | numeric | 10 | √ | null | User who created this records | |
i_order | createdby | numeric | 10 | √ | null | User who created this records | |
i_payment | createdby | numeric | 10 | √ | null | User who created this records | |
i_pricelist | createdby | numeric | 10 | √ | null | User who created this records | |
i_product | createdby | numeric | 10 | √ | null | User who created this records | |
i_reportline | createdby | numeric | 10 | √ | null | User who created this records | |
c_bankstatement | createfrom | bpchar | 1 | √ | 'N'::bpchar | Process which will generate a new document lines based on an existing document | |
c_invoice | createfrom | bpchar | 1 | √ | null | Process which will generate a new document lines based on an existing document | |
m_shipper | createfrom | bpchar | 1 | √ | NULL::bpchar | Process which will generate a new document lines based on an existing document | |
c_bankstatement | createfrombatch | bpchar | 1 | √ | NULL::bpchar | Create From Batch | |
c_invoice | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | Process which will generate a new document lines based on an existing document | |
c_bankstatementline | createpayment | bpchar | 1 | √ | null | Create Payment | |
i_bankstatement | createpayment | bpchar | 1 | √ | null | Create Payment | |
c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | Create Production | |
i_conversion_rate | createreciprocalrate | bpchar | 1 | √ | 'N'::bpchar | Create Reciprocal Rate from current information | |
c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | Create Shipment | |
c_payment | creditcardexpmm | numeric | 10 | √ | null | Expiry Month | |
i_payment | creditcardexpmm | numeric | 10 | √ | null | Expiry Month | |
c_payment | creditcardexpyy | numeric | 10 | √ | null | Expiry Year | |
i_payment | creditcardexpyy | numeric | 10 | √ | null | Expiry Year | |
c_payment | creditcardnumber | varchar | 20 | √ | null | Credit Card Number | |
i_payment | creditcardnumber | varchar | 20 | √ | null | Credit Card Number | |
c_payment | creditcardtype | bpchar | 1 | √ | null | Credit Card (Visa, MC, AmEx) | |
i_payment | creditcardtype | bpchar | 1 | √ | null | Credit Card (Visa, MC, AmEx) | |
c_payment | creditcardvv | varchar | 4 | √ | null | Credit Card Verification code on credit card | |
i_payment | creditcardvv | varchar | 4 | √ | null | Credit Card Verification code on credit card | |
c_bp_group | creditwatchpercent | numeric | 0 | √ | null | Credit Watch - Percent of Credit Limit when OK switches to Watch | |
ad_importtemplate | csvaliasheader | varchar | 2000 | √ | NULL::character varying | CSV Alias Header | |
c_invoice | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
c_payment | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
i_fajournal | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
i_gljournal | currencyrate | numeric | 0 | √ | 0 | Currency Conversion Rate | |
i_fajournal | currencyratetype | bpchar | 1 | √ | null | Currency Rate Type | |
i_inventory | currentcostprice | numeric | 0 | √ | null | The currently used cost price | |
m_inventoryline | currentcostprice | numeric | 0 | √ | (0)::numeric | The currently used cost price | |
c_currency | cursymbol | varchar | 10 | √ | null | Symbol of the currency (opt used for printing only) | |
c_bpartner_location | customeraddressid | varchar | 60 | √ | NULL::character varying | Customer Address ID | |
c_payment | customeraddressid | varchar | 60 | √ | NULL::character varying | Customer Address ID | |
c_payment | customerpaymentprofileid | varchar | 60 | √ | NULL::character varying | Customer Payment Profile ID | |
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
c_payment | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
i_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
ad_impformat_row | dataformat | varchar | 20 | √ | null | Format String in Java Notation, e.g. ddMMyy | |
ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | Date Account Locked | |
gl_journalbatch | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_bankstatement | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_fajournal | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_fixedasset | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_gljournal | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_invoice | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_order | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
i_payment | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
c_project | datecontract | timestamp | 29,6 | √ | null | The (planned) effective date of this document. | |
c_orderline | datedelivered | timestamp | 29,6 | √ | null | Date when the product was delivered | |
gl_journalbatch | datedoc | timestamp | 29,6 | √ | null | Date of the Document | |
c_project | datefinish | timestamp | 29,6 | √ | null | Finish or (planned) completion date | |
exp_formatline | dateformat | varchar | 40 | √ | null | Date format used in the input format | |
c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | Date printed on Invoice | |
i_invoice | dateinvoiced | timestamp | 29,6 | √ | null | Date printed on Invoice | |
ad_user | datelastlogin | timestamp | 29,6 | √ | null | Date Last Login | |
c_invoice | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
i_order | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | Date Password Changed | |
c_invoice | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
c_orderline | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
i_payment | datetrx | timestamp | 29,6 | √ | null | Transaction Date | |
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
i_elementvalue | default_account | varchar | 30 | √ | null | Name of the Default Account Column | |
ad_column | defaultvalue | varchar | 2000 | √ | null | Default value hierarchy, separated by ; | |
c_doctype | definitesequence_id | numeric | 10 | √ | null | Definite Sequence | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
i_movement | deliveryrule | varchar | 40 | √ | NULL::character varying | Defines the timing of Delivery | |
i_order | deliveryrule | bpchar | 1 | √ | NULL::bpchar | Defines the timing of Delivery | |
m_product_po | deliverytime_actual | numeric | 10 | √ | null | Actual days between order and delivery | |
i_product | deliverytime_promised | numeric | 10 | √ | null | Promised days between order and delivery | |
m_product_po | deliverytime_promised | numeric | 10 | √ | null | Promised days between order and delivery | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
i_movement | deliveryviarule | varchar | 40 | √ | NULL::character varying | How the order will be delivered | |
i_asset | depreciationtype | varchar | 10 | √ | null | Depreciation Type | |
ad_column | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_impformat | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_importtemplate | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
ad_org | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
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_bankaccount | description | varchar | 255 | √ | null | Optional short description of the record | |
c_bankstatement | description | varchar | 255 | √ | null | Optional short description of the record | |
c_bankstatementline | description | varchar | 1000 | √ | null | Optional short description of the record | |
c_bp_group | description | varchar | 255 | √ | null | Optional short description of the record | |
c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
c_campaign | description | varchar | 255 | √ | null | Optional short description of the record | |
c_charge | description | varchar | 255 | √ | null | Optional short description of the record | |
c_conversiontype | description | varchar | 255 | √ | null | Optional short description of the record | |
c_country | description | varchar | 255 | √ | null | Optional short description of the record | |
c_doctype | 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_invoice | description | varchar | 255 | √ | null | Optional short description of the record | |
c_invoiceline | description | varchar | 255 | √ | null | Optional short description of the record | |
c_order | description | varchar | 255 | √ | null | Optional short description of the record | |
c_orderline | description | varchar | 255 | √ | null | Optional short description of the record | |
c_payment | 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_uom | description | varchar | 255 | √ | null | Optional short description of the record | |
c_validcombination | description | varchar | 255 | √ | null | Optional short description of the record | |
exp_format | description | varchar | 255 | √ | null | Optional short description of the record | |
exp_formatline | description | varchar | 255 | √ | null | Optional short description of the record | |
exp_processor_type | description | varchar | 255 | √ | null | Optional short description of the record | |
exp_processorparameter | description | varchar | 255 | √ | null | Optional short description of the record | |
gl_budget | description | varchar | 255 | √ | null | Optional short description of the record | |
gl_category | description | varchar | 255 | √ | null | Optional short description of the record | |
gl_journalline | description | varchar | 255 | √ | null | Optional short description of the record | |
i_asset | description | varchar | 510 | √ | null | Optional short description of the record | |
i_bankstatement | description | varchar | 255 | √ | null | Optional short description of the record | |
i_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
i_elementvalue | description | varchar | 255 | √ | null | Optional short description of the record | |
i_fajournal | description | varchar | 510 | √ | null | Optional short description of the record | |
i_fixedasset | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
i_gljournal | description | varchar | 255 | √ | null | Optional short description of the record | |
i_inoutlineconfirm | description | varchar | 255 | √ | null | Optional short description of the record | |
i_inventory | description | varchar | 255 | √ | null | Optional short description of the record | |
i_invoice | description | varchar | 255 | √ | null | Optional short description of the record | |
i_order | description | varchar | 255 | √ | null | Optional short description of the record | |
i_pricelist | description | varchar | 255 | √ | null | Optional short description of the record | |
i_product | description | varchar | 255 | √ | null | Optional short description of the record | |
i_reportline | description | varchar | 255 | √ | null | Optional short description of the record | |
imp_processor_type | description | varchar | 255 | √ | null | Optional short description of the record | |
imp_processorlog | description | varchar | 255 | √ | null | Optional short description of the record | |
imp_processorparameter | description | varchar | 255 | √ | null | Optional short description of the record | |
m_attributesetinstance | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inoutlineconfirm | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inventory | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inventoryline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_pricelist | description | varchar | 255 | √ | null | Optional short description of the record | |
m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
m_product_category | description | varchar | 255 | √ | null | Optional short description of the record | |
m_warehouse | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_reportline | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_reportlineset | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_reportsource | description | varchar | 255 | √ | null | Optional short description of the record | |
r_interestarea | description | varchar | 255 | √ | null | Optional short description of the record | |
s_resourceassignment | description | varchar | 255 | √ | null | Optional short description of the record | |
i_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
m_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
i_inoutlineconfirm | differenceqty | numeric | 0 | √ | 0 | Difference Quantity | |
m_inoutlineconfirm | differenceqty | numeric | 0 | √ | null | Difference Quantity | |
i_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
m_product_po | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
i_product | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
m_product_po | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
i_product | discontinuedby | timestamp | 29,6 | √ | null | ||
m_product | discontinuedby | timestamp | 29,6 | √ | null | ||
m_product_po | discontinuedby | timestamp | 29,6 | √ | null | ||
c_orderline | discount | numeric | 0 | √ | null | Discount in percent | |
c_payment | discountamt | numeric | 0 | √ | 0 | Calculated amount of discount | |
i_payment | discountamt | numeric | 0 | √ | 0 | Calculated amount of discount | |
c_country | displaysequencelocal | varchar | 20 | √ | null | Format for printing this Address locally | |
i_conversion_rate | dividerate | numeric | 0 | √ | null | To convert Source number to Target number, the Source is divided | |
gl_category | docbasetype | bpchar | 3 | √ | null | Logical type of document | |
c_doctype | docnosequence_id | numeric | 10 | √ | null | Document sequence determines the numbering of documents | |
c_doctype | docsubtypeinv | varchar | 2 | √ | NULL::character varying | Inventory Sub Type | |
c_doctype | docsubtypeso | bpchar | 2 | √ | null | Sales Order Sub Type | |
i_fajournal | doctypename | varchar | 120 | √ | null | Name of the Document Type | |
i_gljournal | doctypename | varchar | 60 | √ | null | Name of the Document Type | |
i_inventory | doctypename | varchar | 60 | √ | NULL::character varying | Name of the Document Type | |
i_invoice | doctypename | varchar | 60 | √ | null | Name of the Document Type | |
i_movement | doctypename | varchar | 40 | √ | NULL::character varying | Name of the Document Type | |
i_order | doctypename | varchar | 60 | √ | null | Name of the Document Type | |
i_payment | doctypename | varchar | 60 | √ | null | Name of the Document Type | |
c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
i_invoice | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
i_movement | documentno | varchar | 40 | √ | null | Document sequence number of the document | |
i_order | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
i_payment | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
c_doctype | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
c_paymentterm | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
i_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
m_product | downloadurl | varchar | 120 | √ | null | ||
c_order | dropship_bpartner_id | numeric | 10 | √ | null | Business Partner to ship to | |
c_order | dropship_location_id | numeric | 10 | √ | null | Business Partner Location for shipping to | |
c_order | dropship_user_id | numeric | 10 | √ | null | Business Partner Contact for drop shipment | |
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
c_invoice | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
i_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
c_bankstatementline | eftamt | numeric | 0 | √ | 0 | Electronic Funds Transfer Amount | |
i_bankstatement | eftamt | numeric | 0 | √ | 0 | Electronic Funds Transfer Amount | |
c_bankstatementline | eftcheckno | varchar | 20 | √ | null | Electronic Funds Transfer Check No | |
i_bankstatement | eftcheckno | varchar | 20 | √ | null | Electronic Funds Transfer Check No | |
c_bankstatementline | eftcurrency | varchar | 20 | √ | null | Electronic Funds Transfer Currency | |
i_bankstatement | eftcurrency | varchar | 20 | √ | null | Electronic Funds Transfer Currency | |
c_bankstatementline | eftmemo | varchar | 4000 | √ | null | Electronic Funds Transfer Memo | |
i_bankstatement | eftmemo | varchar | 4000 | √ | null | Electronic Funds Transfer Memo | |
c_bankstatementline | eftpayee | varchar | 255 | √ | null | Electronic Funds Transfer Payee information | |
i_bankstatement | eftpayee | varchar | 255 | √ | null | Electronic Funds Transfer Payee information | |
c_bankstatementline | eftpayeeaccount | varchar | 40 | √ | null | Electronic Funds Transfer Payee Account Information | |
i_bankstatement | eftpayeeaccount | varchar | 40 | √ | null | Electronic Funds Transfer Payee Account Information | |
c_bankstatementline | eftreference | varchar | 255 | √ | null | Electronic Funds Transfer Reference | |
i_bankstatement | eftreference | varchar | 255 | √ | null | Electronic Funds Transfer Reference | |
c_bankstatement | eftstatementdate | timestamp | 29,6 | √ | null | Electronic Funds Transfer Statement Date | |
i_bankstatement | eftstatementdate | timestamp | 29,6 | √ | null | Electronic Funds Transfer Statement Date | |
c_bankstatementline | eftstatementlinedate | timestamp | 29,6 | √ | null | Electronic Funds Transfer Statement Line Date | |
i_bankstatement | eftstatementlinedate | timestamp | 29,6 | √ | null | Electronic Funds Transfer Statement Line Date | |
c_bankstatement | eftstatementreference | varchar | 60 | √ | null | Electronic Funds Transfer Statement Reference | |
i_bankstatement | eftstatementreference | varchar | 60 | √ | null | Electronic Funds Transfer Statement Reference | |
c_bankstatementline | efttrxid | varchar | 40 | √ | null | Electronic Funds Transfer Transaction ID | |
i_bankstatement | efttrxid | varchar | 40 | √ | null | Electronic Funds Transfer Transaction ID | |
c_bankstatementline | efttrxtype | varchar | 255 | √ | null | Electronic Funds Transfer Transaction Type | |
i_bankstatement | efttrxtype | varchar | 255 | √ | null | Electronic Funds Transfer Transaction Type | |
c_bankstatementline | eftvalutadate | timestamp | 29,6 | √ | null | Electronic Funds Transfer Valuta (effective) Date | |
i_bankstatement | eftvalutadate | timestamp | 29,6 | √ | null | Electronic Funds Transfer Valuta (effective) Date | |
i_elementvalue | elementname | varchar | 60 | √ | null | Name of the Element | |
i_reportline | elementvalue | varchar | 40 | √ | null | Key of the element | |
ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
i_bpartner | varchar | 60 | √ | null | Electronic Mail Address | ||
i_invoice | varchar | 60 | √ | null | Electronic Mail Address | ||
i_order | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
ad_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
ad_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
c_currency | emuentrydate | timestamp | 29,6 | √ | null | Date when the currency joined / will join the EMU | |
c_currency | emurate | numeric | 0 | √ | 0 | Official rate to the Euro | |
c_campaign | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
c_period | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
ad_impformat_row | endno | numeric | 10 | √ | null | End No | |
i_pricelist | enforcepricelimit | bpchar | 1 | √ | null | Do not allow prices below the limit price | |
exp_formatline | exp_embeddedformat_id | numeric | 10 | √ | null | Embedded Format | |
exp_formatline | exp_format_id | numeric | 10 | √ | null | Export Format | |
exp_format | exp_format_uu | varchar | 36 | √ | NULL::character varying | EXP_Format_UU | |
exp_formatline | exp_formatline_uu | varchar | 36 | √ | NULL::character varying | EXP_FormatLine_UU | |
exp_processor_type | exp_processor_type_uu | varchar | 36 | √ | NULL::character varying | EXP_Processor_Type_UU | |
exp_processorparameter | exp_processorparameter_uu | varchar | 36 | √ | NULL::character varying | EXP_ProcessorParameter_UU | |
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" | |
ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
c_bpartner_location | fax | varchar | 40 | √ | null | Facsimile number | |
i_bpartner | fax | varchar | 40 | √ | null | Facsimile number | |
ad_column | fieldlength | numeric | 10 | √ | null | Length of the column in the database | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
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) | |
ad_column | fkconstraintmsg_id | numeric | 10 | √ | NULL::numeric | Constraint Message | |
ad_column | fkconstraintname | varchar | 30 | √ | NULL::character varying | Constraint Name | |
ad_column | fkconstrainttype | bpchar | 1 | √ | 'N'::bpchar | Constraint Type | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
ad_column | formatpattern | varchar | 22 | √ | null | The pattern used to format a number or date. | |
c_order | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
i_order | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
i_movement | freightcostrule | varchar | 40 | √ | NULL::character varying | Method for charging Freight | |
m_inventory | generatelist | bpchar | 1 | √ | 'Y'::bpchar | Generate List | |
c_invoice | generateto | bpchar | 1 | √ | null | Generate To | |
c_project | generateto | bpchar | 1 | √ | null | Generate To | |
gl_journal | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
i_fajournal | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
i_gljournal | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
pa_reportline | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
gl_budget | gl_budget_uu | varchar | 36 | √ | NULL::character varying | GL_Budget_UU | |
gl_journalbatch | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
i_fajournal | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
i_gljournal | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
gl_category | gl_category_uu | varchar | 36 | √ | NULL::character varying | GL_Category_UU | |
i_fajournal | gl_journal_id | numeric | 10 | √ | null | General Ledger Journal | |
i_gljournal | gl_journal_id | numeric | 10 | √ | null | General Ledger Journal | |
gl_journal | gl_journal_uu | varchar | 36 | √ | NULL::character varying | GL_Journal_UU | |
gl_journal | gl_journalbatch_id | numeric | 10 | √ | null | General Ledger Journal Batch | |
i_fajournal | gl_journalbatch_id | numeric | 10 | √ | null | General Ledger Journal Batch | |
i_gljournal | gl_journalbatch_id | numeric | 10 | √ | null | General Ledger Journal Batch | |
gl_journalbatch | gl_journalbatch_uu | varchar | 36 | √ | NULL::character varying | GL_JournalBatch_UU | |
i_fajournal | gl_journalline_id | numeric | 10 | √ | null | General Ledger Journal Line | |
i_gljournal | gl_journalline_id | numeric | 10 | √ | null | General Ledger Journal Line | |
gl_journalline | gl_journalline_uu | varchar | 36 | √ | NULL::character varying | GL_JournalLine_UU | |
c_greeting | greeting | varchar | 60 | √ | null | For letters, e.g. "Dear {0}" or "Dear Mr. {0}" - At runtime, "{0}" is replaced by the name | |
i_product | group1 | varchar | 255 | √ | NULL::character varying | Group1 | |
m_product | group1 | varchar | 255 | √ | null | Group1 | |
i_product | group2 | varchar | 255 | √ | NULL::character varying | Group2 | |
m_product | group2 | varchar | 255 | √ | null | Group2 | |
i_bpartner | groupvalue | varchar | 40 | √ | null | Business Partner Group Key | |
i_asset | guaranteedate | timestamp | 29,6 | √ | null | Date when guarantee expires | |
m_attributesetinstance | guaranteedate | timestamp | 29,6 | √ | null | Date when guarantee expires | |
m_product | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | Minimum number of guarantee days | |
c_doctype | hasproforma | bpchar | 1 | √ | 'N'::bpchar | Indicates if Pro Forma Invoices can be generated from this document | |
ad_column | help | varchar | 2000 | √ | null | Comment or Hint | |
c_activity | help | varchar | 2000 | √ | null | Comment or Hint | |
exp_format | help | varchar | 2000 | √ | null | Comment or Hint | |
exp_formatline | help | varchar | 2000 | √ | null | Comment or Hint | |
exp_processor_type | help | varchar | 2000 | √ | null | Comment or Hint | |
exp_processorparameter | help | varchar | 2000 | √ | null | Comment or Hint | |
i_asset | help | varchar | 2000 | √ | null | Comment or Hint | |
i_product | help | varchar | 2000 | √ | null | Comment or Hint | |
imp_processor_type | help | varchar | 2000 | √ | null | Comment or Hint | |
imp_processorlog | help | varchar | 2000 | √ | null | Comment or Hint | |
imp_processorparameter | help | varchar | 2000 | √ | null | Comment or Hint | |
m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
i_asset | i_asset_uu | varchar | 36 | √ | NULL::character varying | I_Asset_UU | |
i_bankstatement | i_bankstatement_uu | varchar | 36 | √ | NULL::character varying | I_BankStatement_UU | |
i_bpartner | i_bpartner_uu | varchar | 36 | √ | NULL::character varying | I_BPartner_UU | |
i_conversion_rate | i_conversion_rate_uu | varchar | 36 | √ | NULL::character varying | I_Conversion_Rate_UU | |
i_elementvalue | i_elementvalue_uu | varchar | 36 | √ | NULL::character varying | I_ElementValue_UU | |
i_asset | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_bankstatement | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_bpartner | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_conversion_rate | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_elementvalue | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_fajournal | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_fixedasset | i_errormsg | varchar | 2000 | √ | NULL::character varying | Messages generated from import process | |
i_gljournal | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_inoutlineconfirm | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_inventory | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_invoice | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_movement | i_errormsg | varchar | 2000 | √ | NULL::character varying | Messages generated from import process | |
i_order | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_payment | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_pricelist | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_product | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_reportline | i_errormsg | varchar | 2000 | √ | null | Messages generated from import process | |
i_fajournal | i_fajournal_uu | varchar | 36 | √ | NULL::character varying | I_FAJournal_UU | |
i_fixedasset | i_fixedasset_uu | varchar | 36 | √ | NULL::character varying | I_FixedAsset_UU | |
i_gljournal | i_gljournal_uu | varchar | 36 | √ | NULL::character varying | I_GLJournal_UU | |
i_inoutlineconfirm | i_inoutlineconfirm_uu | varchar | 36 | √ | NULL::character varying | I_InOutLineConfirm_UU | |
i_inventory | i_inventory_uu | varchar | 36 | √ | NULL::character varying | I_Inventory_UU | |
i_invoice | i_invoice_uu | varchar | 36 | √ | NULL::character varying | I_Invoice_UU | |
i_asset | i_isimported | bpchar | 1 | √ | null | Has this import been processed | |
i_conversion_rate | i_isimported | bpchar | 1 | √ | 'N'::bpchar | Has this import been processed | |
i_movement | i_movement_uu | varchar | 36 | √ | NULL::character varying | I_Movement_UU | |
i_order | i_order_uu | varchar | 36 | √ | NULL::character varying | I_Order_UU | |
i_payment | i_payment_uu | varchar | 36 | √ | NULL::character varying | I_Payment_UU | |
i_pricelist | i_pricelist_uu | varchar | 36 | √ | NULL::character varying | I_PriceList_UU | |
i_product | i_product_uu | varchar | 36 | √ | NULL::character varying | I_Product_UU | |
i_reportline | i_reportline_uu | varchar | 36 | √ | NULL::character varying | I_ReportLine_UU | |
c_bankaccount | iban | varchar | 40 | √ | null | International Bank Account Number | |
c_payment | iban | varchar | 40 | √ | NULL::character varying | International Bank Account Number | |
i_bankstatement | iban | varchar | 40 | √ | NULL::character varying | International Bank Account Number | |
i_payment | iban | varchar | 40 | √ | NULL::character varying | International Bank Account Number | |
i_product | imageurl | varchar | 120 | √ | null | URL of image | |
m_product | imageurl | varchar | 120 | √ | null | URL of image | |
imp_processor_type | imp_processor_type_uu | varchar | 36 | √ | NULL::character varying | IMP_Processor_Type_UU | |
imp_processorlog | imp_processorlog_uu | varchar | 36 | √ | NULL::character varying | IMP_ProcessorLog_UU | |
imp_processorparameter | imp_processorparameter_uu | varchar | 36 | √ | NULL::character varying | IMP_ProcessorParameter_UU | |
ad_impformat_row | importprefix | varchar | 20 | √ | NULL::character varying | This prefix will be added in front of import string if they are not empty | |
ad_column | infofactoryclass | varchar | 255 | √ | null | Fully qualified class name that implements the InfoFactory interface | |
i_bankstatement | interestamt | numeric | 0 | √ | 0 | Interest Amount | |
i_bpartner | interestareaname | varchar | 40 | √ | null | Name of the Interest Area | |
i_fixedasset | inventoryno | varchar | 30 | √ | NULL::character varying | Inventory No | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
c_invoice | invoicecollectiontype | bpchar | 1 | √ | null | Invoice Collection Status | |
i_bankstatement | invoicedocumentno | varchar | 30 | √ | null | Document Number of the Invoice | |
i_payment | invoicedocumentno | varchar | 30 | √ | null | Document Number of the Invoice | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
i_asset | isactive | bpchar | 1 | √ | null | The record is active in the system | |
i_bankstatement | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_bpartner | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_conversion_rate | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_elementvalue | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_gljournal | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_inventory | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_invoice | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_order | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_payment | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_pricelist | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_product | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
i_reportline | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
ad_column | isallowlogging | bpchar | 1 | √ | 'Y'::bpchar | Determine if a column must be recorded into the change log | |
c_acctschema | isallownegativeposting | bpchar | 1 | √ | 'Y'::bpchar | Allow to post negative accounting values | |
gl_journalbatch | isapproved | bpchar | 1 | √ | null | Indicates if this document requires approval | |
i_payment | isapproved | bpchar | 1 | √ | 'N'::bpchar | Indicates if this document requires approval | |
c_elementvalue | isbankaccount | bpchar | 1 | √ | 'N'::bpchar | Indicates if this is the Bank Account | |
c_doctype | ischargeorproductmandatory | bpchar | 1 | √ | 'N'::bpchar | Mandatory Charge or Product | |
i_gljournal | iscreatenewbatch | bpchar | 1 | √ | 'N'::bpchar | If selected a new batch is created | |
i_gljournal | iscreatenewjournal | bpchar | 1 | √ | 'N'::bpchar | If selected a new journal within the batch is created | |
i_bpartner | iscustomer | bpchar | 1 | √ | NULL::bpchar | Indicates if this Business Partner is a Customer | |
c_paymentterm | isdefault | bpchar | 1 | √ | 'N'::bpchar | Default value | |
c_region | isdefault | bpchar | 1 | √ | 'N'::bpchar | Default value | |
i_payment | isdelayedcapture | bpchar | 1 | √ | 'N'::bpchar | Charge after Shipment | |
i_asset | isdepreciated | bpchar | 1 | √ | null | The asset will be depreciated | |
i_fajournal | isdepreciated | varchar | 1 | √ | null | The asset will be depreciated | |
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
i_asset | isdisposed | bpchar | 1 | √ | null | The asset is disposed | |
c_bpartner_location | isdn | varchar | 40 | √ | null | ISDN or modem line | |
c_elementvalue | isdoccontrolled | bpchar | 1 | √ | 'N'::bpchar | Control account - If an account is controlled by a document, you cannot post manually to it | |
i_elementvalue | isdoccontrolled | bpchar | 1 | √ | 'N'::bpchar | Control account - If an account is controlled by a document, you cannot post manually to it | |
i_bpartner | isemployee | bpchar | 1 | √ | NULL::bpchar | Indicates if this Business Partner is an employee | |
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_elementvalue | isforeigncurrency | bpchar | 1 | √ | 'N'::bpchar | Balances in foreign currency accounts are held in the nominated currency | |
i_asset | isfullydepreciated | bpchar | 1 | √ | null | The asset is fully depreciated | |
ad_column | ishtml | bpchar | 1 | √ | 'N'::bpchar | Text has HTML tags | |
i_asset | isinposession | bpchar | 1 | √ | null | The asset is in the possession of the organization | |
m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | Movement is in transit | |
exp_formatline | ismandatory | bpchar | 1 | √ | null | Data entry is required in this column | |
m_pricelist | ismandatory | bpchar | 1 | √ | 'N'::bpchar | Data entry is required in this column | |
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
ad_user | ismenuautoexpand | bpchar | 1 | √ | null | If ticked, the menu is automatically expanded | |
c_paymentterm | isnextbusinessday | bpchar | 1 | √ | 'Y'::bpchar | Payment due on the next business day | |
c_doctype | isnopricelistcheck | bpchar | 1 | √ | 'N'::bpchar | Allow Product Without Price List | |
i_bankstatement | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_conversion_rate | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_fajournal | iso_code | varchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_fixedasset | iso_code | varchar | 3 | √ | NULL::character varying | Three letter ISO 4217 Code of the Currency | |
i_gljournal | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_payment | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_pricelist | iso_code | varchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_product | iso_code | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the Currency | |
i_conversion_rate | iso_code_to | bpchar | 3 | √ | null | Three letter ISO 4217 Code of the To Currency | |
i_payment | isoverunderpayment | bpchar | 1 | √ | 'N'::bpchar | Over-Payment (unallocated) or Under-Payment (partial payment) | |
c_doctype | isoverwritedateoncomplete | bpchar | 1 | √ | 'N'::bpchar | Overwrite Date on Complete | |
c_doctype | isoverwriteseqoncomplete | bpchar | 1 | √ | 'N'::bpchar | Overwrite Sequence on Complete | |
i_asset | isowned | bpchar | 1 | √ | null | The asset is owned by the organization | |
exp_formatline | ispartuniqueindex | bpchar | 1 | √ | 'N'::bpchar | Is Part Unique Index | |
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
c_acctschema | ispostifclearingequal | bpchar | 1 | √ | 'Y'::bpchar | This flag controls if Adempiere must post when clearing (transit) and final accounts are the same | |
m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | Is Present For Product | |
i_reportline | isprinted | bpchar | 1 | √ | 'Y'::bpchar | Indicates if this document / line is printed | |
i_payment | isreceipt | bpchar | 1 | √ | 'Y'::bpchar | This is a sales transaction (receipt) | |
i_bankstatement | isreversal | bpchar | 1 | √ | 'N'::bpchar | This is a reversing transaction | |
i_payment | isselfservice | bpchar | 1 | √ | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | |
pa_reportline | isshowoppositesign | bpchar | 1 | √ | 'N'::bpchar | Display values with the opposite sign | |
i_pricelist | issopricelist | bpchar | 1 | √ | null | This is a Sales Price List | |
i_invoice | issotrx | bpchar | 1 | √ | 'Y'::bpchar | This is a Sales Transaction | |
i_order | issotrx | bpchar | 1 | √ | 'Y'::bpchar | This is a Sales Transaction | |
i_elementvalue | issummary | bpchar | 1 | √ | 'N'::bpchar | This is a summary entity | |
i_reportline | issummary | bpchar | 1 | √ | 'N'::bpchar | This is a summary entity | |
ad_column | issyncdatabase | bpchar | 1 | √ | 'N'::bpchar | Change database table definition when changing dictionary definition | |
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
i_pricelist | istaxincluded | bpchar | 1 | √ | null | Tax is included in the price | |
m_product | istoformule | bpchar | 1 | √ | null | ||
c_location | isvalid | bpchar | 1 | √ | 'N'::bpchar | Element is valid | |
i_bpartner | isvendor | bpchar | 1 | √ | NULL::bpchar | Indicates if this Business Partner is a Vendor | |
i_fajournal | journaldocumentno | varchar | 60 | √ | null | Document number of the Journal | |
i_gljournal | journaldocumentno | varchar | 30 | √ | null | Document number of the Journal | |
ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
ad_user | ldapuser | varchar | 60 | √ | null | User Name used for authorization via LDAP (directory) services | |
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | The source of this lead/opportunity | |
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | Additional information on the source of this lead/opportunity | |
ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | The status of this lead/opportunity in the sales cycle | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | Additional information on the status of this lead/opportunity | |
i_asset | lifeuseunits | numeric | 10 | √ | null | Units of use until the asset is not usable anymore | |
i_bankstatement | line | numeric | 10 | √ | null | Unique line for this document | |
i_fajournal | line | numeric | 10 | √ | null | Unique line for this document | |
i_gljournal | line | numeric | 10 | √ | null | Unique line for this document | |
m_inventoryline | line | numeric | 10 | √ | null | Unique line for this document | |
i_bankstatement | linedescription | varchar | 1000 | √ | null | Description of the Line | |
i_invoice | linedescription | varchar | 255 | √ | null | Description of the Line | |
i_order | linedescription | varchar | 255 | √ | null | Description of the Line | |
c_invoiceline | linetotalamt | numeric | 0 | √ | 0 | Total line amount incl. Tax | |
i_reportline | linetype | bpchar | 1 | √ | null | Line Type | |
c_order | link_order_id | numeric | 10 | √ | null | This field links a sales order to the purchase order that is generated from it. | |
c_orderline | link_orderline_id | numeric | 10 | √ | null | This field links a sales order line to the purchase order line that is generated from it. | |
i_asset | locationcomment | varchar | 255 | √ | null | Additional comments or remarks concerning the location | |
i_movement | locatortovalue | varchar | 40 | √ | NULL::character varying | Locator To Key | |
i_fixedasset | locatorvalue | varchar | 40 | √ | NULL::character varying | Key of the Warehouse Locator | |
i_inventory | locatorvalue | varchar | 40 | √ | null | Key of the Warehouse Locator | |
i_movement | locatorvalue | varchar | 40 | √ | NULL::character varying | Key of the Warehouse Locator | |
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
c_country | lookupclassname | varchar | 255 | √ | null | The class name of the postcode lookup plugin | |
c_country | lookupclientid | varchar | 50 | √ | null | The Client ID or Login submitted to the Lookup URL | |
c_country | lookuppassword | varchar | 50 | √ | null | The password submitted to the Lookup URL | |
c_country | lookupurl | varchar | 100 | √ | null | The URL of the web service that the plugin connects to in order to retrieve postcode data | |
i_asset | lot | varchar | 20 | √ | null | Lot number (alphanumeric) | |
i_inventory | lot | varchar | 20 | √ | null | Lot number (alphanumeric) | |
m_attributesetinstance | lot | varchar | 40 | √ | null | Lot number (alphanumeric) | |
i_product | m_attributeset_id | numeric | 10 | √ | NULL::numeric | Product Attribute Set | |
m_attributesetinstance | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
i_asset | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
m_inventoryline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_attributesetinstance | m_attributesetinstance_uu | varchar | 36 | √ | NULL::character varying | M_AttributeSetInstance_UU | |
i_inventory | m_costingline_id | numeric | 10 | √ | NULL::numeric | Unique line in an Inventory cost adjustment document | |
c_acctschema | m_costtype_id | numeric | 10 | √ | null | Type of Cost (e.g. Current, Plan, Future) | |
c_bp_group | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | Category of the Freight | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
i_inoutlineconfirm | m_inoutlineconfirm_id | numeric | 10 | √ | null | Material Shipment or Receipt Confirmation Line | |
m_inoutlineconfirm | m_inoutlineconfirm_uu | varchar | 36 | √ | NULL::character varying | M_InOutLineConfirm_UU | |
i_inventory | m_inventory_id | numeric | 10 | √ | null | Parameters for a Physical Inventory | |
m_inventory | m_inventory_uu | varchar | 36 | √ | NULL::character varying | M_Inventory_UU | |
i_inventory | m_inventoryline_id | numeric | 10 | √ | null | Unique line in an Inventory document | |
m_inoutlineconfirm | m_inventoryline_id | numeric | 10 | √ | null | Unique line in an Inventory document | |
m_inventoryline | m_inventoryline_uu | varchar | 36 | √ | NULL::character varying | M_InventoryLine_UU | |
i_asset | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
i_fixedasset | m_locator_id | numeric | 10 | √ | NULL::numeric | Warehouse Locator | |
i_inventory | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
i_movement | m_locator_id | numeric | 10 | √ | NULL::numeric | Warehouse Locator | |
m_inventoryline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_locator | m_locator_uu | varchar | 36 | √ | NULL::character varying | M_Locator_UU | |
i_movement | m_locatorto_id | numeric | 10 | √ | NULL::numeric | Location inventory is moved to | |
m_locator | m_locatortype_id | numeric | 10 | √ | NULL::numeric | Locator Type | |
m_attributesetinstance | m_lot_id | numeric | 10 | √ | null | Product Lot Definition | |
i_movement | m_movement_id | numeric | 10 | √ | NULL::numeric | Movement of Inventory | |
i_movement | m_movementline_id | numeric | 10 | √ | null | Inventory Move document Line | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | Part Type | |
m_inventory | m_perpetualinv_id | numeric | 10 | √ | null | Rules for generating physical inventory | |
c_bp_group | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
i_invoice | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
i_order | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
i_pricelist | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
m_pricelist | m_pricelist_uu | varchar | 36 | √ | NULL::character varying | M_PriceList_UU | |
c_project | m_pricelist_version_id | numeric | 10 | √ | null | Identifies a unique instance of a Price List | |
i_pricelist | m_pricelist_version_id | numeric | 10 | √ | null | Identifies a unique instance of a Price List | |
i_product | m_product_category_id | numeric | 10 | √ | null | Category of a Product | |
m_product_category | m_product_category_parent_id | numeric | 10 | √ | null | Parent Product Category | |
m_product_category | m_product_category_uu | varchar | 36 | √ | NULL::character varying | M_Product_Category_UU | |
c_invoiceline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_orderline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_validcombination | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
gl_journalline | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
i_asset | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_fajournal | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_fixedasset | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
i_gljournal | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_inventory | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_invoice | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_movement | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
i_order | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_pricelist | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
i_product | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
pa_reportsource | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_product_po | m_product_po_uu | varchar | 36 | √ | NULL::character varying | M_Product_PO_UU | |
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
c_orderline | m_promotion_id | numeric | 10 | √ | null | Promotion | |
m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | Reservation Locator (just for reporting purposes) | |
c_invoice | m_rma_id | numeric | 10 | √ | null | Return Material Authorization | |
c_invoiceline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
c_order | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
c_orderline | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
i_movement | m_shipper_id | numeric | 10 | √ | NULL::numeric | Method or manner of product delivery | |
i_order | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
m_shipper | m_shipper_uu | varchar | 36 | √ | NULL::character varying | M_Shipper_UU | |
m_shipper | m_shippercfg_id | numeric | 10 | √ | NULL::numeric | Shipper Configuration | |
m_shipper | m_shippingprocessor_id | numeric | 10 | √ | NULL::numeric | Shipping Processor | |
c_project | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
i_inventory | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
i_order | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
m_inventory | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | M_Warehouse_UU | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | Optional Warehouse to replenish from | |
ad_column | mandatorylogic | varchar | 2000 | √ | null | Mandatory Logic | |
i_product | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
m_product_po | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
c_bankstatement | matchstatement | bpchar | 1 | √ | null | Match Statement | |
c_bankstatementline | matchstatement | bpchar | 1 | √ | null | Match Statement | |
i_bankstatement | matchstatement | bpchar | 1 | √ | null | Match Statement | |
c_country | mediasize | varchar | 40 | √ | null | Java Media Size | |
c_bankstatementline | memo | varchar | 4000 | √ | null | Memo Text | |
i_bankstatement | memo | varchar | 4000 | √ | null | Memo Text | |
c_payment | micr | varchar | 20 | √ | null | Combination of routing no, account and check no | |
i_payment | micr | varchar | 20 | √ | null | Combination of routing no, account and check no | |
i_inventory | movementdate | timestamp | 29,6 | √ | null | Date a product was moved in or out of inventory | |
i_movement | movementdate | timestamp | 29,6 | √ | null | Date a product was moved in or out of inventory | |
i_movement | movementqty | numeric | 0 | √ | null | Quantity of a product moved. | |
pa_reportline | multiplier | numeric | 0 | √ | null | Type Multiplier (Credit = -1) | |
i_conversion_rate | multiplyrate | numeric | 0 | √ | null | Rate to multiple the source by to calculate the target. | |
c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
i_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
i_asset | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_bankstatement | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_bpartner | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_elementvalue | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_fixedasset | name | varchar | 120 | √ | NULL::character varying | Alphanumeric identifier of the entity | |
i_invoice | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_order | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_pricelist | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
i_product | name | varchar | 255 | √ | null | Alphanumeric identifier of the entity | |
i_reportline | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
i_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
c_paymentterm | netday | bpchar | 1 | √ | null | Day when payment is due net | |
m_inventoryline | newcostprice | numeric | 0 | √ | (0)::numeric | New current cost price after processing of M_CostDetail | |
c_project | note | varchar | 2000 | √ | null | Optional additional user defined information | |
c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
pa_reportline | oper_1_id | numeric | 10 | √ | null | First operand for calculation | |
pa_reportline | oper_2_id | numeric | 10 | √ | null | Second operand for calculation | |
c_payment | oprocessing | bpchar | 1 | √ | null | This payment can be processed online | |
i_product | order_min | numeric | 0 | √ | 0 | Minimum order quantity in UOM | |
m_product_po | order_min | numeric | 0 | √ | 0 | Minimum order quantity in UOM | |
i_product | order_pack | numeric | 0 | √ | 0 | Package order size in UOM (e.g. order set of 5 units) | |
m_product_po | order_pack | numeric | 0 | √ | 0 | Package order size in UOM (e.g. order set of 5 units) | |
c_order | ordertype | varchar | 510 | √ | null | Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition) | |
pa_reportsource | org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
i_fajournal | orgtrxvalue | varchar | 40 | √ | null | Key of the Transaction Organization | |
i_gljournal | orgtrxvalue | varchar | 40 | √ | null | Key of the Transaction Organization | |
i_movement | orgtrxvalue | varchar | 40 | √ | NULL::character varying | Key of the Transaction Organization | |
i_fajournal | orgvalue | varchar | 40 | √ | null | Key of the Organization | |
i_gljournal | orgvalue | varchar | 40 | √ | null | Key of the Organization | |
i_movement | orgvalue | varchar | 40 | √ | NULL::character varying | Key of the Organization | |
c_payment | orig_trxid | varchar | 20 | √ | null | Original Transaction ID | |
i_payment | orig_trxid | varchar | 20 | √ | null | Original Transaction ID | |
pa_reportline | overlinestroketype | varchar | 3 | √ | NULL::character varying | Overline Stroke Type | |
c_payment | overunderamt | numeric | 0 | √ | 0 | Over-Payment (unallocated) or Under-Payment (partial payment) Amount | |
i_payment | overunderamt | numeric | 0 | √ | 0 | Over-Payment (unallocated) or Under-Payment (partial payment) Amount | |
ad_column | pa_dashboardcontent_id | numeric | 10 | √ | NULL::numeric | Dashboard Content | |
i_reportline | pa_reportline_id | numeric | 10 | √ | null | Report Line | |
pa_reportline | pa_reportline_uu | varchar | 36 | √ | NULL::character varying | PA_ReportLine_UU | |
i_reportline | pa_reportlineset_id | numeric | 10 | √ | null | Report Line Set | |
pa_reportlineset | pa_reportlineset_uu | varchar | 36 | √ | NULL::character varying | PA_ReportLineSet_UU | |
i_reportline | pa_reportsource_id | numeric | 10 | √ | null | Restriction of what will be shown in Report Line | |
pa_reportsource | pa_reportsource_uu | varchar | 36 | √ | NULL::character varying | PA_ReportSource_UU | |
i_reportline | paamounttype | bpchar | 1 | √ | NULL::bpchar | PA Amount Type for reporting | |
pa_reportline | paamounttype | bpchar | 1 | √ | NULL::bpchar | PA Amount Type for reporting | |
i_reportline | paperiodtype | bpchar | 1 | √ | NULL::bpchar | PA Period Type | |
pa_reportline | paperiodtype | bpchar | 1 | √ | NULL::bpchar | PA Period Type | |
exp_processorparameter | parametervalue | varchar | 60 | √ | null | Parameter Value | |
imp_processorparameter | parametervalue | varchar | 60 | √ | null | Parameter Value | |
pa_reportline | parent_id | numeric | 10 | √ | null | Parent of Entity | |
c_tax | parent_tax_id | numeric | 10 | √ | null | Parent Tax indicates a tax that is made up of multiple taxes | |
i_elementvalue | parentelementvalue_id | numeric | 10 | √ | null | The parent (summary) account | |
i_elementvalue | parentvalue | varchar | 40 | √ | null | Key if the Parent | |
ad_column | partitioningmethod | varchar | 2 | √ | NULL::character varying | Indicates how the Table is partitioned | |
ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
i_bpartner | password | varchar | 20 | √ | null | Password of any length (case sensitive) | |
c_order | pay_bpartner_id | numeric | 10 | √ | null | Business Partner responsible for the payment | |
c_order | pay_location_id | numeric | 10 | √ | null | Location of the Business Partner responsible for the payment | |
i_payment | payamt | numeric | 0 | √ | 0 | Amount being paid | |
i_bankstatement | paymentdocumentno | varchar | 30 | √ | null | Document number of the Payment | |
c_bankaccount | paymentexportclass | varchar | 60 | √ | NULL::character varying | Payment Export Class | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
i_invoice | paymenttermvalue | varchar | 40 | √ | null | Key of the Payment Term | |
i_order | paymenttermvalue | varchar | 40 | √ | null | Key of the Payment Term | |
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) | |
ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
c_bpartner_location | phone | varchar | 40 | √ | null | Identifies a telephone number | |
i_bpartner | phone | varchar | 40 | √ | null | Identifies a telephone number | |
i_invoice | phone | varchar | 40 | √ | null | Identifies a telephone number | |
i_order | phone | varchar | 40 | √ | null | Identifies a telephone number | |
ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
c_bpartner_location | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
i_bpartner | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
ad_column | placeholder | varchar | 255 | √ | NULL::character varying | Placeholder | |
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_bp_group | po_discountschema_id | numeric | 10 | √ | null | Schema to calculate the purchase trade discount percentage | |
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_bp_group | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
c_bpartner | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
c_payment | ponum | varchar | 60 | √ | null | Purchase Order Number | |
i_payment | ponum | varchar | 60 | √ | null | Purchase Order Number | |
c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_invoice | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_order | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_project | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
exp_formatline | position | numeric | 10 | √ | null | Position | |
i_elementvalue | postactual | bpchar | 1 | √ | 'Y'::bpchar | Actual Values can be posted | |
c_location | postal | varchar | 10 | √ | null | Postal code | |
i_bpartner | postal | varchar | 10 | √ | null | Postal code | |
i_invoice | postal | varchar | 10 | √ | null | Postal code | |
i_order | postal | varchar | 10 | √ | null | Postal code | |
c_location | postal_add | varchar | 10 | √ | null | Additional ZIP or Postal code | |
i_bpartner | postal_add | varchar | 10 | √ | null | Additional ZIP or Postal code | |
i_elementvalue | postbudget | bpchar | 1 | √ | 'Y'::bpchar | Budget values can be posted | |
i_elementvalue | postencumbrance | bpchar | 1 | √ | 'Y'::bpchar | Post commitments to this account | |
i_asset | postingtype | varchar | 10 | √ | null | The type of posted amount for the transaction | |
i_fajournal | postingtype | bpchar | 1 | √ | null | The type of posted amount for the transaction | |
i_gljournal | postingtype | bpchar | 1 | √ | null | The type of posted amount for the transaction | |
i_reportline | postingtype | bpchar | 1 | √ | null | The type of posted amount for the transaction | |
pa_reportline | postingtype | bpchar | 1 | √ | null | The type of posted amount for the transaction | |
i_elementvalue | poststatistical | bpchar | 1 | √ | 'Y'::bpchar | Post statistical quantities to this account? | |
c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | Manufacturing Cost Collector | |
i_invoice | priceactual | numeric | 0 | √ | 0 | Actual Price | |
i_order | priceactual | numeric | 0 | √ | 0 | Actual Price | |
c_orderline | pricecost | numeric | 0 | √ | null | Price per Unit of Measure including all indirect costs (Freight, etc.) | |
i_product | priceeffective | timestamp | 29,6 | √ | null | Effective Date of Price | |
m_product_po | priceeffective | timestamp | 29,6 | √ | null | Effective Date of Price | |
m_product_po | pricelastinv | numeric | 0 | √ | 0 | Price of the last invoice for the product | |
m_product_po | pricelastpo | numeric | 0 | √ | 0 | Price of the last purchase order for the product | |
i_pricelist | pricelimit | numeric | 0 | √ | null | Lowest price for a product | |
i_product | pricelimit | numeric | 0 | √ | null | Lowest price for a product | |
i_pricelist | pricelist | numeric | 0 | √ | null | List Price | |
i_product | pricelist | numeric | 0 | √ | 0 | List Price | |
m_product_po | pricelist | numeric | 0 | √ | 0 | List Price | |
c_bp_group | pricematchtolerance | numeric | 0 | √ | null | PO-Invoice Match Price Tolerance in percent of the purchase price | |
i_product | pricepo | numeric | 0 | √ | 0 | Price based on a purchase order | |
m_product_po | pricepo | numeric | 0 | √ | 0 | Price based on a purchase order | |
i_pricelist | priceprecision | numeric | 0 | √ | null | Precision (number of decimals) for the Price | |
i_pricelist | pricestd | numeric | 0 | √ | null | Standard Price | |
i_product | pricestd | numeric | 0 | √ | null | Standard Price | |
gl_category | printname | varchar | 60 | √ | NULL::character varying | The label text to be printed on a document or correspondence. | |
c_bp_group | prioritybase | bpchar | 1 | √ | null | Base of Priority | |
i_movement | priorityrule | varchar | 40 | √ | NULL::character varying | Priority of a document | |
gl_journal | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_asset | processed | bpchar | 1 | √ | null | The document has been processed | |
i_bankstatement | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_bpartner | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_conversion_rate | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_elementvalue | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_fajournal | processed | bpchar | 1 | √ | null | The document has been processed | |
i_fixedasset | processed | bpchar | 1 | √ | NULL::bpchar | The document has been processed | |
i_gljournal | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_inventory | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_invoice | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_order | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_payment | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_pricelist | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_product | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
i_reportline | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
c_bankstatement | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_invoice | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_order | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
c_payment | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
gl_journal | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
m_inventory | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
ad_user | processing | bpchar | 1 | √ | null | Process Now | |
c_acctschema | processing | bpchar | 1 | √ | null | Process Now | |
c_bankstatement | processing | bpchar | 1 | √ | null | Process Now | |
c_invoice | processing | bpchar | 1 | √ | null | Process Now | |
c_order | processing | bpchar | 1 | √ | null | Process Now | |
c_payment | processing | bpchar | 1 | √ | null | Process Now | |
c_paymentterm | processing | bpchar | 1 | √ | null | Process Now | |
c_period | processing | bpchar | 1 | √ | null | Process Now | |
c_project | processing | bpchar | 1 | √ | null | Process Now | |
exp_format | processing | bpchar | 1 | √ | null | Process Now | |
gl_journal | processing | bpchar | 1 | √ | null | Process Now | |
i_asset | processing | bpchar | 1 | √ | null | Process Now | |
i_bankstatement | processing | bpchar | 1 | √ | null | Process Now | |
i_bpartner | processing | bpchar | 1 | √ | null | Process Now | |
i_conversion_rate | processing | bpchar | 1 | √ | null | Process Now | |
i_elementvalue | processing | bpchar | 1 | √ | null | Process Now | |
i_fajournal | processing | bpchar | 1 | √ | null | Process Now | |
i_fixedasset | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
i_gljournal | processing | bpchar | 1 | √ | null | Process Now | |
i_inoutlineconfirm | processing | bpchar | 1 | √ | null | Process Now | |
i_inventory | processing | bpchar | 1 | √ | null | Process Now | |
i_invoice | processing | bpchar | 1 | √ | null | Process Now | |
i_order | processing | bpchar | 1 | √ | null | Process Now | |
i_payment | processing | bpchar | 1 | √ | null | Process Now | |
i_pricelist | processing | bpchar | 1 | √ | null | Process Now | |
i_product | processing | bpchar | 1 | √ | null | Process Now | |
i_reportline | processing | bpchar | 1 | √ | null | Process Now | |
m_inventory | processing | bpchar | 1 | √ | null | Process Now | |
m_product | processing | bpchar | 1 | √ | null | Process Now | |
i_product | productcategory_value | varchar | 40 | √ | null | Product Category Key | |
i_product | producttype | bpchar | 1 | √ | 'I'::bpchar | Type of product | |
i_fajournal | productvalue | varchar | 40 | √ | null | Key of the Product | |
i_fixedasset | productvalue | varchar | 40 | √ | NULL::character varying | Key of the Product | |
i_gljournal | productvalue | varchar | 40 | √ | null | Key of the Product | |
i_invoice | productvalue | varchar | 40 | √ | null | Key of the Product | |
i_movement | productvalue | varchar | 40 | √ | NULL::character varying | Key of the Product | |
i_order | productvalue | varchar | 40 | √ | null | Key of the Product | |
i_pricelist | productvalue | varchar | 40 | √ | null | Key of the Product | |
c_project | projectcategory | bpchar | 1 | √ | 'N'::bpchar | Project Category | |
i_fajournal | projectvalue | varchar | 40 | √ | null | Key of the Project | |
i_gljournal | projectvalue | varchar | 40 | √ | null | Key of the Project | |
i_invoice | projectvalue | varchar | 40 | √ | null | Key of the Project | |
i_movement | projectvalue | varchar | 40 | √ | NULL::character varying | Key of the Project | |
c_order | promotioncode | varchar | 30 | √ | null | User entered promotion code at sales time | |
gl_journalline | qty | numeric | 0 | √ | 0 | Quantity | |
i_fajournal | qty | numeric | 0 | √ | null | Quantity | |
i_fixedasset | qty | numeric | 0 | √ | (1)::numeric | Quantity | |
i_gljournal | qty | numeric | 0 | √ | 0 | Quantity | |
s_resourceassignment | qty | numeric | 0 | √ | 0 | Quantity | |
i_inventory | qtybook | numeric | 0 | √ | 0 | Book Quantity | |
i_inventory | qtycount | numeric | 0 | √ | 0 | Counted Quantity | |
i_inventory | qtyinternaluse | numeric | 0 | √ | null | Internal Use Quantity removed from Inventory | |
m_inventoryline | qtyinternaluse | numeric | 0 | √ | null | Internal Use Quantity removed from Inventory | |
i_invoice | qtyordered | numeric | 0 | √ | 0 | Ordered Quantity | |
i_order | qtyordered | numeric | 0 | √ | 0 | Ordered Quantity | |
m_product_po | qualityrating | numeric | 0 | √ | null | Method for rating vendors | |
c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | Quotation used for generating this order | |
c_payment | r_authcode | varchar | 20 | √ | null | Authorization Code returned | |
i_payment | r_authcode | varchar | 20 | √ | null | Authorization Code returned | |
c_payment | r_authcode_dc | varchar | 20 | √ | null | Authorization Code Delayed Capture returned | |
c_payment | r_avsaddr | bpchar | 1 | √ | null | This address has been verified | |
c_payment | r_avszip | bpchar | 1 | √ | null | The Zip Code has been verified | |
c_payment | r_cvv2match | bpchar | 1 | √ | null | Credit Card Verification Code Match | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
c_payment | r_info | varchar | 2000 | √ | null | Response info | |
i_payment | r_info | varchar | 2000 | √ | null | Response info | |
i_bpartner | r_interestarea_id | numeric | 10 | √ | null | Interest Area or Topic | |
r_interestarea | r_interestarea_uu | varchar | 36 | √ | NULL::character varying | R_InterestArea_UU | |
m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
c_payment | r_pnref | varchar | 20 | √ | null | Payment reference | |
i_payment | r_pnref | varchar | 20 | √ | null | Payment reference | |
c_payment | r_pnref_dc | varchar | 20 | √ | null | Payment Reference Delayed Capture | |
c_payment | r_respmsg | varchar | 60 | √ | null | Response message | |
i_payment | r_respmsg | varchar | 60 | √ | null | Response message | |
c_payment | r_result | varchar | 20 | √ | null | Result of transmission | |
i_payment | r_result | varchar | 20 | √ | null | Result of transmission | |
c_payment | r_voidmsg | varchar | 255 | √ | NULL::character varying | Void Message | |
ad_column | rangepartitioninterval | varchar | 30 | √ | NULL::character varying | Indicates the interval used in a range partitioning | |
c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
ad_column | readonlylogic | varchar | 2000 | √ | null | Logic to determine if field is read only (applies only when field is read-write) | |
c_invoice | ref_invoice_id | numeric | 10 | √ | null | Referenced Invoice | |
c_invoiceline | ref_invoiceline_id | numeric | 10 | √ | null | Referenced Invoice Line | |
c_order | ref_order_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
c_orderline | ref_orderline_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
c_payment | ref_payment_id | numeric | 10 | √ | null | Referenced Payment | |
imp_processorlog | reference | varchar | 60 | √ | null | Reference for this record | |
c_bankstatementline | referenceno | varchar | 255 | √ | null | Your customer or vendor number at the Business Partner's site | |
c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
i_bankstatement | referenceno | varchar | 255 | √ | null | Your customer or vendor number at the Business Partner's site | |
c_country | regionname | varchar | 60 | √ | null | Name of the Region | |
c_location | regionname | varchar | 40 | √ | null | Name of the Region | |
i_bpartner | regionname | varchar | 60 | √ | null | Name of the Region | |
i_invoice | regionname | varchar | 60 | √ | null | Name of the Region | |
i_order | regionname | varchar | 60 | √ | null | Name of the Region | |
c_invoice | relatedinvoice_id | numeric | 10 | √ | NULL::numeric | Related Invoice | |
m_warehouse | replenishmentclass | varchar | 60 | √ | null | Custom class to calculate Quantity to Order | |
i_reportline | reportlinesetname | varchar | 60 | √ | null | Name of the Report Line Set | |
c_location | result | varchar | 2000 | √ | NULL::character varying | Result of the action taken | |
c_invoice | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
c_payment | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
gl_journal | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
gl_journalbatch | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
m_inventory | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
m_inventoryline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
pa_reportline | roundfactor | numeric | 10 | √ | NULL::numeric | Round Factor | |
c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment Amount | |
c_payment | routingno | varchar | 20 | √ | null | Bank Routing Number | |
i_bankstatement | routingno | varchar | 20 | √ | null | Bank Routing Number | |
i_payment | routingno | varchar | 20 | √ | null | Bank Routing Number | |
i_product | royaltyamt | numeric | 0 | √ | 0 | (Included) Amount for copyright, etc. | |
m_product_po | royaltyamt | numeric | 0 | √ | 0 | (Included) Amount for copyright, etc. | |
c_invoiceline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
c_orderline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
c_invoiceline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
c_orderline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
s_resourceassignment | s_resourceassignment_uu | varchar | 36 | √ | NULL::character varying | S_ResourceAssignment_UU | |
i_gljournal | salesregionvalue | varchar | 40 | √ | NULL::character varying | Text key of the Sales Region | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | Sales Representative or Company Agent | |
c_bpartner | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_invoice | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_order | 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 | |
i_invoice | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
i_order | 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 | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | Random data added to improve password hash effectiveness | |
i_inoutlineconfirm | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
m_inoutlineconfirm | scrappedqty | numeric | 0 | √ | null | The Quantity scrapped due to QA issues | |
ad_impformat_row | script | varchar | 2000 | √ | null | Dynamic Java Language Script to calculate result | |
ad_user | securityquestion | varchar | 1024 | √ | null | Security Question | |
ad_impformat | separatorchar | varchar | 1 | √ | NULL::character varying | Separator Character | |
ad_column | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
i_fixedasset | seqno | numeric | 10 | √ | (1)::numeric | Method of ordering records; lowest number comes first | |
i_reportline | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
ad_column | seqnopartition | numeric | 10 | √ | NULL::numeric | Indicates the order of partition keys | |
ad_column | seqnoselection | numeric | 10 | √ | NULL::numeric | Selection Column Sequence | |
i_asset | serno | varchar | 20 | √ | null | Product Serial Number | |
i_inventory | serno | varchar | 20 | √ | null | Product Serial Number | |
m_attributesetinstance | serno | varchar | 40 | √ | null | Product Serial Number | |
c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
i_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
i_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
i_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
i_movement | shippername | varchar | 40 | √ | NULL::character varying | Shipper Name | |
c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | Rate Inquiry | |
i_fajournal | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
i_gljournal | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
i_invoice | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
i_order | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
i_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | Total outstanding invoice amounts allowed | |
c_bpartner | so_creditused | numeric | 0 | √ | 0 | Current open balance | |
c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
c_campaign | startdate | timestamp | 29,6 | √ | null | First effective day (inclusive) | |
ad_impformat_row | startno | numeric | 10 | √ | null | Starting number/position | |
i_bankstatement | statementdate | timestamp | 29,6 | √ | null | Date of the statement | |
c_bankstatement | statementdifference | numeric | 0 | √ | 0 | Difference between statement ending balance and actual ending balance | |
i_bankstatement | statementlinedate | timestamp | 29,6 | √ | null | Date of the Statement Line | |
i_bankstatement | stmtamt | numeric | 0 | √ | 0 | Statement Amount | |
imp_processorlog | summary | varchar | 2000 | √ | null | Textual summary of this request | |
ad_user | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
c_payment | swiftcode | varchar | 20 | √ | NULL::character varying | Swift Code or BIC | |
i_payment | swiftcode | varchar | 20 | √ | NULL::character varying | Swift Code or BIC | |
c_payment | swipe | varchar | 80 | √ | null | Track 1 and 2 of the Credit Card | |
i_payment | swipe | varchar | 80 | √ | null | Track 1 and 2 of the Credit Card | |
c_invoiceline | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
c_payment | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
i_invoice | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
i_order | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
i_payment | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | Type of Tax Correction | |
c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
i_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
c_tax | taxindicator | varchar | 10 | √ | null | Short form for Tax to be printed on documents | |
i_invoice | taxindicator | varchar | 10 | √ | null | Short form for Tax to be printed on documents | |
i_order | taxindicator | varchar | 10 | √ | null | Short form for Tax to be printed on documents | |
c_tax | taxpostingindicator | bpchar | 1 | √ | '0'::bpchar | Type of input tax (deductible and non deductible) | |
i_payment | tendertype | bpchar | 1 | √ | null | Method of Payment | |
exp_format | testexportmodel | bpchar | 1 | √ | null | Test Export Model | |
exp_format | testimportmodel | bpchar | 1 | √ | null | Test Import Model | |
imp_processorlog | textmsg | varchar | 2000 | √ | null | Text Message | |
ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
i_bpartner | title | varchar | 40 | √ | null | Name this entity is referred to as | |
c_tax | to_country_id | numeric | 10 | √ | null | Receiving Country | |
c_tax | to_region_id | numeric | 10 | √ | null | Receiving Region | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
i_bankstatement | trxamt | numeric | 0 | √ | 0 | Amount of a transaction | |
i_bankstatement | trxtype | varchar | 20 | √ | null | Type of credit card transaction | |
i_payment | trxtype | bpchar | 1 | √ | null | Type of credit card transaction | |
pa_reportline | underlinestroketype | varchar | 3 | √ | NULL::character varying | Underline Stroke Type | |
i_product | unitsperpallet | numeric | 10 | √ | null | Units Per Pallet | |
m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
c_uom | uomsymbol | varchar | 10 | √ | null | Symbol for a Unit of Measure | |
i_fixedasset | uomsymbol | varchar | 10 | √ | NULL::character varying | Symbol for a Unit of Measure | |
c_uom | uomtype | varchar | 2 | √ | NULL::character varying | UOM Type | |
i_fajournal | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_gljournal | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_inventory | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_invoice | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_order | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product_po | upc | varchar | 20 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
i_bankstatement | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_bpartner | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_conversion_rate | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_elementvalue | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_fajournal | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_gljournal | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_inventory | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_invoice | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_order | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_payment | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_pricelist | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_product | updatedby | numeric | 10 | √ | null | User who updated this records | |
i_reportline | updatedby | numeric | 10 | √ | null | User who updated this records | |
m_inventory | updateqty | bpchar | 1 | √ | 'N'::bpchar | Update Quantities | |
c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
i_asset | uselifemonths | numeric | 10 | √ | null | Months of the usable life of the asset | |
i_fixedasset | uselifemonths | numeric | 10 | √ | null | Months of the usable life of the asset | |
i_fixedasset | uselifemonths_f | numeric | 10 | √ | null | Use Life - Months (fiscal) | |
i_asset | uselifeyears | numeric | 0 | √ | null | Years of the usable life of the asset | |
c_invoice | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoiceline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_order | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_orderline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_payment | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_validcombination | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
gl_journalline | user1_id | numeric | 10 | √ | NULL::numeric | User defined list element #1 | |
i_fajournal | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
i_gljournal | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
i_movement | user1_id | varchar | 10 | √ | NULL::character varying | User defined list element #1 | |
m_inventory | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoice | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_invoiceline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_order | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_orderline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_payment | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_validcombination | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
gl_journalline | user2_id | numeric | 10 | √ | NULL::numeric | User defined list element #2 | |
i_fajournal | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
i_gljournal | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
i_movement | user2_id | varchar | 10 | √ | NULL::character varying | User defined list element #2 | |
m_inventory | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_validcombination | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
i_fajournal | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
pa_reportsource | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
c_validcombination | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
i_fajournal | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
pa_reportsource | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
ad_user | userpin | varchar | 20 | √ | null | User PIN | |
i_asset | useunits | numeric | 10 | √ | null | Currently used units of the assets | |
c_location | validateaddress | bpchar | 1 | √ | NULL::bpchar | Validate Address | |
c_elementvalue | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
i_conversion_rate | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
i_pricelist | validfrom | timestamp | 29,6 | √ | null | 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) | |
i_conversion_rate | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
ad_user | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
i_asset | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
i_bpartner | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
i_elementvalue | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
i_inventory | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
i_product | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
ad_column | valuemax | varchar | 20 | √ | null | Maximum Value for a field | |
ad_column | valuemin | varchar | 20 | √ | null | Minimum Value for a field | |
i_bankstatement | valutadate | timestamp | 29,6 | √ | null | Date when money is available | |
i_product | vendorcategory | varchar | 30 | √ | null | Product Category of the Business Partner | |
m_product_po | vendorcategory | varchar | 30 | √ | null | Product Category of the Business Partner | |
i_product | vendorproductno | varchar | 40 | √ | null | Product Key of the Business Partner | |
i_asset | versionno | varchar | 20 | √ | null | Version Number | |
m_product | versionno | varchar | 20 | √ | null | Version Number | |
ad_column | vformat | varchar | 255 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
c_element | vformat | varchar | 40 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
c_payment | voiceauthcode | varchar | 20 | √ | null | Voice Authorization Code from credit card company | |
i_payment | voiceauthcode | varchar | 20 | √ | null | Voice Authorization Code from credit card company | |
c_order | volume | numeric | 0 | √ | null | Volume of a product | |
i_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
i_inventory | warehousevalue | varchar | 40 | √ | null | Key of the Warehouse | |
c_order | weight | numeric | 0 | √ | null | Weight of a product | |
i_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
exp_format | whereclause | varchar | 255 | √ | null | Fully qualified SQL WHERE clause | |
c_payment | writeoffamt | numeric | 0 | √ | 0 | Amount to write-off | |
i_payment | writeoffamt | numeric | 0 | √ | 0 | Amount to write-off | |
i_inventory | x | varchar | 60 | √ | null | X dimension, e.g., Aisle | |
m_locator | x | varchar | 60 | √ | null | X dimension, e.g., Aisle | |
i_pricelist | x12de355 | varchar | 4 | √ | null | UOM EDI X12 Code | |
i_product | x12de355 | varchar | 4 | √ | null | UOM EDI X12 Code | |
i_inventory | y | varchar | 60 | √ | null | Y dimension, e.g., Bin | |
m_locator | y | varchar | 60 | √ | null | Y dimension, e.g., Bin | |
i_inventory | z | varchar | 60 | √ | null | Z dimension, e.g., Level | |
m_locator | z | varchar | 60 | √ | null | Z dimension, e.g., Level | |
i_fixedasset | a_asset_cost | numeric | 0 | (0)::numeric | Asset Cost | ||
i_fixedasset | a_remaining_period | numeric | 10 | (0)::numeric | Remaining Period | ||
c_validcombination | account_id | numeric | 10 | Account used | |||
c_bankaccount | accountno | varchar | 20 | Account Number | |||
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 | |||
ad_column | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_impformat | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_impformat_row | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_importtemplate | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_org | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_acctschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_activity | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bankaccount | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bankstatement | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bankstatementline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bp_group | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_campaign | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_charge | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_conversion_rate | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_conversiontype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_country | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_currency | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_doctype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_element | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_elementvalue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_greeting | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoice | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoiceline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoicetax | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_order | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_orderline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_ordertax | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payment | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_paymentterm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_period | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_project | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_region | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_salesregion | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_tax | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_uom | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_validcombination | ad_client_id | numeric | 10 | Tenant for this installation. | |||
exp_format | ad_client_id | numeric | 10 | Tenant for this installation. | |||
exp_formatline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
exp_processor_type | ad_client_id | numeric | 10 | Tenant for this installation. | |||
exp_processorparameter | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_budget | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_category | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_journal | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_journalbatch | ad_client_id | numeric | 10 | Tenant for this installation. | |||
gl_journalline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
i_asset | ad_client_id | numeric | 10 | Tenant for this installation. | |||
i_fixedasset | ad_client_id | numeric | 10 | Tenant for this installation. | |||
i_inoutlineconfirm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
i_movement | ad_client_id | numeric | 10 | Tenant for this installation. | |||
imp_processor_type | ad_client_id | numeric | 10 | Tenant for this installation. | |||
imp_processorlog | ad_client_id | numeric | 10 | Tenant for this installation. | |||
imp_processorparameter | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_attributesetinstance | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inoutlineconfirm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inventory | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inventoryline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_locator | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_pricelist | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_category | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_po | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_shipper | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_warehouse | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_reportline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_reportlineset | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_reportsource | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_interestarea | ad_client_id | numeric | 10 | Tenant for this installation. | |||
s_resourceassignment | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_column | ad_column_id | numeric | 10 | Column in the table | |||
ad_impformat_row | ad_column_id | numeric | 10 | Column in the table | |||
ad_impformat | ad_impformat_id | numeric | 10 | Import Format | |||
ad_impformat_row | ad_impformat_id | numeric | 10 | Import Format | |||
ad_impformat_row | ad_impformat_row_id | numeric | 10 | Format Field | |||
ad_importtemplate | ad_importtemplate_id | numeric | 10 | Import Template | |||
ad_column | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_impformat | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_impformat_row | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_importtemplate | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_org | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_acctschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_activity | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bankaccount | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bankstatement | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bankstatementline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bp_group | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_campaign | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_charge | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_conversion_rate | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_conversiontype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_country | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_currency | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_doctype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_element | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_elementvalue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_greeting | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoice | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoiceline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoicetax | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_order | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_orderline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_ordertax | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payment | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_paymentterm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_period | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_project | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_region | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_salesregion | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_tax | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_uom | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_validcombination | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
exp_format | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
exp_formatline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
exp_processor_type | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
exp_processorparameter | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_budget | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_category | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_journal | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_journalbatch | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
gl_journalline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
i_asset | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
i_fixedasset | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
i_inoutlineconfirm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
i_movement | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
imp_processor_type | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
imp_processorlog | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
imp_processorparameter | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_attributesetinstance | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inoutlineconfirm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inventory | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inventoryline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_locator | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_pricelist | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_category | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_po | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_shipper | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_warehouse | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
pa_reportline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
pa_reportlineset | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
pa_reportsource | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_interestarea | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
s_resourceassignment | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_column | ad_reference_id | numeric | 10 | System Reference and Validation | |||
ad_importtemplate | ad_tab_id | numeric | 10 | NULL::numeric | Tab within a Window | ||
ad_column | ad_table_id | numeric | 10 | Database Table information | |||
ad_impformat | ad_table_id | numeric | 10 | Database Table information | |||
exp_format | ad_table_id | numeric | 10 | Database Table information | |||
ad_user | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_importtemplate | ad_window_id | numeric | 10 | NULL::numeric | Data entry or display window | ||
c_paymentterm | afterdelivery | bpchar | 1 | 'N'::bpchar | Due after delivery rather than after invoicing | ||
gl_journalline | amtacctcr | numeric | 0 | 0 | Accounted Credit Amount | ||
gl_journalline | amtacctdr | numeric | 0 | 0 | Accounted Debit Amount | ||
gl_journalline | amtsourcecr | numeric | 0 | 0 | Source Credit Amount | ||
gl_journalline | amtsourcedr | numeric | 0 | 0 | Source Debit Amount | ||
i_fixedasset | assetamtentered | numeric | 0 | '0'::numeric | Entered Amount | ||
i_fixedasset | assetperioddepreciationamt | numeric | 0 | (0)::numeric | Applies to Straight Line depreciation | ||
i_fixedasset | assetsourceamt | numeric | 0 | '0'::numeric | Source Amount | ||
s_resourceassignment | assigndatefrom | timestamp | 29,6 | Assign resource from | |||
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_acctschema | c_acctschema_id | numeric | 10 | Rules for accounting | |||
c_validcombination | c_acctschema_id | numeric | 10 | Rules for accounting | |||
gl_journal | c_acctschema_id | numeric | 10 | Rules for accounting | |||
c_activity | c_activity_id | numeric | 10 | Business Activity | |||
c_bankaccount | c_bank_id | numeric | 10 | Bank | |||
c_bankaccount | c_bankaccount_id | numeric | 10 | Account at the Bank | |||
c_bankstatement | c_bankaccount_id | numeric | 10 | Account at the Bank | |||
c_bankstatement | c_bankstatement_id | numeric | 10 | Bank Statement of account | |||
c_bankstatementline | c_bankstatement_id | numeric | 10 | Bank Statement of account | |||
c_bankstatementline | c_bankstatementline_id | numeric | 10 | Line on a statement from this Bank | |||
c_bp_group | c_bp_group_id | numeric | 10 | Business Partner Group | |||
c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_bpartner_location | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_invoice | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_order | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
m_product_po | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_bpartner_location | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_invoice | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_order | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_campaign | c_campaign_id | numeric | 10 | Marketing Campaign | |||
c_charge | c_charge_id | numeric | 10 | Additional document charges | |||
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_conversiontype | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
gl_journal | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
gl_journalline | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
c_country | c_country_id | numeric | 10 | Country | |||
c_location | c_country_id | numeric | 10 | Country | |||
c_region | c_country_id | numeric | 10 | Country | |||
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_bankstatementline | c_currency_id | numeric | 10 | The Currency for this record | |||
c_conversion_rate | c_currency_id | numeric | 10 | The Currency for this record | |||
c_currency | c_currency_id | numeric | 10 | The Currency for this record | |||
c_invoice | c_currency_id | numeric | 10 | The Currency for this record | |||
c_order | c_currency_id | numeric | 10 | The Currency for this record | |||
c_orderline | c_currency_id | numeric | 10 | The Currency for this record | |||
c_payment | c_currency_id | numeric | 10 | The Currency for this record | |||
c_project | c_currency_id | numeric | 10 | The Currency for this record | |||
gl_journalline | c_currency_id | numeric | 10 | The Currency for this record | |||
m_pricelist | c_currency_id | numeric | 10 | The Currency for this record | |||
c_conversion_rate | c_currency_id_to | numeric | 10 | Target currency | |||
c_bankstatement | c_doctype_id | numeric | 10 | NULL::numeric | Document type or rules | ||
c_doctype | c_doctype_id | numeric | 10 | Document type or rules | |||
c_invoice | c_doctype_id | numeric | 10 | Document type or rules | |||
c_order | c_doctype_id | numeric | 10 | Document type or rules | |||
c_payment | c_doctype_id | numeric | 10 | Document type or rules | |||
gl_journal | c_doctype_id | numeric | 10 | Document type or rules | |||
gl_journalbatch | c_doctype_id | numeric | 10 | Document type or rules | |||
m_inventory | c_doctype_id | numeric | 10 | Document type or rules | |||
c_invoice | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
c_order | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
c_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_greeting | c_greeting_id | numeric | 10 | Greeting to print on correspondence | |||
c_invoice | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoiceline | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoicetax | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoiceline | c_invoiceline_id | numeric | 10 | Invoice Detail Line | |||
c_location | c_location_id | numeric | 10 | Location or Address | |||
m_warehouse | c_location_id | numeric | 10 | Location or Address | |||
c_order | c_order_id | numeric | 10 | Order | |||
c_orderline | c_order_id | numeric | 10 | Order | |||
c_ordertax | c_order_id | numeric | 10 | Order | |||
c_orderline | c_orderline_id | numeric | 10 | Sales Order Line | |||
c_payment | c_payment_id | numeric | 10 | Payment identifier | |||
c_invoice | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
c_order | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
c_paymentterm | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
c_period | c_period_id | numeric | 10 | Period of the Calendar | |||
gl_journal | c_period_id | numeric | 10 | Period of the Calendar | |||
c_project | c_project_id | numeric | 10 | Financial Project | |||
c_region | c_region_id | numeric | 10 | Identifies a geographical Region | |||
c_salesregion | c_salesregion_id | numeric | 10 | Sales coverage region | |||
c_invoicetax | c_tax_id | numeric | 10 | Tax identifier | |||
c_orderline | c_tax_id | numeric | 10 | Tax identifier | |||
c_ordertax | c_tax_id | numeric | 10 | Tax identifier | |||
c_tax | c_tax_id | numeric | 10 | Tax identifier | |||
c_tax | c_taxcategory_id | numeric | 10 | Tax Category | |||
m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
c_orderline | c_uom_id | numeric | 10 | Unit of Measure | |||
c_uom | c_uom_id | numeric | 10 | Unit of Measure | |||
m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
c_validcombination | c_validcombination_id | numeric | 10 | Valid Account Combination | |||
c_period | c_year_id | numeric | 10 | Calendar Year | |||
gl_category | categorytype | bpchar | 1 | Source of the Journal with this category | |||
ad_importtemplate | characterset | varchar | 20 | NULL::character varying | Character Set | ||
c_bankstatementline | chargeamt | numeric | 0 | 0 | Charge Amount | ||
c_charge | chargeamt | numeric | 0 | 0 | Charge Amount | ||
ad_column | columnname | varchar | 30 | Name of the column in the database | |||
c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | Create Commitment and/or Reservations for Budget Control | ||
c_project | committedamt | numeric | 0 | 0 | The (legal) commitment amount | ||
c_project | committedqty | numeric | 0 | 0 | The (legal) commitment Quantity | ||
m_inoutlineconfirm | confirmedqty | numeric | 0 | 0 | Confirmation of a received quantity | ||
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_currency | costingprecision | numeric | 10 | Rounding used costing calculations | |||
c_uom | costingprecision | numeric | 10 | Rounding used costing calculations | |||
c_campaign | costs | numeric | 0 | 0 | Costs in accounting currency | ||
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 | |||
ad_column | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_impformat | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_impformat_row | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_importtemplate | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_org | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
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_bankaccount | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bankstatement | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bankstatementline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bp_group | 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_campaign | created | timestamp | 29,6 | now() | Date this record was created | ||
c_charge | created | timestamp | 29,6 | now() | Date this record was created | ||
c_conversion_rate | created | timestamp | 29,6 | now() | Date this record was created | ||
c_conversiontype | created | timestamp | 29,6 | now() | Date this record was created | ||
c_country | created | timestamp | 29,6 | now() | 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_element | created | timestamp | 29,6 | now() | Date this record was created | ||
c_elementvalue | created | timestamp | 29,6 | now() | Date this record was created | ||
c_greeting | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoice | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoiceline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoicetax | created | timestamp | 29,6 | now() | Date this record was created | ||
c_location | created | timestamp | 29,6 | now() | Date this record was created | ||
c_order | created | timestamp | 29,6 | now() | Date this record was created | ||
c_orderline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_ordertax | created | timestamp | 29,6 | now() | Date this record was created | ||
c_payment | 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_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_uom | created | timestamp | 29,6 | now() | Date this record was created | ||
c_validcombination | created | timestamp | 29,6 | now() | Date this record was created | ||
exp_format | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
exp_formatline | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
exp_processor_type | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
exp_processorparameter | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
gl_budget | created | timestamp | 29,6 | now() | Date this record was created | ||
gl_category | created | timestamp | 29,6 | now() | Date this record was created | ||
gl_journal | created | timestamp | 29,6 | now() | Date this record was created | ||
gl_journalbatch | created | timestamp | 29,6 | now() | Date this record was created | ||
gl_journalline | created | timestamp | 29,6 | now() | Date this record was created | ||
i_asset | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_bankstatement | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_bpartner | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_conversion_rate | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_elementvalue | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_fajournal | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_fixedasset | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_gljournal | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_inoutlineconfirm | created | timestamp | 29,6 | now() | Date this record was created | ||
i_inventory | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_invoice | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_movement | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_order | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_payment | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_pricelist | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_product | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
i_reportline | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
imp_processor_type | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
imp_processorlog | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
imp_processorparameter | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
m_attributesetinstance | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inoutlineconfirm | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inventory | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inventoryline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_locator | created | timestamp | 29,6 | now() | Date this record was created | ||
m_pricelist | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product_category | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product_po | created | timestamp | 29,6 | now() | Date this record was created | ||
m_shipper | created | timestamp | 29,6 | now() | Date this record was created | ||
m_warehouse | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_reportline | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_reportlineset | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_reportsource | created | timestamp | 29,6 | now() | Date this record was created | ||
r_interestarea | created | timestamp | 29,6 | now() | Date this record was created | ||
s_resourceassignment | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_column | createdby | numeric | 10 | User who created this records | |||
ad_impformat | createdby | numeric | 10 | User who created this records | |||
ad_impformat_row | createdby | numeric | 10 | User who created this records | |||
ad_importtemplate | createdby | numeric | 10 | User who created this records | |||
ad_org | createdby | numeric | 10 | User who created this records | |||
ad_user | createdby | numeric | 10 | User who created this records | |||
c_acctschema | createdby | numeric | 10 | User who created this records | |||
c_activity | createdby | numeric | 10 | User who created this records | |||
c_bankaccount | createdby | numeric | 10 | User who created this records | |||
c_bankstatement | createdby | numeric | 10 | User who created this records | |||
c_bankstatementline | createdby | numeric | 10 | User who created this records | |||
c_bp_group | 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_campaign | createdby | numeric | 10 | User who created this records | |||
c_charge | createdby | numeric | 10 | User who created this records | |||
c_conversion_rate | createdby | numeric | 10 | User who created this records | |||
c_conversiontype | createdby | numeric | 10 | User who created this records | |||
c_country | 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_element | createdby | numeric | 10 | User who created this records | |||
c_elementvalue | createdby | numeric | 10 | User who created this records | |||
c_greeting | createdby | numeric | 10 | User who created this records | |||
c_invoice | createdby | numeric | 10 | User who created this records | |||
c_invoiceline | createdby | numeric | 10 | User who created this records | |||
c_invoicetax | createdby | numeric | 10 | User who created this records | |||
c_location | createdby | numeric | 10 | User who created this records | |||
c_order | createdby | numeric | 10 | User who created this records | |||
c_orderline | createdby | numeric | 10 | User who created this records | |||
c_ordertax | createdby | numeric | 10 | User who created this records | |||
c_payment | 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_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_uom | createdby | numeric | 10 | User who created this records | |||
c_validcombination | createdby | numeric | 10 | User who created this records | |||
exp_format | createdby | numeric | 10 | User who created this records | |||
exp_formatline | createdby | numeric | 10 | User who created this records | |||
exp_processor_type | createdby | numeric | 10 | User who created this records | |||
exp_processorparameter | createdby | numeric | 10 | User who created this records | |||
gl_budget | createdby | numeric | 10 | User who created this records | |||
gl_category | createdby | numeric | 10 | User who created this records | |||
gl_journal | createdby | numeric | 10 | User who created this records | |||
gl_journalbatch | createdby | numeric | 10 | User who created this records | |||
gl_journalline | createdby | numeric | 10 | User who created this records | |||
i_fixedasset | createdby | numeric | 10 | User who created this records | |||
i_inoutlineconfirm | createdby | numeric | 10 | User who created this records | |||
i_movement | createdby | numeric | 10 | User who created this records | |||
imp_processor_type | createdby | numeric | 10 | User who created this records | |||
imp_processorlog | createdby | numeric | 10 | User who created this records | |||
imp_processorparameter | createdby | numeric | 10 | User who created this records | |||
m_attributesetinstance | createdby | numeric | 10 | User who created this records | |||
m_inoutlineconfirm | createdby | numeric | 10 | User who created this records | |||
m_inventory | createdby | numeric | 10 | User who created this records | |||
m_inventoryline | createdby | numeric | 10 | User who created this records | |||
m_locator | createdby | numeric | 10 | User who created this records | |||
m_pricelist | createdby | numeric | 10 | User who created this records | |||
m_product | createdby | numeric | 10 | User who created this records | |||
m_product_category | createdby | numeric | 10 | User who created this records | |||
m_product_po | createdby | numeric | 10 | User who created this records | |||
m_shipper | createdby | numeric | 10 | User who created this records | |||
m_warehouse | createdby | numeric | 10 | User who created this records | |||
pa_reportline | createdby | numeric | 10 | User who created this records | |||
pa_reportlineset | createdby | numeric | 10 | User who created this records | |||
pa_reportsource | createdby | numeric | 10 | User who created this records | |||
r_interestarea | createdby | numeric | 10 | User who created this records | |||
s_resourceassignment | createdby | numeric | 10 | User who created this records | |||
c_bankaccount | creditlimit | numeric | 0 | 0 | Amount of Credit allowed | ||
ad_importtemplate | csvheader | varchar | 2000 | NULL::character varying | CSV Header | ||
gl_journal | currencyrate | numeric | 0 | 0 | Currency Conversion Rate | ||
gl_journalline | currencyrate | numeric | 0 | 0 | Currency Conversion Rate | ||
c_bankaccount | currentbalance | numeric | 0 | 0 | Current Balance | ||
ad_impformat_row | datatype | bpchar | 1 | Type of data | |||
c_bankstatement | dateacct | timestamp | 29,6 | Accounting Date | |||
c_bankstatementline | dateacct | timestamp | 29,6 | Accounting Date | |||
c_invoice | dateacct | timestamp | 29,6 | Accounting Date | |||
c_order | dateacct | timestamp | 29,6 | Accounting Date | |||
c_payment | dateacct | timestamp | 29,6 | Accounting Date | |||
gl_journal | dateacct | timestamp | 29,6 | Accounting Date | |||
gl_journalline | dateacct | timestamp | 29,6 | Accounting Date | |||
gl_journal | datedoc | timestamp | 29,6 | Date of the Document | |||
c_invoice | dateinvoiced | timestamp | 29,6 | Date printed on Invoice | |||
c_order | dateordered | timestamp | 29,6 | Date of Order | |||
c_orderline | dateordered | timestamp | 29,6 | Date of Order | |||
c_payment | datetrx | timestamp | 29,6 | Transaction Date | |||
ad_impformat_row | decimalpoint | bpchar | 1 | Decimal Point in the data file - if any | |||
c_order | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
c_order | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
c_currency | description | varchar | 255 | Optional short description of the record | |||
gl_journal | description | varchar | 255 | Optional short description of the record | |||
gl_journalbatch | description | varchar | 255 | Optional short description of the record | |||
c_paymentterm | discount | numeric | 0 | Discount in percent | |||
c_paymentterm | discount2 | numeric | 0 | Discount in percent | |||
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_country | displaysequence | varchar | 20 | Format for printing this Address | |||
ad_impformat_row | divideby100 | bpchar | 1 | 'N'::bpchar | Divide number by 100 to get correct amount | ||
c_conversion_rate | dividerate | numeric | 0 | 0 | To convert Source number to Target number, the Source is divided | ||
c_bankstatement | docaction | bpchar | 2 | The targeted status of the document | |||
c_invoice | docaction | bpchar | 2 | The targeted status of the document | |||
c_order | docaction | bpchar | 2 | The targeted status of the document | |||
c_payment | docaction | bpchar | 2 | The targeted status of the document | |||
gl_journal | docaction | bpchar | 2 | The targeted status of the document | |||
gl_journalbatch | docaction | bpchar | 2 | The targeted status of the document | |||
i_fixedasset | docaction | varchar | 2 | 'CO'::character varying | The targeted status of the document | ||
m_inventory | docaction | bpchar | 2 | The targeted status of the document | |||
c_doctype | docbasetype | bpchar | 3 | Logical type of document | |||
c_bankstatement | docstatus | bpchar | 2 | The current status of the document | |||
c_invoice | docstatus | bpchar | 2 | The current status of the document | |||
c_order | docstatus | bpchar | 2 | The current status of the document | |||
c_payment | docstatus | bpchar | 2 | The current status of the document | |||
gl_journal | docstatus | bpchar | 2 | The current status of the document | |||
gl_journalbatch | docstatus | bpchar | 2 | The current status of the document | |||
m_inventory | docstatus | bpchar | 2 | The current status of the document | |||
c_doctype | documentcopies | numeric | 10 | Number of copies to be printed | |||
c_bankstatement | documentno | varchar | 60 | NULL::character varying | Document sequence number of the document | ||
c_invoice | documentno | varchar | 30 | Document sequence number of the document | |||
c_order | documentno | varchar | 30 | Document sequence number of the document | |||
c_payment | documentno | varchar | 30 | Document sequence number of the document | |||
gl_journal | documentno | varchar | 30 | Document sequence number of the document | |||
gl_journalbatch | documentno | varchar | 30 | Document sequence number of the document | |||
m_inventory | documentno | varchar | 30 | Document sequence number of the document | |||
c_element | elementtype | bpchar | 1 | Element Type (account or user defined) | |||
pa_reportsource | elementtype | bpchar | 2 | Element Type (account or user defined) | |||
c_bankstatement | endingbalance | numeric | 0 | 0 | Ending or closing balance | ||
m_pricelist | enforcepricelimit | bpchar | 1 | 'N'::bpchar | Do not allow prices below the limit price | ||
ad_column | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
exp_format | exp_format_id | numeric | 10 | Export Format | |||
exp_formatline | exp_formatline_id | numeric | 10 | Format Line | |||
exp_processorparameter | exp_processor_id | numeric | 10 | Export Processor | |||
exp_processor_type | exp_processor_type_id | numeric | 10 | Export Processor Type | |||
exp_processorparameter | exp_processorparameter_id | numeric | 10 | Processor Parameter | |||
ad_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
ad_impformat | formattype | bpchar | 1 | Format of the data | |||
c_orderline | freightamt | numeric | 0 | 0 | Freight Amount | ||
c_order | freightcostrule | bpchar | 1 | Method for charging Freight | |||
c_acctschema | gaap | bpchar | 2 | Generally Accepted Accounting Principles | |||
gl_budget | gl_budget_id | numeric | 10 | General Ledger Budget | |||
c_doctype | gl_category_id | numeric | 10 | General Ledger Category | |||
gl_category | gl_category_id | numeric | 10 | General Ledger Category | |||
gl_journal | gl_category_id | numeric | 10 | General Ledger Category | |||
gl_journal | gl_journal_id | numeric | 10 | General Ledger Journal | |||
gl_journalline | gl_journal_id | numeric | 10 | General Ledger Journal | |||
gl_journalbatch | gl_journalbatch_id | numeric | 10 | General Ledger Journal Batch | |||
gl_journalline | gl_journalline_id | numeric | 10 | General Ledger Journal Line | |||
c_paymentterm | gracedays | numeric | 10 | Days after due date to send first dunning letter | |||
c_invoice | grandtotal | numeric | 0 | 0 | Total amount of document | ||
c_order | grandtotal | numeric | 0 | 0 | Total amount of document | ||
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_country | hasregion | bpchar | 1 | 'N'::bpchar | Country contains Regions | ||
i_asset | i_asset_id | numeric | 10 | Asset | |||
i_bankstatement | i_bankstatement_id | numeric | 10 | Import of the Bank Statement | |||
i_bpartner | i_bpartner_id | numeric | 10 | Import Business Partner | |||
i_conversion_rate | i_conversion_rate_id | numeric | 10 | Import Currency Conversion Rate | |||
i_elementvalue | i_elementvalue_id | numeric | 10 | Import Account Value | |||
i_fajournal | i_fajournal_id | numeric | 10 | FA Journal | |||
i_fixedasset | i_fixedasset_id | numeric | 10 | NULL::numeric | Imported Fixed Asset | ||
i_gljournal | i_gljournal_id | numeric | 10 | Import General Ledger Journal | |||
i_inoutlineconfirm | i_inoutlineconfirm_id | numeric | 10 | Material Shipment or Receipt Confirmation Import Line | |||
i_inventory | i_inventory_id | numeric | 10 | Import Inventory Transactions | |||
i_invoice | i_invoice_id | numeric | 10 | Import Invoice | |||
i_bankstatement | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_bpartner | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_elementvalue | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_fajournal | i_isimported | bpchar | 1 | Has this import been processed | |||
i_fixedasset | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_gljournal | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_inoutlineconfirm | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_inventory | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_invoice | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_movement | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_order | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_payment | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_pricelist | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_product | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_reportline | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_movement | i_movement_id | numeric | 10 | I_Movement_ID | |||
i_order | i_order_id | numeric | 10 | Import Orders | |||
i_payment | i_payment_id | numeric | 10 | Import Payment | |||
i_pricelist | i_pricelist_id | numeric | 10 | Import Price List | |||
i_product | i_product_id | numeric | 10 | Import Item or Service | |||
i_reportline | i_reportline_id | numeric | 10 | Import Report Line Set values | |||
imp_processorlog | imp_processor_id | numeric | 10 | Import Processor | |||
imp_processorparameter | imp_processor_id | numeric | 10 | Import Processor | |||
imp_processor_type | imp_processor_type_id | numeric | 10 | Import Processor Type | |||
imp_processorlog | imp_processorlog_id | numeric | 10 | Import Processor Log | |||
imp_processorparameter | imp_processorparameter_id | numeric | 10 | Import Processor Parameter | |||
c_bankstatementline | interestamt | numeric | 0 | 0 | Interest Amount | ||
m_inventoryline | inventorytype | bpchar | 1 | 'D'::bpchar | Type of inventory difference | ||
c_project | invoicedamt | numeric | 0 | 0 | The amount invoiced | ||
c_project | invoicedqty | numeric | 0 | 0 | The quantity invoiced | ||
c_order | invoicerule | bpchar | 1 | 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 | ||
ad_column | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_impformat | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_impformat_row | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_importtemplate | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_org | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user | 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_activity | 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_bankstatement | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_bankstatementline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_bp_group | 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_campaign | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_charge | 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_conversiontype | 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_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_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_greeting | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoice | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoiceline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoicetax | 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_order | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_orderline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_ordertax | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_payment | 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_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_uom | 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 | ||
exp_format | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
exp_formatline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
exp_processor_type | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
exp_processorparameter | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_budget | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_category | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_journal | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_journalbatch | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
gl_journalline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
i_fajournal | isactive | bpchar | 1 | The record is active in the system | |||
i_fixedasset | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
i_inoutlineconfirm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
i_movement | isactive | bpchar | 1 | The record is active in the system | |||
imp_processor_type | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
imp_processorlog | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
imp_processorparameter | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_attributesetinstance | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inoutlineconfirm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inventory | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inventoryline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_locator | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_pricelist | 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_category | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product_po | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_shipper | 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 | ||
pa_reportline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
pa_reportlineset | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
pa_reportsource | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
r_interestarea | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
s_resourceassignment | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | The selected mail template will be automatically inserted when creating an email | ||
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_payment | isallocated | bpchar | 1 | 'N'::bpchar | Indicates if the payment has been allocated | ||
ad_column | isallowcopy | bpchar | 1 | 'Y'::bpchar | Determine if a column must be copied when pushing the button to copy record | ||
ad_column | isalwaysupdateable | bpchar | 1 | 'N'::bpchar | The column is always updateable, even if the record is not active or processed | ||
c_bankstatement | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_invoice | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_order | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
c_payment | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
gl_journal | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
m_inventory | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
ad_column | isautocomplete | bpchar | 1 | 'N'::bpchar | Automatic completion for text fields | ||
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) | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
c_bpartner_location | isbillto | bpchar | 1 | 'Y'::bpchar | Business Partner Invoice/Bill Address | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
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_bp_group | isconfidentialinfo | bpchar | 1 | 'N'::bpchar | Can enter confidential information | ||
s_resourceassignment | isconfirmed | bpchar | 1 | 'N'::bpchar | Assignment is confirmed | ||
c_doctype | iscreatecounter | bpchar | 1 | 'Y'::bpchar | Create Counter Document | ||
c_order | iscreditapproved | bpchar | 1 | 'N'::bpchar | Credit has been approved | ||
m_product_po | iscurrentvendor | bpchar | 1 | 'Y'::bpchar | Use this Vendor for pricing and stock replenishment | ||
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_bp_group | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_conversiontype | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_doctype | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_greeting | 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_uom | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
gl_category | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_locator | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_product_category | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_doctype | isdefaultcounterdoc | bpchar | 1 | 'N'::bpchar | The document type is the default counter document type | ||
c_payment | isdelayedcapture | bpchar | 1 | 'N'::bpchar | Charge after Shipment | ||
c_order | isdelivered | bpchar | 1 | 'N'::bpchar | Delivered | ||
c_invoiceline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
c_orderline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
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_invoice | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
c_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) | ||
c_order | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
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 | ||
ad_column | isencrypted | bpchar | 1 | 'N'::bpchar | Display or Storage is encrypted | ||
imp_processorlog | iserror | bpchar | 1 | 'Y'::bpchar | An Error occurred in the execution | ||
c_currency | iseuro | bpchar | 1 | 'N'::bpchar | This currency is the Euro | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
c_acctschema | isexplicitcostadjustment | bpchar | 1 | 'N'::bpchar | Post the cost adjustment explicitly | ||
c_greeting | isfirstnameonly | bpchar | 1 | 'N'::bpchar | Print only the first name in greetings | ||
ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | The user/contact has full access to Business Partner information and resources | ||
c_validcombination | isfullyqualified | bpchar | 1 | 'Y'::bpchar | This account is fully qualified | ||
gl_journalline | isgenerated | bpchar | 1 | 'N'::bpchar | This Line is generated | ||
ad_column | isidentifier | bpchar | 1 | 'N'::bpchar | This column is part of the record identifier | ||
pa_reportsource | isincludenullsactivity | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the activity | ||
pa_reportsource | isincludenullsbpartner | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the business partner | ||
pa_reportsource | isincludenullscampaign | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the campaign | ||
pa_reportsource | isincludenullselementvalue | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the account | ||
pa_reportsource | isincludenullslocation | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the location | ||
pa_reportsource | isincludenullsorg | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the organization | ||
pa_reportsource | isincludenullsorgtrx | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the organization transaction | ||
pa_reportsource | isincludenullsproduct | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the product | ||
pa_reportsource | isincludenullsproject | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the project | ||
pa_reportsource | isincludenullssalesregion | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the sales region | ||
pa_reportsource | isincludenullsuserelement1 | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the user element 1 | ||
pa_reportsource | isincludenullsuserelement2 | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the user element 2 | ||
c_doctype | isindexed | bpchar | 1 | 'Y'::bpchar | Index the document for the internal search engine | ||
c_invoice | isindispute | bpchar | 1 | 'N'::bpchar | Document is in dispute | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
c_doctype | isintransit | bpchar | 1 | 'N'::bpchar | Movement is in transit | ||
pa_reportline | isinversedebitcreditonly | bpchar | 1 | 'N'::bpchar | Apply inverse operation to debit or credit only column | ||
c_order | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the invoice | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | This part is Kanban controlled | ||
ad_column | iskey | bpchar | 1 | 'N'::bpchar | This column is the key in this table | ||
ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
ad_column | ismandatory | bpchar | 1 | 'N'::bpchar | Data entry is required in this column | ||
c_bankstatement | ismanual | bpchar | 1 | 'Y'::bpchar | This is a manual process | ||
c_bankstatementline | ismanual | bpchar | 1 | 'N'::bpchar | This is a manual process | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
c_element | isnaturalaccount | bpchar | 1 | 'Y'::bpchar | The primary natural account | ||
ad_user | isnoexpire | bpchar | 1 | 'N'::bpchar | No Expire | ||
ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | No Password Reset | ||
c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
c_payment | isonline | bpchar | 1 | 'N'::bpchar | Can be accessed online | ||
c_invoice | isoverridecurrencyrate | bpchar | 1 | 'N'::bpchar | Override Currency Conversion Rate | ||
c_payment | isoverridecurrencyrate | bpchar | 1 | 'N'::bpchar | Override Currency Conversion Rate | ||
c_payment | isoverunderpayment | bpchar | 1 | 'Y'::bpchar | Over-Payment (unallocated) or Under-Payment (partial payment) | ||
m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
c_invoice | ispaid | bpchar | 1 | 'N'::bpchar | The document is fully paid | ||
ad_column | isparent | bpchar | 1 | 'N'::bpchar | This column is a link to the parent table (e.g. header from lines) - incl. Association key columns | ||
ad_column | ispartitionkey | bpchar | 1 | 'N'::bpchar | This is a partition key | ||
c_bpartner_location | ispayfrom | bpchar | 1 | 'Y'::bpchar | Business Partner pays from that address and we'll send dunning letters there | ||
c_invoice | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | Is the Payment Schedule is valid | ||
c_order | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | Is the Payment Schedule is valid | ||
m_product | 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 | 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_payment | isprepayment | bpchar | 1 | 'N'::bpchar | The Payment/Receipt is a Prepayment | ||
c_bpartner_location | ispreservecustomname | bpchar | 1 | 'N'::bpchar | Preserve custom name | ||
gl_budget | isprimary | bpchar | 1 | 'Y'::bpchar | Indicates if this is the primary budget | ||
c_invoice | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
c_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
c_order | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
gl_journal | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
pa_reportline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | Privileged Rate | ||
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
c_payment | isreceipt | bpchar | 1 | 'Y'::bpchar | This is a sales transaction (receipt) | ||
c_payment | isreconciled | bpchar | 1 | 'N'::bpchar | Payment is reconciled with bank statement | ||
c_bpartner_location | isremitto | bpchar | 1 | 'Y'::bpchar | Business Partner payment address | ||
c_bankstatementline | isreversal | bpchar | 1 | 'N'::bpchar | This is a reversing transaction | ||
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | This contact is a sales lead | ||
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) | ||
c_charge | issamecurrency | bpchar | 1 | 'N'::bpchar | Same Currency | ||
c_charge | issametax | bpchar | 1 | 'N'::bpchar | Use the same tax as the main transaction | ||
ad_column | issecure | bpchar | 1 | 'N'::bpchar | Defines whether content must be treated as secure | ||
c_order | isselected | bpchar | 1 | 'N'::bpchar | Selected | ||
ad_column | isselectioncolumn | bpchar | 1 | 'N'::bpchar | Is this column used for finding rows in windows | ||
c_invoice | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_order | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
c_payment | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product_category | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
r_interestarea | isselfservice | bpchar | 1 | 'N'::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 | ||
ad_user | isshipto | bpchar | 1 | 'N'::bpchar | Business Partner Shipment Address | ||
c_bpartner_location | isshipto | bpchar | 1 | 'Y'::bpchar | Business Partner Shipment Address | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
m_pricelist | issopricelist | bpchar | 1 | 'Y'::bpchar | This is a Sales Price List | ||
c_doctype | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
c_invoice | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
c_order | 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 | ||
ad_org | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
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 | ||
pa_reportline | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | Support User | ||
c_tax | istaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on sales | ||
c_charge | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_invoice | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_invoicetax | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_ordertax | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
m_pricelist | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
ad_column | istoolbarbutton | bpchar | 1 | 'Y'::bpchar | Show the button on the toolbar, the window, or both | ||
c_acctschema | istradediscountposted | bpchar | 1 | 'N'::bpchar | Generate postings for trade discounts | ||
c_invoice | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
c_order | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
ad_column | istranslated | bpchar | 1 | 'N'::bpchar | This column is translated | ||
ad_column | isupdateable | bpchar | 1 | 'Y'::bpchar | Determines, if the field can be updated | ||
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 | ||
ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | This contact is a vendor lead | ||
m_product | isverified | bpchar | 1 | 'N'::bpchar | The BOM configuration has been verified | ||
c_payment | isvoided | bpchar | 1 | 'N'::bpchar | Voided | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
exp_processor_type | javaclass | varchar | 255 | Java Class | |||
imp_processor_type | javaclass | varchar | 255 | Java Class | |||
c_bankstatementline | line | numeric | 10 | Unique line for this document | |||
c_invoiceline | line | numeric | 10 | Unique line for this document | |||
c_orderline | line | numeric | 10 | Unique line for this document | |||
gl_journalline | line | numeric | 10 | Unique line for this document | |||
c_invoiceline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
c_orderline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
pa_reportline | linetype | bpchar | 1 | Line Type | |||
m_product | lowlevel | numeric | 10 | (0)::numeric | The Low Level is used to calculate the material plan and determines if a net requirement should be exploited | ||
m_attributesetinstance | m_attributesetinstance_id | numeric | 10 | Product Attribute Set Instance | |||
m_inoutlineconfirm | m_inoutconfirm_id | numeric | 10 | Material Shipment or Receipt Confirmation | |||
m_inoutlineconfirm | m_inoutline_id | numeric | 10 | Line on Shipment or Receipt document | |||
m_inoutlineconfirm | m_inoutlineconfirm_id | numeric | 10 | Material Shipment or Receipt Confirmation Line | |||
m_inventory | m_inventory_id | numeric | 10 | Parameters for a Physical Inventory | |||
m_inventoryline | m_inventory_id | numeric | 10 | Parameters for a Physical Inventory | |||
m_inventoryline | m_inventoryline_id | numeric | 10 | Unique line in an Inventory document | |||
m_locator | m_locator_id | numeric | 10 | Warehouse Locator | |||
c_invoice | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
c_order | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
m_pricelist | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product_category | m_product_category_id | numeric | 10 | Category of a Product | |||
m_inventoryline | m_product_id | numeric | 10 | Product, Service, Item | |||
m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
m_product_po | m_product_id | numeric | 10 | Product, Service, Item | |||
m_shipper | m_shipper_id | numeric | 10 | Method or manner of product delivery | |||
c_order | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
c_orderline | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_locator | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_warehouse | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_product_category | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
m_inventory | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
c_conversion_rate | multiplyrate | numeric | 0 | 0 | Rate to multiple the source by to calculate the target. | ||
ad_column | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_impformat | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_impformat_row | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_importtemplate | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_org | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_acctschema | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_activity | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_bankaccount | name | varchar | 60 | NULL::character varying | Alphanumeric identifier of the entity | ||
c_bankstatement | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_bp_group | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_bpartner_location | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_campaign | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_charge | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_conversiontype | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_country | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_doctype | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_element | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_elementvalue | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_greeting | name | varchar | 60 | 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_uom | name | varchar | 60 | Alphanumeric identifier of the entity | |||
exp_format | name | varchar | 60 | Alphanumeric identifier of the entity | |||
exp_formatline | name | varchar | 60 | Alphanumeric identifier of the entity | |||
exp_processor_type | name | varchar | 60 | Alphanumeric identifier of the entity | |||
exp_processorparameter | name | varchar | 60 | Alphanumeric identifier of the entity | |||
gl_budget | name | varchar | 60 | Alphanumeric identifier of the entity | |||
gl_category | name | varchar | 60 | Alphanumeric identifier of the entity | |||
imp_processor_type | name | varchar | 60 | Alphanumeric identifier of the entity | |||
imp_processorparameter | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_pricelist | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
m_product_category | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_shipper | name | varchar | 60 | NULL::character varying | Alphanumeric identifier of the entity | ||
m_warehouse | name | varchar | 60 | Alphanumeric identifier of the entity | |||
pa_reportline | name | varchar | 255 | Alphanumeric identifier of the entity | |||
pa_reportlineset | name | varchar | 60 | Alphanumeric identifier of the entity | |||
r_interestarea | name | varchar | 60 | Alphanumeric identifier of the entity | |||
s_resourceassignment | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_paymentterm | netdays | numeric | 10 | Net Days in which payment is due | |||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
pa_reportline | pa_reportline_id | numeric | 10 | Report Line | |||
pa_reportsource | pa_reportline_id | numeric | 10 | Report Line | |||
pa_reportline | pa_reportlineset_id | numeric | 10 | Report Line Set | |||
pa_reportlineset | pa_reportlineset_id | numeric | 10 | Report Line Set | |||
pa_reportsource | pa_reportsource_id | numeric | 10 | Restriction of what will be shown in Report Line | |||
c_payment | payamt | numeric | 0 | 0 | Amount being paid | ||
c_invoice | paymentrule | bpchar | 1 | How you pay the invoice | |||
c_order | paymentrule | bpchar | 1 | How you pay the invoice | |||
c_paymentterm | paymenttermusage | bpchar | 1 | 'B'::bpchar | Payment term usage indicates if this payment term is used for sales, purchases or both. | ||
c_period | periodno | numeric | 10 | Unique Period Number | |||
c_period | periodtype | bpchar | 1 | Period Type | |||
c_project | plannedamt | numeric | 0 | 0 | Planned amount for this project | ||
m_product_category | plannedmargin | numeric | 0 | Project's planned margin as a percentage | |||
c_project | plannedmarginamt | numeric | 0 | 0 | Project's planned margin amount | ||
c_project | plannedqty | numeric | 0 | 0 | Planned quantity for this project | ||
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_bankstatement | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_invoice | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_order | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_payment | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
gl_journal | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
m_inventory | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
c_elementvalue | postencumbrance | bpchar | 1 | 'Y'::bpchar | Post commitments to this account | ||
gl_journal | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
gl_journalbatch | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
c_elementvalue | poststatistical | bpchar | 1 | 'Y'::bpchar | Post statistical quantities to this account? | ||
c_invoiceline | priceactual | numeric | 0 | 0 | Actual Price | ||
c_orderline | priceactual | numeric | 0 | 0 | Actual Price | ||
c_invoiceline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
c_orderline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
c_invoiceline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
c_orderline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
c_invoiceline | pricelist | numeric | 0 | 0 | List Price | ||
c_orderline | pricelist | numeric | 0 | 0 | List Price | ||
m_pricelist | priceprecision | numeric | 10 | 2 | Precision (number of decimals) for the Price | ||
c_doctype | printname | varchar | 60 | The label text to be printed on a document or correspondence. | |||
m_locator | priorityno | numeric | 10 | Where inventory should be picked from first | |||
c_order | priorityrule | bpchar | 1 | Priority of a document | |||
c_bankstatement | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_bankstatementline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoice | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoicetax | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_order | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_orderline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_ordertax | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_payment | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_project | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
gl_journalbatch | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
gl_journalline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
i_inoutlineconfirm | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
i_movement | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inoutlineconfirm | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inventory | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inventoryline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
ad_impformat | processing | bpchar | 1 | Process Now | |||
gl_journalbatch | processing | bpchar | 1 | 'N'::bpchar | Process Now | ||
i_movement | processing | bpchar | 1 | 'N'::bpchar | Process Now | ||
pa_reportlineset | processing | bpchar | 1 | Process Now | |||
m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
c_project | projectbalanceamt | numeric | 0 | 0 | Total Project Balance | ||
c_project | projectlinelevel | bpchar | 1 | 'P'::bpchar | Project Line Level | ||
c_project | projinvoicerule | bpchar | 1 | '-'::bpchar | Invoice Rule for the project | ||
m_inventoryline | qtybook | numeric | 0 | 0 | Book Quantity | ||
m_inventoryline | qtycount | numeric | 0 | 0 | Counted Quantity | ||
m_inventoryline | qtycsv | numeric | 0 | 0 | Qty Csv | ||
c_orderline | qtydelivered | numeric | 0 | 0 | Delivered Quantity | ||
c_invoiceline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
c_orderline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
c_invoiceline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
c_orderline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
c_orderline | qtylostsales | numeric | 0 | 0 | Quantity of potential sales | ||
c_orderline | qtyordered | numeric | 0 | 0 | Ordered Quantity | ||
c_orderline | qtyreserved | numeric | 0 | 0 | Reserved Quantity | ||
r_interestarea | r_interestarea_id | numeric | 10 | Interest Area or Topic | |||
c_tax | rate | numeric | 0 | Rate or Tax or Exchange | |||
c_tax | requirestaxcertificate | bpchar | 1 | 'N'::bpchar | This tax rate requires the Business Partner to be tax exempt | ||
s_resourceassignment | s_resource_id | numeric | 10 | Resource | |||
s_resourceassignment | s_resourceassignment_id | numeric | 10 | Resource Assignment | |||
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_invoice | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_order | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_acctschema | separator | bpchar | 1 | Element Separator | |||
m_warehouse | separator | bpchar | 1 | Element Separator | |||
ad_impformat_row | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
pa_reportline | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
c_tax | sopotype | bpchar | 1 | 'B'::bpchar | Sales Tax applies to sales situations, Purchase Tax to purchase situations | ||
c_period | startdate | timestamp | 29,6 | First effective day (inclusive) | |||
c_bankstatement | statementdate | timestamp | 29,6 | Date of the statement | |||
c_bankstatementline | statementlinedate | timestamp | 29,6 | Date of the Statement Line | |||
c_currency | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
c_uom | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
c_bankstatementline | stmtamt | numeric | 0 | 0 | Statement Amount | ||
m_inoutlineconfirm | targetqty | numeric | 0 | 0 | Target Movement Quantity | ||
c_invoicetax | taxamt | numeric | 0 | 0 | Tax Amount for a document | ||
c_ordertax | taxamt | numeric | 0 | 0 | Tax Amount for a document | ||
c_invoicetax | taxbaseamt | numeric | 0 | 0 | Base for calculating the tax amount | ||
c_ordertax | taxbaseamt | numeric | 0 | 0 | Base for calculating the tax amount | ||
c_payment | tendertype | bpchar | 1 | Method of Payment | |||
gl_journal | totalcr | numeric | 0 | 0 | Total Credit in document currency | ||
gl_journalbatch | totalcr | numeric | 0 | 0 | Total Credit in document currency | ||
gl_journal | totaldr | numeric | 0 | 0 | Total debit in document currency | ||
gl_journalbatch | totaldr | numeric | 0 | 0 | Total debit in document currency | ||
c_invoice | totallines | numeric | 0 | 0 | Total of all document lines | ||
c_order | totallines | numeric | 0 | 0 | Total of all document lines | ||
c_bankstatementline | trxamt | numeric | 0 | 0 | Amount of a transaction | ||
c_payment | trxtype | bpchar | 1 | Type of credit card transaction | |||
exp_formatline | type | bpchar | 1 | 'E'::bpchar | Type of Validation (SQL, Java Script, Java Language) | ||
m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
ad_column | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_impformat | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_impformat_row | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_importtemplate | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
ad_org | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
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_bankaccount | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bankstatement | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bankstatementline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bp_group | 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_campaign | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_charge | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_conversion_rate | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_conversiontype | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_country | updated | timestamp | 29,6 | now() | 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_element | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_elementvalue | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_greeting | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoice | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoiceline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoicetax | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_location | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_order | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_orderline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_ordertax | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_payment | 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_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_uom | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_validcombination | updated | timestamp | 29,6 | now() | Date this record was updated | ||
exp_format | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
exp_formatline | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
exp_processor_type | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
exp_processorparameter | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
gl_budget | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_category | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_journal | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_journalbatch | updated | timestamp | 29,6 | now() | Date this record was updated | ||
gl_journalline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
i_asset | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_bankstatement | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_bpartner | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_conversion_rate | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_elementvalue | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_fajournal | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_fixedasset | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_gljournal | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_inoutlineconfirm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
i_inventory | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_invoice | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_movement | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_order | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_payment | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_pricelist | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_product | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
i_reportline | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
imp_processor_type | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
imp_processorlog | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
imp_processorparameter | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
m_attributesetinstance | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inoutlineconfirm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inventory | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inventoryline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_locator | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_pricelist | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product_category | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product_po | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_shipper | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_warehouse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_reportline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_reportlineset | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_reportsource | updated | timestamp | 29,6 | now() | Date this record was updated | ||
r_interestarea | updated | timestamp | 29,6 | now() | Date this record was updated | ||
s_resourceassignment | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_column | updatedby | numeric | 10 | User who updated this records | |||
ad_impformat | updatedby | numeric | 10 | User who updated this records | |||
ad_impformat_row | updatedby | numeric | 10 | User who updated this records | |||
ad_importtemplate | updatedby | numeric | 10 | User who updated this records | |||
ad_org | updatedby | numeric | 10 | User who updated this records | |||
ad_user | updatedby | numeric | 10 | User who updated this records | |||
c_acctschema | updatedby | numeric | 10 | User who updated this records | |||
c_activity | updatedby | numeric | 10 | User who updated this records | |||
c_bankaccount | updatedby | numeric | 10 | User who updated this records | |||
c_bankstatement | updatedby | numeric | 10 | User who updated this records | |||
c_bankstatementline | updatedby | numeric | 10 | User who updated this records | |||
c_bp_group | 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_campaign | updatedby | numeric | 10 | User who updated this records | |||
c_charge | updatedby | numeric | 10 | User who updated this records | |||
c_conversion_rate | updatedby | numeric | 10 | User who updated this records | |||
c_conversiontype | updatedby | numeric | 10 | User who updated this records | |||
c_country | 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_element | updatedby | numeric | 10 | User who updated this records | |||
c_elementvalue | updatedby | numeric | 10 | User who updated this records | |||
c_greeting | updatedby | numeric | 10 | User who updated this records | |||
c_invoice | updatedby | numeric | 10 | User who updated this records | |||
c_invoiceline | updatedby | numeric | 10 | User who updated this records | |||
c_invoicetax | updatedby | numeric | 10 | User who updated this records | |||
c_location | updatedby | numeric | 10 | User who updated this records | |||
c_order | updatedby | numeric | 10 | User who updated this records | |||
c_orderline | updatedby | numeric | 10 | User who updated this records | |||
c_ordertax | updatedby | numeric | 10 | User who updated this records | |||
c_payment | 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_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_uom | updatedby | numeric | 10 | User who updated this records | |||
c_validcombination | updatedby | numeric | 10 | User who updated this records | |||
exp_format | updatedby | numeric | 10 | User who updated this records | |||
exp_formatline | updatedby | numeric | 10 | User who updated this records | |||
exp_processor_type | updatedby | numeric | 10 | User who updated this records | |||
exp_processorparameter | updatedby | numeric | 10 | User who updated this records | |||
gl_budget | updatedby | numeric | 10 | User who updated this records | |||
gl_category | updatedby | numeric | 10 | User who updated this records | |||
gl_journal | updatedby | numeric | 10 | User who updated this records | |||
gl_journalbatch | updatedby | numeric | 10 | User who updated this records | |||
gl_journalline | updatedby | numeric | 10 | User who updated this records | |||
i_asset | updatedby | numeric | 10 | User who updated this records | |||
i_fixedasset | updatedby | numeric | 10 | User who updated this records | |||
i_inoutlineconfirm | updatedby | numeric | 10 | User who updated this records | |||
i_movement | updatedby | numeric | 10 | User who updated this records | |||
imp_processor_type | updatedby | numeric | 10 | User who updated this records | |||
imp_processorlog | updatedby | numeric | 10 | User who updated this records | |||
imp_processorparameter | updatedby | numeric | 10 | User who updated this records | |||
m_attributesetinstance | updatedby | numeric | 10 | User who updated this records | |||
m_inoutlineconfirm | updatedby | numeric | 10 | User who updated this records | |||
m_inventory | updatedby | numeric | 10 | User who updated this records | |||
m_inventoryline | updatedby | numeric | 10 | User who updated this records | |||
m_locator | updatedby | numeric | 10 | User who updated this records | |||
m_pricelist | updatedby | numeric | 10 | User who updated this records | |||
m_product | updatedby | numeric | 10 | User who updated this records | |||
m_product_category | updatedby | numeric | 10 | User who updated this records | |||
m_product_po | updatedby | numeric | 10 | User who updated this records | |||
m_shipper | updatedby | numeric | 10 | User who updated this records | |||
m_warehouse | updatedby | numeric | 10 | User who updated this records | |||
pa_reportline | updatedby | numeric | 10 | User who updated this records | |||
pa_reportlineset | updatedby | numeric | 10 | User who updated this records | |||
pa_reportsource | updatedby | numeric | 10 | User who updated this records | |||
r_interestarea | updatedby | numeric | 10 | User who updated this records | |||
s_resourceassignment | updatedby | numeric | 10 | User who updated this records | |||
c_conversion_rate | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
c_tax | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
ad_org | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
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_bp_group | value | varchar | 40 | 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_conversiontype | 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 | |||
exp_format | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
exp_formatline | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
exp_processor_type | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
exp_processorparameter | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
gl_category | value | varchar | 60 | NULL::character varying | Search key for the record in the format required - must be unique | ||
imp_processor_type | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
imp_processorparameter | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_locator | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
m_product_category | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_warehouse | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
r_interestarea | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_bankstatementline | valutadate | timestamp | 29,6 | Date when money is available | |||
m_product_po | vendorproductno | varchar | 40 | Product Key of the Business Partner | |||
ad_column | version | numeric | 0 | Version of the table definition | |||
exp_format | version | varchar | 40 | Version of the table definition | |||
c_uom | x12de355 | varchar | 4 | UOM EDI X12 Code |