View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.dataimport/I GLJournal

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.dataimport

Index

Contents

I_GLJournal

A new Journal Batch is created, if the Batch Document No is different. A new Journal is created, if the Document No, Accounting Schema, Currency, Document Type, GL Category, Posting Type or Accounting type is different.

Please note that there are three

This table contains the following columns:
Name Nullable Data Type Description
I_GLJournal_ID NVARCHAR2(32)Import General Ledger Journal
AD_Client_ID YVARCHAR2(32)Client for this installation.
ClientValue YNVARCHAR2(40)New Client Identifier
AD_OrgDoc_ID YVARCHAR2(32)Document Organization (independent from account organization)
IsActive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created YDATEThe date that this record is completed.
CreatedBy YVARCHAR2(32)User who created this records
Updated YDATEx not implemented
UpdatedBy YVARCHAR2(32)User who updated this records
I_IsImported YCHAR(1)A indication that the desired process has been completed successfully.
I_ErrorMsg YNVARCHAR2(2000)A message that appears when errors occur during the importing process.
Processing YCHAR(1)A request to process the respective document or task.
Processed YCHAR(1)A confirmation that the associated documents or requests are processed.
GL_JournalBatch_ID YVARCHAR2(32)General Ledger Journal Batch
BatchDocumentNo YNVARCHAR2(30)Document Number of the Batch
BatchDescription YNVARCHAR2(255)Description of the Batch
GL_Journal_ID YVARCHAR2(32)One transaction with a debit and credit and entered into the general ledger.
JournalDocumentNo YNVARCHAR2(30)Document number of the Journal
PostingType YVARCHAR2(60)A distinct posting amount characteristic used for processes and sometimes grouped within a category.
C_AcctSchema_ID YVARCHAR2(32)The structure used in accounting including costing methods, currencies, and the calendar.
AcctSchemaName YNVARCHAR2(60)Name of the Accounting Schema
C_DocType_ID YVARCHAR2(32)A value defining what sequence and process setup are used to handle this document.
DocTypeName YNVARCHAR2(60)A value defining what sequence and process setup are used to handle this document.
GL_Category_ID YVARCHAR2(32)A classification used to group lines in the general ledger.
CategoryName YNVARCHAR2(60)Name of the Category
C_Period_ID YVARCHAR2(32)A specified time period.
GL_Budget_ID YVARCHAR2(32)A group of planned expenses for a task.
GL_JournalLine_ID YVARCHAR2(32)General Ledger Journal Line
Line YNUMBER(10, 0)A line stating the position of this request in the document.
DateAcct YDATEThe date this transaction is recorded for in the general ledger.
Description YNVARCHAR2(255)A space to write additional related information.
AmtSourceDr YNUMBERThe amount debited from the account, given in provider currency.
AmtAcctDr YNUMBERThe amount debited to an account, converted to the organization default currency.
AmtSourceCr YNUMBERThe amount credited from the account, given in provider currency.
AmtAcctCr YNUMBERThe amount credited to an account, converted to the organization default currency.
C_Currency_ID YVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
ISO_Code YCHAR(3)A coding standard for countries.
CurrencyRateType YVARCHAR2(60)A distinct currency rate characteristic used for processes.
CurrencyRate YNUMBERThe percentage to be multiplied by the source to arrive at the tax or exchange amount.
C_UOM_ID YVARCHAR2(32)A non monetary unit of measure.
Qty YNUMBERThe number of a certain item.
C_ValidCombination_ID YVARCHAR2(32)An identification code comprised of an individual account number and additional dimensions such organization, product, and business partner.
OrgValue YNVARCHAR2(40)Key of the Organization
AD_Org_ID YVARCHAR2(32)Organizational entity within client
Account_ID YVARCHAR2(32)The identification code used for accounting.
AccountValue YNVARCHAR2(40)Key of Account Element
AD_OrgTrx_ID YVARCHAR2(32)The organization which performs or initiates the transaction.
OrgTrxValue YNVARCHAR2(40)Key of the Transaction Organization
M_Product_ID YVARCHAR2(32)An item produced by a process.
ProductValue YNVARCHAR2(40)A fast method for finding an item.
UPC YVARCHAR2(30)A bar code with a number to identify a product.
SKU YVARCHAR2(30)A "stock keeping unit" used to track items sold to business partners.
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
BPartnerValue YNVARCHAR2(40)An abbreviated name (or a code) to help find a business partner.
C_Project_ID YVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
ProjectValue YNVARCHAR2(40)Key of the Project
C_LocTo_ID YVARCHAR2(32)The location where items are sent to.
C_LocFrom_ID YVARCHAR2(32)The location where items are sent from.
C_SalesRegion_ID YVARCHAR2(32)A defined section of the world where sales efforts will be focused.
C_Activity_ID YVARCHAR2(32)A distinct activity defined and used in activity based management.
C_Campaign_ID YVARCHAR2(32)An advertising effort aimed at increasing sales.
User1_ID YVARCHAR2(32)A display of optional elements that are previously defined for this account combination.
User2_ID YVARCHAR2(32)A display of optional elements that are previously defined for this account combination.

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Import GL Journal

Import General Ledger Journal

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

New Client Identifier

New Client Identifier

top

Document Org

Foreign key column to AD_Org table, (column: AD_Org_ID)


Reference Table AD_Org (Trx) With the following where clause:

 
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'


top

Active

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Import Process Complete

The Imported check box indicates if this import has been processed.

top

Import Error Message

The Import Error Message displays any error messages generated during the import process.

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Processed

The Processed checkbox indicates that a document has been processed.

top

Journal Batch

Foreign key column to GL_JournalBatch table, (column: GL_JournalBatch_ID)

top

Batch Document No

Document Number of the Batch

top

Batch Description

Description of the Batch

top

Journal Entry

Foreign key column to GL_Journal table, (column: GL_Journal_ID)

top

Journal Document No

Document number of the Journal

top

Posting Type

The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated.

List values: All_Posting Type

The allowed values for this list are:

top

Accounting Schema

Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top

Account Schema Name

Name of the Accounting Schema

top

Document Type

Foreign key column to C_DocType table, (column: C_DocType_ID)

top

Document Type Name

A value defining what sequence and process setup are used to handle this document.

top

G/L Category

Foreign key column to GL_Category table, (column: GL_Category_ID)

top

Category Name

Name of the Category

top

Period

Foreign key column to C_Period table, (column: C_Period_ID)

top

Budget

The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts.

top

Journal Line

Foreign key column to GL_JournalLine table, (column: GL_JournalLine_ID)

top

Line No.

Indicates the unique line for a document. It will also control the display order of the lines within a document.

top

Accounting 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.

top

Description

A description is limited to 255 characters.

top

Foreign Currency Debit

The Source Debit Amount indicates the credit amount for this line in the source currency.

top

Debit

The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency

top

Foreign Currency Credit

The Source Credit Amount indicates the credit amount for this line in the source currency.

top

Credit

The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency

top

Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

ISO Code

For details - http://www.unece.org/trade/rec/rec09en.htm

top

Currency Rate Type

The Conversion Rate Type indicates the type of rate to use when retrieving the conversion rate. It allows you to define multiple rates for the same to and from currency. For example you may have a set of rates used for daily transactions with a rate type of SPOT and rates for currency revaluation defined as REVAL.

List values: C_Conversion_Rate Types

The allowed values for this list are:

top

Rate

The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency

top

UOM

Foreign key column to C_UOM table, (column: C_UOM_ID)

top

Quantity

The Quantity indicates the number of a specific product or item for this document.

top

Accounting Combination

Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top

Org Key

Key of the Organization

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Account

Foreign key column to C_ElementValue table, (column: C_ElementValue_ID)


Reference Table C_ElementValue (Accounts) With the following where clause:

 
C_ElementValue.IsSummary='N'


top

Account Key

Key of Account Element

top

Trx Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)


Reference Table AD_Org (Trx) With the following where clause:

 
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'


top

Trx Org Key

Key of the Transaction Organization

top

Product

Foreign key column to M_Product table, (column: M_Product_ID)

top

Product Search Key

A fast method for finding an item.

top

UPC/EAN

Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode)

top

SKU

The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.

top

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

Business Partner Search Key

An abbreviated name (or a code) to help find a business partner. Usually, a company's internal identifier is entered here.

top

Project

Foreign key column to C_Project table, (column: C_Project_ID)

top

Project Key

Key of the Project

top

Location to Address

Foreign key column to C_Location table, (column: C_Location_ID)


Reference Table C_Location

top

Location from Address

Foreign key column to C_Location table, (column: C_Location_ID)


Reference Table C_Location

top

Sales Region

Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)

top

Activity

Foreign key column to C_Activity table, (column: C_Activity_ID)

top

Sales Campaign

Foreign key column to C_Campaign table, (column: C_Campaign_ID)

top

1st Dimension

The user defined element displays the optional elements that have been defined for this account combination.

top

2nd Dimension

The user defined element displays the optional elements that have been defined for this account combination.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.dataimport/I_GLJournal"

This page has been accessed 3,866 times. This page was last modified on 15 April 2011, at 21:39. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.