Export Format (窗口 ID-53025)
窗口: Export Format
描述: null
幫助: null
TAB: Export Format
描述: null
幫助 null
File:Export Format - Export Format - 窗口 (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 |
Search Key | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
Value character varying(40) NOT NULL String |
Version | 版本 | Version of the table definition | The Version indicates the version of this table definition. | Version character varying(40) NOT NULL String |
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 |
Comment/Help | 注释/帮助 | 注释或提示 | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
Table | 表 | 字段所在表 | The Table indicates the table in which a field or fields reside. | AD_Table_ID numeric(10) NOT NULL Search |
Sql WHERE | SQL的Where子句 | Fully qualified WHERE clause | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". | WhereClause character varying(255) Text |
Test Import Model | Test Import Model | Test Import of XML files | null | TestImportModel character(1) Button |
Test Export Model | Test Export Model | Test Export of XML files | null | TestExportModel character(1) Button |
Export Format | Export Format | null | null | EXP_Format_ID numeric(10) NOT NULL ID |
TAB: Export Format Line
描述: null
幫助 null
File:Export Format - Export Format Line - 窗口 (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 |
Export Format | Export Format | null | null | EXP_Format_ID numeric(10) Table Direct |
Search Key | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
Value character varying(40) NOT NULL String |
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 |
Comment/Help | 注释/帮助 | 注释或提示 | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
Position | Position | null | null | Position numeric(10) Integer |
Mandatory | 强制性的 | Data entry is required in this column | The Mandatory checkbox indicates if the field is required for a record to be save to the database. | IsMandatory character(1) Yes-No |
Type | 类型 | Type of Validation (SQL, Java Script, Java Language) | The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language. | Type character(1) NOT NULL List |
Column | 列 | 在表中的列 | 链接到数据库表中的列。 | AD_Column_ID numeric(10) Search |
Is Part Unique Index | Is Part Unique Index | null | null | IsPartUniqueIndex character(1) Yes-No |
Embedded Format | Embedded Format | null | null | EXP_EmbeddedFormat_ID numeric(10) Table |
Reference | 引用 | 系统引用 | The Reference indicates the type of reference field | AD_Reference_ID null Table |
Date Format | Date Format | Date format used in the imput format | The date format is usually detected, but sometimes need to be defined. | DateFormat character varying(40) String |