SchemaSpy Analysis of idempiere11.adempiere - ColumnsAccounting Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:45 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 528 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_table accesslevel bpchar 1 Access Level required
c_elementvalue accountsign bpchar 1 Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue accounttype bpchar 1 Indicates the type of account
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
c_elementvalue bpartnertype bpchar 1  √  NULL::bpchar Business Partner Type
gl_budget budgetstatus bpchar 1  √  null Indicates the current status of this budget
gl_category categorytype bpchar 1 Source of the Journal with this category
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
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
ad_table createpartition bpchar 1  √  NULL::bpchar Process which create or update table partitions based on the table and column records
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
c_element elementtype bpchar 1 Element Type (account or user defined)
c_acctschema hasalias bpchar 1 'Y'::bpchar Ability to select (partial) account combinations by an Alias
c_acctschema hascombination bpchar 1 'Y'::bpchar Combination of account elements are checked
ad_table importtable bpchar 1  √  null Import Table Columns from Database
c_acctschema isaccrual bpchar 1 'Y'::bpchar Indicates if Accrual or Cash Based accounting will be used
a_asset isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_clientinfo 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_table isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctschema isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctschema_element isactive bpchar 1 'Y'::bpchar The record is active in the system
c_calendar isactive bpchar 1 'Y'::bpchar The record is active in the system
c_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_period isactive bpchar 1 'Y'::bpchar The record is active in the system
c_subacct 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_validcombination isactive bpchar 1 'Y'::bpchar The record is active in the system
c_year isactive bpchar 1 'Y'::bpchar The record is active in the system
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
fact_reconciliation 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
c_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
c_acctschema_element isbalanced bpchar 1 'N'::bpchar Balanced
c_element isbalancing bpchar 1 'N'::bpchar All transactions within an element value must balance (e.g. cost centers)
c_elementvalue isbankaccount bpchar 1  √  'N'::bpchar Indicates if this is the Bank Account
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar Show Confirmation On Document Action Close
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar Show Confirmation On Document Action Void
c_tax isdefault bpchar 1 'N'::bpchar Default value
gl_category isdefault bpchar 1 'N'::bpchar Default value
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
a_asset isdepreciated bpchar 1 'Y'::bpchar The asset will be depreciated
c_elementvalue isdetailbpartner bpchar 1 'N'::bpchar Manage Business Partners
c_elementvalue isdetailproduct bpchar 1 'N'::bpchar Manage Products
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar Correct the tax for payment discount and charges
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar Payment Discount calculation does not include Taxes and Charges
a_asset isdisposed bpchar 1 'N'::bpchar The asset is disposed
c_elementvalue isdoccontrolled bpchar 1  √  'N'::bpchar Control account - If an account is controlled by a document, you cannot post manually to it
c_tax isdocumentlevel bpchar 1 'Y'::bpchar Tax is calculated on document level (rather than line by line)
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar Post the cost adjustment explicitly
c_elementvalue isforeigncurrency bpchar 1  √  'N'::bpchar Balances in foreign currency accounts are held in the nominated currency
a_asset isfullydepreciated bpchar 1 'N'::bpchar The asset is fully depreciated
c_validcombination isfullyqualified bpchar 1 'Y'::bpchar This account is fully qualified
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
a_asset isinposession bpchar 1 'Y'::bpchar The asset is in the possession of the organization
c_acctschema_element ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
c_element isnaturalaccount bpchar 1 'Y'::bpchar The primary natural account
a_asset isowned bpchar 1 'Y'::bpchar The asset is owned by the organization
ad_table ispartition bpchar 1 'N'::bpchar This is a partitioned table
c_acctschema ispostifclearingequal bpchar 1  √  'Y'::bpchar This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema ispostservices bpchar 1 'N'::bpchar Differentiate between Services and Product Receivable/Payables
gl_budget isprimary bpchar 1 'Y'::bpchar Indicates if this is the primary budget
c_tax issalestax bpchar 1 'N'::bpchar This is a sales tax (i.e. not a value added tax)
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
ad_table isshowindrilloptions bpchar 1  √  'Y'::bpchar This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_org issummary bpchar 1 'N'::bpchar This is a summary entity
c_elementvalue issummary bpchar 1 'N'::bpchar This is a summary entity
c_tax issummary bpchar 1 'N'::bpchar This is a summary entity
c_tax istaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on sales
c_acctschema istradediscountposted bpchar 1 'N'::bpchar Generate postings for trade discounts
ad_table isview bpchar 1 'N'::bpchar This is a view
c_period periodtype bpchar 1 Period Type
c_elementvalue postactual bpchar 1 'Y'::bpchar Actual Values can be posted
c_elementvalue postbudget bpchar 1 'Y'::bpchar Budget values can be posted
c_elementvalue postencumbrance bpchar 1 'Y'::bpchar Post commitments to this account
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
c_elementvalue poststatistical bpchar 1 'Y'::bpchar Post statistical quantities to this account?
a_asset processed bpchar 1 'N'::bpchar The document has been processed
a_asset processing bpchar 1  √  'N'::bpchar Process Now
ad_table processing bpchar 1  √  NULL::bpchar Process Now
c_acctschema processing bpchar 1  √  null Process Now
c_period processing bpchar 1  √  null Process Now
c_year processing bpchar 1  √  null Process Now
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
c_tax requirestaxcertificate bpchar 1 'N'::bpchar This tax rate requires the Business Partner to be tax exempt
c_acctschema separator bpchar 1 Element Separator
c_tax sopotype bpchar 1 'B'::bpchar Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
c_tax taxpostingindicator bpchar 1  √  '0'::bpchar Type of input tax (deductible and non deductible)
c_acctschema_element elementtype bpchar 2 Element Type (account or user defined)
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
gl_category docbasetype bpchar 3  √  null Logical type of document
fact_acct_balance isactive bpchar 2147483647  √  null The record is active in the system
a_asset a_qty_current numeric 0  √  null Current Qty
a_asset a_qty_original numeric 0  √  null A_QTY_Original
ad_org ad_replicationstrategy_id numeric 0  √  null Data Replication Strategy
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
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
fact_acct amtsourcecr numeric 0 0 Source Credit Amount
fact_acct amtsourcedr numeric 0 0 Source Debit Amount
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
fact_acct_balance createdby numeric 0  √  null User who created this records
a_asset lifeuseunits numeric 0  √  null Units of use until the asset is not usable anymore
a_asset qty numeric 0  √  null Quantity
fact_acct qty numeric 0  √  0 Quantity
fact_acct_balance qty numeric 0  √  null Quantity
fact_acct_summary qty numeric 0 Quantity
c_tax rate numeric 0 Rate or Tax or Exchange
fact_acct_balance updatedby numeric 0  √  null User who updated this records
a_asset uselifeyears numeric 0  √  null Years of the usable life of the asset
a_asset useunits numeric 0  √  null Currently used units of the assets
a_asset a_asset_class_id numeric 10  √  NULL::numeric Asset class
a_asset a_asset_group_id numeric 10 Group of Assets
a_asset a_asset_id numeric 10 Asset used internally or by customers
fact_acct a_asset_id numeric 10  √  null Asset used internally or by customers
a_asset a_asset_type_id numeric 10  √  null Asset Type
a_asset a_parent_asset_id numeric 10  √  null Parent Asset
c_validcombination account_id numeric 10 Account used
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
a_asset ad_client_id numeric 10 Tenant for this installation.
ad_clientinfo ad_client_id numeric 10 Tenant for this installation.
ad_org ad_client_id numeric 10 Tenant for this installation.
ad_table ad_client_id numeric 10 Tenant for this installation.
c_acctschema ad_client_id numeric 10 Tenant for this installation.
c_acctschema_element ad_client_id numeric 10 Tenant for this installation.
c_calendar 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_period ad_client_id numeric 10 Tenant for this installation.
c_subacct ad_client_id numeric 10 Tenant for this installation.
c_tax ad_client_id numeric 10 Tenant for this installation.
c_validcombination ad_client_id numeric 10 Tenant for this installation.
c_year ad_client_id numeric 10 Tenant for this installation.
fact_acct ad_client_id numeric 10 Tenant for this installation.
fact_acct_balance ad_client_id numeric 10  √  null Tenant for this installation.
fact_acct_summary ad_client_id numeric 10 Tenant for this installation.
fact_reconciliation 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.
c_acctschema_element ad_column_id numeric 10  √  null Column in the table
a_asset ad_org_id numeric 10 Organizational entity within tenant
ad_clientinfo ad_org_id numeric 10 Organizational entity within tenant
ad_org ad_org_id numeric 10 Organizational entity within tenant
ad_table ad_org_id numeric 10 Organizational entity within tenant
c_acctschema ad_org_id numeric 10 Organizational entity within tenant
c_acctschema_element ad_org_id numeric 10 Organizational entity within tenant
c_calendar 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_period ad_org_id numeric 10 Organizational entity within tenant
c_subacct ad_org_id numeric 10 Organizational entity within tenant
c_tax ad_org_id numeric 10 Organizational entity within tenant
c_validcombination ad_org_id numeric 10 Organizational entity within tenant
c_year ad_org_id numeric 10 Organizational entity within tenant
fact_acct ad_org_id numeric 10 Organizational entity within tenant
fact_acct_balance ad_org_id numeric 10  √  null Organizational entity within tenant
fact_acct_summary ad_org_id numeric 10 Organizational entity within tenant
fact_reconciliation 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
c_acctschema ad_orgonly_id numeric 10  √  null Create posting entries only for this organization
c_validcombination ad_orgtrx_id numeric 10  √  null Performing or initiating organization
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
c_tax ad_rule_id numeric 10  √  null Rule
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_table ad_table_id numeric 10 Database Table information
fact_acct ad_table_id numeric 10 Database Table information
ad_clientinfo ad_tree_activity_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_campaign_id numeric 10  √  null Trees are used for (financial) reporting
c_element ad_tree_id numeric 10  √  null Identifies a Tree
ad_clientinfo ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_clientinfo ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_clientinfo ad_tree_product_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_project_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null Trees are used for (financial) reporting
a_asset ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_clientinfo c_acctschema1_id numeric 10  √  null Primary rules for accounting
c_acctschema_element c_acctschema_element_id numeric 10 Acct.Schema Element
c_acctschema c_acctschema_id numeric 10 Rules for accounting
c_acctschema_element c_acctschema_id numeric 10 Rules for accounting
c_validcombination c_acctschema_id numeric 10 Rules for accounting
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
a_asset c_activity_id numeric 10  √  NULL::numeric Business Activity
c_acctschema_element c_activity_id numeric 10  √  null Business Activity
c_validcombination c_activity_id numeric 10  √  null Business Activity
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
c_elementvalue c_bankaccount_id numeric 10  √  null Account at the Bank
a_asset c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_acctschema_element c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_validcombination c_bpartner_id numeric 10  √  null Identifies a Business Partner
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
a_asset c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null Business Partner used for creating new Business Partners on the fly
a_asset c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
ad_clientinfo c_calendar_id numeric 10  √  null Accounting Calendar Name
c_calendar c_calendar_id numeric 10 Accounting Calendar Name
c_year c_calendar_id numeric 10 Accounting Calendar Name
c_acctschema_element c_campaign_id numeric 10  √  null Marketing Campaign
c_validcombination c_campaign_id numeric 10  √  null Marketing Campaign
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
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric Charge for Freight
c_tax c_country_id numeric 10  √  null Country
c_tax c_countrygroupfrom_id numeric 10  √  NULL::numeric Country Group From
c_tax c_countrygroupto_id numeric 10  √  NULL::numeric Country Group To
c_acctschema c_currency_id numeric 10 The Currency for this record
c_elementvalue c_currency_id numeric 10  √  null The Currency for this record
fact_acct c_currency_id numeric 10 The Currency for this record
c_acctschema_element c_element_id numeric 10  √  null Accounting Element
c_element c_element_id numeric 10 Accounting Element
c_elementvalue c_element_id numeric 10 Accounting Element
c_acctschema_element c_elementvalue_id numeric 10  √  null Account Element
c_elementvalue c_elementvalue_id numeric 10 Account Element
c_subacct c_elementvalue_id numeric 10 Account Element
a_asset c_location_id numeric 10  √  null Location or Address
c_acctschema_element c_location_id numeric 10  √  null Location or Address
c_validcombination c_locfrom_id numeric 10  √  null Location that inventory was moved from
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
c_validcombination c_locto_id numeric 10  √  null Location that inventory was moved to
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
c_acctschema c_period_id numeric 10  √  null Period of the Calendar
c_period c_period_id numeric 10 Period of the Calendar
fact_acct c_period_id numeric 10  √  null Period of the Calendar
fact_acct_summary c_period_id numeric 10 Period of the Calendar
a_asset c_project_id numeric 10  √  null Financial Project
c_acctschema_element c_project_id numeric 10  √  null Financial Project
c_validcombination c_project_id numeric 10  √  null Financial Project
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
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
c_tax c_region_id numeric 10  √  null Identifies a geographical Region
c_acctschema_element c_salesregion_id numeric 10  √  null Sales coverage region
c_validcombination c_salesregion_id numeric 10  √  null Sales coverage region
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
c_subacct c_subacct_id numeric 10 Sub account for Element Value
c_validcombination c_subacct_id numeric 10  √  null Sub account for Element Value
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
c_tax c_tax_id numeric 10 Tax identifier
fact_acct c_tax_id numeric 10  √  null Tax identifier
c_tax c_taxcategory_id numeric 10 Tax Category
c_tax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
fact_acct c_uom_id numeric 10  √  null Unit of Measure
ad_clientinfo c_uom_length_id numeric 10  √  null Standard Unit of Measure for Length
ad_clientinfo c_uom_time_id numeric 10  √  null Standard Unit of Measure for Time
ad_clientinfo c_uom_volume_id numeric 10  √  null Standard Unit of Measure for Volume
ad_clientinfo c_uom_weight_id numeric 10  √  null Standard Unit of Measure for Weight
c_validcombination c_validcombination_id numeric 10 Valid Account Combination
c_period c_year_id numeric 10 Calendar Year
c_year c_year_id numeric 10 Calendar Year
a_asset createdby numeric 10 User who created this records
ad_clientinfo createdby numeric 10 User who created this records
ad_org createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
c_acctschema createdby numeric 10 User who created this records
c_acctschema_element createdby numeric 10 User who created this records
c_calendar 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_period createdby numeric 10 User who created this records
c_subacct createdby numeric 10 User who created this records
c_tax createdby numeric 10 User who created this records
c_validcombination createdby numeric 10 User who created this records
c_year 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
fact_reconciliation 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
fact_acct fact_acct_id numeric 10 Accounting Fact
fact_reconciliation fact_acct_id numeric 10 Accounting Fact
fact_reconciliation fact_reconciliation_id numeric 10 Accounting Fact Reconciliation
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
gl_budget gl_budget_id numeric 10 General Ledger Budget
fact_acct gl_category_id numeric 10  √  null General Ledger Category
gl_category gl_category_id numeric 10 General Ledger Category
ad_clientinfo keeplogdays numeric 10  √  null Number of days to keep the log entries
a_asset lastmaintenanceunit numeric 10  √  null Last Maintenance Unit
a_asset lastmaintenanceuseunit numeric 10  √  null
a_asset lease_bpartner_id numeric 10  √  null The Business Partner who rents or leases
fact_acct line_id numeric 10  √  null Transaction line ID (internal)
ad_table loadseq numeric 10  √  null Sequence
ad_clientinfo logo_id numeric 10  √  NULL::numeric Logo
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric Logo Report
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric Logo Web
a_asset m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_acctschema m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
a_asset m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
a_asset m_locator_id numeric 10  √  null Warehouse Locator
fact_acct m_locator_id numeric 10  √  null Warehouse Locator
a_asset m_product_id numeric 10 Product, Service, Item
c_acctschema_element m_product_id numeric 10  √  null Product, Service, Item
c_validcombination m_product_id numeric 10  √  null Product, Service, Item
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
ad_clientinfo m_productfreight_id numeric 10  √  null Product for Freight
a_asset manufacturedyear numeric 10  √  NULL::numeric Manufactured Year
a_asset nextmaintenanceuseunit numeric 10  √  null
a_asset nextmaintenenceunit numeric 10  √  null Next Maintenence Unit
c_acctschema_element org_id numeric 10  √  null Organizational entity within tenant
fact_acct_summary pa_reportcube_id numeric 10 Define reporting cube for pre-calculation of summary accounting data.
c_tax parent_tax_id numeric 10  √  null Parent Tax indicates a tax that is made up of multiple taxes
c_acctschema period_openfuture numeric 10  √  null Number of days to be able to post to a future date (based on system date)
c_acctschema period_openhistory numeric 10  √  null Number of days to be able to post in the past (based on system date)
c_period periodno numeric 10 Unique Period Number
ad_table po_window_id numeric 10  √  null Purchase Order Window
fact_acct record_id numeric 10 Direct internal record ID
c_acctschema_element seqno numeric 10 Method of ordering records; lowest number comes first
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric Archive Store
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric Storage provider for Image
c_tax to_country_id numeric 10  √  null Receiving Country
c_tax to_region_id numeric 10  √  null Receiving Region
a_asset updatedby numeric 10 User who updated this records
ad_clientinfo updatedby numeric 10 User who updated this records
ad_org updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
c_acctschema updatedby numeric 10 User who updated this records
c_acctschema_element updatedby numeric 10 User who updated this records
c_calendar 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_period updatedby numeric 10 User who updated this records
c_subacct updatedby numeric 10 User who updated this records
c_tax updatedby numeric 10 User who updated this records
c_validcombination updatedby numeric 10 User who updated this records
c_year 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
fact_reconciliation 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
a_asset uselifemonths numeric 10  √  null Months of the usable life of the asset
c_validcombination user1_id numeric 10  √  null User defined list element #1
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
c_validcombination user2_id numeric 10  √  null User defined list element #2
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
c_validcombination userelement1_id numeric 10  √  null User defined accounting Element
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
c_validcombination userelement2_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
a_asset a_asset_createdate timestamp 29,6  √  null Create Date
a_asset a_asset_revaldate timestamp 29,6  √  null Revaluation Date
a_asset assetactivationdate timestamp 29,6  √  null Activation Date
a_asset assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
a_asset assetdisposaldate timestamp 29,6  √  null Date when the asset is/was disposed
a_asset assetservicedate timestamp 29,6  √  null Date when Asset was put into service
a_asset created timestamp 29,6 now() Date this record was created
ad_clientinfo created timestamp 29,6 now() Date this record was created
ad_org created timestamp 29,6 now() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
c_acctschema created timestamp 29,6 now() Date this record was created
c_acctschema_element created timestamp 29,6 now() Date this record was created
c_calendar 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_period created timestamp 29,6 now() Date this record was created
c_subacct created timestamp 29,6 now() Date this record was created
c_tax created timestamp 29,6 now() Date this record was created
c_validcombination created timestamp 29,6 now() Date this record was created
c_year 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
fact_reconciliation 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
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
fact_acct datetrx timestamp 29,6 Transaction Date
c_period enddate timestamp 29,6  √  null Last effective date (inclusive)
ad_clientinfo fy_startdate timestamp 29,6  √  null Financial Year Start Date
a_asset guaranteedate timestamp 29,6  √  null Date when guarantee expires
a_asset lastmaintenancedate timestamp 29,6  √  null Last Maintenance Date
a_asset lastmaintenencedate timestamp 29,6  √  null
a_asset leaseterminationdate timestamp 29,6  √  null Lease Termination Date
a_asset nextmaintenencedate timestamp 29,6  √  null Next Maintenance Date
c_period startdate timestamp 29,6 First effective day (inclusive)
a_asset updated timestamp 29,6 now() Date this record was updated
ad_clientinfo updated timestamp 29,6 now() Date this record was updated
ad_org updated timestamp 29,6 now() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
c_acctschema updated timestamp 29,6 now() Date this record was updated
c_acctschema_element updated timestamp 29,6 now() Date this record was updated
c_calendar 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_period updated timestamp 29,6 now() Date this record was updated
c_subacct updated timestamp 29,6 now() Date this record was updated
c_tax updated timestamp 29,6 now() Date this record was updated
c_validcombination updated timestamp 29,6 now() Date this record was updated
c_year 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
fact_reconciliation 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
c_elementvalue validfrom timestamp 29,6  √  null Valid from including this date (first day)
c_tax validfrom timestamp 29,6 Valid from including this date (first day)
c_elementvalue validto timestamp 29,6  √  null Valid to including this date (last day)
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
a_asset a_asset_action varchar 2 'MD'::character varying Asset Action
a_asset a_asset_status varchar 2 'NW'::character varying Asset Status
a_asset a_assettype varchar 3 'MFX'::character varying Asset Type
c_year fiscalyear varchar 10 The Fiscal Year
c_tax taxindicator varchar 10  √  null Short form for Tax to be printed on documents
a_asset versionno varchar 20  √  null Version Number
a_asset inventoryno varchar 30  √  NULL::character varying Inventory No
a_asset manufacturer varchar 30  √  NULL::character varying Manufacturer of the Product
a_asset a_asset_uu varchar 36  √  NULL::character varying A_Asset_UU
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying AD_ClientInfo_UU
ad_org ad_org_uu varchar 36  √  NULL::character varying AD_Org_UU
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
c_acctschema_element c_acctschema_element_uu varchar 36  √  NULL::character varying C_AcctSchema_Element_UU
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying C_AcctSchema_UU
c_calendar c_calendar_uu varchar 36  √  NULL::character varying C_Calendar_UU
c_element c_element_uu varchar 36  √  NULL::character varying C_Element_UU
c_elementvalue c_elementvalue_uu varchar 36  √  NULL::character varying C_ElementValue_UU
c_period c_period_uu varchar 36  √  NULL::character varying C_Period_UU
c_subacct c_subacct_uu varchar 36  √  NULL::character varying C_SubAcct_UU
c_tax c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_validcombination c_validcombination_uu varchar 36  √  NULL::character varying C_ValidCombination_UU
c_year c_year_uu varchar 36  √  NULL::character varying C_Year_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
fact_reconciliation fact_reconciliation_uu varchar 36  √  NULL::character varying Fact_Reconciliation_UU
gl_budget gl_budget_uu varchar 36  √  NULL::character varying GL_Budget_UU
gl_category gl_category_uu varchar 36  √  NULL::character varying GL_Category_UU
c_validcombination alias varchar 40  √  null Defines an alternate method of indicating an account combination.
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table tablename varchar 40 Name of the table in the database
a_asset value varchar 40 Search key for the record in the format required - must be unique
ad_org 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_subacct value varchar 40 Search key for the record in the format required - must be unique
c_element vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_validcombination combination varchar 60  √  null Unique combination of account elements
a_asset lastmaintenancenote varchar 60  √  null Last Maintenance Note
fact_reconciliation matchcode varchar 60  √  NULL::character varying String identifying related accounting facts
a_asset name varchar 60 Alphanumeric identifier of the entity
ad_org name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
c_acctschema name varchar 60 Alphanumeric identifier of the entity
c_acctschema_element name varchar 60 Alphanumeric identifier of the entity
c_calendar name varchar 60 Alphanumeric identifier of the entity
c_element name varchar 60 Alphanumeric identifier of the entity
c_period name varchar 60 Alphanumeric identifier of the entity
c_subacct name varchar 60 Alphanumeric identifier of the entity
c_tax 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
gl_category printname varchar 60  √  NULL::character varying The label text to be printed on a document or correspondence.
ad_clientinfo timezone varchar 60  √  NULL::character varying Time zone name
gl_category value varchar 60 NULL::character varying Search key for the record in the format required - must be unique
c_elementvalue name varchar 120 Alphanumeric identifier of the entity
a_asset description varchar 255  √  null Optional short description of the record
ad_org description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
c_acctschema description varchar 255  √  null Optional short description of the record
c_calendar 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_subacct description varchar 255  √  null Optional short description of the record
c_tax description varchar 255  √  null Optional short description of the record
c_validcombination description varchar 255  √  null Optional short description of the record
c_year description varchar 255  √  null Optional short description of the record
fact_acct 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
a_asset locationcomment varchar 255  √  null Additional comments or remarks concerning the location
a_asset lot varchar 255  √  null Lot number (alphanumeric)
a_asset serno varchar 255  √  null Product Serial Number
a_asset help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
c_subacct help varchar 2000  √  null Comment or Hint