Windchill Attribute Name
|
API Structure
|
API Field
|
API Field Description
|
Value (If default used)
|
Source
|
Transform
|
---|---|---|---|---|---|---|
Number
|
MATERIAL_N UMBER
|
Material number
|
N/A
|
Windchill
|
N/A
|
|
Plant from ProcessPlan to part link
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
|
KEY_DATE
|
Key Date
|
N/A
|
TIBCO if not blank Otherwise Windchill
|
N/A
|
||
Number
|
CHANGE_NUMBER
|
Change
|
N/A
|
Windchill
|
N/A
|
|
Standard Operation Number
|
GROUP_NUMBER
|
Group Number
|
N/A
|
Windchill
|
N/A
|
|
Plant
|
REFERENCE OPERATION SET_PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
|
GROUP_ COUNTER
|
Group Counter
|
N/A
|
TIBCO
|
N/A
|
||
Description
|
TASKLIST_DE SCRIPTION
|
Task list Description
|
N/A
|
Windchill
|
N/A
|
|
TASKLIST_US AGE
|
Task list Usage
|
N/A
|
TIBCO
|
N/A
|
||
TASKLIST_ST ATUS
|
Task List Status
|
N/A
|
TIBCO
|
N/A
|
||
Lot
|
FROM_LOT_ SIZE
|
From lot size
|
N/A
|
Windchill
|
N/A
|
|
TO_LOT_SIZE
|
To lot size
|
N/A
|
TIBCO
|
N/A
|
||
BaseUnitOfMeasure
|
BASE_UNIT_OF_MEASURE
|
Base unit of measure
|
N/A
|
Windchill
|
N/A
|
|
MODIFY_HEADER
|
Modify Header
|
X
|
TIBCO
|
N/A
|
||
INSERT_OPERATION
|
Insert Operation
|
X
|
TIBCO
|
N/A
|
||
MODIFY_OPERATION
|
Modify Operation
|
X
|
TIBCO
|
N/A
|
||
DELETE_OPERATION
|
Delete Operation
|
X
|
TIBCO
|
N/A
|
||
INSERT_SUBOPERATION
|
Insert SubOperation
|
X
|
TIBCO
|
N/A
|
||
MODIFY_SUBOPERATION
|
Modify SubOperation
|
X
|
TIBCO
|
N/A
|
||
DELETE_SUBOPERATION
|
Delete SubOperation
|
X
|
TIBCO
|
N/A
|
||
INSERT_PRT
|
Assign PRT allocation
|
X
|
TIBCO
|
N/A
|
||
MODIFY_PRT
|
Modify PRT Allocation
|
X
|
TIBCO
|
N/A
|
||
DELETE_PRT
|
Delete PRT allocation
|
X
|
TIBCO
|
N/A
|
||
ASSIGN_COMP_ALLOC
|
Assign component Allocation
|
X
|
TIBCO
|
N/A
|
||
MODIFY_ COM P_ALLOC
|
Modify Component Allocation
|
X
|
TIBCO
|
N/A
|
||
DELETE_COMP_ALLOC
|
Delete Component Allocation
|
X
|
TIBCO
|
N/A
|
||
ASSIGN_MATERIAL
|
Assign Material
|
X
|
TIBCO
|
N/A
|
||
Operation Label
|
T_OPERATION_INSERT
|
OPERATIONID
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
T_OPERATION_INSERT
|
STANDARD_VALUE_KEY
|
Standard value key
|
N/A
|
TIBCO
|
N/A
|
|
WorkCenterNumber
|
T_OPERATION_INSERT
|
WORKCENTER
|
Work Center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_OPERATION_INSERT
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidationCode
|
T_OPERATION_INSERT
|
CONTROL-KEY
|
Control key
|
N/A
|
Windchill
|
N/A
|
Description
|
T_OPERATION_INSERT
|
DESCRIPTION
|
Description
|
N/A
|
Windchill
|
N/A
|
BaseUnitOfMeasure
|
T_OPERATION_INSERT
|
UNITOFMEASURE
|
Unit of Measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_OPERATION_INSERT
|
BASE_QUANTITY
|
Base quantity
|
N/A
|
Windchill
|
N/A
|
T_OPERATION_INSERT
|
NUMERATOR_FOR_CONVERSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_OPERATION_INSERT
|
DENOMINATOR_FOR_CONVERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Operation Label
|
T_OPERATION_MODIFY
|
OLD_OPERATIONID
|
Old Operation ID
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_OPERATION_MODIFY
|
OPERATIONID
|
New Operation ID
|
N/A
|
Windchill
|
N/A
|
WorkCenterNumber
|
T_OPERATION_MODIFY
|
WORKCENTER
|
Work Center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_OPERATION_MODIFY
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidationCode
|
T_OPERATION_MODIFY
|
CONTROL-KEY
|
Control key
|
N/A
|
Windchill
|
N/A
|
Description
|
T_OPERATION_MODIFY
|
DESCRIPTION
|
Description
|
N/A
|
Windchill
|
N/A
|
BaseUnitOfMeasure
|
T_OPERATION_MODIFY
|
UNITOFMEASURE
|
Unit of Measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_OPERATION_MODIFY
|
BASE_QUANTITY
|
Base quantity
|
N/A
|
Windchill
|
N/A
|
T_OPERATION_MODIFY
|
NUMERATOR_FOR_CONVERSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_OPERATION_MODIFY
|
DENOMINATOR_FOR_CONVERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Number
|
T_OPERATION_DELETE
|
SEQUENCE_NO
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_OPERATION_DELETE
|
OPERATIONID
|
Operation ID
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_INSERT
|
OPERATIONID
|
Operation ID
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_INSERT
|
SUBOPERATION
|
Suboperation
|
N/A
|
Windchill
|
N/A
|
T_SUBOPERATION_INSERT
|
STANDARD_VALUE_KEY
|
Standard value key
|
N/A
|
TIBCO
|
N/A
|
|
Work Center Number
|
T_SUBOPERATION_INSERT
|
WORKCENTER
|
Work Center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_SUBOPERATION_INSERT
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidationCode
|
T_SUBOPERATION_INSERT
|
CONTROLKEY
|
Control key
|
N/A
|
Windchill
|
Cross referencing
|
Description
|
T_SUBOPERATION_INSERT
|
DESCRIPTION
|
Description
|
N/A
|
Windchill
|
N/A
|
Base unit of measure
|
T_SUBOPERATION_INSERT
|
UNITOFMEASURE
|
Unit of measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_SUBOPERATION_INSERT
|
BASE_QUANTITY
|
Base Quantity
|
N/A
|
Windchill
|
N/A
|
T_SUBOPERATION_INSERT
|
NUMERATOR_FOR_CONVERSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_SUBOPERATION_INSERT
|
DENOMINATOR_FOR_CONVERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Operation Label
|
T_SUBOPERATION_MODIFY
|
OPERATIONID
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_MODIFY
|
OLD_SUBOPERATIONID
|
Suboperation
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_MODIFY
|
SUBOPERATION
|
Suboperation
|
N/A
|
Windchill
|
N/A
|
Work center Number
|
T_SUBOPERATION_MODIFY
|
WORKCENTER
|
Workcenter
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_SUBOPERATION_MODIFY
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidationCode
|
T_SUBOPERATION_MODIFY
|
CONTROLKEY
|
Control Key
|
N/A
|
Windchill
|
Cross referencing
|
Description
|
T_SUBOPERATION_MODIFY
|
DESCRIPTION
|
Description
|
N/A
|
Windchill
|
N/A
|
Base unit of measure
|
T_SUBOPERATION_MODIFY
|
UNITOFMEASURE
|
Unit of measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_SUBOPERATION_MODIFY
|
BASE_QUANTITY
|
Base quantity
|
N/A
|
Windchill
|
N/A
|
T_SUBOPERATION_MODIFY
|
NUMERATOR_FOR_CONVERSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_SUBOPERATION_MODIFY
|
DENOMINATOR_FOR_CONVERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Operation Label
|
T_SUBOPERATION_DELETE
|
OPERATIONID
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_DELETE
|
SUBOPERATION
|
Suboperation
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_PRT_ASSIGN
|
OPERATION_NUMBER
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
AllocationNumber
|
T_PRT_ASSIGN
|
ITEM_NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
Category
|
T_PRT_ASSIGN
|
PRT_CATEGORY
|
PRT category
|
N/A
|
Windchill
|
Cross referencing
|
ResourceNumber
|
T_PRT_ASSIGN
|
EQUIPMENT_NUMBER
|
Equipment number
|
N/A
|
Windchill
|
N/A
|
T_PRT_ASSIGN
|
CONTROL_KEY
|
Control key
|
N/A
|
TIBCO
|
N/A
|
|
T_PRT_ASSIGN
|
STANDARD_TEXT_KEY
|
Standard text key
|
N/A
|
N/A
|
N/A
|
|
ResourceNumber
|
T_PRT_ASSIGN
|
MATERIAL_NUMBER
|
PRT material
|
N/A
|
Windchill
|
N/A
|
T_PRT_ASSIGN
|
PRODUCT_RESOURCE
|
Product resource
|
N/A
|
N/A
|
N/A
|
|
DocumentNumber
|
T_PRT_ASSIGN
|
DOCUMENT_NUMBER
|
Document number
|
N/A
|
Windchill
|
N/A
|
Type
|
T_PRT_ASSIGN
|
DOCUMENT_TYPE
|
Document type
|
N/A
|
Windchill
|
Cross referencing
|
T_PRT_ASSIGN
|
DOCUMENT_PART
|
Document part
|
N/A
|
Windchill
|
Cross referencing
|
|
DocumentVersion
|
T_PRT_ASSIGN
|
DOCUMENT_VERSION
|
Document version
|
N/A
|
Windchill
|
N/A
|
T_PRT_ASSIGN
|
QUANTITY
|
Quantity
|
N/A
|
N/A
|
N/A
|
|
Sequence Line Number
|
T_PRT_MODIFY
|
SEQUENCE_NO
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_PRT_MODIFY
|
OPERATION_NUMBER
|
Operation number
|
N/A
|
Windchill
|
N/A
|
Allocation Number
|
T_PRT_MODIFY
|
ITEM_NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
Category
|
T_PRT_MODIFY
|
PRT_CATEGORY
|
PRT category
|
N/A
|
Windchill
|
Cross referencing
|
ResourceNumber
|
T_PRT_MODIFY
|
EQUIPMENT_NUMBER
|
Equipment number
|
N/A
|
Windchill
|
N/A
|
T_PRT_MODIFY
|
CONTROL_KEY
|
Control key
|
N/A
|
TIBCO
|
N/A
|
|
T_PRT_MODIFY
|
STANDARD_TEXT_KEY
|
Standard text key
|
N/A
|
N/A
|
N/A
|
|
ResourceNumber
|
T_PRT_MODIFY
|
MATERIAL_NUMBER
|
PRT material
|
N/A
|
Windchill
|
N/A
|
T_PRT_MODIFY
|
PRODUCT_RESOURCE
|
Product resource
|
N/A
|
N/A
|
N/A
|
|
Document number
|
T_PRT_MODIFY
|
DOCUMENT_NUMBER
|
Document number
|
N/A
|
Windchill
|
N/A
|
Type
|
T_PRT_MODIFY
|
DOCUMENT_TYPE
|
Document type
|
N/A
|
Windchill
|
Cross referencing
|
Document number
|
T_PRT_MODIFY
|
DOCUMENT_PART
|
Document part
|
N/A
|
Windchill
|
Cross referencing
|
Document Version
|
T_PRT_MODIFY
|
DOCUMENT_VERSION
|
Document version
|
N/A
|
Windchill
|
N/A
|
T_PRT_MODIFY
|
QUANTITY
|
Quantity
|
N/A
|
N/A
|
N/A
|
|
Operation label
|
T_PRT_DELETE
|
OPERATION_NUMBER
|
Operation ID
|
N/A
|
Windchill
|
N/A
|
Allocation Number
|
T_PRT_DELETE
|
ITEM_NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
plant
|
T_COMP_ALLOCATION_ASSIGN
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
Part number
|
T_COMP_ALLOCATION_ASSIGN
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_COMP_ALLOCATION_ASSIGN
|
OPERATION
|
Operation Id
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_COMP_ALLOCATION_MODIFY
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
Part Number
|
T_COMP_ALLOCATION_MODIFY
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_COMP_ALLOCATION_MODIFY
|
SEQUENCE
|
Sequence
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_COMP_ALLOCATION_MODIFY
|
OPERATION
|
Operation Id
|
N/A
|
Windchill
|
N/A
|
Part Number
|
T_COMP_ALLOCATION_DELETE
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Part Number
|
T_MATERIAL_ASSIGNMENT
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_MATERIAL_ASSIGNMENT
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|