导入载入程序格式 (窗口 ID-189)
来自iDempiere zh
窗口: 导入载入程序格式
描述: Maintain Import Loader Formats
幫助: The Import Loader Format Window is used for defining the file layout for product information which will be imported.
TAB: 导入格式
描述: null
幫助 null
File:导入载入程序格式 - 导入格式 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| 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 character varying(60) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Table | 表 | 字段所在表 | The Table indicates the table in which a field or fields reside. | AD_Table_ID numeric(10) NOT NULL Table Direct |
| Format | 格式 | 数据的格式 | 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 character(1) NOT NULL List |
| Separator Character | Separator Character | null | null | SeparatorChar character varying(1) String |
| Copy Lines | 复制明细 | 复制从其他的导入格式 | null | Processing character(1) NOT NULL Button |
TAB: 格式字段
描述: Maintain Format Fields
幫助 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 =>值 H_ItemDesc => Name Description H_ItemDefn =>帮助 H_ItemType =>ProductCategory H_PartnrID =>业务伙伴的价值 H_Commodity1 =>供应商产品号 H_Commodity2 =>SKU H_ItemClass => Classification (A,B,C..) V_OperAmt_T_Cur =>币种 V_OperAmt_T =>价格File:导入载入程序格式 - 格式字段 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Format Field | 格式字段 | null | null | AD_ImpFormat_Row_ID numeric(10) NOT NULL ID |
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Import Format | 导入格式 | null | null | AD_ImpFormat_ID numeric(10) NOT NULL Table Direct |
| Sequence | 序列 | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo numeric(10) NOT NULL 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 character varying(60) NOT NULL String |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Column | 列 | 在表中的列 | 链接到数据库表中的列。 | AD_Column_ID numeric(10) NOT NULL Table Direct |
| Data Type | 数据类型 | 数据的类型 | null | DataType character(1) NOT NULL 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 character varying(20) String |
| Start No | 开始号 | Starting number position | The Start Number indicates the starting number of the document or position | StartNo numeric(10) Integer |
| End No | 结束号 | null | null | EndNo numeric(10) Integer |
| Decimal Point | 小数点 | Decimal Point in the data file - if any | null | DecimalPoint character(1) NOT NULL String |
| Divide by 100 | 除以100 | Divide number by 100 to get correct amount | null | DivideBy100 character(1) NOT NULL Yes-No |
| Constant Value | 常数值 | Constant value | null | ConstantValue character varying(60) String |
| Callout | Callout | Function Calls separated by semicolons; SE_ SL_ UE_ UL_ - 1st: System User; 2nd: Enter Leave; 3rd: _ Underscore, - then Function Name | 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 character varying(60) String |
| Script | 脚本 | Dynamic Java Language Script to calculate result | Use Java language constructs to define the result of the calculation | Script character varying(2000) Text |
.png){kind=link}
.png){kind=link}