ERP 2.50:Developers Guide/Reference/Entity Model/FinancialMgmtAccountingFact
FinancialMgmtAccountingFact
Records accounting entries of all accounting schemas.
To the database table (Fact_Acct) of this entity.
Properties
Note:
- Properties marked with a * are part of the Id of the Entity.
- Properties marked with a # are part of the Identifier of the Entity.
Property | Column | Constraints | Type | Description |
id* | Fact_Acct_ID | Mandatory Max Length: 32 | java.lang.String | |
client | AD_Client_ID | Mandatory | ADClient | A Client is a company or a legal entity. You cannot share data between Clients. |
organization | AD_Org_ID | Mandatory | Organization | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
active | IsActive | Mandatory | java.lang.Boolean | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions. |
creationDate | Created | Mandatory | java.util.Date | The Created field indicates the date that this record was created. |
createdBy | CreatedBy | Mandatory | ADUser | The Created By field indicates the user who created this record. |
updated | Updated | Mandatory | java.util.Date | The Updated field indicates the date that this record was updated. |
updatedBy | UpdatedBy | Mandatory | ADUser | The Updated By field indicates the user who updated this record. |
accountingSchema | C_AcctSchema_ID | Mandatory | FinancialMgmtAcctSchema | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar |
account | Account_ID | Mandatory | FinancialMgmtElementValue | The (natural) account used |
transactionDate | DateTrx | Mandatory | java.util.Date | The Transaction Date indicates the date of the transaction. |
accountingDate | DateAcct | Mandatory | java.util.Date | The date this transaction is recorded on in the general ledger. This date also indicates which accounting period within the fiscal year this transaction will be part of. |
period | C_Period_ID | FinancialMgmtPeriod | The Period indicates an exclusive range of dates for a calendar. | |
table | AD_Table_ID | Mandatory | ADTable | The Table indicates the table in which a field or fields reside. |
recordID | Record_ID | Mandatory Max Length: 32 | java.lang.String | The Record ID is the internal unique identifier of a record |
lineID | Line_ID | Max Length: 32 | java.lang.String | Internal link |
gLCategory | GL_Category_ID | FinancialMgmtGLCategory | The General Ledger Category is an optional, user defined method of grouping journal lines. | |
tax | C_Tax_ID | FinancialMgmtTaxRate | The Tax indicates the type of tax for this document line. | |
storageBin | M_Locator_ID | Locator | The Locator ID indicates where in a Warehouse a product is located. | |
postingType | PostingType | Mandatory Max Length: 60 | java.lang.String | The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated. |
currency | C_Currency_ID | Mandatory | Currency | Indicates the currency to be used when processing this document. |
foreignCurrencyDebit | AmtSourceDr | Mandatory | java.math.BigDecimal | The Source Debit Amount indicates the credit amount for this line in the source currency. |
foreignCurrencyCredit | AmtSourceCr | Mandatory | java.math.BigDecimal | The Source Credit Amount indicates the credit amount for this line in the source currency. |
debit | AmtAcctDr | Mandatory | java.math.BigDecimal | The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency |
credit | AmtAcctCr | Mandatory | java.math.BigDecimal | The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency |
uOM | C_UOM_ID | UOM | The UOM defines a unique non monetary unit of measure | |
quantity | Qty | java.math.BigDecimal | The Quantity indicates the number of a specific product or item for this document. | |
product | M_Product_ID | Product | Identifies an item which is either purchased or sold in this organization. | |
businessPartner | C_BPartner_ID | BusinessPartner | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. | |
trxOrganization | AD_OrgTrx_ID | Organization | The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | |
locationFromAddress | C_LocFrom_ID | Location | The Location From indicates the location that a product was moved from. | |
locationToAddress | C_LocTo_ID | Location | The Location To indicates the location that a product was moved to. | |
salesRegion | C_SalesRegion_ID | SalesRegion | The Sales Region indicates a specific area of sales coverage. | |
project | C_Project_ID | Project | Identifier of a project defined within the Project & Service Management module. | |
salesCampaign | C_Campaign_ID | MarketingCampaign | The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. | |
activity | C_Activity_ID | MaterialMgmtABCActivity | Activities indicate tasks that are performed and used to utilize Activity based Costing | |
stDimension | User1_ID | Max Length: 22 | java.lang.String | The user defined element displays the optional elements that have been defined for this account combination. |
ndDimension | User2_ID | Max Length: 22 | java.lang.String | The user defined element displays the optional elements that have been defined for this account combination. |
description# | Description | Max Length: 255 | java.lang.String | A description is limited to 255 characters. |
asset | A_Asset_ID | FinancialMgmtAsset | Any item of economic value owned by the corporation, especially that which could be converted to cash. | |
groupID | Fact_Acct_Group_ID | Mandatory Max Length: 32 | java.lang.String | Accounting entry group ID. Used to group a set of entries |
sequenceNumber | SeqNo | Mandatory | java.lang.Long | The Sequence indicates the order of records |
type | FactAcctType | java.lang.Boolean | Type of entry (Normal, Closing, Opening, Regularization) | |
documentCategory | DocBaseType | Max Length: 40 | java.lang.String | The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type. |
value | AcctValue | Max Length: 40 | java.lang.String | Value of the account used in the entry. |
accountingEntryDescription | AcctDescription | Max Length: 255 | java.lang.String | Description of the accounting entry |
recordID2 | Record_ID2 | Max Length: 32 | java.lang.String | Payment the fact refers to. |
withholding | C_Withholding_ID | FinancialMgmtWithholding | The Withholding indicates the type of withholding to be calculated. | |
documentType | C_Doctype_ID | DocumentType | The Document Type determines document sequence and processing rules |
Java Entity Class
/* ************************************************************************* * The contents of this file are subject to the Openbravo Public License * Version 1.1 (the "License"), being the Mozilla Public License * Version 1.1 with a permitted attribution clause; you may not use this * file except in compliance with the License. You may obtain a copy of * the License at http://www.openbravo.com/legal/license.html * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU * All portions are Copyright (C) 2008-2010 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ */ package org.openbravo.model.financialmgmt.accounting; import org.openbravo.base.structure.ActiveEnabled; import org.openbravo.base.structure.BaseOBObject; import org.openbravo.base.structure.ClientEnabled; import org.openbravo.base.structure.OrganizationEnabled; import org.openbravo.base.structure.Traceable; import org.openbravo.model.ad.access.User; import org.openbravo.model.ad.datamodel.Table; import org.openbravo.model.ad.system.Client; import org.openbravo.model.common.businesspartner.BusinessPartner; import org.openbravo.model.common.currency.Currency; import org.openbravo.model.common.enterprise.DocumentType; import org.openbravo.model.common.enterprise.Locator; import org.openbravo.model.common.enterprise.Organization; import org.openbravo.model.common.geography.Location; import org.openbravo.model.common.plm.Product; import org.openbravo.model.financialmgmt.accounting.coa.AcctSchema; import org.openbravo.model.financialmgmt.accounting.coa.ElementValue; import org.openbravo.model.financialmgmt.assetmgmt.Asset; import org.openbravo.model.financialmgmt.calendar.Period; import org.openbravo.model.financialmgmt.gl.GLCategory; import org.openbravo.model.financialmgmt.tax.TaxRate; import org.openbravo.model.financialmgmt.tax.Withholding; import org.openbravo.model.marketing.Campaign; import org.openbravo.model.materialmgmt.cost.ABCActivity; import org.openbravo.model.project.Project; import org.openbravo.model.sales.SalesRegion; import java.lang.Boolean; import java.lang.Long; import java.lang.String; import java.math.BigDecimal; import java.util.Date; /** * Entity class for entity FinancialMgmtAccountingFact (stored in table Fact_Acct). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class AccountingFact extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "Fact_Acct"; public static final String FinancialMgmtAccountingFact = "FinancialMgmtAccountingFact"; public static final String PROPERTY_ID = "id"; public static final String PROPERTY_CLIENT = "client"; public static final String PROPERTY_ORGANIZATION = "organization"; public static final String PROPERTY_ACTIVE = "active"; public static final String PROPERTY_CREATIONDATE = "creationDate"; public static final String PROPERTY_CREATEDBY = "createdBy"; public static final String PROPERTY_UPDATED = "updated"; public static final String PROPERTY_UPDATEDBY = "updatedBy"; public static final String PROPERTY_ACCOUNTINGSCHEMA = "accountingSchema"; public static final String PROPERTY_ACCOUNT = "account"; public static final String PROPERTY_TRANSACTIONDATE = "transactionDate"; public static final String PROPERTY_ACCOUNTINGDATE = "accountingDate"; public static final String PROPERTY_PERIOD = "period"; public static final String PROPERTY_TABLE = "table"; public static final String PROPERTY_RECORDID = "recordID"; public static final String PROPERTY_LINEID = "lineID"; public static final String PROPERTY_GLCATEGORY = "gLCategory"; public static final String PROPERTY_TAX = "tax"; public static final String PROPERTY_STORAGEBIN = "storageBin"; public static final String PROPERTY_POSTINGTYPE = "postingType"; public static final String PROPERTY_CURRENCY = "currency"; public static final String PROPERTY_FOREIGNCURRENCYDEBIT = "foreignCurrencyDebit"; public static final String PROPERTY_FOREIGNCURRENCYCREDIT = "foreignCurrencyCredit"; public static final String PROPERTY_DEBIT = "debit"; public static final String PROPERTY_CREDIT = "credit"; public static final String PROPERTY_UOM = "uOM"; public static final String PROPERTY_QUANTITY = "quantity"; public static final String PROPERTY_PRODUCT = "product"; public static final String PROPERTY_BUSINESSPARTNER = "businessPartner"; public static final String PROPERTY_TRXORGANIZATION = "trxOrganization"; public static final String PROPERTY_LOCATIONFROMADDRESS = "locationFromAddress"; public static final String PROPERTY_LOCATIONTOADDRESS = "locationToAddress"; public static final String PROPERTY_SALESREGION = "salesRegion"; public static final String PROPERTY_PROJECT = "project"; public static final String PROPERTY_SALESCAMPAIGN = "salesCampaign"; public static final String PROPERTY_ACTIVITY = "activity"; public static final String PROPERTY_STDIMENSION = "stDimension"; public static final String PROPERTY_NDDIMENSION = "ndDimension"; public static final String PROPERTY_DESCRIPTION = "description"; public static final String PROPERTY_ASSET = "asset"; public static final String PROPERTY_GROUPID = "groupID"; public static final String PROPERTY_SEQUENCENUMBER = "sequenceNumber"; public static final String PROPERTY_TYPE = "type"; public static final String PROPERTY_DOCUMENTCATEGORY = "documentCategory"; public static final String PROPERTY_VALUE = "value"; public static final String PROPERTY_ACCOUNTINGENTRYDESCRIPTION = "accountingEntryDescription"; public static final String PROPERTY_RECORDID2 = "recordID2"; public static final String PROPERTY_WITHHOLDING = "withholding"; public static final String PROPERTY_DOCUMENTTYPE = "documentType"; public AccountingFact() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_TYPE, false); } @Override public String getEntityName() { return FinancialMgmtAccountingFact; } public String getId() { return (String) get(PROPERTY_ID); } public void setId(String id) { set(PROPERTY_ID, id); } public Client getClient() { return (Client) get(PROPERTY_CLIENT); } public void setClient(Client client) { set(PROPERTY_CLIENT, client); } public Organization getOrganization() { return (Organization) get(PROPERTY_ORGANIZATION); } public void setOrganization(Organization organization) { set(PROPERTY_ORGANIZATION, organization); } public Boolean isActive() { return (Boolean) get(PROPERTY_ACTIVE); } public void setActive(Boolean active) { set(PROPERTY_ACTIVE, active); } public Date getCreationDate() { return (Date) get(PROPERTY_CREATIONDATE); } public void setCreationDate(Date creationDate) { set(PROPERTY_CREATIONDATE, creationDate); } public User getCreatedBy() { return (User) get(PROPERTY_CREATEDBY); } public void setCreatedBy(User createdBy) { set(PROPERTY_CREATEDBY, createdBy); } public Date getUpdated() { return (Date) get(PROPERTY_UPDATED); } public void setUpdated(Date updated) { set(PROPERTY_UPDATED, updated); } public User getUpdatedBy() { return (User) get(PROPERTY_UPDATEDBY); } public void setUpdatedBy(User updatedBy) { set(PROPERTY_UPDATEDBY, updatedBy); } public AcctSchema getAccountingSchema() { return (AcctSchema) get(PROPERTY_ACCOUNTINGSCHEMA); } public void setAccountingSchema(AcctSchema accountingSchema) { set(PROPERTY_ACCOUNTINGSCHEMA, accountingSchema); } public ElementValue getAccount() { return (ElementValue) get(PROPERTY_ACCOUNT); } public void setAccount(ElementValue account) { set(PROPERTY_ACCOUNT, account); } public Date getTransactionDate() { return (Date) get(PROPERTY_TRANSACTIONDATE); } public void setTransactionDate(Date transactionDate) { set(PROPERTY_TRANSACTIONDATE, transactionDate); } public Date getAccountingDate() { return (Date) get(PROPERTY_ACCOUNTINGDATE); } public void setAccountingDate(Date accountingDate) { set(PROPERTY_ACCOUNTINGDATE, accountingDate); } public Period getPeriod() { return (Period) get(PROPERTY_PERIOD); } public void setPeriod(Period period) { set(PROPERTY_PERIOD, period); } public Table getTable() { return (Table) get(PROPERTY_TABLE); } public void setTable(Table table) { set(PROPERTY_TABLE, table); } public String getRecordID() { return (String) get(PROPERTY_RECORDID); } public void setRecordID(String recordID) { set(PROPERTY_RECORDID, recordID); } public String getLineID() { return (String) get(PROPERTY_LINEID); } public void setLineID(String lineID) { set(PROPERTY_LINEID, lineID); } public GLCategory getGLCategory() { return (GLCategory) get(PROPERTY_GLCATEGORY); } public void setGLCategory(GLCategory gLCategory) { set(PROPERTY_GLCATEGORY, gLCategory); } public TaxRate getTax() { return (TaxRate) get(PROPERTY_TAX); } public void setTax(TaxRate tax) { set(PROPERTY_TAX, tax); } public Locator getStorageBin() { return (Locator) get(PROPERTY_STORAGEBIN); } public void setStorageBin(Locator storageBin) { set(PROPERTY_STORAGEBIN, storageBin); } public String getPostingType() { return (String) get(PROPERTY_POSTINGTYPE); } public void setPostingType(String postingType) { set(PROPERTY_POSTINGTYPE, postingType); } public Currency getCurrency() { return (Currency) get(PROPERTY_CURRENCY); } public void setCurrency(Currency currency) { set(PROPERTY_CURRENCY, currency); } public BigDecimal getForeignCurrencyDebit() { return (BigDecimal) get(PROPERTY_FOREIGNCURRENCYDEBIT); } public void setForeignCurrencyDebit(BigDecimal foreignCurrencyDebit) { set(PROPERTY_FOREIGNCURRENCYDEBIT, foreignCurrencyDebit); } public BigDecimal getForeignCurrencyCredit() { return (BigDecimal) get(PROPERTY_FOREIGNCURRENCYCREDIT); } public void setForeignCurrencyCredit(BigDecimal foreignCurrencyCredit) { set(PROPERTY_FOREIGNCURRENCYCREDIT, foreignCurrencyCredit); } public BigDecimal getDebit() { return (BigDecimal) get(PROPERTY_DEBIT); } public void setDebit(BigDecimal debit) { set(PROPERTY_DEBIT, debit); } public BigDecimal getCredit() { return (BigDecimal) get(PROPERTY_CREDIT); } public void setCredit(BigDecimal credit) { set(PROPERTY_CREDIT, credit); } public org.openbravo.model.common.uom.UOM getUOM() { return (org.openbravo.model.common.uom.UOM) get(PROPERTY_UOM); } public void setUOM(org.openbravo.model.common.uom.UOM uOM) { set(PROPERTY_UOM, uOM); } public BigDecimal getQuantity() { return (BigDecimal) get(PROPERTY_QUANTITY); } public void setQuantity(BigDecimal quantity) { set(PROPERTY_QUANTITY, quantity); } public Product getProduct() { return (Product) get(PROPERTY_PRODUCT); } public void setProduct(Product product) { set(PROPERTY_PRODUCT, product); } public BusinessPartner getBusinessPartner() { return (BusinessPartner) get(PROPERTY_BUSINESSPARTNER); } public void setBusinessPartner(BusinessPartner businessPartner) { set(PROPERTY_BUSINESSPARTNER, businessPartner); } public Organization getTrxOrganization() { return (Organization) get(PROPERTY_TRXORGANIZATION); } public void setTrxOrganization(Organization trxOrganization) { set(PROPERTY_TRXORGANIZATION, trxOrganization); } public Location getLocationFromAddress() { return (Location) get(PROPERTY_LOCATIONFROMADDRESS); } public void setLocationFromAddress(Location locationFromAddress) { set(PROPERTY_LOCATIONFROMADDRESS, locationFromAddress); } public Location getLocationToAddress() { return (Location) get(PROPERTY_LOCATIONTOADDRESS); } public void setLocationToAddress(Location locationToAddress) { set(PROPERTY_LOCATIONTOADDRESS, locationToAddress); } public SalesRegion getSalesRegion() { return (SalesRegion) get(PROPERTY_SALESREGION); } public void setSalesRegion(SalesRegion salesRegion) { set(PROPERTY_SALESREGION, salesRegion); } public Project getProject() { return (Project) get(PROPERTY_PROJECT); } public void setProject(Project project) { set(PROPERTY_PROJECT, project); } public Campaign getSalesCampaign() { return (Campaign) get(PROPERTY_SALESCAMPAIGN); } public void setSalesCampaign(Campaign salesCampaign) { set(PROPERTY_SALESCAMPAIGN, salesCampaign); } public ABCActivity getActivity() { return (ABCActivity) get(PROPERTY_ACTIVITY); } public void setActivity(ABCActivity activity) { set(PROPERTY_ACTIVITY, activity); } public String getStDimension() { return (String) get(PROPERTY_STDIMENSION); } public void setStDimension(String stDimension) { set(PROPERTY_STDIMENSION, stDimension); } public String getNdDimension() { return (String) get(PROPERTY_NDDIMENSION); } public void setNdDimension(String ndDimension) { set(PROPERTY_NDDIMENSION, ndDimension); } public String getDescription() { return (String) get(PROPERTY_DESCRIPTION); } public void setDescription(String description) { set(PROPERTY_DESCRIPTION, description); } public Asset getAsset() { return (Asset) get(PROPERTY_ASSET); } public void setAsset(Asset asset) { set(PROPERTY_ASSET, asset); } public String getGroupID() { return (String) get(PROPERTY_GROUPID); } public void setGroupID(String groupID) { set(PROPERTY_GROUPID, groupID); } public Long getSequenceNumber() { return (Long) get(PROPERTY_SEQUENCENUMBER); } public void setSequenceNumber(Long sequenceNumber) { set(PROPERTY_SEQUENCENUMBER, sequenceNumber); } public Boolean isType() { return (Boolean) get(PROPERTY_TYPE); } public void setType(Boolean type) { set(PROPERTY_TYPE, type); } public String getDocumentCategory() { return (String) get(PROPERTY_DOCUMENTCATEGORY); } public void setDocumentCategory(String documentCategory) { set(PROPERTY_DOCUMENTCATEGORY, documentCategory); } public String getValue() { return (String) get(PROPERTY_VALUE); } public void setValue(String value) { set(PROPERTY_VALUE, value); } public String getAccountingEntryDescription() { return (String) get(PROPERTY_ACCOUNTINGENTRYDESCRIPTION); } public void setAccountingEntryDescription(String accountingEntryDescription) { set(PROPERTY_ACCOUNTINGENTRYDESCRIPTION, accountingEntryDescription); } public String getRecordID2() { return (String) get(PROPERTY_RECORDID2); } public void setRecordID2(String recordID2) { set(PROPERTY_RECORDID2, recordID2); } public Withholding getWithholding() { return (Withholding) get(PROPERTY_WITHHOLDING); } public void setWithholding(Withholding withholding) { set(PROPERTY_WITHHOLDING, withholding); } public DocumentType getDocumentType() { return (DocumentType) get(PROPERTY_DOCUMENTTYPE); } public void setDocumentType(DocumentType documentType) { set(PROPERTY_DOCUMENTTYPE, documentType); } }