Skip to content

Tables#

Generic Tables#

SMTTimeConstraintTracker#

Generic table used to store the time constraints for materials in SMT Lines

The following table describes the table columns:

Name Is Key Is Mandatory Data Type Reference Description
Material Yes Yes String <EntityType> Material Material with the time constraint
FromStep Yes Yes String <EntityType> Step Step in which the time constraint was created
FromOperation Yes Yes String <LookupValue> MaterialTimeConstraintFromOperations Operation in which the time constraint was created
ToStep Yes Yes String <EntityType> Step Step in which the time constraint will be validated
ToFlow No No String <EntityType> Flow Flow in which the time constraint will be validated
ToOperation Yes Yes String <LookupValue> MaterialTimeConstraintFromOperations Operation in which the time constraint will be validated
Type No Yes Integer <Enum> ConstraintType Type of constraint (minimum/maximum)
TimeLimitDate No Yes DateTime None Time constraint expiration date time
TimeLimitRule No No String <EntityType> Rule Rule to be called when expiration time is reached
WarningLimitDate No No DateTime None Time constraint warning date time
WarningLimitRule No No String <EntityType> Rule Rule to be called when the warning time is reached
SystemState No Yes Integer <Enum> TimeConstraintsTrackerSystemState The system state of the constraint

SMTMaterialBakingTable#

Used to establish the required Material baking hours for a given material.

Name Is Key Is Mandatory Data Type Reference Description
Order Yes Yes Integer None Represents the order of the required baking hours for a given context.
BakingOvenType Yes Yes String <LookupValue> SMTBakingOvenType Represents the baking oven type.
MaterialThickness Yes Yes String <LookupValue> SMTMaterialThickness Represents the Material thickness.
MoistureSensitivityLevel Yes Yes String <LookupValue> MoistureSensitivityLevel Represents the Material Moisture Sensitivity Level.
IsBGA Yes Yes Boolean None Indicates if the Material is BGA (Ball Grid Array).
IsFloorLifeExceededByMore
ThanSeventyTwoHours
Yes Yes Boolean None Indicates if the Material floor life has been exceeded by more than 72 hours.
RequiredBakingHours No Yes Decimal None Represents the Material required baking hours.

Lookup Tables#

CustomConvention#

Lookup table used to translate the mapping convention of the equipment board ID to the MES position ID (the submaterial ID). The values of this table are used by the SMTConventionContext smart table to determine when a given custom convention should be used.

SMTPanelForms#

Lookup table used to keep track of which material forms are used to represent panels.

SMTBoardForms#

Lookup table used to keep track of which material forms are used to represent boards.

SMTBakingOvenType#

Lookup table used to enumerate different specifications of baking ovens.

SMTMaterialThickness#

Lookup table used to select a thickness range for a component for the purpose of baking time calculations.

Smart Tables#

SMTCallExternalApplicationContext#

Smart table used to create a new IntegrationEntry on Material Operation given a specific context.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Product Yes No String <EntityType> Product Indicates the Product
ProductGroup Yes No String <EntityType> ProductGroup Indicates the ProductGroup
Flow Yes No String <EntityType> Flow Indicates the Flow
Step Yes No String <EntityType> Step Indicates the Step
Material Yes No String <EntityType> Material Indicates the Material
Operation Yes Yes Integer <Enum> CallExternalApplicationOperation Indicates which operation triggers the action
IntegrationEntryType No Yes String <SmartTable> Material Indicates the integration entry type
SourceSystem No Yes String <LookupValue> IntegrationSystem Indicates the source system
TargetSystem No Yes String <LookupValue> IntegrationSystem Indicates the target system
Precedence Keys
Order Precedence Keys
1 Product+ProductGroup+Flow+Step+Material+Operation
2 Product+ProductGroup+Flow+Step+Operation
3 Product+ProductGroup+Flow+Material+Operation
4 Product+ProductGroup+Flow+Operation
5 Product+ProductGroup+Step+Material+Operation
6 Product+ProductGroup+Step+Operation
7 Product+ProductGroup+Material+Operation
8 Product+ProductGroup+Operation
9 Product+Flow+Step+Material+Operation
10 Product+Flow+Step+Operation
11 Product+Flow+Material+Operation
12 Product+Flow+Operation
13 Product+Step+Material+Operation
14 Product+Step+Operation
15 Product+Material+Operation
16 Product+Operation
17 ProductGroup+Flow+Step+Material+Operation
18 ProductGroup+Flow+Step+Operation
19 ProductGroup+Flow+Material+Operation
20 ProductGroup+Flow+Operation
21 ProductGroup+Step+Material+Operation
22 ProductGroup+Step+Operation
23 ProductGroup+Material+Operation
24 ProductGroup+Operation
25 Flow+Step+Material+Operation
26 Flow+Step+Operation
27 Flow+Material+Operation
28 Flow+Operation
29 Step+Material+Operation
30 Step+Operation
31 Material+Operation

SMTConventionContext#

Smart table to resolve the Custom Convention per Step and Resource.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Resource Yes No String <EntityType> Resource Resource for the Custom Convention
Model Yes No String <LookupValue> ResourceModel Resource Model
Vendor Yes No String <LookupValue> ResourceVendor Resource Vendor
Step Yes No String <EntityType> Step Step for the Custom Convention
Convention No No String <LookupValue> CustomConvention Custom Convention
Precedence Keys
Order Precedence Keys
1 Resource+Step
2 Model+Step

SMTDataCollectionPostOperationContext#

Smart table used to resolve the Material Repair for the specific material context

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Product Yes No String <EntityType> Product Indicates the Product
ProductGroup Yes No String <EntityType> ProductGroup Indicates the ProductGroup
Flow Yes No String <EntityType> Flow Indicates the Flow
Step Yes No String <EntityType> Step Indicates the Step
Material Yes No String <EntityType> Material Indicates the Material
Resource Yes No String <EntityType> Resource Indicates the Resource
ResourceType Yes No String <LookupValue> ResourceType Indicates the ResourceType
Parameter Yes Yes String <EntityType> Parameter Indicates the Parameter
ParameterValue Yes Yes String None Indicates the Parameter Value
SampleNumber Yes Yes Integer None Indicates the DataCollection Sample Number
ReadingNumber Yes Yes Integer None Indicates the DataCollection Reading umber
Operation No Yes Integer <Enum> DataCollectionPostOperation Indicates the MES Operation to perform
LoadPortType No Yes String <LookupValue> ResourceType Indicates the LoadPort Resource ResourceType
ReworkReason No No String <EntityType> Reason Indicates the Rework Reason
Precedence Keys
Order Precedence Keys
1 Step+Flow+ProductGroup+Parameter+SampleNumber+ReadingNumber+ParameterValue
2 Step+Flow+Product+Parameter+SampleNumber+ReadingNumber+ParameterValue
3 Step+Flow+Material+Parameter+SampleNumber+ReadingNumber+ParameterValue
4 Step+Flow+Parameter+SampleNumber+ReadingNumber+ParameterValue
5 Step+ProductGroup+Parameter+SampleNumber+ReadingNumber+ParameterValue
6 Step+Product+Parameter+SampleNumber+ReadingNumber+ParameterValue
7 Step+Material+Parameter+SampleNumber+ReadingNumber+ParameterValue
8 Step+Resource+Parameter+SampleNumber+ReadingNumber+ParameterValue
9 Step+ResourceType+Parameter+SampleNumber+ReadingNumber+ParameterValue
10 Step+Parameter+SampleNumber+ReadingNumber+ParameterValue
11 Resource+Parameter+SampleNumber+ReadingNumber+ParameterValue
12 ResourceType+Parameter+SampleNumber+ReadingNumber+ParameterValue

SMTDefectActionContext#

Smart table used to resolve the Defect Action to be run for a specific material context

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Product Yes No String <EntityType> Product Indicates the Product to apply a given defect action
ProductGroup Yes No String <EntityType> ProductGroup Indicates the Product Group to apply a given defect action
MaterialType Yes No String <LookupValue> MaterialType Indicates the Material Type to apply a given defect action
Flow Yes No String <EntityType> Flow Indicates the Flow to apply a given defect action
Step Yes No String <EntityType> Step Indicates the Step to apply a given defect action
PartNumber Yes No String <EntityType> Product Indicates the Part Number to apply a given defect action
ReferenceDesignator Yes No String None Indicates the Reference Designator to apply a given defect action
MaterialDefect
SystemState
Yes No Integer <Enum> MaterialDefect
SystemState
Indicates the Material Defect System State where a given defect action is applicable
DefectReason Yes No String <EntityType> Reason Indicates the Defect Reason that should trigger a given defect action
DefectAction No Yes Integer <Enum> DefectActionType Indicates the Defect Action to apply accordingly the defined context
Precedence Keys
Order Precedence Keys
1 MaterialType+Flow+Step+DefectReason
2 MaterialType+Flow+Step
3 MaterialType+Step+DefectReason
4 MaterialType+Step
5 Product+Flow+Step+ReferenceDesignator+MaterialDefectSystemState+DefectReason
6 Product+Flow+Step+ReferenceDesignator+DefectReason
7 Product+Flow+Step+ReferenceDesignator+MaterialDefectSystemState
8 Product+Flow+Step+ReferenceDesignator
9 Product+Step+ReferenceDesignator+MaterialDefectSystemState+DefectReason
10 Product+Step+ReferenceDesignator+DefectReason
11 Product+Step+ReferenceDesignator+MaterialDefectSystemState
12 Product+Step+ReferenceDesignator
13 Product+ReferenceDesignator+MaterialDefectSystemState+DefectReason
14 Product+ReferenceDesignator+DefectReason
15 Product+ReferenceDesignator+MaterialDefectSystemState
16 Product+ReferenceDesignator
17 Product+Flow+Step+PartNumber+MaterialDefectSystemState+DefectReason
18 Product+Flow+Step+PartNumber+DefectReason
19 Product+Flow+Step+PartNumber+MaterialDefectSystemState
20 Product+Flow+Step+PartNumber
21 Product+Step+PartNumber+MaterialDefectSystemState+DefectReason
22 Product+Step+PartNumber+DefectReason
23 Product+Step+PartNumber+MaterialDefectSystemState
24 Product+Step+PartNumber
25 Product+PartNumber+MaterialDefectSystemState+DefectReason
26 Product+PartNumber+DefectReason
27 Product+PartNumber+MaterialDefectSystemState
28 Product+PartNumber
29 Product+Flow+Step+MaterialDefectSystemState+DefectReason
30 Product+Flow+Step+MaterialDefectSystemState
31 Product+Flow+Step+DefectReason
32 Product+Flow+Step
33 Product+MaterialDefectSystemState+DefectReason
34 Product+DefectReason
35 Product+MaterialDefectSystemState
36 Product
37 ProductGroup+Flow+Step+ReferenceDesignator+MaterialDefectSystemState+DefectReason
38 ProductGroup+Flow+Step+ReferenceDesignator+DefectReason
39 ProductGroup+Flow+Step+ReferenceDesignator+MaterialDefectSystemState
40 ProductGroup+Flow+Step+ReferenceDesignator
41 ProductGroup+Step+ReferenceDesignator+MaterialDefectSystemState+DefectReason
42 ProductGroup+Step+ReferenceDesignator+DefectReason
43 ProductGroup+Step+ReferenceDesignator+MaterialDefectSystemState
44 ProductGroup+Step+ReferenceDesignator
45 ProductGroup+ReferenceDesignator+MaterialDefectSystemState+DefectReason
46 ProductGroup+ReferenceDesignator+DefectReason
47 ProductGroup+ReferenceDesignator+MaterialDefectSystemState
48 ProductGroup+ReferenceDesignator
49 ProductGroup+Flow+Step+PartNumber+MaterialDefectSystemState+DefectReason
50 ProductGroup+Flow+Step+PartNumber+DefectReason
51 ProductGroup+Flow+Step+PartNumber
52 ProductGroup+Flow+Step+PartNumber
53 ProductGroup+Step+PartNumber+MaterialDefectSystemState+DefectReason
54 ProductGroup+Step+PartNumber+DefectReason
55 ProductGroup+Step+PartNumber
56 ProductGroup+Step+PartNumber
57 ProductGroup+PartNumber+MaterialDefectSystemState+DefectReason
58 ProductGroup+PartNumber+DefectReason
59 ProductGroup+MaterialDefectSystemState+PartNumber
60 ProductGroup+PartNumber
61 ProductGroup+Flow+Step+ReferenceDesignator+MaterialDefectSystemState+DefectReason
62 ProductGroup+Flow+Step+ReferenceDesignator+MaterialDefectSystemState
63 ProductGroup+Flow+Step+ReferenceDesignator+DefectReason
64 ProductGroup+Flow+Step+ReferenceDesignator
65 ProductGroup+MaterialDefectSystemState+DefectReason
66 ProductGroup+DefectReason
67 ProductGroup+MaterialDefectSystemState
68 ProductGroup

SMTMapBoardIDContext#

Smart table to resolve the Panel Product and Custom Convention.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Product Yes No String <EntityType> Product Product for the Custom Convention
ProductGroup Yes No String <EntityType> Resource Resource for the Custom Convention
PanelizationProduct Yes No String <EntityType> Product Panelization Product
Convention Yes No String <LookupValue> CustomConvention Lookup Custom Convention
EquipmentBoardID No No String None Equipment Board ID
MESPositionId No No Int None MES Position ID
Precedence Keys
Order Precedence Keys
1 Product+Convention
2 ProductGroup+Convention
3 PanelizationProduct+Convention
4 MapDefinition+Convention
5 Convention

SMTMaterialExpandContext#

Smart table used to perform the Material Expand given a specific context

Columns:

Name Is Key Is Mandatory Data Type Reference Description
ExpandStep Yes Yes String <EntityType> Step Indicates where the Material expand will occur
ProductGroup Yes No String <EntityType> ProductGroup Indicates the Product Group
Product Yes No String <EntityType> Product Indicates the Product
ParentForm Yes Yes String <LookupValue> MaterialForm Indicates the form of the Parent Material
ChildForm No Yes String <LookupValue> MaterialForm Indicates the form of the Child Material
SubChildForm No Yes String <LookupValue> MaterialForm Indicates the form of the Sub Child Material
ExpandOperation No Yes Integer <Enum> SMTMaterialExpandOperation Indicates which operation triggers the expand, Track-In or Track-Out
IsExternalNaming No Yes Boolean None Indicates if the name of Material is externally generated
ExpansionFactor No No Decimal None Determines the factor of the expansion from parent to Child form
SubExpansionFactor No No Decimal None Determines the factor of the sub expansion from Child to Sub Child form
DetachStep No Yes Boolean <EntityType> Step Indicates where the Material is detached
IsSpecialMode No Yes Boolean None Indicates if there will be a second expand (i.e. expand panels and boards at the same time)
Precedence Keys
Order Precedence Keys
1 Product+ExpandStep+ParentForm
2 ProductGroup+ExpandStep+ParentForm
3 ExpandStep+ParentForm

SMTMaterialNameGenerationContext#

Smart table to configure and derive the Name Generator to apply.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Step Yes Yes String <EntityType> Step Indicates the Step where serialization for the board or panel form is going to be performed
Customer No No String <EntityType> BusinessPartner Indicates the BusinessPartner
ProductGroup Yes No String <EntityType> ProductGroup Indicates the Product Group
Product Yes No String <EntityType> Product Indicates the Product
Form Yes Yes String <LookupValue> MaterialForm Indicates the material form for which a name is to be generated
Operation Yes Yes Enum <Enum> MaterialNameGeneratorOperation Indicates in which operation the name should be generated
NameGenerator No No String None Indicates what is the Name Generator to use
LabelValidationMask No Yes String None Indicates the validation string to validate the label name
Precedence Keys
Order Precedence Keys
1 Product+Step+MaterialForm
2 ProductGroup+Step+MaterialForm
3 Customer+Step+MaterialForm
4 Step+MaterialForm

SMTMaterialPackingContext#

Smart table to configure list of product containers available to pack a product.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Customer Yes No String <EntityType> BusinessPartner Indicates the Business Partner
ProductGroup Yes No String <EntityType> ProductGroup Indicates the Product Group
Product Yes No String <EntityType> Product Indicates the Product
ProductionOrder Yes No String <EntityType> ProductionOrder Indicates the Production Order
PackingContainer No Yes String <EntityType> Product Indicates the Packing Container Product
Precedence Keys
Order Precedence Keys
1 ProductionOrder
2 Product
3 ProductGroup
4 Customer

SMTPartialTrackOutContext#

Smart table used to resolve the Partial TrackOut for the specific material context

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Product Yes No String <EntityType> Product Indicates the Product
ProductGroup Yes No String <EntityType> ProductGroup Indicates the ProductGroup
Flow Yes No String <EntityType> Flow Indicates the Flow
Step Yes No String <EntityType> Step Indicates the Step
Material Yes No String <EntityType> Material Indicates the Material
IsToMoveNext No True Boolean None Indicates whether the material should be moved to the next step
Precedence Keys
Order Precedence Keys
1 Step+Flow+ProductGroup
2 Step+Flow+Product
3 Step+Flow+Material
4 Step+Flow
5 Step+ProductGroup
6 Step+Product
7 Step+Material
8 Step

SMTMaterialPrintableDocumentContext#

Smart table to configure and derive the Labels to apply.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Step Yes Yes String <EntityType> Step Indicates the Step where serialization for the board or panel form is going to be performed
Customer Yes No String <EntityType> BusinessPartner Indicates the BusinessPartner
ProductGroup Yes No String <EntityType> ProductGroup Indicates the Product Group
Product Yes No String <EntityType> Product Indicates the Product
Flow Yes No String <EntityType> Flow Indicates the Flow
Material Yes No String <EntityType> Material Indicates the Material for which a label is to be printed
MaterialType Yes No String None Indicates the material type for which a label is to be printed
MaterialForm Yes Yes String <LookupValue> MaterialForm Indicates the material form for which a label is to be printed
Operation Yes Yes Enum <Enum> MaterialPrintable
DocumentOperation
Operation that will trigger the label printing
Label No Yes String <EntityType> PrintableDocument Indicates the Printable document to be used for printing
SynchronousPrinting No Yes Boolean None Indicates whether the Print should be Synchronous
Precedence Keys
Order Precedence Keys
1 Step+Product+MaterialForm+Operation
2 Step+ProductGroup+MaterialForm+Operation
3 Step+Customer+MaterialForm+Operation
4 Step+Material+MaterialForm+Operation
5 Step+Flow+MaterialForm+Operation
6 Step+MaterialForm+Operation
7 Step+Material
8 Step+Product+Flow
9 Step+Product+MaterialType
10 Step+Product
11 Step+ProductGroup+Flow
12 Step+ProductGroup+MaterialType
13 Step+ProductGroup
14 Step+MaterialType
15 Step

SMTReprocessLimitContext#

Smart table to place a limit on how many times a material can go through a step.

Columns:

Name Is Key Is Mandatory Data Type Reference Description
Product Yes No String <EntityType> Product Product of the material
ProductGroup Yes No String <EntityType> ProductGroup Product Group of the material
LogicalFlowPath Yes No String None Logical Flow Path of the material
Flow Yes No String <EntityType> Flow The flow immediately above the material's current step
Step Yes No String <EntityType> Step The material's current step
MaximumReprocessLimit No Yes Int None The maximum number of times the material is allowed to go through the step
Precedence Keys
Order Precedence Keys
1 Product+LogicalFlowPath+Step
2 Product+Flow+Step
3 Product+Step
4 Product
5 ProductGroup+LogicalFlowPath+Step
6 ProductGroup+Flow+Step
7 ProductGroup+Step
8 ProductGroup

IoTMetadataDefinition#

This smart table serves as the primary source of configuration data for IoT template integrations. By defining a set of keys within this table, you can specify connection configurations and control the expected behavior of your integration.

Name Is Key Is Mandatory Data Type Reference Description
Resource Yes No String <EntityType> Resource Resource Name
ResourceType Yes No String <LookupValue> ResourceType Resource Type
Area Yes No String <EntityType> Area Area Name
Name No Yes String None Name of Metadata
Value No Yes String None Value of Metadata
Precedence Keys
Order Precedence Keys
1 Resource
2 ResourceType
3 Area