ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/C Paymenttermline
C_Paymenttermline
Line in a Payment Term
- Name:FinancialMgmtPaymentTermLine
- Classname:PaymentTermLine
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_Paymenttermline_ID | N | VARCHAR2(32) | null |
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_PaymentTerm_ID | N | VARCHAR2(32) | The setup and timing defined to complete a specified payment. |
Line | N | NUMBER(10, 0) | A line stating the position of this request in the document. |
Percentage | N | NUMBER | Percent of the entire amount |
Onremainder | N | CHAR(1) | null |
Excludetax | N | CHAR(1) | null |
PaymentRule | Y | VARCHAR2(60) | The method used for payment of this transaction. |
IsDueFixed | N | CHAR(1) | Payment is due on a fixed date |
NetDays | N | NUMBER(10, 0) | A plan to give additional days after the agreed payment term to pay without penalty. |
FixMonthCutoff | Y | NUMBER(10, 0) | Last day to include for next due date |
FixMonthDay | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
FixMonthDay2 | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
Fixmonthday3 | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
FixMonthOffset | Y | NUMBER(10, 0) | Number of months (0=same, 1=following) |
IsNextBusinessDay | Y | CHAR(1) | Payment due on the next business day |
NetDay | Y | VARCHAR2(60) | A plan to give until a specific day after the agreed payment term to pay without penalty. |
FIN_Paymentmethod_ID | Y | VARCHAR2(32) | It is the method by which payment is expected to be made or received. |
Other Info
Check constraints
These are the check constraints for this table:
- C_PAYMENTTERMLINE_EXCLUDET_CHK: EXCLUDETAX IN ('Y', 'N')
- C_PAYMENTTERMLINE_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- C_PAYMENTTERMLINE_ISDUEFIX_CHK: ISDUEFIXED IN ('Y', 'N')
- C_PAYMENTTERMLINE_ISNEXTBU_CHK: ISNEXTBUSINESSDAY IN ('Y', 'N')
- C_PAYMENTTERMLINE_ONREMAIN_CHK: ONREMAINDER IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- C_PAYMENTTERMLINE_KEY
Columns
C_Paymenttermline_ID
- Physical column name: C_Paymenttermline_ID
- Property Name: id
- Reference: ID
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)
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)
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
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: @#Date@
Created By
- Physical column name: Createdby
- Property 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
- Property Name: updated
- Reference: DateTime
- Default value: @#Date@
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Payment Terms
- Physical column name: C_PaymentTerm_ID
- Property Name: paymentTerms
- Reference: TableDir
- 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_PaymentTerm table, (column: C_PaymentTerm_ID)
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_PAYMENTTERMLINE WHERE C_PAYMENTTERM_ID=@C_PAYMENTTERM_ID@
- This column is part of the table's identifier
Percentage Due
Percentage of an amount (up to 100)
- Physical column name: Percentage
- Property Name: percentageDue
- Reference: Number
- Default value: 100
Rest
- Physical column name: Onremainder
- Property Name: rest
- Reference: YesNo
- Default value: Y
Exclude Tax
- Physical column name: Excludetax
- Property Name: excludeTax
- Reference: YesNo
- Default value: N
Form of Payment
Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
- 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:
- 1 (Wire Transfer): Wire Transfer
- 2 (Check): Check
- 3 (Promissory Note): Promissory Note
- 4 (Money Order)
- 5 (Bank Deposit)
- B (Cash): Cash payments that generate an automatic accounting line.
- C (Cash on Delivery): Cash on Delivery
- K (Credit Card)
- P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
- R (Bank Remittance)
- T (Transfer (ACH))
- W (Withholding)
Fixed Due Date
The Fixed Due Date checkbox indicates if invoices using this payment term will be due on a fixed day of the month.
- Physical column name: IsDueFixed
- Property Name: fixedDueDate
- Reference: YesNo
- Default value: N
Overdue Payment Days Rule
Indicates the number of days after invoice date that payment is due.
- Physical column name: NetDays
- Property Name: overduePaymentDaysRule
- Reference: Integer
Last Day Cut-off
The Last Day Cut-off indicates the last day invoices can have to be included in the current due date.
- Physical column name: FixMonthCutoff
- Property Name: lastDayCutoff
- Reference: Integer
Maturity Date 1
The Fix Month Day indicates the day of the month that invoices are due. This field is displayed only when the fixed due date checkbox is selected. 3 different fix month days can be defined.
- Physical column name: FixMonthDay
- Property Name: maturityDate1
- Reference: Integer
Maturity Date 2
The Fix Month Day indicates the day of the month that invoices are due. This field is displayed only when the fixed due date checkbox is selected. 3 different fix month days can be defined.
- Physical column name: FixMonthDay2
- Property Name: maturityDate2
- Reference: Integer
Maturity Date 3
The Fix Month Day indicates the day of the month that invoices are due. This field is displayed only when the fixed due date checkbox is selected. 3 different fix month days can be defined.
- Physical column name: Fixmonthday3
- Property Name: maturityDate3
- Reference: Integer
Offset Month Due
The Offset Month Due indicates the number of months from the current month to indicate an invoice is due. A 0 indicates the same month, a 1 the following month.
- Physical column name: FixMonthOffset
- Property Name: offsetMonthDue
- Reference: Integer
Next Business Day
The Next Business Day checkbox indicates that payment is due on the next business day after invoice or delivery.
- Physical column name: IsNextBusinessDay
- Property Name: nextBusinessDay
- Reference: YesNo
- Default value: Y
Overdue Payment Day Rule
When defined, overwrites the number of net days with the relative number of days to the day defined.
- Physical column name: NetDay
- Property Name: overduePaymentDayRule
- Reference: List
List values: Weekdays
The allowed values for this list are:
- 1 (Monday)
- 2 (Tuesday)
- 3 (Wednesday)
- 4 (Thursday)
- 5 (Friday)
- 6 (Saturday)
- 7 (Sunday)
Payment Method
- Physical column name: FIN_Paymentmethod_ID
- Property Name: paymentMethod
- Reference: TableDir
Foreign key column to FIN_Paymentmethod table, (column: Fin_Paymentmethod_ID)
Validation Rule FIN_PaymentMethodsWithAccount: Filters only the payment methods that belong to a financial account. With the following code:
EXISTS (SELECT 1 FROM FIN_FinAcc_PaymentMethod fapm WHERE FIN_PaymentMethod.FIN_PaymentMethod_ID=fapm.FIN_PaymentMethod_ID)