Item Costs from Inbound Transactions

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

The interoperability interface table for item cost inbound transactions is Unedited Transaction Table - Item Cost (F4105Z1).

The related application table for item cost inbound transactions is Item Cost File (F4105).

For the F4105Z1 table, interoperability requires data in these fields:

• EDI User ID (EDUS).

• EDI Batch Number (EDBT).

• EDI Transaction Number (EDTN).

• EDI Line Number (EDLN).

• Short Item Number (ITM), Second Item Number (LITM), or Third Item Number (AITM).

• Branch/Plant (MCU), if level 2 or 3.

• Location (LOCN), if used and if level 3 is used.

• Lot Number (LOTN), if used and if level 3 is used.

• Cost Method (LEDG).

• Unit Cost (UNCS).

• Directional Indicator of "1" for Inbound Processing (DRIN).

• Transaction Action UDC code (TNAC).

  The first letter of the 2nd Description must be A, C, D. Only Add, Change, and Delete are supported.

• Costing Selection - Purchasing (CSPO), Costing Selection - Inventory (CSIN), or both fields when:

  • Adding a new record with a CSPO and CSIN.

  • Changing an existing record with CSPO and CSIN.

During processing, the Item Cost Inbound Transaction Process program (R4105Z1I) adds, changes, or deletes multiple records that exist within the Unedited Transaction Table - Item Cost table (F4105Z1) directly to the F4105 table. Additionally, the costing selection methods for sales, inventory, and purchasing can be added or changed during processing.