Window: Import Template
[Created: 29/10/2014 - Updated: 29/10/2014 ]
Description:
Help:
Tab: Import Template
[Created: 29/10/2014 - Updated: 29/10/2014 ]
Description:
Help:
Tab Level: 0
Table 10: Import Template - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_importtemplate.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. | ad_importtemplate.AD_Org_ID numeric(10) 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. | ad_importtemplate.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_importtemplate.Description character varying(255) String |
| Window | Data entry or display window | The Window field identifies a unique Window in the system. | ad_importtemplate.AD_Window_ID numeric(10) Table Direct |
| Tab | Tab within a Window | The Tab indicates a tab that displays within a window. | ad_importtemplate.AD_Tab_ID numeric(10) Table Direct |
| Character Set | ad_importtemplate.CharacterSet character varying(20) String | ||
| Separator Character | ad_importtemplate.SeparatorChar character varying(1) String | ||
| Quote Char | ad_importtemplate.QuoteChar character varying(1) String | ||
| CSV Header | ad_importtemplate.CSVHeader character varying(2000) String | ||
| CSV Alias Header | ad_importtemplate.CSVAliasHeader character varying(2000) String | ||
| Import Template Type | ad_importtemplate.ImportTemplateType character varying(4) List | ||
| 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. | ad_importtemplate.IsActive character(1) Yes-No |
Tab: Import Template Access
[Created: 29/10/2014 - Updated: 29/10/2014 ]
Description:
Help:
Tab Level: 1
Table 20: Import Template Access - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_importtemplateaccess.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. | ad_importtemplateaccess.AD_Org_ID numeric(10) Table Direct |
| Import Template | ad_importtemplateaccess.AD_ImportTemplate_ID numeric(10) Table Direct | ||
| Role | Responsibility Role | The Role determines security and access a user who has this Role will have in the System. | ad_importtemplateaccess.AD_Role_ID numeric(10) Table Direct |
| Allow Insert | ad_importtemplateaccess.IsAllowInsert character(1) Yes-No | ||
| Allow Merge | ad_importtemplateaccess.IsAllowMerge character(1) Yes-No | ||
| Allow Update | ad_importtemplateaccess.IsAllowUpdate character(1) Yes-No | ||
| 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. | ad_importtemplateaccess.IsActive character(1) Yes-No |