View idempiere9.adempiere.rv_fact_acct
Accounting Fact View

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
fact_acct_id numeric 10  √  null Accounting Fact
c_acctschema_id numeric 10  √  null Rules for accounting
account_id numeric 10  √  null Account used
datetrx timestamp 29,6  √  null Transaction Date
dateacct timestamp 29,6  √  null Accounting Date
c_period_id numeric 10  √  null Period of the Calendar
ad_table_id numeric 10  √  null Database Table information
record_id numeric 10  √  null Direct internal record ID
line_id numeric 10  √  null Transaction line ID (internal)
gl_category_id numeric 10  √  null General Ledger Category
gl_budget_id numeric 10  √  null General Ledger Budget
c_tax_id numeric 10  √  null Tax identifier
m_locator_id numeric 10  √  null Warehouse Locator
postingtype bpchar 1  √  null The type of posted amount for the transaction
c_currency_id numeric 10  √  null The Currency for this record
amtsourcedr numeric 0  √  null Source Debit Amount
amtsourcecr numeric 0  √  null Source Credit Amount
amtsource numeric 0  √  null Amount Balance in Source Currency
amtacctdr numeric 0  √  null Accounted Debit Amount
amtacctcr numeric 0  √  null Accounted Credit Amount
amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
rate numeric 0  √  null Rate or Tax or Exchange
c_uom_id numeric 10  √  null Unit of Measure
qty numeric 0  √  null Quantity
m_product_id numeric 10  √  null Product, Service, Item
c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_locfrom_id numeric 10  √  null Location that inventory was moved from
c_locto_id numeric 10  √  null Location that inventory was moved to
c_salesregion_id numeric 10  √  null Sales coverage region
c_project_id numeric 10  √  null Financial Project
c_campaign_id numeric 10  √  null Marketing Campaign
c_activity_id numeric 10  √  null Business Activity
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
a_asset_id numeric 10  √  null Asset used internally or by customers
description varchar 255  √  null Optional short description of the record
orgvalue varchar 40  √  null Key of the Organization
orgname varchar 60  √  null Name of the Organization
accountvalue varchar 40  √  null Key of Account Element
name varchar 120  √  null Alphanumeric identifier of the entity
accounttype bpchar 1  √  null Indicates the type of account
bpartnervalue varchar 40  √  null Key of the Business Partner
bpname varchar 120  √  null BP Name
c_bp_group_id numeric 10  √  null Business Partner Group
productvalue varchar 40  √  null Key of the Product
productname varchar 255  √  null Name of the Product
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product_category_id numeric 10  √  null Category of a Product
c_projectphase_id numeric 10  √  null Phase of a Project
c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_subacct_id numeric 10  √  null Sub account for Element Value
userelement1_id numeric 10  √  null User defined accounting Element
userelement2_id numeric 10  √  null User defined accounting Element
ad_org_description varchar 255  √  null ad_org_description
ad_org_isactive bpchar 1  √  null ad_org_isactive
c_elementvalue_ad_org_id numeric 10  √  null c_elementvalue_ad_org_id
c_bankaccount_id numeric 10  √  null Account at the Bank
c_elementvalue_c_currency_id numeric 10  √  null c_elementvalue_c_currency_id
c_element_id numeric 10  √  null Accounting Element
c_elementvalue_id numeric 10  √  null Account Element
c_elementvalue_description varchar 255  √  null c_elementvalue_description
c_elementvalue_isactive bpchar 1  √  null c_elementvalue_isactive
isbankaccount bpchar 1  √  null Indicates if this is the Bank Account
isforeigncurrency bpchar 1  √  null Balances in foreign currency accounts are held in the nominated currency
c_elementvalue_issummary bpchar 1  √  null c_elementvalue_issummary
c_bp_acqusitioncost numeric 0  √  null c_bp_acqusitioncost
c_bp_actuallifetimevalue numeric 0  √  null c_bp_actuallifetimevalue
c_bp_ad_language varchar 6  √  null c_bp_ad_language
c_bp_ad_orgbp_id numeric 10  √  null c_bp_ad_orgbp_id
c_bp_ad_org_id numeric 10  √  null c_bp_ad_org_id
c_bp_bpartner_parent_id numeric 10  √  null c_bp_bpartner_parent_id
c_bp_c_dunning_id numeric 10  √  null c_bp_c_dunning_id
c_bp_c_greeting_id numeric 10  √  null c_bp_c_greeting_id
c_bp_c_invoiceschedule_id numeric 10  √  null c_bp_c_invoiceschedule_id
c_bp_c_paymentterm_id numeric 10  √  null c_bp_c_paymentterm_id
c_bp_created timestamp 29,6  √  null c_bp_created
c_bp_createdby numeric 10  √  null c_bp_createdby
c_bp_c_taxgroup_id numeric 10  √  null c_bp_c_taxgroup_id
c_bp_deliveryrule bpchar 1  √  null c_bp_deliveryrule
c_bp_deliveryviarule bpchar 1  √  null c_bp_deliveryviarule
c_bp_description varchar 255  √  null c_bp_description
c_bp_dunninggrace timestamp 29,6  √  null c_bp_dunninggrace
duns varchar 11  √  null Dun & Bradstreet Number
c_bp_firstsale timestamp 29,6  √  null c_bp_firstsale
c_bp_flatdiscount numeric 0  √  null c_bp_flatdiscount
c_bp_freightcostrule bpchar 1  √  null c_bp_freightcostrule
c_bp_invoicerule bpchar 1  √  null c_bp_invoicerule
c_bp_isactive bpchar 1  √  null c_bp_isactive
c_bp_iscustomer bpchar 1  √  null c_bp_iscustomer
c_bp_isdiscountprinted bpchar 1  √  null c_bp_isdiscountprinted
c_bp_isemployee bpchar 1  √  null c_bp_isemployee
c_bp_ismanufacturer bpchar 1  √  null c_bp_ismanufacturer
c_bp_isonetime bpchar 1  √  null c_bp_isonetime
c_bp_ispotaxexempt bpchar 1  √  null c_bp_ispotaxexempt
c_bp_isprospect bpchar 1  √  null c_bp_isprospect
c_bp_issalesrep bpchar 1  √  null c_bp_issalesrep
c_bp_issummary bpchar 1  √  null c_bp_issummary
c_bp_istaxexempt bpchar 1  √  null c_bp_istaxexempt
c_bp_isvendor bpchar 1  √  null c_bp_isvendor
c_bp_logo_id numeric 10  √  null c_bp_logo_id
c_bp_m_discountschema_id numeric 10  √  null c_bp_m_discountschema_id
c_bp_m_pricelist_id numeric 10  √  null c_bp_m_pricelist_id
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bp_name2 varchar 60  √  null c_bp_name2
c_bp_numberemployees numeric 10  √  null c_bp_numberemployees
c_bp_paymentrule bpchar 1  √  null c_bp_paymentrule
c_bp_paymentrulepo bpchar 1  √  null c_bp_paymentrulepo
c_bp_po_discountschema_id numeric 10  √  null c_bp_po_discountschema_id
c_bp_po_paymentterm_id numeric 10  √  null c_bp_po_paymentterm_id
c_bp_po_pricelist_id numeric 10  √  null c_bp_po_pricelist_id
c_bp_poreference varchar 20  √  null c_bp_poreference
c_bp_potentiallifetimevalue numeric 0  √  null c_bp_potentiallifetimevalue
c_bp_rating bpchar 1  √  null c_bp_rating
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_bp_salesrep_id numeric 10  √  null c_bp_salesrep_id
c_bp_salesvolume numeric 10  √  null c_bp_salesvolume
c_bp_sendemail bpchar 1  √  null c_bp_sendemail
c_bp_shareofcustomer numeric 10  √  null c_bp_shareofcustomer
c_bp_shelflifeminpct numeric 10  √  null c_bp_shelflifeminpct
c_bp_so_creditlimit numeric 0  √  null c_bp_so_creditlimit
c_bp_socreditstatus bpchar 1  √  null c_bp_socreditstatus
c_bp_so_creditused numeric 0  √  null c_bp_so_creditused
c_bp_so_description varchar 255  √  null c_bp_so_description
taxid varchar 20  √  null Tax Identification
c_bp_totalopenbalance numeric 0  √  null c_bp_totalopenbalance
c_bp_updated timestamp 29,6  √  null c_bp_updated
c_bp_updatedby numeric 10  √  null c_bp_updatedby
c_bp_url varchar 120  √  null c_bp_url
m_product_ad_org_id numeric 10  √  null m_product_ad_org_id
classification varchar 12  √  null Classification for grouping
m_product_copyfrom bpchar 1  √  null m_product_copyfrom
m_product_created timestamp 29,6  √  null m_product_created
m_product_createdby numeric 10  √  null m_product_createdby
c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_subscriptiontype_id numeric 10  √  null Type of subscription
c_taxcategory_id numeric 10  √  null Tax Category
m_product_c_uom_id numeric 10  √  null m_product_c_uom_id
m_product_description varchar 255  √  null m_product_description
descriptionurl varchar 120  √  null URL for the description
discontinued bpchar 1  √  null This product is no longer available
discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
documentnote varchar 2000  √  null Additional information for a Document
group1 varchar 255  √  null Group1
group2 varchar 255  √  null Group2
guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
help varchar 2000  √  null Comment or Hint
imageurl varchar 120  √  null URL of image
m_product_isactive bpchar 1  √  null m_product_isactive
isdropship bpchar 1  √  null Drop Shipments are sent directly to the Drop Shipment Location
isexcludeautodelivery bpchar 1  √  null Exclude from automatic Delivery
isinvoiceprintdetails bpchar 1  √  null Print detail BOM elements on the invoice
ispicklistprintdetails bpchar 1  √  null Print detail BOM elements on the pick list
ispurchased bpchar 1  √  null Organization purchases this product
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
issold bpchar 1  √  null Organization sells this product
isstocked bpchar 1  √  null Organization stocks this product
m_product_issummary bpchar 1  √  null m_product_issummary
isverified bpchar 1  √  null The BOM configuration has been verified
iswebstorefeatured bpchar 1  √  null If selected, the product is displayed in the initial or any empty search
lowlevel numeric 10  √  null The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product_m_attributeset_id numeric 10  √  null Product Attribute Set
m_product_m_asi_id numeric 10  √  null M_Product_M_ASI_ID
m_freightcategory_id numeric 10  √  null Category of the Freight
m_product_m_locator_id numeric 10  √  null m_product_m_locator_id
m_product_processing bpchar 1  √  null m_product_processing
producttype bpchar 1  √  null Type of product
r_mailtext_id numeric 10  √  null Text templates for mailings
m_product_salesrep_id numeric 10  √  null m_product_salesrep_id
s_expensetype_id numeric 10  √  null Expense report type
shelfdepth numeric 10  √  null Shelf depth required
shelfheight numeric 0  √  null Shelf height required
shelfwidth numeric 10  √  null Shelf width required
sku varchar 30  √  null Stock Keeping Unit
s_resource_id numeric 10  √  null Resource
unitsperpack numeric 10  √  null The Units Per Pack indicates the no of units of a product packed together.
unitsperpallet numeric 0  √  null Units Per Pallet
m_product_updated timestamp 29,6  √  null m_product_updated
m_product_updatedby numeric 10  √  null m_product_updatedby
versionno varchar 20  √  null Version Number
volume numeric 0  √  null Volume of a product
weight numeric 0  √  null Weight of a product

Analyzed at 2021-12-25 14:48 +0100