MFG Data Archive Manual

Download PDF version here.

2.Installation #

The installation process for all WilloWare products is identical.  Please review the general installation instructions at www.willoware.com/install.

3.Registration #

Registration

Please see Registration Information here:

//willoware.com/online/registration-window/

WilloWare will provide a time-limited trial Registration Key for testing MFG Data Archive with live data. Testing should only be done in a test environment (a separate, stand-alone server) with a duplicate of the live data.

If MFG Data Archive is installed into a LIVE environment with a trial key, and the key expires, the product will no longer function, which will remove important controls from the live company that prevent duplication of data. Do not attempt to archive Manufacturing data if the key expires. Do not continue to use the archive company—it should be deleted immediately.

 

4.Security #

Security

The Installation routine will automatically create a Security Task called MFGDATARC, and a Security Role called MFGDATARC.

The Task will have access to all windows in MFG Data Archive, and the Task will be assigned to the Role.

To give a user access to MFG Data Archive you can either assign the Task to an existing Role, or assign the new MFGDATARC Role to a user.

Do NOT modify the MFGDATARC Security Task. Each time an update is installed for MFG Data Archive, it will recreate the Task so it has access to everything in the suite, and any changes will be lost.

Regular manufacturing users do NOT need security access to anything in MFG Data Archive. The controls that prevent duplication of records will be active regardless of security.

5.About #

The About Window for all WilloWare products is identical.  Open the About Window by going to Help >> About Microsoft Dynamics GP.  From that window select Additional >> About {WilloWare Product/Customization}.

{WilloWare Product/Customization} = the installed product, such as GP PowerPack or LabelLink.

Please refer to the general About Window guide here: www.willoware.com/online/about-window

6.Help Button #

Help Button

Every WilloWare window has a special Help Button:

The button provides access to several different forms of help documentation. The PDF Manual and Local Help (CHM File) are installed with the product and can be found in the Dynamics GP “Documentation” folder. Since these files are installed along with the product, they are only updated when/if a new version of the WilloWare product is installed. The Web Manual and Web About This Window options both access an online version of the documentation from the WilloWare website. The web manual is updated as changes occur to the product or to add additional information, so it is the most current, correct and complete version of the documentation.

PDF Manual: Opens the PDF manual.

Local Help: Opens context sensitive help (CHM) to display information about the current window.

Web Manual: Opens the product documentation as a web-page on the WilloWare website.

Web About This Window: Opens a page of the online documentation from the WilloWare website pertaining to the current window. The “HelpID” located just below the Chapter Heading throughout the documentation is used by the software to locate the correct web-page on the WilloWare website.

7.Overview #

Overview

MFG Data Archive moves data for completed manufacturing orders out of a live company database into an archive company database. This frees space in the live company, improving performance and making it easier to manage backups.

The first step is to create the archive company. This can be done manually by using GP Utilities to create a new, empty, company, or with the included Archive Utility that creates an archive company from a backup of the live company. The advantage of the second approach is the archive company will already have a copy of master records like Item Numbers and Sites.

If you have already installed Company Data Archive from Professional Advantage, and created an Archive Company, MFG Data Archive will use the existing Archive Company.

NOTE: MFG Data Archive archives the manufacturing data only. Use of Company Data Archive from Professional Advantage will allow archiving of other data that may be important to manufacturing, such as Item Numbers and Inventory Transactions. See www.ProfAd.com for more information. MFG Data Archive must be used together with Company Data Archive.

 

MFG Data Archive integrates with the GP Manufacturing Remove Manufacturing Orders utility. When Remove Manufacturing Orders is run, MFG Data Archive will automatically move the deleted data into the archive company.

MFG Data Archive also has its own Archive Manufacturing Data window which allows setting the utility to run for a set period of time, after which it will stop automatically.

MFG Data Archive integrates with the GP Manufacturing Remove Archived BOMs utility. When Remove Archived BOMs is run the MFG Data Archive will automatically move the deleted BOMs into the archive company.

Inquiries and reports on historical data can be run from the archive company.

8.Setup #

Setup

HelpID: 589922007

Navigation: Tools >> Setup >> Manufacturing >> MFG Data Archive Setup

Use this window to specify the Archive Company database, and to enable/disable MFG Data Archive. Enabled MFG Data Archive is a company-specific setting. If you have multiple live companies, each company can have its own Archive.

If you have not already created an Archive Company per the Professional Advantage instructions, follow the Create Archive Utility instructions below.

Enable Mfg Data Archive: mark this box to enable the archive for the current company database. You must have first created the Archive company database and specified the database name in the Archive Company Database field.

Archive Company Database: If you are using Company Data Archive (CDA) from Professional Advantage, select the Company ID you created as an archive for CDA. NOTE: the archive company must already have manufacturing installed and must be at exactly the same version level as the live company. If the CDA archive company was created without manufacturing installed, contact Microsoft Professional Services for instructions and support on adding Manufacturing to an existing company.

Utilities button: The Setup Utilities allow you to manually perform some database preparation activities that would normally be performed automatically when using the Create Archive Utility. If you manually created an archive database, see the instructions below for Setup Utilities.

Create Archive button: Opens the Create Archive Utility. See instructions below.

Click SAVE to store the settings.

Creating an Archive Company

If you do not have an archive company, there are two options:

  1. Create a new, empty company using GP Utilities. See the Dynamics GP Installation.pdf document for instructions.
  2. Use the Create Archive Utility included with MFG Data Archive. This method creates the archive by copying the live company, then it removes data from tables that will be covered by the archive. See instructions below for Create Archive Utility.

8.1.Creating an Archive Company #

Creating an Archive Company

If you do not have an archive company, there are two options:

  1. Create a new, empty company using GP Utilities. See the Dynamics GP Installation.pdf document for instructions.
  2. Use the Create Archive Utility included with MFG Data Archive. This method creates the archive by copying the live company, then it removes data from tables that will be covered by the archive. See instructions below for Create Archive Utility.

 

8.2.Create Archive Utility #

Create Archive Utility

HelpID: 589922023

To run this utility, you must be logged in as SA.

The Archive Utility will create an archive company by creating an empty database, making a backup of the live database, then restoring the backup of live into the archive database. The final step removes all data in the archive database from tables that will be populated by the archive.

It also removes SQL table triggers from archive tables. SQL Triggers can interfere with the archiving process. This approach to creating an archive database can be faster than creating a new, empty company using GP Utilities.

Database Name: this will default to the current company. You must be logged-in to the live company for which you want to create an archive.

Company Name: name of the current company.

Save Backup To: this will default to the Backup path specified on the SQL server. If it is blank, enter the path to a folder where the backup can be stored. Make sure the backup location has enough free space to store the backup file.

Archive Database Name: provide a 5-character database name for the archive company.

Archive Company Name: provide a company name. This must be different than the company name for any other GP company.

Data File Location: this will default to the data file location specified on the SQL server. Only change this if instructed to do so by the database administrator. Changing the database location later is extremely difficult to do.

Have all users out of the live company before proceeding.

Click Create Archive Company.

NOTE: this process may run for many a long time depending on the size of your company database. GP may appear to be “Not Responding”. Do not force GP to close during this process.

 

8.3.Setup Utilities #

Setup Utilities

HelpID: 589922007

WARNING: these utilities mass delete data. They should never be against a live company database. Make backups of your databases before running these utilities.

Clear Manufacturing Tables and Drop All Triggers run automatically when the archive database is created using our Create Archive Utility.

You must enter an Archive Database on the Setup window before you can open the Utilities window.

The system will check whether data already exists in the Manufacturing tables. If it does, it must be cleared before using Mfg Data Archive or the archival process will generate errors.

If you manually created an archive database by restoring a backup of live, all utilities should be run before starting to use Mfg Data Archive and Company Data Archive.

Clear Manufacturing Tables: this process removes all manufacturing transaction data from the archive database.

Clear CDA Tables: (OPTIONAL): Only use this utility if you will be using Company Data Archive (CDA) from Professional Advantage. This utility removes all Dynamics GP transaction data for transactions covered by CDA. DO NOT run this if you have been using Company Data Archive and already have archived data.

Drop All Triggers: Dynamics GP databases have SQL table triggers that help keep different tables in-sync. When the archive software adds records to the archive database these triggers can execute, resulting in errors. Since Dynamics GP will not be used to create new transactions in the archive company, or to add, remove, or update master records, these triggers serve no purpose and must be dropped.

 

9.Using MFG Data Archive #

Using MFG Data Archive

Manufacturing data can be archived using two different methods:

  • Using the “Remove MO” utility provided by GP Manufacturing. MFG Data Archive integrates into Manufacturing’s Remove MO window, and as that window deletes an MO it is captured by MFG Data Archive and moved into the archive database. This utility allows archiving single MOs, or a range of MOs. It is slow because it processes one MO at a time.
  • Using the “Archive Processor” utility provided by MFG Data Archive. This utility archives all MOs prior to a specified date. It does not provide a way to select specific MOs or a range of MOs. This utility is much faster because it processes the entire batch of MOs as a group.

The process of using each utility is described below.

To move data from the live company into the archive company your GP User ID must have full read/write permissions on the archive database.

 

9.1.Remove MO Utility #

Remove MO Utility

Navigation: Tools >> Utilities >> Manufacturing >> Remove MO

This window is part of GP Manufacturing. When MFG Data Archive is enabled, the title bar of the window will show <<MFG Data Archive ENABLED>>. If you do not see that MFG Data Archive is enabled, do NOT use this window.

Refer to the Manufacturing Online Help for information about how to use the Remove Manufacturing Orders window.

Begin by selecting an MO, or range of MOs using the From/To selections at the top of the window. Archiving MOs can take a long time, so start by selecting a small number of MOs so that it can complete the process and you can gauge how long it will take to archive a certain number of MOs. Based on the time it takes to process a small number of MOs (such as 10 or 100), you can calculate how long it will take to process a larger number.

You must mark to include Canceled and/or Close Orders and set a Last Change Date. The Change Date column is in the Work Order Master table (WO010032). You can then open the Restrictions window to see which MOs are included, and to manually mark/unmark manufacturing orders.

NOTE: the Remove MO process will only remove (and archive) MOs that are Canceled and/or Closed, and which meet a number of other checks to ensure they can be removed/archived. An MO can be included in the selection range, and appear as Marked in the Restrictions window, and still not be removed/archived.

After making selections, click the PROCESS button.

MFG Data Archive will take a “pre” snapshot to record statistics on the manufacturing tables.

Then the Manufacturing Order(s) will be archived. The process finishes by taking a “post” snapshot of table statistics.

Lastly, the MDA History window will open automatically. See the MDA History chapter later in this manual.

 

9.2.Archive Processor Utility #

Archive Processor Utility

HelpID: 589922006

Navigation: Tools >> Utilities >> Manufacturing >> Archive Processor

The Archive Processor is part of MFD Data Archive. In contrast to the Remove MO Utility, which processes MOs one at a time moving table by table, this utility processes a batch of MOs at once moving table by table. The Archive Processor is a much faster method when a large number of MOs need to be archived.

Set the archiving Start/Stop Date/Time. Be sure to allow the utility enough time to run. If you start the processor and the Stop Time is already in the past, it will take a start/stop snapshot of the table statistics, but nothing will be archived.

Once it starts archiving a table, the utility will complete a table regardless of the Stop Date/Time. In other words, if it is scheduled to stop at 7am, but it starts a large table shortly before that time, it may run significantly past the Stop Time.

Do not terminate the Archive Processor by forcing GP to close. This may result in corrupt or lost data.

Enter the MO Change Date cut-off. Change Date is found in the Work Order Master (WO010032). Records will be selected for Archiving that are Completed or Canceled, and have a Change Date on or before the date you enter.

Before attempting to archive a large number of MOs, select an early MO Change Date Cut-off that results in a “small” number of MOs. Perform several runs on progressively larger amounts of data until you can calculate a “typical” run time give the size of your database.

Click START.

The Archive MO window starts a timer. It can take up to 1-minute for the timer to makes its first pass at starting the archiving process, so even if the Start Date/Time is “now”, or already in the past, the utility may not start immediately. The window will display “Please wait” until it is ready to begin.

Once the timer has started it will calculate how much time remains until the archiving process starts. The status message at the bottom of the window will count down each minute until the process starts.

CANCEL: Click the Cancel button to stop the process at any time (before archiving as started, or while archiving is running). If archiving has already started, it will finish the current manufacturing table, then stop. Note that when moving a large amount of data it may take some time to complete that step before it can stop. DO NOT TERMINATE DYNAMICS GP PRIOR TO A STEP COMPLETING.

Closing the Archive MO window will also cancel the timer and cancel the archiving process at the next available step.

When the Stop Archiving Date/Time is reached, archiving will stop once it completes the current step. A second statistics snapshot will be taken, and the MDA History window will open (see section MDA History).

 

9.3.Remove BOM Utility #

Remove Bills Of Material

Navigation: Tools >> Utilities >> Manufacturing >> Remove Archived BOMs

This window is part of GP Manufacturing.

Refer to the Manufacturing Help for information about how to use the Remove Archived BOMs window.

When MFG Data Archive is enabled the Title Bar of the Remove Archived BOMs window will display: <<MFG Data Archive ENABLED>>.

MFG Data Archive integrates automatically with Remove Archived BOMs and will archive any records that are selected for removal. The entire BOM record will then be available in the archive company.

MFG Data Archive will take a snapshot of the manufacturing table statistics before and after the archival process, then display the results in the MFG Data Archive History window.

Archive Controls

MFG Data Archive adds controls to prevent re-use of archived document numbers. The following document numbers are controlled:

  • Manufacturing Order Entry – Manufacture Order Number
  • Component Transaction Entry – Pick Number
  • Manufacturing Order Receipt Entry – Receipt Number

Mfg Data Archive will ensure that when manufacturing documents are moved to the archive database, those document numbers cannot be re-used in the live environment.

Mfg Data Archive must be registered (have a valid, un-expired registration key) for these controls to be active.

 

9.4.Archive Controls #

Archive Controls

MFG Data Archive adds controls to prevent re-use of archived document numbers. The following document numbers are controlled:

  • Manufacturing Order Entry – Manufacture Order Number
  • Component Transaction Entry – Pick Number
  • Manufacturing Order Receipt Entry – Receipt Number

Mfg Data Archive will ensure that when manufacturing documents are moved to the archive database, those document numbers cannot be re-used in the live environment.

Mfg Data Archive must be registered (have a valid, un-expired registration key) for these controls to be active.

10.MDA History #

MDA History

HelpID: 589922015

Navigation: Tools >> Utilities >> Manufacturing >> MFG Data Archive History

The MDA History window shows the before and after statistics snapshots created when the archive utility runs. This is especially useful when beginning to use MFD Data Archive and need to plan how long it will take to archive certain amounts of data.

The MDA History window opens automatically after archiving MOs or Archived BOMs.

Field Description
Archive Select an archive from the dropdown list.
Show ALL – Displays all tables in the snapshot

Changed – Displays only those where the record count changed.

Display In Changes the unit of measure for the data fields. Options are:

  • Kilobytes
  • Megabytes
  • Gigabytes
Start Date/Time

End Date/Time

When the Remove MO or Remove Archive BOM process starts, MFG Data Archive records the Start Date/Time. When the process completes it records the End Date/Time.
Elapsed Min (or Hrs) Depending on how much time has elapsed, this field will display the elapsed time in minutes or hours. If the process runs for more than 1-day the elapsed time will be in hours.
kB per Min The volume of data moved per unit of time. The field is calculated using the elapsed min/hrs and the Display In setting (kB, MB or GB).
MOs Moved Displays the total number of MOs moved.
MOs per Min Displays the calculated number of MOs moved per min/hr. The min/hr setting depends on the Elapsed time reading.
Rows Displays the total number of rows of data removed from all tables during the archive.
Data Displays the total number of (kB, MB, GB) recovered by removing data from tables during the archive.
Index Display the total number of (kB, MB, GB) recovered by removing data from indexes during the archive.
Total Displays the total amount of disk space recovered in the Company Database from archiving data.

11.MFG Data Inquiry #

MFG Data Inquiry

HelpID: 589922013

Navigation: Tools >> Utilities >> Manufacturing >> MFG Data Inquiry

MFG Data Inquiry provides a set of database health and volume analysis tools to help you monitor the status of the manufacturing system.

Report: Data Size / View: Tables

This report (shown above) lists all of the manufacturing tables covered by MFG Data Archive. It shows the number of rows in each table, and the amount of space required for data storage and for the indexes.

A SQL Index can be thought of like a table of contents. It summarizes the details, and provides pointers (page numbers) to get you quickly to the information you need. A database table can have multiple indexes which provide different methods of summarizing the data, and each index takes up additional space in the database (just like additional tables of contents would require additional pages in a book).

Removing manufacturing orders reduces both the data size and the index size.

The window is sortable by clicking on the column headers.

Report: Data Size / View: Statistics

The Statistics report provides several different measurements to help you track and monitor the size and growth rate of the manufacturing data. This information is helpful for planning archiving frequency.

Field Description
Total MOs Total count of manufacturing orders in the Work Order Master (WO010032).
Total Data Rows Total row count from all tables covered by the archive. There are manufacturing tables which are not archived (such as QA Test setup, Item Engineering, and Routings) that are not included.
Data The total amount of disk space required for the manufacturing data.
Indexes Total amount of disk space required for manufacturing table indexes. See the previous section for a discussion of Indexes.
Total on Disk Total of Data plus Indexes.
Est. Per MO Total on Disk / Total MOs.
Date First MO Earliest Start Date on an MO in the Work Order Master (WO010032).
MO/month Last Mo. Total MO’s with a Start Date in the prior month.
MO/month YTD Total MO’s with a Start Date in the current year, divided by the number of months up to the current date.
MO/month R12 Total MO’s during the last 12-months, divided by 12.
MO/month All Total MO’s in system, divided by number of months between earliest MO and the current date.
Growth per month (Est. Per MO) * (MO/month R12)
Next GB in Days Uses the Growth per month to estimate how long (in days) it will take to add a gigabyte of manufacturing data.

The small listview window showing Years and kBData uses the Est. Per MO to gauge how much manufacturing data was added during each year.

Report: Fragmentation

Index fragmentation can have a significant adverse effect on performance. An index can be thought of like a table of contents in a book. It is a summary of the data in the book, with pointers (page numbers) to help you quickly locate what you are looking for. An index, like a table of contents, takes up space.

An index, like a table of contents, can use different methods to order the list, such as by Chapter or by Topic (such as a Glossary in a book). Each different method of summarizing and sorting the data is a different index and takes up additional disk space.

A fragmented index means that the data is not located contiguously on the hard-drive, so when SQL Server needs to locate information it needs to skip around on the drive to find it. The extra time required by this skipping can dramatically slow the time it takes Lookups to fill or reports to run.

The Fragmentation report shows the percent of fragmentation in each index for the tables covered by the archive. Under 20% is good, over 40% is bad. The Red/Yellow/Green dots correlated to those percentages.

If you have a high amount of fragmentation, consult with you Dynamics GP reseller regarding database maintenance to rebuild the indexes. Rebuilding indexes should be part of a scheduled maintenance routine on the SQL server.

12.Archived Tables #

Archived Tables

Display Name Technical Name Physical Name
CRP Line Item CRP_Line CP010100
CRP_Parallel CRP_Parallel CPSP0200
Critical Path Working File CRP_Critical_Path CPSP0300
CRP_Critical_Path_WORK CRP_Critical_Path_WORK CPSP0400
ECM_Reject ECM_Reject EC030031
ECM_Exclude_Items ECM_Exclude_Items EC040131
ECM_Item_Line ECM_Item_Line EC050031
Manufacturing Series GL Line IC_GL_TRX_LINE_WORK ICGL0102
ivConfiguredStandardCosts ivConfiguredStandardCosts ICIV0324
ICJC_DataCollection_Link ICJC_DataCollection_Link ICJC5000
ICJC_MDataCollection_Link ICJC_MDataCollection_Link ICJC5001
ICONrol Sales Order Line IC_SOP_LINE_WORK IS010001
iconROL Sale Order Line History IC_SOP_LINE_HIST IS030001
Manufacturing Series Inventory Line IC_IV_TRX_WORK_LINE IVIC0101
Manufacturing Series Inventory Header IC_IV_TRX_WORK_HDR IVIC0200
MPS Schedule MF_SCHED MF010230
MPS Transaction Log MF_TRX_Log MF010430
MOP_JOB_LINK MOP_JOB_LINK MOJB0031
MOP_WIP_Stack MOP_WIP_Stack MOP1000
MOP WIP Stack MOP_WIP_Stack MOP1000Rebuild
MOP WIP Stack MOP_WIP_Stack_Work MOP1001
MOP_WIP_Costs MOP_WIP_Costs MOP1002
MOP_MOVar_HIST MOP_MOVar_HIST MOP1003
MOP_MO_Variance_Material_Hist MOP_MO_Variance_Material_Hist MOP1004
MOP WIP Variance MOP_WIP_Variance MOP1005
MOP_Item_MSTR_Qty_Var MOP_Item_MSTR_Qty_Var MOP1006
MOP_WIPCostChanges MOP_WIPCostChanges MOP1009
MOP WIP Labor and Machine MOP_WIP_Lab_Mach MOP1010
MOP_MO_Variance_Material_Hist_STD MOP_MO_Variance_Material_Hist_STD MOP1012
MOP_WIPOverrideHist MOP_WIPOverrideHist MOP1015
MOP WIP Receipt History MOP_WIP_Receipt_History MOP1016
Manufacture Order Lot Issue MOP_Pending_Serial_Lot MOP1020
Manufacture Order Activity MOP_Order_Activity MOP10213
Manufacture Order Locking MOPLockRecord MOP10223
Manufacture Order Pending Bin MOP_Pending_Nontracked_Bin MOP1025
Manufacture Order Pending Bin Trx MOP_Pending_Bin_TRX MOP1026
Manufacture Order Lot Issue MOP_Bin_Issue MOP1027
Manufacture Order Lot Issue MOP_Bin_Issue MOP1027Rebuild
Manufacutre Order Lot Issue MOP_Serial_Lot_Issue MOP1030
MOP Serial Lot Assign MOP_Serial_Lot_Assign MOP1040
MOP Nontracked Assign MOP_Nontracked_Assign MOP1041
MOP Serial Pre Entry MOP_Serial_Pre_Entry MOP1042
MOP_Serial_Lot_Links MOP_Serial_Lot_Links MOP1043
MOP Component Trx Serial Lot History MOP_Component_Trx_Serial_Lot_Hist MOP1050
MOP Component Trx Serial Lot History MOP_Component_Trx_Nontracked_Bin_Hist MOP1055
Manufacture Order Lot Issue HIST MOP_Pending_Serial_Lot_HIST MOP1090
Manufacture Order Lot Issue HIST MOP_Pending_Serial_Lot_HIST MOP1090Rebuild
Manufacture Order Pending Bin HIST MOP_Pending_Nontracked_Bin_HIST MOP1095
Manufacture Order Pending Bin HIST MOP_Pending_Nontracked_Bin_HIST MOP1095Rebuild
MOP_Receipt_MSTR MOP_Receipt_MSTR MOP1100
MOP_Receipt_Detail MOP_Receipt_Detail MOP1110
MOP_Receipt_Detail_Serial_Lot MOP_Receipt_Detail_Serial_Lot MOP1120
MOP_Receipt_Detail_Serial_Lot MOP_Receipt_Detail_Nontracked_Bin MOP1121
MOP_PickDoc_MSTR MOP_PickDoc_MSTR MOP1200
MOP_PickDoc_Line MOP_PickDoc_Line MOP1210
MOP_PickDoc_Line_WORK MOP_PickDoc_Line_WORK MOP1220
MOP_Picklist_Site_QTYS MOP_Picklist_Site_QTYS MOP1400
MOP_Picklist_Site_Bin_QTYS MOP_Picklist_Site_Bin_QTYS MOP1410
MOP_Backflushed_Costs MOP_Backflushed_Costs MOP1500
MOP_Backflushed_Costs MOP_Close_Backflush_Costs MOP1510
Manufacture Order Complete Close Work MOP_Complete_Close_Work MOP1600
MOP_Interim_Allocations MOP_Interim_Allocations MOP1700
MOP_Picklist_Reconcile_Report_MSTR MOP_Picklist_Reconcile_Report_MSTR MOP1800
MOP_Picklist_Reconcile_Report_Line MOP_Picklist_Reconcile_Report_Line MOP1810
MOP_Trx_Bin_WORK MOP_Trx_Bin_WORK MOP1900
MOP_Variances MOP_Variances MOP3000
MOP Inventory Transaction Detail History MOP_TRX_HIST_LINE_DTL MOP30301
MOP_Receipt_Labor_Costs_WORK MOP_Receipt_Labor_Costs_WORK MOPW100
MOP Receipt Detail Work MOP_Receipt_Detail_Work MOPW400
MOP Receipt TEMP WORK MOP_Receipt_TEMP_WORK MOPW500
MOP_Sched_Interface_Orders MOP_Sched_Interface_Orders MOS02000
OSRC_MOP_POP_Link_MSTR OSRC_MOP_POP_Link_MSTR OSRC1000
OSRC_MOP_POP_Link_Work OSRC_MOP_POP_Link_Work OSRC1010
OSRC_Suggested_PO_MSTR OSRC_Suggested_PO_MSTR OSRC1100
OSRC_Suggested_PO_Work OSRC_Suggested_PO_Work OSRC1110
OSRC_Suggested_Shipments_MSTR OSRC_Suggested_Shipments_MSTR OSRC1200
OSRC_Recorded_Shipments_MSTR OSRC_Recorded_Shipments_MSTR OSRC1300
OSRC_Additional_Costs_MSTR OSRC_Additional_Costs_MSTR OSRC1400
OSRC_Selected_Lot_Numbers_MSTR OSRC_Selected_Lot_Numbers_MSTR OSRC1500
OSRC Selected Serials MSTR OSRC_Selected_Serials_MSTR OSRC1600
Picklist File MOP_Item_MSTR PK010033
Picklist Sequence Master MOP_Picklist_Seq_MSTR PK01200
Picklist File for a single Finished Good MOP_Item_MSTR_Single PK020031
QA_In_Process_MSTR QA_In_Process_MSTR QA020032
QA_In_Process_Step_LINE QA_In_Process_Step_LINE QA020232
QA_In_Process_Measurement_LINE QA_In_Process_Measurement_LINE QA020332
QA_In_Process_RTSequence_LINE QA_In_Process_RTSequence_LINE QA021132
RebuildErrors RebuildErrors RebuildErrors
Routing Cycle Time routing_cycle_time RT010500
Data Collection MSTR Data_Collection_MSTR SF010014
Data Collection Line Items Data_Collection_Line SF010115
Data Collection Transaction Log Data_Collection_TRX_Log SF010200
Data_Collection_Material Data_Collection_Material SF010400
Automated Data Collection Input Records ADC_Input_Records SF010500
Automated Data Collection Records ADC_Records SF010501
Automated Data Collection Matched Records ADC_Matched_Records SF010502
DC_Labor_Batch_Entry_Dtl DC_Labor_Batch_Entry_Dtl SF010601
Manufacture Order Master MOP_Order_MSTR WO010032
MOP Historical Variance MFG_MOP_History WO010116
Manufacture Order History MOP_Oder_History WO010213
Manufacture Order Lot Issue MOP_Lot_Issue WO010302
Manufacture Order Lot Issue MOP_Lot_Issue WO010302Rebuild
Manufacture Order Lot/Serial Issue MOP_Lot_Serial WO010400
MOP_Close_WIP_Hist MOP_Close_WIP_Hist WO01050
Manufacture Order Serial Issue MOP_Serial_Issue WO010515
Manufacture Order Serial Issue MOP_Serial_Issue WO010515Rebuild
Manufacture Order Finished Serial Assign MOP_Serial_Assign WO010615
Manufacture Order Closing File MOP_Close WO010701
MOP_Close_WIP MOP_Close_WIP WO010702
Manufacture Order Finished Serial Assign Archive MOP_Serial_Assign_Archive WOA01060
MOP_Routing_Line MOP_Routing_Line WR010130
MOP_Routing_Security MOP_Routing_Security WRS10001
Bill Of Material Line File BOM_Line BM010115
BOM_Line_HIST BOM_Line_HIST BM010116
BOM Revision BOM_Revision BM010415
BOM_Revision_HIST BOM_Revisio_HIST BM010416

 

Help Guide Powered by Documentor
Suggest Edit