ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.gl/GL Journal
GL_Journal
The GL Journal Tab defines the control parameters for a single GL Journal.
- Name:FinancialMgmtGLJournal
- Classname:GLJournal
This table contains the following columns:
Name | Nullable | Data Type | Description |
GL_Journal_ID | N | VARCHAR2(32) | One transaction with a debit and credit and entered into the general ledger. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
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. |
C_Campaign_ID | Y | VARCHAR2(32) | An advertising effort aimed at increasing sales. |
C_Project_ID | Y | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
C_AcctSchema_ID | N | VARCHAR2(32) | The structure used in accounting including costing methods, currencies, and the calendar. |
C_DocType_ID | N | VARCHAR2(32) | A value defining what sequence and process setup are used to handle this document. |
DocumentNo | N | NVARCHAR2(30) | An often automatically generated identifier for all documents. |
DocStatus | N | VARCHAR2(60) | The Document Status indicates the status of a document at this time. |
DocAction | N | VARCHAR2(60) | A means of changing the transaction status of the document. |
IsApproved | N | CHAR(1) | Indicates if this document requires approval |
IsPrinted | Y | CHAR(1) | A reference stating whether or not the document has been printed at any time in the past. |
Description | N | NVARCHAR2(255) | A space to write additional related information. |
PostingType | N | VARCHAR2(60) | A distinct posting amount characteristic used for processes and sometimes grouped within a category. |
GL_Category_ID | N | VARCHAR2(32) | A classification used to group lines in the general ledger. |
DateDoc | N | DATE | The time listed on the document. |
DateAcct | N | DATE | The date this transaction is recorded for in the general ledger. |
C_Period_ID | N | VARCHAR2(32) | A specified time period. |
C_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
CurrencyRateType | N | VARCHAR2(60) | A distinct currency rate characteristic used for processes. |
CurrencyRate | N | NUMBER | The percentage to be multiplied by the source to arrive at the tax or exchange amount. |
GL_JournalBatch_ID | Y | VARCHAR2(32) | General Ledger Journal Batch |
TotalDr | N | NUMBER | Total debit in document currency |
TotalCr | N | NUMBER | Total Credit in document currency |
ControlAmt | Y | NUMBER | If not zero, the Debit amount of the document must be equal this amount |
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. |
Posted | N | VARCHAR2(60) | An accounting status button that indicates if the transaction has already been posted to the general ledger or not. |
IsOpening | N | CHAR(1) | A flag indicating this is an opening entry |
Other Info
Check constraints
These are the check constraints for this table:
- GL_JOURNAL_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- GL_JOURNAL_ISAPPROVED_CHECK: ISAPPROVED IN ('Y', 'N')
- GL_JOURNAL_ISPRINTED_CHECK: ISPRINTED IN ('Y', 'N')
- GL_JOURNAL_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
- GL_JOURNAL_DOCNO
- GL_JOURNAL_KEY
Columns
Journal Entry
The General Ledger Journal identifies a group of journal lines which represent a logical business transaction
- Physical column name: GL_Journal_ID
- Property Name: id
- Reference: ID
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)
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)
Validation Rule AD_Org show child organizations: It only shows the child organizations of the organization's header. With the following code:
AD_ISORGINCLUDED(ad_org.ad_org_id, @AD_ORG_ID@, ad_org.ad_client_id)<>-1 AND IsReady='Y'
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
- Default value: Y
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)
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
Sales Campaign
- Physical column name: C_Campaign_ID
- Property Name: salesCampaign
- Reference: TableDir
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: TableDir
Foreign key column to C_Project table, (column: C_Project_ID)
Accounting Schema
- Physical column name: C_AcctSchema_ID
- Property Name: accountingSchema
- Reference: TableDir
- Default value: @$C_AcctSchema_ID@
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)
Validation Rule C_AcctSchema - Schemas matching parent organizations: null. With the following code:
EXISTS (SELECT 1 FROM AD_ORG_ACCTSCHEMA WHERE AD_ORG_ACCTSCHEMA.C_ACCTSCHEMA_ID = C_ACCTSCHEMA.C_ACCTSCHEMA_ID AND (AD_ISORGINCLUDED(@AD_Org_ID@, AD_ORG_ID, AD_CLIENT_ID)<>-1))
Document Type
- Physical column name: C_DocType_ID
- Property Name: documentType
- Reference: TableDir
- Default value: @C_DocType_ID@
Foreign key column to C_DocType table, (column: C_DocType_ID)
Validation Rule C_DocType Journals: Document Type Journal. With the following code:
C_DocType.DocBaseType='GLJ' AND AD_ISORGINCLUDED( @AD_Org_ID@, C_DocType.AD_Org_ID, @#AD_Client_ID@) <> '-1'
Document No.
The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>". If the document type of your document has no automatic document sequence defined, the field will be empty when creating a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Document Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table inside the database (e.g. C_Order).
- Physical column name: DocumentNo
- Property Name: documentNo
- Reference: String
- This column is part of the table's identifier
Document Status
The Document Status indicates the status of a document at this time. To change the status of a document, use one of the buttons usually located at the bottom of the document window.
- Physical column name: DocStatus
- Property Name: documentStatus
- Reference: List
- Default value: DR
List values: All_Document Status
The allowed values for this list are:
- ?? (Unknown)
- AP (Accepted)
- CH (Modified)
- CL (Closed)
- CO (Completed)
- DR (Draft)
- IN (Inactive)
- IP (Under Way)
- NA (Not Accepted)
- PE (Accounting Error)
- PO (Posted)
- PR (Printed)
- RE (Re-Opened)
- TE (Transfer Error)
- TR (Transferred)
- VO (Voided)
- WP (Not Paid)
- XX (Procesando)
Document Action
You find the current status in the Document Status field. The options are listed in a popup
- Physical column name: DocAction
- Property Name: documentAction
- Reference: Button
- Default value: CO
Approved
The Approved checkbox indicates if this document requires approval before it can be processed.
- Physical column name: IsApproved
- Property Name: approved
- Reference: YesNo
- Default value: Y
The Printed checkbox indicates if this document or line will included when printing.
- Physical column name: IsPrinted
- Property Name: print
- Reference: YesNo
- Default value: N
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
- Default value: @DESCRIPTION1@
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
- Default value: @PostingType@
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
G/L Category
- Physical column name: GL_Category_ID
- Property Name: gLCategory
- Reference: TableDir
- Default value: @GL_Category_ID@
Foreign key column to GL_Category table, (column: GL_Category_ID)
Validation Rule GL_Category for Manual Journals: Manual Journal GL Category. With the following code:
GL_Category.CategoryType='M'
Document Date
The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date.
- Physical column name: DateDoc
- Property Name: documentDate
- Reference: Date
- Default value: @DateDoc@
Callout: SL_Journal_Period
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Journal_Period Java class.
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
- Default value: @DateAcct@
Callout: SL_Journal_Period
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Journal_Period Java class.
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: Table
- Default value: @C_Period_ID@
Foreign key column to C_Period table, (column: C_Period_ID)
Reference Table C_Period (Open) With the following where clause:
EXISTS (SELECT * FROM C_PeriodControl pc WHERE C_Period.C_Period_ID=pc.C_Period_ID AND pc.PeriodStatus='O')
Callout: SL_Journal_Period
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Journal_Period Java class.
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
- Default value: @C_Currency_ID@
Foreign key column to C_Currency table, (column: C_Currency_ID)
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
- Default value: S
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
- Default value: 1
Journal Batch
- Physical column name: GL_JournalBatch_ID
- Property Name: journalBatch
- Reference: Search
- This column is a child for a buisiness object (is Parent)
Foreign key column to GL_JournalBatch table, (column: GL_JournalBatch_ID)
Total Debit Amount
The Total Debit indicates the total debit amount for a journal or journal batch in the source currency
- Physical column name: TotalDr
- Property Name: totalDebitAmount
- Reference: Amount
- Default value: 0
Total Credit Amount
The Total Credit indicates the total credit amount for a journal or journal batch in the source currency
- Physical column name: TotalCr
- Property Name: totalCreditAmount
- Reference: Amount
- Default value: 0
Control Amount
If the control amount is zero, no check is performed.Otherwise the total Debit amount must be equal to the control amount, before the document is processed.
- Physical column name: ControlAmt
- Property Name: controlAmount
- Reference: Amount
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
Posted
An accounting status button that indicates if the transaction has already been posted to the general ledger or not. When doing the accounting manually this button can be used to post or unpost the transaction from the general ledger by hand.
- Physical column name: Posted
- Property Name: posted
- Reference: Button
- Default value: N
Opening
A flag indicating this is an opening entry
- Physical column name: IsOpening
- Property Name: opening
- Reference: YesNo
- Default value: N