From INTFC_FIN
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.