References (Supported Data Types)


Type Description
Account Account Element
Amount Number with 4 decimals
Assignment Resource Assignment
Binary Binary Data
Button Command Button - starts a process
Color Color element
Costs+Prices Costs + Prices (minimum currency precision, but if exists more)
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 10 Digit numeric
List Reference List
Location (Address) Location/Address
Locator (WH) Warehouse Locator Data type
Memo Large Text Editor - Character String up to 2000 characters
Number Float Number
Printer Name
Product Attribute Product Attribute
Quantity Quantity data type
RowID Row ID Data Type
Search Search List
String Character String
Table Table List (Use Key and Display)
Table Direct Direct Table Access
NOTE: Table name is taken from the column name except the _ID suffix – CASE SENSITIVE (Use Key and Identifier)
Text Character String up to 2000 characters
Text Long Text (Long) - Text > 2000 characters
Time Time
URL URL
Yes-No CheckBox

Comments

Post a Comment

Popular posts from this blog

Print Paper

Steps for creating a new Print Paper in ADempiere Login to the Client. Navigate System Admin > General Rules > Printing > Print Paper window. Create a new record, Enter Paper Name. The most important field is validation code. I have mentioned below list of validation code which can be used. Left, Right, Top, Bottom Margin is determined in units of 1/72 inch. Determine the value that is wanted. Here is the validation code that can be used in ADempiere:   iso-a0 iso-a1 iso-a2 iso-a3 iso-a4 iso-a5 iso-a6 iso-a7 iso-a8 iso-a9 iso-a10 iso-b0 iso-b1 iso-b2 iso-b3 iso-b4 iso-b5 iso-b6 iso-b7 iso-b8 iso-B9 iso-B10 iso-designated-long italian-envelope monarch-envelope personal-envelope na-number-9-envelope na-number-10-envelope na-number-11-envelope na-number-12-envelope na-number-14-envelope na-6x9-envelope na-7x9-envelope na-9x11-envelope na-9x12-envelope na-10x13-envelope na-10x14-envelope na...
Read more

Window, Tab and Field

The Window, Tab & Field Window defines the presentation (GUI) of tables and columns within each window. Transaction windows just show items created/updated last 24 hours or pending (user can select to show more with history button) Window Tab Level: Top = 0 (The master), level 1 entries are dependent on level 0, level 2 on level 1, and so on Link Column: The foreign key to link with the parent – it needs to be defined here if the table has more than one parent Tab Field Group: New functionality -> Collapse, Horizontal tab, label New functionality (still beta) -> master/detail Field The Field Tab defines the Fields displayed within a tab. If the Sequence is negative, the record are ordered descending. Note that the name, description and help is automatically synchronized if centrally maintained.
Read more

ADempiere Features

ERP Features Sales: Quotes to Invoice, Proposals, POS, Sales Orders, Work Orders, Invoicing, Shipment Purchasing: Purchase Requisition, RfQ, Purchase Order, Material Reciept, Invoicing Manufacturing Management: Product Life Cycle Management, Pool Resource Management, Manufacturing_Workflows, Forecast Management, Planning Management,CRP, MRP, DRP, Discrete Manufacturing,Maintenance Management, Quality Management, Costing Management Material Management: Inventory Control, Warehouse Management, Replenishment, Stock Movement, Stock Count, Price List, Bill of Materials Finance: General Ledger , Accounts Receivable, Accounts Payable, Financial Reporting, Cash Management Budgeting, VAT/TAX/IVA Human Resource: Payroll, Payroll Concepts, Payroll Rule Engine Project Management, Manufacturing, Customer Relationship Management (CRM), POS, ecommerce Maintenance Management OLAP & Reporting Business Intelligence, Financial Reporting, Extending Report...
Read more