ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/C Debt Payment

Contents 1 C_Debt_Payment 1.1 Columns 1.1.1 Active 1.1.2 Amount 1.1.3 Balancing Amount 1.1.4 Bank Account 1.1.5 Bank Statement Line 1.1.6 Business Partner 1.1.7 C_Settlement_Generate_ID 1.1.8 Cancel processed 1.1.9 Cash Journal Line 1.1.10 Cashbook 1.1.11 Change settlement cancel 1.1.12 Client 1.1.13 Created By 1.1.14 Creation Date 1.1.15 Currency 1.1.16 Description 1.1.17 Direct Posting 1.1.18 Due Date 1.1.19 Form of Payment 1.1.19.1 List values: All_Payment Rule 1.1.20 G/L Item 1.1.21 Generate_Processed 1.1.22 Initial Status 1.1.22.1 List values: C_DP_Management_Status 1.1.23 Invoice 1.1.24 Is Automatic Generated 1.1.25 Manual 1.1.26 Organization 1.1.27 Payment 1.1.28 Payment Complete 1.1.29 Project 1.1.30 Receipt 1.1.31 Sales Order 1.1.32 Settlement Cancelled 1.1.33 Status 1.1.33.1 List values: C_DP_Management_Status 1.1.34 Updated 1.1.35 Updated By 1.1.36 Valid 1.1.37 Withholding 1.1.38 Withholdingamount 1.1.39 Write-off Amount 1.2 Other Info 1.2.1 Indices 1.2.2 Check Constraints

C_Debt_Payment

• Name:C_Debt_Payment
• Classname:FinancialMgmtDebtPayment

This table contains the following columns:

Name	Nullable	Data Type	Description
IsActive	No	CHAR (1)	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.
Amount	No	DECIMAL	The Amount indicates the amount for this document line.
GLItemAmt	Yes	DECIMAL
C_BankAccount_ID	Yes	VARCHAR (32)	The Bank Account identifies an account at this Bank.
C_BankStatementLine_ID	Yes	VARCHAR (32)	The Bank Statement Line identifies a unique transaction (Payment, Withdrawal, Charge) for the defined time period at this Bank.
C_BPartner_ID	No	VARCHAR (32)	A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
C_Settlement_Generate_ID	Yes	VARCHAR (32)	Refers to the settlement in which this Debt/Payment has been generated.
Cancel_Processed	No	CHAR (1)	The settlement cancel is processed.
C_CashLine_ID	Yes	VARCHAR (32)	The Cash Journal Line indicates a unique line in a cash journal.
C_CashBook_ID	Yes	VARCHAR (32)	The Cash Book identifies a unique cash book. The cash book is used to record cash transactions.
Changesettlementcancel	No	CHAR (1)
AD_Client_ID	No	VARCHAR (32)	A Client is a company or a legal entity. You cannot share data between Clients.
CreatedBy	No	VARCHAR (32)	The Created By field indicates the user who created this record.
Created	No	TIMESTAMP (7)	The Created field indicates the date that this record was created.
C_Currency_ID	No	VARCHAR (32)	Indicates the currency to be used when processing this document.
Description	Yes	NVARCHAR (255)	A description is limited to 255 characters.
Isdirectposting	No	CHAR (1)	Direct Posting
Dateplanned	No	TIMESTAMP (7)	Refers to a date by which the payment must be completed.
PaymentRule	No	VARCHAR (60)	Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
C_Glitem_ID	Yes	VARCHAR (32)	General ledger item.
Generate_Processed	No	CHAR (1)	The settlement generate is processed.
Status_Initial	Yes	VARCHAR (60)	Status of a payment upon creation.
C_Invoice_ID	Yes	VARCHAR (32)	The Invoice ID uniquely identifies an Invoice Document.
IsAutomaticGenerated	Yes	CHAR (1)	It is automatically generated.
IsManual	No	CHAR (1)	The Manual check box indicates if the process will done manually.
AD_Org_ID	No	VARCHAR (32)	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
C_Debt_Payment_ID	No	VARCHAR (32)	Refers to the amount of money to be paid or collected.
IsPaid	No	CHAR (1)	The document is paid for.
C_Project_ID	Yes	VARCHAR (32)	Identifier of a project defined within the Project & Service Management module.
IsReceipt	No	CHAR (1)	Indicated a sales transaction (Accounts Receivable if Receipt=Y) or a purchase transaction (Accounts Payable if Receipt=N).
C_Order_ID	Yes	VARCHAR (32)	Unique identifier and a reference to a Sales Order originating from the document sequence defined for this document type.
C_Settlement_Cancel_ID	Yes	VARCHAR (32)	Identifier of a settlement in which this Payment has been cancelled.
Status	No	VARCHAR (60)	Current status of a debt/payment.
Updated	No	TIMESTAMP (7)	The Updated field indicates the date that this record was updated.
UpdatedBy	No	VARCHAR (32)	The Updated By field indicates the user who updated this record.
IsValid	No	CHAR (1)	The element passed the validation check
C_Withholding_ID	Yes	VARCHAR (32)	The Withholding indicates the type of withholding to be calculated.
Withholdingamount	Yes	DECIMAL
WriteOffAmt	Yes	DECIMAL	The Write Off Amount indicates the amount to be written off as uncollectible.

Columns

Active

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

top

Amount

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

top

Balancing Amount

• Physical column name: GLItemAmt
• Property Name: balancingAmount
• Reference: Amount
• Default value: 0

top

Bank Account

• Physical column name: C_BankAccount_ID
• Property Name: bankAccount
• Reference: TableDir

Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)

top

Bank Statement Line

• Physical column name: C_BankStatementLine_ID
• Property Name: bankStatementLine
• Reference: Search

Foreign key column to C_BankStatementLine table, (column: C_BankStatementLine_ID)

top

Business Partner

• Physical column name: C_BPartner_ID
• Property Name: businessPartner
• Reference: Search

• This column is part of the table's identifier

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

top

C_Settlement_Generate_ID

• Physical column name: C_Settlement_Generate_ID
• Property Name: settlementGenerate
• Reference: Search

• This column is a child for a business object (is Parent)

Foreign key column to C_Settlement table, (column: C_Settlement_ID)

top

Cancel processed

• Physical column name: Cancel_Processed
• Property Name: cancelProcessed
• Reference: YesNo
• Default value: N

top

Cash Journal Line

• Physical column name: C_CashLine_ID
• Property Name: cashJournalLine
• Reference: Search

Foreign key column to C_CashLine table, (column: C_CashLine_ID)

top

Cashbook

• Physical column name: C_CashBook_ID
• Property Name: cashbook
• Reference: TableDir

Foreign key column to C_CashBook table, (column: C_CashBook_ID)

top

Change settlement cancel

• Physical column name: Changesettlementcancel
• Property Name: changeSettlementCancel
• Reference: Button
• Default value: N

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir

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

top

Created By

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

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

top

Creation Date

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

top

Currency

• Physical column name: C_Currency_ID
• Property Name: currency
• Reference: TableDir

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

top

Description

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

top

Direct Posting

• Physical column name: Isdirectposting
• Property Name: directPosting
• Reference: YesNo
• Default value: N

top

Due Date

• Physical column name: Dateplanned
• Property Name: dueDate
• Reference: Date

• This column is part of the table's identifier

top

Form of Payment

• Physical column name: PaymentRule
• Property Name: formOfPayment
• Reference: List

• This column is part of the table's identifier

List values: All_Payment Rule

The allowed values for this list are:

• B (Cash): Cash payments that generate an automatic accounting line.
• K (Credit Card)
• T (Transfer (ACH))
• P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
• 1 (Wire Transfer): Wire Transfer
• 2 (Check): Check
• 3 (Promissory Note): Promissory Note
• C (Cash on Delivery): Cash on Delivery
• 4 (Money Order)
• 5 (Bank Deposit)
• R (Bank Remittance)
• W (Withholding)

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

Generate_Processed

• Physical column name: Generate_Processed
• Property Name: generateProcessed
• Reference: YesNo
• Default value: N

top

Initial Status

• Physical column name: Status_Initial
• Property Name: initialStatus
• Reference: List

List values: C_DP_Management_Status

The allowed values for this list are:

• DE (--)
• RE (Returned)
• RT (In Remittance)
• RC (Received)
• SE (Sent)
• AN (Advance)

top

Invoice

• Physical column name: C_Invoice_ID
• Property Name: invoice
• Reference: Search

• This column is a child for a business object (is Parent)

Foreign key column to C_Invoice table, (column: C_Invoice_ID)

top

Is Automatic Generated

• Physical column name: IsAutomaticGenerated
• Property Name: isAutomaticGenerated
• Reference: YesNo

top

Manual

• Physical column name: IsManual
• Property Name: manual
• Reference: YesNo

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir

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

top

Payment

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

top

Payment Complete

• Physical column name: IsPaid
• Property Name: paymentComplete
• Reference: YesNo

top

Project

• Physical column name: C_Project_ID
• Property Name: project
• Reference: TableDir

Foreign key column to C_Project table, (column: C_Project_ID)

top

Receipt

• Physical column name: IsReceipt
• Property Name: receipt
• Reference: YesNo
• Default value: Y
• This column is part of the table's identifier

top

Sales Order

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

• This column is a child for a business object (is Parent)

Foreign key column to C_Order table, (column: C_Order_ID)

top

Settlement Cancelled

• Physical column name: C_Settlement_Cancel_ID
• Property Name: settlementCancelled
• Reference: Search

• This column is a child for a business object (is Parent)

Foreign key column to C_Settlement table, (column: C_Settlement_ID)

top

Status

• Physical column name: Status
• Property Name: status
• Reference: List

List values: C_DP_Management_Status

The allowed values for this list are:

• DE (--)
• RE (Returned)
• RT (In Remittance)
• RC (Received)
• SE (Sent)
• AN (Advance)

top

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

Valid

• Physical column name: IsValid
• Property Name: valid
• Reference: YesNo

top

Withholding

• Physical column name: C_Withholding_ID
• Property Name: withholding
• Reference: TableDir

Foreign key column to C_Withholding table, (column: C_Withholding_ID)

top

Withholdingamount

• Physical column name: Withholdingamount
• Property Name: withholdingamount
• Reference: Amount

top

Write-off Amount

• Physical column name: WriteOffAmt
• Property Name: writeoffAmount
• Reference: Amount
• Default value: 0

top

Other Info

Indices

These are the indices for this table (for each index there is a list of all the columns included within it):

• C_DEBT_PAYMENT_BPARTNER_IDX Not Unique. Columns:
  • C_BPARTNER_ID
• C_DEBT_PAYMENT_INVOICE_IDX Not Unique. Columns:
  • C_INVOICE_ID
• C_DEBT_PAYMENT_SETTCANCEL_IDX Not Unique. Columns:
  • C_SETTLEMENT_CANCEL_ID
• C_DEBT_PAYMENT_SETTGENERAT_IDX Not Unique. Columns:
  • C_SETTLEMENT_GENERATE_ID
• C_DEBTPAYMENT_ORDER_IDX Not Unique. Columns:
  • C_ORDER_ID

top

Check Constraints

These are the check constraints for this table:

• C_DEBT_PAYMENT_C_BANKSTATE_CHK: C_BANKSTATEMENTLINE_ID IS NULL AND C_CASHLINE_ID IS NULL OR ISPAID = 'Y'
• C_DEBT_PAYMENT_C_BPARTNER__CHK: C_BPARTNER_ID IS NOT NULL
• C_DEBT_PAYMENT_C_CASHLINE__CHK: C_CASHLINE_ID IS NULL OR C_BANKSTATEMENTLINE_ID IS NULL
• C_DEBT_PAYMENT_C_SETTLEMEN_CH1: C_SETTLEMENT_CANCEL_ID IS NOT NULL OR C_SETTLEMENT_GENERATE_ID IS NOT NULL OR ISPAID = 'N'
• C_DEBT_PAYMENT_C_SETTLEMEN_CHK: C_SETTLEMENT_CANCEL_ID IS NULL OR ISVALID = 'Y'
• C_DEBT_PAYMENT_CANCEL_PROC_CH1: CANCEL_PROCESSED IN ('Y', 'N')
• C_DEBT_PAYMENT_CANCEL_PROC_CHK: CANCEL_PROCESSED = 'N' OR C_SETTLEMENT_CANCEL_ID IS NOT NULL
• C_DEBT_PAYMENT_GENERATE_PR_CHK: GENERATE_PROCESSED IN ('Y', 'N')
• C_DEBT_PAYMENT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
• C_DEBT_PAYMENT_ISDIRECTPOS_CHK: ISDIRECTPOSTING = 'N' OR C_GLITEM_ID IS NOT NULL
• C_DEBT_PAYMENT_ISMANUAL: ISMANUAL IN ('Y', 'N')
• C_DEBT_PAYMENT_ISRECEIPT: ISRECEIPT IN ('Y', 'N')
• C_DEBT_PAYMENT_ISVALID: ISVALID IN ('Y', 'N')
• C_DEBT_PAYMENT_ISVALID_CHK: ISVALID = 'N' OR ISACTIVE = 'Y'
• C_DEBT_PAYMENT_ISVALID_CHK1: ISVALID = 'Y' AND (C_SETTLEMENT_GENERATE_ID IS NULL AND GENERATE_PROCESSED = 'N' OR C_SETTLEMENT_GENERATE_ID IS NOT NULL AND GENERATE_PROCESSED = 'Y') OR ISVALID = 'N' AND C_SETTLEMENT_GENERATE_ID IS NOT NULL AND GENERATE_PROCESSED = 'N' OR ISVALID = 'N' AND ISAUTOMATICGENERATED = 'N'

top

Categories: Database Entity Model | Generated Doc