Difference between revisions of "Entering Data - Fields and Buttons"
m (→Account) |
m (Intermediate save - more to follow.) |
||
Line 12: | Line 12: | ||
{{Space}} | {{Space}} | ||
Data can be typed into the field as text. The data that is entered will be assessed as follows: | Data can be typed into the field as text. The data that is entered will be assessed as follows: | ||
− | * If the text is null, zero length or equals "%", the | + | * If the text is null, zero length or equals "%", the [[Account Dialog]] will be opened. |
* If the text does not end with a percent sign "%", one is added as the last character. | * If the text does not end with a percent sign "%", one is added as the last character. | ||
* The software then looks for a valid combination where the alias or the combination string match the text | * The software then looks for a valid combination where the alias or the combination string match the text | ||
Line 23: | Line 23: | ||
==Amount== | ==Amount== | ||
− | + | Amounts are numeric fields with a minimum precision of 2 decimal places and a maximum of 12. Amount fields are typically used for monetary values. See [[#Number|Number]] for more information. | |
+ | |||
==Assignment== | ==Assignment== | ||
Resource Assignment | Resource Assignment | ||
Line 33: | Line 34: | ||
Color element | Color element | ||
==Costs+Prices== | ==Costs+Prices== | ||
− | Costs + Prices | + | Costs + Prices are numeric fields with a minimum precision of 2 decimal places and a maximum of 12. Costs + Prices fields are typically used for monetary values. See [[#Number|Number]] for more information. |
+ | |||
==Date== | ==Date== | ||
Date mm/dd/yyyy | Date mm/dd/yyyy | ||
Line 47: | Line 49: | ||
Binary Image Data | Binary Image Data | ||
==Integer== | ==Integer== | ||
− | + | The Integer field is a numeric field with no fractional part and a maximum of 10 digits. See [[#Number|Number]] for more information. | |
+ | |||
==List== | ==List== | ||
Reference List | Reference List | ||
Line 56: | Line 59: | ||
==Memo== | ==Memo== | ||
Large Text Editor - Character String up to 2000 characters | Large Text Editor - Character String up to 2000 characters | ||
+ | |||
==Number== | ==Number== | ||
− | + | Number fields provide a way to enter and display numeric values. There are several types: | |
+ | * [[#Amount|Amounts]] | ||
+ | * [[#Costs+Prices|Costs + Prices]] | ||
+ | * [[#Integer|Integers]] and | ||
+ | * [[#Quantity|Quantities]] | ||
+ | |||
+ | The default number field has a maximum of 28 digits in the integer part and 12 digits in the fractional part. The default presentation is as a float number with one digit after the decimal. The number of digits in the presentation varies with the type of field. | ||
+ | |||
+ | All the numeric fields use the [[Calculator Tool]] as the helper function. To access the Calculator, click on the Calculator icon ([[Image:Icon_Calculator24.png]]). | ||
+ | |||
+ | The presentation of the field for all the numeric fields can be overridden by defining a number format in the {{TabRef|TableandColumn|Column}} of the {{WindowRef|TableandColumn|Table and Column}}. | ||
+ | |||
+ | |||
+ | |||
==Printer Name== | ==Printer Name== | ||
==Product Attribute== | ==Product Attribute== | ||
Product Attribute | Product Attribute | ||
+ | |||
==Quantity== | ==Quantity== | ||
− | Quantity | + | The Quantity field is a numeric field with a maximum of 12 digits in the fractional part and 28 digits in the integer part. See [[#Number|Number]] for more information. |
+ | |||
==RowID== | ==RowID== | ||
Row ID Data Type | Row ID Data Type |
Revision as of 19:22, 7 November 2010
⇐ Table of Contents{{#if: | | [[{{{2}}}]] }}{{#if: | | [[{{{3}}}]] }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Entering Data - Fields and Buttons{{#if: Functionality| | Functionality }} ⇒
Each window that you open in ADempiere will likely provide you with the opportunity to enter data. This article describes the types of fields, buttons and controls that you will come across, the type of data that they will accept and how each of them functions. All the controls are listed below. The most common ones are String, Number, Date.
Several of the fields have helper functions, indicated by an icon/button at the right side of the field. The helper functions can be opened by clicking this icon. They may also open if the entered data is not clear or complete. The helper functions include the Calendar Tool, Calculator Tool, Search and Info windows (See the Functionality list, and others.
Contents
- 1 Account
- 2 Amount
- 3 Assignment
- 4 Binary
- 5 Button
- 6 Color
- 7 Costs+Prices
- 8 Date
- 9 Date+Time
- 10 FileName
- 11 FilePath
- 12 ID
- 13 Image
- 14 Integer
- 15 List
- 16 Location (Address)
- 17 Locator (WH)
- 18 Memo
- 19 Number
- 20 Printer Name
- 21 Product Attribute
- 22 Quantity
- 23 RowID
- 24 Search
- 25 String
- 26 Table
- 27 Table Direct
- 28 Text
- 29 Text Long
- 30 Time
- 31 URL
- 32 Yes-No
Account
The Account Element control displays the details of a selected Accounting Dimension or combination. (See Accounting Dimensions for more info.) It is usually found on Accounting tabs which provide accounting information related to the parent tab.
Data can be typed into the field as text. The data that is entered will be assessed as follows:
- If the text is null, zero length or equals "%", the Account Dialog will be opened.
- If the text does not end with a percent sign "%", one is added as the last character.
- The software then looks for a valid combination where the alias or the combination string match the text
- If there is a single match, the field is filled with the valid combination.
- If there is no match or more than one match, the Account Dialog is opened.
The Account Button () can also be pressed to activate the Account Dialog. A combination selected in the Account Dialog will be displayed once the dialog is confirmed and closed. If the Account Dialog is canceled, the Account field will be cleared.
(Software: client/src org.compiere.grid.ed.VAccount.java)
Amount
Amounts are numeric fields with a minimum precision of 2 decimal places and a maximum of 12. Amount fields are typically used for monetary values. See Number for more information.
Assignment
Resource Assignment
Binary
Binary Data
Button
Command Button - starts a process
Color
Color element
Costs+Prices
Costs + Prices are numeric fields with a minimum precision of 2 decimal places and a maximum of 12. Costs + Prices fields are typically used for monetary values. See Number for more information.
Date
Date mm/dd/yyyy
Date+Time
Date with time
FileName
Local File
FilePath
Local File Path
ID
10 Digit Identifier
Image
Binary Image Data
Integer
The Integer field is a numeric field with no fractional part and a maximum of 10 digits. See Number for more information.
List
Reference List
Location (Address)
Location/Address
Locator (WH)
Warehouse Locator Data type
Memo
Large Text Editor - Character String up to 2000 characters
Number
Number fields provide a way to enter and display numeric values. There are several types:
The default number field has a maximum of 28 digits in the integer part and 12 digits in the fractional part. The default presentation is as a float number with one digit after the decimal. The number of digits in the presentation varies with the type of field.
All the numeric fields use the Calculator Tool as the helper function. To access the Calculator, click on the Calculator icon ().
The presentation of the field for all the numeric fields can be overridden by defining a number format in the {{#if: |{{{3}}}|Column }} Tab of the {{#if: Table and Column|Table and Column|TableandColumn }} Window.
Printer Name
Product Attribute
Product Attribute
Quantity
The Quantity field is a numeric field with a maximum of 12 digits in the fractional part and 28 digits in the integer part. See Number for more information.
RowID
Row ID Data Type
Search
Search Field
String
Character String
Table
Table List
Table Direct
Direct Table Access
Text
Character String up to 2000 characters
Text Long
Text (Long) - Text > 2000 characters
Time
Time
URL
URL
Yes-No
CheckBox