RF_ASSET_RECON (SQL Table)	Index Back
Asset Reconciliation table This page contains asset entries received from the Financial system that must be reconciled with installed asset entries.

RF_ASSET_RECON

(SQL Table)

Asset Reconciliation table

This page contains asset entries received from the Financial system that must be reconciled with installed asset entries.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RF_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identifier used in Contracts Integration

3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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

5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

7 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.

8 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Indicates the component to which the current asset belongs.

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

11 AM_ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL This field defines the asset types that are available
010=IT Hardware
020=IT Software
030=Plant
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
999=Other

12 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL This field is used in the problem tree in work management.

13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

14 MFG_ID Character(50) VARCHAR2(50) NOT NULL Key field to represent Manufacturer Identification number

15 MODEL Character(30) VARCHAR2(30) NOT NULL Model

16 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

17 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

18 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

19 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

20 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

21 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

22 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

23 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RF_NONVW
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identifier used in Contracts Integration
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
4	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
5	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
6	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
7	INST_PROD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Status of an installed product.
8	COMPONENT_OF_ID	Character(12)	VARCHAR2(12) NOT NULL	Indicates the component to which the current asset belongs.
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
11	AM_ASSET_TYPE	Character(3)	VARCHAR2(3) NOT NULL	This field defines the asset types that are available 010=IT Hardware 020=IT Software 030=Plant 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 999=Other
12	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	This field is used in the problem tree in work management.
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
14	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Key field to represent Manufacturer Identification number
15	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
16	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
17	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
18	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
19	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
20	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
21	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
22	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
23	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
24	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.
25	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time