Skip to main content
Version: 1.6

Upload Excel template

Sequor Platforma Site

How to upload a Excel file (template)

Once you reach the Sync Files Sequor MTC App, you will find the grid mode, wich lists all the records of uploaded files. To upload a new Excel file (template), just click and then, select the target Excel file (template) to upload.

Sequor Platforma Site

In time you made your choice and open the file, the system will load the data and finish the process returning the new file uploaded. Just click to refresh the grid.

How to verify the status and import messages

Once you reach the Sync Files Sequor MTC App, you will find the grid mode, wich lists all the records of uploaded files. Just by one click, you can choose and detail each register to consult its upload process and error log (if appliable)

Sequor Platforma Site

note

To avoid errors while importing files, it is important to use exactly the same sheet and colum names as the template. Be sure to start the sheet header at Colun A Line 1.

Data Structure Excel file (template):

Material Header Data

Column nameTypeLengthscaleprecisionrequiredDescription of the fieldSample
BaseUnitMeasurenvarchartrueIs this the unit of measurement of the material entryKg
ExpirationDatedatetime28727true
GrossWeightdecimal9313true
Heightdecimal9313true
HeightUnitnvarchar4false
IsPRTbit11true
Lenghtdecimal9313true
LenghtUnitnvarchar4false
MaterialDescriptionnvarchar40true
MaterialLockedbit11true
MaterialNumbernvarchar18true
MaterialTypenvarchar4true
NetWeightdecimal9313true
Pricedecimal9211true
PriceUnitnvarchar4false
ValidFromDatedatetime28727true
Volumedecimal9313true
VolumeUnitnvarchar4false
WeightUnitnvarchar4false
Widthdecimal9313true
WidthUnitnvarchar4false

Equipment Header Data

Column nameTypeLengthscaleprecisionrequired
EquipmentCategoryCodenvarchar4false
EquipmentDescriptionnvarchar40false
EquipmentNumbernvarchar18true
IsPRTbit11true
Pricenumeric536false
PriceUnitnvarchar50false

Personnel Header Data

Column nameTypeLengthscaleprecisionrequired
Desactivatedbit12true
PersonnelDescriptionnvarchar40false
PersonnelLocationnvarchar-1false
PersonnelNumbernvarchar18true
Pricenumeric9313true
PriceUnitnvarchar30false

Order Header Data MTC

Column nameTypeLengthscaleprecisionrequired
BasicFinish Datedatetime28727true
BasicStartDatedatetime28727true
CancelDatedatetime28727true
CloseDatedatetime28727true
EquipmentNumber
ExternalOrderNumbernvarchar30false
FunctionalLocationnvarchar12false
GeneratePickingWMbit12true
MaterialNumber
NotificationCodenvarchar30false
OrderCategoryCodenvarchar4false
OrderDescriptionnvarchar40true
OrderNumbernvarchar30true
OrderPriorityint410true
OrderTypenvarchar4false
ParentOrderNumbernvarchar30false
PersonResponbileClientnvarchar18false
PersonResponbileClientPhonenvarchar20false
ReleaseDatedatetime28727true
RequestingCompanyCodenvarchar4false
RequestingCostCenternvarchar10false
RequestingOrderCodenvarchar30false
StopDatedatetime29727true
WorkCenterCodenvarchar30false
WorkEndDatedatetime28727true
WorkStartDatedatetime28727true

Order Operation TaskList Header MTC

Column nameTypeLengthscaleprecisionrequired
ActualWorkdecimal9313true
BasicFinishDatedatetime28727true
BasicStartDatedatetime28727true
FunctionalLocationnvarchar12false
NormalDurationActivitydecimal515true
OperationSequenceint410true
OperationShortTextnvarchar40false
OrderNumbernvarchar30true
Prioritynvarchar-1false
UnitNormalDurationnvarchar4false
UnitWorknvarchar4false
WorkCenternvarchar30false
WorkFactordecimal53true
WorkInvolvedActivitydecimal517true

Order Item Data

Column nameTypeLengthscaleprecisionrequired
MaterialNumbernvarchar18true
OperationSequenceint410true
OrderItemQuantitydecimal9313true
OrderNumbernvarchar30true
QuantityGoodsReceiveddecimal9313true
QuantityRepairdecimal9313true
QuantityScrapdecimal9313true
SurplusDeficitGoodsReceiptdecimal9313true

Order Personnel Data

ColumnTypeLengthscaleprecisionrequired
BaseUnitMeasurePersonnelnvarchar4false
BaseUnitMeasureTimenvarchar4false
ConsumptionPostingnvarchar14false
OperationSequenceint410true
OrderItemPersonnelQuantitydecimal9313true
OrderNumbernvarchar30true
PersonnelNumbernvarchar18true
PersonnelTimeQuantitydecimal9313true
PersonNumbernvarchar18false
QuantityPersonnelMissingdecimal9313true
QuantityTimeMissingdecimal9313true
SurplusDeficitTimeExtradecimal9313true
SurplusDeficitTimeNormaldecimal9313true
TimeExtraTypeCodenvarchar4false

Unit Measurement

Column nameTypeLengthscaleprecisionrequired
UnitMeasurementCategoryCodenvarchar2false
UnitMeasurementCodenvarchar4true
UnitMeasurementDescriptionnvarchar10false

Work Center Header Data

Column nameTypeLengthscaleprecisionrequired
AdditionalPercentageSetupdecimal513false
AdditionalTimePercentageMachinesdecimal513false
AditionalTimePercentageLabordecimal513false
Backflushingbit11false
CalculationActualCapacityRequirementsbit11false
Capacity Codedecimal58false
DimensionWorknvarchar6false
FunctionalLocationnvarchar12false
ImportGroupCodenvarchar16false
ImportSubGroupCodenvarchar16false
LocationGroupnvarchar4false
MachineTypeCodenvarchar10false
MixingMaterialAllowedbit11false
NormalDurationUnitnvarchar4false
NumberConfirmationSlipsdecimal53false
NumberTimeTicketsdecimal53false
PersonResponsiblenvarchar18false
PrinterShopPapersnvarchar4false
NormalDurationUnitnvarchar4false
SameFormulasCapacitynvarchar1false
ShiftNoteTypeCodenvarchar2false
ShiftReportTypeCodenvarchar10false
StorageLocationStorageResourcenvarchar4false
UnitMeasureWorknvarchar4false
UnitStandardQueueTimenvarchar4false
WorkCenternvarchar30true
WorkCenterCategorynvarchar30false
WorkCenterDescriptionnvarchar40false
UnitStandardQueueTimebit11false
WorkCenterLockedMaintenancebit11false