Difference between revisions of "Export Format (Window ID-53025)"
From iDempiere en
m (Created page with " <!-- Note to editors: DON'T MODIFY THIS CODE --> Category: Reference Manual Category: dataimport {{Export Format (Window ID-53025 V1.0.0)}} <!-- END Note to editors:...") |
CarlosRuiz (talk | contribs) (template generated from idempiere51) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | <!-- breadcrumb --> | ||
| + | <font size=-2> | ||
| + | ⇐ | ||
| + | [[Manual|Table of Contents]] | ||
| + | </font> | ||
| + | |||
| + | [[Category:Manual|W]] | ||
| + | |||
| + | [[en:Export Format (Window ID-53025)]] | ||
| + | [[ar:Export Format (نافذة ID-53025)]] | ||
| + | [[bg:Export Format (прозорец ID-53025)]] | ||
| + | [[da:Export Format (Vindue ID-53025)]] | ||
| + | [[de:Exportformat (Fenster ID-53025)]] | ||
| + | [[el:Export Format (παράθυρο ID-53025)]] | ||
| + | [[es:Formato Exportación (Ventana ID-53025)]] | ||
| + | [[fr:Format d'export (Fenêtre ID-53025)]] | ||
| + | [[hu:Export Format (Aablak ID-53025)]] | ||
| + | [[id:Export Format (jendela ID-53025)]] | ||
| + | [[it:Export Format (finestra ID-53025)]] | ||
| + | [[ja:Export Format (ウィンドウ ID-53025)]] | ||
| + | [[ms:Export Format (tetingkap ID-53025)]] | ||
| + | [[nl:Export Format (Venster ID-53025)]] | ||
| + | [[pl:Export Format (Okno ID-53025)]] | ||
| + | [[pt:Export Format (Janela ID-53025)]] | ||
| + | [[ro:Export Format (fereastră ID-53025)]] | ||
| + | [[ru:Export Format (окно ID-53025)]] | ||
| + | [[sr:Export Format (прозор ID-53025)]] | ||
| + | [[sv:Export Format (Fönster ID-53025)]] | ||
| + | [[th:Export Format (หน้าต่าง ID-53025)]] | ||
| + | [[tr:Export Format (pencere ID-53025)]] | ||
| + | [[zh:Export Format (窗口 ID-53025)]] | ||
<!-- Note to editors: DON'T MODIFY THIS CODE --> | <!-- Note to editors: DON'T MODIFY THIS CODE --> | ||
Latest revision as of 15:32, 17 November 2017
Window: Export Format
Description:
Help:
Tab: Export Format
Description:
Help:
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | EXP_Format.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | EXP_Format.AD_Org_ID numeric(10) Table Direct |
| Search Key | Search key for the record in the format required - must be unique | 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). |
EXP_Format.Value character varying(40) String |
| Version | Version of the table definition | The Version indicates the version of this table definition. | EXP_Format.Version character varying(40) 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. | EXP_Format.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | EXP_Format.Description character varying(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. |
EXP_Format.IsActive character(1) Yes-No |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | EXP_Format.Help character varying(2000) Text |
| Table | Database Table information | The Database Table provides the information of the table definition | EXP_Format.AD_Table_ID numeric(10) Search |
| Sql WHERE | Fully qualified SQL 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". | EXP_Format.WhereClause character varying(255) Text |
| Test Import Model | Test Import of XML files | EXP_Format.TestImportModel character(1) Button | |
| Test Export Model | Test Export of XML files | EXP_Format.TestExportModel character(1) Button | |
| Export Format | EXP_Format.EXP_Format_ID numeric(10) ID |
Tab: Export Format Line
Description:
Help:
File:Export Format - Export Format Line - Window (iDempiere 1.0.0).png
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | EXP_FormatLine.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | EXP_FormatLine.AD_Org_ID numeric(10) Table Direct |
| Export Format | EXP_FormatLine.EXP_Format_ID numeric(10) Table Direct | ||
| Search Key | Search key for the record in the format required - must be unique | 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). |
EXP_FormatLine.Value character varying(40) 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. | EXP_FormatLine.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | EXP_FormatLine.Description character varying(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. |
EXP_FormatLine.IsActive character(1) Yes-No |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | EXP_FormatLine.Help character varying(2000) Text |
| Position | EXP_FormatLine.Position numeric(10) Integer | ||
| Mandatory | Data entry is required in this column | The field must have a value for the record to be saved to the database. | EXP_FormatLine.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. | EXP_FormatLine.Type character(1) List |
| Column | Column in the table | Link to the database column of the table | EXP_FormatLine.AD_Column_ID numeric(10) Search |
| Is Part Unique Index | EXP_FormatLine.IsPartUniqueIndex character(1) Yes-No | ||
| Embedded Format | EXP_FormatLine.EXP_EmbeddedFormat_ID numeric(10) Table | ||
| Date Format | Date format used in the input format | The date format is usually detected, but sometimes need to be defined. | EXP_FormatLine.DateFormat character varying(40) String |
.png){kind=link}