View source | Discuss this page | Page history | Printable version   

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

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment


Contents

C_PromissoryFormat

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



top


Bank Account


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

top


Bank location font



top


C_Promissoryformat_ID



top


Client


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

top


Created By


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

top


Creation Date



top


Description



top


Line 1 Left



top


Line 1 Top



top


Line 2 Left



top


Line 2 Top



top


Line 3 Left



top


Line 3 Top



top


Line 4 Left



top


Line 4 Top



top


Name


top


Organization


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

top


Param 13



top


Param 42



top


Param. 11



top


Param. 12



top


Param. 31



top


Param. 32



top


Param. 41



top


Param. 43



top


Print Bank Location



top


Source Amount



top


Source Amount Text



top


Source Day Today



top


Source Last Year



top


Source Month to Day



top


Source Planned Day



top


Source Planned Month



top


Source Year to Day



top


Source to Business Partner



top


Updated



top


Updated By


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

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.financialmgmt.payment

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.payment/C_PromissoryFormat"

This page has been accessed 3,837 times. This page was last modified on 7 September 2020, at 01:58. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.