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

Contents 1 C_BankStatementLine 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 Bank Statement 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 Bank Statement 1.2.10 Line No. 1.2.11 Description 1.2.12 Effective Date 1.2.13 Accounting Date 1.2.14 Currency 1.2.15 Transaction Amount 1.2.16 Statement Amount 1.2.16.1 Callout: SL_BankStmt_Amount 1.2.17 Charge 1.2.18 Charge Amount 1.2.18.1 Callout: SL_BankStmt_Amount 1.2.19 Memo 1.2.20 Reference No. 1.2.21 Payment 1.2.21.1 Callout: SL_BankDebt_Amount 1.2.22 Convert Charge amount 1.2.22.1 Callout: SL_BankStmt_Amount 1.2.23 Created Debt Payment 1.2.24 Payment Management 1.2.25 G/L Item 1.3 Related tables

C_BankStatementLine

The Statement Line Tab defines the individual line items on the Bank Statement. They can be entered manually or generated from payments entered.

• Name:FinancialMgmtBankStatementLine
• Classname:BankStatementLine

This table contains the following columns:

Name	Nullable	Data Type	Description
C_BankStatementLine_ID	N	VARCHAR2(32)	A statement displaying one transaction in the bank statement.
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_BankStatement_ID	N	VARCHAR2(32)	Bank Statement of account
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.
ValutaDate	N	DATE	Date when money is available
DateAcct	N	DATE	The date this transaction is recorded for in the general ledger.
C_Currency_ID	N	VARCHAR2(32)	An accepted medium of monetary exchange that may vary across countries.
TrxAmt	N	NUMBER	Amount of a transaction
StmtAmt	N	NUMBER	Statement Amount
C_Charge_ID	Y	VARCHAR2(32)	A cost or expense incurred during business activity.
ChargeAmt	N	NUMBER	The amount of a cost or expense incurred during business activity.
Memo	Y	NVARCHAR2(255)	Memo Text
ReferenceNo	Y	NVARCHAR2(40)	The number for a specific reference.
C_Debt_Payment_ID	Y	VARCHAR2(32)	A obligation to pay or a right to collect for a specified item or service.
ConvertChargeAmt	N	NUMBER	Convert Charge amount
C_Debt_Payment_Create	Y	CHAR(1)	Debt payment create
C_Dp_Management_ID	Y	VARCHAR2(32)	Debt Payment Management
C_Glitem_ID	Y	VARCHAR2(32)	An alias for the Account Combination which can be commonly used in daily operations.

Other Info

Check constraints

These are the check constraints for this table:

• C_BANKSTATLN_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
• C_BANKSTATLN_PA_GLITEM_ID_CHK: ((C_DEBT_PAYMENT_ID IS NOT NULL) AND (C_GLITEM_ID IS NULL)) OR (C_DEBT_PAYMENT_ID IS NULL)

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_BANKSTMTLINE_BANKSTMT
  • C_BankStatement_ID

Unique

• C_BANKSTATEMENTLINE_KEY
  • C_BankStatementLine_ID

top

Columns

Bank Statement Line

The Bank Statement Line identifies a unique transaction (Payment, Withdrawal, Charge) for the defined time period at this Bank.

• Physical column name: C_BankStatementLine_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

Bank Statement

• Physical column name: C_BankStatement_ID
• Property Name: bankStatement
• 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_BankStatement table, (column: C_BankStatement_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_BankStatementLine WHERE C_BankStatement_ID=@C_BankStatement_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

Effective Date

The Effective Date indicates the date that money is available from the bank.

• Physical column name: ValutaDate
• Property Name: effectiveDate
• Reference: Date
• Default value: @StatementDate@

top

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: @StatementDate@

top

Currency

• Physical column name: C_Currency_ID
• Property Name: currency
• Reference: TableDir
• Default value: @SQL=SELECT C_CURRENCY_ID FROM C_BANKACCOUNT WHERE C_BANKACCOUNT_ID = @C_BankAccount_ID@

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

top

Transaction Amount

The Transaction Amount indicates the amount for a single transaction.

• Physical column name: TrxAmt
• Property Name: transactionAmount
• Reference: Amount

top

Statement Amount

The Statement Amount indicates the amount of a single statement line.

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

Callout: SL_BankStmt_Amount

This element is linked to a callout.

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

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

Charge Amount

The Charge Amount indicates the amount for an additional charge.

• Physical column name: ChargeAmt
• Property Name: chargeAmount
• Reference: Amount

Callout: SL_BankStmt_Amount

This element is linked to a callout.

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

top

Memo

Memo Text

• Physical column name: Memo
• Property Name: memo
• Reference: String

top

Reference No.

The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.

• Physical column name: ReferenceNo
• Property Name: referenceNo
• Reference: String

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_BankDebt_Amount

This element is linked to a callout.

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

top

Convert Charge amount

The Convert Charge Amount indicates the amount for an additional charge due to currency conversions.

• Physical column name: ConvertChargeAmt
• Property Name: convertChargeAmount
• Reference: Amount
• Default value: 0

Callout: SL_BankStmt_Amount

This element is linked to a callout.

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

top

Created Debt Payment

Process to create a debt/payment.

• Physical column name: C_Debt_Payment_Create
• Property Name: createdDebtPayment
• Reference: Button
• Default value: N

top

Payment Management

• Physical column name: C_Dp_Management_ID
• Property Name: paymentManagement
• Reference: TableDir

Foreign key column to C_Dp_Management table, (column: C_Dp_Management_ID)

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)

top

Related tables

Tables that link this table:

• DebtPaymentV.Bank Statement Line

top