Z Files

When you prepare to import external operations data into the JD Edwards EnterpriseOne Blend Management system, you first convert the flat file into a JD Edwards EnterpriseOne table for unedited inbound data (Z file) using the Inbound Flat File Conversion program (R47002C). Running this process populates the following tables:

  • Operations Transaction File (F31B65Z1)

  • Operations Composition Transaction File (F31B31Z1)

  • Operations Style Transaction File (F31B34Z1)

  • Operations Cost Transaction File (F31B3CZ1)

  • Operations Equipment Transaction File (F31B52Z1)

  • Operations Consumables Transaction file (F31B53Z1)

  • Work Order Transaction File (F31B93Z1)

  • Operations Resource Transaction File (F31B97Z1)

  • Operations Quality Test Transaction File (F31BQAZ1)

  • Sample Transactions (F31BSPZ1)

  • Operation EUR Transaction File (F31B17Z1)

  • VBT Barrel Transaction File (F31B18Z1)

  • Instructed Attributes Transaction File (F31B19Z1)

  • Weigh Tag Detail Transaction File (F31B85Z1)

Note: When you import multiple dependent operations in a work order, ensure that the operation reference numbers are in the appropriate sequence. The system uses the operation reference numbers to sequence operations in the Operation Transaction table during processing.

To process Z files into the JD Edwards EnterpriseOne Blend Management system, the system uses specific transaction process types for every type of record that you import. You configure a version of the Inbound Flat File Conversion program (R47002C) for each type of record by entering the corresponding transaction process type in the processing options. The following table lists the transaction process types and the corresponding information sets:

Transaction Process Type

Description

JDEWCN

Consumable

JDEWCO

Composition

JDEWCST

Cost

JDEWEQ

Equipment

JDEWEUR

Multiple EUR

JDEWINS

Instructed attributes

JDEWOP

Blend operation

JDEWQA

Quality

JDEWSPL

WIM Samples

JDEWRS

Resource

JDEWST

Style

JDEWVBT

VBT transaction

JDEWWO

Blend work order

JDEWWTD

WIM Weigh Tag Details

Note: Interoperability does not support spirit operations. The Z files do not include temperature fields.