INTFC_BTF_BASE (SQL Table)	Index Back
AM Interface-Physical A When altering this and/or the INTFC_FIN record, be sure to recreate views that start with INTFC_FIN, INTFC_PH, ASSET_UNIT, and ASSET_CON. Views ASSET_CON_B_VW, C, G, and H are based on INTFC_FIN. Views A, C, E, F, I, J, K, and L are based on INTFC_PHY_A. Also regenerate SQL for mass change definitions PI1 through PI7. ---------------------------------------- Please, also reflect the changes in AMIF_IPA_TMP.

INTFC_BTF_BASE

(SQL Table)

AM Interface-Physical A

When altering this and/or the INTFC_FIN record, be sure to recreate views that start with INTFC_FIN*, INTFC_PH*, ASSET_UNIT*, and ASSET_CON*. Views ASSET_CON_B_VW, C, G, and H are based on INTFC_FIN. Views A, C, E, F, I, J, K, and L are based on INTFC_PHY_A. Also regenerate SQL for mass change definitions PI1 through PI7. ---------------------------------------- Please, also reflect the changes in AMIF_IPA_TMP.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance