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

Contents 1 FIN_PaymentMethod 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Unique 1.2 Columns 1.2.1 Payment Method 1.2.2 Client 1.2.3 Organization 1.2.4 Creation Date 1.2.5 Created By 1.2.6 Updated 1.2.7 Updated By 1.2.8 Active 1.2.9 Name 1.2.10 Description 1.2.11 Automatic Receipt 1.2.12 Automatic Payment 1.2.13 Automatic Deposit 1.2.14 Automatic Withdrawn 1.2.15 Payin_Allow 1.2.16 Payout_Allow 1.2.17 Payin_Execution_Type 1.2.17.1 List values: Payment Execution Type 1.2.18 Payout_Execution_Type 1.2.18.1 List values: Payment Execution Type 1.2.19 Payin_Execution_Process_ID 1.2.20 Payout_Execution_Process_ID 1.2.21 Payin_Deferred 1.2.22 Payout_Deferred 1.2.23 Upon Receipt Use 1.2.23.1 List values: New Financial Flows Accounts 1.2.24 Upon Deposit Use 1.2.24.1 List values: New Financial Flows Accounts 1.2.25 Upon Reconciliation Use 1.2.25.1 List values: New Financial Flows Accounts 1.2.26 Upon Payment Use 1.2.26.1 List values: New Financial Flows Accounts 1.2.27 Upon Withdrawal Use 1.2.27.1 List values: New Financial Flows Accounts 1.2.28 Upon Reconciliation Use 1.2.28.1 List values: New Financial Flows Accounts 1.3 Related tables

FIN_PaymentMethod

• Name:FIN_PaymentMethod
• Classname:FIN_PaymentMethod

This table contains the following columns:

Name	Nullable	Data Type	Description
Fin_Paymentmethod_ID	N	VARCHAR2(32)	It is the method by which payment is expected to be made or received.
AD_Client_ID	N	VARCHAR2(32)	Client for this installation.
AD_Org_ID	N	VARCHAR2(32)	Organizational entity within client
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
Isactive	Y	CHAR(1)	A flag indicating whether this record is available for use or de-activated.
Name	N	VARCHAR2(60)	A non-unique identifier for a record/document often used as a search tool.
Description	Y	VARCHAR2(255)	A space to write additional related information.
Automatic_Receipt	N	CHAR(1)	null
Automatic_Payment	N	CHAR(1)	null
Automatic_Deposit	N	CHAR(1)	null
Automatic_Withdrawn	N	CHAR(1)	null
Payin_Allow	N	CHAR(1)	null
Payout_Allow	N	CHAR(1)	null
Payin_Execution_Type	N	VARCHAR2(60)	null
Payout_Execution_Type	N	VARCHAR2(60)	null
Payin_Execution_Process_ID	Y	VARCHAR2(32)	null
Payout_Execution_Process_ID	Y	VARCHAR2(32)	null
Payin_Deferred	N	CHAR(1)	null
Payout_Deferred	N	CHAR(1)	null
Uponreceiptuse	Y	VARCHAR2(60)	Account used upon receipt
Upondeposituse	Y	VARCHAR2(60)	Account used upon deposit
Inuponclearinguse	Y	VARCHAR2(60)	Account used upon reconciliation
Uponpaymentuse	Y	VARCHAR2(60)	Account used upon payment
Uponwithdrawaluse	Y	VARCHAR2(60)	Account used upon withdrawal
Outuponclearinguse	Y	VARCHAR2(60)	Account to be used upon reconciliation

Other Info

Check constraints

These are the check constraints for this table:

• FIN_PAYMENTMETHOD_ACTIVE_CHK: ISACTIVE IN ('Y', 'N')
• FIN_PAYMENTMETHOD_PAYINDEF_CHK: PAYIN_DEFERRED IN ('Y', 'N')
• FIN_PAYMENTMETH_AYOUTALLOW_CHK: PAYOUT_ALLOW IN ('Y', 'N')
• FIN_PAYMENTMETH_DEPOSIT_CHK: AUTOMATIC_DEPOSIT IN ('Y', 'N')
• FIN_PAYMENTMETH_PAYINALLOW_CHK: PAYIN_ALLOW IN ('Y', 'N')
• FIN_PAYMENTMETH_PAYMENT_CHK: AUTOMATIC_PAYMENT IN ('Y', 'N')
• FIN_PAYMENTMETH_PAYOUTDEF_CHK: PAYOUT_DEFERRED IN ('Y', 'N')
• FIN_PAYMENTMETH_RECEIPT_CHK: AUTOMATIC_RECEIPT IN ('Y', 'N')
• FIN_PAYMENTMETH_WITHDRAW_CHK: AUTOMATIC_WITHDRAWN 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):

Unique

• FIN_PAYMENT_METHOD_KEY
  • Fin_Paymentmethod_ID

top

Columns

Payment Method

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

Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

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 Security validation: Organizations of the Client with user acces rights. With the following code:

 
(@AD_Client_ID@='0' AND AD_Org.AD_Org_ID='0') OR (@AD_Client_ID@!='0' AND ((AD_Org.AD_Client_ID IN (@#User_Client@) AND AD_Org.AD_Org_ID IN (@#User_Org@)) OR AD_Org.AD_Org_ID='0' AND AD_Org.IsSummary='N'))

top

Creation Date

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

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime
• Default value: SYSDATE

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
• Default value: SYSDATE

top

Updated By

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

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.

• Physical column name: Isactive
• Property Name: active
• Reference: YesNo
• Default value: Y

top

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
• Property Name: name
• Reference: String
• 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: Text

top

Automatic Receipt

Automatically create the receipt when the invoice is completed.

• Physical column name: Automatic_Receipt
• Property Name: automaticReceipt
• Reference: YesNo
• Default value: N

top

Automatic Payment

Automatically create the payment when the invoice is completed.

• Physical column name: Automatic_Payment
• Property Name: automaticPayment
• Reference: YesNo
• Default value: N

top

Automatic Deposit

Automatically deposit the payment when it is processed.

• Physical column name: Automatic_Deposit
• Property Name: automaticDeposit
• Reference: YesNo
• Default value: N

top

Automatic Withdrawn

Automatically withdrawn the payment when it is processed.

• Physical column name: Automatic_Withdrawn
• Property Name: automaticWithdrawn
• Reference: YesNo
• Default value: N

top

Payin_Allow

Sets that Payment Ins are allowed.

• Physical column name: Payin_Allow
• Property Name: payinAllow
• Reference: YesNo
• Default value: Y

top

Payout_Allow

Sets that Payment Ins are allowed.

• Physical column name: Payout_Allow
• Property Name: payoutAllow
• Reference: YesNo
• Default value: Y

top

Payin_Execution_Type

Type of Payment Execution for Payment In flow.

• Physical column name: Payin_Execution_Type
• Property Name: payinExecutionType
• Reference: List
• Default value: M

List values: Payment Execution Type

The allowed values for this list are:

• A (Automatic): Payment Execution is managed by Openbravo ERP. Payments will use the Awaiting Execution status.
• M (Manual): The execution process is managed outside Openbravo ERP. Awaiting Execution status will be bypassed.

top

Payout_Execution_Type

Type of Payment Execution for Payment Out flow.

• Physical column name: Payout_Execution_Type
• Property Name: payoutExecutionType
• Reference: List
• Default value: M

List values: Payment Execution Type

The allowed values for this list are:

• A (Automatic): Payment Execution is managed by Openbravo ERP. Payments will use the Awaiting Execution status.
• M (Manual): The execution process is managed outside Openbravo ERP. Awaiting Execution status will be bypassed.

top

Payin_Execution_Process_ID

• Physical column name: Payin_Execution_Process_ID
• Property Name: payinExecutionProcess
• Reference: Table

Foreign key column to FIN_Pay_Exec_Process table, (column: FIN_Pay_Exec_Process_ID)

Reference Table FIN_Pay_Exec_Process : Links to an Execution Process.

top

Payout_Execution_Process_ID

• Physical column name: Payout_Execution_Process_ID
• Property Name: payoutExecutionProcess
• Reference: Table

Foreign key column to FIN_Pay_Exec_Process table, (column: FIN_Pay_Exec_Process_ID)

Reference Table FIN_Pay_Exec_Process : Links to an Execution Process.

top

Payin_Deferred

Sets that the Execution Process is deferred in the Payment In flow.

• Physical column name: Payin_Deferred
• Property Name: payinDeferred
• Reference: YesNo
• Default value: N

top

Payout_Deferred

Sets that the Executiion Process is deferred in the Payment In flow.

• Physical column name: Payout_Deferred
• Property Name: payoutDeferred
• Reference: YesNo
• Default value: N

top

Upon Receipt Use

Account used upon receipt

• Physical column name: Uponreceiptuse
• Property Name: uponReceiptUse
• Reference: List

Validation Rule Payment IN Accounts: null. With the following code:

 
AD_Ref_List.Value IN ('INT', 'DEP', 'CLE')

List values: New Financial Flows Accounts

The allowed values for this list are:

• CLE (Cleared Payment Account)
• DEP (Deposited Payment Account)
• INT (In Transit Payment Account)
• WIT (Withdrawn Payment Account)

top

Upon Deposit Use

Account used upon deposit

• Physical column name: Upondeposituse
• Property Name: uponDepositUse
• Reference: List

Validation Rule Payment IN Accounts: null. With the following code:

 
AD_Ref_List.Value IN ('INT', 'DEP', 'CLE')

List values: New Financial Flows Accounts

The allowed values for this list are:

• CLE (Cleared Payment Account)
• DEP (Deposited Payment Account)
• INT (In Transit Payment Account)
• WIT (Withdrawn Payment Account)

top

Upon Reconciliation Use

Account used upon reconciliation

• Physical column name: Inuponclearinguse
• Property Name: iNUponClearingUse
• Reference: List

Validation Rule Payment IN Accounts: null. With the following code:

 
AD_Ref_List.Value IN ('INT', 'DEP', 'CLE')

List values: New Financial Flows Accounts

The allowed values for this list are:

• CLE (Cleared Payment Account)
• DEP (Deposited Payment Account)
• INT (In Transit Payment Account)
• WIT (Withdrawn Payment Account)

top

Upon Payment Use

Account used upon payment

• Physical column name: Uponpaymentuse
• Property Name: uponPaymentUse
• Reference: List

Validation Rule Payment OUT Accounts: null. With the following code:

 
AD_Ref_List.Value IN ('WIT', 'INT', 'CLE')

List values: New Financial Flows Accounts

The allowed values for this list are:

• CLE (Cleared Payment Account)
• DEP (Deposited Payment Account)
• INT (In Transit Payment Account)
• WIT (Withdrawn Payment Account)

top

Upon Withdrawal Use

Account used upon withdrawal

• Physical column name: Uponwithdrawaluse
• Property Name: uponWithdrawalUse
• Reference: List

Validation Rule Payment OUT Accounts: null. With the following code:

 
AD_Ref_List.Value IN ('WIT', 'INT', 'CLE')

List values: New Financial Flows Accounts

The allowed values for this list are:

• CLE (Cleared Payment Account)
• DEP (Deposited Payment Account)
• INT (In Transit Payment Account)
• WIT (Withdrawn Payment Account)

top

Upon Reconciliation Use

Account to be used upon reconciliation

• Physical column name: Outuponclearinguse
• Property Name: oUTUponClearingUse
• Reference: List

Validation Rule Payment OUT Accounts: null. With the following code:

 
AD_Ref_List.Value IN ('WIT', 'INT', 'CLE')

List values: New Financial Flows Accounts

The allowed values for this list are:

• CLE (Cleared Payment Account)
• DEP (Deposited Payment Account)
• INT (In Transit Payment Account)
• WIT (Withdrawn Payment Account)

top

Related tables

Tables that link this table:

• BusinessPartner.PO Payment method
• BusinessPartner.Payment Method
• FIN_Payment.Payment Method
• FIN_Payment_Proposal.Payment Method
• FIN_Payment_Schedule.Fin_Paymentmethod_ID
• FinancialMgmtFinAccPaymentMethod.Payment Method
• FinancialMgmtPaymentTermLine.Payment Method
• Invoice.Payment Method
• Order.Payment Method
• Project.Payment Method
• ProjectProposal.Payment Method

top