ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/C PromissoryFormat
C_PromissoryFormat
It is necessary a Promissory format to print any Promissory Note with each Bank. Currently this format is prepared for the Spanish model.
- Name:FinancialMgmtPromissoryFormat
- Classname:PromissoryFormat
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_Promissoryformat_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 |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
C_BankAccount_ID | N | VARCHAR2(32) | A monetary account of funds held in a recognized banking institution. |
Line1top | N | NUMBER | null |
Line1left | N | NUMBER | null |
Line2top | N | NUMBER | null |
Line2left | N | NUMBER | Distance from the left side for the 2nd line. |
Line3top | N | NUMBER | null |
Line3left | N | NUMBER | Distance from the left side for the 3rd line. |
Line4top | N | NUMBER | null |
Line4left | N | NUMBER | Distance from the left side for the 4th line. |
Param11 | N | NUMBER | null |
Param12 | N | NUMBER | null |
Param13 | N | NUMBER | null |
Param31 | N | NUMBER | null |
Param32 | N | NUMBER | null |
Param41 | N | NUMBER | null |
Param42 | N | NUMBER | null |
Param43 | N | NUMBER | null |
Printbankloc | N | CHAR(1) | null |
Fontdayplanned | N | NUMBER | null |
Fontmonthplanned | N | NUMBER | null |
Fontyearplanned | N | NUMBER | null |
Fontamount | N | NUMBER | null |
Fontpartnername | N | NUMBER | null |
Fontamounttext | N | NUMBER | null |
Fontdaytoday | N | NUMBER | null |
Fontmonthtoday | N | NUMBER | null |
Fontyeartoday | N | NUMBER | null |
FontBankLocation | N | NUMBER | Bank location font |
Other Info
Check constraints
These are the check constraints for this table:
- C_PROMISSORYFORMAT_ISACTIV_CHK: ISACTIVE IN ('Y', 'N')
- C_PROMISSORYFORMAT_PRINTBA_CHK: PRINTBANKLOC 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_PROMISSORYFORMAT_KEY
Columns
C_Promissoryformat_ID
- Physical column name: C_Promissoryformat_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)
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
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: Text
Bank Account
- Physical column name: C_BankAccount_ID
- Property Name: bankAccount
- Reference: TableDir
Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)
Line 1 Top
Distance to the top for the 1st line.
- Physical column name: Line1top
- Property Name: line1Top
- Reference: Number
- Default value: 1
Line 1 Left
Distance from the left side for the 1st line.
- Physical column name: Line1left
- Property Name: line1Left
- Reference: Number
- Default value: 1
Line 2 Top
Distance to the top for the 2nd line.
- Physical column name: Line2top
- Property Name: line2Top
- Reference: Number
- Default value: 1
Line 2 Left
Distance from the left side for the 2nd line.
- Physical column name: Line2left
- Property Name: line2Left
- Reference: Number
- Default value: 1
Line 3 Top
Distance to the top for the 3rd line.
- Physical column name: Line3top
- Property Name: line3Top
- Reference: Number
- Default value: 1
Line 3 Left
Distance from the left side for the 3rd line.
- Physical column name: Line3left
- Property Name: line3Left
- Reference: Number
- Default value: 1
Line 4 Top
Distance to the top for the 4th line.
- Physical column name: Line4top
- Property Name: line4Top
- Reference: Number
- Default value: 1
Line 4 Left
Distance from the left side for the 4th line.
- Physical column name: Line4left
- Property Name: line4Left
- Reference: Number
- Default value: 1
Param. 11
Position for 1st parameter of 1st line.
- Physical column name: Param11
- Property Name: param11
- Reference: Number
- Default value: 0
Param. 12
Position for 2nd parameter of 1st line.
- Physical column name: Param12
- Property Name: param12
- Reference: Number
- Default value: 0
Param 13
Position for 3rd parameter of 1st line.
- Physical column name: Param13
- Property Name: param13
- Reference: Number
- Default value: 0
Param. 31
Position for 1st parameter of 3rd line.
- Physical column name: Param31
- Property Name: param31
- Reference: Number
- Default value: 0
Param. 32
Position for 2nd parameter of 3rd line.
- Physical column name: Param32
- Property Name: param32
- Reference: Number
- Default value: 0
Param. 41
Position for 1st parameter of 4th line.
- Physical column name: Param41
- Property Name: param41
- Reference: Number
- Default value: 0
Param 42
Position for 2nd parameter of 4th line.
- Physical column name: Param42
- Property Name: param42
- Reference: Number
- Default value: 0
Param. 43
Position for 3rd parameter of 4th line.
- Physical column name: Param43
- Property Name: param43
- Reference: Number
- Default value: 0
Print Bank Location
Specifies whether bank location is going to be printed.
- Physical column name: Printbankloc
- Property Name: printBankLocation
- Reference: YesNo
- Default value: Y
Source Planned Day
Font size for planned day field.
- Physical column name: Fontdayplanned
- Property Name: sourcePlannedDay
- Reference: Number
- Default value: 8
Source Planned Month
Font size for planned month field.
- Physical column name: Fontmonthplanned
- Property Name: sourcePlannedMonth
- Reference: Number
- Default value: 8
Source Last Year
Font size for planned year field.
- Physical column name: Fontyearplanned
- Property Name: sourceLastYear
- Reference: Number
- Default value: 8
Source Amount
Font size for amount field.
- Physical column name: Fontamount
- Property Name: sourceAmount
- Reference: Number
- Default value: 8
Source to Business Partner
Font size for partner name field.
- Physical column name: Fontpartnername
- Property Name: sourceToBusinessPartner
- Reference: Number
- Default value: 8
Source Amount Text
Font size for amount text field.
- Physical column name: Fontamounttext
- Property Name: sourceAmountText
- Reference: Number
- Default value: 8
Source Day Today
Font size for day to day field.
- Physical column name: Fontdaytoday
- Property Name: sourceDayToday
- Reference: Number
- Default value: 8
Source Month to Day
Font size for month to day field.
- Physical column name: Fontmonthtoday
- Property Name: sourceMonthToDay
- Reference: Number
- Default value: 8
Source Year to Day
Font size for year to day field.
- Physical column name: Fontyeartoday
- Property Name: sourceYearToDay
- Reference: Number
- Default value: 8
Bank location font
Bank location font
- Physical column name: FontBankLocation
- Property Name: bankLocationFont
- Reference: Number
- Default value: 8