INTFC_AM_VW (SQL View)	Index Back
Interface AM View This view is used by the Unitize component.

INTFC_AM_VW

(SQL View)

Interface AM View

This view is used by the Unitize component.

SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.PROFILE_ID , A.DESCR , %subrec(CF14_AN_SBR, A) , %subrec(AM_CF1_N_SBR, A) , A.PROJECT_ID , A.DEPTID , A.COST_TYPE , B.QUANTITY , A.TXN_CURRENCY_CD , A.CURRENCY_CD , B.TXN_COST , B.COST , B.SALVAGE_VALUE , A.SALETX_AMT , A.SALETX_AMT_BSE , A.USETAX_AMT , A.USETAX_AMT_BSE , A.FREIGHT_AMT , A.FREIGHT_AMT_BSE , A.MISC_AMT , A.MISC_AMT_BSE , A.INTFC_STATUS , A.LOAD_STATUS , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.INVOICE_ID , A.PO_ID , A.ORIG_INTFC_ID , A.ORIG_LINE_NUM , A.TAG_NUMBER , A.SERIAL_ID , A.CUSTODIAN , A.LOCATION , A.MANUFACTURER , A.MODEL , A.DESCRSHORT , A.TXN_AMOUNT , A.AMOUNT , A.MERCHANDISE_AMT , A.MERCH_AMT_BSE , A.VAT_INV_AMT , A.VAT_INV_AMT_BSE , A.VAT_NRCVR_AMT , A.VAT_NRCVR_AMT_BSE , A.VAT_RCVRY_AMT , A.VAT_RCVRY_AMT_BSE , A.DESCR_LONG , A.AREA_ID , A.LINEAR_ASSET_SW , A.NBR_OF_CPU , A.CAP_THRSHLD_ID , A.CAPVAL_VALUE , A.ARO_SW , A.ARO_ID , A.EMPLID , A.MFG_ID , B.TRANS_DT , B.ACCOUNTING_DT , A.COMPONENT_OF_ID , A.LINEAR_ASSET_SW , A.PROD_VERSION , A.INTFC_TYPE , A.RATE_MULT , A.RATE_DIV , A.SEQUENCE_NBR_6 , A.CONSOLIDATION_ID , B.IN_SERVICE_DT , A.ACQUISITION_DT , A.DTTM_STAMP , A.EFFSEQ , A.LOCATION_EFFSEQ , DFLT_INTFC_ID , DFLT_LINE_NUM FROM %Sql(OUTER_JOIN_INTFC_PHY_A_FIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
Prompt Table: AM_ACT_ASSET_VW

5 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
Prompt Table: PROFILE_VW

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPER_UNIT_TBL

8 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_TBL

9 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_TBL

10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_CF_TBL

11 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_TBL

12 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_TBL

13 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

14 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

15 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

16 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CHARTFIELD1_TBL

17 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CHARTFIELD2_TBL

18 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CHARTFIELD3_TBL

19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

20 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

21 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

22 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

23 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

24 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

25 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_ID_VW

26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

27 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

28 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface

29 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

31 TXN_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cost

32 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost

33 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value

34 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount

35 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount

36 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

37 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount

38 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount

39 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount

40 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount

41 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount

42 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized

43 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized

44 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

45 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

46 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

47 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

48 ORIG_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID

49 ORIG_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number

50 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

51 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

52 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian

53 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL

54 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

55 MODEL Character(30) VARCHAR2(30) NOT NULL Model
Prompt Table: MFG_MODEL

56 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

57 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

58 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

59 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

60 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

61 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount

62 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr

63 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable

64 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount

65 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt

66 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr

67 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description

68 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
Prompt Table: AM_AREA_TBL

69 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset
Y/N Table Edit

70 NBR_OF_CPU Number(3,0) SMALLINT NOT NULL Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.

71 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID
Prompt Table: CAP_THR_DFN1_VW

72 CAPVAL_VALUE Character(1) VARCHAR2(1) NOT NULL Capitalizaion Value
1=FIN to PHY
2=FIN to EXP
3=PHY to EXP
4=PHY to FIN
5=FIN to PHY - Book Level
6=PHY - FIN Book Level

73 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
N=No
Y=Yes
Y/N Table Edit

74 ARO_ID Character(12) VARCHAR2(12) NOT NULL ARO Identification

75 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

76 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
Prompt Table: MANUFACTURER

77 TRANS_DT Date(10) DATE Transaction Date

78 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

79 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID
Prompt Table: PARENT_ASSET

80 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
Prompt Table: AM_COMPONENT

81 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version

82 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type

83 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

84 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

85 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence

86 CONSOLIDATION_ID Number(8,0) INTEGER NOT NULL Consolidation ID

87 IN_SERVICE_DT Date(10) DATE In Service Date

88 ACQUISITION_DT Date(10) DATE Acquisition Date

89 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

90 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

91 LOCATION_EFFSEQ Number(3,0) SMALLINT NOT NULL Asset Location Effective Seq

92 DFLT_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID

93 DFLT_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
2	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
4	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: AM_ACT_ASSET_VW
5	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Prompt Table: PROFILE_VW
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
8	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
9	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
10	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
11	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
12	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
13	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
14	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
15	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
16	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
17	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
18	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
19	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
20	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
21	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
22	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
23	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
24	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
25	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_ID_VW
26	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
27	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
28	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
29	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	TXN_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Cost
32	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
33	SALVAGE_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Salvage Value
34	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
35	SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
36	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
37	USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
38	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
39	FREIGHT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
40	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
41	MISC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
42	INTFC_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Interface Status CON=Consolidated DON=Mass Changes Generated ERR=Error NEW=Mass Changes Not Generated REP=Replaced by Other Records (AP) UNI=Unitized
43	LOAD_STATUS	Character(3)	VARCHAR2(3) NOT NULL	/* -> JMZ. PSOFT. 11-OCT-2002 / New Status were added : HLD and INP for Asset Management. / <- JMZ. PSOFT. 11-OCT-2002 */ CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized
44	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
45	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
46	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
47	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
48	ORIG_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Original Interface ID
49	ORIG_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Original Interface Line Number
50	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
51	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
52	CUSTODIAN	Character(30)	VARCHAR2(30) NOT NULL	Custodian
53	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
54	MANUFACTURER	Character(60)	VARCHAR2(60) NOT NULL	Manufacturer Name
55	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model Prompt Table: MFG_MODEL
56	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
57	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
58	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
59	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
60	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
61	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
62	VAT_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amt Base Curr
63	VAT_NRCVR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non Recoverable
64	VAT_NRCVR_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT NonRecoverable Amount
65	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
66	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt in Base Curr
67	DESCR_LONG	Character(254)	VARCHAR2(254) NOT NULL	Long Description
68	AREA_ID	Character(10)	VARCHAR2(10) NOT NULL	Area ID Prompt Table: AM_AREA_TBL
69	LINEAR_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Linear Asset Y/N Table Edit
70	NBR_OF_CPU	Number(3,0)	SMALLINT NOT NULL	Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.
71	CAP_THRSHLD_ID	Character(10)	VARCHAR2(10) NOT NULL	Threshold ID Prompt Table: CAP_THR_DFN1_VW
72	CAPVAL_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Capitalizaion Value 1=FIN to PHY 2=FIN to EXP 3=PHY to EXP 4=PHY to FIN 5=FIN to PHY - Book Level 6=PHY - FIN Book Level
73	ARO_SW	Character(1)	VARCHAR2(1) NOT NULL	Asset Retirement Obligations N=No Y=Yes Y/N Table Edit
74	ARO_ID	Character(12)	VARCHAR2(12) NOT NULL	ARO Identification
75	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
76	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: MANUFACTURER
77	TRANS_DT	Date(10)	DATE	Transaction Date
78	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
79	PARENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Parent ID Prompt Table: PARENT_ASSET
80	COMPONENT_OF_ID	Character(12)	VARCHAR2(12) NOT NULL	Component of Asset Prompt Table: AM_COMPONENT
81	PROD_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Product Version
82	INTFC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Trans Load Type
83	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
84	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
85	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
86	CONSOLIDATION_ID	Number(8,0)	INTEGER NOT NULL	Consolidation ID
87	IN_SERVICE_DT	Date(10)	DATE	In Service Date
88	ACQUISITION_DT	Date(10)	DATE	Acquisition Date
89	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
90	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
91	LOCATION_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Asset Location Effective Seq
92	DFLT_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Original Interface ID
93	DFLT_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Original Interface Line Number