RE_LS_AST_LOTRF

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
3 TRANS_DT Date(10) DATE Transaction Date
4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
5 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
6 TRF_KEY Number(3,0) SMALLINT NOT NULL Transfer Key
7 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
8 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
9 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
10 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.
11 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
12 IU_MAP_KEY Number(7,0) INTEGER NOT NULL InterUnit transfer map key
13 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
14 TRF_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Type
LN=Lease Incentive
LO=Lease Obligation
RE=Rent Expense
15 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
16 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
17 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
18 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount