Item Master Inbound Transactions

You might receive inbound transactions for the F4101 table if, for example, you are converting the inventory from a legacy system to JD Edwards EnterpriseOne Inventory Management.

The interoperability interface tables for item master inbound transactions are:

F4101 Item Master Unedited Transaction Table (F4101Z1).
F4101 Detail Item Master Unedited Transaction (F4101Z1A).
A F4101Z1 record must precede and be associated with a detail F4101Z1A record

The related application tables for item master inbound transactions are:

Item Master (F4101).
Item Branch File (F4102).
Bulk Item Master (F41011).
Bulk Depot/Product Information (F41022).
Item Master - Customer Service Extension (F4117).
Item Branch Master - Customer Service Extension (F41171).
Item Profile (F46010).
Item Shipping Information (F4908).

You run the Item Master Inbound Transaction Process program (R4101Z1I) to copy the information from the F4101Z1 and F4101Z1A tables to the related application tables.

The fields in the F4101Z1 table that must contain data for interoperability depend on whether the transaction is an add, a change, or a delete. This table identifies which fields must contain data for each type of transaction:

Transaction	Fields
Add (available for Item Master and Branch/Plant levels)	Fields that must contain data for an Add transaction at the Item Master level are: Short Item Number (ITM), Second Item Number (LITM), and Third Item Number (AITM), which must be a unique number. Stocking Type (STKT). G/L Class (GLPT). Description (DSC1). Transaction Action (TNAC) Direction Indicator (DRIN) Fields that must be populated for an Add transaction at the Branch/Plant level are: Short Item Number (ITM), Second Item Number (LITM), and Third Item Number (AITM), which must be a unique number. Cost Center (MCU). Transaction Action (TNAC) Direction Indicator (DRIN) Note: Specify 2 in the Update Item/Branch (ITBR) field for a branch transaction (for item transactions, the value in this field should be 1.). If you leave the ITBR field and the MCU field blank, the record is processed as an item transaction. If you leave the ITBR field blank and specify a branch/plant in the MCU field, the record is treated as a branch transaction.
Change (available for Item Master and Branch/Plant levels)	Fields that must contain data for a Change transaction are: Transaction Action (TNAC) Direction Indicator (DRIN) For a Change transaction, the record in the F4101Z1 table must contain data in all the fields that contain data in the application table, even if the data is the same.
Delete (available for Item Master and Branch/Plant levels)	Fields that must contain data for a Delete transaction are: Transaction Action (TNAC) Direction Indicator (DRIN) Additional fields that must contain data for a Delete transaction vary: A Delete transaction for the F4101 table requires that the Short Item Number (ITM) field contain data. A Delete transaction for F4102 requires that the Short Item Number (ITM) and Branch/Plant (MCU) fields contain data.

Transaction

Fields

Add (available for Item Master and Branch/Plant levels)

Fields that must contain data for an Add transaction at the Item Master level are:

Short Item Number (ITM), Second Item Number (LITM), and Third Item Number (AITM), which must be a unique number.
Stocking Type (STKT).
G/L Class (GLPT).
Description (DSC1).
Transaction Action (TNAC)
Direction Indicator (DRIN)

Fields that must be populated for an Add transaction at the Branch/Plant level are:

Short Item Number (ITM), Second Item Number (LITM), and Third Item Number (AITM), which must be a unique number.
Cost Center (MCU).
Transaction Action (TNAC)
Direction Indicator (DRIN)

Note: Specify 2 in the Update Item/Branch (ITBR) field for a branch transaction (for item transactions, the value in this field should be 1.). If you leave the ITBR field and the MCU field blank, the record is processed as an item transaction. If you leave the ITBR field blank and specify a branch/plant in the MCU field, the record is treated as a branch transaction.

Change (available for Item Master and Branch/Plant levels)

Fields that must contain data for a Change transaction are:

Transaction Action (TNAC)
Direction Indicator (DRIN)

For a Change transaction, the record in the F4101Z1 table must contain data in all the fields that contain data in the application table, even if the data is the same.

Delete (available for Item Master and Branch/Plant levels)

Fields that must contain data for a Delete transaction are:

Transaction Action (TNAC)
Direction Indicator (DRIN)

Additional fields that must contain data for a Delete transaction vary:

A Delete transaction for the F4101 table requires that the Short Item Number (ITM) field contain data.
A Delete transaction for F4102 requires that the Short Item Number (ITM) and Branch/Plant (MCU) fields contain data.