View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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


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.
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.
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.

Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Createdby No VARCHAR (32) The Created By field indicates the user who created this record.
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.
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.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
C_BankAccount_ID No VARCHAR (32) The Bank Account identifies an account at this Bank.
Line1top No DECIMAL Distance to the top for the 1st line.
Line1left No DECIMAL Distance from the left side for the 1st line.
Line2top No DECIMAL Distance to the top for the 2nd line.
Line2left No DECIMAL Distance from the left side for the 2nd line.
Line3top No DECIMAL Distance to the top for the 3rd line.
Line3left No DECIMAL Distance from the left side for the 3rd line.
Line4top No DECIMAL Distance to the top for the 4th line.
Line4left No DECIMAL Distance from the left side for the 4th line.
Param11 No DECIMAL Position for 1st parameter of 1st line.
Param12 No DECIMAL Position for 2nd parameter of 1st line.
Param13 No DECIMAL Position for 3rd 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.
Param42 No DECIMAL Position for 2nd 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.
Fontdayplanned No DECIMAL Font size for planned day field.
Fontmonthplanned No DECIMAL Font size for planned month field.
Fontyearplanned No DECIMAL Font size for planned year field.
Fontamount No DECIMAL Font size for amount field.
Fontpartnername No DECIMAL Font size for partner name field.
Fontamounttext No DECIMAL Font size for amount text field.
Fontdaytoday No DECIMAL Font size for day to day field.
Fontmonthtoday No DECIMAL Font size for month to day field.
Fontyeartoday No DECIMAL Font size for year to day field.
FontBankLocation No DECIMAL Bank location font

Columns

C_Promissoryformat_ID



top


Client


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

top


Organization


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

top


Active



top


Creation Date



top


Created By


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

top


Updated



top


Updated By


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

top


Name


top


Description



top


Bank Account


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

top


Line 1 Top



top


Line 1 Left



top


Line 2 Top



top


Line 2 Left



top


Line 3 Top



top


Line 3 Left



top


Line 4 Top



top


Line 4 Left



top


Param. 11



top


Param. 12



top


Param 13



top


Param. 31



top


Param. 32



top


Param. 41



top


Param 42



top


Param. 43



top


Print Bank Location



top


Source Planned Day



top


Source Planned Month



top


Source Last Year



top


Source Amount



top


Source to Business Partner



top


Source Amount Text



top


Source Day Today



top


Source Month to Day



top


Source Year to Day



top


Bank location font



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 867 times. This page was last modified on 5 August 2014, at 14:00. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.