ERP/3.0/Developers Guide/Database Model/org.openbravo.model.dataimport/I GLJournal
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
- Name:DataImportGLJournal
- Classname:GLJournal
| Name | Nullable | Data Type | Description |
| I_GLJournal_ID | N | VARCHAR2(32) | Import General Ledger Journal |
| AD_Client_ID | Y | VARCHAR2(32) | Client for this installation. |
| ClientValue | Y | NVARCHAR2(40) | New Client Identifier |
| AD_OrgDoc_ID | Y | VARCHAR2(32) | Document Organization (independent from account organization) |
| IsActive | Y | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
| Created | Y | DATE | The date that this record is completed. |
| CreatedBy | Y | VARCHAR2(32) | User who created this records |
| Updated | Y | DATE | x not implemented |
| UpdatedBy | Y | VARCHAR2(32) | User who updated this records |
| I_IsImported | Y | CHAR(1) | A indication that the desired process has been completed successfully. |
| I_ErrorMsg | Y | NVARCHAR2(2000) | A message that appears when errors occur during the importing process. |
| Processing | Y | CHAR(1) | A request to process the respective document or task. |
| Processed | Y | CHAR(1) | A confirmation that the associated documents or requests are processed. |
| GL_JournalBatch_ID | Y | VARCHAR2(32) | General Ledger Journal Batch |
| BatchDocumentNo | Y | NVARCHAR2(30) | Document Number of the Batch |
| BatchDescription | Y | NVARCHAR2(255) | Description of the Batch |
| GL_Journal_ID | Y | VARCHAR2(32) | One transaction with a debit and credit and entered into the general ledger. |
| JournalDocumentNo | Y | NVARCHAR2(30) | Document number of the Journal |
| PostingType | Y | VARCHAR2(60) | A distinct posting amount characteristic used for processes and sometimes grouped within a category. |
| C_AcctSchema_ID | Y | VARCHAR2(32) | The structure used in accounting including costing methods, currencies, and the calendar. |
| AcctSchemaName | Y | NVARCHAR2(60) | Name of the Accounting Schema |
| C_DocType_ID | Y | VARCHAR2(32) | A value defining what sequence and process setup are used to handle this document. |
| DocTypeName | Y | NVARCHAR2(60) | A value defining what sequence and process setup are used to handle this document. |
| GL_Category_ID | Y | VARCHAR2(32) | A classification used to group lines in the general ledger. |
| CategoryName | Y | NVARCHAR2(60) | Name of the Category |
| C_Period_ID | Y | VARCHAR2(32) | A specified time period. |
| GL_Budget_ID | Y | VARCHAR2(32) | A group of planned expenses for a task. |
| GL_JournalLine_ID | Y | VARCHAR2(32) | General Ledger Journal Line |
| Line | Y | NUMBER(10, 0) | A line stating the position of this request in the document. |
| DateAcct | Y | DATE | The date this transaction is recorded for in the general ledger. |
| Description | Y | NVARCHAR2(255) | A space to write additional related information. |
| AmtSourceDr | Y | NUMBER | The amount debited from the account, given in provider currency. |
| AmtAcctDr | Y | NUMBER | The amount debited to an account, converted to the organization default currency. |
| AmtSourceCr | Y | NUMBER | The amount credited from the account, given in provider currency. |
| AmtAcctCr | Y | NUMBER | The amount credited to an account, converted to the organization default currency. |
| C_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
| ISO_Code | Y | CHAR(3) | A coding standard for countries. |
| CurrencyRateType | Y | VARCHAR2(60) | A distinct currency rate characteristic used for processes. |
| CurrencyRate | Y | NUMBER | The percentage to be multiplied by the source to arrive at the tax or exchange amount. |
| C_UOM_ID | Y | VARCHAR2(32) | A non monetary unit of measure. |
| Qty | Y | NUMBER | The number of a certain item. |
| C_ValidCombination_ID | Y | VARCHAR2(32) | An identification code comprised of an individual account number and additional dimensions such organization, product, and business partner. |
| OrgValue | Y | NVARCHAR2(40) | Key of the Organization |
| AD_Org_ID | Y | VARCHAR2(32) | Organizational entity within client |
| Account_ID | Y | VARCHAR2(32) | The identification code used for accounting. |
| AccountValue | Y | NVARCHAR2(40) | Key of Account Element |
| AD_OrgTrx_ID | Y | VARCHAR2(32) | The organization which performs or initiates the transaction. |
| OrgTrxValue | Y | NVARCHAR2(40) | Key of the Transaction Organization |
| M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
| ProductValue | Y | NVARCHAR2(40) | A fast method for finding an item. |
| UPC | Y | VARCHAR2(30) | A bar code with a number to identify a product. |
| SKU | Y | VARCHAR2(30) | A "stock keeping unit" used to track items sold to business partners. |
| C_BPartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
| BPartnerValue | Y | NVARCHAR2(40) | An abbreviated name (or a code) to help find a business partner. |
| C_Project_ID | Y | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
| ProjectValue | Y | NVARCHAR2(40) | Key of the Project |
| C_LocTo_ID | Y | VARCHAR2(32) | The location where items are sent to. |
| C_LocFrom_ID | Y | VARCHAR2(32) | The location where items are sent from. |
| C_SalesRegion_ID | Y | VARCHAR2(32) | A defined section of the world where sales efforts will be focused. |
| C_Activity_ID | Y | VARCHAR2(32) | A distinct activity defined and used in activity based management. |
| C_Campaign_ID | Y | VARCHAR2(32) | An advertising effort aimed at increasing sales. |
| User1_ID | Y | VARCHAR2(32) | A display of optional elements that are previously defined for this account combination. |
| User2_ID | Y | VARCHAR2(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:
- I_GLJOURNAL_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- I_GLJOURNAL_I_ISIMPORTED_CHK: I_ISIMPORTED IN ('Y', 'N')
- I_GLJOURNAL_PROCESSED_CHECK: PROCESSED IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- I_GLJOURNAL_KEY
Columns
Import GL Journal
Import General Ledger Journal
- Physical column name: I_GLJournal_ID
- Property Name: id
- Reference: ID
- This column is part of the table's identifier
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
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@)
New Client Identifier
New Client Identifier
- Physical column name: ClientValue
- Property Name: newClientIdentifier
- Reference: String
Document Org
- Physical column name: AD_OrgDoc_ID
- Property Name: documentOrg
- Reference: Table
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'
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.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Import Process Complete
The Imported check box indicates if this import has been processed.
- Physical column name: I_IsImported
- Property Name: importProcessComplete
- Reference: YesNo
Import Error Message
The Import Error Message displays any error messages generated during the import process.
- Physical column name: I_ErrorMsg
- Property Name: importErrorMessage
- Reference: String
Process Now
When this field is set as 'Y' a process is being performed on this record.
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column name: Processed
- Property Name: processed
- Reference: YesNo
Journal Batch
- Physical column name: GL_JournalBatch_ID
- Property Name: journalBatch
- Reference: Search
Foreign key column to GL_JournalBatch table, (column: GL_JournalBatch_ID)
Batch Document No
Document Number of the Batch
- Physical column name: BatchDocumentNo
- Property Name: batchDocumentNo
- Reference: String
Batch Description
Description of the Batch
- Physical column name: BatchDescription
- Property Name: batchDescription
- Reference: String
Journal Entry
- Physical column name: GL_Journal_ID
- Property Name: journalEntry
- Reference: Search
Foreign key column to GL_Journal table, (column: GL_Journal_ID)
Journal Document No
Document number of the Journal
- Physical column name: JournalDocumentNo
- Property Name: journalDocumentNo
- Reference: String
Posting Type
The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated.
- Physical column name: PostingType
- Property Name: postingType
- Reference: List
List values: All_Posting Type
The allowed values for this list are:
- A (Actual): Actual Postings
- B (Budget): Budget Postings
- E (Encumbrance): Encumbrance or Commitment Postings
- S (Statistical): Statistical Postings
Accounting Schema
- Physical column name: C_AcctSchema_ID
- Property Name: accountingSchema
- Reference: TableDir
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)
Account Schema Name
Name of the Accounting Schema
- Physical column name: AcctSchemaName
- Property Name: accountSchemaName
- Reference: String
Document Type
- Physical column name: C_DocType_ID
- Property Name: documentType
- Reference: TableDir
Foreign key column to C_DocType table, (column: C_DocType_ID)
Document Type Name
A value defining what sequence and process setup are used to handle this document.
- Physical column name: DocTypeName
- Property Name: documentTypeName
- Reference: String
G/L Category
- Physical column name: GL_Category_ID
- Property Name: gLCategory
- Reference: TableDir
Foreign key column to GL_Category table, (column: GL_Category_ID)
Category Name
Name of the Category
- Physical column name: CategoryName
- Property Name: categoryName
- Reference: String
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: TableDir
Foreign key column to C_Period table, (column: C_Period_ID)
Budget
The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts.
- Physical column name: GL_Budget_ID
- Property Name: budget
- Reference: String
Journal Line
- Physical column name: GL_JournalLine_ID
- Property Name: journalLine
- Reference: Search
Foreign key column to GL_JournalLine table, (column: GL_JournalLine_ID)
Line No.
Indicates the unique line for a document. It will also control the display order of the lines within a document.
- Physical column name: Line
- Property Name: lineNo
- Reference: Integer
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.
- Physical column name: DateAcct
- Property Name: accountingDate
- Reference: Date
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Foreign Currency Debit
The Source Debit Amount indicates the credit amount for this line in the source currency.
- Physical column name: AmtSourceDr
- Property Name: foreignCurrencyDebit
- Reference: Amount
Debit
The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency
- Physical column name: AmtAcctDr
- Property Name: debit
- Reference: Amount
Foreign Currency Credit
The Source Credit Amount indicates the credit amount for this line in the source currency.
- Physical column name: AmtSourceCr
- Property Name: foreignCurrencyCredit
- Reference: Amount
Credit
The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency
- Physical column name: AmtAcctCr
- Property Name: credit
- Reference: Amount
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
ISO Code
For details - http://www.unece.org/trade/rec/rec09en.htm
- Physical column name: ISO_Code
- Property Name: iSOCode
- Reference: String
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.
- Physical column name: CurrencyRateType
- Property Name: currencyRateType
- Reference: List
List values: C_Conversion_Rate Types
The allowed values for this list are:
- A (Average): Average Rates
- C (Company): Company Rate
- F (Fixed): Euro Fixed Currency
- M (Manual Rate): Manual Rate
- N (None): No Conversion Rate
- P (Period End): Period Conversion Type
- S (Spot): Spot Conversation Rate Type
- U (User Type): User Rate Type
Rate
The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency
- Physical column name: CurrencyRate
- Property Name: rate
- Reference: Number
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
Quantity
The Quantity indicates the number of a specific product or item for this document.
- Physical column name: Qty
- Property Name: quantity
- Reference: Quantity
Accounting Combination
- Physical column name: C_ValidCombination_ID
- Property Name: accountingCombination
- Reference: Search
Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)
Org Key
Key of the Organization
- Physical column name: OrgValue
- Property Name: orgKey
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Account
- Physical column name: Account_ID
- Property Name: account
- Reference: Table
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'
Account Key
Key of Account Element
- Physical column name: AccountValue
- Property Name: accountKey
- Reference: String
Trx Organization
- Physical column name: AD_OrgTrx_ID
- Property Name: trxOrganization
- Reference: Table
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'
Trx Org Key
Key of the Transaction Organization
- Physical column name: OrgTrxValue
- Property Name: trxOrgKey
- Reference: String
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Product Search Key
A fast method for finding an item.
- Physical column name: ProductValue
- Property Name: productSearchKey
- Reference: String
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)
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
SKU
The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.
- Physical column name: SKU
- Property Name: sKU
- Reference: String
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
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.
- Physical column name: BPartnerValue
- Property Name: businessPartnerSearchKey
- Reference: String
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: Search
Foreign key column to C_Project table, (column: C_Project_ID)
Project Key
Key of the Project
- Physical column name: ProjectValue
- Property Name: projectKey
- Reference: String
Location to Address
- Physical column name: C_LocTo_ID
- Property Name: locationToAddress
- Reference: Table
Foreign key column to C_Location table, (column: C_Location_ID)
Reference Table C_Location
Location from Address
- Physical column name: C_LocFrom_ID
- Property Name: locationFromAddress
- Reference: Table
Foreign key column to C_Location table, (column: C_Location_ID)
Reference Table C_Location
Sales Region
- Physical column name: C_SalesRegion_ID
- Property Name: salesRegion
- Reference: TableDir
Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)
Activity
- Physical column name: C_Activity_ID
- Property Name: activity
- Reference: TableDir
Foreign key column to C_Activity table, (column: C_Activity_ID)
Sales Campaign
- Physical column name: C_Campaign_ID
- Property Name: salesCampaign
- Reference: TableDir
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
1st Dimension
The user defined element displays the optional elements that have been defined for this account combination.
- Physical column name: User1_ID
- Property Name: stDimension
- Reference: String
2nd Dimension
The user defined element displays the optional elements that have been defined for this account combination.
- Physical column name: User2_ID
- Property Name: ndDimension
- Reference: String