Transaction Loader Inserts
Depending on what transaction type you are processing and which loader table it is reading, the Transaction Loader inserts field values into various Asset Management tables and performs any additional processing noted in the following table. It inserts all fields that the target table and the loader table have in common.
The following table describes the information inserted from the INTFC_FIN table:
|
Transaction Type (Load Type) |
Inserts into These Tables |
Additional Processing |
|---|---|---|
|
FAD |
Book* Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Open Trans * Open Trans Profile # |
|
|
ADD |
Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Open Trans * Open Trans Profile # |
|
|
CN1 |
Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # |
Process Conversion Open Trans 1 |
|
CN2 |
Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # |
Process Conversion Open Trans 1 |
|
CAP |
Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Open Trans * Open Trans Profile # |
|
|
CIC |
Book * Book Profile # Cost * Cost Profile # Open Trans * Open Trans Profile # |
Validate Distribution Templates |
|
AAD |
Cost * Cost Profile # Open Trans * Open Trans Profile # |
|
|
IUI |
Book * Cost # Open Trans * |
Set Trans Type to TRF Set Trans_In_Out to I Validate Distribution Templates Process IUI Asset ID |
|
IUO |
Cost * Open Trans * |
Set Trans Type to TRF Set Trans_In_Out to O Validate Distribution Templates |
|
TRF |
Cost (positive amount for transfer in) * Cost (negative amount for transfer out) * Open Trans * |
|
|
ADJ |
Cost * Open Trans * |
|
|
RCT |
Cost * Open Trans * |
|
|
RET |
Cost * Retirement Open Trans * |
Set Asset Status to Disposed |
|
PRT |
Cost * Retirement Open Trans * |
|
|
REI |
Cost * Retirement Open Trans * |
Update Asset Status to In Service |
|
BKS |
Open Trans * |
Update Book Processing |
|
BKD |
Delete Book |
|
|
BSD |
Delete only BU/Book/Asset ID combinations |
|
|
OPT |
Open Trans * |
|
|
ASD |
Deletes from all base tables |
Check DIST_LN Delete Asset Processing |
|
ADQ |
Cost * Cost Profile # Open Trans * Open Trans Profile # |
|
|
ARA |
Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Retirement * Retirement Profile # |
|
|
LAD |
Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Retirement * Retirement Profile # Open Trans * |
|
|
ADP |
Depreciation * Open Trans |
* When Default Profile Switch = N
# When Default Profile Switch = Y and PHY_A.PROFILE_ID is valid in the profile detail table, the system gets book, cost, depreciation, and open trans information from the profile detail table rather than INTFC_FIN.
The following table describes the information inserted from the INTFC_PHY_A table:
|
Transaction Type |
Inserts into These Tables |
Additional Processing |
|---|---|---|
|
FAD |
Asset, Asset Acquisition Detail, Asset Custodian, Asset Location |
|
|
NAD |
Asset, Asset Acquisition Detail, Asset Custodian, Asset Location |
|
|
IUI |
Asset, Asset Acquisition Detail, Asset Custodian, Asset Location |
|
|
CN1 |
Asset, Asset Acquisition Detail, Asset Custodian, Asset Location |
|
|
AUP |
|
Update Asset |
|
PHY |
Asset Acquisition Detail Asset Custodian Asset Location |
|
|
CAP |
Asset Acquisition Detail |
Capitalize Asset Acquisition Detail |
|
ACQ |
Asset Acquisition Detail |
|
|
ADQ |
Asset Acquisition Detail |
|
|
CLC |
Asset Custodian Asset Location |
|
|
LAD |
Asset, Asset Custodian, Asset Location |
|
|
CIC |
Update Asset Acquisition Detail = CIC |
|
|
IHI |
Physical Inventory History |
|
|
RAQ |
Asset Acquisition Detail |
Replace Acquisition Detail - Used solely by AMIF1000 |
|
ARA |
Asset Custodian, Asset Location, Physical Inventory History, Parent Asset |
The following table describes the information inserted from the INTFC_PHY_B table:
|
Transaction Type |
Inserts into These Tables |
Additional Processing |
|---|---|---|
|
FAD |
Asset Attribute Asset Comments Asset License Asset Warranty |
|
|
NAD |
Asset Attribute Asset Comments Asset License Asset Warranty |
|
|
PHY |
Asset Attribute Asset Comments Asset License Asset Warranty |
|
|
CN1 |
Asset Attribute Asset Comments Asset License Asset Warranty |
|
|
ARA |
Asset Attribute Asset Comments Asset License Asset Warranty |
|
|
LAD |
Asset Attribute Asset Comments Asset License Asset Warranty |