StoreFront Initialization Program (SMU960) field descriptions

Use these fields to initially upload their FACTS items to the eCatalog database.

1. Key Code

The program prompts you for a Key Code. You can select One or All. For an initial load, select "All", and the program creates records in the eCatalog log file for all key codes that are flagged to get catalog updates. If a key code is added at some later time, you can run this program for just that one key code and the item data will be collected for the upload.  

Use the check boxes for each of the different types of requests for data that come from eCatalog. All check boxes are initially set to selected. For the initial load FACTS items to the eCatalog database, leave all check boxes selected. This is how it should be run for an initial load. To refresh data that has been previously sent to eCatalog or begin to send substitute items, select and un-select the individual check box settings independently for data upload.

In the Code Information section you can select to upload this information.

2. GL Posting Table

Indicates you want to upload GL Posting table information for FACTS items to the eCatalog database.

3. Item Class

Indicates you want to upload item class information for FACTS items to the eCatalog database.

4. Item Price Class

Indicates you want to upload item price class information for FACTS items to the eCatalog database.

5. User-defined Codes

Indicates you want to upload user-defined codes information for FACTS items to the eCatalog database.

In the Item Information section you can select to upload this information.

6. Item Master

Indicates you want to upload information located in the FACTS Item Master table to the eCatalog database.

7. Warehouse Item

Indicates you want to upload information located in the FACTS Warehouse Item table to the eCatalog database.

8. Customer Item

Indicates you want to upload customer item information to the eCatalog database.

9. Substitute Item

Indicates you want to upload substitute item information to the eCatalog database.

10. Companion Item

Indicates you want to upload companion item information to the eCatalog database.

In the eStorefront Information section you can select to upload this information.

Note: Even though the data files for country codes and state codes are not company specific in FACTS, when this initialization program is run for these codes, the company that is running the program IS put into the company field of the SMCATL data table. When "Companies" is selected, only a record for the company running the initialization program will be created.

11. Country Codes

Indicates you want to upload country code information for use in eStorefront initialization.

12. State Codes

Indicates you want to upload state code information for use in eStorefront initialization.

13. Companies

Indicates you want to upload FACTS company information for use in eStorefront initialization.

14. Warehouses

Indicates you want to upload FACTS Warehouse Master information for use in eStorefront initialization.

15. Payment Codes

Indicates you want to upload payment code information for use in eStorefront initialization.

16. Carrier Codes

Indicates you want to upload carrier code information for use in eStorefront initialization.

17.Ship Tos

Indicates you want to upload ship to location information for use in eStorefront initialization.

18. Corporate Groups

Indicates you want to upload corporate group information for use in eStorefront initialization.