


|
Field Name
|
Type
|
Size
|
Description
|
|---|---|---|---|
|
FxPartProcurable
|
Nvarchar
|
1
|
Boolean, ‘y’ or ‘n’. Can be null.
|
|
FxPartRepairable
|
Nvarchar
|
1
|
Boolean, ‘y’ or ‘n’. Can be null.
|
|
Part Number
|
Relation Type
|
Available Date
|
Effective Date
|
Procurable
|
Repairable
|
FX Procurable
|
FX Repairable
|
|---|---|---|---|---|---|---|---|
|
B_TMR
|
11/1/2014
|
9/22/2014
|
Yes
|
Yes
|
|||
|
B1_TMR
|
Alternate
|
No
|
Yes
|
No
|
Yes
|
||
|
B1
|
Alternate
|
No
|
Yes
|
|
Part Number
|
Relation Type
|
Procurable
|
Repairable
|
|---|---|---|---|
|
B_TMR
|
Yes
|
Yes
|
|
|
B1_TMR
|
Alternate
|
No
|
Yes
|
|
B1
|
Alternate
|
No
|
Yes
|
|
|
Note the different values for current effective TMR compared to its future values.
|