ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.cashmgmt/C Cash Detail
C_Cash_Detail
- Name:CashDetail
- Classname:CashDetail
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_Cash_ID | N | VARCHAR2(32) | Cash Journal |
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_CashBook_ID | N | VARCHAR2(32) | A document used to manage all cash transactions. |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
StatementDate | N | DATE | The date the transaction is carried out and registered in the cash journal. |
DateAcct | N | DATE | The date this transaction is recorded for in the general ledger. |
Processed | N | VARCHAR2(60) | 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. |
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_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
Amount | N | NUMBER | A monetary total. |
ConvertedAmt | Y | NUMBER | The monetary sum at which one unit of measure is changed to another. |
C_Debt_Payment_ID | Y | VARCHAR2(32) | A obligation to pay or a right to collect for a specified item or service. |
C_Charge_ID | Y | VARCHAR2(32) | A cost or expense incurred during business activity. |
Columns
Cash Journal
- Physical column name: C_Cash_ID
- Reference: Search
- This column is part of the table's identifier
Foreign key column to C_Cash table, (column: C_Cash_ID)
Cash Journal Line
- Physical column name: C_CashLine_ID
- Reference: Search
Foreign key column to C_CashLine table, (column: C_CashLine_ID)
Client
- Physical column name: AD_Client_ID
- 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
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
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
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Reference: DateTime
Created By
- Physical column 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
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Cashbook
- Physical column name: C_CashBook_ID
- Reference: TableDir
Foreign key column to C_CashBook table, (column: C_CashBook_ID)
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Reference: String
Transaction Date
The Statement Date field defines the date of the statement being processed.
- Physical column name: StatementDate
- Reference: Date
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
- Reference: Date
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column 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
- Reference: List
List values: All_Posted Status
The allowed values for this list are:
- C (Post: Error, No cost)
- D (Post: Document Disabled): Document disabled for accounting
- E (Post: Error)
- N (Post)
- Y (Unpost)
- b (Post: Not Balanced)
- c (Post: Not Convertible (no rate))
- d (Post: Disabled For Background)
- i (Post: Invalid Account)
- p (Post: Period Closed)
- y (Post: Post Prepared)
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
- Reference: Integer
Description
A description is limited to 255 characters.
- Physical column name: Description
- Reference: String
Cash Type
The Cash Type indicates the source for this Cash Journal Line.
- Physical column name: CashType
- Reference: List
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)
Currency
- Physical column name: C_Currency_ID
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Amount
The Amount indicates the amount for this document line.
- Physical column name: Amount
- Reference: Amount
Converted Amount
The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency.
- Physical column name: ConvertedAmt
- Reference: Amount
Payment
- Physical column name: C_Debt_Payment_ID
- Reference: Search
Foreign key column to C_Debt_Payment table, (column: C_Debt_Payment_ID)
Charge
- Physical column name: C_Charge_ID
- Reference: TableDir
Foreign key column to C_Charge table, (column: C_Charge_ID)