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

Contents 1 C_CashLine 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Non Unique 1.1.2.2 Unique 1.2 Columns 1.2.1 Cash Journal Line 1.2.2 Client 1.2.3 Organization 1.2.4 Active 1.2.5 Creation Date 1.2.6 Created By 1.2.7 Updated 1.2.8 Updated By 1.2.9 Cash Journal 1.2.10 Line No. 1.2.11 Description 1.2.12 Cash Type 1.2.12.1 List values: C_Cash Trx Type 1.2.13 Charge 1.2.14 Currency 1.2.15 Amount 1.2.15.1 Callout: SL_CashJournal_Amounts 1.2.16 Discount Amount 1.2.16.1 Callout: SL_CashJournal_Amounts 1.2.17 Write-off Amount 1.2.17.1 Callout: SL_CashJournal_Amounts 1.2.18 Generated 1.2.19 Sales Order 1.2.19.1 Callout: SL_CashJournal_Amounts 1.2.20 Payment 1.2.20.1 Callout: SL_CashJournal_Amounts 1.2.21 G/L Item 1.2.22 Create a payment in advance 1.3 Related tables

C_CashLine

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

• Name:FinancialMgmtJournalLine
• Classname:CashJournalLine

This table contains the following columns:

Name	Nullable	Data Type	Description
C_CashLine_ID	N	VARCHAR2(32)	A statement displaying one transaction in the cash journal.
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
C_Cash_ID	N	VARCHAR2(32)	Cash Journal
Line	N	NUMBER(10, 0)	A line stating the position of this request in the document.
Description	Y	NVARCHAR2(255)	A space to write additional related information.
CashType	N	VARCHAR2(60)	Source of Cash
C_Charge_ID	Y	VARCHAR2(32)	A cost or expense incurred during business activity.
C_Currency_ID	Y	VARCHAR2(32)	An accepted medium of monetary exchange that may vary across countries.
Amount	N	NUMBER	A monetary total.
DiscountAmt	Y	NUMBER	x not implemented
WriteOffAmt	Y	NUMBER	A monetary sum that can be deducted from tax obligations.
IsGenerated	Y	CHAR(1)	This Line is generated
C_Order_ID	Y	VARCHAR2(32)	A unique and often automatically generated identifier for a sales order.
C_Debt_Payment_ID	Y	VARCHAR2(32)	A obligation to pay or a right to collect for a specified item or service.
C_Glitem_ID	Y	VARCHAR2(32)	An alias for the Account Combination which can be commonly used in daily operations.
PayInAdvance	Y	CHAR(1)	Create a payment in advance

Other Info

Check constraints

These are the check constraints for this table:

• C_CASHLINE_CASHTYPE_CHK: ((CASHTYPE) <> 'C') OR (C_CHARGE_ID IS NOT NULL)
• C_CASHLINE_CASHTYPE_CHK1: ((CASHTYPE) <> 'G') OR (C_GLITEM_ID IS NOT NULL)
• C_CASHLINE_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
• C_CASHLINE_ISGENERATED_CHK: ISGENERATED IN ('Y', 'N')

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

• C_CASHLINE_CASH
  • C_Cash_ID
• C_CASHLINE_ORDER
  • C_Order_ID

Unique

• C_CASHLINE_DEBT_PAYMENT
  • C_Debt_Payment_ID
• C_CASHLINE_KEY
  • C_CashLine_ID

top

Columns

Cash Journal Line

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

• Physical column name: C_CashLine_ID
• Property Name: id
• Reference: ID

top

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)

top

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'

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.

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo

top

Creation Date

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

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime

top

Created By

• Physical column name: CreatedBy
• Property Name: createdBy
• Reference: Search

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

top

Updated

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

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime

top

Updated By

• Physical column name: UpdatedBy
• Property Name: updatedBy
• Reference: Search

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

top

Cash Journal

• Physical column name: C_Cash_ID
• Property Name: cashJournal
• Reference: Search
• This column is part of the table's identifier
• This column is a child for a buisiness object (is Parent)

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.

• Physical column name: Line
• Property Name: lineNo
• Reference: Integer
• Default value: @SQL=SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM C_CashLine WHERE C_Cash_ID=@C_Cash_ID@
• This column is part of the table's identifier

top

Description

A description is limited to 255 characters.

• Physical column name: Description
• Property Name: description
• Reference: String

top

Cash Type

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

• Physical column name: CashType
• Property Name: cashType
• Reference: List
• Default value: E

List values: C_Cash Trx Type

The allowed values for this list are:

• A (Pay In Advance): Pay in advance
• C (Charge)
• D (Difference)
• E (General Expense)
• G (G/L Item)
• O (Order)
• P (Debt-Payment)
• R (General Receipts)

top

Charge

• Physical column name: C_Charge_ID
• Property Name: charge
• Reference: TableDir

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

top

Currency

• Physical column name: C_Currency_ID
• Property Name: currency
• Reference: TableDir
• Default value: @SQL=SELECT C_CURRENCY_ID FROM C_CASHBOOK WHERE C_CASHBOOK_ID = @C_CashBook_ID@

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

top

Amount

The Amount indicates the amount for this document line.

• Physical column name: Amount
• Property Name: amount
• Reference: Amount
• This column is part of the table's identifier

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.

• Physical column name: DiscountAmt
• Property Name: discountAmount
• Reference: Amount

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.

• Physical column name: WriteOffAmt
• Property Name: writeoffAmount
• Reference: Amount

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.

• Physical column name: IsGenerated
• Property Name: generated
• Reference: YesNo
• Default value: N

top

Sales Order

• Physical column name: C_Order_ID
• Property Name: salesOrder
• Reference: Search

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

• Physical column name: C_Debt_Payment_ID
• Property Name: payment
• Reference: Search

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

• Physical column name: C_Glitem_ID
• Property Name: gLItem
• Reference: TableDir

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

• Physical column name: PayInAdvance
• Property Name: createAPaymentInAdvance
• Reference: Button

top

Related tables

Tables that link this table:

• DebtPaymentV.Cash Journal Line

top