Windchill Attribute Name
|
Interface Table
|
Interface Field
|
Field Description
|
Value If Default
|
Source
|
Transform
|
A
|
B
|
C
|
D
|
TransactionID
|
N/A (TIBCO field)
|
TIBCO_KEY
|
Unique id
|
N/A
|
Windchill and date/time
|
Concatenate Windchill Transaction ID with date/time
|
X
|
X
|
X
|
|
Version
|
MTL_ITEM_ REVISIONS_ INTERFACE
|
REVISION
|
Revision
|
N/A
|
Windchill
|
N/A
|
X
|
X
|
X
|
|
Distribution Target
|
MTL_ITEM_ REVISIONS_ INTERFACE
|
ORGANIZA TION_ CODE
|
Organization
|
N/A
|
Windchill
|
Substring
|
X
|
X
|
X
|
|
(Part) Number
|
MTL_ITEM_ REVISIONS_ INTERFACE
|
ITEM_ NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
X
|
X
|
X
|
|
N/A
|
MTL_ITEM_ REVISIONS_ INTERFACE
|
SET_ PROCESS_ ID
|
This value is used to tell Oracle which values to process in the Interface Table
|
'1'
|
Default
|
X
|
X
|
X
|
||
N/A
|
MTL_ITEM_ REVISIONS_ INTERFACE
|
PROCESS_ FLAG
|
Row status
|
'1' (Pending)
|
Default
|
N/A
|
X
|
X
|
X
|
|
N/A
|
MTL_ SYSTEM _ITEMS_ INTERFACE
|
TRANS ACTION_ TYPE
|
Transaction Type
|
'CREATE'*
|
Default
|
N/A
|
X
|
X
|
X
|
|
When creating/updating parts with Change Orders, the revision change will be done through the ECO process.
|