AE_ERCREXP_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

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

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

6 CONVERSION_DT Date(10) DATE Conversion Date

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

8 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction

9 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

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

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

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

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

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

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

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

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

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

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

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

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

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

23 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

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

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

26 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

27 PYMNT_DT Date(10) DATE Payment Date

28 MRP Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Rental Payment

29 INTEREST_EXPENSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Expense

30 RECONCILE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Reconcile Amt - Euro Cur Exp

31 LEASE_PYMT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

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

33 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

34 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

35 YEAR_CHAR Character(4) VARCHAR2(4) NOT NULL Year Char

36 YEAR_NUM Number(4,0) SMALLINT NOT NULL Year in Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
4	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	CONVERSION_DT	Date(10)	DATE	Conversion Date
7	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
8	OBLIGATION_REDUCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Obligation Reduction
9	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
10	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
11	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
12	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
13	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
14	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
15	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
16	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
17	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
18	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
19	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
20	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
21	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
22	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
23	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
24	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
25	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.
26	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
27	PYMNT_DT	Date(10)	DATE	Payment Date
28	MRP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Minimum Rental Payment
29	INTEREST_EXPENSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Expense
30	RECONCILE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Reconcile Amt - Euro Cur Exp
31	LEASE_PYMT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
32	GROUP_ASSET_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Group Asset Flag G=Group Asset M=Group Member N=None
33	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
34	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
35	YEAR_CHAR	Character(4)	VARCHAR2(4) NOT NULL	Year Char
36	YEAR_NUM	Number(4,0)	SMALLINT NOT NULL	Year in Number