|
Windchill Attribute Name
|
Interface Table
|
Interface Field
|
Field Description
|
Value If Default
|
Source
|
Transform
|
A
|
B
|
C
|
|
TransactionID
|
N/A (TIBCO field)
|
TIBCO_KEY
|
Unique id
|
N/A
|
Windchill and date/time
|
Concat Windchill Transaction ID with date/time
|
X
|
X
|
X
|
|
(Part) Number
|
MTL_SYSTEM _ITEMS_INTER FACE
|
ITEM_NUMBER
|
Item number
|
N/A
|
Windchill
|
N/A
|
X
|
X
|
X
|
|
partType
|
MTL_SYSTEM _ITEMS_INTER FACE
|
ITEM_TYPE
|
"SA"
"P"
|
N/A
|
Windchill
|
Sub-string
|
X
|
X
|
|
|
defaultUnit
|
MTL_SYSTEM _ITEMS_INTER FACE
|
PRIMARY_UOM _CODE
|
Base Unit Of Measure "EA", "KG" "L", "M", "AN"
|
N/A
|
Windchill
|
Cross Reference
|
X
|
X
|
|
|
Distribution Target
|
MTL_SYSTEM _ITEMS_INTER FACE
|
ORGANIZA TION_CODE
|
Organization
|
N/A
|
Windchill
|
Cross Reference
|
X
|
X
|
X
|
|
Source
|
MTL_SYSTEM _ITEMS_INTER FACE
|
PLANNING_ MAKE_BUY_ CODE
|
Make/Buy flag"1","2"
|
N/A
|
Windchill
|
X
|
X
|
||
|
Name
|
MTL_SYSTEM _ITEMS_INTER FACE
|
DESCRIPTION
|
Item Description
|
N/A
|
Windchill
|
Cross Reference
|
X
|
X
|
|
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
TEMPLATE_ID
|
Template for part creation based on part type
|
N/A
|
Windchill
|
Cross Reference (on part type)
|
X
|
||
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
TEMPLATE_ NAME
|
Template for part creation based on part type
|
N/A
|
Windchill
|
Cross Reference (on part type)
|
X
|
||
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
TRANSACTION _TYPE
|
Transaction Type
|
'CREATE'
|
Default
|
N/A
|
X
|
X
|
|
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
TRANSACTION _TYPE
|
Transaction Type
|
'UPDATE'
|
Default
|
N/A
|
X
|
X
|
|
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
PROCESS_FLAG
|
Row status
|
'1' (Pending)
|
Default
|
N/A
|
X
|
X
|
X
|
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
SUMMARY_ FLAG
|
Summary Flag
|
'N'
|
Default
|
N/A
|
X
|
X
|
|
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
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_SYSTEM _ITEMS_INTER FACE
|
Effectivity_ Control
|
Date/Unit
1/2
|
1
|
Windchill data and ESIORA Lookups. properties
|
2
|
X
|
||
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
SERIAL_ NUMBER_ CONTROL_ CODE
|
2 for Predefined, 1 for No control, and 5 for At receipt
|
1
|
Windchill data and ESIORA Lookups. properties
|
Cross Reference
|
X
|
||
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
SERIAL_AUTO_ SERIAL_ NUMBER
|
Serial number prefix
|
N/A
|
Windchill data and ESIORA Lookups. properties
|
Cross Reference
|
X
|
||
|
N/A
|
MTL_SYSTEM _ITEMS_INTER FACE
|
AUTO_SERIAL_ ALPHA_ PREFIX Start Serial Number
|
Start serial number
|
N/A
|
Windchill data and ESIORA Lookups. properties
|
Cross Reference
|
X
|