INTFC_AM_ALL_VW

(SQL View)
 Index Back

AM Interface View

This view is used by the Unitize component.

SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.DTTM_STAMP , A.MC_DEFN_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.INTFC_TYPE , A.SYSTEM_SOURCE , A.APPROVAL_SW , A.INTFC_STATUS , A.LOAD_STATUS , A.DEFAULT_PROFILE_SW , A.TRANS_IN_OUT , A.PARENT_ID , A.PARENT_DESCR , A.PARENT_DESCRLONG50 , A.TAGGABLE_SW , A.TAG_NUMBER , A.DESCR , A.DESCRSHORT , A.ASSET_STATUS , A.FINANCIAL_ASSET_SW , A.REPLACE_SW , A.REPLACE_ASSET_ID , A.CONVERSION_ID , A.NEW_ASSET_SW , A.AVAIL_SW , A.AVAIL_CONTACT , A.AVAIL_PHONE , A.ACQUISITION_CD , A.ACQUISITION_DT , A.FINANCING_CD , A.ASSET_DTTM_STAMP , A.PROFILE_ID , A.ASSET_CLASS , A.CAP_NUM , A.MANUFACTURER , A.MODEL , A.PROD_VERSION , A.SERIAL_ID , A.PRODUCTION_DT , A.PLANT , A.MANUFACTUR_CONTACT , A.CAP_SEQUENCE , A.REPLACEMENT_COST , A.LEASE_ASSET_ID , A.BUSINESS_UNIT_JV , A.COMPOSITE_SW , A.COMPOSITE_ID , A.FERC_CD , A.SEQUENCE_NBR_6 , A.ACQUISITION_DESCR , A.CAPITALIZATION_SW , A.BUSINESS_UNIT_AP , A.CURRENCY_CD , A.BUSINESS_UNIT_PO , A.PO_ID , A.PO_LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , A.REFERENCE_ID , A.INVOICE_DT , A.VENDOR_ID , A.VENDOR_NAME , A.INVOICE_ID , A.TXN_AMOUNT , A.AMOUNT , A.QUANTITY , A.SALETX_AMT , A.SALETX_AMT_BSE , A.SALETX_CD , A.USETAX_AMT , A.USETAX_AMT_BSE , A.USETAX_CD , A.FREIGHT_AMT , A.FREIGHT_AMT_BSE , A.MISC_AMT , A.MISC_AMT_BSE , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.RECV_DIST_LINE_NUM , A.DISTRIB_SEQ_NUM , A.INV_ITEM_ID , A.BUSINESS_UNIT_PC , A.MASTER_PROJECT , A.ACTIVITY_ID , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.ANALYSIS_TYPE , A.CUSTODIAN_EFFDT , A.EFFSEQ , A.CUSTODIAN , A.EMPLID , A.CUSTODIAN_DEPTID , A.CUSTODIAN_PROJECT , A.OFFSITE_SW , A.AUTH_STATUS , A.AUTHORIZATION_NAME , A.AUTHORIZATION_DT , A.LOCATION_EFFDT , A.LOCATION_EFFSEQ , A.LOCATION , A.PI_ID , A.INVENTORY_DT , A.PERFORMED_BY , A.DOCUMENT_ID , A.LOC_AUTH_STATUS , A.LOC_AUTH_NAME , A.LOC_AUTH_DT , A.ORIG_INTFC_ID , A.ORIG_LINE_NUM , B.BOOK , B.COST , B.SALVAGE_VALUE , B.QUANTITY , %subrec(cf14_An_sbr, A) , A.PROJECT_ID , A.DEPTID , A.CATEGORY , A.COST_TYPE , B.TRANS_DT , B.ACCOUNTING_DT , B.IN_SERVICE_DT , B.CALCULATION_TYPE , B.CALC_DEPR_STATUS , B.CALC_DIST_STATUS , B.OPEN_TRANS_ID , B.OPRID , B.DEPR_IN_SERVICE_SW , B.DEPR_AVG_OPTION , 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 , B.TXN_COST , A.TXN_CURRENCY_CD , A.RATE_MULT , A.RATE_DIV , A.RT_TYPE , A.MERCHANDISE_AMT , B.CONVENTION , B.RETIRE_CONVENTION , B.LIFE , B.DEPR_STATUS , B.METHOD , A.DESCR_LONG , A.AREA_ID , A.LINEAR_ASSET_SW , A.NBR_OF_CPU , B.FULLY_DEPR_SW , A.CAP_THRSHLD_ID , A.CAPVAL_VALUE , %subrec(AM_VAT_ATTR_SBR, A) , A.ARO_SW , A.ARO_ID , A.PO_GROUP_ID , A.MFG_ID , B.RT_EFFDT , A.CONSOLIDATION_ID , A.ASSET_TYPE , A.COMPONENT_OF_ID , B.AM_CAP_STATUS_SW , A.AVAIL_FOR_USE , A.CHARGE_BACK_SW , A.IN_PHY_USE , A.OFFLINE_FLG , A.ALLOW_OVERBOOK_SW , A.GROUP_ASSET_FLAG , A.REPAIR_STATUS , A.REPAIRABLE_FLG , A.SCHEDULABLE_SW 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

Prompt Table: SP_BU_AM_NONVW

4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 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.
6 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
9 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
10 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
11 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
12 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status

Y/N Table Edit

Default Value: Y

13 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

Default Value: DON

14 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

Default Value: NEW

15 DEFAULT_PROFILE_SW Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

Y/N Table Edit

Default Value: N

16 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
17 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

Prompt Table: PARENT_ASSET

18 PARENT_DESCR Character(30) VARCHAR2(30) NOT NULL Parent Asset Description
19 PARENT_DESCRLONG50 Character(50) VARCHAR2(50) NOT NULL Parent Asset Long Description
20 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
N=Non Taggable Asset
Y=Taggable Asset
21 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
22 DESCR Character(30) VARCHAR2(30) NOT NULL Description
23 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: INTFC_AM_ALL_VW.DESCR

24 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
A=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress

Default Value: I

25 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize

Y/N Table Edit

Default Value: Y

26 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset

Y/N Table Edit

Default Value: N

27 REPLACE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Replaced Asset ID

Prompt Table: ASSET

28 CONVERSION_ID Character(15) VARCHAR2(15) NOT NULL Old Asset ID
29 NEW_ASSET_SW Character(1) VARCHAR2(1) NOT NULL New Asset
N=Used Asset
Y=New Asset

Default Value: Y

30 AVAIL_SW Character(1) VARCHAR2(1) NOT NULL Asset is Available

Y/N Table Edit

Default Value: N

31 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
32 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
33 ACQUISITION_CD Character(1) VARCHAR2(1) NOT NULL Acquisition Code
C=Constructed
D=Donated
I=Trade In
K=Like Exchange
L=Leased
P=Purchased
T=Transferred

Default Value: P

34 ACQUISITION_DT Date(10) DATE Acquisition Date
35 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code
36 ASSET_DTTM_STAMP DateTime(26) TIMESTAMP Asset Date Time Stamp
37 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: PROFILE_TBL

38 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class
39 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

Prompt Table: CAP

40 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
41 MODEL Character(30) VARCHAR2(30) NOT NULL Model
42 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
43 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
44 PRODUCTION_DT Date(10) DATE Production Date
45 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant
46 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact
47 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence
48 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
49 LEASE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Lease Asset ID
50 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
51 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset
52 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID
53 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code
54 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
55 ACQUISITION_DESCR Character(30) VARCHAR2(30) NOT NULL DESCR field for ACQ_DETAIL
56 CAPITALIZATION_SW Character(1) VARCHAR2(1) NOT NULL Capitalized
0=To Capitalize Later
1=To be Capitalized
2=Already Capitalized
3=Never Capitalize
4=Already Non Capitalized
5=Consolidated
57 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
58 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
59 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
60 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
61 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
62 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
63 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
64 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
65 INVOICE_DT Date(10) DATE Invoice Date
66 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
67 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name
68 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
69 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
70 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
71 QTY_INV_RECV Number(16,4) DECIMAL(15,4) NOT NULL Quantity Received
72 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
73 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
74 SALETX_CD Character(8) VARCHAR2(8) NOT NULL Sales Tax Code
75 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
76 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
77 USETAX_CD Character(8) VARCHAR2(8) NOT NULL Use Tax Code
78 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
79 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
80 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
81 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
82 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
83 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
84 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
85 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
86 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
87 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
88 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
89 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
90 MASTER_PROJECT Character(15) VARCHAR2(15) NOT NULL Master Project
91 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
92 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
93 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
94 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
95 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
96 CUSTODIAN_EFFDT Date(10) DATE Asset Custodian Effective Dt
97 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
98 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
99 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
100 CUSTODIAN_DEPTID Character(10) VARCHAR2(10) NOT NULL Asset Custodian Deptid
101 CUSTODIAN_PROJECT Character(15) VARCHAR2(15) NOT NULL Asset Custodian Project
102 OFFSITE_SW Character(1) VARCHAR2(1) NOT NULL This Asset is Offsite
103 AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending
104 AUTHORIZATION_NAME Character(30) VARCHAR2(30) NOT NULL Authorization Name
105 AUTHORIZATION_DT Date(10) DATE Date Authorized
106 LOCATION_EFFDT Date(10) DATE Location Effective Date
107 LOCATION_EFFSEQ Number(3,0) SMALLINT NOT NULL Asset Location Effective Seq
108 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
109 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID
110 INVENTORY_DT Date(10) DATE Inventory Date
111 PERFORMED_BY Character(30) VARCHAR2(30) NOT NULL Performed By
112 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
113 LOC_AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Location Authorization Status
114 LOC_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Location Authorization Name
115 LOC_AUTH_DT Date(10) DATE Location Authorization Date
116 ORIG_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID
117 ORIG_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number
118 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
119 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
120 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
121 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
122 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

123 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: %EDIT_PRODUCT

124 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

125 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

126 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

127 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

128 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

129 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

130 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

131 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: %EDIT_CHARTFLD1

132 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: %EDIT_CHARTFLD2

133 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: %EDIT_CHARTFLD3

134 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

135 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: %EDIT_DEPT

136 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
137 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
138 TRANS_DT Date(10) DATE Transaction Date
139 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
140 IN_SERVICE_DT Date(10) DATE In Service Date
141 CALCULATION_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Type
L=Life-to-Date
R=Remaining Value
142 CALC_DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Calc Status
C=Completed Depreciation
H=Held For Transfer In
I=In Processing
N=Never Calculate Depreciation
P=Pending Depreciation
143 CALC_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL Acctg Entry Creation Status
C=Completed Distribution
N=Never Calculate Distribution
P=Pending Distribution
R=Reconcilie Clearing
144 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID
145 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
146 DEPR_IN_SERVICE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate When In Service
N=No
X=Used to be set to 'Y'
Y=Yes
147 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging
148 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
149 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
150 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
151 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
152 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
153 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
154 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
155 TXN_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cost
156 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
157 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
158 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
159 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
160 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
161 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention
162 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention
163 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
164 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable
165 METHOD Character(2) VARCHAR2(2) NOT NULL Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production
166 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
167 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

168 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset

Y/N Table Edit

169 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.
170 FULLY_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense
171 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID
172 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
173 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID
174 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
175 BUSINESS_UNIT_VAT Character(5) VARCHAR2(5) NOT NULL Vat Apportionment Business Uni
176 CHARTFIELD_PR1_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 1 Value
177 CHARTFIELD_PR2_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 2 Value
178 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
179 VAT_CONSTRAINT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Constraint
180 VAT_TAXATION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Taxation
181 VAT_ADMISSION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Admission
182 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
183 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
N=No
Y=Yes

Y/N Table Edit

184 ARO_ID Character(12) VARCHAR2(12) NOT NULL ARO Identification
185 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
186 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
187 RT_EFFDT Date(10) DATE The effective date for a given item of market rate data.
188 CONSOLIDATION_ID Number(8,0) INTEGER NOT NULL Consolidation ID
189 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
190 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset

Prompt Table: AM_COMPONENT

191 AM_CAP_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Physical Book Cost
192 AVAIL_FOR_USE Character(1) VARCHAR2(1) NOT NULL Available For Use
193 CHARGE_BACK_SW Character(1) VARCHAR2(1) NOT NULL Charge Back Switch
D=Default
N=No
Y=Yes
194 IN_PHY_USE Character(1) VARCHAR2(1) NOT NULL Describes if entity is in physical use.
195 OFFLINE_FLG Character(1) VARCHAR2(1) NOT NULL Asset Offline
196 ALLOW_OVERBOOK_SW Character(1) VARCHAR2(1) NOT NULL Allow Overbooking
197 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None
198 REPAIR_STATUS Character(1) VARCHAR2(1) NOT NULL Repair Status
0=None
1=Needs Repair
2=In Repair
199 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag
200 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch