1/21
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Data Access Tools
1.1
JD Edwards EnterpriseOne Data Access Tools Overview
1.2
JD Edwards EnterpriseOne Data Access Tools Implementation Steps
Part I Designing Tables in JD Edwards EnterpriseOne
2
Designing Tables
2.1
Understanding JD Edwards EnterpriseOne Table Design Aid
2.2
Understanding Table Creation
2.3
Creating Tables
2.3.1
Creating Audit Trail Information
2.3.2
Naming Tables
2.3.3
Using Index Guidelines
2.4
Working with JD Edwards EnterpriseOne Table Design Aid
2.4.1
Using Table Design Aid Forms
2.4.2
Selecting Data Items
2.4.3
Defining Indices
2.4.4
Reviewing Table Information
2.5
Working with Tables
2.5.1
Generating Tables
2.5.2
Generating Indices
2.5.3
Generating Header Files
2.5.4
Copying Tables
2.5.5
Removing Tables
2.6
Viewing the Data in Tables
2.7
Designing Custom Tables
2.7.1
Forms Used to Create Tables
2.7.2
Adding Table Objects
2.7.3
Modifying Table Objects
2.7.4
Selecting Data Items for Tables
2.7.5
Defining Indices
2.7.6
Previewing Tables
2.7.7
Generating Tables
2.7.8
Generating Indices
2.7.9
Generating Header Files
2.7.10
Copying Tables
2.7.11
Removing Tables
2.7.12
Viewing the Data in Tables
3
Working with Table Input/Output
3.1
Understanding Table I/O
3.1.1
Available Operations
3.1.2
Valid Mapping Operators
3.2
Understanding Buffered Inserts
3.2.1
Buffered Insert Error Messaging
3.3
Understanding Special Operations
3.3.1
Get Error Data Event Rules Example
3.4
Understanding Handles
3.5
Working with Table I/O
3.5.1
Prerequisites
3.5.2
Creating Table I/O Event Rules
3.5.3
Using Buffered Inserts in Table I/O
3.5.4
Using Special Operations for Buffered Inserts
3.5.5
Creating Handles
3.5.6
Using Handles with Table I/O
4
Creating Table Event Rules
4.1
Understanding Table Event Rules
4.2
Working with Table Event Rules
4.2.1
Understanding Table Event Rule Triggers
4.2.2
Adding Table Event Rules to Table Conversions
Part II Using Cross Reference Facility
5
Understanding the Cross Reference Facility
5.1
Understanding the Cross Reference Facility
5.2
Searching for Objects
5.2.1
Searching for Objects
5.2.1.1
Searching for Data Items
5.2.1.2
Searching for Interactive Applications
5.2.1.3
Searching for Batch Applications
5.2.1.4
Searching for Business Functions
5.2.1.5
Searching for Business Views
5.2.1.6
Searching for Data Structures
5.2.1.7
Searching for Tables
5.2.1.8
Searching for Forms
5.2.1.9
Searching for Event Rules
5.3
Viewing Field Relationships
5.3.1
Search Types
5.3.2
Control Types
5.4
Rebuilding Cross-Reference Information
5.4.1
Understanding Rebuilding Cross-Reference Information
5.4.2
Rebuilding Information for the Cross-Reference Facility
5.5
Working with the Cross Reference Facility Application
5.5.1
Forms Used to Work with the Cross Reference Facility
5.5.2
Searching for Objects
5.5.3
Searching for Event Rules
5.5.4
Viewing Field Relationships
5.5.5
Rebuilding Cross-Reference Information
Part III Designing Business Views
6
Understanding Business Views
6.1
Business Views
6.1.1
Table Joins
6.1.2
Table Union
6.1.3
Select Distinct
6.1.4
Primary Key Fields
7
Designing Business Views
7.1
Understanding Business View Design Aid
7.2
Understanding Business View Naming Conventions
7.2.1
External Developer Considerations for Naming Business Views
7.2.2
Naming Joined Business Views
7.3
Understanding Business View Design Aid
7.3.1
Understanding the Business View Design Aid Interface
7.3.2
Tables for Business Views
7.3.3
Data Items for Business Views
7.3.4
Select Distinct
7.3.4.1
Example: Select Distinct Feature
7.3.5
Table Joins
7.3.6
Table Unions
7.4
Creating Business Views
7.4.1
Forms Used to Add Business Views
7.4.2
Adding Business Views
7.4.3
Selecting Tables for Business Views
7.4.4
Selecting Data Items for Business Views
7.4.5
Using Select Distinct
7.4.6
Creating Table Joins
7.4.7
Creating Table Unions
Part IV Converting Tables
8
Understanding Table Conversion
8.1
Table Conversions
8.2
Types of Tables to Use
8.3
Business Views in Table Conversions
8.4
Text Files in Table Conversions
8.5
Sort and Selection Criteria in Table Conversions
8.6
Input and Output Environments
9
Setting Up Table Conversions
9.1
Understanding Table Conversion Setup
9.2
Understanding the Table Conversion Process Flow
9.3
Adding Table Conversions
9.3.1
Understanding the Navigation Assistant
9.3.2
Prerequisites
9.3.3
Forms Used to Add New Table Conversions
9.3.4
Adding New Table Conversions
9.3.5
Starting the Table Conversion Director
9.4
Converting Data
9.4.1
Understanding Data Conversion
9.4.1.1
Data Conversion Example
9.4.2
Forms Used to Convert Data
9.4.3
Defining External Data for Table Conversions
9.4.4
Defining Input and Output Environments for Table Conversions
9.4.5
Defining Table Conversion Input
9.4.6
Defining Table Conversion Output
9.4.7
Mapping Inputs to Outputs
9.4.8
Specifying Table Conversion Logging Options
9.4.9
Reviewing Table Conversion Results
9.5
Defining File Formats for Table Conversion Input or Output
9.5.1
Understanding User-Defined Formats
9.5.1.1
Importing and Exporting Text Files
9.5.1.2
Using User-Defined Formats as Input
9.5.1.3
Using User-Defined Formats as Output
9.5.2
Prerequisite
9.5.3
Defining Delimited File Formats with a Single Format
9.5.4
Defining Delimited File Formats with Multiple Formats
9.5.5
Defining Fixed-Width File Formats with a Single Format
9.5.6
Defining Fixed-Width File Formats with Multiple Formats
9.6
Copying Data
9.6.1
Understanding Copying Data
9.6.2
Prerequisites
9.6.3
Defining Data Copy Actions
9.7
Copying Data with Table Input
9.7.1
Understanding How to Copy Data with Table Input
9.7.2
Prerequisites
9.7.3
Defining Data Copy with Table Input Actions
9.8
Deleting Groups of Records
9.8.1
Understanding Batch Deletion
9.8.1.1
Example: Creating Purge Programs as a Batch Delete
9.8.2
Prerequisites
9.8.3
Defining Batch Deletion Actions
9.9
Using Event Rules in Table Conversions
9.9.1
Understanding Event Rules in Table Conversions
9.9.1.1
Table Conversion System Functions
9.9.2
Creating Event Rules in Table Conversions
10
Running Table Conversions
10.1
Understanding Table Conversion Processing
10.2
Submitting Table Conversions
10.2.1
Understanding Submitting Table Conversions
10.2.2
Understanding Overriding Table Conversion Properties
10.2.2.1
Table Conversions on the Web Client
10.2.3
Forms Used to Submit Table Conversions
10.2.4
Overriding Table Conversion Properties at Runtime
10.2.5
Overriding Table Conversion Properties of New Versions
10.2.6
Overriding Table Conversion Locations
10.2.7
Running Table Conversions from the Web Client
10.3
Testing Table Conversions
10.3.1
Understanding Table Conversion Testing
10.3.1.1
Difference Between Logging Options and Debug Logging
10.3.1.2
Trace Levels
10.3.2
Setting the Trace Level for Debug Logging on the Workstation
10.3.3
Setting the Trace Level for Debug Logging on the Server
10.3.4
Forcing Row-By-Row Conversion
11
Preparing Foreign Tables for Table Conversion
11.1
Understanding Foreign Tables
11.2
Adding Data Sources
11.2.1
Forms Used to Add Data Sources
11.2.2
Adding Data Sources
11.3
Adding Environments
11.3.1
Forms Used to Add Environments
11.3.2
Adding Environments
11.4
Setting Up Default OCM Mappings
11.4.1
Understanding OCM Mappings
11.4.2
Forms Used to Set Up Default OCM Mappings
11.4.3
Setting Up Default OCM Mappings
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.