Staged Departments

This forms is used to hold the temporary master data before being written to the real master tables in factory Track. When the synchronization process is initiated, the master data is extracted from the ERP system and written to the staging tables for departments. An individual staging record is created for every master data record extracted. For example, if 20 departments are extracted, 20 staged department records are created. The defaults (set up in the Data Synchronization Default forms) are then applied to the staging tables, updating the staging record with information required in Factory Track, and is not available in the native ERP system. The Department Staging form can then be used to alter values on the Staging records before being uploaded to the Master Files in Factory Track.

The form initially shows the base data from the ERP system along with a status of Downloaded. When the defaults are applied the values on the Department Staging form are updated with the defaults and the status changed to Defaults Applied. At this stage, this form can be used to manually change certain fields if necessary. Consequently, the batch is posted to Factory Track and the status is changed to Posted. After this action is updated, no changes can be made to the staging records (for departments).

These fields display the staged record of the form:

  • Batch Number
  • Department
  • Description
  • Post Status
  • Posted
  • Master Record Exists
  • Posted Date/Time
  • Error Code
  • Updated By

For more information on the above fields see, Configuring Department Parameters.

Parent topic: Forms