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

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.cashmgmt/C CashLine

Contents

C_CashLine

The Cash Line Tab defines the individual lines for this journal.

This table contains the following columns:

Name Nullable Data Type Description
C_CashLine_ID NVARCHAR2(32)A statement displaying one transaction in the cash journal.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
C_Cash_ID NVARCHAR2(32)Cash Journal
Line NNUMBER(10, 0)A line stating the position of this request in the document.
Description YNVARCHAR2(255)A space to write additional related information.
CashType NVARCHAR2(60)Source of Cash
C_Charge_ID YVARCHAR2(32)A cost or expense incurred during business activity.
C_Currency_ID YVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
Amount NNUMBERA monetary total.
DiscountAmt YNUMBERx not implemented
WriteOffAmt YNUMBERA monetary sum that can be deducted from tax obligations.
IsGenerated YCHAR(1)This Line is generated
C_Order_ID YVARCHAR2(32)A unique and often automatically generated identifier for a sales order.
C_Debt_Payment_ID YVARCHAR2(32)A obligation to pay or a right to collect for a specified item or service.
C_Glitem_ID YVARCHAR2(32)An alias for the Account Combination which can be commonly used in daily operations.
PayInAdvance YCHAR(1)Create a payment in advance

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):

Non Unique

Unique

top

Columns

Cash Journal Line

The Cash Journal Line indicates a unique line in a cash journal.

top

Client

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

top

Organization

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'

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

Cash Journal

Foreign key column to C_Cash table, (column: C_Cash_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

Description

A description is limited to 255 characters.

top

Cash Type

The Cash Type indicates the source for this Cash Journal Line.

List values: C_Cash Trx Type

The allowed values for this list are:

top

Charge

Foreign key column to C_Charge table, (column: C_Charge_ID)

top

Currency

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

top

Amount

The Amount indicates the amount for this document line.

Callout: SL_CashJournal_Amounts

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_CashJournal_Amounts Java class.

top

Discount Amount

The Discount Amount indicates the discount amount for a document or line.

Callout: SL_CashJournal_Amounts

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_CashJournal_Amounts Java class.

top

Write-off Amount

The Write Off Amount indicates the amount to be written off as uncollectible.

Callout: SL_CashJournal_Amounts

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_CashJournal_Amounts Java class.

top

Generated

The Generated checkbox identifies a journal line that was generated from a source document. Lines could also be entered manually or imported.

top

Sales Order

Foreign key column to C_Order table, (column: C_Order_ID)

Callout: SL_CashJournal_Amounts

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_CashJournal_Amounts Java class.

top

Payment

Foreign key column to C_Debt_Payment table, (column: C_Debt_Payment_ID)

Callout: SL_CashJournal_Amounts

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_CashJournal_Amounts Java class.

top

G/L Item

Foreign key column to C_Glitem table, (column: C_Glitem_ID)


Validation Rule C_Glitem cash: null. With the following code:

 
EnableInCash='Y'

top

Create a payment in advance

Create a payment in advance

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.cashmgmt/C_CashLine"

This page has been accessed 4,002 times. This page was last modified on 2 July 2011, at 20:55. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.