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

idempiere9.adempiere contains 393 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
rv_fact_acct amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
rv_fact_acct_day amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
rv_fact_acct_period amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
rv_fact_simple amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
gl_journalline amtacctcr numeric 0 0 Accounted Credit Amount
rv_fact_acct amtacctcr numeric 0  √  null Accounted Credit Amount
rv_fact_acct_day amtacctcr numeric 0  √  null Accounted Credit Amount
rv_fact_acct_period amtacctcr numeric 0  √  null Accounted Credit Amount
gl_journalline amtacctdr numeric 0 0 Accounted Debit Amount
rv_fact_acct amtacctdr numeric 0  √  null Accounted Debit Amount
rv_fact_acct_day amtacctdr numeric 0  √  null Accounted Debit Amount
rv_fact_acct_period amtacctdr numeric 0  √  null Accounted Debit Amount
rv_fact_acct amtsource numeric 0  √  null Amount Balance in Source Currency
rv_fact_acct_day amtsource numeric 0  √  null Amount Balance in Source Currency
rv_fact_acct_period amtsource numeric 0  √  null Amount Balance in Source Currency
gl_journalline amtsourcecr numeric 0 0 Source Credit Amount
rv_fact_acct amtsourcecr numeric 0  √  null Source Credit Amount
rv_fact_acct_day amtsourcecr numeric 0  √  null Source Credit Amount
rv_fact_acct_period amtsourcecr numeric 0  √  null Source Credit Amount
gl_journalline amtsourcedr numeric 0 0 Source Debit Amount
rv_fact_acct amtsourcedr numeric 0  √  null Source Debit Amount
rv_fact_acct_day amtsourcedr numeric 0  √  null Source Debit Amount
rv_fact_acct_period amtsourcedr numeric 0  √  null Source Debit Amount
rv_fact_acct c_bp_acqusitioncost numeric 0  √  null c_bp_acqusitioncost
rv_fact_acct c_bp_actuallifetimevalue numeric 0  √  null c_bp_actuallifetimevalue
rv_fact_acct c_bp_flatdiscount numeric 0  √  null c_bp_flatdiscount
rv_fact_acct c_bp_potentiallifetimevalue numeric 0  √  null c_bp_potentiallifetimevalue
rv_fact_acct c_bp_so_creditlimit numeric 0  √  null c_bp_so_creditlimit
rv_fact_acct c_bp_so_creditused numeric 0  √  null c_bp_so_creditused
rv_fact_acct c_bp_totalopenbalance numeric 0  √  null c_bp_totalopenbalance
gl_journal controlamt numeric 0  √  0 If not zero, the Debit amount of the document must be equal this amount
gl_journalbatch controlamt numeric 0  √  0 If not zero, the Debit amount of the document must be equal this amount
gl_journal currencyrate numeric 0 0 Currency Conversion Rate
gl_journalline currencyrate numeric 0 0 Currency Conversion Rate
gl_journal processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
rv_unposted processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
gl_journalline qty numeric 0  √  0 Quantity
rv_fact_acct qty numeric 0  √  null Quantity
rv_fact_acct rate numeric 0  √  null Rate or Tax or Exchange
rv_fact_acct_day rate numeric 0  √  null Rate or Tax or Exchange
rv_fact_acct_period rate numeric 0  √  null Rate or Tax or Exchange
rv_fact_acct shelfheight numeric 0  √  null Shelf height required
gl_journal totalcr numeric 0 0 Total Credit in document currency
gl_journalbatch totalcr numeric 0 0 Total Credit in document currency
gl_journal totaldr numeric 0 0 Total debit in document currency
gl_journalbatch totaldr numeric 0 0 Total debit in document currency
rv_fact_acct unitsperpallet numeric 0  √  null Units Per Pallet
rv_fact_acct volume numeric 0  √  null Volume of a product
rv_fact_acct weight numeric 0  √  null Weight of a product
gl_journalline a_createasset bpchar 1  √  'N'::bpchar Create Asset
gl_journalline a_processed bpchar 1  √  'N'::bpchar Processed
rv_fact_acct accounttype bpchar 1  √  null Indicates the type of account
rv_fact_simple accounttype bpchar 1  √  null Indicates the type of account
rv_fact_acct ad_org_isactive bpchar 1  √  null ad_org_isactive
rv_fact_acct c_bp_deliveryrule bpchar 1  √  null c_bp_deliveryrule
rv_fact_acct c_bp_deliveryviarule bpchar 1  √  null c_bp_deliveryviarule
rv_fact_acct c_bp_freightcostrule bpchar 1  √  null c_bp_freightcostrule
rv_fact_acct c_bp_invoicerule bpchar 1  √  null c_bp_invoicerule
rv_fact_acct c_bp_isactive bpchar 1  √  null c_bp_isactive
rv_fact_acct c_bp_iscustomer bpchar 1  √  null c_bp_iscustomer
rv_fact_acct c_bp_isdiscountprinted bpchar 1  √  null c_bp_isdiscountprinted
rv_fact_acct c_bp_isemployee bpchar 1  √  null c_bp_isemployee
rv_fact_acct c_bp_ismanufacturer bpchar 1  √  null c_bp_ismanufacturer
rv_fact_acct c_bp_isonetime bpchar 1  √  null c_bp_isonetime
rv_fact_acct c_bp_ispotaxexempt bpchar 1  √  null c_bp_ispotaxexempt
rv_fact_acct c_bp_isprospect bpchar 1  √  null c_bp_isprospect
rv_fact_acct c_bp_issalesrep bpchar 1  √  null c_bp_issalesrep
rv_fact_acct c_bp_issummary bpchar 1  √  null c_bp_issummary
rv_fact_acct c_bp_istaxexempt bpchar 1  √  null c_bp_istaxexempt
rv_fact_acct c_bp_isvendor bpchar 1  √  null c_bp_isvendor
rv_fact_acct c_bp_paymentrule bpchar 1  √  null c_bp_paymentrule
rv_fact_acct c_bp_paymentrulepo bpchar 1  √  null c_bp_paymentrulepo
rv_fact_acct c_bp_rating bpchar 1  √  null c_bp_rating
rv_fact_acct c_bp_sendemail bpchar 1  √  null c_bp_sendemail
rv_fact_acct c_bp_socreditstatus bpchar 1  √  null c_bp_socreditstatus
rv_fact_acct c_elementvalue_isactive bpchar 1  √  null c_elementvalue_isactive
rv_fact_acct c_elementvalue_issummary bpchar 1  √  null c_elementvalue_issummary
gl_journal copyfrom bpchar 1  √  NULL::bpchar Copy From Record
gl_journalbatch copyfrom bpchar 1  √  null Copy From Record
rv_fact_acct discontinued bpchar 1  √  null This product is no longer available
gl_journal isactive bpchar 1 'Y'::bpchar The record is active in the system
gl_journalbatch isactive bpchar 1 'Y'::bpchar The record is active in the system
gl_journalline isactive bpchar 1 'Y'::bpchar The record is active in the system
rv_fact_acct isactive bpchar 1  √  null The record is active in the system
rv_fact_simple isactive bpchar 1  √  null The record is active in the system
rv_unposted isactive bpchar 1  √  null The record is active in the system
gl_journal isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
gl_journalbatch isapproved bpchar 1  √  null Indicates if this document requires approval
rv_fact_acct isbankaccount bpchar 1  √  null Indicates if this is the Bank Account
rv_fact_acct isdropship bpchar 1  √  null Drop Shipments are sent directly to the Drop Shipment Location
rv_fact_acct isexcludeautodelivery bpchar 1  √  null Exclude from automatic Delivery
rv_fact_acct isforeigncurrency bpchar 1  √  null Balances in foreign currency accounts are held in the nominated currency
gl_journalline isgenerated bpchar 1 'N'::bpchar This Line is generated
rv_fact_acct isinvoiceprintdetails bpchar 1  √  null Print detail BOM elements on the invoice
rv_fact_acct ispicklistprintdetails bpchar 1  √  null Print detail BOM elements on the pick list
gl_journal isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
rv_fact_acct ispurchased bpchar 1  √  null Organization purchases this product
rv_fact_acct isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
rv_fact_acct issold bpchar 1  √  null Organization sells this product
rv_fact_acct isstocked bpchar 1  √  null Organization stocks this product
rv_fact_acct isverified bpchar 1  √  null The BOM configuration has been verified
rv_fact_acct iswebstorefeatured bpchar 1  √  null If selected, the product is displayed in the initial or any empty search
rv_fact_acct m_product_copyfrom bpchar 1  √  null m_product_copyfrom
rv_fact_acct m_product_isactive bpchar 1  √  null m_product_isactive
rv_fact_acct m_product_issummary bpchar 1  √  null m_product_issummary
rv_fact_acct m_product_processing bpchar 1  √  null m_product_processing
gl_journal posted bpchar 1 'N'::bpchar Posting status
rv_unposted posted bpchar 1  √  null Posting status
gl_journal postingtype bpchar 1 The type of posted amount for the transaction
gl_journalbatch postingtype bpchar 1 The type of posted amount for the transaction
rv_fact_acct postingtype bpchar 1  √  null The type of posted amount for the transaction
rv_fact_acct_day postingtype bpchar 1  √  null The type of posted amount for the transaction
rv_fact_acct_period postingtype bpchar 1  √  null The type of posted amount for the transaction
gl_journal processed bpchar 1  √  'N'::bpchar The document has been processed
gl_journalbatch processed bpchar 1 'N'::bpchar The document has been processed
gl_journalline processed bpchar 1 'N'::bpchar The document has been processed
rv_unposted processed bpchar 1  √  null The document has been processed
gl_journal processing bpchar 1  √  null Process Now
gl_journalbatch processing bpchar 1 'N'::bpchar Process Now
rv_unposted processing bpchar 1  √  null Process Now
rv_fact_acct producttype bpchar 1  √  null Type of product
gl_journal docaction bpchar 2 The targeted status of the document
gl_journalbatch docaction bpchar 2 The targeted status of the document
gl_journal docstatus bpchar 2 The current status of the document
gl_journalbatch docstatus bpchar 2 The current status of the document
rv_fact_acct c_bp_ad_language varchar 6  √  null c_bp_ad_language
rv_fact_acct naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
gl_journalline a_asset_group_id numeric 10  √  null Group of Assets
gl_journalline a_asset_id numeric 10  √  null Asset used internally or by customers
rv_fact_acct a_asset_id numeric 10  √  null Asset used internally or by customers
rv_fact_acct_day a_asset_id numeric 10  √  null Asset used internally or by customers
rv_fact_acct_period a_asset_id numeric 10  √  null Asset used internally or by customers
gl_journalline account_id numeric 10  √  NULL::numeric Account used
rv_fact_acct account_id numeric 10  √  null Account used
rv_fact_acct_day account_id numeric 10  √  null Account used
rv_fact_acct_period account_id numeric 10  √  null Account used
rv_fact_simple account_id numeric 10  √  null Account used
gl_journal ad_client_id numeric 10 Client/Tenant for this installation.
gl_journalbatch ad_client_id numeric 10 Client/Tenant for this installation.
gl_journalline ad_client_id numeric 10 Client/Tenant for this installation.
rv_fact_acct ad_client_id numeric 10  √  null Client/Tenant for this installation.
rv_fact_acct_day ad_client_id numeric 10  √  null Client/Tenant for this installation.
rv_fact_acct_period ad_client_id numeric 10  √  null Client/Tenant for this installation.
rv_fact_simple ad_client_id numeric 10  √  null Client/Tenant for this installation.
rv_unposted ad_client_id numeric 10  √  null Client/Tenant for this installation.
gl_journal ad_org_id numeric 10 Organizational entity within client
gl_journalbatch ad_org_id numeric 10 Organizational entity within client
gl_journalline ad_org_id numeric 10 Organizational entity within client
rv_fact_acct ad_org_id numeric 10  √  null Organizational entity within client
rv_fact_acct_day ad_org_id numeric 10  √  null Organizational entity within client
rv_fact_acct_period ad_org_id numeric 10  √  null Organizational entity within client
rv_fact_simple ad_org_id numeric 10  √  null Organizational entity within client
rv_unposted ad_org_id numeric 10  √  null Organizational entity within client
gl_journalline ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
rv_fact_acct ad_orgtrx_id numeric 10  √  null Performing or initiating organization
rv_fact_acct_day ad_orgtrx_id numeric 10  √  null Performing or initiating organization
rv_fact_acct_period ad_orgtrx_id numeric 10  √  null Performing or initiating organization
rv_fact_acct ad_table_id numeric 10  √  null Database Table information
rv_unposted ad_table_id int4 10  √  null Database Table information
gl_journalline alias_validcombination_id numeric 10  √  NULL::numeric Valid Account Alias List
gl_journal c_acctschema_id numeric 10 Rules for accounting
rv_fact_acct c_acctschema_id numeric 10  √  null Rules for accounting
rv_fact_acct_day c_acctschema_id numeric 10  √  null Rules for accounting
rv_fact_acct_period c_acctschema_id numeric 10  √  null Rules for accounting
rv_fact_simple c_acctschema_id numeric 10  √  null Rules for accounting
gl_journalline c_activity_id numeric 10  √  NULL::numeric Business Activity
rv_fact_acct c_activity_id numeric 10  √  null Business Activity
rv_fact_acct_day c_activity_id numeric 10  √  null Business Activity
rv_fact_acct_period c_activity_id numeric 10  √  null Business Activity
rv_fact_acct c_bankaccount_id numeric 10  √  null Account at the Bank
rv_fact_acct c_bp_ad_org_id numeric 10  √  null c_bp_ad_org_id
rv_fact_acct c_bp_ad_orgbp_id numeric 10  √  null c_bp_ad_orgbp_id
rv_fact_acct c_bp_bpartner_parent_id numeric 10  √  null c_bp_bpartner_parent_id
rv_fact_acct c_bp_c_dunning_id numeric 10  √  null c_bp_c_dunning_id
rv_fact_acct c_bp_c_greeting_id numeric 10  √  null c_bp_c_greeting_id
rv_fact_acct c_bp_c_invoiceschedule_id numeric 10  √  null c_bp_c_invoiceschedule_id
rv_fact_acct c_bp_c_paymentterm_id numeric 10  √  null c_bp_c_paymentterm_id
rv_fact_acct c_bp_c_taxgroup_id numeric 10  √  null c_bp_c_taxgroup_id
rv_fact_acct c_bp_createdby numeric 10  √  null c_bp_createdby
rv_fact_acct c_bp_group_id numeric 10  √  null Business Partner Group
rv_fact_acct c_bp_logo_id numeric 10  √  null c_bp_logo_id
rv_fact_acct c_bp_m_discountschema_id numeric 10  √  null c_bp_m_discountschema_id
rv_fact_acct c_bp_m_pricelist_id numeric 10  √  null c_bp_m_pricelist_id
rv_fact_acct c_bp_numberemployees numeric 10  √  null c_bp_numberemployees
rv_fact_acct c_bp_po_discountschema_id numeric 10  √  null c_bp_po_discountschema_id
rv_fact_acct c_bp_po_paymentterm_id numeric 10  √  null c_bp_po_paymentterm_id
rv_fact_acct c_bp_po_pricelist_id numeric 10  √  null c_bp_po_pricelist_id
rv_fact_acct c_bp_salesrep_id numeric 10  √  null c_bp_salesrep_id
rv_fact_acct c_bp_salesvolume numeric 10  √  null c_bp_salesvolume
rv_fact_acct c_bp_shareofcustomer numeric 10  √  null c_bp_shareofcustomer
rv_fact_acct c_bp_shelflifeminpct numeric 10  √  null c_bp_shelflifeminpct
rv_fact_acct c_bp_updatedby numeric 10  √  null c_bp_updatedby
gl_journalline c_bpartner_id numeric 10  √  NULL::numeric Identifies a Business Partner
rv_fact_acct c_bpartner_id numeric 10  √  null Identifies a Business Partner
rv_fact_acct_day c_bpartner_id numeric 10  √  null Identifies a Business Partner
rv_fact_acct_period c_bpartner_id numeric 10  √  null Identifies a Business Partner
gl_journalline c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
rv_fact_acct c_campaign_id numeric 10  √  null Marketing Campaign
rv_fact_acct_day c_campaign_id numeric 10  √  null Marketing Campaign
rv_fact_acct_period c_campaign_id numeric 10  √  null Marketing Campaign
gl_journal c_conversiontype_id numeric 10 Currency Conversion Rate Type
gl_journalline c_conversiontype_id numeric 10 Currency Conversion Rate Type
gl_journal c_currency_id numeric 10  √  null The Currency for this record
gl_journalbatch c_currency_id numeric 10  √  null The Currency for this record
gl_journalline c_currency_id numeric 10 The Currency for this record
rv_fact_acct c_currency_id numeric 10  √  null The Currency for this record
rv_fact_acct_day c_currency_id numeric 10  √  null The Currency for this record
rv_fact_acct_period c_currency_id numeric 10  √  null The Currency for this record
gl_journal c_doctype_id numeric 10 Document type or rules
gl_journalbatch c_doctype_id numeric 10 Document type or rules
rv_fact_acct c_element_id numeric 10  √  null Accounting Element
rv_fact_acct c_elementvalue_ad_org_id numeric 10  √  null c_elementvalue_ad_org_id
rv_fact_acct c_elementvalue_c_currency_id numeric 10  √  null c_elementvalue_c_currency_id
rv_fact_acct c_elementvalue_id numeric 10  √  null Account Element
gl_journalline c_locfrom_id numeric 10  √  NULL::numeric Location that inventory was moved from
rv_fact_acct c_locfrom_id numeric 10  √  null Location that inventory was moved from
rv_fact_acct_day c_locfrom_id numeric 10  √  null Location that inventory was moved from
rv_fact_acct_period c_locfrom_id numeric 10  √  null Location that inventory was moved from
gl_journalline c_locto_id numeric 10  √  NULL::numeric Location that inventory was moved to
rv_fact_acct c_locto_id numeric 10  √  null Location that inventory was moved to
rv_fact_acct_day c_locto_id numeric 10  √  null Location that inventory was moved to
rv_fact_acct_period c_locto_id numeric 10  √  null Location that inventory was moved to
gl_journal c_period_id numeric 10 Period of the Calendar
gl_journalbatch c_period_id numeric 10  √  null Period of the Calendar
rv_fact_acct c_period_id numeric 10  √  null Period of the Calendar
rv_fact_acct_day c_period_id numeric 10  √  null Period of the Calendar
rv_fact_acct_period c_period_id numeric 10  √  null Period of the Calendar
gl_journalline c_project_id numeric 10  √  NULL::numeric Financial Project
rv_fact_acct c_project_id numeric 10  √  null Financial Project
rv_fact_acct_day c_project_id numeric 10  √  null Financial Project
rv_fact_acct_period c_project_id numeric 10  √  null Financial Project
rv_fact_simple c_project_id numeric 10  √  null Financial Project
rv_fact_acct c_projectphase_id numeric 10  √  null Phase of a Project
rv_fact_acct c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
rv_fact_acct c_revenuerecognition_id numeric 10  √  null Method for recording revenue
gl_journalline c_salesregion_id numeric 10  √  NULL::numeric Sales coverage region
rv_fact_acct c_salesregion_id numeric 10  √  null Sales coverage region
rv_fact_acct_day c_salesregion_id numeric 10  √  null Sales coverage region
rv_fact_acct_period c_salesregion_id numeric 10  √  null Sales coverage region
gl_journalline c_subacct_id numeric 10  √  NULL::numeric Sub account for Element Value
rv_fact_acct c_subacct_id numeric 10  √  null Sub account for Element Value
rv_fact_acct c_subscriptiontype_id numeric 10  √  null Type of subscription
rv_fact_acct c_tax_id numeric 10  √  null Tax identifier
rv_fact_acct_day c_tax_id numeric 10  √  null Tax identifier
rv_fact_acct_period c_tax_id numeric 10  √  null Tax identifier
rv_fact_acct c_taxcategory_id numeric 10  √  null Tax Category
gl_journalline c_uom_id numeric 10  √  null Unit of Measure
rv_fact_acct c_uom_id numeric 10  √  null Unit of Measure
gl_journalline c_validcombination_id numeric 10  √  null Valid Account Combination
gl_journal createdby numeric 10 User who created this records
gl_journalbatch createdby numeric 10 User who created this records
gl_journalline createdby numeric 10 User who created this records
rv_fact_acct createdby numeric 10  √  null User who created this records
rv_fact_simple createdby numeric 10  √  null User who created this records
rv_unposted createdby numeric 10  √  null User who created this records
rv_fact_acct fact_acct_id numeric 10  √  null Accounting Fact
gl_journal gl_budget_id numeric 10  √  null General Ledger Budget
rv_fact_acct gl_budget_id numeric 10  √  null General Ledger Budget
rv_fact_acct_day gl_budget_id numeric 10  √  null General Ledger Budget
rv_fact_acct_period gl_budget_id numeric 10  √  null General Ledger Budget
gl_journal gl_category_id numeric 10 General Ledger Category
gl_journalbatch gl_category_id numeric 10  √  null General Ledger Category
rv_fact_acct gl_category_id numeric 10  √  null General Ledger Category
rv_fact_acct_day gl_category_id numeric 10  √  null General Ledger Category
rv_fact_acct_period gl_category_id numeric 10  √  null General Ledger Category
gl_journal gl_journal_id numeric 10 General Ledger Journal
gl_journalline gl_journal_id numeric 10 General Ledger Journal
gl_journal gl_journalbatch_id numeric 10  √  null General Ledger Journal Batch
gl_journalbatch gl_journalbatch_id numeric 10 General Ledger Journal Batch
gl_journalline gl_journalline_id numeric 10 General Ledger Journal Line
rv_fact_acct guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
rv_fact_acct guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
gl_journalline line numeric 10 Unique line for this document
rv_fact_acct line_id numeric 10  √  null Transaction line ID (internal)
rv_fact_acct lowlevel numeric 10  √  null The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
rv_fact_acct m_freightcategory_id numeric 10  √  null Category of the Freight
rv_fact_acct m_locator_id numeric 10  √  null Warehouse Locator
rv_fact_acct_day m_locator_id numeric 10  √  null Warehouse Locator
rv_fact_acct_period m_locator_id numeric 10  √  null Warehouse Locator
rv_fact_acct m_product_ad_org_id numeric 10  √  null m_product_ad_org_id
rv_fact_acct m_product_c_uom_id numeric 10  √  null m_product_c_uom_id
rv_fact_acct m_product_category_id numeric 10  √  null Category of a Product
rv_fact_acct m_product_createdby numeric 10  √  null m_product_createdby
gl_journalline m_product_id numeric 10  √  NULL::numeric Product, Service, Item
rv_fact_acct m_product_id numeric 10  √  null Product, Service, Item
rv_fact_acct_day m_product_id numeric 10  √  null Product, Service, Item
rv_fact_acct_period m_product_id numeric 10  √  null Product, Service, Item
rv_fact_acct m_product_m_asi_id numeric 10  √  null M_Product_M_ASI_ID
rv_fact_acct m_product_m_attributeset_id numeric 10  √  null Product Attribute Set
rv_fact_acct m_product_m_locator_id numeric 10  √  null m_product_m_locator_id
rv_fact_acct m_product_salesrep_id numeric 10  √  null m_product_salesrep_id
rv_fact_acct m_product_updatedby numeric 10  √  null m_product_updatedby
rv_fact_acct r_mailtext_id numeric 10  √  null Text templates for mailings
rv_fact_acct record_id numeric 10  √  null Direct internal record ID
rv_unposted record_id numeric 10  √  null Direct internal record ID
gl_journal reversal_id numeric 10  √  null ID of document reversal
gl_journalbatch reversal_id numeric 10  √  null ID of document reversal
rv_fact_acct s_expensetype_id numeric 10  √  null Expense report type
rv_fact_acct s_resource_id numeric 10  √  null Resource
rv_fact_acct shelfdepth numeric 10  √  null Shelf depth required
rv_fact_acct shelfwidth numeric 10  √  null Shelf width required
rv_fact_acct unitsperpack numeric 10  √  null The Units Per Pack indicates the no of units of a product packed together.
gl_journal updatedby numeric 10 User who updated this records
gl_journalbatch updatedby numeric 10 User who updated this records
gl_journalline updatedby numeric 10 User who updated this records
rv_fact_acct updatedby numeric 10  √  null User who updated this records
rv_fact_simple updatedby numeric 10  √  null User who updated this records
rv_unposted updatedby numeric 10  √  null User who updated this records
gl_journalline user1_id numeric 10  √  NULL::numeric User defined list element #1
rv_fact_acct user1_id numeric 10  √  null User defined list element #1
rv_fact_acct_day user1_id numeric 10  √  null User defined list element #1
rv_fact_acct_period user1_id numeric 10  √  null User defined list element #1
gl_journalline user2_id numeric 10  √  NULL::numeric User defined list element #2
rv_fact_acct user2_id numeric 10  √  null User defined list element #2
rv_fact_acct_day user2_id numeric 10  √  null User defined list element #2
rv_fact_acct_period user2_id numeric 10  √  null User defined list element #2
rv_fact_acct userelement1_id numeric 10  √  null User defined accounting Element
rv_fact_acct userelement2_id numeric 10  √  null User defined accounting Element
rv_fact_acct duns varchar 11  √  null Dun & Bradstreet Number
rv_fact_acct classification varchar 12  √  null Classification for grouping
rv_fact_acct_day dateacct date 13  √  null Accounting Date
rv_fact_acct c_bp_poreference varchar 20  √  null c_bp_poreference
rv_fact_acct taxid varchar 20  √  null Tax Identification
rv_fact_acct versionno varchar 20  √  null Version Number
rv_fact_acct c_bp_created timestamp 29,6  √  null c_bp_created
rv_fact_acct c_bp_dunninggrace timestamp 29,6  √  null c_bp_dunninggrace
rv_fact_acct c_bp_firstsale timestamp 29,6  √  null c_bp_firstsale
rv_fact_acct c_bp_updated timestamp 29,6  √  null c_bp_updated
gl_journal created timestamp 29,6 now() Date this record was created
gl_journalbatch created timestamp 29,6 now() Date this record was created
gl_journalline created timestamp 29,6 now() Date this record was created
rv_fact_acct created timestamp 29,6  √  null Date this record was created
rv_fact_simple created timestamp 29,6  √  null Date this record was created
rv_unposted created timestamp 29,6  √  null Date this record was created
gl_journal dateacct timestamp 29,6 Accounting Date
gl_journalbatch dateacct timestamp 29,6  √  null Accounting Date
gl_journalline dateacct timestamp 29,6 Accounting Date
rv_fact_acct dateacct timestamp 29,6  √  null Accounting Date
rv_fact_simple dateacct timestamp 29,6  √  null Accounting Date
rv_unposted dateacct timestamp 29,6  √  null Accounting Date
gl_journal datedoc timestamp 29,6 Date of the Document
gl_journalbatch datedoc timestamp 29,6  √  null Date of the Document
rv_unposted datedoc timestamp 29,6  √  null Date of the Document
rv_fact_acct datetrx timestamp 29,6  √  null Transaction Date
rv_fact_acct discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
rv_fact_acct m_product_created timestamp 29,6  √  null m_product_created
rv_fact_acct m_product_updated timestamp 29,6  √  null m_product_updated
gl_journal updated timestamp 29,6 now() Date this record was updated
gl_journalbatch updated timestamp 29,6 now() Date this record was updated
gl_journalline updated timestamp 29,6 now() Date this record was updated
rv_fact_acct updated timestamp 29,6  √  null Date this record was updated
rv_fact_simple updated timestamp 29,6  √  null Date this record was updated
rv_unposted updated timestamp 29,6  √  null Date this record was updated
gl_journal documentno varchar 30 Document sequence number of the document
gl_journalbatch documentno varchar 30 Document sequence number of the document
rv_fact_acct sku varchar 30  √  null Stock Keeping Unit
rv_fact_acct upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
gl_journal gl_journal_uu varchar 36  √  NULL::character varying GL_Journal_UU
gl_journalbatch gl_journalbatch_uu varchar 36  √  NULL::character varying GL_JournalBatch_UU
gl_journalline gl_journalline_uu varchar 36  √  NULL::character varying GL_JournalLine_UU
rv_fact_acct accountvalue varchar 40  √  null Key of Account Element
rv_fact_simple accountvalue varchar 40  √  null Key of Account Element
rv_fact_acct bpartnervalue varchar 40  √  null Key of the Business Partner
rv_fact_acct orgvalue varchar 40  √  null Key of the Organization
rv_fact_acct productvalue varchar 40  √  null Key of the Product
rv_fact_acct referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
rv_fact_acct c_bp_name2 varchar 60  √  null c_bp_name2
rv_fact_acct orgname varchar 60  √  null Name of the Organization
rv_fact_acct bpname varchar 120  √  null BP Name
rv_fact_acct c_bp_url varchar 120  √  null c_bp_url
rv_fact_acct descriptionurl varchar 120  √  null URL for the description
rv_fact_acct imageurl varchar 120  √  null URL of image
rv_fact_acct name varchar 120  √  null Alphanumeric identifier of the entity
rv_fact_acct ad_org_description varchar 255  √  null ad_org_description
rv_fact_acct c_bp_description varchar 255  √  null c_bp_description
rv_fact_acct c_bp_so_description varchar 255  √  null c_bp_so_description
rv_fact_acct c_elementvalue_description varchar 255  √  null c_elementvalue_description
gl_journal description varchar 255 Optional short description of the record
gl_journalbatch description varchar 255 Optional short description of the record
gl_journalline description varchar 255  √  null Optional short description of the record
rv_fact_acct description varchar 255  √  null Optional short description of the record
rv_fact_acct group1 varchar 255  √  null Group1
rv_fact_acct group2 varchar 255  √  null Group2
rv_fact_acct m_product_description varchar 255  √  null m_product_description
rv_fact_acct productname varchar 255  √  null Name of the Product
rv_fact_acct documentnote varchar 2000  √  null Additional information for a Document
rv_fact_acct help varchar 2000  √  null Comment or Hint
rv_fact_simple case text 2147483647  √  null Case
rv_unposted docstatus bpchar 2147483647  √  null The current status of the document
rv_unposted documentno varchar 2147483647  √  null Document sequence number of the document
rv_fact_simple finyear text 2147483647  √  null Financial Year
rv_fact_simple finyear_mth text 2147483647  √  null Financial Month
rv_unposted issotrx text 2147483647  √  null This is a Sales Transaction