37 Company

This chapter includes these topics:

37.1 Company Overview

This chapter provides detailed information about the business interfaces that are available for the Company business object.

This table lists all of the available interface components:

Interface Type Available Interfaces
Business Services The Company Manager web service (JP000010) manages the processing of Company constant-related web service operations:
  • getCompany (J0000110 )

  • processCompany (J0000100)

Real-Time Events This list includes the real-time events for the Company business object:
  • RTCOOUT

  • RTCOOUT2

Batch Import Programs This list includes the batch import programs for the Company business object:
  • Process Company Constants Inbound (R0010ZI)

  • Purge Company Z File (R0010ZP)

Batch Export This list includes the batch export programs for the Company business object:
  • Company File Export (R0010ZO)

Additional Components There are several programs that work together to enable users to manually input, or upload from a spreadsheet, company data. The data can be reviewed and modified, and then transferred to a the live EnterpriseOne tables. You can then purge the records in the temporary table.

For additional information about these programs, seeImporting and Exporting Business Unit and Company Records (Release 9.1 Update)



Note:

You can find additional technical information about each type of business interface component. For additional descriptions of the information available, and instructions for finding this information, see Chapter 5, "Accessing Additional Information for Business Interface Components."

37.2 Company Business Services - CompanyManager

This section describes the available business services associated with the Company business object, which include the Company Manager web service (JP000010), which manages the processing of these company-related web service operations:

The Company Manager web service (JP000010) manages the processing of the company-related web service operations. This table includes a description of the company web service operations:

Operation Description
getCompany (J0000110 ) Use this operation to retrieve and review company constants from the JD Edwards EnterpriseOne General Accounting system.
processCompany (J0000100) Use this operation to add, company constant record in the JD Edwards EnterpriseOne General Accounting system.

37.2.1 Accessing Javadoc for the CompanyManager Web Services

To access Javadoc for the CompanyManager web service and its related operations, review these Javadoc packages:

  • JP000010 (CompanyManager)

  • getCompany (J0000110 )

  • processCompany (J0000100)

37.2.2 getCompany

The getCompany web service operation is a database query operation that enables consumers to retrieve company constant records from the JD Edwards EnterpriseOne General Accounting system.

The operation retrieves records based on the selection criteria that is passed in. If no selection criteria is passed in, the operation attempts to retrieve all records from the EnterpriseOne database, using the business service property to limit the number of records returned. If the operation encounters errors, processing stops and the errors are returned to the consumer.

37.2.2.1 Setup Considerations

Before you use this operation, you can set business service properties to specify how the system processes contact data. This table includes information about the business service properties that the getCompany operation uses:

Group Key Description Default Value
J0000110 J0000110_MAX_ROWS Use this business service property to specify the maximum number of records the operation returns for the query. 100

See JD Edwards EnterpriseOne Tools Business Services Development Methodology Guide.


Note:

It is recommended that this business service property is configured and used. Also, it is strongly recommended that the consumer pass in selection criteria when performing a query. If these two recommendations are not followed, the operation attempts to fetch all the records from the database, which can significantly impact performance.

Also be aware that this operation performs multiple data retrievals from the EnterpriseOne database. Initially, records are selected from the Company constant tables (F0010,F0010T) based on the selection criteria that is passed in by the consumer. After the operation retrieves records from the F0010, processing continues, and additional record is retrieved from the Company Constant Tag table(F0010T), based on the data in the F0010 records. This business service property limits the number of records initially retrieved from the F0010. Therefore, the total number of records that are returned to the consumer might be greater than the value that you enter in this property.


37.2.2.2 Implementation Details

This table includes information that can help determine whether the getCompany operation is functioning correctly:

Question Answer
How can I tell if the operation completes successfully? If the operation completes successfully, zero to many records are returned to the consumer based on the selection criteria.

The records that are returned to the consumer include all of the fields that are listed in the response interface for this operation. However, some of those fields can contain blank or zero values, depending on the data that exists in the JD Edwards EnterpriseOne system.

At a minimum, the system returns non-zero values for these fields:

  • companyNumber

  • companyName

  • GeneralAccounting

  • fiscalDatePattern

  • numberofPeriod

  • currentGLPeriodandBeginFiscalYear

  • currentPeriod

  • beginFiscalYear

  • accountPayable

  • currentAPPeriodandBeginFiscalYear

  • currentPeriod

  • beginFiscalYear

  • accountsReceivable

  • currentARPeriodandBeginFiscalYear

  • currentPeriod

  • beginFiscalYear

If I encounter errors while processing a transaction, do I need to reverse the transaction? This is a database query operation that does not perform transactions. If you encounter errors during processing, review your search criteria and business service property settings and try your query again. If the operation does not return any records, verify that records matching your query exist in the JD Edwards EnterpriseOne database.
Does this operation use record reservation? No. The operation does not reserve records within the JD Edwards EnterpriseOne system during processing.

37.2.3 processCompany

The processCompany web service operation is an inbound transaction operation that enables consumers to add, delete Company Constants in the JD Edwards EnterpriseOne General Accounting system.

If the operation completes successfully, the consumer receives a success message. If the operation encounters errors, processing stops and the errors are returned to the consumer.

37.2.3.1 Implementation Details

This table includes information that can help determine whether the processCompany operation is functioning correctly:

Question Answer
How can I tell if the operation completes successfully? If the operation completes successfully, a success message is returned to the consumer.

The records that are returned to the consumer include all of the fields that are listed in the response interface for this operation. However, some of those fields can contain blank or zero values, depending on the data that exists in the JD Edwards EnterpriseOne system.

At a minimum, the system returns non-zero values for these fields:

  • companyNumber

  • companyName

  • generalAccounting

  • fiscalDatePattern

  • numberofPeriod

  • currentGLPeriodandBeginFiscalYear

  • currentPeriod

  • beginFiscalYear

  • accountPayable

  • currentAPPeriodandBeginFiscalYear

  • currentPeriod

  • beginFiscalYear

  • accountsReceivable

  • currentARPeriodandBeginFiscalYear

  • currentPeriod

  • beginFiscalYear

If I encounter errors while processing a transaction, do I need to reverse the transaction? This operation uses standard transaction processing. If the system encounters errors during processing, no data in the JD Edwards EnterpriseOne system is updated. No manual updates are required.
Does this operation use record reservation? No. The operation does not reserve records within the JD Edwards EnterpriseOne system during processing.

37.3 Company Real-Time Events

This section describes the available real-time events associated with the Company business object, which include:

  • RTCOOUT

  • RTCOOUT2

37.3.1 RTCOOUT

RTCOOUT is a single event generated by the JD Edwards EnterpriseOne system to provide company information.

Event Type Event Description Event Category Event Aggregate Product Code Data Structure
RTCOOUT Company Master RTE Single H00 D0000310B: Company Real Time Notification Outbound Data

37.3.1.1 Conceptual Approach

A new company added in the JD Edwards EnterpriseOne system creates a new record in the Company table (F0010). If a company is added or modified in a system, the information is sent to a third-party system for add or update. If a company is deleted, the pertinent information is sent to the third-party, which will take the appropriate action. If applicable, the third-party integration must update the cross-reference table in the process in order to tie together the key values from both systems.

37.3.1.2 Objects that Can Initiate the Event

These objects can initiate the RTCOOUT event:

  • P0000 - System Setup

  • P0010 - Companies

  • B0000132 - Update Currency Conversion

  • B03B0026 - Retrieve/Update A/R Constants

37.3.2 RTCOOUT2

RTCOOUT2 is a single event generated by the JD Edwards EnterpriseOne system to provide company information.

Event Type Event Description Event Category Event Aggregate Product Code Data Structure
RTCOOUT2 RTCOOUT2 RTE Single H00 D0001460B: Company Real Time Notification Outbound Data 2

37.3.2.1 Conceptual Approach

A new company added in the JD Edwards EnterpriseOne system creates a new record in the Company tables (F0010,F0010T). If a company is added or modified in a system, the information is sent to a third-party system for add or update. If a company is deleted, the pertinent information is sent to the third-party, which will take the appropriate action. If applicable, the third-party integration must update the cross-reference table in the process in order to tie together the key values from both systems.

37.3.2.2 Objects that Can Initiate the Event

These objects can initiate the RTCOOUT2 event:

  • P0000 - System Setup

  • P0010 - Companies

  • B0000132 - Update Currency Conversion

  • B03B0026 - Retrieve/Update A/R Constants

  • R890010E - Currency Conversion

  • B0001450 - Process Company Info

  • P001001 - Alternate Tax Rate/Area Assign

  • P00218 - Invoice and Voucher Company Tax Constants

37.4 Company Batch Import Programs

You use batch import programs to import data from an external software system into the JD Edwards EnterpriseOne system, where it can then be processed by EnterpriseOne programs.

This table lists and describes the available batch import programs that are associated with the Company business object:

Program and Program Type Description Available Documentation
Process Company Constants Inbound (R0010ZI) This program is used to import data from the F0010Z into the F0010 and F0010T tables. See this topic:

37.5 Company Batch Export Programs

You use batch export programs to retrieve and format data from the JD Edwards EnterpriseOne database so that it can be used by an external software system.

This table lists and describes the available batch export programs that are associated with the Company business object:

Program and Program Type Description Available Documentation
Company File Export (R0010ZO) Run this program to export data from the F0010 and F0010T tables and create an XML output that can be consumed by a third party system. See this topic: