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

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/FIN BankStatementLine

Contents

FIN_BankStatementLine

Line related to the given Bank Statement

This table contains the following columns:

Name Nullable Data Type Description
FIN_Bankstatementline_ID NVARCHAR2(32)Line related to the bank statement
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
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
Isactive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
FIN_Bankstatement_ID NVARCHAR2(32)Bank statements related to a financial account
Line NNUMBER(10, 0)A line stating the position of this request in the document.
Bpartnername YNVARCHAR2(60)Business Partner Name
C_Bpartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Datetrx NDATEThe date that a specified transaction is entered into the application.
Cramount NNUMBERAmount credited. Reflects amount IN
Dramount NNUMBERAmount Debited. Reflects the amount OUT
Referenceno NNVARCHAR2(30)The number for a specific reference.
Matchingtype YVARCHAR2(60)Type of matching for the given line
FIN_FinAcc_Transaction_ID YVARCHAR2(32)null
Description YNVARCHAR2(2000)A space to write additional related information.

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

Unique

top

Columns

FIN_Bankstatementline_ID

Line related to the bank statement

top

Client

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


Validation Rule AD_Client Trx Security validation: null. With the following code:

 
AD_Client.AD_Client_ID<>'0'

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)


Validation Rule AD_Org Trx Security validation: null. With the following code:

 
AD_Org.AD_Org_ID<> '0' AND AD_Org.IsReady='Y'

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

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

Bank Statement

Foreign key column to FIN_Bankstatement table, (column: FIN_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.

top

Bpartnername

Business Partner Name

top

Business Partner

Foreign key column to C_Bpartner table, (column: C_BPartner_ID)

top

Transaction Date

The Transaction Date indicates the date of the transaction.

top

Cramount

Amount credited. Reflects amount IN

top

Dramount

Amount Debited. Reflects the amount OUT

top

Reference No.

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

top

Matchingtype

Type of matching for the given line

List values: FIN_Matching Type

The allowed values for this list are:

top

Financial account transaction

Foreign key column to FIN_FinAcc_Transaction table, (column: Fin_Finacc_Transaction_ID)

top

Description

A description is limited to 255 characters.

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.payment/FIN_BankStatementLine"

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