ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/C PromissoryFormat
C_PromissoryFormat
- Name:C_PromissoryFormat
- Classname:FinancialMgmtPromissoryFormat
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_BankAccount_ID | No | VARCHAR (32) | The Bank Account identifies an account at this Bank. |
FontBankLocation | No | DECIMAL | Bank location font |
C_Promissoryformat_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. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
Line1left | No | DECIMAL | Distance from the left side for the 1st line. |
Line1top | No | DECIMAL | Distance to the top for the 1st line. |
Line2left | No | DECIMAL | Distance from the left side for the 2nd line. |
Line2top | No | DECIMAL | Distance to the top for the 2nd line. |
Line3left | No | DECIMAL | Distance from the left side for the 3rd line. |
Line3top | No | DECIMAL | Distance to the top for the 3rd line. |
Line4left | No | DECIMAL | Distance from the left side for the 4th line. |
Line4top | No | DECIMAL | Distance to the top for the 4th line. |
Name | No | NVARCHAR (60) | 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. |
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. |
Param13 | No | DECIMAL | Position for 3rd parameter of 1st line. |
Param42 | No | DECIMAL | Position for 2nd parameter of 4th line. |
Param11 | No | DECIMAL | Position for 1st parameter of 1st line. |
Param12 | No | DECIMAL | Position for 2nd parameter of 1st line. |
Param31 | No | DECIMAL | Position for 1st parameter of 3rd line. |
Param32 | No | DECIMAL | Position for 2nd parameter of 3rd line. |
Param41 | No | DECIMAL | Position for 1st parameter of 4th line. |
Param43 | No | DECIMAL | Position for 3rd parameter of 4th line. |
Printbankloc | No | CHAR (1) | Specifies whether bank location is going to be printed. |
Fontamount | No | DECIMAL | Font size for amount field. |
Fontamounttext | No | DECIMAL | Font size for amount text field. |
Fontdaytoday | No | DECIMAL | Font size for day to day field. |
Fontyearplanned | No | DECIMAL | Font size for planned year field. |
Fontmonthtoday | No | DECIMAL | Font size for month to day field. |
Fontdayplanned | No | DECIMAL | Font size for planned day field. |
Fontmonthplanned | No | DECIMAL | Font size for planned month field. |
Fontyeartoday | No | DECIMAL | Font size for year to day field. |
Fontpartnername | No | DECIMAL | Font size for partner name field. |
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
Bank Account
- Physical column name: C_BankAccount_ID
- Property Name: bankAccount
- Reference: TableDir
Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)
Bank location font
- Physical column name: FontBankLocation
- Property Name: bankLocationFont
- Reference: Number
- Default value: 8
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
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
Description
- Physical column name: Description
- Property Name: description
- Reference: Text
Line 1 Left
- Physical column name: Line1left
- Property Name: line1Left
- Reference: Number
- Default value: 0
Line 1 Top
- Physical column name: Line1top
- Property Name: line1Top
- Reference: Number
- Default value: 0
Line 2 Left
- Physical column name: Line2left
- Property Name: line2Left
- Reference: Number
- Default value: 0
Line 2 Top
- Physical column name: Line2top
- Property Name: line2Top
- Reference: Number
- Default value: 0
Line 3 Left
- Physical column name: Line3left
- Property Name: line3Left
- Reference: Number
- Default value: 0
Line 3 Top
- Physical column name: Line3top
- Property Name: line3Top
- Reference: Number
- Default value: 0
Line 4 Left
- Physical column name: Line4left
- Property Name: line4Left
- Reference: Number
- Default value: 0
Line 4 Top
- Physical column name: Line4top
- Property Name: line4Top
- Reference: Number
- Default value: 0
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Param 13
- Physical column name: Param13
- Property Name: param13
- Reference: Number
- Default value: 0
Param 42
- Physical column name: Param42
- Property Name: param42
- Reference: Number
- Default value: 0
Param. 11
- Physical column name: Param11
- Property Name: param11
- Reference: Number
- Default value: 0
Param. 12
- Physical column name: Param12
- Property Name: param12
- Reference: Number
- Default value: 0
Param. 31
- Physical column name: Param31
- Property Name: param31
- Reference: Number
- Default value: 0
Param. 32
- Physical column name: Param32
- Property Name: param32
- Reference: Number
- Default value: 0
Param. 41
- Physical column name: Param41
- Property Name: param41
- Reference: Number
- Default value: 0
Param. 43
- Physical column name: Param43
- Property Name: param43
- Reference: Number
- Default value: 0
Print Bank Location
- Physical column name: Printbankloc
- Property Name: printBankLocation
- Reference: YesNo
- Default value: Y
Source Amount
- Physical column name: Fontamount
- Property Name: sourceAmount
- Reference: Number
- Default value: 8
Source Amount Text
- Physical column name: Fontamounttext
- Property Name: sourceAmountText
- Reference: Number
- Default value: 8
Source Day Today
- Physical column name: Fontdaytoday
- Property Name: sourceDayToday
- Reference: Number
- Default value: 8
Source Last Year
- Physical column name: Fontyearplanned
- Property Name: sourceLastYear
- Reference: Number
- Default value: 8
Source Month to Day
- Physical column name: Fontmonthtoday
- Property Name: sourceMonthToDay
- Reference: Number
- Default value: 8
Source Planned Day
- Physical column name: Fontdayplanned
- Property Name: sourcePlannedDay
- Reference: Number
- Default value: 8
Source Planned Month
- Physical column name: Fontmonthplanned
- Property Name: sourcePlannedMonth
- Reference: Number
- Default value: 8
Source Year to Day
- Physical column name: Fontyeartoday
- Property Name: sourceYearToDay
- Reference: Number
- Default value: 8
Source to Business Partner
- Physical column name: Fontpartnername
- Property Name: sourceToBusinessPartner
- Reference: Number
- Default value: 8
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
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')