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 process plan 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 Number
|
N/A
|
Windchill
|
N/A
|
|
Number
|
GROUP_NUM BER
|
Group Number
|
N/A
|
Windchill
|
N/A
|
|
Plant
|
ROUTING_PL ANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
|
GROUP_COUN TER
|
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
|
||
BaseUnitOf Measure
|
BASE_UNIT_O F_MEASURE
|
Base unit of measure
|
N/A
|
Windchill
|
N/A
|
|
MODIFY_HEA DER
|
Modify Header
|
X
|
TIBCO
|
N/A
|
||
INSERT_OPR_ FOR_SEQ
|
Insert Operation for Sequence
|
X
|
||||
TIBCO
|
N/A
|
|||||
MODIFY_OPR _FOR_SEQ
|
Modify Operation for sequence
|
X
|
TIBCO
|
N/A
|
||
DELETE_OPR_ FOR_SEQ
|
Delete Operation for Sequence
|
X
|
TIBCO
|
N/A
|
||
INSERT_SUBO PR_FOR_SEQ
|
Insert sub operation for sequence
|
X
|
TIBCO
|
N/A
|
||
MODIFY_SUB OPR_FOR_SEQ
|
Modificatio n of suboperation
|
X
|
TIBCO
|
N/A
|
||
DELETE_SUB OPR_FOR_SEQ
|
Delete Sub operation
|
X
|
TIBCO
|
N/A
|
||
ADD_ALT_SEQUENCE
|
Add Alternate Sequence
|
X
|
TIBCO
|
N/A
|
||
ADD_PARLLE L_SEQUENCE
|
Add Parallel Sequence
|
X
|
TIBCO
|
N/A
|
||
MODIFY_SEQ
|
Modify all Sequences
|
X
|
TIBCO
|
N/A
|
||
DELETE_SEQ UENCE
|
Delete all Sequence
|
X
|
TIBCO
|
N/A
|
||
ADD_PRT_AL LOCATION
|
Assign PRT allocation
|
X
|
TIBCO
|
N/A
|
||
MODIFY_PRT _ALLOCATION
|
Modify PRT Allocation
|
X
|
TIBCO
|
N/A
|
||
DELETE_PRT_ ALLOCATION
|
Delete PRT allocation
|
X
|
TIBCO
|
N/A
|
||
ASSIGN_COM P_ALLOC
|
Assign component Allocation
|
X
|
TIBCO
|
N/A
|
||
MODIFY_COM P_ALLOC
|
Modify Component Allocation
|
X
|
TIBCO
|
N/A
|
||
DELETE_COM P_ALLOC
|
Delete Component Allocation
|
X
|
TIBCO
|
N/A
|
||
ASSIGN_REF_ OPR_SET
|
Assign Reference Operation set to Operation
|
X
|
TIBCO
|
N/A
|
||
DELETE_REF_ OPR_SET
|
Delete Reference Operation set
|
X
|
TIBCO
|
N/A
|
||
ASSIGN_MAT ERIAL
|
Assign Material
|
X
|
TIBCO
|
N/A
|
||
Sequence Line Number
|
T_OPERA TION_INSERT
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_OPERA TION_INSERT
|
OPERATIONID
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
T_OPERA TION_INSERT
|
STANDARD_V ALUE_KEY
|
Standard value key
|
N/A
|
TIBCO
|
N/A
|
|
WorkCenter Number
|
T_OPERA TION_INSERT
|
WORKCENTE R
|
Work Center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_OPERA TION_INSERT
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidati onCode
|
T_OPERA TION_INSERT
|
CONTROLKEY
|
Control key
|
N/A
|
Windchill
|
N/A
|
Description
|
T_OPERA TION_INSERT
|
DESCRIPTION
|
Description
|
N/A
|
Windchill
|
N/A
|
BaseUnitOf Measure
|
T_OPERA TION_INSERT
|
UNITOFMEAS URE
|
Unit of Measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_OPERA TION_INSERT
|
BASE_QUANT ITY
|
Base quantity
|
N/A
|
Windchill
|
N/A
|
T_OPERA TION_INSERT
|
NUMERATOR _FOR_CONVE RSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_OPERA TION_INSERT
|
DENOMINAT OR_FOR_CON VERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Operation Label
|
T_OPERA TION_MODIFY
|
OLD_OPERAT IONID
|
Old Operation ID
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_OPERA TION_MODIFY
|
OPERATIONID
|
New Operation ID
|
N/A
|
Windchill
|
N/A
|
WorkCenter Number
|
T_OPERA TION_MODIFY
|
WORKCENTE R
|
Work Center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_OPERA TION_MODIFY
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidati onCode
|
T_OPERA TION_MODIFY
|
CONTROLKEY
|
Control key
|
N/A
|
Windchill
|
N/A
|
Description
|
T_OPERA TION_MODIFY
|
DESCRIPTION
|
Description
|
N/A
|
Windchill
|
N/A
|
BaseUnitOf Measure
|
T_OPERA TION_MODIFY
|
UNITOFMEAS URE
|
Unit of Measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_OPERA TION_MODIFY
|
BASE_QUANT ITY
|
Base quantity
|
N/A
|
Windchill
|
N/A
|
T_OPERA TION_MODIFY
|
NUMERATOR _FOR_CONVE RSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_OPERA TION_MODIFY
|
DENOMINAT OR_FOR_CON VERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Number
|
T_OPERA TION_DELETE
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_OPERA TION_DELETE
|
OPERATIONID
|
Operation ID
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_SUBOPERATION_INSERT
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_I NSERT
|
OPERATIONID
|
Operation ID
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_INSERT
|
SUBOPERATI ON
|
Sub operation
|
N/A
|
Windchill
|
N/A
|
T_SUBOPERATION_INSERT
|
STANDARD_V ALUE_KEY
|
Standard value key
|
N/A
|
TIBCO
|
N/A
|
|
Work Center Number
|
T_SUBOPERATION_INSERT
|
WORKCENTE R
|
Work Center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_SUBOPERATION_INSERT
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidati onCode
|
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
|
UNITOFMEAS URE
|
Unit of measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_SUBOPERATION_INSERT
|
BASE_QUANT ITY
|
Base Quantity
|
N/A
|
Windchill
|
N/A
|
T_SUBOPERATION_INSERT
|
NUMERATOR _FOR_CONVE RSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_SUBOPERATION_INSERT
|
DENOMINAT OR_FOR_CON VERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Sequence Line Number
|
T_SUBOPERATION_ MODIFY
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_ MODIFY
|
OPERATIONID
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_ MODIFY
|
OLD_SUBOPERATIONID
|
Sub operation
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_ MODIFY
|
SUBOPERATI ON
|
Sub operation
|
N/A
|
Windchill
|
N/A
|
Work center Number
|
T_SUBOPERATION_ MODIFY
|
WORKCENTE R
|
Work center
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_SUBOPERATION_ MODIFY
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
ErpValidati onCode
|
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
|
UNITOFMEAS URE
|
Unit of measure
|
N/A
|
Windchill
|
N/A
|
Quantity
|
T_SUBOPERATION_ MODIFY
|
BASE_QUANT ITY
|
Base quantity
|
N/A
|
Windchill
|
N/A
|
T_SUBOPERATION_ MODIFY
|
NUMERATOR _FOR_CONVE RSION
|
Numerator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
T_SUBOPERATION_ MODIFY
|
DENOMINAT OR_FOR_CON VERSION
|
Denominator for conversion
|
N/A
|
TIBCO
|
N/A
|
|
Sequence Line Number
|
T_SUBOPERATION_ DELETE
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_ DELETE
|
OPERATIONID
|
Operation Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_SUBOPERATION_ DELETE
|
SUBOPERATI ON
|
Sub operation
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_ALTERNATE_SEQ_CREATE
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
BranchingO peration
|
T_ALTERNATE_SEQ_CREATE
|
BRANCH_OPERATION_NO
|
Branch operation number
|
N/A
|
Windchill
|
N/A
|
ReturnOper ation
|
T_ALTERNATE_SEQ_CREATE
|
RETURN_OPERATION_NO
|
Return operation number
|
N/A
|
Windchill
|
N/A
|
Name
|
T_ALTERNATE_SEQ_CREATE
|
DESCRIPTION _SEQUENCE
|
Description
|
N/A
|
Windchill
|
N/A
|
T_ALTERNATE_SEQ_CREATE
|
REFERENCE_ SEQUENCE
|
Reference Sequence
|
N/A
|
TIBCO
|
N/A
|
|
T_ALTERNATE_SEQ_CREATE
|
FROM_LOT_SIZE
|
From lot size
|
N/A
|
Windchill
|
N/A
|
|
T_ALTERNATE_SEQ_CREATE
|
TO_LOT_SIZE
|
To lot size
|
N/A
|
TIBCO
|
N/A
|
|
Sequence Line Number
|
T_PARALLEL_SEQ_ CREATE
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
BranchingO peration
|
T_PARALLEL_SEQ_ CREATE
|
BRANCH_OPERATION_NO
|
Branch operation number
|
N/A
|
Windchill
|
N/A
|
ReturnOper ation
|
T_PARALLEL_SEQ_ CREATE
|
RETURN_OPERATION_NO
|
Return operation number
|
N/A
|
Windchill
|
N/A
|
Name
|
T_PARALLEL_SEQ_ CREATE
|
DESCRIPTION _SEQUENCE
|
Description
|
N/A
|
Windchill
|
N/A
|
T_PARALLEL_SEQ_ CREATE
|
REFERENCE_ SEQUENCE
|
Reference Sequence
|
N/A
|
TIBCO
|
N/A
|
|
Sequence Line Number
|
T_SEQ_MODIFY
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
BranchingO peration
|
T_SEQ_MODIFY
|
BRANCH_OPERATION_NO
|
Branch operation number
|
N/A
|
Windchill
|
N/A
|
ReturnOper ation
|
T_SEQ_MODIFY
|
RETURN_OPERATION_NO
|
Return operation number
|
N/A
|
Windchill
|
N/A
|
Name
|
T_SEQ_MODIFY
|
DESCRIPTION _SEQUENCE
|
Description
|
N/A
|
Windchill
|
N/A
|
T_SEQ_MODIFY
|
REFERENCE_ SEQUENCE
|
Reference Sequence
|
N/A
|
TIBCO
|
N/A
|
|
T_SEQ_MODIFY
|
FROM_LOT_SIZE
|
From lot size
|
N/A
|
N/A
|
N/A
|
|
T_SEQ_MODIFY
|
TO_LOT_SIZE
|
To lot size
|
N/A
|
N/A
|
N/A
|
|
Category
|
T_SEQ_MODIFY
|
SEQUENCE_C ATEGORY
|
Sequence category
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_SEQ_DE LETE
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_PRT_AS SIGN
|
SEQUENCE_N O
|
Sequence Number
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_PRT_AS SIGN
|
OPERATION_ NUMBER
|
Operation number
|
N/A
|
Windchill
|
N/A
|
AllocationN umber
|
T_PRT_AS SIGN
|
ITEM_NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
Category
|
T_PRT_AS SIGN
|
PRT_CATEGO RY
|
PRT category
|
N/A
|
Windchill
|
Cross referencing
|
ResourceNumber
|
T_PRT_AS SIGN
|
EQUIPMENT_ NUMBER
|
Equipment number
|
N/A
|
Windchill
|
N/A
|
T_PRT_AS SIGN
|
CONTROL_KEY
|
Control key
|
N/A
|
TIBCO
|
N/A
|
|
T_PRT_AS SIGN
|
STANDARD_T EXT_KEY
|
Standard text key
|
N/A
|
N/A
|
N/A
|
|
ResourceNumber
|
T_PRT_AS SIGN
|
MATERIAL_N UMBER
|
PRT material
|
N/A
|
Windchill
|
N/A
|
T_PRT_AS SIGN
|
PRODUCT_RE SOURCE
|
Product resource
|
N/A
|
N/A
|
N/A
|
|
DocumentN umber
|
T_PRT_AS SIGN
|
DOCUMENT_ NUMBER
|
Document number
|
N/A
|
Windchill
|
N/A
|
Type
|
T_PRT_AS SIGN
|
DOCUMENT_ TYPE
|
Document type
|
N/A
|
Windchill
|
Cross referencing
|
T_PRT_AS SIGN
|
DOCUMENT_P ART
|
Document part
|
N/A
|
Windchill
|
Cross referencing
|
|
DocumentVersion
|
T_PRT_AS SIGN
|
DOCUMENT_ VERSION
|
Document version
|
N/A
|
Windchill
|
N/A
|
T_PRT_AS SIGN
|
QUANTITY
|
Quantity
|
N/A
|
N/A
|
N/A
|
|
Sequence Line Number
|
T_PRT_MODIFY
|
SEQUENCE_N O
|
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_CATEGO RY
|
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_T EXT_KEY
|
Standard text key
|
N/A
|
N/A
|
N/A
|
|
ResourceNumber
|
T_PRT_MODIFY
|
MATERIAL_N UMBER
|
PRT material
|
N/A
|
Windchill
|
N/A
|
T_PRT_MODIFY
|
PRODUCT_RE SOURCE
|
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_P ART
|
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
|
|
Sequence Line Number
|
T_PRT_DE LETE
|
SEQUENCE_N O
|
Sequence number
|
N/A
|
Windchill
|
N/A
|
Operation label
|
T_PRT_DE LETE
|
OPERATION_ NUMBER
|
Operation ID
|
N/A
|
Windchill
|
N/A
|
Allocation Number
|
T_PRT_DE LETE
|
ITEM_NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
plant
|
T_COMP_ ALLOCAT ION_ASSI GN
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
Part number
|
T_COMP_ ALLOCAT ION_ASSI GN
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_COMP_ ALLOCAT ION_ASSI GN
|
SEQUENCE
|
Sequence
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_COMP_ ALLOCAT ION_ASSI GN
|
OPERATION
|
Operation id
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_COMP_ ALLOCAT ION_MODI FY
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|
Part Number
|
T_COMP_ ALLOCAT ION_MODI FY
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Sequence Line Number
|
T_COMP_ ALLOCAT ION_MODI FY
|
SEQUENCE
|
Sequence
|
N/A
|
Windchill
|
N/A
|
Operation Label
|
T_COMP_ ALLOCAT ION_MODI FY
|
OPERATION
|
Operation id
|
N/A
|
Windchill
|
N/A
|
Part Number
|
T_COMP_ ALLOCAT ION_DELE TE
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
T_REFERE NCE_OPR_ SET_ASSI GN
|
SEQUENCE_N O
|
Sequence number
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_ASSI GN
|
OPERATION
|
Operation number
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_ASSI GN
|
STANDARD_T EXT_KEY
|
Standard text key
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_ASSI GN
|
DESCRIPTION
|
Description
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_ASSI GN
|
REFERRED_G ROUP
|
Referred group
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_ASSI GN
|
REFERRED_G ROUP_COUNT ER
|
Referred group counter
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_DELE TE
|
REFERRED_G ROUP
|
Referred group
|
N/A
|
N/A
|
N/A
|
|
T_REFERE NCE_OPR_ SET_DELE TE
|
REFERRED_G ROUP_COUNT ER
|
Referred group counter
|
N/A
|
N/A
|
N/A
|
|
Part Number
|
T_MATERI AL_ASSIG NMENT
|
MATERIAL
|
Material
|
N/A
|
Windchill
|
N/A
|
Plant
|
T_MATERI AL_ASSIG NMENT
|
PLANT
|
Plant
|
N/A
|
Windchill
|
N/A
|