ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/C Paymenttermline
C_Paymenttermline
- Name:C_Paymenttermline
- Classname:FinancialMgmtPaymentTermLine
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. |
C_Paymenttermline_ID | No | VARCHAR (32) | |
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. |
Excludetax | No | CHAR (1) | |
IsDueFixed | No | CHAR (1) | The Fixed Due Date checkbox indicates if invoices using this payment term will be due on a fixed day of the month. |
PaymentRule | Yes | VARCHAR (60) | Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.) |
FixMonthCutoff | Yes | DECIMAL (10,0) | The Last Day Cut-off indicates the last day invoices can have to be included in the current due date. |
Line | No | DECIMAL (10,0) | Indicates the unique line for a document. It will also control the display order of the lines within a document. |
FixMonthDay | Yes | DECIMAL (10,0) | 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. |
FixMonthDay2 | Yes | DECIMAL (10,0) | 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. |
Fixmonthday3 | Yes | DECIMAL (10,0) | 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. |
IsNextBusinessDay | Yes | CHAR (1) | The Next Business Day checkbox indicates that payment is due on the next business day after invoice or delivery. |
FixMonthOffset | Yes | DECIMAL (10,0) | 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. |
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. |
NetDay | Yes | VARCHAR (60) | When defined, overwrites the number of net days with the relative number of days to the day defined. |
NetDays | No | DECIMAL (10,0) | Indicates the number of days after invoice date that payment is due. |
FIN_Paymentmethod_ID | Yes | VARCHAR (32) | |
C_PaymentTerm_ID | No | VARCHAR (32) | Payment Terms identify the method and timing of payment for this transaction. |
Percentage | No | DECIMAL | Percentage of an amount (up to 100) |
Onremainder | No | CHAR (1) | |
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. |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
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
Foreign key column to AD_Client table, (column: AD_Client_ID)
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Exclude Tax
- Physical column name: Excludetax
- Property Name: excludeTax
- Reference: YesNo
- Default value: N
Fixed Due Date
- Physical column name: IsDueFixed
- Property Name: fixedDueDate
- Reference: YesNo
- Default value: N
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)
Last Day Cut-off
- Physical column name: FixMonthCutoff
- Property Name: lastDayCutoff
- Reference: Integer
Line No.
- Physical column name: Line
- Property Name: lineNo
- Reference: Integer
- This column is part of the table's identifier
Maturity Date 1
- Physical column name: FixMonthDay
- Property Name: maturityDate1
- Reference: Integer
Maturity Date 2
- Physical column name: FixMonthDay2
- Property Name: maturityDate2
- Reference: Integer
Maturity Date 3
- Physical column name: Fixmonthday3
- Property Name: maturityDate3
- Reference: Integer
Next Business Day
- Physical column name: IsNextBusinessDay
- Property Name: nextBusinessDay
- Reference: YesNo
- Default value: Y
Offset Month Due
- Physical column name: FixMonthOffset
- Property Name: offsetMonthDue
- Reference: Integer
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Overdue Payment Day Rule
- 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)
Overdue Payment Days Rule
- Physical column name: NetDays
- Property Name: overduePaymentDaysRule
- Reference: Integer
Payment Method
- Physical column name: FIN_Paymentmethod_ID
- Property Name: paymentMethod
- Reference: TableDir
Foreign key column to FIN_PaymentMethod table, (column: Fin_Paymentmethod_ID)
It has a validation "FIN_PaymentMethodsWithAccount", with the following code
EXISTS (SELECT 1 FROM FIN_FinAcc_PaymentMethod fapm WHERE FIN_PaymentMethod.FIN_PaymentMethod_ID=fapm.FIN_PaymentMethod_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 business object (is Parent)
Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)
Percentage Due
- Physical column name: Percentage
- Property Name: percentageDue
- Reference: Number
Rest
- Physical column name: Onremainder
- Property Name: rest
- Reference: YesNo
- Default value: Y
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
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_PAYMENTTERMLINE_PAYMENTT_IDX Not Unique. Columns:
- C_PAYMENTTERM_ID
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')