Understanding Data Import Programs
JD Edwards EnterpriseOne Demand Flow Manufacturing provides a number of batch import programs that populate base data tables for JD Edwards EnterpriseOne Demand Flow Manufacturing from corresponding JD Edwards EnterpriseOne tables. In some cases, the information that is imported into JD Edwards EnterpriseOne Demand Flow Manufacturing is drawn from multiple JD Edwards EnterpriseOne tables. Running an import program deletes all the records in the JD Edwards EnterpriseOne Demand Flow Manufacturing tables based on scenario ID and updates the tables with the new records with the exception of the sales order import. The import programs also generate reports that list all the updated and newly added records, and print error messages for records that were not written to the JD Edwards EnterpriseOne Demand Flow Manufacturing table.
The following table lists the UBEs that are used to move data from JD Edwards EnterpriseOne tables to JD Edwards EnterpriseOne Demand Flow Manufacturing base data tables:
Import UBE |
From Table |
To Table |
|---|---|---|
DFM - Import Item Definitions (RF30L501I) |
Item Branch (F4102), Item Units of Measure Conversion Factors (F41002), Unit of Measure Standard Conversion (F41003) |
DFM Item Definition Master (FF30L501), DFM Item Units of Measure Conversion Factors (FF30L512), DFM Units of Measure Standard Conversions (FF30L513) |
Import Work Center Master Information (RF30L017I) |
Work Center Master (F30006) |
DFM Work Center Master (FF30L017) |
Import Branch/Plant Master Information (RF30L014I) |
Job Shop Manufacturing Constants (F3009), Inventory Constants (F41001), Business Unit Master (F0006) |
Branch/Plant Master (FF30L014) |
Import Bill of Material (RF30L002I) |
Bill of Material Master (F3002) |
DFM Bill of Material Master (FF30L002) |
Import Customer Information (RF30L301I) |
Customer Master by Line of Business (F03012), Address Book Master (F0101) |
DFM Customer Master (FF30L301) |
Import Supplier Information (RF30L401I) |
Supplier Master (F0401), Address Book Master (F0101) |
DFM Supplier Master (FF30L401) |
Import Employee Information (RF30L601I) |
Employee Master Information (F060116), Address Book Master (F0101) |
DFM Employee Master (FF30L601) |
DFM - Import Sales Orders (RF30L801I) |
Sales Order Header (F4201), Sales Order Detail (F4211) |
Sales Order Master (FF30L801) |
DFM Import Kanban Locations (RF31K42I) |
Location Master (F4100) |
DFM Kanban Location (FF31K42) |