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

idempiere9.adempiere contains 486 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
pa_reportcolumn calculationtype bpchar 1  √  null Calculation
pa_reportline calculationtype bpchar 1  √  null Calculation
pa_reportcolumn columntype bpchar 1 Column Type
ad_printformat createcopy bpchar 1  √  null Create Copy
pa_reportcolumn currencytype bpchar 1  √  null Currency Type
c_element elementtype bpchar 1 Element Type (account or user defined)
pa_report excludeadjustmentperiods bpchar 1 '1'::bpchar Exclude Adjustment Periods
pa_reportcolumn factor bpchar 1  √  null Scaling factor.
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
fact_acct_summary isactive bpchar 1 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
pa_reportcolumn isadhocconversion bpchar 1  √  'N'::bpchar Perform conversion for all amounts to currency
ad_tree isallnodes bpchar 1 'Y'::bpchar All Nodes are included (Complete Tree)
pa_reportcolumn isallowoppositesign bpchar 1  √  'N'::bpchar Allow column values to be displayed with the opposite sign
c_element isbalancing bpchar 1 'N'::bpchar All transactions within an element value must balance (e.g. cost centers)
ad_printformat isbreakpageperrecord bpchar 1 'Y'::bpchar Page Break after each record
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_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_pinstance isprocessing bpchar 1 'N'::bpchar Processing
ad_pinstance isrunasjob bpchar 1  √  'N'::bpchar Run as Job
pa_reportline isshowoppositesign bpchar 1  √  'N'::bpchar Display values with the opposite sign
ad_printformat isstandardheaderfooter bpchar 1 'Y'::bpchar The standard Header and Footer is used
ad_pinstance issummary bpchar 1  √  NULL::bpchar This is a summary entity
pa_reportline issummary bpchar 1 'N'::bpchar This is a summary entity
ad_printformat istablebased bpchar 1 'Y'::bpchar Table based List Reporting
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 jasperprocessing bpchar 1  √  null Jasper Process Now
pa_reportline linetype bpchar 1 Line Type
pa_report listsources bpchar 1 'N'::bpchar List Report Line Sources
pa_report listsourcesxtrx bpchar 1  √  'N'::bpchar Include source accounts with no transaction for list report line sources
pa_report listtrx bpchar 1 'N'::bpchar List the report transactions
pa_reportcolumn paamounttype bpchar 1  √  'B'::bpchar PA Amount Type for reporting
pa_reportline paamounttype bpchar 1  √  NULL::bpchar PA Amount Type for reporting
pa_reportcolumn paperiodtype bpchar 1  √  'P'::bpchar PA Period Type
pa_reportline paperiodtype bpchar 1  √  NULL::bpchar PA Period Type
fact_acct postingtype bpchar 1 The type of posted amount for the transaction
fact_acct_balance postingtype bpchar 1  √  null 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
pa_reportline postingtype bpchar 1  √  null The type of posted amount for the transaction
t_trialbalance postingtype bpchar 1 The type of posted amount for the transaction
ad_tree processing bpchar 1  √  null Process Now
pa_report processing bpchar 1 Process Now
pa_reportcolumnset processing bpchar 1 Process Now
pa_reportlineset processing bpchar 1 Process Now
pa_reportcolumn amounttype bpchar 2  √  null Type of amount to report
pa_reportline amounttype bpchar 2  √  null Type of amount to report
pa_reportcolumn elementtype bpchar 2  √  null Element Type (account or user defined)
pa_reportsource elementtype bpchar 2 Element Type (account or user defined)
ad_tree treetype bpchar 2 Element this tree is built on (i.e Product, Business Partner)
fact_acct_balance isactive bpchar 2147483647  √  null The record is active in the system
t_trialbalance amtacctbalance numeric 0 Accounted Balance Amount
fact_acct amtacctcr numeric 0 0 Accounted Credit Amount
fact_acct_balance amtacctcr numeric 0  √  null Accounted Credit Amount
fact_acct_summary amtacctcr numeric 0 Accounted Credit Amount
t_reportstatement amtacctcr numeric 0  √  0 Accounted Credit Amount
t_trialbalance amtacctcr numeric 0 Accounted Credit Amount
fact_acct amtacctdr numeric 0 0 Accounted Debit Amount
fact_acct_balance amtacctdr numeric 0  √  null Accounted Debit Amount
fact_acct_summary amtacctdr numeric 0 Accounted Debit Amount
t_reportstatement amtacctdr numeric 0  √  0 Accounted Debit Amount
t_trialbalance amtacctdr numeric 0 Accounted Debit Amount
t_trialbalance amtsourcebalance numeric 0  √  null Source Balance Amount
fact_acct amtsourcecr numeric 0 0 Source Credit Amount
t_trialbalance amtsourcecr numeric 0  √  null Source Credit Amount
fact_acct amtsourcedr numeric 0 0 Source Debit Amount
t_trialbalance amtsourcedr numeric 0  √  null Source Debit Amount
t_reportstatement balance numeric 0  √  0 Balance
fact_acct_balance c_projectphase_id numeric 0  √  null Phase of a Project
fact_acct_balance c_projecttask_id numeric 0  √  null Actual Project Task in a Phase
fact_acct_balance c_subacct_id numeric 0  √  null Sub account for Element Value
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
fact_acct_balance createdby numeric 0  √  null User who created this records
fact_acct qty numeric 0  √  0 Quantity
fact_acct_balance qty numeric 0  √  null Quantity
fact_acct_summary qty numeric 0 Quantity
t_reportstatement qty numeric 0  √  0 Quantity
t_trialbalance qty numeric 0  √  null Quantity
pa_reportcolumn relativeperiodto numeric 0  √  null Period offset (0 is current)
t_report seqno numeric 0  √  null Method of ordering records; lowest number comes first
fact_acct_balance updatedby numeric 0  √  null User who updated this records
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 account_id numeric 10 Account used
fact_acct_balance account_id numeric 10  √  null Account used
fact_acct_summary account_id numeric 10 Account used
t_trialbalance account_id numeric 10  √  null Account used
ad_pinstance ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_printformat ad_client_id numeric 10 Client/Tenant for this installation.
ad_tree ad_client_id numeric 10 Client/Tenant for this installation.
c_element ad_client_id numeric 10 Client/Tenant for this installation.
fact_acct ad_client_id numeric 10 Client/Tenant for this installation.
fact_acct_balance ad_client_id numeric 10  √  null Client/Tenant for this installation.
fact_acct_summary ad_client_id numeric 10 Client/Tenant for this installation.
pa_hierarchy ad_client_id numeric 10 Client/Tenant for this installation.
pa_report ad_client_id numeric 10 Client/Tenant for this installation.
pa_reportcolumn ad_client_id numeric 10 Client/Tenant for this installation.
pa_reportcolumnset ad_client_id numeric 10 Client/Tenant for this installation.
pa_reportline ad_client_id numeric 10 Client/Tenant for this installation.
pa_reportlineset ad_client_id numeric 10 Client/Tenant for this installation.
pa_reportsource ad_client_id numeric 10 Client/Tenant for this installation.
t_trialbalance ad_client_id numeric 10 Client/Tenant for this installation.
ad_pinstance ad_language_id numeric 10  √  NULL::numeric Language ID
ad_pinstance ad_org_id numeric 10  √  null Organizational entity within client
ad_printformat ad_org_id numeric 10 Organizational entity within client
ad_tree ad_org_id numeric 10 Organizational entity within client
c_element ad_org_id numeric 10 Organizational entity within client
fact_acct ad_org_id numeric 10 Organizational entity within client
fact_acct_balance ad_org_id numeric 10  √  null Organizational entity within client
fact_acct_summary ad_org_id numeric 10 Organizational entity within client
pa_hierarchy ad_org_id numeric 10 Organizational entity within client
pa_report ad_org_id numeric 10  √  null Organizational entity within client
pa_reportcolumn ad_org_id numeric 10 Organizational entity within client
pa_reportcolumnset ad_org_id numeric 10 Organizational entity within client
pa_reportline ad_org_id numeric 10 Organizational entity within client
pa_reportlineset ad_org_id numeric 10 Organizational entity within client
pa_reportsource ad_org_id numeric 10 Organizational entity within client
t_trialbalance ad_org_id numeric 10  √  null Organizational entity within client
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
fact_acct_summary ad_orgtrx_id numeric 10  √  NULL::numeric 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
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_pinstance ad_printformat_id numeric 10  √  NULL::numeric Data Print Format
ad_printformat ad_printformat_id numeric 10 Data Print Format
pa_report ad_printformat_id numeric 10  √  null Data Print Format
ad_printformat ad_printheaderfooter_id numeric 10  √  NULL::numeric Print Header/Footer
ad_printformat ad_printpaper_id numeric 10 Printer paper definition
ad_printformat ad_printtableformat_id numeric 10  √  null Table Format in Reports
ad_pinstance ad_process_id numeric 10 Process or Report
ad_printformat ad_reportview_id numeric 10  √  null View used to generate this report
ad_printformat ad_table_id numeric 10 Database Table information
ad_tree ad_table_id numeric 10  √  NULL::numeric Database Table information
fact_acct ad_table_id numeric 10 Database Table information
t_trialbalance ad_table_id numeric 10  √  null 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
c_element ad_tree_id numeric 10  √  null 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
ad_pinstance ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_printformat ad_window_id numeric 10  √  NULL::numeric Data entry or display window
fact_acct c_acctschema_id numeric 10 Rules for accounting
fact_acct_balance c_acctschema_id numeric 10  √  null 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
fact_acct c_activity_id numeric 10  √  null Business Activity
fact_acct_balance c_activity_id numeric 10  √  null Business Activity
fact_acct_summary c_activity_id numeric 10  √  NULL::numeric 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
fact_acct_summary c_bpartner_id numeric 10  √  NULL::numeric 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
pa_report c_calendar_id numeric 10 Accounting Calendar Name
fact_acct c_campaign_id numeric 10  √  null Marketing Campaign
fact_acct_balance c_campaign_id numeric 10  √  null Marketing Campaign
fact_acct_summary c_campaign_id numeric 10  √  NULL::numeric 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
fact_acct c_currency_id numeric 10 The Currency for this record
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
c_element c_element_id numeric 10 Accounting Element
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
fact_acct_summary c_locfrom_id numeric 10  √  NULL::numeric 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
fact_acct_summary c_locto_id numeric 10  √  NULL::numeric 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
fact_acct_summary c_period_id numeric 10 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
fact_acct_summary c_project_id numeric 10  √  NULL::numeric 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_summary c_projectphase_id numeric 10  √  NULL::numeric Phase of a Project
fact_acct c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
fact_acct_summary c_projecttask_id numeric 10  √  NULL::numeric 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
fact_acct_summary c_salesregion_id numeric 10  √  NULL::numeric 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_summary c_subacct_id numeric 10  √  NULL::numeric 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
ad_pinstance createdby numeric 10  √  null User who created this records
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 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
fact_acct gl_budget_id numeric 10  √  null General Ledger Budget
fact_acct_balance gl_budget_id numeric 10  √  null General Ledger Budget
fact_acct_summary gl_budget_id numeric 10  √  NULL::numeric 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
ad_printformat headermargin numeric 10 Margin of the Header in 1/72 of an inch
ad_printformat jasperprocess_id numeric 10  √  null The Jasper Process used by the printengine if any process defined
pa_report jasperprocess_id numeric 10  √  null The Jasper Process used by the printengine if any process defined
t_report levelno numeric 10  √  0 Level no
t_reportstatement levelno numeric 10 Level no
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
fact_acct_summary m_product_id numeric 10  √  NULL::numeric 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 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 client
pa_reportsource org_id numeric 10  √  null Organizational entity within client
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_report pa_reportcube_id numeric 10  √  NULL::numeric 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
ad_tree parent_column_id numeric 10  √  NULL::numeric The link column on the parent tab.
pa_reportline parent_id numeric 10  √  null Parent of Entity
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
t_trialbalance record_id numeric 10  √  null Direct internal record ID
pa_reportcolumn relativeperiod numeric 10  √  null Period offset (0 is current)
ad_pinstance result numeric 10  √  null Result of the action taken
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_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
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
fact_acct_summary user1_id numeric 10  √  NULL::numeric 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
fact_acct_summary user2_id numeric 10  √  NULL::numeric 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
fact_acct_summary userelement1_id numeric 10  √  NULL::numeric 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
fact_acct_summary userelement2_id numeric 10  √  NULL::numeric 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
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
fact_acct_balance created timestamp 29,6  √  null Date this record was created
fact_acct_summary created timestamp 29,6 statement_timestamp() 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
t_trialbalance created timestamp 29,6 statement_timestamp() Date this record was created
fact_acct dateacct timestamp 29,6 Accounting Date
fact_acct_balance dateacct timestamp 29,6  √  null Accounting Date
fact_acct_summary dateacct timestamp 29,6  √  null 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
t_trialbalance datetrx timestamp 29,6  √  null Transaction Date
ad_pinstance updated timestamp 29,6 statement_timestamp() Date this record was updated
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
fact_acct_balance updated timestamp 29,6  √  null Date this record was updated
fact_acct_summary updated timestamp 29,6 statement_timestamp() 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
t_trialbalance updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_pinstance notificationtype varchar 2  √  NULL::character varying Type of Notifications
pa_reportline overlinestroketype varchar 3  √  NULL::character varying Overline Stroke Type
pa_reportline underlinestroketype varchar 3  √  NULL::character varying Underline Stroke Type
ad_pinstance reporttype varchar 5  √  NULL::character varying Report Type
pa_reportcolumn formatpattern varchar 22  √  null The pattern used to format a number or date.
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
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
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 accountvalue varchar 40  √  null Key of Account Element
ad_printformat printername varchar 40  √  null Name of the Printer
c_element vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_pinstance name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
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 60 Alphanumeric identifier of the entity
pa_reportcolumnset name varchar 60 Alphanumeric identifier of the entity
pa_reportline name varchar 60 Alphanumeric identifier of the entity
pa_reportlineset name varchar 60 Alphanumeric identifier of the entity
t_report name varchar 60  √  null Alphanumeric identifier of the entity
t_reportstatement name varchar 60  √  null Alphanumeric identifier of the entity
ad_printformat classname varchar 240  √  null Java Classname
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
ad_printformat args varchar 510  √  null Args
pa_reportcolumn oper_2_linename varchar 512  √  NULL::character varying Name of the financial report line to take values from
ad_pinstance errormsg varchar 2000  √  null Error Msg
pa_hierarchy help varchar 2000  √  null Comment or Hint