Difference between revisions of "Adempiere3.4.0/en/ManPageW ImportLoaderFormat olh"
(→Tab: Format Field) |
m (→Tab: Format Field) |
||
Line 263: | Line 263: | ||
|'''''Start No''''' | |'''''Start No''''' | ||
||Starting number/position | ||Starting number/position | ||
− | ||The Start Number indicates the starting position or column number of the field in the source data. | + | ||The Start Number indicates the starting position or column number of the field in the source data. The first column/position has Starting Number = 1. |
|| <small>StartNo | || <small>StartNo | ||
Revision as of 13:27, 29 September 2009
Window: Import Loader Format
Description : Maintain Import Loader Formats
Help : The Import Loader Format Window is used for defining the file layout for product information which will be imported.
Tab: Import Format
Description :
Help :
Table Name : AD_ImpFormat
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
Format | Format of the data | The Format is a drop down list box for selecting the format type (text, tab delimited, XML, etc) of the file to be imported | FormatType
CHAR(1) List |
Copy Lines | Copy Lines from other Import Format | Processing
CHAR(1) Button |
Tab: Format Field
Description : Maintain Format Fields
Help : Define the individual field based on the table definition. Please note that you have to make sure that a Constant has the correct SQL data type (i.e. if it is a 'string', you need to enclose it like 'this').
Product mapping (for details see documentation):
H_Item => Value H_ItemDesc => Name / Description H_ItemDefn => Help H_ItemType => ProductCategory H_PartnrID => Value of Business Partner H_Commodity1 => Vendor Product No H_Commodity2 => SKU H_ItemClass => Classification (A,B,C..) V_OperAmt_T_Cur => Currency V_OperAmt_T => Price
Table Name : AD_ImpFormat_Row
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Import Format | AD_ImpFormat_ID
NUMBER(10) TableDir | ||
Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo
NUMBER(10) Integer |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Column | Column in the table | Link to the database column of the table | AD_Column_ID
NUMBER(10) TableDir |
Data Type | Type of data | DataType
CHAR(1) List | |
Data Format | Format String in Java Notation, e.g. ddMMyy | The Date Format indicates how dates are defined on the record to be imported. It must be in Java Notation | DataFormat
NVARCHAR2(20) String |
Start No | Starting number/position | The Start Number indicates the starting position or column number of the field in the source data. The first column/position has Starting Number = 1. | StartNo
NUMBER(10) Integer |
End No | EndNo
NUMBER(10) Integer | ||
Decimal Point | Decimal Point in the data file - if any | DecimalPoint
CHAR(1) String | |
Divide by 100 | Divide number by 100 to get correct amount | DivideBy100
CHAR(1) YesNo | |
Constant Value | Constant value | ConstantValue
NVARCHAR2(60) String | |
Callout | Fully qualified class names and method - separated by semicolons | A Callout allow you to create Java extensions to perform certain tasks always after a value changed. Callouts should not be used for validation but consquences of a user selecting a certain value.
The callout is a Java class implementing org.compiere.model.Callout and a method name to call. Example: "org.compiere.model.CalloutRequest.copyText" instanciates the class "CalloutRequest" and calls the method "copyText". You can have multiple callouts by separating them via a semicolon |
Callout
NVARCHAR2(60) String |
Script | Dynamic Java Language Script to calculate result | Use Java language constructs to define the result of the calculation | Script
NVARCHAR2(2000) Text |