3 Working with Companies (WCMP)
Purpose: Use Work with Companies to work with a company on your system.
You must define at least one company in order to use Order Management System. Information throughout Order Management System is segregated by company.
Companies are single, isolated sets of tables and data: an organization of financial information, inventory, and customers. Essentially a company has a completely separate database from other companies.
When should you create more than one company?
You must create another company when you do not want data, for example sales analysis figures, items, and customers, to mix with another company’s data. If you only want to separate sales analysis, you can handle that through entities and divisions.
Creating a company: You can use the COPYCMP Copy Company (program name PFR0200) periodic function to create a company based on the data defined for an existing company. This periodic function uses the following parameters to create a company:
-
the owner of the database.
-
the From company number whose data you wish to copy.
-
the To company number.
-
Y or N setting indicating whether the system should delete the data in the To company before copying. Note: Unless you can verify that you are not copying over any records that already exist in the target company, this setting should be set to N.
Separate each parameter setting with a single space. For example, enter the following in the Parameter field, where DB is the database owner, 1 is the From company number, 2 is the To company number, and N is the Delete To company parameter: DB 1 2 N
Using the copy company periodic function to delete a company: To use the Copy Company periodic function to delete a company, enter the company you wish to delete in the From and To company parameters and set the Delete parameter to Y. For example, enter the following in the Parameter field, where DB is the database owner, 1 is the company you wish to delete, and Y is the Delete parameter: DB 1 1 Y.
In this chapter:
-
Work with Companies Screen (see topic below)
Work with Companies Screen
Purpose: Use this screen to change, delete, or display a company.
How to display this screen: Enter WCMP in the Fast Path field or select Work with Companies from a menu.
Field |
Description |
Company |
A code representing a company. Numeric, 3 positions; optional. |
Description |
The name of the company. Alphanumeric, 30 positions; optional. |
Screen Options | Procedures |
---|---|
Change a company |
Select Change for a company to advance to the Change Company Screen. |
Delete a company |
Select Delete for a company to delete it. |
Display a company |
Select Display for a company to advance to the Display Company screen. You cannot change any information on this screen. See Change Company Screen for a description of the fields on this screen. |
Work with phone numbers for computer telephony integration |
Select Phone #s for a company to advance to the Work with Company Phone Numbers Screen. |
Enter or change the return address for printing on customer return labels from the web storefront |
Select Return address for a company to advance to the Work with Company Return Address Screen. |
Define other companies that share inventory with the parent company |
Select Shared Companies for a company to advance to the Work with Shared Companies Screen. |
Work with user defined field |
Select User Field for a company to advance to the Work with User Fields screen. |
Change Company Screen
Purpose: Use this screen to change a company on the system.
How to display this screen: Select Change at the Work with Companies Screen.
Field | Description |
---|---|
Company |
The company code (001 - 999). Information throughout the system is segregated by company. You can assign or prohibit access to companies to users and user classes. See Working with User Records (WUSR), and Setting Up User Classes (WUCL). Numeric, 3 positions; display-only. |
Description |
The company's name or description, which appears on many screens and reports. Note: The system does not validate the company’s address in the same way it validates a customer’s address, as in order entry. For example, it does not validate that the state is associated with the SCF for the postal code. Alphanumeric, 30 positions; required. |
Address |
The company's address. Alphanumeric, two 32-position fields; optional. |
City |
The company's city. Alphanumeric, 25 positions; optional. |
State |
The code representing the company's state or province. Alphanumeric, 2 positions; optional. |
Zip |
The company's zip or postal code. Alphanumeric, 10 positions; optional. |
Country |
The company's country. Country codes are defined in and validated against the Country table. See Setting Up the Country Table (WCTY) in the online help. Alphanumeric, 3 positions; optional. |
Locale |
The locale assigned to the company, identifying the language that the system uses for reports and HTML email templates. The locale defined in the DEFAULT_LOCALE property initially defaults, but you can override it. Available locales are:
The setting of the locale here controls the settings that are available for the BI Date and Separator Format, below. See:
Required. |
BI Date and Separator Format |
The date and separator formats to use on reports generated through BI Publisher. See Reports and Forms Generated through Oracle BI Publisher for a listing of these reports, and see BI Publisher Date and Separator Formats for a listing of the formats applied on these reports through this setting. The Locale setting controls the BI Date and Separator Formats. If the Locale is set to:
|
Date Format |
The date format assigned to the company, identifying the format of the date that displays for the company on screens. The date format defined in the DEFAULT_DATE_FORMAT property initially defaults, but you can override it. Valid values are:
Note: In order to have a consistent date format on all reports, the DEFAULT_DATE_FORMAT property and this setting should be the same. See: Regional Settings for an overview. Where are Date Formats Applied? for more information on which date format the system uses in different areas of the application. Where are Number Format Applied? for more information on the decimal and thousand separators the system uses in different areas of the application. Required. |
Phone Number |
The company's phone number. Numeric; one 3-position field (area code) and one 8-position field (phone number). |
Fax Phone Number |
The company's fax number. Numeric; one 3-position field (area code) and one 8-position field (phone number). |
From Email Address |
The email address to use as the “from” address for system-generated emails. The system uses the following hierarchy in selecting the “from” email address:
The system performs standard email format validation. Note: The system does not validate the format of the “from” email address, and it does not need to be an existing email address; however, using a working email address provides a means to track undeliverable emails sent to customers. Alphanumeric, 50 positions; optional. |
Cross Company Scan |
Indicates whether you can scan for customers across companies in Order Entry, standard Order Inquiry, and Order Maintenance. Valid values are:
Standard Order Inquiry and Order Maintenance You can use cross-company scanning with the match code, postal code, postal code with company name, and postal code with customer name fields. Order Entry The source code field is at the top of the Select Customer Sold To screen or the Customer Scan screen, enabling cross-company scanning by source code, provided the user does not select to scan for a customer from the Customer Selection screen.
|
Active Company |
Indicates whether this company is currently active. This field works with the Cross Company scan field to select or restrict the companies eligible for cross company scan. You might use this field to distinguish training or testing vs. “live” companies, to prevent users from inadvertently scanning into the wrong type of company. Also, if a company is flagged as inactive, the menu screen displays a message indicating This company is flagged as inactive and should not be used to process live orders. Valid values are:
|
Cross Company Maintenance Group |
You assign a common cross company maintenance group code to a group of companies that share a portion of their customer base. By entering any group in this field, you enable the system to store information on the name or address of each customer you update in this company. You can then identify and update matching customer records within the maintenance group. This code can be any value that you define. Example: If you enter 5 in this field for companies 27, 123, and 495, you will be able to update customer records in companies 123 and 495 based on a change of address you process for the customer in company 27. If you enter B this field for companies 44 and 66, you will be able to update customer records only across these two companies; the system will not update a record in company 44 based on an address change you process in company 27. In order for cross company maintenance to work between companies, both companies must use the same logic for composing match codes. |
Work with Company Phone Numbers Screen
Purpose: Use this screen to work with DNIS (dialed number identification service) phone numbers for computer telephony integration (CTI). The system uses the DNIS number for an incoming call to identify the company related to the call and to route the call appropriately.
The DNIS number is ordinarily the last four positions of the phone number that the customer calls; however, it is possible that the DNIS number is not the same as the actual phone number dialed. In this situation, you can create a company phone number that does not actually exist, but whose last four positions match the DNIS number that you will receive through your CTI application.
Note:
CTI is not currently implemented.For more information: Contact your Order Management System representative for more information on implementing CTI.
Work with Company Return Address Screen
Purpose: Use this screen to create or edit the company address to print on return labels. The system uses this address only if your web storefront supports printing these labels for return authorizations when customers enter returns on the storefront.
Entity return address overrides company address: If you define a return address for the entity associated with an order at the Work with Entity Return Address screen, the system uses the entity return address instead.
If no entity or company return address: If a return address is not specified for the entity associated with the order or for the company, the system uses the address for the Default Warehouse (A04).
How to display this screen: Select Return address for a company at the Work with Companies Screen.
Completing this screen: Enter the address to appear on return labels for use when customers enter returns through your web storefront. To delete the return address, select Delete.
Work with Shared Companies Screen
Purpose: Use this screen to define other companies that share inventory with the parent company. Companies display on this screen in shared company sequence.
Example: If company 555 is the company where the inventory is located, company 555 represents the parent company and any other company that shares inventory with this company is considered a shared company.
Note:
You do not need to define shared companies if you are using inventory sharing.Copying items in the parent company to the shared companies: If you wish to add, update, or delete items in shared companies, based on an item copied in the parent company, you must define shared companies using this screen.
To create: Enter a company code and select OK to create a shared company. The company code must be a valid company. You cannot select the company code that represents the parent company or the screen displays an error message: Shared company must not be the same as the parent company.
Note:
The system allows you to define a company as a shared company for more than one parent company. For example, you can define company 554 as a shared company for both company 555 and company 25. You can also define a shared company for a company that is also a shared company for another company. For example, you can define company 123 as a shared company for company 456, even if company 456 is a shared company for company 789.To scan:: Enter a company code and select OK to position to the shared company. If the company code does not exist as a shared company, the system creates it. The company code must be a valid company.
How to display this screen: Select Shared Companies for a company on the Work with Companies Screen.
Screen Option | Procedure |
---|---|
Company |
The code and name of the parent company. Code: Numeric, 3 positions; display-only. Description: Alphanumeric, 30 positions; display-only. |
Cmp |
A code representing a company that shares inventory with the parent company. If you prompt on this field, the system displays all valid Order Management System companies, not just the companies to which the user has authority. Numeric, 3 positions; display-only. |
Description |
The name of the company. Alphanumeric, 30 positions; display-only. |
Screen Option | Procedure |
---|---|
Delete a shared company |
Select Delete for a shared company to delete it. Note: Deleting a shared company does not delete the company, just the association between the company and the parent company. |