1

Global Integration Suite transfers transformed Composites / Rest of World data from S/4, and performs some formatting, and sends the data to Maestro. 

2

China Integration Suite transfers transformed China data from S/4, and performs some formatting, and sends the data to Maestro. 

3

Transferred files will be sent to Maestro’s Client SFTP server. This sits outside of the Maestro firewall and is accessible by client using a user id/ password. Files are transferred from this component to the Planning Server SFTP by a Kinaxis automatic process once the trigger file has been placed (see below)

4

Files are moved to this SFTP server automatically, where they await loading into Maestro.

5

Maestro uses the configured DSM (Data Sources and Mapping) setup to load the data into the IndependentDemand table, with the load initiated either manually or through a scheduled system task.

6 

The Data Tables which store information in Maestro

0

Control Set

Status.ControlSet.Value

FixedValue

N

Fixed

N

 The control set associated with this record

1

Line

Line

String

Y

ExtractField

Default

A unique identifier associated with each IndependentDemand record with the same Order.Id

2

Order Id

Order.Id

String

Y

ExtractField

Y

A value that identifies an order number for an IndependentDemand record

3

Order Site

Order.Site.Value

String

Y

ExtractField

N

The site this demand order relates to.

3

Batch Site

Batch.Part.Site.Value

String

N

ExtractField

N

The site associated with this part. This field is a reference to the Value field on the Site table.

3

Part Site

Part.Site.Value

String

N

ExtractField

N

The site associated with this part. This field is a reference to the Value field on the Site table.

4

Order Type

Order.Type.Value

String

Y

ExtractField

N

A value that determines the processing policies of demand.

5

Customer Id

Order.Customer.Id

String

N

ExtractField

N

A value that identifies the customer.

6

Batch Part

Batch.Part.Name

String

N

ExtractField

N

The part that belongs to this batch record.

6

Part

Part,Name

String

N

ExtractField

N

Part number or item number.

7

Unit Selling Price

UnitSellingPrice

Money

N

ExtractField

Default

The unit price for this line item.

8

Due Date

DueDate

Date

N

ExtractField

Default

The date the order is scheduled to be completed to stock.

9

Request Date

RequestDate

Date

N

ExtractField

Default

The date by which the order would need to be completed to stock in order to ensure it can be shipped in time to meet the customer's requested date.

10

Quantity

Quantity

Quantity

N

ExtractField

Default

The amount still to be delivered.

11

Shipped Quantity

ShippedQuantity

Quantity

N

ExtractField

Default

The quantity that has already been shipped.

12

Status

Status.Value

String

N

ExtractField

N

A value for this type of DemandStatus.

13

Customer Request Date

CustomerRequestDate

Date

N

ExtractField

Default

The date on which the customer wants to receive delivery of the order at their location.

14

Batch

Batch.Id

String

N

ExtractField

Y

The identifier for this batch record.

15

Order Prioirty

Order.Priority.Value

String

N

ExtractField

N

16

Saved Priority

SavedPriority.Value

String

N

ExtractField

N

Field name

Description

Data type

Key

RevenueRecognitionDate

Calculated field

Date

N

Data Load Successful

Data File contains 0 records

The Data Update should fail with a status of Pending. 

Data File contains invalid references (or other error)

The Data Update should Fail, the invalid references should be visible in the error log and the records with the error are not loaded into Maestro, and an alert is sent to the Admin team <Or whatever action is needed>

Fields for IndependentDemand.tab which should be checked for invalid references are shown in the Data Structure table above as "Ref String" and are: 

Data file contains duplicates

The IndependentDemand.tab file must be checked further for data uniqueness with respect to the key fields, in case data is available in file but not in Maestro