ASSET_DT_TMP

(SQL Table)
 Index Back

Asset General Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

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

Default Value: NEXT

3 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
4 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
5 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

Prompt Table: PARENT_ASSET

6 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
7 ASSET_ASSIGNED_TO Character(12) VARCHAR2(12) NOT NULL Asset Assigned To
8 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
N=Non Taggable Asset
Y=Taggable Asset
9 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: ASSET.DESCR

12 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: ASSET

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

Default Value: Y

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

Y/N Table Edit

Default Value: N

19 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
20 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
21 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

22 ACQUISITION_DT Date(10) DATE Acquisition Date
23 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code

Prompt Table: FINANCE_CD_TBL

24 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
25 REPLACE_COST_DT Date(10) DATE Last Update
26 LEASE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Lease Asset ID

Prompt Table: LEASE_SRCH2

27 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: PROFILE_TBL

28 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class

Prompt Table: ASSET_CLASS_TBL

29 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

Prompt Table: CAP

30 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

Prompt Table: CAP_DET_OPEN_VW

31 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
32 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

Prompt Table: MANUF_FS_VW

33 MODEL Character(30) VARCHAR2(30) NOT NULL Model
34 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
35 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
36 PRODUCTION_DT Date(10) DATE Production Date
37 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant
38 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact
39 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
40 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name

Prompt Table: AM_INDEX_TBL

41 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name

Prompt Table: AM_INDEX_DETAIL

42 LAST_INDEX_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Last Index Value
43 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

Y/N Table Edit

Default Value: N

44 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID

Prompt Table: ASSET_COMPOS_VW

45 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

46 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
G=Group Asset
M=Group Member
N=None

Default Value: N

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

Default Value: CURR_CD_AM_VW.CURRENCY_CD

48 RD_PLANT_ASSET Character(1) VARCHAR2(1) NOT NULL R and D Plant Asset

Y/N Table Edit

49 RD_START_DT Date(10) DATE R and D Start Date
50 RD_USE_NBV Character(1) VARCHAR2(1) NOT NULL Use NBV for R and D

Y/N Table Edit

51 IP_ADDRESS Character(39) VARCHAR2(39) NOT NULL Internet Protocol Address
52 IP_ALIAS Character(35) VARCHAR2(35) NOT NULL Internet Address Alias/UNC
53 COLLATERAL_ASSET Character(2) VARCHAR2(2) NOT NULL Collateral Asset
01=Mortgage
02=Fixed Mortgage
03=Factory Foundation Mortgage
04=Others
54 CLUSTERED_ASSET Character(1) VARCHAR2(1) NOT NULL Clustered Asset

Y/N Table Edit

55 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
56 LAST_REVIEW_DT Date(10) DATE Used for Australian VAT - last date of mandatory review
57 AM_AST_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1
58 AM_AST_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2
59 AM_AST_UD_DATE1 Date(10) DATE User Defined Date Field1
60 AM_AST_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1
61 AM_AST_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2
62 LAST_CALC_RPL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Last calculated replacement cost
63 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset
64 SS_STATUS Character(1) VARCHAR2(1) NOT NULL Strategic Sourcing Status
A=Sent to Auction
N=Not allowed to be Auctioned
S=Sold in Auction
Y=Allowed to be Auctioned
65 VIN Character(18) VARCHAR2(18) NOT NULL VIN
66 ASSET_RESOURCE_SW Character(1) VARCHAR2(1) NOT NULL Field to indicate that an Asset is used as a tool or resource

Y/N Table Edit

67 ALLOW_OVERBOOK_SW Character(1) VARCHAR2(1) NOT NULL Allow Overbooking

Y/N Table Edit

Default Value: N

68 CHARGE_BACK_SW Character(1) VARCHAR2(1) NOT NULL Charge Back Switch
D=Default
N=No
Y=Yes

Default Value: D

69 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

Y/N Table Edit

Default Value: N

70 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template

Prompt Table: EPL_LOOKUP_VW

71 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag

Y/N Table Edit

Default Value: N

72 REPAIR_STATUS Character(1) VARCHAR2(1) NOT NULL Repair Status
0=None
1=Needs Repair
2=In Repair

Default Value: 0

73 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

74 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: AM_WM_SHOP

75 UNOWNED_FLG Character(1) VARCHAR2(1) NOT NULL Non-Owned Asset

Y/N Table Edit

76 WO_LOCATION_FLG Character(1) VARCHAR2(1) NOT NULL Work Order Location
1=Shop Location
2=Asset Location
3=Other Location
77 OFFLINE_FLG Character(1) VARCHAR2(1) NOT NULL Asset Offline

Y/N Table Edit

Default Value: N

78 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality

Prompt Table: AM_CRIT_LVL

79 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

Prompt Table: AM_CREW_VW

80 AVAIL_FOR_USE Character(1) VARCHAR2(1) NOT NULL Available For Use
81 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
82 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
83 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field
84 IN_SERVICE_DT Date(10) DATE In Service Date
85 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

Prompt Table: REGION_CD

86 SKU Character(50) VARCHAR2(50) NOT NULL Stock Keeping Unit
87 CRM_IPROD_ID Character(20) VARCHAR2(20) NOT NULL For CRM integration of IT Assets
88 CRM_IPROD_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
89 CRM_IPROD_STATUS Character(3) VARCHAR2(3) NOT NULL For CRM integration of IT Assets
INS=Install
UNI=Uninstall
90 CRM_DEPT_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets