B Appendix B - Z File Processing

This appendix contains this topic:

B.1 Import Data Using Z File Processing

The Z File processing consists of programs that wrap around the interactive programs, passing in parameters from the Z file records to run in batch mode. Z File uses existing Item Master and Item Branch creation processes in a batch mode to ensure that programs perform the same edits that they do in an online mode. Z file records are tied together by User ID, Batch Number, and Transaction Number.

Each wrapper program has a processing option in which you designate the version of the revisions program to be called. For example, you designate the version of P4101 to be called by P4101Z.

Note:

The version of the revisions program you attach to the version of the wrapper program (P4101Z or P4102Z) determines which programs are launched in batch mode.

Use the Item Master Revisions (P4101) and the Branch/Plant Item Information (P41026) processing options to determine which programs to launch automatically. For example, you can set up P4101Z to call a version of P4101 for which the processing option is set to call the Item Branch program. If the processing option for the item branch program is set to call the Cost Revisions screen, and the Z files are populated properly, when you run P4101Z, the system will create item master records, item branch records, and item branch cost records.

Note:

The programs Item Location Information (P41024Z), Unit of Measure Conversions (P41002Z), and Lot Master Revisions (P4108Z) must be run individually.

You have the option to write errors to a report via a processing option behind each of the wrapper programs. In case of errors, the program writes the errors to a file (F00BLOG) and proceeds to the next record in the Z file. In addition, you can populate the Z files for the item revisions processes using the PC Batch Import functionality. From the Import/Export menu (G00PCIE), choose option 3 to perform a Batch Import from CSV files.

JD Edwards World created wrapper programs to launch each of the existing item revisions programs in batch mode.

The following table lists the programs and Z files that add item information.

Note:

Some of the wrapper programs allow for changes and deletions to existing item information, while others allow for the addition of information only. Program helps for each wrapper program indicate which transactions you can perform.
Revisions Program Description Wrapper Program Z File
P4101 Item Master Information P4101Z F4101Z
P41011 Classification Codes P41011Z F4101ZA
P41012 Default Units of Measure P41012Z F4101ZB
P41013 Manufacturing Values P41013Z F4101ZC
P41018 Bulk Product Information P41018Z F41011Z
P41020 Item Master Information UCC 128 P41020Z F4101UZ
P4101A Lot Processing P4101AZ F4101ZD
P41026 Item Branch Information P41026Z F4102Z
P41025 Item Branch Class Codes P41025Z F4102Z1
P41022 Item Branch Quantities P41022Z F4102Z2
P41027 Plant Manufacturing Data P41027Z F4102Z3
P41029 Bulk Depot/Product Information P41029Z F41022Z
P4102A Item Branch Lot Information P4102AZ F4102Z4
P41024 Item Location Information P41024Z F41024HZ (header)

F41024DZ (detail)

P4105 Item Cost Revisions P4105Z F4105HZ (header)

F4105DZ (detail)

P4106 Base Price Revisions P4106Z F4106HZ (header)

F4106DZ (detail)

P41002 Unit of Measure - Item Conversions P41002Z F41002HZ (header)

F41002DZ (detail)

P4108 Lot Master Revisions P4108Z F4108Z

Navigation

From Inventory Management (G41), enter 27

From Inventory Advanced and Technical Operations (G4131), choose Item Master/Branch Z-File Processes

From Item Master/Branch Z-File Processes (G4101Z), choose an option

B.1.1 Technical Considerations

You use the following Z File programs to add data. You cannot change or delete data using these programs.

You use the following Z File programs to change data. You cannot add or delete data using these programs.

  • Item Master Classification Codes Z File (P41011Z)

  • Manufacturing Data - Z File (P41013Z)

  • Item Master Lot/SN Set Up - Z File (P4101AZ)

  • Default Units of Measure - Z File (P41020Z)

  • Item Master UCC - Z File (P41012Z)

  • Item Branch Revisions - Z File - Class Codes (P41025Z)

  • Item Branch Revisions - Z File - Manufacturing Data (P41027Z)

  • Item Branch Revisions - Z File - Lot (P4102AZ)

  • Item Branch Revisions - Z File - Quantities and Amounts (P41022Z)

Use the UOM Conversions - Z File program (P41002Z) to add and change data. You cannot delete UOM Conversion information using this program.

B.1.3 Data Selection

Do not change the existing data selection. The Processed Y/N field is set to NE Y. This prevents the program from processing records more than once.

You can add additional selections to limit the data.

B.1.4 Data Sequence

Do not change the data sequence.