SchemaSpy Analysis of idempiere11.adempiere - ColumnsFinancial Reporting | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:48 +0100 |
| |||||
|
idempiere11.adempiere contains 496 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
t_trialbalance | levelno | numeric | 10 | √ | '0'::numeric | Level no | |
pa_report | excludeadjustmentperiods | bpchar | 1 | '1'::bpchar | Exclude Adjustment Periods | ||
pa_reportcolumn | paamounttype | bpchar | 1 | √ | 'B'::bpchar | PA Amount Type for reporting | |
pa_reportcolumn | isadhocconversion | bpchar | 1 | √ | 'N'::bpchar | Perform conversion for all amounts to currency | |
pa_reportcolumn | isallowoppositesign | bpchar | 1 | √ | 'N'::bpchar | Allow column values to be displayed with the opposite sign | |
ad_pinstance | isrunasjob | bpchar | 1 | √ | 'N'::bpchar | Run as Job | |
pa_reportline | isshowoppositesign | bpchar | 1 | √ | 'N'::bpchar | Display values with the opposite sign | |
pa_report | listsourcesxtrx | bpchar | 1 | √ | 'N'::bpchar | Include source accounts with no transaction for list report line sources | |
c_element | isbalancing | bpchar | 1 | 'N'::bpchar | All transactions within an element value must balance (e.g. cost centers) | ||
ad_printformat | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
ad_tree | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
ad_printformat | isform | bpchar | 1 | 'N'::bpchar | If Selected, a Form is printed, if not selected a columnar List report | ||
pa_reportcolumn | isincludenullsactivity | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the activity | ||
pa_reportsource | isincludenullsactivity | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the activity | ||
pa_reportcolumn | isincludenullsbpartner | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the business partner | ||
pa_reportsource | isincludenullsbpartner | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the business partner | ||
pa_reportcolumn | isincludenullscampaign | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the campaign | ||
pa_reportsource | isincludenullscampaign | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the campaign | ||
pa_reportcolumn | isincludenullselementvalue | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the account | ||
pa_reportsource | isincludenullselementvalue | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the account | ||
pa_reportcolumn | isincludenullslocation | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the location | ||
pa_reportsource | isincludenullslocation | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the location | ||
pa_reportcolumn | isincludenullsorg | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the organization | ||
pa_reportsource | isincludenullsorg | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the organization | ||
pa_reportcolumn | isincludenullsorgtrx | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the organization transaction | ||
pa_reportsource | isincludenullsorgtrx | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the organization transaction | ||
pa_reportcolumn | isincludenullsproduct | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the product | ||
pa_reportsource | isincludenullsproduct | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the product | ||
pa_reportcolumn | isincludenullsproject | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the project | ||
pa_reportsource | isincludenullsproject | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the project | ||
pa_reportcolumn | isincludenullssalesregion | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the sales region | ||
pa_reportsource | isincludenullssalesregion | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the sales region | ||
pa_reportcolumn | isincludenullsuserelement1 | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the user element 1 | ||
pa_reportsource | isincludenullsuserelement1 | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the user element 1 | ||
pa_reportcolumn | isincludenullsuserelement2 | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the user element 2 | ||
pa_reportsource | isincludenullsuserelement2 | bpchar | 1 | 'N'::bpchar | Include nulls in the selection of the user element 2 | ||
pa_reportline | isinversedebitcreditonly | bpchar | 1 | 'N'::bpchar | Apply inverse operation to debit or credit only column | ||
ad_pinstance | isprocessing | bpchar | 1 | 'N'::bpchar | Processing | ||
pa_reportline | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_tree | istreedrivenbyvalue | bpchar | 1 | 'N'::bpchar | Driven by Search Key | ||
ad_tree | isvaluedisplayed | bpchar | 1 | 'N'::bpchar | Displays Value column with the Display column | ||
pa_report | listsources | bpchar | 1 | 'N'::bpchar | List Report Line Sources | ||
pa_report | listtrx | bpchar | 1 | 'N'::bpchar | List the report transactions | ||
pa_reportcolumn | paperiodtype | bpchar | 1 | √ | 'P'::bpchar | PA Period Type | |
ad_pinstance | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
ad_printformat | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_tree | 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 | ||
fact_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
pa_hierarchy | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
pa_report | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
pa_reportcolumn | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
pa_reportcolumnset | 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 | ||
ad_tree | isallnodes | bpchar | 1 | 'Y'::bpchar | All Nodes are included (Complete Tree) | ||
ad_printformat | isbreakpageperrecord | bpchar | 1 | 'Y'::bpchar | Page Break after each record | ||
ad_tree | isloadallnodesimmediately | bpchar | 1 | 'Y'::bpchar | If checked, all nodes are loaded before tree is displayed | ||
c_element | isnaturalaccount | bpchar | 1 | 'Y'::bpchar | The primary natural account | ||
pa_reportcolumn | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
pa_reportline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
ad_printformat | isstandardheaderfooter | bpchar | 1 | 'Y'::bpchar | The standard Header and Footer is used | ||
ad_printformat | istablebased | bpchar | 1 | 'Y'::bpchar | Table based List Reporting | ||
t_reportstatement | amtacctcr | numeric | 0 | √ | 0 | Accounted Credit Amount | |
t_reportstatement | amtacctdr | numeric | 0 | √ | 0 | Accounted Debit Amount | |
t_reportstatement | balance | numeric | 0 | √ | 0 | Balance | |
t_report | levelno | numeric | 10 | √ | 0 | Level no | |
fact_acct | qty | numeric | 0 | √ | 0 | Quantity | |
t_reportstatement | qty | numeric | 0 | √ | 0 | Quantity | |
fact_acct | amtacctcr | numeric | 0 | 0 | Accounted Credit Amount | ||
fact_acct | amtacctdr | numeric | 0 | 0 | Accounted Debit Amount | ||
fact_acct | amtsourcecr | numeric | 0 | 0 | Source Credit Amount | ||
fact_acct | amtsourcedr | numeric | 0 | 0 | Source Debit Amount | ||
ad_pinstance | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_printformat | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_tree | created | timestamp | 29,6 | now() | Date this record was created | ||
c_element | created | timestamp | 29,6 | now() | Date this record was created | ||
fact_acct | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_hierarchy | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_report | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_reportcolumn | created | timestamp | 29,6 | now() | Date this record was created | ||
pa_reportcolumnset | 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 | ||
ad_printformat | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_tree | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_element | updated | timestamp | 29,6 | now() | Date this record was updated | ||
fact_acct | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_hierarchy | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_report | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_reportcolumn | updated | timestamp | 29,6 | now() | Date this record was updated | ||
pa_reportcolumnset | 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 | ||
fact_acct | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
t_trialbalance | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
fact_acct_balance | account_id | numeric | 10 | √ | null | Account used | |
t_trialbalance | accountvalue | varchar | 40 | √ | null | Key of Account Element | |
ad_pinstance | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
fact_acct_balance | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
ad_pinstance | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
fact_acct_balance | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
pa_report | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
fact_acct | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
fact_acct_balance | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
pa_reportcolumn | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
pa_reportsource | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
t_trialbalance | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
pa_report | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
ad_printformat | ad_printtableformat_id | numeric | 10 | √ | null | Table Format in Reports | |
ad_printformat | ad_reportview_id | numeric | 10 | √ | null | View used to generate this report | |
t_trialbalance | ad_table_id | numeric | 10 | √ | null | Database Table information | |
c_element | ad_tree_id | numeric | 10 | √ | null | Identifies a Tree | |
ad_pinstance | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
pa_reportcolumn | amounttype | bpchar | 2 | √ | null | Type of amount to report | |
pa_reportline | amounttype | bpchar | 2 | √ | null | Type of amount to report | |
fact_acct_balance | amtacctcr | numeric | 0 | √ | null | Accounted Credit Amount | |
fact_acct_balance | amtacctdr | numeric | 0 | √ | null | Accounted Debit Amount | |
t_trialbalance | amtsourcebalance | numeric | 0 | √ | null | Source Balance Amount | |
t_trialbalance | amtsourcecr | numeric | 0 | √ | null | Source Credit Amount | |
t_trialbalance | amtsourcedr | numeric | 0 | √ | null | Source Debit Amount | |
ad_printformat | args | varchar | 510 | √ | null | Args | |
fact_acct_balance | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
fact_acct | c_activity_id | numeric | 10 | √ | null | Business Activity | |
fact_acct_balance | c_activity_id | numeric | 10 | √ | null | Business Activity | |
pa_reportcolumn | c_activity_id | numeric | 10 | √ | null | Business Activity | |
pa_reportsource | c_activity_id | numeric | 10 | √ | null | Business Activity | |
t_trialbalance | c_activity_id | numeric | 10 | √ | null | Business Activity | |
fact_acct | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
fact_acct_balance | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
pa_reportcolumn | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
pa_reportsource | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
t_trialbalance | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
fact_acct | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
fact_acct_balance | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
pa_reportcolumn | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
pa_reportsource | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
t_trialbalance | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
pa_reportcolumn | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
t_trialbalance | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
pa_reportcolumn | c_elementvalue_id | numeric | 10 | √ | null | Account Element | |
pa_reportsource | c_elementvalue_id | numeric | 10 | √ | null | Account Element | |
pa_reportcolumn | c_location_id | numeric | 10 | √ | null | Location or Address | |
pa_reportsource | c_location_id | numeric | 10 | √ | null | Location or Address | |
fact_acct | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
fact_acct_balance | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
t_trialbalance | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
fact_acct | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
fact_acct_balance | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
t_trialbalance | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
fact_acct | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
t_trialbalance | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
fact_acct | c_project_id | numeric | 10 | √ | null | Financial Project | |
fact_acct_balance | c_project_id | numeric | 10 | √ | null | Financial Project | |
pa_reportcolumn | c_project_id | numeric | 10 | √ | null | Financial Project | |
pa_reportsource | c_project_id | numeric | 10 | √ | null | Financial Project | |
t_trialbalance | c_project_id | numeric | 10 | √ | null | Financial Project | |
fact_acct | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
fact_acct_balance | c_projectphase_id | numeric | 0 | √ | null | Phase of a Project | |
fact_acct | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
fact_acct_balance | c_projecttask_id | numeric | 0 | √ | null | Actual Project Task in a Phase | |
fact_acct | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
fact_acct_balance | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
pa_reportcolumn | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
pa_reportsource | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
t_trialbalance | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
fact_acct | c_subacct_id | numeric | 10 | √ | null | Sub account for Element Value | |
fact_acct_balance | c_subacct_id | numeric | 0 | √ | null | Sub account for Element Value | |
fact_acct | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
t_trialbalance | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
fact_acct | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
t_trialbalance | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
pa_reportcolumn | calculationtype | bpchar | 1 | √ | null | Calculation | |
pa_reportline | calculationtype | bpchar | 1 | √ | null | Calculation | |
ad_printformat | classname | varchar | 240 | √ | null | Java Classname | |
t_report | col_0 | numeric | 0 | √ | null | Col_0 | |
t_report | col_1 | numeric | 0 | √ | null | Col_1 | |
t_report | col_10 | numeric | 0 | √ | null | Col_10 | |
t_report | col_11 | numeric | 0 | √ | null | Col_11 | |
t_report | col_12 | numeric | 0 | √ | null | Col_12 | |
t_report | col_13 | numeric | 0 | √ | null | Col_13 | |
t_report | col_14 | numeric | 0 | √ | null | Col_14 | |
t_report | col_15 | numeric | 0 | √ | null | Col_15 | |
t_report | col_16 | numeric | 0 | √ | null | Col_16 | |
t_report | col_17 | numeric | 0 | √ | null | Col_17 | |
t_report | col_18 | numeric | 0 | √ | null | Col_18 | |
t_report | col_19 | numeric | 0 | √ | null | Col_19 | |
t_report | col_2 | numeric | 0 | √ | null | Col_2 | |
t_report | col_20 | numeric | 0 | √ | null | Col_20 | |
t_report | col_21 | numeric | 0 | √ | null | Col_21 | |
t_report | col_22 | numeric | 0 | √ | null | Col_22 | |
t_report | col_23 | numeric | 0 | √ | null | Col_23 | |
t_report | col_24 | numeric | 0 | √ | null | Col_24 | |
t_report | col_25 | numeric | 0 | √ | null | Col_25 | |
t_report | col_26 | numeric | 0 | √ | null | Col_26 | |
t_report | col_27 | numeric | 0 | √ | null | Col_27 | |
t_report | col_28 | numeric | 0 | √ | null | Col_28 | |
t_report | col_29 | numeric | 0 | √ | null | Col_29 | |
t_report | col_3 | numeric | 0 | √ | null | Col_3 | |
t_report | col_30 | numeric | 0 | √ | null | Col_30 | |
t_report | col_4 | numeric | 0 | √ | null | Col_4 | |
t_report | col_5 | numeric | 0 | √ | null | Col_5 | |
t_report | col_6 | numeric | 0 | √ | null | Col_6 | |
t_report | col_7 | numeric | 0 | √ | null | Col_7 | |
t_report | col_8 | numeric | 0 | √ | null | Col_8 | |
t_report | col_9 | numeric | 0 | √ | null | Col_9 | |
ad_printformat | createcopy | bpchar | 1 | √ | null | Create Copy | |
fact_acct_balance | created | timestamp | 29,6 | √ | null | Date this record was created | |
ad_pinstance | createdby | numeric | 10 | √ | null | User who created this records | |
fact_acct_balance | createdby | numeric | 0 | √ | null | User who created this records | |
pa_reportcolumn | currencytype | bpchar | 1 | √ | null | Currency Type | |
fact_acct_balance | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
fact_acct_summary | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
t_trialbalance | datetrx | timestamp | 29,6 | √ | null | Transaction Date | |
ad_printformat | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_tree | description | varchar | 255 | √ | null | Optional short description of the record | |
c_element | description | varchar | 255 | √ | null | Optional short description of the record | |
fact_acct | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_hierarchy | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_report | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_reportcolumn | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_reportcolumnset | 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 | |
t_report | description | varchar | 255 | √ | null | Optional short description of the record | |
t_reportstatement | description | varchar | 255 | √ | null | Optional short description of the record | |
t_trialbalance | description | varchar | 255 | √ | null | Optional short description of the record | |
pa_reportcolumn | elementtype | bpchar | 2 | √ | null | Element Type (account or user defined) | |
ad_pinstance | errormsg | varchar | 2000 | √ | null | Error Msg | |
pa_reportcolumn | factor | bpchar | 1 | √ | null | Scaling factor. | |
ad_printformat | filenamepattern | varchar | 255 | √ | null | File Name Pattern | |
pa_reportcolumn | formatpattern | varchar | 22 | √ | null | The pattern used to format a number or date. | |
fact_acct | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
fact_acct_balance | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
pa_reportcolumn | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
pa_reportline | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
t_trialbalance | gl_budget_id | numeric | 10 | √ | null | General Ledger Budget | |
fact_acct | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
t_trialbalance | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
pa_hierarchy | help | varchar | 2000 | √ | null | Comment or Hint | |
fact_acct_balance | isactive | bpchar | 2147483647 | √ | null | The record is active in the system | |
ad_printformat | jasperprocess_id | numeric | 10 | √ | null | The Jasper Process used by the print engine if any process defined | |
pa_report | jasperprocess_id | numeric | 10 | √ | null | The Jasper Process used by the print engine if any process defined | |
pa_report | jasperprocessing | bpchar | 1 | √ | null | Jasper Process Now | |
fact_acct | line_id | numeric | 10 | √ | null | Transaction line ID (internal) | |
t_trialbalance | line_id | numeric | 10 | √ | null | Transaction line ID (internal) | |
fact_acct | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
t_trialbalance | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
fact_acct | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
fact_acct_balance | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
pa_reportcolumn | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
pa_reportsource | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
t_trialbalance | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
pa_reportcolumn | multiplier | numeric | 0 | √ | null | Type Multiplier (Credit = -1) | |
pa_reportline | multiplier | numeric | 0 | √ | null | Type Multiplier (Credit = -1) | |
t_report | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
t_reportstatement | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
pa_reportcolumn | oper_1_id | numeric | 10 | √ | null | First operand for calculation | |
pa_reportline | oper_1_id | numeric | 10 | √ | null | First operand for calculation | |
pa_reportcolumn | oper_2_id | numeric | 10 | √ | null | Second operand for calculation | |
pa_reportline | oper_2_id | numeric | 10 | √ | null | Second operand for calculation | |
pa_reportcolumn | org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
pa_reportsource | org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
pa_reportline | parent_id | numeric | 10 | √ | null | Parent of Entity | |
fact_acct_balance | 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 | |
ad_printformat | printername | varchar | 40 | √ | null | Name of the Printer | |
ad_tree | processing | bpchar | 1 | √ | null | Process Now | |
fact_acct_balance | qty | numeric | 0 | √ | null | Quantity | |
t_trialbalance | qty | numeric | 0 | √ | null | Quantity | |
t_trialbalance | record_id | numeric | 10 | √ | null | Direct internal record ID | |
pa_reportcolumn | relativeperiod | numeric | 10 | √ | null | Period offset (0 is current) | |
pa_reportcolumn | relativeperiodto | numeric | 0 | √ | null | Period offset (0 is current) | |
ad_pinstance | result | numeric | 10 | √ | null | Result of the action taken | |
t_report | seqno | numeric | 0 | √ | null | Method of ordering records; lowest number comes first | |
fact_acct_balance | updated | timestamp | 29,6 | √ | null | Date this record was updated | |
fact_acct_balance | updatedby | numeric | 0 | √ | null | User who updated this records | |
fact_acct | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
fact_acct_balance | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
t_trialbalance | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
fact_acct | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
fact_acct_balance | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
t_trialbalance | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
fact_acct | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
fact_acct_balance | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
pa_reportcolumn | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
pa_reportsource | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
fact_acct | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
fact_acct_balance | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
pa_reportcolumn | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
pa_reportsource | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
c_element | vformat | varchar | 40 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
fact_acct | account_id | numeric | 10 | Account used | |||
fact_acct_summary | account_id | numeric | 10 | Account used | |||
t_trialbalance | account_id | numeric | 10 | Account used | |||
ad_printformat | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_tree | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_element | ad_client_id | numeric | 10 | Tenant for this installation. | |||
fact_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
fact_acct_summary | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_hierarchy | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_report | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_reportcolumn | ad_client_id | numeric | 10 | Tenant for this installation. | |||
pa_reportcolumnset | 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. | |||
t_trialbalance | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_printformat | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_tree | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_element | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
fact_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
fact_acct_summary | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
pa_hierarchy | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
pa_reportcolumn | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
pa_reportcolumnset | 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 | |||
t_trialbalance | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_pinstance | ad_pinstance_id | numeric | 10 | Instance of the process | |||
t_report | ad_pinstance_id | numeric | 10 | Instance of the process | |||
t_reportstatement | ad_pinstance_id | numeric | 10 | Instance of the process | |||
t_trialbalance | ad_pinstance_id | numeric | 10 | Instance of the process | |||
ad_printformat | ad_printcolor_id | numeric | 10 | Color used for printing and display | |||
ad_printformat | ad_printfont_id | numeric | 10 | Maintain Print Font | |||
ad_printformat | ad_printformat_id | numeric | 10 | Data Print Format | |||
ad_printformat | ad_printpaper_id | numeric | 10 | Printer paper definition | |||
ad_pinstance | ad_process_id | numeric | 10 | Process or Report | |||
ad_printformat | ad_table_id | numeric | 10 | Database Table information | |||
fact_acct | ad_table_id | numeric | 10 | Database Table information | |||
pa_hierarchy | ad_tree_account_id | numeric | 10 | Tree for Natural Account Tree | |||
pa_hierarchy | ad_tree_activity_id | numeric | 10 | Trees are used for (financial) reporting | |||
pa_hierarchy | ad_tree_bpartner_id | numeric | 10 | Trees are used for (financial) reporting | |||
pa_hierarchy | ad_tree_campaign_id | numeric | 10 | Trees are used for (financial) reporting | |||
ad_tree | ad_tree_id | numeric | 10 | Identifies a Tree | |||
pa_hierarchy | ad_tree_org_id | numeric | 10 | Trees are used for (financial) reporting and security access (via role) | |||
pa_hierarchy | ad_tree_product_id | numeric | 10 | Trees are used for (financial) reporting | |||
pa_hierarchy | ad_tree_project_id | numeric | 10 | Trees are used for (financial) reporting | |||
pa_hierarchy | ad_tree_salesregion_id | numeric | 10 | Trees are used for (financial) reporting | |||
t_trialbalance | amtacctbalance | numeric | 0 | Accounted Balance Amount | |||
fact_acct_summary | amtacctcr | numeric | 0 | Accounted Credit Amount | |||
t_trialbalance | amtacctcr | numeric | 0 | Accounted Credit Amount | |||
fact_acct_summary | amtacctdr | numeric | 0 | Accounted Debit Amount | |||
t_trialbalance | amtacctdr | numeric | 0 | Accounted Debit Amount | |||
fact_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
fact_acct_summary | c_acctschema_id | numeric | 10 | Rules for accounting | |||
pa_report | c_acctschema_id | numeric | 10 | Rules for accounting | |||
t_trialbalance | c_acctschema_id | numeric | 10 | Rules for accounting | |||
pa_report | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
fact_acct | c_currency_id | numeric | 10 | The Currency for this record | |||
c_element | c_element_id | numeric | 10 | Accounting Element | |||
fact_acct_summary | c_period_id | numeric | 10 | Period of the Calendar | |||
pa_reportcolumn | columntype | bpchar | 1 | Column Type | |||
ad_printformat | createdby | numeric | 10 | User who created this records | |||
ad_tree | createdby | numeric | 10 | User who created this records | |||
c_element | createdby | numeric | 10 | User who created this records | |||
fact_acct | createdby | numeric | 10 | User who created this records | |||
fact_acct_summary | createdby | numeric | 10 | User who created this records | |||
pa_hierarchy | createdby | numeric | 10 | User who created this records | |||
pa_report | createdby | numeric | 10 | User who created this records | |||
pa_reportcolumn | createdby | numeric | 10 | User who created this records | |||
pa_reportcolumnset | 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 | |||
t_trialbalance | createdby | numeric | 10 | User who created this records | |||
fact_acct | dateacct | timestamp | 29,6 | Accounting Date | |||
t_reportstatement | dateacct | timestamp | 29,6 | Accounting Date | |||
t_trialbalance | dateacct | timestamp | 29,6 | Accounting Date | |||
fact_acct | datetrx | timestamp | 29,6 | Transaction Date | |||
c_element | elementtype | bpchar | 1 | Element Type (account or user defined) | |||
pa_reportsource | elementtype | bpchar | 2 | Element Type (account or user defined) | |||
fact_acct | fact_acct_id | numeric | 10 | Accounting Fact | |||
t_report | fact_acct_id | numeric | 10 | Accounting Fact | |||
t_reportstatement | fact_acct_id | numeric | 10 | Accounting Fact | |||
t_trialbalance | fact_acct_id | numeric | 10 | Accounting Fact | |||
ad_printformat | footermargin | numeric | 10 | Margin of the Footer in 1/72 of an inch | |||
ad_printformat | headermargin | numeric | 10 | Margin of the Header in 1/72 of an inch | |||
fact_acct_summary | isactive | bpchar | 1 | The record is active in the system | |||
t_reportstatement | levelno | numeric | 10 | Level no | |||
pa_reportline | linetype | bpchar | 1 | Line Type | |||
ad_printformat | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_tree | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_element | name | varchar | 60 | Alphanumeric identifier of the entity | |||
pa_hierarchy | name | varchar | 60 | Alphanumeric identifier of the entity | |||
pa_report | name | varchar | 60 | Alphanumeric identifier of the entity | |||
pa_reportcolumn | name | varchar | 255 | Alphanumeric identifier of the entity | |||
pa_reportcolumnset | 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 | |||
pa_hierarchy | pa_hierarchy_id | numeric | 10 | Optional Reporting Hierarchy - If not selected the default hierarchy trees are used. | |||
pa_report | pa_report_id | numeric | 10 | Financial Report | |||
pa_reportcolumn | pa_reportcolumn_id | numeric | 10 | Column in Report | |||
pa_report | pa_reportcolumnset_id | numeric | 10 | Collection of Columns for Report | |||
pa_reportcolumn | pa_reportcolumnset_id | numeric | 10 | Collection of Columns for Report | |||
pa_reportcolumnset | pa_reportcolumnset_id | numeric | 10 | Collection of Columns for Report | |||
fact_acct_summary | pa_reportcube_id | numeric | 10 | Define reporting cube for pre-calculation of summary accounting data. | |||
pa_reportline | pa_reportline_id | numeric | 10 | Report Line | |||
pa_reportsource | pa_reportline_id | numeric | 10 | Report Line | |||
t_report | pa_reportline_id | numeric | 10 | Report Line | |||
pa_report | pa_reportlineset_id | numeric | 10 | Report Line Set | |||
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 | |||
fact_acct | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
fact_acct_summary | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
pa_reportcolumn | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
t_trialbalance | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
pa_report | processing | bpchar | 1 | Process Now | |||
pa_reportcolumnset | processing | bpchar | 1 | Process Now | |||
pa_reportlineset | processing | bpchar | 1 | Process Now | |||
fact_acct_summary | qty | numeric | 0 | Quantity | |||
ad_pinstance | record_id | numeric | 10 | Direct internal record ID | |||
fact_acct | record_id | numeric | 10 | Direct internal record ID | |||
t_report | record_id | numeric | 10 | Direct internal record ID | |||
pa_reportcolumn | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
pa_reportline | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
ad_tree | treetype | bpchar | 2 | Element this tree is built on (i.e Product, Business Partner) | |||
ad_pinstance | updatedby | numeric | 10 | User who updated this records | |||
ad_printformat | updatedby | numeric | 10 | User who updated this records | |||
ad_tree | updatedby | numeric | 10 | User who updated this records | |||
c_element | updatedby | numeric | 10 | User who updated this records | |||
fact_acct | updatedby | numeric | 10 | User who updated this records | |||
fact_acct_summary | updatedby | numeric | 10 | User who updated this records | |||
pa_hierarchy | updatedby | numeric | 10 | User who updated this records | |||
pa_report | updatedby | numeric | 10 | User who updated this records | |||
pa_reportcolumn | updatedby | numeric | 10 | User who updated this records | |||
pa_reportcolumnset | 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 | |||
t_trialbalance | updatedby | numeric | 10 | User who updated this records | |||
ad_pinstance | issummary | bpchar | 1 | √ | NULL::bpchar | This is a summary entity | |
pa_reportline | paamounttype | bpchar | 1 | √ | NULL::bpchar | PA Amount Type for reporting | |
pa_reportline | paperiodtype | bpchar | 1 | √ | NULL::bpchar | PA Period Type | |
ad_pinstance | ad_pinstance_uu | varchar | 36 | √ | NULL::character varying | AD_PInstance_UU | |
ad_printformat | ad_printformat_uu | varchar | 36 | √ | NULL::character varying | AD_PrintFormat_UU | |
ad_tree | ad_tree_uu | varchar | 36 | √ | NULL::character varying | AD_Tree_UU | |
c_element | c_element_uu | varchar | 36 | √ | NULL::character varying | C_Element_UU | |
fact_acct_summary | fact_acct_summary_uu | varchar | 36 | √ | NULL::character varying | Fact_Acct_Summary_UU | |
fact_acct | fact_acct_uu | varchar | 36 | √ | NULL::character varying | Fact_Acct_UU | |
ad_pinstance | name | varchar | 60 | √ | NULL::character varying | Alphanumeric identifier of the entity | |
ad_pinstance | notificationtype | varchar | 2 | √ | NULL::character varying | Type of Notifications | |
pa_reportcolumn | oper_2_linename | varchar | 512 | √ | NULL::character varying | Name of the financial report line to take values from | |
pa_reportline | overlinestroketype | varchar | 3 | √ | NULL::character varying | Overline Stroke Type | |
pa_hierarchy | pa_hierarchy_uu | varchar | 36 | √ | NULL::character varying | PA_Hierarchy_UU | |
pa_report | pa_report_uu | varchar | 36 | √ | NULL::character varying | PA_Report_UU | |
pa_reportcolumn | pa_reportcolumn_uu | varchar | 36 | √ | NULL::character varying | PA_ReportColumn_UU | |
pa_reportcolumnset | pa_reportcolumnset_uu | varchar | 36 | √ | NULL::character varying | PA_ReportColumnSet_UU | |
pa_reportline | pa_reportline_uu | varchar | 36 | √ | NULL::character varying | PA_ReportLine_UU | |
pa_reportlineset | pa_reportlineset_uu | varchar | 36 | √ | NULL::character varying | PA_ReportLineSet_UU | |
pa_reportsource | pa_reportsource_uu | varchar | 36 | √ | NULL::character varying | PA_ReportSource_UU | |
ad_pinstance | record_uu | varchar | 36 | √ | NULL::character varying | Record UUID | |
ad_pinstance | reporttype | varchar | 5 | √ | NULL::character varying | Report Type | |
t_report | t_report_uu | varchar | 36 | √ | NULL::character varying | T_Report_UU | |
t_reportstatement | t_reportstatement_uu | varchar | 36 | √ | NULL::character varying | T_ReportStatement_UU | |
t_trialbalance | t_trialbalance_uu | varchar | 36 | √ | NULL::character varying | T_TrialBalance_UU | |
pa_reportline | underlinestroketype | varchar | 3 | √ | NULL::character varying | Underline Stroke Type | |
ad_pinstance | ad_language_id | numeric | 10 | √ | NULL::numeric | Language ID | |
fact_acct_summary | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
ad_pinstance | ad_printformat_id | numeric | 10 | √ | NULL::numeric | Data Print Format | |
ad_printformat | ad_printheaderfooter_id | numeric | 10 | √ | NULL::numeric | Print Header/Footer | |
ad_pinstance | ad_session_id | numeric | 10 | √ | NULL::numeric | User Session Online or Web | |
ad_pinstance | ad_table_id | numeric | 10 | √ | NULL::numeric | Database Table information | |
ad_tree | ad_table_id | numeric | 10 | √ | NULL::numeric | Database Table information | |
ad_printformat | ad_window_id | numeric | 10 | √ | NULL::numeric | Data entry or display window | |
fact_acct_summary | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
fact_acct_summary | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
fact_acct_summary | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
fact_acct_summary | c_locfrom_id | numeric | 10 | √ | NULL::numeric | Location that inventory was moved from | |
fact_acct_summary | c_locto_id | numeric | 10 | √ | NULL::numeric | Location that inventory was moved to | |
fact_acct_summary | c_project_id | numeric | 10 | √ | NULL::numeric | Financial Project | |
fact_acct_summary | c_projectphase_id | numeric | 10 | √ | NULL::numeric | Phase of a Project | |
fact_acct_summary | c_projecttask_id | numeric | 10 | √ | NULL::numeric | Actual Project Task in a Phase | |
fact_acct_summary | c_salesregion_id | numeric | 10 | √ | NULL::numeric | Sales coverage region | |
fact_acct_summary | c_subacct_id | numeric | 10 | √ | NULL::numeric | Sub account for Element Value | |
fact_acct_summary | gl_budget_id | numeric | 10 | √ | NULL::numeric | General Ledger Budget | |
fact_acct_summary | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
pa_report | pa_reportcube_id | numeric | 10 | √ | NULL::numeric | Define reporting cube for pre-calculation of summary accounting data. | |
ad_tree | parent_column_id | numeric | 10 | √ | NULL::numeric | The link column on the parent tab. | |
pa_reportcolumn | roundfactor | numeric | 10 | √ | NULL::numeric | Round Factor | |
pa_reportline | roundfactor | numeric | 10 | √ | NULL::numeric | Round Factor | |
fact_acct_summary | user1_id | numeric | 10 | √ | NULL::numeric | User defined list element #1 | |
fact_acct_summary | user2_id | numeric | 10 | √ | NULL::numeric | User defined list element #2 | |
fact_acct_summary | userelement1_id | numeric | 10 | √ | NULL::numeric | User defined accounting Element | |
fact_acct_summary | userelement2_id | numeric | 10 | √ | NULL::numeric | User defined accounting Element | |
fact_acct_summary | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
t_trialbalance | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_pinstance | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
fact_acct_summary | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
t_trialbalance | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated |