ASSET_DT_TBL (SQL Table)	Index Back
Asset General Information If you add fields to ASSET, they must also be added to ASSET_JV_VW.

ASSET_DT_TBL

(SQL Table)

Asset General Information

If you add fields to ASSET, they must also be added to ASSET_JV_VW.

# 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_OPEN_VW

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
Y/N Table Edit
Default Value: N

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

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

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

93 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.

94 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

95 IN_PHY_USE Character(1) VARCHAR2(1) NOT NULL Describes if entity is in physical use.

96 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

97 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

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

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

100 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

#	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_OPEN_VW
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 Y/N Table Edit Default Value: N
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
91	DESCR_LONG	Character(254)	VARCHAR2(254) NOT NULL	Long Description
92	LINEAR_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Linear Asset
93	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.
94	CAP_THRSHLD_ID	Character(10)	VARCHAR2(10) NOT NULL	Threshold ID
95	IN_PHY_USE	Character(1)	VARCHAR2(1) NOT NULL	Describes if entity is in physical use.
96	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
97	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
98	ARO_SW	Character(1)	VARCHAR2(1) NOT NULL	Asset Retirement Obligations N=No Y=Yes Y/N Table Edit
99	ARO_ID	Character(12)	VARCHAR2(12) NOT NULL	ARO Identification
100	SES_LAST_DTTM	DateTime(26)	TIMESTAMP	PTSF Last Modified DateTimestamp