Click or drag to resize

Workcenter Sync

This option allows the Ultriva Workcenter master data to be in synch with the ERP Workcenter master data. The fields marked as bold are required. Required fields must always have non-empty data.

Workcenter Sync Flat File Field Definition

The following table defines the fields in Workcenter Data file. The fields marked as bold are required. Required fields must always have non-empty data.

Workcenter Master Data File (inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

PlantCode

STRING

32

Y

N

Plant Code where this new supplier or association should be made

WorkcenterCode

STRING

32

Y

N

Unique Workcenter Code to identify this supplier.

WorkcenterName

STRING

256

Y

N

Workcenter Name for this Workcenter.

Address1

STRING

64

Y

N

Address Line 1 for the supplier address

Address2

STRING

64

N

N

Address Line 2 for the supplier address

Address3

STRING

64

N

N

Address Line 3 for the supplier address

City

STRING

32

Y

N

City of this Supplier

State

STRING

32

Y

N

State

Zip

STRING

32

Y

N

Zip Code

Country

STRING

32

Y

N

Country

Pre-Processing

This interface uses following fields as uniqueness constraint.

Field Name

Mandatory Field

EBJ_BUSCODE

Yes

WorkcenterCode

Yes

WorkcenterName

Yes

  1. Given EBJ_BUSCODE must exist in the system.

Validation

Batch Job Processor validates each record with following validation before it starts processing the record.

  1. WorkcenterCode must be unique under the plant.

  2. All required fields must be present.

Processing Logic

The Batch Job Processor uses following logic to identify and update the vendor information.

  1. It uses the EBJ_BUSCODE to find the parent plant.

  2. It uses the WorkcenterCode to search for workcenters underneath the plant.

  3. If the workcenters being mentioned in the VendorCode are present then the workcenters' address is update. If the workcenters being mentioned in VendorCode are not present then the new workcenters are added.

  4. The workcenter inherits all the weekly holidays, time zones, label details, and Kanban formula from the parent.

Additional Flex Fields

NONE