RET_DET_TEO2

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: RETIREMENT

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

Prompt Table: RETIREMENT

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

Prompt Table: RETIREMENT

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.

Prompt Table: RETIREMENT

6 SERIAL_COUNT Number(6,0) INTEGER NOT NULL Serial Count
7 TXN_TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Trade-In Value
8 TRADE_IN_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In value
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 LIKE_EXCH_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Like Exch Asset
11 LIKE_KIND_DATESTMP DateTime(26) TIMESTAMP Like Kind datetimestmp
12 TXN_LK_KIND_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Like Kind Basis
13 LIKE_KIND_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Like Kind Exch Basis
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
16 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
17 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.
18 RT_EFFDT Date(10) DATE The effective date for a given item of market rate data.
19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
20 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code