4 Importing and Exporting Business Unit and Company Records (Release 9.1 Update)

This chapter discusses these topics:

4.1 Business Unit and Company Import and Export Overview

Business interfaces are programs or software components that enable you to share data between JD Edwards EnterpriseOne and other external software systems. There are several business interface components that enable you to share business unit and company data between systems.


See Also:

Introduction to Business Interfaces

4.1.1 Business Unit Import and Export Interface Components

The following business interfaces have been created to enable data sharing of business unit data between JD Edwards EnterpriseOne and external software systems:

  • Business Unit Inbound Application program (P0006Z)

  • Use this program to manually enter records into the Business Unit Master Z File table (F0006Z2). You can also use this program to import business unit records into this table from a spreadsheet. Once records are added, you can use this program to update the records and add translation information for each record.

    See Section 3.4.1.2, "Business Unit Translation."

  • Business Unit Batch Inbound program (R0006ZI)

  • Use this program to transfer records from the F0006Z2 table into the live Business Unit Master table (F0006). Once data is transferred to this table, it is available for processing in the EnterpriseOne system.

  • Business Unit Inbound Purge (R0006ZP)

  • Use this program to delete data out of the F0006Z2 table after it has been processed.


See Also:

For additional information about business unit setup, see Section 3.4, "Setting Up Business Units."

4.1.2 Company Import and Export Interface Components

The following business interfaces have been created to enable data sharing of company data between JD Edwards EnterpriseOne and external software systems:

  • Company Inbound Application program (P0010Z)

  • Use this program to manually enter records into the Company Master Z File table (F0010Z). You can also use this program to import company records into this table from a spreadsheet. Once records are added, you can use this program to update the records as needed.

  • Company Batch Inbound program (R0010ZI)

  • Use this program to transfer records from the F0010Z table into the live Company Master table (F0010). Once data is transferred to this table, it is available for processing in the EnterpriseOne system.

  • Company Inbound Purge (R0010ZP)

  • Use this program to delete data out of the F0110Z table after it has been processed.

  • Company Batch Outbound Program (R0010ZO)

    This program extracts data from the Company Constants table (F0010), and writes the data into an XML file that can be consumed by an external software system.


See Also:

For additional information about setting up company information, see Section 3.3, "Setting Up Companies."

4.2 Using the Business Unit Import and Export Interface Components

This section discusses these topics:

4.2.1 Forms Used to Access Business Unit Import and Export Interface Components

Form Name FormID Navigation Usage
Work With Business Unit - Inbound W0006ZA From the Business Interface Operations menu (G094116), select Business Unit Inbound Application Review existing records, or access forms to add new busienss unit records.
Business Unit Revisions - Inbound W0006ZB From the Work With Business Unit - Inbound form, click Add. Add records to the F0006Z2 table.
Business Unit Translations - Inbound W0006ZC From the Work With Business Unit - Inbound form, select a record, and then select Translations from the Row menu. Add translation records to a business unit.

4.2.2 Adding Business Unit Records Using the Business Unit Interface

Access the Work With Business Unit - Inbound form, and then click Add.

Figure 4-1 Business Unit Revision - Inbound

Description of Figure 4-1 follows
Description of ''Figure 4-1 Business Unit Revision - Inbound''

At a minimum, complete these required fields:

  • Action Code

  • Company

  • Business Unit

  • Description

Complete any addition fields, and then click OK to save your records. The records are then available in the F0006Z2, and can be processed by the Business Unit Batch Inbound Program (R0006ZI) to transfer the records into the F0006 table.

For additional information about business unit records, see Section 3.4, "Setting Up Business Units."

4.2.3 Entering Translation Information for Business Units Using the Business Unit Interface

Access the Business Unit Translations - Inbound form.

Figure 4-2 Business Unit Translations Inbound

Description of Figure 4-2 follows
Description of ''Figure 4-2 Business Unit Translations Inbound''

At a minimum, complete these required fields:

  • Action Code

  • Language Code

  • Description Compressed

Complete any addition fields, and then click OK to save your records.

For additional information about business unit translation records, see Section 3.4.1.2, "Business Unit Translation."

4.2.4 Setting Processing Options for the Business Unit Batch Inbound Program (R0006ZI)

You use processing options to specify default processing information for a program.

4.2.4.1 Versions Tab

1. Business Unit Versions

Use this processing option to specify which version of P0006 program the system uses when processing business unit records. The default value is ZJDE0001.

4.2.5 Running the Business Unit Batch Inbound Program (R0006ZI)

From the Business Interface Operations menu (G094116), select Business Unit Batch Inbound.

4.2.6 Running the Business Unit Inbound Purge Program (R0006ZP)

From the Business Interface Operations menu (G094116), select Business Unit Inbound Purge.

4.3 Using the Company Import and Export Interface Components

This section discusses these topics:

4.3.1 Forms Used to Access Company Import and Export Interface Components

Form Name FormID Navigation Usage
Work With Company - Inbound W0010ZA From the Business Interface Operations menu (G094116), select Company Inbound Application Review existing records, or access forms to add new company records.
Company Revisions - Inbound W00010ZB From the Work With Company - Inbound Form, click Add. Add records to the F0010Z table.

4.3.2 Adding Company Records Using the Company Interface

Access the Company Revisions - Inbound form.

Figure 4-3 Company Revisions - Inbound

Description of Figure 4-3 follows
Description of ''Figure 4-3 Company Revisions - Inbound''

At a minimum, complete these required fields on the :

  • Action Code

  • Company

Complete any addition fields, and then click OK to save your records.

For additional information about business unit records, see Section 3.3, "Setting Up Companies."

4.3.3 Running the Company Batch Inbound Program (R0010ZI)

From the Business Interface Operations menu (G094116), select Company Batch Inbound.

4.3.4 Running the Company Inbound Purge Program (R0010ZP)

From the Business Interface Operations menu (G094116), select Company Inbound Purge.

4.3.5 Running the Company Batch Outbound Program (R0010ZO)

From the Business Interface Operations menu (G094116), select Company Batch Outbound.